From bd00843666fc46a112d885a6b629d4020b597149 Mon Sep 17 00:00:00 2001 From: DELL <DELL@WIN-3EOIPEE9ML1> Date: 星期三, 10 一月 2024 16:35:40 +0800 Subject: [PATCH] V1.92 edit at date 2024-01-10 1.新增数据库'db_pwrdev_data_rt.tb_pwrdev_rt_info' CREATE TABLE `tb_pwrdev_rt_info` ( `num` bigint(20) NOT NULL AUTO_INCREMENT, `PowerDeviceId` bigint(20) NOT NULL DEFAULT '0', `record_datetime` datetime NOT NULL DEFAULT '2005-01-01 00:00:00', `CommTxCount` int(11) NOT NULL DEFAULT '0', `CommSuccessCount` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (`num`), KEY `index_powerdev_id` (`PowerDeviceId`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8; 2.表'db_pwrdev_data_rt.tb_pwrdev_acdcdata'新增字段 `chargLimitCurr` float NOT NULL DEFAULT '0', `junChargeVol` float NOT NULL DEFAULT '0', `floatChargeVol` float NOT NULL DEFAULT '0', `acVolH_Limit` float NOT NULL DEFAULT '0', `acVolL_Limit` float NOT NULL DEFAULT '0', `dcOutVolH_Limit` float NOT NULL DEFAULT '0', `dcOutVolL_Limit` float NOT NULL DEFAULT '0', `acInUseCount` tinyint(4) NOT NULL DEFAULT '0', --- BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 1 + 1 files changed, 1 insertions(+), 0 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java index 79f85d2..dc831cc 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -348,6 +348,7 @@ public final static String Pwrdev_Event_Table = DB_PWRDEV_DATA_RT + ".`tb_pwrdev_event`"; public final static String Upspower_Sinal_Table = DB_PWRDEV_DATA_RT + ".`tb_upspower_sinal`"; //UPS遥信和告警实时状态表 public final static String Upspower_Simulate_Table = DB_PWRDEV_DATA_RT + ".`tb_upspower_simulate`"; //UPS遥测信息实时状态表 + public final static String Pwrdev_Rt_Info_Table = DB_PWRDEV_DATA_RT + ".`tb_pwrdev_rt_info`"; //UPS遥测信息实时状态表 -- Gitblit v1.9.1