From 49fd768b0e7018d314eebcb86a67a865ac5e1d9b Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Tue, 17 Mar 2015 14:27:56 +0100 Subject: started to remake testdata --- dbSetup/dbtestdata.sql | 11 ----------- 1 file changed, 11 deletions(-) delete mode 100644 dbSetup/dbtestdata.sql (limited to 'dbSetup/dbtestdata.sql') diff --git a/dbSetup/dbtestdata.sql b/dbSetup/dbtestdata.sql deleted file mode 100644 index 7f877f1..0000000 --- a/dbSetup/dbtestdata.sql +++ /dev/null @@ -1,11 +0,0 @@ --- 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