commit | author | age | ||
b7e7c8 | 1 | -- Updates from version 0.1-stable |
AM | 2 | |
3 | TRUNCATE TABLE `messages`; | |
4 | ||
5 | ALTER TABLE `messages` | |
6 | DROP INDEX `idx`, | |
7 | DROP INDEX `uid`; | |
8 | ||
9 | ALTER TABLE `cache` | |
10 | DROP INDEX `cache_key`, | |
11 | DROP INDEX `session_id`, | |
12 | ADD INDEX `user_cache_index` (`user_id`,`cache_key`); | |
13 | ||
14 | ALTER TABLE `users` | |
15 | ADD INDEX `username_index` (`username`), | |
16 | ADD INDEX `alias_index` (`alias`); |