Difference between revisions of "Database Table: pollsubmission"

From Dreamwidth Notes
Jump to: navigation, search
m (typo)
 
(5 intermediate revisions by 4 users not shown)
Line 1: Line 1:
Global database; deprecated in favor of [[Database Table: pollsubmission2|pollsubmission2]] (clustered).
+
{{Database Table|name=pollsubmission|table type=global|repo=dw-free|removed=1|removed in=a907ed584e44}}
 
+
Deprecated in favor of [[Database Table: pollsubmission2|pollsubmission2]] (clustered).
[[Category: Obsolete Database Tables|pollsubmission]]
+
= 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}