CREATE TABLE IF NOT EXISTS eth_header (
	tmstmp DOUBLE(18,7) NOT NULL,
	eth_src CHAR(17) NOT NULL,
	eth_dst	CHAR(17) NOT NULL,
	eth_typ SMALLINT UNSIGNED NOT NULL,
	PRIMARY KEY (tmstmp)
);

CREATE TABLE IF NOT EXISTS arp_header (
	tmstmp DOUBLE(18,7) NOT NULL,
	arp_hrd_typ SMALLINT UNSIGNED NOT NULL,
	arp_prt_typ SMALLINT UNSIGNED NOT NULL,
	arp_hrd_len CHAR(1) NOT NULL,
	arp_prt_len CHAR(1) NOT NULL,
	arp_typ SMALLINT UNSIGNED NOT NULL,
	arp_sdr_mac CHAR(17) NOT NULL,
	arp_tgt_mac CHAR(17) NOT NULL,
	arp_sdr_ip INT UNSIGNED NOT NULL,
	arp_tgt_ip INT UNSIGNED NOT NULL,
	PRIMARY KEY (tmstmp)
);

CREATE TABLE IF NOT EXISTS ip_header (
	tmstmp DOUBLE(18,7) NOT NULL,
	ip_hdr_len TINYINT UNSIGNED NOT NULL,
	ip_ver TINYINT UNSIGNED NOT NULL,
	ip_tos CHAR(1) NOT NULL,
	ip_pkt_len SMALLINT UNSIGNED NOT NULL,
	ip_id SMALLINT UNSIGNED NOT NULL,
	ip_frg_off SMALLINT UNSIGNED,
	ip_ttl CHAR(1) NOT NULL,
	ip_protocol CHAR(1) NOT NULL,
	ip_chksum SMALLINT UNSIGNED,
	ip_src INT UNSIGNED NOT NULL,
	ip_src_b1 TINYINT UNSIGNED,
	ip_src_b2 TINYINT UNSIGNED,
	ip_src_b3 TINYINT UNSIGNED,
	ip_src_b4 TINYINT UNSIGNED,
	src_hostname TEXT,
	ip_dst INT UNSIGNED NOT NULL,
	ip_dst_b1 TINYINT UNSIGNED,
	ip_dst_b2 TINYINT UNSIGNED,
	ip_dst_b3 TINYINT UNSIGNED,
	ip_dst_b4 TINYINT UNSIGNED,
	dst_hostname TEXT,
	PRIMARY KEY (tmstmp)
);

CREATE TABLE IF NOT EXISTS tcp_header (
	tmstmp DOUBLE(18,7) NOT NULL,
	tcp_src_port SMALLINT UNSIGNED NOT NULL,
	tcp_dst_port SMALLINT UNSIGNED NOT NULL,
	tcp_seq_num INT UNSIGNED NOT NULL,
	tcp_ack_num INT UNSIGNED NOT NULL,
	tcp_reserved TINYINT UNSIGNED NOT NULL,
	tcp_hdr_len TINYINT UNSIGNED NOT NULL,
	tcp_flags TINYINT UNSIGNED NOT NULL,
	tcp_win_siz SMALLINT UNSIGNED NOT NULL,
	tcp_chksum SMALLINT UNSIGNED,
	tcp_urg_ptr SMALLINT UNSIGNED,
	PRIMARY KEY (tmstmp)
);

CREATE TABLE IF NOT EXISTS udp_header (
	tmstmp DOUBLE(18,7) NOT NULL,
	udp_src_port SMALLINT UNSIGNED NOT NULL,
	udp_dst_port SMALLINT UNSIGNED NOT NULL,
	udp_len SMALLINT UNSIGNED NOT NULL,
	udp_chksum SMALLINT UNSIGNED,
	PRIMARY KEY (tmstmp)
);

CREATE TABLE IF NOT EXISTS icmp_header (
	tmstmp DOUBLE(18,7) NOT NULL,
	icmp_typ TINYINT UNSIGNED NOT NULL,
	icmp_code TINYINT UNSIGNED NOT NULL,
	icmp_chksum SMALLINT UNSIGNED,
	PRIMARY KEY (tmstmp)
);

CREATE TABLE IF NOT EXISTS igmp_header (
	tmstmp DOUBLE(18,7) NOT NULL,
	igmp_typ TINYINT UNSIGNED NOT NULL,
	igmp_ver TINYINT UNSIGNED NOT NULL,
	igmp_chksum SMALLINT UNSIGNED,
	igmp_addr INT UNSIGNED NOT NULL,
	PRIMARY KEY (tmstmp)
);