1ALTER TABLE `alert_rules` ADD `query_builder` TEXT NOT NULL AFTER `query`; 2CREATE TABLE `alert_group_map` (`id` INT PRIMARY KEY AUTO_INCREMENT, `rule_id` INT NOT NULL, `group_id` INT NOT NULL); 3CREATE UNIQUE INDEX `alert_group_map_rule_id_group_id_uindex` ON `alert_group_map` (`rule_id`, `group_id`); 4INSERT INTO `alert_group_map` (`rule_id`, `group_id`) SELECT `rule`, SUBSTRING(`target`, 2) as `group_id` FROM `alert_map` WHERE `target` LIKE 'g%'; 5DELETE FROM `alert_map` WHERE `target` LIKE 'g%'; 6ALTER TABLE `alert_map` CHANGE `rule` `rule_id` INT(11) NOT NULL; 7ALTER TABLE `alert_map` CHANGE `target` `device_id` INT(11) NOT NULL; 8ALTER TABLE `alert_map` RENAME TO `alert_device_map`; 9CREATE UNIQUE INDEX `alert_device_map_rule_id_device_id_uindex` ON `alert_device_map` (`rule_id`, `device_id`); 10INSERT INTO `alert_device_map` (`rule_id`, `device_id`) SELECT `id`, `device_id` FROM `alert_rules` WHERE `device_id` != -1; 11ALTER TABLE `alert_rules` DROP COLUMN `device_id`; 12