lbqms.git - Gitblit

			@@ -2,7 +2,7 @@
			SnailJob Database Transfer Tool
			Source Server Type : MySQL
			Target Server Type : Oracle
			Date: 2024-07-06 12:49:36
			Date: 2024-12-27 22:22:15
			*/


			@@ -82,7 +82,7 @@
			id number GENERATED ALWAYS AS IDENTITY,
			namespace_id varchar2(64) DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' NULL,
			group_name varchar2(64) NULL,
			business_id varchar2(64) NULL,
			notify_name varchar2(64) DEFAULT '' NULL,
			system_task_type smallint DEFAULT 3 NOT NULL,
			notify_status smallint DEFAULT 0 NOT NULL,
			recipient_ids varchar2(128) NULL,
			@@ -98,12 +98,12 @@
			ALTER TABLE sj_notify_config
			ADD CONSTRAINT pk_sj_notify_config PRIMARY KEY (id);

			CREATE INDEX idx_sj_notify_config_01 ON sj_notify_config (namespace_id, group_name, business_id);
			CREATE INDEX idx_sj_notify_config_01 ON sj_notify_config (namespace_id, group_name);

			COMMENT ON COLUMN sj_notify_config.id IS '主键';
			COMMENT ON COLUMN sj_notify_config.namespace_id IS '命名空间id';
			COMMENT ON COLUMN sj_notify_config.group_name IS '组名称';
			COMMENT ON COLUMN sj_notify_config.business_id IS '业务id ( job_id或workflow_id或scene_name ) ';
			COMMENT ON COLUMN sj_notify_config.notify_name IS '通知名称';
			COMMENT ON COLUMN sj_notify_config.system_task_type IS '任务类型 1. 重试任务 2. 重试回调 3、JOB任务 4、WORKFLOW任务';
			COMMENT ON COLUMN sj_notify_config.notify_status IS '通知状态 0、未启用 1、启用';
			COMMENT ON COLUMN sj_notify_config.recipient_ids IS '接收人id列表';
			@@ -321,6 +321,7 @@
			max_retry_count number DEFAULT 5 NOT NULL,
			back_off smallint DEFAULT 1 NOT NULL,
			trigger_interval varchar2(16) DEFAULT '' NULL,
			notify_ids varchar2(128) DEFAULT '' NULL,
			deadline_request number DEFAULT 60000 NOT NULL,
			executor_timeout number DEFAULT 5 NOT NULL,
			route_key smallint DEFAULT 4 NOT NULL,
			@@ -342,6 +343,7 @@
			COMMENT ON COLUMN sj_retry_scene_config.max_retry_count IS '最大重试次数';
			COMMENT ON COLUMN sj_retry_scene_config.back_off IS '1、默认等级 2、固定间隔时间 3、CRON 表达式';
			COMMENT ON COLUMN sj_retry_scene_config.trigger_interval IS '间隔时长';
			COMMENT ON COLUMN sj_retry_scene_config.notify_ids IS '通知告警场景配置id列表';
			COMMENT ON COLUMN sj_retry_scene_config.deadline_request IS 'Deadline Request 调用链超时单位毫秒';
			COMMENT ON COLUMN sj_retry_scene_config.executor_timeout IS '任务执行超时时间，单位秒';
			COMMENT ON COLUMN sj_retry_scene_config.route_key IS '路由策略';
			@@ -506,6 +508,8 @@
			retry_interval number DEFAULT 0 NOT NULL,
			bucket_index number DEFAULT 0 NOT NULL,
			resident smallint DEFAULT 0 NOT NULL,
			notify_ids varchar2(128) DEFAULT '' NULL,
			owner_id number NULL,
			description varchar2(256) DEFAULT '' NULL,
			ext_attrs varchar2(256) DEFAULT '' NULL,
			deleted smallint DEFAULT 0 NOT NULL,
			@@ -541,6 +545,8 @@
			COMMENT ON COLUMN sj_job.retry_interval IS '重试间隔 ( s ) ';
			COMMENT ON COLUMN sj_job.bucket_index IS 'bucket';
			COMMENT ON COLUMN sj_job.resident IS '是否是常驻任务';
			COMMENT ON COLUMN sj_job.notify_ids IS '通知告警场景配置id列表';
			COMMENT ON COLUMN sj_job.owner_id IS '负责人id';
			COMMENT ON COLUMN sj_job.description IS '描述';
			COMMENT ON COLUMN sj_job.ext_attrs IS '扩展字段';
			COMMENT ON COLUMN sj_job.deleted IS '逻辑删除 1、删除';
			@@ -548,7 +554,7 @@
			COMMENT ON COLUMN sj_job.update_dt IS '修改时间';
			COMMENT ON TABLE sj_job IS '任务信息';

			INSERT INTO sj_job(namespace_id, group_name, job_name, args_str, args_type, next_trigger_at, job_status, task_type, route_key, executor_type, executor_info, trigger_type, trigger_interval, block_strategy,executor_timeout, max_retry_times, parallel_num, retry_interval, bucket_index, resident, description, ext_attrs, deleted, create_dt, update_dt) VALUES ('dev', 'ruoyi_group', 'demo-job', NULL, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', '', 0, sysdate, sysdate);
			INSERT INTO sj_job(namespace_id, group_name, job_name, args_str, args_type, next_trigger_at, job_status, task_type, route_key, executor_type, executor_info, trigger_type, trigger_interval, block_strategy,executor_timeout, max_retry_times, parallel_num, retry_interval, bucket_index, resident, notify_ids, owner_id, description, ext_attrs, deleted, create_dt, update_dt) VALUES ('dev', 'ruoyi_group', 'demo-job', NULL, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', 1,'', '', 0, sysdate, sysdate);

			-- sj_job_log_message
			CREATE TABLE sj_job_log_message
			@@ -781,6 +787,7 @@
			description varchar2(256) DEFAULT '' NULL,
			flow_info clob DEFAULT NULL NULL,
			wf_context clob DEFAULT NULL NULL,
			notify_ids varchar2(128) DEFAULT '' NULL,
			bucket_index number DEFAULT 0 NOT NULL,
			version number NOT NULL,
			ext_attrs varchar2(256) DEFAULT '' NULL,
			@@ -808,6 +815,7 @@
			COMMENT ON COLUMN sj_workflow.description IS '描述';
			COMMENT ON COLUMN sj_workflow.flow_info IS '流程信息';
			COMMENT ON COLUMN sj_workflow.wf_context IS '上下文';
			COMMENT ON COLUMN sj_workflow.notify_ids IS '通知告警场景配置id列表';
			COMMENT ON COLUMN sj_workflow.bucket_index IS 'bucket';
			COMMENT ON COLUMN sj_workflow.version IS '版本号';
			COMMENT ON COLUMN sj_workflow.ext_attrs IS '扩展字段';