From c11b7d9af50694fe72445c487a7b1e8660893051 Mon Sep 17 00:00:00 2001 From: vogelor <vogelor@ispconfig3> Date: Tue, 16 Dec 2008 02:23:22 -0500 Subject: [PATCH] Forgot the table --- install/sql/ispconfig3.sql | 33 +++++++++++++++++++++++++++++++++ 1 files changed, 33 insertions(+), 0 deletions(-) diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql index cc5b893..be62ad2 100644 --- a/install/sql/ispconfig3.sql +++ b/install/sql/ispconfig3.sql @@ -103,6 +103,39 @@ -- Daten f�r Tabelle `client` -- +-- +-- Tabellenstruktur f�r Tabelle `client_template` +-- + +CREATE TABLE `client_template` ( + `template_id` bigint(20) NOT NULL auto_increment, + `template_name` varchar(50) NOT NULL, + `template_type` varchar(1) NOT NULL default 'm', + `limit_maildomain` int(11) NOT NULL default '-1', + `limit_mailbox` int(11) NOT NULL default '-1', + `limit_mailalias` int(11) NOT NULL default '-1', + `limit_mailforward` int(11) NOT NULL default '-1', + `limit_mailcatchall` int(11) NOT NULL default '-1', + `limit_mailrouting` int(11) NOT NULL default '0', + `limit_mailfilter` int(11) NOT NULL default '-1', + `limit_fetchmail` int(11) NOT NULL default '-1', + `limit_mailquota` int(11) NOT NULL default '-1', + `limit_spamfilter_wblist` int(11) NOT NULL default '0', + `limit_spamfilter_user` int(11) NOT NULL default '0', + `limit_spamfilter_policy` int(11) NOT NULL default '0', + `limit_web_ip` text, + `limit_web_domain` int(11) NOT NULL default '-1', + `limit_web_subdomain` int(11) NOT NULL default '-1', + `limit_web_aliasdomain` int(11) NOT NULL default '-1', + `limit_ftp_user` int(11) NOT NULL default '-1', + `limit_shell_user` int(11) NOT NULL default '0', + `limit_dns_zone` int(11) NOT NULL default '-1', + `limit_dns_record` int(11) NOT NULL default '-1', + `limit_database` int(11) NOT NULL default '-1', + `limit_client` int(11) NOT NULL default '0', + PRIMARY KEY (`template_id`) +) ENGINE=MyISAM AUTO_INCREMENT=1 ; + -- -------------------------------------------------------- -- Gitblit v1.9.1