From 7e78b2ec373f4596f986bb75a0e6c33bd67a82b4 Mon Sep 17 00:00:00 2001 From: alecpl <alec@alec.pl> Date: Sat, 07 Jun 2008 15:33:07 -0400 Subject: [PATCH] -segfault (#1485109) --- SQL/mysql.update.sql | 26 +++++++++++++++++++++----- 1 files changed, 21 insertions(+), 5 deletions(-) diff --git a/SQL/mysql.update.sql b/SQL/mysql.update.sql index ef5f07d..2a9603f 100644 --- a/SQL/mysql.update.sql +++ b/SQL/mysql.update.sql @@ -1,11 +1,27 @@ -- RoundCube Webmail update script for MySQL databases --- Updates from version 0.1-beta and 0.1-beta2 +-- Updates from version 0.1-stable to 0.1.1 + +TRUNCATE TABLE `messages`; ALTER TABLE `messages` - DROP `body`, + DROP INDEX `idx`, + DROP INDEX `uid`; + +ALTER TABLE `cache` DROP INDEX `cache_key`, - ADD `structure` TEXT, - ADD UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`); + DROP INDEX `session_id`, + ADD INDEX `user_cache_index` (`user_id`,`cache_key`); + +ALTER TABLE `users` + ADD INDEX `username_index` (`username`), + ADD INDEX `alias_index` (`alias`); + +-- Updates from version 0.1.1 ALTER TABLE `identities` - ADD `html_signature` tinyint(1) default 0 NOT NULL; + MODIFY `signature` text NOT NULL DEFAULT '', + MODIFY `bcc` varchar(128) NOT NULL DEFAULT '', + MODIFY `reply-to` varchar(128) NOT NULL DEFAULT '', + MODIFY `organization` varchar(128) NOT NULL DEFAULT '', + MODIFY `name` varchar(128) NOT NULL, + MODIFY `email` varchar(128) NOT NULL; -- Gitblit v1.9.1