Database Table: poll
From Dreamwidth Notes
Revision as of 14:56, 11 September 2009 by 68.17.171.105 (Talk)
Global database; deprecated in favor of poll2 (clustered).
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) )