/usr/share/gforge/db/20140521-fix-forum_saved_place-fk.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 | -- 'forum' confusingly stores forum messages, not forums.
-- 'forum_saved_place' references forum, not forum messages.
-- The following fixes errors such as:
-- Forum::savePlace() : ERROR: insert or update on table "forum_saved_place" violates foreign key constraint "forum_saved_place_forum_id_fkey" DÉTAIL : Key (forum_id)=(10462) is not present in table "forum".
ALTER TABLE forum_saved_place DROP CONSTRAINT forum_saved_place_forum_id_fkey;
ALTER TABLE forum_saved_place ADD FOREIGN KEY (forum_id) REFERENCES forum_group_list (group_forum_id) ON DELETE CASCADE ON UPDATE CASCADE;
|