From 684feac5342de849a8642979d07ebdbfa6192ebd Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期五, 29 十月 2021 17:30:57 +0800
Subject: [PATCH] V1.88 edit at date 2021-10-29 1：新增`db_user`.`tb_user_log` 表下字段 operation_detail
---
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 6e2e937..43badfd 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
@@ -1025,14 +1025,32 @@
" KEY `user_id` (`uId`)" +
") ENGINE=InnoDB AUTO_INCREMENT=7293 DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
try {
if(true == recreate) {
sql.sqlMysqlExecute(sql_str01);
}
sql.sqlMysqlExecute(sql_str02);
+
+ //添加face_id
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_log'"
+ + " AND column_name='operation_detail'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
+ + " ADD COLUMN `operation_detail` int(5) NOT NULL DEFAULT '1'");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
+ if(res != null) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ e.printStackTrace();
+ }
+ }
sql.close_con();
}
}
--
Gitblit v1.9.1