Jump to content

Recommended Posts

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'

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())

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

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

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

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

/* 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(AdminThemes, es:Temas|it:Temi|de:Themen|en:Themes|fr:Thèmes, 7); */

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

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

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

/* PHP:add_new_tab(AdminCounty, fr:Comtés|es:Condados|en:Counties|de:Counties|it:Counties, 5); */

ALTER TABLE `ps_tax_rule` ADD `county_behavior` INT NOT NULL AFTER `state_behavior`

(1060) Duplicate column name 'county_behavior'


ALTER TABLE `ps_tax_rule` ADD `id_county` INT NOT NULL AFTER `state_behavior`

(1060) Duplicate column name 'id_county'


ALTER TABLE `ps_tax_rule` ADD UNIQUE ( `id_tax_rules_group` , `id_country` , `id_state` , `id_county` )

CREATE TABLE `ps_county` ( `id_county` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(64) NOT NULL, `id_state` int(11) NOT NULL, `active` tinyint(1) NOT NULL, PRIMARY KEY (`id_county`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_county' already exists


CREATE TABLE `ps_county_zip_code` ( `id_county` INT NOT NULL , `from_zip_code` INT NOT NULL , `to_zip_code` INT NOT NULL , PRIMARY KEY ( `id_county` , `from_zip_code` , `to_zip_code` ) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(1050) Table 'ps_county_zip_code' already exists


INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_HOMEPAGE_PHP_SELF', 'index.php', NOW(), NOW())

INSERT INTO `ps_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_USE_ECOTAX', (SELECT IF((SELECT `ecotax` FROM `ps_product` WHERE `ecotax` != 0 LIMIT 1),'1','0')), NOW(), NOW())

ALTER TABLE `ps_hook` ADD `live_edit` TINYINT NOT NULL DEFAULT '0'

UPDATE `ps_hook` SET `live_edit` = '1' WHERE `ps_hook`.`name` IN ('rightColumn', 'leftColumn', 'home')

INSERT INTO `ps_hook` (`id_hook`, `name`, `title`, `description`, `position`) VALUES (NULL, 'afterCreateHtaccess', 'After htaccess creation', 'After htaccess creation', 0)

UPDATE `ps_meta_lang` SET `url_rewrite` = 'kontaktieren-sie-uns' WHERE id_meta = 3 AND id_lang = 4 AND url_rewrite = 'Kontaktieren Sie uns'

UPDATE `ps_meta_lang` SET `url_rewrite` = 'kennwort-wiederherstellung' WHERE id_meta = 7 AND id_lang = 4 AND url_rewrite = 'Kennwort Wiederherstellung'

UPDATE `ps_meta_lang` SET `url_rewrite` = 'il-mio-account' WHERE id_meta = 18 AND id_lang = 5 AND url_rewrite = 'il mio-account'

UPDATE `ps_meta_lang` SET `url_rewrite` = 'nota-di-ordine' WHERE id_meta = 20 AND id_lang = 5 AND url_rewrite = 'nota di-ordine'

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

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) ( SELECT `id_lang`, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'order-opc'), 'Order', 'quick-order' FROM `ps_lang` )

INSERT INTO `ps_meta` (`page`) VALUES ('guest-tracking')

INSERT INTO `ps_meta_lang` (`id_lang`, `id_meta`, `title`, `url_rewrite`) ( SELECT `id_lang`, (SELECT `id_meta` FROM `ps_meta` WHERE `page` = 'guest-tracking'), 'Guest tracking', 'guest-tracking' FROM `ps_lang` )

UPDATE `ps_hook` SET `live_edit` = '1' WHERE `ps_hook`.`name` IN ('productfooter', 'payment')

UPDATE `ps_configuration` SET name = 'PS_GEOLOCATION_ENABLED' WHERE name = 'PS_GEOLOCALIZATION_ENABLED'

UPDATE `ps_configuration` SET name = 'PS_GEOLOCATION_BEHAVIOR' WHERE name = 'PS_GEOLOCALIZATION_BEHAVIOR'

UPDATE `ps_configuration` SET name = 'PS_GEOLOCATION_WHITELIST' WHERE name = 'PS_GEOLOCALIZATION_WHITELIST'

UPDATE `ps_tab` SET class_name = 'AdminGeolocation' WHERE class_name = 'AdminGeolocalization'

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

ALTER TABLE `ps_webservice_account` ADD `class_name` VARCHAR( 50 ) NOT NULL DEFAULT 'WebserviceRequest' AFTER `key`

(1060) Duplicate column name 'class_name'


ALTER TABLE `ps_webservice_account` ADD `description` text NULL AFTER `key`

(1060) Duplicate column name 'description'


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

/* PHP:add_new_tab(AdminHome, en:Home|fr:Accueil|es:Home|de:Home|it:Home, -1); */

/* PHP:add_new_tab(AdminStockMvt, de:Lagerbewegungen|fr:Mouvements de Stock|it:Movimenti magazzino|en:Stock Movements, 1); */

/* PHP:update_for_13version(); */

SET NAMES 'utf8'

ALTER TABLE `ps_stock_mvt_reason` ADD `sign` TINYINT(1) NOT NULL AFTER `id_stock_mvt_reason`

(1060) Duplicate column name 'sign'


UPDATE `ps_stock_mvt_reason` SET `sign`=-1

UPDATE `ps_stock_mvt_reason` SET `sign`=1 WHERE `id_stock_mvt_reason`=3

UPDATE `ps_stock_mvt_reason` SET `id_stock_mvt_reason`=`id_stock_mvt_reason`+2 ORDER BY `id_stock_mvt_reason` DESC

UPDATE `ps_stock_mvt` SET `id_stock_mvt_reason`=`id_stock_mvt_reason`+2

UPDATE `ps_stock_mvt_reason_lang` SET `id_stock_mvt_reason`=`id_stock_mvt_reason`+2 ORDER BY `id_stock_mvt_reason` DESC

INSERT INTO `ps_stock_mvt_reason` (`id_stock_mvt_reason` ,`sign` ,`date_add` ,`date_upd`) VALUES ('1', '1', NOW(), NOW()), ('2', '-1', NOW(), NOW())

INSERT INTO `ps_stock_mvt_reason_lang` (`id_stock_mvt_reason` ,`id_lang` ,`name`) VALUES ('1', '1', 'Increase'), ('1', '2', 'Augmenter'), ('1', '3', 'Aumentar'), ('1', '4', 'Erhöhen'), ('1', '5', 'Aumento'), ('2', '1', 'Decrease'), ('2', '2', 'Diminuer'), ('2', '3', 'Disminuir'), ('2', '4', 'Reduzieren'), ('2', '5', 'Diminuzione')

SET NAMES 'utf8'

INSERT INTO `ps_hook` (`name`, `title`, `description`, `position`, `live_edit`) VALUES ('afterSaveAdminMeta', 'After save configuration in AdminMeta', 'After save configuration in AdminMeta', 0, 0)

INSERT INTO `ps_hook_module` (`id_module`, `id_hook`, `position`) VALUES ( (SELECT `id_module` FROM `ps_module` WHERE `name` = 'blockcategories'), (SELECT `id_hook` FROM `ps_hook` WHERE `name` = 'afterSaveAdminMeta'), 1 )

ALTER TABLE `ps_webservice_account` ADD `is_module` TINYINT( 2 ) NOT NULL DEFAULT '0' AFTER `class_name` , ADD `module_name` VARCHAR( 50 ) NULL DEFAULT NULL AFTER `is_module`

(1060) Duplicate column name 'is_module'


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

UPDATE `ps_cms_lang` set link_rewrite = "uber-uns" where link_rewrite like "%ber-uns"

ALTER TABLE `ps_connections` CHANGE `ip_address` `ip_address` BIGINT NULL DEFAULT NULL

(1317) Query execution was interrupted


UPDATE `ps_meta_lang` SET `title` = 'Angebote', `keywords` = 'besonders, Angebote', `url_rewrite` = 'angebote' WHERE url_rewrite = 'preise-fallen'

(2006) MySQL server has gone away


ALTER TABLE `ps_country` ADD `display_tax_label` BOOLEAN NOT NULL DEFAULT '1'

(2006) MySQL server has gone away


DROP TABLE IF EXISTS `ps_country_tax`

(2006) MySQL server has gone away


ALTER TABLE `ps_order_detail` CHANGE `product_quantity_in_stock` `product_quantity_in_stock` INT(10) NOT NULL DEFAULT '0'

(2006) MySQL server has gone away


CREATE TABLE `ps_address_format` ( `id_country` int(10) unsigned NOT NULL, `format` varchar(255) NOT NULL DEFAULT '', KEY `country` (`id_country`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8

(2006) MySQL server has gone away


INSERT INTO `ps_address_format` (`id_country`, `format`) (SELECT `id_country` as id_country, 'firstname lastname\ncompany\nvat_number\naddress1\naddress2\npostcode city\ncountry\nphone' as format FROM ps_country)

(2006) MySQL server has gone away


UPDATE `ps_address_format` set `format`='firstname lastname company address1 address2 city state postcode country phone' where `id_country`=21

(2006) MySQL server has gone away


ALTER TABLE `ps_tab_lang` MODIFY `id_lang` int(10) unsigned NOT NULL AFTER `id_tab`

(2006) MySQL server has gone away


/* PHP:alter_cms_block(); */
Link to comment
Share on other sites

  • nadie locked this topic
Guest
This topic is now closed to further replies.
×
×
  • Create New...