| Structure | zabbix | zabbix_clean |
|---|---|---|
| Database | zabbix | zabbix_clean |
| Tables | Tables | Tables |
| Table | acknowledges | acknowledges |
| Partitions | Partitions | N/A |
| Table | actions | actions |
| Columns | Columns | Columns |
| Column | def_shortdata | N/A |
| Column | def_longdata | N/A |
| Column | r_shortdata | N/A |
| Column | r_longdata | N/A |
| Column | ack_shortdata | N/A |
| Column | ack_longdata | N/A |
| Partitions | Partitions | N/A |
| Table | alerts | alerts |
| Partitions | Partitions | N/A |
| Table | application_discovery | N/A |
| Table | application_prototype | N/A |
| Table | application_template | N/A |
| Table | applications | N/A |
| Table | auditlog | auditlog |
| Columns | Columns | Columns |
| Column | details | N/A |
| Column | N/A | note |
| Indexes | Indexes | Indexes |
| Index | N/A | auditlog_3 |
| Partitions | Partitions | N/A |
| Table | auditlog_details | auditlog_details |
| Partitions | Partitions | N/A |
| Table | autoreg_host | autoreg_host |
| Partitions | Partitions | N/A |
| Table | conditions | conditions |
| Partitions | Partitions | N/A |
| Table | config | config |
| Columns | Columns | Columns |
| Column | refresh_unsupported | N/A |
| Column | dropdown_first_entry | N/A |
| Column | dropdown_first_remember | N/A |
| Column | N/A | compression_status |
| Column | N/A | compress_older |
| Column | N/A | instanceid |
| Column | N/A | saml_auth_enabled |
| Column | N/A | saml_idp_entityid |
| Column | N/A | saml_sso_url |
| Column | N/A | saml_slo_url |
| Column | N/A | saml_username_attribute |
| Column | N/A | saml_sp_entityid |
| Column | N/A | saml_nameid_format |
| Column | N/A | saml_sign_messages |
| Column | N/A | saml_sign_assertions |
| Column | N/A | saml_sign_authn_requests |
| Column | N/A | saml_sign_logout_requests |
| Column | N/A | saml_sign_logout_responses |
| Column | N/A | saml_encrypt_nameid |
| Column | N/A | saml_encrypt_assertions |
| Column | N/A | saml_case_sensitive |
| Column | N/A | default_lang |
| Column | N/A | default_timezone |
| Column | N/A | login_attempts |
| Column | N/A | login_block |
| Column | N/A | show_technical_errors |
| Column | N/A | validate_uri_schemes |
| Column | N/A | uri_valid_schemes |
| Column | N/A | x_frame_options |
| Column | N/A | iframe_sandboxing_enabled |
| Column | N/A | iframe_sandboxing_exceptions |
| Column | N/A | max_overview_table_size |
| Column | N/A | history_period |
| Column | N/A | period_default |
| Column | N/A | max_period |
| Column | N/A | socket_timeout |
| Column | N/A | connect_timeout |
| Column | N/A | media_type_test_timeout |
| Column | N/A | script_timeout |
| Column | N/A | item_test_timeout |
| Column | N/A | session_key |
| Column | N/A | url |
| Column | N/A | report_test_timeout |
| Column | N/A | dbversion_status |
| Partitions | Partitions | N/A |
| Table | config_autoreg_tls | config_autoreg_tls |
| Partitions | Partitions | N/A |
| Table | corr_condition | corr_condition |
| Partitions | Partitions | N/A |
| Table | corr_condition_group | corr_condition_group |
| Partitions | Partitions | N/A |
| Table | corr_condition_tag | corr_condition_tag |
| Partitions | Partitions | N/A |
| Table | corr_condition_tagpair | corr_condition_tagpair |
| Partitions | Partitions | N/A |
| Table | corr_condition_tagvalue | corr_condition_tagvalue |
| Partitions | Partitions | N/A |
| Table | corr_operation | corr_operation |
| Partitions | Partitions | N/A |
| Table | correlation | correlation |
| Partitions | Partitions | N/A |
| Table | dashboard | dashboard |
| Columns | Columns | Columns |
| Column | N/A | templateid |
| Column | N/A | display_period |
| Column | N/A | auto_start |
| Column | N/A | uuid |
| Foreign Keys | Foreign Keys | Foreign Keys |
| Foreign Key | N/A | c_dashboard_2 |
| Indexes | Indexes | Indexes |
| Index | c_dashboard_1 | N/A |
| Index | N/A | dashboard_1 |
| Index | N/A | dashboard_2 |
| Partitions | Partitions | N/A |
| Table | dashboard_user | dashboard_user |
| Partitions | Partitions | N/A |
| Table | dashboard_usrgrp | dashboard_usrgrp |
| Partitions | Partitions | N/A |
| Table | dbversion | dbversion |
| Partitions | Partitions | N/A |
| Table | dchecks | dchecks |
| Partitions | Partitions | N/A |
| Table | dhosts | dhosts |
| Partitions | Partitions | N/A |
| Table | drules | drules |
| Partitions | Partitions | N/A |
| Table | dservices | dservices |
| Partitions | Partitions | N/A |
| Table | escalations | escalations |
| Partitions | Partitions | N/A |
| Table | event_recovery | event_recovery |
| Partitions | Partitions | N/A |
| Table | event_suppress | event_suppress |
| Partitions | Partitions | N/A |
| Table | event_tag | event_tag |
| Partitions | Partitions | N/A |
| Table | events | events |
| Partitions | Partitions | N/A |
| Table | expressions | expressions |
| Partitions | Partitions | N/A |
| Table | functions | functions |
| Partitions | Partitions | N/A |
| Table | globalmacro | globalmacro |
| Columns | Columns | Columns |
| Column | N/A | type |
| Partitions | Partitions | N/A |
| Table | globalvars | globalvars |
| Partitions | Partitions | N/A |
| Table | graph_discovery | graph_discovery |
| Columns | Columns | Columns |
| Column | N/A | lastcheck |
| Column | N/A | ts_delete |
| Partitions | Partitions | N/A |
| Table | graph_theme | graph_theme |
| Partitions | Partitions | N/A |
| Table | graphs | graphs |
| Columns | Columns | Columns |
| Column | N/A | discover |
| Column | N/A | uuid |
| Partitions | Partitions | N/A |
| Table | graphs_items | graphs_items |
| Partitions | Partitions | N/A |
| Table | group_discovery | group_discovery |
| Partitions | Partitions | N/A |
| Table | group_prototype | group_prototype |
| Partitions | Partitions | N/A |
| Table | history | history |
| Partitions | Partitions | N/A |
| Table | history_log | history_log |
| Partitions | Partitions | N/A |
| Table | history_str | history_str |
| Partitions | Partitions | N/A |
| Table | history_text | history_text |
| Partitions | Partitions | N/A |
| Table | history_uint | history_uint |
| Partitions | Partitions | N/A |
| Table | host_discovery | host_discovery |
| Partitions | Partitions | N/A |
| Table | host_inventory | host_inventory |
| Partitions | Partitions | N/A |
| Table | host_tag | host_tag |
| Partitions | Partitions | N/A |
| Table | hostmacro | hostmacro |
| Columns | Columns | Columns |
| Column | N/A | type |
| Partitions | Partitions | N/A |
| Table | hosts | hosts |
| Columns | Columns | Columns |
| Column | disable_until | N/A |
| Column | error | N/A |
| Column | available | N/A |
| Column | errors_from | N/A |
| Column | ipmi_disable_until | N/A |
| Column | ipmi_available | N/A |
| Column | snmp_disable_until | N/A |
| Column | snmp_available | N/A |
| Column | ipmi_errors_from | N/A |
| Column | snmp_errors_from | N/A |
| Column | ipmi_error | N/A |
| Column | snmp_error | N/A |
| Column | jmx_disable_until | N/A |
| Column | jmx_available | N/A |
| Column | jmx_errors_from | N/A |
| Column | jmx_error | N/A |
| Column | N/A | discover |
| Column | N/A | custom_interfaces |
| Column | N/A | uuid |
| Partitions | Partitions | N/A |
| Table | hosts_groups | hosts_groups |
| Partitions | Partitions | N/A |
| Table | hosts_templates | hosts_templates |
| Partitions | Partitions | N/A |
| Table | housekeeper | housekeeper |
| Partitions | Partitions | N/A |
| Table | hstgrp | hstgrp |
| Columns | Columns | Columns |
| Column | N/A | uuid |
| Partitions | Partitions | N/A |
| Table | httpstep | httpstep |
| Partitions | Partitions | N/A |
| Table | httpstep_field | httpstep_field |
| Partitions | Partitions | N/A |
| Table | httpstepitem | httpstepitem |
| Partitions | Partitions | N/A |
| Table | httptest | httptest |
| Columns | Columns | Columns |
| Column | applicationid | N/A |
| Column | N/A | uuid |
| Foreign Keys | Foreign Keys | Foreign Keys |
| Foreign Key | c_httptest_1 | N/A |
| Indexes | Indexes | Indexes |
| Index | httptest_1 | N/A |
| Partitions | Partitions | N/A |
| Table | httptest_field | httptest_field |
| Partitions | Partitions | N/A |
| Table | httptestitem | httptestitem |
| Partitions | Partitions | N/A |
| Table | icon_map | icon_map |
| Partitions | Partitions | N/A |
| Table | icon_mapping | icon_mapping |
| Partitions | Partitions | N/A |
| Table | ids | ids |
| Partitions | Partitions | N/A |
| Table | images | images |
| Partitions | Partitions | N/A |
| Table | interface | interface |
| Columns | Columns | Columns |
| Column | bulk | N/A |
| Column | N/A | available |
| Column | N/A | error |
| Column | N/A | errors_from |
| Column | N/A | disable_until |
| Indexes | Indexes | Indexes |
| Index | N/A | interface_3 |
| Partitions | Partitions | N/A |
| Table | interface_discovery | interface_discovery |
| Partitions | Partitions | N/A |
| Table | item_application_prototype | N/A |
| Table | item_condition | item_condition |
| Partitions | Partitions | N/A |
| Table | item_discovery | item_discovery |
| Partitions | Partitions | N/A |
| Table | item_preproc | item_preproc |
| Partitions | Partitions | N/A |
| Table | item_rtdata | item_rtdata |
| Partitions | Partitions | N/A |
| Table | items | items |
| Columns | Columns | Columns |
| Column | snmp_community | N/A |
| Column | snmpv3_securityname | N/A |
| Column | snmpv3_securitylevel | N/A |
| Column | snmpv3_authpassphrase | N/A |
| Column | snmpv3_privpassphrase | N/A |
| Column | port | N/A |
| Column | snmpv3_authprotocol | N/A |
| Column | snmpv3_privprotocol | N/A |
| Column | snmpv3_contextname | N/A |
| Column | N/A | discover |
| Column | N/A | uuid |
| Constraints | Constraints | Constraints |
| Constraint | items_1 | N/A |
| Indexes | Indexes | Indexes |
| Index | N/A | items_8 |
| Partitions | Partitions | N/A |
| Table | items_applications | N/A |
| Table | lld_macro_path | lld_macro_path |
| Partitions | Partitions | N/A |
| Table | maintenance_tag | maintenance_tag |
| Partitions | Partitions | N/A |
| Table | maintenances | maintenances |
| Partitions | Partitions | N/A |
| Table | maintenances_groups | maintenances_groups |
| Partitions | Partitions | N/A |
| Table | maintenances_hosts | maintenances_hosts |
| Partitions | Partitions | N/A |
| Table | maintenances_windows | maintenances_windows |
| Partitions | Partitions | N/A |
| Table | mappings | N/A |
| Table | media | media |
| Partitions | Partitions | N/A |
| Table | media_type | media_type |
| Partitions | Partitions | N/A |
| Table | media_type_param | media_type_param |
| Partitions | Partitions | N/A |
| Table | opcommand | opcommand |
| Columns | Columns | Columns |
| Column | type | N/A |
| Column | execute_on | N/A |
| Column | port | N/A |
| Column | authtype | N/A |
| Column | username | N/A |
| Column | password | N/A |
| Column | publickey | N/A |
| Column | privatekey | N/A |
| Column | command | N/A |
| Partitions | Partitions | N/A |
| Table | opcommand_grp | opcommand_grp |
| Partitions | Partitions | N/A |
| Table | opcommand_hst | opcommand_hst |
| Partitions | Partitions | N/A |
| Table | opconditions | opconditions |
| Partitions | Partitions | N/A |
| Table | operations | operations |
| Partitions | Partitions | N/A |
| Table | opgroup | opgroup |
| Partitions | Partitions | N/A |
| Table | opinventory | opinventory |
| Partitions | Partitions | N/A |
| Table | opmessage | opmessage |
| Partitions | Partitions | N/A |
| Table | opmessage_grp | opmessage_grp |
| Partitions | Partitions | N/A |
| Table | opmessage_usr | opmessage_usr |
| Partitions | Partitions | N/A |
| Table | optemplate | optemplate |
| Partitions | Partitions | N/A |
| Table | problem | problem |
| Partitions | Partitions | N/A |
| Table | problem_tag | problem_tag |
| Partitions | Partitions | N/A |
| Table | profiles | profiles |
| Partitions | Partitions | N/A |
| Table | proxy_autoreg_host | proxy_autoreg_host |
| Partitions | Partitions | N/A |
| Table | proxy_dhistory | proxy_dhistory |
| Partitions | Partitions | N/A |
| Table | proxy_history | proxy_history |
| Columns | Columns | Columns |
| Column | N/A | write_clock |
| Partitions | Partitions | N/A |
| Table | regexps | regexps |
| Partitions | Partitions | N/A |
| Table | rights | rights |
| Partitions | Partitions | N/A |
| Table | screen_user | N/A |
| Table | screen_usrgrp | N/A |
| Table | screens | N/A |
| Table | screens_items | N/A |
| Table | scripts | scripts |
| Columns | Columns | Columns |
| Column | N/A | timeout |
| Column | N/A | scope |
| Column | N/A | port |
| Column | N/A | authtype |
| Column | N/A | username |
| Column | N/A | password |
| Column | N/A | publickey |
| Column | N/A | privatekey |
| Column | N/A | menu_path |
| Partitions | Partitions | N/A |
| Table | service_alarms | service_alarms |
| Partitions | Partitions | N/A |
| Table | services | services |
| Partitions | Partitions | N/A |
| Table | services_links | services_links |
| Partitions | Partitions | N/A |
| Table | services_times | services_times |
| Partitions | Partitions | N/A |
| Table | sessions | sessions |
| Partitions | Partitions | N/A |
| Table | slides | N/A |
| Table | slideshow_user | N/A |
| Table | slideshow_usrgrp | N/A |
| Table | slideshows | N/A |
| Table | sysmap_element_trigger | sysmap_element_trigger |
| Partitions | Partitions | N/A |
| Table | sysmap_element_url | sysmap_element_url |
| Partitions | Partitions | N/A |
| Table | sysmap_shape | sysmap_shape |
| Partitions | Partitions | N/A |
| Table | sysmap_url | sysmap_url |
| Partitions | Partitions | N/A |
| Table | sysmap_user | sysmap_user |
| Partitions | Partitions | N/A |
| Table | sysmap_usrgrp | sysmap_usrgrp |
| Partitions | Partitions | N/A |
| Table | sysmaps | sysmaps |
| Partitions | Partitions | N/A |
| Table | sysmaps_elements | sysmaps_elements |
| Columns | Columns | Columns |
| Column | application | N/A |
| Column | N/A | evaltype |
| Partitions | Partitions | N/A |
| Table | sysmaps_link_triggers | sysmaps_link_triggers |
| Partitions | Partitions | N/A |
| Table | sysmaps_links | sysmaps_links |
| Partitions | Partitions | N/A |
| Table | tag_filter | tag_filter |
| Partitions | Partitions | N/A |
| Table | task | task |
| Partitions | Partitions | N/A |
| Table | task_acknowledge | task_acknowledge |
| Partitions | Partitions | N/A |
| Table | task_check_now | task_check_now |
| Partitions | Partitions | N/A |
| Table | task_close_problem | task_close_problem |
| Partitions | Partitions | N/A |
| Table | task_remote_command | task_remote_command |
| Partitions | Partitions | N/A |
| Table | task_remote_command_result | task_remote_command_result |
| Partitions | Partitions | N/A |
| Table | timeperiods | timeperiods |
| Partitions | Partitions | N/A |
| Table | trends | trends |
| Partitions | Partitions | N/A |
| Table | trends_uint | trends_uint |
| Partitions | Partitions | N/A |
| Table | trigger_depends | trigger_depends |
| Partitions | Partitions | N/A |
| Table | trigger_discovery | trigger_discovery |
| Columns | Columns | Columns |
| Column | N/A | lastcheck |
| Column | N/A | ts_delete |
| Partitions | Partitions | N/A |
| Table | trigger_tag | trigger_tag |
| Partitions | Partitions | N/A |
| Table | triggers | triggers |
| Columns | Columns | Columns |
| Column | N/A | discover |
| Column | N/A | event_name |
| Column | N/A | uuid |
| Partitions | Partitions | N/A |
| Table | users | users |
| Columns | Columns | Columns |
| Column | alias | N/A |
| Column | type | N/A |
| Column | N/A | username |
| Column | N/A | timezone |
| Column | N/A | roleid |
| Constraints | Constraints | Constraints |
| Constraint | users_1 | users_1 |
| Constraint columns | alias | N/A |
| Constraint columns | N/A | username |
| Foreign Keys | Foreign Keys | Foreign Keys |
| Foreign Key | N/A | c_users_1 |
| Indexes | Indexes | Indexes |
| Index | users_1 | users_1 |
| Column | alias | N/A |
| Column | N/A | username |
| Index | N/A | c_users_1 |
| Partitions | Partitions | N/A |
| Table | users_groups | users_groups |
| Partitions | Partitions | N/A |
| Table | usrgrp | usrgrp |
| Partitions | Partitions | N/A |
| Table | valuemaps | N/A |
| Table | widget | widget |
| Columns | Columns | Columns |
| Column | dashboardid | N/A |
| Column | N/A | dashboard_pageid |
| Foreign Keys | Foreign Keys | Foreign Keys |
| Foreign Key | c_widget_1 | c_widget_1 |
| Column | dashboardid | N/A |
| Column | N/A | dashboard_pageid |
| Indexes | Indexes | Indexes |
| Index | widget_1 | widget_1 |
| Column | dashboardid | N/A |
| Column | N/A | dashboard_pageid |
| Partitions | Partitions | N/A |
| Table | widget_field | widget_field |
| Partitions | Partitions | N/A |
| Table | N/A | dashboard_page |
| Table | N/A | httptest_tag |
| Table | N/A | interface_snmp |
| Table | N/A | item_parameter |
| Table | N/A | item_tag |
| Table | N/A | lld_override |
| Table | N/A | lld_override_condition |
| Table | N/A | lld_override_opdiscover |
| Table | N/A | lld_override_operation |
| Table | N/A | lld_override_ophistory |
| Table | N/A | lld_override_opinventory |
| Table | N/A | lld_override_opperiod |
| Table | N/A | lld_override_opseverity |
| Table | N/A | lld_override_opstatus |
| Table | N/A | lld_override_optag |
| Table | N/A | lld_override_optemplate |
| Table | N/A | lld_override_optrends |
| Table | N/A | media_type_message |
| Table | N/A | module |
| Table | N/A | report |
| Table | N/A | report_param |
| Table | N/A | report_user |
| Table | N/A | report_usrgrp |
| Table | N/A | role |
| Table | N/A | role_rule |
| Table | N/A | script_param |
| Table | N/A | sysmaps_element_tag |
| Table | N/A | task_data |
| Table | N/A | task_result |
| Table | N/A | token |
| Table | N/A | trigger_queue |
| Table | N/A | valuemap |
| Table | N/A | valuemap_mapping |
| Packages | N/A | Packages |
| Sequences | N/A | Sequences |
| 3649 objects compared | ||