/usr/share/gforge/db/20111129_roadmap.sql is in gforge-db-postgresql 5.3.2+20141104-3+deb8u3.
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 | CREATE SEQUENCE roadmap_id_seq
INCREMENT 1
MINVALUE 1
MAXVALUE 2147483647
START 1
CACHE 1;
CREATE TABLE roadmap
(
roadmap_id integer NOT NULL DEFAULT nextval('roadmap_id_seq'::regclass),
"name" text,
group_id integer NOT NULL,
"enable" integer,
release_order text,
is_default integer,
CONSTRAINT roadmap_pkey PRIMARY KEY (roadmap_id)
)
WITH OIDS;
CREATE TABLE roadmap_list
(
roadmap_id integer NOT NULL,
artifact_type_id integer NOT NULL,
field_id integer NOT NULL,
CONSTRAINT roadmap_id FOREIGN KEY (roadmap_id)
REFERENCES roadmap (roadmap_id) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH OIDS;
|