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

     1  CREATE TABLE IF NOT EXISTS message_segments (
     2      hash BLOB NOT NULL,
     3      segment_index INTEGER NOT NULL,
     4      segments_count INTEGER NOT NULL,
     5      payload BLOB NOT NULL,
     6      sig_pub_key BLOB NOT NULL,
     7      PRIMARY KEY (hash, sig_pub_key, segment_index) ON CONFLICT REPLACE
     8  );
     9  
    10  CREATE TABLE IF NOT EXISTS message_segments_completed (
    11      hash BLOB NOT NULL,
    12      sig_pub_key BLOB NOT NULL,
    13      PRIMARY KEY (hash, sig_pub_key)
    14  );