diff options
Diffstat (limited to 'mysqltest.sql')
| -rw-r--r-- | mysqltest.sql | 28 |
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 -); |
