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
29
30
31
32
33
34
35
36
37
38
39
40
|
ALTER TABLE artifact_extra_field_list ADD COLUMN is_required INT;
UPDATE artifact_extra_field_list SET is_required=0;
ALTER TABLE artifact_extra_field_list ALTER COLUMN is_required SET NOT NULL;
ALTER TABLE artifact_extra_field_list ALTER COLUMN is_required SET DEFAULT 0;
ALTER TABLE artifact_extra_field_elements ADD COLUMN status_id INT;
UPDATE artifact_extra_field_elements SET status_id=0;
ALTER TABLE artifact_extra_field_elements ALTER COLUMN status_id SET NOT NULL;
ALTER TABLE artifact_extra_field_elements ALTER COLUMN status_id SET DEFAULT 0;
ALTER TABLE artifact_group_list ADD COLUMN custom_status_field INT;
UPDATE artifact_group_list SET custom_status_field=0;
ALTER TABLE artifact_group_list ALTER COLUMN custom_status_field SET NOT NULL;
ALTER TABLE artifact_group_list ALTER COLUMN custom_status_field SET DEFAULT 0;
ALTER TABLE artifact_group_list ADD COLUMN custom_renderer TEXT;
CREATE TABLE artifact_query (
artifact_query_id SERIAL NOT NULL,
group_artifact_id integer NOT NULL
CONSTRAINT artquery_groupartid_fk REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE,
user_id integer NOT NULL,
query_name text NOT NULL,
Constraint artifact_query_pkey Primary Key (artifact_query_id)
);
CREATE TABLE artifact_query_fields (
artifact_query_id integer NOT NULL
CONSTRAINT artqueryelmnt_artqueryid REFERENCES artifact_query(artifact_query_id) ON DELETE CASCADE,
query_field_type text NOT NULL,
query_field_id int NOT NULL,
query_field_values text NOT NULL,
Constraint artifact_query_elements_pkey Primary Key (artifact_query_id,query_field_type,query_field_id)
);
ALTER TABLE doc_groups ADD COLUMN parent_doc_group INTEGER;
UPDATE doc_groups SET parent_doc_group=0;
ALTER TABLE doc_groups ALTER COLUMN parent_doc_group SET NOT NULL;
ALTER TABLE doc_groups ALTER COLUMN parent_doc_group SET DEFAULT 0;
CREATE INDEX docgroups_parentdocgroup ON doc_groups(parent_doc_group);
|
