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

  def change do
    create table(:acquirer_merchant, primary_key: false) do
      add :id, :integer, primary_key: true, null: false
      add :acquirer_id, :integer, null: false
      add :merchantid, :string, size: 45, null: false
      add :mcc, :string, size: 5
      add :address_id, :integer
    end

    create index(:acquirer_merchant, [:acquirer_id])
    create index(:acquirer_merchant, [:address_id])
  end
end