Difference between revisions of "Database Table: friendgroup2"
From Dreamwidth Notes
(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) )