-- Downgrades from version 0.3.1

DELETE FROM messages;
DROP INDEX ix_messages_user_cache_uid;
CREATE INDEX ix_messages_user_cache_uid ON messages(user_id,cache_key,uid);
-- pek: version 0.3.1 update added a UNIQUE constraint that this drops

DROP INDEX ix_messages_index;

DROP INDEX ix_contacts_user_id;
CREATE INDEX ix_contacts_user_id ON contacts(user_id);
-- pek: version 0.3.1 added email to the index


