Database Table: friends

From Dreamwidth Notes
Revision as of 16:03, 22 July 2010 by Exor674Bot (Talk | contribs)

Jump to: navigation, search

Note: This table is removed and no longer used.
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)
)