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

  def change do
    alter table(:parameter_push_logs) do
      add :config_type, :string, default: "parameter"
      add :file_path, :string
      add :file_size, :integer
      add :checksum, :string
      add :version_sent, :string
      add :device_vendor, :string
      add :device_model, :string
      add :trigger_reason, :string
    end

    create index(:parameter_push_logs, [:config_type])
    create index(:parameter_push_logs, [:device_vendor, :device_model])
    create index(:parameter_push_logs, [:trigger_reason])
  end
end