From 66a0127a8dd1c87e87a5203bbb97f7820f15aba8 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期三, 15 二月 2023 11:43:49 +0800
Subject: [PATCH] V1.53 edit at date 2023-02-15 1.'db_battinf.tb_a059_station_inf' 新增字段用于标识导入的机房信息 `station_type` int(11) NOT NULL DEFAULT '0' COMMENT '机房类型[0:充放电一体机；1:FBO4830]' 2.'db_ram_db.tb_li9130_bms_state' 新增字段用于FBO4830因单体温度数目不定,新增字符串mon_tmps `mon_tmps` varchar(256) NOT NULL DEFAULT '' COMMENT '单体温度拼接字符串',
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 12 ++++++++++++
1 files changed, 12 insertions(+), 0 deletions(-)
diff --git a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
index e94710e..dc96d6b 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -109,6 +109,7 @@
" `video_url` varchar(255) NOT NULL DEFAULT '' COMMENT '视频监控序列号'," +
" `dev_num` varchar(255) NOT NULL DEFAULT '' COMMENT '设备编号'," +
" `last_update_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '上一次更新时间'," +
+ " `station_type` int(11) NOT NULL DEFAULT '0' COMMENT '机房类型[0:充放电一体机；1:FBO4830]'," +
" PRIMARY KEY (`num`)" +
") ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;";
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -129,6 +130,17 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.A059_Station_Inf_TABLE
+ " ADD COLUMN `station_name_ex` varchar(255) NOT NULL DEFAULT '' COMMENT '拼接带设备编号的机房名称';");
}
+
+ res = null;
+ //添加station_type
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_a059_station_inf'"
+ + " AND column_name='station_type'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.A059_Station_Inf_TABLE
+ + " ADD COLUMN `station_type` int(11) NOT NULL DEFAULT '0' COMMENT '机房类型[0:充放电一体机；1:FBO4830]';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1