-- WHMCS "dedicated IP" of a service: for CWPpro licenses this is the licensed server IP (or a CIDR range for NOC).
ALTER TABLE services ADD dedicated_ip VARCHAR(500) NOT NULL DEFAULT '' AFTER username, ADD KEY dedicated_ip (dedicated_ip(64));