aboutsummaryrefslogtreecommitdiffstats
path: root/db/downgrade_0065---0064.sql
blob: 455627b770288c1d022fc71c608bc650e52f71f7 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
BEGIN;

DELETE FROM admin_log WHERE object_type = 'moderation';

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'
);

COMMIT;