From 1af8f55d45abf04bc0cf1a8ae368ac7f82215192 Mon Sep 17 00:00:00 2001 From: x2004laborde Date: Sat, 17 Mar 2007 21:35:05 +0000 Subject: [PATCH] MySQL structure for surveys git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1586 839d8a87-29fc-0310-9880-83ba4fa771e5 --- upgrade/0.9.14/07_survey.sql | 33 +++++++++++++++++++++++++++++++++ 1 file changed, 33 insertions(+) create mode 100644 upgrade/0.9.14/07_survey.sql diff --git a/upgrade/0.9.14/07_survey.sql b/upgrade/0.9.14/07_survey.sql new file mode 100644 index 0000000..f2d24bb --- /dev/null +++ b/upgrade/0.9.14/07_survey.sql @@ -0,0 +1,33 @@ +CREATE TABLE `survey_answers` ( + `id` smallint(5) unsigned NOT NULL auto_increment, + `survey_id` smallint(4) unsigned NOT NULL, + `vote_id` smallint(5) unsigned NOT NULL, + `question_id` smallint(3) unsigned NOT NULL, + `answer` text NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `vote` (`survey_id`,`vote_id`,`question_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE `survey_questions` ( + `survey_id` smallint(4) unsigned NOT NULL auto_increment, + `questions` mediumtext NOT NULL, + `title` varchar(255) NOT NULL, + `description` text NOT NULL, + `author_id` smallint(5) unsigned NOT NULL, + `end` date NOT NULL default '0000-00-00', + `promos` varchar(255) NOT NULL, + `valid` tinyint(1) unsigned NOT NULL default '0', + PRIMARY KEY (`survey_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + + +CREATE TABLE `survey_votes` ( + `id` smallint(4) unsigned NOT NULL auto_increment, + `survey_id` smallint(4) unsigned NOT NULL, + `user_id` smallint(5) unsigned NOT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `voter` (`survey_id`,`user_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; + +# vim: set syntax=mysql: -- 2.1.4