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

     1  CREATE TABLE keypairs_accounts_t1 (
     2      id         INTEGER PRIMARY KEY AUTOINCREMENT,
     3      address    VARCHAR,
     4      key_uid    VARCHAR,
     5      pubkey     VARCHAR,
     6      path       VARCHAR  NOT NULL DEFAULT "",
     7      name       VARCHAR  NOT NULL DEFAULT "",
     8      color      VARCHAR  NOT NULL DEFAULT "",
     9      emoji      VARCHAR  NOT NULL DEFAULT "",
    10      wallet     BOOL     NOT NULL DEFAULT FALSE,
    11      chat       BOOL     NOT NULL DEFAULT FALSE,
    12      hidden     BOOL     NOT NULL DEFAULT FALSE,
    13      operable   VARCHAR  NOT NULL DEFAULT "no",
    14      created_at DATETIME NOT NULL,
    15      updated_at DATETIME NOT NULL,
    16      clock      INT      NOT NULL DEFAULT 0
    17  );
    18  
    19  INSERT INTO keypairs_accounts_t1(address,key_uid,pubkey,path,name,color,emoji,wallet,chat,hidden,operable,created_at,updated_at,clock) SELECT
    20     address,
    21     key_uid,
    22     pubkey,
    23     path,
    24     name,
    25     color,
    26     emoji,
    27     wallet,
    28     chat,
    29     hidden,
    30     operable,
    31     created_at,
    32     updated_at,
    33     clock
    34  FROM keypairs_accounts ORDER BY created_at;
    35  
    36  CREATE TABLE keypairs_accounts_t2 (
    37     address    VARCHAR PRIMARY KEY,
    38     key_uid    VARCHAR,
    39     pubkey     VARCHAR,
    40     path       VARCHAR  NOT NULL DEFAULT "",
    41     name       VARCHAR  NOT NULL DEFAULT "",
    42     color      VARCHAR  NOT NULL DEFAULT "",
    43     emoji      VARCHAR  NOT NULL DEFAULT "",
    44     wallet     BOOL     NOT NULL DEFAULT FALSE,
    45     chat       BOOL     NOT NULL DEFAULT FALSE,
    46     hidden     BOOL     NOT NULL DEFAULT FALSE,
    47     operable   VARCHAR  NOT NULL DEFAULT "no",
    48     created_at DATETIME NOT NULL,
    49     updated_at DATETIME NOT NULL,
    50     clock      INT      NOT NULL DEFAULT 0,
    51     position   INT      NOT NULL DEFAULT 0,
    52     FOREIGN KEY (key_uid) REFERENCES keypairs (key_uid) ON DELETE CASCADE
    53  );
    54  
    55  INSERT INTO keypairs_accounts_t2 SELECT
    56     address,
    57     key_uid,
    58     pubkey,
    59     path,
    60     name,
    61     color,
    62     emoji,
    63     wallet,
    64     chat,
    65     hidden,
    66     operable,
    67     created_at,
    68     updated_at,
    69     clock,
    70     id
    71  FROM keypairs_accounts_t1;
    72  
    73  DROP TABLE keypairs_accounts;
    74  DROP TABLE keypairs_accounts_t1;
    75  
    76  ALTER TABLE keypairs_accounts_t2 RENAME TO keypairs_accounts;