From e044a4670963c95db54eb396d6455008d7c07ebd Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Mon, 2 Mar 2015 11:48:59 +0100 Subject: renamed files --- mysqltest.sql | 28 ---------------------------- 1 file changed, 28 deletions(-) delete mode 100644 mysqltest.sql (limited to 'mysqltest.sql') 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 -); -- cgit v1.1