1 -- DEBUG code, drop before
2 -- DROP SEQUENCE artifact_workflow_event_id_seq;
3 -- DROP INDEX artifact_workflow_event_index;
4 -- DROP TABLE artifact_workflow_event CASCADE;
5 -- DROP TABLE artifact_workflow_roles CASCADE;
6 -- DROP TABLE artifact_workflow_notify CASCADE;
7 -- ALTER TABLE artifact_extra_field_list DROP CONSTRAINT artifact_extra_field_list_unique;
9 ALTER TABLE artifact_extra_field_list ADD CONSTRAINT artifact_extra_field_list_unique UNIQUE (group_artifact_id, extra_field_id);
11 -- Table: artifact_workflow_event
13 CREATE SEQUENCE artifact_workflow_event_id_seq
19 -- ALTER TABLE artifact_workflow_event_id_seq OWNER TO gforge;
21 CREATE TABLE artifact_workflow_event
23 event_id integer NOT NULL DEFAULT nextval('"artifact_workflow_event_id_seq"'::text),
24 group_artifact_id integer NOT NULL,
25 field_id integer NOT NULL,
26 from_value_id integer NOT NULL,
27 to_value_id integer NOT NULL,
28 CONSTRAINT artifact_workflow_event_pkey PRIMARY KEY (event_id),
29 CONSTRAINT artifact_workflow_event_group_artifact_id_fkey FOREIGN KEY (group_artifact_id, field_id)
30 REFERENCES artifact_extra_field_list (group_artifact_id, extra_field_id) MATCH SIMPLE
31 ON UPDATE NO ACTION ON DELETE CASCADE
34 -- ALTER TABLE artifact_workflow_event OWNER TO gforge;
36 -- Index: artifact_workflow_event_index
38 CREATE INDEX artifact_workflow_event_index
39 ON artifact_workflow_event
41 (event_id, group_artifact_id, field_id);
45 -- Table: artifact_workflow_roles
47 CREATE TABLE artifact_workflow_roles
49 event_id integer NOT NULL,
50 role_id integer NOT NULL,
51 CONSTRAINT artifact_workflow_roles_pkey PRIMARY KEY (event_id, role_id),
52 CONSTRAINT artifact_workflow_roles_event_id_fkey FOREIGN KEY (event_id)
53 REFERENCES artifact_workflow_event (event_id) MATCH SIMPLE
54 ON UPDATE NO ACTION ON DELETE CASCADE
57 -- ALTER TABLE artifact_workflow_roles OWNER TO gforge;
60 -- Table: artifact_workflow_notify
62 CREATE TABLE artifact_workflow_notify
64 event_id integer NOT NULL,
65 role_id integer NOT NULL,
66 CONSTRAINT artifact_workflow_notify_pkey PRIMARY KEY (event_id, role_id),
67 CONSTRAINT artifact_workflow_notify_event_id_fkey FOREIGN KEY (event_id)
68 REFERENCES artifact_workflow_event (event_id) MATCH SIMPLE
69 ON UPDATE NO ACTION ON DELETE CASCADE
72 -- ALTER TABLE artifact_workflow_notify OWNER TO gforge;