CREATE DATABASE netflow;

CREATE TABLE headers (HEADER_ID INT AUTO_INCREMENT PRIMARY KEY,
			NETFLOW_SOURCE VARCHAR(15),
			NETFLOW_EXPORT_VERSION CHAR,
			FLOW_RECORD_COUNT INT,
			SYS_UP_TIME INT,
			UNIX_DATE_TIME_SECONDS INT,
			UNIX_RESIDUAL_NSECONDS INT
			);

CREATE TABLE flows (FLOW_ID INT AUTO_INCREMENT PRIMARY KEY,
			FROM_HEADER_ID INT,
			IP_SOURCE_ADDRESS VARCHAR(15),
			IP_DESTINATION_ADDRESS VARCHAR(15),
			IP_NEXT_HOP_ADDRESS VARCHAR(15),
			INPUT_IF_SNMP_ID VARCHAR(2),
			OUTPUT_IF_SNMP_ID VARCHAR(2),
			PACKETS_SENT INT,
			OCTETS_SENT INT,
			FLOW_START_UNIX_TIME_SECS INT,
			FLOW_END_UNIX_TIME_SECS INT,
			IP_PORT_SOURCE INT,
			IP_PORT_DESTINATION INT,
			PAD1 INT,
			IP_PROTOCOL VARCHAR(5),
			IP_TOS VARCHAR(5),
			TCP_FLAGS VARCHAR(5),
			RESERVED VARCHAR(8)
			);

INSERT INTO cadastro_testes (Nome, ComoConheceu) VALUES ()