status-go/protocol/migrations/sqlite/1682528339_add_index_user_m...

4 lines
104 B
MySQL
Raw Permalink Normal View History

CREATE INDEX
idx_user_messages_unseen ON user_messages (local_chat_id, clock_value)
WHERE NOT(seen)