diff options
| author | Dries Buytaert <dries@buytaert.net> | 2001-05-31 18:22:00 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2001-05-31 18:22:00 +0000 |
| commit | 83ac3c58767b4b45c6a6fbc90583af21dd32423f (patch) | |
| tree | c01cd83fa8a33d53b24f96dc442aeac2b618d669 | |
| parent | 41521562607d650cbf6e70500fbe6aa3217c934d (diff) | |
| download | brdo-83ac3c58767b4b45c6a6fbc90583af21dd32423f.tar.gz brdo-83ac3c58767b4b45c6a6fbc90583af21dd32423f.tar.bz2 | |
- Added the poll-related SQL tables.
| -rw-r--r-- | updates/2.00-to-x.xx.sql | 21 |
1 files changed, 21 insertions, 0 deletions
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) +); + |