From 6b1bcd3537d3b412296c4db4a4079137231fb3f4 Mon Sep 17 00:00:00 2001 From: DELL <1525436766@qq.com> Date: 星期三, 03 七月 2024 16:51:17 +0800 Subject: [PATCH] 3.新增表 'db_rab_db.tb_dev_6185_almparam' CREATE TABLE `tb_dev_6185_almparam` ( `num` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增主键', `dev_id` int(11) NOT NULL DEFAULT '0' COMMENT '设备id', `op_cmd` int(11) NOT NULL DEFAULT '0' COMMENT '操作命令', `groupvol_high_val` float NOT NULL DEFAULT '0' COMMENT '组端电压高阈值', `groupvol_low_val` float NOT NULL DEFAULT '0' COMMENT '组端电压低阈值', `monvol_high_val` float NOT NULL DEFAULT '0' COMMENT '单体电压高阈值', `monvol_low_val` float NOT NULL DEFAULT '0' COMMENT '单体电压低阈值', `montmp_high_val` float NOT NULL DEFAULT '0' COMMENT '单体温度高阈值', `montmp_low_val` float NOT NULL DEFAULT '0' COMMENT '单体温度低阈值', `monres_high_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻高阈值', `monres_low_val` float NOT NULL DEFAULT '0' COMMENT '单体内阻低阈值', `moncap_high_val` float NOT NULL DEFAULT '0' COMMENT '单体容量高阈值', `moncap_low_val` float NOT NULL DEFAULT '0' COMMENT '单体容量低阈值', PRIMARY KEY (`num`), UNIQUE KEY `index_dev_id` (`dev_id`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='bts6185相关设备告警阈值遥调表'; --- BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java | 4 +++- 1 files changed, 3 insertions(+), 1 deletions(-) diff --git a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java index 6be80f6..5316e4b 100644 --- a/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java +++ b/BattMonitor_DB_Builder/src/com/sql/Sql_Mysql.java @@ -174,7 +174,9 @@ 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"; //充放电一体机离线检测表 + public final static String IntelligentBusbar_State_Table = DB_RamDB + ".tb_intelligentbusbar_state"; //充放电一体机离线检测表 + + public final static String Dev_6185_AlmpPram_Table = DB_RamDB + ".tb_dev_6185_almparam"; //BTS61850告警参数表 /**************************** db_user数据库 ***************************************************/ -- Gitblit v1.9.1