/usr/share/gforge/db/20120801-create-indices.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 30 31 32 33 34 35 | CREATE INDEX layouts_contents_owner_idx ON layouts_contents (owner_type,owner_id);
ALTER TABLE users_idx ADD PRIMARY KEY (user_id);
ALTER TABLE groups_idx ADD PRIMARY KEY (group_id);
DROP INDEX artmonitor_useridartid;
ALTER TABLE artifact_monitor DROP COLUMN id;
ALTER TABLE artifact_monitor ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
DROP SEQUENCE artifact_monitor_id_seq;
DELETE FROM docdata_monitored_docman WHERE doc_id NOT IN (SELECT docid FROM doc_data);
ALTER TABLE docdata_monitored_docman DROP COLUMN monitor_id;
ALTER TABLE docdata_monitored_docman ADD PRIMARY KEY (doc_id, user_id);
ALTER TABLE docdata_monitored_docman ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
ALTER TABLE docdata_monitored_docman ADD FOREIGN KEY (doc_id) REFERENCES doc_data(docid);
DROP SEQUENCE docdata_monitored_docman_pk_seq;
ALTER TABLE docgroup_monitored_docman DROP COLUMN monitor_id;
ALTER TABLE docgroup_monitored_docman ADD PRIMARY KEY (docgroup_id, user_id);
ALTER TABLE docgroup_monitored_docman ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
ALTER TABLE docgroup_monitored_docman ADD FOREIGN KEY (docgroup_id) REFERENCES doc_groups(doc_group);
DROP SEQUENCE docgroup_monitored_docman_pk_seq;
DROP INDEX forummonitoredforums_useridforumid;
ALTER TABLE forum_monitored_forums DROP COLUMN monitor_id;
ALTER TABLE forum_monitored_forums ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
ALTER TABLE forum_monitored_forums ADD FOREIGN KEY (forum_id) REFERENCES forum_group_list(group_forum_id);
DROP SEQUENCE forum_monitored_forums_pk_seq;
DELETE FROM user_diary_monitor WHERE user_id NOT IN (SELECT user_id FROM users);
DROP INDEX userdiarymon_useridmonitoredid;
ALTER TABLE user_diary_monitor ADD FOREIGN KEY (user_id) REFERENCES users(user_id);
ALTER TABLE user_diary_monitor ADD FOREIGN KEY (monitored_user) REFERENCES users(user_id);
ALTER TABLE user_diary_monitor DROP COLUMN monitor_id;
DROP SEQUENCE user_diary_monitor_pk_seq;
|