Database Table: poll2
From Dreamwidth Notes
Revision as of 17:38, 22 March 2009 by SlowSculpture (Talk | contribs)
Definition
CREATE TABLE poll ( pollid INT(10) UNSIGNED NOT NULL AUTO_INCREMENT, itemid INT(10) UNSIGNED NOT NULL DEFAULT '0', journalid INT(10) UNSIGNED NOT NULL DEFAULT '0', posterid INT(10) UNSIGNED NOT NULL DEFAULT '0', whovote enum('all','friends') NOT NULL DEFAULT 'all', whoview enum('all','friends','none') NOT NULL DEFAULT 'all', name VARCHAR(255) DEFAULT NULL, PRIMARY KEY (pollid), KEY (itemid), KEY (journalid), KEY (posterid) )