From 9e5f7be1c5142b1cdafc7e7c79d88d8538265d36 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期二, 30 四月 2024 15:52:12 +0800
Subject: [PATCH] update 增加 job 测试demo数据
---
script/sql/easy_retry.sql | 2 ++
script/sql/postgres/easy_retry_postgre.sql | 2 ++
script/sql/oracle/easy_retry_oracle.sql | 5 ++++-
script/sql/sqlserver/easy_retry_sqlserver.sql | 2 ++
4 files changed, 10 insertions(+), 1 deletions(-)
diff --git a/script/sql/easy_retry.sql b/script/sql/easy_retry.sql
index c884c88..6008a7c 100644
--- a/script/sql/easy_retry.sql
+++ b/script/sql/easy_retry.sql
@@ -310,6 +310,8 @@
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);
+
CREATE TABLE `er_job_log_message`
(
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT '涓婚敭',
diff --git a/script/sql/oracle/easy_retry_oracle.sql b/script/sql/oracle/easy_retry_oracle.sql
index 4c8c062..78ef6ca 100644
--- a/script/sql/oracle/easy_retry_oracle.sql
+++ b/script/sql/oracle/easy_retry_oracle.sql
@@ -474,8 +474,11 @@
COMMENT ON COLUMN er_job.description IS '鎻忚堪';
COMMENT ON COLUMN er_job.ext_attrs IS '鎵╁睍瀛楁';
COMMENT ON COLUMN er_job.create_dt IS '鍒涘缓鏃堕棿';
-COMMENT ON COLUMN er_job.deleted IS '閫昏緫鍒犻櫎 1銆佸垹闄�';
COMMENT ON COLUMN er_job.update_dt IS '鏇存柊鏃堕棿';
+COMMENT ON COLUMN er_job.deleted IS '閫昏緫鍒犻櫎 1銆佸垹闄�';
+
+INSERT INTO er_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, create_dt, update_dt, deleted)
+VALUES ('dev', 'ruoyi_group', 'demo-job', NULL, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', '', SYSDATE, SYSDATE, 0);
-- er_job_log_message
CREATE TABLE er_job_log_message
diff --git a/script/sql/postgres/easy_retry_postgre.sql b/script/sql/postgres/easy_retry_postgre.sql
index 62801e9..58cd8ac 100644
--- a/script/sql/postgres/easy_retry_postgre.sql
+++ b/script/sql/postgres/easy_retry_postgre.sql
@@ -463,6 +463,8 @@
COMMENT ON COLUMN er_job.update_dt IS '鏇存柊鏃堕棿';
COMMENT ON TABLE er_job IS '浠诲姟淇℃伅';
+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);
+
CREATE TABLE er_job_log_message
(
id BIGSERIAL PRIMARY KEY,
diff --git a/script/sql/sqlserver/easy_retry_sqlserver.sql b/script/sql/sqlserver/easy_retry_sqlserver.sql
index da22b5f..db6ad4f 100644
--- a/script/sql/sqlserver/easy_retry_sqlserver.sql
+++ b/script/sql/sqlserver/easy_retry_sqlserver.sql
@@ -418,6 +418,8 @@
'TABLE', N'er_job'
GO
+INSERT INTO `er_job` VALUES (1, N'dev', N'ruoyi_group', N'demo-job', null, 1, 1710344035622, 1, 1, 4, 1, N'testJobExecutor', 2, N'60', 1, 60, 3, 1, 1, 116, 0, N'', N'', getdate(), getdate(), 0);
+GO
-- er_job_log_message
CREATE TABLE er_job_log_message
--
Gitblit v1.9.3