; 05/03/08 ALTER TABLE `nagios_hosts` ADD INDEX ( `host_object_id` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `instance_id` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `status_update_time` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `current_state` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `check_type` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `state_type` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `last_state_change` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `notifications_enabled` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `problem_has_been_acknowledged` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `active_checks_enabled` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `passive_checks_enabled` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `event_handler_enabled` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `flap_detection_enabled` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `is_flapping` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `percent_state_change` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `latency` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `execution_time` ); ALTER TABLE `nagios_hoststatus` ADD INDEX ( `scheduled_downtime_depth` ); ALTER TABLE `nagios_services` ADD INDEX ( `service_object_id` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `instance_id` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `status_update_time` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `current_state` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `check_type` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `state_type` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `last_state_change` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `notifications_enabled` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `problem_has_been_acknowledged` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `active_checks_enabled` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `passive_checks_enabled` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `event_handler_enabled` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `flap_detection_enabled` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `is_flapping` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `percent_state_change` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `latency` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `execution_time` ); ALTER TABLE `nagios_servicestatus` ADD INDEX ( `scheduled_downtime_depth` ); ALTER TABLE `nagios_timedeventqueue` ADD INDEX ( `instance_id` ); ALTER TABLE `nagios_timedeventqueue` ADD INDEX ( `event_type` ); ALTER TABLE `nagios_timedeventqueue` ADD INDEX ( `scheduled_time` ); ALTER TABLE `nagios_timedeventqueue` ADD INDEX ( `object_id` ); ALTER TABLE `nagios_timedevents` DROP INDEX `instance_id` ; ALTER TABLE `nagios_timedevents` ADD INDEX ( `instance_id` ); ALTER TABLE `nagios_timedevents` ADD INDEX ( `event_type` ); ALTER TABLE `nagios_timedevents` ADD INDEX ( `scheduled_time` ); ALTER TABLE `nagios_timedevents` ADD INDEX ( `object_id` ); ALTER TABLE `nagios_systemcommands` DROP INDEX `instance_id`; ALTER TABLE `nagios_systemcommands` ADD INDEX ( `instance_id` ); ALTER TABLE `nagios_servicechecks` DROP INDEX `instance_id`; ALTER TABLE `nagios_servicechecks` ADD INDEX ( `instance_id` ); ALTER TABLE `nagios_servicechecks` ADD INDEX ( `service_object_id` ); ALTER TABLE `nagios_servicechecks` ADD INDEX ( `start_time` ); ALTER TABLE `nagios_configfilevariables` DROP INDEX `instance_id`;