Difference between revisions of "Database Table: friends"

From Dreamwidth Notes
Jump to: navigation, search
m (reformat, right category)
Line 20: Line 20:
 
[[Global database]]
 
[[Global database]]
  
[[Category: Database Tables|friends]]
+
[[Category: Removed Database Tables|friends]]

Revision as of 18:27, 23 August 2009

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)
)

Relationships

Location

Global database