Roundcube Community Forum

 

No UPGRADING file?

Started by superfly, January 31, 2009, 12:45:06 PM

Previous topic - Next topic

superfly

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?

rosali

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);

Regards,
Rosali

superfly

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.

JohnDoh

where are you downloading from? I just tried both the tar.gz and the zip file from here Downloading RoundCube Webmail and they look fine.
Roundcube Plugins: Contextmenu, SpamAssassin Prefs, and more...

superfly

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.