diff options
Diffstat (limited to 'modules/poll/poll.install')
-rw-r--r-- | modules/poll/poll.install | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/modules/poll/poll.install b/modules/poll/poll.install new file mode 100644 index 000000000..6ce2dbba0 --- /dev/null +++ b/modules/poll/poll.install @@ -0,0 +1,34 @@ +<?php + +function poll_install() { + switch ($GLOBALS['db_type']) { + case 'mysql': + case 'mysqli': + db_query("CREATE TABLE {poll} ( + nid int(10) unsigned NOT NULL default '0', + runtime int(10) NOT NULL default '0', + active int(2) unsigned NOT NULL default '0', + PRIMARY KEY (nid) + ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + + db_query("CREATE TABLE {poll_votes} ( + nid int(10) unsigned NOT NULL, + uid int(10) unsigned NOT NULL default 0, + chorder int(10) NOT NULL default -1, + hostname varchar(128) NOT NULL default '', + INDEX (nid), + INDEX (uid), + INDEX (hostname) + ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + + db_query("CREATE TABLE {poll_choices} ( + chid int(10) unsigned NOT NULL auto_increment, + nid int(10) unsigned NOT NULL default '0', + chtext varchar(128) NOT NULL default '', + chvotes int(6) NOT NULL default '0', + chorder int(2) NOT NULL default '0', + PRIMARY KEY (chid), + KEY nid (nid) + ) /*!40100 DEFAULT CHARACTER SET UTF8 */ "); + } +} |