lbqms.git - Gitblit

ÎÄ¼þÃû´Ó script/sql/snail_job.sql ÐÞ¸Ä
			@@ -40,13 +40,14 @@
			DEFAULT CHARSET = utf8mb4 COMMENT ='ç»éç½®';

			INSERT INTO `sj_group_config` VALUES (1, 'dev', 'ruoyi_group', '', 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, 4, now(), now());
			INSERT INTO `sj_group_config` VALUES (2, 'prod', 'ruoyi_group', '', 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, 4, now(), now());

			CREATE TABLE `sj_notify_config`
			(
			`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ä¸»é®',
			`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT 'å½åç©ºé´id',
			`group_name` varchar(64) NOT NULL COMMENT 'ç»åç§°',
			`business_id` varchar(64) NOT NULL COMMENT 'ä¸å¡id (job_idæworkflow_idæscene_name)',
			`notify_name` varchar(64) NOT NULL DEFAULT '' COMMENT 'éç¥åç§°',
			`system_task_type` tinyint(4) NOT NULL DEFAULT 3 COMMENT 'ä»»å¡ç±»å 1. éè¯ä»»å¡ 2. éè¯åè° 3ãJOBä»»å¡ 4ãWORKFLOWä»»å¡',
			`notify_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'éç¥ç¶æ 0ãæªå¯ç¨ 1ãå¯ç¨',
			`recipient_ids` varchar(128) NOT NULL COMMENT 'æ¥æ¶äººidåè¡¨',
			@@ -58,7 +59,7 @@
			`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'åå»ºæ¶é´',
			`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'ä¿®æ¹æ¶é´',
			PRIMARY KEY (`id`),
			KEY `idx_namespace_id_group_name_scene_name` (`namespace_id`, `group_name`, `business_id`)
			KEY `idx_namespace_id_group_name_scene_name` (`namespace_id`, `group_name`)
			) ENGINE = InnoDB
			AUTO_INCREMENT = 0
			DEFAULT CHARSET = utf8mb4 COMMENT ='éç¥éç½®';
			@@ -187,6 +188,7 @@
			`max_retry_count` int(11) NOT NULL DEFAULT 5 COMMENT 'æå¤§éè¯æ¬¡æ°',
			`back_off` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1ãé»è®¤ççº§ 2ãåºå®é´éæ¶é´ 3ãCRON è¡¨è¾¾å¼',
			`trigger_interval` varchar(16) NOT NULL DEFAULT '' COMMENT 'é´éæ¶é¿',
			`notify_ids` varchar(128) NOT NULL DEFAULT '' COMMENT 'éç¥åè¦åºæ¯éç½®idåè¡¨',
			`deadline_request` bigint(20) unsigned NOT NULL DEFAULT 60000 COMMENT 'Deadline Request è°ç¨é¾è¶æ¶ åä½æ¯«ç§',
			`executor_timeout` int(11) unsigned NOT NULL DEFAULT 5 COMMENT 'ä»»å¡æ§è¡è¶æ¶æ¶é´ï¼åä½ç§',
			`route_key` tinyint(4) NOT NULL DEFAULT 4 COMMENT 'è·¯ç±çç¥',
			@@ -299,6 +301,8 @@
			`retry_interval` int(11) NOT NULL DEFAULT 0 COMMENT 'éè¯é´é(s)',
			`bucket_index` int(11) NOT NULL DEFAULT 0 COMMENT 'bucket',
			`resident` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'æ¯å¦æ¯å¸¸é©»ä»»å¡',
			`notify_ids` varchar(128) NOT NULL DEFAULT '' COMMENT 'éç¥åè¦åºæ¯éç½®idåè¡¨',
			`owner_id` bigint(20) NULL COMMENT 'è´è´£äººid',
			`description` varchar(256) NOT NULL DEFAULT '' COMMENT 'æè¿°',
			`ext_attrs` varchar(256) NULL DEFAULT '' COMMENT 'æ©å±åæ®µ',
			`deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'é»è¾å é¤ 1ãå é¤',
			@@ -312,7 +316,7 @@
			AUTO_INCREMENT = 0
			DEFAULT CHARSET = utf8mb4 COMMENT ='ä»»å¡ä¿¡æ¯';

			INSERT INTO `sj_job` VALUES (1, 'dev', 'ruoyi_group', 'demo-job', null, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', '', 0 , now(), now());
			INSERT INTO `sj_job` VALUES (1, 'dev', 'ruoyi_group', 'demo-job', null, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', 1, '', '', 0 , now(), now());

			CREATE TABLE `sj_job_log_message`
			(
			@@ -450,6 +454,7 @@
			`description` varchar(256) NOT NULL DEFAULT '' COMMENT 'æè¿°',
			`flow_info` text DEFAULT NULL COMMENT 'æµç¨ä¿¡æ¯',
			`wf_context` text DEFAULT NULL COMMENT 'ä¸ä¸æ',
			`notify_ids` varchar(128) NOT NULL DEFAULT '' COMMENT 'éç¥åè¦åºæ¯éç½®idåè¡¨',
			`bucket_index` int(11) NOT NULL DEFAULT 0 COMMENT 'bucket',
			`version` int(11) NOT NULL COMMENT 'çæ¬å·',
			`ext_attrs` varchar(256) NULL DEFAULT '' COMMENT 'æ©å±åæ®µ',