-- pj_app_info definition

-- Drop table

-- DROP TABLE pj_app_info;

CREATE TABLE pj_app_info (
 id int8 NOT NULL,
 app_name varchar(255) NULL,
 current_server varchar(255) NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 "password" varchar(255) NULL,
 CONSTRAINT pj_app_info_pkey PRIMARY KEY (id),
 CONSTRAINT uidx01_app_info UNIQUE (app_name)
);

INSERT INTO pj_app_info VALUES(1, 'ruoyi-worker', '127.0.0.1:10010', '2023-06-13 16:32:59.263', '2023-07-04 17:25:49.798', '123456');



-- pj_container_info definition

-- Drop table

-- DROP TABLE pj_container_info;

CREATE TABLE pj_container_info (
 id int8 NOT NULL,
 app_id int8 NULL,
 container_name varchar(255) NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 last_deploy_time timestamp NULL,
 source_info varchar(255) NULL,
 source_type int4 NULL,
 status int4 NULL,
 "version" varchar(255) NULL,
 CONSTRAINT pj_container_info_pkey PRIMARY KEY (id)
);
CREATE INDEX idx01_container_info ON pj_container_info USING btree (app_id);


-- pj_instance_info definition

-- Drop table

-- DROP TABLE pj_instance_info;

CREATE TABLE pj_instance_info (
 id int8 NOT NULL,
 actual_trigger_time int8 NULL,
 app_id int8 NULL,
 expected_trigger_time int8 NULL,
 finished_time int8 NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 instance_id int8 NULL,
 instance_params oid NULL,
 job_id int8 NULL,
 job_params oid NULL,
 last_report_time int8 NULL,
 "result" oid NULL,
 running_times int8 NULL,
 status int4 NULL,
 task_tracker_address varchar(255) NULL,
 "type" int4 NULL,
 wf_instance_id int8 NULL,
 CONSTRAINT pj_instance_info_pkey PRIMARY KEY (id)
);
CREATE INDEX idx01_instance_info ON pj_instance_info USING btree (job_id, status);
CREATE INDEX idx02_instance_info ON pj_instance_info USING btree (app_id, status);
CREATE INDEX idx03_instance_info ON pj_instance_info USING btree (instance_id, status);


-- pj_job_info definition

-- Drop table

-- DROP TABLE pj_job_info;

CREATE TABLE pj_job_info (
 id int8 NOT NULL,
 alarm_config varchar(255) NULL,
 app_id int8 NULL,
 concurrency int4 NULL,
 designated_workers varchar(255) NULL,
 dispatch_strategy int4 NULL,
 execute_type int4 NULL,
 extra varchar(255) NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 instance_retry_num int4 NULL,
 instance_time_limit int8 NULL,
 job_description varchar(255) NULL,
 job_name varchar(255) NULL,
 job_params oid NULL,
 lifecycle varchar(255) NULL,
 log_config varchar(255) NULL,
 max_instance_num int4 NULL,
 max_worker_count int4 NULL,
 min_cpu_cores float8 NOT NULL,
 min_disk_space float8 NOT NULL,
 min_memory_space float8 NOT NULL,
 next_trigger_time int8 NULL,
 notify_user_ids varchar(255) NULL,
 processor_info varchar(255) NULL,
 processor_type int4 NULL,
 status int4 NULL,
 tag varchar(255) NULL,
 task_retry_num int4 NULL,
 time_expression varchar(255) NULL,
 time_expression_type int4 NULL,
 CONSTRAINT pj_job_info_pkey PRIMARY KEY (id)
);
CREATE INDEX idx01_job_info ON pj_job_info USING btree (app_id, status, time_expression_type, next_trigger_time);


INSERT INTO pj_job_info VALUES(1, '{\"alertThreshold\":0,\"silenceWindowLen\":0,\"statisticWindowLen\":0}', 1, 5, '', 2, 1, NULL, '2023-06-02 15:01:27.717', '2023-07-04 17:22:12.374', 1, 0, '', '单机处理器执行测试', NULL, '{}', '{\"type\":1}', 0, 0, 0.0, 0.0, 0.0, NULL, NULL, 'org.dromara.job.processors.StandaloneProcessorDemo', 1, 2, NULL, 1, '30000', 3);
INSERT INTO pj_job_info VALUES(2, '{\"alertThreshold\":0,\"silenceWindowLen\":0,\"statisticWindowLen\":0}', 1, 5, '', 1, 2, NULL, '2023-06-02 15:04:45.342', '2023-07-04 17:22:12.816', 0, 0, NULL, '广播处理器测试', NULL, '{}', '{\"type\":1}', 0, 0, 0.0, 0.0, 0.0, NULL, NULL, 'org.dromara.job.processors.BroadcastProcessorDemo', 1, 2, NULL, 1, '30000', 3);
INSERT INTO pj_job_info VALUES(3, '{\"alertThreshold\":0,\"silenceWindowLen\":0,\"statisticWindowLen\":0}', 1, 5, '', 1, 4, NULL, '2023-06-02 15:13:23.519', '2023-06-02 16:03:22.421', 0, 0, NULL, 'Map处理器测试', NULL, '{}', '{\"type\":1}', 0, 0, 0.0, 0.0, 0.0, NULL, NULL, 'org.dromara.job.processors.MapProcessorDemo', 1, 2, NULL, 1, '1000', 3);
INSERT INTO pj_job_info VALUES(4, '{\"alertThreshold\":0,\"silenceWindowLen\":0,\"statisticWindowLen\":0}', 1, 5, '', 1, 3, NULL, '2023-06-02 15:45:25.896', '2023-06-02 16:03:23.125', 0, 0, NULL, 'MapReduce处理器测试', NULL, '{}', '{\"type\":1}', 0, 0, 0.0, 0.0, 0.0, NULL, NULL, 'org.dromara.job.processors.MapReduceProcessorDemo', 1, 2, NULL, 1, '1000', 3);


-- pj_oms_lock definition

-- Drop table

-- DROP TABLE pj_oms_lock;

CREATE TABLE pj_oms_lock (
 id int8 NOT NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 lock_name varchar(255) NULL,
 max_lock_time int8 NULL,
 ownerip varchar(255) NULL,
 CONSTRAINT pj_oms_lock_pkey PRIMARY KEY (id),
 CONSTRAINT uidx01_oms_lock UNIQUE (lock_name)
);


-- pj_server_info definition

-- Drop table

-- DROP TABLE pj_server_info;

CREATE TABLE pj_server_info (
 id int8 NOT NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 ip varchar(255) NULL,
 CONSTRAINT pj_server_info_pkey PRIMARY KEY (id),
 CONSTRAINT uidx01_server_info UNIQUE (ip)
);
CREATE INDEX idx01_server_info ON pj_server_info USING btree (gmt_modified);


-- pj_user_info definition

-- Drop table

-- DROP TABLE pj_user_info;

CREATE TABLE pj_user_info (
 id int8 NOT NULL,
 email varchar(255) NULL,
 extra varchar(255) NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 "password" varchar(255) NULL,
 phone varchar(255) NULL,
 username varchar(255) NULL,
 web_hook varchar(255) NULL,
 CONSTRAINT pj_user_info_pkey PRIMARY KEY (id)
);
CREATE INDEX uidx01_user_info ON pj_user_info USING btree (username);
CREATE INDEX uidx02_user_info ON pj_user_info USING btree (email);


-- pj_workflow_info definition

-- Drop table

-- DROP TABLE pj_workflow_info;

CREATE TABLE pj_workflow_info (
 id int8 NOT NULL,
 app_id int8 NULL,
 extra varchar(255) NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 lifecycle varchar(255) NULL,
 max_wf_instance_num int4 NULL,
 next_trigger_time int8 NULL,
 notify_user_ids varchar(255) NULL,
 pedag oid NULL,
 status int4 NULL,
 time_expression varchar(255) NULL,
 time_expression_type int4 NULL,
 wf_description varchar(255) NULL,
 wf_name varchar(255) NULL,
 CONSTRAINT pj_workflow_info_pkey PRIMARY KEY (id)
);
CREATE INDEX idx01_workflow_info ON pj_workflow_info USING btree (app_id, status, time_expression_type, next_trigger_time);


-- pj_workflow_instance_info definition

-- Drop table

-- DROP TABLE pj_workflow_instance_info;

CREATE TABLE pj_workflow_instance_info (
 id int8 NOT NULL,
 actual_trigger_time int8 NULL,
 app_id int8 NULL,
 dag oid NULL,
 expected_trigger_time int8 NULL,
 finished_time int8 NULL,
 gmt_create timestamp NULL,
 gmt_modified timestamp NULL,
 parent_wf_instance_id int8 NULL,
 "result" oid NULL,
 status int4 NULL,
 wf_context oid NULL,
 wf_init_params oid NULL,
 wf_instance_id int8 NULL,
 workflow_id int8 NULL,
 CONSTRAINT pj_workflow_instance_info_pkey PRIMARY KEY (id),
 CONSTRAINT uidx01_wf_instance UNIQUE (wf_instance_id)
);
CREATE INDEX idx01_wf_instance ON pj_workflow_instance_info USING btree (workflow_id, status, app_id, expected_trigger_time);


-- pj_workflow_node_info definition

-- Drop table

-- DROP TABLE pj_workflow_node_info;

CREATE TABLE pj_workflow_node_info (
 id int8 NOT NULL,
 app_id int8 NOT NULL,
 "enable" bool NOT NULL,
 extra oid NULL,
 gmt_create timestamp NOT NULL,
 gmt_modified timestamp NOT NULL,
 job_id int8 NULL,
 node_name varchar(255) NULL,
 node_params oid NULL,
 skip_when_failed bool NOT NULL,
 "type" int4 NULL,
 workflow_id int8 NULL,
 CONSTRAINT pj_workflow_node_info_pkey PRIMARY KEY (id)
);
CREATE INDEX idx01_workflow_node_info ON pj_workflow_node_info USING btree (workflow_id, gmt_create);