diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-02 11:48:59 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-02 11:48:59 +0100 |
| commit | e044a4670963c95db54eb396d6455008d7c07ebd (patch) | |
| tree | c93631e297e5bb5803b925744dd26077eb14e181 /mysqltest.sql | |
| parent | 3a75f337ee4cb305c7ed8b56d45a3a64f6e4665e (diff) | |
renamed files
Diffstat (limited to 'mysqltest.sql')
| -rw-r--r-- | mysqltest.sql | 28 |
1 files changed, 0 insertions, 28 deletions
diff --git a/mysqltest.sql b/mysqltest.sql deleted file mode 100644 index aad5b9a..0000000 --- a/mysqltest.sql +++ /dev/null @@ -1,28 +0,0 @@ -DROP TABLE IF EXISTS asnip; - -CREATE TABLE asnip ( - asn INT, - ip_block CHAR(18) -- Since a ip block consist of a maximum of 18 chars "255.255.255.255/32" -); - -DROP TABLE IF EXISTS clean_data; - -CREATE TABLE clean_data ( - ipb_src CHAR(18), - ipb_dst CHAR(18), - time DATETIME, - port INT, - volume CHAR(10), - occurences INT, - UNIQUE idx (ipb_src, ipb_dst, time, port, packet_size) -); - -DROP TABLE IF EXISTS raw_data; - -CREATE TABLE raw_data ( - ip_src CHAR(15), -- Since a ip consist of a maximum of 15 chars "255.255.255.255" - ip_dst CHAR(15), - time DATETIME, - port INT, - packet_size INT -); |
