From 715c7961ba8ff72fe40720bb4feaa7865e57e8b9 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Tue, 01 Mar 2011 16:22:52 -0500 Subject: [PATCH] Don't do exact matches when searching for existing email records --- SQL/postgres.update.sql | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql index 444caf6..91c32f8 100644 --- a/SQL/postgres.update.sql +++ b/SQL/postgres.update.sql @@ -88,3 +88,9 @@ ALTER TABLE users ADD UNIQUE (username, mail_host); ALTER TABLE contacts ALTER email TYPE varchar(255); +TRUNCATE messages; + +-- Updates from version 0.5.1 + +ALTER TABLE contacts ADD words TEXT NULL; +CREATE INDEX contactgroupmembers_contact_id_idx ON contactgroupmembers (contact_id); -- Gitblit v1.9.1