From 3879fa5df2e9a80e924d9df55e11a65de7dd71a2 Mon Sep 17 00:00:00 2001
From: TomXin <766781886@qq.com>
Date: 星期一, 13 五月 2024 16:29:43 +0800
Subject: [PATCH] 修正Oracle的sql
---
script/sql/sqlserver/easy_retry_sqlserver.sql | 32 +++++++++++++++++---------------
1 files changed, 17 insertions(+), 15 deletions(-)
diff --git a/script/sql/sqlserver/easy_retry_sqlserver.sql b/script/sql/sqlserver/easy_retry_sqlserver.sql
index 3cf7045..db6ad4f 100644
--- a/script/sql/sqlserver/easy_retry_sqlserver.sql
+++ b/script/sql/sqlserver/easy_retry_sqlserver.sql
@@ -188,7 +188,7 @@
'TABLE', N'er_group_config'
GO
-INSERT INTO er_group_config VALUES (N'1', N'dev', N'ruoyi_group', N'', N'ER_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', N'1', N'1', N'0', N'1', N'1', N'4', getdate(), getdate());
+INSERT INTO er_group_config(namespace_id, group_name, description, token, group_status, version, group_partition, id_generator_mode, init_scene, bucket_index, create_dt, update_dt) VALUES (N'dev', N'ruoyi_group', N'', N'ER_cKqBTPzCsWA3VyuCfFoccmuIEGXjr5KT', N'1', N'1', N'0', N'1', N'1', N'4', getdate(), getdate());
GO
-- er_job
@@ -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
@@ -1154,8 +1156,8 @@
'TABLE', N'er_namespace'
GO
-INSERT INTO er_namespace VALUES (N'1', N'Development', N'dev', N'', getdate(), getdate(), N'0');
-INSERT INTO er_namespace VALUES (N'2', N'Production', N'prod', N'', getdate(), getdate(), N'0');
+INSERT INTO er_namespace(name, unique_id, description, create_dt, update_dt, deleted) VALUES (N'Development', N'dev', N'', getdate(), getdate(), N'0');
+INSERT INTO er_namespace(name, unique_id, description, create_dt, update_dt, deleted) VALUES (N'Production', N'prod', N'', getdate(), getdate(), N'0');
GO
-- er_notify_config
@@ -1423,7 +1425,7 @@
GO
CREATE UNIQUE NONCLUSTERED INDEX uk_scene_name_trigger_at ON er_retry_summary (namespace_id ASC, group_name ASC,
- scene_name ASC, trigger_at ASC)
+ scene_name ASC, trigger_at ASC)
GO
EXEC sp_addextendedproperty
@@ -2187,8 +2189,8 @@
'TABLE', N'er_server_node'
GO
--- er_system_user_
-CREATE TABLE er_system_user_
+-- er_system_user
+CREATE TABLE er_system_user
(
id bigint PRIMARY KEY IDENTITY,
username nvarchar(64) NOT NULL,
@@ -2199,59 +2201,59 @@
)
GO
-CREATE UNIQUE NONCLUSTERED INDEX uk_username ON er_system_user_ (username ASC)
+CREATE UNIQUE NONCLUSTERED INDEX uk_username ON er_system_user (username ASC)
GO
EXEC sp_addextendedproperty
'MS_Description', N'涓婚敭',
'SCHEMA', N'dbo',
- 'TABLE', N'er_system_user_',
+ 'TABLE', N'er_system_user',
'COLUMN', N'id'
GO
EXEC sp_addextendedproperty
'MS_Description', N'璐﹀彿',
'SCHEMA', N'dbo',
- 'TABLE', N'er_system_user_',
+ 'TABLE', N'er_system_user',
'COLUMN', N'username'
GO
EXEC sp_addextendedproperty
'MS_Description', N'瀵嗙爜',
'SCHEMA', N'dbo',
- 'TABLE', N'er_system_user_',
+ 'TABLE', N'er_system_user',
'COLUMN', N'password'
GO
EXEC sp_addextendedproperty
'MS_Description', N'瑙掕壊锛�1-鏅�氱敤鎴枫��2-绠＄悊鍛�',
'SCHEMA', N'dbo',
- 'TABLE', N'er_system_user_',
+ 'TABLE', N'er_system_user',
'COLUMN', N'role'
GO
EXEC sp_addextendedproperty
'MS_Description', N'鍒涘缓鏃堕棿',
'SCHEMA', N'dbo',
- 'TABLE', N'er_system_user_',
+ 'TABLE', N'er_system_user',
'COLUMN', N'create_dt'
GO
EXEC sp_addextendedproperty
'MS_Description', N'淇敼鏃堕棿',
'SCHEMA', N'dbo',
- 'TABLE', N'er_system_user_',
+ 'TABLE', N'er_system_user',
'COLUMN', N'update_dt'
GO
EXEC sp_addextendedproperty
'MS_Description', N'绯荤粺鐢ㄦ埛琛�',
'SCHEMA', N'dbo',
- 'TABLE', N'er_system_user_'
+ 'TABLE', N'er_system_user'
GO
-- pwd: admin
-INSERT INTO er_system_user_ VALUES (N'1', N'admin', N'465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', N'2', getdate(), getdate());
+INSERT INTO er_system_user(username, password, role, create_dt, update_dt) VALUES (N'admin', N'465c194afb65670f38322df087f0a9bb225cc257e43eb4ac5a0c98ef5b3173ac', N'2', getdate(), getdate());
GO
-- er_system_user_permission
--
Gitblit v1.9.3