[AMaViS-user] maddr_email_key

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

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/