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 |    7 +++++++
 1 files changed, 7 insertions(+), 0 deletions(-)

diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql
index 99b9c0e..91c32f8 100644
--- a/SQL/postgres.update.sql
+++ b/SQL/postgres.update.sql
@@ -86,4 +86,11 @@
 
 DROP INDEX users_username_id_idx;
 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