github.com/status-im/status-go@v1.1.0/appdatabase/migrations/sql/1682393575_sync_ens_name.up.sql (about)

     1  ALTER TABLE settings_sync_clock ADD COLUMN usernames INTEGER NOT NULL DEFAULT 0;
     2  
     3  -- we need remove duplicate records since ens.AddEnsUsername(INSERT OR REPLACE INTO ens_usernames) may inserted duplicate records
     4  CREATE TABLE ens_usernames_temp AS SELECT DISTINCT username, chain_id FROM ens_usernames;
     5  DROP TABLE ens_usernames;
     6  ALTER TABLE ens_usernames_temp RENAME TO ens_usernames;
     7  
     8  -- we need add unique index to avoid duplicate records, or we can say it will make `INSERT OR REPLACE INTO` work
     9  CREATE UNIQUE INDEX idx_unique_username_chain_id ON ens_usernames (username, chain_id);
    10  
    11  ALTER TABLE ens_usernames ADD COLUMN clock INT DEFAULT 0;
    12  ALTER TABLE ens_usernames ADD COLUMN removed BOOLEAN DEFAULT FALSE;