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

     1  ALTER TABLE user_messages ADD COLUMN contact_verification_status INT;
     2  ALTER TABLE activity_center_notifications ADD COLUMN contact_verification_status INT DEFAULT 0;
     3  
     4  DROP TABLE verification_requests;
     5  
     6  CREATE TABLE IF NOT EXISTS verification_requests_individual (
     7    from_user TEXT,
     8    to_user TEXT,
     9    challenge TEXT NOT NULL,
    10    requested_at INT NOT NULL DEFAULT 0,
    11    response TEXT,
    12    replied_at INT NOT NULL DEFAULT 0,
    13    verification_status INT NOT NULL DEFAULT 0,
    14    id TEXT PRIMARY KEY ON CONFLICT REPLACE
    15  );