X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F12_profiles.sql;h=9a337978ab423f2c02a9ca456c0ad0cb4592ce4e;hb=69d311a9e667ba071af1070cfe9a6906a4f0ed32;hp=1c5a8d5bd4733f75092af5075bd87f8d705a5779;hpb=f73d928119c633d998c1fc3c3b78613d3fe438f3;p=platal.git

diff --git a/upgrade/1.0.1/12_profiles.sql b/upgrade/1.0.1/12_profiles.sql
index 1c5a8d5..9a33797 100644
--- a/upgrade/1.0.1/12_profiles.sql
+++ b/upgrade/1.0.1/12_profiles.sql
@@ -7,9 +7,9 @@ CREATE TABLE profile_modifications (
   oldText TEXT NOT NULL,
   newText TEXT NOT NULL,
   pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
-  PRIMARY KEY(pid, uid, field)
-  #FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
-  #FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
+  PRIMARY KEY(pid, uid, field),
+  FOREIGN KEY (uid) REFERENCES accounts (uid) ON DELETE CASCADE ON UPDATE CASCADE,
+  FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB, CHARSET=utf8;
 
 -- vim:set syntax=mysql: