github.com/status-im/status-go@v1.1.0/appdatabase/migrationsprevnodecfg/sql/0001_app.up.sql (about)

     1  CREATE TABLE IF NOT EXISTS settings (
     2  type VARCHAR PRIMARY KEY,
     3  value BLOB
     4  ) WITHOUT ROWID;
     5  
     6  CREATE TABLE IF NOT EXISTS accounts (
     7  address VARCHAR PRIMARY KEY,
     8  wallet BOOLEAN,
     9  chat BOOLEAN,
    10  type TEXT,
    11  storage TEXT,
    12  pubkey BLOB,
    13  path TEXT,
    14  name TEXT,
    15  color TEXT,
    16  created_at DATETIME NOT NULL,
    17  updated_at DATETIME NOT NULL
    18  ) WITHOUT ROWID;
    19  
    20  CREATE UNIQUE INDEX unique_wallet_address ON accounts (wallet) WHERE (wallet);
    21  CREATE UNIQUE INDEX unique_chat_address ON accounts (chat) WHERE (chat);
    22  CREATE INDEX created_at_account ON accounts (created_at) WHERE (created_at);
    23  
    24  CREATE TABLE IF NOT EXISTS browsers (
    25  id TEXT PRIMARY KEY,
    26  name TEXT NOT NULL,
    27  timestamp USGIGNED BIGINT,
    28  dapp BOOLEAN DEFAULT false,
    29  historyIndex UNSIGNED INT
    30  ) WITHOUT ROWID;
    31  
    32  CREATE TABLE IF NOT EXISTS browsers_history (
    33  browser_id TEXT NOT NULL,
    34  history TEXT,
    35  FOREIGN KEY(browser_id) REFERENCES browsers(id) ON DELETE CASCADE
    36  );
    37  
    38  CREATE TABLE IF NOT EXISTS dapps (
    39  name TEXT PRIMARY KEY
    40  ) WITHOUT ROWID;
    41  
    42  CREATE TABLE IF NOT EXISTS permissions (
    43  dapp_name TEXT NOT NULL,
    44  permission TEXT NOT NULL,
    45  FOREIGN KEY(dapp_name) REFERENCES dapps(name) ON DELETE CASCADE
    46  );
    47  
    48  
    49  CREATE TABLE IF NOT EXISTS transfers (
    50  network_id UNSIGNED BIGINT NOT NULL,
    51  hash VARCHAR NOT NULL,
    52  address VARCHAR NOT NULL,
    53  blk_hash VARCHAR NOT NULL,
    54  tx BLOB,
    55  sender VARCHAR,
    56  receipt BLOB,
    57  log BLOB,
    58  type VARCHAR NOT NULL,
    59  blk_number BIGINT NOT NULL,
    60  timestamp UNSIGNED BIGINT NOT NULL,
    61  loaded BOOL DEFAULT 1,
    62  FOREIGN KEY(network_id,address,blk_hash) REFERENCES blocks(network_id,address,blk_hash) ON DELETE CASCADE,
    63  CONSTRAINT unique_transfer_per_address_per_network UNIQUE (hash,address,network_id)
    64  );
    65  
    66  CREATE TABLE IF NOT EXISTS blocks (
    67  network_id UNSIGNED BIGINT NOT NULL,
    68  address VARCHAR NOT NULL,
    69  blk_number BIGINT NOT NULL,
    70  blk_hash BIGINT NOT NULL,
    71  loaded BOOL DEFAULT FALSE,
    72  CONSTRAINT unique_mapping_for_account_to_block_per_network UNIQUE (address,blk_hash,network_id)
    73  );
    74  
    75  CREATE TABLE IF NOT EXISTS blocks_ranges (
    76  network_id UNSIGNED BIGINT NOT NULL,
    77  address VARCHAR NOT NULL,
    78  blk_from BIGINT NOT NULL,
    79  blk_to BIGINT NOT NULL
    80  );
    81  
    82  CREATE TABLE IF NOT EXISTS mailservers (
    83      id VARCHAR PRIMARY KEY,
    84      name VARCHAR NOT NULL,
    85      address VARCHAR NOT NULL,
    86      password VARCHAR,
    87      fleet VARCHAR NOT NULL
    88  ) WITHOUT ROWID;
    89  
    90  CREATE TABLE IF NOT EXISTS mailserver_request_gaps (
    91      gap_from UNSIGNED INTEGER NOT NULL,
    92      gap_to UNSIGNED INTEGER NOT NULL,
    93      id TEXT PRIMARY KEY,
    94      chat_id TEXT NOT NULL
    95  ) WITHOUT ROWID;
    96  
    97  CREATE INDEX mailserver_request_gaps_chat_id_idx ON mailserver_request_gaps (chat_id);
    98  
    99  CREATE TABLE IF NOT EXISTS mailserver_topics (
   100      topic VARCHAR PRIMARY KEY,
   101      chat_ids VARCHAR,
   102      last_request INTEGER DEFAULT 1,
   103      discovery BOOLEAN DEFAULT FALSE,
   104      negotiated BOOLEAN DEFAULT FALSE
   105  ) WITHOUT ROWID;
   106  
   107  CREATE TABLE IF NOT EXISTS mailserver_chat_request_ranges (
   108      chat_id VARCHAR PRIMARY KEY,
   109      lowest_request_from INTEGER,
   110      highest_request_to INTEGER
   111  ) WITHOUT ROWID;