github.com/status-im/status-go@v1.1.0/protocol/migrations/sqlite/1682528339_add_index_user_messages_unseen.up.sql (about)

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