| commit | author | age | ||
| 79fe17 | 1 | -- RoundCube Webmail update script for MySQL databases |
| ac26b9 | 2 | -- Updates from version 0.1-stable to 0.1.1 |
| 79fe17 | 3 | |
| 29451c | 4 | TRUNCATE TABLE `messages`; |
| T | 5 | |
| f7bfec | 6 | ALTER TABLE `messages` |
| ac26b9 | 7 | DROP INDEX `idx`, |
| T | 8 | DROP INDEX `uid`; |
| 9 | ||
| 10 | ALTER TABLE `cache` | |
| f7bfec | 11 | DROP INDEX `cache_key`, |
| ac26b9 | 12 | DROP INDEX `session_id`, |
| T | 13 | ADD INDEX `user_cache_index` (`user_id`,`cache_key`); |
| 6cb778 | 14 | |
| A | 15 | ALTER TABLE `users` |
| f5e8d2 | 16 | ADD INDEX `username_index` (`username`), |
| 6cb778 | 17 | ADD INDEX `alias_index` (`alias`); |
| d7f3d7 | 18 | |
| A | 19 | -- Updates from version 0.1.1 |
| 20 | ||
| 21 | ALTER TABLE `identities` | |
| f18911 | 22 | MODIFY `signature` text, |
| d7f3d7 | 23 | MODIFY `bcc` varchar(128) NOT NULL DEFAULT '', |
| A | 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; | |
| c98f3b | 28 | |
| A | 29 | -- Updates from version 0.2-alpha |
| 30 | ||
| 31 | ALTER TABLE `messages` | |
| 32 | ADD INDEX `created_index` (`created`); | |
| be7d3b | 33 | |
| A | 34 | -- Updates from version 0.2-beta (InnoDB only) |
| 35 | ||
| 36 | ALTER TABLE `cache` | |
| dcf780 | 37 | DROP `session_id`; |
| A | 38 | |
| 3e48d2 | 39 | ALTER TABLE `session` |
| A | 40 | ADD INDEX `changed_index` (`changed`); |
| e4d9f0 | 41 | |
| A | 42 | ALTER TABLE `cache` |
| 43 | ADD INDEX `created_index` (`created`); | |
| debdda | 44 | |
| A | 45 | ALTER TABLE `users` |
| 46 | CHANGE `language` `language` varchar(5); | |
