status-im/status-go

View on GitHub
protocol/migrations/sqlite/1682528339_add_index_user_messages_unseen.up.sql

Summary

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