Difference between revisions of "Database Table: friends"

From Dreamwidth Notes
Jump to: navigation, search
m (reformat, right category)
 
(4 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 +
{{Database Table|name=friends|table type=global|repo=dw-free|removed=1|removed in=57d3ef6cc307}}
 +
Removed in [http://bugs.dwscoalition.org/show_bug.cgi?id=80 bug 80]
 
= Definition =
 
= Definition =
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE friends (
 
CREATE TABLE friends (
Line 13: Line 14:
 
)
 
)
 
</source>
 
</source>
 
+
{{Database Table Footer|removed=1}}
= Relationships =
+
 
+
= Location =
+
 
+
[[Global database]]
+
 
+
[[Category: Database Tables|friends]]
+

Latest revision as of 16:26, 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 friends (
  userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  friendid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  fgcolor CHAR(7) DEFAULT NULL,
  bgcolor CHAR(7) DEFAULT NULL,
  groupmask BIGINT(20) UNSIGNED NOT NULL DEFAULT '1',
  showbydefault enum('1','0') NOT NULL DEFAULT '1',
  PRIMARY KEY  (userid,friendid),
  KEY (friendid)
)