| Server IP : 184.154.167.98 / Your IP : 3.141.46.108 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 RC2+
* @signature dd0022fb14892c0bb6a9700392df2de7
*
* Migrate file attachment data from %file to %file_chunk
*
*/
DROP TABLE IF EXISTS `%TABLE_PREFIX%file_chunk`;
CREATE TABLE `%TABLE_PREFIX%file_chunk` (
`file_id` int(11) NOT NULL,
`chunk_id` int(11) NOT NULL,
`filedata` longblob NOT NULL,
PRIMARY KEY (`file_id`, `chunk_id`)
) DEFAULT CHARSET=utf8;
INSERT INTO `%TABLE_PREFIX%file_chunk` (`file_id`, `chunk_id`, `filedata`)
SELECT `id`, 0, `filedata`
FROM `%TABLE_PREFIX%file`;
ALTER TABLE `%TABLE_PREFIX%file`
DROP COLUMN `filedata`,
ADD `bk` CHAR(1) NOT NULL DEFAULT 'D' AFTER `id`,
ADD `attrs` VARCHAR(255) AFTER `name`;
OPTIMIZE TABLE `%TABLE_PREFIX%file`;
-- Finished with patch
UPDATE `%TABLE_PREFIX%config`
SET `schema_signature`='dd0022fb14892c0bb6a9700392df2de7';