diff options
Diffstat (limited to 'dbSetup/dbTestData.mysql')
| -rw-r--r-- | dbSetup/dbTestData.mysql | 22 |
1 files changed, 11 insertions, 11 deletions
diff --git a/dbSetup/dbTestData.mysql b/dbSetup/dbTestData.mysql index 6ed6f71..9ffde41 100644 --- a/dbSetup/dbTestData.mysql +++ b/dbSetup/dbTestData.mysql @@ -40,28 +40,28 @@ grant all privileges on test.* to flowcleaner@localhost identified by 'nil' with grant all privileges on test.* to pmacct@localhost identified by 'arealsmartpwd' with grant option; -- New data that should not be processed in case there is more that should be aggregated together with it. INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); + VALUES ("123.123.123.124", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); + VALUES ("123.123.123.125", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); + VALUES ("123.123.123.126", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("124.123.123.123", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); + VALUES ("124.123.123.127", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("124.123.123.123", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); + VALUES ("124.123.123.122", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", NOW()); -- Old data that should be processed INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); + VALUES ("123.123.123.122", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); + VALUES ("123.123.123.124", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); + VALUES ("123.123.123.125", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("123.123.123.123", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); + VALUES ("123.123.123.121", "12.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("124.123.123.123", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); + VALUES ("124.123.123.126", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); INSERT INTO test_raw (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) - VALUES ("124.123.123.123", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); + VALUES ("124.123.123.123", "13.12.12.13", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); |