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

  def change do
    create table(:req_pay_events) do
      add :req_pay_id, :bigint, null: false
      add :transaction_id, :bigint, null: false
      add :seq, :integer, null: false
      add :event_type, :string, null: false, size: 50
      add :payload, :json
      add :prev_hash, :binary
      add :hash, :binary, null: false
      add :req_xml_hash, :binary
      add :resp_xml_hash, :binary

      timestamps(type: :utc_datetime)
    end

    create index(:req_pay_events, [:req_pay_id])
    create index(:req_pay_events, [:transaction_id])
    create index(:req_pay_events, [:event_type])
    create unique_index(:req_pay_events, [:req_pay_id, :seq])
  end
end