From bad8d2dcd2ee934ba88163af546e1997413a4556 Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Fri, 13 Mar 2015 13:22:13 +0100 Subject: renamed misspelled file 2 --- pmacct/dbSetupCustom.mysql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) create mode 100644 pmacct/dbSetupCustom.mysql (limited to 'pmacct/dbSetupCustom.mysql') diff --git a/pmacct/dbSetupCustom.mysql b/pmacct/dbSetupCustom.mysql new file mode 100644 index 0000000..dafc638 --- /dev/null +++ b/pmacct/dbSetupCustom.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