blob: 3827642050c7cc22dfd8c4749374ffec718063ee (
plain)
1
2
3
4
5
6
7
8
9
10
11
|
CREATE TRIGGER IF NOT EXISTS enforce_size_id
BEFORE INSERT ON Preferences
BEGIN
SELECT
CASE
WHEN (
SELECT COUNT(*) FROM Sizes WHERE id = new.size_id
) = 0
THEN RAISE(ABORT, 'Size does not exist')
END;
END;
|