diff options
-rw-r--r-- | create/data/data.sql | 44 | ||||
-rw-r--r-- | create/schema/schema.sql | 26 |
2 files changed, 33 insertions, 37 deletions
diff --git a/create/data/data.sql b/create/data/data.sql index 6b043562..3179c150 100644 --- a/create/data/data.sql +++ b/create/data/data.sql @@ -69,28 +69,28 @@ INSERT INTO users_groups VALUES (2,8,2); -- Dumping data for table hosts -- -INSERT INTO hosts VALUES (10001,0,'Template_Linux','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10002,0,'Template_Windows','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10003,0,'Template_App_MySQL','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10004,0,'Template_Standalone','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10007,0,'Template_SNMPv2_Device','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10008,0,'Template_FreeBSD','Template_FreeBSD',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10009,0,'Template_OpenBSD','Template_OpenBSD',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10010,0,'Template_Tru64','Template_Tru64',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10011,0,'Template_Netware','Template_Netware',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10012,0,'Template_AIX','Template_AIX',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10013,0,'Template_HPUX','Template_HPUX',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10014,0,'Template_MacOS_X','Template_MacOS_X',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10015,0,'Template_Solaris','Template_Solaris',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10016,0,'Template_SNMPv1_Device','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10017,0,'ZABBIX Server','',1,'127.0.0.1',10050,1,0,'',0,0); -INSERT INTO hosts VALUES (10018,0,'Template_Cisco_PIX_525','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10019,0,'Template_Dell_PowerConnect_6248','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10020,0,'Template_APC_Battery','',0,'0.0.0.0',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10021,0,'Template_HP_InsightManager','',0,'127.0.0.1',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10022,0,'Template_Dell_OpenManage','',0,'0.0.0.0',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10023,0,'Template_Cisco_PIX','',0,'',10050,3,0,'',0,0); -INSERT INTO hosts VALUES (10024,0,'Template_Dell_PowerEdge','',0,'0.0.0.0',10050,3,0,'',0,0); +INSERT INTO hosts VALUES (10001,0,'Template_Linux','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10002,0,'Template_Windows','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10003,0,'Template_App_MySQL','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10004,0,'Template_Standalone','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10007,0,'Template_SNMPv2_Device','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10008,0,'Template_FreeBSD','Template_FreeBSD',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10009,0,'Template_OpenBSD','Template_OpenBSD',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10010,0,'Template_Tru64','Template_Tru64',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10011,0,'Template_Netware','Template_Netware',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10012,0,'Template_AIX','Template_AIX',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10013,0,'Template_HPUX','Template_HPUX',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10014,0,'Template_MacOS_X','Template_MacOS_X',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10015,0,'Template_Solaris','Template_Solaris',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10016,0,'Template_SNMPv1_Device','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10017,0,'ZABBIX Server','',1,'127.0.0.1',10050,1,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10018,0,'Template_Cisco_PIX_525','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10019,0,'Template_Dell_PowerConnect_6248','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10020,0,'Template_APC_Battery','',0,'0.0.0.0',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10021,0,'Template_HP_InsightManager','',0,'127.0.0.1',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10022,0,'Template_Dell_OpenManage','',0,'0.0.0.0',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10023,0,'Template_Cisco_PIX','',0,'',10050,3,0,'',0,0,0,0,0); +INSERT INTO hosts VALUES (10024,0,'Template_Dell_PowerEdge','',0,'0.0.0.0',10050,3,0,'',0,0,0,0,0); -- -- Dumping data for table `hosts_templates` diff --git a/create/schema/schema.sql b/create/schema/schema.sql index c0d06c4d..b310fbae 100644 --- a/create/schema/schema.sql +++ b/create/schema/schema.sql @@ -36,7 +36,7 @@ INDEX |slides_1 |slideshowid TABLE|drules|druleid|ZBX_SYNC FIELD |druleid |t_id |'0' |NOT NULL |0 -FIELD |proxyid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |proxy_hostid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |name |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |iprange |t_varchar(255) |'' |NOT NULL |ZBX_SYNC,ZBX_PROXY FIELD |delay |t_integer |'0' |NOT NULL |ZBX_SYNC,ZBX_PROXY @@ -185,6 +185,7 @@ FIELD |itemid |t_id |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |clock |t_time |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |value |t_double |'0.0000'|NOT NULL |ZBX_HISTORY_SYNC INDEX |1 |nodeid,id +INDEX |2 |clock TABLE|history_uint||0 FIELD |itemid |t_id |'0' |NOT NULL |0 @@ -199,6 +200,7 @@ FIELD |itemid |t_id |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |clock |t_time |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |value |t_bigint |'0' |NOT NULL |ZBX_HISTORY_SYNC INDEX |1 |nodeid,id +INDEX |2 |clock TABLE|history_str||0 FIELD |itemid |t_id |'0' |NOT NULL |0 @@ -213,6 +215,7 @@ FIELD |itemid |t_id |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |clock |t_time |'0' |NOT NULL |ZBX_HISTORY_SYNC FIELD |value |t_varchar(255) |'' |NOT NULL |ZBX_HISTORY_SYNC INDEX |1 |nodeid,id +INDEX |2 |clock TABLE|history_log|id|ZBX_HISTORY FIELD |id |t_id |'0' |NOT NULL |0 @@ -223,6 +226,7 @@ FIELD |source |t_varchar(64) |'' |NOT NULL |0 FIELD |severity |t_integer |'0' |NOT NULL |0 FIELD |value |t_history_log |'' |NOT NULL |0 INDEX |1 |itemid,clock +INDEX |2 |clock TABLE|history_text|id|ZBX_HISTORY FIELD |id |t_id |'0' |NOT NULL |0 @@ -230,6 +234,7 @@ FIELD |itemid |t_id |'0' |NOT NULL |0 FIELD |clock |t_time |'0' |NOT NULL |0 FIELD |value |t_history_text |'' |NOT NULL |0 INDEX |1 |itemid,clock +INDEX |2 |clock TABLE|proxy_dhistory|id|0 FIELD |id |t_serial | |NOT NULL |0 @@ -394,21 +399,9 @@ FIELD |itemtype |t_integer |'0' |NOT NULL |ZBX_SYNC FIELD |key_ |t_varchar(255) |'' |NOT NULL |ZBX_SYNC FIELD |description |t_varchar(255) |'' |NOT NULL |ZBX_SYNC -TABLE|proxies|proxyid|ZBX_SYNC -FIELD |proxyid |t_id |'0' |NOT NULL |0 -FIELD |name |t_varchar(64) |'' |NOT NULL |ZBX_SYNC -FIELD |lastaccess |t_integer |'0' |NOT NULL |ZBX_SYNC -FIELD |history_lastid |t_bigint |'0' |NOT NULL |0 -FIELD |history_uint_lastid|t_bigint |'0' |NOT NULL |0 -FIELD |history_str_lastid|t_bigint |'0' |NOT NULL |0 -FIELD |history_text_lastid|t_bigint |'0' |NOT NULL |0 -FIELD |history_log_lastid|t_bigint |'0' |NOT NULL |0 -FIELD |dhistory_lastid|t_bigint |'0' |NOT NULL |0 -INDEX |1 |name - TABLE|hosts|hostid|ZBX_SYNC FIELD |hostid |t_id |'0' |NOT NULL |0 -FIELD |proxyid |t_id |'0' |NOT NULL |ZBX_SYNC +FIELD |proxy_hostid |t_id |'0' |NOT NULL |ZBX_SYNC FIELD |host |t_varchar(64) |'' |NOT NULL |ZBX_SYNC,ZBX_PROXY FIELD |dns |t_varchar(64) |'' |NOT NULL |ZBX_SYNC,ZBX_PROXY FIELD |useip |t_integer |'1' |NOT NULL |ZBX_SYNC,ZBX_PROXY @@ -419,9 +412,12 @@ 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 +FIELD |lastaccess |t_integer |'0' |NOT NULL |ZBX_SYNC +FIELD |inbytes |t_bigint |'0' |NOT NULL |ZBX_SYNC +FIELD |outbytes |t_bigint |'0' |NOT NULL |ZBX_SYNC INDEX |1 |host INDEX |2 |status -INDEX |3 |proxyid +INDEX |3 |proxy_hostid TABLE|hosts_groups|hostgroupid|ZBX_SYNC FIELD |hostgroupid |t_id |'0' |NOT NULL |0 |