added config files for pmacct

1 files changed, 16 insertions, 0 deletions

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)
+);