diff options
author | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-09-24 15:36:35 +0000 |
---|---|---|
committer | alex <alex@97f52cf1-0a1b-0410-bd0e-c28be96e8082> | 2006-09-24 15:36:35 +0000 |
commit | abafe94bd653f8510dba94760607869ff31b248d (patch) | |
tree | c90de20cdc2ffd1be5c327fdce3ef873a6897d2e /create/data | |
parent | 027a8968f5e0af59673aaa1e72f09c018fd123bb (diff) | |
download | zabbix-abafe94bd653f8510dba94760607869ff31b248d.tar.gz zabbix-abafe94bd653f8510dba94760607869ff31b248d.tar.xz zabbix-abafe94bd653f8510dba94760607869ff31b248d.zip |
Added basic support of distributed history (Alexei)
git-svn-id: svn://svn.zabbix.com/trunk@3322 97f52cf1-0a1b-0410-bd0e-c28be96e8082
Diffstat (limited to 'create/data')
-rw-r--r-- | create/data/data.sql | 4 | ||||
-rw-r--r-- | create/data/nodes.sql | 100 |
2 files changed, 53 insertions, 51 deletions
diff --git a/create/data/data.sql b/create/data/data.sql index 205636d5..50a7e1ef 100644 --- a/create/data/data.sql +++ b/create/data/data.sql @@ -60,8 +60,8 @@ INSERT INTO rights VALUES (3,2,'Default permission','R',0); -- Dumping data for table `hosts` -- -INSERT INTO hosts VALUES (10001,'Unix_t',0,'',10000,3,0,'',0,0,0); ---INSERT INTO hosts VALUES (10001,'Unix_t',1,'127.0.0.1',10050,0,0,'',0,0,0); +--INSERT INTO hosts VALUES (10001,'Unix_t',0,'',10000,3,0,'',0,0,0); +INSERT INTO hosts VALUES (10001,'Unix_t',1,'127.0.0.1',10050,0,0,'',0,0,0); INSERT INTO hosts VALUES (10002,'Windows_t',0,'',10000,3,0,'',0,0,0); INSERT INTO hosts VALUES (10004,'Standalone_t',0,'',10000,3,0,'',0,0,0); INSERT INTO hosts VALUES (10003,'MySQL_t',0,'',10000,3,0,'',0,0,0); 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); |