github.com/status-im/status-go@v1.1.0/protocol/migrations/sqlite/1615374373_add_confirmations.up.sql (about) 1 CREATE TABLE raw_message_confirmations ( 2 datasync_id BLOB NOT NULL, 3 message_id BLOB NOT NULL, 4 public_key BLOB NOT NULL, 5 confirmed_at INT NOT NULL DEFAULT 0, 6 PRIMARY KEY (message_id, public_key) ON CONFLICT REPLACE 7 );