13 lines
750 B
MySQL
13 lines
750 B
MySQL
|
-- ============================================================================
|
||
|
|
-- 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);
|