1ALTER TABLE `groups` CHANGE `entity_type` `entity_type` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ; 2UPDATE `alert_tests` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers'; 3UPDATE `alert_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers'; 4UPDATE `groups` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers'; 5UPDATE `alert_log` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers'; 6UPDATE `group_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers'; 7UPDATE `groups_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers'; 8UPDATE `alert_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers'; 9UPDATE `alert_tests` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver'; 10UPDATE `alert_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver'; 11UPDATE `groups` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver'; 12UPDATE `alert_log` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver'; 13UPDATE `group_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver'; 14UPDATE `groups_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver'; 15UPDATE `alert_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver'; 16UPDATE `alert_tests` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc'; 17UPDATE `alert_table` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc'; 18UPDATE `groups` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc'; 19UPDATE `alert_log` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc'; 20UPDATE `group_table` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc'; 21UPDATE `groups_assoc` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc'; 22UPDATE `alert_assoc` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc'; 23UPDATE `alert_tests` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem'; 24UPDATE `alert_table` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem'; 25UPDATE `groups` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem'; 26UPDATE `alert_log` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem'; 27UPDATE `group_table` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem'; 28UPDATE `groups_assoc` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem'; 29UPDATE `alert_assoc` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem'; 30 31