defmodule Benchmark.Repo.Migrations.CreateAlerts do
  use Ecto.Migration

  def change do
    create table(:alerts) do
      add :alert_type, :string, null: false, default: "INFO"
      add :description, :string, null: false
      timestamps(type: :utc_datetime)
    end

    create index(:alerts, [:alert_type])
    create index(:alerts, [:inserted_at])
  end
end