/usr/share/gforge/db/20140128-tracker-vote-table.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 | -- Add a table to count tracker votes.
CREATE TABLE artifact_votes (
artifact_id integer NOT NULL,
user_id integer NOT NULL,
CONSTRAINT artifact_votes_fk_aid
FOREIGN KEY (artifact_id) REFERENCES artifact (artifact_id),
CONSTRAINT artifact_votes_fk_uid
FOREIGN KEY (user_id) REFERENCES users (user_id),
CONSTRAINT artifact_votes_pk
PRIMARY KEY (artifact_id, user_id)
);
|