From aca3d25f1b65bc601ea66b59528e39ce158f6c89 Mon Sep 17 00:00:00 2001 From: svncommit <devs@roundcube.net> Date: Thu, 20 Sep 2007 07:24:41 -0400 Subject: [PATCH] Make smtp HELO/EHLO hostname configurable (closes #1484067) --- SQL/mysql.update.sql | 16 +++++++++++++--- 1 files changed, 13 insertions(+), 3 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index b16f255..e904be2 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -1,11 +1,21 @@ -- 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`, ADD `structure` TEXT, - ADD UNIQUE `uniqueness` (`cache_key`, `uid`); + ADD UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`); -ALTER TABLE 'identities' - ADD 'html_signature' tinyint(1) default 0 NOT NULL; +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, +-- CHANGE `username` `username` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, +-- CHANGE `alias` `alias` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; -- Gitblit v1.9.1