From ac985f8bb4d214cdb24f741179cabf30516ab96d Mon Sep 17 00:00:00 2001 From: DELL <1525436766@qq.com> Date: 星期四, 25 四月 2024 13:51:31 +0800 Subject: [PATCH] CREATE TABLE `tb_intelligentbusbar_state` ( `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备ID', `record_time` datetime NOT NULL DEFAULT '2000-01-01 00:00:00' COMMENT '记录时间', `dcdc1_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC1_实时温度', `dcdc2_temp` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时温度', `dcdc1_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电压', `dcdc2_outputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电压', `dcdc1_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输出电流', `dcdc2_outputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输出电流', `dcdc1_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电压', `dcdc2_inputvol` float NOT NULL DEFAULT '0' COMMENT 'DCDC2实时输入电压', `dcdc1_inputcurr` float NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流', `dcdc2_inputcurr` float unsigned NOT NULL DEFAULT '0' COMMENT 'DCDC1实时输入电流', `dcdc1_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC1 异常代码-状态', `dcdc2_errcode` int(11) NOT NULL DEFAULT '0' COMMENT 'DCDC2 异常代码-状态', PRIMARY KEY (`num`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='智能母联实时状态表'; --- 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 2e6cd5d..6be80f6 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -174,6 +174,7 @@ public final static String FBS9140_Topology_State = DB_RamDB + ".tb_fbs9140_topology_state"; //并联BTS拓扑状态信息 public final static String FBS9149_SetParam = DB_RamDB + ".tb_fbs9149_setparam"; //并联BTS9组参数表 public final static String Check_Dialog_Table = DB_RamDB + ".tb_check_dialog"; //充放电一体机离线检测表 + public final static String IntelligentBusbar_State_Table = DB_RamDB + ".tb_intelligentbusbar_state"; //充放电一体机离线检测表 /**************************** db_user数据库 ***************************************************/ -- Gitblit v1.9.1