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

     1  ALTER TABLE chats ADD COLUMN read_messages_at_clock_value INT DEFAULT 0;
     2  UPDATE chats SET read_messages_at_clock_value = 0;
     3  CREATE INDEX local_chat_id_seen_mentioned_clock_value_idx ON user_messages(local_chat_id, seen, mentioned, clock_value);