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

     1  -- +goose Up
     2  
     3  CREATE TABLE party_activity_streaks (
     4         party_id					BYTEA NOT NULL,
     5         active_for				INT NOT NULL,
     6         inactive_for				INT NOT NULL,
     7         is_active				BOOLEAN NOT NULL,
     8         reward_distribution_activity_multiplier 	TEXT NOT NULL,
     9         reward_vesting_activity_multiplier      	TEXT NOT NULL,
    10         epoch 					INT NOT NULL,
    11         traded_volume 				TEXT NOT NULL,
    12         open_volume 				TEXT NOT NULL,
    13         vega_time      				TIMESTAMP WITH TIME ZONE NOT NULL,
    14         tx_hash           			BYTEA                    NOT NULL,
    15         PRIMARY KEY (party_id, epoch, vega_time)
    16  );
    17  SELECT create_hypertable('party_activity_streaks', 'vega_time', chunk_time_interval => INTERVAL '1 day');
    18  CREATE INDEX ON party_activity_streaks (party_id, vega_time);
    19  CREATE INDEX ON party_activity_streaks (tx_hash);
    20  
    21  -- +goose Down
    22  
    23  DROP INDEX IF EXISTS party_activity_streaks_idx_tx_hash;
    24  DROP TABLE IF EXISTS party_activity_streaks;