From 84d06edb06433c980dc7718188fcdd0799b08c09 Mon Sep 17 00:00:00 2001 From: thomascube <thomas@roundcube.net> Date: Wed, 19 Sep 2007 02:55:05 -0400 Subject: [PATCH] IPv6 Compatability --- 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