summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--mysqltest.sql4
1 files 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
);