diff options
| -rw-r--r-- | dbSetup/dbTestData.mysql | 24 |
1 files changed, 12 insertions, 12 deletions
diff --git a/dbSetup/dbTestData.mysql b/dbSetup/dbTestData.mysql index 18df0bb..6ed6f71 100644 --- a/dbSetup/dbTestData.mysql +++ b/dbSetup/dbTestData.mysql @@ -39,29 +39,29 @@ CREATE TABLE test_clean ( grant all privileges on test.* to flowcleaner@localhost identified by 'nil' with grant option; 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 raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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 raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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 raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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 raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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 raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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()); -INSERT INTO raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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()); -- Old data that should be processed -INSERT INTO raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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"); -INSERT INTO raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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"); -INSERT INTO raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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"); -INSERT INTO raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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"); -INSERT INTO raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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"); -INSERT INTO raw_data (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, packets, bytes, pkt_len_distrib, stamp_inserted) +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"); |