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

     1  -- +goose Up
     2  
     3  -- paid_liquidity_fees stores the per-epoch accumulated paid fees
     4  create table if not exists paid_liquidity_fees (
     5        market_id bytea not null,
     6        asset_id bytea not null,
     7        epoch_seq bigint not null,
     8        total_fees_paid text not null,
     9        fees_paid_per_party jsonb not null,
    10        vega_time timestamp with time zone not null,
    11        primary key (vega_time, market_id, asset_id, epoch_seq)
    12  );
    13  
    14  create index paid_liquidity_fees_market_id_idx on paid_liquidity_fees(market_id);
    15  create index paid_liquidity_fees_asset_id_idx on paid_liquidity_fees(asset_id);
    16  create index paid_liquidity_fees_epoch_seq_idx on paid_liquidity_fees(epoch_seq);
    17  create index paid_liquidity_fees_fees_paid_per_party_ix on paid_liquidity_fees((fees_paid_per_party->>'party'));
    18  
    19  -- +goose Down
    20  drop index paid_liquidity_fees_market_id_idx;
    21  drop index paid_liquidity_fees_asset_id_idx;
    22  drop index paid_liquidity_fees_epoch_seq_idx;
    23  drop index paid_liquidity_fees_fees_paid_per_party_ix;
    24  drop table if exists paid_liquidity_fees;