From 83ac3c58767b4b45c6a6fbc90583af21dd32423f Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 31 May 2001 18:22:00 +0000 Subject: - Added the poll-related SQL tables. --- updates/2.00-to-x.xx.sql | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) diff --git a/updates/2.00-to-x.xx.sql b/updates/2.00-to-x.xx.sql index a60ab2cb2..cc7f83f7c 100644 --- a/updates/2.00-to-x.xx.sql +++ b/updates/2.00-to-x.xx.sql @@ -188,3 +188,24 @@ CREATE TABLE item ( attribute varchar(255) DEFAULT '' NOT NULL, PRIMARY KEY (iid) ); + +# 31/05/01 + +CREATE TABLE poll ( + lid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + runtime int(10) DEFAULT '0' NOT NULL, + voters text NOT NULL, + active int(2) unsigned DEFAULT '0' NOT NULL, + PRIMARY KEY (lid) +); + +CREATE TABLE poll_choices ( + chid int(10) unsigned DEFAULT '0' NOT NULL auto_increment, + nid int(10) unsigned DEFAULT '0' NOT NULL, + chtext varchar(128) DEFAULT '' NOT NULL, + chvotes int(6) DEFAULT '0' NOT NULL, + chorder int(2) DEFAULT '0' NOT NULL, + PRIMARY KEY (chid) +); + -- cgit v1.2.3