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

     1  ALTER TABLE contacts ADD COLUMN verification_status INT DEFAULT 0;
     2  
     3  UPDATE contacts SET verification_status = 0;  
     4  
     5  CREATE TABLE IF NOT EXISTS trusted_users (
     6    id TEXT PRIMARY KEY ON CONFLICT REPLACE,
     7    trust_status INT NOT NULL DEFAULT 0,
     8    updated_at INT NOT NULL DEFAULT 0
     9  ) WITHOUT ROWID;
    10  
    11  CREATE TABLE IF NOT EXISTS verification_requests (
    12    from_user TEXT,
    13    to_user TEXT,
    14    challenge TEXT NOT NULL,
    15    requested_at INT NOT NULL DEFAULT 0,
    16    response TEXT,
    17    replied_at INT NOT NULL DEFAULT 0,
    18    verification_status INT NOT NULL DEFAULT 0,
    19    CONSTRAINT fromto_unique UNIQUE (from_user, to_user) ON CONFLICT REPLACE
    20  );