/usr/share/gforge/db/20050804-1.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 | ALTER TABLE doc_data ADD COLUMN filesize INTEGER;
UPDATE doc_data SET filesize=0;
ALTER TABLE doc_data ALTER COLUMN filesize SET NOT NULL;
ALTER TABLE doc_data ALTER COLUMN filesize SET DEFAULT 0;
DROP VIEW docdata_vw;
CREATE VIEW docdata_vw AS
SELECT users.user_name, users.realname, users.email, d.group_id, d.docid, d.stateid, d.title, d.updatedate, d.createdate, d.created_by, d.doc_group, d.description, d.language_id, d.filename, d.filetype, d.filesize, doc_states.name AS state_name, doc_groups.groupname AS group_name, sl.name AS language_name
FROM doc_data d
NATURAL JOIN doc_states
NATURAL JOIN doc_groups
JOIN supported_languages sl ON sl.language_id = d.language_id
JOIN users ON users.user_id = d.created_by;
|