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

     1  INSERT INTO keycards (keycard_uid, keycard_name, keycard_locked, key_uid, position)
     2  SELECT
     3      s.keycard_instance_uid,
     4      s.name,
     5      0 AS keycard_locked,
     6      s.key_uid,
     7      0 AS position
     8  FROM settings s
     9  WHERE s.keycard_instance_uid IS NOT NULL
    10    AND s.keycard_instance_uid NOT IN (SELECT keycard_uid FROM keycards);
    11  
    12  INSERT INTO keycards_accounts (keycard_uid, account_address)
    13  SELECT
    14      k.keycard_uid,
    15      kpa.address
    16  FROM keypairs_accounts kpa
    17  JOIN keycards k ON k.key_uid = kpa.key_uid
    18  WHERE kpa.chat = 0
    19    AND kpa.key_uid IN (SELECT key_uid FROM settings WHERE keycard_instance_uid IS NOT NULL)
    20    AND NOT EXISTS (
    21          SELECT 1
    22          FROM keycards_accounts ka
    23          WHERE ka.account_address = kpa.address
    24      );