github.com/status-im/status-go@v1.1.0/walletdatabase/migrations/sql/1716912885_add_wallet_connect_dapps.up.sql (about)

     1  -- wallet_connect_dapps table keeps track of connected dApps to provide a link to their individual sessions
     2  CREATE TABLE IF NOT EXISTS wallet_connect_dapps (
     3      url TEXT PRIMARY KEY,
     4      name TEXT NOT NULL,
     5      icon_url TEXT
     6  ) WITHOUT ROWID;
     7  
     8  DROP TABLE wallet_connect_sessions;
     9  
    10  -- wallet_connect_sessions table keeps track of connected sessions for each dApp
    11  CREATE TABLE wallet_connect_sessions (
    12      topic TEXT PRIMARY KEY NOT NULL,
    13      disconnected BOOLEAN NOT NULL,
    14      session_json JSON NOT NULL,
    15      expiry INTEGER NOT NULL,
    16      created_timestamp INTEGER NOT NULL,
    17      pairing_topic TEXT NOT NULL,
    18      test_chains BOOLEAN NOT NULL,
    19      dapp_url TEXT NOT NULL,
    20      FOREIGN KEY (dapp_url) REFERENCES wallet_connect_dapps(url)
    21  ) WITHOUT ROWID;