From dcff5718f345f55f7ea81f18d1f086facde4eacf Mon Sep 17 00:00:00 2001 From: pedro_morgan <pedro_morgan@ispconfig3> Date: Mon, 20 Aug 2007 23:14:51 -0400 Subject: [PATCH] * Using new ISPC_*_PATH constants * Adding new data schema (to be moved shortly * no more $conf['classpath'] --- install/sql/ispconfig3.sql | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index 79405fc..d55a440 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -329,6 +329,25 @@ -- Daten f�r Tabelle `mail_mailman_domain` -- +-- -------------------------------------------------------- + +-- +-- Tabellenstruktur f�r Tabelle `mail_traffic` +-- + +CREATE TABLE `mail_traffic` ( + `traffic_id` int(10) unsigned NOT NULL auto_increment, + `mailuser_id` int(10) unsigned NOT NULL, + `month` char(7) NOT NULL, + `traffic` bigint(20) unsigned NOT NULL, + PRIMARY KEY (`traffic_id`), + KEY `mailuser_id` (`mailuser_id`,`month`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; + +-- +-- Daten f�r Tabelle `mail_traffic` +-- + -- -------------------------------------------------------- -- Gitblit v1.9.1