diff options
| author | thomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2011-01-26 11:53:18 +0000 |
|---|---|---|
| committer | thomasb <thomasb@208e9e7b-5314-0410-a742-e7e81cd9613c> | 2011-01-26 11:53:18 +0000 |
| commit | 5f51ba1e7cbd9bbbf927d9817bc3b847db7d9eec (patch) | |
| tree | a00ac56f622e4b97eb1272bd4002280c4591dc96 /roundcubemail/SQL | |
| parent | e0124f63c5491882d31aadc35c45d454c0c51153 (diff) | |
Clear message cache table when upgrading
git-svn-id: https://svn.roundcube.net/trunk@4459 208e9e7b-5314-0410-a742-e7e81cd9613c
Diffstat (limited to 'roundcubemail/SQL')
| -rw-r--r-- | roundcubemail/SQL/mysql.update.sql | 2 | ||||
| -rw-r--r-- | roundcubemail/SQL/postgres.update.sql | 1 | ||||
| -rw-r--r-- | roundcubemail/SQL/sqlite.update.sql | 2 |
3 files changed, 5 insertions, 0 deletions
diff --git a/roundcubemail/SQL/mysql.update.sql b/roundcubemail/SQL/mysql.update.sql index 2af0a47e6..aaab43fb2 100644 --- a/roundcubemail/SQL/mysql.update.sql +++ b/roundcubemail/SQL/mysql.update.sql @@ -131,3 +131,5 @@ ALTER TABLE `users` ADD UNIQUE `username` (`username`, `mail_host`); ALTER TABLE `contacts` MODIFY `email` varchar(255) NOT NULL; +TRUNCATE TABLE `messages`; + diff --git a/roundcubemail/SQL/postgres.update.sql b/roundcubemail/SQL/postgres.update.sql index 444caf6f6..2f4498d36 100644 --- a/roundcubemail/SQL/postgres.update.sql +++ b/roundcubemail/SQL/postgres.update.sql @@ -88,3 +88,4 @@ DROP INDEX users_username_id_idx; ALTER TABLE users ADD UNIQUE (username, mail_host); ALTER TABLE contacts ALTER email TYPE varchar(255); +TRUNCATE messages; diff --git a/roundcubemail/SQL/sqlite.update.sql b/roundcubemail/SQL/sqlite.update.sql index 328693944..6f2acf913 100644 --- a/roundcubemail/SQL/sqlite.update.sql +++ b/roundcubemail/SQL/sqlite.update.sql @@ -180,3 +180,5 @@ INSERT INTO contacts (contact_id, user_id, changed, del, name, email, firstname, CREATE INDEX ix_contacts_user_id ON contacts(user_id, email); DROP TABLE contacts_tmp; +DELETE FROM messages; + |