Database Table: poll2

From Dreamwidth Notes
Revision as of 17:38, 22 March 2009 by SlowSculpture (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

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)
)

Relationships

Location

Global database