27 lines
1.5 KiB
MySQL
27 lines
1.5 KiB
MySQL
|
-- ============================================================================
|
||
|
|
-- Widen all short VARCHAR columns in configuration_items to TEXT
|
||
|
|
-- Autotask data frequently exceeds VARCHAR(100/255) limits for identifiers,
|
||
|
|
-- hostnames, serial numbers, SNMP strings, etc.
|
||
|
|
-- ============================================================================
|
||
|
|
|
||
|
|
ALTER TABLE configuration_items
|
||
|
|
ALTER COLUMN datto_serial_number TYPE TEXT,
|
||
|
|
ALTER COLUMN device_type TYPE TEXT,
|
||
|
|
ALTER COLUMN reference_number TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_mac_address TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_mobile_number TYPE TEXT,
|
||
|
|
ALTER COLUMN serial_number TYPE TEXT,
|
||
|
|
ALTER COLUMN backup_type_udf TYPE TEXT,
|
||
|
|
ALTER COLUMN datto_hostname TYPE TEXT,
|
||
|
|
ALTER COLUMN reference_title TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_description TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_hostname TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_last_user TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_snmp_contact TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_snmp_location TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_audit_snmp_name TYPE TEXT,
|
||
|
|
ALTER COLUMN rmm_device_uid TYPE TEXT,
|
||
|
|
ALTER COLUMN snmp_contact TYPE TEXT,
|
||
|
|
ALTER COLUMN snmp_location TYPE TEXT,
|
||
|
|
ALTER COLUMN snmp_name TYPE TEXT;
|