From 971fb330bd4074ffea11beb7c4f0d891b3a418fb Mon Sep 17 00:00:00 2001
From: tbrehm <t.brehm@ispconfig.org>
Date: Thu, 19 Nov 2009 08:51:02 -0500
Subject: [PATCH] Added key on type column in mail_forwarding table.
---
install/sql/ispconfig3.sql | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/install/sql/ispconfig3.sql b/install/sql/ispconfig3.sql
index 270ad50..d635554 100644
--- a/install/sql/ispconfig3.sql
+++ b/install/sql/ispconfig3.sql
@@ -398,7 +398,8 @@
`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`)
+ KEY `server_id` (`server_id`,`source`),
+ KEY `type` (`type`)
) ENGINE=MyISAM AUTO_INCREMENT=1;
-- --------------------------------------------------------
--
Gitblit v1.9.1