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

  def change do
    # Add snmp_port to organizations with default 161
    alter table(:organizations) do
      add :snmp_port, :integer, default: 161, null: false
    end

    # Add snmp_port to sites (nullable for inheritance)
    alter table(:sites) do
      add :snmp_port, :integer, null: true
    end
  end
end
