diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-02-27 14:59:06 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-02-27 14:59:06 +0100 |
| commit | 0f348ff8d458d0d1c55ec87df6b6ac3bc0f5af5d (patch) | |
| tree | 4035594b0795544125a54924b29c08a20348fd32 | |
| parent | 9fe8a6e44cc53c2b96db45c8e605d9b7820252f8 (diff) | |
renamed volume to packet_size to be able to tell the difference of cleaned vs raw data
| -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 ); |