Fixes small errors in merge files.

[platal.git] / upgrade / 1.0.1 / 15_merge_issues.sql

diff --git a/upgrade/1.0.1/15_merge_issues.sql b/upgrade/1.0.1/15_merge_issues.sql
index b96baf0..259970c 100644 (file)
--- 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: