From 0f348ff8d458d0d1c55ec87df6b6ac3bc0f5af5d Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Fri, 27 Feb 2015 14:59:06 +0100 Subject: renamed volume to packet_size to be able to tell the difference of cleaned vs raw data --- mysqltest.sql | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/mysqltest.sql b/mysqltest.sql index 6d4d072..aad5b9a 100644 --- a/mysqltest.sql +++ b/mysqltest.sql @@ -14,7 +14,7 @@ CREATE TABLE clean_data ( port INT, volume CHAR(10), occurences INT, - UNIQUE idx (ipb_src, ipb_dst, time, port, volume) + UNIQUE idx (ipb_src, ipb_dst, time, port, packet_size) ); DROP TABLE IF EXISTS raw_data; @@ -24,5 +24,5 @@ CREATE TABLE raw_data ( ip_dst CHAR(15), time DATETIME, port INT, - volume INT + packet_size INT ); -- cgit v1.1