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