Difference between revisions of "Database Table: poll"
From Dreamwidth Notes
m (typo) |
|||
| Line 2: | Line 2: | ||
[[Category: Obsolete Database Tables|poll]] | [[Category: Obsolete Database Tables|poll]] | ||
| + | =Definition= | ||
| + | <source lang="sql"> | ||
| + | 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) | ||
| + | ) | ||
| + | </source> | ||
| + | |||
| + | =Relationships= | ||
| + | |||
| + | =Location= | ||
Revision as of 23:04, 22 March 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) )
