<code>
| 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    |       |
+-------------------------------+--------------+------+-----+---------+-------+
</code>