Improvements of default templates.

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

1 files changed, 300 insertions, 0 deletions

diff --git a/create/data/data.sql b/create/data/data.sql
index 18490be6..b872849d 100644
--- a/create/data/data.sql
+++ b/create/data/data.sql
@@ -69,6 +69,82 @@ INSERT INTO hosts VALUES (10003,'MySQL_t','MySQL_t',0,'',10050,3,0,'',0,0);
 INSERT INTO hosts VALUES (10007,'SNMP_t','SNMP_t',0,'',161,3,0,'',0,0);
 
 --
+-- Dumping data for table `applications`
+--
+
+INSERT INTO applications VALUES (1,10001,'OS',0);
+INSERT INTO applications VALUES (2,10001,'Services',0);
+INSERT INTO applications VALUES (3,10008,'OS',1);
+INSERT INTO applications VALUES (4,10008,'Services',2);
+INSERT INTO applications VALUES (5,10001,'Filesystem',0);
+INSERT INTO applications VALUES (6,10008,'Filesystem',5);
+INSERT INTO applications VALUES (7,10001,'Network',0);
+INSERT INTO applications VALUES (8,10008,'Network',7);
+INSERT INTO applications VALUES (9,10001,'Processes',0);
+INSERT INTO applications VALUES (10,10008,'Processes',9);
+INSERT INTO applications VALUES (11,10001,'Log files',0);
+INSERT INTO applications VALUES (12,10008,'Log files',11);
+INSERT INTO applications VALUES (13,10001,'CPU',0);
+INSERT INTO applications VALUES (14,10008,'CPU',13);
+INSERT INTO applications VALUES (15,10001,'Memory',0);
+INSERT INTO applications VALUES (16,10008,'Memory',15);
+INSERT INTO applications VALUES (17,10001,'Performance',0);
+INSERT INTO applications VALUES (18,10008,'Performance',17);
+INSERT INTO applications VALUES (19,10001,'Availability',0);
+INSERT INTO applications VALUES (20,10008,'Availability',19);
+INSERT INTO applications VALUES (21,10001,'General',0);
+INSERT INTO applications VALUES (22,10008,'General',21);
+INSERT INTO applications VALUES (23,10001,'Integrity',0);
+INSERT INTO applications VALUES (24,10008,'Integrity',23);
+INSERT INTO applications VALUES (25,10002,'Availability',0);
+INSERT INTO applications VALUES (26,10010,'Availability',25);
+INSERT INTO applications VALUES (27,10002,'CPU',0);
+INSERT INTO applications VALUES (28,10010,'CPU',27);
+INSERT INTO applications VALUES (29,10002,'Filesystem',0);
+INSERT INTO applications VALUES (30,10010,'Filesystem',29);
+INSERT INTO applications VALUES (31,10002,'General',0);
+INSERT INTO applications VALUES (32,10010,'General',31);
+INSERT INTO applications VALUES (33,10002,'Integrity',0);
+INSERT INTO applications VALUES (34,10010,'Integrity',33);
+INSERT INTO applications VALUES (35,10002,'Memory',0);
+INSERT INTO applications VALUES (36,10010,'Memory',35);
+INSERT INTO applications VALUES (37,10002,'Network',0);
+INSERT INTO applications VALUES (38,10010,'Network',37);
+INSERT INTO applications VALUES (39,10002,'OS',0);
+INSERT INTO applications VALUES (40,10010,'OS',39);
+INSERT INTO applications VALUES (41,10002,'Performance',0);
+INSERT INTO applications VALUES (42,10010,'Performance',41);
+INSERT INTO applications VALUES (43,10002,'Processes',0);
+INSERT INTO applications VALUES (44,10010,'Processes',43);
+INSERT INTO applications VALUES (45,10002,'Services',0);
+INSERT INTO applications VALUES (46,10010,'Services',45);
+
+--
+-- Dumping data for table `mappings`
+--
+
+INSERT INTO mappings VALUES (2,1,'1','Up');
+INSERT INTO mappings VALUES (1,1,'0','Down');
+INSERT INTO mappings VALUES (3,2,'0','Up');
+INSERT INTO mappings VALUES (4,2,'2','Unreachable');
+INSERT INTO mappings VALUES (5,3,'0','Running');
+INSERT INTO mappings VALUES (6,3,'1','Paused');
+INSERT INTO mappings VALUES (7,3,'3','Pause pending');
+INSERT INTO mappings VALUES (8,3,'4','Continue pending');
+INSERT INTO mappings VALUES (9,3,'5','Stop pending');
+INSERT INTO mappings VALUES (10,3,'6','Stopped');
+INSERT INTO mappings VALUES (11,3,'7','Unknown');
+INSERT INTO mappings VALUES (12,3,'255','No such service');
+
+--
+-- Dumping data for table `valuemaps`
+--
+
+INSERT INTO valuemaps VALUES (1,'Service state');
+INSERT INTO valuemaps VALUES (2,'Host status');
+INSERT INTO valuemaps VALUES (3,'Windows service state');
+
+--
 -- Dumping data for table `groups`
 --
 
@@ -1067,3 +1143,227 @@ INSERT INTO functions VALUES (11205,17205,12205,NULL,'delta','0');
 INSERT INTO functions VALUES (11206,17206,12206,NULL,'delta','0');
 INSERT INTO functions VALUES (11207,17207,12207,NULL,'delta','0');
 INSERT INTO functions VALUES (11208,17208,12208,NULL,'delta','0');
+
+--
+-- Dumping data for table `items_applications`
+--
+
+INSERT INTO items_applications VALUES (816,29,10156);
+INSERT INTO items_applications VALUES (815,25,10156);
+INSERT INTO items_applications VALUES (716,2,10031);
+INSERT INTO items_applications VALUES (730,2,10060);
+INSERT INTO items_applications VALUES (726,2,10033);
+INSERT INTO items_applications VALUES (724,2,10036);
+INSERT INTO items_applications VALUES (722,2,10046);
+INSERT INTO items_applications VALUES (720,2,10037);
+INSERT INTO items_applications VALUES (784,5,10414);
+INSERT INTO items_applications VALUES (780,5,10416);
+INSERT INTO items_applications VALUES (776,5,10415);
+INSERT INTO items_applications VALUES (772,5,10413);
+INSERT INTO items_applications VALUES (768,5,10417);
+INSERT INTO items_applications VALUES (764,5,10412);
+INSERT INTO items_applications VALUES (271,19,10005);
+INSERT INTO items_applications VALUES (275,19,10022);
+INSERT INTO items_applications VALUES (279,19,10006);
+INSERT INTO items_applications VALUES (283,19,10007);
+INSERT INTO items_applications VALUES (287,19,10008);
+INSERT INTO items_applications VALUES (602,19,10030);
+INSERT INTO items_applications VALUES (604,19,10014);
+INSERT INTO items_applications VALUES (874,41,17401);
+INSERT INTO items_applications VALUES (650,15,10028);
+INSERT INTO items_applications VALUES (231,19,10029);
+INSERT INTO items_applications VALUES (873,39,17401);
+INSERT INTO items_applications VALUES (872,29,17401);
+INSERT INTO items_applications VALUES (870,39,17399);
+INSERT INTO items_applications VALUES (869,43,17397);
+INSERT INTO items_applications VALUES (866,43,10137);
+INSERT INTO items_applications VALUES (864,43,10102);
+INSERT INTO items_applications VALUES (235,19,10001);
+INSERT INTO items_applications VALUES (443,21,10058);
+INSERT INTO items_applications VALUES (447,21,10057);
+INSERT INTO items_applications VALUES (646,1,17318);
+INSERT INTO items_applications VALUES (734,1,10061);
+INSERT INTO items_applications VALUES (694,1,10025);
+INSERT INTO items_applications VALUES (608,17,10075);
+INSERT INTO items_applications VALUES (862,33,10104);
+INSERT INTO items_applications VALUES (860,33,10357);
+INSERT INTO items_applications VALUES (858,33,10106);
+INSERT INTO items_applications VALUES (856,21,10148);
+INSERT INTO items_applications VALUES (854,21,10109);
+INSERT INTO items_applications VALUES (852,43,10098);
+INSERT INTO items_applications VALUES (628,17,10078);
+INSERT INTO items_applications VALUES (850,25,10119);
+INSERT INTO items_applications VALUES (848,25,10103);
+INSERT INTO items_applications VALUES (846,31,10114);
+INSERT INTO items_applications VALUES (844,31,10150);
+INSERT INTO items_applications VALUES (612,17,10072);
+INSERT INTO items_applications VALUES (842,31,10147);
+INSERT INTO items_applications VALUES (840,35,10115);
+INSERT INTO items_applications VALUES (634,1,10056);
+INSERT INTO items_applications VALUES (636,1,10055);
+INSERT INTO items_applications VALUES (812,29,10358);
+INSERT INTO items_applications VALUES (811,25,10358);
+INSERT INTO items_applications VALUES (808,29,10091);
+INSERT INTO items_applications VALUES (807,25,10091);
+INSERT INTO items_applications VALUES (600,9,10009);
+INSERT INTO items_applications VALUES (836,35,10090);
+INSERT INTO items_applications VALUES (835,25,10090);
+INSERT INTO items_applications VALUES (832,41,10100);
+INSERT INTO items_applications VALUES (831,27,10100);
+INSERT INTO items_applications VALUES (828,41,10101);
+INSERT INTO items_applications VALUES (827,27,10101);
+INSERT INTO items_applications VALUES (804,9,10013);
+INSERT INTO items_applications VALUES (790,9,10052);
+INSERT INTO items_applications VALUES (792,9,10053);
+INSERT INTO items_applications VALUES (794,9,10048);
+INSERT INTO items_applications VALUES (796,9,10047);
+INSERT INTO items_applications VALUES (798,9,10049);
+INSERT INTO items_applications VALUES (800,9,10051);
+INSERT INTO items_applications VALUES (802,9,10050);
+INSERT INTO items_applications VALUES (138,1,10016);
+INSERT INTO items_applications VALUES (824,41,10099);
+INSERT INTO items_applications VALUES (823,27,10099);
+INSERT INTO items_applications VALUES (820,29,10359);
+INSERT INTO items_applications VALUES (819,25,10359);
+INSERT INTO items_applications VALUES (786,5,17373);
+INSERT INTO items_applications VALUES (785,19,17373);
+INSERT INTO items_applications VALUES (684,17,17362);
+INSERT INTO items_applications VALUES (620,17,10084);
+INSERT INTO items_applications VALUES (680,17,17360);
+INSERT INTO items_applications VALUES (676,17,17358);
+INSERT INTO items_applications VALUES (672,17,17356);
+INSERT INTO items_applications VALUES (632,17,10087);
+INSERT INTO items_applications VALUES (624,17,10081);
+INSERT INTO items_applications VALUES (690,17,17354);
+INSERT INTO items_applications VALUES (642,1,17352);
+INSERT INTO items_applications VALUES (736,21,10020);
+INSERT INTO items_applications VALUES (588,17,10010);
+INSERT INTO items_applications VALUES (592,17,10012);
+INSERT INTO items_applications VALUES (596,17,10011);
+INSERT INTO items_applications VALUES (239,19,10027);
+INSERT INTO items_applications VALUES (178,11,10015);
+INSERT INTO items_applications VALUES (718,2,10032);
+INSERT INTO items_applications VALUES (182,1,10419);
+INSERT INTO items_applications VALUES (184,1,10420);
+INSERT INTO items_applications VALUES (186,1,10418);
+INSERT INTO items_applications VALUES (698,5,10067);
+INSERT INTO items_applications VALUES (702,5,10071);
+INSERT INTO items_applications VALUES (706,5,10068);
+INSERT INTO items_applications VALUES (710,5,10069);
+INSERT INTO items_applications VALUES (714,5,10070);
+INSERT INTO items_applications VALUES (311,19,10062);
+INSERT INTO items_applications VALUES (315,19,10066);
+INSERT INTO items_applications VALUES (319,19,10063);
+INSERT INTO items_applications VALUES (323,19,10064);
+INSERT INTO items_applications VALUES (327,19,10065);
+INSERT INTO items_applications VALUES (760,5,10023);
+INSERT INTO items_applications VALUES (756,5,10004);
+INSERT INTO items_applications VALUES (752,5,10003);
+INSERT INTO items_applications VALUES (748,5,10024);
+INSERT INTO items_applications VALUES (744,5,10021);
+INSERT INTO items_applications VALUES (740,5,10002);
+INSERT INTO items_applications VALUES (220,9,10059);
+INSERT INTO items_applications VALUES (243,19,10026);
+INSERT INTO items_applications VALUES (649,19,10028);
+INSERT INTO items_applications VALUES (232,15,10029);
+INSERT INTO items_applications VALUES (236,15,10001);
+INSERT INTO items_applications VALUES (240,15,10027);
+INSERT INTO items_applications VALUES (244,15,10026);
+INSERT INTO items_applications VALUES (783,19,10414);
+INSERT INTO items_applications VALUES (779,19,10416);
+INSERT INTO items_applications VALUES (775,19,10415);
+INSERT INTO items_applications VALUES (771,19,10413);
+INSERT INTO items_applications VALUES (767,19,10417);
+INSERT INTO items_applications VALUES (763,19,10412);
+INSERT INTO items_applications VALUES (272,5,10005);
+INSERT INTO items_applications VALUES (276,5,10022);
+INSERT INTO items_applications VALUES (280,5,10006);
+INSERT INTO items_applications VALUES (284,5,10007);
+INSERT INTO items_applications VALUES (288,5,10008);
+INSERT INTO items_applications VALUES (697,19,10067);
+INSERT INTO items_applications VALUES (701,19,10071);
+INSERT INTO items_applications VALUES (705,19,10068);
+INSERT INTO items_applications VALUES (709,19,10069);
+INSERT INTO items_applications VALUES (713,19,10070);
+INSERT INTO items_applications VALUES (312,5,10062);
+INSERT INTO items_applications VALUES (316,5,10066);
+INSERT INTO items_applications VALUES (320,5,10063);
+INSERT INTO items_applications VALUES (324,5,10064);
+INSERT INTO items_applications VALUES (328,5,10065);
+INSERT INTO items_applications VALUES (759,19,10023);
+INSERT INTO items_applications VALUES (755,19,10004);
+INSERT INTO items_applications VALUES (751,19,10003);
+INSERT INTO items_applications VALUES (747,19,10024);
+INSERT INTO items_applications VALUES (743,19,10021);
+INSERT INTO items_applications VALUES (739,19,10002);
+INSERT INTO items_applications VALUES (607,7,10075);
+INSERT INTO items_applications VALUES (627,7,10078);
+INSERT INTO items_applications VALUES (611,7,10072);
+INSERT INTO items_applications VALUES (839,25,10115);
+INSERT INTO items_applications VALUES (683,13,17362);
+INSERT INTO items_applications VALUES (619,7,10084);
+INSERT INTO items_applications VALUES (679,13,17360);
+INSERT INTO items_applications VALUES (675,13,17358);
+INSERT INTO items_applications VALUES (631,7,10087);
+INSERT INTO items_applications VALUES (671,13,17356);
+INSERT INTO items_applications VALUES (689,13,17354);
+INSERT INTO items_applications VALUES (623,7,10081);
+INSERT INTO items_applications VALUES (641,21,17352);
+INSERT INTO items_applications VALUES (587,13,10010);
+INSERT INTO items_applications VALUES (591,13,10012);
+INSERT INTO items_applications VALUES (595,13,10011);
+INSERT INTO items_applications VALUES (645,21,17318);
+INSERT INTO items_applications VALUES (444,1,10058);
+INSERT INTO items_applications VALUES (448,1,10057);
+INSERT INTO items_applications VALUES (733,21,10061);
+INSERT INTO items_applications VALUES (693,21,10025);
+INSERT INTO items_applications VALUES (652,23,10017);
+INSERT INTO items_applications VALUES (654,23,10019);
+INSERT INTO items_applications VALUES (656,23,10040);
+INSERT INTO items_applications VALUES (658,23,10039);
+INSERT INTO items_applications VALUES (662,23,10038);
+INSERT INTO items_applications VALUES (660,23,10018);
+INSERT INTO items_applications VALUES (512,5,17320);
+INSERT INTO items_applications VALUES (511,19,17320);
+INSERT INTO items_applications VALUES (513,19,17322);
+INSERT INTO items_applications VALUES (514,5,17322);
+INSERT INTO items_applications VALUES (517,19,17324);
+INSERT INTO items_applications VALUES (518,5,17324);
+INSERT INTO items_applications VALUES (521,19,17326);
+INSERT INTO items_applications VALUES (522,5,17326);
+INSERT INTO items_applications VALUES (525,19,17328);
+INSERT INTO items_applications VALUES (526,5,17328);
+INSERT INTO items_applications VALUES (529,19,17330);
+INSERT INTO items_applications VALUES (530,5,17330);
+INSERT INTO items_applications VALUES (533,19,17332);
+INSERT INTO items_applications VALUES (534,5,17332);
+INSERT INTO items_applications VALUES (537,19,17334);
+INSERT INTO items_applications VALUES (538,5,17334);
+INSERT INTO items_applications VALUES (541,19,17336);
+INSERT INTO items_applications VALUES (542,5,17336);
+INSERT INTO items_applications VALUES (545,19,17338);
+INSERT INTO items_applications VALUES (546,5,17338);
+INSERT INTO items_applications VALUES (549,19,17340);
+INSERT INTO items_applications VALUES (550,5,17340);
+INSERT INTO items_applications VALUES (553,19,17342);
+INSERT INTO items_applications VALUES (554,5,17342);
+INSERT INTO items_applications VALUES (557,19,17344);
+INSERT INTO items_applications VALUES (558,5,17344);
+INSERT INTO items_applications VALUES (561,19,17346);
+INSERT INTO items_applications VALUES (562,5,17346);
+INSERT INTO items_applications VALUES (565,19,17348);
+INSERT INTO items_applications VALUES (566,5,17348);
+INSERT INTO items_applications VALUES (569,19,17350);
+INSERT INTO items_applications VALUES (570,5,17350);
+INSERT INTO items_applications VALUES (878,29,17403);
+INSERT INTO items_applications VALUES (879,39,17403);
+INSERT INTO items_applications VALUES (880,41,17403);
+INSERT INTO items_applications VALUES (892,41,17405);
+INSERT INTO items_applications VALUES (891,37,17405);
+INSERT INTO items_applications VALUES (890,29,17405);
+INSERT INTO items_applications VALUES (899,29,17409);
+INSERT INTO items_applications VALUES (900,37,17409);
+INSERT INTO items_applications VALUES (901,41,17409);
+INSERT INTO items_applications VALUES (905,29,17411);
+INSERT INTO items_applications VALUES (906,37,17411);
+INSERT INTO items_applications VALUES (907,41,17411);