From 3f1e5702a293f31c5b70255c888f8ebc68fe49be Mon Sep 17 00:00:00 2001
From: May <1742057357@qq.com>
Date: 星期一, 27 十一月 2023 10:52:59 +0800
Subject: [PATCH] !454 添加excel多sheet页导出 * add 添加excel多sheet导出
---
script/sql/sqlserver/sqlserver_ry_vue_5.X.sql | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
index f16edb1..2045c58 100644
--- a/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
+++ b/script/sql/sqlserver/sqlserver_ry_vue_5.X.sql
@@ -1383,6 +1383,8 @@
info_id bigint NOT NULL,
tenant_id nvarchar(20) DEFAULT ('000000') NULL,
user_name nvarchar(50) DEFAULT '' NULL,
+ client_key nvarchar(32) DEFAULT '' NULL,
+ device_type nvarchar(32) DEFAULT '' NULL,
ipaddr nvarchar(128) DEFAULT '' NULL,
login_location nvarchar(255) DEFAULT '' NULL,
browser nvarchar(50) DEFAULT '' NULL,
@@ -1421,6 +1423,18 @@
'COLUMN', N'user_name'
GO
EXEC sys.sp_addextendedproperty
+ 'MS_Description', N'瀹㈡埛绔�' ,
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'sys_logininfor',
+ 'COLUMN', N'client_key'
+GO
+EXEC sys.sp_addextendedproperty
+ 'MS_Description', N'璁惧绫诲瀷' ,
+ 'SCHEMA', N'dbo',
+ 'TABLE', N'sys_logininfor',
+ 'COLUMN', N'device_type'
+GO
+EXEC sys.sp_addextendedproperty
'MS_Description', N'鐧诲綍IP鍦板潃' ,
'SCHEMA', N'dbo',
'TABLE', N'sys_logininfor',
--
Gitblit v1.9.3