myheats

commit 3c517efe44977380cc31d2ef0486ab401fcb90e7
parent 31d8f029733fd59e8b97ab069c04645f34f3cb0a
Author: Andreas Gruhler <andreas.gruhler@adfinis.com>
Date:   Sun, 23 Jul 2023 10:17:29 +0200

fix: cascade delete judges on scores

Diffstat:
M
schema/scores.sql
 | 
2
+-

1 file changed, 1 insertion(+), 1 deletion(-)
diff --git a/schema/scores.sql b/schema/scores.sql
@@ -86,7 +86,7 @@ ALTER TABLE ONLY public.scores
 --
 
 ALTER TABLE ONLY public.scores
-    ADD CONSTRAINT scores_judge_fkey FOREIGN KEY (judge) REFERENCES public.judges(id);
+    ADD CONSTRAINT scores_judge_fkey FOREIGN KEY (judge) REFERENCES public.judges(id) ON DELETE CASCADE;
 
 
 --