X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.1.0%2F10_surveys.sql;h=e6e5f473bfb6d749bb7c1bc1671d288cee5eba0e;hb=5b48ebf46ef939d701852d2117bbcf308036027c;hp=010a72b0d5f3304c75b754c6144093de19c179f0;hpb=2f4b93beb55b35a978d3a9520bdf67ac3abf43fb;p=platal.git

diff --git a/upgrade/1.1.0/10_surveys.sql b/upgrade/1.1.0/10_surveys.sql
index 010a72b..e6e5f47 100644
--- a/upgrade/1.1.0/10_surveys.sql
+++ b/upgrade/1.1.0/10_surveys.sql
@@ -16,12 +16,11 @@ CREATE TABLE surveys (
     description TEXT NOT NULL,
     begin       DATE NOT NULL,
     end         DATE NOT NULL,
-    anonymous   TINYINT(1) DEFAULT 0,
 
     voters      TEXT DEFAULT NULL COMMENT "Filter users who can vote",
     viewers     TEXT DEFAULT NULL COMMENT "Filter users who can see the results",
 
-    flags       SET('validated'),
+    flags       SET('validated', 'anonymous'),
 
     PRIMARY KEY id (id),
     UNIQUE KEY shortname (shortname),
@@ -47,10 +46,10 @@ CREATE TABLE survey_questions (
 ) ENGINE=InnoDB, CHARSET=utf8, COMMENT="Describe the questions of the surveys";
 
 CREATE TABLE survey_votes (
+    vid         INT(11) UNSIGNED NOT NULL auto_increment,
     sid         INT(11) UNSIGNED NOT NULL,
-    vid         INT(11) UNSIGNED NOT NULL,
 
-    PRIMARY KEY id (sid, vid),
+    PRIMARY KEY vid (vid),
     FOREIGN KEY (sid) REFERENCES surveys (id)
                       ON UPDATE CASCADE
                       ON DELETE CASCADE
@@ -72,12 +71,15 @@ CREATE TABLE survey_voters (
 
 CREATE TABLE survey_vote_answers (
     sid         INT(11) UNSIGNED NOT NULL,
-    vid         INT(11) UNSIGNED NOT NULL,
     qid         INT(11) UNSIGNED NOT NULL,
+    vid         INT(11) UNSIGNED NOT NULL,
 
     answer      TEXT DEFAULT NULL,
 
     PRIMARY KEY id (sid, vid, qid),
+    FOREIGN KEY (vid) REFERENCES survey_votes (vid)
+                      ON UPDATE CASCADE
+                      ON DELETE CASCADE,
     FOREIGN KEY (sid, qid) REFERENCES survey_questions (sid, qid)
                            ON UPDATE CASCADE
                            ON DELETE CASCADE