| Server IP : 184.154.167.98 / Your IP : 18.117.101.250 Web Server : Apache System : Linux pink.dnsnetservice.com 4.18.0-553.22.1.lve.1.el8.x86_64 #1 SMP Tue Oct 8 15:52:54 UTC 2024 x86_64 User : puertode ( 1767) PHP Version : 7.2.34 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : ON | Pkexec : ON Directory : /home/puertode/public_html/mesa/include/upgrader/streams/core/ |
Upload File : |
/**
* 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';