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

     1  CREATE TABLE hash_ratchet_encrypted_messages (
     2    hash BLOB PRIMARY KEY ON CONFLICT REPLACE,
     3    sig BLOB NOT NULL,
     4    TTL INT NOT NULL,
     5    timestamp INT NOT NULL,
     6    topic BLOB NOT NULL,
     7    payload BLOB NOT NULL,
     8    dst BLOB,
     9    p2p BOOLEAN,
    10    group_id BLOB NOT NULL,
    11    key_id INT NOT NULL
    12  );
    13  
    14  CREATE INDEX hash_ratchet_encrypted_messages_group_id_key_id ON hash_ratchet_encrypted_messages(group_id, key_id);
    15