1 -- RoundCube Webmail update script for MySQL databases
2 -- Updates from version 0.1-stable to 0.1.1
4 TRUNCATE TABLE `messages`;
11 DROP INDEX `cache_key`,
12 DROP INDEX `session_id`,
13 ADD INDEX `user_cache_index` (`user_id`,`cache_key`);
16 ADD INDEX `username_index` (`username`),
17 ADD INDEX `alias_index` (`alias`);
19 -- Updates from version 0.1.1
21 ALTER TABLE `identities`
22 MODIFY `signature` text,
23 MODIFY `bcc` varchar(128) NOT NULL DEFAULT '',
24 MODIFY `reply-to` varchar(128) NOT NULL DEFAULT '',
25 MODIFY `organization` varchar(128) NOT NULL DEFAULT '',
26 MODIFY `name` varchar(128) NOT NULL,
27 MODIFY `email` varchar(128) NOT NULL;
29 -- Updates from version 0.2-alpha
31 ALTER TABLE `messages`
32 ADD INDEX `created_index` (`created`);
34 -- Updates from version 0.2-beta (InnoDB only)
40 ADD INDEX `changed_index` (`changed`);
43 ADD INDEX `created_index` (`created`);
46 CHANGE `language` `language` varchar(5);