- added index in messages table
| | |
| | | `structure` text, |
| | | PRIMARY KEY(`message_id`), |
| | | INDEX `created_index` (`created`), |
| | | INDEX `index_index` (`user_id`, `cache_key`, `idx`), |
| | | UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`), |
| | | CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`) |
| | | REFERENCES `users`(`user_id`) |
| | |
| | | |
| | | ALTER TABLE `users` |
| | | CHANGE `language` `language` varchar(5); |
| | | |
| | | -- Updates from version 0.3-stable |
| | | |
| | | ALTER TABLE `messages` |
| | | ADD INDEX `index_index` (`user_id`, `cache_key`, `idx`); |
| | |
| | | ); |
| | | |
| | | ALTER TABLE messages ADD UNIQUE (user_id, cache_key, uid); |
| | | CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx); |
| | | CREATE INDEX messages_created_idx ON messages (created); |
| | |
| | | ALTER TABLE identities ALTER standard TYPE smallint; |
| | | ALTER TABLE contacts ALTER del TYPE smallint; |
| | | ALTER TABLE messages ALTER del TYPE smallint; |
| | | |
| | | -- Updates from version 0.3-stable |
| | | |
| | | CREATE INDEX messages_index_idx ON messages (user_id, cache_key, idx); |
| | |
| | | structure text |
| | | ); |
| | | |
| | | CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,uid); |
| | | CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid); |
| | | CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx); |
| | | CREATE INDEX ix_messages_created ON messages (created); |
| | |
| | | |
| | | CREATE INDEX ix_session_changed ON session (changed); |
| | | CREATE INDEX ix_cache_created ON cache (created); |
| | | |
| | | -- Updates from version 0.3-stable |
| | | |
| | | DROP INDEX ix_messages_user_cache_uid; |
| | | CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid); |
| | | CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx); |