This implements soft delete for spent elements, sidestepping the issue of reverts clobbering the chain index. Spent elements will be pruned 144 blocks after their spend height. This also reverts the removal of the chain_indices table to use the foreign key as a bug sanity check.
This implements soft delete for spent elements, sidestepping the issue of reverts clobbering the chain index. Spent elements will be pruned 144 blocks after their spend height. This also reverts the removal of the
chain_indicestable to use the foreign key as a bug sanity check.