Minor changes.

git-svn-id: svn://svn.zabbix.com/trunk@3556 97f52cf1-0a1b-0410-bd0e-c28be96e8082

1 files changed, 538 insertions, 682 deletions

diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index 0413a05b..312237bb 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -18,687 +18,543 @@
 --
 
 --
--- Table structure for table 'nodes'
+-- Do not use spaces
 --
 
-CREATE TABLE nodes (
-	nodeid			{integer}		DEFAULT '0' NOT NULL,
-	name			{varchar}(64)		DEFAULT '' NOT NULL,
-	timezone		{integer}		DEFAULT '0' NOT NULL,
-	ip			{varchar}(15)		DEFAULT '' NOT NULL,
-	port			{integer}		DEFAULT '0' NOT NULL,
-	slave_history		{integer}		DEFAULT '0' NOT NULL,
-	slave_trends		{integer}		DEFAULT '0' NOT NULL,
-	event_lastid		{bigint}		DEFAULT '0' NOT NULL,
-	history_lastid		{bigint}		DEFAULT '0' NOT NULL,
-	nodetype		{integer}		DEFAULT '0' NOT NULL,
-	masterid		{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (nodeid)
-) {create_table_opt};
-
-CREATE TABLE node_cksum (
-	cksumid			{bigint}		DEFAULT '0' NOT NULL,
-	nodeid			{bigint}		DEFAULT '0' NOT NULL,
-	tablename		{varchar}(64)	DEFAULT '' NOT NULL,
-	fieldname		{varchar}(64)	DEFAULT '' NOT NULL,
-	recordid		{bigint}		DEFAULT '0' NOT NULL,
-	cksumtype		{integer}		DEFAULT '0' NOT NULL,
-	cksum			{char}(32)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (cksumid)
-) {create_table_opt};
-
-CREATE INDEX node_cksum_1 ON node_cksum (nodeid,tablename,fieldname,recordid,cksumtype);
-
-CREATE TABLE node_configlog (
-	conflogid		{bigint}		DEFAULT '0' NOT NULL,
-	nodeid			{bigint}		DEFAULT '0' NOT NULL,
-	tablename		{varchar}(64)	DEFAULT '' NOT NULL,
-	recordid		{bigint}		DEFAULT '0' NOT NULL,
-	operation		{integer}	DEFAULT '0' NOT NULL,
-	sync_master		{integer}		DEFAULT '0' NOT NULL,
-	sync_slave		{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (nodeid,conflogid)
-) {create_table_opt};
-
-CREATE INDEX node_configlog_1 ON node_configlog (conflogid);
-CREATE INDEX node_configlog_2 ON node_configlog (nodeid,tablename);
-
-CREATE TABLE services (
-	serviceid		{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(128)	DEFAULT '' NOT NULL,
-	status			{integer}		DEFAULT '0' NOT NULL,
-	algorithm		{integer}		DEFAULT '0' NOT NULL,
-	triggerid		{bigint},
-	showsla			{integer}		DEFAULT '0' NOT NULL,
-	goodsla			{double}(5,2)	DEFAULT '99.9' NOT NULL,
-	sortorder		{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (serviceid)
-) {create_table_opt};
-
-CREATE TABLE services_times (
-	timeid		{bigint}		DEFAULT '0' NOT NULL,
-	serviceid	{bigint}		DEFAULT '0' NOT NULL,
-	type		{integer}		DEFAULT '0' NOT NULL,
-	ts_from		{integer}		DEFAULT '0' NOT NULL,
-	ts_to		{integer}		DEFAULT '0' NOT NULL,
-	note		{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (timeid)
-) {create_table_opt};
-
-CREATE INDEX services_times_1 ON services_times (serviceid,type,ts_from,ts_to);
-
-CREATE TABLE services_links (
-	linkid			{bigint}		DEFAULT '0' NOT NULL,
-	serviceupid		{bigint}		DEFAULT '0' NOT NULL,
-	servicedownid		{bigint}		DEFAULT '0' NOT NULL,
-	soft			{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (linkid)
-) {create_table_opt};
-
-CREATE INDEX services_links_1 ON services_links (servicedownid);
-CREATE INDEX services_links_2 ON services_links (serviceupid,servicedownid);
-
-CREATE TABLE graphs_items (
-	gitemid		{bigint}		DEFAULT '0' NOT NULL,
-	graphid		{bigint}		DEFAULT '0' NOT NULL,
-	itemid		{bigint}		DEFAULT '0' NOT NULL,
-	drawtype	{integer}		DEFAULT '0' NOT NULL,
-	sortorder	{integer}		DEFAULT '0' NOT NULL,
-	color		{varchar}(32)	DEFAULT 'Dark Green' NOT NULL,
-	yaxisside	{integer}		DEFAULT '1' NOT NULL,
-	calc_fnc	{integer}		DEFAULT '2' NOT NULL,
-	type		{integer}		DEFAULT '0' NOT NULL,
-	periods_cnt	{integer}		DEFAULT '5' NOT NULL,
-	PRIMARY KEY (gitemid)
-) {create_table_opt};
-
-CREATE TABLE graphs (
-	graphid			{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(128)	DEFAULT '' NOT NULL,
-	width			{integer}		DEFAULT '0' NOT NULL,
-	height			{integer}		DEFAULT '0' NOT NULL,
-	yaxistype		{integer}		DEFAULT '0' NOT NULL,
-	yaxismin		{double}(16,4)	DEFAULT '0' NOT NULL,
-	yaxismax		{double}(16,4)	DEFAULT '0' NOT NULL,
-	templateid		{bigint}		DEFAULT '0' NOT NULL,
-	show_work_period	{integer}		DEFAULT '1' NOT NULL,
-	show_triggers		{integer}		DEFAULT '1' NOT NULL,
-	graphtype		{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (graphid)
-) {create_table_opt};
-
-CREATE INDEX graphs_1 ON graphs (name);
-
-CREATE TABLE sysmaps_links (
-	linkid			{bigint}		DEFAULT '0' NOT NULL,
-	sysmapid		{bigint}		DEFAULT '0' NOT NULL,
-	selementid1		{bigint}		DEFAULT '0' NOT NULL,
-	selementid2		{bigint}		DEFAULT '0' NOT NULL,
-	triggerid		{bigint},
-	drawtype_off		{integer}		DEFAULT '0' NOT NULL,
-	color_off		{varchar}(32)	DEFAULT 'Black' NOT NULL,
-	drawtype_on		{integer}		DEFAULT '0' NOT NULL,
-	color_on		{varchar}(32)	DEFAULT 'Red' NOT NULL,
-	PRIMARY KEY (linkid)
-) {create_table_opt};
-
-CREATE TABLE sysmaps_elements (
-	selementid		{bigint}		DEFAULT '0' NOT NULL,
-	sysmapid		{bigint}		DEFAULT '0' NOT NULL,
-	elementid		{bigint}		DEFAULT '0' NOT NULL,
-	elementtype		{integer}		DEFAULT '0' NOT NULL,
-	iconid_off		{bigint}		DEFAULT '0' NOT NULL,
-	iconid_on		{bigint}		DEFAULT '0' NOT NULL,
-	label			{varchar}(128)	DEFAULT '' NOT NULL,
-	label_location		{integer}		DEFAULT NULL,
-	x			{integer}		DEFAULT '0' NOT NULL,
-	y			{integer}		DEFAULT '0' NOT NULL,
-	url			{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (selementid)
-) {create_table_opt};
-
-CREATE TABLE sysmaps (
-	sysmapid		{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(128)	DEFAULT '' NOT NULL,
-	width			{integer}		DEFAULT '0' NOT NULL,
-	height			{integer}		DEFAULT '0' NOT NULL,
-	backgroundid		{bigint}		DEFAULT '0' NOT NULL,
-	label_type		{integer}		DEFAULT '0' NOT NULL,
-	label_location		{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (sysmapid)
-) {create_table_opt};
-
-CREATE INDEX sysmaps_1 ON sysmaps (name);
-
-CREATE TABLE config (
-	configid		{bigint}		DEFAULT '0' NOT NULL,
-	alert_history		{integer}		DEFAULT '0' NOT NULL,
-	event_history		{integer}		DEFAULT '0' NOT NULL,
-	refresh_unsupported	{integer}		DEFAULT '0' NOT NULL,
-	work_period		{varchar}(100)	DEFAULT '1-5,00:00-24:00' NOT NULL,
-	PRIMARY KEY (configid)
-) {create_table_opt};
-
-CREATE TABLE groups (
-	groupid			{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(64)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (groupid)
-) {create_table_opt};
-
-CREATE INDEX groups_1 ON groups (name);
-
-CREATE TABLE hosts_groups (
-	hostgroupid		{bigint}		DEFAULT '0' NOT NULL,
-	hostid			{bigint}		DEFAULT '0' NOT NULL,
-	groupid			{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (hostgroupid)
-) {create_table_opt};
-
-CREATE INDEX hosts_groups_1 ON hosts_groups (hostid,groupid);
-
-CREATE TABLE alerts (
-	alertid			{bigint}		DEFAULT '0' NOT NULL,
-	actionid		{bigint}		DEFAULT '0' NOT NULL,
-	triggerid		{bigint}		DEFAULT '0' NOT NULL,
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	mediatypeid		{bigint}		DEFAULT '0' NOT NULL,
-	sendto			{varchar}(100)	DEFAULT '' NOT NULL,
-	subject			{varchar}(255)	DEFAULT '' NOT NULL,
-	message			{blob}		DEFAULT '' NOT NULL,
-	status			{integer}		DEFAULT '0' NOT NULL,
-	retries			{integer}		DEFAULT '0' NOT NULL,
-	error			{varchar}(128)	DEFAULT '' NOT NULL,
-	repeats			{integer}		DEFAULT '0' NOT NULL,
-	maxrepeats		{integer}		DEFAULT '0' NOT NULL,
-	nextcheck		{integer}		DEFAULT '0' NOT NULL,
-	delay			{integer}		DEFAULT '0' NOT NULL,
-
-	PRIMARY KEY (alertid)
-) {create_table_opt};
-
-CREATE INDEX alerts_1 ON alerts (actionid);
-CREATE INDEX alerts_2 ON alerts (clock);
-CREATE INDEX alerts_3 ON alerts (triggerid);
-CREATE INDEX alerts_4 ON alerts (status, retries);
-CREATE INDEX alerts_5 ON alerts (mediatypeid);
-CREATE INDEX alerts_6 ON alerts (userid);
-
-CREATE TABLE actions (
-	actionid		{bigint}		DEFAULT '0' NOT NULL,
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	subject			{varchar}(255)	DEFAULT '' NOT NULL,
-	message			{blob}		DEFAULT '' NOT NULL,
-	recipient		{integer}		DEFAULT '0' NOT NULL,
-	maxrepeats		{integer}		DEFAULT '0' NOT NULL,
-	repeatdelay		{integer}		DEFAULT '600' NOT NULL,
-	source			{integer}		DEFAULT '0' NOT NULL,
-	actiontype		{integer}		DEFAULT '0' NOT NULL,
-	status			{integer}		DEFAULT '0' NOT NULL,
-	scripts			{blob}		DEFAULT '' NOT NULL,
-	PRIMARY KEY (actionid)
-) {create_table_opt};
-
-CREATE TABLE conditions (
-	conditionid		{bigint}		DEFAULT '0' NOT NULL,
-	actionid		{bigint}		DEFAULT '0' NOT NULL,
-	conditiontype		{integer}		DEFAULT '0' NOT NULL,
-	operator		{integer}		DEFAULT '0' NOT NULL,
-	value			{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (conditionid)
-) {create_table_opt};
-
-CREATE INDEX conditions_1 ON conditions (actionid);
-
-CREATE TABLE events (
-	eventid			{bigint}		DEFAULT '0' NOT NULL,
-	triggerid		{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{integer}		DEFAULT '0' NOT NULL,
-	acknowledged		{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (eventid)
-) {create_table_opt};
-
-CREATE INDEX events_1 ON events (triggerid,clock);
-CREATE INDEX events_2 ON events (clock);
-
-CREATE TABLE functions (
-	functionid		{bigint}		DEFAULT '0' NOT NULL,
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	triggerid		{bigint}		DEFAULT '0' NOT NULL,
-	lastvalue		{varchar}(255),
-	function		{varchar}(12)	DEFAULT '' NOT NULL,
-	parameter		{varchar}(255)	DEFAULT '0' NOT NULL,
-	PRIMARY KEY (functionid)
-) {create_table_opt};
-
-CREATE INDEX functions_1 ON functions (triggerid);
-CREATE INDEX functions_2 ON functions (itemid,function,parameter);
-
-CREATE TABLE history (
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{double}(16,4)	DEFAULT '0.0000' NOT NULL
-) {create_table_opt};
-
-CREATE INDEX history_1 ON history (itemid, clock);
-
-CREATE TABLE history_sync (
-	id			{serial},
-	nodeid			{bigint}			DEFAULT '0' NOT NULL,
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{double}(16,4)		DEFAULT '0.0000' NOT NULL,
-	PRIMARY KEY (id)
-) {create_table_opt};
-
-CREATE INDEX history_sync_1 ON history_sync (nodeid, id);
-
-CREATE TABLE history_uint (
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{bigint}		DEFAULT '0' NOT NULL
-) {create_table_opt};
-
-CREATE INDEX history_uint_1 ON history_uint (itemid, clock);
-
-CREATE TABLE history_uint_sync (
-	id			{serial},
-	nodeid			{integer}			DEFAULT '0' NOT NULL,
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (id)
-) {create_table_opt};
-
-CREATE INDEX history_uint_sync_1 ON history_uint_sync (nodeid, id);
-
-CREATE TABLE history_str (
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{varchar}(255)	DEFAULT '' NOT NULL
-) {create_table_opt};
-
-CREATE INDEX history_str_1 ON history_str (itemid, clock);
-
-CREATE TABLE history_str_sync (
-	id			{serial},
-	nodeid			{integer}			DEFAULT '0' NOT NULL,
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (id)
-) {create_table_opt};
-
-CREATE INDEX history_str_sync_1 ON history_str_sync (nodeid, id);
-
-CREATE TABLE hosts (
-	hostid			{bigint}			DEFAULT '0' NOT NULL,
-	host			{varchar}(64)		DEFAULT '' NOT NULL,
-	useip			{integer}			DEFAULT '1' NOT NULL,
-	ip			{varchar}(15)		DEFAULT '127.0.0.1' NOT NULL,
-	port			{integer}			DEFAULT '0' NOT NULL,
-	status			{integer}			DEFAULT '0' NOT NULL,
-	disable_until		{integer}			DEFAULT '0' NOT NULL,
-	error			{varchar}(128)		DEFAULT '' NOT NULL,
-	available		{integer}			DEFAULT '0' NOT NULL,
-	errors_from		{integer}			DEFAULT '0' NOT NULL,
-	PRIMARY KEY	(hostid)
-) {create_table_opt};
-
-CREATE INDEX hosts_1 ON hosts (host);
-CREATE INDEX hosts_2 ON hosts (status);
-
-CREATE TABLE items (
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	type			{integer}		DEFAULT '0' NOT NULL,
-	snmp_community		{varchar}(64)	DEFAULT '' NOT NULL,
-	snmp_oid		{varchar}(255)	DEFAULT '' NOT NULL,
-	snmp_port		{integer}		DEFAULT '161' NOT NULL,
-	hostid			{bigint}	 	DEFAULT '0' NOT NULL,
-	description		{varchar}(255)	DEFAULT '' NOT NULL,
-	key_			{varchar}(64)	DEFAULT '' NOT NULL,
-	delay			{integer} 	DEFAULT '0' NOT NULL,
-	history			{integer} 	DEFAULT '90' NOT NULL,
-	trends			{integer}		DEFAULT '365' NOT NULL,
-	nextcheck		{integer}		DEFAULT '0' NOT NULL,
-	lastvalue		{varchar}(255)	DEFAULT NULL,
-	lastclock		{integer}		DEFAULT NULL,
-	prevvalue		{varchar}(255)	DEFAULT NULL,
-	status			{integer}		DEFAULT '0' NOT NULL,
-	value_type		{integer}		DEFAULT '0' NOT NULL,
-	trapper_hosts		{varchar}(255)	DEFAULT '' NOT NULL,
-	units			{varchar}(10)	DEFAULT '' NOT NULL,
-	multiplier		{integer}		DEFAULT '0' NOT NULL,
-	delta			{integer}		DEFAULT '0' NOT NULL,
-	prevorgvalue		{double}(16,4)	DEFAULT NULL,
-	snmpv3_securityname	{varchar}(64)	DEFAULT '' NOT NULL,
-	snmpv3_securitylevel	{integer}		DEFAULT '0' NOT NULL,
-	snmpv3_authpassphrase	{varchar}(64)	DEFAULT '' NOT NULL,
-	snmpv3_privpassphrase	{varchar}(64)	DEFAULT '' NOT NULL,
-
-	formula			{varchar}(255)	DEFAULT '0' NOT NULL,
-	error			{varchar}(128)	DEFAULT '' NOT NULL,
-
-	lastlogsize		{integer}		DEFAULT '0' NOT NULL,
-	logtimefmt		{varchar}(64)	DEFAULT '' NOT NULL,
-	templateid		{bigint}		DEFAULT '0' NOT NULL,
-	valuemapid		{bigint}		DEFAULT '0' NOT NULL,
-	delay_flex		{varchar}(255)	DEFAULT '' NOT NULL,
-
-	PRIMARY KEY	(itemid)
-) {create_table_opt};
-
-CREATE INDEX items_1 ON items (hostid,key_);
-CREATE INDEX items_2 ON items (nextcheck);
-CREATE INDEX items_3 ON items (status);
-
-CREATE TABLE media (
-	mediaid			{bigint}		DEFAULT '0' NOT NULL,
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	mediatypeid		{bigint}		DEFAULT '0' NOT NULL,
-	sendto			{varchar}(100)	DEFAULT '' NOT NULL,
-	active			{integer}		DEFAULT '0' NOT NULL,
-	severity		{integer}		DEFAULT '63' NOT NULL,
-	period			{varchar}(100)	DEFAULT '1-7,00:00-23:59' NOT NULL,
-	PRIMARY KEY	(mediaid)
-) {create_table_opt};
-
-CREATE INDEX media_1 ON media (userid);
-CREATE INDEX media_2 ON media (mediatypeid);
-
-CREATE TABLE media_type (
-	mediatypeid		{bigint}		DEFAULT '0' NOT NULL,
-	type			{integer}		DEFAULT '0' NOT NULL,
-	description		{varchar}(100)	DEFAULT '' NOT NULL,
-	smtp_server		{varchar}(255)	DEFAULT '' NOT NULL,
-	smtp_helo		{varchar}(255)	DEFAULT '' NOT NULL,
-	smtp_email		{varchar}(255)	DEFAULT '' NOT NULL,
-	exec_path		{varchar}(255)	DEFAULT '' NOT NULL,
-	gsm_modem		{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY	(mediatypeid)
-) {create_table_opt};
-
-CREATE TABLE triggers (
-	triggerid		{bigint}		DEFAULT '0' NOT NULL,
-	expression		{varchar}(255)	DEFAULT '' NOT NULL,
-	description		{varchar}(255)	DEFAULT '' NOT NULL,
-	url			{varchar}(255)	DEFAULT '' NOT NULL,
-	status			{integer}		DEFAULT '0' NOT NULL,
-	value			{integer}		DEFAULT '0' NOT NULL,
-	priority		{integer}		DEFAULT '0' NOT NULL,
-	lastchange		{integer}		DEFAULT '0' NOT NULL,
-	dep_level		{integer}		DEFAULT '0' NOT NULL,
-	comments		{blob},
-	error			{varchar}(128)	DEFAULT '' NOT NULL,
-	templateid		{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY	(triggerid)
-) {create_table_opt};
-
-CREATE INDEX triggers_1 ON triggers (status);
-CREATE INDEX triggers_2 ON triggers (value);
-
-CREATE TABLE trigger_depends (
-	triggerdepid		{bigint}		DEFAULT '0' NOT NULL,
-	triggerid_down		{bigint}		DEFAULT '0' NOT NULL,
-	triggerid_up		{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY	(triggerdepid)
-) {create_table_opt};
-
-CREATE INDEX trigger_depends_1 ON trigger_depends (triggerid_down, triggerid_up);
-CREATE INDEX trigger_depends_2 ON trigger_depends (triggerid_up);
-
-CREATE TABLE users (
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	alias			{varchar}(100)	DEFAULT '' NOT NULL,
-	name			{varchar}(100)	DEFAULT '' NOT NULL,
-	surname			{varchar}(100)	DEFAULT '' NOT NULL,
-	passwd			{char}(32)	DEFAULT '' NOT NULL,
-	url			{varchar}(255)	DEFAULT '' NOT NULL,
-	autologout		{integer}		DEFAULT '900' NOT NULL,
-	lang			{varchar}(5)	DEFAULT 'en_gb' NOT NULL,
-	refresh			{integer}		DEFAULT '30' NOT NULL,
-	type			{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (userid)
-) {create_table_opt};
-
-CREATE INDEX users_1 ON users (alias);
-
-CREATE TABLE auditlog (
-	auditid			{bigint}		DEFAULT '0' NOT NULL,
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	action			{integer}		DEFAULT '0' NOT NULL,
-	resourcetype		{integer}		DEFAULT '0' NOT NULL,
-	details			{varchar}(128)	DEFAULT '0' NOT NULL,
-	PRIMARY KEY (auditid)
-) {create_table_opt};
-
-CREATE INDEX auditlog_1 ON auditlog (userid,clock);
-CREATE INDEX auditlog_2 ON auditlog (clock);
-
-CREATE TABLE sessions (
-	sessionid		{varchar}(32)	NOT NULL DEFAULT '',
-	userid			{bigint}		NOT NULL DEFAULT '0',
-	lastaccess		{integer}		NOT NULL DEFAULT '0',
-	PRIMARY KEY (sessionid)
-) {create_table_opt};
-
-CREATE TABLE rights (
-	rightid			{bigint}		DEFAULT '0' NOT NULL,
-	groupid			{bigint}		DEFAULT '0' NOT NULL,
-	type			{integer}		DEFAULT '0' NOT NULL,
-	permission		{integer}		DEFAULT '0' NOT NULL,
-	id			{bigint},
-	PRIMARY KEY (rightid)
-) {create_table_opt};
-
-CREATE INDEX rights_1 ON rights (groupid);
-
-CREATE TABLE service_alarms (
-	servicealarmid		{bigint}		DEFAULT '0' NOT NULL,
-	serviceid		{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (servicealarmid)
-) {create_table_opt};
-
-CREATE INDEX service_alarms_1 ON service_alarms (serviceid,clock);
-CREATE INDEX service_alarms_2 ON service_alarms (clock);
-
-CREATE TABLE profiles (
-	profileid		{bigint}		DEFAULT '0' NOT NULL,
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	idx			{varchar}(64)	DEFAULT '' NOT NULL,
-	value			{varchar}(255)	DEFAULT '' NOT NULL,
-	valuetype		{integer}		DEFAULT 0 NOT NULL,
-	PRIMARY KEY (profileid)
-) {create_table_opt};
-
-CREATE INDEX profiles_1 ON profiles (userid,idx);
-
-CREATE TABLE screens (
-	screenid		{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(255)	DEFAULT 'Screen' NOT NULL,
-	hsize			{integer}		DEFAULT '1' NOT NULL,
-	vsize			{integer}		DEFAULT '1' NOT NULL,
-	PRIMARY KEY  (screenid)
-) {create_table_opt};
-
-CREATE TABLE screens_items (
-	screenitemid	{bigint}		DEFAULT '0' NOT NULL,
-	screenid	{bigint}		DEFAULT '0' NOT NULL,
-	resourcetype	{integer}		DEFAULT '0' NOT NULL,
-	resourceid	{bigint}		DEFAULT '0' NOT NULL,
-	width		{integer}		DEFAULT '320' NOT NULL,
-	height		{integer}		DEFAULT '200' NOT NULL,
-	x		{integer}		DEFAULT '0' NOT NULL,
-	y		{integer}		DEFAULT '0' NOT NULL,
-	colspan		{integer}		DEFAULT '0' NOT NULL,
-	rowspan		{integer}		DEFAULT '0' NOT NULL,
-	elements	{integer}		DEFAULT '25' NOT NULL,
-	valign		{integer}		DEFAULT '0' NOT NULL,
-	halign		{integer}		DEFAULT '0' NOT NULL,
-	style		{integer}		DEFAULT '0' NOT NULL,
-	url		{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY  (screenitemid)
-) {create_table_opt};
-
-CREATE TABLE usrgrp (
-	usrgrpid		{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(64)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (usrgrpid)
-) {create_table_opt};
-
-CREATE INDEX usrgrp_1 ON usrgrp (name);
-
-CREATE TABLE users_groups (
-	id			{bigint}		DEFAULT '0' NOT NULL,
-	usrgrpid		{bigint}		DEFAULT '0' NOT NULL,
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (id)
-) {create_table_opt};
-
-CREATE INDEX users_groups_1 ON users_groups (usrgrpid,userid);
-
-CREATE TABLE trends (
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	num			{integer}		DEFAULT '0' NOT NULL,
-	value_min		{double}(16,4)	DEFAULT '0.0000' NOT NULL,
-	value_avg		{double}(16,4)	DEFAULT '0.0000' NOT NULL,
-	value_max		{double}(16,4)	DEFAULT '0.0000' NOT NULL,
-	PRIMARY KEY (itemid,clock)
-) {create_table_opt};
-
-CREATE TABLE images (
-	imageid			{bigint}		DEFAULT '0' NOT NULL,
-	imagetype		{integer}		DEFAULT '0' NOT NULL,
-	name			{varchar}(64)	DEFAULT '0' NOT NULL,
-	image			{image_type}	DEFAULT '' NOT NULL,
-	PRIMARY KEY (imageid)
-) {create_table_opt};
-
-CREATE INDEX images_1 ON images (imagetype, name);
-
-CREATE TABLE hosts_templates (
-	hosttemplateid		{bigint}		DEFAULT '0' NOT NULL,
-	hostid			{bigint}		DEFAULT '0' NOT NULL,
-	templateid		{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (hosttemplateid)
-) {create_table_opt};
-
-CREATE INDEX hosts_templates_1 ON hosts_templates (hostid, templateid);
-
-CREATE TABLE history_log (
-	id			{bigint}		DEFAULT '0' NOT NULL,
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	timestamp		{integer}		DEFAULT '0' NOT NULL,
-	source			{varchar}(64)	DEFAULT '' NOT NULL,
-	severity		{integer}		DEFAULT '0' NOT NULL,
-	value			{history_log_type}	DEFAULT '' NOT NULL,
-	PRIMARY KEY (id)
-) {create_table_opt};
-
-CREATE INDEX history_log_1 ON history_log (itemid, clock);
-
-CREATE TABLE history_text (
-	id			{bigint}		DEFAULT '0' NOT NULL,
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	value			{history_text_type}	DEFAULT '' NOT NULL,
-	PRIMARY KEY (id)
-) {create_table_opt};
-
-CREATE INDEX history_text_1 ON history_text (itemid, clock);
-
-CREATE TABLE hosts_profiles (
-	hostid			{bigint}		DEFAULT '0' NOT NULL,
-	devicetype		{varchar}(64)	DEFAULT '' NOT NULL,
-	name			{varchar}(64)	DEFAULT '' NOT NULL,
-	os			{varchar}(64)	DEFAULT '' NOT NULL,
-	serialno		{varchar}(64)	DEFAULT '' NOT NULL,
-	tag			{varchar}(64)	DEFAULT '' NOT NULL,
-	macaddress		{varchar}(64)	DEFAULT '' NOT NULL,
-	hardware		{blob}		DEFAULT '' NOT NULL,
-	software		{blob}		DEFAULT '' NOT NULL,
-	contact			{blob}		DEFAULT '' NOT NULL,
-	location		{blob}		DEFAULT '' NOT NULL,
-	notes			{blob}		DEFAULT '' NOT NULL,
-	PRIMARY KEY (hostid)
-) {create_table_opt};
-
-CREATE TABLE autoreg (
-	id		{bigint}		DEFAULT '0' NOT NULL,
-	priority	{integer}		DEFAULT '0' NOT NULL,
-	pattern		{varchar}(255)	DEFAULT '' NOT NULL,
-	hostid		{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (id)
-) {create_table_opt};
-
-CREATE TABLE valuemaps (
-	valuemapid		{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(64)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (valuemapid)
-) {create_table_opt};
-
-CREATE INDEX valuemaps_1 ON valuemaps (name);
-
-CREATE TABLE mappings (
-	mappingid		{bigint}		DEFAULT '0' NOT NULL,
-	valuemapid		{bigint}		DEFAULT '0' NOT NULL,
-	value			{varchar}(64)	DEFAULT '' NOT NULL,
-	newvalue		{varchar}(64)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (mappingid)
-) {create_table_opt};
-
-CREATE INDEX mappings_1 ON mappings (valuemapid);
-
-CREATE TABLE housekeeper (
-	housekeeperid		{bigint}		DEFAULT '0' NOT NULL,
-	tablename		{varchar}(64)	DEFAULT '' NOT NULL,
-	field			{varchar}(64)	DEFAULT '' NOT NULL,
-	value			{integer}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (housekeeperid)
-) {create_table_opt};
-
-CREATE TABLE acknowledges (
-	acknowledgeid		{bigint}		DEFAULT '0' NOT NULL,
-	userid			{bigint}		DEFAULT '0' NOT NULL,
-	eventid			{bigint}		DEFAULT '0' NOT NULL,
-	clock			{integer}		DEFAULT '0' NOT NULL,
-	message			{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (acknowledgeid)
-) {create_table_opt};
-
-CREATE INDEX acknowledges_1 ON acknowledges (userid);
-CREATE INDEX acknowledges_2 ON acknowledges (eventid);
-CREATE INDEX acknowledges_3 ON acknowledges (clock);
-
-CREATE TABLE applications (
-	applicationid		{bigint}		DEFAULT '0' NOT NULL,
-	hostid			{bigint}		DEFAULT '0' NOT NULL,
-	name			{varchar}(255)	DEFAULT '' NOT NULL,
-	templateid		{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY 	(applicationid)
-) {create_table_opt};
-
-CREATE INDEX applications_1 ON applications (templateid);
-CREATE INDEX applications_2 ON applications (hostid,name);
-
-CREATE TABLE items_applications (
-	itemappid		{bigint}		DEFAULT '0' NOT NULL,
-	applicationid		{bigint}		DEFAULT '0' NOT NULL,
-	itemid			{bigint}		DEFAULT '0' NOT NULL,
-	PRIMARY KEY (itemappid)
-) {create_table_opt};
-
-CREATE INDEX items_applications_1 ON items_applications (applicationid,itemid);
-
-CREATE TABLE help_items (
-	itemtype		{integer}          DEFAULT '0' NOT NULL,
-	key_			{varchar}(64)	DEFAULT '' NOT NULL,
-	description		{varchar}(255)	DEFAULT '' NOT NULL,
-	PRIMARY KEY (itemtype, key_)
-) {create_table_opt};
+TABLE|nodes|nodeid|
+FIELD		|nodeid		|t_id		|'0'	|NOT NULL	|0
+FIELD		|name		|t_varchar(64)	|'0'	|NOT NULL	|0
+FIELD		|timezone	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|ip		|t_varchar(15)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|port		|t_integer	|'10051'|NOT NULL	|ZBX_SYNC
+FIELD		|slave_history	|t_integer	|'30'	|NOT NULL	|ZBX_SYNC
+FIELD		|slave_trends	|t_integer	|'365'	|NOT NULL	|ZBX_SYNC
+FIELD		|event_lastid	|t_id		|'0'	|NOT NULL	|0
+FIELD		|event_maxid	|t_id		|'0'	|NOT NULL	|0
+FIELD		|alert_maxid	|t_id		|'0'	|NOT NULL	|0
+FIELD		|history_lastid	|t_bigint	|'0'	|NOT NULL	|0
+FIELD		|history_str_lastid|t_bigint	|'0'	|NOT NULL	|0
+FIELD		|history_uint_lastid|t_bigint	|'0'	|NOT NULL	|0
+FIELD		|nodetype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|masterid	|t_id		|'0'	|NOT NULL	|0
+
+TABLE|node_cksum|cksumid|0
+FIELD		|cksumid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|nodeid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|tablename	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|fieldname	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|recordid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|cksumtype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|cksum		|t_char(32)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|cksum_1	|nodeid,tablename,fieldname,recordid,cksumtype
+
+TABLE|node_configlog|nodeid,conflogid|0
+FIELD		|conflogid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|nodeid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|tablename	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|recordid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|operation	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|sync_master	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|sync_slave	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|configlog_1	|conflogid
+INDEX		|configlog_2	|nodeid,tablename
+
+TABLE|services|serviceid|ZBX_SYNC
+FIELD		|serviceid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|algorithm	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid	|t_id		|	|		|ZBX_SYNC
+FIELD		|showsla	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|goodsla	|t_double(5,2)	|'99.9'	|NOT NULL	|ZBX_SYNC
+FIELD		|sortorder	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+
+TABLE|services_times|timeid|ZBX_SYNC
+FIELD		|timeid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|serviceid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|ts_from	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|ts_to		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|note		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|times_1	|serviceid,type,ts_from,ts_to
+
+TABLE|services_links|linkid|ZBX_SYNC
+FIELD		|linkid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|serviceupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|servicedownid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|soft		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|links_1	|servicedownid
+UNIQUE		|links_2	|serviceupid,servicedownid
+
+TABLE|graphs_items|gitemid|ZBX_SYNC
+FIELD		|gitemid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|graphid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|drawtype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|sortorder	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|color		|t_varchar(32)	|'Dark Green'	|NOT NULL	|ZBX_SYNC
+FIELD		|yaxisside	|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
+FIELD		|calc_fnc	|t_integer	|'2'	|NOT NULL	|ZBX_SYNC
+FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|periods_cnt	|t_integer	|'5'	|NOT NULL	|ZBX_SYNC
+
+TABLE|graphs|graphid|ZBX_SYNC
+FIELD		|graphid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|width		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|height		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|yaxistype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|yaxismin	|t_double(16,4)	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|yaxismax	|t_double(16,4)	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|templateid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|show_work_period|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
+FIELD		|show_triggers	|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
+FIELD		|graphtype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|graphs_1	|name
+
+TABLE|sysmaps_links|linkid|ZBX_SYNC
+FIELD		|linkid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|sysmapid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|selementid1	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|selementid2	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid	|t_id		|	|		|ZBX_SYNC
+FIELD		|drawtype_off	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|color_off	|t_varchar(32)	|'Black'|NOT NULL	|ZBX_SYNC
+FIELD		|drawtype_on	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|color_on	|t_varchar(32)	|'Red'	|NOT NULL	|ZBX_SYNC
+
+TABLE|sysmaps_elements|selementid|ZBX_SYNC
+FIELD		|selementid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|sysmapid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|elementid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|elementtype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|iconid_off	|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|iconid_on	|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|label		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|label_location	|t_integer	|	|NULL		|ZBX_SYNC
+FIELD		|x		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|y		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+
+TABLE|sysmaps|sysmapid|ZBX_SYNC
+FIELD		|sysmapid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|width		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|height		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|backgroundid	|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|label_type	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|label_location	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|name
+
+TABLE|config|configid|ZBX_SYNC
+FIELD		|configid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|alert_history	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|event_history	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|refresh_unsupported|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|work_period	|t_varchar(100)	|'1-5,00:00-24:00'	|NOT NULL	|ZBX_SYNC
+
+TABLE|groups|groupid|ZBX_SYNC
+FIELD		|groupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|name
+
+TABLE|hosts_groups|hostgroupid|ZBX_SYNC
+FIELD		|hostgroupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|groupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|groups_1	|hostid,groupid
+
+TABLE|alerts|alertid|ZBX_SYNC
+FIELD		|alertid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|actionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|mediatypeid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|sendto		|t_varchar(100)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|subject	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|message	|t_blob		|''	|NOT NULL	|ZBX_SYNC
+FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|retries	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|error		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|repeats	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|maxrepeats	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|nextcheck	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|delay		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|actionid
+INDEX		|2		|clock
+INDEX		|3		|triggerid
+INDEX		|4		|status,retries
+INDEX		|5		|mediatypeid
+INDEX		|6		|userid
+
+TABLE|actions|actionid|ZBX_SYNC
+FIELD		|actionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|subject	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|message	|t_blob		|''	|NOT NULL	|ZBX_SYNC
+FIELD		|recipient	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|maxrepeats	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|repeatdelay	|t_integer	|'600'	|NOT NULL	|ZBX_SYNC
+FIELD		|source		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|actiontype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|scripts	|t_blob		|''	|NOT NULL	|ZBX_SYNC
+
+TABLE|conditions|conditionid|ZBX_SYNC
+FIELD		|conditionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|actionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|conditiontype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|operator	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|actionid
+
+TABLE|events|eventid|0
+FIELD		|eventid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|acknowledged	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|triggerid,clock
+INDEX		|2		|clock
+
+TABLE|functions|functionid|ZBX_SYNC
+FIELD		|functionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|lastvalue	|t_varchar(255)	|	|		|0
+FIELD		|function	|t_varchar(12)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|parameter	|t_varchar(255)	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|triggerid
+INDEX		|2		|itemid,function,parameter
+
+TABLE|history||0
+FIELD		|itemid		|t_id		|'0'		|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'		|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_double(16,4)	|'0.0000'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|itemid,clock
+
+TABLE|history_sync|id|
+FIELD		|id		|t_serial		|		|		|ZBX_SYNC
+FIELD		|nodeid		|t_id		|'0'		|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'		|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'		|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_double(16,4)	|'0.0000'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|nodeid,id
+
+TABLE|history_uint||0
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|itemid,clock
+
+TABLE|history_uint_sync|id|
+FIELD		|id		|t_serial		|	|		|ZBX_SYNC
+FIELD		|nodeid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|nodeid,id
+
+TABLE|history_str||0
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|itemid,clock
+
+TABLE|history_str_sync|id|
+FIELD		|id		|t_serial		|	|		|ZBX_SYNC
+FIELD		|nodeid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|nodeid,id
+
+TABLE|hosts|hostid|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|host		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|useip		|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
+FIELD		|ip		|t_varchar(15)	|'127.0.0.1'|NOT NULL	|ZBX_SYNC
+FIELD		|port		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|disable_until	|t_integer	|'0'	|NOT NULL	|0
+FIELD		|error		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|available	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|errors_from	|t_integer	|'0'	|NOT NULL	|0
+INDEX		|1		|host
+INDEX		|2		|status
+
+TABLE|items|itemid|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|snmp_community	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|snmp_oid	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|snmp_port	|t_integer	|'161'	|NOT NULL	|ZBX_SYNC
+FIELD		|hostid		|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|description	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|key_		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|delay		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|history	|t_integer	|'90'	|NOT NULL	|ZBX_SYNC
+FIELD		|trends		|t_integer	|'365'	|NOT NULL	|ZBX_SYNC
+FIELD		|nextcheck	|t_time		|'0'	|NOT NULL	|0
+FIELD		|lastvalue	|t_varchar(255)	|	|NULL		|0
+FIELD		|lastclock	|t_time		|	|NULL		|0
+FIELD		|prevvalue	|t_varchar(255)	|	|NULL		|0
+FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value_type	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|trapper_hosts	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|units		|t_varchar(10)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|multiplier	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|delta		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|prevorgvalue	|t_double(16,4)	|	|NULL		|0
+FIELD		|snmpv3_securityname|t_varchar(64)|''	|NOT NULL	|ZBX_SYNC
+FIELD		|snmpv3_securitylevel|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|snmpv3_authpassphrase|t_varchar(64)|''	|NOT NULL	|ZBX_SYNC
+FIELD		|snmpv3_privpassphrase|t_varchar(64)|''	|NOT NULL	|ZBX_SYNC
+
+FIELD		|formula	|t_varchar(255)	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|error		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+
+FIELD		|lastlogsize	|t_integer	|'0'	|NOT NULL	|0
+FIELD		|logtimefmt	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|templateid	|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|valuemapid	|t_bigint		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|delay_flex	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+UNIQUE		|1		|hostid,key_
+INDEX		|2		|nextcheck
+INDEX		|3		|status
+
+TABLE|media|mediaid|ZBX_SYNC
+FIELD		|mediaid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|mediatypeid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|sendto		|t_varchar(100)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|active		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|severity	|t_integer	|'63'	|NOT NULL	|ZBX_SYNC
+FIELD		|period		|t_varchar(100)	|'1-7,00:00-23:59'|NOT NULL	|ZBX_SYNC
+INDEX		|1		|userid
+INDEX		|2		|mediatypeid
+
+TABLE|media_type|mediatypeid|ZBX_SYNC
+FIELD		|mediatypeid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|description	|t_varchar(100)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|smtp_server	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|smtp_helo	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|smtp_email	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|exec_path	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|gsm_modem	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+
+TABLE|triggers|triggerid|ZBX_SYNC
+FIELD		|triggerid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|expression	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|description	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|priority	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|lastchange	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|dep_level	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|comments	|t_blob		|	|		|ZBX_SYNC
+FIELD		|error		|t_varchar(128)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|templateid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|status
+INDEX		|2		|value
+
+TABLE|trigger_depends|triggerdepid|ZBX_SYNC
+FIELD		|triggerdepid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid_down	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid_up	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|triggerid_down,triggerid_up
+INDEX		|2		|triggerid_up
+
+TABLE|users|userid|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|alias		|t_varchar(100)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(100)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|surname	|t_varchar(100)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|passwd		|t_char(32)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|autologout	|t_integer	|'900'	|NOT NULL	|ZBX_SYNC
+FIELD		|lang		|t_varchar(5)	|'en_gb'|NOT NULL	|ZBX_SYNC
+FIELD		|refresh	|t_integer	|'30'	|NOT NULL	|ZBX_SYNC
+FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|alias
+
+TABLE|auditlog|auditid|0
+FIELD		|auditid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|action		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|resourcetype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|details	|t_varchar(128)	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|userid,clock
+INDEX		|2		|clock
+
+TABLE|sessions|sessionid|0
+FIELD		|sessionid	|t_varchar(32)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|lastaccess	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+
+TABLE|rights|rightid|ZBX_SYNC
+FIELD		|rightid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|groupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|permission	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|id		|t_id		|	|		|ZBX_SYNC
+INDEX		|1		|groupid
+
+TABLE|service_alarms|servicealarmid|0
+FIELD		|servicealarmid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|serviceid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|serviceid,clock
+INDEX		|2		|clock
+
+TABLE|profiles|profileid|ZBX_SYNC
+FIELD		|profileid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|idx		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|valuetype	|t_integer	|0	|NOT NULL	|ZBX_SYNC
+UNIQUE		|1		|userid,idx
+
+TABLE|screens|screenid|ZBX_SYNC
+FIELD		|screenid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(255)	|'Screen'|NOT NULL	|ZBX_SYNC
+FIELD		|hsize		|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
+FIELD		|vsize		|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
+
+TABLE|screens_items|screenitemid|ZBX_SYNC
+FIELD		|screenitemid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|screenid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|resourcetype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|resourceid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|width		|t_integer	|'320'	|NOT NULL	|ZBX_SYNC
+FIELD		|height		|t_integer	|'200'	|NOT NULL	|ZBX_SYNC
+FIELD		|x		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|y		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|colspan	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|rowspan	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|elements	|t_integer	|'25'	|NOT NULL	|ZBX_SYNC
+FIELD		|valign		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|halign		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|style		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+
+TABLE|usrgrp|usrgrpid|ZBX_SYNC
+FIELD		|usrgrpid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|name
+
+TABLE|users_groups|id|ZBX_SYNC
+FIELD		|id		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|usrgrpid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|usrgrpid,userid
+
+TABLE|trends|itemid,clock|0
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|num		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value_min	|t_double(16,4)	|'0.0000'|NOT NULL	|ZBX_SYNC
+FIELD		|value_avg	|t_double(16,4)	|'0.0000'|NOT NULL	|ZBX_SYNC
+FIELD		|value_max	|t_double(16,4)	|'0.0000'|NOT NULL	|ZBX_SYNC
+
+TABLE|images|imageid|ZBX_SYNC
+FIELD		|imageid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|imagetype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(64)	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|image		|t_image	|''	|NOT NULL	|0
+INDEX		|1		|imagetype,name
+
+TABLE|hosts_templates|hosttemplateid|ZBX_SYNC
+FIELD		|hosttemplateid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|templateid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+UNIQUE		|1		|hostid,templateid
+
+TABLE|history_log|id|0
+FIELD		|id		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|timestamp	|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|source		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|severity	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_history_log	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|itemid,clock
+
+TABLE|history_text|id|0
+FIELD		|id		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_history_text	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|itemid,clock
+
+TABLE|hosts_profiles|hostid|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|devicetype	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|os		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|serialno	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|tag		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|macaddress	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|hardware	|t_blob		|''	|NOT NULL	|ZBX_SYNC
+FIELD		|software	|t_blob		|''	|NOT NULL	|ZBX_SYNC
+FIELD		|contact	|t_blob		|''	|NOT NULL	|ZBX_SYNC
+FIELD		|location	|t_blob		|''	|NOT NULL	|ZBX_SYNC
+FIELD		|notes		|t_blob		|''	|NOT NULL	|ZBX_SYNC
+
+TABLE|autoreg|id|ZBX_SYNC
+FIELD		|id		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|priority	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|pattern	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+
+TABLE|valuemaps|valuemapid|ZBX_SYNC
+FIELD		|valuemapid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|name
+
+TABLE|mappings|mappingid|ZBX_SYNC
+FIELD		|mappingid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|valuemapid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|newvalue	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|valuemapid
+
+TABLE|housekeeper|housekeeperid|0
+FIELD		|housekeeperid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|tablename	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|field		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|value		|t_integer		|'0'	|NOT NULL	|ZBX_SYNC
+
+TABLE|acknowledges|acknowledgeid|ZBX_SYNC
+FIELD		|acknowledgeid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|eventid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|message	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|userid
+INDEX		|2		|eventid
+INDEX		|3		|clock
+
+TABLE|applications|applicationid|ZBX_SYNC
+FIELD		|applicationid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|templateid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|templateid
+UNIQUE		|2		|hostid,name
+
+TABLE|items_applications|itemappid|ZBX_SYNC
+FIELD		|itemappid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|applicationid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+INDEX		|1		|applicationid,itemid
+
+TABLE|help_items|itemtype,key_|0
+FIELD		|itemtype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|key_		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
+FIELD		|description	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC