BoKr Posted May 12, 2013 Share Posted May 12, 2013 Hello since one week I try desperately to upgrade our live shop from 1.4.9 to 1.5.2 but to no avail. With the newest autoupgrade modul it always fails and I have to restore the shop. But that was to expect when I follow all the posts about problems with it. So, I decided to manually update. I followed the Prestashop wiki documentation. All 3rd party modules are resetted and deactivated. Default theme is active. All files and directories are deleted from the live host except my /config and /img folders. Then via FTP the content of the 1.5.2 archive/zip is being copied over via WinSCP. what I forgot to do is to turn off friendly URLs and to copy an empty .htaccess though I read only once that this would be necessary. All that may differ from a standard setup is that we had taxes deactivated iin 1.4.9 I tried this several times and and am desperate now. Please help us. There must be a way for normal users to update their live shop with Prestashop. Finally I call the www.myshop.de/install/upgrade/upgrade.php Eventually I got this huge error log. <action result="fail" error="34"><request result="ok" sqlfile="1.5.0.0"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_group_shop` ( `id_group_shop` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(64) CHARACTER SET utf8 NOT NULL, `share_customer` TINYINT(1) NOT NULL, `share_order` TINYINT(1) NOT NULL, `share_stock` TINYINT(1) NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '1', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_group_shop` (`id_group_shop`, `name`, `active`, `deleted`, `share_stock`, `share_customer`, `share_order`) VALUES (1, 'Default', 1, 0, 0, 0, 0)</sqlQuery><sqlMsgError>Unknown column 'id_group_shop' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_shop` ( `id_shop` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_group_shop` int(11) unsigned NOT NULL, `name` varchar(64) CHARACTER SET utf8 NOT NULL, `id_category` INT(11) UNSIGNED NOT NULL DEFAULT '1', `id_theme` INT(1) UNSIGNED NOT NULL, `active` tinyint(1) NOT NULL DEFAULT '1', `deleted` tinyint(1) NOT NULL DEFAULT '0', PRIMARY KEY (`id_shop`), KEY `id_group_shop` (`id_group_shop`), KEY `id_category` (`id_category`), KEY `id_theme` (`id_theme`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_shop` (`id_shop`, `id_group_shop`, `name`, `id_category`, `id_theme`, `active`, `deleted`) VALUES (1, 1, (SELECT value FROM `ps1_configuration` WHERE name = 'PS_SHOP_NAME'), 1, 1, 1, 0)</sqlQuery><sqlMsgError>Unknown column 'id_group_shop' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_configuration` ADD `id_group_shop` INT(11) UNSIGNED DEFAULT NULL AFTER `id_configuration` , ADD `id_shop` INT(11) UNSIGNED DEFAULT NULL AFTER `id_group_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_configuration` DROP INDEX `name` , ADD INDEX `name` ( `name` )</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_configuration` ADD INDEX (`id_group_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_configuration` ADD INDEX (`id_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_configuration` (`id_configuration`, `name`, `value`, `date_add`, `date_upd`) VALUES (NULL, 'PS_SHOP_DEFAULT', '1', NOW(), NOW())</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_shop_url` ( `id_shop_url` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_shop` int(11) unsigned NOT NULL, `domain` varchar(255) NOT NULL, `domain_ssl` varchar(255) NOT NULL, `physical_uri` varchar(64) NOT NULL, `virtual_uri` varchar(64) NOT NULL, `main` TINYINT(1) NOT NULL, `active` TINYINT(1) NOT NULL, PRIMARY KEY (`id_shop_url`), KEY `id_shop` (`id_shop`), UNIQUE KEY `shop_url` (`domain`, `virtual_uri`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_theme` ( `id_theme` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, PRIMARY KEY (`id_theme`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_theme` (`id_theme`, `name`) VALUES (1, 'prestashop')</sqlQuery><sqlMsgError>Duplicate entry '1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_theme_specific` ( `id_theme` int(11) unsigned NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, `entity` int(11) unsigned NOT NULL, `id_object` int(11) unsigned NOT NULL, PRIMARY KEY (`id_theme`,`id_shop`, `entity`,`id_object`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_stock` ( `id_stock` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT, `id_product` INT( 11 ) UNSIGNED NOT NULL, `id_product_attribute` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, `quantity` INT(11) NOT NULL, PRIMARY KEY (`id_stock`), KEY `id_product` (`id_product`), KEY `id_product_attribute` (`id_product_attribute`), KEY `id_shop` (`id_shop`), UNIQUE KEY `product_stock` (`id_product` ,`id_product_attribute` ,`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_stock' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, id_product_attribute, 1, quantity FROM ps1_product_attribute)</sqlQuery><sqlMsgError>Unknown column 'id_shop' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_stock` (id_product, id_product_attribute, id_shop, quantity) (SELECT id_product, 0, 1, IF( (SELECT COUNT(*) FROM ps1_product_attribute pa WHERE p.id_product = pa.id_product) > 0, (SELECT SUM(pa2.quantity) FROM ps1_product_attribute pa2 WHERE p.id_product = pa2.id_product), quantity ) FROM ps1_product p)</sqlQuery><sqlMsgError>Unknown column 'id_shop' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE ps1_stock_mvt ADD id_stock INT UNSIGNED NOT NULL AFTER id_stock_mvt</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>UPDATE ps1_stock_mvt sm SET sm.id_stock = IFNULL(( SELECT IFNULL(s.id_stock, 0) FROM ps1_stock s WHERE s.id_product = sm.id_product AND s.id_product_attribute = sm.id_product_attribute ORDER BY s.id_shop LIMIT 1 ), 0)</sqlQuery><sqlMsgError>Unknown column 's.id_shop' in 'order clause'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>DELETE FROM ps1_stock_mvt WHERE id_stock = 0</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE ps1_stock_mvt DROP id_product, DROP id_product_attribute</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_country_shop` ( `id_country` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_country`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_country_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_country_shop` (id_shop, id_country) (SELECT 1, id_country FROM ps1_country)</sqlQuery><sqlMsgError>Duplicate entry '4-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_carrier_shop` ( `id_carrier` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_carrier`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_carrier_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_carrier_shop` (id_shop, id_carrier) (SELECT 1, id_carrier FROM ps1_carrier)</sqlQuery><sqlMsgError>Duplicate entry '24-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>/* PHP:upgrade_cms_15(); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_lang_shop` ( `id_lang` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_lang`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_lang_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_lang_shop` (id_shop, id_lang) (SELECT 1, id_lang FROM ps1_lang)</sqlQuery><sqlMsgError>Duplicate entry '4-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_currency_shop` ( `id_currency` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_currency`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_currency_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_currency_shop` (id_shop, id_currency) (SELECT 1, id_currency FROM ps1_currency)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_cart` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_cart` , ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`, ADD INDEX `id_group_shop` (`id_group_shop`), ADD INDEX `id_shop` (`id_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_customer` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_customer` , ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`, ADD INDEX `id_group_shop` (`id_group_shop`), ADD INDEX `id_shop` (`id_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_orders` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_order` , ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`, ADD INDEX `id_group_shop` (`id_group_shop`), ADD INDEX `id_shop` (`id_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_customer_thread` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_customer_thread`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_customer_thread` ADD INDEX `id_shop` (`id_shop`), ADD INDEX `id_lang` (`id_lang`), ADD INDEX `id_contact` (`id_contact`), ADD INDEX `id_customer` (`id_customer`), ADD INDEX `id_order` (`id_order`), ADD INDEX `id_product` (`id_product`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_customer_message` ADD INDEX `id_employee` (`id_employee`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_meta_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_meta`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_meta_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_meta`, `id_shop`, `id_lang`), ADD INDEX `id_shop` (`id_shop`), ADD INDEX `id_lang` (`id_lang`)</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_contact_shop` ( `id_contact` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_contact`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_contact_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_contact_shop` (id_shop, id_contact) (SELECT 1, id_contact FROM `ps1_contact`)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_image_shop` ( `id_image` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_image`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_image_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_image_shop` (id_shop, id_image) (SELECT 1, id_image FROM ps1_image)</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_attribute_group_shop` ( `id_attribute` INT(11) UNSIGNED NOT NULL, `id_group_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_attribute`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_attribute_group_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_attribute_group_shop` (id_group_shop, id_attribute) (SELECT 1, id_attribute FROM ps1_attribute)</sqlQuery><sqlMsgError>Unknown column 'id_group_shop' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_feature_group_shop` ( `id_feature` INT(11) UNSIGNED NOT NULL, `id_group_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_feature`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_feature_group_shop` (id_group_shop, id_feature) (SELECT 1, id_feature FROM ps1_feature)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_group_group_shop` ( `id_group` INT( 11 ) UNSIGNED NOT NULL, `id_group_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_group`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_group_group_shop` (id_group_shop, id_group) (SELECT 1, id_group FROM ps1_group)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_attribute_group_group_shop` ( `id_attribute_group` INT( 11 ) UNSIGNED NOT NULL , `id_group_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_attribute_group`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_attribute_group_group_shop` (id_group_shop, id_attribute_group) (SELECT 1, id_attribute_group FROM ps1_attribute_group)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_tax_rules_group_group_shop` ( `id_tax_rules_group` INT( 11 ) UNSIGNED NOT NULL, `id_group_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_tax_rules_group`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_tax_rules_group_group_shop` (`id_tax_rules_group`, `id_group_shop`) (SELECT `id_tax_rules_group`, 1 FROM `ps1_tax_rules_group`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_zone_group_shop` ( `id_zone` INT( 11 ) UNSIGNED NOT NULL , `id_group_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_zone`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_zone_group_shop` (id_group_shop, id_zone) (SELECT 1, id_zone FROM ps1_zone)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_manufacturer_group_shop` ( `id_manufacturer` INT( 11 ) UNSIGNED NOT NULL , `id_group_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_manufacturer`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_manufacturer_group_shop` (id_group_shop, id_manufacturer) (SELECT 1, id_manufacturer FROM ps1_manufacturer)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_supplier_group_shop` ( `id_supplier` INT( 11 ) UNSIGNED NOT NULL, `id_group_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_supplier`, `id_group_shop`), KEY `id_group_shop` (`id_group_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_supplier_group_shop` (id_group_shop, id_supplier) (SELECT 1, id_supplier FROM ps1_supplier)</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_store_shop` ( `id_store` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_store`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_store_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_store_shop` (id_shop, id_store) (SELECT 1, id_store FROM ps1_store)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_product_shop` ( `id_product` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY ( `id_shop` , `id_product` ), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_product_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_product_shop` (id_shop, id_product) (SELECT 1, id_product FROM ps1_product)</sqlQuery><sqlMsgError>Duplicate entry '11-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_category_lang` ADD `id_shop` INT( 11 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_category`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_category_lang` ADD UNIQUE KEY( `id_category`, `id_shop`, `id_lang`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_product_lang` ADD `id_shop` INT( 11 ) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_product`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_product_lang` ADD UNIQUE KEY ( `id_product`, `id_shop` , `id_lang`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_specific_price` CHANGE `id_shop` `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1'</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_hook_module` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_hook`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_hook_module` DROP PRIMARY KEY</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_hook_module` ADD PRIMARY KEY (`id_module`,`id_hook`,`id_shop` )</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_hook_module_exceptions` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_hook`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_connections` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1', ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1'</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_page_viewed` ADD `id_group_shop` INT UNSIGNED NOT NULL DEFAULT '1' AFTER `id_page`, ADD `id_shop` INT UNSIGNED NOT NULL DEFAULT '1' AFTER `id_group_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_page_viewed` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_page`, `id_date_range`, `id_shop`)</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_module_shop` ( `id_module` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_module` , `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_module_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_module_shop` (`id_module`, `id_shop`) (SELECT `id_module`, 1 FROM `ps1_module`)</sqlQuery><sqlMsgError>Duplicate entry '99-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_currency` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_module`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_currency` DROP PRIMARY KEY</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_currency` ADD PRIMARY KEY (`id_module`, `id_shop`, `id_currency`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_country` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_module`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_country` DROP PRIMARY KEY</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_country` ADD PRIMARY KEY (`id_module`, `id_shop`, `id_country`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_group` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_module`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_group` DROP PRIMARY KEY</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_module_group` ADD PRIMARY KEY (`id_module`, `id_shop`, `id_group`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_carrier_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_carrier`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>/* PHP:add_id_shop_to_shipper_lang_index(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_search_word` ADD `id_shop` INT(11) NOT NULL DEFAULT '1' AFTER `id_word`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_search_word` DROP INDEX `id_lang`, ADD UNIQUE `id_lang` (`id_lang`,`id_shop`,`word`)</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_referrer_shop` ( `id_referrer` int(10) unsigned NOT NULL auto_increment, `id_shop` int(10) unsigned NOT NULL default '1', `cache_visitors` int(11) default NULL, `cache_visits` int(11) default NULL, `cache_pages` int(11) default NULL, `cache_registrations` int(11) default NULL, `cache_orders` int(11) default NULL, `cache_sales` decimal(17,2) default NULL, `cache_reg_rate` decimal(5,4) default NULL, `cache_order_rate` decimal(5,4) default NULL, PRIMARY KEY (`id_referrer`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_referrer_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_referrer_shop` (`id_referrer`, `id_shop`) SELECT `id_referrer`, 1 FROM `ps1_referrer`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_referrer` DROP `cache_visitors`, DROP `cache_visits`, DROP `cache_pages`, DROP `cache_registrations`, DROP `cache_orders`, DROP `cache_sales`, DROP `cache_reg_rate`, DROP `cache_order_rate`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_cart_product` ADD `id_shop` INT NOT NULL DEFAULT '1' AFTER `id_product`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_customization` ADD `in_cart` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0'</sqlQuery></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>CREATE TABLE `ps1_scene_shop` ( `id_scene` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_scene`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_scene_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.0"><sqlQuery>INSERT INTO `ps1_scene_shop` (id_shop, id_scene) (SELECT 1, id_scene FROM ps1_scene)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>ALTER TABLE `ps1_delivery` ADD `id_shop` INT UNSIGNED NULL DEFAULT NULL AFTER `id_delivery`, ADD `id_group_shop` INT UNSIGNED NULL DEFAULT NULL AFTER `id_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.0"><sqlQuery>/* PHP:create_multistore(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_module_access` ( `id_profile` int(10) unsigned NOT NULL, `id_module` int(10) unsigned NOT NULL, `view` tinyint(1) NOT NULL, `configure` tinyint(1) NOT NULL, PRIMARY KEY (`id_profile`,`id_module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* Create SuperAdmin */ UPDATE `ps1_profile_lang` SET `name` = 'SuperAdmin' WHERE `id_profile` = 1</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_accounting_zone_shop` ( `id_accounting_zone_shop` int(11) NOT NULL AUTO_INCREMENT, `id_zone` int(11) NOT NULL, `id_shop` int(11) NOT NULL, `account_number` varchar(64) NOT NULL, PRIMARY KEY (`id_accounting_zone_shop`), UNIQUE KEY `id_zone` (`id_zone`,`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_accounting_product_zone_shop` ( `id_accounting_product_zone_shop` int(11) NOT NULL AUTO_INCREMENT, `id_product` int(11) NOT NULL, `id_shop` int(11) NOT NULL, `id_zone` int(11) NOT NULL, `account_number` varchar(64) NOT NULL, PRIMARY KEY (`id_accounting_product_zone_shop`), UNIQUE KEY `id_product` (`id_product`,`id_shop`,`id_zone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_accounting_tab(); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_module_access` (`id_profile`, `id_module`, `configure`, `view`) ( SELECT `id_profile`, `id_module`, 0, 1 FROM `ps1_access` a, ps1_module m WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` WHERE `class_name` != "" LIMIT 1) AND a.`view` = 0 )</sqlQuery><sqlMsgError>Duplicate entry '2-99' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_module_access` (`id_profile`, `id_module`, `configure`, `view`) ( SELECT `id_profile`, `id_module`, 1, 1 FROM `ps1_access` a, ps1_module m WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` WHERE `class_name` != "" LIMIT 1) AND a.`view` = 1 )</sqlQuery><sqlMsgError>Duplicate entry '1-99' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_tab` SET `class_name` = 'AdminThemes' WHERE `class_name` = 'AdminAppearance'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_hook` ( `name` , `title` , `description` , `position` , `live_edit` ) VALUES ('taxmanager', 'taxmanager', NULL , '1', '0')</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_tax_rule` ADD `zipcode_from` INT NOT NULL AFTER `id_state` , ADD `zipcode_to` INT NOT NULL AFTER `zipcode_from` , ADD `behavior` INT NOT NULL AFTER `zipcode_to`, ADD `description` VARCHAR( 100 ) NOT NULL AFTER `id_tax`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_tax_rule` (`id_tax_rules_group`, `id_country`, `id_state`, `id_tax`, `behavior`, `zipcode_from`, `zipcode_to`, `id_county`, `description`, `state_behavior`, `county_behavior`) SELECT r.`id_tax_rules_group`, r.`id_country`, r.`id_state`, r.`id_tax`, 0, z.`from_zip_code`, z.`to_zip_code`, r.`id_county`, r.`description`, r.`state_behavior`, r.county_behavior FROM `ps1_tax_rule` r INNER JOIN `ps1_county_zip_code` z ON (z.`id_county` = r.`id_county`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_tax_rule` SET `behavior` = GREATEST(`state_behavior`, `county_behavior`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>DELETE FROM `ps1_tax_rule` WHERE `id_county` != 0 AND `zipcode_from` = 0</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_tax_rule` DROP `id_county`, DROP `state_behavior`, DROP `county_behavior`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:remove_tab(AdminCounty); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>DROP TABLE `ps1_county_zip_code`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>DROP TABLE `ps1_county`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_employee` ADD `id_last_order` tinyint(1) unsigned NOT NULL default '0', ADD `id_last_customer_message` tinyint(1) unsigned NOT NULL default '0', ADD `id_last_customer` tinyint(1) unsigned NOT NULL default '0'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_SHOW_NEW_ORDERS', '1', NOW(), NOW()), ('PS_SHOW_NEW_CUSTOMERS', '1', NOW(), NOW()), ('PS_SHOW_NEW_MESSAGES', '1', NOW(), NOW()), ('PS_FEATURE_FEATURE_ACTIVE', '1', NOW(), NOW()), ('PS_COMBINATION_FEATURE_ACTIVE', '1', NOW(), NOW()), ('PS_ADMINREFRESH_NOTIFICATION', '1', NOW(), NOW())</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:update_feature_detachable_cache(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product` ADD `available_date` DATE NOT NULL AFTER `available_for_order`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product_attribute` ADD `available_date` DATE NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* Index was only used by deprecated function Image::positionImage() */ ALTER TABLE `ps1_image` DROP INDEX `product_position`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_gender` ( `id_gender` int(11) NOT NULL AUTO_INCREMENT, `type` tinyint(1) NOT NULL, PRIMARY KEY (`id_gender`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_gender_lang` ( `id_gender` int(10) unsigned NOT NULL, `id_lang` int(10) unsigned NOT NULL, `name` varchar(20) NOT NULL, PRIMARY KEY (`id_gender`,`id_lang`), KEY `id_gender` (`id_gender`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_gender` (`id_gender`, `type`) VALUES (1, 0), (2, 1), (3, 1)</sqlQuery><sqlMsgError>Duplicate entry '1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_gender_lang` (`id_gender`, `id_lang`, `name`) VALUES (1, 1, 'Mr.'), (1, 2, 'M.'), (1, 3, 'Sr.'), (1, 4, 'Herr'), (1, 5, 'Sig.'), (2, 1, 'Ms.'), (2, 2, 'Mme'), (2, 3, 'Sra.'), (2, 4, 'Frau'), (2, 5, 'Sig.ra'), (3, 1, 'Miss'), (3, 2, 'Melle'), (3, 3, 'Miss'), (3, 4, 'Miss'), (3, 5, 'Miss')</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>DELETE FROM `ps1_configuration` WHERE `name` = 'PS_FORCE_SMARTY_2'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_order_detail_tax` ( `id_order_detail` INT NOT NULL , `id_tax` INT NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_tax` ADD `deleted` INT NOT NULL AFTER `active`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:update_order_detail_taxes(); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_customer_message_sync_imap` ( `md5_header` varbinary(32) NOT NULL, KEY `md5_header_index` (`md5_header`(4)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_customer_message_sync_imap' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_customer_message` ADD `private` TINYINT NOT NULL DEFAULT '0' AFTER `user_agent`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_tab(AdminGenders, fr:Genres|es:Genders|en:Genders|de:Genders|it:Genders, 2); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_attribute` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_attribute_position(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product_download` CHANGE `date_deposit` `date_add` DATETIME NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product_download` CHANGE `physically_filename` `filename` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product_download` ADD `id_product_attribute` INT( 10 ) UNSIGNED NOT NULL AFTER `id_product` , ADD INDEX ( `id_product_attribute` )</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product_download` ADD `is_shareable` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `active`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_attribute_group` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_attribute_group` ADD `group_type` ENUM('select', 'radio', 'color') NOT NULL DEFAULT 'select'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_attribute_group` SET `group_type`='color' WHERE `is_color_group` = 1</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product` DROP `id_color_default`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_group_attribute_position(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_feature` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_feature_position(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_request_sql` ( `id_request_sql` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `sql` text NOT NULL, PRIMARY KEY (`id_request_sql`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_tab(AdminRequestSql, fr:SQL Manager|es:SQL Manager|en:SQL Manager|de:Wunsh|it:SQL Manager, 9); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_carrier` ADD COLUMN `id_reference` int(10) NOT NULL AFTER `id_carrier`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_carrier` SET id_reference = id_carrier</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_product` ADD `is_virtual` TINYINT( 1 ) NOT NULL DEFAULT '0' AFTER `cache_has_attachments`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_tab(AdminProducts, fr:Produits|es:Productos|en:Products|de:Produkten|it:Prodotti, 1); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_tab(AdminCategories, fr:Catégories|es:Categoria|en:Categories|de:Kategorien|it:Categories, 1); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_employee_shop` ( `id_employee` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY ( `id_employee` , `id_shop` ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_employee_shop` (`id_employee`, `id_shop`) (SELECT `id_employee`, 1 FROM `ps1_employee`)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_access` SET `view` = 0, `add` = 0, `edit` = 0, `delete` = 0 WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminShop' LIMIT 1) AND `id_profile` != 1</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_carrier` ADD `position` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_carrier_position(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_state` ADD COLUMN `shipped` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `delivery`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_order_state` SET `shipped` = 1 WHERE id_order_state IN (4, 5)</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_order_invoice` ( `id_order_invoice` int(11) NOT NULL AUTO_INCREMENT, `id_order` int(11) NOT NULL, `number` int(11) NOT NULL, `total_discount_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_discount_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_paid_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_paid_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_products` decimal(17,2) NOT NULL DEFAULT '0.00', `total_products_wt` decimal(17,2) NOT NULL DEFAULT '0.00', `total_shipping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_shipping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_wrapping_tax_excl` decimal(17,2) NOT NULL DEFAULT '0.00', `total_wrapping_tax_incl` decimal(17,2) NOT NULL DEFAULT '0.00', `date_add` datetime NOT NULL, PRIMARY KEY (`id_order_invoice`), KEY `id_order` (`id_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_order_invoice' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_detail` ADD `id_order_invoice` int(11) NOT NULL DEFAULT 0 AFTER `id_order`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_payment_cc` CHANGE `id_payment_cc` `id_order_payment` INT NOT NULL auto_increment</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_payment_cc` ADD `id_order_invoice` varchar(255) NOT NULL AFTER `id_order_payment`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_payment_cc` ADD `payment_method` varchar(255) NOT NULL AFTER `amount`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_payment_cc` ADD `conversion_rate` decimal(13,6) NOT NULL DEFAULT 1 AFTER `payment_method`</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>RENAME TABLE `ps1_payment_cc` TO `ps1_order_payment`</sqlQuery><sqlMsgError>Table 'ps1_order_payment' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_carrier` ADD COLUMN `max_width` int(10) DEFAULT 0 AFTER `position`, ADD COLUMN `max_height` int(10) DEFAULT 0 AFTER `max_width`, ADD COLUMN `max_depth` int(10) DEFAULT 0 AFTER `max_height`, ADD COLUMN `max_weight` int(10) DEFAULT 0 AFTER `max_depth`, ADD COLUMN `grade` int(10) DEFAULT 0 AFTER `max_weight`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart_product` ADD COLUMN `id_address_delivery` int(10) UNSIGNED DEFAULT 0 AFTER `date_add`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_cart_product` SET id_address_delivery = 0</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart` ADD COLUMN `allow_seperated_package` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `gift_message`</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_product_carrier` ( `id_product` int(10) unsigned NOT NULL, `id_carrier_reference` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, PRIMARY KEY (`id_product`, `id_carrier_reference`, `id_shop`) ) ENGINE = InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_product_carrier' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_customization` ADD COLUMN `id_address_delivery` int(10) UNSIGNED NOT NULL DEFAULT 0 AFTER `id_product_attribute`, DROP PRIMARY KEY, ADD PRIMARY KEY (`id_customization`, `id_cart`, `id_product`, `id_address_delivery`)</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_cart_rule` ( `id_cart_rule` int(10) unsigned NOT NULL auto_increment, `id_customer` int unsigned NOT NULL default 0, `date_from` datetime NOT NULL, `date_to` datetime NOT NULL, `description` text, `quantity` int(10) unsigned NOT NULL default 0, `quantity_per_user` int(10) unsigned NOT NULL default 0, `priority` int(10) unsigned NOT NULL default 1, `code` varchar(254) NOT NULL, `minimum_amount` decimal(17,2) NOT NULL default 0, `minimum_amount_tax` tinyint(1) NOT NULL default 0, `minimum_amount_currency` int unsigned NOT NULL default 0, `minimum_amount_shipping` tinyint(1) NOT NULL default 0, `country_restriction` tinyint(1) unsigned NOT NULL default 0, `carrier_restriction` tinyint(1) unsigned NOT NULL default 0, `group_restriction` tinyint(1) unsigned NOT NULL default 0, `cart_rule_restriction` tinyint(1) unsigned NOT NULL default 0, `product_restriction` tinyint(1) unsigned NOT NULL default 0, `free_shipping` tinyint(1) NOT NULL default 0, `reduction_percent` decimal(5,2) NOT NULL default 0, `reduction_amount` decimal(17,2) NOT NULL default 0, `reduction_tax` tinyint(1) unsigned NOT NULL default 0, `reduction_currency` int(10) unsigned NOT NULL default 0, `reduction_product` int(10) NOT NULL default 0, `gift_product` int(10) unsigned NOT NULL default 0, `active` tinyint(1) unsigned NOT NULL default 0, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_cart_rule`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_cart_rule_country` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_country` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_country`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_country' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_cart_rule_group` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_group` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_group' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_cart_rule_carrier` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_carrier` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_carrier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_carrier' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_cart_rule_combination` ( `id_cart_rule_1` int(10) unsigned NOT NULL, `id_cart_rule_2` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule_1`, `id_cart_rule_2`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_combination' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_cart_rule_product_rule` ( `id_product_rule` int(10) unsigned NOT NULL auto_increment, `id_cart_rule` int(10) unsigned NOT NULL, `quantity` int(10) unsigned NOT NULL default 1, `type` ENUM('products', 'categories', 'attributes') NOT NULL, PRIMARY KEY (`id_product_rule`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_product_rule' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>SET @id_currency_default = (SELECT value FROM `ps1_configuration` WHERE name = 'PS_CURRENCY_DEFAULT' LIMIT 1)</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_cart_rule` ( `id_cart_rule`, `id_customer`, `date_from`, `date_to`, `description`, `quantity`, `quantity_per_user`, `priority`, `code`, `minimum_amount`, `minimum_amount_tax`, `minimum_amount_currency`, `minimum_amount_shipping`, `country_restriction`, `carrier_restriction`, `group_restriction`, `cart_rule_restriction`, `product_restriction`, `free_shipping`, `reduction_percent`, `reduction_amount`, `reduction_tax`, `reduction_currency`, `reduction_product`, `gift_product`, `active`, `date_add`, `date_upd` ) ( SELECT `id_discount`, `id_customer`, `date_from`, `date_to`, `name`, `quantity`, `quantity_per_user`, 1, `name`, `minimal`, 1, @id_currency_default, 1, 0, 0, IF(id_group = 0, 0, 1), IF(cumulable = 1, 0, 1), 0, IF(id_discount_type = 3, 1, 0), IF(id_discount_type = 1, value, 0), IF(id_discount_type = 2, value, 0), 1, `id_currency`, 0, 0, `active`, `date_add`, `date_upd` FROM `ps1_discount` )</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>RENAME TABLE `ps1_discount_lang` TO `ps1_cart_rule_lang`</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_lang' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart_rule_lang` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL</sqlQuery><sqlMsgError>Unknown column 'id_discount' in 'ps1_cart_rule_lang'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart_rule_lang` CHANGE `description` `name` varchar(254) NOT NULL</sqlQuery><sqlMsgError>Unknown column 'description' in 'ps1_cart_rule_lang'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>RENAME TABLE `ps1_discount_category` TO `ps1_cart_rule_product_rule_value`</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_product_rule_value' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart_rule_product_rule_value` CHANGE `id_category` `id_item` int(10) unsigned NOT NULL</sqlQuery><sqlMsgError>Unknown column 'id_category' in 'ps1_cart_rule_product_rule_value'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart_rule_product_rule_value` CHANGE `id_discount` `id_product_rule` int(10) unsigned NOT NULL</sqlQuery><sqlMsgError>Unknown column 'id_discount' in 'ps1_cart_rule_product_rule_value'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_cart_rule_product_rule` (`id_product_rule`, `id_cart_rule`, `quantity`, `type`) ( SELECT DISTINCT `id_product_rule`, `id_product_rule`, 1, 'categories' FROM `ps1_cart_rule_product_rule_value` )</sqlQuery><sqlMsgError>Unknown column 'id_cart_rule' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_cart_rule` SET product_restriction = 1 WHERE `id_cart_rule` IN (SELECT `id_cart_rule` FROM `ps1_cart_rule_product_rule`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart_discount` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_discount` CHANGE `id_discount` `id_cart_rule` int(10) unsigned NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_discount` CHANGE `id_order_discount` `id_order_cart_rule` int(10) unsigned NOT NULL AUTO_INCREMENT</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>RENAME TABLE `ps1_order_discount` TO `ps1_order_cart_rule`</sqlQuery><sqlMsgError>Table 'ps1_order_cart_rule' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>RENAME TABLE `ps1_cart_discount` TO `ps1_cart_cart_rule`</sqlQuery><sqlMsgError>Table 'ps1_cart_cart_rule' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_configuration` (`name`, `value`, `date_add`, `date_upd`) ( SELECT 'PS_CART_RULE_FEATURE_ACTIVE', `value`, NOW(), NOW() FROM `ps1_configuration` WHERE `name` = 'PS_DISCOUNT_FEATURE_ACTIVE' LIMIT 1 )</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_tab` SET class_name = 'AdminCartRules' WHERE class_name = 'AdminDiscounts'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayPayment' WHERE `name` = 'payment'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionValidateOrder' WHERE `name` = 'newOrder'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionPaymentConfirmation' WHERE `name` = 'paymentConfirm'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayPaymentReturn' WHERE `name` = 'paymentReturn'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionUpdateQuantity' WHERE `name` = 'updateQuantity'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayRightColumn' WHERE `name` = 'rightColumn'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayLeftColumn' WHERE `name` = 'leftColumn'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayHome' WHERE `name` = 'home'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayHeader' WHERE `name` = 'header'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionCartSave' WHERE `name` = 'cart'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionAuthentication' WHERE `name` = 'authentication'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductAdd' WHERE `name` = 'addproduct'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductUpdate' WHERE `name` = 'updateproduct'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayTop' WHERE `name` = 'top'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayRightColumnProduct' WHERE `name` = 'extraRight'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductDelete' WHERE `name` = 'deleteproduct'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayFooterProduct' WHERE `name` = 'productfooter'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayInvoice' WHERE `name` = 'invoice'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionOrderStatusUpdate' WHERE `name` = 'updateOrderStatus'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAdminOrder' WHERE `name` = 'adminOrder'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayFooter' WHERE `name` = 'footer'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayPDFInvoice' WHERE `name` = 'PDFInvoice'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAdminCustomers' WHERE `name` = 'adminCustomers'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayOrderConfirmation' WHERE `name` = 'orderConfirmation'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionCustomerAccountAdd' WHERE `name` = 'createAccount'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayCustomerAccount' WHERE `name` = 'customerAccount'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionOrderSlipAdd' WHERE `name` = 'orderSlip'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayProductTab' WHERE `name` = 'productTab'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayProductTabContent' WHERE `name` = 'productTabContent'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayShoppingCartFooter' WHERE `name` = 'shoppingCart'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayCustomerAccountForm' WHERE `name` = 'createAccountForm'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAdminStatsModules' WHERE `name` = 'AdminStatsModules'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAdminStatsGraphEngine' WHERE `name` = 'GraphEngine'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionOrderReturn' WHERE `name` = 'orderReturn'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayProductButtons' WHERE `name` = 'productActions'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayBackOfficeHome' WHERE `name` = 'backOfficeHome'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAdminStatsGridEngine' WHERE `name` = 'GridEngine'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionWatermark' WHERE `name` = 'watermark'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductCancel' WHERE `name` = 'cancelProduct'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayLeftColumnProduct' WHERE `name` = 'extraLeft'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductOutOfStock' WHERE `name` = 'productOutOfStock'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductAttributeUpdate' WHERE `name` = 'updateProductAttribute'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayCarrierList' WHERE `name` = 'extraCarrier'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayShoppingCart' WHERE `name` = 'shoppingCartExtra'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionSearch' WHERE `name` = 'search'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayBeforePayment' WHERE `name` = 'backBeforePayment'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionCarrierUpdate' WHERE `name` = 'updateCarrier'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionOrderStatusPostUpdate' WHERE `name` = 'postUpdateOrderStatus'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayCustomerAccountFormTop' WHERE `name` = 'createAccountTop'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayBackOfficeHeader' WHERE `name` = 'backOfficeHeader'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayBackOfficeTop' WHERE `name` = 'backOfficeTop'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayBackOfficeFooter' WHERE `name` = 'backOfficeFooter'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductAttributeDelete' WHERE `name` = 'deleteProductAttribute'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionCarrierProcess' WHERE `name` = 'processCarrier'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionOrderDetail' WHERE `name` = 'orderDetail'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayBeforeCarrier' WHERE `name` = 'beforeCarrier'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayOrderDetail' WHERE `name` = 'orderDetailDisplayed'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionPaymentCCAdd' WHERE `name` = 'paymentCCAdded'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayProductComparison' WHERE `name` = 'extraProductComparison'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionCategoryAdd' WHERE `name` = 'categoryAddition'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionCategoryUpdate' WHERE `name` = 'categoryUpdate'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionCategoryDelete' WHERE `name` = 'categoryDeletion'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionBeforeAuthentication' WHERE `name` = 'beforeAuthentication'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayPaymentTop' WHERE `name` = 'paymentTop'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionHtaccessCreate' WHERE `name` = 'afterCreateHtaccess'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionAdminMetaSave' WHERE `name` = 'afterSaveAdminMeta'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAttributeGroupForm' WHERE `name` = 'attributeGroupForm'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionAttributeGroupSave' WHERE `name` = 'afterSaveAttributeGroup'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionAttributeGroupDelete' WHERE `name` = 'afterDeleteAttributeGroup'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayFeatureForm' WHERE `name` = 'featureForm'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionFeatureSave' WHERE `name` = 'afterSaveFeature'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionFeatureDelete' WHERE `name` = 'afterDeleteFeature'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductSave' WHERE `name` = 'afterSaveProduct'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionProductListOverride' WHERE `name` = 'productListAssign'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAttributeGroupPostProcess' WHERE `name` = 'postProcessAttributeGroup'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayFeaturePostProcess' WHERE `name` = 'postProcessFeature'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayFeatureValueForm' WHERE `name` = 'featureValueForm'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayFeatureValuePostProcess' WHERE `name` = 'postProcessFeatureValue'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionFeatureValueDelete' WHERE `name` = 'afterDeleteFeatureValue'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionFeatureValueSave' WHERE `name` = 'afterSaveFeatureValue'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'displayAttributeForm' WHERE `name` = 'attributeForm'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionAttributePostProcess' WHERE `name` = 'postProcessAttribute'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionAttributeDelete' WHERE `name` = 'afterDeleteAttribute'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionAttributeSave' WHERE `name` = 'afterSaveAttribute'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_hook` SET `name` = 'actionTaxManager' WHERE `name` = 'taxManager'</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_detail_tax` ADD `unit_amount` DECIMAL(16, 6) NOT NULL AFTER `id_tax`, ADD `total_amount` DECIMAL(16, 6) NOT NULL AFTER `unit_amount`</sqlQuery><sqlMsgError>Duplicate column name 'unit_amount'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD `id_product_attribute` INT UNSIGNED NOT NULL AFTER `id_product`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_specific_price` DROP INDEX `id_product`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD INDEX `id_product` (`id_product`, `id_product_attribute`, `id_shop`, `id_currency`, `id_country`, `id_group`, `from_quantity`, `from`, `to`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_column_orders_reference_if_not_exists(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_orders` ADD COLUMN `id_warehouse` int(10) unsigned DEFAULT 0 AFTER `id_carrier`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart` ADD COLUMN `order_reference` varchar(9) AFTER `id_cart`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_cart` ADD COLUMN `delivery_option` varchar(100) AFTER `id_carrier`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_tax` ADD COLUMN `account_number` VARCHAR(64) NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_tab(AdminAttributeGenerator, fr:Générateur de déclinaisons|es:Combinations generator|en:Combinations generator|de:Combinations generator|it:Combinations generator, -1); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_tab(AdminCMSCategories, fr:Catégories CMS|es:CMS categories|en:CMS categories|de:CMS categories|it:CMS categories, -1); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_tab(AdminCMS, fr:Pages CMS|es:CMS pages|en:CMS pages|de:CMS pages|it:CMS pages, -1); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_quick_access` SET `link` = 'index.php?controller=AdminCategories&addcategory' WHERE `id_quick_access` = 3</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_quick_access` SET `link` = 'index.php?controller=AdminProducts&addproduct' WHERE `id_quick_access` = 4</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminCmsCategories' LIMIT 1) AND `id_profile` = '3'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminCmsCategories' LIMIT 1) AND `id_profile` = '5'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminCms' LIMIT 1) AND `id_profile` = '3'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminCms' LIMIT 1) AND `id_profile` = '5'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CUSTOMER_GROUP', '1', NOW(), NOW())</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_groups('Visiteur', 'Visitor'); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>/* PHP:add_new_groups('Invité', 'Guest'); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_employee` SET `bo_theme` = 'default'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_tab` SET `class_name` = 'AdminCmsContent' WHERE `class_name` = 'AdminCMSContent'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_tab` SET `class_name` = 'AdminCms' WHERE `class_name` = 'AdminCMS'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_tab` SET `class_name` = 'AdminCmsCategories' WHERE `class_name` = 'AdminCMSCategories'</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>UPDATE `ps1_tab` SET `class_name` = 'AdminPdf' WHERE `class_name` = 'AdminPDF'</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_order_carrier` ( `id_order_carrier` int(11) NOT NULL AUTO_INCREMENT, `id_order` int(11) unsigned NOT NULL, `id_carrier` int(11) unsigned NOT NULL, `id_order_invoice` int(11) unsigned DEFAULT NULL, `weight` float DEFAULT NULL, `shipping_cost_tax_excl` decimal(20,6) DEFAULT NULL, `shipping_cost_tax_incl` decimal(20,6) DEFAULT NULL, `tracking_number` varchar(64) DEFAULT NULL, `date_add` datetime NOT NULL, PRIMARY KEY (`id_order_carrier`), KEY `id_order` (`id_order`), KEY `id_carrier` (`id_carrier`), KEY `id_order_invoice` (`id_order_invoice`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_order_carrier' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_slip` ADD COLUMN `amount` DECIMAL(10,2) NOT NULL AFTER `shipping_cost`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_slip` ADD COLUMN `shipping_cost_amount` DECIMAL(10,2) NOT NULL AFTER `amount`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_slip` ADD COLUMN `partial` TINYINT(1) NOT NULL AFTER `shipping_cost_amount`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>ALTER TABLE `ps1_order_slip_detail` ADD COLUMN `amount` DECIMAL(10,2) NOT NULL AFTER `product_quantity`</sqlQuery></request><request result="ok" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_tab` (`id_parent`, `class_name`, `position`) VALUES (-1, 'AdminLogin', 0)</sqlQuery></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>CREATE TABLE `ps1_hook_alias` ( `id_hook_alias` int(10) unsigned NOT NULL auto_increment, `alias` varchar(64) NOT NULL, `name` varchar(64) NOT NULL, PRIMARY KEY (`id_hook_alias`), UNIQUE KEY `alias` (`alias`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_hook_alias' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.1"><sqlQuery>INSERT INTO `ps1_hook_alias` (`id_hook_alias`, `name`, `alias`) VALUES (1, 'displayPayment', 'payment'), (2, 'actionValidateOrder', 'newOrder'), (3, 'actionPaymentConfirmation', 'paymentConfirm'), (4, 'displayPaymentReturn', 'paymentReturn'), (5, 'actionUpdateQuantity', 'updateQuantity'), (6, 'displayRightColumn', 'rightColumn'), (7, 'displayLeftColumn', 'leftColumn'), (8, 'displayHome', 'home'), (9, 'displayHeader', 'header'), (10, 'actionCartSave', 'cart'), (11, 'actionAuthentication', 'authentication'), (12, 'actionProductAdd', 'addproduct'), (13, 'actionProductUpdate', 'updateproduct'), (14, 'displayTop', 'top'), (15, 'displayRightColumnProduct', 'extraRight'), (16, 'actionProductDelete', 'deleteproduct'), (17, 'displayFooterProduct', 'productfooter'), (18, 'displayInvoice', 'invoice'), (19, 'actionOrderStatusUpdate', 'updateOrderStatus'), (20, 'displayAdminOrder', 'adminOrder'), (21, 'displayFooter', 'footer'), (22, 'displayPDFInvoice', 'PDFInvoice'), (23, 'displayAdminCustomers', 'adminCustomers'), (24, 'displayOrderConfirmation', 'orderConfirmation'), (25, 'actionCustomerAccountAdd', 'createAccount'), (26, 'displayCustomerAccount', 'customerAccount'), (27, 'actionOrderSlipAdd', 'orderSlip'), (28, 'displayProductTab', 'productTab'), (29, 'displayProductTabContent', 'productTabContent'), (30, 'displayShoppingCartFooter', 'shoppingCart'), (31, 'displayCustomerAccountForm', 'createAccountForm'), (32, 'displayAdminStatsModules', 'AdminStatsModules'), (33, 'displayAdminStatsGraphEngine', 'GraphEngine'), (34, 'actionOrderReturn', 'orderReturn'), (35, 'displayProductButtons', 'productActions'), (36, 'displayBackOfficeHome', 'backOfficeHome'), (37, 'displayAdminStatsGridEngine', 'GridEngine'), (38, 'actionWatermark', 'watermark'), (39, 'actionProductCancel', 'cancelProduct'), (40, 'displayLeftColumnProduct', 'extraLeft'), (41, 'actionProductOutOfStock', 'productOutOfStock'), (42, 'actionProductAttributeUpdate', 'updateProductAttribute'), (43, 'displayCarrierList', 'extraCarrier'), (44, 'displayShoppingCart', 'shoppingCartExtra'), (45, 'actionSearch', 'search'), (46, 'displayBeforePayment', 'backBeforePayment'), (47, 'actionCarrierUpdate', 'updateCarrier'), (48, 'actionOrderStatusPostUpdate', 'postUpdateOrderStatus'), (49, 'displayCustomerAccountFormTop', 'createAccountTop'), (50, 'displayBackOfficeHeader', 'backOfficeHeader'), (51, 'displayBackOfficeTop', 'backOfficeTop'), (52, 'displayBackOfficeFooter', 'backOfficeFooter'), (53, 'actionProductAttributeDelete', 'deleteProductAttribute'), (54, 'actionCarrierProcess', 'processCarrier'), (55, 'actionOrderDetail', 'orderDetail'), (56, 'displayBeforeCarrier', 'beforeCarrier'), (57, 'displayOrderDetail', 'orderDetailDisplayed'), (58, 'actionPaymentCCAdd', 'paymentCCAdded'), (59, 'displayProductComparison', 'extraProductComparison'), (60, 'actionCategoryAdd', 'categoryAddition'), (61, 'actionCategoryUpdate', 'categoryUpdate'), (62, 'actionCategoryDelete', 'categoryDeletion'), (63, 'actionBeforeAuthentication', 'beforeAuthentication'), (64, 'displayPaymentTop', 'paymentTop'), (65, 'actionHtaccessCreate', 'afterCreateHtaccess'), (66, 'actionAdminMetaSave', 'afterSaveAdminMeta'), (67, 'displayAttributeGroupForm', 'attributeGroupForm'), (68, 'actionAttributeGroupSave', 'afterSaveAttributeGroup'), (69, 'actionAttributeGroupDelete', 'afterDeleteAttributeGroup'), (70, 'displayFeatureForm', 'featureForm'), (71, 'actionFeatureSave', 'afterSaveFeature'), (72, 'actionFeatureDelete', 'afterDeleteFeature'), (73, 'actionProductSave', 'afterSaveProduct'), (74, 'actionProductListOverride', 'productListAssign'), (75, 'displayAttributeGroupPostProcess', 'postProcessAttributeGroup'), (76, 'displayFeaturePostProcess', 'postProcessFeature'), (77, 'displayFeatureValueForm', 'featureValueForm'), (78, 'displayFeatureValuePostProcess', 'postProcessFeatureValue'), (79, 'actionFeatureValueDelete', 'afterDeleteFeatureValue'), (80, 'actionFeatureValueSave', 'afterSaveFeatureValue'), (81, 'displayAttributeForm', 'attributeForm'), (82, 'actionAttributePostProcess', 'postProcessAttribute'), (83, 'actionAttributeDelete', 'afterDeleteAttribute'), (84, 'actionAttributeSave', 'afterSaveAttribute'), (85, 'actionTaxManager', 'taxManager')</sqlQuery><sqlMsgError>Duplicate entry '1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_tab` WHERE `id_tab` = 59</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_tab_lang` WHERE `id_tab` = 59 AND `id_lang` = 1</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_tab_lang` WHERE `id_tab` = 59 AND `id_lang` = 2</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_tab_lang` WHERE `id_tab` = 59 AND `id_lang` = 3</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_tab_lang` WHERE `id_tab` = 59 AND `id_lang` = 4</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_tab_lang` WHERE `id_tab` = 59 AND `id_lang` = 5</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_module` ADD `version` VARCHAR( 8 ) NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_specific_price_rule` ( `id_specific_price_rule` int(10) unsigned NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL, `id_shop` int(11) unsigned NOT NULL DEFAULT '1', `id_currency` int(10) unsigned NOT NULL, `id_country` int(10) unsigned NOT NULL, `id_group` int(10) unsigned NOT NULL, `from_quantity` mediumint(8) unsigned NOT NULL, `price` DECIMAL(20,6), `reduction` decimal(20,6) NOT NULL, `reduction_type` enum('amount','percentage') NOT NULL, `from` datetime NOT NULL, `to` datetime NOT NULL, PRIMARY KEY (`id_specific_price_rule`), KEY `id_product` (`id_shop`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`from`,`to`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE `ps1_specific_price_rule_condition_group` ( `id_specific_price_rule_condition_group` INT(11) UNSIGNED NOT NULL, `id_specific_price_rule` INT(11) UNSIGNED NOT NULL, PRIMARY KEY ( `id_specific_price_rule_condition_group`, `id_specific_price_rule` ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_specific_price_rule_condition_group' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE `ps1_specific_price_rule_condition` ( `id_specific_price_rule_condition` INT(11) UNSIGNED NOT NULL, `id_specific_price_rule_condition_group` INT(11) UNSIGNED NOT NULL, `type` VARCHAR(255) NOT NULL, `value` VARCHAR(255) NOT NULL, PRIMARY KEY (`id_specific_price_rule_condition`), INDEX (`id_specific_price_rule_condition_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_specific_price_rule_condition' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD `id_specific_price_rule` INT(11) UNSIGNED NOT NULL AFTER `id_specific_price`, ADD INDEX (`id_specific_price_rule`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* PHP:add_new_tab(AdminSpecificPriceRule, es:Catalog price rules|it:Catalog price rules|en:Catalog price rules|de:Catalog price rules|fr:Règles de prix catalogue, 1); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_invoice` ADD `note` TEXT NOT NULL AFTER `total_wrapping_tax_incl`</sqlQuery><sqlMsgError>Duplicate column name 'note'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* ORDER STATES */ ALTER TABLE `ps1_order_state` ADD `paid` TINYINT( 1 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `shipped`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_order_state` SET `paid` = 1 WHERE `id_order_state` IN (2, 3, 4, 5, 9, 12)</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* SPECIFIC PRICE */ ALTER TABLE `ps1_specific_price` ADD `id_customer` INT UNSIGNED NOT NULL AFTER `id_group`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_specific_price` DROP INDEX `id_product` , ADD INDEX `id_product` (`id_product`, `id_shop`, `id_currency`, `id_country`, `id_group`, `id_customer`, `from_quantity`, `from`, `to`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/************************ * STOCK MANAGEMENT *************************/ /* PHP:add_stock_tab(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_access` SET `view` = '1' WHERE `id_profile` = 5 AND `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminStock' LIMIT 1)</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminSupplyOrders' LIMIT 1) AND `id_profile` = '4'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminSupplyOrders' LIMIT 1) AND `id_profile` = '5'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminStockConfiguration' LIMIT 1) AND `id_profile` = '4'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_access` SET `view` = '0', `add` = '0', `edit` = '0', `delete` = '0' WHERE `id_tab` = (SELECT `id_tab` FROM `ps1_tab` t WHERE t.`class_name` = 'AdminStockConfiguration' LIMIT 1) AND `id_profile` = '5'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* New tables */ CREATE TABLE IF NOT EXISTS `ps1_product_supplier` ( `id_product_supplier` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_product` int(11) unsigned NOT NULL, `id_product_attribute` int(11) unsigned NOT NULL DEFAULT '0', `id_supplier` int(11) unsigned NOT NULL, `product_supplier_reference` varchar(32) DEFAULT NULL, `product_supplier_price_te` decimal(20,6) NOT NULL DEFAULT '0.000000', `id_currency` int(11) unsigned NOT NULL, PRIMARY KEY (`id_product_supplier`), UNIQUE KEY `id_product` (`id_product`,`id_product_attribute`,`id_supplier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_stock_available` ( `id_stock_available` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_product` int(11) unsigned NOT NULL, `id_product_attribute` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, `id_group_shop` int(11) unsigned NOT NULL, `quantity` int(10) NOT NULL DEFAULT '0', `depends_on_stock` tinyint(1) unsigned NOT NULL DEFAULT '0', `out_of_stock` int(2) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_stock_available`), KEY `id_shop` (`id_shop`), KEY `id_group_shop` (`id_group_shop`), KEY `id_product` (`id_product`), KEY `id_product_attribute` (`id_product_attribute`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_supply_order` ( `id_supply_order` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_supplier` int(11) unsigned NOT NULL, `supplier_name` varchar(64) NOT NULL, `id_lang` int(11) unsigned NOT NULL, `id_warehouse` int(11) unsigned NOT NULL, `id_supply_order_state` int(11) unsigned NOT NULL, `id_currency` int(11) unsigned NOT NULL, `id_ref_currency` int(11) unsigned NOT NULL, `reference` varchar(32) NOT NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, `date_delivery_expected` datetime DEFAULT NULL, `total_te` decimal(20,6) DEFAULT '0.000000', `total_with_discount_te` decimal(20,6) DEFAULT '0.000000', `total_tax` decimal(20,6) DEFAULT '0.000000', `total_ti` decimal(20,6) DEFAULT '0.000000', `discount_rate` decimal(20,6) DEFAULT '0.000000', `discount_value_te` decimal(20,6) DEFAULT '0.000000', `is_template` tinyint(1) DEFAULT '0', PRIMARY KEY (`id_supply_order`), KEY `id_supplier` (`id_supplier`), KEY `id_warehouse` (`id_warehouse`), KEY `reference` (`reference`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_supply_order_detail` ( `id_supply_order_detail` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_supply_order` int(11) unsigned NOT NULL, `id_currency` int(11) unsigned NOT NULL, `id_product` int(11) unsigned NOT NULL, `id_product_attribute` int(11) unsigned NOT NULL, `reference` varchar(32) NOT NULL, `supplier_reference` varchar(32) NOT NULL, `name` varchar(128) NOT NULL, `ean13` varchar(13) DEFAULT NULL, `upc` varchar(12) DEFAULT NULL, `exchange_rate` decimal(20,6) DEFAULT '0.000000', `unit_price_te` decimal(20,6) DEFAULT '0.000000', `quantity_expected` int(11) unsigned NOT NULL, `quantity_received` int(11) unsigned NOT NULL, `price_te` decimal(20,6) DEFAULT '0.000000', `discount_rate` decimal(20,6) DEFAULT '0.000000', `discount_value_te` decimal(20,6) DEFAULT '0.000000', `price_with_discount_te` decimal(20,6) DEFAULT '0.000000', `tax_rate` decimal(20,6) DEFAULT '0.000000', `tax_value` decimal(20,6) DEFAULT '0.000000', `price_ti` decimal(20,6) DEFAULT '0.000000', `tax_value_with_order_discount` decimal(20,6) DEFAULT '0.000000', `price_with_order_discount_te` decimal(20,6) DEFAULT '0.000000', PRIMARY KEY (`id_supply_order_detail`), KEY `id_supply_order` (`id_supply_order`), KEY `id_product` (`id_product`), KEY `id_product_attribute` (`id_product_attribute`), KEY `id_product_product_attribute` (`id_product`,`id_product_attribute`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_supply_order_history` ( `id_supply_order_history` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_supply_order` int(11) unsigned NOT NULL, `id_employee` int(11) unsigned NOT NULL, `employee_lastname` varchar(32) DEFAULT '', `employee_firstname` varchar(32) DEFAULT '', `id_state` int(11) unsigned NOT NULL, `date_add` datetime NOT NULL, PRIMARY KEY (`id_supply_order_history`), KEY `id_supply_order` (`id_supply_order`), KEY `id_employee` (`id_employee`), KEY `id_state` (`id_state`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_supply_order_receipt_history` ( `id_supply_order_receipt_history` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_supply_order_detail` int(11) unsigned NOT NULL, `id_employee` int(11) unsigned NOT NULL, `employee_lastname` varchar(32) DEFAULT '', `employee_firstname` varchar(32) DEFAULT '', `id_supply_order_state` int(11) unsigned NOT NULL, `quantity` int(11) unsigned NOT NULL, `date_add` datetime NOT NULL, PRIMARY KEY (`id_supply_order_receipt_history`), KEY `id_supply_order_detail` (`id_supply_order_detail`), KEY `id_supply_order_state` (`id_supply_order_state`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_supply_order_state` ( `id_supply_order_state` int(11) unsigned NOT NULL AUTO_INCREMENT, `delivery_note` tinyint(1) NOT NULL DEFAULT '0', `editable` tinyint(1) NOT NULL DEFAULT '0', `receipt_state` tinyint(1) NOT NULL DEFAULT '0', `pending_receipt` tinyint(1) NOT NULL DEFAULT '0', `enclosed` tinyint(1) NOT NULL DEFAULT '0', `color` varchar(32) DEFAULT NULL, PRIMARY KEY (`id_supply_order_state`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_supply_order_state_lang` ( `id_supply_order_state` int(11) unsigned NOT NULL, `id_lang` int(11) unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, PRIMARY KEY (`id_supply_order_state`,`id_lang`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_warehouse` ( `id_warehouse` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_currency` int(11) unsigned NOT NULL, `id_address` int(11) unsigned NOT NULL, `id_employee` int(11) unsigned NOT NULL, `reference` varchar(32) DEFAULT NULL, `name` varchar(45) NOT NULL, `management_type` enum('WA','FIFO','LIFO') NOT NULL DEFAULT 'WA', `deleted` tinyint(1) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`id_warehouse`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_warehouse_carrier` ( `id_carrier` int(11) unsigned NOT NULL, `id_warehouse` int(11) unsigned NOT NULL, PRIMARY KEY (`id_warehouse`,`id_carrier`), KEY `id_warehouse` (`id_warehouse`), KEY `id_carrier` (`id_carrier`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_warehouse_product_location` ( `id_warehouse_product_location` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_product` int(11) unsigned NOT NULL, `id_product_attribute` int(11) unsigned NOT NULL, `id_warehouse` int(11) unsigned NOT NULL, `location` varchar(64) DEFAULT NULL, PRIMARY KEY (`id_warehouse_product_location`), UNIQUE KEY `id_product` (`id_product`,`id_product_attribute`,`id_warehouse`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_warehouse_shop` ( `id_shop` int(11) unsigned NOT NULL, `id_warehouse` int(11) unsigned NOT NULL, PRIMARY KEY (`id_warehouse`,`id_shop`), KEY `id_warehouse` (`id_warehouse`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>/* Update records before alter tables */ /* PHP:set_stock_available(); */</sqlQuery><phpMsgError>(products)Unknown column 'id_group_shop' in 'field list'</phpMsgError><phpNumberError>1054</phpNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* PHP:set_product_suppliers(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* Update tables */ DROP TABLE IF EXISTS `ps1_stock`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_stock` ( `id_stock` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `id_warehouse` INT(11) UNSIGNED NOT NULL, `id_product` INT(11) UNSIGNED NOT NULL, `id_product_attribute` INT(11) UNSIGNED NOT NULL, `reference` VARCHAR(32) NOT NULL, `ean13` VARCHAR(13) DEFAULT NULL, `upc` VARCHAR(12) DEFAULT NULL, `physical_quantity` INT(11) UNSIGNED NOT NULL, `usable_quantity` INT(11) UNSIGNED NOT NULL, `price_te` DECIMAL(20,6) DEFAULT '0.000000', PRIMARY KEY (`id_stock`), KEY `id_warehouse` (`id_warehouse`), KEY `id_product` (`id_product`), KEY `id_product_attribute` (`id_product_attribute`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DROP TABLE IF EXISTS `ps1_stock_mvt`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_stock_mvt` ( `id_stock_mvt` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `id_stock` INT(11) UNSIGNED NOT NULL, `id_order` INT(11) UNSIGNED DEFAULT NULL, `id_supply_order` INT(11) UNSIGNED DEFAULT NULL, `id_stock_mvt_reason` INT(11) UNSIGNED NOT NULL, `id_employee` INT(11) UNSIGNED NOT NULL, `employee_lastname` varchar(32) DEFAULT '', `employee_firstname` varchar(32) DEFAULT '', `physical_quantity` INT(11) UNSIGNED NOT NULL, `date_add` DATETIME NOT NULL, `sign` tinyint(1) NOT NULL DEFAULT 1, `price_te` DECIMAL(20,6) DEFAULT '0.000000', `last_wa` DECIMAL(20,6) DEFAULT '0.000000', `current_wa` DECIMAL(20,6) DEFAULT '0.000000', `referer` bigint UNSIGNED DEFAULT NULL, PRIMARY KEY (`id_stock_mvt`), KEY `id_stock` (`id_stock`), KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_orders` DROP COLUMN `id_warehouse`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_supplier` ADD COLUMN `id_address` int(10) unsigned NOT NULL default '0' AFTER `id_supplier`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_address` ADD COLUMN `id_warehouse` int(10) unsigned NOT NULL DEFAULT 0 AFTER `id_supplier`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_detail` ADD COLUMN `id_warehouse` int(10) unsigned NOT NULL default '0' AFTER `id_order_invoice`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_stock_mvt_reason` ADD COLUMN `deleted` tinyint(1) unsigned NOT NULL default '0' AFTER `date_upd`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_product` ADD COLUMN `advanced_stock_management` tinyint(1) default '0' NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* Update records after alter tables */ /* PHP:update_stock_mvt_reason(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_configuration` WHERE `name` = 'PS_PDF_ENCODING'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>DELETE FROM `ps1_configuration` WHERE `name` = 'PS_PDF_FONT'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_detail` ADD `reduction_amount_tax_incl` DECIMAL( 20, 6 ) NOT NULL AFTER `reduction_amount` , ADD `reduction_amount_tax_excl` DECIMAL( 20, 6 ) NOT NULL AFTER `reduction_amount_tax_incl`, ADD `total_price_tax_incl` DECIMAL(20, 6) NOT NULL AFTER `download_deadline`, ADD `total_price_tax_excl` DECIMAL(20, 6) NOT NULL AFTER `total_price_tax_incl`, ADD `unit_price_tax_incl` DECIMAL(20, 6) NOT NULL AFTER `total_price_tax_excl`, ADD `unit_price_tax_excl` DECIMAL(20, 6) NOT NULL AFTER `unit_price_tax_incl`, ADD `total_shipping_price_tax_incl` DECIMAL(20, 6) NOT NULL AFTER `unit_price_tax_excl`, ADD `total_shipping_price_tax_excl` DECIMAL(20, 6) NOT NULL AFTER `total_shipping_price_tax_incl`, ADD `purchase_supplier_price` DECIMAL(20, 6) NOT NULL AFTER `total_shipping_price_tax_excl`, ADD `original_product_price` DECIMAL(20, 6) NOT NULL AFTER `purchase_supplier_price`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_orders` ADD `total_discounts_tax_excl` decimal(17,2) NOT NULL AFTER `total_discounts`, ADD `total_discounts_tax_incl` decimal(17,2) NOT NULL AFTER `total_discounts_tax_excl`, ADD `total_paid_tax_excl` decimal(17,2) NOT NULL AFTER `total_paid`, ADD `total_paid_tax_incl` decimal(17,2) NOT NULL AFTER `total_paid_tax_excl`, ADD `total_shipping_tax_excl` decimal(17,2) NOT NULL AFTER `total_shipping`, ADD `total_shipping_tax_incl` decimal(17,2) NOT NULL AFTER `total_shipping_tax_excl`, ADD `total_wrapping_tax_excl` decimal(17,2) NOT NULL AFTER `total_wrapping`, ADD `total_wrapping_tax_incl` decimal(17,2) NOT NULL AFTER `total_wrapping_tax_excl`</sqlQuery></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_cart_rule` ADD `value_tax_excl` DECIMAL(17, 2) NOT NULL DEFAULT '0.00'</sqlQuery><sqlMsgError>Duplicate column name 'value_tax_excl'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_cart_rule` ADD `id_order_invoice` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `id_cart_rule`</sqlQuery><sqlMsgError>Duplicate column name 'id_order_invoice'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD `id_group_shop` INT(11) UNSIGNED NOT NULL AFTER `id_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* Generate order references */ UPDATE `ps1_orders` SET `reference` = id_order</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_detail` ADD `tax_computation_method` tinyint(1) unsigned NOT NULL default '0' AFTER `product_weight`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* PHP:migrate_orders(); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_invoice` ADD `delivery_number` int(0) NOT NULL DEFAULT '0' AFTER `number`</sqlQuery><sqlMsgError>Duplicate column name 'delivery_number'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_invoice` ADD `delivery_date` datetime AFTER `delivery_number`</sqlQuery><sqlMsgError>Duplicate column name 'delivery_date'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>INSERT INTO `ps1_order_invoice` (`id_order`, `number`, `total_discount_tax_excl`, `total_discount_tax_incl`, `total_paid_tax_excl`, `total_paid_tax_incl`, `total_products`, `total_products_wt`, `total_shipping_tax_excl`, `total_shipping_tax_incl`, `total_wrapping_tax_excl`, `total_wrapping_tax_incl`, `note`, `date_add`) ( SELECT `id_order`, `invoice_number`, `total_discounts_tax_excl`, `total_discounts_tax_incl`, `total_paid_tax_excl`, `total_paid_tax_incl`, `total_products`, `total_products_wt`, `total_shipping_tax_excl`, `total_shipping_tax_incl`, `total_wrapping_tax_excl`, `total_wrapping_tax_incl`, '', `invoice_date` FROM `ps1_orders` WHERE `invoice_number` != 0 )</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_tab` ADD `active` TINYINT(1) UNSIGNED NOT NULL DEFAULT '1'</sqlQuery></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_order_detail` od SET od.`id_order_invoice` = ( SELECT oi.`id_order_invoice` FROM `ps1_order_invoice` oi WHERE oi.`id_order` = od.`id_order` )</sqlQuery><sqlMsgError>Subquery returns more than 1 row</sqlMsgError><sqlNumberError>1242</sqlNumberError></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>INSERT INTO `ps1_order_carrier` (`id_order`, `id_carrier`, `id_order_invoice`, `weight`, `shipping_cost_tax_excl`, `shipping_cost_tax_incl`, `tracking_number`, `date_add`) ( SELECT `id_order`, `id_carrier`, ( SELECT oi.`id_order_invoice` FROM `ps1_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), ( SELECT SUM(`product_weight`) FROM `ps1_order_detail` od WHERE od.`id_order` = o.`id_order` ), `total_shipping_tax_excl`, `total_shipping_tax_incl`, `shipping_number`, `date_add` FROM `ps1_orders` o )</sqlQuery><sqlMsgError>Subquery returns more than 1 row</sqlMsgError><sqlNumberError>1242</sqlNumberError></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>INSERT IGNORE INTO `ps1_order_payment` (`id_order_invoice`, `id_order`, `id_currency`, `amount`, `payment_method`, `conversion_rate`, `date_add`) ( SELECT ( SELECT oi.`id_order_invoice` FROM `ps1_order_invoice` oi WHERE oi.`id_order` = o.`id_order` ), o.`id_order`, o.`id_currency`, o.`total_paid_real`, o.`payment`, o.`conversion_rate`, o.`date_add` FROM `ps1_orders` o LEFT JOIN `ps1_order_payment` op ON (op.`id_order` = o.`id_order`) WHERE op.`id_order_payment` IS NULL )</sqlQuery><sqlMsgError>Unknown column 'op.id_order' in 'on clause'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>INSERT INTO `ps1_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_SMARTY_CONSOLE', '0', NOW(), NOW()),('PS_INVOICE_MODEL', 'invoice', NOW(), NOW())</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD `id_cart` INT(11) UNSIGNED NOT NULL AFTER `id_specific_price_rule`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD INDEX `id_cart` (`id_cart`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* PHP:update_modules_multishop(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_tab` SET `position` = ( SELECT `position` FROM ( SELECT MAX(`position`)+1 as `position` FROM `ps1_tab` WHERE `id_parent` = 0 ) tmp ) WHERE `class_name` = 'AdminStock'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_tab` SET `position` = ( SELECT `position` FROM ( SELECT MAX(`position`)+1 as `position` FROM `ps1_tab` WHERE `id_parent` = 0 ) tmp ) WHERE `class_name` = 'AdminAccounting'</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_slip_detail` CHANGE `amount` `amount_tax_excl` DECIMAL( 10, 2 ) default NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_order_slip_detail` ADD COLUMN `amount_tax_incl` DECIMAL(10,2) default NULL AFTER `amount_tax_excl`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>/* PHP:drop_image_type_non_unique_index(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_image_type` ADD `id_theme` INT(11) NOT NULL AFTER `id_image_type`</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_image_type` ADD UNIQUE (`id_theme` ,`name`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>UPDATE `ps1_image_type` SET `id_theme`=1</sqlQuery></request><request result="fail" sqlfile="1.5.0.2"><sqlQuery>CREATE TABLE `ps1_webservice_account_shop` ( `id_webservice_account` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_webservice_account` , `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_webservice_account_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.2"><sqlQuery>ALTER TABLE `ps1_group` ADD `show_prices` tinyint(1) unsigned NOT NULL DEFAULT '1' AFTER `price_display_method`</sqlQuery></request><request result="ok" sqlfile="1.5.0.3"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="fail" sqlfile="1.5.0.3"><sqlQuery>ALTER TABLE `ps1_theme` ADD COLUMN directory varchar(64) NOT NULL</sqlQuery><sqlMsgError>Duplicate column name 'directory'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.3"><sqlQuery>UPDATE `ps1_theme` SET directory = name</sqlQuery></request><request result="ok" sqlfile="1.5.0.3"><sqlQuery>/* Supply Order modification as of 1.5.0.3 */ ALTER TABLE `ps1_supply_order` DROP INDEX `reference`</sqlQuery></request><request result="ok" sqlfile="1.5.0.3"><sqlQuery>ALTER TABLE `ps1_supply_order` ADD UNIQUE (`reference`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>/* PHP:add_column_order_state_deleted_if_not_exists(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_category` ADD COLUMN `is_root_category` tinyint(1) NOT NULL default '0' AFTER `position`</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>UPDATE `ps1_category` SET `is_root_category` = 1 WHERE `id_category` = 1</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_image_type` DROP `id_theme`</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_specific_price_rule_condition` CHANGE `id_specific_price_rule_condition` `id_specific_price_rule_condition` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_specific_price_rule_condition_group` CHANGE `id_specific_price_rule_condition_group` `id_specific_price_rule_condition_group` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>UPDATE `ps1_supply_order_state_lang` SET `name` = "order canceled" WHERE `name` = "order fenced" AND (`id_lang` = 1 OR `id_lang` = 3 OR `id_lang` = 4 OR `id_lang` = 5)</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>UPDATE `ps1_supply_order_state_lang` SET `name` = "Commande cloturée" WHERE `name` = "order fenced" AND id_lang = 2</sqlQuery></request><request result="fail" sqlfile="1.5.0.4"><sqlQuery>CREATE TABLE `ps1_category_shop` ( `id_category` int(11) NOT NULL, `id_shop` int(11) NOT NULL, PRIMARY KEY (`id_category`, `id_shop`), UNIQUE KEY `id_category_shop` (`id_category`,`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_category_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>/* PHP:generate_root_category_for_multishop(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>/* PHP:update_mailalerts_add_column_idshop(); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.4"><sqlQuery>CREATE TABLE `ps1_cart_rule_product_rule_group` ( `id_product_rule_group` int(10) unsigned NOT NULL auto_increment, `id_cart_rule` int(10) unsigned NOT NULL, `quantity` int(10) unsigned NOT NULL default 1, PRIMARY KEY (`id_product_rule_group`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_product_rule_group' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.4"><sqlQuery>INSERT INTO `ps1_cart_rule_product_rule_group` (`id_product_rule_group`, `id_cart_rule`, `quantity`) ( SELECT `id_cart_rule`, `id_cart_rule`, `quantity` FROM `ps1_cart_rule_product_rule` )</sqlQuery><sqlMsgError>Unknown column 'id_cart_rule' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_cart_rule_product_rule` CHANGE `id_cart_rule` `id_product_rule_group` int(10) unsigned NOT NULL</sqlQuery><sqlMsgError>Unknown column 'id_cart_rule' in 'ps1_cart_rule_product_rule'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_cart_rule_product_rule` CHANGE `type` `type` ENUM('products', 'categories', 'attributes', 'manufacturers', 'suppliers') NOT NULL</sqlQuery></request><request result="fail" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_cart_rule` ADD `partial_use` tinyint(1) unsigned NOT NULL default 0 AFTER `priority`</sqlQuery><sqlMsgError>Duplicate column name 'partial_use'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.4"><sqlQuery>ALTER TABLE `ps1_orders` ADD `current_state` int(10) unsigned NOT NULL default 0 AFTER `id_address_invoice`</sqlQuery></request><request result="ok" sqlfile="1.5.0.5"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="fail" sqlfile="1.5.0.5"><sqlQuery>ALTER TABLE `ps1_cart_rule` ADD `shop_restriction` tinyint(1) unsigned NOT NULL default 0 AFTER `product_restriction`</sqlQuery><sqlMsgError>Duplicate column name 'shop_restriction'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="fail" sqlfile="1.5.0.5"><sqlQuery>CREATE TABLE `ps1_cart_rule_shop` ( `id_cart_rule` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, PRIMARY KEY (`id_cart_rule`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_cart_rule_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.5"><sqlQuery>INSERT INTO `ps1_configuration`(`id_group_shop`, `id_shop`, `name`, `value`, `date_add`, `date_upd`) VALUES (NULL, NULL, 'PS_LOGO', 'logo.jpg', NOw(), NOW()), (NULL, NULL, 'PS_LOGO_MAIL', 'logo_mail.jpg', NOw(), NOW()), (NULL, NULL, 'PS_LOGO_INVOICE', 'logo_invoice.jpg', NOW(), NOW()), (NULL, NULL, 'PS_FAVICON', 'favicon.jpg', NOW(), NOW()), (NULL, NULL, 'PS_STORES_ICON', 'logo_stores.gif', NOW(), NOW())</sqlQuery></request><request result="fail" sqlfile="1.5.0.5"><sqlQuery>CREATE TABLE `ps1_module_preference` ( `id_module_preference` int(11) NOT NULL auto_increment, `id_employee` int(11) NOT NULL, `module` varchar(255) NOT NULL, `interest` tinyint(1) default NULL, `favorite` tinyint(1) default NULL, PRIMARY KEY (`id_module_preference`), UNIQUE KEY `employee_module` (`id_employee`, `module`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_module_preference' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.5"><sqlQuery>ALTER TABLE `ps1_category_shop` ADD `position` int(10) unsigned NOT NULL default 0 AFTER `id_shop`</sqlQuery><sqlMsgError>Duplicate column name 'position'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.6"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.6"><sqlQuery>UPDATE `ps1_orders` o SET o.`current_state` = ( SELECT oh.`id_order_state` FROM `ps1_order_history` oh WHERE oh.`id_order` = o.`id_order` ORDER BY oh.`date_add` DESC LIMIT 1 )</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>/* PHP:add_unknown_gender(); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_cart_rule` ADD `gift_product_attribute` int(10) unsigned NOT NULL default 0 AFTER `gift_product`</sqlQuery><sqlMsgError>Duplicate column name 'gift_product_attribute'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>UPDATE `ps1_product` set is_virtual = 1 WHERE id_product IN (SELECT id_product FROM `ps1_product_download` WHERE active = 1)</sqlQuery></request><request result="fail" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_product_shop` ADD `id_category_default` int(11) UNSIGNED DEFAULT NULL</sqlQuery><sqlMsgError>Duplicate column name 'id_category_default'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_employee` ADD `bo_width` int(10) unsigned NOT NULL DEFAULT 0 AFTER `bo_theme`</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>CREATE TABLE `ps1_product_tax_rules_group_shop` ( `id_product` int(11) UNSIGNED NOT NULL, `id_tax_rules_group` int(11) UNSIGNED NOT NULL, `id_shop` int(11) UNSIGNED NOT NULL, PRIMARY KEY ( `id_product`, `id_tax_rules_group`, `id_shop` ) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>INSERT INTO `ps1_product_tax_rules_group_shop` (`id_product`, `id_tax_rules_group`, `id_shop`) (SELECT `id_product`, `id_tax_rules_group`, `id_shop` FROM `ps1_product`, `ps1_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_product` DROP `id_tax_rules_group`</sqlQuery></request><request result="fail" sqlfile="1.5.0.7"><sqlQuery>CREATE TABLE `ps1_carrier_tax_rules_group_shop` ( `id_carrier` int(11) unsigned NOT NULL, `id_tax_rules_group` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, PRIMARY KEY (`id_carrier`, `id_tax_rules_group`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_carrier_tax_rules_group_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.7"><sqlQuery>INSERT INTO `ps1_carrier_tax_rules_group_shop` (`id_carrier`, `id_tax_rules_group`, `id_shop`) (SELECT `id_carrier`, `id_tax_rules_group`, `id_shop` FROM `ps1_carrier`, `ps1_shop`)</sqlQuery><sqlMsgError>Duplicate entry '1-0-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_carrier` DROP `id_tax_rules_group`</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_customer` ADD `account_number` VARCHAR(128) NULL AFTER `birthday`</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>/* PHP:fix_unique_specific_price(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_specific_price` DROP INDEX `id_product`</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD INDEX (`id_product`, `id_shop`, `id_currency`, `id_country`, `id_group`, `id_customer`, `from_quantity`, `from`, `to`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD UNIQUE (`id_product`,`id_shop`,`id_group_shop`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`from`,`to`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.7"><sqlQuery>ALTER TABLE `ps1_specific_price` ADD INDEX (`id_cart`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.8"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.8"><sqlQuery>ALTER TABLE `ps1_product` ADD `visibility` ENUM('both', 'catalog', 'search', 'none') NOT NULL default 'both' AFTER `indexed`</sqlQuery></request><request result="ok" sqlfile="1.5.0.8"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_accounting_export` ( `id_accounting_export` int(11) NOT NULL AUTO_INCREMENT, `begin_to` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `end_to` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', `type` int(11) NOT NULL, `file` varchar(256) NOT NULL, `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id_accounting_export`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.9"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.9"><sqlQuery>ALTER TABLE `ps1_employee` MODIFY COLUMN `id_last_order` INT(10) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `id_last_customer_message` INT(10) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `id_last_customer` INT(10) UNSIGNED NOT NULL DEFAULT 0</sqlQuery></request><request result="ok" sqlfile="1.5.0.9"><sqlQuery>ALTER TABLE `ps1_employee` ADD `default_tab` int(10) unsigned NOT NULL default 0 AFTER `bo_theme`</sqlQuery></request><request result="ok" sqlfile="1.5.0.9"><sqlQuery>DROP TABLE `ps1_subdomain`</sqlQuery></request><request result="ok" sqlfile="1.5.0.9"><sqlQuery>/* PHP:migrate_tabs_15(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.9"><sqlQuery>DROP TABLE IF EXISTS `ps1_order_tax`</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>/* PHP:module_blockwishlist_multishop(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>/* PHP:p15010_drop_column_id_address_if_exists(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>UPDATE `ps1_meta` SET `page` = 'contact' WHERE `page` = 'contact-form'</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>RENAME TABLE `ps1_group_shop` TO `ps1_shop_group`</sqlQuery><sqlMsgError>Table 'ps1_shop_group' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_shop_group` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL AUTO_INCREMENT</sqlQuery><sqlMsgError>Unknown column 'id_group_shop' in 'ps1_shop_group'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_shop` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery><sqlMsgError>Unknown column 'id_group_shop' in 'ps1_shop'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_stock_available` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery><sqlMsgError>Unknown column 'id_group_shop' in 'ps1_stock_available'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_cart` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_configuration` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_connections` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_customer` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_delivery` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_orders` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_page_viewed` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_specific_price` CHANGE `id_group_shop` `id_shop_group` INT( 11 ) UNSIGNED NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_product` ADD `id_tax_rules_group` int(10) unsigned NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_product_shop_TMP` ( `id_product` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, `id_category_default` int(10) unsigned DEFAULT NULL, `id_tax_rules_group` INT(11) UNSIGNED NOT NULL, `on_sale` tinyint(1) unsigned NOT NULL DEFAULT '0', `online_only` tinyint(1) unsigned NOT NULL DEFAULT '0', `ecotax` decimal(17,6) NOT NULL DEFAULT '0.000000', `minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1', `price` decimal(20,6) NOT NULL DEFAULT '0.000000', `wholesale_price` decimal(20,6) NOT NULL DEFAULT '0.000000', `unity` varchar(255) DEFAULT NULL, `unit_price_ratio` decimal(20,6) NOT NULL DEFAULT '0.000000', `additional_shipping_cost` decimal(20,2) NOT NULL DEFAULT '0.00', `customizable` tinyint(2) NOT NULL DEFAULT '0', `text_fields` tinyint(4) NOT NULL DEFAULT '0', `active` tinyint(1) unsigned NOT NULL DEFAULT '0', `available_for_order` tinyint(1) NOT NULL DEFAULT '1', `available_date` date NOT NULL, `condition` enum('new','used','refurbished') NOT NULL DEFAULT 'new', `show_price` tinyint(1) NOT NULL DEFAULT '1', `indexed` tinyint(1) NOT NULL DEFAULT '0', `visibility` enum('both','catalog','search','none') NOT NULL DEFAULT 'both', `cache_default_attribute` int(10) unsigned DEFAULT NULL, `advanced_stock_management` tinyint(1) default '0' NOT NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_product`, `id_shop`), KEY `id_category_default` (`id_category_default`), KEY `date_add` (`date_add`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_product_shop_TMP` (`id_product`, `id_shop`, `id_category_default`, `on_sale`, `online_only`, `ecotax`, `minimal_quantity`, `price`, `wholesale_price`, `unity`, `unit_price_ratio`, `additional_shipping_cost`, `customizable`, `text_fields`, `active`, `available_for_order`, `available_date`, `condition`, `show_price`, `indexed`, `visibility`, `cache_default_attribute`, `advanced_stock_management`, `date_add`, `date_upd`, `id_tax_rules_group`) (SELECT a.`id_product`, a.`id_shop`, b.`id_category_default`, b.`on_sale`, b.`online_only`, b.`ecotax`, b.`minimal_quantity`, b.`price`, b.`wholesale_price`, b.`unity`, b.`unit_price_ratio`, b.`additional_shipping_cost`, b.`customizable`, b.`text_fields`, b.`active`, b.`available_for_order`, b.`available_date`, b.`condition`, b.`show_price`, b.`indexed`, b.`visibility`, b.`cache_default_attribute`, b.`advanced_stock_management`, b.`date_add`, b.`date_upd`, c.`id_tax_rules_group` FROM `ps1_product_shop` a INNER JOIN `ps1_product` b ON a.id_product = b.id_product LEFT JOIN `ps1_product_tax_rules_group_shop` c ON b.id_product = c.id_product AND a.id_shop = c.id_shop)</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_product_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_product_tax_rules_group_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>RENAME TABLE `ps1_product_shop_TMP` TO `ps1_product_shop`</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_product_attribute_shop` ( `id_product_attribute` int(10) unsigned NOT NULL, `id_shop` int(10) unsigned NOT NULL, `wholesale_price` decimal(20,6) NOT NULL default '0.000000', `price` decimal(20,6) NOT NULL default '0.000000', `ecotax` decimal(17,6) NOT NULL default '0.00', `weight` float NOT NULL default '0', `unit_price_impact` decimal(17,2) NOT NULL default '0.00', `default_on` tinyint(1) unsigned NOT NULL default '0', `minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1', `available_date` date NOT NULL, PRIMARY KEY (`id_product_attribute`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_product_attribute_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_product_attribute_shop` (`id_product_attribute`, `id_shop`, `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date`) (SELECT `id_product_attribute`, (SELECT `value` FROM `ps1_configuration` WHERE `name` = 'PS_SHOP_DEFAULT'), `wholesale_price`, `price`, `ecotax`, `weight`, `unit_price_impact`, `default_on`, `minimal_quantity`, `available_date` FROM `ps1_product_attribute`)</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_attribute_shop` ( `id_attribute` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL, PRIMARY KEY (`id_attribute`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_attribute_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_attribute_shop` (`id_attribute`, `id_shop`) (SELECT a.id_attribute, c.id_shop FROM ps1_attribute_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery><sqlMsgError>Unknown column 'a.id_attribute' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_attribute_group_shop`</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_feature_shop` ( `id_feature` INT(11) UNSIGNED NOT NULL, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_feature`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_feature_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_feature_shop` (`id_feature`, `id_shop`) (SELECT a.id_feature, c.id_shop FROM ps1_feature_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery><sqlMsgError>Duplicate entry '6-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_feature_group_shop`</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_group_shop` ( `id_group` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_group_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_group_shop` (`id_group`, `id_shop`) (SELECT a.id_group, c.id_shop FROM ps1_group_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_group_group_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_attribute_group_shop` ( `id_attribute_group` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_attribute_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_attribute_group_shop` (`id_attribute_group`, `id_shop`) (SELECT a.id_attribute_group, c.id_shop FROM ps1_attribute_group_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_attribute_group_group_shop`</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_tax_rules_group_shop` ( `id_tax_rules_group` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_tax_rules_group`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_tax_rules_group_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_tax_rules_group_shop` (`id_tax_rules_group`, `id_shop`) (SELECT a.id_tax_rules_group, c.id_shop FROM ps1_tax_rules_group_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_tax_rules_group_group_shop`</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_zone_shop` ( `id_zone` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_zone`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_zone_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_zone_shop` (`id_zone`, `id_shop`) (SELECT a.id_zone, c.id_shop FROM ps1_zone_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_zone_group_shop`</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_manufacturer_shop` ( `id_manufacturer` INT( 11 ) UNSIGNED NOT NULL , `id_shop` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY (`id_manufacturer`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_manufacturer_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_manufacturer_shop` (`id_manufacturer`, `id_shop`) (SELECT a.id_manufacturer, c.id_shop FROM ps1_manufacturer_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery><sqlMsgError>Duplicate entry '3-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_manufacturer_group_shop`</sqlQuery></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>CREATE TABLE `ps1_supplier_shop` ( `id_supplier` INT( 11 ) UNSIGNED NOT NULL, `id_shop` INT( 11 ) UNSIGNED NOT NULL, PRIMARY KEY (`id_supplier`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_supplier_shop' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.10"><sqlQuery>INSERT INTO `ps1_supplier_shop` (`id_supplier`, `id_shop`) (SELECT a.id_supplier, c.id_shop FROM ps1_supplier_group_shop a LEFT JOIN ps1_shop_group b ON a.id_group_shop = b.id_shop_group INNER JOIN ps1_shop c ON b.id_shop_group = c.id_shop_group)</sqlQuery><sqlMsgError>Duplicate entry '1-1' for key 'PRIMARY'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>DROP TABLE `ps1_supplier_group_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.10"><sqlQuery>ALTER TABLE `ps1_product_download` DROP COLUMN `id_product_attribute`</sqlQuery></request><request result="ok" sqlfile="1.5.0.11"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>ALTER TABLE `ps1_state` CHANGE `iso_code` `iso_code` varchar(7) NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>DROP TABLE `ps1_accounting_export`</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>DROP TABLE `ps1_accounting_zone_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>DROP TABLE `ps1_accounting_product_zone_shop`</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>ALTER TABLE `ps1_tax` DROP `account_number`</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>ALTER TABLE `ps1_customer` DROP `account_number`</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>DELETE FROM `ps1_tab_lang` WHERE `id_tab` IN ( SELECT `id_tab` FROM `ps1_tab` WHERE `class_name` LIKE('%Accounting%') )</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>DELETE FROM `ps1_tab` WHERE `class_name` LIKE('%Accounting%')</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:move_translations_module_file(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>ALTER TABLE `ps1_tax_rule` CHANGE `zipcode_from` `zipcode_from` VARCHAR(12) NOT NULL, CHANGE `zipcode_to` `zipcode_to` VARCHAR(12) NOT NULL</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>UPDATE ps1_order_detail_tax odt LEFT JOIN ps1_tax t ON (t.id_tax = odt.id_tax) SET unit_amount = IFNULL(ROUND((t.rate / 100) * ( SELECT od.unit_price_tax_excl - ( o.total_discounts_tax_excl * ( od.unit_price_tax_excl / o.total_products )) FROM ps1_order_detail od LEFT JOIN ps1_orders o ON ( o.id_order = od.id_order) WHERE odt.id_order_detail = od.id_order_detail ), 2), 0)</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>UPDATE ps1_order_detail_tax odt LEFT JOIN ps1_order_detail od ON (od.id_order_detail = odt.id_order_detail) SET total_amount = IFNULL(odt.unit_amount * od.product_quantity, 0)</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:add_missing_shop_column_pagenotfound(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:editorial_update_multishop(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:update_module_product_comments(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:add_missing_columns_customer(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_risk` ( `id_risk` int(11) NOT NULL AUTO_INCREMENT, `percent` tinyint(3) NOT NULL, `color` varchar(32) NULL, PRIMARY KEY (`id_risk`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_risk_lang` ( `id_risk` int(10) unsigned NOT NULL, `id_lang` int(10) unsigned NOT NULL, `name` varchar(20) NOT NULL, PRIMARY KEY (`id_risk`,`id_lang`), KEY `id_risk` (`id_risk`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>UPDATE `ps1_tab` SET `class_name`="AdminShopGroup" WHERE class_name="AdminGroupShop"</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:upgrade_cms_15_rename(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:migrate_tabs_multi_shop(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:add_default_restrictions_modules_groups(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>/* PHP:p15012_add_missing_columns(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.12"><sqlQuery>UPDATE `ps1_specific_price` SET `price` = -1 WHERE `price` = 0</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>DROP TABLE IF EXISTS `ps1_discount`</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>DROP TABLE IF EXISTS `ps1_discount_type`</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>DROP TABLE IF EXISTS `ps1_discount_type_lang`</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>/* PHP:add_missing_image_key(); */</sqlQuery></request><request result="fail" sqlfile="1.5.0.13"><sqlQuery>-- Update order_payment structure for multishipping -- Step 1: Add the table ps_order_invoice_payment and populate it CREATE TABLE `ps1_order_invoice_payment` ( `id_order_invoice` int(11) unsigned NOT NULL, `id_order_payment` int(11) unsigned NOT NULL, `id_order` int(11) unsigned NOT NULL, PRIMARY KEY (`id_order_invoice`,`id_order_payment`), KEY `order_payment` (`id_order_payment`), KEY `id_order` (`id_order`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery><sqlMsgError>Table 'ps1_order_invoice_payment' already exists</sqlMsgError><sqlNumberError>1050</sqlNumberError></request><request result="fail" sqlfile="1.5.0.13"><sqlQuery>INSERT INTO `ps1_order_invoice_payment` (SELECT id_order_invoice, id_order_payment, id_order FROM `ps1_order_payment` WHERE id_order_invoice > 0)</sqlQuery><sqlMsgError>Unknown column 'id_order_invoice' in 'field list'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.13"><sqlQuery>-- Step 2: Add the collumn id_order_reference ALTER TABLE `ps1_order_payment` ADD COLUMN `order_reference` VARCHAR(9) AFTER `id_order`, ADD INDEX `order_reference`(`order_reference`)</sqlQuery><sqlMsgError>Unknown column 'id_order' in 'ps1_order_payment'</sqlMsgError><sqlNumberError>1054</sqlNumberError></request><request result="fail" sqlfile="1.5.0.13"><sqlQuery>-- Step 3: Fill in id_order_reference and merge duplicate lines /* PHP:add_order_reference_in_order_payment(); */</sqlQuery><phpMsgError></phpMsgError><phpNumberError></phpNumberError></request><request result="fail" sqlfile="1.5.0.13"><sqlQuery>-- Step 4: Drop collumn id_order ALTER TABLE `ps1_order_payment` DROP COLUMN `id_order`, DROP COLUMN `id_order_invoice`</sqlQuery><sqlMsgError>Can't DROP 'id_order'; check that column/key exists</sqlMsgError><sqlNumberError>1091</sqlNumberError></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>-- update for all employee the last ids for notifications UPDATE `ps1_employee` SET `id_last_order`= (SELECT IFNULL(MAX(`id_order`), 0) FROM `ps1_orders`), `id_last_customer_message`= (SELECT IFNULL(MAX(`id_customer_message`), 0) FROM `ps1_customer_message`), `id_last_customer`= (SELECT IFNULL(MAX(`id_customer`), 0) FROM `ps1_customer`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>UPDATE `ps1_category_shop` cs SET `position` = (SELECT `position` FROM `ps1_category` c WHERE cs.`id_category` = c.`id_category`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>ALTER TABLE `ps1_stock_available` CHANGE `out_of_stock` `out_of_stock` INT(2) UNSIGNED NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.0.13"><sqlQuery>/* PHP:p15013_add_missing_columns(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>/* PHP:p15014_copy_missing_images_tab_from_installer(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>/* PHP:p15014_add_missing_columns(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>/* PHP:p15014_upgrade_sekeywords(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>UPDATE `ps1_orders` SET `reference` = LPAD(reference, 9 , '0')</sqlQuery></request><request result="fail" sqlfile="1.5.0.14"><sqlQuery>INSERT INTO `ps1_hook_alias` (`name`, `alias`) VALUES ('displayMyAccountBlock', 'myAccountBlock')</sqlQuery><sqlMsgError>Duplicate entry 'myAccountBlock' for key 'alias'</sqlMsgError><sqlNumberError>1062</sqlNumberError></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>UPDATE `ps1_image_type` SET height = 189, width = 520 WHERE name = 'large_scene'</sqlQuery></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>CREATE TABLE IF NOT EXISTS `ps1_order_invoice_tax` ( `id_order_invoice` int(11) NOT NULL, `type` varchar(15) NOT NULL, `id_tax` int(11) NOT NULL, `amount` decimal(10,6) NOT NULL DEFAULT '0.000000' ) ENGINE=InnoDB DEFAULT CHARSET=utf8</sqlQuery></request><request result="fail" sqlfile="1.5.0.14"><sqlQuery>ALTER TABLE `ps1_order_invoice` ADD `shipping_tax_computation_method` INT NOT NULL AFTER `total_shipping_tax_incl`</sqlQuery><sqlMsgError>Duplicate column name 'shipping_tax_computation_method'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="ok" sqlfile="1.5.0.14"><sqlQuery>INSERT INTO `ps1_configuration`(`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_SEARCH_INDEXATION', '1', NOW(), NOW())</sqlQuery></request><request result="ok" sqlfile="1.5.0.15"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.15"><sqlQuery>/* PHP:p15015_blockadvertising_extension(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.15"><sqlQuery>ALTER TABLE `ps1_order_state` ADD `module_name` VARCHAR(255) NULL DEFAULT NULL AFTER `send_email`</sqlQuery></request><request result="ok" sqlfile="1.5.0.15"><sqlQuery>UPDATE `ps1_order_state` SET `module_name` = 'cheque' WHERE `id_order_state` = (SELECT `value` FROM `ps1_configuration` WHERE `name` = 'PS_OS_CHEQUE' LIMIT 1)</sqlQuery></request><request result="ok" sqlfile="1.5.0.15"><sqlQuery>UPDATE `ps1_order_state` SET `module_name` = 'bankwire' WHERE `id_order_state` = (SELECT `value` FROM `ps1_configuration` WHERE `name` = 'PS_OS_BANKWIRE' LIMIT 1)</sqlQuery></request><request result="ok" sqlfile="1.5.0.15"><sqlQuery>ALTER TABLE `ps1_product_shop` ADD `uploadable_files` TINYINT NOT NULL DEFAULT 0 AFTER `customizable`</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>/* PHP:p15016_add_missing_columns(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>ALTER TABLE `ps1_order_detail` ADD `id_shop` INT(11) UNSIGNED NOT NULL AFTER `id_warehouse`, ADD INDEX (`id_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>UPDATE `ps1_order_detail` od SET `id_shop`=(SELECT `id_shop` FROM `ps1_orders` WHERE `id_order`=od.`id_order`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>DELETE FROM `ps1_tab` WHERE `class_name` = 'AdminAddonsMyAccount'</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>DELETE FROM `ps1_tab_lang` WHERE `id_tab` NOT IN (SELECT `id_tab` FROM `ps1_tab`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>DELETE FROM `ps1_access` WHERE `id_tab` NOT IN (SELECT `id_tab` FROM `ps1_tab`)</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>UPDATE `ps1_employee` SET bo_theme = 'default'</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>ALTER TABLE `ps1_tax_rule` ADD INDEX `category_getproducts` ( `id_tax_rules_group` , `id_country` , `id_state` , `zipcode_from` )</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>ALTER TABLE `ps1_stock_available` ADD INDEX `product_sqlstock` ( `id_product` , `id_product_attribute` , `id_shop` )</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>ALTER TABLE `ps1_product` ADD `id_shop_default` int(10) unsigned NOT NULL default 1 AFTER `id_category_default`</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>UPDATE `ps1_product` p SET `id_shop_default` = IFNULL((SELECT MIN(id_shop) FROM `ps1_product_shop` ps WHERE ps.`id_product` = p.`id_product`), 1)</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>ALTER TABLE `ps1_category` ADD `id_shop_default` int(10) unsigned NOT NULL default 1 AFTER `id_parent`</sqlQuery></request><request result="ok" sqlfile="1.5.0.16"><sqlQuery>UPDATE `ps1_category` c SET `id_shop_default` = IFNULL((SELECT MIN(id_shop) FROM `ps1_category_shop` cs WHERE cs.`id_category` = c.`id_category`), 1)</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>ALTER TABLE `ps1_order_detail_tax` CHANGE `unit_amount` `unit_amount` DECIMAL(16, 6) NOT NULL DEFAULT '0.000000'</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>ALTER TABLE `ps1_order_detail_tax` CHANGE `total_amount` `total_amount` DECIMAL(16, 6) NOT NULL DEFAULT '0.000000'</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>ALTER TABLE `ps1_customer_message` ADD `read` tinyint(1) NOT NULL default '0' AFTER `private`</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>INSERT INTO `ps1_configuration`(`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_ALLOW_MOBILE_DEVICE', '1', NOW(), NOW())</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>/* PHP:p15017_add_id_shop_to_primary_key(); */</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>UPDATE `ps1_tab_lang` SET `name` = 'Menus' WHERE `name` = 'tabs' AND `id_tab` = (SELECT `id_tab` FROM `ps1_tab` WHERE `class_name` = 'AdminTabs' LIMIT 1) AND `id_lang` IN (SELECT `id_lang` FROM `ps1_lang` WHERE `iso_code` IN ('en','fr','es','de','it'))</sqlQuery></request><request result="ok" sqlfile="1.5.0.17"><sqlQuery>/* PHP:clean_tabs_15(); */</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="fail" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_image_shop` ADD `cover` TINYINT(1) UNSIGNED NOT NULL AFTER `id_shop`</sqlQuery><sqlMsgError>Duplicate column name 'cover'</sqlMsgError><sqlNumberError>1060</sqlNumberError></request><request result="fail" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_image_shop` DROP PRIMARY KEY</sqlQuery><sqlMsgError>Can't DROP 'PRIMARY'; check that column/key exists</sqlMsgError><sqlNumberError>1091</sqlNumberError></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_image_shop` ADD INDEX (`id_image`, `id_shop`, `cover`)</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>UPDATE `ps1_image_shop` image_shop SET image_shop.`cover`=1 WHERE `id_image` IN (SELECT `id_image` FROM `ps1_image` i WHERE i.`cover`=1)</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>INSERT INTO `ps1_configuration`(`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_ONE_PHONE_AT_LEAST', '1', NOW(), NOW())</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>/* PHP:p15018_change_image_types(); */</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_product` CHANGE `width` `width` DECIMAL(20, 6) NOT NULL DEFAULT '0', CHANGE `height` `height` DECIMAL(20, 6) NOT NULL DEFAULT '0', CHANGE `depth` `depth` DECIMAL(20, 6) NOT NULL DEFAULT '0', CHANGE `weight` `weight` DECIMAL(20, 6) NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_product_attribute` CHANGE `weight` `weight` DECIMAL(20, 6) NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_product_attribute_shop` CHANGE `weight` `weight` DECIMAL(20, 6) NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_order_carrier` CHANGE `weight` `weight` DECIMAL(20, 6) NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_attribute_impact` CHANGE `weight` `weight` DECIMAL(20, 6) NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_order_detail` CHANGE `product_weight` `product_weight` DECIMAL(20, 6) NOT NULL DEFAULT '0'</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_stock_available` DROP INDEX `product_sqlstock`</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_stock_available` ADD UNIQUE (`id_product`, `id_product_attribute`, `id_shop`)</sqlQuery></request><request result="ok" sqlfile="1.5.1.0"><sqlQuery>ALTER TABLE `ps1_cms` ADD INDEX (`id_cms_category`)</sqlQuery></request><request result="ok" sqlfile="1.5.2.0"><sqlQuery>SET NAMES 'utf8'</sqlQuery></request><request result="ok" sqlfile="1.5.2.0"><sqlQuery>ALTER TABLE `ps1_address` CHANGE `company` `company` VARCHAR(32) NULL</sqlQuery></request><request result="ok" sqlfile="1.5.2.0"><sqlQuery>/* PHP:fix_cms_shop_1520(); */</sqlQuery></request></action Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now