From 1ed1752f678f769e43e9faa34809701850c7f727 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期四, 30 三月 2023 19:14:38 +0800
Subject: [PATCH] update 优化 验证码有效期 迁移到数据库 参数管理内
---
script/sql/sqlserver/sqlserver_ry_vue_5.X.sql | 84 ++++++++++++++++++++++++++++++------------
1 files changed, 60 insertions(+), 24 deletions(-)
diff --git a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
index 86563d7..38e2b2f 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
@@ -592,7 +592,7 @@
CREATE TABLE sys_config
(
config_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT '000000' NULL,
config_name nvarchar(100) DEFAULT '' NULL,
config_key nvarchar(100) DEFAULT '' NULL,
config_value nvarchar(500) DEFAULT '' NULL,
@@ -694,7 +694,19 @@
GO
INSERT sys_config VALUES (3, N'000000', N'涓绘鏋堕〉-渚ц竟鏍忎富棰�', N'sys.index.sideTheme', N'theme-dark', N'Y', 103, 1, getdate(), NULL, NULL, N'娣辫壊涓婚theme-dark锛屾祬鑹蹭富棰榯heme-light')
GO
+INSERT sys_config VALUES (4, N'000000', N'鐢ㄦ埛閰嶇疆-楠岃瘉鐮佹湁鏁堟湡', N'sys.account.captchaExpired', N'2', N'Y', 103, 1, sysdate(), null, NULL, N'楠岃瘉鐮佹湁鏁堟湡锛堝垎閽燂級');
+GO
INSERT sys_config VALUES (5, N'000000', N'璐﹀彿鑷姪-鏄惁寮�鍚敤鎴锋敞鍐屽姛鑳�', N'sys.account.registerUser', N'false', N'Y', 103, 1, getdate(), NULL, NULL, N'鏄惁寮�鍚敞鍐岀敤鎴峰姛鑳斤紙true寮�鍚紝false鍏抽棴锛�')
+GO
+INSERT sys_config VALUES (6, N'000000', N'鐢ㄦ埛閰嶇疆-瀵嗙爜鏈�澶ч敊璇鏁�', N'sys.user.maxRetryCount', N'5', N'Y', 103, 1, getdate(), NULL, NULL, N'瀵嗙爜鏈�澶ч敊璇鏁�')
+GO
+INSERT sys_config VALUES (7, N'000000', N'鐢ㄦ埛閰嶇疆-瀵嗙爜閿佸畾鏃堕棿', N'sys.user.lockTime', N'10', N'Y', 103, 1, getdate(), NULL, NULL, N'瀵嗙爜閿佸畾鏃堕棿锛堝垎閽燂級')
+GO
+INSERT sys_config VALUES (8, N'000000', N'璐﹀彿鑷姪-鐭俊寮�鍏�', N'sys.account.smsEnabled', N'false', N'Y', 103, 1, getdate(), NULL, NULL, N'鏄惁寮�鍚煭淇″姛鑳斤紙true寮�鍚紝false鍏抽棴锛�')
+GO
+INSERT sys_config VALUES (9, N'000000', N'璐﹀彿鑷姪-楠岃瘉鐮佹ā鏉縤d', N'sys.account.templateId', N'', N'Y', 103, 1, getdate(), NULL, NULL, N'楠岃瘉鐮佹ā鏉縤d')
+GO
+INSERT sys_config VALUES (10, N'000000', N'璐﹀彿鑷姪-閭欢寮�鍏�', N'sys.account.emailEnabled', N'false', N'Y', 103, 1, getdate(), NULL, NULL, N'鏄惁寮�鍚偖浠跺姛鑳斤紙true寮�鍚紝false鍏抽棴锛�')
GO
INSERT sys_config VALUES (11, N'000000', N'OSS棰勮鍒楄〃璧勬簮寮�鍏�', N'sys.oss.previewListResource', N'true', N'Y', 103, 1, getdate(), NULL, NULL, N'true:寮�鍚�, false:鍏抽棴');
GO
@@ -702,7 +714,7 @@
CREATE TABLE sys_dept
(
dept_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
parent_id bigint DEFAULT ((0)) NULL,
ancestors nvarchar(500)DEFAULT '' NULL,
dept_name nvarchar(30) DEFAULT '' NULL,
@@ -850,7 +862,7 @@
CREATE TABLE sys_dict_data
(
dict_code bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
dict_sort int DEFAULT ((0)) NULL,
dict_label nvarchar(100) DEFAULT '' NULL,
dict_value nvarchar(100) DEFAULT '' NULL,
@@ -1036,7 +1048,7 @@
CREATE TABLE sys_dict_type
(
dict_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
dict_name nvarchar(100) DEFAULT '' NULL,
dict_type nvarchar(100) DEFAULT '' NULL,
status nchar(1) DEFAULT ('0') NULL,
@@ -1051,6 +1063,9 @@
ON [PRIMARY]
)
ON [PRIMARY]
+GO
+
+CREATE NONCLUSTERED INDEX sys_dict_type_index1 ON sys_dict_type (tenant_id, dict_type)
GO
EXEC sys.sp_addextendedproperty
@@ -1149,7 +1164,7 @@
CREATE TABLE sys_logininfor
(
info_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
user_name nvarchar(50) DEFAULT '' NULL,
ipaddr nvarchar(128) DEFAULT '' NULL,
login_location nvarchar(255) DEFAULT '' NULL,
@@ -1163,6 +1178,11 @@
ON [PRIMARY]
)
ON [PRIMARY]
+GO
+
+CREATE NONCLUSTERED INDEX idx_sys_logininfor_s ON sys_logininfor (status)
+GO
+CREATE NONCLUSTERED INDEX idx_sys_logininfor_lt ON sys_logininfor (login_time)
GO
EXEC sys.sp_addextendedproperty
@@ -1394,6 +1414,8 @@
GO
INSERT sys_menu VALUES (3, N'绯荤粺宸ュ叿', 0, 4, N'tool', NULL, N'', 1, 0, N'M', N'0', N'0', N'', N'tool', 103, 1, getdate(), NULL, NULL, N'绯荤粺宸ュ叿鐩綍')
GO
+INSERT sys_menu VALUES (4, N'PLUS瀹樼綉', 0, 5, N'https://gitee.com/dromara/RuoYi-Vue-Plus', null, N'', 0, 0, N'M', N'0', N'0', N'', N'guide', 103, 1, getdate(), null, null, N'RuoYi-Vue-Plus瀹樼綉鍦板潃');
+GO
INSERT sys_menu VALUES (100, N'鐢ㄦ埛绠＄悊', 1, 1, N'user', N'system/user/index', N'', 1, 0, N'C', N'0', N'0', N'system:user:list', N'user', 103, 1, getdate(), NULL, NULL, N'鐢ㄦ埛绠＄悊鑿滃崟')
GO
INSERT sys_menu VALUES (101, N'瑙掕壊绠＄悊', 1, 2, N'role', N'system/role/index', N'', 1, 0, N'C', N'0', N'0', N'system:role:list', N'peoples', 103, 1, getdate(), NULL, NULL, N'瑙掕壊绠＄悊鑿滃崟')
@@ -1583,7 +1605,7 @@
CREATE TABLE sys_notice
(
notice_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
notice_title nvarchar(50) NOT NULL,
notice_type nchar(1) NOT NULL,
notice_content nvarchar(max) NULL,
@@ -1688,7 +1710,7 @@
CREATE TABLE sys_oper_log
(
oper_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
title nvarchar(50) DEFAULT '' NULL,
business_type int DEFAULT ((0)) NULL,
method nvarchar(100) DEFAULT '' NULL,
@@ -1704,11 +1726,19 @@
status int DEFAULT ((0)) NULL,
error_msg nvarchar(2000) DEFAULT '' NULL,
oper_time datetime2(7) NULL,
+ cost_time bigint DEFAULT ((0)) NULL,
CONSTRAINT PK__sys_oper__34723BF9BD954573 PRIMARY KEY CLUSTERED (oper_id)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
)
ON [PRIMARY]
+GO
+
+CREATE NONCLUSTERED INDEX idx_sys_oper_log_bt ON sys_oper_log (business_type)
+GO
+CREATE NONCLUSTERED INDEX idx_sys_oper_log_s ON sys_oper_log (status)
+GO
+CREATE NONCLUSTERED INDEX idx_sys_oper_log_ot ON sys_oper_log (oper_time)
GO
EXEC sys.sp_addextendedproperty
@@ -1814,6 +1844,12 @@
'COLUMN', N'oper_time'
GO
EXEC sys.sp_addextendedproperty
+ 'MS_Description', N'娑堣�楁椂闂�' ,
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'sys_oper_log',
+ 'COLUMN', N'cost_time'
+GO
+EXEC sys.sp_addextendedproperty
'MS_Description', N'鎿嶄綔鏃ュ織璁板綍' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_oper_log'
@@ -1821,18 +1857,18 @@
CREATE TABLE sys_post
(
- post_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
- post_code nvarchar(64) NOT NULL,
- post_name nvarchar(50) NOT NULL,
- post_sort int NOT NULL,
- status nchar(1) NOT NULL,
- create_dept bigint NOT NULL,
- create_by bigint NOT NULL,
- create_time datetime2(7) NULL,
- update_by bigint NOT NULL,
- update_time datetime2(7) NULL,
- remark nvarchar(500) NULL,
+ post_id bigint NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
+ post_code nvarchar(64) NOT NULL,
+ post_name nvarchar(50) NOT NULL,
+ post_sort int NOT NULL,
+ status nchar(1) NOT NULL,
+ create_dept bigint NULL,
+ create_by bigint NULL,
+ create_time datetime2(7) NULL,
+ update_by bigint NULL,
+ update_time datetime2(7) NULL,
+ remark nvarchar(500) NULL,
CONSTRAINT PK__sys_post__3ED7876668E2D081 PRIMARY KEY CLUSTERED (post_id)
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)
ON [PRIMARY]
@@ -1930,7 +1966,7 @@
CREATE TABLE sys_role
(
role_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
role_name nvarchar(30) NOT NULL,
role_key nvarchar(100) NOT NULL,
role_sort int NOT NULL,
@@ -2292,7 +2328,7 @@
CREATE TABLE sys_user
(
user_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
dept_id bigint NULL,
user_name nvarchar(30) NOT NULL,
nick_name nvarchar(30) NOT NULL,
@@ -2527,7 +2563,7 @@
CREATE TABLE sys_oss
(
oss_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
file_name nvarchar(255) DEFAULT '' NOT NULL,
original_name nvarchar(255) DEFAULT '' NOT NULL,
file_suffix nvarchar(10) DEFAULT '' NOT NULL,
@@ -2626,7 +2662,7 @@
CREATE TABLE sys_oss_config
(
oss_config_id bigint NOT NULL,
- tenant_id nvarchar(20) NOT NULL,
+ tenant_id nvarchar(20) DEFAULT ('000000') NULL,
config_key nvarchar(20) DEFAULT '' NOT NULL,
access_key nvarchar(255) DEFAULT '' NULL,
secret_key nvarchar(255) DEFAULT '' NULL,
@@ -2725,7 +2761,7 @@
'COLUMN', N'access_policy'
GO
EXEC sp_addextendedproperty
- 'MS_Description', N'鐘舵�侊紙0=姝ｅ父,1=鍋滅敤锛�',
+ 'MS_Description', N'鏄惁榛樿锛�0=鏄�,1=鍚︼級',
'SCHEMA', N'dbo',
'TABLE', N'sys_oss_config',
'COLUMN', N'status'
--
Gitblit v1.9.3