CREATE TABLE "icinga_objects" ( "object_id" bigint(20) unsigned NOT NULL AUTO_INCREMENT, "instance_id" bigint(20) unsigned DEFAULT '0', "objecttype_id" bigint(20) unsigned DEFAULT '0', "name1" varchar(128) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT '', "name2" varchar(128) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT NULL, "is_active" smallint(6) DEFAULT '0', PRIMARY KEY ("object_id") /*T![clustered_index] CLUSTERED */, KEY "objecttype_id" ("objecttype_id","name1","name2"), KEY "objects_objtype_id_idx" ("objecttype_id"), KEY "objects_name1_idx" ("name1"), KEY "objects_name2_idx" ("name2"), KEY "objects_inst_id_idx" ("instance_id") ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30002 COMMENT='Current and historical objects of all kinds'; CREATE TABLE "icinga_services" ( "service_id" bigint(20) unsigned NOT NULL AUTO_INCREMENT, "instance_id" bigint(20) unsigned DEFAULT '0', "config_type" smallint(6) DEFAULT '0', "host_object_id" bigint(20) unsigned DEFAULT '0', "service_object_id" bigint(20) unsigned DEFAULT '0', "display_name" varchar(255) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT '', "check_command_object_id" bigint(20) unsigned DEFAULT '0', "check_command_args" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "eventhandler_command_object_id" bigint(20) unsigned DEFAULT '0', "eventhandler_command_args" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "notification_timeperiod_object_id" bigint(20) unsigned DEFAULT '0', "check_timeperiod_object_id" bigint(20) unsigned DEFAULT '0', "failure_prediction_options" varchar(64) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '', "check_interval" double DEFAULT '0', "retry_interval" double DEFAULT '0', "max_check_attempts" smallint(6) DEFAULT '0', "first_notification_delay" double DEFAULT '0', "notification_interval" double DEFAULT '0', "notify_on_warning" smallint(6) DEFAULT '0', "notify_on_unknown" smallint(6) DEFAULT '0', "notify_on_critical" smallint(6) DEFAULT '0', "notify_on_recovery" smallint(6) DEFAULT '0', "notify_on_flapping" smallint(6) DEFAULT '0', "notify_on_downtime" smallint(6) DEFAULT '0', "stalk_on_ok" smallint(6) DEFAULT '0', "stalk_on_warning" smallint(6) DEFAULT '0', "stalk_on_unknown" smallint(6) DEFAULT '0', "stalk_on_critical" smallint(6) DEFAULT '0', "is_volatile" smallint(6) DEFAULT '0', "flap_detection_enabled" smallint(6) DEFAULT '0', "flap_detection_on_ok" smallint(6) DEFAULT '0', "flap_detection_on_warning" smallint(6) DEFAULT '0', "flap_detection_on_unknown" smallint(6) DEFAULT '0', "flap_detection_on_critical" smallint(6) DEFAULT '0', "low_flap_threshold" double DEFAULT '0', "high_flap_threshold" double DEFAULT '0', "process_performance_data" smallint(6) DEFAULT '0', "freshness_checks_enabled" smallint(6) DEFAULT '0', "freshness_threshold" int(11) DEFAULT '0', "passive_checks_enabled" smallint(6) DEFAULT '0', "event_handler_enabled" smallint(6) DEFAULT '0', "active_checks_enabled" smallint(6) DEFAULT '0', "retain_status_information" smallint(6) DEFAULT '0', "retain_nonstatus_information" smallint(6) DEFAULT '0', "notifications_enabled" smallint(6) DEFAULT '0', "obsess_over_service" smallint(6) DEFAULT '0', "failure_prediction_enabled" smallint(6) DEFAULT '0', "notes" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "notes_url" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "action_url" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "icon_image" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "icon_image_alt" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "config_hash" varchar(64) DEFAULT NULL, PRIMARY KEY ("service_id") /*T![clustered_index] CLUSTERED */, UNIQUE KEY "instance_id" ("instance_id","config_type","service_object_id"), KEY "service_object_id" ("service_object_id"), KEY "services_i_id_idx" ("instance_id"), KEY "services_host_object_id_idx" ("host_object_id"), KEY "services_combined_object_idx" ("service_object_id","host_object_id") ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30002 COMMENT='Service definitions'; CREATE TABLE "icinga_servicestatus" ( "servicestatus_id" bigint(20) unsigned NOT NULL AUTO_INCREMENT, "instance_id" bigint(20) unsigned DEFAULT '0', "service_object_id" bigint(20) unsigned DEFAULT '0', "status_update_time" timestamp NULL DEFAULT NULL, "output" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "long_output" text DEFAULT NULL, "perfdata" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "check_source" varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '', "current_state" smallint(6) DEFAULT '0', "has_been_checked" smallint(6) DEFAULT '0', "should_be_scheduled" smallint(6) DEFAULT '0', "current_check_attempt" smallint(6) DEFAULT '0', "max_check_attempts" smallint(6) DEFAULT '0', "last_check" timestamp NULL DEFAULT NULL, "next_check" timestamp NULL DEFAULT NULL, "check_type" smallint(6) DEFAULT '0', "last_state_change" timestamp NULL DEFAULT NULL, "last_hard_state_change" timestamp NULL DEFAULT NULL, "last_hard_state" smallint(6) DEFAULT '0', "last_time_ok" timestamp NULL DEFAULT NULL, "last_time_warning" timestamp NULL DEFAULT NULL, "last_time_unknown" timestamp NULL DEFAULT NULL, "last_time_critical" timestamp NULL DEFAULT NULL, "state_type" smallint(6) DEFAULT '0', "last_notification" timestamp NULL DEFAULT NULL, "next_notification" timestamp NULL DEFAULT NULL, "no_more_notifications" smallint(6) DEFAULT '0', "notifications_enabled" smallint(6) DEFAULT '0', "problem_has_been_acknowledged" smallint(6) DEFAULT '0', "acknowledgement_type" smallint(6) DEFAULT '0', "current_notification_number" int(10) unsigned DEFAULT '0', "passive_checks_enabled" smallint(6) DEFAULT '0', "active_checks_enabled" smallint(6) DEFAULT '0', "event_handler_enabled" smallint(6) DEFAULT '0', "flap_detection_enabled" smallint(6) DEFAULT '0', "is_flapping" smallint(6) DEFAULT '0', "percent_state_change" double DEFAULT '0', "latency" double DEFAULT '0', "execution_time" double DEFAULT '0', "scheduled_downtime_depth" smallint(6) DEFAULT '0', "failure_prediction_enabled" smallint(6) DEFAULT '0', "process_performance_data" smallint(6) DEFAULT '0', "obsess_over_service" smallint(6) DEFAULT '0', "modified_service_attributes" int(11) DEFAULT '0', "original_attributes" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "event_handler" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "check_command" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "normal_check_interval" double DEFAULT '0', "retry_check_interval" double DEFAULT '0', "check_timeperiod_object_id" bigint(20) unsigned DEFAULT '0', "is_reachable" smallint(6) DEFAULT '0', "endpoint_object_id" bigint(20) DEFAULT NULL, PRIMARY KEY ("servicestatus_id") /*T![clustered_index] CLUSTERED */, UNIQUE KEY "object_id" ("service_object_id"), KEY "servicestatus_i_id_idx" ("instance_id"), KEY "srvcstatus_stat_upd_time_idx" ("status_update_time"), KEY "srvcstatus_current_state_idx" ("current_state"), KEY "srvcstatus_check_type_idx" ("check_type"), KEY "srvcstatus_state_type_idx" ("state_type"), KEY "srvcstatus_last_state_chg_idx" ("last_state_change"), KEY "srvcstatus_notif_enabled_idx" ("notifications_enabled"), KEY "srvcstatus_problem_ack_idx" ("problem_has_been_acknowledged"), KEY "srvcstatus_act_chks_en_idx" ("active_checks_enabled"), KEY "srvcstatus_pas_chks_en_idx" ("passive_checks_enabled"), KEY "srvcstatus_event_hdl_en_idx" ("event_handler_enabled"), KEY "srvcstatus_flap_det_en_idx" ("flap_detection_enabled"), KEY "srvcstatus_is_flapping_idx" ("is_flapping"), KEY "srvcstatus_p_state_chg_idx" ("percent_state_change"), KEY "srvcstatus_latency_idx" ("latency"), KEY "srvcstatus_ex_time_idx" ("execution_time"), KEY "srvcstatus_sch_downt_d_idx" ("scheduled_downtime_depth") ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30002 COMMENT='Current service status information'; CREATE TABLE "icinga_hoststatus" ( "hoststatus_id" bigint(20) unsigned NOT NULL AUTO_INCREMENT, "instance_id" bigint(20) unsigned DEFAULT '0', "host_object_id" bigint(20) unsigned DEFAULT '0', "status_update_time" timestamp NULL DEFAULT NULL, "output" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "long_output" text DEFAULT NULL, "perfdata" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "check_source" varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '', "current_state" smallint(6) DEFAULT '0', "has_been_checked" smallint(6) DEFAULT '0', "should_be_scheduled" smallint(6) DEFAULT '0', "current_check_attempt" smallint(6) DEFAULT '0', "max_check_attempts" smallint(6) DEFAULT '0', "last_check" timestamp NULL DEFAULT NULL, "next_check" timestamp NULL DEFAULT NULL, "check_type" smallint(6) DEFAULT '0', "last_state_change" timestamp NULL DEFAULT NULL, "last_hard_state_change" timestamp NULL DEFAULT NULL, "last_hard_state" smallint(6) DEFAULT '0', "last_time_up" timestamp NULL DEFAULT NULL, "last_time_down" timestamp NULL DEFAULT NULL, "last_time_unreachable" timestamp NULL DEFAULT NULL, "state_type" smallint(6) DEFAULT '0', "last_notification" timestamp NULL DEFAULT NULL, "next_notification" timestamp NULL DEFAULT NULL, "no_more_notifications" smallint(6) DEFAULT '0', "notifications_enabled" smallint(6) DEFAULT '0', "problem_has_been_acknowledged" smallint(6) DEFAULT '0', "acknowledgement_type" smallint(6) DEFAULT '0', "current_notification_number" int(10) unsigned DEFAULT '0', "passive_checks_enabled" smallint(6) DEFAULT '0', "active_checks_enabled" smallint(6) DEFAULT '0', "event_handler_enabled" smallint(6) DEFAULT '0', "flap_detection_enabled" smallint(6) DEFAULT '0', "is_flapping" smallint(6) DEFAULT '0', "percent_state_change" double DEFAULT '0', "latency" double DEFAULT '0', "execution_time" double DEFAULT '0', "scheduled_downtime_depth" smallint(6) DEFAULT '0', "failure_prediction_enabled" smallint(6) DEFAULT '0', "process_performance_data" smallint(6) DEFAULT '0', "obsess_over_host" smallint(6) DEFAULT '0', "modified_host_attributes" int(11) DEFAULT '0', "original_attributes" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "event_handler" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "check_command" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "normal_check_interval" double DEFAULT '0', "retry_check_interval" double DEFAULT '0', "check_timeperiod_object_id" bigint(20) unsigned DEFAULT '0', "is_reachable" smallint(6) DEFAULT '0', "endpoint_object_id" bigint(20) DEFAULT NULL, PRIMARY KEY ("hoststatus_id") /*T![clustered_index] CLUSTERED */, UNIQUE KEY "object_id" ("host_object_id"), KEY "hoststatus_i_id_idx" ("instance_id"), KEY "hoststatus_stat_upd_time_idx" ("status_update_time"), KEY "hoststatus_current_state_idx" ("current_state"), KEY "hoststatus_check_type_idx" ("check_type"), KEY "hoststatus_state_type_idx" ("state_type"), KEY "hoststatus_last_state_chg_idx" ("last_state_change"), KEY "hoststatus_notif_enabled_idx" ("notifications_enabled"), KEY "hoststatus_problem_ack_idx" ("problem_has_been_acknowledged"), KEY "hoststatus_act_chks_en_idx" ("active_checks_enabled"), KEY "hoststatus_pas_chks_en_idx" ("passive_checks_enabled"), KEY "hoststatus_event_hdl_en_idx" ("event_handler_enabled"), KEY "hoststatus_flap_det_en_idx" ("flap_detection_enabled"), KEY "hoststatus_is_flapping_idx" ("is_flapping"), KEY "hoststatus_p_state_chg_idx" ("percent_state_change"), KEY "hoststatus_latency_idx" ("latency"), KEY "hoststatus_ex_time_idx" ("execution_time"), KEY "hoststatus_sch_downt_d_idx" ("scheduled_downtime_depth") ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30002 COMMENT='Current host status information'; CREATE TABLE "icinga_hosts" ( "host_id" bigint(20) unsigned NOT NULL AUTO_INCREMENT, "instance_id" bigint(20) unsigned DEFAULT '0', "config_type" smallint(6) DEFAULT '0', "host_object_id" bigint(20) unsigned DEFAULT '0', "alias" varchar(255) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '', "display_name" varchar(255) CHARACTER SET latin1 COLLATE latin1_general_cs DEFAULT '', "address" varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '', "address6" varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '', "check_command_object_id" bigint(20) unsigned DEFAULT '0', "check_command_args" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "eventhandler_command_object_id" bigint(20) unsigned DEFAULT '0', "eventhandler_command_args" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "notification_timeperiod_object_id" bigint(20) unsigned DEFAULT '0', "check_timeperiod_object_id" bigint(20) unsigned DEFAULT '0', "failure_prediction_options" varchar(128) CHARACTER SET latin1 COLLATE latin1_bin DEFAULT '', "check_interval" double DEFAULT '0', "retry_interval" double DEFAULT '0', "max_check_attempts" smallint(6) DEFAULT '0', "first_notification_delay" double DEFAULT '0', "notification_interval" double DEFAULT '0', "notify_on_down" smallint(6) DEFAULT '0', "notify_on_unreachable" smallint(6) DEFAULT '0', "notify_on_recovery" smallint(6) DEFAULT '0', "notify_on_flapping" smallint(6) DEFAULT '0', "notify_on_downtime" smallint(6) DEFAULT '0', "stalk_on_up" smallint(6) DEFAULT '0', "stalk_on_down" smallint(6) DEFAULT '0', "stalk_on_unreachable" smallint(6) DEFAULT '0', "flap_detection_enabled" smallint(6) DEFAULT '0', "flap_detection_on_up" smallint(6) DEFAULT '0', "flap_detection_on_down" smallint(6) DEFAULT '0', "flap_detection_on_unreachable" smallint(6) DEFAULT '0', "low_flap_threshold" double DEFAULT '0', "high_flap_threshold" double DEFAULT '0', "process_performance_data" smallint(6) DEFAULT '0', "freshness_checks_enabled" smallint(6) DEFAULT '0', "freshness_threshold" int(11) DEFAULT '0', "passive_checks_enabled" smallint(6) DEFAULT '0', "event_handler_enabled" smallint(6) DEFAULT '0', "active_checks_enabled" smallint(6) DEFAULT '0', "retain_status_information" smallint(6) DEFAULT '0', "retain_nonstatus_information" smallint(6) DEFAULT '0', "notifications_enabled" smallint(6) DEFAULT '0', "obsess_over_host" smallint(6) DEFAULT '0', "failure_prediction_enabled" smallint(6) DEFAULT '0', "notes" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "notes_url" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "action_url" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "icon_image" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "icon_image_alt" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "vrml_image" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "statusmap_image" text CHARACTER SET latin1 COLLATE latin1_bin DEFAULT NULL, "have_2d_coords" smallint(6) DEFAULT '0', "x_2d" smallint(6) DEFAULT '0', "y_2d" smallint(6) DEFAULT '0', "have_3d_coords" smallint(6) DEFAULT '0', "x_3d" double DEFAULT '0', "y_3d" double DEFAULT '0', "z_3d" double DEFAULT '0', "config_hash" varchar(64) DEFAULT NULL, PRIMARY KEY ("host_id") /*T![clustered_index] CLUSTERED */, UNIQUE KEY "instance_id" ("instance_id","config_type","host_object_id"), KEY "host_object_id" ("host_object_id"), KEY "hosts_i_id_idx" ("instance_id"), KEY "hosts_host_object_id_idx" ("host_object_id") ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin AUTO_INCREMENT=30002 COMMENT='Host definitions';