-- ============================================================================
-- Widen VARCHAR(50) columns in configuration_items that hold IPs / identifiers
-- Real-world data (IPv6, UUIDs, long hostnames) exceeds the original 50-char limit
-- ============================================================================

ALTER TABLE configuration_items
  ALTER COLUMN datto_internal_ip              TYPE VARCHAR(255),
  ALTER COLUMN datto_remote_ip               TYPE VARCHAR(255),
  ALTER COLUMN rmm_device_audit_external_ip_address TYPE VARCHAR(255),
  ALTER COLUMN rmm_device_audit_ip_address   TYPE VARCHAR(255),
  ALTER COLUMN rmm_device_audit_mac_address  TYPE VARCHAR(100),
  ALTER COLUMN rmm_device_audit_mobile_number TYPE VARCHAR(100);