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

     1  ALTER TABLE raw_messages ADD COLUMN sender BLOB;
     2  ALTER TABLE raw_messages ADD COLUMN community_id BLOB;
     3  ALTER TABLE raw_messages ADD COLUMN resend_type INT DEFAULT 0;
     4  ALTER TABLE raw_messages ADD COLUMN resend_method INT DEFAULT 0;
     5  ALTER TABLE raw_messages ADD COLUMN pubsub_topic VARCHAR DEFAULT '';
     6  ALTER TABLE raw_messages ADD COLUMN hash_ratchet_group_id BLOB;
     7  ALTER TABLE raw_messages ADD COLUMN community_key_ex_msg_type INT DEFAULT 0;
     8  
     9  DROP INDEX IF EXISTS idx_resend_automatically;
    10  CREATE INDEX idx_resend_type ON raw_messages(resend_type);
    11  ALTER TABLE raw_messages DROP COLUMN resend_automatically;