From 00c06374dc63c9be5114d38e224204d3e171dda7 Mon Sep 17 00:00:00 2001
From: Administrator <1525436766@qq.com>
Date: 星期一, 19 六月 2023 15:36:08 +0800
Subject: [PATCH] CREATE TABLE `tb_battinf_update_record` ( `num` int(11) NOT NULL AUTO_INCREMENT, `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00', `update_reason` text COMMENT '电池信息更改原因', `update_name` varchar(20) DEFAULT ' ' COMMENT '更改人', `StationId` varchar(20) DEFAULT '0', `StationId_ex` varchar(20) DEFAULT '0', `StationName` varchar(100) DEFAULT ' ', `StationName1` varchar(100) DEFAULT ' ', `StationName2` varchar(100) DEFAULT ' ', `StationName3` varchar(100) DEFAULT ' ', `StationName4` varchar(100) DEFAULT ' ', `StationName5` varchar(100) DEFAULT ' ', `StationName6` varchar(100) DEFAULT ' ', `StationName7` varchar(100) DEFAULT ' ', `StationName8` varchar(100) DEFAULT ' ', `StationName9` varchar(100) DEFAULT ' ', `StationIP` varchar(20) DEFAULT '0', `FBSDeviceId` bigint(11) DEFAULT '0', `FBSDeviceIp` varchar(50) DEFAULT '192.168.0.88', `FBSDeviceIp_WG` varchar(64) DEFAULT '192.168.0.1', `FBSDeviceIp_YM` varchar(64) DEFAULT '255.255.255.0', `FBSDeviceName` varchar(100) DEFAULT '0', `GroupIndexInFBSDevice` int(11) DEFAULT '0', `BattModel` varchar(100) DEFAULT ' ', `BattGroupId` int(11) DEFAULT '0', `BattGroupNum` int(11) DEFAULT '0', `BattGroupName` varchar(100) DEFAULT ' ', `BattGroupName1` varchar(100) DEFAULT ' ', `BattGroupName2` varchar(100) DEFAULT ' ', `BattGroupName3` varchar(100) DEFAULT ' ', `BattGroupName4` varchar(100) DEFAULT ' ', `BattGroupName5` varchar(100) DEFAULT ' ', `BattGroupName6` varchar(100) DEFAULT ' ', `FloatVolLevel` float DEFAULT '1.12', `OfflineVolLevel` float DEFAULT '1.06', `BattFloatCurrent` float DEFAULT '0', `DeviceId` varchar(20) DEFAULT '0', `DeviceName` varchar(100) DEFAULT '0', `MonCount` int(11) DEFAULT '0', `MonCapStd` float DEFAULT '0', `MonVolStd` float DEFAULT '0', `MonResStd` float DEFAULT '0', `MonSerStd` float DEFAULT '0', `MonTmpStd` float DEFAULT '0', `MonVolLowToAvg` float DEFAULT '0', `MonNum` int(11) DEFAULT '0', `BattProducer` varchar(45) DEFAULT '0', `BattProductDate` date DEFAULT '2006-07-06', `BattInUseDate` date DEFAULT '2006-07-06', `BattGuarantDayCount` int(11) DEFAULT '1095', `SignalId` varchar(20) DEFAULT '0', `CInterFaceId` int(11) DEFAULT '0', `SignalName` varchar(50) DEFAULT '0', `Load_curr` float DEFAULT '15', `DisCurrMax` float DEFAULT '0', `station_phone` varchar(32) DEFAULT '', `station_install` tinyint(1) DEFAULT '0', `install_user` varchar(64) DEFAULT '', `charge_curr_max` float DEFAULT '20', `Vol_grade` float DEFAULT '0', `Manufacturers` varchar(64) DEFAULT '', `Assetequipment` varchar(64) DEFAULT '', `Deviceclasspath` varchar(64) DEFAULT '', `DeviceOperationDepartment` varchar(64) DEFAULT '', `PropertyRightUnit` varchar(64) DEFAULT '', `PropertyAttribute` varchar(64) DEFAULT '', `FactoryNumber` varchar(64) DEFAULT '', `OperationTeam` varchar(64) DEFAULT '', `DeviceIdentityCode` varchar(64) DEFAULT '', `ProjectType` varchar(64) DEFAULT '', `BatteryApplicationType` varchar(64) DEFAULT '', `SingleRatedVoltage` float DEFAULT '0', `RemoteMonitor` varchar(64) DEFAULT '', `BatttIndependentPlaced` varchar(64) DEFAULT '', `JunChargeVoltageValue` float DEFAULT '0', `PublicKeyX` varchar(200) DEFAULT '', `PublicKeyY` varchar(200) DEFAULT '', `KeyID` varchar(200) DEFAULT '', `SerialNumber` varchar(200) DEFAULT '', `sort_id` int(3) DEFAULT '0', `video_url` varchar(200) DEFAULT NULL, `charge_type` int(11) DEFAULT '1' COMMENT '充放电状态：1:限流充电；2；逆变充电', `buscouple_state` int(11) DEFAULT '0' COMMENT '母联状态：0：无母联；1:有母联', `tmp_id` int(11) DEFAULT '0', `price_factor` float DEFAULT '1' COMMENT '电价系数', `smps_brand` varchar(50) DEFAULT NULL COMMENT '开关电源品牌', `smps_model` varchar(50) DEFAULT NULL COMMENT '开关电源型号', `PackCount` int(11) DEFAULT '1' COMMENT '锂电池包数量', `dev_num` varchar(255) NOT NULL DEFAULT '0' COMMENT '设备编号[a059用于标识设备]', `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位', `cellShowType` int(11) NOT NULL DEFAULT '0' COMMENT '电池类型[0：铅酸 1：锂电]', `NomCapWH` float NOT NULL DEFAULT '0' COMMENT '标称容量[KWH]', `NomCapAH` float NOT NULL DEFAULT '0' COMMENT '标称容量AH', `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]', `NodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '节点站标识:0:不是节点站[默认] 1:节点站', `StationType` varchar(255) DEFAULT NULL COMMENT '站点类型[例如110V/22V]', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='电池信息更改记录表';
---
BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java | 121 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 120 insertions(+), 1 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 5f02209..e227a41 100644
--- a/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
+++ b/BattMonitor_DB_Builder/src/com/database_util/DB_battinf.java
@@ -56,7 +56,7 @@
createBattmon_Standardcurve_TABLE(pool,recreate);
-
+ createBattinf_Update_Record_Table(pool, recreate); //创建电池信息更改记录表
System.out.println(" db_battinf init end at " + Com.getDateTimeFormat(new Date(), Com.DTF_YMDhms));
}
@@ -672,6 +672,125 @@
sql.close_con();
}
}
+ /**
+ * 创建 `db_battinf`.`tb_battinf_update_record` 表
+ * @param pool
+ * @param recreate
+ */
+ public static void createBattinf_Update_Record_Table(MysqlConnPool pool, boolean recreate) {
+ String sql_str01 = " DROP TABLE IF EXISTS "+Sql_Mysql.Battinf_Update_Record_Table;
+ String sql_str02 = "CREATE TABLE IF NOT EXISTS " + Sql_Mysql.Battinf_Update_Record_Table + " (" +
+ " `num` int(11) NOT NULL AUTO_INCREMENT," +
+ " `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00'," +
+ " `update_reason` text COMMENT '电池信息更改原因'," +
+ " `update_name` varchar(20) DEFAULT ' ' COMMENT '更改人'," +
+ " `StationId` varchar(20) DEFAULT '0'," +
+ " `StationId_ex` varchar(20) DEFAULT '0'," +
+ " `StationName` varchar(100) DEFAULT ' '," +
+ " `StationName1` varchar(100) DEFAULT ' '," +
+ " `StationName2` varchar(100) DEFAULT ' '," +
+ " `StationName3` varchar(100) DEFAULT ' '," +
+ " `StationName4` varchar(100) DEFAULT ' '," +
+ " `StationName5` varchar(100) DEFAULT ' '," +
+ " `StationName6` varchar(100) DEFAULT ' '," +
+ " `StationName7` varchar(100) DEFAULT ' '," +
+ " `StationName8` varchar(100) DEFAULT ' '," +
+ " `StationName9` varchar(100) DEFAULT ' '," +
+ " `StationIP` varchar(20) DEFAULT '0'," +
+ " `FBSDeviceId` bigint(11) DEFAULT '0'," +
+ " `FBSDeviceIp` varchar(50) DEFAULT '192.168.0.88'," +
+ " `FBSDeviceIp_WG` varchar(64) DEFAULT '192.168.0.1'," +
+ " `FBSDeviceIp_YM` varchar(64) DEFAULT '255.255.255.0'," +
+ " `FBSDeviceName` varchar(100) DEFAULT '0'," +
+ " `GroupIndexInFBSDevice` int(11) DEFAULT '0'," +
+ " `BattModel` varchar(100) DEFAULT ' '," +
+ " `BattGroupId` int(11) DEFAULT '0'," +
+ " `BattGroupNum` int(11) DEFAULT '0'," +
+ " `BattGroupName` varchar(100) DEFAULT ' '," +
+ " `BattGroupName1` varchar(100) DEFAULT ' '," +
+ " `BattGroupName2` varchar(100) DEFAULT ' '," +
+ " `BattGroupName3` varchar(100) DEFAULT ' '," +
+ " `BattGroupName4` varchar(100) DEFAULT ' '," +
+ " `BattGroupName5` varchar(100) DEFAULT ' '," +
+ " `BattGroupName6` varchar(100) DEFAULT ' '," +
+ " `FloatVolLevel` float DEFAULT '1.12'," +
+ " `OfflineVolLevel` float DEFAULT '1.06'," +
+ " `BattFloatCurrent` float DEFAULT '0'," +
+ " `DeviceId` varchar(20) DEFAULT '0'," +
+ " `DeviceName` varchar(100) DEFAULT '0'," +
+ " `MonCount` int(11) DEFAULT '0'," +
+ " `MonCapStd` float DEFAULT '0'," +
+ " `MonVolStd` float DEFAULT '0'," +
+ " `MonResStd` float DEFAULT '0'," +
+ " `MonSerStd` float DEFAULT '0'," +
+ " `MonTmpStd` float DEFAULT '0'," +
+ " `MonVolLowToAvg` float DEFAULT '0'," +
+ " `MonNum` int(11) DEFAULT '0'," +
+ " `BattProducer` varchar(45) DEFAULT '0'," +
+ " `BattProductDate` date DEFAULT '2006-07-06'," +
+ " `BattInUseDate` date DEFAULT '2006-07-06'," +
+ " `BattGuarantDayCount` int(11) DEFAULT '1095'," +
+ " `SignalId` varchar(20) DEFAULT '0'," +
+ " `CInterFaceId` int(11) DEFAULT '0'," +
+ " `SignalName` varchar(50) DEFAULT '0'," +
+ " `Load_curr` float DEFAULT '15'," +
+ " `DisCurrMax` float DEFAULT '0'," +
+ " `station_phone` varchar(32) DEFAULT ''," +
+ " `station_install` tinyint(1) DEFAULT '0'," +
+ " `install_user` varchar(64) DEFAULT ''," +
+ " `charge_curr_max` float DEFAULT '20'," +
+ " `Vol_grade` float DEFAULT '0'," +
+ " `Manufacturers` varchar(64) DEFAULT ''," +
+ " `Assetequipment` varchar(64) DEFAULT ''," +
+ " `Deviceclasspath` varchar(64) DEFAULT ''," +
+ " `DeviceOperationDepartment` varchar(64) DEFAULT ''," +
+ " `PropertyRightUnit` varchar(64) DEFAULT ''," +
+ " `PropertyAttribute` varchar(64) DEFAULT ''," +
+ " `FactoryNumber` varchar(64) DEFAULT ''," +
+ " `OperationTeam` varchar(64) DEFAULT ''," +
+ " `DeviceIdentityCode` varchar(64) DEFAULT ''," +
+ " `ProjectType` varchar(64) DEFAULT ''," +
+ " `BatteryApplicationType` varchar(64) DEFAULT ''," +
+ " `SingleRatedVoltage` float DEFAULT '0'," +
+ " `RemoteMonitor` varchar(64) DEFAULT ''," +
+ " `BatttIndependentPlaced` varchar(64) DEFAULT ''," +
+ " `JunChargeVoltageValue` float DEFAULT '0'," +
+ " `PublicKeyX` varchar(200) DEFAULT ''," +
+ " `PublicKeyY` varchar(200) DEFAULT ''," +
+ " `KeyID` varchar(200) DEFAULT ''," +
+ " `SerialNumber` varchar(200) DEFAULT ''," +
+ " `sort_id` int(3) DEFAULT '0'," +
+ " `video_url` varchar(200) DEFAULT NULL," +
+ " `charge_type` int(11) DEFAULT '1' COMMENT '充放电状态：1:限流充电；2；逆变充电'," +
+ " `buscouple_state` int(11) DEFAULT '0' COMMENT '母联状态：0：无母联；1:有母联'," +
+ " `tmp_id` int(11) DEFAULT '0'," +
+ " `price_factor` float DEFAULT '1' COMMENT '电价系数'," +
+ " `smps_brand` varchar(50) DEFAULT NULL COMMENT '开关电源品牌'," +
+ " `smps_model` varchar(50) DEFAULT NULL COMMENT '开关电源型号'," +
+ " `PackCount` int(11) DEFAULT '1' COMMENT '锂电池包数量'," +
+ " `dev_num` varchar(255) NOT NULL DEFAULT '0' COMMENT '设备编号[a059用于标识设备]'," +
+ " `mId` bigint(20) DEFAULT '0' COMMENT '二维码信息标识位'," +
+ " `cellShowType` int(11) NOT NULL DEFAULT '0' COMMENT '电池类型[0：铅酸 1：锂电]'," +
+ " `NomCapWH` float NOT NULL DEFAULT '0' COMMENT '标称容量[KWH]'," +
+ " `NomCapAH` float NOT NULL DEFAULT '0' COMMENT '标称容量AH'," +
+ " `LoadCurrFromDis` float NOT NULL DEFAULT '0' COMMENT '负载电流-[来源核容放电数据]'," +
+ " `NodeStation` int(11) NOT NULL DEFAULT '0' COMMENT '节点站标识:0:不是节点站[默认] 1:节点站'," +
+ " `StationType` varchar(255) DEFAULT NULL COMMENT '站点类型[例如110V/22V]'," +
+ " PRIMARY KEY (`num`)" +
+ ") ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;";
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ try {
+ if(true == recreate) {
+ //sql.sqlMysqlExecute(sql_str01);
+ }
+ sql.sqlMysqlExecute(sql_str02);
+
+ } catch (SQLException e) {
+ e.printStackTrace();
+ } finally {
+ sql.close_con();
+ }
+ }
/**
* 创建 tb_batt_maint_inf 表
--
Gitblit v1.9.1