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

     1  ALTER TABLE pending_transactions RENAME TO pending_transactions_old;
     2  
     3  CREATE TABLE IF NOT EXISTS pending_transactions (
     4    network_id UNSIGNED BIGINT NOT NULL,
     5    hash VARCHAR NOT NULL,
     6    timestamp UNSIGNED BIGINT NOT NULL,
     7    from_address VARCHAR NOT NULL,
     8    to_address VARCHAR,
     9    symbol VARCHAR,
    10    gas_price BLOB,
    11    gas_limit BLOB,
    12    value BLOB,
    13    data TEXT,
    14    type VARCHAR,
    15    additional_data TEXT,
    16    PRIMARY KEY (network_id, hash)
    17  ) WITHOUT ROWID;
    18  
    19  INSERT INTO pending_transactions(network_id, hash, from_address, to_address, type, additional_data, timestamp)
    20  SELECT network_id, transaction_hash, from_address, to_address, type, data, 0 FROM pending_transactions_old;
    21  
    22  DROP TABLE pending_transactions_old;