diff options
author | Dries Buytaert <dries@buytaert.net> | 2005-12-27 14:34:21 +0000 |
---|---|---|
committer | Dries Buytaert <dries@buytaert.net> | 2005-12-27 14:34:21 +0000 |
commit | 387b47ec2bb700776162086882ed66db9a2e7626 (patch) | |
tree | b8cb3f17a0d2e61308fb71d6f1b6946f5edd503f /database/database.mysql | |
parent | 02eb24bfbd073383f185f4d68daefa09660c477f (diff) | |
download | brdo-387b47ec2bb700776162086882ed66db9a2e7626.tar.gz brdo-387b47ec2bb700776162086882ed66db9a2e7626.tar.bz2 |
- Patch #41755 by Neil: normalize poll.polled database column.
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' -- |