update database with new transaction column