/usr/share/gforge/db/20121123-multiple-scm-repositories.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 | CREATE TABLE scm_secondary_repos (
group_id int NOT NULL REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE,
plugin_id int NOT NULL REFERENCES plugins ON DELETE CASCADE ON UPDATE CASCADE,
repo_name text NOT NULL,
clone_url text NOT NULL,
description text NOT NULL,
next_action int DEFAULT 0 NOT NULL,
CONSTRAINT scm_secondary_repos_unique UNIQUE (group_id, plugin_id, repo_name)
) ;
CREATE INDEX scm_secondary_repos_gid_idx ON scm_secondary_repos (group_id) ;
CREATE TABLE scm_personal_repos (
group_id int NOT NULL REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE,
plugin_id int NOT NULL REFERENCES plugins ON DELETE CASCADE ON UPDATE CASCADE,
user_id int NOT NULL REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE,
next_action int DEFAULT 0 NOT NULL,
CONSTRAINT scm_personal_repos_unique UNIQUE (group_id, plugin_id, user_id)
) ;
CREATE INDEX scm_personal_repos_uid_idx ON scm_personal_repos (group_id) ;
|