Database Table: moodthemes
From Dreamwidth Notes
Revision as of 17:31, 22 March 2009 by SlowSculpture (Talk | contribs)
Definition
CREATE TABLE moodthemes ( moodthemeid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, ownerid INT(10) UNSIGNED NOT NULL DEFAULT '0', name VARCHAR(50) DEFAULT NULL, des VARCHAR(100) DEFAULT NULL, is_public enum('Y','N') NOT NULL DEFAULT 'N', PRIMARY KEY (moodthemeid), KEY (is_public), KEY (ownerid) )