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