projects
/
platal.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
tree
raw
|
inline
| side by side
Merge branch 'xorg/maint' into xorg/master
[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,
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:
) ENGINE=InnoDB, CHARSET=utf8;
-- vim:set syntax=mysql: