status-im/status-go

View on GitHub
protocol/migrations/sqlite/1599720851_add_seen_index_remove_long_messages.up.sql

Summary

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