Difference between revisions of "Database Table: poll"
From Dreamwidth Notes
| Line 1: | Line 1: | ||
Global database; deprecated in favor of [[Database Table: poll2|poll2]] (clustered). | Global database; deprecated in favor of [[Database Table: poll2|poll2]] (clustered). | ||
| − | [[Category: | + | [[Category: Removed Database Tables|poll]] |
=Definition= | =Definition= | ||
<source lang="sql"> | <source lang="sql"> | ||
Revision as of 14:56, 11 September 2009
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) )
