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

     1  -- See TxStatus in transactions/pendingtxtracker.go
     2  ALTER TABLE pending_transactions ADD status TEXT NOT NULL DEFAULT "Pending";
     3  
     4  -- The watcher will auto delete the pending txs that are confirmed or failed
     5  -- Else the producer module will have to delete them manually on processing
     6  ALTER TABLE pending_transactions ADD COLUMN auto_delete BOOLEAN NOT NULL DEFAULT 1;
     7  
     8  DROP INDEX idx_pending_transactions;
     9  
    10  CREATE INDEX idx_pending_transactions
    11  ON pending_transactions (multi_transaction_id, from_address, to_address, network_id, timestamp, symbol, type, status, auto_delete);