| Server IP : 184.154.167.98 / Your IP : 3.15.202.169 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 : |
/**
* @version v1.7 RC3
* @signature 1da1bcbafcedc65efef58f142a48ac91
*
* Upgrade from 1.6 RC3 + filters
*
*/
DROP TABLE IF EXISTS `%TABLE_PREFIX%filter`;
RENAME TABLE `%TABLE_PREFIX%email_filter` TO `%TABLE_PREFIX%filter`;
DROP TABLE IF EXISTS `%TABLE_PREFIX%filter_rule`;
RENAME TABLE `%TABLE_PREFIX%email_filter_rule` TO `%TABLE_PREFIX%filter_rule`;
ALTER TABLE `%TABLE_PREFIX%filter` CHANGE `reject_email` `reject_ticket` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `%TABLE_PREFIX%filter`
ADD `target` ENUM( 'Any', 'Web', 'Email', 'API' ) NOT NULL DEFAULT 'Any' AFTER `sla_id` ,
ADD INDEX ( `target` );
UPDATE `%TABLE_PREFIX%filter` SET `target` = 'Email' WHERE `email_id` != 0;
-- Finished with patch
UPDATE `%TABLE_PREFIX%config`
SET `schema_signature`='1da1bcbafcedc65efef58f142a48ac91';