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

     1  CREATE TABLE secrets (
     2    identity BLOB NOT NULL PRIMARY KEY ON CONFLICT IGNORE,
     3    secret BLOB NOT NULL
     4  );
     5  
     6  CREATE TABLE secret_installation_ids (
     7    id TEXT NOT NULL,
     8    identity_id BLOB NOT NULL,
     9    UNIQUE(id, identity_id) ON CONFLICT IGNORE,
    10    FOREIGN KEY (identity_id) REFERENCES secrets(identity)
    11  );