Difference between revisions of "Database Table: friendgroup2"

From Dreamwidth Notes
Jump to: navigation, search
(Created page with 'friendgroup =Definition= <source lang="sql"> CREATE TABLE friendgroup ( userid int(10) unsigned NOT NULL default '0', groupnum tinyint(3) unsigne...')
(No difference)

Revision as of 20:27, 21 March 2009

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