IntersectMBO/cardano-db-sync 12.0.0 on GitHub

This release is compatible with Cardano Node 1.31.0.

⚠️ Note that this release requires the database to be dropped and recreated.

The state snapshot files for this release can be found here:

Network	Link to snapshot
Testnet	https://updates-cardano-testnet.s3.amazonaws.com/cardano-db-sync/index.html#12/
Mainnet	https://update-cardano-mainnet.iohk.io/cardano-db-sync/index.html#12/

Documentation for restoring from these files available at state-snapshot.md.

Requires ghc-8.10.x to build.

Added

Include json and (raw) bytes fields to script table.
Add cost_model, datum and redeemer tables.
Add a multi_asset table with policy, name and asset fingerprint columns (#868).
Ported SMASH version (its documentation), which is a standalone SMASH ported to DB sync 12, under trial-run and production monitoring to verify performance. Therefore, SMASH users are advised to stay on their current standalone version and NOT update to this ported SMASH version. Updates on the ported version will follow in the following DB sync releases.

Update rewardtype enum (used in reward table) to include a pool deposit refund type.
Update cost_model* fields of param_proposal and epoch_param tables to reference cost_model
table.
Unify SQL types of epoch_stake.epoch_no and epoch.no (#811).
Handle the empty list case in insertManyUncheckedUnique (#869).
Update system requirements (#951).

Drop the policy and name columns of ma_tx_mint and ma_tx_out tables, replacing those
columns with a reference to the multi_asset table.
Stop supporting test configs which don't initiate Shelley properly.

Fix handling of transactions which have contracts which fail second stage validation (#883).
Fix missing and inconsistent rewards issues (#791, #796, #805. #882, #826, #918, #921, #923, #939,
#947).
Fix the git SHA hash in the version subcommand (#844).