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

  def change do
    # Add SSH port to organizations (default 22 for new orgs)
    alter table(:organizations) do
      add :mikrotik_ssh_port, :integer, default: 22
    end

    # Add SSH port to sites (nullable for inheritance)
    alter table(:sites) do
      add :mikrotik_ssh_port, :integer
    end

    # Add SSH port to devices (nullable for inheritance)
    alter table(:devices) do
      add :mikrotik_ssh_port, :integer
    end
  end
end
