summaryrefslogtreecommitdiff
path: root/util
diff options
context:
space:
mode:
Diffstat (limited to 'util')
-rw-r--r--util/updates/2020-04-16-imgflag-user-deletion.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/util/updates/2020-04-16-imgflag-user-deletion.sql b/util/updates/2020-04-16-imgflag-user-deletion.sql
new file mode 100644
index 00000000..f8f21ac1
--- /dev/null
+++ b/util/updates/2020-04-16-imgflag-user-deletion.sql
@@ -0,0 +1,4 @@
+ALTER TABLE image_votes ADD CONSTRAINT image_votes_uid_fkey FOREIGN KEY (uid) REFERENCES users (id) ON DELETE SET DEFAULT;
+
+DROP TRIGGER image_votes_cache ON image_votes;
+\i sql/triggers.sql