status-im / open-bounty

Enable communities to distribute funds to push their cause forward.
https://openbounty.status.im/
GNU Affero General Public License v3.0
118 stars 36 forks source link

WIP migration: add unique constraint on transaction_hash column #429

Closed martinklepsch closed 6 years ago

martinklepsch commented 6 years ago

We repeatedly ran into the issue that deployment of bounty contracts resulted in the same TX (and eventually contract) being associated with a bounty. This is broken and so this constraint on the Postgres table should help with ensuring that this does not happen anymore.

Before this can be deployed or even tested the respective databases need to be cleared of any records that violate this constraint.