diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 15:31:31 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-17 15:31:31 +0100 |
| commit | 8423a9ba80ea36300c8659ed44b193a83b936287 (patch) | |
| tree | 5ed9472cfbd9d64a98660601159bf57b35009fc4 | |
| parent | 49fd768b0e7018d314eebcb86a67a865ac5e1d9b (diff) | |
fixed testdata
| -rw-r--r-- | dbSetup/dbTestData.mysql | 26 |
1 files changed, 24 insertions, 2 deletions
diff --git a/dbSetup/dbTestData.mysql b/dbSetup/dbTestData.mysql index ccc6c65..18df0bb 100644 --- a/dbSetup/dbTestData.mysql +++ b/dbSetup/dbTestData.mysql @@ -39,7 +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, time, port, packet_size) VALUES ("123.123.123.123", "12.12.12.12", NOW(), 80, 255); +INSERT INTO raw_data (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) + 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) + 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) + 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) + 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) + 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, time, port, packet_size) VALUES ("63.63.63.63", "73.73.73.73", '2008-12-01 12:00:00', 80, 200); +INSERT INTO raw_data (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) + 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) + 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) + 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) + 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) + VALUES ("124.123.123.123", "13.12.12.12", 123, 321, 80, 80, 3, 300, "0-200", "2008-12-01 12:23:32"); |