diff options
Diffstat (limited to 'util/updates/2021-09-02-some-foreign-key-stuff.sql')
-rw-r--r-- | util/updates/2021-09-02-some-foreign-key-stuff.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/util/updates/2021-09-02-some-foreign-key-stuff.sql b/util/updates/2021-09-02-some-foreign-key-stuff.sql new file mode 100644 index 00000000..09abff70 --- /dev/null +++ b/util/updates/2021-09-02-some-foreign-key-stuff.sql @@ -0,0 +1,5 @@ +-- Add an ON UPDATE CASCADE clause to these contraints to simplify moving lists across users or VNs. +ALTER TABLE ulist_vns_labels DROP CONSTRAINT ulist_vns_labels_uid_lbl_fkey; +ALTER TABLE ulist_vns_labels DROP CONSTRAINT ulist_vns_labels_uid_vid_fkey; +ALTER TABLE ulist_vns_labels ADD CONSTRAINT ulist_vns_labels_uid_lbl_fkey FOREIGN KEY (uid,lbl) REFERENCES ulist_labels (uid,id) ON DELETE CASCADE ON UPDATE CASCADE; +ALTER TABLE ulist_vns_labels ADD CONSTRAINT ulist_vns_labels_uid_vid_fkey FOREIGN KEY (uid,vid) REFERENCES ulist_vns (uid,vid) ON DELETE CASCADE ON UPDATE CASCADE; |