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

     1  -- +goose Up
     2  ALTER TABLE trades ADD COLUMN buyer_maker_fee_referral_discount HUGEINT NOT NULL DEFAULT(0),
     3                     ADD COLUMN buyer_infrastructure_fee_referral_discount HUGEINT NOT NULL DEFAULT(0),
     4                     ADD COLUMN buyer_liquidity_fee_referral_discount HUGEINT NOT NULL DEFAULT(0),
     5                     ADD COLUMN buyer_maker_fee_volume_discount HUGEINT NOT NULL DEFAULT(0),
     6                     ADD COLUMN buyer_infrastructure_fee_volume_discount HUGEINT NOT NULL DEFAULT(0),
     7                     ADD COLUMN buyer_liquidity_fee_volume_discount HUGEINT NOT NULL DEFAULT(0),
     8                     ADD COLUMN seller_maker_fee_referral_discount HUGEINT NOT NULL DEFAULT(0),
     9                     ADD COLUMN seller_infrastructure_fee_referral_discount HUGEINT NOT NULL DEFAULT(0),
    10                     ADD COLUMN seller_liquidity_fee_referral_discount HUGEINT NOT NULL DEFAULT(0),
    11                     ADD COLUMN seller_maker_fee_volume_discount HUGEINT NOT NULL DEFAULT(0),
    12                     ADD COLUMN seller_infrastructure_fee_volume_discount HUGEINT NOT NULL DEFAULT(0),
    13                     ADD COLUMN seller_liquidity_fee_volume_discount HUGEINT NOT NULL DEFAULT(0);
    14  
    15  -- +goose Down
    16  ALTER TABLE trades DROP COLUMN buyer_maker_fee_referral_discount,
    17                     DROP COLUMN buyer_infrastructure_fee_referral_discount,
    18                     DROP COLUMN buyer_liquidity_fee_referral_discount,
    19                     DROP COLUMN buyer_maker_fee_volume_discount,
    20                     DROP COLUMN buyer_infrastructure_fee_volume_discount,
    21                     DROP COLUMN buyer_liquidity_fee_volume_discount,
    22                     DROP COLUMN seller_maker_fee_referral_discount,
    23                     DROP COLUMN seller_infrastructure_fee_referral_discount,
    24                     DROP COLUMN seller_liquidity_fee_referral_discount,
    25                     DROP COLUMN seller_maker_fee_volume_discount,
    26                     DROP COLUMN seller_infrastructure_fee_volume_discount,
    27                     DROP COLUMN seller_liquidity_fee_volume_discount;