I've just downloaded the tar.gz for 0.2 stable, but there is no UGRADING file nor SQL scripts in the tarball. Did someone forget to add them?
Do you look for MSSQL? No, this one is not included. But you should see what has to be updated by looking into './SQL/mysql.update.sql'
-- RoundCube Webmail update script for MySQL databases
-- Updates from version 0.1-stable to 0.1.1
TRUNCATE TABLE `messages`;
ALTER TABLE `messages`
DROP INDEX `idx`,
DROP INDEX `uid`;
ALTER TABLE `cache`
DROP INDEX `cache_key`,
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`
MODIFY `signature` text,
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;
-- Updates from version 0.2-alpha
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);
I'm not an idiot, please don't treat me like one. FYI I've been involved in web development for 10 years.
The .tar.gz file did not contain an UPGRADING file, nor an SQL directory, nor a number of other files and directories that the zip file contains. I downloaded the zip file because of this, and it has all of those.
where are you downloading from? I just tried both the tar.gz and the zip file from here Downloading RoundCube Webmail (http://www.roundcube.net/downloads) and they look fine.
JohnDoh: From SourceForge... perhaps I hit a mirror that hadn't rsynced properly or something... I get that from time to time...
I just downloaded it again, and it seems fine. *shrug* Oh well.