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

     1  DELETE FROM sessions;
     2  DELETE FROM keys;
     3  DROP TABLE ratchet_info;
     4  
     5  CREATE TABLE ratchet_info_v2 (
     6    bundle_id BLOB NOT NULL,
     7    ephemeral_key BLOB,
     8    identity BLOB NOT NULL,
     9    symmetric_key BLOB NOT NULL,
    10    installation_id TEXT NOT NULL,
    11    UNIQUE(bundle_id, identity, installation_id) ON CONFLICT REPLACE,
    12    FOREIGN KEY (bundle_id) REFERENCES bundles(signed_pre_key)
    13  );