diff options
Diffstat (limited to 'create/data/nodes.sql')
-rw-r--r-- | create/data/nodes.sql | 100 |
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); |