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

  def change do
    create table(:risk_rules) do
      add :name, :string, null: false
      add :description, :text
      add :category, :string, null: false  # Cat A/B/C/D
      add :parameters, :json
      add :enabled, :boolean, default: true
      add :rule_type, :string, null: false  # 'hold' or 'alert'
      add :execution_order, :integer, default: 0
      add :mcc_codes, :json  # Merchant Category Codes (stored as JSON array)

      timestamps(type: :utc_datetime)
    end

    create index(:risk_rules, [:category])
    create index(:risk_rules, [:enabled])
    create index(:risk_rules, [:rule_type])
    create unique_index(:risk_rules, [:name, :category])
  end
end