From 864e5d695f05f2b441f593fc5d912f3b28bb60f9 Mon Sep 17 00:00:00 2001
From: 疯狂的狮子Li <15040126243@163.com>
Date: 星期四, 02 十一月 2023 12:25:54 +0800
Subject: [PATCH] update 优化 重构登录策略增加扩展性降低复杂度
---
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