From 29118ae78c202f4e1f54f3220a69304f2149a97a Mon Sep 17 00:00:00 2001 From: MichelleChung <1242874891@qq.com> Date: 星期一, 23 十月 2023 09:28:11 +0800 Subject: [PATCH] !433 更新登录日志以及在线用户展示信息 * update 更新登录日志, 在线用户展示信息(增加 客户端, 设备类型) --- script/sql/oracle/oracle_ry_vue_5.X.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/script/sql/oracle/oracle_ry_vue_5.X.sql b/script/sql/oracle/oracle_ry_vue_5.X.sql index ecab07c..1100fa9 100644 --- a/script/sql/oracle/oracle_ry_vue_5.X.sql +++ b/script/sql/oracle/oracle_ry_vue_5.X.sql @@ -925,6 +925,8 @@ info_id number(20) not null, tenant_id varchar2(20) default '000000', user_name varchar2(50) default '', + client_key varchar2(32) default '', + device_type varchar2(32) default '', ipaddr varchar2(128) default '', login_location varchar2(255) default '', browser varchar2(50) default '', @@ -942,6 +944,8 @@ comment on column sys_logininfor.info_id is '璁块棶ID'; comment on column sys_logininfor.tenant_id is '绉熸埛缂栧彿'; comment on column sys_logininfor.user_name is '鐧诲綍璐﹀彿'; +comment on column sys_logininfor.client_key is '瀹㈡埛绔�'; +comment on column sys_logininfor.device_type is '璁惧绫诲瀷'; comment on column sys_logininfor.ipaddr is '鐧诲綍IP鍦板潃'; comment on column sys_logininfor.login_location is '鐧诲綍鍦扮偣'; comment on column sys_logininfor.browser is '娴忚鍣ㄧ被鍨�'; -- Gitblit v1.9.3