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

     1  CREATE TABLE IF NOT EXISTS keycards (
     2      keycard_uid VARCHAR NOT NULL PRIMARY KEY,
     3      keycard_name VARCHAR NOT NULL,
     4      keycard_locked BOOLEAN DEFAULT FALSE,
     5      key_uid VARCHAR NOT NULL
     6  );
     7  
     8  CREATE TABLE IF NOT EXISTS keycards_accounts (
     9      keycard_uid VARCHAR NOT NULL,
    10      account_address VARCHAR NOT NULL,
    11      FOREIGN KEY(keycard_uid) REFERENCES keycards(keycard_uid) 
    12        ON UPDATE CASCADE 
    13        ON DELETE CASCADE    
    14  );
    15  
    16  INSERT INTO keycards select distinct keycard_uid, keycard_name, keycard_locked, key_uid from keypairs;
    17  
    18  INSERT INTO keycards_accounts select keycard_uid, account_address from keypairs;
    19  
    20  DROP TABLE keypairs;