comparison SQL/sqlite/2009090400.sql @ 0:4681f974d28b

vanilla 1.3.3 distro, I hope
author Charlie Root
date Thu, 04 Jan 2018 15:52:31 -0500
parents
children
comparison
equal deleted inserted replaced
-1:000000000000 0:4681f974d28b
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);