diff options
| author | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-16 11:53:31 +0100 |
|---|---|---|
| committer | Daniel Langesten <daniel.langest@gmail.com> | 2015-03-16 11:53:31 +0100 |
| commit | 3caee15a2597feed739f48cc0cd3334b98233630 (patch) | |
| tree | fc750c057211e590a9a64a2faeb8e576b2f1a12e /pmacct/dbSetupCustom.mysql | |
| parent | 529e8ca8708049f44c76a5e948e82c8632589dee (diff) | |
updated the db for the nfacct.conf
Diffstat (limited to 'pmacct/dbSetupCustom.mysql')
| -rw-r--r-- | pmacct/dbSetupCustom.mysql | 24 |
1 files changed, 14 insertions, 10 deletions
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) ); + |