defmodule Towerops.Repo.Migrations.AddDisplayOrderToSites do
  use Ecto.Migration

  def change do
    alter table(:sites) do
      add :display_order, :integer
    end

    # Composite index for efficient sorting (organization + display_order + name)
    create index(:sites, [:organization_id, :display_order, :name])
  end
end
