Database Table: qotd
From Dreamwidth Notes
Revision as of 13:18, 2 October 2009 by Exor674Bot (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) )