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

  def change do
    create table(:software_versions) do
      add :version, :string, null: false
      add :changelog, :text
      add :file_path, :string
      add :file_size, :bigint
      add :checksum, :string
      add :release_date, :utc_datetime
      add :active, :boolean, default: true
      add :software_id, references(:software, on_delete: :delete_all), null: false

      timestamps(type: :utc_datetime)
    end

    create index(:software_versions, [:software_id])
    create index(:software_versions, [:version])
    create index(:software_versions, [:active])
  end
end