gforge-db-postgresql 5.1.1-2 / usr / share / gforge / db / 20050227.sql

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);