diff options
Diffstat (limited to 'mysqltest.sql')
| -rw-r--r-- | mysqltest.sql | 4 |
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 ); |