Difference between revisions of "Database Table: friends"

From Dreamwidth Notes
Jump to: navigation, search
(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 ...')
 
m (reformat, right category)
Line 1: Line 1:
[[Category: Database Table|friends]]
+
= Definition =
=Definition=
+
 
 
<source lang="sql">
 
<source lang="sql">
 
CREATE TABLE friends (
 
CREATE TABLE friends (
Line 14: Line 14:
 
</source>
 
</source>
  
=Relationships=
+
= Relationships =
 +
 
 +
= Location =
  
=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)
)

Relationships

Location

Global database