From 9d5482d753d3e1db3e226a054116ff6856a2e769 Mon Sep 17 00:00:00 2001
From: Daniel Langesten <daniel.langest@gmail.com>
Date: Tue, 10 Mar 2015 09:16:28 +0100
Subject: added testdata

---
 dbtestdata.sql | 8 ++++++++
 1 file changed, 8 insertions(+)

(limited to 'dbtestdata.sql')

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);
-- 
cgit v1.1

