Errores Actulizacion

Beicker · June 27, 2014

Buenas tardes.

Me gustaría que alguien me ayudara.

Estoy intentando mi tienda y me da errores.

He realizado varios intentos para pasar de 1.3.X a 1.4.X y siempre tengo problemas de sql

Empece desde 1.3.1.1 a 1.3.3 OK

1.3.3 a 1.3.5 Ok

1.3.5 a 1.3.7OK

1.3.7 a 1.4.1 errores sql

Dejo listado con los errores por si alguien me puede ayudar, ya no se que hacer:

SET NAMES 'utf8'

ALTER TABLE `ps_employee` ADD `bo_color` varchar(32) default NULL AFTER `stats_date_to`

ALTER TABLE `ps_employee` ADD `bo_theme` varchar(32) default NULL AFTER `bo_color`

ALTER TABLE `ps_employee` ADD `bo_uimode` ENUM('hover','click') default 'click' AFTER `bo_theme`

ALTER TABLE `ps_employee` ADD `id_lang` int(10) unsigned NOT NULL default 0 AFTER `id_profile`

ALTER TABLE `ps_cms` ADD `id_cms_category` int(10) unsigned NOT NULL default '0' AFTER `id_cms`

ALTER TABLE `ps_cms` ADD `position` int(10) unsigned NOT NULL default '0' AFTER `id_cms_category`

CREATE TABLE `ps_cms_category` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_parent` int(10) unsigned NOT NULL, `level_depth` tinyint(3) unsigned NOT NULL DEFAULT '0', `active` tinyint(1) unsigned NOT NULL DEFAULT '0', `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, `position` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`id_cms_category`), KEY `category_parent` (`id_parent`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_cms_category' already exists

CREATE TABLE `ps_cms_category_lang` ( `id_cms_category` int(10) unsigned NOT NULL, `id_lang` int(10) unsigned NOT NULL, `name` varchar(128) NOT NULL, `description` text, `link_rewrite` varchar(128) NOT NULL, `meta_title` varchar(128) DEFAULT NULL, `meta_keywords` varchar(255) DEFAULT NULL, `meta_description` varchar(255) DEFAULT NULL, UNIQUE KEY `category_lang_index` (`id_cms_category`,`id_lang`), KEY `category_name` (`name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_cms_category_lang' already exists

INSERT INTO `ps_cms_category_lang` VALUES(1, 1, 'Home', '', 'home', NULL, NULL, NULL)

(1062) Duplicate entry '1-1' for key 'category_lang_index'

INSERT INTO `ps_cms_category_lang` VALUES(1, 2, 'Accueil', '', 'home', NULL, NULL, NULL)

(1062) Duplicate entry '1-2' for key 'category_lang_index'

INSERT INTO `ps_cms_category_lang` VALUES(1, 3, 'Inicio', '', 'home', NULL, NULL, NULL)

(1062) Duplicate entry '1-3' for key 'category_lang_index'

INSERT INTO `ps_cms_category` VALUES(1, 0, 0, 1, NOW(), NOW(),0)

(1062) Duplicate entry '1' for key 'PRIMARY'

UPDATE `ps_cms_category` SET `position` = 0

UPDATE `ps_cms` SET `position` = 0

UPDATE `ps_cms` SET `id_cms_category` = 0

ALTER TABLE `ps_category` ADD `position` int(10) unsigned NOT NULL default '0' AFTER `date_upd`

UPDATE `ps_employee` SET `id_lang` = (SELECT `value` FROM `ps_configuration` WHERE `name` LIKE "PS_LANG_DEFAULT")

ALTER TABLE `ps_customer` ADD `note` text AFTER `secure_key`

ALTER TABLE `ps_contact` ADD `customer_service` tinyint(1) NOT NULL DEFAULT 0 AFTER `email`

CREATE TABLE `ps_customer_thread` ( `id_customer_thread` int(11) unsigned NOT NULL auto_increment, `id_lang` int(10) unsigned NOT NULL, `id_contact` int(10) unsigned NOT NULL, `id_customer` int(10) unsigned default NULL, `id_order` int(10) unsigned default NULL, `id_product` int(10) unsigned default NULL, `status` enum('open','closed','pending1','pending2') NOT NULL default 'open', `email` varchar(128) NOT NULL, `token` varchar(12) default NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_customer_thread`), KEY `id_customer_thread` (`id_customer_thread`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_customer_thread' already exists

CREATE TABLE `ps_customer_message` ( `id_customer_message` int(10) unsigned NOT NULL auto_increment, `id_customer_thread` int(11) default NULL, `id_employee` int(10) unsigned default NULL, `message` text NOT NULL, `file_name` varchar(18) DEFAULT NULL, `ip_address` int(11) default NULL, `user_agent` varchar(128) default NULL, `date_add` datetime NOT NULL, PRIMARY KEY (`id_customer_message`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_customer_message' already exists

CREATE TABLE `ps_payment_cc` ( `id_payment_cc` INT NOT NULL auto_increment, `id_order` INT UNSIGNED NULL, `id_currency` INT UNSIGNED NOT NULL, `amount` DECIMAL(10,2) NOT NULL, `transaction_id` VARCHAR(254) NULL, `card_number` VARCHAR(254) NULL, `card_brand` VARCHAR(254) NULL, `card_expiration` CHAR(7) NULL, `card_holder` VARCHAR(254) NULL, `date_add` DATETIME NOT NULL, PRIMARY KEY (`id_payment_cc`), KEY `id_order` (`id_order`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_payment_cc' already exists

CREATE TABLE `ps_specific_price` ( `id_specific_price` INT UNSIGNED NOT NULL AUTO_INCREMENT, `id_product` INT UNSIGNED NOT NULL, `id_shop` TINYINT UNSIGNED NOT NULL, `id_currency` INT UNSIGNED NOT NULL, `id_country` INT UNSIGNED NOT NULL, `id_group` INT UNSIGNED NOT NULL, `priority` SMALLINT UNSIGNED NOT NULL, `price` DECIMAL(20, 6) NOT NULL, `from_quantity` SMALLINT UNSIGNED NOT NULL, `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`), KEY (`id_product`, `id_shop`, `id_currency`, `id_country`, `id_group`, `from_quantity`, `from`, `to`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_specific_price' already exists

INSERT INTO `ps_specific_price` (`id_product`, `id_shop`, `id_currency`, `id_country`, `id_group`, `priority`, `price`, `from_quantity`, `reduction`, `reduction_type`, `from`, `to`) ( SELECT dq.`id_product`, 1, 1, 0, 1, 0, 0.00, dq.`quantity`, IF(dq.`id_discount_type` = 2, dq.`value`, dq.`value` / 100), IF (dq.`id_discount_type` = 2, 'amount', 'percentage'), '0000-00-00 00:00:00', '0000-00-00 00:00:00' FROM `ps_discount_quantity` dq INNER JOIN `ps_product` p ON (p.`id_product` = dq.`id_product`) )

(1054) Unknown column 'priority' in 'field list'

DROP TABLE `ps_discount_quantity`

INSERT INTO `ps_specific_price` (`id_product`, `id_shop`, `id_currency`, `id_country`, `id_group`, `priority`, `price`, `from_quantity`, `reduction`, `reduction_type`, `from`, `to`) ( SELECT p.`id_product`, 1, 0, 0, 0, 0, 0.00, 1, IF(p.`reduction_price` > 0, p.`reduction_price`, p.`reduction_percent` / 100), IF(p.`reduction_price` > 0, 'amount', 'percentage'), IF (p.`reduction_from` = p.`reduction_to`, '0000-00-00 00:00:00', p.`reduction_from`), IF (p.`reduction_from` = p.`reduction_to`, '0000-00-00 00:00:00', p.`reduction_to`) FROM `ps_product` p WHERE p.`reduction_price` OR p.`reduction_percent` )

(1054) Unknown column 'priority' in 'field list'

ALTER TABLE `ps_product` DROP `reduction_price`, DROP `reduction_percent`, DROP `reduction_from`, DROP `reduction_to`

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_SPECIFIC_PRICE_PRIORITIES', 'id_shop;id_currency;id_country;id_group', NOW(), NOW()), ('PS_TAX_DISPLAY', 0, NOW(), NOW()), ('PS_SMARTY_FORCE_COMPILE', 1, NOW(), NOW()), ('PS_DISTANCE_UNIT', 'km', NOW(), NOW()), ('PS_STORES_DISPLAY_CMS', 0, NOW(), NOW()), ('PS_STORES_DISPLAY_FOOTER', 0, NOW(), NOW()), ('PS_STORES_SIMPLIFIED', 0, NOW(), NOW()), ('PS_STATSDATA_CUSTOMER_PAGESVIEWS', 1, NOW(), NOW()), ('PS_STATSDATA_PAGESVIEWS', 1, NOW(), NOW()), ('PS_STATSDATA_PLUGINS', 1, NOW(), NOW())

CREATE TABLE `ps_group_reduction` ( `id_group_reduction` MEDIUMINT UNSIGNED NOT NULL AUTO_INCREMENT, `id_group` INT(10) UNSIGNED NOT NULL, `id_category` INT(10) UNSIGNED NOT NULL, `reduction` DECIMAL(4, 3) NOT NULL, PRIMARY KEY(`id_group_reduction`), UNIQUE KEY(`id_group`, `id_category`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_group_reduction' already exists

CREATE TABLE `ps_product_group_reduction_cache` ( `id_product` INT UNSIGNED NOT NULL, `id_group` INT UNSIGNED NOT NULL, `reduction` DECIMAL(4, 3) NOT NULL, PRIMARY KEY(`id_product`, `id_group`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_product_group_reduction_cache' already exists

ALTER TABLE `ps_currency` ADD `iso_code_num` varchar(3) NOT NULL default '0' AFTER `iso_code`

UPDATE `ps_currency` SET iso_code_num = '978' WHERE iso_code LIKE 'EUR' LIMIT 1

UPDATE `ps_currency` SET iso_code_num = '840' WHERE iso_code LIKE 'USD' LIMIT 1

UPDATE `ps_currency` SET iso_code_num = '826' WHERE iso_code LIKE 'GBP' LIMIT 1

ALTER TABLE `ps_country` ADD `call_prefix` int(10) NOT NULL default '0' AFTER `iso_code`

UPDATE `ps_country` SET `call_prefix` = 49 WHERE `iso_code` = 'DE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 43 WHERE `iso_code` = 'AT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 32 WHERE `iso_code` = 'BE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 1 WHERE `iso_code` = 'CA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 86 WHERE `iso_code` = 'CN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 34 WHERE `iso_code` = 'ES' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 358 WHERE `iso_code` = 'FI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 33 WHERE `iso_code` = 'FR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 30 WHERE `iso_code` = 'GR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 39 WHERE `iso_code` = 'IT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 81 WHERE `iso_code` = 'JP' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 352 WHERE `iso_code` = 'LU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 31 WHERE `iso_code` = 'NL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 48 WHERE `iso_code` = 'PL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 351 WHERE `iso_code` = 'PT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 420 WHERE `iso_code` = 'CZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 44 WHERE `iso_code` = 'GB' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 46 WHERE `iso_code` = 'SE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 41 WHERE `iso_code` = 'CH' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 45 WHERE `iso_code` = 'DK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 1 WHERE `iso_code` = 'US' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 852 WHERE `iso_code` = 'HK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 47 WHERE `iso_code` = 'NO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 61 WHERE `iso_code` = 'AU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 65 WHERE `iso_code` = 'SG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 353 WHERE `iso_code` = 'IE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 64 WHERE `iso_code` = 'NZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 82 WHERE `iso_code` = 'KR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 972 WHERE `iso_code` = 'IL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 27 WHERE `iso_code` = 'ZA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 234 WHERE `iso_code` = 'NG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 225 WHERE `iso_code` = 'CI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 228 WHERE `iso_code` = 'TG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 591 WHERE `iso_code` = 'BO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 230 WHERE `iso_code` = 'MU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 40 WHERE `iso_code` = 'RO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 421 WHERE `iso_code` = 'SK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 213 WHERE `iso_code` = 'DZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 376 WHERE `iso_code` = 'AD' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 244 WHERE `iso_code` = 'AO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 54 WHERE `iso_code` = 'AR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 374 WHERE `iso_code` = 'AM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 297 WHERE `iso_code` = 'AW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 994 WHERE `iso_code` = 'AZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 973 WHERE `iso_code` = 'BH' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 880 WHERE `iso_code` = 'BD' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 501 WHERE `iso_code` = 'BZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 229 WHERE `iso_code` = 'BJ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 975 WHERE `iso_code` = 'BT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 267 WHERE `iso_code` = 'BW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 55 WHERE `iso_code` = 'BR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 673 WHERE `iso_code` = 'BN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 226 WHERE `iso_code` = 'BF' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 95 WHERE `iso_code` = 'MM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 257 WHERE `iso_code` = 'BI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 855 WHERE `iso_code` = 'KH' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 237 WHERE `iso_code` = 'CM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 238 WHERE `iso_code` = 'CV' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 236 WHERE `iso_code` = 'CF' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 235 WHERE `iso_code` = 'TD' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 56 WHERE `iso_code` = 'CL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 57 WHERE `iso_code` = 'CO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 269 WHERE `iso_code` = 'KM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 242 WHERE `iso_code` = 'CD' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 243 WHERE `iso_code` = 'CG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 506 WHERE `iso_code` = 'CR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 385 WHERE `iso_code` = 'HR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 53 WHERE `iso_code` = 'CU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 357 WHERE `iso_code` = 'CY' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 253 WHERE `iso_code` = 'DJ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 670 WHERE `iso_code` = 'TL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 593 WHERE `iso_code` = 'EC' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 20 WHERE `iso_code` = 'EG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 503 WHERE `iso_code` = 'SV' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 240 WHERE `iso_code` = 'GQ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 291 WHERE `iso_code` = 'ER' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 372 WHERE `iso_code` = 'EE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 251 WHERE `iso_code` = 'ET' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 298 WHERE `iso_code` = 'FO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 679 WHERE `iso_code` = 'FJ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 241 WHERE `iso_code` = 'GA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 220 WHERE `iso_code` = 'GM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 995 WHERE `iso_code` = 'GE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 233 WHERE `iso_code` = 'GH' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 299 WHERE `iso_code` = 'GL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 350 WHERE `iso_code` = 'GI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 590 WHERE `iso_code` = 'GP' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 502 WHERE `iso_code` = 'GT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 224 WHERE `iso_code` = 'GN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 245 WHERE `iso_code` = 'GW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 592 WHERE `iso_code` = 'GY' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 509 WHERE `iso_code` = 'HT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 379 WHERE `iso_code` = 'VA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 504 WHERE `iso_code` = 'HN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 354 WHERE `iso_code` = 'IS' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 91 WHERE `iso_code` = 'IN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 62 WHERE `iso_code` = 'ID' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 98 WHERE `iso_code` = 'IR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 964 WHERE `iso_code` = 'IQ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 962 WHERE `iso_code` = 'JO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 7 WHERE `iso_code` = 'KZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 254 WHERE `iso_code` = 'KE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 686 WHERE `iso_code` = 'KI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 850 WHERE `iso_code` = 'KP' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 965 WHERE `iso_code` = 'KW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 996 WHERE `iso_code` = 'KG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 856 WHERE `iso_code` = 'LA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 371 WHERE `iso_code` = 'LV' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 961 WHERE `iso_code` = 'LB' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 266 WHERE `iso_code` = 'LS' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 231 WHERE `iso_code` = 'LR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 218 WHERE `iso_code` = 'LY' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 423 WHERE `iso_code` = 'LI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 370 WHERE `iso_code` = 'LT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 853 WHERE `iso_code` = 'MO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 389 WHERE `iso_code` = 'MK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 261 WHERE `iso_code` = 'MG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 265 WHERE `iso_code` = 'MW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 60 WHERE `iso_code` = 'MY' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 960 WHERE `iso_code` = 'MV' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 223 WHERE `iso_code` = 'ML' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 356 WHERE `iso_code` = 'MT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 692 WHERE `iso_code` = 'MH' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 596 WHERE `iso_code` = 'MQ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 222 WHERE `iso_code` = 'MR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 36 WHERE `iso_code` = 'HU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 262 WHERE `iso_code` = 'YT' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 52 WHERE `iso_code` = 'MX' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 691 WHERE `iso_code` = 'FM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 373 WHERE `iso_code` = 'MD' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 377 WHERE `iso_code` = 'MC' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 976 WHERE `iso_code` = 'MN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 382 WHERE `iso_code` = 'ME' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 212 WHERE `iso_code` = 'MA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 258 WHERE `iso_code` = 'MZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 264 WHERE `iso_code` = 'NA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 674 WHERE `iso_code` = 'NR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 977 WHERE `iso_code` = 'NP' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 599 WHERE `iso_code` = 'AN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 687 WHERE `iso_code` = 'NC' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 505 WHERE `iso_code` = 'NI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 227 WHERE `iso_code` = 'NE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 683 WHERE `iso_code` = 'NU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 968 WHERE `iso_code` = 'OM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 92 WHERE `iso_code` = 'PK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 680 WHERE `iso_code` = 'PW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 507 WHERE `iso_code` = 'PA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 675 WHERE `iso_code` = 'PG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 595 WHERE `iso_code` = 'PY' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 51 WHERE `iso_code` = 'PE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 63 WHERE `iso_code` = 'PH' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 974 WHERE `iso_code` = 'QA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 262 WHERE `iso_code` = 'RE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 7 WHERE `iso_code` = 'RU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 250 WHERE `iso_code` = 'RW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 508 WHERE `iso_code` = 'PM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 685 WHERE `iso_code` = 'WS' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 378 WHERE `iso_code` = 'SM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 239 WHERE `iso_code` = 'ST' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 966 WHERE `iso_code` = 'SA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 221 WHERE `iso_code` = 'SN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 381 WHERE `iso_code` = 'RS' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 248 WHERE `iso_code` = 'SC' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 232 WHERE `iso_code` = 'SL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 386 WHERE `iso_code` = 'SI' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 677 WHERE `iso_code` = 'SB' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 252 WHERE `iso_code` = 'SO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 94 WHERE `iso_code` = 'LK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 249 WHERE `iso_code` = 'SD' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 597 WHERE `iso_code` = 'SR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 268 WHERE `iso_code` = 'SZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 963 WHERE `iso_code` = 'SY' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 886 WHERE `iso_code` = 'TW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 992 WHERE `iso_code` = 'TJ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 255 WHERE `iso_code` = 'TZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 66 WHERE `iso_code` = 'TH' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 690 WHERE `iso_code` = 'TK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 676 WHERE `iso_code` = 'TO' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 216 WHERE `iso_code` = 'TN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 90 WHERE `iso_code` = 'TR' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 993 WHERE `iso_code` = 'TM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 688 WHERE `iso_code` = 'TV' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 256 WHERE `iso_code` = 'UG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 380 WHERE `iso_code` = 'UA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 971 WHERE `iso_code` = 'AE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 598 WHERE `iso_code` = 'UY' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 998 WHERE `iso_code` = 'UZ' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 678 WHERE `iso_code` = 'VU' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 58 WHERE `iso_code` = 'VE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 84 WHERE `iso_code` = 'VN' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 681 WHERE `iso_code` = 'WF' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 967 WHERE `iso_code` = 'YE' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 260 WHERE `iso_code` = 'ZM' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 263 WHERE `iso_code` = 'ZW' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 355 WHERE `iso_code` = 'AL' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 93 WHERE `iso_code` = 'AF' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 387 WHERE `iso_code` = 'BA' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 359 WHERE `iso_code` = 'BG' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 682 WHERE `iso_code` = 'CK' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 594 WHERE `iso_code` = 'GF' LIMIT 1

UPDATE `ps_country` SET `call_prefix` = 689 WHERE `iso_code` = 'PF' LIMIT 1

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CONDITIONS_CMS_ID', IFNULL((SELECT `id_cms` FROM `ps_cms` WHERE `id_cms` = 3), 0), NOW(), NOW())

UPDATE `ps_configuration` SET `value` = IF((SELECT value FROM (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_CONDITIONS_CMS_ID')tmp), 1, 0) WHERE `name` = 'PS_CONDITIONS'

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CIPHER_ALGORITHM', 0, NOW(), NOW())

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_ORDER_PROCESS_TYPE', 0, NOW(), NOW())

ALTER TABLE `ps_product` ADD `minimal_quantity` INT NOT NULL DEFAULT '1' AFTER `quantity`

ALTER TABLE `ps_product` ADD `cache_default_attribute` int(10) unsigned default NULL AFTER `indexed`

ALTER TABLE `ps_product` ADD `cache_has_attachments` TINYINT(1) NOT NULL default '0' AFTER `indexed`

ALTER TABLE `ps_product` ADD `cache_is_pack` TINYINT(1) NOT NULL default '0' AFTER `indexed`

ALTER TABLE `ps_product` ADD `available_for_order` TINYINT(1) NOT NULL DEFAULT '1' AFTER `active`

ALTER TABLE `ps_product` ADD `show_price` TINYINT(1) NOT NULL DEFAULT '1' AFTER `available_for_order`

ALTER TABLE `ps_product` ADD `online_only` TINYINT(1) NOT NULL DEFAULT '0' AFTER `on_sale`

ALTER TABLE `ps_product` ADD `condition` ENUM('new', 'used', 'refurbished') NOT NULL DEFAULT 'new' AFTER `available_for_order`

ALTER TABLE `ps_product` ADD `upc` VARCHAR( 12 ) NULL AFTER `ean13`

ALTER TABLE `ps_product_attribute` ADD `upc` VARCHAR( 12 ) NULL AFTER `ean13`

SET @defaultOOS = (SELECT value FROM `ps_configuration` WHERE name = 'PS_ORDER_OUT_OF_STOCK')

/* Set 0 for every non-attribute product */ UPDATE `ps_product` p SET `cache_default_attribute` = 0 WHERE `id_product` NOT IN (SELECT `id_product` FROM `ps_product_attribute`)

/* First default attribute in stock */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND default_on = 1 AND quantity > 0 LIMIT 1) WHERE `cache_default_attribute` IS NULL

/* Then default attribute without stock if we don't care */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND default_on = 1 LIMIT 1) WHERE `cache_default_attribute` IS NULL AND `out_of_stock` = 1 OR `out_of_stock` = IF(@defaultOOS = 1, 2, 1)

/* Next, the default attribute can be any attribute with stock */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND quantity > 0 LIMIT 1) WHERE `cache_default_attribute` IS NULL

/* If there is still no default attribute, then we go back to the default one */ UPDATE `ps_product` p SET `cache_default_attribute` = (SELECT `id_product_attribute` FROM `ps_product_attribute` WHERE `id_product` = p.`id_product` AND default_on = 1 LIMIT 1) WHERE `cache_default_attribute` IS NULL

UPDATE `ps_product` p SET cache_is_pack = (SELECT IF(COUNT(*) > 0, 1, 0) FROM `ps_pack` pp WHERE pp.`id_product_pack` = p.`id_product`), cache_has_attachments = (SELECT IF(COUNT(*) > 0, 1, 0) FROM `ps_product_attachment` pa WHERE pa.`id_product` = p.`id_product`)

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('deleteProductAttribute', 'Product Attribute Deletion', NULL, 0)

INSERT INTO `ps_hook` (`name` ,`title` ,`description` ,`position`) VALUES ('beforeCarrier', 'Before carrier list', 'This hook is display before the carrier list on Front office', 1)

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('orderDetailDisplayed', 'Order detail displayed', 'Displayed on order detail on front office', 1)

INSERT INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES ((SELECT IFNULL((SELECT `id_module` FROM `ps_module` WHERE `name` = 'mailalerts'), 0)), (SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'deleteProductAttribute'), 1)

DELETE FROM `ps_hook_module` WHERE `id_module` = 0

ALTER TABLE `ps_country` ADD `need_zip_code` TINYINT(1) NOT NULL DEFAULT '1'

ALTER TABLE `ps_country` ADD `zip_code_format` VARCHAR(12) NOT NULL DEFAULT ''

ALTER TABLE `ps_product` ADD `unit_price` DECIMAL(20,6) NOT NULL DEFAULT '0.000000' AFTER `wholesale_price`

ALTER TABLE `ps_product` ADD `unity` VARCHAR(10) NOT NULL DEFAULT '0.000000' AFTER `unit_price`

ALTER TABLE `ps_product_attribute` ADD `unit_price_impact`DECIMAL(17,2) NOT NULL DEFAULT '0.00' AFTER `weight`

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_VOLUME_UNIT', 'cl', NOW(), NOW())

ALTER TABLE `ps_carrier` ADD `shipping_external` TINYINT( 1 ) UNSIGNED NOT NULL

ALTER TABLE `ps_carrier` ADD `external_module_name` varchar(64) DEFAULT NULL

ALTER TABLE `ps_carrier` ADD `need_range` TINYINT( 1 ) UNSIGNED NOT NULL

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('processCarrier', 'Carrier Process', NULL, 0)

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('orderDetail', 'Order Detail', 'To set the follow-up in smarty when order detail is called', 0)

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('paymentCCAdded', 'Payment CC added', 'Payment CC added', '0')

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('extraProductComparison', 'Extra Product Comparison', 'Extra Product Comparison', '0')

ALTER TABLE `ps_address` ADD `vat_number` varchar(32) NULL DEFAULT NULL AFTER `phone_mobile`

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_TAX_ADDRESS_TYPE', 'id_address_delivery', NOW(), NOW())

/* PHP:add_module_to_hook(blockpaymentlogo, header); */

/* PHP:add_module_to_hook(blockpermanentlinks, header); */

/* PHP:add_module_to_hook(blockviewed, header); */

/* PHP:add_module_to_hook(blockcart, header); */

/* PHP:add_module_to_hook(editorial, header); */

/* PHP:add_module_to_hook(blockbestsellers, header); */

/* PHP:add_module_to_hook(blockcategories, header); */

/* PHP:add_module_to_hook(blockspecials, header); */

/* PHP:add_module_to_hook(blockcurrencies, header); */

/* PHP:add_module_to_hook(blocknewproducts, header); */

/* PHP:add_module_to_hook(blockuserinfo, header); */

/* PHP:add_module_to_hook(blockcms, header); */

/* PHP:add_module_to_hook(blocklanguages, header); */

/* PHP:add_module_to_hook(blockmanufacturer, header); */

/* PHP:add_module_to_hook(blockadvertising, header); */

/* PHP:add_module_to_hook(blocktags, header); */

/* PHP:add_module_to_hook(blockmyaccount, header); */

ALTER TABLE `ps_product` ADD `additional_shipping_cost` DECIMAL(20,2) NOT NULL DEFAULT '0.000000' AFTER `unit_price`

ALTER TABLE `ps_currency` ADD `active` TINYINT(1) NOT NULL DEFAULT '1'

ALTER TABLE `ps_tax` ADD `active` TINYINT(1) NOT NULL DEFAULT '1'

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_ATTRIBUTE_CATEGORY_DISPLAY', 1, NOW(), NOW())

ALTER TABLE `ps_discount` ADD `cart_display` TINYINT( 4 ) NOT NULL AFTER `active` , ADD `date_add` DATETIME NOT NULL AFTER `cart_display` , ADD `date_upd` DATETIME NOT NULL AFTER `date_add`

ALTER TABLE `ps_carrier` ADD `shipping_method` INT( 2 ) NOT NULL DEFAULT '0'

CREATE TABLE `ps_stock_mvt` ( `id_stock_mvt` int(11) unsigned NOT NULL AUTO_INCREMENT, `id_product` int(11) unsigned DEFAULT NULL, `id_product_attribute` int(11) unsigned DEFAULT NULL, `id_order` int(11) unsigned DEFAULT NULL, `id_stock_mvt_reason` int(11) unsigned NOT NULL, `id_employee` int(11) unsigned NOT NULL, `quantity` int(11) NOT NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_stock_mvt`), KEY `id_order` (`id_order`), KEY `id_product` (`id_product`), KEY `id_product_attribute` (`id_product_attribute`), KEY `id_stock_mvt_reason` (`id_stock_mvt_reason`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_stock_mvt' already exists

CREATE TABLE `ps_stock_mvt_reason` ( `id_stock_mvt_reason` int(11) NOT NULL AUTO_INCREMENT, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_stock_mvt_reason`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_stock_mvt_reason' already exists

ALTER TABLE `ps_product` CHANGE `quantity` `quantity` INT( 10 ) NOT NULL DEFAULT '0'

ALTER TABLE `ps_product_attribute` CHANGE `quantity` `quantity` INT( 10 ) NOT NULL DEFAULT '0'

CREATE TABLE `ps_stock_mvt_reason_lang` ( `id_stock_mvt_reason` int(11) NOT NULL, `id_lang` int(11) NOT NULL, `name` varchar(255) CHARACTER SET utf8 NOT NULL, PRIMARY KEY (`id_stock_mvt_reason`,`id_lang`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_stock_mvt_reason_lang' already exists

INSERT INTO `ps_stock_mvt_reason` (`id_stock_mvt_reason`, `date_add`, `date_upd`) VALUES (1, NOW(), NOW()), (2, NOW(), NOW()), (3, NOW(), NOW())

(1062) Duplicate entry '1' for key 'PRIMARY'

INSERT INTO `ps_stock_mvt_reason_lang` (`id_stock_mvt_reason`, `id_lang`, `name`) VALUES (1, 1, 'Order'), (1, 2, 'Commande'), (2, 1, 'Missing Stock Movement'), (2, 2, 'Mouvement de stock manquant'), (3, 1, 'Restocking'), (3, 2, 'RÃ©assort')

(1062) Duplicate entry '1-1' for key 'PRIMARY'

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_COMPARATOR_MAX_ITEM', 0, NOW(), NOW())

ALTER TABLE `ps_meta_lang` ADD `url_rewrite` VARCHAR( 255 ) NOT NULL , ADD INDEX ( `url_rewrite` )

INSERT INTO `ps_meta` (`page`) VALUES ('address')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'address'), 'Address', 'address'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'address'), 'Adresse', 'adresse'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'address'), 'DirecciÃ³n', 'direccion')

INSERT INTO `ps_meta` (`page`) VALUES ('addresses')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'addresses'), 'Addresses', 'addresses'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'addresses'), 'Adresses', 'adresses'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'addresses'), 'Direcciones', 'direcciones')

INSERT INTO `ps_meta` (`page`) VALUES ('authentication')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'authentication'), 'Authentication', 'authentication'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'authentication'), 'Authentification', 'authentification'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'authentication'), 'AutenticaciÃ³n', 'autenticacion')

INSERT INTO `ps_meta` (`page`) VALUES ('cart')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'cart'), 'Cart', 'cart'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'cart'), 'Panier', 'panier'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'cart'), 'Carro de la compra', 'carro-de-la-compra')

INSERT INTO `ps_meta` (`page`) VALUES ('discount')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'discount'), 'Discount', 'discount'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'discount'), 'Bons de rÃ©duction', 'bons-de-reduction'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'discount'), 'Descuento', 'descuento')

INSERT INTO `ps_meta` (`page`) VALUES ('history')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'history'), 'Order history', 'order-history'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'history'), 'Historique des commandes', 'historique-des-commandes'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'history'), 'Historial de pedidos', 'historial-de-pedidos')

INSERT INTO `ps_meta` (`page`) VALUES ('identity')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'identity'), 'Identity', 'identity'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'identity'), 'IdentitÃ©', 'identite'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'identity'), 'Identidad', 'identidad')

INSERT INTO `ps_meta` (`page`) VALUES ('my-account')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'my-account'), 'My account', 'my-account'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'my-account'), 'Mon compte', 'mon-compte'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'my-account'), 'Mi Cuenta', 'mi-cuenta')

INSERT INTO `ps_meta` (`page`) VALUES ('order-follow')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order-follow'), 'Order follow', 'order-follow'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order-follow'), 'DÃ©tails de la commande', 'details-de-la-commande'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order-follow'), 'DevoluciÃ³n de productos', 'devolucion-de-productos')

INSERT INTO `ps_meta` (`page`) VALUES ('order-slip')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order-slip'), 'Order slip', 'order-slip'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order-slip'), 'Avoirs', 'avoirs'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order-slip'), 'Vales', 'vales')

INSERT INTO `ps_meta` (`page`) VALUES ('order')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order'), 'Order', 'order'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order'), 'Commande', 'commande'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order'), 'Carrito', 'carrito')

INSERT INTO `ps_meta` (`page`) VALUES ('search')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'search'), 'Search', 'search'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'search'), 'Recherche', 'recherche'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'search'), 'Buscar', 'buscar')

INSERT INTO `ps_meta` (`page`) VALUES ('stores')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) VALUES (1, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'stores'), 'Stores', 'stores'), (2, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'stores'), 'Magagins', 'magasins'), (3, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'stores'), 'Tiendas', 'tiendas')

ALTER TABLE `ps_manufacturer` ADD `active` tinyint(1) NOT NULL default 0

ALTER TABLE `ps_supplier` ADD `active` tinyint(1) NOT NULL default 0

UPDATE `ps_manufacturer` SET `active` = 1

UPDATE `ps_supplier` SET `active` = 1

ALTER TABLE `ps_cms` ADD `active` tinyint(1) unsigned NOT NULL default 0

UPDATE `ps_cms` SET `active` = 1

UPDATE `ps_tab_lang` SET `name` = 'SEO' WHERE `id_tab` = 56 AND `id_lang` IN(1,2,3)

ALTER TABLE `ps_cart` ADD `secure_key` varchar(32) NOT NULL default '-1' AFTER `id_guest`

ALTER TABLE `ps_order_detail` ADD `product_upc` varchar(12) default NULL AFTER `product_ean13`

ALTER TABLE `ps_discount` ADD `id_group` int(10) unsigned NOT NULL default 0

CREATE TABLE `ps_store` ( `id_store` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_country` int(10) unsigned NOT NULL, `id_state` int(10) unsigned DEFAULT NULL, `name` varchar(128) NOT NULL, `address1` varchar(128) NOT NULL, `address2` varchar(128) DEFAULT NULL, `city` varchar(64) NOT NULL, `postcode` varchar(12) NOT NULL, `latitude` float(10,6) DEFAULT NULL, `longitude` float(10,6) DEFAULT NULL, `hours` varchar(254) DEFAULT NULL, `phone` varchar(16) DEFAULT NULL, `fax` varchar(16) DEFAULT NULL, `email` varchar(128) DEFAULT NULL, `note` text, `active` tinyint(1) unsigned NOT NULL DEFAULT '0', `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_store`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_store' already exists

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('categoryAddition', '', 'Temporary hook. Must NEVER be used. Will soon be replaced by a generic CRUD hook system.', 0), ('categoryUpdate', '', 'Temporary hook. Must NEVER be used. Will soon be replaced by a generic CRUD hook system.', 0), ('categoryDeletion', '', 'Temporary hook. Must NEVER be used. Will soon be replaced by a generic CRUD hook system.', 0)

/* PHP:add_module_to_hook(blockcategories, categoryAddition); */

/* PHP:add_module_to_hook(blockcategories, categoryUpdate); */

/* PHP:add_module_to_hook(blockcategories, categoryDeletion); */

DELETE FROM `ps_hook_module` WHERE `id_module` = 0

CREATE TABLE `ps_required_field` ( `id_required_field` int(11) NOT NULL AUTO_INCREMENT, `object_name` varchar(32) NOT NULL, `field_name` varchar(32) NOT NULL, PRIMARY KEY (`id_required_field`), KEY `object_name` (`object_name`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_required_field' already exists

CREATE TABLE `ps_memcached_servers` ( `id_memcached_server` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY , `ip` VARCHAR( 254 ) NOT NULL , `port` INT(11) UNSIGNED NOT NULL , `weight` INT(11) UNSIGNED NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_memcached_servers' already exists

CREATE TABLE `ps_webservice_account` ( `id_webservice_account` int(11) NOT NULL AUTO_INCREMENT, `key` varchar(32) NOT NULL, `active` tinyint(2) NOT NULL, PRIMARY KEY (`id_webservice_account`), KEY `key` (`key`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_webservice_account' already exists

CREATE TABLE `ps_webservice_permission` ( `id_webservice_permission` int(11) NOT NULL AUTO_INCREMENT, `resource` varchar(50) NOT NULL, `method` enum('GET','POST','PUT','DELETE') NOT NULL, `id_webservice_account` int(11) NOT NULL, PRIMARY KEY (`id_webservice_permission`), UNIQUE KEY `resource_2` (`resource`,`method`,`id_webservice_account`), KEY `resource` (`resource`), KEY `method` (`method`), KEY `id_webservice_account` (`id_webservice_account`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_webservice_permission' already exists

/* PHP */ /* PHP:editorial_update(); */

/* PHP:reorderpositions(); */

/* PHP:update_image_size_in_db(); */

/* PHP:update_order_details(); */

/* PHP:add_new_tab(AdminInformation, en:Configuration Information|fr:Informations|es:Informations|it:Informazioni di configurazione|de:Konfigurationsinformationen, 9); */

/* PHP:add_new_tab(AdminCustomerThreads, en:Customer Service|de:Kundenservice|fr:SAV|es:Servicio al cliente|it:Servizio clienti, 29); */

/* PHP:add_new_tab(AdminAddonsCatalog, fr:Catalogue de modules et thÃ¨mes|de:Module und Themenkatalog|en:Modules & Themes Catalog|it:Moduli & Temi catalogo, 7); */

/* PHP:add_new_tab(AdminAddonsMyAccount, it:Il mio Account|de:Mein Konto|fr:Mon compte|en:My Account, 7); */

/* PHP:add_new_tab(AdminPerformance, de:Leistung|en:Performance|it:Performance|fr:Performances|es:Rendimiento, 8); */

/* PHP:add_new_tab(AdminThemes, es:Temas|it:Temi|de:Themen|en:Themes|fr:ThÃ¨mes, 7); */

/* PHP:add_new_tab(AdminWebservice, fr:Service web|es:Web service|en:Webservice|de:Webservice|it:Webservice, 8); */

SET NAMES 'utf8'

CREATE TABLE IF NOT EXISTS `ps_country_tax` ( `id_country_tax` int(11) NOT NULL AUTO_INCREMENT, `id_country` int(11) NOT NULL, `id_tax` int(11) NOT NULL, PRIMARY KEY (`id_country_tax`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

CREATE TABLE IF NOT EXISTS `ps_product_country_tax` ( `id_product` int(11) NOT NULL, `id_country` int(11) NOT NULL, `id_tax` int(11) NOT NULL, UNIQUE KEY `id_product` (`id_product`,`id_country`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

DELETE FROM `ps_tab` WHERE `class_name` = 'AdminStatsModules' LIMIT 1

DELETE FROM `ps_tab_lang` WHERE `id_tab` NOT IN (SELECT id_tab FROM `ps_tab`)

DELETE FROM `ps_access` WHERE `id_tab` NOT IN (SELECT id_tab FROM `ps_tab`)

INSERT INTO `ps_module` (`name`, `active`) VALUES ('statsforecast', 1)

INSERT INTO `ps_hook_module` (`id_module`, `id_hook` , `position`) (SELECT id_module, 32, (SELECT max_position from (SELECT MAX(position)+1 as max_position FROM `ps_hook_module` WHERE `id_hook` = 32) tmp) FROM `ps_module` WHERE `name` = 'statsforecast')

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_GEOLOCATION_ENABLED', '0', NOW(), NOW()), ('PS_ALLOWED_COUNTRIES', 'AF;ZA;AX;AL;DZ;DE;AD;AO;AI;AQ;AG;AN;SA;AR;AM;AW;AU;AT;AZ;BS;BH;BD;BB;BY;BE;BZ;BJ;BM;BT;BO;BA;BW;BV;BR;BN;BG;BF;MM;BI;KY;KH;CM;CA;CV;CF;CL;CN;CX;CY;CC;CO;KM;CG;CD;CK;KR;KP;CR;CI;HR;CU;DK;DJ;DM;EG;IE;SV;AE;EC;ER;ES;EE;ET;FK;FO;FJ;FI;FR;GA;GM;GE;GS;GH;GI;GR;GD;GL;GP;GU;GT;GG;GN;GQ;GW;GY;GF;HT;HM;HN;HK;HU;IM;MU;VG;VI;IN;ID;IR;IQ;IS;IL;IT;JM;JP;JE;JO;KZ;KE;KG;KI;KW;LA;LS;LV;LB;LR;LY;LI;LT;LU;MO;MK;MG;MY;MW;MV;ML;MT;MP;MA;MH;MQ;MR;YT;MX;FM;MD;MC;MN;ME;MS;MZ;NA;NR;NP;NI;NE;NG;NU;NF;NO;NC;NZ;IO;OM;UG;UZ;PK;PW;PS;PA;PG;PY;NL;PE;PH;PN;PL;PF;PR;PT;QA;DO;CZ;RE;RO;UK;RU;RW;EH;BL;KN;SM;MF;PM;VA;VC;LC;SB;WS;AS;ST;SN;RS;SC;SL;SG;SK;SI;SO;SD;LK;SE;CH;SR;SJ;SZ;SY;TJ;TW;TZ;TD;TF;TH;TL;TG;TK;TO;TT;TN;TM;TC;TR;TV;UA;UY;US;VU;VE;VN;WF;YE;ZM;ZW', NOW(), NOW()), ('PS_GEOLOCATION_BEHAVIOR', '0', NOW(), NOW())

ALTER TABLE `ps_orders` ADD `conversion_rate` decimal(13,6) NOT NULL default 1 AFTER `payment`

UPDATE `ps_orders` o SET o.`conversion_rate` = ( SELECT c.`conversion_rate` FROM `ps_currency` c WHERE c.`id_currency` = o.`id_currency` LIMIT 1 )

ALTER TABLE `ps_order_slip` ADD `conversion_rate` decimal(13,6) NOT NULL default 1 AFTER `id_order`

UPDATE `ps_order_slip` os SET os.`conversion_rate` = ( SELECT o.`conversion_rate` FROM `ps_orders` o WHERE os.`id_order` = o.`id_order` LIMIT 1 )

UPDATE `ps_configuration` SET `value` = 'gridhtml' WHERE `name` = 'PS_STATS_GRID_RENDER' LIMIT 1

UPDATE `ps_module` SET `name` = 'gridhtml' WHERE `name` = 'gridextjs' LIMIT 1

ALTER TABLE `ps_attachment` CHANGE `mime` `mime` varchar(64) NOT NULL

ALTER TABLE `ps_attachment` ADD `file_name` varchar(128) NOT NULL default '' AFTER `file`

UPDATE `ps_attachment` a SET `file_name` = ( SELECT `name` FROM `ps_attachment_lang` al WHERE al.`id_attachment` = a.`id_attachment` AND al.`id_lang` = ( SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_LANG_DEFAULT') )

UPDATE `ps_tab` SET `class_name` = 'AdminCMSContent' WHERE `class_name` = 'AdminCMS' LIMIT 1

SET @id_timezone = (SELECT `name` FROM `ps_timezone` WHERE `id_timezone` = (SELECT `value` FROM `ps_configuration` WHERE `name` = 'PS_TIMEZONE' LIMIT 1) LIMIT 1)

UPDATE `ps_configuration` SET `value` = @id_timezone WHERE `name` = "PS_TIMEZONE" LIMIT 1

ALTER TABLE `ps_country` ADD `id_currency` INT NOT NULL DEFAULT '0' AFTER `id_zone`

/* PHP */ /* PHP:group_reduction_column_fix(); */

/* PHP:ecotax_tax_application_fix(); */

/* PHP:cms_block(); */

/* PHP:add_new_tab(AdminGeolocation, es:GeolocalizaciÃ³n|it:Geolocalizzazione|en:Geolocation|de:Geotargeting|fr:GÃ©olocalisation, 8); */

SET NAMES 'utf8'

ALTER TABLE `ps_product` CHANGE `ecotax` `ecotax` DECIMAL(21, 6) NOT NULL DEFAULT '0.00'

/* PHP:move_crossselling(); */

UPDATE `ps_cms` SET `id_cms_category` = 1

/* PHP:admin_stores_tab(); */

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_LANGUAGE', l.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_lang` l ON (l.`id_lang` = c.`value`) WHERE c.`name` = 'PS_LANG_DEFAULT'

INSERT IGNORE INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) SELECT 'PS_LOCALE_COUNTRY', co.`iso_code`, NOW(), NOW() FROM `ps_configuration` c INNER JOIN `ps_country` co ON (co.`id_country` = c.`value`) WHERE c.`name` = 'PS_COUNTRY_DEFAULT'

/* PHP:reorderpositions(); */

ALTER TABLE `ps_webservice_permission` CHANGE `method` `method` ENUM( 'GET', 'POST', 'PUT', 'DELETE', 'HEAD' ) NOT NULL

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_ATTACHMENT_MAXIMUM_SIZE', '2', NOW(), NOW()), ('PS_SMARTY_CACHE', '1', NOW(), NOW())

ALTER TABLE `ps_product_attribute` CHANGE `price` `price` decimal(20,6) NOT NULL default '0.000000'

UPDATE `ps_product_attribute` pa SET pa.`price` = pa.`price` / (1 + IFNULL((SELECT t.`rate` FROM `ps_tax` t INNER JOIN `ps_product` p ON (p.`id_tax` = t.`id_tax`) WHERE p.`id_product` = pa.`id_product`) ,0) / 100)

SET NAMES 'utf8'

SET @alias = (SELECT IFNULL((SELECT `id_tab` FROM `ps_tab` WHERE `class_name` = "AdminAlias" LIMIT 1), '0'))

UPDATE `ps_tab` SET `id_parent` = 8 WHERE `id_tab` = @alias LIMIT 1

SET @stores = (SELECT IFNULL((SELECT `id_tab` FROM `ps_tab` WHERE `class_name` = "AdminStores" LIMIT 1), '0'))

UPDATE `ps_tab` SET `id_parent` = 9 WHERE `id_tab` = @stores LIMIT 1

SET @pdf = (SELECT IFNULL((SELECT `id_tab` FROM `ps_tab` WHERE `class_name` = "AdminPDF" LIMIT 1), '0'))

UPDATE `ps_tab` SET `id_parent` = 3 WHERE `id_tab` = @pdf LIMIT 1

SET @tabs = (SELECT IFNULL((SELECT `id_tab` FROM `ps_tab` WHERE `class_name` = "AdminTabs" LIMIT 1), '0'))

UPDATE `ps_tab` SET `id_parent` = 29 WHERE `id_tab` = @tabs LIMIT 1

ALTER TABLE `ps_image_type` ADD `stores` tinyint(1) NOT NULL default '1'

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_FORCE_SMARTY_2', '0', NOW(), NOW()), ('PS_DIMENSION_UNIT', 'cm', NOW(), NOW())

ALTER TABLE `ps_product` ADD `width` FLOAT NOT NULL AFTER `location`, ADD `height` FLOAT NOT NULL AFTER `width`, ADD `depth` FLOAT NOT NULL AFTER `height`

SET @id_module = (SELECT IFNULL((SELECT `id_module` FROM `ps_module` WHERE `name` = "statshome" LIMIT 1), '0'))

DELETE FROM `ps_module` WHERE `id_module` = @id_module

DELETE FROM `ps_hook_module` WHERE `id_module` = @id_module

ALTER TABLE `ps_customer` ADD `is_guest` TINYINT(1) NOT NULL DEFAULT '0' AFTER `deleted`

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_GUEST_CHECKOUT_ENABLED', '0', NOW(), NOW())

ALTER TABLE `ps_category` ADD `nleft` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `level_depth`

ALTER TABLE `ps_category` ADD `nright` INT UNSIGNED NOT NULL DEFAULT '0' AFTER `nleft`

ALTER TABLE `ps_category` ADD INDEX `nleftright` (`nleft`, `nright`)

ALTER TABLE `ps_product` ADD `id_tax_rules_group` int(10) unsigned NOT NULL AFTER `id_tax`

ALTER TABLE `ps_carrier` ADD `id_tax_rules_group` int(10) unsigned NOT NULL AFTER `id_tax`

CREATE TABLE `ps_tax_rule` ( `id_tax_rules_group` INT NOT NULL , `id_country` INT NOT NULL , `id_state` INT NOT NULL , `id_tax` INT NOT NULL , `state_behavior` INT NOT NULL , PRIMARY KEY ( `id_tax_rules_group`, `id_country` , `id_state` ) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_tax_rule' already exists

CREATE TABLE `ps_tax_rules_group` ( `id_tax_rules_group` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `name` VARCHAR( 32 ) NOT NULL , `active` INT NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_tax_rules_group' already exists

CREATE TABLE IF NOT EXISTS `ps_help_access` ( `id_help_access` int(11) NOT NULL AUTO_INCREMENT, `label` varchar(45) NOT NULL, `version` varchar(8) NOT NULL, PRIMARY KEY (`id_help_access`), UNIQUE KEY `label` (`label`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

/* PHP:add_new_tab(AdminTaxRulesGroup, it:Regimi fiscali|es:Reglas de Impuestos|fr:RÃ¨gles de taxes|de:Steuerregeln|en:Tax Rules, 4); */

/* PHP:generate_ntree(); */

/* PHP:generate_tax_rules(); */

/* PHP:id_currency_country_fix(); */

/* PHP:update_modules_sql(); */

ALTER TABLE `ps_product` DROP `id_tax`

ALTER TABLE `ps_carrier` DROP `id_tax`

DROP TABLE `ps_tax_state`, `ps_tax_zone`, `ps_country_tax`

ALTER TABLE `ps_orders` ADD `carrier_tax_rate` DECIMAL(10, 3) NOT NULL default '0.00' AFTER `total_shipping`

INSERT INTO `ps_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES (NULL, 'beforeAuthentication', 'Before Authentication', 'Before authentication', 0)

SET NAMES 'utf8'

ALTER TABLE `ps_customer` DROP INDEX `customer_email`

ALTER TABLE `ps_customer` ADD INDEX `customer_email` (`email`)

ALTER TABLE `ps_lang` ADD `language_code` char(5) NULL AFTER `iso_code`

UPDATE `ps_lang` SET language_code = iso_code

ALTER TABLE `ps_lang` MODIFY `language_code` char(5) NOT NULL

DELETE FROM `ps_module` WHERE `name` = 'gridextjs' LIMIT 1

DELETE FROM `ps_hook_module` WHERE `id_module` NOT IN (SELECT id_module FROM `ps_module`)

UPDATE `ps_configuration` SET `value` = 'gridhtml' WHERE `name` = 'PS_STATS_GRID_RENDER' AND `value` = 'gridextjs' LIMIT 1

SET NAMES 'utf8'

ALTER TABLE `ps_product_attribute` ADD `minimal_quantity` int(10) unsigned NOT NULL DEFAULT '1' AFTER `default_on`

ALTER TABLE `ps_orders` ADD `reference` VARCHAR(14) NOT NULL AFTER `id_address_invoice`

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES('PS_DISPLAY_SUPPLIERS', '1', NOW(), NOW())

/* PHP:update_products_ecotax_v133(); */

SET NAMES 'utf8'

UPDATE `ps_tab` SET `position` = `position` + 1 WHERE `id_parent` = (SELECT * FROM (SELECT `id_parent` FROM `ps_tab` WHERE `class_name` = 'AdminTaxes') tmp) AND `position` > (SELECT * FROM (SELECT `position` FROM `ps_tab` WHERE `class_name` = 'AdminTaxes') tmp2)

UPDATE `ps_tab` SET `position` = (SELECT * FROM (SELECT `position` FROM `ps_tab` WHERE `class_name` = 'AdminTaxes') tmp) + 1 WHERE `class_name` = 'AdminTaxRulesGroup'

UPDATE `ps_hook` SET `title` = 'Category creation', description = '' WHERE `name` = 'categoryAddition' LIMIT 1

UPDATE `ps_hook` SET `title` = 'Category modification', description = '' WHERE `name` = 'categoryUpdate' LIMIT 1

UPDATE `ps_hook` SET `title` = 'Category removal', description = '' WHERE `name` = 'categoryDeletion' LIMIT 1

DELETE FROM `ps_module` WHERE `name` = 'canonicalurl' LIMIT 1

DELETE FROM `ps_hook_module` WHERE `id_module` NOT IN (SELECT id_module FROM `ps_module`)

/* PHP:gridextjs_deprecated(); */

/* PHP:shop_url(); */

/* PHP:updateproductcomments(); */

SET NAMES 'utf8'

CREATE TABLE `ps_specific_price_priority` ( `id_specific_price_priority` INT NOT NULL AUTO_INCREMENT , `id_product` INT NOT NULL , `priority` VARCHAR( 80 ) NOT NULL , PRIMARY KEY ( `id_specific_price_priority` , `id_product` ) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_specific_price_priority' already exists

ALTER TABLE `ps_product` ADD `unit_price_ratio` DECIMAL(20, 6) NOT NULL default '0.00' AFTER `unit_price`

UPDATE `ps_product` SET `unit_price_ratio` = IF (`unit_price` != 0, `price` / `unit_price`, 0)

ALTER TABLE `ps_product` DROP `unit_price`

ALTER TABLE `ps_discount` ADD `behavior_not_exhausted` TINYINT(3) DEFAULT '1' AFTER `id_discount_type`

SET NAMES 'utf8'

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CATALOG_MODE', '0', NOW(), NOW())

ALTER TABLE `ps_specific_price` DROP `priority`

(1091) Can't DROP 'priority'; check that column/key exists

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_GEOLOCATION_WHITELIST', '209.185.108;209.185.253;209.85.238;209.85.238.11;209.85.238.4;216.239.33.96;216.239.33.97;216.239.33.98;216.239.33.99;216.239.37.98;216.239.37.99;216.239.39.98;216.239.39.99;216.239.41.96;216.239.41.97;216.239.41.98;216.239.41.99;216.239.45.4;216.239.46;216.239.51.96;216.239.51.97;216.239.51.98;216.239.51.99;216.239.53.98;216.239.53.99;216.239.57.96;216.239.57.97;216.239.57.98;216.239.57.99;216.239.59.98;216.239.59.99;216.33.229.163;64.233.173.193;64.233.173.194;64.233.173.195;64.233.173.196;64.233.173.197;64.233.173.198;64.233.173.199;64.233.173.200;64.233.173.201;64.233.173.202;64.233.173.203;64.233.173.204;64.233.173.205;64.233.173.206;64.233.173.207;64.233.173.208;64.233.173.209;64.233.173.210;64.233.173.211;64.233.173.212;64.233.173.213;64.233.173.214;64.233.173.215;64.233.173.216;64.233.173.217;64.233.173.218;64.233.173.219;64.233.173.220;64.233.173.221;64.233.173.222;64.233.173.223;64.233.173.224;64.233.173.225;64.233.173.226;64.233.173.227;64.233.173.228;64.233.173.229;64.233.173.230;64.233.173.231;64.233.173.232;64.233.173.233;64.233.173.234;64.233.173.235;64.233.173.236;64.233.173.237;64.233.173.238;64.233.173.239;64.233.173.240;64.233.173.241;64.233.173.242;64.233.173.243;64.233.173.244;64.233.173.245;64.233.173.246;64.233.173.247;64.233.173.248;64.233.173.249;64.233.173.250;64.233.173.251;64.233.173.252;64.233.173.253;64.233.173.254;64.233.173.255;64.68.80;64.68.81;64.68.82;64.68.83;64.68.84;64.68.85;64.68.86;64.68.87;64.68.88;64.68.89;64.68.90.1;64.68.90.10;64.68.90.11;64.68.90.12;64.68.90.129;64.68.90.13;64.68.90.130;64.68.90.131;64.68.90.132;64.68.90.133;64.68.90.134;64.68.90.135;64.68.90.136;64.68.90.137;64.68.90.138;64.68.90.139;64.68.90.14;64.68.90.140;64.68.90.141;64.68.90.142;64.68.90.143;64.68.90.144;64.68.90.145;64.68.90.146;64.68.90.147;64.68.90.148;64.68.90.149;64.68.90.15;64.68.90.150;64.68.90.151;64.68.90.152;64.68.90.153;64.68.90.154;64.68.90.155;64.68.90.156;64.68.90.157;64.68.90.158;64.68.90.159;64.68.90.16;64.68.90.160;64.68.90.161;64.68.90.162;64.68.90.163;64.68.90.164;64.68.90.165;64.68.90.166;64.68.90.167;64.68.90.168;64.68.90.169;64.68.90.17;64.68.90.170;64.68.90.171;64.68.90.172;64.68.90.173;64.68.90.174;64.68.90.175;64.68.90.176;64.68.90.177;64.68.90.178;64.68.90.179;64.68.90.18;64.68.90.180;64.68.90.181;64.68.90.182;64.68.90.183;64.68.90.184;64.68.90.185;64.68.90.186;64.68.90.187;64.68.90.188;64.68.90.189;64.68.90.19;64.68.90.190;64.68.90.191;64.68.90.192;64.68.90.193;64.68.90.194;64.68.90.195;64.68.90.196;64.68.90.197;64.68.90.198;64.68.90.199;64.68.90.2;64.68.90.20;64.68.90.200;64.68.90.201;64.68.90.202;64.68.90.203;64.68.90.204;64.68.90.205;64.68.90.206;64.68.90.207;64.68.90.208;64.68.90.21;64.68.90.22;64.68.90.23;64.68.90.24;64.68.90.25;64.68.90.26;64.68.90.27;64.68.90.28;64.68.90.29;64.68.90.3;64.68.90.30;64.68.90.31;64.68.90.32;64.68.90.33;64.68.90.34;64.68.90.35;64.68.90.36;64.68.90.37;64.68.90.38;64.68.90.39;64.68.90.4;64.68.90.40;64.68.90.41;64.68.90.42;64.68.90.43;64.68.90.44;64.68.90.45;64.68.90.46;64.68.90.47;64.68.90.48;64.68.90.49;64.68.90.5;64.68.90.50;64.68.90.51;64.68.90.52;64.68.90.53;64.68.90.54;64.68.90.55;64.68.90.56;64.68.90.57;64.68.90.58;64.68.90.59;64.68.90.6;64.68.90.60;64.68.90.61;64.68.90.62;64.68.90.63;64.68.90.64;64.68.90.65;64.68.90.66;64.68.90.67;64.68.90.68;64.68.90.69;64.68.90.7;64.68.90.70;64.68.90.71;64.68.90.72;64.68.90.73;64.68.90.74;64.68.90.75;64.68.90.76;64.68.90.77;64.68.90.78;64.68.90.79;64.68.90.8;64.68.90.80;64.68.90.9;64.68.91;64.68.92;66.249.64;66.249.65;66.249.66;66.249.67;66.249.68;66.249.69;66.249.70;66.249.71;66.249.72;66.249.73;66.249.78;66.249.79;72.14.199;8.6.48', NOW(), NOW())

ALTER TABLE `ps_address` ADD `dni` VARCHAR(16) NULL AFTER `vat_number`

UPDATE `ps_address` a SET `dni` = ( SELECT `dni` FROM `ps_customer` c WHERE c.`id_customer` = a.`id_customer` )

ALTER TABLE `ps_customer` DROP `dni`

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`) VALUES ('paymentTop', 'Top of payment page', 'Top of payment page', 0)

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ( 'ps_INVOICE_START_NUMBER', ( SELECT `invoice_number` FROM (SELECT GREATEST(`value`, (SELECT CAST(MAX(`invoice_number`) AS CHAR) FROM `ps_orders`)) AS `invoice_number` FROM `ps_configuration` WHERE `name` = 'ps_INVOICE_NUMBER' ) as tmp), NOW(), NOW() )

DELETE FROM `ps_configuration` WHERE `name` = 'PS_INVOICE_NUMBER'

CREATE TABLE `ps_log` ( `id_log` int(10) unsigned NOT NULL AUTO_INCREMENT, `severity` tinyint(1) NOT NULL, `error_code` int(11) DEFAULT NULL, `message` text NOT NULL, `object_type` varchar(32) DEFAULT NULL, `object_id` int(10) unsigned DEFAULT NULL, `date_add` datetime NOT NULL, `date_upd` datetime NOT NULL, PRIMARY KEY (`id_log`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_log' already exists

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LOGS_BY_EMAIL', '5', NOW(), NOW())

ALTER TABLE `ps_tax_rules_group` CHANGE `name` `name` VARCHAR( 50 ) NOT NULL

CREATE TABLE `ps_import_match` ( `id_import_match` int(10) NOT NULL AUTO_INCREMENT, `name` varchar(32) NOT NULL, `match` text NOT NULL, `skip` int(2) NOT NULL, PRIMARY KEY (`id_import_match`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_import_match' already exists

/* PHP:add_new_tab(AdminLogs, en:Log|fr:Log|es:Log|de:Log|it:Log, 9); */

ALTER TABLE `ps_product` CHANGE `ecotax` `ecotax` DECIMAL( 17, 6 ) NOT NULL DEFAULT '0.00'

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LAST_SHOP_UPDATE', NOW(), NOW(), NOW())

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_STORES_DISPLAY_SITEMAP', 1, NOW(), NOW())

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_COOKIE_CHECKIP', 1, NOW(), NOW())

/* PHP:regenerate_level_depth(); */

SET NAMES 'utf8'

/* PHP:regenerate_level_depth(); */

SET NAMES 'utf8'

ALTER TABLE `ps_tax_rule` DROP PRIMARY KEY

(1075) Incorrect table definition; there can be only one auto column and it must be defined as a key

ALTER TABLE `ps_tax_rule` ADD `id_tax_rule` INT NOT NULL AUTO_INCREMENT PRIMARY KEY FIRST

(1060) Duplicate column name 'id_tax_rule'

ALTER TABLE `ps_tax_rule` ADD INDEX ( `id_tax` )

ALTER TABLE `ps_tax_rule` ADD INDEX ( `id_tax_rules_group` )

ALTER TABLE `ps_address` MODIFY `dni` VARCHAR(16) NULL AFTER `vat_number`

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('BLOCKSTORE_IMG', 'store.jpg', NOW(), NOW()), ('PS_STORES_CENTER_LAT', '25.948969', NOW(), NOW()), ('PS_STORES_CENTER_LONG', '-80.226439', NOW(), NOW())