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

     1  ALTER TABLE message_segments RENAME TO old_message_segments;
     2  
     3  CREATE TABLE message_segments (
     4      hash BLOB NOT NULL,
     5      segment_index INTEGER NOT NULL,
     6      segments_count INTEGER NOT NULL,
     7      payload BLOB NOT NULL,
     8      sig_pub_key BLOB NOT NULL,
     9      timestamp INTEGER NOT NULL,
    10      parity_segment_index INTEGER NOT NULL,
    11      parity_segments_count INTEGER NOT NULL,
    12      PRIMARY KEY (hash, sig_pub_key, segment_index, segments_count, parity_segment_index, parity_segments_count) ON CONFLICT REPLACE
    13  );
    14  
    15  INSERT INTO message_segments (hash, segment_index, segments_count, payload, sig_pub_key, timestamp, parity_segment_index, parity_segments_count)
    16  SELECT hash, segment_index, segments_count, payload, sig_pub_key, timestamp, 0, 0
    17  FROM old_message_segments;
    18  
    19  DROP TABLE old_message_segments;