X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F0.9.14%2F07_survey.sql;h=b118916571251f7df1b0ae9331303d1a252fbdf3;hb=9f01f40bbb3074f13b228d98f3a9db8f23ea4992;hp=6528dca5b06c1a327eefd6679f46f870de11d10f;hpb=441c2451a618423c3ce326af2598714b68e40631;p=platal.git

diff --git a/upgrade/0.9.14/07_survey.sql b/upgrade/0.9.14/07_survey.sql
index 6528dca..b118916 100644
--- a/upgrade/0.9.14/07_survey.sql
+++ b/upgrade/0.9.14/07_survey.sql
@@ -4,7 +4,7 @@ CREATE TABLE `survey_answers` (
   `question_id` smallint(3) unsigned NOT NULL,
   `answer` text NOT NULL,
   PRIMARY KEY  (`id`),
-  UNIQUE KEY `vote` (`vote_id`,`question_id`)
+  KEY `vote` (`vote_id`,`question_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
@@ -27,6 +27,7 @@ CREATE TABLE `survey_votes` (
   `survey_id` smallint(4) unsigned NOT NULL,
   `user_id` smallint(5) unsigned NOT NULL,
   PRIMARY KEY  (`id`),
+  KEY `voter` (`survey_id`,`user_id`)
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 # vim: set syntax=mysql: