From 38eb46bad4062e04f1db1b93bf5d0d1a935c4d96 Mon Sep 17 00:00:00 2001 From: Daniel Langesten Date: Tue, 17 Mar 2015 12:01:38 +0100 Subject: merged db setups into one file --- pmacct/dbSetupCustom.mysql | 20 -------------------- 1 file changed, 20 deletions(-) delete mode 100644 pmacct/dbSetupCustom.mysql (limited to 'pmacct/dbSetupCustom.mysql') diff --git a/pmacct/dbSetupCustom.mysql b/pmacct/dbSetupCustom.mysql deleted file mode 100644 index 167ffb1..0000000 --- a/pmacct/dbSetupCustom.mysql +++ /dev/null @@ -1,20 +0,0 @@ -drop database if exists pmacct; -create database pmacct; -use pmacct; - -drop table if exists acct; - 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