/usr/share/gforge/db/view_patch.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 16 17 18 | DROP VIEW patch;
CREATE VIEW patch AS
SELECT a.artifact_id AS patch_id,
g.group_id,
a.status_id,
a.priority,
a.category_id,
a.submitted_by,
a.assigned_to,
a.open_date,
a.summary,a.details,
a.close_date,
a.group_artifact_id AS patch_group_id,
a.resolution_id AS resolution
FROM artifact a, groups g, artifact_group_list agl
WHERE a.group_artifact_id=agl.group_artifact_id
AND agl.group_id=g.group_id
AND agl.name='Patches';
|