From e321185263fa236c446ca9c086129d9871f5d2e5 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期六, 21 八月 2021 10:39:49 +0800
Subject: [PATCH] V1.67 edit at date 2021-08-17 1.db_battinf.tb_battinf表新增视频链接地址字段'video_url' 2.db_battinf.tb_battinf表新增逆变充放电状态'charge_type'和母联状态'buscouple_state' 3.新增数据库db_fbo_testdata,用于存放从充放电一体机导入的历史数据文件 4.在数据库'db_fbo_testdata'中新增表'tb_fbotestdata_inf'用于存放历史数据导入记录 5.新增'db_ram_db.tb_fgcd_filedownload'表用于充放电一体机历史数据远程导入
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 20 ++++++++++++++++++++
1 files changed, 20 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 71256ae..0ab4142 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -823,6 +823,26 @@
sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ " ADD COLUMN `video_url` varchar(200) DEFAULT NULL;");
}
+
+ //添加charge_type
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='charge_type'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `charge_type` int(11) NOT NULL DEFAULT '1' COMMENT '充放电状态：1:限流充电；2；逆变充电';");
+ }
+
+ //添加buscouple_state
+ res = sql.sqlMysqlQuery("SELECT * FROM information_schema.columns"
+ + " WHERE table_schema='db_battinf'"
+ + " AND table_name='tb_battinf'"
+ + " AND column_name='buscouple_state'");
+ if(false == res.next()) {
+ sql.sqlMysqlExecute("ALTER TABLE " + Sql_Mysql.BattInf_Table
+ + " ADD COLUMN `buscouple_state` int(11) NOT NULL DEFAULT '0' COMMENT '母联状态：0：无母联；1:有母联';");
+ }
} catch (SQLException e) {
e.printStackTrace();
} finally {
--
Gitblit v1.9.1