X-Git-Url: http://git.polytechnique.org/?a=blobdiff_plain;f=upgrade%2F1.0.1%2F15_merge_issues.sql;h=259970c98be14ccf71a4865f4cca18955194e2ae;hb=3d964835e8ff04f0f86c80aea026b82896cb4a46;hp=b96baf02a27283d11b8cfcb4bb44025466294a06;hpb=e7a4823959ee4d267f653d463ccdd09841849b8c;p=platal.git

diff --git a/upgrade/1.0.1/15_merge_issues.sql b/upgrade/1.0.1/15_merge_issues.sql
index b96baf0..259970c 100644
--- a/upgrade/1.0.1/15_merge_issues.sql
+++ b/upgrade/1.0.1/15_merge_issues.sql
@@ -6,7 +6,8 @@ CREATE TABLE IF NOT EXISTS profile_merge_issues (
   deathdate_ax DATE DEFAULT NULL,
   name VARCHAR(255) DEFAULT NULL,
   name_type TINYINT(2) UNSIGNED DEFAULT NULL,
-  PRIMARY KEY (pid)
+  PRIMARY KEY (pid),
+  FOREIGN KEY (pid) REFERENCES profiles (pid) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB, CHARSET=utf8;
 
 -- vim:set syntax=mysql: