diff options
Diffstat (limited to 'database/database.mysql')
-rw-r--r-- | database/database.mysql | 14 |
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' -- |