1 CREATE SEQUENCE "plugin_cvstracker_artifact_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
3 CREATE TABLE plugin_cvstracker_data_artifact (
4 "id" integer DEFAULT nextval ('plugin_cvstracker_artifact_seq'::text) NOT NULL,
5 "kind" integer DEFAULT '0' NOT NULL,
6 "group_artifact_id" integer ,
7 "project_task_id" integer ,
8 Constraint "plugin_cvstracker_artifact_pkey" Primary Key ("id")
13 CREATE SEQUENCE "plugin_cvstracker_master_seq" start 1 increment 1 maxvalue 2147483647 minvalue 1 cache 1;
15 CREATE TABLE plugin_cvstracker_data_master (
16 "id" integer DEFAULT nextval ('plugin_cvstracker_master_seq'::text) NOT NULL,
17 "holder_id" integer NOT NULL,
18 "cvs_date" date NOT NULL,
19 "log_text" text DEFAULT '',
20 "file" text DEFAULT '' NOT NULL,
21 "prev_version" text DEFAULT '',
22 "actual_version" text DEFAULT '',
23 "author" text DEFAULT '' NOT NULL,
24 Constraint "plugin_cvstracker_master_pkey" Primary Key ("id"),
25 FOREIGN KEY (holder_id) REFERENCES plugin_cvstracker_data_artifact ("id"),
26 FOREIGN KEY (author) REFERENCES users (user_name)
29 CREATE INDEX plugin_cvstracker_group_artifact_id ON plugin_cvstracker_data_artifact USING btree (group_artifact_id);