From 856f0767b4ada087e9e2cb33f373e23dbcf39b85 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子li <15040126243@163.com>
Date: 星期二, 07 三月 2023 17:56:59 +0800
Subject: [PATCH] update 同步 ruoyi * update element-ui 2.15.10 => 2.15.12 * update 优化 tagsView右选框，首页不应该存在关闭左侧选项 * update copyright 2023 * update 优化 监控页面图标显示 * update 优化 日志注解支持排除指定的请求参数 * update 优化 业务校验优化代码 * fix 修复 优化文件下载出现的异常 * fix 修复 修改密码日志存储明文问题 * add 新增 操作日志消耗时间属性 * update 优化 日志管理使用索引提升查询性能 * update 优化 框架时间检索使用时间默认值 00:00:00 - 23:59:59
---
script/sql/sqlserver/sqlserver_ry_vue_5.X.sql | 28 +++++++++++++++++++++++++---
1 files changed, 25 insertions(+), 3 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..8ecfaf5 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
@@ -1165,6 +1165,11 @@
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
'MS_Description', N'璁块棶ID' ,
'SCHEMA', N'dbo',
@@ -1704,11 +1709,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 +1827,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'
@@ -1827,10 +1846,10 @@
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_dept bigint NULL,
+ create_by bigint NULL,
create_time datetime2(7) NULL,
- update_by bigint NOT NULL,
+ update_by bigint NULL,
update_time datetime2(7) NULL,
remark nvarchar(500) NULL,
CONSTRAINT PK__sys_post__3ED7876668E2D081 PRIMARY KEY CLUSTERED (post_id)
@@ -1840,6 +1859,9 @@
ON [PRIMARY]
GO
+CREATE NONCLUSTERED INDEX sys_dict_type_index1 ON sys_dict_type (tenant_id, dict_type)
+GO
+
EXEC sys.sp_addextendedproperty
'MS_Description', N'宀椾綅ID' ,
'SCHEMA', N'dbo',
--
Gitblit v1.9.3