Difference between revisions of "Database Table: pollsubmission"
From Dreamwidth Notes
(New page: Global database; Deprecated in favor of see Database Table: pollsubmission2 (clustered). pollsubmission) |
|||
| (7 intermediate revisions by 5 users not shown) | |||
| Line 1: | Line 1: | ||
| − | + | {{Database Table|name=pollsubmission|table type=global|repo=dw-free|removed=1|removed in=a907ed584e44}} | |
| − | + | Deprecated in favor of [[Database Table: pollsubmission2|pollsubmission2]] (clustered). | |
| − | + | = Definition = | |
| + | <source lang="sql"> | ||
| + | CREATE TABLE pollsubmission ( | ||
| + | pollid int(10) unsigned NOT NULL default '0', | ||
| + | userid int(10) unsigned NOT NULL default '0', | ||
| + | datesubmit datetime NOT NULL default '0000-00-00 00:00:00', | ||
| + | PRIMARY KEY (pollid,userid), | ||
| + | KEY (userid) | ||
| + | ) | ||
| + | </source> | ||
| + | {{Database Table Footer|removed=1} | ||
Latest revision as of 16:28, 22 July 2010
Note: This table is removed and no longer used. This table was removed in dw-free changeset a907ed584e44 [1]
This is a global table.
Deprecated in favor of pollsubmission2 (clustered).
Definition
CREATE TABLE pollsubmission ( pollid INT(10) UNSIGNED NOT NULL DEFAULT '0', userid INT(10) UNSIGNED NOT NULL DEFAULT '0', datesubmit datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (pollid,userid), KEY (userid) )
{{Database Table Footer|removed=1}
