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

  def change do
    create table(:pos_merchant, primary_key: false) do
      add :id, :integer, primary_key: true, null: false
      add :merchantid, :string, size: 45, null: false
      add :merchant_name, :string, size: 255
      add :address_id, :integer
    end

    create index(:pos_merchant, [:address_id])
  end
end