search

regen-network / indexer

:rocket: Blockchain indexer and database
Other
2 stars 0 forks source link

feat: add tx hash to retirements table #20

Closed wgwz closed 1 year ago

wgwz commented 1 year ago

Closes: https://github.com/regen-network/regen-registry/issues/1753

This adds the tx hash to each row in the retirements table. This is done in such a way where it can be re-used in the future. I.e. we can include the tx hash in the proposals PR as well.

wgwz commented 1 year ago

One thing to note is that either we need an additional/modified migration or as part of deploying this we could truncate the retirements table. The problem is that the new tx hash column needs to be populated with correct data. I'd suggest truncating the retirements table before applying the migration in this PR and deploying. It's a simple approach with little downsides, it would take a couple of minutes for all retirements to be reindexed.