From 0f348ff8d458d0d1c55ec87df6b6ac3bc0f5af5d Mon Sep 17 00:00:00 2001
From: Daniel Langesten <daniel.langest@gmail.com>
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(-)

(limited to 'mysqltest.sql')

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

