From 89fdf101bc23228f7f207e0dfe09c6e357bdbdbd Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期四, 24 二月 2022 16:42:21 +0800
Subject: [PATCH] V2.11 edit at date 2022-2-23 1.表 `db_user`.`tb_user_inf` 新增字段 ADD COLUMN `visit_time` VARCHAR(17) NULL DEFAULT '00:00:01~23:59:59' COMMENT '允许访问时间区间' AFTER `lock_time`, ADD COLUMN `visit_ip` VARCHAR(255) NULL DEFAULT '*' COMMENT '允许访问ip' AFTER `visit_time`;
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
index b10a613..3fa6a04 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java
@@ -1066,6 +1066,24 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `lock_time` datetime DEFAULT NULL COMMENT '账号锁定时间';");
}
+ //添加visit_time
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_inf'"
+ + " AND column_name='visit_time'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ + " ADD COLUMN `visit_time` VARCHAR(17) NULL DEFAULT '00:00:01~23:59:59' COMMENT '允许访问时间区间' AFTER `lock_time`;");
+ }
+ //添加visit_ip
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_inf'"
+ + " AND column_name='visit_ip'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ + " ADD COLUMN `visit_ip` VARCHAR(255) NULL DEFAULT '*' COMMENT '允许访问ip' AFTER `visit_time`;");
+ }
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1