DROP TABLE IF EXISTS acct_v5;

CREATE TABLE acct_v5 (

agent_id INT(8) NOT NULL DEFAULT 0,

class_id CHAR(16) NOT NULL DEFAULT ' ',

mac_src CHAR(17) NOT NULL DEFAULT '0:0:0:0:0:0',

mac_dst CHAR(17) NOT NULL DEFAULT '0:0:0:0:0:0',

vlan INT(4) NOT NULL DEFAULT 0,

ip_src CHAR(45) NOT NULL DEFAULT '0.0.0.0',

ip_dst CHAR(45) NOT NULL DEFAULT '0.0.0.0',

src_port INT(4) NOT NULL DEFAULT 0,

dst_port INT(4) NOT NULL DEFAULT 0,

ip_proto CHAR(6) NOT NULL DEFAULT 0,

tos INT(4) NOT NULL DEFAULT 0,

packets INT NOT NULL,

bytes BIGINT NOT NULL,

flows INT NOT NULL DEFAULT 0,

stamp_inserted DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',

stamp_updated DATETIME,

PRIMARY KEY (agent_id, class_id, mac_src, mac_dst, vlan, ip_src, ip_dst, src_port, dst_port, ip_proto, tos, stamp_inserted)

);