diff options
| author | thomascube <thomas@roundcube.net> | 2007-09-11 20:51:11 +0000 |
|---|---|---|
| committer | thomascube <thomas@roundcube.net> | 2007-09-11 20:51:11 +0000 |
| commit | 29451cfc61ed7dcd6a55bcdb2358b8f8b9ddeef1 (patch) | |
| tree | e6b072e1050da0633fb87e06c481353d33a0ade8 /SQL | |
| parent | 67eda0850d9e71a3b461e278730afe7b9ad9b9c3 (diff) | |
Truncate cache table before adding index
Diffstat (limited to 'SQL')
| -rw-r--r-- | 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 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`, |