/usr/share/gforge/db/FTI-20060130.sql is in gforge-db-postgresql 5.1.1-2.
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 | SET client_min_messages TO warning;
DROP FUNCTION doc_data_search(text, int, text, bool) CASCADE;
DROP FUNCTION news_bytes_search(text, int) CASCADE;
DROP FUNCTION artifact_search(text, int) CASCADE;
DROP FUNCTION trackers_search(text, int, text, bool) CASCADE;
CREATE TRIGGER artifactmessage_ts_update AFTER UPDATE OR INSERT OR DELETE ON artifact_message
FOR EACH ROW EXECUTE PROCEDURE update_vectors('artifact_message');
DELETE FROM artifact_message_idx;
INSERT INTO artifact_message_idx (id, artifact_id, vectors)
SELECT id, artifact_id, to_tsvector(coalesce(body,'')) AS vectors
FROM artifact_message ORDER BY id;
|