| Server IP : 184.154.167.98 / Your IP : 18.227.140.100 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.11
* @signature ad9d0a5f1bd9f83a4ecb3f590b334eac
* @title Custom Queues, Advanced Sorting
*
* Add advanced sorting configuration to custom queues
*/
ALTER TABLE `%TABLE_PREFIX%queue`
ADD `sort_id` int(11) unsigned AFTER `columns_id`;
DROP TABLE IF EXISTS `%TABLE_PREFIX%queue_sort`;
CREATE TABLE `%TABLE_PREFIX%queue_sort` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`root` varchar(32) DEFAULT NULL,
`name` varchar(64) NOT NULL DEFAULT '',
`columns` text,
`updated` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) DEFAULT CHARSET=utf8;
DROP TABLE IF EXISTS `%TABLE_PREFIX%queue_sorts`;
CREATE TABLE `%TABLE_PREFIX%queue_sorts` (
`queue_id` int(11) unsigned NOT NULL,
`sort_id` int(11) unsigned NOT NULL,
`bits` int(11) unsigned NOT NULL DEFAULT '0',
`sort` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`queue_id`, `sort_id`)
) DEFAULT CHARSET=utf8;
-- Finished with patch
UPDATE `%TABLE_PREFIX%config`
SET `value` = 'ad9d0a5f1bd9f83a4ecb3f590b334eac'
WHERE `key` = 'schema_signature' AND `namespace` = 'core';