code.vegaprotocol.io/vega@v0.79.0/datanode/sqlstore/migrations/0053_fee_transfers.sql (about)

     1  -- +goose Up
     2  
     3  -- transfer_fees table contains the fees paid on transfers. Epoch is 0 for one-off transfers.
     4  CREATE TABLE IF NOT EXISTS transfer_fees (
     5        transfer_id bytea NOT NULL,
     6        amount HUGEINT NOT NULL,
     7        epoch_seq BIGINT NOT NULL,
     8        vega_time TIMESTAMP WITH time zone NOT NULL,
     9        PRIMARY KEY (vega_time, transfer_id)
    10  );
    11  
    12  CREATE INDEX transfer_fees_transfer_id_idx ON transfer_fees(transfer_id);
    13  
    14  -- +goose Down
    15  DROP INDEX transfer_fees_transfer_id_idx;
    16  DROP TABLE IF EXISTS transfer_fees;