From 614365f8e1e61b6e1cfa34fd8084a31b235c944b Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Thu, 10 Jul 2008 09:10:03 -0400
Subject: [PATCH] The server log priority setting is now preserved when the system is updated.

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

diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index c29fe2d..1a430d5 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -265,7 +265,8 @@
   `domain` varchar(255) NOT NULL default '',
   `active` enum('y','n') NOT NULL,
   PRIMARY KEY  (`domain_id`),
-  KEY `server_id` (`server_id`,`domain`)
+  KEY `server_id` (`server_id`,`domain`),
+  KEY `domain_active` (`domain`,`active`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- 
@@ -448,7 +449,8 @@
   `postfix` enum('y','n') NOT NULL,
   `access` enum('y','n') NOT NULL,
   PRIMARY KEY  (`mailuser_id`),
-  KEY `server_id` (`server_id`,`email`)
+  KEY `server_id` (`server_id`,`email`),
+  KEY `email_access` (`email`,`access`)
 ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
 
 -- 

--
Gitblit v1.9.1