From aa16b4af8f67d91b1bfd2c584a665a53c403f47c Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Wed, 23 Dec 2009 03:01:39 -0500 Subject: [PATCH] - Improved handling of message parts of type message/rfc822 (fixed e.g. inline images in multipart/alternative messages attached as message/rfc822) --- SQL/mysql.update.sql | 10 +++++++++- 1 files changed, 9 insertions(+), 1 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index f0cac24..17301ab 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -1,5 +1,5 @@ -- RoundCube Webmail update script for MySQL databases --- Updates from version 0.1-stable to 0.1.1 +-- Updates from version 0.1-stable to 0.3.1 TRUNCATE TABLE `messages`; @@ -47,5 +47,13 @@ -- Updates from version 0.3-stable +TRUNCATE `messages`; + ALTER TABLE `messages` ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`); + +ALTER TABLE `session` + CHANGE `vars` `vars` MEDIUMTEXT NOT NULL; + +ALTER TABLE `contacts` + ADD INDEX `user_contacts_index` (`user_id`,`email`); -- Gitblit v1.9.1