Issue 872

Fixes #872 once merged.

Adds the `txid` field into the transactions table so run the SQL upgrade file supplied. Otherwise you payouts will fail until this is added.