From 4b16059c4e7f3735c016d4f47c9f87371bf22d8e Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Fri, 13 Mar 2015 13:15:55 +0100 Subject: added config files for pmacct --- pmacct/sbSetupCustom.mysql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 pmacct/sbSetupCustom.mysql (limited to 'pmacct/sbSetupCustom.mysql') diff --git a/pmacct/sbSetupCustom.mysql b/pmacct/sbSetupCustom.mysql new file mode 100644 index 0000000..dafc638 --- /dev/null +++ b/pmacct/sbSetupCustom.mysql @@ -0,0 +1,16 @@ +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) +); -- cgit v1.1