summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.mysql')
-rw-r--r--database/database.mysql24
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;