I forgot to commit the sql script for last commits.

[platal.git] / upgrade / 1.0.1 / 12_profiles.sql

diff --git a/upgrade/1.0.1/12_profiles.sql b/upgrade/1.0.1/12_profiles.sql
index 1c5a8d5..9a33797 100644 (file)
--- 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',
   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:
 ) ENGINE=InnoDB, CHARSET=utf8;
 
 -- vim:set syntax=mysql: