/** * Change IP address columns to have sufficient room to store IPv6 address * * @version 1.7-rc1 ipv6-addresses */ ALTER TABLE `%TABLE_PREFIX%api_key` CHANGE `ipaddr` `ipaddr` varchar(64) NOT NULL; ALTER TABLE `%TABLE_PREFIX%session` CHANGE `user_id` `user_id` int(10) unsigned NOT NULL default '0' COMMENT 'osTicket staff ID', CHANGE `user_ip` `user_ip` varchar(64) NOT NULL; ALTER TABLE `%TABLE_PREFIX%syslog` CHANGE `ip_address` `ip_address` varchar(64) NOT NULL; ALTER TABLE `%TABLE_PREFIX%ticket` CHANGE `ip_address` `ip_address` varchar(64) NOT NULL default ''; -- Finished with patch UPDATE `%TABLE_PREFIX%config` SET `schema_signature`='b19dc97d19f7a30f59663c812d1f3ddc';