Difference between revisions of "Database Table: friends"
From Dreamwidth Notes
| Line 1: | Line 1: | ||
| + | {{Database Table|name=friends|table type=global|removed=1}} | ||
Removed in [http://bugs.dwscoalition.org/show_bug.cgi?id=80 bug 80] | 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 15: | Line 14: | ||
) | ) | ||
</source> | </source> | ||
| − | + | {{Database Table Footer|removed=1}} | |
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
| − | + | ||
Revision as of 04:12, 30 January 2010
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) )
