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

     1  CREATE INDEX IF NOT EXISTS seen_local_chat_id_idx ON user_messages(local_chat_id, seen);
     2  UPDATE user_messages SET hide = 1 WHERE length(text) > 4096;