/usr/share/gforge/db/20121026-more-db-cleaning.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 | ALTER TABLE project_assigned_to DROP COLUMN project_assigned_id;
DROP INDEX projectassigned_assignedtotaskid;
DROP SEQUENCE project_assigned_to_pk_seq;
ALTER TABLE forum_saved_place DROP COLUMN saved_place_id;
DROP SEQUENCE forum_saved_place_pk_seq;
DELETE FROM forum_saved_place WHERE forum_id NOT IN (SELECT msg_id FROM forum);
ALTER TABLE forum_saved_place ADD FOREIGN KEY (forum_id) REFERENCES forum (msg_id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE filemodule_monitor DROP COLUMN id;
DROP SEQUENCE filemodule_monitor_pk_seq;
DELETE FROM filemodule_monitor WHERE filemodule_id NOT IN (SELECT package_id FROM frs_package);
ALTER TABLE filemodule_monitor ADD FOREIGN KEY (filemodule_id) REFERENCES frs_package (package_id) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE prdb_dbs ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE trove_treesums DROP COLUMN trove_treesums_id;
DROP SEQUENCE trove_treesums_pk_seq;
ALTER TABLE prdb_dbs ADD FOREIGN KEY (created_by) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
UPDATE mail_group_list SET list_admin=100 WHERE list_admin NOT IN (SELECT user_id FROM users);
ALTER TABLE mail_group_list ADD FOREIGN KEY (list_admin) REFERENCES users ON DELETE CASCADE ON UPDATE CASCADE;
|