From 52bd7bf16ed79c10c3b37d147595f57f3cc53cd6 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Wed, 30 Sep 2009 12:09:25 -0400 Subject: [PATCH] - fix 2px splitter issue on IE8 --- SQL/mysql.update.sql | 29 ++++++++++++++++++++++++++++- 1 files changed, 28 insertions(+), 1 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index ae6fb75..77bf317 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`; @@ -30,3 +30,30 @@ ALTER TABLE `messages` ADD INDEX `created_index` (`created`); + +-- Updates from version 0.2-beta (InnoDB only) + +ALTER TABLE `cache` + DROP `session_id`; + +ALTER TABLE `session` + ADD INDEX `changed_index` (`changed`); + +ALTER TABLE `cache` + ADD INDEX `created_index` (`created`); + +ALTER TABLE `users` + CHANGE `language` `language` varchar(5); + +-- Updates from version 0.3-stable + +ALTER TABLE `messages` + ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`); + +TRUNCATE `messages`; + +ALTER TABLE `session` + CHANGE `vars` `vars` MEDIUMTEXT NOT NULL; + +ALTER TABLE `contacts` + ADD INDEX `user_contacts_index` (`user_id`,`email`); -- Gitblit v1.9.1