From df997f21bffb21274e22aff36883bf7827af278c Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Tue, 10 Mar 2015 10:37:35 +0100 Subject: fixed timezone issues --- dbtestdata.sql | 14 +++++++------- 1 file changed, 7 insertions(+), 7 deletions(-) (limited to 'dbtestdata.sql') diff --git a/dbtestdata.sql b/dbtestdata.sql index c8553e2..7f877f1 100644 --- a/dbtestdata.sql +++ b/dbtestdata.sql @@ -1,11 +1,11 @@ ---New data that should not be processed in case there is more that should be aggregated together with it. +-- 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); +-- 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