/usr/share/gforge/db/20090507-add_artifact_workflow.sql is in gforge-db-postgresql 5.1.1-2.
This file is owned by root:root, with mode 0o644.
The actual contents of the file can be viewed below.
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 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 | -- DEBUG code, drop before
-- DROP SEQUENCE artifact_workflow_event_id_seq;
-- DROP INDEX artifact_workflow_event_index;
-- DROP TABLE artifact_workflow_event CASCADE;
-- DROP TABLE artifact_workflow_roles CASCADE;
-- DROP TABLE artifact_workflow_notify CASCADE;
-- ALTER TABLE artifact_extra_field_list DROP CONSTRAINT artifact_extra_field_list_unique;
ALTER TABLE artifact_extra_field_list ADD CONSTRAINT artifact_extra_field_list_unique UNIQUE (group_artifact_id, extra_field_id);
-- Table: artifact_workflow_event
CREATE SEQUENCE artifact_workflow_event_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 2147483647
START 1
CACHE 1;
-- ALTER TABLE artifact_workflow_event_id_seq OWNER TO gforge;
CREATE TABLE artifact_workflow_event
(
event_id integer NOT NULL DEFAULT nextval('"artifact_workflow_event_id_seq"'::text),
group_artifact_id integer NOT NULL,
field_id integer NOT NULL,
from_value_id integer NOT NULL,
to_value_id integer NOT NULL,
CONSTRAINT artifact_workflow_event_pkey PRIMARY KEY (event_id),
CONSTRAINT artifact_workflow_event_group_artifact_id_fkey FOREIGN KEY (group_artifact_id, field_id)
REFERENCES artifact_extra_field_list (group_artifact_id, extra_field_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH OIDS;
-- ALTER TABLE artifact_workflow_event OWNER TO gforge;
-- Index: artifact_workflow_event_index
CREATE INDEX artifact_workflow_event_index
ON artifact_workflow_event
USING btree
(event_id, group_artifact_id, field_id);
-- Table: artifact_workflow_roles
CREATE TABLE artifact_workflow_roles
(
event_id integer NOT NULL,
role_id integer NOT NULL,
CONSTRAINT artifact_workflow_roles_pkey PRIMARY KEY (event_id, role_id),
CONSTRAINT artifact_workflow_roles_event_id_fkey FOREIGN KEY (event_id)
REFERENCES artifact_workflow_event (event_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH OIDS;
-- ALTER TABLE artifact_workflow_roles OWNER TO gforge;
-- Table: artifact_workflow_notify
CREATE TABLE artifact_workflow_notify
(
event_id integer NOT NULL,
role_id integer NOT NULL,
CONSTRAINT artifact_workflow_notify_pkey PRIMARY KEY (event_id, role_id),
CONSTRAINT artifact_workflow_notify_event_id_fkey FOREIGN KEY (event_id)
REFERENCES artifact_workflow_event (event_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE CASCADE
)
WITH OIDS;
-- ALTER TABLE artifact_workflow_notify OWNER TO gforge;
|