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