diff options
Diffstat (limited to 'database/database.mysql')
-rw-r--r-- | database/database.mysql | 24 |
1 files changed, 24 insertions, 0 deletions
diff --git a/database/database.mysql b/database/database.mysql index 1940099bd..7fc160d31 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -257,6 +257,30 @@ CREATE TABLE page ( ); # +# Table structure for table 'poll' +# +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) +); + +# +# Table structure for table 'poll_choices' +# +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) +); + +# # Table structure for table 'rating' # DROP TABLE IF EXISTS rating; |