diff options
author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 15:43:14 +0100 |
---|---|---|
committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 15:43:14 +0100 |
commit | 8d4ed3d37743bfebb58803ea1b010384f9cf3d7e (patch) | |
tree | 5afee3c8ddf45bcdb8dda6331f3ef3775cc3c12d | |
parent | 1598052fe5d6615245d65a4de911ef4cdfad2123 (diff) |
fixed typeo
-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"); |