| Tables_in_centreon_storage | +--------------------------------+ | acknowledgements | | centreon_acl | | comments | | config | | customvariables | | data_bin | | data_stats_daily | | data_stats_monthly | | data_stats_yearly | | downtimes | | eventhandlers | | flappingstatuses | | hostgroups | | hosts | | hosts_hostgroups | | hosts_hosts_dependencies | | hosts_hosts_parents | | hoststateevents | | index_data | | instances | | issues | | issues_issues_parents | | log_action | | log_action_modification | | log_archive_host | | log_archive_last_status | | log_archive_service | | log_traps | | log_traps_args | | logs | | metrics | | modules | | nagios_stats | | notifications | | schemaversion | | servicegroups | | services | | services_servicegroups | | services_services_dependencies | | servicestateevents | +--------------------------------+ MariaDB [centreon_storage]> describe servicestateevents; +----------------------+-------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+-------------+------+-----+---------+----------------+ | servicestateevent_id | int(11) | NO | PRI | NULL | auto_increment | | end_time | int(11) | YES | MUL | NULL | | | host_id | int(11) | NO | MUL | NULL | | | service_id | int(11) | YES | | NULL | | | start_time | int(11) | NO | MUL | NULL | | | state | tinyint(11) | NO | | NULL | | | last_update | tinyint(4) | NO | | 0 | | | in_downtime | tinyint(4) | NO | | NULL | | | ack_time | int(11) | YES | | NULL | | | in_ack | tinyint(4) | YES | | 0 | | +----------------------+-------------+------+-----+---------+----------------+ MariaDB [centreon_storage]> describe hosts; +-------------------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------------+--------------+------+-----+---------+-------+ | host_id | int(11) | NO | PRI | NULL | | | name | varchar(255) | NO | MUL | NULL | | | instance_id | int(11) | NO | MUL | NULL | | | acknowledged | tinyint(1) | YES | | NULL | | | acknowledgement_type | smallint(6) | YES | | NULL | | | action_url | varchar(255) | YES | | NULL | | | active_checks | tinyint(1) | YES | | NULL | | | address | varchar(75) | YES | | NULL | | | alias | varchar(100) | YES | | NULL | | | check_attempt | smallint(6) | YES | | NULL | | | check_command | text | YES | | NULL | | | check_freshness | tinyint(1) | YES | | NULL | | | check_interval | double | YES | | NULL | | | check_period | varchar(75) | YES | | NULL | | | check_type | smallint(6) | YES | | NULL | | | checked | tinyint(1) | YES | | NULL | | | command_line | text | YES | | NULL | | | default_active_checks | tinyint(1) | YES | | NULL | | | default_event_handler_enabled | tinyint(1) | YES | | NULL | | | default_failure_prediction | tinyint(1) | YES | | NULL | | | default_flap_detection | tinyint(1) | YES | | NULL | | | default_notify | tinyint(1) | YES | | NULL | | | default_passive_checks | tinyint(1) | YES | | NULL | | | default_process_perfdata | tinyint(1) | YES | | NULL | | | display_name | varchar(100) | YES | | NULL | | | enabled | tinyint(1) | NO | | 1 | | | event_handler | varchar(255) | YES | | NULL | | | event_handler_enabled | tinyint(1) | YES | | NULL | | | execution_time | double | YES | | NULL | | | failure_prediction | tinyint(1) | YES | | NULL | | | first_notification_delay | double | YES | | NULL | | | flap_detection | tinyint(1) | YES | | NULL | | | flap_detection_on_down | tinyint(1) | YES | | NULL | | | flap_detection_on_unreachable | tinyint(1) | YES | | NULL | | | flap_detection_on_up | tinyint(1) | YES | | NULL | | | flapping | tinyint(1) | YES | | NULL | | | freshness_threshold | double | YES | | NULL | | | high_flap_threshold | double | YES | | NULL | | | icon_image | varchar(255) | YES | | NULL | | | icon_image_alt | varchar(255) | YES | | NULL | | | last_check | int(11) | YES | | NULL | | | last_hard_state | smallint(6) | YES | | NULL | | | last_hard_state_change | int(11) | YES | | NULL | | | last_notification | int(11) | YES | | NULL | | | last_state_change | int(11) | YES | | NULL | | | last_time_down | int(11) | YES | | NULL | | | last_time_unreachable | int(11) | YES | | NULL | | | last_time_up | int(11) | YES | | NULL | | | last_update | int(11) | YES | | NULL | | | latency | double | YES | | NULL | | | low_flap_threshold | double | YES | | NULL | | | max_check_attempts | smallint(6) | YES | | NULL | | | modified_attributes | int(11) | YES | | NULL | | | next_check | int(11) | YES | | NULL | | | next_host_notification | int(11) | YES | | NULL | | | no_more_notifications | tinyint(1) | YES | | NULL | | | notes | varchar(255) | YES | | NULL | | | notes_url | varchar(255) | YES | | NULL | | | notification_interval | double | YES | | NULL | | | notification_number | smallint(6) | YES | | NULL | | | notification_period | varchar(75) | YES | | NULL | | | notify | tinyint(1) | YES | | NULL | | | notify_on_down | tinyint(1) | YES | | NULL | | | notify_on_downtime | tinyint(1) | YES | | NULL | | | notify_on_flapping | tinyint(1) | YES | | NULL | | | notify_on_recovery | tinyint(1) | YES | | NULL | | | notify_on_unreachable | tinyint(1) | YES | | NULL | | | obsess_over_host | tinyint(1) | YES | | NULL | | | output | text | YES | | NULL | | | passive_checks | tinyint(1) | YES | | NULL | | | percent_state_change | double | YES | | NULL | | | perfdata | text | YES | | NULL | | | process_perfdata | tinyint(1) | YES | | NULL | | | retain_nonstatus_information | tinyint(1) | YES | | NULL | | | retain_status_information | tinyint(1) | YES | | NULL | | | retry_interval | double | YES | | NULL | | | scheduled_downtime_depth | smallint(6) | YES | | NULL | | | should_be_scheduled | tinyint(1) | YES | | NULL | | | stalk_on_down | tinyint(1) | YES | | NULL | | | stalk_on_unreachable | tinyint(1) | YES | | NULL | | | stalk_on_up | tinyint(1) | YES | | NULL | | | state | smallint(6) | YES | | NULL | | | state_type | smallint(6) | YES | | NULL | | | statusmap_image | varchar(255) | YES | | NULL | | | timezone | varchar(64) | YES | | NULL | | | real_state | smallint(6) | YES | | NULL | | +-------------------------------+--------------+------+-----+---------+-------+ MariaDB [centreon_storage]> describe services; +-------------------------------+--------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-------------------------------+--------------+------+-----+---------+-------+ | host_id | int(11) | NO | PRI | NULL | | | description | varchar(255) | NO | MUL | NULL | | | service_id | int(11) | NO | PRI | NULL | | | acknowledged | tinyint(1) | YES | | NULL | | | acknowledgement_type | smallint(6) | YES | | NULL | | | action_url | varchar(255) | YES | | NULL | | | active_checks | tinyint(1) | YES | | NULL | | | check_attempt | smallint(6) | YES | | NULL | | | check_command | text | YES | | NULL | | | check_freshness | tinyint(1) | YES | | NULL | | | check_interval | double | YES | | NULL | | | check_period | varchar(75) | YES | | NULL | | | check_type | smallint(6) | YES | | NULL | | | checked | tinyint(1) | YES | | NULL | | | command_line | text | YES | | NULL | | | default_active_checks | tinyint(1) | YES | | NULL | | | default_event_handler_enabled | tinyint(1) | YES | | NULL | | | default_failure_prediction | tinyint(1) | YES | | NULL | | | default_flap_detection | tinyint(1) | YES | | NULL | | | default_notify | tinyint(1) | YES | | NULL | | | default_passive_checks | tinyint(1) | YES | | NULL | | | default_process_perfdata | tinyint(1) | YES | | NULL | | | display_name | varchar(160) | YES | | NULL | | | enabled | tinyint(1) | NO | | 1 | | | event_handler | varchar(255) | YES | | NULL | | | event_handler_enabled | tinyint(1) | YES | | NULL | | | execution_time | double | YES | | NULL | | | failure_prediction | tinyint(1) | YES | | NULL | | | failure_prediction_options | varchar(64) | YES | | NULL | | | first_notification_delay | double | YES | | NULL | | | flap_detection | tinyint(1) | YES | | NULL | | | flap_detection_on_critical | tinyint(1) | YES | | NULL | | | flap_detection_on_ok | tinyint(1) | YES | | NULL | | | flap_detection_on_unknown | tinyint(1) | YES | | NULL | | | flap_detection_on_warning | tinyint(1) | YES | | NULL | | | flapping | tinyint(1) | YES | | NULL | | | freshness_threshold | double | YES | | NULL | | | high_flap_threshold | double | YES | | NULL | | | icon_image | varchar(255) | YES | | NULL | | | icon_image_alt | varchar(255) | YES | | NULL | | | last_check | int(11) | YES | | NULL | | | last_hard_state | smallint(6) | YES | | NULL | | | last_hard_state_change | int(11) | YES | MUL | NULL | | | last_notification | int(11) | YES | | NULL | | | last_state_change | int(11) | YES | | NULL | | | last_time_critical | int(11) | YES | | NULL | | | last_time_ok | int(11) | YES | | NULL | | | last_time_unknown | int(11) | YES | | NULL | | | last_time_warning | int(11) | YES | | NULL | | | last_update | int(11) | YES | | NULL | | | latency | double | YES | | NULL | | | low_flap_threshold | double | YES | | NULL | | | max_check_attempts | smallint(6) | YES | | NULL | | | modified_attributes | int(11) | YES | | NULL | | | next_check | int(11) | YES | | NULL | | | next_notification | int(11) | YES | | NULL | | | no_more_notifications | tinyint(1) | YES | | NULL | | | notes | varchar(255) | YES | | NULL | | | notes_url | varchar(255) | YES | | NULL | | | notification_interval | double | YES | | NULL | | | notification_number | smallint(6) | YES | | NULL | | | notification_period | varchar(75) | YES | | NULL | | | notify | tinyint(1) | YES | | NULL | | | notify_on_critical | tinyint(1) | YES | | NULL | | | notify_on_downtime | tinyint(1) | YES | | NULL | | | notify_on_flapping | tinyint(1) | YES | | NULL | | | notify_on_recovery | tinyint(1) | YES | | NULL | | | notify_on_unknown | tinyint(1) | YES | | NULL | | | notify_on_warning | tinyint(1) | YES | | NULL | | | obsess_over_service | tinyint(1) | YES | | NULL | | | output | text | YES | | NULL | | | passive_checks | tinyint(1) | YES | | NULL | | | percent_state_change | double | YES | | NULL | | | perfdata | text | YES | | NULL | | | process_perfdata | tinyint(1) | YES | | NULL | | | retain_nonstatus_information | tinyint(1) | YES | | NULL | | | retain_status_information | tinyint(1) | YES | | NULL | | | retry_interval | double | YES | | NULL | | | scheduled_downtime_depth | smallint(6) | YES | | NULL | | | should_be_scheduled | tinyint(1) | YES | | NULL | | | stalk_on_critical | tinyint(1) | YES | | NULL | | | stalk_on_ok | tinyint(1) | YES | | NULL | | | stalk_on_unknown | tinyint(1) | YES | | NULL | | | stalk_on_warning | tinyint(1) | YES | | NULL | | | state | smallint(6) | YES | | NULL | | | state_type | smallint(6) | YES | | NULL | | | volatile | tinyint(1) | YES | | NULL | | | real_state | smallint(6) | YES | | NULL | | +-------------------------------+--------------+------+-----+---------+-------+