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

     1  CREATE TABLE IF NOT EXISTS store_messages (
     2  	id BLOB,
     3  	receiverTimestamp INTEGER NOT NULL,
     4  	senderTimestamp INTEGER NOT NULL,
     5  	contentTopic BLOB NOT NULL,
     6  	pubsubTopic BLOB NOT NULL,
     7  	payload BLOB,
     8  	version INTEGER NOT NULL DEFAULT 0,
     9  	CONSTRAINT messageIndex PRIMARY KEY (id, pubsubTopic)
    10  ) WITHOUT ROWID;
    11  
    12  CREATE INDEX IF NOT EXISTS store_message_senderTimestamp ON store_messages(senderTimestamp);
    13  CREATE INDEX IF NOT EXISTS store_message_receiverTimestamp ON store_messages(receiverTimestamp);