/usr/share/gforge/db/20121026-add-constraints.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 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 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 | ALTER TABLE users_idx ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE user_session ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE user_ratings ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE user_ratings ADD FOREIGN KEY (rated_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE user_preferences ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE user_metric_history ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE user_diary ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE user_bookmarks ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE survey_responses ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE survey_rating_response ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM stats_cvs_user WHERE user_id NOT IN (SELECT user_id FROM users);
ALTER TABLE stats_cvs_user ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE snippet_version ADD FOREIGN KEY (submitted_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE snippet_package_version ADD FOREIGN KEY (submitted_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE snippet_package ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE snippet ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE rep_user_act_weekly ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE rep_user_act_monthly ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE rep_user_act_daily ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE rep_time_tracking ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_assigned_to ADD FOREIGN KEY (assigned_to_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_skill_inventory ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE news_bytes ADD FOREIGN KEY (submitted_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE forum_saved_place ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM filemodule_monitor WHERE user_id NOT IN (SELECT user_id FROM users);
ALTER TABLE filemodule_monitor ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE doc_data ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE doc_data ADD FOREIGN KEY (reserved_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE doc_data ADD FOREIGN KEY (locked_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE forum_pending_messages ADD FOREIGN KEY (posted_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM frs_dlstats_file WHERE user_id NOT IN (SELECT user_id FROM users);
ALTER TABLE frs_dlstats_file ADD FOREIGN KEY (user_id) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE skills_data_idx ADD FOREIGN KEY (skills_data_id) REFERENCES skills_data ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_task_idx ADD FOREIGN KEY (project_task_id) REFERENCES project_task ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE news_bytes_idx ADD FOREIGN KEY (id) REFERENCES news_bytes ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE groups_idx ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE frs_release_idx ADD FOREIGN KEY (release_id) REFERENCES frs_release ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE frs_file_idx ADD FOREIGN KEY (file_id) REFERENCES frs_file ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE forum_idx ADD FOREIGN KEY (msg_id) REFERENCES forum ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE doc_data_idx ADD FOREIGN KEY (docid) REFERENCES doc_data ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE artifact_idx ADD FOREIGN KEY (artifact_id) REFERENCES artifact ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE surveys ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE survey_questions ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM stats_subd_pages WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE stats_subd_pages ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM stats_project_months WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE stats_project_months ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM stats_project_metric WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE stats_project_metric ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM stats_project WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE stats_project ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE stats_cvs_group ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE roadmap ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM rep_group_act_weekly WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE rep_group_act_weekly ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM rep_group_act_monthly WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE rep_group_act_monthly ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE rep_group_act_daily ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM prweb_vhost WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE prweb_vhost ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_weekly_metric ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_sums_agg ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_metric ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM group_history WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE group_history ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE group_cvs_history ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE db_images ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE doc_data_idx ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE news_bytes ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM stats_project_developers WHERE group_id NOT IN (SELECT group_id FROM groups);
ALTER TABLE stats_project_developers ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE prdb_dbs ADD FOREIGN KEY (group_id) REFERENCES groups ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE survey_questions ADD FOREIGN KEY (question_type) REFERENCES survey_question_types ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_history ADD FOREIGN KEY (project_task_id) REFERENCES project_task ON DELETE CASCADE ON UPDATE CASCADE;
DELETE FROM project_dependencies WHERE is_dependent_on_task_id NOT IN (SELECT project_task_id FROM project_task);
ALTER TABLE project_dependencies ADD FOREIGN KEY (project_task_id) REFERENCES project_task ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_dependencies ADD FOREIGN KEY (is_dependent_on_task_id) REFERENCES project_task ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE project_counts_agg ADD FOREIGN KEY (group_project_id) REFERENCES project_group_list ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE prdb_states ADD PRIMARY KEY (stateid);
ALTER TABLE prdb_dbs ADD FOREIGN KEY (dbtype) REFERENCES prdb_types ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE prdb_dbs ADD FOREIGN KEY (state) REFERENCES prdb_states ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job_inventory ADD FOREIGN KEY (job_id) REFERENCES people_job ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job_inventory ADD FOREIGN KEY (skill_id) REFERENCES people_skill ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job_inventory ADD FOREIGN KEY (skill_level_id) REFERENCES people_skill_level ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job_inventory ADD FOREIGN KEY (skill_year_id) REFERENCES people_skill_year ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job ADD FOREIGN KEY (status_id) REFERENCES people_job_status ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE people_job ADD FOREIGN KEY (category_id) REFERENCES people_job_category ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE frs_dlstats_filetotal_agg ADD FOREIGN KEY (file_id) REFERENCES frs_file ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE forum_agg_msg_count ADD FOREIGN KEY (group_forum_id) REFERENCES forum_group_list ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE artifact_canned_responses ADD FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE artifact_counts_agg ADD FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE artifact_extra_field_elements ADD FOREIGN KEY (extra_field_id) REFERENCES artifact_extra_field_list ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE artifact_extra_field_data ADD FOREIGN KEY (extra_field_id) REFERENCES artifact_extra_field_list ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE artifact_extra_field_data ADD FOREIGN KEY (artifact_id) REFERENCES artifact ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE artifact_extra_field_list ADD FOREIGN KEY (group_artifact_id) REFERENCES artifact_group_list ON DELETE CASCADE ON UPDATE CASCADE;
|