You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
23 lines
723 B
23 lines
723 B
/**
|
|
* 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';
|