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

     1  CREATE TABLE communities_requests_to_join  (
     2    id BLOB NOT NULL,
     3    public_key VARCHAR NOT NULL,
     4    clock INT NOT NULL,
     5    ens_name VARCHAR NOT NULL DEFAULT "",
     6    chat_id VARCHAR NOT NULL DEFAULT "",
     7    community_id BLOB NOT NULL,
     8    state INT NOT NULL DEFAULT 0,
     9    PRIMARY KEY (id) ON CONFLICT REPLACE
    10  );
    11  
    12  
    13  CREATE TABLE ens_verification_records (
    14    public_key VARCHAR NOT NULL,
    15    name VARCHAR NOT NULL,
    16    verified BOOLEAN NOT NULL DEFAULT FALSE,
    17    verified_at INT NOT NULL DEFAULT 0,
    18    clock INT NOT NULL DEFAULT 0,
    19    verification_retries INT NOT NULL DEFAULT 0,
    20    next_retry INT NOT NULL DEFAULT 0,
    21    PRIMARY KEY (public_key) ON CONFLICT REPLACE
    22  );
    23  
    24  INSERT INTO ens_verification_records (public_key, name, verified, verified_at, clock) SELECT id, name, ens_verified, ens_verified_at, ens_verified_at FROM contacts WHERE ens_verified;