Mercurial > hg > rc1
annotate SQL/sqlite/2009090400.sql @ 40:3ea4a836c377
tweaks
author | Charlie Root |
---|---|
date | Fri, 24 Jan 2025 14:16:58 -0500 |
parents | 1e000243b222 |
children |
rev | line source |
---|---|
0 | 1 -- Updates from version 0.3-stable |
2 | |
3 DELETE FROM messages; | |
4 DROP INDEX ix_messages_user_cache_uid; | |
5 CREATE UNIQUE INDEX ix_messages_user_cache_uid ON messages (user_id,cache_key,uid); | |
6 CREATE INDEX ix_messages_index ON messages (user_id,cache_key,idx); | |
7 DROP INDEX ix_contacts_user_id; | |
8 CREATE INDEX ix_contacts_user_id ON contacts(user_id, email); |