From e044a4670963c95db54eb396d6455008d7c07ebd Mon Sep 17 00:00:00 2001
From: Daniel Langesten <daniel.langest@gmail.com>
Date: Mon, 2 Mar 2015 11:48:59 +0100
Subject: renamed files

---
 dbsetup.sql | 28 ++++++++++++++++++++++++++++
 1 file changed, 28 insertions(+)
 create mode 100644 dbsetup.sql

(limited to 'dbsetup.sql')

diff --git a/dbsetup.sql b/dbsetup.sql
new file mode 100644
index 0000000..aad5b9a
--- /dev/null
+++ b/dbsetup.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, 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

