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

  def change do
    create table(:pos_terminal, primary_key: false) do
      add :id, :integer, primary_key: true, null: false
      add :terminalid, :string, size: 15, null: false
      add :serial_number, :string, size: 45
      add :pos_merchant_id, :integer
    end

    create index(:pos_terminal, [:pos_merchant_id])
  end
end