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

     1  CREATE TABLE IF NOT EXISTS saved_addresses_new (
     2    address VARCHAR NOT NULL,
     3    name TEXT NOT NULL,
     4    favourite BOOLEAN NOT NULL DEFAULT FALSE,
     5    removed BOOLEAN NOT NULL DEFAULT FALSE,
     6    update_clock INT NOT NULL DEFAULT 0,
     7    chain_short_names VARCHAR DEFAULT "",
     8    ens_name VARCHAR DEFAULT "",
     9    is_test BOOLEAN DEFAULT FALSE,
    10    PRIMARY KEY (address, ens_name, is_test)
    11  ) WITHOUT ROWID;
    12  
    13  INSERT INTO saved_addresses_new (address, name, favourite, removed, update_clock)
    14     SELECT address, name, favourite, removed, update_clock FROM saved_addresses;
    15  DROP TABLE saved_addresses;
    16  ALTER TABLE saved_addresses_new RENAME TO saved_addresses;