Database Table: qotd
From Dreamwidth Notes
Revision as of 20:41, 26 March 2009 by Foxfirefey (Talk | contribs)
Definition
CREATE TABLE qotd ( qid INT UNSIGNED NOT NULL AUTO_INCREMENT, time_start INT UNSIGNED NOT NULL DEFAULT '0', time_end INT UNSIGNED NOT NULL DEFAULT '0', active ENUM('Y','N') NOT NULL DEFAULT 'Y', text TEXT NOT NULL DEFAULT '', img_url VARCHAR(255) DEFAULT NULL, PRIMARY KEY (qid), INDEX (time_start), INDEX (time_end) )