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

     1  ALTER TABLE user_messages ADD COLUMN edited_at INTEGER;
     2  
     3  CREATE TABLE user_messages_edits (
     4    clock INTEGER NOT NULL,
     5    chat_id VARCHAR NOT NULL,
     6    message_id VARCHAR NOT NULL,
     7    source VARCHAR NOT NULL,
     8    text VARCHAR NOT NULL,
     9    id VARCHAR NOT NULL,
    10    PRIMARY KEY(id)
    11  );
    12  
    13  CREATE INDEX user_messages_edits_message_id_source ON user_messages_edits(message_id, source);