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

  def change do
    alter table(:pos_transactions) do
      add_if_not_exists :entry_mode, :string, size: 3
      add_if_not_exists :bin_number, :string, size: 8
      add_if_not_exists :response_code, :string, size: 2
      add_if_not_exists :onboarding_date, :date
    end

    create_if_not_exists index(:pos_transactions, [:entry_mode])
    create_if_not_exists index(:pos_transactions, [:bin_number])
    create_if_not_exists index(:pos_transactions, [:response_code])
    create_if_not_exists index(:pos_transactions, [:onboarding_date])
  end
end