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

  def change do
    alter table(:merchants) do
      add :category, :string  # Cat A, Cat B, Cat C, Cat D
      add :mcc_code, :string  # Merchant Category Code
      add :risk_tier, :string  # Enterprise, Mid-Market, Known Entity, SME/SMB
    end

    create index(:merchants, [:category])
    create index(:merchants, [:mcc_code])
    create index(:merchants, [:risk_tier])
  end
end