From 29451cfc61ed7dcd6a55bcdb2358b8f8b9ddeef1 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Tue, 11 Sep 2007 16:51:11 -0400 Subject: [PATCH] Truncate cache table before adding index --- SQL/mysql.update.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index b64f407..27d45eb 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -1,6 +1,8 @@ -- RoundCube Webmail update script for MySQL databases -- Updates from version 0.1-beta and 0.1-beta2 +TRUNCATE TABLE `messages`; + ALTER TABLE `messages` DROP `body`, DROP INDEX `cache_key`, -- Gitblit v1.9.1