From cfc79e73e49fdb1f3cc3e80238011c8c1b9dd7dd Mon Sep 17 00:00:00 2001 From: LEVEILLE Cédric <leveille.cedric@oricom.org> Date: Mon, 18 Jan 2016 13:49:38 -0500 Subject: [PATCH] Ftp statistics feature --- install/sql/ispconfig3.sql | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 672f94b..5053b9b 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -638,6 +638,20 @@ -- -------------------------------------------------------- +-- +-- Table structure for table `ftp_traffic` +-- + +CREATE TABLE `ftp_traffic` ( + `hostname` varchar(255) NOT NULL, + `traffic_date` date NOT NULL, + `in_bytes` bigint(32) unsigned NOT NULL, + `out_bytes` bigint(32) unsigned NOT NULL, + PRIMARY KEY (`hostname`,`traffic_date`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ; + +-- -------------------------------------------------------- + -- -- Table structure for table `help_faq` -- -- Gitblit v1.9.1