From abe6b05c5c1322eb28185a8354d02c72247f26b2 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 14 三月 2024 01:13:29 +0800
Subject: [PATCH] update 优化 !pr493 代码结构与问题修复
---
script/sql/postgres/easy_retry.sql | 16 ++++++----------
1 files changed, 6 insertions(+), 10 deletions(-)
diff --git a/script/sql/postgres/easy_retry.sql b/script/sql/postgres/easy_retry.sql
index 9e5d072..fa0a07e 100644
--- a/script/sql/postgres/easy_retry.sql
+++ b/script/sql/postgres/easy_retry.sql
@@ -22,8 +22,8 @@
COMMENT ON COLUMN namespace.deleted IS '閫昏緫鍒犻櫎 1銆佸垹闄�';
COMMENT ON TABLE namespace IS '鍛藉悕绌洪棿';
-INSERT INTO namespace (name, unique_id, create_dt, update_dt, deleted)
-VALUES ('Default', '764d604ec6fc45f68cd92514c40e9e1a', now(), now(), 0);
+INSERT INTO namespace VALUES (1, 'Development', 'dev', '', now(), now(), 0);
+INSERT INTO namespace VALUES (2, 'Production', 'prod', '', now(), now(), 0);
CREATE TABLE group_config
(
@@ -57,10 +57,7 @@
COMMENT ON COLUMN "group_config"."update_dt" IS '淇敼鏃堕棿';
COMMENT ON TABLE "group_config" IS '缁勯厤缃�';
-INSERT INTO `namespace` (`id`, `name`, `unique_id`, `create_dt`, `update_dt`, `deleted`)
-VALUES (1, 'Development', 'dev', now(), now(), 0);
-INSERT INTO `namespace` (`id`, `name`, `unique_id`, `create_dt`, `update_dt`, `deleted`)
-VALUES (2, 'Production', 'prod', now(), now(), 0);
+INSERT INTO group_config VALUES (1, 'dev', 'ruoyi_group', '', 1, 1, 0, 1, 1, 4, now(), now());
CREATE TABLE notify_config
(
@@ -353,8 +350,8 @@
COMMENT ON TABLE "system_user" IS '绯荤粺鐢ㄦ埛琛�';
-- pwd: admin
-INSERT INTO system_user (username, password, role)
-VALUES ('admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2);
+INSERT INTO system_user VALUES (1, 'admin', '465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', 2, now(), now());
+
CREATE TABLE system_user_permission
(
@@ -459,8 +456,7 @@
COMMENT ON COLUMN "job"."update_dt" IS '鏇存柊鏃堕棿';
COMMENT ON TABLE "job" IS '浠诲姟淇℃伅';
-INSERT INTO job (id, 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 (1, 'dev', 'ruoyi_group', 'demo-job', null, 1, 1710344035622, 1, 1, 4, 1, 'testJobExecutor', 2, '60', 1, 60, 3, 1, 1, 116, 0, '', '', '2024-03-13 22:59:39', '2024-03-13 23:32:52', 0);
+INSERT INTO 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 job_log_message
(
--
Gitblit v1.9.3