From 084d3b346263754694cb4f874cd85b37e9a2b06c Mon Sep 17 00:00:00 2001
From: Daniel Langesten <daniel.langest@gmail.com>
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

