eth2-beaconchain-explorer icon indicating copy to clipboard operation
eth2-beaconchain-explorer copied to clipboard

Rocketpool Redstone Rewards - Claimed/Unclaimed & Smoothing Pool

Open manuelsc opened this issue 1 year ago • 0 comments

Migrate Database before merging:

ALTER TABLE rocketpool_nodes ADD COLUMN claimed_smoothing_pool numeric NOT NULL default 0;
ALTER TABLE rocketpool_nodes ADD COLUMN unclaimed_smoothing_pool numeric NOT NULL default 0;
ALTER TABLE rocketpool_nodes ADD COLUMN unclaimed_rpl_rewards numeric NOT NULL default 0;
ALTER TABLE rocketpool_nodes ADD COLUMN smoothing_pool_opted_in boolean not null default false;

drop table if exists rocketpool_reward_tree;
create table rocketpool_reward_tree
(
    id       bigserial,
    data   jsonb not null,

    primary key(id)
);

manuelsc avatar Aug 09 '22 13:08 manuelsc