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

     1  -- +goose Up
     2  
     3  CREATE UNIQUE INDEX referral_set_referees_pkey_update ON referral_set_referees(referral_set_id, referee, at_epoch);
     4  
     5  ALTER TABLE referral_set_referees DROP CONSTRAINT referral_set_referees_pkey;
     6  
     7  ALTER TABLE referral_set_referees
     8    ADD CONSTRAINT referral_set_referees_pkey PRIMARY KEY USING INDEX referral_set_referees_pkey_update;
     9  
    10  CREATE VIEW current_referral_set_referees AS
    11  SELECT DISTINCT ON (referee) *
    12  FROM referral_set_referees
    13  ORDER BY
    14    referee,
    15    at_epoch DESC;
    16  
    17  -- +goose Down
    18  
    19  DROP VIEW IF EXISTS current_referral_set_referees;
    20  
    21  CREATE UNIQUE INDEX referral_set_referees_pkey_update ON referral_set_referees(referral_set_id, referee);
    22  
    23  ALTER TABLE referral_set_referees DROP CONSTRAINT referral_set_referees_pkey;
    24  
    25  ALTER TABLE referral_set_referees
    26    ADD CONSTRAINT referral_set_referees_pkey PRIMARY KEY USING INDEX referral_set_referees_pkey_update;
    27