Added basic support of distributed history (Alexei)

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

1 files changed, 51 insertions, 49 deletions

diff --git a/create/data/nodes.sql b/create/data/nodes.sql
index 4d35fa71..8d48980b 100644
--- a/create/data/nodes.sql
+++ b/create/data/nodes.sql
@@ -1,68 +1,70 @@
 connect node7;
 delete from nodes;
-insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 1, 5);
-insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 5);
-insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 4);
-insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0);
-insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 4);
-insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 3);
-insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 3);
+insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 1, 5);
+insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 0, 5);
+insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 0, 4);
+insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0, 0);
+insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 0, 4);
+insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 0, 3);
+insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 0, 3);
 insert into events values (700000000000001, 700000000000003, 123456789, 0, 0);
 insert into events values (700000000000002, 700000000000012, 123456789, 0, 0);
 insert into events values (700000000000003, 700000000000023, 123456789, 0, 0);
 insert into events values (700000000000004, 700000000000045, 123456789, 0, 0);
 connect node6;
 delete from nodes;
-insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 5);
-insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 1, 5);
-insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 4);
-insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0);
-insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 4);
-insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 3);
-insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 3);
+insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 0, 5);
+insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 1, 5);
+insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 0, 4);
+insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0, 0);
+insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 0, 4);
+insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 0, 3);
+insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 0, 3);
+insert into events values (600000000000001, 600000000000103, 123456789, 1, 0);
 connect node5;
 delete from nodes;
-insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 5);
-insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 5);
-insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 1, 4);
-insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0);
-insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 4);
-insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 3);
-insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 3);
+insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 0, 5);
+insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 0, 5);
+insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 1, 4);
+insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0, 0);
+insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 0, 4);
+insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 0, 3);
+insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 0, 3);
+insert into events values (500000000000001, 500000000000122, 123456789, 1, 0);
 connect node4;
 delete from nodes;
-insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 5);
-insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 5);
-insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 4);
-insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 1, 0);
-insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 4);
-insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 3);
-insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 3);
+insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 0, 5);
+insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 0, 5);
+insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 0, 4);
+insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 1, 0);
+insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 0, 4);
+insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 0, 3);
+insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 0, 3);
 connect node3;
 delete from nodes;
-insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 5);
-insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 5);
-insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 4);
-insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0);
-insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 1, 4);
-insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 3);
-insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 3);
+insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 0, 5);
+insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 0, 5);
+insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 0, 4);
+insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0, 0);
+insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 1, 4);
+insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 0, 3);
+insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 0, 3);
 connect node2;
 delete from nodes;
-insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 5);
-insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 5);
-insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 4);
-insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0);
-insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 4);
-insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 1, 3);
-insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 3);
+insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 0, 5);
+insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 0, 5);
+insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 0, 4);
+insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0, 0);
+insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 0, 4);
+insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 1, 3);
+insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 0, 3);
 connect node1;
 delete from nodes;
-insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 5);
-insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 5);
-insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 4);
-insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0);
-insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 4);
-insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 3);
-insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 1, 3);
+insert into nodes values (7, "Cologne",2, "127.0.0.1", 15057, 30, 365, 0, 0, 0, 5);
+insert into nodes values (6, "Berlin", 2, "127.0.0.1", 15056, 30, 365, 0, 0, 0, 5);
+insert into nodes values (5, "Germany",2, "127.0.0.1", 15055, 30, 365, 0, 0, 0, 4);
+insert into nodes values (4, "Zabbix", 2, "127.0.0.1", 15054, 30, 365, 0, 0, 0, 0);
+insert into nodes values (3, "Latvia", 2, "127.0.0.1", 15053, 30, 365, 0, 0, 0, 4);
+insert into nodes values (2, "Riga",   2, "127.0.0.1", 15052, 30, 365, 0, 0, 0, 3);
+insert into nodes values (1, "Dpils",  2, "127.0.0.1", 15051, 30, 365, 0, 0, 1, 3);
 insert into events values (100000000000001, 100000000000002, 123456789, 0, 0);