You are here

Amavis 2.6.2 - NEW FEATURES

Amavis 2.6.2 - NEW FEATURES

SQL tables tables maddr, msgs, msgrcpt and quarantine are extended by a new field 'partition_tag'.

To convert tables of an existing database, please use ALTER command.

(make a backup before execute these command!!!!)

To convert tables of an existing database, please use ALTER command.
Here is a conversion example (MySQL or PostgreSQL, probably others):

ALTER TABLE maddr ADD partition_tag integer DEFAULT 0;
ALTER TABLE msgs ADD partition_tag integer DEFAULT 0;
ALTER TABLE msgrcpt ADD partition_tag integer DEFAULT 0;
ALTER TABLE quarantine ADD partition_tag integer DEFAULT 0;

As the maddr.email is no longer guaranteed to be unique, but a pair
of (maddr.partition_tag, maddr.email) is unique, the constraint and
an associated index needs to be changed:

=> PostgreSQL:
ALTER TABLE maddr
DROP CONSTRAINT maddr_email_key,
ADD CONSTRAINT maddr_email_key UNIQUE (partition_tag,email);

=> MySQL:
ALTER TABLE maddr
DROP KEY email,
ADD UNIQUE KEY part_email (partition_tag,email);

more details:
http://www.ijs.si/software/amavisd/release-notes.txt