ALTER TABLE `nagios_hosts` ADD `alias` VARCHAR( 64 ) NOT NULL AFTER `host_object_id` ; -- BEGIN 1.4b5 MODS -- -- Table structure for table `nagios_host_contactgroups` -- CREATE TABLE IF NOT EXISTS `nagios_host_contactgroups` ( `host_contactgroup_id` int(11) NOT NULL auto_increment, `instance_id` smallint(6) NOT NULL default '0', `host_id` int(11) NOT NULL default '0', `contactgroup_object_id` int(11) NOT NULL default '0', PRIMARY KEY (`host_contactgroup_id`), UNIQUE KEY `instance_id` (`host_id`,`contactgroup_object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Host contact groups'; -- -------------------------------------------------------- -- -- Table structure for table `nagios_hostescalation_contactgroups` -- CREATE TABLE IF NOT EXISTS `nagios_hostescalation_contactgroups` ( `hostescalation_contactgroup_id` int(11) NOT NULL auto_increment, `instance_id` smallint(6) NOT NULL default '0', `hostescalation_id` int(11) NOT NULL default '0', `contactgroup_object_id` int(11) NOT NULL default '0', PRIMARY KEY (`hostescalation_contactgroup_id`), UNIQUE KEY `instance_id` (`hostescalation_id`,`contactgroup_object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Host escalation contact groups'; -- -------------------------------------------------------- -- -- Table structure for table `nagios_service_contactgroups` -- CREATE TABLE IF NOT EXISTS `nagios_service_contactgroups` ( `service_contactgroup_id` int(11) NOT NULL auto_increment, `instance_id` smallint(6) NOT NULL default '0', `service_id` int(11) NOT NULL default '0', `contactgroup_object_id` int(11) NOT NULL default '0', PRIMARY KEY (`service_contactgroup_id`), UNIQUE KEY `instance_id` (`service_id`,`contactgroup_object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Service contact groups'; -- -------------------------------------------------------- -- -- Table structure for table `nagios_serviceescalation_contactgroups` -- CREATE TABLE IF NOT EXISTS `nagios_serviceescalation_contactgroups` ( `serviceescalation_contactgroup_id` int(11) NOT NULL auto_increment, `instance_id` smallint(6) NOT NULL default '0', `serviceescalation_id` int(11) NOT NULL default '0', `contactgroup_object_id` int(11) NOT NULL default '0', PRIMARY KEY (`serviceescalation_contactgroup_id`), UNIQUE KEY `instance_id` (`serviceescalation_id`,`contactgroup_object_id`) ) ENGINE=MyISAM DEFAULT CHARSET=ascii COMMENT='Service escalation contact groups'; -- -------------------------------------------------------- ALTER TABLE `nagios_acknowledgements` TYPE = innodb; ALTER TABLE `nagios_commands` TYPE = innodb; ALTER TABLE `nagios_commenthistory` TYPE = innodb; ALTER TABLE `nagios_comments` TYPE = innodb; ALTER TABLE `nagios_configfiles` TYPE = innodb; ALTER TABLE `nagios_configfilevariables` TYPE = innodb; ALTER TABLE `nagios_conninfo` TYPE = innodb; ALTER TABLE `nagios_contact_addresses` TYPE = innodb; ALTER TABLE `nagios_contact_notificationcommands` TYPE = innodb; ALTER TABLE `nagios_contactgroup_members` TYPE = innodb; ALTER TABLE `nagios_contactgroups` TYPE = innodb; ALTER TABLE `nagios_contactnotificationmethods` TYPE = innodb; ALTER TABLE `nagios_contactnotifications` TYPE = innodb; ALTER TABLE `nagios_contacts` TYPE = innodb; ALTER TABLE `nagios_contactstatus` TYPE = innodb; ALTER TABLE `nagios_customvariables` TYPE = innodb; ALTER TABLE `nagios_customvariablestatus` TYPE = innodb; ALTER TABLE `nagios_dbversion` TYPE = innodb; ALTER TABLE `nagios_downtimehistory` TYPE = innodb; ALTER TABLE `nagios_eventhandlers` TYPE = innodb; ALTER TABLE `nagios_externalcommands` TYPE = innodb; ALTER TABLE `nagios_flappinghistory` TYPE = innodb; ALTER TABLE `nagios_host_contactgroups` TYPE = innodb; ALTER TABLE `nagios_host_contacts` TYPE = innodb; ALTER TABLE `nagios_host_parenthosts` TYPE = innodb; ALTER TABLE `nagios_hostchecks` TYPE = innodb; ALTER TABLE `nagios_hostdependencies` TYPE = innodb; ALTER TABLE `nagios_hostescalation_contactgroups` TYPE = innodb; ALTER TABLE `nagios_hostescalation_contacts` TYPE = innodb; ALTER TABLE `nagios_hostescalations` TYPE = innodb; ALTER TABLE `nagios_hostgroup_members` TYPE = innodb; ALTER TABLE `nagios_hostgroups` TYPE = innodb; ALTER TABLE `nagios_hosts` TYPE = innodb; ALTER TABLE `nagios_hoststatus` TYPE = innodb; ALTER TABLE `nagios_instances` TYPE = innodb; ALTER TABLE `nagios_logentries` TYPE = innodb; ALTER TABLE `nagios_notifications` TYPE = innodb; ALTER TABLE `nagios_objects` TYPE = innodb; ALTER TABLE `nagios_processevents` TYPE = innodb; ALTER TABLE `nagios_programstatus` TYPE = innodb; ALTER TABLE `nagios_runtimevariables` TYPE = innodb; ALTER TABLE `nagios_scheduleddowntime` TYPE = innodb; ALTER TABLE `nagios_service_contactgroups` TYPE = innodb; ALTER TABLE `nagios_service_contacts` TYPE = innodb; ALTER TABLE `nagios_servicechecks` TYPE = innodb; ALTER TABLE `nagios_servicedependencies` TYPE = innodb; ALTER TABLE `nagios_serviceescalation_contactgroups` TYPE = innodb; ALTER TABLE `nagios_serviceescalation_contacts` TYPE = innodb; ALTER TABLE `nagios_serviceescalations` TYPE = innodb; ALTER TABLE `nagios_servicegroup_members` TYPE = innodb; ALTER TABLE `nagios_servicegroups` TYPE = innodb; ALTER TABLE `nagios_services` TYPE = innodb; ALTER TABLE `nagios_servicestatus` TYPE = innodb; ALTER TABLE `nagios_statehistory` TYPE = innodb; ALTER TABLE `nagios_systemcommands` TYPE = innodb; ALTER TABLE `nagios_timedeventqueue` TYPE = innodb; ALTER TABLE `nagios_timedevents` TYPE = innodb; ALTER TABLE `nagios_timeperiod_timeranges` TYPE = innodb; ALTER TABLE `nagios_timeperiods` TYPE = innodb; ALTER TABLE `nagios_statehistory` ADD `last_state` SMALLINT DEFAULT '-1' NOT NULL AFTER `max_check_attempts` , ADD `last_hard_state` SMALLINT DEFAULT '-1' NOT NULL AFTER `last_state` ; -- END 1.4b5 MODS -- BEGIN 1.4b7 MODS ALTER TABLE `nagios_configfilevariables` DROP INDEX `instance_id`; ALTER TABLE `nagios_configfilevariables` ADD INDEX ( `instance_id` , `configfile_id` ) ; ALTER TABLE `nagios_timedeventqueue` ADD INDEX ( `instance_id` ) ; ALTER TABLE `nagios_statehistory` ADD INDEX ( `instance_id` , `object_id` ) ; ALTER TABLE `nagios_servicestatus` ADD INDEX ( `instance_id` , `service_object_id` ) ; ALTER TABLE `nagios_processevents` ADD INDEX ( `instance_id` , `event_type` ) ; ALTER TABLE `nagios_logentries` ADD INDEX ( `instance_id` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `instance_id` , `host_object_id` ) ; ALTER TABLE `nagios_flappinghistory` ADD INDEX ( `instance_id` , `object_id` ) ; ALTER TABLE `nagios_externalcommands` ADD INDEX ( `instance_id` ) ; ALTER TABLE `nagios_customvariablestatus` ADD INDEX ( `instance_id` ) ; ALTER TABLE `nagios_contactstatus` ADD INDEX ( `instance_id` ) ; ALTER TABLE `nagios_conninfo` ADD INDEX ( `instance_id` ) ; ALTER TABLE `nagios_acknowledgements` ADD INDEX ( `instance_id` , `object_id` ) ; ALTER TABLE `nagios_objects` ADD INDEX ( `instance_id` ) ; ALTER TABLE `nagios_logentries` ADD INDEX ( `logentry_time` ) ; ALTER TABLE `nagios_commenthistory` CHANGE `comment_data` `comment_data` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_comments` CHANGE `comment_data` `comment_data` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_downtimehistory` CHANGE `comment_data` `comment_data` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_externalcommands` CHANGE `command_args` `command_args` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_hostchecks` CHANGE `output` `output` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_hostchecks` CHANGE `perfdata` `perfdata` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_hoststatus` CHANGE `output` `output` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_hoststatus` CHANGE `perfdata` `perfdata` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_logentries` CHANGE `logentry_data` `logentry_data` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_scheduleddowntime` CHANGE `comment_data` `comment_data` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_servicechecks` CHANGE `output` `output` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_servicechecks` CHANGE `perfdata` `perfdata` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_servicestatus` CHANGE `output` `output` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_servicestatus` CHANGE `perfdata` `perfdata` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_statehistory` CHANGE `output` `output` TEXT CHARACTER SET ascii COLLATE ascii_general_ci NOT NULL ; ALTER TABLE `nagios_processevents` ADD INDEX ( `event_time` , `event_time_usec` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `current_state` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `state_type` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `last_check` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `notifications_enabled` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `problem_has_been_acknowledged` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `passive_checks_enabled` ) ; ALTER TABLE `nagios_hoststatus` ADD INDEX ( `active_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 ( `scheduled_downtime_depth` ) ; ALTER TABLE `nagios_servicestatus` ADD INDEX ( `current_state` ) ; ALTER TABLE `nagios_servicestatus` ADD INDEX ( `last_check` ) ; ALTER TABLE `nagios_servicestatus` ADD INDEX ( `notifications_enabled` ) ; ALTER TABLE `nagios_servicestatus` ADD INDEX ( `problem_has_been_acknowledged` ) ; ALTER TABLE `nagios_servicestatus` ADD INDEX ( `passive_checks_enabled` ) ; ALTER TABLE `nagios_servicestatus` ADD INDEX ( `active_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 ( `scheduled_downtime_depth` ) ; ALTER TABLE `nagios_statehistory` ADD INDEX ( `state_time` , `state_time_usec` ) ; ALTER TABLE `nagios_timedeventqueue` ADD INDEX ( `event_type` ) ; ALTER TABLE `nagios_timedeventqueue` ADD INDEX ( `scheduled_time` ) ; ALTER TABLE `nagios_logentries` ADD INDEX ( `entry_time` ) ; ALTER TABLE `nagios_logentries` ADD INDEX ( `entry_time_usec` ) ; ALTER TABLE `nagios_externalcommands` ADD INDEX ( `entry_time` ) ; -- END 1.4b7 MODS