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

     1  CREATE TABLE IF NOT EXISTS user_messages_deleted_for_mes_bk (
     2      clock      INTEGER NOT NULL,
     3      message_id VARCHAR NOT NULL,
     4      PRIMARY KEY (message_id)
     5  );
     6  
     7  INSERT OR REPLACE INTO user_messages_deleted_for_mes_bk SELECT clock, message_id FROM user_messages_deleted_for_mes;
     8  
     9  DROP TABLE user_messages_deleted_for_mes;
    10  
    11  ALTER TABLE user_messages_deleted_for_mes_bk RENAME TO user_messages_deleted_for_mes;