-- 1、b_notice_timely details字段修改长度为20000
ALTER TABLE `cloud_backend_monitor`.`b_notice_timely` 
MODIFY COLUMN `details` varchar(20000)  COMMENT '内容sql' AFTER `noticeNames`;

-- 2、系统及时消息配置，每半个小时提示一次，当前告警量统计，给admi和root 
INSERT INTO `cloud_backend_monitor`.`b_notice_timely` (`id`, `name`, `type`, `state`, `noticeNames`, `details`, `frequency`, `site`, `voice`, `retry`, `retryTime`, `sendState`, `broadcast`) VALUES ('5272b3bbf8e444388dec024f00bfc068', '当前告警统计', 'sql', 2, 'admin,root', 'select CONCAT(\'当前告警总数：\',(select count(1) as count from b_alarm) ,\'</br>\',(select GROUP_CONCAT(str) from (select CONCAT( CONCAT(alarmLevelName,\': \'),count(1)) as str   from b_alarm GROUP BY alarmLevelName order by alarmLevel DESC) b),\'。\') as count ', '0 0/30 * * * ?', '', '咳咳', 1, '1', 1, 2);