Mark,
Just to clarify, to upgrade to 2.6.0, you have us drop:
<...>
ALTER TABLE maddr DROP CONSTRAINT maddr_email_key;
<...>
Yet, I could find no where in the documentation where a constraint
called maddr_email_key is created (so it's not clear if
'maddr_email_key' is literal or not).
This created an 'email' INDEX:
CREATE TABLE maddr (
id int unsigned NOT NULL AUTO_INCREMENT PRIMARY KEY,
email varchar(255) NOT NULL UNIQUE, -- full mail address
domain varchar(255) NOT NULL -- only domain part of the email address
-- with subdomain fields in reverse
) ENGINE=InnoDB;
It is this index you wish dropped (and subsequently replaced)?
--
Gary V
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/
