summaryrefslogtreecommitdiffstats
path: root/schema/mysql-legacy-changes/upgrade_42.sql
diff options
context:
space:
mode:
Diffstat (limited to 'schema/mysql-legacy-changes/upgrade_42.sql')
-rw-r--r--schema/mysql-legacy-changes/upgrade_42.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/schema/mysql-legacy-changes/upgrade_42.sql b/schema/mysql-legacy-changes/upgrade_42.sql
new file mode 100644
index 0000000..849ffda
--- /dev/null
+++ b/schema/mysql-legacy-changes/upgrade_42.sql
@@ -0,0 +1,7 @@
+ALTER TABLE import_run DROP FOREIGN KEY import_run_source;
+ALTER TABLE import_run ADD CONSTRAINT import_run_source
+ FOREIGN KEY import_source (source_id)
+ REFERENCES import_source (id)
+ ON DELETE CASCADE
+ ON UPDATE RESTRICT;
+