drop database if exists pmacct;
create database pmacct;
use pmacct;

drop table is exists acct;
create table acct (
	ip_src CHAR(15) NOT NULL,
	ip_dst CHAR(15) NOT NULL,
	src_port INT(2) UNSIGNED NOT NULL,
	dst_port INT(2) UNSIGNED NOT NULL,
	packets INT UNSIGNED NOT NULL,
	bytes BIGINT UNSIGNED NOT NULL,
	stamp_inserted DATETIME NOT NULL,
	stamp_updated DATETIME,
	PRIMARY KEY (ip_src, ip_dst, src_port, dst_port, stamp_inserted)
);