From a7dab1f18c26bbb3e2cc1f8679b1b744c784dfd8 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期四, 09 十二月 2021 09:55:27 +0800
Subject: [PATCH] V1.97 edit at date 2021-12-9 1：修改`db_user`.`tb_battinf` 表下字段 去掉字段old_password ,新增字段`lock_time` datetime DEFAULT NULL COMMENT '账号锁定时间'
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 21 +++++++++++----------
1 files changed, 11 insertions(+), 10 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 72682cc..b10a613 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
@@ -1001,16 +1001,6 @@
}
}
-
- //添加old_password
- res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
- + " WHERE table_schema='db_user'"
- + " AND table_name='tb_user_inf'"
- + " AND column_name='password_default'");
- if(false == res.next()) {
- sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
- + " ADD COLUMN `password_default` tinyint(1) DEFAULT '1' COMMENT '密码是否为初始化密码,1:默认,0:非默认';");
- }
//添加type
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_user'"
@@ -1066,6 +1056,17 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ " ADD COLUMN `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间';");
}
+
+ //添加lock_time
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_inf'"
+ + " AND column_name='lock_time'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.TB_UserInf
+ + " ADD COLUMN `lock_time` datetime DEFAULT NULL COMMENT '账号锁定时间';");
+ }
+
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1