summaryrefslogtreecommitdiff
path: root/mysqltest.sql
diff options
context:
space:
mode:
Diffstat (limited to 'mysqltest.sql')
-rw-r--r--mysqltest.sql28
1 files changed, 0 insertions, 28 deletions
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
-);