   PRIMARY KEY  (`service_id`),
   UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`service_object_id`),
   KEY `host_object_id` (`host_object_id`),
-  KEY `service_object_id` (`service_object_id`),
-  KEY `service_object_id_2` (`service_object_id`)
+  KEY `service_object_id` (`service_object_id`)
 ) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='Service definitions' AUTO_INCREMENT=1 ;
 
 -- --------------------------------------------------------

  KEY `current_state` (`current_state`),
  KEY `instance_id` (`instance_id`),
  KEY `status_update_time` (`status_update_time`),
  KEY `current_state_2` (`current_state`),
  KEY `check_type` (`check_type`),
  KEY `state_type` (`state_type`),
  KEY `last_state_change` (`last_state_change`),

  PRIMARY KEY  (`host_id`),
  UNIQUE KEY `instance_id` (`instance_id`,`config_type`,`host_object_id`),
  KEY `host_object_id` (`host_object_id`),
  KEY `display_name` (`display_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 COMMENT='Host definitions' AUTO_INCREMENT=1 ;

-- --------------------------------------------------------
