--
-- Zabbix
-- Copyright (C) 2001-2016 Zabbix SIA
--
-- This program is free software; you can redistribute it and/or modify
-- it under the terms of the GNU General Public License as published by
-- the Free Software Foundation; either version 2 of the License, or
-- (at your option) any later version.
--
-- This program is distributed in the hope that it will be useful,
-- but WITHOUT ANY WARRANTY; without even the implied warranty of
-- MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
-- GNU General Public License for more details.
--
-- You should have received a copy of the GNU General Public License
-- along with this program; if not, write to the Free Software
-- Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
--

--
-- Do not use spaces
-- Tables must be sorted to match referential integrity rules
--

TABLE|maintenances|maintenanceid|ZBX_DATA
FIELD		|maintenanceid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|maintenance_type|t_integer	|'0'	|NOT NULL	|0
FIELD		|description	|t_shorttext	|''	|NOT NULL	|0
FIELD		|active_since	|t_integer	|'0'	|NOT NULL	|0
FIELD		|active_till	|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|active_since,active_till
UNIQUE		|2		|name

TABLE|hosts|hostid|ZBX_DATA
FIELD		|hostid		|t_id		|	|NOT NULL	|0
FIELD		|proxy_hostid	|t_id		|	|NULL		|0			|1|hosts	|hostid		|RESTRICT
FIELD		|host		|t_varchar(128)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|disable_until	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|error		|t_varchar(2048)|''	|NOT NULL	|ZBX_NODATA
FIELD		|available	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|errors_from	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|lastaccess	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ipmi_authtype	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|ipmi_privilege	|t_integer	|'2'	|NOT NULL	|ZBX_PROXY
FIELD		|ipmi_username	|t_varchar(16)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|ipmi_password	|t_varchar(20)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|ipmi_disable_until|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ipmi_available	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|snmp_disable_until|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|snmp_available	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|maintenanceid	|t_id		|	|NULL		|ZBX_NODATA		|2|maintenances	|		|RESTRICT
FIELD		|maintenance_status|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|maintenance_type|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|maintenance_from|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ipmi_errors_from|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|snmp_errors_from|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ipmi_error	|t_varchar(2048)|''	|NOT NULL	|ZBX_NODATA
FIELD		|snmp_error	|t_varchar(2048)|''	|NOT NULL	|ZBX_NODATA
FIELD		|jmx_disable_until|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|jmx_available	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|jmx_errors_from|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|jmx_error	|t_varchar(2048)|''	|NOT NULL	|ZBX_NODATA
FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|flags		|t_integer	|'0'	|NOT NULL	|0
FIELD		|templateid	|t_id		|	|NULL		|0			|3|hosts	|hostid
FIELD		|description	|t_shorttext	|''	|NOT NULL	|0
FIELD		|tls_connect	|t_integer	|'1'	|NOT NULL	|ZBX_PROXY
FIELD		|tls_accept	|t_integer	|'1'	|NOT NULL	|ZBX_PROXY
FIELD		|tls_issuer	|t_varchar(1024)|''	|NOT NULL	|ZBX_PROXY
FIELD		|tls_subject	|t_varchar(1024)|''	|NOT NULL	|ZBX_PROXY
FIELD		|tls_psk_identity|t_varchar(128)|''	|NOT NULL	|ZBX_PROXY
FIELD		|tls_psk	|t_varchar(512)	|''	|NOT NULL	|ZBX_PROXY
INDEX		|1		|host
INDEX		|2		|status
INDEX		|3		|proxy_hostid
INDEX		|4		|name
INDEX		|5		|maintenanceid

TABLE|groups|groupid|ZBX_DATA
FIELD		|groupid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|internal	|t_integer	|'0'	|NOT NULL	|0
FIELD		|flags		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|name

TABLE|group_prototype|group_prototypeid|ZBX_DATA
FIELD		|group_prototypeid|t_id		|	|NOT NULL	|0
FIELD		|hostid		|t_id		|	|NOT NULL	|0			|1|hosts
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|groupid	|t_id		|	|NULL		|0			|2|groups	|		|RESTRICT
FIELD		|templateid	|t_id		|	|NULL		|0			|3|group_prototype|group_prototypeid
INDEX		|1		|hostid

TABLE|group_discovery|groupid|ZBX_DATA
FIELD		|groupid	|t_id		|	|NOT NULL	|0			|1|groups
FIELD		|parent_group_prototypeid|t_id	|	|NOT NULL	|0			|2|group_prototype|group_prototypeid|RESTRICT
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|lastcheck	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ts_delete	|t_time		|'0'	|NOT NULL	|ZBX_NODATA

TABLE|screens|screenid|ZBX_DATA
FIELD		|screenid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(255)	|	|NOT NULL	|0
FIELD		|hsize		|t_integer	|'1'	|NOT NULL	|0
FIELD		|vsize		|t_integer	|'1'	|NOT NULL	|0
FIELD		|templateid	|t_id		|	|NULL		|0			|1|hosts	|hostid
FIELD		|userid		|t_id		|	|NULL		|0			|3|users	|		|RESTRICT
FIELD		|private	|t_integer	|'1'	|NOT NULL	|0
INDEX		|1		|templateid

TABLE|screens_items|screenitemid|ZBX_DATA
FIELD		|screenitemid	|t_id		|	|NOT NULL	|0
FIELD		|screenid	|t_id		|	|NOT NULL	|0			|1|screens
FIELD		|resourcetype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|resourceid	|t_id		|'0'	|NOT NULL	|0
FIELD		|width		|t_integer	|'320'	|NOT NULL	|0
FIELD		|height		|t_integer	|'200'	|NOT NULL	|0
FIELD		|x		|t_integer	|'0'	|NOT NULL	|0
FIELD		|y		|t_integer	|'0'	|NOT NULL	|0
FIELD		|colspan	|t_integer	|'1'	|NOT NULL	|0
FIELD		|rowspan	|t_integer	|'1'	|NOT NULL	|0
FIELD		|elements	|t_integer	|'25'	|NOT NULL	|0
FIELD		|valign		|t_integer	|'0'	|NOT NULL	|0
FIELD		|halign		|t_integer	|'0'	|NOT NULL	|0
FIELD		|style		|t_integer	|'0'	|NOT NULL	|0
FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|dynamic	|t_integer	|'0'	|NOT NULL	|0
FIELD		|sort_triggers	|t_integer	|'0'	|NOT NULL	|0
FIELD		|application	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|max_columns	|t_integer	|'3'	|NOT NULL	|0
INDEX		|1		|screenid

TABLE|screen_user|screenuserid|ZBX_DATA
FIELD		|screenuserid|t_id		|	|NOT NULL	|0
FIELD		|screenid	|t_id		|	|NOT NULL	|0			|1|screens
FIELD		|userid		|t_id		|	|NOT NULL	|0			|2|users
FIELD		|permission	|t_integer	|'2'	|NOT NULL	|0
UNIQUE		|1		|screenid,userid

TABLE|screen_usrgrp|screenusrgrpid|ZBX_DATA
FIELD		|screenusrgrpid|t_id		|	|NOT NULL	|0
FIELD		|screenid	|t_id		|	|NOT NULL	|0			|1|screens
FIELD		|usrgrpid	|t_id		|	|NOT NULL	|0			|2|usrgrp
FIELD		|permission	|t_integer	|'2'	|NOT NULL	|0
UNIQUE		|1		|screenid,usrgrpid

TABLE|slideshows|slideshowid|ZBX_DATA
FIELD		|slideshowid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|delay		|t_integer	|'0'	|NOT NULL	|0
FIELD		|userid		|t_id		|	|NOT NULL	|0			|3|users	|		|RESTRICT
FIELD		|private	|t_integer	|'1'	|NOT NULL	|0
UNIQUE		|1		|name

TABLE|slideshow_user|slideshowuserid|ZBX_DATA
FIELD		|slideshowuserid|t_id		|	|NOT NULL	|0
FIELD		|slideshowid	|t_id		|	|NOT NULL	|0			|1|slideshows
FIELD		|userid		|t_id		|	|NOT NULL	|0			|2|users
FIELD		|permission	|t_integer	|'2'	|NOT NULL	|0
UNIQUE		|1		|slideshowid,userid

TABLE|slideshow_usrgrp|slideshowusrgrpid|ZBX_DATA
FIELD		|slideshowusrgrpid|t_id		|	|NOT NULL	|0
FIELD		|slideshowid	|t_id		|	|NOT NULL	|0			|1|slideshows
FIELD		|usrgrpid	|t_id		|	|NOT NULL	|0			|2|usrgrp
FIELD		|permission	|t_integer	|'2'	|NOT NULL	|0
UNIQUE		|1		|slideshowid,usrgrpid

TABLE|slides|slideid|ZBX_DATA
FIELD		|slideid	|t_id		|	|NOT NULL	|0
FIELD		|slideshowid	|t_id		|	|NOT NULL	|0			|1|slideshows
FIELD		|screenid	|t_id		|	|NOT NULL	|0			|2|screens
FIELD		|step		|t_integer	|'0'	|NOT NULL	|0
FIELD		|delay		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|slideshowid
INDEX		|2		|screenid

TABLE|drules|druleid|ZBX_DATA
FIELD		|druleid	|t_id		|	|NOT NULL	|0
FIELD		|proxy_hostid	|t_id		|	|NULL		|0			|1|hosts	|hostid		|RESTRICT
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|iprange	|t_varchar(2048)|''	|NOT NULL	|ZBX_PROXY
FIELD		|delay		|t_integer	|'3600'	|NOT NULL	|ZBX_PROXY
FIELD		|nextcheck	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|proxy_hostid
UNIQUE		|2		|name

TABLE|dchecks|dcheckid|ZBX_DATA
FIELD		|dcheckid	|t_id		|	|NOT NULL	|0
FIELD		|druleid	|t_id		|	|NOT NULL	|ZBX_PROXY		|1|drules
FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|key_		|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|snmp_community	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|ports		|t_varchar(255)	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_securityname|t_varchar(64)|''	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_securitylevel|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_authpassphrase|t_varchar(64)|''	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_privpassphrase|t_varchar(64)|''	|NOT NULL	|ZBX_PROXY
FIELD		|uniq		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_authprotocol|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_privprotocol|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_contextname|t_varchar(255)|''	|NOT NULL	|ZBX_PROXY
INDEX		|1		|druleid

TABLE|applications|applicationid|ZBX_DATA
FIELD		|applicationid	|t_id		|	|NOT NULL	|0
FIELD		|hostid		|t_id		|	|NOT NULL	|0			|1|hosts
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|flags		|t_integer	|'0'	|NOT NULL	|0
UNIQUE		|2		|hostid,name

TABLE|httptest|httptestid|ZBX_DATA
FIELD		|httptestid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|applicationid	|t_id		|	|NULL		|0			|1|applications	|		|RESTRICT
FIELD		|nextcheck	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|delay		|t_integer	|'60'	|NOT NULL	|ZBX_PROXY
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|variables	|t_shorttext	|''	|NOT NULL	|ZBX_PROXY
FIELD		|agent		|t_varchar(255)	|'Zabbix'|NOT NULL	|ZBX_PROXY
FIELD		|authentication	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|http_user	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|http_password	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|hostid		|t_id		|	|NOT NULL	|ZBX_PROXY		|2|hosts
FIELD		|templateid	|t_id		|	|NULL		|0			|3|httptest	|httptestid
FIELD		|http_proxy	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|retries	|t_integer	|'1'	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|ssl_cert_file	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|ssl_key_file	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|ssl_key_password|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|verify_peer	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|verify_host	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|headers	|t_shorttext	|''	|NOT NULL	|ZBX_PROXY
INDEX		|1		|applicationid
UNIQUE		|2		|hostid,name
INDEX		|3		|status
INDEX		|4		|templateid

TABLE|httpstep|httpstepid|ZBX_DATA
FIELD		|httpstepid	|t_id		|	|NOT NULL	|0
FIELD		|httptestid	|t_id		|	|NOT NULL	|ZBX_PROXY		|1|httptest
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|no		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|url		|t_varchar(2048)|''	|NOT NULL	|ZBX_PROXY
FIELD		|timeout	|t_integer	|'15'	|NOT NULL	|ZBX_PROXY
FIELD		|posts		|t_shorttext	|''	|NOT NULL	|ZBX_PROXY
FIELD		|required	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|status_codes	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|variables	|t_shorttext	|''	|NOT NULL	|ZBX_PROXY
FIELD		|follow_redirects|t_integer	|'1'	|NOT NULL	|ZBX_PROXY
FIELD		|retrieve_mode	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|headers	|t_shorttext	|''	|NOT NULL	|ZBX_PROXY
INDEX		|1		|httptestid

TABLE|interface|interfaceid|ZBX_DATA
FIELD		|interfaceid	|t_id		|	|NOT NULL	|0
FIELD		|hostid		|t_id		|	|NOT NULL	|ZBX_PROXY		|1|hosts
FIELD		|main		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|useip		|t_integer	|'1'	|NOT NULL	|ZBX_PROXY
FIELD		|ip		|t_varchar(64)	|'127.0.0.1'|NOT NULL	|ZBX_PROXY
FIELD		|dns		|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|port		|t_varchar(64)	|'10050'|NOT NULL	|ZBX_PROXY
FIELD		|bulk		|t_integer	|'1'	|NOT NULL	|ZBX_PROXY
INDEX		|1		|hostid,type
INDEX		|2		|ip,dns

TABLE|valuemaps|valuemapid|ZBX_DATA
FIELD		|valuemapid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|0
UNIQUE		|1		|name

TABLE|items|itemid|ZBX_DATA
FIELD		|itemid		|t_id		|	|NOT NULL	|0
FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmp_community	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|snmp_oid	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|hostid		|t_id		|	|NOT NULL	|ZBX_PROXY		|1|hosts
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|key_		|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|delay		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|history	|t_integer	|'90'	|NOT NULL	|0
FIELD		|trends		|t_integer	|'365'	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|value_type	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|trapper_hosts	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|units		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|multiplier	|t_integer	|'0'	|NOT NULL	|0
FIELD		|delta		|t_integer	|'0'	|NOT NULL	|0
FIELD		|snmpv3_securityname|t_varchar(64)|''	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_securitylevel|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_authpassphrase|t_varchar(64)|''	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_privpassphrase|t_varchar(64)|''	|NOT NULL	|ZBX_PROXY
FIELD		|formula	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|error		|t_varchar(2048)|''	|NOT NULL	|ZBX_NODATA
FIELD		|lastlogsize	|t_bigint	|'0'	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|logtimefmt	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|templateid	|t_id		|	|NULL		|0			|2|items	|itemid
FIELD		|valuemapid	|t_id		|	|NULL		|0			|3|valuemaps	|		|RESTRICT
FIELD		|delay_flex	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|params		|t_shorttext	|''	|NOT NULL	|ZBX_PROXY
FIELD		|ipmi_sensor	|t_varchar(128)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|data_type	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|authtype	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|username	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|password	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|publickey	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|privatekey	|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|mtime		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|flags		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|interfaceid	|t_id		|	|NULL		|ZBX_PROXY		|4|interface	|		|RESTRICT
FIELD		|port		|t_varchar(64)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|description	|t_shorttext	|''	|NOT NULL	|0
FIELD		|inventory_link	|t_integer	|'0'	|NOT NULL	|0
FIELD		|lifetime	|t_varchar(64)	|'30'	|NOT NULL	|0
FIELD		|snmpv3_authprotocol|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|snmpv3_privprotocol|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|state		|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|snmpv3_contextname|t_varchar(255)|''	|NOT NULL	|ZBX_PROXY
FIELD		|evaltype	|t_integer	|'0'	|NOT NULL	|0
UNIQUE		|1		|hostid,key_
INDEX		|3		|status
INDEX		|4		|templateid
INDEX		|5		|valuemapid
INDEX		|6		|interfaceid

TABLE|httpstepitem|httpstepitemid|ZBX_DATA
FIELD		|httpstepitemid	|t_id		|	|NOT NULL	|0
FIELD		|httpstepid	|t_id		|	|NOT NULL	|ZBX_PROXY		|1|httpstep
FIELD		|itemid		|t_id		|	|NOT NULL	|ZBX_PROXY		|2|items
FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
UNIQUE		|1		|httpstepid,itemid
INDEX		|2		|itemid

TABLE|httptestitem|httptestitemid|ZBX_DATA
FIELD		|httptestitemid	|t_id		|	|NOT NULL	|0
FIELD		|httptestid	|t_id		|	|NOT NULL	|ZBX_PROXY		|1|httptest
FIELD		|itemid		|t_id		|	|NOT NULL	|ZBX_PROXY		|2|items
FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
UNIQUE		|1		|httptestid,itemid
INDEX		|2		|itemid

TABLE|media_type|mediatypeid|ZBX_DATA
FIELD		|mediatypeid	|t_id		|	|NOT NULL	|0
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
FIELD		|description	|t_varchar(100)	|''	|NOT NULL	|0
FIELD		|smtp_server	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|smtp_helo	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|smtp_email	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|exec_path	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|gsm_modem	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|username	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|passwd		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|smtp_port	|t_integer	|'25'	|NOT NULL	|0
FIELD		|smtp_security	|t_integer	|'0'	|NOT NULL	|0
FIELD		|smtp_verify_peer|t_integer	|'0'	|NOT NULL	|0
FIELD		|smtp_verify_host|t_integer	|'0'	|NOT NULL	|0
FIELD		|smtp_authentication|t_integer	|'0'	|NOT NULL	|0
FIELD		|exec_params	|t_varchar(255)	|''	|NOT NULL	|0
UNIQUE		|1		|description

TABLE|users|userid|ZBX_DATA
FIELD		|userid		|t_id		|	|NOT NULL	|0
FIELD		|alias		|t_varchar(100)	|''	|NOT NULL	|0
FIELD		|name		|t_varchar(100)	|''	|NOT NULL	|0
FIELD		|surname	|t_varchar(100)	|''	|NOT NULL	|0
FIELD		|passwd		|t_char(32)	|''	|NOT NULL	|0
FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|autologin	|t_integer	|'0'	|NOT NULL	|0
FIELD		|autologout	|t_integer	|'900'	|NOT NULL	|0
FIELD		|lang		|t_varchar(5)	|'en_GB'|NOT NULL	|0
FIELD		|refresh	|t_integer	|'30'	|NOT NULL	|0
FIELD		|type		|t_integer	|'1'	|NOT NULL	|0
FIELD		|theme		|t_varchar(128)	|'default'|NOT NULL	|0
FIELD		|attempt_failed	|t_integer	|0	|NOT NULL	|ZBX_NODATA
FIELD		|attempt_ip	|t_varchar(39)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|attempt_clock	|t_integer	|0	|NOT NULL	|ZBX_NODATA
FIELD		|rows_per_page	|t_integer	|50	|NOT NULL	|0
UNIQUE		|1		|alias

TABLE|usrgrp|usrgrpid|ZBX_DATA
FIELD		|usrgrpid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|gui_access	|t_integer	|'0'	|NOT NULL	|0
FIELD		|users_status	|t_integer	|'0'	|NOT NULL	|0
FIELD		|debug_mode	|t_integer	|'0'	|NOT NULL	|0
UNIQUE		|1		|name

TABLE|users_groups|id|ZBX_DATA
FIELD		|id		|t_id		|	|NOT NULL	|0
FIELD		|usrgrpid	|t_id		|	|NOT NULL	|0			|1|usrgrp
FIELD		|userid		|t_id		|	|NOT NULL	|0			|2|users
UNIQUE		|1		|usrgrpid,userid
INDEX		|2		|userid

TABLE|scripts|scriptid|ZBX_DATA
FIELD		|scriptid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|command	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|host_access	|t_integer	|'2'	|NOT NULL	|0
FIELD		|usrgrpid	|t_id		|	|NULL		|0			|1|usrgrp	|		|RESTRICT
FIELD		|groupid	|t_id		|	|NULL		|0			|2|groups	|		|RESTRICT
FIELD		|description	|t_shorttext	|''	|NOT NULL	|0
FIELD		|confirmation	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
FIELD		|execute_on	|t_integer	|'1'	|NOT NULL	|0
INDEX		|1		|usrgrpid
INDEX		|2		|groupid
UNIQUE		|3		|name

TABLE|actions|actionid|ZBX_DATA
FIELD		|actionid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|eventsource	|t_integer	|'0'	|NOT NULL	|0
FIELD		|evaltype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|esc_period	|t_integer	|'0'	|NOT NULL	|0
FIELD		|def_shortdata	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|def_longdata	|t_shorttext	|''	|NOT NULL	|0
FIELD		|recovery_msg	|t_integer	|'0'	|NOT NULL	|0
FIELD		|r_shortdata	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|r_longdata	|t_shorttext	|''	|NOT NULL	|0
FIELD		|formula	|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|eventsource,status
UNIQUE		|2		|name

TABLE|operations|operationid|ZBX_DATA
FIELD		|operationid	|t_id		|	|NOT NULL	|0
FIELD		|actionid	|t_id		|	|NOT NULL	|0			|1|actions
FIELD		|operationtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|esc_period	|t_integer	|'0'	|NOT NULL	|0
FIELD		|esc_step_from	|t_integer	|'1'	|NOT NULL	|0
FIELD		|esc_step_to	|t_integer	|'1'	|NOT NULL	|0
FIELD		|evaltype	|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|actionid

TABLE|opmessage|operationid|ZBX_DATA
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|default_msg	|t_integer	|'0'	|NOT NULL	|0
FIELD		|subject	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|message	|t_shorttext	|''	|NOT NULL	|0
FIELD		|mediatypeid	|t_id		|	|NULL		|0			|2|media_type	|		|RESTRICT
INDEX		|1		|mediatypeid

TABLE|opmessage_grp|opmessage_grpid|ZBX_DATA
FIELD		|opmessage_grpid|t_id		|	|NOT NULL	|0
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|usrgrpid	|t_id		|	|NOT NULL	|0			|2|usrgrp	|		|RESTRICT
UNIQUE		|1		|operationid,usrgrpid
INDEX		|2		|usrgrpid

TABLE|opmessage_usr|opmessage_usrid|ZBX_DATA
FIELD		|opmessage_usrid|t_id		|	|NOT NULL	|0
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|userid		|t_id		|	|NOT NULL	|0			|2|users	|		|RESTRICT
UNIQUE		|1		|operationid,userid
INDEX		|2		|userid

TABLE|opcommand|operationid|ZBX_DATA
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
FIELD		|scriptid	|t_id		|	|NULL		|0			|2|scripts	|		|RESTRICT
FIELD		|execute_on	|t_integer	|'0'	|NOT NULL	|0
FIELD		|port		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|authtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|username	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|password	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|publickey	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|privatekey	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|command	|t_shorttext	|''	|NOT NULL	|0
INDEX		|1		|scriptid

TABLE|opcommand_hst|opcommand_hstid|ZBX_DATA
FIELD		|opcommand_hstid|t_id		|	|NOT NULL	|0
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|hostid		|t_id		|	|NULL		|0			|2|hosts	|		|RESTRICT
INDEX		|1		|operationid
INDEX		|2		|hostid

TABLE|opcommand_grp|opcommand_grpid|ZBX_DATA
FIELD		|opcommand_grpid|t_id		|	|NOT NULL	|0
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|groupid	|t_id		|	|NOT NULL	|0			|2|groups	|		|RESTRICT
INDEX		|1		|operationid
INDEX		|2		|groupid

TABLE|opgroup|opgroupid|ZBX_DATA
FIELD		|opgroupid	|t_id		|	|NOT NULL	|0
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|groupid	|t_id		|	|NOT NULL	|0			|2|groups	|		|RESTRICT
UNIQUE		|1		|operationid,groupid
INDEX		|2		|groupid

TABLE|optemplate|optemplateid|ZBX_DATA
FIELD		|optemplateid	|t_id		|	|NOT NULL	|0
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|templateid	|t_id		|	|NOT NULL	|0			|2|hosts	|hostid		|RESTRICT
UNIQUE		|1		|operationid,templateid
INDEX		|2		|templateid

TABLE|opconditions|opconditionid|ZBX_DATA
FIELD		|opconditionid	|t_id		|	|NOT NULL	|0
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|conditiontype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|operator	|t_integer	|'0'	|NOT NULL	|0
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|operationid

TABLE|conditions|conditionid|ZBX_DATA
FIELD		|conditionid	|t_id		|	|NOT NULL	|0
FIELD		|actionid	|t_id		|	|NOT NULL	|0			|1|actions
FIELD		|conditiontype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|operator	|t_integer	|'0'	|NOT NULL	|0
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|actionid

TABLE|config|configid|ZBX_DATA
FIELD		|configid	|t_id		|	|NOT NULL	|0
FIELD		|refresh_unsupported|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|work_period	|t_varchar(100)	|'1-5,00:00-24:00'|NOT NULL|0
FIELD		|alert_usrgrpid	|t_id		|	|NULL		|0			|1|usrgrp	|usrgrpid	|RESTRICT
FIELD		|event_ack_enable|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|event_expire	|t_integer	|'7'	|NOT NULL	|ZBX_NODATA
FIELD		|event_show_max	|t_integer	|'100'	|NOT NULL	|ZBX_NODATA
FIELD		|default_theme	|t_varchar(128)	|'blue-theme'|NOT NULL	|ZBX_NODATA
FIELD		|authentication_type|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ldap_host	|t_varchar(255)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|ldap_port	|t_integer	|389	|NOT NULL	|ZBX_NODATA
FIELD		|ldap_base_dn	|t_varchar(255)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|ldap_bind_dn	|t_varchar(255)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|ldap_bind_password|t_varchar(128)|''	|NOT NULL	|ZBX_NODATA
FIELD		|ldap_search_attribute|t_varchar(128)|''|NOT NULL	|ZBX_NODATA
FIELD		|dropdown_first_entry|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|dropdown_first_remember|t_integer|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|discovery_groupid|t_id		|	|NOT NULL	|ZBX_PROXY		|2|groups	|groupid	|RESTRICT
FIELD		|max_in_table	|t_integer	|'50'	|NOT NULL	|ZBX_NODATA
FIELD		|search_limit	|t_integer	|'1000'	|NOT NULL	|ZBX_NODATA
FIELD		|severity_color_0|t_varchar(6)	|'97AAB3'|NOT NULL	|ZBX_NODATA
FIELD		|severity_color_1|t_varchar(6)	|'7499FF'|NOT NULL	|ZBX_NODATA
FIELD		|severity_color_2|t_varchar(6)	|'FFC859'|NOT NULL	|ZBX_NODATA
FIELD		|severity_color_3|t_varchar(6)	|'FFA059'|NOT NULL	|ZBX_NODATA
FIELD		|severity_color_4|t_varchar(6)	|'E97659'|NOT NULL	|ZBX_NODATA
FIELD		|severity_color_5|t_varchar(6)	|'E45959'|NOT NULL	|ZBX_NODATA
FIELD		|severity_name_0|t_varchar(32)	|'Not classified'|NOT NULL|ZBX_NODATA
FIELD		|severity_name_1|t_varchar(32)	|'Information'|NOT NULL	|ZBX_NODATA
FIELD		|severity_name_2|t_varchar(32)	|'Warning'|NOT NULL	|ZBX_NODATA
FIELD		|severity_name_3|t_varchar(32)	|'Average'|NOT NULL	|ZBX_NODATA
FIELD		|severity_name_4|t_varchar(32)	|'High'	|NOT NULL	|ZBX_NODATA
FIELD		|severity_name_5|t_varchar(32)	|'Disaster'|NOT NULL	|ZBX_NODATA
FIELD		|ok_period	|t_integer	|'1800'	|NOT NULL	|ZBX_NODATA
FIELD		|blink_period	|t_integer	|'1800'	|NOT NULL	|ZBX_NODATA
FIELD		|problem_unack_color|t_varchar(6)|'DC0000'|NOT NULL	|ZBX_NODATA
FIELD		|problem_ack_color|t_varchar(6)	|'DC0000'|NOT NULL	|ZBX_NODATA
FIELD		|ok_unack_color	|t_varchar(6)	|'00AA00'|NOT NULL	|ZBX_NODATA
FIELD		|ok_ack_color	|t_varchar(6)	|'00AA00'|NOT NULL	|ZBX_NODATA
FIELD		|problem_unack_style|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|problem_ack_style|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|ok_unack_style	|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|ok_ack_style	|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|snmptrap_logging|t_integer	|'1'	|NOT NULL	|ZBX_PROXY,ZBX_NODATA
FIELD		|server_check_interval|t_integer|'10'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_events_mode	|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_events_trigger|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_events_internal|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_events_discovery|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_events_autoreg|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_services_mode|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_services	|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_audit_mode	|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_audit	|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_sessions_mode|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_sessions	|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_history_mode|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_history_global|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_history	|t_integer	|'90'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_trends_mode	|t_integer	|'1'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_trends_global|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|hk_trends	|t_integer	|'365'	|NOT NULL	|ZBX_NODATA
FIELD		|default_inventory_mode|t_integer|'-1'	|NOT NULL	|ZBX_NODATA
INDEX		|1		|alert_usrgrpid
INDEX		|2		|discovery_groupid

TABLE|triggers|triggerid|ZBX_DATA
FIELD		|triggerid	|t_id		|	|NOT NULL	|0
FIELD		|expression	|t_varchar(2048)|''	|NOT NULL	|0
FIELD		|description	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|value		|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|priority	|t_integer	|'0'	|NOT NULL	|0
FIELD		|lastchange	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|comments	|t_shorttext	|''	|NOT NULL	|0
FIELD		|error		|t_varchar(128)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|templateid	|t_id		|	|NULL		|0			|1|triggers	|triggerid
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
FIELD		|state		|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|flags		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|status
INDEX		|2		|value,lastchange
INDEX		|3		|templateid

TABLE|trigger_depends|triggerdepid|ZBX_DATA
FIELD		|triggerdepid	|t_id		|	|NOT NULL	|0
FIELD		|triggerid_down	|t_id		|	|NOT NULL	|0			|1|triggers	|triggerid
FIELD		|triggerid_up	|t_id		|	|NOT NULL	|0			|2|triggers	|triggerid
UNIQUE		|1		|triggerid_down,triggerid_up
INDEX		|2		|triggerid_up

TABLE|functions|functionid|ZBX_DATA
FIELD		|functionid	|t_id		|	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|1|items
FIELD		|triggerid	|t_id		|	|NOT NULL	|0			|2|triggers
FIELD		|function	|t_varchar(12)	|''	|NOT NULL	|0
FIELD		|parameter	|t_varchar(255)	|'0'	|NOT NULL	|0
INDEX		|1		|triggerid
INDEX		|2		|itemid,function,parameter

TABLE|graphs|graphid|ZBX_DATA
FIELD		|graphid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|width		|t_integer	|'900'	|NOT NULL	|0
FIELD		|height		|t_integer	|'200'	|NOT NULL	|0
FIELD		|yaxismin	|t_double	|'0'	|NOT NULL	|0
FIELD		|yaxismax	|t_double	|'100'	|NOT NULL	|0
FIELD		|templateid	|t_id		|	|NULL		|0			|1|graphs	|graphid
FIELD		|show_work_period|t_integer	|'1'	|NOT NULL	|0
FIELD		|show_triggers	|t_integer	|'1'	|NOT NULL	|0
FIELD		|graphtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|show_legend	|t_integer	|'1'	|NOT NULL	|0
FIELD		|show_3d	|t_integer	|'0'	|NOT NULL	|0
FIELD		|percent_left	|t_double	|'0'	|NOT NULL	|0
FIELD		|percent_right	|t_double	|'0'	|NOT NULL	|0
FIELD		|ymin_type	|t_integer	|'0'	|NOT NULL	|0
FIELD		|ymax_type	|t_integer	|'0'	|NOT NULL	|0
FIELD		|ymin_itemid	|t_id		|	|NULL		|0			|2|items	|itemid		|RESTRICT
FIELD		|ymax_itemid	|t_id		|	|NULL		|0			|3|items	|itemid		|RESTRICT
FIELD		|flags		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|name
INDEX		|2		|templateid
INDEX		|3		|ymin_itemid
INDEX		|4		|ymax_itemid

TABLE|graphs_items|gitemid|ZBX_DATA
FIELD		|gitemid	|t_id		|	|NOT NULL	|0
FIELD		|graphid	|t_id		|	|NOT NULL	|0			|1|graphs
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|2|items
FIELD		|drawtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|sortorder	|t_integer	|'0'	|NOT NULL	|0
FIELD		|color		|t_varchar(6)	|'009600'|NOT NULL	|0
FIELD		|yaxisside	|t_integer	|'0'	|NOT NULL	|0
FIELD		|calc_fnc	|t_integer	|'2'	|NOT NULL	|0
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|itemid
INDEX		|2		|graphid

TABLE|graph_theme|graphthemeid|ZBX_DATA
FIELD		|graphthemeid	|t_id		|	|NOT NULL	|0
FIELD		|theme		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|backgroundcolor|t_varchar(6)	|''	|NOT NULL	|0
FIELD		|graphcolor	|t_varchar(6)	|''	|NOT NULL	|0
FIELD		|gridcolor	|t_varchar(6)	|''	|NOT NULL	|0
FIELD		|maingridcolor	|t_varchar(6)	|''	|NOT NULL	|0
FIELD		|gridbordercolor|t_varchar(6)	|''	|NOT NULL	|0
FIELD		|textcolor	|t_varchar(6)	|''	|NOT NULL	|0
FIELD		|highlightcolor	|t_varchar(6)	|''	|NOT NULL	|0
FIELD		|leftpercentilecolor|t_varchar(6)|''	|NOT NULL	|0
FIELD		|rightpercentilecolor|t_varchar(6)|''	|NOT NULL	|0
FIELD		|nonworktimecolor|t_varchar(6)	|''	|NOT NULL	|0
UNIQUE		|1		|theme

TABLE|globalmacro|globalmacroid|ZBX_DATA
FIELD		|globalmacroid	|t_id		|	|NOT NULL	|0
FIELD		|macro		|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
UNIQUE		|1		|macro

TABLE|hostmacro|hostmacroid|ZBX_DATA
FIELD		|hostmacroid	|t_id		|	|NOT NULL	|0
FIELD		|hostid		|t_id		|	|NOT NULL	|ZBX_PROXY		|1|hosts
FIELD		|macro		|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
UNIQUE		|1		|hostid,macro

TABLE|hosts_groups|hostgroupid|ZBX_DATA
FIELD		|hostgroupid	|t_id		|	|NOT NULL	|0
FIELD		|hostid		|t_id		|	|NOT NULL	|0			|1|hosts
FIELD		|groupid	|t_id		|	|NOT NULL	|0			|2|groups
UNIQUE		|1		|hostid,groupid
INDEX		|2		|groupid

TABLE|hosts_templates|hosttemplateid|ZBX_DATA
FIELD		|hosttemplateid	|t_id		|	|NOT NULL	|0
FIELD		|hostid		|t_id		|	|NOT NULL	|ZBX_PROXY		|1|hosts
FIELD		|templateid	|t_id		|	|NOT NULL	|ZBX_PROXY		|2|hosts	|hostid
UNIQUE		|1		|hostid,templateid
INDEX		|2		|templateid

TABLE|items_applications|itemappid|ZBX_DATA
FIELD		|itemappid	|t_id		|	|NOT NULL	|0
FIELD		|applicationid	|t_id		|	|NOT NULL	|0			|1|applications
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|2|items
UNIQUE		|1		|applicationid,itemid
INDEX		|2		|itemid

TABLE|mappings|mappingid|ZBX_DATA
FIELD		|mappingid	|t_id		|	|NOT NULL	|0
FIELD		|valuemapid	|t_id		|	|NOT NULL	|0			|1|valuemaps
FIELD		|value		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|newvalue	|t_varchar(64)	|''	|NOT NULL	|0
INDEX		|1		|valuemapid

TABLE|media|mediaid|ZBX_DATA
FIELD		|mediaid	|t_id		|	|NOT NULL	|0
FIELD		|userid		|t_id		|	|NOT NULL	|0			|1|users
FIELD		|mediatypeid	|t_id		|	|NOT NULL	|0			|2|media_type
FIELD		|sendto		|t_varchar(100)	|''	|NOT NULL	|0
FIELD		|active		|t_integer	|'0'	|NOT NULL	|0
FIELD		|severity	|t_integer	|'63'	|NOT NULL	|0
FIELD		|period		|t_varchar(100)	|'1-7,00:00-24:00'|NOT NULL|0
INDEX		|1		|userid
INDEX		|2		|mediatypeid

TABLE|rights|rightid|ZBX_DATA
FIELD		|rightid	|t_id		|	|NOT NULL	|0
FIELD		|groupid	|t_id		|	|NOT NULL	|0			|1|usrgrp	|usrgrpid
FIELD		|permission	|t_integer	|'0'	|NOT NULL	|0
FIELD		|id		|t_id		|	|NOT NULL	|0			|2|groups	|groupid
INDEX		|1		|groupid
INDEX		|2		|id

TABLE|services|serviceid|ZBX_DATA
FIELD		|serviceid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|algorithm	|t_integer	|'0'	|NOT NULL	|0
FIELD		|triggerid	|t_id		|	|NULL		|0			|1|triggers
FIELD		|showsla	|t_integer	|'0'	|NOT NULL	|0
FIELD		|goodsla	|t_double	|'99.9'	|NOT NULL	|0
FIELD		|sortorder	|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|triggerid

TABLE|services_links|linkid|ZBX_DATA
FIELD		|linkid		|t_id		|	|NOT NULL	|0
FIELD		|serviceupid	|t_id		|	|NOT NULL	|0			|1|services	|serviceid
FIELD		|servicedownid	|t_id		|	|NOT NULL	|0			|2|services	|serviceid
FIELD		|soft		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|servicedownid
UNIQUE		|2		|serviceupid,servicedownid

TABLE|services_times|timeid|ZBX_DATA
FIELD		|timeid		|t_id		|	|NOT NULL	|0
FIELD		|serviceid	|t_id		|	|NOT NULL	|0			|1|services
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
FIELD		|ts_from	|t_integer	|'0'	|NOT NULL	|0
FIELD		|ts_to		|t_integer	|'0'	|NOT NULL	|0
FIELD		|note		|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|serviceid,type,ts_from,ts_to

TABLE|icon_map|iconmapid|ZBX_DATA
FIELD		|iconmapid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|default_iconid	|t_id		|	|NOT NULL	|0			|1|images	|imageid	|RESTRICT
UNIQUE		|1		|name
INDEX		|2		|default_iconid

TABLE|icon_mapping|iconmappingid|ZBX_DATA
FIELD		|iconmappingid	|t_id		|	|NOT NULL	|0
FIELD		|iconmapid	|t_id		|	|NOT NULL	|0			|1|icon_map
FIELD		|iconid		|t_id		|	|NOT NULL	|0			|2|images	|imageid	|RESTRICT
FIELD		|inventory_link	|t_integer	|'0'	|NOT NULL	|0
FIELD		|expression	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|sortorder	|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|iconmapid
INDEX		|2		|iconid

TABLE|sysmaps|sysmapid|ZBX_DATA
FIELD		|sysmapid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|width		|t_integer	|'600'	|NOT NULL	|0
FIELD		|height		|t_integer	|'400'	|NOT NULL	|0
FIELD		|backgroundid	|t_id		|	|NULL		|0			|1|images	|imageid	|RESTRICT
FIELD		|label_type	|t_integer	|'2'	|NOT NULL	|0
FIELD		|label_location	|t_integer	|'0'	|NOT NULL	|0
FIELD		|highlight	|t_integer	|'1'	|NOT NULL	|0
FIELD		|expandproblem	|t_integer	|'1'	|NOT NULL	|0
FIELD		|markelements	|t_integer	|'0'	|NOT NULL	|0
FIELD		|show_unack	|t_integer	|'0'	|NOT NULL	|0
FIELD		|grid_size	|t_integer	|'50'	|NOT NULL	|0
FIELD		|grid_show	|t_integer	|'1'	|NOT NULL	|0
FIELD		|grid_align	|t_integer	|'1'	|NOT NULL	|0
FIELD		|label_format	|t_integer	|'0'	|NOT NULL	|0
FIELD		|label_type_host|t_integer	|'2'	|NOT NULL	|0
FIELD		|label_type_hostgroup|t_integer	|'2'	|NOT NULL	|0
FIELD		|label_type_trigger|t_integer	|'2'	|NOT NULL	|0
FIELD		|label_type_map|t_integer	|'2'	|NOT NULL	|0
FIELD		|label_type_image|t_integer	|'2'	|NOT NULL	|0
FIELD		|label_string_host|t_varchar(255)|''	|NOT NULL	|0
FIELD		|label_string_hostgroup|t_varchar(255)|''|NOT NULL	|0
FIELD		|label_string_trigger|t_varchar(255)|''	|NOT NULL	|0
FIELD		|label_string_map|t_varchar(255)|''	|NOT NULL	|0
FIELD		|label_string_image|t_varchar(255)|''	|NOT NULL	|0
FIELD		|iconmapid	|t_id		|	|NULL		|0			|2|icon_map	|		|RESTRICT
FIELD		|expand_macros	|t_integer	|'0'	|NOT NULL	|0
FIELD		|severity_min	|t_integer	|'0'	|NOT NULL	|0
FIELD		|userid		|t_id		|	|NOT NULL	|0			|3|users	|		|RESTRICT
FIELD		|private	|t_integer	|'1'	|NOT NULL	|0
UNIQUE		|1		|name
INDEX		|2		|backgroundid
INDEX		|3		|iconmapid

TABLE|sysmaps_elements|selementid|ZBX_DATA
FIELD		|selementid	|t_id		|	|NOT NULL	|0
FIELD		|sysmapid	|t_id		|	|NOT NULL	|0			|1|sysmaps
FIELD		|elementid	|t_id		|'0'	|NOT NULL	|0
FIELD		|elementtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|iconid_off	|t_id		|	|NULL		|0			|2|images	|imageid	|RESTRICT
FIELD		|iconid_on	|t_id		|	|NULL		|0			|3|images	|imageid	|RESTRICT
FIELD		|label		|t_varchar(2048)|''	|NOT NULL	|0
FIELD		|label_location	|t_integer	|'-1'	|NOT NULL	|0
FIELD		|x		|t_integer	|'0'	|NOT NULL	|0
FIELD		|y		|t_integer	|'0'	|NOT NULL	|0
FIELD		|iconid_disabled|t_id		|	|NULL		|0			|4|images	|imageid	|RESTRICT
FIELD		|iconid_maintenance|t_id	|	|NULL		|0			|5|images	|imageid	|RESTRICT
FIELD		|elementsubtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|areatype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|width		|t_integer	|'200'	|NOT NULL	|0
FIELD		|height		|t_integer	|'200'	|NOT NULL	|0
FIELD		|viewtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|use_iconmap	|t_integer	|'1'	|NOT NULL	|0
FIELD		|application	|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|sysmapid
INDEX		|2		|iconid_off
INDEX		|3		|iconid_on
INDEX		|4		|iconid_disabled
INDEX		|5		|iconid_maintenance

TABLE|sysmaps_links|linkid|ZBX_DATA
FIELD		|linkid		|t_id		|	|NOT NULL	|0
FIELD		|sysmapid	|t_id		|	|NOT NULL	|0			|1|sysmaps
FIELD		|selementid1	|t_id		|	|NOT NULL	|0			|2|sysmaps_elements|selementid
FIELD		|selementid2	|t_id		|	|NOT NULL	|0			|3|sysmaps_elements|selementid
FIELD		|drawtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|color		|t_varchar(6)	|'000000'|NOT NULL	|0
FIELD		|label		|t_varchar(2048)|''	|NOT NULL	|0
INDEX		|1		|sysmapid
INDEX		|2		|selementid1
INDEX		|3		|selementid2

TABLE|sysmaps_link_triggers|linktriggerid|ZBX_DATA
FIELD		|linktriggerid	|t_id		|	|NOT NULL	|0
FIELD		|linkid		|t_id		|	|NOT NULL	|0			|1|sysmaps_links
FIELD		|triggerid	|t_id		|	|NOT NULL	|0			|2|triggers
FIELD		|drawtype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|color		|t_varchar(6)	|'000000'|NOT NULL	|0
UNIQUE		|1		|linkid,triggerid
INDEX		|2		|triggerid

TABLE|sysmap_element_url|sysmapelementurlid|ZBX_DATA
FIELD		|sysmapelementurlid|t_id	|	|NOT NULL	|0
FIELD		|selementid	|t_id		|	|NOT NULL	|0			|1|sysmaps_elements
FIELD		|name		|t_varchar(255)	|	|NOT NULL	|0
FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|0
UNIQUE		|1		|selementid,name

TABLE|sysmap_url|sysmapurlid|ZBX_DATA
FIELD		|sysmapurlid	|t_id		|	|NOT NULL	|0
FIELD		|sysmapid	|t_id		|	|NOT NULL	|0			|1|sysmaps
FIELD		|name		|t_varchar(255)	|	|NOT NULL	|0
FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|elementtype	|t_integer	|'0'	|NOT NULL	|0
UNIQUE		|1		|sysmapid,name

TABLE|sysmap_user|sysmapuserid|ZBX_DATA
FIELD		|sysmapuserid|t_id		|	|NOT NULL	|0
FIELD		|sysmapid	|t_id		|	|NOT NULL	|0			|1|sysmaps
FIELD		|userid		|t_id		|	|NOT NULL	|0			|2|users
FIELD		|permission	|t_integer	|'2'	|NOT NULL	|0
UNIQUE		|1		|sysmapid,userid

TABLE|sysmap_usrgrp|sysmapusrgrpid|ZBX_DATA
FIELD		|sysmapusrgrpid|t_id		|	|NOT NULL	|0
FIELD		|sysmapid	|t_id		|	|NOT NULL	|0			|1|sysmaps
FIELD		|usrgrpid	|t_id		|	|NOT NULL	|0			|2|usrgrp
FIELD		|permission	|t_integer	|'2'	|NOT NULL	|0
UNIQUE		|1		|sysmapid,usrgrpid

TABLE|maintenances_hosts|maintenance_hostid|ZBX_DATA
FIELD		|maintenance_hostid|t_id	|	|NOT NULL	|0
FIELD		|maintenanceid	|t_id		|	|NOT NULL	|0			|1|maintenances
FIELD		|hostid		|t_id		|	|NOT NULL	|0			|2|hosts
UNIQUE		|1		|maintenanceid,hostid
INDEX		|2		|hostid

TABLE|maintenances_groups|maintenance_groupid|ZBX_DATA
FIELD		|maintenance_groupid|t_id	|	|NOT NULL	|0
FIELD		|maintenanceid	|t_id		|	|NOT NULL	|0			|1|maintenances
FIELD		|groupid	|t_id		|	|NOT NULL	|0			|2|groups
UNIQUE		|1		|maintenanceid,groupid
INDEX		|2		|groupid

TABLE|timeperiods|timeperiodid|ZBX_DATA
FIELD		|timeperiodid	|t_id		|	|NOT NULL	|0
FIELD		|timeperiod_type|t_integer	|'0'	|NOT NULL	|0
FIELD		|every		|t_integer	|'1'	|NOT NULL	|0
FIELD		|month		|t_integer	|'0'	|NOT NULL	|0
FIELD		|dayofweek	|t_integer	|'0'	|NOT NULL	|0
FIELD		|day		|t_integer	|'0'	|NOT NULL	|0
FIELD		|start_time	|t_integer	|'0'	|NOT NULL	|0
FIELD		|period		|t_integer	|'0'	|NOT NULL	|0
FIELD		|start_date	|t_integer	|'0'	|NOT NULL	|0

TABLE|maintenances_windows|maintenance_timeperiodid|ZBX_DATA
FIELD		|maintenance_timeperiodid|t_id	|	|NOT NULL	|0
FIELD		|maintenanceid	|t_id		|	|NOT NULL	|0			|1|maintenances
FIELD		|timeperiodid	|t_id		|	|NOT NULL	|0			|2|timeperiods
UNIQUE		|1		|maintenanceid,timeperiodid
INDEX		|2		|timeperiodid

TABLE|regexps|regexpid|ZBX_DATA
FIELD		|regexpid	|t_id		|	|NOT NULL	|0
FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|test_string	|t_shorttext	|''	|NOT NULL	|0
UNIQUE		|1		|name

TABLE|expressions|expressionid|ZBX_DATA
FIELD		|expressionid	|t_id		|	|NOT NULL	|0
FIELD		|regexpid	|t_id		|	|NOT NULL	|ZBX_PROXY		|1|regexps
FIELD		|expression	|t_varchar(255)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|expression_type|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
FIELD		|exp_delimiter	|t_varchar(1)	|''	|NOT NULL	|ZBX_PROXY
FIELD		|case_sensitive	|t_integer	|'0'	|NOT NULL	|ZBX_PROXY
INDEX		|1		|regexpid

TABLE|ids|table_name,field_name|0
FIELD		|table_name	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|field_name	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|nextid		|t_id		|	|NOT NULL	|0

-- History tables

TABLE|alerts|alertid|0
FIELD		|alertid	|t_id		|	|NOT NULL	|0
FIELD		|actionid	|t_id		|	|NOT NULL	|0			|1|actions
FIELD		|eventid	|t_id		|	|NOT NULL	|0			|2|events
FIELD		|userid		|t_id		|	|NULL		|0			|3|users
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|mediatypeid	|t_id		|	|NULL		|0			|4|media_type
FIELD		|sendto		|t_varchar(100)	|''	|NOT NULL	|0
FIELD		|subject	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|message	|t_text		|''	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|retries	|t_integer	|'0'	|NOT NULL	|0
FIELD		|error		|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|esc_step	|t_integer	|'0'	|NOT NULL	|0
FIELD		|alerttype	|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|actionid
INDEX		|2		|clock
INDEX		|3		|eventid
INDEX		|4		|status,retries
INDEX		|5		|mediatypeid
INDEX		|6		|userid

TABLE|history||0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|value		|t_double	|'0.0000'|NOT NULL	|0
FIELD		|ns		|t_nanosec	|'0'	|NOT NULL	|0
INDEX		|1		|itemid,clock

TABLE|history_uint||0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|value		|t_bigint	|'0'	|NOT NULL	|0
FIELD		|ns		|t_nanosec	|'0'	|NOT NULL	|0
INDEX		|1		|itemid,clock

TABLE|history_str||0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|ns		|t_nanosec	|'0'	|NOT NULL	|0
INDEX		|1		|itemid,clock

TABLE|history_log|id|0
FIELD		|id		|t_id		|	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|timestamp	|t_time		|'0'	|NOT NULL	|0
FIELD		|source		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|severity	|t_integer	|'0'	|NOT NULL	|0
FIELD		|value		|t_text		|''	|NOT NULL	|0
FIELD		|logeventid	|t_integer	|'0'	|NOT NULL	|0
FIELD		|ns		|t_nanosec	|'0'	|NOT NULL	|0
INDEX		|1		|itemid,clock
UNIQUE		|2		|itemid,id

TABLE|history_text|id|0
FIELD		|id		|t_id		|	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|value		|t_text		|''	|NOT NULL	|0
FIELD		|ns		|t_nanosec	|'0'	|NOT NULL	|0
INDEX		|1		|itemid,clock
UNIQUE		|2		|itemid,id

TABLE|proxy_history|id|0
FIELD		|id		|t_serial	|	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|timestamp	|t_time		|'0'	|NOT NULL	|0
FIELD		|source		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|severity	|t_integer	|'0'	|NOT NULL	|0
FIELD		|value		|t_longtext	|''	|NOT NULL	|0
FIELD		|logeventid	|t_integer	|'0'	|NOT NULL	|0
FIELD		|ns		|t_nanosec	|'0'	|NOT NULL	|0
FIELD		|state		|t_integer	|'0'	|NOT NULL	|0
FIELD		|lastlogsize	|t_bigint	|'0'	|NOT NULL	|0
FIELD		|mtime		|t_integer	|'0'	|NOT NULL	|0
FIELD		|flags		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|clock

TABLE|proxy_dhistory|id|0
FIELD		|id		|t_serial	|	|NOT NULL	|0
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|druleid	|t_id		|	|NOT NULL	|0			|-|drules
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
FIELD		|ip		|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|port		|t_integer	|'0'	|NOT NULL	|0
FIELD		|key_		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|dcheckid	|t_id		|	|NULL		|0			|-|dchecks
FIELD		|dns		|t_varchar(64)	|''	|NOT NULL	|0
INDEX		|1		|clock

TABLE|events|eventid|0
FIELD		|eventid	|t_id		|	|NOT NULL	|0
FIELD		|source		|t_integer	|'0'	|NOT NULL	|0
FIELD		|object		|t_integer	|'0'	|NOT NULL	|0
FIELD		|objectid	|t_id		|'0'	|NOT NULL	|0
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|value		|t_integer	|'0'	|NOT NULL	|0
FIELD		|acknowledged	|t_integer	|'0'	|NOT NULL	|0
FIELD		|ns		|t_nanosec	|'0'	|NOT NULL	|0
INDEX		|1		|source,object,objectid,clock
INDEX		|2		|source,object,clock

TABLE|trends|itemid,clock|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|num		|t_integer	|'0'	|NOT NULL	|0
FIELD		|value_min	|t_double	|'0.0000'|NOT NULL	|0
FIELD		|value_avg	|t_double	|'0.0000'|NOT NULL	|0
FIELD		|value_max	|t_double	|'0.0000'|NOT NULL	|0

TABLE|trends_uint|itemid,clock|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|-|items
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|num		|t_integer	|'0'	|NOT NULL	|0
FIELD		|value_min	|t_bigint	|'0'	|NOT NULL	|0
FIELD		|value_avg	|t_bigint	|'0'	|NOT NULL	|0
FIELD		|value_max	|t_bigint	|'0'	|NOT NULL	|0

TABLE|acknowledges|acknowledgeid|0
FIELD		|acknowledgeid	|t_id		|	|NOT NULL	|0
FIELD		|userid		|t_id		|	|NOT NULL	|0			|1|users
FIELD		|eventid	|t_id		|	|NOT NULL	|0			|2|events
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|message	|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|userid
INDEX		|2		|eventid
INDEX		|3		|clock

TABLE|auditlog|auditid|0
FIELD		|auditid	|t_id		|	|NOT NULL	|0
FIELD		|userid		|t_id		|	|NOT NULL	|0			|1|users
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|action		|t_integer	|'0'	|NOT NULL	|0
FIELD		|resourcetype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|details	|t_varchar(128) |'0'	|NOT NULL	|0
FIELD		|ip		|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|resourceid	|t_id		|'0'	|NOT NULL	|0
FIELD		|resourcename	|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|userid,clock
INDEX		|2		|clock

TABLE|auditlog_details|auditdetailid|0
FIELD		|auditdetailid	|t_id		|	|NOT NULL	|0
FIELD		|auditid	|t_id		|	|NOT NULL	|0			|1|auditlog
FIELD		|table_name	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|field_name	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|oldvalue	|t_shorttext	|''	|NOT NULL	|0
FIELD		|newvalue	|t_shorttext	|''	|NOT NULL	|0
INDEX		|1		|auditid

TABLE|service_alarms|servicealarmid|0
FIELD		|servicealarmid	|t_id		|	|NOT NULL	|0
FIELD		|serviceid	|t_id		|	|NOT NULL	|0			|1|services
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|value		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|serviceid,clock
INDEX		|2		|clock

TABLE|autoreg_host|autoreg_hostid|0
FIELD		|autoreg_hostid	|t_id		|	|NOT NULL	|0
FIELD		|proxy_hostid	|t_id		|	|NULL		|0			|1|hosts	|hostid
FIELD		|host		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|listen_ip	|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|listen_port	|t_integer	|'0'	|NOT NULL	|0
FIELD		|listen_dns	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|host_metadata	|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|proxy_hostid,host

TABLE|proxy_autoreg_host|id|0
FIELD		|id		|t_serial	|	|NOT NULL	|0
FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
FIELD		|host		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|listen_ip	|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|listen_port	|t_integer	|'0'	|NOT NULL	|0
FIELD		|listen_dns	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|host_metadata	|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|clock

TABLE|dhosts|dhostid|0
FIELD		|dhostid	|t_id		|	|NOT NULL	|0
FIELD		|druleid	|t_id		|	|NOT NULL	|0			|1|drules
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|lastup		|t_integer	|'0'	|NOT NULL	|0
FIELD		|lastdown	|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|druleid

TABLE|dservices|dserviceid|0
FIELD		|dserviceid	|t_id		|	|NOT NULL	|0
FIELD		|dhostid	|t_id		|	|NOT NULL	|0			|1|dhosts
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
FIELD		|key_		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|port		|t_integer	|'0'	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|lastup		|t_integer	|'0'	|NOT NULL	|0
FIELD		|lastdown	|t_integer	|'0'	|NOT NULL	|0
FIELD		|dcheckid	|t_id		|	|NOT NULL	|0			|2|dchecks
FIELD		|ip		|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|dns		|t_varchar(64)	|''	|NOT NULL	|0
UNIQUE		|1		|dcheckid,type,key_,ip,port
INDEX		|2		|dhostid

-- Other tables

TABLE|escalations|escalationid|0
FIELD		|escalationid	|t_id		|	|NOT NULL	|0
FIELD		|actionid	|t_id		|	|NOT NULL	|0			|-|actions
FIELD		|triggerid	|t_id		|	|NULL		|0			|-|triggers
FIELD		|eventid	|t_id		|	|NULL		|0			|-|events
FIELD		|r_eventid	|t_id		|	|NULL		|0			|-|events	|eventid
FIELD		|nextcheck	|t_time		|'0'	|NOT NULL	|0
FIELD		|esc_step	|t_integer	|'0'	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NULL		|0			|-|items
UNIQUE		|1		|actionid,triggerid,itemid,escalationid

TABLE|globalvars|globalvarid|0
FIELD		|globalvarid	|t_id		|	|NOT NULL	|0
FIELD		|snmp_lastsize	|t_integer	|'0'	|NOT NULL	|0

TABLE|graph_discovery|graphid|0
FIELD		|graphid	|t_id		|	|NOT NULL	|0			|1|graphs
FIELD		|parent_graphid	|t_id		|	|NOT NULL	|0			|2|graphs	|graphid	|RESTRICT
INDEX		|1		|parent_graphid

TABLE|host_inventory|hostid|0
FIELD		|hostid		|t_id		|	|NOT NULL	|0			|1|hosts
FIELD		|inventory_mode	|t_integer	|'0'	|NOT NULL	|0
FIELD		|type		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|type_full	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|alias		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|os		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|os_full	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|os_short	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|serialno_a	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|serialno_b	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|tag		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|asset_tag	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|macaddress_a	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|macaddress_b	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|hardware	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|hardware_full	|t_shorttext	|''	|NOT NULL	|0
FIELD		|software	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|software_full	|t_shorttext	|''	|NOT NULL	|0
FIELD		|software_app_a	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|software_app_b	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|software_app_c	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|software_app_d	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|software_app_e	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|contact	|t_shorttext	|''	|NOT NULL	|0
FIELD		|location	|t_shorttext	|''	|NOT NULL	|0
FIELD		|location_lat	|t_varchar(16)	|''	|NOT NULL	|0
FIELD		|location_lon	|t_varchar(16)	|''	|NOT NULL	|0
FIELD		|notes		|t_shorttext	|''	|NOT NULL	|0
FIELD		|chassis	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|model		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|hw_arch	|t_varchar(32)	|''	|NOT NULL	|0
FIELD		|vendor		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|contract_number|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|installer_name	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|deployment_status|t_varchar(64)|''	|NOT NULL	|0
FIELD		|url_a		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|url_b		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|url_c		|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|host_networks	|t_shorttext	|''	|NOT NULL	|0
FIELD		|host_netmask	|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|host_router	|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|oob_ip		|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|oob_netmask	|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|oob_router	|t_varchar(39)	|''	|NOT NULL	|0
FIELD		|date_hw_purchase|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|date_hw_install|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|date_hw_expiry	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|date_hw_decomm	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|site_address_a	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|site_address_b	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|site_address_c	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|site_city	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|site_state	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|site_country	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|site_zip	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|site_rack	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|site_notes	|t_shorttext	|''	|NOT NULL	|0
FIELD		|poc_1_name	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|poc_1_email	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|poc_1_phone_a	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_1_phone_b	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_1_cell	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_1_screen	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_1_notes	|t_shorttext	|''	|NOT NULL	|0
FIELD		|poc_2_name	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|poc_2_email	|t_varchar(128)	|''	|NOT NULL	|0
FIELD		|poc_2_phone_a	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_2_phone_b	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_2_cell	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_2_screen	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|poc_2_notes	|t_shorttext	|''	|NOT NULL	|0

TABLE|housekeeper|housekeeperid|0
FIELD		|housekeeperid	|t_id		|	|NOT NULL	|0
FIELD		|tablename	|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|field		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|value		|t_id		|	|NOT NULL	|0			|-|items

TABLE|images|imageid|0
FIELD		|imageid	|t_id		|	|NOT NULL	|0
FIELD		|imagetype	|t_integer	|'0'	|NOT NULL	|0
FIELD		|name		|t_varchar(64)	|'0'	|NOT NULL	|0
FIELD		|image		|t_image	|''	|NOT NULL	|0
UNIQUE		|1		|name

TABLE|item_discovery|itemdiscoveryid|ZBX_DATA
FIELD		|itemdiscoveryid|t_id		|	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|1|items
FIELD		|parent_itemid	|t_id		|	|NOT NULL	|0			|2|items	|itemid
FIELD		|key_		|t_varchar(255)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|lastcheck	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ts_delete	|t_time		|'0'	|NOT NULL	|ZBX_NODATA
UNIQUE		|1		|itemid,parent_itemid
INDEX		|2		|parent_itemid

TABLE|host_discovery|hostid|ZBX_DATA
FIELD		|hostid		|t_id		|	|NOT NULL	|0			|1|hosts
FIELD		|parent_hostid	|t_id		|	|NULL		|0			|2|hosts	|hostid		|RESTRICT
FIELD		|parent_itemid	|t_id		|	|NULL		|0			|3|items	|itemid		|RESTRICT
FIELD		|host		|t_varchar(64)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|lastcheck	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ts_delete	|t_time		|'0'	|NOT NULL	|ZBX_NODATA

TABLE|interface_discovery|interfaceid|0
FIELD		|interfaceid	|t_id		|	|NOT NULL	|0			|1|interface
FIELD		|parent_interfaceid|t_id	|	|NOT NULL	|0			|2|interface	|interfaceid

TABLE|profiles|profileid|0
FIELD		|profileid	|t_id		|	|NOT NULL	|0
FIELD		|userid		|t_id		|	|NOT NULL	|0			|1|users
FIELD		|idx		|t_varchar(96)	|''	|NOT NULL	|0
FIELD		|idx2		|t_id		|'0'	|NOT NULL	|0
FIELD		|value_id	|t_id		|'0'	|NOT NULL	|0
FIELD		|value_int	|t_integer	|'0'	|NOT NULL	|0
FIELD		|value_str	|t_varchar(255)	|''	|NOT NULL	|0
FIELD		|source		|t_varchar(96)	|''	|NOT NULL	|0
FIELD		|type		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|userid,idx,idx2
INDEX		|2		|userid,profileid

TABLE|sessions|sessionid|0
FIELD		|sessionid	|t_varchar(32)	|''	|NOT NULL	|0
FIELD		|userid		|t_id		|	|NOT NULL	|0			|1|users
FIELD		|lastaccess	|t_integer	|'0'	|NOT NULL	|0
FIELD		|status		|t_integer	|'0'	|NOT NULL	|0
INDEX		|1		|userid,status

TABLE|trigger_discovery|triggerid|0
FIELD		|triggerid	|t_id		|	|NOT NULL	|0			|1|triggers
FIELD		|parent_triggerid|t_id		|	|NOT NULL	|0			|2|triggers	|triggerid	|RESTRICT
INDEX		|1		|parent_triggerid

TABLE|application_template|application_templateid|ZBX_DATA
FIELD		|application_templateid|t_id	|	|NOT NULL	|0
FIELD		|applicationid	|t_id		|	|NOT NULL	|0			|1|applications
FIELD		|templateid	|t_id		|	|NOT NULL	|0			|2|applications	|applicationid
UNIQUE		|1		|applicationid,templateid
INDEX		|2		|templateid

TABLE|item_condition|item_conditionid|ZBX_DATA
FIELD		|item_conditionid|t_id		|	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|1|items
FIELD		|operator	|t_integer	|'8'	|NOT NULL	|0
FIELD		|macro		|t_varchar(64)	|''	|NOT NULL	|0
FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|itemid

TABLE|application_prototype|application_prototypeid|ZBX_DATA
FIELD		|application_prototypeid|t_id	|	|NOT NULL	|0
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|1|items
FIELD		|templateid	|t_id		|	|NULL		|0			|2|application_prototype|application_prototypeid
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|0
INDEX		|1		|itemid
INDEX		|2		|templateid

TABLE|item_application_prototype|item_application_prototypeid|ZBX_DATA
FIELD		|item_application_prototypeid|t_id|	|NOT NULL	|0
FIELD		|application_prototypeid|t_id	|	|NOT NULL	|0			|1|application_prototype
FIELD		|itemid		|t_id		|	|NOT NULL	|0			|2|items
UNIQUE		|1		|application_prototypeid,itemid
INDEX		|2		|itemid

TABLE|application_discovery|application_discoveryid|ZBX_DATA
FIELD		|application_discoveryid|t_id	|	|NOT NULL	|0
FIELD		|applicationid	|t_id		|	|NOT NULL	|0			|1|applications
FIELD		|application_prototypeid|t_id	|	|NOT NULL	|0			|2|application_prototype
FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|ZBX_NODATA
FIELD		|lastcheck	|t_integer	|'0'	|NOT NULL	|ZBX_NODATA
FIELD		|ts_delete	|t_time		|'0'	|NOT NULL	|ZBX_NODATA
INDEX		|1		|applicationid
INDEX		|2		|application_prototypeid

TABLE|opinventory|operationid|ZBX_DATA
FIELD		|operationid	|t_id		|	|NOT NULL	|0			|1|operations
FIELD		|inventory_mode	|t_integer	|'0'	|NOT NULL	|0

TABLE|dbversion||
FIELD		|mandatory	|t_integer	|'0'	|NOT NULL	|
FIELD		|optional	|t_integer	|'0'	|NOT NULL	|
ROW		|3000000	|3000000
