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

     1  CREATE TABLE contact_requests (
     2    signing_key VARCHAR NOT NULL,
     3    contact_key VARCHAR NOT NULL,
     4    signature BLOB NOT NULL,
     5    timestamp INT NOT NULL,
     6    PRIMARY KEY (signing_key, contact_key)
     7  );
     8  
     9  ALTER TABLE contacts ADD COLUMN contact_message_id VARCHAR;
    10  ALTER TABLE contacts ADD COLUMN contact_request_clock INT;
    11  ALTER TABLE user_messages ADD COLUMN contact_request_state INT;
    12  
    13  CREATE INDEX contact_request_state ON user_messages(contact_request_state);