From ef57259386e58c3c12e44760e8e41aade68d219e Mon Sep 17 00:00:00 2001
From: dhb52 <dhb52@126.com>
Date: 星期五, 17 五月 2024 09:54:18 +0800
Subject: [PATCH] !535 feat: EasyRetry-v3.2.0 => SnailJob-v1.0.0beta1 * feat: EasyRetry-v3.2.0 => SnailJob-v1.0.0beta1
---
script/sql/snail_job.sql | 288 +++++++++++++++++++++++++++------------------------------
1 files changed, 135 insertions(+), 153 deletions(-)
diff --git a/script/sql/easy_retry.sql b/script/sql/snail_job.sql
similarity index 70%
rename from script/sql/easy_retry.sql
rename to script/sql/snail_job.sql
index 6008a7c..ce93e11 100644
--- a/script/sql/easy_retry.sql
+++ b/script/sql/snail_job.sql
@@ -1,73 +1,85 @@
SET NAMES utf8mb4;
-CREATE TABLE `er_namespace`
+CREATE TABLE `sj_namespace`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`name` varchar(64) NOT NULL COMMENT '鍚嶇О',
`unique_id` varchar(64) NOT NULL COMMENT '鍞竴id',
`description` varchar(256) NOT NULL DEFAULT '' COMMENT '鎻忚堪',
+ `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
PRIMARY KEY (`id`),
KEY `idx_name` (`name`),
UNIQUE KEY `uk_unique_id` (`unique_id`)
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='鍛藉悕绌洪棿';
-INSERT INTO `er_namespace` VALUES (1, 'Development', 'dev', '', now(), now(), 0);
-INSERT INTO `er_namespace` VALUES (2, 'Production', 'prod', '', now(), now(), 0);
+INSERT INTO `sj_namespace` VALUES (1, 'Development', 'dev', '', 0, now(), now());
+INSERT INTO `sj_namespace` VALUES (2, 'Production', 'prod', '', 0, now(), now());
-
-CREATE TABLE `er_group_config`
+CREATE TABLE `sj_group_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 DEFAULT '' COMMENT '缁勫悕绉�',
`description` varchar(256) NOT NULL DEFAULT '' COMMENT '缁勬弿杩�',
- `token` varchar(64) NOT NULL DEFAULT 'ER_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT' COMMENT 'token',
- `group_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '缁勭姸鎬� 0銆佹湭鍚敤 1銆佸惎鐢�',
+ `token` varchar(64) NOT NULL DEFAULT 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT' COMMENT 'token',
+ `group_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '缁勭姸鎬� 0銆佹湭鍚敤 1銆佸惎鐢�',
`version` int(11) NOT NULL COMMENT '鐗堟湰鍙�',
`group_partition` int(11) NOT NULL COMMENT '鍒嗗尯',
- `id_generator_mode` tinyint(4) NOT NULL DEFAULT '1' COMMENT '鍞竴id鐢熸垚妯″紡 榛樿鍙锋妯″紡',
- `init_scene` tinyint(4) NOT NULL DEFAULT '0' COMMENT '鏄惁鍒濆鍖栧満鏅� 0:鍚� 1:鏄�',
- `bucket_index` int(11) NOT NULL DEFAULT '0' COMMENT 'bucket',
+ `id_generator_mode` tinyint(4) NOT NULL DEFAULT 1 COMMENT '鍞竴id鐢熸垚妯″紡 榛樿鍙锋妯″紡',
+ `init_scene` tinyint(4) NOT NULL DEFAULT 0 COMMENT '鏄惁鍒濆鍖栧満鏅� 0:鍚� 1:鏄�',
+ `bucket_index` int(11) NOT NULL DEFAULT 0 COMMENT 'bucket',
`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`),
UNIQUE KEY `uk_namespace_id_group_name` (`namespace_id`, `group_name`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='缁勯厤缃�'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='缁勯厤缃�';
-INSERT INTO `er_group_config` VALUES (1, 'dev', 'ruoyi_group', '', 'ER_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, 4, now(), now());
+INSERT INTO `sj_group_config` VALUES (1, 'dev', 'ruoyi_group', '', 'SJ_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', 1, 1, 0, 1, 1, 4, now(), now());
-
-CREATE TABLE `er_notify_config`
+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 '缁勫悕绉�',
- `scene_name` varchar(64) NOT NULL COMMENT '鍦烘櫙鍚嶇О',
- `notify_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫氱煡鐘舵�� 0銆佹湭鍚敤 1銆佸惎鐢�',
- `notify_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫氱煡绫诲瀷 1銆侀拤閽� 2銆侀偖浠� 3銆佷紒涓氬井淇�',
- `notify_attribute` varchar(512) NOT NULL COMMENT '閰嶇疆灞炴��',
- `notify_threshold` int(11) NOT NULL DEFAULT '0' COMMENT '閫氱煡闃堝��',
- `notify_scene` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫氱煡鍦烘櫙',
- `rate_limiter_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '闄愭祦鐘舵�� 0銆佹湭鍚敤 1銆佸惎鐢�',
- `rate_limiter_threshold` int(11) NOT NULL DEFAULT '0' COMMENT '姣忕闄愭祦闃堝��',
+ `business_id` varchar(64) NOT NULL COMMENT '涓氬姟id (job_id鎴杦orkflow_id鎴杝cene_name)',
+ `system_task_type` tinyint(4) NOT NULL DEFAULT 3 COMMENT '浠诲姟绫诲瀷 1. 閲嶈瘯浠诲姟 2. 閲嶈瘯鍥炶皟 3銆丣OB浠诲姟 4銆乄ORKFLOW浠诲姟',
+ `notify_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫氱煡鐘舵�� 0銆佹湭鍚敤 1銆佸惎鐢�',
+ `recipient_ids` varchar(128) NOT NULL COMMENT '鎺ユ敹浜篿d鍒楄〃',
+ `notify_threshold` int(11) NOT NULL DEFAULT 0 COMMENT '閫氱煡闃堝��',
+ `notify_scene` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫氱煡鍦烘櫙',
+ `rate_limiter_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '闄愭祦鐘舵�� 0銆佹湭鍚敤 1銆佸惎鐢�',
+ `rate_limiter_threshold` int(11) NOT NULL DEFAULT 0 COMMENT '姣忕闄愭祦闃堝��',
`description` varchar(256) NOT NULL DEFAULT '' COMMENT '鎻忚堪',
`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`, `scene_name`)
+ KEY `idx_namespace_id_group_name_scene_name` (`namespace_id`, `group_name`, `business_id`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='閫氱煡閰嶇疆'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='閫氱煡閰嶇疆';
-CREATE TABLE `er_retry_dead_letter_0`
+CREATE TABLE `sj_notify_recipient`
+(
+ `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
+ `namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
+ `recipient_name` varchar(64) NOT NULL COMMENT '鎺ユ敹浜哄悕绉�',
+ `notify_type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫氱煡绫诲瀷 1銆侀拤閽� 2銆侀偖浠� 3銆佷紒涓氬井淇� 4 椋炰功',
+ `notify_attribute` varchar(512) NOT NULL COMMENT '閰嶇疆灞炴��',
+ `description` varchar(256) NOT NULL DEFAULT '' COMMENT '鎻忚堪',
+ `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` (`namespace_id`)
+) ENGINE = InnoDB
+ AUTO_INCREMENT = 0
+ DEFAULT CHARSET = utf8mb4 COMMENT ='鍛婅閫氱煡鎺ユ敹浜�';
+
+CREATE TABLE `sj_retry_dead_letter_0`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
@@ -79,7 +91,7 @@
`executor_name` varchar(512) NOT NULL DEFAULT '' COMMENT '鎵ц鍣ㄥ悕绉�',
`args_str` text NOT NULL COMMENT '鎵ц鏂规硶鍙傛暟',
`ext_attrs` text NOT NULL COMMENT '鎵╁睍瀛楁',
- `task_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '浠诲姟绫诲瀷 1銆侀噸璇曟暟鎹� 2銆佸洖璋冩暟鎹�',
+ `task_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '浠诲姟绫诲瀷 1銆侀噸璇曟暟鎹� 2銆佸洖璋冩暟鎹�',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
PRIMARY KEY (`id`),
KEY `idx_namespace_id_group_name_scene_name` (`namespace_id`, `group_name`, `scene_name`),
@@ -89,10 +101,9 @@
UNIQUE KEY `uk_namespace_id_group_name_unique_id` (`namespace_id`, `group_name`, `unique_id`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='姝讳俊闃熷垪琛�'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='姝讳俊闃熷垪琛�';
-CREATE TABLE `er_retry_task_0`
+CREATE TABLE `sj_retry_task_0`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
@@ -105,9 +116,9 @@
`args_str` text NOT NULL COMMENT '鎵ц鏂规硶鍙傛暟',
`ext_attrs` text NOT NULL COMMENT '鎵╁睍瀛楁',
`next_trigger_at` datetime NOT NULL COMMENT '涓嬫瑙﹀彂鏃堕棿',
- `retry_count` int(11) NOT NULL DEFAULT '0' COMMENT '閲嶈瘯娆℃暟',
- `retry_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閲嶈瘯鐘舵�� 0銆侀噸璇曚腑 1銆佹垚鍔� 2銆佹渶澶ч噸璇曟鏁�',
- `task_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '浠诲姟绫诲瀷 1銆侀噸璇曟暟鎹� 2銆佸洖璋冩暟鎹�',
+ `retry_count` int(11) NOT NULL DEFAULT 0 COMMENT '閲嶈瘯娆℃暟',
+ `retry_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閲嶈瘯鐘舵�� 0銆侀噸璇曚腑 1銆佹垚鍔� 2銆佹渶澶ч噸璇曟鏁�',
+ `task_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '浠诲姟绫诲瀷 1銆侀噸璇曟暟鎹� 2銆佸洖璋冩暟鎹�',
`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`),
@@ -120,10 +131,9 @@
UNIQUE KEY `uk_name_unique_id` (`namespace_id`, `group_name`, `unique_id`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟琛�'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟琛�';
-CREATE TABLE `er_retry_task_log`
+CREATE TABLE `sj_retry_task_log`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
@@ -135,8 +145,8 @@
`executor_name` varchar(512) NOT NULL DEFAULT '' COMMENT '鎵ц鍣ㄥ悕绉�',
`args_str` text NOT NULL COMMENT '鎵ц鏂规硶鍙傛暟',
`ext_attrs` text NOT NULL COMMENT '鎵╁睍瀛楁',
- `retry_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閲嶈瘯鐘舵�� 0銆侀噸璇曚腑 1銆佹垚鍔� 2銆佹渶澶ф鏁�',
- `task_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '浠诲姟绫诲瀷 1銆侀噸璇曟暟鎹� 2銆佸洖璋冩暟鎹�',
+ `retry_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閲嶈瘯鐘舵�� 0銆侀噸璇曚腑 1銆佹垚鍔� 2銆佹渶澶ф鏁�',
+ `task_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '浠诲姟绫诲瀷 1銆侀噸璇曟暟鎹� 2銆佸洖璋冩暟鎹�',
`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`),
@@ -148,40 +158,38 @@
KEY `idx_create_dt` (`create_dt`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟鏃ュ織鍩虹淇℃伅琛�'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟鏃ュ織鍩虹淇℃伅琛�';
-CREATE TABLE `er_retry_task_log_message`
+CREATE TABLE `sj_retry_task_log_message`
(
`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 '缁勫悕绉�',
`unique_id` varchar(64) NOT NULL COMMENT '鍚岀粍涓媔d鍞竴',
- `create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`message` longtext NOT NULL COMMENT '寮傚父淇℃伅',
`log_num` int(11) NOT NULL DEFAULT 1 COMMENT '鏃ュ織鏁伴噺',
`real_time` bigint(13) NOT NULL DEFAULT 0 COMMENT '涓婃姤鏃堕棿',
+ `create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
PRIMARY KEY (`id`),
KEY `idx_namespace_id_group_name_scene_name` (`namespace_id`, `group_name`, `unique_id`),
KEY `idx_create_dt` (`create_dt`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟璋冨害鏃ュ織淇℃伅璁板綍琛�'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟璋冨害鏃ュ織淇℃伅璁板綍琛�';
-CREATE TABLE `er_scene_config`
+CREATE TABLE `sj_retry_scene_config`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
`scene_name` varchar(64) NOT NULL COMMENT '鍦烘櫙鍚嶇О',
`group_name` varchar(64) NOT NULL COMMENT '缁勫悕绉�',
- `scene_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '缁勭姸鎬� 0銆佹湭鍚敤 1銆佸惎鐢�',
- `max_retry_count` int(11) NOT NULL DEFAULT '5' COMMENT '鏈�澶ч噸璇曟鏁�',
- `back_off` tinyint(4) NOT NULL DEFAULT '1' COMMENT '1銆侀粯璁ょ瓑绾� 2銆佸浐瀹氶棿闅旀椂闂� 3銆丆RON 琛ㄨ揪寮�',
+ `scene_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '缁勭姸鎬� 0銆佹湭鍚敤 1銆佸惎鐢�',
+ `max_retry_count` int(11) NOT NULL DEFAULT 5 COMMENT '鏈�澶ч噸璇曟鏁�',
+ `back_off` tinyint(4) NOT NULL DEFAULT 1 COMMENT '1銆侀粯璁ょ瓑绾� 2銆佸浐瀹氶棿闅旀椂闂� 3銆丆RON 琛ㄨ揪寮�',
`trigger_interval` varchar(16) NOT NULL DEFAULT '' COMMENT '闂撮殧鏃堕暱',
- `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 '璺敱绛栫暐',
+ `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 '璺敱绛栫暐',
`description` varchar(256) NOT NULL DEFAULT '' COMMENT '鎻忚堪',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
@@ -189,21 +197,19 @@
UNIQUE KEY `uk_namespace_id_group_name_scene_name` (`namespace_id`, `group_name`, `scene_name`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='鍦烘櫙閰嶇疆'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='鍦烘櫙閰嶇疆';
-CREATE TABLE `er_server_node`
+CREATE TABLE `sj_server_node`
(
`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 '缁勫悕绉�',
`host_id` varchar(64) NOT NULL COMMENT '涓绘満id',
`host_ip` varchar(64) NOT NULL COMMENT '鏈哄櫒ip',
- `context_path` varchar(256) NOT NULL DEFAULT '/' COMMENT '瀹㈡埛绔笂涓嬫枃璺緞 server.servlet.context-path',
`host_port` int(16) NOT NULL COMMENT '鏈哄櫒绔彛',
`expire_at` datetime NOT NULL COMMENT '杩囨湡鏃堕棿',
`node_type` tinyint(4) NOT NULL COMMENT '鑺傜偣绫诲瀷 1銆佸鎴风 2銆佹槸鏈嶅姟绔�',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
`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`),
@@ -212,10 +218,9 @@
UNIQUE KEY `uk_host_id_host_ip` (`host_id`, `host_ip`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='鏈嶅姟鍣ㄨ妭鐐�'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='鏈嶅姟鍣ㄨ妭鐐�';
-CREATE TABLE `er_distributed_lock`
+CREATE TABLE `sj_distributed_lock`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`name` varchar(64) NOT NULL COMMENT '閿佸悕绉�',
@@ -228,15 +233,14 @@
UNIQUE KEY `uk_name` (`name`)
) ENGINE = InnoDB
AUTO_INCREMENT = 0
- DEFAULT CHARSET = utf8mb4 COMMENT ='閿佸畾琛�'
-;
+ DEFAULT CHARSET = utf8mb4 COMMENT ='閿佸畾琛�';
-CREATE TABLE `er_system_user`
+CREATE TABLE `sj_system_user`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`username` varchar(64) NOT NULL COMMENT '璐﹀彿',
`password` varchar(128) NOT NULL COMMENT '瀵嗙爜',
- `role` tinyint(4) NOT NULL DEFAULT '0' COMMENT '瑙掕壊锛�1-鏅�氱敤鎴枫��2-绠＄悊鍛�',
+ `role` tinyint(4) NOT NULL DEFAULT 0 COMMENT '瑙掕壊锛�1-鏅�氱敤鎴枫��2-绠＄悊鍛�',
`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`),
@@ -245,9 +249,9 @@
DEFAULT CHARSET = utf8mb4 COMMENT ='绯荤粺鐢ㄦ埛琛�';
-- pwd: admin
-INSERT INTO `er_system_user` VALUES (1, 'admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2, now(), now());
+INSERT INTO `sj_system_user` VALUES (1, 'admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2, now(), now());
-CREATE TABLE `er_system_user_permission`
+CREATE TABLE `sj_system_user_permission`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`group_name` varchar(64) NOT NULL COMMENT '缁勫悕绉�',
@@ -260,13 +264,13 @@
) ENGINE = InnoDB
DEFAULT CHARSET = utf8mb4 COMMENT ='绯荤粺鐢ㄦ埛鏉冮檺琛�';
-CREATE TABLE `er_sequence_alloc`
+CREATE TABLE `sj_sequence_alloc`
(
`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 DEFAULT '' COMMENT '缁勫悕绉�',
- `max_id` bigint(20) NOT NULL DEFAULT '1' COMMENT '鏈�澶d',
- `step` int(11) NOT NULL DEFAULT '100' COMMENT '姝ラ暱',
+ `max_id` bigint(20) NOT NULL DEFAULT 1 COMMENT '鏈�澶d',
+ `step` int(11) NOT NULL DEFAULT 100 COMMENT '姝ラ暱',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿',
PRIMARY KEY (`id`),
UNIQUE KEY `uk_namespace_id_group_name` (`namespace_id`, `group_name`)
@@ -274,34 +278,34 @@
DEFAULT CHARSET = utf8mb4 COMMENT ='鍙锋妯″紡搴忓彿ID鍒嗛厤琛�';
-- 鍒嗗竷寮忚皟搴DL
-CREATE TABLE `er_job`
+CREATE TABLE `sj_job`
(
`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 '缁勫悕绉�',
`job_name` varchar(64) NOT NULL COMMENT '鍚嶇О',
`args_str` text DEFAULT NULL COMMENT '鎵ц鏂规硶鍙傛暟',
- `args_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '鍙傛暟绫诲瀷 ',
+ `args_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '鍙傛暟绫诲瀷 ',
`next_trigger_at` bigint(13) NOT NULL COMMENT '涓嬫瑙﹀彂鏃堕棿',
- `job_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '浠诲姟鐘舵�� 0銆佸叧闂��1銆佸紑鍚�',
- `task_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '浠诲姟绫诲瀷 1銆侀泦缇� 2銆佸箍鎾� 3銆佸垏鐗�',
- `route_key` tinyint(4) NOT NULL DEFAULT '4' COMMENT '璺敱绛栫暐',
- `executor_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '鎵ц鍣ㄧ被鍨�',
+ `job_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '浠诲姟鐘舵�� 0銆佸叧闂��1銆佸紑鍚�',
+ `task_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '浠诲姟绫诲瀷 1銆侀泦缇� 2銆佸箍鎾� 3銆佸垏鐗�',
+ `route_key` tinyint(4) NOT NULL DEFAULT 4 COMMENT '璺敱绛栫暐',
+ `executor_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '鎵ц鍣ㄧ被鍨�',
`executor_info` varchar(255) DEFAULT NULL COMMENT '鎵ц鍣ㄥ悕绉�',
`trigger_type` tinyint(4) NOT NULL COMMENT '瑙﹀彂绫诲瀷 1.CRON 琛ㄨ揪寮� 2. 鍥哄畾鏃堕棿',
`trigger_interval` varchar(255) NOT NULL COMMENT '闂撮殧鏃堕暱',
- `block_strategy` tinyint(4) NOT NULL DEFAULT '1' COMMENT '闃诲绛栫暐 1銆佷涪寮� 2銆佽鐩� 3銆佸苟琛�',
- `executor_timeout` int(11) NOT NULL DEFAULT '0' COMMENT '浠诲姟鎵ц瓒呮椂鏃堕棿锛屽崟浣嶇',
- `max_retry_times` int(11) NOT NULL DEFAULT '0' COMMENT '鏈�澶ч噸璇曟鏁�',
- `parallel_num` int(11) NOT NULL DEFAULT '1' COMMENT '骞惰鏁�',
- `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 '鏄惁鏄父椹讳换鍔�',
+ `block_strategy` tinyint(4) NOT NULL DEFAULT 1 COMMENT '闃诲绛栫暐 1銆佷涪寮� 2銆佽鐩� 3銆佸苟琛�',
+ `executor_timeout` int(11) NOT NULL DEFAULT 0 COMMENT '浠诲姟鎵ц瓒呮椂鏃堕棿锛屽崟浣嶇',
+ `max_retry_times` int(11) NOT NULL DEFAULT 0 COMMENT '鏈�澶ч噸璇曟鏁�',
+ `parallel_num` int(11) NOT NULL DEFAULT 1 COMMENT '骞惰鏁�',
+ `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 '鏄惁鏄父椹讳换鍔�',
`description` varchar(256) NOT NULL DEFAULT '' COMMENT '鎻忚堪',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
+ `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
PRIMARY KEY (`id`),
KEY `idx_namespace_id_group_name` (`namespace_id`, `group_name`),
KEY `idx_job_status_bucket_index` (`job_status`, `bucket_index`),
@@ -310,9 +314,9 @@
AUTO_INCREMENT = 0
DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟淇℃伅';
-INSERT INTO `er_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, '', '', now(), now(), 0);
+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());
-CREATE TABLE `er_job_log_message`
+CREATE TABLE `sj_job_log_message`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
@@ -323,8 +327,8 @@
`message` longtext NOT NULL COMMENT '璋冨害淇℃伅',
`log_num` int(11) NOT NULL DEFAULT 1 COMMENT '鏃ュ織鏁伴噺',
`real_time` bigint(13) NOT NULL DEFAULT 0 COMMENT '涓婃姤鏃堕棿',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
PRIMARY KEY (`id`),
KEY `idx_task_batch_id_task_id` (`task_batch_id`, `task_id`),
KEY `idx_create_dt` (`create_dt`),
@@ -333,21 +337,21 @@
AUTO_INCREMENT = 0
DEFAULT CHARSET = utf8mb4 COMMENT ='璋冨害鏃ュ織';
-CREATE TABLE `er_job_task`
+CREATE TABLE `sj_job_task`
(
`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 '缁勫悕绉�',
`job_id` bigint(20) NOT NULL COMMENT '浠诲姟淇℃伅id',
`task_batch_id` bigint(20) NOT NULL COMMENT '璋冨害浠诲姟id',
- `parent_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '鐖舵墽琛屽櫒id',
- `task_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '鎵ц鐨勭姸鎬� 0銆佸け璐� 1銆佹垚鍔�',
- `retry_count` int(11) NOT NULL DEFAULT '0' COMMENT '閲嶈瘯娆℃暟',
+ `parent_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '鐖舵墽琛屽櫒id',
+ `task_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '鎵ц鐨勭姸鎬� 0銆佸け璐� 1銆佹垚鍔�',
+ `retry_count` int(11) NOT NULL DEFAULT 0 COMMENT '閲嶈瘯娆℃暟',
`client_info` varchar(128) DEFAULT NULL COMMENT '瀹㈡埛绔湴鍧� clientId#ip:port',
`result_message` text NOT NULL COMMENT '鎵ц缁撴灉',
`args_str` text DEFAULT NULL COMMENT '鎵ц鏂规硶鍙傛暟',
- `args_type` tinyint(4) NOT NULL DEFAULT '1' COMMENT '鍙傛暟绫诲瀷 ',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
+ `args_type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '鍙傛暟绫诲瀷 ',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
`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`),
@@ -358,24 +362,24 @@
AUTO_INCREMENT = 0
DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟瀹炰緥';
-CREATE TABLE `er_job_task_batch`
+CREATE TABLE `sj_job_task_batch`
(
`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 '缁勫悕绉�',
`job_id` bigint(20) NOT NULL COMMENT '浠诲姟id',
- `workflow_node_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '宸ヤ綔娴佽妭鐐筰d',
- `parent_workflow_node_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '宸ヤ綔娴佷换鍔＄埗鎵规id',
- `workflow_task_batch_id` bigint(20) NOT NULL DEFAULT '0' COMMENT '宸ヤ綔娴佷换鍔℃壒娆d',
- `task_batch_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '浠诲姟鎵规鐘舵�� 0銆佸け璐� 1銆佹垚鍔�',
- `operation_reason` tinyint(4) NOT NULL DEFAULT '0' COMMENT '鎿嶄綔鍘熷洜',
- `execution_at` bigint(13) NOT NULL DEFAULT '0' COMMENT '浠诲姟鎵ц鏃堕棿',
- `system_task_type` tinyint(4) NOT NULL DEFAULT '3' COMMENT '浠诲姟绫诲瀷 3銆丣OB浠诲姟 4銆乄ORKFLOW浠诲姟',
+ `workflow_node_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '宸ヤ綔娴佽妭鐐筰d',
+ `parent_workflow_node_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '宸ヤ綔娴佷换鍔＄埗鎵规id',
+ `workflow_task_batch_id` bigint(20) NOT NULL DEFAULT 0 COMMENT '宸ヤ綔娴佷换鍔℃壒娆d',
+ `task_batch_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '浠诲姟鎵规鐘舵�� 0銆佸け璐� 1銆佹垚鍔�',
+ `operation_reason` tinyint(4) NOT NULL DEFAULT 0 COMMENT '鎿嶄綔鍘熷洜',
+ `execution_at` bigint(13) NOT NULL DEFAULT 0 COMMENT '浠诲姟鎵ц鏃堕棿',
+ `system_task_type` tinyint(4) NOT NULL DEFAULT 3 COMMENT '浠诲姟绫诲瀷 3銆丣OB浠诲姟 4銆乄ORKFLOW浠诲姟',
`parent_id` varchar(64) NOT NULL DEFAULT '' COMMENT '鐖惰妭鐐�',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
+ `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
PRIMARY KEY (`id`),
KEY `idx_job_id_task_batch_status` (`job_id`, `task_batch_status`),
KEY `idx_create_dt` (`create_dt`),
@@ -385,42 +389,20 @@
AUTO_INCREMENT = 0
DEFAULT CHARSET = utf8mb4 COMMENT ='浠诲姟鎵规';
-CREATE TABLE `er_job_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 '缁勫悕绉�',
- `job_id` bigint(20) NOT NULL COMMENT '浠诲姟id',
- `notify_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫氱煡鐘舵�� 0銆佹湭鍚敤 1銆佸惎鐢�',
- `notify_type` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫氱煡绫诲瀷 1銆侀拤閽� 2銆侀偖浠� 3銆佷紒涓氬井淇�',
- `notify_attribute` varchar(512) NOT NULL COMMENT '閰嶇疆灞炴��',
- `notify_threshold` int(11) NOT NULL DEFAULT '0' COMMENT '閫氱煡闃堝��',
- `notify_scene` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫氱煡鍦烘櫙',
- `rate_limiter_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '闄愭祦鐘舵�� 0銆佹湭鍚敤 1銆佸惎鐢�',
- `rate_limiter_threshold` int(11) NOT NULL DEFAULT '0' COMMENT '姣忕闄愭祦闃堝��',
- `description` varchar(256) NOT NULL DEFAULT '' COMMENT '鎻忚堪',
- `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_job_id` (`namespace_id`, `group_name`, job_id)
-) ENGINE = InnoDB
- AUTO_INCREMENT = 4
- DEFAULT CHARSET = utf8mb4 COMMENT ='job閫氱煡閰嶇疆';
-
-CREATE TABLE `er_job_summary`
+CREATE TABLE `sj_job_summary`
(
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` VARCHAR(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
`group_name` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '缁勫悕绉�',
`business_id` bigint NOT NULL COMMENT '涓氬姟id (job_id鎴杦orkflow_id)',
- `system_task_type` tinyint(4) NOT NULL DEFAULT '3' COMMENT '浠诲姟绫诲瀷 3銆丣OB浠诲姟 4銆乄ORKFLOW浠诲姟',
+ `system_task_type` tinyint(4) NOT NULL DEFAULT 3 COMMENT '浠诲姟绫诲瀷 3銆丣OB浠诲姟 4銆乄ORKFLOW浠诲姟',
`trigger_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '缁熻鏃堕棿',
- `success_num` int NOT NULL DEFAULT '0' COMMENT '鎵ц鎴愬姛-鏃ュ織鏁伴噺',
- `fail_num` int NOT NULL DEFAULT '0' COMMENT '鎵ц澶辫触-鏃ュ織鏁伴噺',
+ `success_num` int NOT NULL DEFAULT 0 COMMENT '鎵ц鎴愬姛-鏃ュ織鏁伴噺',
+ `fail_num` int NOT NULL DEFAULT 0 COMMENT '鎵ц澶辫触-鏃ュ織鏁伴噺',
`fail_reason` varchar(512) NOT NULL DEFAULT '' COMMENT '澶辫触鍘熷洜',
- `stop_num` int NOT NULL DEFAULT '0' COMMENT '鎵ц澶辫触-鏃ュ織鏁伴噺',
+ `stop_num` int NOT NULL DEFAULT 0 COMMENT '鎵ц澶辫触-鏃ュ織鏁伴噺',
`stop_reason` varchar(512) NOT NULL DEFAULT '' COMMENT '澶辫触鍘熷洜',
- `cancel_num` int NOT NULL DEFAULT '0' COMMENT '鎵ц澶辫触-鏃ュ織鏁伴噺',
+ `cancel_num` int NOT NULL DEFAULT 0 COMMENT '鎵ц澶辫触-鏃ュ織鏁伴噺',
`cancel_reason` varchar(512) NOT NULL DEFAULT '' COMMENT '澶辫触鍘熷洜',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
@@ -431,17 +413,17 @@
AUTO_INCREMENT = 1
DEFAULT CHARSET = utf8mb4 COMMENT ='DashBoard_Job';
-CREATE TABLE `er_retry_summary`
+CREATE TABLE `sj_retry_summary`
(
`id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` VARCHAR(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
`group_name` VARCHAR(64) NOT NULL DEFAULT '' COMMENT '缁勫悕绉�',
`scene_name` VARCHAR(50) NOT NULL DEFAULT '' COMMENT '鍦烘櫙鍚嶇О',
`trigger_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '缁熻鏃堕棿',
- `running_num` int NOT NULL DEFAULT '0' COMMENT '閲嶈瘯涓�-鏃ュ織鏁伴噺',
- `finish_num` int NOT NULL DEFAULT '0' COMMENT '閲嶈瘯瀹屾垚-鏃ュ織鏁伴噺',
- `max_count_num` int NOT NULL DEFAULT '0' COMMENT '閲嶈瘯鍒拌揪鏈�澶ф鏁�-鏃ュ織鏁伴噺',
- `suspend_num` int NOT NULL DEFAULT '0' COMMENT '鏆傚仠閲嶈瘯-鏃ュ織鏁伴噺',
+ `running_num` int NOT NULL DEFAULT 0 COMMENT '閲嶈瘯涓�-鏃ュ織鏁伴噺',
+ `finish_num` int NOT NULL DEFAULT 0 COMMENT '閲嶈瘯瀹屾垚-鏃ュ織鏁伴噺',
+ `max_count_num` int NOT NULL DEFAULT 0 COMMENT '閲嶈瘯鍒拌揪鏈�澶ф鏁�-鏃ュ織鏁伴噺',
+ `suspend_num` int NOT NULL DEFAULT 0 COMMENT '鏆傚仠閲嶈瘯-鏃ュ織鏁伴噺',
`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`),
@@ -451,26 +433,26 @@
AUTO_INCREMENT = 1
DEFAULT CHARSET = utf8mb4 COMMENT ='DashBoard_Retry';
-CREATE TABLE `er_workflow`
+CREATE TABLE `sj_workflow`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`workflow_name` varchar(64) NOT NULL COMMENT '宸ヤ綔娴佸悕绉�',
`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
`group_name` varchar(64) NOT NULL COMMENT '缁勫悕绉�',
- `workflow_status` tinyint(4) NOT NULL DEFAULT '1' COMMENT '宸ヤ綔娴佺姸鎬� 0銆佸叧闂��1銆佸紑鍚�',
+ `workflow_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '宸ヤ綔娴佺姸鎬� 0銆佸叧闂��1銆佸紑鍚�',
`trigger_type` tinyint(4) NOT NULL COMMENT '瑙﹀彂绫诲瀷 1.CRON 琛ㄨ揪寮� 2. 鍥哄畾鏃堕棿',
`trigger_interval` varchar(255) NOT NULL COMMENT '闂撮殧鏃堕暱',
`next_trigger_at` bigint(13) NOT NULL COMMENT '涓嬫瑙﹀彂鏃堕棿',
- `block_strategy` tinyint(4) NOT NULL DEFAULT '1' COMMENT '闃诲绛栫暐 1銆佷涪寮� 2銆佽鐩� 3銆佸苟琛�',
- `executor_timeout` int(11) NOT NULL DEFAULT '0' COMMENT '浠诲姟鎵ц瓒呮椂鏃堕棿锛屽崟浣嶇',
+ `block_strategy` tinyint(4) NOT NULL DEFAULT 1 COMMENT '闃诲绛栫暐 1銆佷涪寮� 2銆佽鐩� 3銆佸苟琛�',
+ `executor_timeout` int(11) NOT NULL DEFAULT 0 COMMENT '浠诲姟鎵ц瓒呮椂鏃堕棿锛屽崟浣嶇',
`description` varchar(256) NOT NULL DEFAULT '' COMMENT '鎻忚堪',
`flow_info` text DEFAULT NULL COMMENT '娴佺▼淇℃伅',
- `bucket_index` int(11) NOT NULL DEFAULT '0' COMMENT 'bucket',
+ `bucket_index` int(11) NOT NULL DEFAULT 0 COMMENT 'bucket',
`version` int(11) NOT NULL COMMENT '鐗堟湰鍙�',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
+ `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
PRIMARY KEY (`id`),
KEY `idx_create_dt` (`create_dt`),
KEY `idx_namespace_id_group_name` (`namespace_id`, `group_name`)
@@ -478,7 +460,7 @@
AUTO_INCREMENT = 0
DEFAULT CHARSET = utf8mb4 COMMENT ='宸ヤ綔娴�';
-CREATE TABLE `er_workflow_node`
+CREATE TABLE `sj_workflow_node`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
`namespace_id` varchar(64) NOT NULL DEFAULT '764d604ec6fc45f68cd92514c40e9e1a' COMMENT '鍛藉悕绌洪棿id',
@@ -493,10 +475,10 @@
`priority_level` int(11) NOT NULL DEFAULT 1 COMMENT '浼樺厛绾�',
`node_info` text DEFAULT NULL COMMENT '鑺傜偣淇℃伅 ',
`version` int(11) NOT NULL COMMENT '鐗堟湰鍙�',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
+ `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
PRIMARY KEY (`id`),
KEY `idx_create_dt` (`create_dt`),
KEY `idx_namespace_id_group_name` (`namespace_id`, `group_name`)
@@ -504,20 +486,20 @@
AUTO_INCREMENT = 0
DEFAULT CHARSET = utf8mb4 COMMENT ='宸ヤ綔娴佽妭鐐�';
-CREATE TABLE `er_workflow_task_batch`
+CREATE TABLE `sj_workflow_task_batch`
(
`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 '缁勫悕绉�',
`workflow_id` bigint(20) NOT NULL COMMENT '宸ヤ綔娴佷换鍔d',
- `task_batch_status` tinyint(4) NOT NULL DEFAULT '0' COMMENT '浠诲姟鎵规鐘舵�� 0銆佸け璐� 1銆佹垚鍔�',
- `operation_reason` tinyint(4) NOT NULL DEFAULT '0' COMMENT '鎿嶄綔鍘熷洜',
+ `task_batch_status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '浠诲姟鎵规鐘舵�� 0銆佸け璐� 1銆佹垚鍔�',
+ `operation_reason` tinyint(4) NOT NULL DEFAULT 0 COMMENT '鎿嶄綔鍘熷洜',
`flow_info` text DEFAULT NULL COMMENT '娴佺▼淇℃伅',
- `execution_at` bigint(13) NOT NULL DEFAULT '0' COMMENT '浠诲姟鎵ц鏃堕棿',
+ `execution_at` bigint(13) NOT NULL DEFAULT 0 COMMENT '浠诲姟鎵ц鏃堕棿',
+ `ext_attrs` varchar(256) NULL DEFAULT '' COMMENT '鎵╁睍瀛楁',
+ `deleted` tinyint(4) NOT NULL DEFAULT 0 COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
`create_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
`update_dt` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '淇敼鏃堕棿',
- `deleted` tinyint(4) NOT NULL DEFAULT '0' COMMENT '閫昏緫鍒犻櫎 1銆佸垹闄�',
- `ext_attrs` varchar(256) NULL default '' COMMENT '鎵╁睍瀛楁',
PRIMARY KEY (`id`),
KEY `idx_job_id_task_batch_status` (`workflow_id`, `task_batch_status`),
KEY `idx_create_dt` (`create_dt`),
--
Gitblit v1.9.3