1 CREATE TABLE scm_secondary_repos (
2 group_id int NOT NULL REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE,
3 plugin_id int NOT NULL REFERENCES plugins ON DELETE CASCADE ON UPDATE CASCADE,
4 repo_name text NOT NULL,
5 clone_url text NOT NULL,
6 description text NOT NULL,
7 next_action int DEFAULT 0 NOT NULL,
8 CONSTRAINT scm_secondary_repos_unique UNIQUE (group_id, plugin_id, repo_name)
10 CREATE INDEX scm_secondary_repos_gid_idx ON scm_secondary_repos (group_id) ;
12 CREATE TABLE scm_personal_repos (
13 group_id int NOT NULL REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE,
14 plugin_id int NOT NULL REFERENCES plugins ON DELETE CASCADE ON UPDATE CASCADE,
15 user_id int NOT NULL REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE,
16 next_action int DEFAULT 0 NOT NULL,
17 CONSTRAINT scm_personal_repos_unique UNIQUE (group_id, plugin_id, user_id)
19 CREATE INDEX scm_personal_repos_uid_idx ON scm_personal_repos (group_id) ;