/usr/share/gforge/db/20050227.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 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 | INSERT INTO plugins(plugin_name,plugin_desc) values ('cvstracker','CVS Tracker Integration');
CREATE SEQUENCE "plugin_cvstracker_artifact_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
CREATE TABLE plugin_cvstracker_data_artifact (
"id" integer DEFAULT nextval ('plugin_cvstracker_artifact_seq'::text) NOT NULL,
"kind" integer DEFAULT '0' NOT NULL,
"group_artifact_id" integer ,
"project_task_id" integer ,
Constraint "plugin_cvstracker_artifact_pkey" Primary Key ("id")
);
CREATE SEQUENCE "plugin_cvstracker_master_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
CREATE TABLE plugin_cvstracker_data_master (
"id" integer DEFAULT nextval ('plugin_cvstracker_master_seq'::text) NOT NULL,
"holder_id" integer NOT NULL,
"cvs_date" date NOT NULL,
"log_text" text DEFAULT '',
"file" text DEFAULT '' NOT NULL,
"prev_version" text DEFAULT '',
"actual_version" text DEFAULT '',
"author" text DEFAULT '' NOT NULL,
Constraint "plugin_cvstracker_master_pkey" Primary Key ("id"),
FOREIGN KEY (holder_id) REFERENCES plugin_cvstracker_data_artifact ("id"),
FOREIGN KEY (author) REFERENCES users (user_name)
);
CREATE INDEX plugin_cvstracker_group_artifact_id ON plugin_cvstracker_data_artifact USING btree (group_artifact_id);
|