From 6086bd101c46bd2817e171c25785ef55002489df Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期二, 01 三月 2022 14:41:54 +0800
Subject: [PATCH] V2.12 edit at date 2022-3-1 1.表 `db_user`.`tb_user_log` 新增修改字段 CHANGE `operation_detail` `operation_detail` text COMMENT '操作的具体数据' ADD COLUMN `read_flag` TINYINT(1) NULL DEFAULT 1 COMMENT '是否已阅读,此功能针对异常信息' AFTER `operation_detail`
---
BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java | 17 ++++++++++++++++-
1 files changed, 16 insertions(+), 1 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 3fa6a04..214f8bd 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
@@ -1117,7 +1117,7 @@
}
sql.sqlMysqlExecute(sql_str02);
- //添加face_id
+ //添加operation_detail
res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ " WHERE table_schema='db_user'"
+ " AND table_name='tb_user_log'"
@@ -1125,6 +1125,21 @@
if(false == res.next()) {
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
+ " ADD COLUMN `operation_detail` int(5) NOT NULL DEFAULT '1'");
+ }else{
+ //修改当前字段的类型
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
+ + " CHANGE `operation_detail` `operation_detail` text COMMENT '操作的具体数据';");
+ }
+
+
+ //添加read_flag
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_user'"
+ + " AND table_name='tb_user_log'"
+ + " AND column_name='read_flag'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.User_Log_Table
+ + " ADD COLUMN `read_flag` tinyint(1) DEFAULT '1' COMMENT '是否已阅读,此功能针对异常信息'");
}
} catch (SQLException e) {
e.printStackTrace();
--
Gitblit v1.9.1