dbsetup.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

DROP TABLE IF EXISTS clean_data;

CREATE TABLE clean_data (
	ipb_src CHAR(39) NOT NULL,
	ipb_dst CHAR(39) NOT NULL,
	as_src INT(4) UNSIGNED NOT NULL,
	as_dst INT(4) UNSIGNED NOT NULL,
	port_src INT(2) UNSIGNED NOT NULL,
	port_dst INT(2) UNSIGNED NOT NULL,
	occurences INT UNSIGNED NOT NULL,
	volume CHAR(10) NOT NULL,
	time DATETIME NOT NULL,
	UNIQUE idx (ipb_src, ipb_dst, as_src, as_dst, port_src, port_dst, volume, time)
);