diff --git a/util/db-upgrade-0.1.24-vs-0.1.25.sql b/util/db-upgrade-0.1.24-vs-0.1.25.sql index 1d8aff6..c25190a 100644 --- a/util/db-upgrade-0.1.24-vs-0.1.25.sql +++ b/util/db-upgrade-0.1.24-vs-0.1.25.sql @@ -14,12 +14,6 @@ alter table archiving_rule add column `attachment_name` varchar(128) default null; alter table retention_rule add column `attachment_name` varchar(128) default null; -alter table archiving_rule drop index `from`; -create unique index `entry` on archiving_rule (`domain`,`from`,`to`,`subject`,`_size`,`size`,`attachment_name`,`attachment_type`,`_attachment_size`,`attachment_size`,`spam`); - -create unique index `entry` on retention_rule (`domain`,`from`,`to`,`subject`,`_size`,`size`,`attachment_name`,`attachment_type`,`_attachment_size`,`attachment_size`,`spam`); - - alter table ldap add column ldap_mail_attr varchar(128) default null; alter table ldap add column ldap_account_objectclass varchar(128) default null; alter table ldap add column ldap_distributionlist_attr varchar(128) default null; @@ -35,3 +29,7 @@ ) Engine=InnoDB; +create unique index `entry` on archiving_rule (`domain`,`from`,`to`,`subject`,`_size`,`size`,`attachment_name`,`attachment_type`,`_attachment_size`,`attachment_size`,`spam`); + +create unique index `entry` on retention_rule (`domain`,`from`,`to`,`subject`,`_size`,`size`,`attachment_name`,`attachment_type`,`_attachment_size`,`attachment_size`,`spam`); +