status-go/walletdatabase/migrations/sql/1715839555_rename_chain_pre...

2 lines
259 B
SQL

UPDATE saved_addresses SET chain_short_names = REPLACE(chain_short_names, 'arb:', 'arb1:') WHERE chain_short_names LIKE '%arb:%';
UPDATE saved_addresses SET chain_short_names = REPLACE(chain_short_names, 'opt:', 'oeth:') WHERE chain_short_names LIKE '%opt:%';