Uncomment foreign keys.

[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..4a792f0 100644 (file)
--- a/upgrade/1.0.1/12_profiles.sql
+++ b/upgrade/1.0.1/12_profiles.sql
@@ -8,8 +8,8 @@ CREATE TABLE profile_modifications (
   newText TEXT NOT NULL,
   pub ENUM('private', 'ax', 'public') NOT NULL DEFAULT 'private',
   PRIMARY KEY(pid, uid, field)
   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
+  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: