| commit | author | age | ||
| 79fe17 | 1 | -- RoundCube Webmail update script for MySQL databases |
| b2b8b1 | 2 | -- Updates from version 0.1-stable to 0.3.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); | |
| 3d601d | 47 | |
| A | 48 | -- Updates from version 0.3-stable |
| 49 | ||
| f47e2d | 50 | TRUNCATE `messages`; |
| A | 51 | |
| 3d601d | 52 | ALTER TABLE `messages` |
| A | 53 | ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`); |
| b2b8b1 | 54 | |
| V | 55 | ALTER TABLE `session` |
| 56 | CHANGE `vars` `vars` MEDIUMTEXT NOT NULL; | |
| 23b765 | 57 | |
| A | 58 | ALTER TABLE `contacts` |
| 59 | ADD INDEX `user_contacts_index` (`user_id`,`email`); | |
| 8248e4 | 60 | |
| A | 61 | -- Updates from version 0.3.1 |
| 62 | ||
| 63 | /* MySQL bug workaround: http://bugs.mysql.com/bug.php?id=46293 */ | |
| 5cec0c | 64 | /*!40014 SET FOREIGN_KEY_CHECKS=0 */; |
| 8248e4 | 65 | |
| A | 66 | ALTER TABLE `messages` DROP FOREIGN KEY `user_id_fk_messages`; |
| 67 | ALTER TABLE `cache` DROP FOREIGN KEY `user_id_fk_cache`; | |
| 68 | ALTER TABLE `contacts` DROP FOREIGN KEY `user_id_fk_contacts`; | |
| 69 | ALTER TABLE `identities` DROP FOREIGN KEY `user_id_fk_identities`; | |
| 70 | ||
| 71 | ALTER TABLE `messages` ADD CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`) | |
| 94fe9c | 72 | REFERENCES `users`(`user_id`); |
| 8248e4 | 73 | ALTER TABLE `cache` ADD CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`) |
| 94fe9c | 74 | REFERENCES `users`(`user_id`); |
| 8248e4 | 75 | ALTER TABLE `contacts` ADD CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`) |
| 94fe9c | 76 | REFERENCES `users`(`user_id`); |
| 8248e4 | 77 | ALTER TABLE `identities` ADD CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`) |
| 94fe9c | 78 | REFERENCES `users`(`user_id`); |
| 8248e4 | 79 | |
| 951c07 | 80 | ALTER TABLE `contacts` ALTER `name` SET DEFAULT ''; |
| A | 81 | ALTER TABLE `contacts` ALTER `firstname` SET DEFAULT ''; |
| 82 | ALTER TABLE `contacts` ALTER `surname` SET DEFAULT ''; | |
| 83 | ||
| ac756e | 84 | ALTER TABLE `identities` ADD INDEX `user_identities_index` (`user_id`, `del`); |
| a35062 | 85 | ALTER TABLE `identities` ADD `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00' AFTER `user_id`; |
| 94fe9c | 86 | |
| a61bbb | 87 | CREATE TABLE `contactgroups` ( |
| T | 88 | `contactgroup_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, |
| 89 | `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0', | |
| 192413 | 90 | `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| a61bbb | 91 | `del` tinyint(1) NOT NULL DEFAULT '0', |
| T | 92 | `name` varchar(128) NOT NULL DEFAULT '', |
| 93 | PRIMARY KEY(`contactgroup_id`), | |
| 94 | CONSTRAINT `user_id_fk_contactgroups` FOREIGN KEY (`user_id`) | |
| 95 | REFERENCES `users`(`user_id`) ON DELETE CASCADE ON UPDATE CASCADE, | |
| 96 | INDEX `contactgroups_user_index` (`user_id`,`del`) | |
| 97 | ) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */; | |
| 98 | ||
| 99 | CREATE TABLE `contactgroupmembers` ( | |
| 100 | `contactgroup_id` int(10) UNSIGNED NOT NULL, | |
| 101 | `contact_id` int(10) UNSIGNED NOT NULL DEFAULT '0', | |
| 192413 | 102 | `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00', |
| a61bbb | 103 | PRIMARY KEY (`contactgroup_id`, `contact_id`), |
| T | 104 | CONSTRAINT `contactgroup_id_fk_contactgroups` FOREIGN KEY (`contactgroup_id`) |
| 105 | REFERENCES `contactgroups`(`contactgroup_id`) ON DELETE CASCADE ON UPDATE CASCADE, | |
| 106 | CONSTRAINT `contact_id_fk_contacts` FOREIGN KEY (`contact_id`) | |
| 107 | REFERENCES `contacts`(`contact_id`) ON DELETE CASCADE ON UPDATE CASCADE | |
| 108 | ) /*!40000 ENGINE=INNODB */; | |
| 109 | ||
| 5cec0c | 110 | /*!40014 SET FOREIGN_KEY_CHECKS=1 */; |
| e2402e | 111 | |
| A | 112 | -- Updates from version 0.4-beta |
| 113 | ||
| 114 | ALTER TABLE `users` CHANGE `last_login` `last_login` datetime DEFAULT NULL; | |
| 115 | UPDATE `users` SET `last_login` = NULL WHERE `last_login` = '1000-01-01 00:00:00'; | |
