/usr/share/fusionforge/plugins/scmhook/db/scmhook-init.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 18 19 20 21 22 23 24 | CREATE TABLE plugin_scmhook (
id serial PRIMARY KEY,
id_group integer NOT NULL,
need_update integer DEFAULT 0,
hooks text
);
CREATE TABLE plugin_scmhook_scmsvn_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_scmsvn_committracker_data_master (
id serial PRIMARY KEY,
holder_id integer NOT NULL,
svn_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
);
|