38 lines
2.2 KiB
SQL
38 lines
2.2 KiB
SQL
ALTER TABLE `data_alarm_push_condition`
|
|
ADD COLUMN `tiger_num` int(10) UNSIGNED NULL DEFAULT 1 COMMENT '多少次报警触发' AFTER `push_object`,
|
|
ADD COLUMN `sent_num` int(10) UNSIGNED NULL DEFAULT 1 COMMENT '发送次数（发送对应次数后使用）' AFTER `tiger_num`,
|
|
ADD COLUMN `interval_time` decimal(5,2) UNSIGNED NULL DEFAULT 0 COMMENT '间隔时间（小时）' AFTER `sent_num`,
|
|
ADD COLUMN `alarm_num` int(10) NULL DEFAULT 0 COMMENT '告警次数，用于统计多少次告警了' AFTER `interval_time`,
|
|
ADD COLUMN `has_sent_num` int(10) UNSIGNED NULL DEFAULT 0 COMMENT '已经发送次数' AFTER `alarm_num`;
|
|
ADD COLUMN `push_param` text NULL COMMENT '推送参数' AFTER `has_sent_num`;
|
|
ADD COLUMN `service_provider` varchar(40) NULL COMMENT '服务方' AFTER `push_param`;
|
|
|
|
|
|
ALTER TABLE `data_alarm_push_record`
|
|
ADD COLUMN `alarm_key` varchar(50) NULL COMMENT '告警key' AFTER `alarm_time`;
|
|
|
|
ALTER TABLE `data_alarm_push_record`
|
|
ADD COLUMN `alarm_rule` text NULL COMMENT '推送规则' AFTER `contact_add`;
|
|
ALTER TABLE `fourfaith_application_parent`.`data_alarm_push_record`
|
|
CHANGE COLUMN `alarm_key` `alarm_value` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警key' AFTER `alarm_time`;
|
|
ALTER TABLE `fourfaith_application_parent`.`data_alarm_push_record`
|
|
MODIFY COLUMN `alarm_value` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '告警value' AFTER `alarm_time`,
|
|
ADD COLUMN `alarm_key` varchar(50) NULL COMMENT '告警key' AFTER `alarm_rule`;
|
|
|
|
ALTER TABLE `data_device_monitor_rel`
|
|
DROP COLUMN `monitor_point_name`,
|
|
ADD COLUMN `monitor_point_name` varchar(40) NULL COMMENT '测点名称' AFTER `monitor_point_id`;
|
|
|
|
|
|
ALTER TABLE `data_device_monitor_rel`
|
|
ADD COLUMN `monitor_tags_name` varchar(40) NULL COMMENT '水库名称 结构名称' AFTER `monitor_point_name`;
|
|
|
|
|
|
ALTER TABLE `data_device_monitor_formula`
|
|
ADD COLUMN `init_json` varchar(255) NULL COMMENT '初始值(json)' AFTER `request_url`,
|
|
ADD COLUMN `init_flag` tinyint(1) NULL COMMENT '初值是否已经使用1使用 0未使用' AFTER `init_json`;
|
|
|
|
ALTER TABLE `data_alarm_push_record`
|
|
ADD COLUMN `push_rule` text NULL COMMENT '推送规则' AFTER `alarm_key`;
|
|
|