Database Table: friendgroup2

From Dreamwidth Notes
Revision as of 20:27, 21 March 2009 by SlowSculpture (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Definition

CREATE TABLE friendgroup (
  userid INT(10) UNSIGNED NOT NULL DEFAULT '0',
  groupnum tinyint(3) UNSIGNED NOT NULL DEFAULT '0',
  groupname VARCHAR(30) NOT NULL DEFAULT '',
  sortorder tinyint(3) UNSIGNED NOT NULL DEFAULT '50',
  is_public enum('0','1') NOT NULL DEFAULT '0',
  PRIMARY KEY  (userid,groupnum)
)

Relationships

Location

Global database