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

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