From 3caee15a2597feed739f48cc0cd3334b98233630 Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Mon, 16 Mar 2015 11:53:31 +0100 Subject: updated the db for the nfacct.conf --- pmacct/dbSetupCustom.mysql | 24 ++++++++++++++---------- 1 file changed, 14 insertions(+), 10 deletions(-) (limited to 'pmacct/dbSetupCustom.mysql') diff --git a/pmacct/dbSetupCustom.mysql b/pmacct/dbSetupCustom.mysql index 9cc8f6b..167ffb1 100644 --- a/pmacct/dbSetupCustom.mysql +++ b/pmacct/dbSetupCustom.mysql @@ -3,14 +3,18 @@ create database pmacct; use pmacct; drop table if 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) + create table acct ( + ip_src CHAR(39) NOT NULL, + ip_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, + packets INT UNSIGNED NOT NULL, + bytes INT UNSIGNED NOT NULL, + pkt_len_distrib CHAR(10) NOT NULL, + stamp_inserted DATETIME NOT NULL, + stamp_updated DATETIME, + PRIMARY KEY (ip_src, ip_dst, as_src, as_dst, port_src, port_dst, pkt_len_distrib, stamp_inserted) ); + -- cgit v1.1