github.com/status-im/status-go@v1.1.0/appdatabase/migrations/sql/1647956635_add_waku_messages_table.up.sql (about)

     1  CREATE TABLE waku_messages (
     2    sig BLOB NOT NULL,
     3    timestamp INT NOT NULL,
     4    topic TEXT NOT NULL,
     5    payload BLOB NOT NULL,
     6    padding BLOB NOT NULL,
     7    hash TEXT PRIMARY KEY NOT NULL
     8  );
     9  
    10  CREATE INDEX waku_messages_timestamp_topic ON waku_messages (timestamp, topic);