From cdb8b96e31fdb71b37fe6b0fca81ef5221de7a6d Mon Sep 17 00:00:00 2001
From: thomascube <thomas@roundcube.net>
Date: Wed, 26 Jan 2011 06:53:18 -0500
Subject: [PATCH] Clear message cache table when upgrading

---
 SQL/sqlite.update.sql   |    2 ++
 SQL/postgres.update.sql |    1 +
 SQL/mysql.update.sql    |    2 ++
 3 files changed, 5 insertions(+), 0 deletions(-)

diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index 2af0a47..aaab43f 100644
--- a/SQL/mysql.update.sql
+++ b/SQL/mysql.update.sql
@@ -131,3 +131,5 @@
 
 ALTER TABLE `contacts` MODIFY `email` varchar(255) NOT NULL;
 
+TRUNCATE TABLE `messages`;
+
diff --git a/SQL/postgres.update.sql b/SQL/postgres.update.sql
index 444caf6..2f4498d 100644
--- a/SQL/postgres.update.sql
+++ b/SQL/postgres.update.sql
@@ -88,3 +88,4 @@
 ALTER TABLE users ADD UNIQUE (username, mail_host);
 ALTER TABLE contacts ALTER email TYPE varchar(255);
 
+TRUNCATE messages;
diff --git a/SQL/sqlite.update.sql b/SQL/sqlite.update.sql
index 3286939..6f2acf9 100644
--- a/SQL/sqlite.update.sql
+++ b/SQL/sqlite.update.sql
@@ -180,3 +180,5 @@
 CREATE INDEX ix_contacts_user_id ON contacts(user_id, email);
 DROP TABLE contacts_tmp;
 
+DELETE FROM messages;
+

--
Gitblit v1.9.1