Difference between revisions of "Database Table: friends"
From Dreamwidth Notes
| Line 1: | Line 1: | ||
| + | Removed in [http://bugs.dwscoalition.org/show_bug.cgi?id=80 bug 80] | ||
| + | |||
= Definition = | = Definition = | ||
Revision as of 18:46, 23 August 2009
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) )
