From 6b79f7b57a51141dbef44011cdf0ebacf5f74c8c Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Wed, 26 Sep 2007 11:13:22 -0400 Subject: [PATCH] Set default IMAP folder delimiter; make sure is not empty --- SQL/mysql.update.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index b64f407..e904be2 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`, @@ -10,6 +12,8 @@ ALTER TABLE `identities` ADD `html_signature` tinyint(1) default 0 NOT NULL; +ALTER TABLE `session` CHANGE `ip` `ip` VARCHAR(40) + -- Uncomment these lines if you're using MySQL 4.1 or higher -- ALTER TABLE `users` -- DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci, -- Gitblit v1.9.1