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

  def change do
    create table(:transaction, primary_key: false) do
      add :id, :integer, primary_key: true, null: false
      add :pan, :string, size: 45
      add :proc_code, :string, size: 45
      add :amount, :string, size: 45
      add :stan, :string, size: 45
      add :date_time, :string, size: 45
      add :settlement_date, :string, size: 45
      add :mcc, :string, size: 45
      add :terminal_id, :string, size: 45
      add :merchant_id, :string, size: 45
      add :reference_id, :string, size: 45
      add :auth_code, :string, size: 45
      add :response_code, :string, size: 45
      add :upi_url, :string, size: 511
      add :upi_info, :string, size: 1023
      add :meta_data, :string, size: 45
      add :date_added, :naive_datetime, default: fragment("CURRENT_TIMESTAMP")
    end
  end
end