- [ZBX-102] Distributed monitoring: overwriting information (Sasha)

   [svn merge -r4918:4921 svn://svn.zabbix.com/branches/1.4.j]


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

1 files changed, 61 insertions, 63 deletions

diff --git a/create/schema/schema.sql b/create/schema/schema.sql
index fc7bfae6..82fb2d44 100644
--- a/create/schema/schema.sql
+++ b/create/schema/schema.sql
@@ -22,12 +22,12 @@
 --
 
 TABLE|slideshows|slideshowid|ZBX_SYNC
-FIELD		|slideshowid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|slideshowid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|delay		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 
 TABLE|slides|slideid|ZBX_SYNC
-FIELD		|slideid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|slideid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|slideshowid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|screenid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|step		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
@@ -35,7 +35,7 @@ FIELD		|delay		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 INDEX		|slides_1	|slideshowid
 
 TABLE|drules|druleid|ZBX_SYNC
-FIELD		|druleid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|druleid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|iprange	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|delay		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
@@ -43,7 +43,7 @@ FIELD		|nextcheck	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 
 TABLE|dchecks|dcheckid|ZBX_SYNC
-FIELD		|dcheckid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|dcheckid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|druleid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|key_		|t_varchar(255)	|'0'	|NOT NULL	|ZBX_SYNC
@@ -51,7 +51,7 @@ FIELD		|snmp_community	|t_varchar(255)	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|ports		|t_varchar(255)	|'0'	|NOT NULL	|ZBX_SYNC
 
 TABLE|dhosts|dhostid|ZBX_SYNC
-FIELD		|dhostid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|dhostid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|druleid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|ip		|t_varchar(39)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
@@ -59,7 +59,7 @@ FIELD		|lastup		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|lastdown	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 
 TABLE|dservices|dserviceid|ZBX_SYNC
-FIELD		|dserviceid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|dserviceid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|dhostid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|key_		|t_varchar(255)	|'0'	|NOT NULL	|ZBX_SYNC
@@ -76,7 +76,7 @@ FIELD		|field_name	|t_varchar(64)	|''	|NOT NULL	|0
 FIELD		|nextid		|t_id		|'0'	|NOT NULL	|0
 
 TABLE|httptest|httptestid|ZBX_SYNC
-FIELD		|httptestid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|httptestid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|applicationid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|lastcheck	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
@@ -92,7 +92,7 @@ FIELD		|time		|t_double	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|error		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 
 TABLE|httpstep|httpstepid|ZBX_SYNC
-FIELD		|httpstepid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|httpstepid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|httptestid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|no		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
@@ -104,14 +104,14 @@ FIELD		|status_codes	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 INDEX		|httpstep_1	|httptestid
 
 TABLE|httpstepitem|httpstepitemid|ZBX_SYNC
-FIELD		|httpstepitemid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|httpstepitemid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|httpstepid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 UNIQUE		|httpstepitem_1	|httpstepid,itemid
 
 TABLE|httptestitem|httptestitemid|ZBX_SYNC
-FIELD		|httptestitemid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|httptestitemid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|httptestid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
@@ -131,7 +131,7 @@ FIELD		|nodetype	|t_integer	|'0'	|NOT NULL	|0
 FIELD		|masterid	|t_integer	|'0'	|NOT NULL	|0
 
 TABLE|node_cksum||0
-FIELD		|nodeid		|t_id		|'0'	|NOT NULL	|0
+FIELD		|nodeid		|t_integer	|'0'	|NOT NULL	|0
 FIELD		|tablename	|t_varchar(64)	|''	|NOT NULL	|0
 FIELD		|recordid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|cksumtype	|t_integer	|'0'	|NOT NULL	|0
@@ -164,7 +164,7 @@ FIELD		|value		|t_bigint	|'0'	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|nodeid,id
 
 TABLE|services_times|timeid|ZBX_SYNC
-FIELD		|timeid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|timeid		|t_id		|'0'	|NOT NULL	|0
 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
@@ -175,7 +175,7 @@ INDEX		|times_1	|serviceid,type,ts_from,ts_to
 -- History tables
 
 TABLE|alerts|alertid|ZBX_SYNC
-FIELD		|alertid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|alertid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -252,7 +252,7 @@ FIELD		|value_max	|t_double	|'0.0000'|NOT NULL	|ZBX_SYNC
 -- Other tables
 
 TABLE|acknowledges|acknowledgeid|ZBX_SYNC
-FIELD		|acknowledgeid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|acknowledgeid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -262,14 +262,14 @@ INDEX		|2		|eventid
 INDEX		|3		|clock
 
 TABLE|actions|actionid|ZBX_SYNC
-FIELD		|actionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|actionid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|eventsource	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|evaltype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|status		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 
 TABLE|operations|operationid|ZBX_SYNC
-FIELD		|operationid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|operationid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|actionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|operationtype	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|object		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
@@ -279,7 +279,7 @@ FIELD		|longdata	|t_blob		|''	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|actionid
 
 TABLE|applications|applicationid|ZBX_SYNC
-FIELD		|applicationid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|applicationid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -297,7 +297,7 @@ INDEX		|1		|userid,clock
 INDEX		|2		|clock
 
 TABLE|conditions|conditionid|ZBX_SYNC
-FIELD		|conditionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|conditionid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -305,7 +305,7 @@ FIELD		|value		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|actionid
 
 TABLE|config|configid|ZBX_SYNC
-FIELD		|configid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|configid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -315,7 +315,7 @@ FIELD		|ack_enable	|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
 FIELD		|ack_expire	|t_integer	|'7'	|NOT NULL	|ZBX_SYNC
 
 TABLE|functions|functionid|ZBX_SYNC
-FIELD		|functionid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|functionid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|triggerid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|lastvalue	|t_varchar(255)	|	|		|0
@@ -325,7 +325,7 @@ INDEX		|1		|triggerid
 INDEX		|2		|itemid,function,parameter
 
 TABLE|graphs|graphid|ZBX_SYNC
-FIELD		|graphid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|graphid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -341,7 +341,7 @@ FIELD		|show_3d	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 INDEX		|graphs_1	|name
 
 TABLE|graphs_items|gitemid|ZBX_SYNC
-FIELD		|gitemid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|gitemid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -353,7 +353,7 @@ FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|periods_cnt	|t_integer	|'5'	|NOT NULL	|ZBX_SYNC
 
 TABLE|groups|groupid|ZBX_SYNC
-FIELD		|groupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|groupid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|name
 
@@ -363,7 +363,7 @@ FIELD		|key_		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|description	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 
 TABLE|hosts|hostid|ZBX_SYNC
-FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|0
 FIELD		|host		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|dns		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|useip		|t_integer	|'1'	|NOT NULL	|ZBX_SYNC
@@ -378,13 +378,13 @@ INDEX		|1		|host
 INDEX		|2		|status
 
 TABLE|hosts_groups|hostgroupid|ZBX_SYNC
-FIELD		|hostgroupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|hostgroupid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|groupid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 INDEX		|groups_1	|hostid,groupid
 
 TABLE|hosts_profiles|hostid|ZBX_SYNC
-FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|hostid		|t_id		|'0'	|NOT NULL	|0
 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
@@ -398,26 +398,26 @@ FIELD		|location	|t_blob		|''	|NOT NULL	|ZBX_SYNC
 FIELD		|notes		|t_blob		|''	|NOT NULL	|ZBX_SYNC
 
 TABLE|hosts_templates|hosttemplateid|ZBX_SYNC
-FIELD		|hosttemplateid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|hosttemplateid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|hostid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|templateid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 UNIQUE		|1		|hostid,templateid
 
 TABLE|housekeeper|housekeeperid|0
-FIELD		|housekeeperid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|housekeeperid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|tablename	|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|field		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|value		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 
 TABLE|images|imageid|ZBX_SYNC
-FIELD		|imageid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|imageid	|t_id		|'0'	|NOT NULL	|0
 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	|ZBX_SYNC
 INDEX		|1		|imagetype,name
 
 TABLE|items|itemid|ZBX_SYNC
-FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemid		|t_id		|'0'	|NOT NULL	|0
 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
@@ -443,10 +443,8 @@ 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)	|'1'	|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_id		|'0'	|NOT NULL	|ZBX_SYNC
@@ -458,21 +456,21 @@ INDEX		|2		|nextcheck
 INDEX		|3		|status
 
 TABLE|items_applications|itemappid|ZBX_SYNC
-FIELD		|itemappid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|itemappid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|applicationid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|itemid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|applicationid,itemid
 INDEX		|2		|itemid
 
 TABLE|mappings|mappingid|ZBX_SYNC
-FIELD		|mappingid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|mappingid	|t_id		|'0'	|NOT NULL	|0
 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|media|mediaid|ZBX_SYNC
-FIELD		|mediaid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|mediaid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -483,7 +481,7 @@ INDEX		|1		|userid
 INDEX		|2		|mediatypeid
 
 TABLE|media_type|mediatypeid|ZBX_SYNC
-FIELD		|mediatypeid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|mediatypeid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -495,7 +493,7 @@ FIELD		|username	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|passwd		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 
 TABLE|profiles|profileid|ZBX_SYNC
-FIELD		|profileid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|profileid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -503,7 +501,7 @@ FIELD		|valuetype	|t_integer	|0	|NOT NULL	|ZBX_SYNC
 UNIQUE		|1		|userid,idx
 
 TABLE|rights|rightid|ZBX_SYNC
-FIELD		|rightid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|rightid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -511,19 +509,19 @@ FIELD		|id		|t_id		|	|		|ZBX_SYNC
 INDEX		|1		|groupid
 
 TABLE|scripts|scriptid|ZBX_SYNC
-FIELD		|scriptid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|scriptid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|name		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|command	|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 FIELD		|host_access	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 
 TABLE|screens|screenid|ZBX_SYNC
-FIELD		|screenid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|screenid	|t_id		|'0'	|NOT NULL	|0
 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		|screenitemid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -540,7 +538,7 @@ FIELD		|style		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|url		|t_varchar(255)	|''	|NOT NULL	|ZBX_SYNC
 
 TABLE|services|serviceid|ZBX_SYNC
-FIELD		|serviceid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|serviceid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -550,15 +548,15 @@ FIELD		|goodsla	|t_percentage	|'99.9'	|NOT NULL	|ZBX_SYNC
 FIELD		|sortorder	|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 
 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
+FIELD		|servicealarmid	|t_id		|'0'	|NOT NULL	|0
+FIELD		|serviceid	|t_id		|'0'	|NOT NULL	|0
+FIELD		|clock		|t_time		|'0'	|NOT NULL	|0
+FIELD		|value		|t_integer	|'0'	|NOT NULL	|0
 INDEX		|1		|serviceid,clock
 INDEX		|2		|clock
 
 TABLE|services_links|linkid|ZBX_SYNC
-FIELD		|linkid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|linkid		|t_id		|'0'	|NOT NULL	|0
 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
@@ -566,12 +564,12 @@ INDEX		|links_1	|servicedownid
 UNIQUE		|links_2	|serviceupid,servicedownid
 
 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
+FIELD		|sessionid	|t_varchar(32)	|''	|NOT NULL	|0
+FIELD		|userid		|t_id		|'0'	|NOT NULL	|0
+FIELD		|lastaccess	|t_integer	|'0'	|NOT NULL	|0
 
 TABLE|sysmaps_links|linkid|ZBX_SYNC
-FIELD		|linkid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|linkid		|t_id		|'0'	|NOT NULL	|0
 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
@@ -582,13 +580,13 @@ 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		|selementid	|t_id		|'0'	|NOT NULL	|0
 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		|iconid_unknown	|t_bigint		|'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		|iconid_unknown	|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
@@ -596,18 +594,18 @@ 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		|sysmapid	|t_id		|'0'	|NOT NULL	|0
 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		|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|triggers|triggerid|ZBX_SYNC
-FIELD		|triggerid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerid	|t_id		|'0'	|NOT NULL	|0
 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
@@ -624,14 +622,14 @@ INDEX		|1		|status
 INDEX		|2		|value
 
 TABLE|trigger_depends|triggerdepid|ZBX_SYNC
-FIELD		|triggerdepid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|triggerdepid	|t_id		|'0'	|NOT NULL	|0
 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		|userid		|t_id		|'0'	|NOT NULL	|0
 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
@@ -644,18 +642,18 @@ FIELD		|type		|t_integer	|'0'	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|alias
 
 TABLE|usrgrp|usrgrpid|ZBX_SYNC
-FIELD		|usrgrpid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|usrgrpid	|t_id		|'0'	|NOT NULL	|0
 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		|id		|t_id		|'0'	|NOT NULL	|0
 FIELD		|usrgrpid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 FIELD		|userid		|t_id		|'0'	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|usrgrpid,userid
 
 TABLE|valuemaps|valuemapid|ZBX_SYNC
-FIELD		|valuemapid	|t_id		|'0'	|NOT NULL	|ZBX_SYNC
+FIELD		|valuemapid	|t_id		|'0'	|NOT NULL	|0
 FIELD		|name		|t_varchar(64)	|''	|NOT NULL	|ZBX_SYNC
 INDEX		|1		|name