db/schema_0008-add_user_object_to_admin_log.sql


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


commit;