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

     1  CREATE TABLE IF NOT EXISTS chat_identity_last_published (
     2    chat_id VARCHAR NOT NULL PRIMARY KEY ON CONFLICT REPLACE,
     3    clock_value INT NOT NULL,
     4    hash BLOB NOT NULL
     5  );
     6  
     7  CREATE TABLE IF NOT EXISTS chat_identity_contacts (
     8    contact_id VARCHAR NOT NULL,
     9    image_type VARCHAR NOT NULL,
    10    clock_value INT NOT NULL,
    11    payload BLOB NOT NULL,
    12    UNIQUE(contact_id, image_type) ON CONFLICT REPLACE
    13  );