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

     1  CREATE TABLE hash_ratchet_encryption (
     2    group_id BLOB NOT NULL,
     3    key_id INT NOT NULL,
     4    key BLOB NOT NULL,
     5    PRIMARY KEY(group_id, key_id)
     6  );
     7  
     8  CREATE UNIQUE INDEX idx_hash_ratchet_enc ON hash_ratchet_encryption(group_id, key_id);
     9  
    10  CREATE TABLE hash_ratchet_encryption_cache (
    11    group_id BLOB NOT NULL,
    12    key_id int NOT NULL,
    13    seq_no INTEGER,
    14    hash BLOB NOT NULL,
    15    sym_enc_key BLOB,
    16    FOREIGN KEY(group_id, key_id) REFERENCES hash_ratchet_encryption(group_id, key_id)
    17  );
    18  
    19  CREATE UNIQUE INDEX idx_hash_ratchet_enc_cache ON hash_ratchet_encryption_cache(group_id, key_id, seq_no);
    20