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

  def change do
    create table(:tms_terminals) do
      add :serial_number, :string, null: false
      add :oid, :string
      add :status, :string
      add :model, :string
      add :vendor, :string
      add :area, :string
      add :group, :string
      add :imei, :string
      add :imei2, :string
      add :cpuid, :string
      add :mac, :string
      add :app_version, :string
      add :data_version, :string
      add :system_version, :string
      add :secure_firmware, :string
      add :factory_time, :utc_datetime
      add :boot_version, :string
      add :pubkey, :string
      add :appkey, :string
      add :locked, :string
      add :hardware_version, :string
      add :driver_version, :string
      add :pro_version, :string
      add :module_version, :string
      add :wifi_version, :string
      add :remark, :string
      add :otp_id, :string
      add :netmac, :string
      add :heart, :integer
      add :merchant_id, :string
      add :location_code, :string
      add :deployment_type, :string
      add :tier, :string

      timestamps(type: :utc_datetime)
    end

    create unique_index(:tms_terminals, [:serial_number])
    create index(:tms_terminals, [:status])
    create index(:tms_terminals, [:vendor])
    create index(:tms_terminals, [:model])
    create index(:tms_terminals, [:merchant_id])
  end
end