status-im/status-go

protocol/migrations/sqlite/1715163262_rename_peersyncing_group_id_field.up.sql

Summary

Maintainability

Test Coverage

Issues

DROP INDEX IF EXISTS peersyncing_messages_timestamp;

ALTER TABLE peersyncing_messages RENAME COLUMN group_id TO chat_id;

CREATE INDEX peersyncing_messages_timestamp ON peersyncing_messages(chat_id, timestamp);