evolix
/
lilac
Archived
21
0
Fork 0
Code Issues Pull Requests Releases Wiki Activity
This repository has been archived on 2020-01-20. You can view files and clone it, but cannot push or open issues or pull requests.
lilac/sqldata/schema.sql

1701 lines
55 KiB
SQL
Executable File
Raw Permalink Blame History

# This is a fix for InnoDB in MySQL >= 4.1.x
# It "suspends judgement" for fkey relationships until are tables are set.
SET FOREIGN_KEY_CHECKS = 0;
#-----------------------------------------------------------------------------
#-- lilac_configuration
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `lilac_configuration`;
CREATE TABLE `lilac_configuration`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`version` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Lilac Configuration';
#-----------------------------------------------------------------------------
#-- import_job
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `import_job`;
CREATE TABLE `import_job`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`description` VARCHAR(255) NOT NULL,
`config` TEXT NOT NULL,
`start_time` DATETIME,
`end_time` DATETIME,
`status` VARCHAR(255),
`status_code` INTEGER NOT NULL,
`status_change_time` DATETIME,
`stats` TEXT NOT NULL,
`cmd` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Import Job Information';
#-----------------------------------------------------------------------------
#-- export_job
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `export_job`;
CREATE TABLE `export_job`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`description` VARCHAR(255) NOT NULL,
`config` TEXT NOT NULL,
`start_time` DATETIME,
`end_time` DATETIME,
`status` VARCHAR(255),
`status_code` INTEGER NOT NULL,
`status_change_time` DATETIME,
`stats` TEXT NOT NULL,
`cmd` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Export Job Information';
#-----------------------------------------------------------------------------
#-- export_log_entry
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `export_log_entry`;
CREATE TABLE `export_log_entry`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`job` INTEGER,
`time` DATETIME NOT NULL,
`text` TEXT NOT NULL,
`type` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `export_log_entry_FI_1` (`job`),
CONSTRAINT `export_log_entry_FK_1`
FOREIGN KEY (`job`)
REFERENCES `export_job` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Export Job Entry';
#-----------------------------------------------------------------------------
#-- import_log_entry
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `import_log_entry`;
CREATE TABLE `import_log_entry`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`job` INTEGER,
`time` DATETIME NOT NULL,
`text` TEXT NOT NULL,
`type` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `import_log_entry_FI_1` (`job`),
CONSTRAINT `import_log_entry_FK_1`
FOREIGN KEY (`job`)
REFERENCES `import_job` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Import Job Entry';
#-----------------------------------------------------------------------------
#-- label
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `label`;
CREATE TABLE `label`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`section` VARCHAR(255),
`name` VARCHAR(255),
`label` TEXT,
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Language based labels';
#-----------------------------------------------------------------------------
#-- nagios_broker_module
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_broker_module`;
CREATE TABLE `nagios_broker_module`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`line` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Event Broker Modules';
#-----------------------------------------------------------------------------
#-- nagios_cgi_configuration
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_cgi_configuration`;
CREATE TABLE `nagios_cgi_configuration`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`physical_html_path` VARCHAR(255),
`url_html_path` VARCHAR(255),
`use_authentication` TINYINT,
`default_user_name` VARCHAR(255),
`authorized_for_system_information` VARCHAR(255),
`authorized_for_system_commands` VARCHAR(255),
`authorized_for_configuration_information` VARCHAR(255),
`authorized_for_all_hosts` VARCHAR(255),
`authorized_for_all_host_commands` VARCHAR(255),
`authorized_for_all_services` VARCHAR(255),
`authorized_for_all_service_commands` VARCHAR(255),
`lock_author_names` TINYINT,
`statusmap_background_image` VARCHAR(255),
`default_statusmap_layout` TINYINT,
`statuswrl_include` VARCHAR(255),
`default_statuswrl_layout` TINYINT,
`refresh_rate` INTEGER,
`host_unreachable_sound` VARCHAR(255),
`host_down_sound` VARCHAR(255),
`service_critical_sound` VARCHAR(255),
`service_warning_sound` VARCHAR(255),
`service_unknown_sound` VARCHAR(255),
`ping_syntax` VARCHAR(255),
`escape_html_tags` TINYINT,
`notes_url_target` VARCHAR(255),
`action_url_target` VARCHAR(255),
`enable_splunk_integration` TINYINT,
`splunk_url` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='CGI Configuration';
#-----------------------------------------------------------------------------
#-- nagios_command
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_command`;
CREATE TABLE `nagios_command`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`line` TEXT NOT NULL,
`description` TEXT(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Nagios Command';
#-----------------------------------------------------------------------------
#-- nagios_timeperiod
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_timeperiod`;
CREATE TABLE `nagios_timeperiod`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Nagios Timeperiods';
#-----------------------------------------------------------------------------
#-- nagios_timeperiod_entry
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_timeperiod_entry`;
CREATE TABLE `nagios_timeperiod_entry`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`timeperiod_id` INTEGER,
`entry` VARCHAR(255) NOT NULL,
`value` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_timeperiod_entry_FI_1` (`timeperiod_id`),
CONSTRAINT `nagios_timeperiod_entry_FK_1`
FOREIGN KEY (`timeperiod_id`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Time Period Entries';
#-----------------------------------------------------------------------------
#-- nagios_timeperiod_exclude
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_timeperiod_exclude`;
CREATE TABLE `nagios_timeperiod_exclude`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`timeperiod_id` INTEGER,
`excluded_timeperiod` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_timeperiod_exclude_FI_1` (`timeperiod_id`),
CONSTRAINT `nagios_timeperiod_exclude_FK_1`
FOREIGN KEY (`timeperiod_id`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL,
INDEX `nagios_timeperiod_exclude_FI_2` (`excluded_timeperiod`),
CONSTRAINT `nagios_timeperiod_exclude_FK_2`
FOREIGN KEY (`excluded_timeperiod`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Time Period Excludes';
#-----------------------------------------------------------------------------
#-- nagios_contact
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_contact`;
CREATE TABLE `nagios_contact`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
`email` VARCHAR(255),
`pager` VARCHAR(255),
`host_notifications_enabled` TINYINT NOT NULL,
`service_notifications_enabled` TINYINT NOT NULL,
`host_notification_period` INTEGER,
`service_notification_period` INTEGER,
`host_notification_on_down` TINYINT NOT NULL,
`host_notification_on_unreachable` TINYINT NOT NULL,
`host_notification_on_recovery` TINYINT NOT NULL,
`host_notification_on_flapping` TINYINT NOT NULL,
`host_notification_on_scheduled_downtime` TINYINT NOT NULL,
`service_notification_on_warning` TINYINT NOT NULL,
`service_notification_on_unknown` TINYINT NOT NULL,
`service_notification_on_critical` TINYINT NOT NULL,
`service_notification_on_recovery` TINYINT NOT NULL,
`service_notification_on_flapping` TINYINT NOT NULL,
`can_submit_commands` TINYINT NOT NULL,
`retain_status_information` TINYINT NOT NULL,
`retain_nonstatus_information` TINYINT NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_contact_FI_1` (`host_notification_period`),
CONSTRAINT `nagios_contact_FK_1`
FOREIGN KEY (`host_notification_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL,
INDEX `nagios_contact_FI_2` (`service_notification_period`),
CONSTRAINT `nagios_contact_FK_2`
FOREIGN KEY (`service_notification_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Nagios Contact';
#-----------------------------------------------------------------------------
#-- nagios_contact_address
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_contact_address`;
CREATE TABLE `nagios_contact_address`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`contact` INTEGER NOT NULL,
`address` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_contact_address_FI_1` (`contact`),
CONSTRAINT `nagios_contact_address_FK_1`
FOREIGN KEY (`contact`)
REFERENCES `nagios_contact` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Nagios Contact Address';
#-----------------------------------------------------------------------------
#-- nagios_contact_group
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_contact_group`;
CREATE TABLE `nagios_contact_group`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Nagios Contact Group';
#-----------------------------------------------------------------------------
#-- nagios_contact_group_member
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_contact_group_member`;
CREATE TABLE `nagios_contact_group_member`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`contact` INTEGER NOT NULL,
`contactgroup` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_contact_group_member_FI_1` (`contact`),
CONSTRAINT `nagios_contact_group_member_FK_1`
FOREIGN KEY (`contact`)
REFERENCES `nagios_contact` (`id`)
ON DELETE CASCADE,
INDEX `nagios_contact_group_member_FI_2` (`contactgroup`),
CONSTRAINT `nagios_contact_group_member_FK_2`
FOREIGN KEY (`contactgroup`)
REFERENCES `nagios_contact_group` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Member of a Nagios Contact Group';
#-----------------------------------------------------------------------------
#-- nagios_contact_notification_command
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_contact_notification_command`;
CREATE TABLE `nagios_contact_notification_command`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`contact_id` INTEGER NOT NULL,
`command` INTEGER NOT NULL,
`type` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_contact_notification_command_FI_1` (`contact_id`),
CONSTRAINT `nagios_contact_notification_command_FK_1`
FOREIGN KEY (`contact_id`)
REFERENCES `nagios_contact` (`id`)
ON DELETE CASCADE,
INDEX `nagios_contact_notification_command_FI_2` (`command`),
CONSTRAINT `nagios_contact_notification_command_FK_2`
FOREIGN KEY (`command`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Notification Command for a Nagios Contact';
#-----------------------------------------------------------------------------
#-- nagios_host_template
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host_template`;
CREATE TABLE `nagios_host_template`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`description` VARCHAR(255),
`initial_state` VARCHAR(1),
`check_command` INTEGER,
`retry_interval` INTEGER,
`first_notification_delay` INTEGER,
`maximum_check_attempts` INTEGER,
`check_interval` INTEGER,
`passive_checks_enabled` TINYINT,
`check_period` INTEGER,
`obsess_over_host` TINYINT,
`check_freshness` TINYINT,
`freshness_threshold` INTEGER,
`active_checks_enabled` TINYINT,
`checks_enabled` TINYINT,
`event_handler` INTEGER,
`event_handler_enabled` TINYINT,
`low_flap_threshold` INTEGER,
`high_flap_threshold` INTEGER,
`flap_detection_enabled` TINYINT,
`process_perf_data` TINYINT,
`retain_status_information` TINYINT,
`retain_nonstatus_information` TINYINT,
`notification_interval` INTEGER,
`notification_period` INTEGER,
`notifications_enabled` TINYINT,
`notification_on_down` TINYINT,
`notification_on_unreachable` TINYINT,
`notification_on_recovery` TINYINT,
`notification_on_flapping` TINYINT,
`notification_on_scheduled_downtime` TINYINT,
`stalking_on_up` TINYINT,
`stalking_on_down` TINYINT,
`stalking_on_unreachable` TINYINT,
`failure_prediction_enabled` TINYINT,
`flap_detection_on_up` TINYINT,
`flap_detection_on_down` TINYINT,
`flap_detection_on_unreachable` TINYINT,
`notes` VARCHAR(255),
`notes_url` VARCHAR(255),
`action_url` VARCHAR(255),
`icon_image` VARCHAR(255),
`icon_image_alt` VARCHAR(255),
`vrml_image` VARCHAR(255),
`statusmap_image` VARCHAR(255),
`two_d_coords` VARCHAR(255),
`three_d_coords` VARCHAR(255),
`autodiscovery_address_filter` VARCHAR(255),
`autodiscovery_hostname_filter` VARCHAR(255),
`autodiscovery_os_family_filter` VARCHAR(255),
`autodiscovery_os_generation_filter` VARCHAR(255),
`autodiscovery_os_vendor_filter` VARCHAR(255),
PRIMARY KEY (`id`),
INDEX `nagios_host_template_FI_1` (`check_command`),
CONSTRAINT `nagios_host_template_FK_1`
FOREIGN KEY (`check_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_host_template_FI_2` (`event_handler`),
CONSTRAINT `nagios_host_template_FK_2`
FOREIGN KEY (`event_handler`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_host_template_FI_3` (`check_period`),
CONSTRAINT `nagios_host_template_FK_3`
FOREIGN KEY (`check_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL,
INDEX `nagios_host_template_FI_4` (`notification_period`),
CONSTRAINT `nagios_host_template_FK_4`
FOREIGN KEY (`notification_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Nagios Host Template';
#-----------------------------------------------------------------------------
#-- nagios_host_template_autodiscovery_service
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host_template_autodiscovery_service`;
CREATE TABLE `nagios_host_template_autodiscovery_service`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`host_template` INTEGER,
`name` VARCHAR(255),
`protocol` VARCHAR(255),
`port` VARCHAR(255),
`product` VARCHAR(255),
`version` VARCHAR(255),
`extra_information` VARCHAR(255),
PRIMARY KEY (`id`),
INDEX `nagios_host_template_autodiscovery_service_FI_1` (`host_template`),
CONSTRAINT `nagios_host_template_autodiscovery_service_FK_1`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE
)Type=MyISAM;
#-----------------------------------------------------------------------------
#-- nagios_host
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host`;
CREATE TABLE `nagios_host`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
`display_name` VARCHAR(255) NOT NULL,
`initial_state` VARCHAR(1),
`address` VARCHAR(255) NOT NULL,
`check_command` INTEGER,
`retry_interval` INTEGER,
`first_notification_delay` INTEGER,
`maximum_check_attempts` INTEGER,
`check_interval` INTEGER,
`passive_checks_enabled` TINYINT,
`check_period` INTEGER,
`obsess_over_host` TINYINT,
`check_freshness` TINYINT,
`freshness_threshold` INTEGER,
`active_checks_enabled` TINYINT,
`checks_enabled` TINYINT,
`event_handler` INTEGER,
`event_handler_enabled` TINYINT,
`low_flap_threshold` INTEGER,
`high_flap_threshold` INTEGER,
`flap_detection_enabled` TINYINT,
`process_perf_data` TINYINT,
`retain_status_information` TINYINT,
`retain_nonstatus_information` TINYINT,
`notification_interval` INTEGER,
`notification_period` INTEGER,
`notifications_enabled` TINYINT,
`notification_on_down` TINYINT,
`notification_on_unreachable` TINYINT,
`notification_on_recovery` TINYINT,
`notification_on_flapping` TINYINT,
`notification_on_scheduled_downtime` TINYINT,
`stalking_on_up` TINYINT,
`stalking_on_down` TINYINT,
`stalking_on_unreachable` TINYINT,
`failure_prediction_enabled` TINYINT,
`flap_detection_on_up` TINYINT,
`flap_detection_on_down` TINYINT,
`flap_detection_on_unreachable` TINYINT,
`notes` VARCHAR(255),
`notes_url` VARCHAR(255),
`action_url` VARCHAR(255),
`icon_image` VARCHAR(255),
`icon_image_alt` VARCHAR(255),
`vrml_image` VARCHAR(255),
`statusmap_image` VARCHAR(255),
`two_d_coords` VARCHAR(255),
`three_d_coords` VARCHAR(255),
PRIMARY KEY (`id`),
INDEX `nagios_host_FI_1` (`check_command`),
CONSTRAINT `nagios_host_FK_1`
FOREIGN KEY (`check_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_host_FI_2` (`event_handler`),
CONSTRAINT `nagios_host_FK_2`
FOREIGN KEY (`event_handler`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_host_FI_3` (`check_period`),
CONSTRAINT `nagios_host_FK_3`
FOREIGN KEY (`check_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL,
INDEX `nagios_host_FI_4` (`notification_period`),
CONSTRAINT `nagios_host_FK_4`
FOREIGN KEY (`notification_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Nagios Host';
#-----------------------------------------------------------------------------
#-- nagios_service_template
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service_template`;
CREATE TABLE `nagios_service_template`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`description` VARCHAR(255),
`initial_state` VARCHAR(1),
`is_volatile` TINYINT,
`check_command` INTEGER,
`maximum_check_attempts` INTEGER,
`normal_check_interval` INTEGER,
`retry_interval` INTEGER,
`first_notification_delay` INTEGER,
`active_checks_enabled` TINYINT,
`passive_checks_enabled` TINYINT,
`check_period` INTEGER,
`parallelize_check` TINYINT,
`obsess_over_service` TINYINT,
`check_freshness` TINYINT,
`freshness_threshold` INTEGER,
`event_handler` INTEGER,
`event_handler_enabled` TINYINT,
`low_flap_threshold` INTEGER,
`high_flap_threshold` INTEGER,
`flap_detection_enabled` TINYINT,
`flap_detection_on_ok` TINYINT,
`flap_detection_on_warning` TINYINT,
`flap_detection_on_critical` TINYINT,
`flap_detection_on_unknown` TINYINT,
`process_perf_data` TINYINT,
`retain_status_information` TINYINT,
`retain_nonstatus_information` TINYINT,
`notification_interval` INTEGER,
`notification_period` INTEGER,
`notification_on_warning` TINYINT,
`notification_on_unknown` TINYINT,
`notification_on_critical` TINYINT,
`notification_on_recovery` TINYINT,
`notification_on_flapping` TINYINT,
`notification_on_scheduled_downtime` TINYINT,
`notifications_enabled` TINYINT,
`stalking_on_ok` TINYINT,
`stalking_on_warning` TINYINT,
`stalking_on_unknown` TINYINT,
`stalking_on_critical` TINYINT,
`failure_prediction_enabled` TINYINT,
`notes` VARCHAR(255),
`notes_url` VARCHAR(255),
`action_url` VARCHAR(255),
`icon_image` VARCHAR(255),
`icon_image_alt` VARCHAR(255),
PRIMARY KEY (`id`),
INDEX `nagios_service_template_FI_1` (`check_command`),
CONSTRAINT `nagios_service_template_FK_1`
FOREIGN KEY (`check_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_service_template_FI_2` (`event_handler`),
CONSTRAINT `nagios_service_template_FK_2`
FOREIGN KEY (`event_handler`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_service_template_FI_3` (`check_period`),
CONSTRAINT `nagios_service_template_FK_3`
FOREIGN KEY (`check_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL,
INDEX `nagios_service_template_FI_4` (`notification_period`),
CONSTRAINT `nagios_service_template_FK_4`
FOREIGN KEY (`notification_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Nagios Service Template';
#-----------------------------------------------------------------------------
#-- nagios_service
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service`;
CREATE TABLE `nagios_service`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`description` VARCHAR(255),
`display_name` VARCHAR(255),
`host` INTEGER,
`host_template` INTEGER,
`hostgroup` INTEGER,
`initial_state` VARCHAR(1),
`is_volatile` TINYINT,
`check_command` INTEGER,
`maximum_check_attempts` INTEGER,
`normal_check_interval` INTEGER,
`retry_interval` INTEGER,
`first_notification_delay` INTEGER,
`active_checks_enabled` TINYINT,
`passive_checks_enabled` TINYINT,
`check_period` INTEGER,
`parallelize_check` TINYINT,
`obsess_over_service` TINYINT,
`check_freshness` TINYINT,
`freshness_threshold` INTEGER,
`event_handler` INTEGER,
`event_handler_enabled` TINYINT,
`low_flap_threshold` INTEGER,
`high_flap_threshold` INTEGER,
`flap_detection_enabled` TINYINT,
`flap_detection_on_ok` TINYINT,
`flap_detection_on_warning` TINYINT,
`flap_detection_on_critical` TINYINT,
`flap_detection_on_unknown` TINYINT,
`process_perf_data` TINYINT,
`retain_status_information` TINYINT,
`retain_nonstatus_information` TINYINT,
`notification_interval` INTEGER,
`notification_period` INTEGER,
`notification_on_warning` TINYINT,
`notification_on_unknown` TINYINT,
`notification_on_critical` TINYINT,
`notification_on_recovery` TINYINT,
`notification_on_flapping` TINYINT,
`notification_on_scheduled_downtime` TINYINT,
`notifications_enabled` TINYINT,
`stalking_on_ok` TINYINT,
`stalking_on_warning` TINYINT,
`stalking_on_unknown` TINYINT,
`stalking_on_critical` TINYINT,
`failure_prediction_enabled` TINYINT,
`notes` VARCHAR(255),
`notes_url` VARCHAR(255),
`action_url` VARCHAR(255),
`icon_image` VARCHAR(255),
`icon_image_alt` VARCHAR(255),
PRIMARY KEY (`id`),
INDEX `nagios_service_FI_1` (`host`),
CONSTRAINT `nagios_service_FK_1`
FOREIGN KEY (`host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_FI_2` (`host_template`),
CONSTRAINT `nagios_service_FK_2`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_FI_3` (`hostgroup`),
CONSTRAINT `nagios_service_FK_3`
FOREIGN KEY (`hostgroup`)
REFERENCES `nagios_hostgroup` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_FI_4` (`check_command`),
CONSTRAINT `nagios_service_FK_4`
FOREIGN KEY (`check_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_service_FI_5` (`event_handler`),
CONSTRAINT `nagios_service_FK_5`
FOREIGN KEY (`event_handler`)
REFERENCES `nagios_command` (`id`)
ON DELETE SET NULL,
INDEX `nagios_service_FI_6` (`check_period`),
CONSTRAINT `nagios_service_FK_6`
FOREIGN KEY (`check_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL,
INDEX `nagios_service_FI_7` (`notification_period`),
CONSTRAINT `nagios_service_FK_7`
FOREIGN KEY (`notification_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Nagios Service';
#-----------------------------------------------------------------------------
#-- nagios_service_check_command_parameter
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service_check_command_parameter`;
CREATE TABLE `nagios_service_check_command_parameter`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`service` INTEGER,
`template` INTEGER,
`parameter` VARCHAR(255),
PRIMARY KEY (`id`),
INDEX `nagios_service_check_command_parameter_FI_1` (`service`),
CONSTRAINT `nagios_service_check_command_parameter_FK_1`
FOREIGN KEY (`service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_check_command_parameter_FI_2` (`template`),
CONSTRAINT `nagios_service_check_command_parameter_FK_2`
FOREIGN KEY (`template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Parameter for check command for service or service template';
#-----------------------------------------------------------------------------
#-- nagios_service_group
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service_group`;
CREATE TABLE `nagios_service_group`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
`notes` VARCHAR(255),
`notes_url` VARCHAR(255),
`action_url` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Nagios Service Group';
#-----------------------------------------------------------------------------
#-- nagios_service_group_member
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service_group_member`;
CREATE TABLE `nagios_service_group_member`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`service` INTEGER,
`template` INTEGER,
`service_group` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_service_group_member_FI_1` (`service`),
CONSTRAINT `nagios_service_group_member_FK_1`
FOREIGN KEY (`service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_group_member_FI_2` (`template`),
CONSTRAINT `nagios_service_group_member_FK_2`
FOREIGN KEY (`template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_group_member_FI_3` (`service_group`),
CONSTRAINT `nagios_service_group_member_FK_3`
FOREIGN KEY (`service_group`)
REFERENCES `nagios_service_group` (`id`)
ON DELETE CASCADE
)Type=MyISAM;
#-----------------------------------------------------------------------------
#-- nagios_host_contact_member
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host_contact_member`;
CREATE TABLE `nagios_host_contact_member`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`host` INTEGER,
`template` INTEGER,
`contact` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_host_contact_member_FI_1` (`host`),
CONSTRAINT `nagios_host_contact_member_FK_1`
FOREIGN KEY (`host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_contact_member_FI_2` (`template`),
CONSTRAINT `nagios_host_contact_member_FK_2`
FOREIGN KEY (`template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_contact_member_FI_3` (`contact`),
CONSTRAINT `nagios_host_contact_member_FK_3`
FOREIGN KEY (`contact`)
REFERENCES `nagios_contact` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Contacts which belong to host templates or hosts';
#-----------------------------------------------------------------------------
#-- nagios_service_contact_member
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service_contact_member`;
CREATE TABLE `nagios_service_contact_member`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`service` INTEGER,
`template` INTEGER,
`contact` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_service_contact_member_FI_1` (`service`),
CONSTRAINT `nagios_service_contact_member_FK_1`
FOREIGN KEY (`service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_contact_member_FI_2` (`template`),
CONSTRAINT `nagios_service_contact_member_FK_2`
FOREIGN KEY (`template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_contact_member_FI_3` (`contact`),
CONSTRAINT `nagios_service_contact_member_FK_3`
FOREIGN KEY (`contact`)
REFERENCES `nagios_contact` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Contacts which belong to service templates or services';
#-----------------------------------------------------------------------------
#-- nagios_service_contact_group_member
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service_contact_group_member`;
CREATE TABLE `nagios_service_contact_group_member`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`service` INTEGER,
`template` INTEGER,
`contact_group` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_service_contact_group_member_FI_1` (`service`),
CONSTRAINT `nagios_service_contact_group_member_FK_1`
FOREIGN KEY (`service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_contact_group_member_FI_2` (`template`),
CONSTRAINT `nagios_service_contact_group_member_FK_2`
FOREIGN KEY (`template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_contact_group_member_FI_3` (`contact_group`),
CONSTRAINT `nagios_service_contact_group_member_FK_3`
FOREIGN KEY (`contact_group`)
REFERENCES `nagios_contact_group` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Nagios Service Group';
#-----------------------------------------------------------------------------
#-- nagios_dependency
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_dependency`;
CREATE TABLE `nagios_dependency`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`host_template` INTEGER,
`host` INTEGER,
`service_template` INTEGER,
`service` INTEGER,
`hostgroup` INTEGER,
`name` VARCHAR(255),
`execution_failure_criteria_up` TINYINT,
`execution_failure_criteria_down` TINYINT,
`execution_failure_criteria_unreachable` TINYINT,
`execution_failure_criteria_pending` TINYINT,
`execution_failure_criteria_ok` TINYINT,
`execution_failure_criteria_warning` TINYINT,
`execution_failure_criteria_unknown` TINYINT,
`execution_failure_criteria_critical` TINYINT,
`notification_failure_criteria_ok` TINYINT,
`notification_failure_criteria_warning` TINYINT,
`notification_failure_criteria_unknown` TINYINT,
`notification_failure_criteria_critical` TINYINT,
`notification_failure_criteria_pending` TINYINT,
`notification_failure_criteria_up` TINYINT,
`notification_failure_criteria_down` TINYINT,
`notification_failure_criteria_unreachable` TINYINT,
`inherits_parent` TINYINT,
`dependency_period` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_dependency_FI_1` (`host_template`),
CONSTRAINT `nagios_dependency_FK_1`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_FI_2` (`host`),
CONSTRAINT `nagios_dependency_FK_2`
FOREIGN KEY (`host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_FI_3` (`service_template`),
CONSTRAINT `nagios_dependency_FK_3`
FOREIGN KEY (`service_template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_FI_4` (`service`),
CONSTRAINT `nagios_dependency_FK_4`
FOREIGN KEY (`service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_FI_5` (`hostgroup`),
CONSTRAINT `nagios_dependency_FK_5`
FOREIGN KEY (`hostgroup`)
REFERENCES `nagios_hostgroup` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_FI_6` (`dependency_period`),
CONSTRAINT `nagios_dependency_FK_6`
FOREIGN KEY (`dependency_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Nagios Dependency';
#-----------------------------------------------------------------------------
#-- nagios_dependency_target
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_dependency_target`;
CREATE TABLE `nagios_dependency_target`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`dependency` INTEGER,
`target_host` INTEGER,
`target_service` INTEGER,
`target_hostgroup` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_dependency_target_FI_1` (`dependency`),
CONSTRAINT `nagios_dependency_target_FK_1`
FOREIGN KEY (`dependency`)
REFERENCES `nagios_dependency` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_target_FI_2` (`target_host`),
CONSTRAINT `nagios_dependency_target_FK_2`
FOREIGN KEY (`target_host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_target_FI_3` (`target_service`),
CONSTRAINT `nagios_dependency_target_FK_3`
FOREIGN KEY (`target_service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_dependency_target_FI_4` (`target_hostgroup`),
CONSTRAINT `nagios_dependency_target_FK_4`
FOREIGN KEY (`target_hostgroup`)
REFERENCES `nagios_hostgroup` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Targets for a Dependency';
#-----------------------------------------------------------------------------
#-- nagios_escalation
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_escalation`;
CREATE TABLE `nagios_escalation`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`description` VARCHAR(255) NOT NULL,
`host_template` INTEGER,
`host` INTEGER,
`hostgroup` INTEGER,
`service_template` INTEGER,
`service` INTEGER,
`first_notification` INTEGER,
`last_notification` INTEGER,
`notification_interval` INTEGER,
`escalation_period` INTEGER,
`escalation_options_up` TINYINT,
`escalation_options_down` TINYINT,
`escalation_options_unreachable` TINYINT,
`escalation_options_ok` TINYINT,
`escalation_options_warning` TINYINT,
`escalation_options_unknown` TINYINT,
`escalation_options_critical` TINYINT,
PRIMARY KEY (`id`),
INDEX `nagios_escalation_FI_1` (`host_template`),
CONSTRAINT `nagios_escalation_FK_1`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_escalation_FI_2` (`host`),
CONSTRAINT `nagios_escalation_FK_2`
FOREIGN KEY (`host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_escalation_FI_3` (`service_template`),
CONSTRAINT `nagios_escalation_FK_3`
FOREIGN KEY (`service_template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_escalation_FI_4` (`service`),
CONSTRAINT `nagios_escalation_FK_4`
FOREIGN KEY (`service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_escalation_FI_5` (`hostgroup`),
CONSTRAINT `nagios_escalation_FK_5`
FOREIGN KEY (`hostgroup`)
REFERENCES `nagios_hostgroup` (`id`)
ON DELETE CASCADE,
INDEX `nagios_escalation_FI_6` (`escalation_period`),
CONSTRAINT `nagios_escalation_FK_6`
FOREIGN KEY (`escalation_period`)
REFERENCES `nagios_timeperiod` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='Nagios Escalation';
#-----------------------------------------------------------------------------
#-- nagios_escalation_contact
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_escalation_contact`;
CREATE TABLE `nagios_escalation_contact`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`escalation` INTEGER NOT NULL,
`contact` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_escalation_contact_FI_1` (`escalation`),
CONSTRAINT `nagios_escalation_contact_FK_1`
FOREIGN KEY (`escalation`)
REFERENCES `nagios_escalation` (`id`)
ON DELETE CASCADE,
INDEX `nagios_escalation_contact_FI_2` (`contact`),
CONSTRAINT `nagios_escalation_contact_FK_2`
FOREIGN KEY (`contact`)
REFERENCES `nagios_contact` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Contact Group for Escalation';
#-----------------------------------------------------------------------------
#-- nagios_escalation_contactgroup
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_escalation_contactgroup`;
CREATE TABLE `nagios_escalation_contactgroup`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`escalation` INTEGER NOT NULL,
`contactgroup` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_escalation_contactgroup_FI_1` (`escalation`),
CONSTRAINT `nagios_escalation_contactgroup_FK_1`
FOREIGN KEY (`escalation`)
REFERENCES `nagios_escalation` (`id`)
ON DELETE CASCADE,
INDEX `nagios_escalation_contactgroup_FI_2` (`contactgroup`),
CONSTRAINT `nagios_escalation_contactgroup_FK_2`
FOREIGN KEY (`contactgroup`)
REFERENCES `nagios_contact_group` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Contact Group for Escalation';
#-----------------------------------------------------------------------------
#-- nagios_host_contactgroup
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host_contactgroup`;
CREATE TABLE `nagios_host_contactgroup`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`host` INTEGER,
`host_template` INTEGER,
`contactgroup` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_host_contactgroup_FI_1` (`host`),
CONSTRAINT `nagios_host_contactgroup_FK_1`
FOREIGN KEY (`host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_contactgroup_FI_2` (`host_template`),
CONSTRAINT `nagios_host_contactgroup_FK_2`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_contactgroup_FI_3` (`contactgroup`),
CONSTRAINT `nagios_host_contactgroup_FK_3`
FOREIGN KEY (`contactgroup`)
REFERENCES `nagios_contact_group` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Contact Group for Host';
#-----------------------------------------------------------------------------
#-- nagios_hostgroup
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_hostgroup`;
CREATE TABLE `nagios_hostgroup`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`alias` VARCHAR(255) NOT NULL,
`notes` VARCHAR(255),
`notes_url` VARCHAR(255),
`action_url` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Nagios Hostgroup';
#-----------------------------------------------------------------------------
#-- nagios_hostgroup_membership
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_hostgroup_membership`;
CREATE TABLE `nagios_hostgroup_membership`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`host` INTEGER,
`host_template` INTEGER,
`hostgroup` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_hostgroup_membership_FI_1` (`host`),
CONSTRAINT `nagios_hostgroup_membership_FK_1`
FOREIGN KEY (`host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_hostgroup_membership_FI_2` (`host_template`),
CONSTRAINT `nagios_hostgroup_membership_FK_2`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_hostgroup_membership_FI_3` (`hostgroup`),
CONSTRAINT `nagios_hostgroup_membership_FK_3`
FOREIGN KEY (`hostgroup`)
REFERENCES `nagios_hostgroup` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Hostgroup Membership for Host';
#-----------------------------------------------------------------------------
#-- nagios_host_check_command_parameter
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host_check_command_parameter`;
CREATE TABLE `nagios_host_check_command_parameter`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`host` INTEGER,
`host_template` INTEGER,
`parameter` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_host_check_command_parameter_FI_1` (`host`),
CONSTRAINT `nagios_host_check_command_parameter_FK_1`
FOREIGN KEY (`host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_check_command_parameter_FI_2` (`host_template`),
CONSTRAINT `nagios_host_check_command_parameter_FK_2`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Parameter for Host Check Command';
#-----------------------------------------------------------------------------
#-- nagios_host_parent
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host_parent`;
CREATE TABLE `nagios_host_parent`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`child_host` INTEGER,
`child_host_template` INTEGER,
`parent_host` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_host_parent_FI_1` (`child_host`),
CONSTRAINT `nagios_host_parent_FK_1`
FOREIGN KEY (`child_host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_parent_FI_2` (`parent_host`),
CONSTRAINT `nagios_host_parent_FK_2`
FOREIGN KEY (`parent_host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_parent_FI_3` (`child_host_template`),
CONSTRAINT `nagios_host_parent_FK_3`
FOREIGN KEY (`child_host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Nagios Additional Host Parent Relationship';
#-----------------------------------------------------------------------------
#-- nagios_resource
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_resource`;
CREATE TABLE `nagios_resource`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`user1` VARCHAR(255),
`user2` VARCHAR(255),
`user3` VARCHAR(255),
`user4` VARCHAR(255),
`user5` VARCHAR(255),
`user6` VARCHAR(255),
`user7` VARCHAR(255),
`user8` VARCHAR(255),
`user9` VARCHAR(255),
`user10` VARCHAR(255),
`user11` VARCHAR(255),
`user12` VARCHAR(255),
`user13` VARCHAR(255),
`user14` VARCHAR(255),
`user15` VARCHAR(255),
`user16` VARCHAR(255),
`user17` VARCHAR(255),
`user18` VARCHAR(255),
`user19` VARCHAR(255),
`user20` VARCHAR(255),
`user21` VARCHAR(255),
`user22` VARCHAR(255),
`user23` VARCHAR(255),
`user24` VARCHAR(255),
`user25` VARCHAR(255),
`user26` VARCHAR(255),
`user27` VARCHAR(255),
`user28` VARCHAR(255),
`user29` VARCHAR(255),
`user30` VARCHAR(255),
`user31` VARCHAR(255),
`user32` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='Nagios Resource';
#-----------------------------------------------------------------------------
#-- nagios_main_configuration
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_main_configuration`;
CREATE TABLE `nagios_main_configuration`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`config_dir` VARCHAR(255),
`log_file` VARCHAR(255),
`temp_file` VARCHAR(255),
`status_file` VARCHAR(255),
`status_update_interval` INTEGER,
`nagios_user` VARCHAR(255),
`nagios_group` VARCHAR(255),
`enable_notifications` TINYINT,
`execute_service_checks` TINYINT,
`accept_passive_service_checks` TINYINT,
`enable_event_handlers` TINYINT,
`log_rotation_method` CHAR,
`log_archive_path` VARCHAR(255),
`check_external_commands` TINYINT,
`command_check_interval` VARCHAR(255),
`command_file` VARCHAR(255),
`lock_file` VARCHAR(255),
`retain_state_information` TINYINT,
`state_retention_file` VARCHAR(255),
`retention_update_interval` INTEGER,
`use_retained_program_state` TINYINT,
`use_syslog` TINYINT,
`log_notifications` TINYINT,
`log_service_retries` TINYINT,
`log_host_retries` TINYINT,
`log_event_handlers` TINYINT,
`log_initial_states` TINYINT,
`log_external_commands` TINYINT,
`log_passive_checks` TINYINT,
`global_host_event_handler` INTEGER,
`global_service_event_handler` INTEGER,
`external_command_buffer_slots` INTEGER,
`sleep_time` FLOAT,
`service_interleave_factor` CHAR,
`max_concurrent_checks` INTEGER,
`service_reaper_frequency` INTEGER,
`interval_length` INTEGER,
`use_aggressive_host_checking` TINYINT,
`enable_flap_detection` TINYINT,
`low_service_flap_threshold` FLOAT,
`high_service_flap_threshold` FLOAT,
`low_host_flap_threshold` FLOAT,
`high_host_flap_threshold` FLOAT,
`soft_state_dependencies` TINYINT,
`service_check_timeout` INTEGER,
`host_check_timeout` INTEGER,
`event_handler_timeout` INTEGER,
`notification_timeout` INTEGER,
`ocsp_timeout` INTEGER,
`ohcp_timeout` INTEGER,
`perfdata_timeout` INTEGER,
`obsess_over_services` TINYINT,
`ocsp_command` INTEGER,
`process_performance_data` TINYINT,
`check_for_orphaned_services` TINYINT,
`check_service_freshness` TINYINT,
`freshness_check_interval` INTEGER,
`date_format` VARCHAR(255),
`illegal_object_name_chars` VARCHAR(255),
`illegal_macro_output_chars` VARCHAR(255),
`admin_email` VARCHAR(255),
`admin_pager` VARCHAR(255),
`execute_host_checks` TINYINT,
`service_inter_check_delay_method` VARCHAR(255),
`use_retained_scheduling_info` TINYINT,
`accept_passive_host_checks` TINYINT,
`max_service_check_spread` INTEGER,
`host_inter_check_delay_method` VARCHAR(255),
`max_host_check_spread` INTEGER,
`auto_reschedule_checks` TINYINT,
`auto_rescheduling_interval` INTEGER,
`auto_rescheduling_window` INTEGER,
`ochp_timeout` INTEGER,
`obsess_over_hosts` TINYINT,
`ochp_command` INTEGER,
`check_host_freshness` TINYINT,
`host_freshness_check_interval` INTEGER,
`service_freshness_check_interval` INTEGER,
`use_regexp_matching` TINYINT,
`use_true_regexp_matching` TINYINT,
`event_broker_options` VARCHAR(255),
`daemon_dumps_core` TINYINT,
`host_perfdata_command` INTEGER,
`service_perfdata_command` INTEGER,
`host_perfdata_file` VARCHAR(255),
`host_perfdata_file_template` VARCHAR(255),
`service_perfdata_file` VARCHAR(255),
`service_perfdata_file_template` VARCHAR(255),
`host_perfdata_file_mode` CHAR,
`service_perfdata_file_mode` CHAR,
`host_perfdata_file_processing_command` INTEGER,
`service_perfdata_file_processing_command` INTEGER,
`host_perfdata_file_processing_interval` INTEGER,
`service_perfdata_file_processing_interval` INTEGER,
`object_cache_file` VARCHAR(255),
`precached_object_file` VARCHAR(255),
`retained_host_attribute_mask` INTEGER,
`retained_service_attribute_mask` INTEGER,
`retained_process_host_attribute_mask` INTEGER,
`retained_process_service_attribute_mask` INTEGER,
`retained_contact_host_attribute_mask` INTEGER,
`retained_contact_service_attribute_mask` INTEGER,
`check_result_reaper_frequency` INTEGER,
`max_check_result_reaper_time` INTEGER,
`check_result_path` VARCHAR(255),
`max_check_result_file_age` INTEGER,
`translate_passive_host_checks` TINYINT,
`passive_host_checks_are_soft` TINYINT,
`enable_predictive_host_dependency_checks` TINYINT,
`enable_predictive_service_dependency_checks` TINYINT,
`cached_host_check_horizon` INTEGER,
`cached_service_check_horizon` INTEGER,
`use_large_installation_tweaks` TINYINT,
`free_child_process_memory` TINYINT,
`child_processes_fork_twice` TINYINT,
`enable_environment_macros` TINYINT,
`additional_freshness_latency` INTEGER,
`enable_embedded_perl` TINYINT,
`use_embedded_perl_implicitly` TINYINT,
`p1_file` VARCHAR(255),
`use_timezone` VARCHAR(255),
`debug_file` VARCHAR(255),
`debug_level` INTEGER,
`debug_verbosity` INTEGER,
`max_debug_file_size` INTEGER,
PRIMARY KEY (`id`),
INDEX `nagios_main_configuration_FI_1` (`ocsp_command`),
CONSTRAINT `nagios_main_configuration_FK_1`
FOREIGN KEY (`ocsp_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE,
INDEX `nagios_main_configuration_FI_2` (`ochp_command`),
CONSTRAINT `nagios_main_configuration_FK_2`
FOREIGN KEY (`ochp_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE,
INDEX `nagios_main_configuration_FI_3` (`host_perfdata_command`),
CONSTRAINT `nagios_main_configuration_FK_3`
FOREIGN KEY (`host_perfdata_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE,
INDEX `nagios_main_configuration_FI_4` (`service_perfdata_command`),
CONSTRAINT `nagios_main_configuration_FK_4`
FOREIGN KEY (`service_perfdata_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE,
INDEX `nagios_main_configuration_FI_5` (`host_perfdata_file_processing_command`),
CONSTRAINT `nagios_main_configuration_FK_5`
FOREIGN KEY (`host_perfdata_file_processing_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE,
INDEX `nagios_main_configuration_FI_6` (`service_perfdata_file_processing_command`),
CONSTRAINT `nagios_main_configuration_FK_6`
FOREIGN KEY (`service_perfdata_file_processing_command`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE,
INDEX `nagios_main_configuration_FI_7` (`global_service_event_handler`),
CONSTRAINT `nagios_main_configuration_FK_7`
FOREIGN KEY (`global_service_event_handler`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE,
INDEX `nagios_main_configuration_FI_8` (`global_host_event_handler`),
CONSTRAINT `nagios_main_configuration_FK_8`
FOREIGN KEY (`global_host_event_handler`)
REFERENCES `nagios_command` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Nagios Main Configuration';
#-----------------------------------------------------------------------------
#-- nagios_host_template_inheritance
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_host_template_inheritance`;
CREATE TABLE `nagios_host_template_inheritance`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`source_host` INTEGER,
`source_template` INTEGER,
`target_template` INTEGER NOT NULL,
`order` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_host_template_inheritance_FI_1` (`source_host`),
CONSTRAINT `nagios_host_template_inheritance_FK_1`
FOREIGN KEY (`source_host`)
REFERENCES `nagios_host` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_template_inheritance_FI_2` (`source_template`),
CONSTRAINT `nagios_host_template_inheritance_FK_2`
FOREIGN KEY (`source_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_host_template_inheritance_FI_3` (`target_template`),
CONSTRAINT `nagios_host_template_inheritance_FK_3`
FOREIGN KEY (`target_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Nagios Host Template Inheritance';
#-----------------------------------------------------------------------------
#-- nagios_service_template_inheritance
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `nagios_service_template_inheritance`;
CREATE TABLE `nagios_service_template_inheritance`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`source_service` INTEGER,
`source_template` INTEGER,
`target_template` INTEGER NOT NULL,
`order` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `nagios_service_template_inheritance_FI_1` (`source_service`),
CONSTRAINT `nagios_service_template_inheritance_FK_1`
FOREIGN KEY (`source_service`)
REFERENCES `nagios_service` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_template_inheritance_FI_2` (`source_template`),
CONSTRAINT `nagios_service_template_inheritance_FK_2`
FOREIGN KEY (`source_template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE,
INDEX `nagios_service_template_inheritance_FI_3` (`target_template`),
CONSTRAINT `nagios_service_template_inheritance_FK_3`
FOREIGN KEY (`target_template`)
REFERENCES `nagios_service_template` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Nagios service Template Inheritance';
#-----------------------------------------------------------------------------
#-- autodiscovery_job
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `autodiscovery_job`;
CREATE TABLE `autodiscovery_job`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`name` VARCHAR(255) NOT NULL,
`description` VARCHAR(255) NOT NULL,
`config` TEXT NOT NULL,
`start_time` DATETIME,
`end_time` DATETIME,
`status` VARCHAR(255),
`status_code` INTEGER NOT NULL,
`status_change_time` DATETIME,
`stats` TEXT NOT NULL,
`cmd` VARCHAR(255),
PRIMARY KEY (`id`)
)Type=MyISAM COMMENT='AutoDiscovery Job Information';
#-----------------------------------------------------------------------------
#-- autodiscovery_log_entry
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `autodiscovery_log_entry`;
CREATE TABLE `autodiscovery_log_entry`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`job` INTEGER,
`time` DATETIME NOT NULL,
`text` TEXT NOT NULL,
`type` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `autodiscovery_log_entry_FI_1` (`job`),
CONSTRAINT `autodiscovery_log_entry_FK_1`
FOREIGN KEY (`job`)
REFERENCES `autodiscovery_job` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='Export Job Entry';
#-----------------------------------------------------------------------------
#-- autodiscovery_device
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `autodiscovery_device`;
CREATE TABLE `autodiscovery_device`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`job_id` INTEGER NOT NULL,
`address` VARCHAR(255) NOT NULL,
`name` VARCHAR(255),
`hostname` VARCHAR(255),
`description` VARCHAR(255),
`osvendor` VARCHAR(255),
`osfamily` VARCHAR(255),
`osgen` VARCHAR(255),
`host_template` INTEGER NOT NULL,
`proposed_parent` INTEGER,
PRIMARY KEY (`id`),
INDEX `autodiscovery_device_FI_1` (`job_id`),
CONSTRAINT `autodiscovery_device_FK_1`
FOREIGN KEY (`job_id`)
REFERENCES `autodiscovery_job` (`id`)
ON DELETE CASCADE,
INDEX `autodiscovery_device_FI_2` (`host_template`),
CONSTRAINT `autodiscovery_device_FK_2`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE SET NULL,
INDEX `autodiscovery_device_FI_3` (`proposed_parent`),
CONSTRAINT `autodiscovery_device_FK_3`
FOREIGN KEY (`proposed_parent`)
REFERENCES `nagios_host` (`id`)
ON DELETE SET NULL
)Type=MyISAM COMMENT='AutoDiscovery Found Device';
#-----------------------------------------------------------------------------
#-- autodiscovery_device_service
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `autodiscovery_device_service`;
CREATE TABLE `autodiscovery_device_service`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`device_id` INTEGER NOT NULL,
`protocol` VARCHAR(255) NOT NULL,
`port` INTEGER NOT NULL,
`name` VARCHAR(255) NOT NULL,
`product` VARCHAR(255) NOT NULL,
`version` VARCHAR(255) NOT NULL,
`extrainfo` VARCHAR(255) NOT NULL,
PRIMARY KEY (`id`),
INDEX `autodiscovery_device_service_FI_1` (`device_id`),
CONSTRAINT `autodiscovery_device_service_FK_1`
FOREIGN KEY (`device_id`)
REFERENCES `autodiscovery_device` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='AutoDiscovery Found Service';
#-----------------------------------------------------------------------------
#-- autodiscovery_device_template_match
#-----------------------------------------------------------------------------
DROP TABLE IF EXISTS `autodiscovery_device_template_match`;
CREATE TABLE `autodiscovery_device_template_match`
(
`id` INTEGER NOT NULL AUTO_INCREMENT,
`device_id` INTEGER NOT NULL,
`host_template` INTEGER NOT NULL,
`percent` FLOAT NOT NULL,
`complexity` INTEGER NOT NULL,
PRIMARY KEY (`id`),
INDEX `autodiscovery_device_template_match_FI_1` (`device_id`),
CONSTRAINT `autodiscovery_device_template_match_FK_1`
FOREIGN KEY (`device_id`)
REFERENCES `autodiscovery_device` (`id`)
ON DELETE CASCADE,
INDEX `autodiscovery_device_template_match_FI_2` (`host_template`),
CONSTRAINT `autodiscovery_device_template_match_FK_2`
FOREIGN KEY (`host_template`)
REFERENCES `nagios_host_template` (`id`)
ON DELETE CASCADE
)Type=MyISAM COMMENT='AutoDiscovery Device Matched Template';
# This restores the fkey checks, after having unset them earlier
SET FOREIGN_KEY_CHECKS = 1;
Reference in New Issue View Git Blame Copy Permalink