github.com/status-im/status-go@v1.1.0/protocol/encryption/migrations/sqlite/1698137564_add_migration_index.up.sql (about)

     1  CREATE INDEX IF NOT EXISTS idx_group_timestamp_desc
     2  ON hash_ratchet_encryption (group_id, key_timestamp DESC);
     3  
     4  CREATE INDEX IF NOT EXISTS idx_hash_ratchet_encryption_keys_key_id
     5  ON hash_ratchet_encryption (key_id);
     6  
     7  CREATE INDEX IF NOT EXISTS idx_hash_ratchet_encryption_keys_deprecated_key_id
     8  ON hash_ratchet_encryption (deprecated_key_id);
     9  
    10  CREATE INDEX IF NOT EXISTS idx_hash_ratchet_cache_group_id_key_id_seq_no
    11  ON hash_ratchet_encryption_cache (group_id, key_id, seq_no DESC);