diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-10 09:16:28 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-10 09:16:28 +0100 |
| commit | 9d5482d753d3e1db3e226a054116ff6856a2e769 (patch) | |
| tree | ce922afcbd7094409db8b1ae69606b59f74c5857 | |
| parent | b757248a2922052342fbdb9540eafe50a2497129 (diff) | |
added testdata
| -rw-r--r-- | dbtestdata.sql | 8 |
1 files changed, 8 insertions, 0 deletions
diff --git a/dbtestdata.sql b/dbtestdata.sql index 39256cc..c8553e2 100644 --- a/dbtestdata.sql +++ b/dbtestdata.sql @@ -1,3 +1,11 @@ +--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, time, port, packet_size) VALUES ("123.123.123.123", "12.12.12.12", NOW(), 80, 255); INSERT INTO raw_data (ip_src, ip_dst, time, port, packet_size) VALUES ("45.45.45.45", "12.12.12.12", NOW(), 80, 255); + +--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, 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, time, port, packet_size) VALUES ("8.8.8.8", "11.73.73.73", ('2008-12-01 12:00:00'), 80, 200); +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, time, port, packet_size) VALUES ("100.63.63.63", "8.8.8.8", ('2008-12-01 12:00:00'), 80, 200); |