1 ALTER TABLE artifact_extra_field_list ADD COLUMN is_required INT;
2 UPDATE artifact_extra_field_list SET is_required=0;
3 ALTER TABLE artifact_extra_field_list ALTER COLUMN is_required SET NOT NULL;
4 ALTER TABLE artifact_extra_field_list ALTER COLUMN is_required SET DEFAULT 0;
6 ALTER TABLE artifact_extra_field_elements ADD COLUMN status_id INT;
7 UPDATE artifact_extra_field_elements SET status_id=0;
8 ALTER TABLE artifact_extra_field_elements ALTER COLUMN status_id SET NOT NULL;
9 ALTER TABLE artifact_extra_field_elements ALTER COLUMN status_id SET DEFAULT 0;
11 ALTER TABLE artifact_group_list ADD COLUMN custom_status_field INT;
12 UPDATE artifact_group_list SET custom_status_field=0;
13 ALTER TABLE artifact_group_list ALTER COLUMN custom_status_field SET NOT NULL;
14 ALTER TABLE artifact_group_list ALTER COLUMN custom_status_field SET DEFAULT 0;
16 ALTER TABLE artifact_group_list ADD COLUMN custom_renderer TEXT;
18 CREATE TABLE artifact_query (
19 artifact_query_id SERIAL NOT NULL,
20 group_artifact_id integer NOT NULL
21 CONSTRAINT artquery_groupartid_fk REFERENCES artifact_group_list(group_artifact_id) ON DELETE CASCADE,
22 user_id integer NOT NULL,
23 query_name text NOT NULL,
24 Constraint artifact_query_pkey Primary Key (artifact_query_id)
27 CREATE TABLE artifact_query_fields (
28 artifact_query_id integer NOT NULL
29 CONSTRAINT artqueryelmnt_artqueryid REFERENCES artifact_query(artifact_query_id) ON DELETE CASCADE,
30 query_field_type text NOT NULL,
31 query_field_id int NOT NULL,
32 query_field_values text NOT NULL,
33 Constraint artifact_query_elements_pkey Primary Key (artifact_query_id,query_field_type,query_field_id)
36 ALTER TABLE doc_groups ADD COLUMN parent_doc_group INTEGER;
37 UPDATE doc_groups SET parent_doc_group=0;
38 ALTER TABLE doc_groups ALTER COLUMN parent_doc_group SET NOT NULL;
39 ALTER TABLE doc_groups ALTER COLUMN parent_doc_group SET DEFAULT 0;
40 CREATE INDEX docgroups_parentdocgroup ON doc_groups(parent_doc_group);