31 lines
2.9 KiB
SQL
31 lines
2.9 KiB
SQL
ALTER TABLE `groups` CHANGE `entity_type` `entity_type` VARCHAR( 32 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ;
|
|
UPDATE `alert_tests` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers';
|
|
UPDATE `alert_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers';
|
|
UPDATE `groups` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers';
|
|
UPDATE `alert_log` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers';
|
|
UPDATE `group_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers';
|
|
UPDATE `groups_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers';
|
|
UPDATE `alert_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vservers';
|
|
UPDATE `alert_tests` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver';
|
|
UPDATE `alert_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver';
|
|
UPDATE `groups` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver';
|
|
UPDATE `alert_log` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver';
|
|
UPDATE `group_table` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver';
|
|
UPDATE `groups_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver';
|
|
UPDATE `alert_assoc` SET `entity_type` = 'netscalervsvr' WHERE `entity_type` = 'netscaler_vserver';
|
|
UPDATE `alert_tests` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc';
|
|
UPDATE `alert_table` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc';
|
|
UPDATE `groups` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc';
|
|
UPDATE `alert_log` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc';
|
|
UPDATE `group_table` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc';
|
|
UPDATE `groups_assoc` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc';
|
|
UPDATE `alert_assoc` SET `entity_type` = 'netscalersvc' WHERE `entity_type` = 'netscaler_svc';
|
|
UPDATE `alert_tests` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem';
|
|
UPDATE `alert_table` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem';
|
|
UPDATE `groups` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem';
|
|
UPDATE `alert_log` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem';
|
|
UPDATE `group_table` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem';
|
|
UPDATE `groups_assoc` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem';
|
|
UPDATE `alert_assoc` SET `entity_type` = 'netscalersvcgrpmem' WHERE `entity_type` = 'netscaler_svcgrpmem';
|
|
|