1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
|
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,
packet_size INT,
process_time DATETIME
);
|
