aboutsummaryrefslogtreecommitdiff
path: root/sqitch/revert
diff options
context:
space:
mode:
authorChristopher Baines <mail@cbaines.net>2020-10-02 18:14:40 +0100
committerChristopher Baines <mail@cbaines.net>2020-10-02 20:15:10 +0100
commit841f5fb18697a545f083e48e2b1e3ab47e4312e4 (patch)
tree2cbf1d634873b77bbf3f01bcffb01ae9a034ae29 /sqitch/revert
parent125a35fce557ed0c73872944c04ec39d10b4ca1c (diff)
downloaddata-service-841f5fb18697a545f083e48e2b1e3ab47e4312e4.tar
data-service-841f5fb18697a545f083e48e2b1e3ab47e4312e4.tar.gz
Change a constraint to add ON DELETE CASCADE
I've not used these in many places, to try and avoid hiding deleting data, but in this case, this will allow more easily deleting the derivation source file nars, by just deleting the derivation_source_files table entry.
Diffstat (limited to 'sqitch/revert')
-rw-r--r--sqitch/revert/change_derivation_source_file_nars_constraint.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/sqitch/revert/change_derivation_source_file_nars_constraint.sql b/sqitch/revert/change_derivation_source_file_nars_constraint.sql
new file mode 100644
index 0000000..a2143f8
--- /dev/null
+++ b/sqitch/revert/change_derivation_source_file_nars_constraint.sql
@@ -0,0 +1,7 @@
+-- Revert guix-data-service:change_derivation_source_file_nars_constraint from pg
+
+BEGIN;
+
+-- XXX Add DDLs here.
+
+COMMIT;