aboutsummaryrefslogtreecommitdiffstats
path: root/db/downgrade_0069---0068.sql
blob: 6682585243a55ae575908ed48966df596c2406c9 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
BEGIN;

ALTER TABLE admin_log DROP CONSTRAINT admin_log_object_type_check;

ALTER TABLE admin_log ADD CONSTRAINT admin_log_object_type_check CHECK (
    object_type = 'problem'
    OR object_type = 'update'
    OR object_type = 'user'
    OR object_type = 'moderation'
);

COMMIT;