summaryrefslogtreecommitdiff
path: root/SQL
diff options
context:
space:
mode:
authorthomascube <thomas@roundcube.net>2007-09-11 20:51:11 +0000
committerthomascube <thomas@roundcube.net>2007-09-11 20:51:11 +0000
commit29451cfc61ed7dcd6a55bcdb2358b8f8b9ddeef1 (patch)
treee6b072e1050da0633fb87e06c481353d33a0ade8 /SQL
parent67eda0850d9e71a3b461e278730afe7b9ad9b9c3 (diff)
Truncate cache table before adding index
Diffstat (limited to 'SQL')
-rw-r--r--SQL/mysql.update.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql
index b64f407c7..27d45ebad 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`,