diff options
| author | thomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2007-09-11 20:51:11 +0000 |
|---|---|---|
| committer | thomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2007-09-11 20:51:11 +0000 |
| commit | ccced3c4d2a004fdfdcd708eb3d37bcfd9fbb28d (patch) | |
| tree | 4111f059585b2d0a261f50bf11d1df62f5919824 /roundcubemail/SQL | |
| parent | 96da6cd44b1d98c84b225de72e6a30935da6d944 (diff) | |
Truncate cache table before adding index
git-svn-id: https://svn.roundcube.net/trunk@796 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL')
| -rw-r--r-- | roundcubemail/SQL/mysql.update.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/roundcubemail/SQL/mysql.update.sql b/roundcubemail/SQL/mysql.update.sql index b64f407c7..27d45ebad 100644 --- a/roundcubemail/SQL/mysql.update.sql +++ b/roundcubemail/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`, |