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

     1  -- +goose Up
     2  
     3  -- index the json columns to make them faster to query
     4  create index if not exists idx_referral_fee_stats_total_rewards_paid on referral_fee_stats using gin(total_rewards_paid);
     5  create index if not exists idx_referral_fee_stats_referrer_rewards_generated on referral_fee_stats using gin(referrer_rewards_generated);
     6  create index if not exists idx_referral_fee_stats_referees_discount_applied on referral_fee_stats using gin(referees_discount_applied);
     7  create index if not exists idx_referral_fee_stats_volume_discount_applied on referral_fee_stats using gin(volume_discount_applied);
     8  
     9  -- +goose Down
    10  
    11  drop index if exists idx_referral_fee_stats_total_rewards_paid;
    12  drop index if exists idx_referral_fee_stats_referrer_rewards_generated;
    13  drop index if exists idx_referral_fee_stats_referees_discount_applied;
    14  drop index if exists idx_referral_fee_stats_volume_discount_applied;