Difference between revisions of "Database Table: pollresult"
From Dreamwidth Notes
m (typo) |
|||
| Line 2: | Line 2: | ||
[[Category: Obsolete Database Tables|pollresult]] | [[Category: Obsolete Database Tables|pollresult]] | ||
| + | =Definition= | ||
| + | <source lang="sql"> | ||
| + | CREATE TABLE pollresult ( | ||
| + | pollid int(10) unsigned NOT NULL default '0', | ||
| + | pollqid tinyint(3) unsigned NOT NULL default '0', | ||
| + | userid int(10) unsigned NOT NULL default '0', | ||
| + | value varchar(255) default NULL, | ||
| + | PRIMARY KEY (pollid,pollqid,userid), | ||
| + | KEY (pollid,userid) | ||
| + | ) | ||
| + | </source> | ||
| + | |||
| + | =Relationships= | ||
| + | |||
| + | =Location= | ||
| + | [[Global database]] | ||
Revision as of 23:22, 22 March 2009
Global database; deprecated in favor of pollresult2 (clustered).
Definition
CREATE TABLE pollresult ( pollid INT(10) UNSIGNED NOT NULL DEFAULT '0', pollqid tinyint(3) UNSIGNED NOT NULL DEFAULT '0', userid INT(10) UNSIGNED NOT NULL DEFAULT '0', VALUE VARCHAR(255) DEFAULT NULL, PRIMARY KEY (pollid,pollqid,userid), KEY (pollid,userid) )
