Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SET NAMES 'utf8';
- ALTER TABLE `ps_carrier` CHANGE `max_weight` `max_weight` DECIMAL( 20, 6 ) NULL DEFAULT '0';
- DELETE ms.*, hm.* FROM `ps_module_shop` ms INNER JOIN `ps_hook_module` hm USING (`id_module`) INNER JOIN `ps_module` m USING (`id_module`) WHERE m.`name` LIKE 'backwardcompatibility';
- UPDATE `ps_module` SET `active` = 0 WHERE `name` LIKE 'backwardcompatibility';
- ALTER TABLE `ps_orders` CHANGE `reference` `reference` VARCHAR( 10 ) NULL DEFAULT NULL;
- ALTER TABLE `ps_order_payment` CHANGE `order_reference` `order_reference` VARCHAR( 10 ) NULL DEFAULT NULL;
- # 5.0
- SET NAMES 'utf8';
- ALTER TABLE `ps_store` CHANGE `latitude` `latitude` DECIMAL( 13, 8 ) NULL DEFAULT NULL , CHANGE `longitude` `longitude` DECIMAL( 13, 8 ) NULL DEFAULT NULL ;
- INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('PS_CUSTOMER_CREATION_EMAIL', 1, NOW(), NOW());
- ALTER TABLE `ps_webservice_account` CHANGE `class_name` `class_name` VARCHAR(64) NOT NULL DEFAULT 'WebserviceRequest';
- /* PHP:add_module_to_hook(blockcart, actionCartListOverride); */;
- /* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerDeleteAfter); */;
- /* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerAddAfter); */;
- /* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerUpdateAfter); */;
- /* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierDeleteAfter); */;
- /* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierAddAfter); */;
- /* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierUpdateAfter); */;
- /* PHP:fix_download_product_feature_active(); */;
- /* PHP:add_module_to_hook(blockmyaccount, actionModuleRegisterHookAfter); */;
- /* PHP:add_module_to_hook(blockmyaccountfooter, actionModuleRegisterHookAfter); */;
- /* PHP:add_module_to_hook(blockmyaccount, actionModuleUnRegisterHookAfter); */;
- /* PHP:add_module_to_hook(blockmyaccountfooter, actionModuleUnRegisterHookAfter); */;
- /* PHP:remove_tab(AdminRangePrice); */;
- /* PHP:remove_tab(AdminRangeWeight); */;
- ALTER TABLE `ps_log` ADD `id_employee` INT(10) UNSIGNED NULL DEFAULT NULL AFTER `object_id`;
- SET @id_parent = (SELECT IFNULL(id_tab, 1) FROM `ps_tab` WHERE `class_name` = 'AdminPriceRule' LIMIT 1);
- UPDATE `ps_tab` SET id_parent = @id_parent WHERE `id_parent` = 1 AND `class_name` = 'AdminMarketing' LIMIT 1;
- UPDATE `ps_hook` SET `description` = 'This hook is called when a new credit slip is added regarding client order' WHERE `name` = 'actionOrderSlipAdd';
- ALTER TABLE `ps_product_shop` DROP INDEX `date_add`, ADD INDEX `date_add` (`date_add` , `active` , `visibility`);
- UPDATE `ps_hook` SET `live_edit` = '1' WHERE `name` LIKE 'leftcolumn';
- UPDATE `ps_configuration` SET `value` = '0' WHERE `name` LIKE 'PS_LEGACY_IMAGES' AND `value` = 1;
- INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('PS_SMARTY_CONSOLE_KEY', 'SMARTY_DEBUG', NOW(), NOW());
- # 6.0
- ALTER TABLE `ps_manufacturer_lang` CHANGE `short_description` `short_description` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL;
- /* PHP:add_module_to_hook(blockcart, actionCartListOverride); */;
- /* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerDeleteAfter); */;
- /* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerAddAfter); */;
- /* PHP:add_module_to_hook(blockmanufacturer, actionObjectManufacturerUpdateAfter); */;
- /* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierDeleteAfter); */;
- /* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierAddAfter); */;
- /* PHP:add_module_to_hook(blocksupplier, actionObjectSupplierUpdateAfter); */;
- /* PHP:add_module_to_hook(blockmyaccount, actionModuleRegisterHookAfter); */;
- /* PHP:add_module_to_hook(blockmyaccountfooter, actionModuleRegisterHookAfter); */;
- /* PHP:add_module_to_hook(blockmyaccount, actionModuleUnRegisterHookAfter); */;
- /* PHP:add_module_to_hook(blockmyaccountfooter, actionModuleUnRegisterHookAfter); */;
- /* PHP:remove_tab(AdminRangePrice); */;
- /* PHP:remove_tab(AdminRangeWeight); */;
- UPDATE `ps_employee` SET default_tab = (SELECT `id_tab` FROM `ps_tab` WHERE `class_name` LIKE 'AdminOrders' LIMIT 0 , 1) WHERE default_tab = 0;
- # 6.1
- ALTER TABLE `ps_customer_message` CHANGE `ip_address` `ip_address` VARCHAR( 15 ) NULL DEFAULT NULL;
- UPDATE `ps_currency` SET `conversion_rate` = 1 WHERE `conversion_rate` = 0;
- ALTER TABLE `ps_currency` CHANGE `conversion_rate` `conversion_rate` DECIMAL( 13, 6 ) NOT NULL DEFAULT '1';
- UPDATE `ps_orders` SET conversion_rate = 1 WHERE conversion_rate = 0;
- ALTER TABLE `ps_cms` ADD `indexation` tinyint(1) UNSIGNED NULL DEFAULT '1' AFTER `active`;
- /* PHP:update_order_messages(); */;
- ALTER TABLE `ps_group_reduction` CHANGE `reduction` `reduction` DECIMAL( 4, 4 ) NOT NULL;
- # 6.2
- SET NAMES 'utf8';
- ALTER TABLE ps_newsletter ADD update_at TIMESTAMP
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement