Difference between revisions of "Database Table: friends"
From Dreamwidth Notes
(Created page with 'friends =Definition= <source lang="sql"> CREATE TABLE friends ( userid int(10) unsigned NOT NULL default '0', friendid int(10) unsigned NOT NULL ...') |
Foxfirefey (Talk | contribs) m (reformat, right category) |
||
Line 1: | Line 1: | ||
− | + | = Definition = | |
− | =Definition= | + | |
<source lang="sql"> | <source lang="sql"> | ||
CREATE TABLE friends ( | CREATE TABLE friends ( | ||
Line 14: | Line 14: | ||
</source> | </source> | ||
− | =Relationships= | + | = Relationships = |
+ | |||
+ | = Location = | ||
− | |||
[[Global database]] | [[Global database]] | ||
+ | |||
+ | [[Category: Database Tables|friends]] |
Revision as of 20:54, 26 March 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) )