added setup for db

1 files changed, 28 insertions, 0 deletions

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
+);