From 9fb4728484e32743f5796f0e2aa8a49113b8078e Mon Sep 17 00:00:00 2001 From: x2004laborde Date: Tue, 10 Apr 2007 14:17:09 +0000 Subject: [PATCH] changes in surveys database structure git-svn-id: svn+ssh://murphy/home/svn/platal/trunk@1680 839d8a87-29fc-0310-9880-83ba4fa771e5 --- upgrade/0.9.14/07_survey.sql | 13 ++++++------- 1 file changed, 6 insertions(+), 7 deletions(-) diff --git a/upgrade/0.9.14/07_survey.sql b/upgrade/0.9.14/07_survey.sql index f2d24bb..6528dca 100644 --- a/upgrade/0.9.14/07_survey.sql +++ b/upgrade/0.9.14/07_survey.sql @@ -1,33 +1,32 @@ 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`) + UNIQUE KEY `vote` (`vote_id`,`question_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -CREATE TABLE `survey_questions` ( - `survey_id` smallint(4) unsigned NOT NULL auto_increment, +CREATE TABLE `survey_surveys` ( + `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', + `mode` tinyint(2) unsigned NOT NULL default '0', `promos` varchar(255) NOT NULL, `valid` tinyint(1) unsigned NOT NULL default '0', - PRIMARY KEY (`survey_id`) + PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE `survey_votes` ( - `id` smallint(4) unsigned NOT NULL auto_increment, + `id` smallint(5) 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