defmodule DaProductApp.Repo.Migrations.AddMissingPayoutBatchColumns do
  use Ecto.Migration

  def change do
    alter table(:payout_batches) do
      add :batch_reference, :string, size: 255
      add :encrypted_file_path, :string, size: 500
      add :file_hash, :string
      add :encryption_key_ref, :string
      add :bank_confirmation_ref, :string
      add :failure_reason, :string
      add :generated_by, :integer
      add :generated_at, :naive_datetime
    end

    create unique_index(:payout_batches, [:batch_reference])
    create index(:payout_batches, [:bank_confirmation_ref])
  end
end