db/schema_0065-add-moderation-admin-log.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

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;