summaryrefslogtreecommitdiff
path: root/modules/poll/poll.install
diff options
context:
space:
mode:
Diffstat (limited to 'modules/poll/poll.install')
-rw-r--r--modules/poll/poll.install34
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 */ ");
+ }
+}