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

     1  -- One entry per chain_id, address, currency, block
     2  -- balance is a serialized big.Int
     3  CREATE TABLE IF NOT EXISTS balance_history_v2 (
     4      chain_id UNSIGNED BIGINT NOT NULL,
     5      address VARCHAR NOT NULL,
     6      currency VARCHAR NOT NULL,
     7      block BIGINT NOT NULL,
     8      timestamp INT NOT NULL,
     9      balance BLOB
    10  );
    11  
    12  CREATE UNIQUE INDEX IF NOT EXISTS balance_history_identify_entry ON balance_history_v2 (chain_id, address, currency, block);
    13  CREATE INDEX IF NOT EXISTS balance_history_filter_entries ON balance_history_v2 (chain_id, address, currency, block, timestamp);
    14  
    15  DROP TABLE balance_history;
    16  ALTER TABLE balance_history_v2 RENAME TO balance_history;
    17