summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
Diffstat (limited to 'database/database.mysql')
-rw-r--r--database/database.mysql14
1 files changed, 13 insertions, 1 deletions
diff --git a/database/database.mysql b/database/database.mysql
index c96c51ee3..92df2c686 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -536,12 +536,24 @@ CREATE TABLE permission (
CREATE TABLE poll (
nid int(10) unsigned NOT NULL default '0',
runtime int(10) NOT NULL default '0',
- polled longtext NOT NULL,
active int(2) unsigned NOT NULL default '0',
PRIMARY KEY (nid)
) TYPE=MyISAM;
--
+-- Table structure for table 'poll_votes'
+--
+
+CREATE TABLE poll_votes (
+ nid int(10) unsigned NOT NULL,
+ uid int(10) unsigned NOT NULL,
+ hostname varchar(128) NOT NULL,
+ INDEX (nid),
+ INDEX (uid),
+ INDEX (hostname)
+) TYPE=MyISAM;
+
+--
-- Table structure for table 'poll_choices'
--