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

     1  CREATE TABLE IF NOT EXISTS dapps_2 (
     2      id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
     3      name TEXT,
     4      address TEXT NOT NULL default "",
     5      CONSTRAINT unique_dapps_name_address UNIQUE (name,address)
     6  );
     7  
     8  CREATE TABLE IF NOT EXISTS permissions_2 (
     9      dapp_id int NOT NULL,
    10      permission TEXT NOT NULL,
    11      FOREIGN KEY(dapp_id) REFERENCES dapps_2(id) ON DELETE CASCADE
    12  );
    13  
    14  INSERT INTO dapps_2 SELECT NULL, name, "" FROM dapps;
    15  
    16  INSERT INTO permissions_2 select dapps_2.id, permissions.permission from permissions join dapps_2 on dapps_2.name = permissions.dapp_name;
    17  
    18  DROP TABLE permissions;
    19  DROP TABLE dapps;
    20  
    21  ALTER TABLE permissions_2 RENAME TO permissions;
    22  ALTER TABLE dapps_2 RENAME TO dapps;