diff options
Diffstat (limited to 'db/sql/triggers.sql')
-rw-r--r-- | db/sql/triggers.sql | 11 |
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 @@ | |||
1 | CREATE TRIGGER IF NOT EXISTS enforce_size_id | ||
2 | BEFORE INSERT ON Preferences | ||
3 | BEGIN | ||
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; | ||
11 | END; | ||