Difference between revisions of "Database Table: friendgroup2"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'friendgroup =Definition= <source lang="sql"> CREATE TABLE friendgroup ( userid int(10) unsigned NOT NULL default '0', groupnum tinyint(3) unsigne...')
 
 
(7 intermediate revisions by 5 users not shown)
Line 1: Line 1:
[[Category: Database Table|friendgroup]]
+
{{Database Table|name=friendgroup2|table type=global|repo=dw-free|removed=1|removed in=57d3ef6cc307}}
=Definition=
+
Removed in [http://bugs.dwscoalition.org/show_bug.cgi?id=80 bug 80]
 +
= Definition =
 
<source lang="sql">
 
<source lang="sql">
CREATE TABLE friendgroup (
+
CREATE TABLE friendgroup2 (
  userid int(10) unsigned NOT NULL default '0',
+
    userid     INT(10) UNSIGNED NOT NULL DEFAULT '0',
  groupnum tinyint(3) unsigned NOT NULL default '0',
+
    groupnum   TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
   groupname varchar(30) NOT NULL default '',
+
    groupname   VARCHAR(90) NOT NULL DEFAULT '',
  sortorder tinyint(3) unsigned NOT NULL default '50',
+
    sortorder   TINYINT(3) UNSIGNED NOT NULL DEFAULT '50',
  is_public enum('0','1') NOT NULL default '0',
+
    is_public   ENUM('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY (userid,groupnum)
+
    PRIMARY KEY (userid, groupnum)
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer|removed=1}}
=Relationships=
+
 
+
=Location=
+
[[Global database]]
+

Latest revision as of 16:25, 22 July 2010

Note: This table is removed and no longer used. This table was removed in dw-free changeset 57d3ef6cc307 [1]
This is a global table. Removed in bug 80

Definition

CREATE TABLE friendgroup2 (
    userid      INT(10) UNSIGNED NOT NULL DEFAULT '0',
    groupnum    TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
    groupname   VARCHAR(90) NOT NULL DEFAULT '',
    sortorder   TINYINT(3) UNSIGNED NOT NULL DEFAULT '50',
    is_public   ENUM('0','1') NOT NULL DEFAULT '0',
    PRIMARY KEY (userid, groupnum)
)