From a73335376ec33249486e9c38dd890043ecd3ae30 Mon Sep 17 00:00:00 2001
From: mcramer <m.cramer@pixcept.de>
Date: Mon, 08 Jun 2009 16:22:27 -0400
Subject: [PATCH] Added: vlogger mysql usage to store traffic reports Added: interface module web traffic statistics Fixed: mail_traffic is now reported to master server instead of local Fixed: GRANTs for slave server database user on master database

---
 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 448c0a8..376ff66 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -1019,6 +1019,20 @@
 -- --------------------------------------------------------
 
 --
+-- Table structure for table  `web_traffic`
+--
+
+CREATE TABLE `web_traffic` (
+  `hostname` varchar(255) NOT NULL,
+  `traffic_date` date NOT NULL,
+  `traffic_bytes` bigint(32) unsigned NOT NULL default '0',
+  PRIMARY KEY  (`hostname`,`traffic_date`)
+) ENGINE=MyISAM;
+
+
+-- --------------------------------------------------------
+
+--
 -- Table structure for table  `attempts_login`
 --
 

--
Gitblit v1.9.1