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

     1  ALTER TABLE communities_communities ADD COLUMN control_node BLOB;
     2  CREATE TABLE communities_validate_signer (
     3    id BLOB NOT NULL,
     4    clock INT NOT NULL,
     5    payload BLOB NOT NULL,
     6    validate_at INT NOT NULL,
     7    signer BLOB NOT NULL,
     8    PRIMARY KEY(id, signer) ON CONFLICT REPLACE
     9  );
    10  
    11  CREATE INDEX communities_validate_signer_clock ON communities_validate_signer(validate_at, clock);