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

     1  CREATE TABLE hash_ratchet_encryption_v2 (
     2    group_id BLOB NOT NULL,
     3    deprecated_key_id INT NOT NULL,
     4    key BLOB NOT NULL,
     5    key_timestamp BLOB,
     6    key_id BLOB NOT NULL,
     7    PRIMARY KEY(key_id) ON CONFLICT REPLACE
     8  );
     9  
    10  INSERT INTO hash_ratchet_encryption_v2(group_id, deprecated_key_id, key, key_id) SELECT group_id, key_id, key, group_id || key_id FROM hash_ratchet_encryption;
    11  
    12  DROP TABLE hash_ratchet_encryption_cache;
    13  
    14  DROP TABLE hash_ratchet_encryption;
    15  
    16  ALTER TABLE hash_ratchet_encryption_v2 RENAME TO hash_ratchet_encryption;
    17  
    18  UPDATE hash_ratchet_encryption SET key_timestamp = deprecated_key_id;
    19  
    20  CREATE TABLE hash_ratchet_encryption_cache (
    21    group_id BLOB NOT NULL,
    22    key_id int NOT NULL,
    23    seq_no INTEGER,
    24    hash BLOB NOT NULL,
    25    sym_enc_key BLOB
    26  );