From 084d3b346263754694cb4f874cd85b37e9a2b06c Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Fri, 27 Feb 2015 13:13:41 +0100 Subject: added setup for db --- mysqltest.sql | 28 ++++++++++++++++++++++++++++ 1 file changed, 28 insertions(+) create mode 100644 mysqltest.sql (limited to 'mysqltest.sql') diff --git a/mysqltest.sql b/mysqltest.sql new file mode 100644 index 0000000..6d4d072 --- /dev/null +++ b/mysqltest.sql @@ -0,0 +1,28 @@ +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, volume) +); + +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, + volume INT +); -- cgit v1.1