-- Add status column to network_devices for online/offline/warning indicators.
ALTER TABLE network_devices
  ADD COLUMN IF NOT EXISTS status TEXT NOT NULL DEFAULT 'unknown'
    CHECK (status IN ('online', 'offline', 'warning', 'unknown'));