aboutsummaryrefslogtreecommitdiff
path: root/db/sql/triggers.sql
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;