~whyclj/BattMonitor_DB_Builder.git

			@@ -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();

			@@ -383,3 +383,12 @@
			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`;

			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`;

			@@ -28,7 +28,7 @@
			/**************************************************************************/
			/**************************************************************************/
			public final static boolean app_debug = false;
			public final static float m_VersionNum = (float) 2.11;
			public final static float m_VersionNum = (float) 2.12;
			public final static String m_Version = "Welcome To Use BTS DB BUILDER V" + m_VersionNum + " RC_20180908";
			/**************************************************************************/
			/**************************************************************************/

	BattMonitor_DB_Builder/src/com/database_util/DB_db_user.java	17 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/com/version_inf/version_inf.txt	9 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史
	BattMonitor_DB_Builder/src/main/main_BTS_DB_Builder.java	2 ●●●●● 补丁 \| 查看 \| 原始文档 \| blame \| 历史