Difference between revisions of "Database Table: moods"
From Dreamwidth Notes
(Created page with 'moods =Definition= <source lang="sql"> CREATE TABLE moods ( moodid int(10) unsigned NOT NULL auto_increment, mood varchar(40) default NULL, par...') |
(No difference)
|
Revision as of 17:30, 22 March 2009
Definition
CREATE TABLE moods ( moodid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, mood VARCHAR(40) DEFAULT NULL, parentmood INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (moodid), UNIQUE KEY mood (mood) )