Background
A new competition_auctions table is being introduced with PR #2980. While this PR will populate new entries, we also need to backfill historical data, as the necessary information already exists in other tables. This will allow us to drop other tables.
Details
Populate the auctions table using existing data from the following sources:
auction_id – from solver_competition table
block – from solver_competition table field auctionStartBlock
deadline – from settlement_scores table; if missing, set to 0 or use the value of block
order_uids – from solver_competition or auction_orders table
prices – from solver_competition or auction_prices table
surplus_capturing_jit_order_owners – from surplus_capturing_jit_order_owners table
Background
A new
competition_auctionstable is being introduced with PR #2980. While this PR will populate new entries, we also need to backfill historical data, as the necessary information already exists in other tables. This will allow us to drop other tables.Details
Populate the auctions table using existing data from the following sources:
auction_id – from
solver_competitiontableblock – from
solver_competitiontable fieldauctionStartBlockdeadline – from
settlement_scorestable; if missing, set to 0 or use the value of blockorder_uids – from
solver_competitionorauction_orderstableprices – from
solver_competitionorauction_pricestablesurplus_capturing_jit_order_owners – from
surplus_capturing_jit_order_ownerstable