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