From 451d1d244f301b73f06a6791911d580c8340067c Mon Sep 17 00:00:00 2001 From: RuoYi <yzz_ivy@163.com> Date: 星期三, 10 二月 2021 12:47:46 +0800 Subject: [PATCH] 修改ip字段长度防止ipv6地址长度不够 --- sql/ry_20210210.sql | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/sql/ry_20210108.sql b/sql/ry_20210210.sql similarity index 99% rename from sql/ry_20210108.sql rename to sql/ry_20210210.sql index 9e5dc88..d78be11 100644 --- a/sql/ry_20210108.sql +++ b/sql/ry_20210210.sql @@ -52,7 +52,7 @@ password varchar(100) default '' comment '瀵嗙爜', status char(1) default '0' comment '甯愬彿鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', del_flag char(1) default '0' comment '鍒犻櫎鏍囧織锛�0浠ｈ〃瀛樺湪 2浠ｈ〃鍒犻櫎锛�', - login_ip varchar(50) default '' comment '鏈�鍚庣櫥褰旾P', + login_ip varchar(128) default '' comment '鏈�鍚庣櫥褰旾P', login_date datetime comment '鏈�鍚庣櫥褰曟椂闂�', create_by varchar(64) default '' comment '鍒涘缓鑰�', create_time datetime comment '鍒涘缓鏃堕棿', @@ -421,7 +421,7 @@ oper_name varchar(50) default '' comment '鎿嶄綔浜哄憳', dept_name varchar(50) default '' comment '閮ㄩ棬鍚嶇О', oper_url varchar(255) default '' comment '璇锋眰URL', - oper_ip varchar(50) default '' comment '涓绘満鍦板潃', + oper_ip varchar(128) default '' comment '涓绘満鍦板潃', oper_location varchar(255) default '' comment '鎿嶄綔鍦扮偣', oper_param varchar(2000) default '' comment '璇锋眰鍙傛暟', json_result varchar(2000) default '' comment '杩斿洖鍙傛暟', @@ -546,7 +546,7 @@ create table sys_logininfor ( info_id bigint(20) not null auto_increment comment '璁块棶ID', user_name varchar(50) default '' comment '鐢ㄦ埛璐﹀彿', - ipaddr varchar(50) default '' comment '鐧诲綍IP鍦板潃', + ipaddr varchar(128) default '' comment '鐧诲綍IP鍦板潃', login_location varchar(255) default '' comment '鐧诲綍鍦扮偣', browser varchar(50) default '' comment '娴忚鍣ㄧ被鍨�', os varchar(50) default '' comment '鎿嶄綔绯荤粺', -- Gitblit v1.9.3