From 3764dc4ad0b85b25cfe1247f68c5df00a2f0445d Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Tue, 27 Oct 2009 11:34:34 -0400
Subject: [PATCH] Implemented: FS#539 - ssl domain must be selectable

---
 install/sql/ispconfig3.sql |    9 +++++++--
 1 files changed, 7 insertions(+), 2 deletions(-)

diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index a682705..017423f 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -69,6 +69,7 @@
   `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_mailaliasdomain` 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',
@@ -125,6 +126,7 @@
   `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_mailaliasdomain` 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',
@@ -229,6 +231,8 @@
   `ttl` int(11) unsigned NOT NULL default '86400',
   `active` enum('N','Y') NOT NULL,
   `xfer` varchar(255) NOT NULL,
+  `also_notify` varchar(255) default NULL,
+  `update_acl` varchar(255) default NULL,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `origin` (`origin`),
   KEY `active` (`active`)
@@ -389,7 +393,7 @@
   `server_id` int(11) unsigned NOT NULL default '0',
   `source` varchar(255) NOT NULL,
   `destination` text NOT NULL default '',
-  `type` enum('alias','forward','catchall') NOT NULL default 'alias',
+  `type` enum('alias','aliasdomain','forward','catchall') NOT NULL default 'alias',
   `active` enum('n','y') NOT NULL,
   PRIMARY KEY  (`forwarding_id`),
   KEY `server_id` (`server_id`,`source`)
@@ -1018,6 +1022,7 @@
   `ssl_organisation` varchar(255) NULL,
   `ssl_organisation_unit` varchar(255) NULL,
   `ssl_country` varchar(255) NULL,
+  `ssl_domain` varchar(255) NULL,
   `ssl_request` mediumtext NULL,
   `ssl_cert` mediumtext NULL,
   `ssl_bundle` mediumtext NULL,
@@ -1201,7 +1206,7 @@
 -- Dumping data for table `sys_config`
 --
 
-INSERT INTO sys_config VALUES ('1','db','db_version','3.0.1.4');
+INSERT INTO sys_config VALUES ('1','db','db_version','3.0.1.5');
 
 -- --------------------------------------------------------
 

--
Gitblit v1.9.1