"use strict";

module.exports = {
  up: async (queryInterface, Sequelize) => {
    await queryInterface.addColumn("Transactions", "reconciliationAttempts", {
      type: Sequelize.INTEGER,
      defaultValue: 0,
      allowNull: false,
      comment: "Number of times the background job has requeried this pending payout against 9PSB without a SUCCESS. Only marked failed once this reaches the retry limit.",
    });
  },

  down: async (queryInterface) => {
    await queryInterface.removeColumn("Transactions", "reconciliationAttempts");
  },
};
