blob: 308d345f565b34f87a3e651e5bfba3ef0e5c5e77 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
|
BEGIN;
CREATE TABLE manifest_theme (
id serial not null primary key,
cobrand text not null unique,
name text not null,
short_name text not null,
background_colour text,
theme_colour text,
images text ARRAY
);
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'
OR object_type = 'template'
OR object_type = 'body'
OR object_type = 'category'
OR object_type = 'role'
OR object_type = 'manifesttheme'
);
COMMIT;
|
