/usr/share/fusionforge/plugins/scmhook/db/20130702-create_scmhook_git_committracker.sql is in fusionforge-plugin-scmhook 6.0.3+20151023-1ubuntu1.
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 | CREATE TABLE plugin_scmhook_scmgit_committracker_data_artifact (
id serial PRIMARY KEY,
kind integer DEFAULT '0' NOT NULL,
group_artifact_id integer,
project_task_id integer
);
CREATE TABLE plugin_scmhook_scmgit_committracker_data_master (
id serial PRIMARY KEY,
holder_id integer NOT NULL,
git_date integer NOT NULL,
log_text text DEFAULT '',
file text DEFAULT '' NOT NULL,
prev_version text DEFAULT '',
actual_version text DEFAULT '',
author text DEFAULT '' NOT NULL
);
|