aboutsummaryrefslogtreecommitdiff
path: root/db/sql/triggers.sql
diff options
context:
space:
mode:
Diffstat (limited to 'db/sql/triggers.sql')
-rw-r--r--db/sql/triggers.sql11
1 files changed, 11 insertions, 0 deletions
diff --git a/db/sql/triggers.sql b/db/sql/triggers.sql
new file mode 100644
index 0000000..3827642
--- /dev/null
+++ b/db/sql/triggers.sql
@@ -0,0 +1,11 @@
1CREATE TRIGGER IF NOT EXISTS enforce_size_id
2BEFORE INSERT ON Preferences
3BEGIN
4 SELECT
5 CASE
6 WHEN (
7 SELECT COUNT(*) FROM Sizes WHERE id = new.size_id
8 ) = 0
9 THEN RAISE(ABORT, 'Size does not exist')
10 END;
11END;