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相关设备告警阈值遥调表';