· 10 years ago · Sep 23, 2016, 10:36 AM
1This XML file does not appear to have any style information associated with it. The document tree is shown below.
2<action result="fail" error="34" data-livestyle-extension="available">
3<request result="ok" sqlfile="1.6.0.9">
4<sqlQuery>
5<![CDATA[ SET NAMES 'utf8' ]]>
6</sqlQuery>
7</request>
8<request result="fail" sqlfile="1.6.0.9">
9<sqlQuery>
10<![CDATA[
11INSERT INTO `kap_hook` (`id_hook` , `name` , `title` , `description` , `position` , `live_edit`) VALUES (NULL , 'displayAdminOrderTabOrder', 'Display new elements in Back Office on AdminOrder, panel Order', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Order panel tabs', '1', '0'), (NULL , 'displayAdminOrderContentOrder', 'Display new elements in Back Office on AdminOrder, panel Order', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Order panel content', '1', '0'), (NULL , 'displayAdminOrderTabShip', 'Display new elements in Back Office, AdminOrder, panel Shipping', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Shipping panel tabs', '1', '0'), (NULL , 'displayAdminOrderContentShip', 'Display new elements in Back Office, AdminOrder, panel Shipping', 'This hook launches modules when the AdminOrder tab is displayed in the Back Office and extends / override Shipping panel content', '1', '0')
12]]>
13</sqlQuery>
14<sqlMsgError>
15<![CDATA[
16Duplicate entry 'displayAdminOrderTabOrder' for key 'hook_name'
17]]>
18</sqlMsgError>
19<sqlNumberError>
20<![CDATA[ 1062 ]]>
21</sqlNumberError>
22</request>
23<request result="ok" sqlfile="1.6.0.9">
24<sqlQuery>
25<![CDATA[
26INSERT INTO `kap_configuration` (`name` , `value` , `date_add` , `date_upd`) VALUES ('PS_SET_DISPLAY_SUBCATEGORIES', '1', NOW(), NOW())
27]]>
28</sqlQuery>
29</request>
30<request result="ok" sqlfile="1.6.0.9">
31<sqlQuery>
32<![CDATA[
33UPDATE `kap_hook` SET `live_edit` = 0 WHERE `name`='displayOverrideTemplate'
34]]>
35</sqlQuery>
36</request>
37<request result="ok" sqlfile="1.6.0.10">
38<sqlQuery>
39<![CDATA[ SET NAMES 'utf8' ]]>
40</sqlQuery>
41</request>
42<request result="fail" sqlfile="1.6.0.10">
43<sqlQuery>
44<![CDATA[
45CREATE TABLE `kap_smarty_cache` ( `id_smarty_cache` char(40) NOT NULL, `name` char(40), `cache_id` varchar(254) DEFAULT NULL, `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `content` longtext NOT NULL, PRIMARY KEY (`id_smarty_cache`), KEY `name` (`name`), KEY `cache_id` (`cache_id`), KEY `modified` (`modified`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
46]]>
47</sqlQuery>
48<sqlMsgError>
49<![CDATA[ Table 'kap_smarty_cache' already exists ]]>
50</sqlMsgError>
51<sqlNumberError>
52<![CDATA[ 1050 ]]>
53</sqlNumberError>
54</request>
55<request result="ok" sqlfile="1.6.0.10">
56<sqlQuery>
57<![CDATA[
58INSERT INTO `kap_configuration` (`name` , `value` , `date_add` , `date_upd`) VALUES ('PS_SMARTY_CACHING_TYPE', 'filesystem', NOW(), NOW()), ('PS_SMARTY_CLEAR_CACHE', 'everytime', NOW(), NOW()), ('PS_DETECT_LANG', '1', NOW(), NOW()), ('PS_DETECT_COUNTRY', '1', NOW(), NOW())
59]]>
60</sqlQuery>
61</request>
62<request result="ok" sqlfile="1.6.0.10">
63<sqlQuery>
64<![CDATA[
65ALTER TABLE `kap_quick_access` CHANGE `link` `link` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL
66]]>
67</sqlQuery>
68</request>
69<request result="ok" sqlfile="1.6.0.10">
70<sqlQuery>
71<![CDATA[
72ALTER TABLE `kap_order_slip_detail` CHANGE `amount_tax_excl` `amount_tax_excl` DECIMAL(20, 6) NULL DEFAULT NULL
73]]>
74</sqlQuery>
75</request>
76<request result="ok" sqlfile="1.6.0.10">
77<sqlQuery>
78<![CDATA[
79ALTER TABLE `kap_order_slip_detail` CHANGE `amount_tax_incl` `amount_tax_incl` DECIMAL( 20, 6 ) NULL DEFAULT NULL
80]]>
81</sqlQuery>
82</request>
83<request result="ok" sqlfile="1.6.0.10">
84<sqlQuery>
85<![CDATA[
86INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_ROUND_TYPE', 2, now(), now())
87]]>
88</sqlQuery>
89</request>
90<request result="fail" sqlfile="1.6.0.10">
91<sqlQuery>
92<![CDATA[
93ALTER TABLE `kap_order_slip` ADD `total_products_tax_excl` DECIMAL(20, 6) NULL AFTER `id_order`, ADD `total_products_tax_incl` DECIMAL(20, 6) NULL AFTER `total_products_tax_excl`,ADD `total_shipping_tax_excl` DECIMAL(20, 6) NULL AFTER `total_products_tax_incl`, ADD `total_shipping_tax_incl` DECIMAL(20, 6) NULL AFTER `total_shipping_tax_excl`
94]]>
95</sqlQuery>
96<sqlMsgError>
97<![CDATA[ Duplicate column name 'total_products_tax_excl' ]]>
98</sqlMsgError>
99<sqlNumberError>
100<![CDATA[ 1060 ]]>
101</sqlNumberError>
102</request>
103<request result="fail" sqlfile="1.6.0.10">
104<sqlQuery>
105<![CDATA[
106ALTER TABLE `kap_order_slip_detail` ADD `unit_price_tax_excl` DECIMAL(20, 6) NULL AFTER `product_quantity`, ADD `unit_price_tax_incl` DECIMAL(20, 6) NULL AFTER `unit_price_tax_excl`, ADD `total_price_tax_excl` DECIMAL(20, 6) NULL AFTER `unit_price_tax_incl`, ADD `total_price_tax_incl` DECIMAL(20, 6) NULL AFTER `total_price_tax_excl`
107]]>
108</sqlQuery>
109<sqlMsgError>
110<![CDATA[ Duplicate column name 'unit_price_tax_excl' ]]>
111</sqlMsgError>
112<sqlNumberError>
113<![CDATA[ 1060 ]]>
114</sqlNumberError>
115</request>
116<request result="ok" sqlfile="1.6.0.10">
117<sqlQuery>
118<![CDATA[
119CREATE TABLE IF NOT EXISTS `kap_order_slip_detail_tax` ( `id_order_slip_detail` int(11) unsigned NOT NULL, `id_tax` int(11) unsigned NOT NULL, `unit_amount` decimal(16,6) NOT NULL DEFAULT '0.000000', `total_amount` decimal(16,6) NOT NULL DEFAULT '0.000000', KEY (`id_order_slip_detail`), KEY `id_tax` (`id_tax`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
120]]>
121</sqlQuery>
122</request>
123<request result="fail" sqlfile="1.6.0.10">
124<sqlQuery>
125<![CDATA[
126ALTER TABLE `kap_tax_rules_group` ADD `deleted` TINYINT(1) UNSIGNED NOT NULL, ADD `date_add` DATETIME NOT NULL, ADD `date_upd` DATETIME NOT NULL
127]]>
128</sqlQuery>
129<sqlMsgError>
130<![CDATA[ Duplicate column name 'deleted' ]]>
131</sqlMsgError>
132<sqlNumberError>
133<![CDATA[ 1060 ]]>
134</sqlNumberError>
135</request>
136<request result="ok" sqlfile="1.6.0.10">
137<sqlQuery>
138<![CDATA[
139UPDATE `kap_tax_rules_group` SET `date_add` = NOW(), `date_upd` = NOW()
140]]>
141</sqlQuery>
142</request>
143<request result="fail" sqlfile="1.6.0.10">
144<sqlQuery>
145<![CDATA[
146ALTER TABLE `kap_order_detail` ADD `id_tax_rules_group` INT(11) UNSIGNED DEFAULT '0' AFTER `product_weight`, ADD INDEX `id_tax_rules_group` (`id_tax_rules_group`)
147]]>
148</sqlQuery>
149<sqlMsgError>
150<![CDATA[ Duplicate column name 'id_tax_rules_group' ]]>
151</sqlMsgError>
152<sqlNumberError>
153<![CDATA[ 1060 ]]>
154</sqlNumberError>
155</request>
156<request result="ok" sqlfile="1.6.0.10">
157<sqlQuery>
158<![CDATA[
159CREATE TABLE IF NOT EXISTS `kap_mail` ( `id_mail` int(11) unsigned NOT NULL AUTO_INCREMENT, `recipient` varchar(126) NOT NULL, `template` varchar(62) NOT NULL, `subject` varchar(254) NOT NULL, `id_lang` int(11) unsigned NOT NULL, `date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id_mail`), KEY `recipient` (`recipient`(10)) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
160]]>
161</sqlQuery>
162</request>
163<request result="ok" sqlfile="1.6.0.10">
164<sqlQuery>
165<![CDATA[
166INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_LOG_EMAILS', 1, now(), now())
167]]>
168</sqlQuery>
169</request>
170<request result="fail" sqlfile="1.6.0.10">
171<sqlQuery>
172<![CDATA[
173ALTER TABLE `kap_employee` ADD `last_connection_date` date NOT NULL DEFAULT '0000-00-00'
174]]>
175</sqlQuery>
176<sqlMsgError>
177<![CDATA[ Duplicate column name 'last_connection_date' ]]>
178</sqlMsgError>
179<sqlNumberError>
180<![CDATA[ 1060 ]]>
181</sqlNumberError>
182</request>
183<request result="ok" sqlfile="1.6.0.10">
184<sqlQuery>
185<![CDATA[
186UPDATE `kap_category` SET `is_root_category` = 0 WHERE `id_parent` != (SELECT `value` FROM `kap_configuration` WHERE `name` = 'PS_ROOT_CATEGORY' LIMIT 1) AND `is_root_category` = 1
187]]>
188</sqlQuery>
189</request>
190<request result="ok" sqlfile="1.6.0.10">
191<sqlQuery>
192<![CDATA[ ALTER TABLE `kap_orders` ADD INDEX (`reference`) ]]>
193</sqlQuery>
194</request>
195<request result="ok" sqlfile="1.6.0.10">
196<sqlQuery>
197<![CDATA[
198UPDATE `kap_meta` SET `page` = 'pagenotfound' WHERE `page` = '404'
199]]>
200</sqlQuery>
201</request>
202<request result="ok" sqlfile="1.6.0.11">
203<sqlQuery>
204<![CDATA[ SET NAMES 'utf8' ]]>
205</sqlQuery>
206</request>
207<request result="ok" sqlfile="1.6.0.11">
208<sqlQuery>
209<![CDATA[
210INSERT INTO `kap_order_state` (`invoice`, `send_email`, `module_name`, `color`, `unremovable`, `hidden`, `logable`, `delivery`, `shipped`, `paid`, `deleted`) VALUES ('0', '1', NULL, '#FF69B4', '1', '0', '0', '0', '0', '0', '0')
211]]>
212</sqlQuery>
213</request>
214<request result="ok" sqlfile="1.6.0.11">
215<sqlQuery>
216<![CDATA[ SET @id_order_state = LAST_INSERT_ID() ]]>
217</sqlQuery>
218</request>
219<request result="ok" sqlfile="1.6.0.11">
220<sqlQuery>
221<![CDATA[
222SET @id_order_state_oos = (SELECT `value` FROM `kap_configuration` WHERE `name` = 'PS_OS_OUTOFSTOCK' LIMIT 1)
223]]>
224</sqlQuery>
225</request>
226<request result="ok" sqlfile="1.6.0.11">
227<sqlQuery>
228<![CDATA[
229INSERT INTO `kap_order_state_lang` (`id_order_state`, `id_lang`, `name`, `template`) (SELECT @id_order_state, id_lang, name, template FROM `kap_order_state_lang` WHERE id_order_state = @id_order_state_oos)
230]]>
231</sqlQuery>
232</request>
233<request result="ok" sqlfile="1.6.0.11">
234<sqlQuery>
235<![CDATA[
236INSERT IGNORE INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_OS_OUTOFSTOCK_PAID', @id_order_state_oos, NOW(), NOW()), ('PS_OS_OUTOFSTOCK_UNPAID', @id_order_state, NOW(), NOW())
237]]>
238</sqlQuery>
239</request>
240<request result="fail" sqlfile="1.6.0.11">
241<sqlQuery>
242<![CDATA[
243ALTER TABLE `kap_module_access` ADD `uninstall` TINYINT( 1 ) NOT NULL AFTER `configure`
244]]>
245</sqlQuery>
246<sqlMsgError>
247<![CDATA[ Duplicate column name 'uninstall' ]]>
248</sqlMsgError>
249<sqlNumberError>
250<![CDATA[ 1060 ]]>
251</sqlNumberError>
252</request>
253<request result="fail" sqlfile="1.6.0.11">
254<sqlQuery>
255<![CDATA[
256ALTER TABLE `kap_specific_price` ADD `reduction_tax` TINYINT( 1 ) NOT NULL DEFAULT 1 AFTER `reduction`
257]]>
258</sqlQuery>
259<sqlMsgError>
260<![CDATA[ Duplicate column name 'reduction_tax' ]]>
261</sqlMsgError>
262<sqlNumberError>
263<![CDATA[ 1060 ]]>
264</sqlNumberError>
265</request>
266<request result="fail" sqlfile="1.6.0.11">
267<sqlQuery>
268<![CDATA[
269ALTER TABLE `kap_specific_price_rule` ADD `reduction_tax` TINYINT( 1 ) NOT NULL DEFAULT 1 AFTER `reduction`
270]]>
271</sqlQuery>
272<sqlMsgError>
273<![CDATA[ Duplicate column name 'reduction_tax' ]]>
274</sqlMsgError>
275<sqlNumberError>
276<![CDATA[ 1060 ]]>
277</sqlNumberError>
278</request>
279<request result="fail" sqlfile="1.6.0.11">
280<sqlQuery>
281<![CDATA[
282INSERT INTO `kap_hook` (`id_hook` , `name` , `title` , `description` , `position` , `live_edit`) VALUES (NULL , 'displayCustomerIdentityForm', 'Customer identity form displayed in Front Office', 'This hook displays new elements on the form to update a customer identity', '1', '0')
283]]>
284</sqlQuery>
285<sqlMsgError>
286<![CDATA[
287Duplicate entry 'displayCustomerIdentityForm' for key 'hook_name'
288]]>
289</sqlMsgError>
290<sqlNumberError>
291<![CDATA[ 1062 ]]>
292</sqlNumberError>
293</request>
294<request result="fail" sqlfile="1.6.0.11">
295<sqlQuery>
296<![CDATA[
297ALTER TABLE `kap_orders` ADD `round_mode` TINYINT(1) NOT NULL DEFAULT '2' AFTER `total_wrapping_tax_excl`
298]]>
299</sqlQuery>
300<sqlMsgError>
301<![CDATA[ Duplicate column name 'round_mode' ]]>
302</sqlMsgError>
303<sqlNumberError>
304<![CDATA[ 1060 ]]>
305</sqlNumberError>
306</request>
307<request result="ok" sqlfile="1.6.0.11">
308<sqlQuery>
309<![CDATA[
310ALTER TABLE `kap_product_attribute` MODIFY `unit_price_impact` DECIMAL(20,6)
311]]>
312</sqlQuery>
313</request>
314<request result="ok" sqlfile="1.6.0.11">
315<sqlQuery>
316<![CDATA[
317ALTER TABLE `kap_product_attribute_shop` MODIFY `unit_price_impact` DECIMAL(20,6)
318]]>
319</sqlQuery>
320</request>
321<request result="ok" sqlfile="1.6.0.11">
322<sqlQuery>
323<![CDATA[ /* PHP:p16011_media_server(); */ ]]>
324</sqlQuery>
325</request>
326<request result="ok" sqlfile="1.6.0.11">
327<sqlQuery>
328<![CDATA[
329INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_PRICE_DISPLAY_PRECISION', 2, NOW(), NOW())
330]]>
331</sqlQuery>
332</request>
333<request result="ok" sqlfile="1.6.0.11">
334<sqlQuery>
335<![CDATA[
336/* Precision used to be 2, now it can be set freely, so the DB must be ready to accept more decimals */ ALTER TABLE `kap_orders` CHANGE COLUMN `total_discounts` `total_discounts` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_discounts_tax_incl` `total_discounts_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_discounts_tax_excl` `total_discounts_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid` `total_paid` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid_tax_incl` `total_paid_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid_tax_excl` `total_paid_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid_real` `total_paid_real` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_products` `total_products` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_products_wt` `total_products_wt` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_shipping` `total_shipping` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_shipping_tax_incl` `total_shipping_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_shipping_tax_excl` `total_shipping_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_wrapping` `total_wrapping` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_wrapping_tax_incl` `total_wrapping_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_wrapping_tax_excl` `total_wrapping_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00'
337]]>
338</sqlQuery>
339</request>
340<request result="ok" sqlfile="1.6.0.11">
341<sqlQuery>
342<![CDATA[
343ALTER IGNORE TABLE `kap_product` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL DEFAULT NULL
344]]>
345</sqlQuery>
346</request>
347<request result="ok" sqlfile="1.6.0.11">
348<sqlQuery>
349<![CDATA[
350ALTER TABLE `kap_product` CHANGE `ean13` `ean13` VARCHAR( 13 ) NULL DEFAULT NULL
351]]>
352</sqlQuery>
353</request>
354<request result="ok" sqlfile="1.6.0.11">
355<sqlQuery>
356<![CDATA[
357ALTER IGNORE TABLE `kap_product_attribute` CHANGE `ean13` `ean13` BIGINT( 15 ) NULL DEFAULT NULL
358]]>
359</sqlQuery>
360</request>
361<request result="ok" sqlfile="1.6.0.11">
362<sqlQuery>
363<![CDATA[
364ALTER TABLE `kap_product_attribute` CHANGE `ean13` `ean13` VARCHAR( 13 ) NULL DEFAULT NULL
365]]>
366</sqlQuery>
367</request>
368<request result="fail" sqlfile="1.6.0.11">
369<sqlQuery>
370<![CDATA[
371ALTER TABLE `kap_order_slip` ADD `order_slip_type` TINYINT(1) NOT NULL DEFAULT 0 AFTER `partial`
372]]>
373</sqlQuery>
374<sqlMsgError>
375<![CDATA[ Duplicate column name 'order_slip_type' ]]>
376</sqlMsgError>
377<sqlNumberError>
378<![CDATA[ 1060 ]]>
379</sqlNumberError>
380</request>
381<request result="ok" sqlfile="1.6.0.12">
382<sqlQuery>
383<![CDATA[ SET NAMES 'utf8' ]]>
384</sqlQuery>
385</request>
386<request result="ok" sqlfile="1.6.0.12">
387<sqlQuery>
388<![CDATA[
389INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_CUSTOMER_NWSL', 1, NOW(), NOW()), ('PS_CUSTOMER_OPTIN', 1, NOW(), NOW())
390]]>
391</sqlQuery>
392</request>
393<request result="ok" sqlfile="1.6.0.12">
394<sqlQuery>
395<![CDATA[
396INSERT INTO `kap_order_state` (`invoice`, `send_email`, `module_name`, `color`, `unremovable`, `hidden`, `logable`, `delivery`, `shipped`, `paid`, `deleted`) VALUES ('0', '0', 'cashondelivery', '#4169E1', '1', '0', '0', '0', '0', '0', '0')
397]]>
398</sqlQuery>
399</request>
400<request result="ok" sqlfile="1.6.0.12">
401<sqlQuery>
402<![CDATA[ SET @id_order_state = LAST_INSERT_ID() ]]>
403</sqlQuery>
404</request>
405<request result="ok" sqlfile="1.6.0.12">
406<sqlQuery>
407<![CDATA[
408INSERT INTO `kap_order_state_lang` (`id_order_state`, `id_lang`, `name`, `template`) (SELECT @id_order_state, id_lang, 'Waiting cod validation', '' FROM `kap_lang`)
409]]>
410</sqlQuery>
411</request>
412<request result="ok" sqlfile="1.6.0.12">
413<sqlQuery>
414<![CDATA[
415INSERT IGNORE INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_OS_COD_VALIDATION', @id_order_state, NOW(), NOW())
416]]>
417</sqlQuery>
418</request>
419<request result="ok" sqlfile="1.6.0.12">
420<sqlQuery>
421<![CDATA[
422UPDATE `kap_hook` set `position` = 1 where `name` in ('displayBanner', 'displayNav', 'displayTopColumn')
423]]>
424</sqlQuery>
425</request>
426<request result="fail" sqlfile="1.6.0.12">
427<sqlQuery>
428<![CDATA[
429ALTER TABLE `kap_product` ADD `pack_stock_type` int(11) UNSIGNED DEFAULT '3'
430]]>
431</sqlQuery>
432<sqlMsgError>
433<![CDATA[ Duplicate column name 'pack_stock_type' ]]>
434</sqlMsgError>
435<sqlNumberError>
436<![CDATA[ 1060 ]]>
437</sqlNumberError>
438</request>
439<request result="fail" sqlfile="1.6.0.12">
440<sqlQuery>
441<![CDATA[
442ALTER TABLE `kap_product_shop` ADD `pack_stock_type` int(11) UNSIGNED DEFAULT '3'
443]]>
444</sqlQuery>
445<sqlMsgError>
446<![CDATA[ Duplicate column name 'pack_stock_type' ]]>
447</sqlMsgError>
448<sqlNumberError>
449<![CDATA[ 1060 ]]>
450</sqlNumberError>
451</request>
452<request result="fail" sqlfile="1.6.0.12">
453<sqlQuery>
454<![CDATA[
455ALTER TABLE `kap_pack` ADD `id_product_attribute_item` int(10) UNSIGNED NOT NULL AFTER `id_product_item`
456]]>
457</sqlQuery>
458<sqlMsgError>
459<![CDATA[ Duplicate column name 'id_product_attribute_item' ]]>
460</sqlMsgError>
461<sqlNumberError>
462<![CDATA[ 1060 ]]>
463</sqlNumberError>
464</request>
465<request result="ok" sqlfile="1.6.0.12">
466<sqlQuery>
467<![CDATA[ ALTER TABLE `kap_pack` DROP PRIMARY KEY ]]>
468</sqlQuery>
469</request>
470<request result="ok" sqlfile="1.6.0.12">
471<sqlQuery>
472<![CDATA[ /* PHP:p16012_pack_rework(); */ ]]>
473</sqlQuery>
474</request>
475<request result="ok" sqlfile="1.6.0.12">
476<sqlQuery>
477<![CDATA[
478ALTER TABLE `kap_pack` ADD PRIMARY KEY (`id_product_pack`, `id_product_item`, `id_product_attribute_item`)
479]]>
480</sqlQuery>
481</request>
482<request result="fail" sqlfile="1.6.0.12">
483<sqlQuery>
484<![CDATA[
485ALTER TABLE `kap_order_state` ADD `pdf_delivery` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `paid`
486]]>
487</sqlQuery>
488<sqlMsgError>
489<![CDATA[ Duplicate column name 'pdf_delivery' ]]>
490</sqlMsgError>
491<sqlNumberError>
492<![CDATA[ 1060 ]]>
493</sqlNumberError>
494</request>
495<request result="fail" sqlfile="1.6.0.12">
496<sqlQuery>
497<![CDATA[
498ALTER TABLE `kap_order_state` ADD `pdf_invoice` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0' AFTER `pdf_delivery`
499]]>
500</sqlQuery>
501<sqlMsgError>
502<![CDATA[ Duplicate column name 'pdf_invoice' ]]>
503</sqlMsgError>
504<sqlNumberError>
505<![CDATA[ 1060 ]]>
506</sqlNumberError>
507</request>
508<request result="ok" sqlfile="1.6.0.12">
509<sqlQuery>
510<![CDATA[
511ALTER TABLE `kap_orders` CHANGE `shipping_number` `shipping_number` VARCHAR( 64 )
512]]>
513</sqlQuery>
514</request>
515<request result="ok" sqlfile="1.6.0.12">
516<sqlQuery>
517<![CDATA[ /* PHP:ps16012_update_alias(); */ ]]>
518</sqlQuery>
519</request>
520<request result="ok" sqlfile="1.6.0.12">
521<sqlQuery>
522<![CDATA[
523ALTER TABLE `kap_store` CHANGE `hours` `hours` TEXT
524]]>
525</sqlQuery>
526</request>
527<request result="fail" sqlfile="1.6.0.12">
528<sqlQuery>
529<![CDATA[
530ALTER TABLE `kap_cms_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang`
531]]>
532</sqlQuery>
533<sqlMsgError>
534<![CDATA[ Duplicate column name 'id_shop' ]]>
535</sqlMsgError>
536<sqlNumberError>
537<![CDATA[ 1060 ]]>
538</sqlNumberError>
539</request>
540<request result="ok" sqlfile="1.6.0.12">
541<sqlQuery>
542<![CDATA[
543ALTER TABLE `kap_cms_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cms`, `id_shop`, `id_lang`)
544]]>
545</sqlQuery>
546</request>
547<request result="fail" sqlfile="1.6.0.12">
548<sqlQuery>
549<![CDATA[
550ALTER TABLE `kap_cms_category_lang` ADD `id_shop` INT(11) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang`
551]]>
552</sqlQuery>
553<sqlMsgError>
554<![CDATA[ Duplicate column name 'id_shop' ]]>
555</sqlMsgError>
556<sqlNumberError>
557<![CDATA[ 1060 ]]>
558</sqlNumberError>
559</request>
560<request result="ok" sqlfile="1.6.0.12">
561<sqlQuery>
562<![CDATA[
563ALTER TABLE `kap_cms_category_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_cms_category`, `id_shop`, `id_lang`)
564]]>
565</sqlQuery>
566</request>
567<request result="fail" sqlfile="1.6.0.12">
568<sqlQuery>
569<![CDATA[
570CREATE TABLE `kap_cms_category_shop` ( `id_cms_category` int(10) unsigned NOT NULL AUTO_INCREMENT, `id_shop` INT(11) UNSIGNED NOT NULL , PRIMARY KEY (`id_cms_category`, `id_shop`), KEY `id_shop` (`id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
571]]>
572</sqlQuery>
573<sqlMsgError>
574<![CDATA[ Table 'kap_cms_category_shop' already exists ]]>
575</sqlMsgError>
576<sqlNumberError>
577<![CDATA[ 1050 ]]>
578</sqlNumberError>
579</request>
580<request result="ok" sqlfile="1.6.0.12">
581<sqlQuery>
582<![CDATA[ /* PHP:cms_multishop(); */ ]]>
583</sqlQuery>
584</request>
585<request result="fail" sqlfile="1.6.0.12">
586<sqlQuery>
587<![CDATA[
588ALTER TABLE `kap_customization_field_lang` ADD `id_shop` INT(10) UNSIGNED NOT NULL DEFAULT '1' AFTER `id_lang`
589]]>
590</sqlQuery>
591<sqlMsgError>
592<![CDATA[ Duplicate column name 'id_shop' ]]>
593</sqlMsgError>
594<sqlNumberError>
595<![CDATA[ 1060 ]]>
596</sqlNumberError>
597</request>
598<request result="ok" sqlfile="1.6.0.12">
599<sqlQuery>
600<![CDATA[
601ALTER TABLE `kap_customization_field_lang` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_customization_field`, `id_shop`, `id_lang`)
602]]>
603</sqlQuery>
604</request>
605<request result="ok" sqlfile="1.6.0.12">
606<sqlQuery>
607<![CDATA[ /* PHP:customization_field_multishop_lang(); */ ]]>
608</sqlQuery>
609</request>
610<request result="ok" sqlfile="1.6.0.12">
611<sqlQuery>
612<![CDATA[
613ALTER TABLE `kap_product` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00'
614]]>
615</sqlQuery>
616</request>
617<request result="ok" sqlfile="1.6.0.12">
618<sqlQuery>
619<![CDATA[
620ALTER TABLE `kap_product_shop` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00'
621]]>
622</sqlQuery>
623</request>
624<request result="ok" sqlfile="1.6.0.12">
625<sqlQuery>
626<![CDATA[
627ALTER TABLE `kap_product_attribute` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00'
628]]>
629</sqlQuery>
630</request>
631<request result="ok" sqlfile="1.6.0.12">
632<sqlQuery>
633<![CDATA[
634ALTER TABLE `kap_product_attribute_shop` CHANGE `available_date` `available_date` DATE NOT NULL DEFAULT '0000-00-00'
635]]>
636</sqlQuery>
637</request>
638<request result="ok" sqlfile="1.6.0.12">
639<sqlQuery>
640<![CDATA[
641ALTER TABLE `kap_module_access` CHANGE `view` `view` TINYINT( 1 ) NOT NULL DEFAULT '0', CHANGE `configure` `configure` TINYINT( 1 ) NOT NULL DEFAULT '0', CHANGE `uninstall` `uninstall` TINYINT( 1 ) NOT NULL DEFAULT '0'
642]]>
643</sqlQuery>
644</request>
645<request result="ok" sqlfile="1.6.1.0">
646<sqlQuery>
647<![CDATA[ SET NAMES 'utf8' ]]>
648</sqlQuery>
649</request>
650<request result="ok" sqlfile="1.6.1.0">
651<sqlQuery>
652<![CDATA[
653UPDATE `kap_configuration` SET `value` = CONCAT('#', `value`) WHERE `name` LIKE 'PS_%_PREFIX' AND `value` NOT LIKE '#%'
654]]>
655</sqlQuery>
656</request>
657<request result="ok" sqlfile="1.6.1.0">
658<sqlQuery>
659<![CDATA[
660UPDATE `kap_configuration_lang` SET `value` = CONCAT('#', `value`) WHERE `id_configuration` IN (SELECT `id_configuration` FROM `kap_configuration` WHERE `name` LIKE 'PS_%_PREFIX') AND `value` NOT LIKE '#%'
661]]>
662</sqlQuery>
663</request>
664<request result="ok" sqlfile="1.6.1.0">
665<sqlQuery>
666<![CDATA[
667ALTER TABLE `kap_orders` CHANGE `invoice_number` `invoice_number` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0', CHANGE `delivery_number` `delivery_number` INT( 11 ) UNSIGNED NOT NULL DEFAULT '0'
668]]>
669</sqlQuery>
670</request>
671<request result="ok" sqlfile="1.6.1.0">
672<sqlQuery>
673<![CDATA[
674/* taxes-patch */ ALTER TABLE `kap_order_invoice` CHANGE COLUMN `total_discount_tax_excl` `total_discount_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_discount_tax_incl` `total_discount_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid_tax_excl` `total_paid_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_paid_tax_incl` `total_paid_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_products` `total_products` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_products_wt` `total_products_wt` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_shipping_tax_excl` `total_shipping_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_shipping_tax_incl` `total_shipping_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_wrapping_tax_excl` `total_wrapping_tax_excl` DECIMAL(20,6) NOT NULL DEFAULT '0.00' , CHANGE COLUMN `total_wrapping_tax_incl` `total_wrapping_tax_incl` DECIMAL(20,6) NOT NULL DEFAULT '0.00'
675]]>
676</sqlQuery>
677</request>
678<request result="fail" sqlfile="1.6.1.0">
679<sqlQuery>
680<![CDATA[
681ALTER TABLE `kap_orders` ADD `round_type` TINYINT(1) NOT NULL DEFAULT '1' AFTER `round_mode`
682]]>
683</sqlQuery>
684<sqlMsgError>
685<![CDATA[ Duplicate column name 'round_type' ]]>
686</sqlMsgError>
687<sqlNumberError>
688<![CDATA[ 1060 ]]>
689</sqlNumberError>
690</request>
691<request result="fail" sqlfile="1.6.1.0">
692<sqlQuery>
693<![CDATA[
694ALTER TABLE kap_product_tag ADD `id_lang` int(10) unsigned NOT NULL, ADD KEY (id_lang, id_tag)
695]]>
696</sqlQuery>
697<sqlMsgError>
698<![CDATA[ Duplicate column name 'id_lang' ]]>
699</sqlMsgError>
700<sqlNumberError>
701<![CDATA[ 1060 ]]>
702</sqlNumberError>
703</request>
704<request result="ok" sqlfile="1.6.1.0">
705<sqlQuery>
706<![CDATA[
707UPDATE kap_product_tag, kap_tag SET kap_product_tag.id_lang=kap_tag.id_lang WHERE kap_tag.id_tag=kap_product_tag.id_tag
708]]>
709</sqlQuery>
710</request>
711<request result="ok" sqlfile="1.6.1.0">
712<sqlQuery>
713<![CDATA[ DROP TABLE IF EXISTS `kap_tag_count` ]]>
714</sqlQuery>
715</request>
716<request result="ok" sqlfile="1.6.1.0">
717<sqlQuery>
718<![CDATA[
719CREATE TABLE `kap_tag_count` ( `id_group` int(10) unsigned NOT NULL DEFAULT 0, `id_tag` int(10) unsigned NOT NULL DEFAULT 0, `id_lang` int(10) unsigned NOT NULL DEFAULT 0, `id_shop` int(11) unsigned NOT NULL DEFAULT 0, `counter` int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (`id_group`, `id_tag`), KEY (`id_group`, `id_lang`, `id_shop`, `counter`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
720]]>
721</sqlQuery>
722</request>
723<request result="ok" sqlfile="1.6.1.0">
724<sqlQuery>
725<![CDATA[
726REPLACE INTO `kap_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `kap_product_tag` pt LEFT JOIN `kap_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `kap_product` p ON (p.id_product = pt.id_product)
727]]>
728<![CDATA[
729INNER JOIN `kap_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_group FROM `kap_category_group`) cg JOIN (SELECT DISTINCT id_shop FROM `kap_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `kap_category_product` cp LEFT JOIN `kap_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND p.`id_product` = cp.`id_product`) AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag, cg.id_group
730]]>
731</sqlQuery>
732</request>
733<request result="ok" sqlfile="1.6.1.0">
734<sqlQuery>
735<![CDATA[
736REPLACE INTO `kap_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, t.id_tag, t.id_lang, ps.id_shop, COUNT(pt.id_tag) AS times FROM `kap_product_tag` pt LEFT JOIN `kap_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `kap_product` p ON (p.id_product = pt.id_product) INNER JOIN `kap_product_shop` product_shop ON (product_shop.id_product = p.id_product) JOIN (SELECT DISTINCT id_shop FROM `kap_shop`) ps WHERE pt.`id_lang` = 1 AND product_shop.`active` = 1 AND product_shop.id_shop = ps.id_shop GROUP BY pt.id_tag
737]]>
738</sqlQuery>
739</request>
740<request result="ok" sqlfile="1.6.1.0">
741<sqlQuery>
742<![CDATA[
743/* PHP:alter_ignore_drop_key(shop, id_group_shop); */
744]]>
745</sqlQuery>
746</request>
747<request result="ok" sqlfile="1.6.1.0">
748<sqlQuery>
749<![CDATA[
750/* PHP:alter_ignore_drop_key(specific_price, id_product_2); */
751]]>
752</sqlQuery>
753</request>
754<request result="ok" sqlfile="1.6.1.0">
755<sqlQuery>
756<![CDATA[
757/* PHP:alter_ignore_drop_key(hook_module, position); */
758]]>
759</sqlQuery>
760</request>
761<request result="ok" sqlfile="1.6.1.0">
762<sqlQuery>
763<![CDATA[
764/* PHP:alter_ignore_drop_key(cart_product, PRIMARY); */
765]]>
766</sqlQuery>
767</request>
768<request result="ok" sqlfile="1.6.1.0">
769<sqlQuery>
770<![CDATA[
771/* PHP:alter_ignore_drop_key(cart_product, cart_product_index); */
772]]>
773</sqlQuery>
774</request>
775<request result="fail" sqlfile="1.6.1.0">
776<sqlQuery>
777<![CDATA[
778ALTER TABLE `kap_shop_group` ADD KEY `deleted` (`deleted`, `name`)
779]]>
780</sqlQuery>
781<sqlMsgError>
782<![CDATA[ Duplicate key name 'deleted' ]]>
783</sqlMsgError>
784<sqlNumberError>
785<![CDATA[ 1061 ]]>
786</sqlNumberError>
787</request>
788<request result="ok" sqlfile="1.6.1.0">
789<sqlQuery>
790<![CDATA[ ALTER TABLE `kap_shop` DROP KEY `id_shop_group` ]]>
791</sqlQuery>
792</request>
793<request result="ok" sqlfile="1.6.1.0">
794<sqlQuery>
795<![CDATA[
796ALTER TABLE `kap_shop` ADD KEY `id_shop_group` (`id_shop_group`, `deleted`)
797]]>
798</sqlQuery>
799</request>
800<request result="ok" sqlfile="1.6.1.0">
801<sqlQuery>
802<![CDATA[ ALTER TABLE `kap_shop_url` DROP KEY `id_shop` ]]>
803</sqlQuery>
804</request>
805<request result="ok" sqlfile="1.6.1.0">
806<sqlQuery>
807<![CDATA[
808ALTER TABLE `kap_shop_url` ADD KEY `id_shop` (`id_shop`, `main`)
809]]>
810</sqlQuery>
811</request>
812<request result="ok" sqlfile="1.6.1.0">
813<sqlQuery>
814<![CDATA[
815ALTER TABLE `kap_customization` ADD KEY `id_cart` (`id_cart`)
816]]>
817</sqlQuery>
818</request>
819<request result="fail" sqlfile="1.6.1.0">
820<sqlQuery>
821<![CDATA[
822ALTER TABLE `kap_product_sale` ADD KEY `quantity` (`quantity`)
823]]>
824</sqlQuery>
825<sqlMsgError>
826<![CDATA[ Duplicate key name 'quantity' ]]>
827</sqlMsgError>
828<sqlNumberError>
829<![CDATA[ 1061 ]]>
830</sqlNumberError>
831</request>
832<request result="fail" sqlfile="1.6.1.0">
833<sqlQuery>
834<![CDATA[
835ALTER TABLE `kap_cart_rule` ADD KEY `id_customer` (`id_customer`, `active`, `date_to`)
836]]>
837</sqlQuery>
838<sqlMsgError>
839<![CDATA[ Duplicate key name 'id_customer' ]]>
840</sqlMsgError>
841<sqlNumberError>
842<![CDATA[ 1061 ]]>
843</sqlNumberError>
844</request>
845<request result="fail" sqlfile="1.6.1.0">
846<sqlQuery>
847<![CDATA[
848ALTER TABLE `kap_cart_rule` ADD KEY `group_restriction` (`group_restriction`, `active`, `date_to`)
849]]>
850</sqlQuery>
851<sqlMsgError>
852<![CDATA[ Duplicate key name 'group_restriction' ]]>
853</sqlMsgError>
854<sqlNumberError>
855<![CDATA[ 1061 ]]>
856</sqlNumberError>
857</request>
858<request result="ok" sqlfile="1.6.1.0">
859<sqlQuery>
860<![CDATA[
861ALTER TABLE `kap_hook_module` ADD KEY `position` (`id_shop`, `position`)
862]]>
863</sqlQuery>
864</request>
865<request result="ok" sqlfile="1.6.1.0">
866<sqlQuery>
867<![CDATA[
868ALTER IGNORE TABLE `kap_cart_product` ADD PRIMARY KEY (`id_cart`,`id_product`,`id_product_attribute`,`id_address_delivery`)
869]]>
870</sqlQuery>
871</request>
872<request result="fail" sqlfile="1.6.1.0">
873<sqlQuery>
874<![CDATA[
875ALTER TABLE `kap_cart_product` ADD KEY `id_cart_order` (`id_cart`, `date_add`, `id_product`, `id_product_attribute`)
876]]>
877</sqlQuery>
878<sqlMsgError>
879<![CDATA[ Duplicate key name 'id_cart_order' ]]>
880</sqlMsgError>
881<sqlNumberError>
882<![CDATA[ 1061 ]]>
883</sqlNumberError>
884</request>
885<request result="ok" sqlfile="1.6.1.0">
886<sqlQuery>
887<![CDATA[ ALTER TABLE `kap_customization` DROP KEY id_cart ]]>
888</sqlQuery>
889</request>
890<request result="fail" sqlfile="1.6.1.0">
891<sqlQuery>
892<![CDATA[
893ALTER IGNORE TABLE `kap_customization` ADD KEY `id_cart_product` (`id_cart`, `id_product`, `id_product_attribute`)
894]]>
895</sqlQuery>
896<sqlMsgError>
897<![CDATA[ Duplicate key name 'id_cart_product' ]]>
898</sqlMsgError>
899<sqlNumberError>
900<![CDATA[ 1061 ]]>
901</sqlNumberError>
902</request>
903<request result="fail" sqlfile="1.6.1.0">
904<sqlQuery>
905<![CDATA[
906ALTER TABLE `kap_category` DROP KEY nleftright, DROP KEY nleft
907]]>
908</sqlQuery>
909<sqlMsgError>
910<![CDATA[
911Can't DROP 'nleftright'; check that column/key exists
912]]>
913</sqlMsgError>
914<sqlNumberError>
915<![CDATA[ 1091 ]]>
916</sqlNumberError>
917</request>
918<request result="fail" sqlfile="1.6.1.0">
919<sqlQuery>
920<![CDATA[
921ALTER TABLE `kap_category` ADD KEY `activenleft` (`active`,`nleft`), ADD KEY `activenright` (`active`,`nright`)
922]]>
923</sqlQuery>
924<sqlMsgError>
925<![CDATA[ Duplicate key name 'activenleft' ]]>
926</sqlMsgError>
927<sqlNumberError>
928<![CDATA[ 1061 ]]>
929</sqlNumberError>
930</request>
931<request result="fail" sqlfile="1.6.1.0">
932<sqlQuery>
933<![CDATA[
934ALTER IGNORE TABLE `kap_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`, `id_shop`, `cover`)
935]]>
936</sqlQuery>
937<sqlMsgError>
938<![CDATA[
939Can't DROP 'id_image'; check that column/key exists
940]]>
941</sqlMsgError>
942<sqlNumberError>
943<![CDATA[ 1091 ]]>
944</sqlNumberError>
945</request>
946<request result="fail" sqlfile="1.6.1.0">
947<sqlQuery>
948<![CDATA[
949ALTER TABLE kap_product_attribute_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `default_on`)
950]]>
951</sqlQuery>
952<sqlMsgError>
953<![CDATA[ Duplicate column name 'id_product' ]]>
954</sqlMsgError>
955<sqlNumberError>
956<![CDATA[ 1060 ]]>
957</sqlNumberError>
958</request>
959<request result="ok" sqlfile="1.6.1.0">
960<sqlQuery>
961<![CDATA[
962UPDATE kap_product_attribute_shop, kap_product_attribute SET kap_product_attribute_shop.id_product=kap_product_attribute.id_product WHERE kap_product_attribute_shop.id_product_attribute=kap_product_attribute.id_product_attribute
963]]>
964</sqlQuery>
965</request>
966<request result="fail" sqlfile="1.6.1.0">
967<sqlQuery>
968<![CDATA[
969ALTER TABLE kap_image_shop ADD `id_product` int(10) unsigned NOT NULL, ADD KEY `id_product` (`id_product`, `id_shop`, `cover`)
970]]>
971</sqlQuery>
972<sqlMsgError>
973<![CDATA[ Duplicate column name 'id_product' ]]>
974</sqlMsgError>
975<sqlNumberError>
976<![CDATA[ 1060 ]]>
977</sqlNumberError>
978</request>
979<request result="ok" sqlfile="1.6.1.0">
980<sqlQuery>
981<![CDATA[
982UPDATE kap_image_shop, kap_image SET kap_image_shop.id_product=kap_image.id_product WHERE kap_image_shop.id_image=kap_image.id_image
983]]>
984</sqlQuery>
985</request>
986<request result="ok" sqlfile="1.6.1.0">
987<sqlQuery>
988<![CDATA[
989ALTER IGNORE TABLE `kap_image_shop` DROP PRIMARY KEY, ADD PRIMARY KEY (`id_image`, `id_shop`)
990]]>
991</sqlQuery>
992</request>
993<request result="fail" sqlfile="1.6.1.0">
994<sqlQuery>
995<![CDATA[
996ALTER TABLE `kap_product_supplier` ADD KEY `id_supplier` (`id_supplier`,`id_product`)
997]]>
998</sqlQuery>
999<sqlMsgError>
1000<![CDATA[ Duplicate key name 'id_supplier' ]]>
1001</sqlMsgError>
1002<sqlNumberError>
1003<![CDATA[ 1061 ]]>
1004</sqlNumberError>
1005</request>
1006<request result="ok" sqlfile="1.6.1.0">
1007<sqlQuery>
1008<![CDATA[
1009ALTER TABLE `kap_product` DROP KEY `product_manufacturer`
1010]]>
1011</sqlQuery>
1012</request>
1013<request result="ok" sqlfile="1.6.1.0">
1014<sqlQuery>
1015<![CDATA[
1016ALTER TABLE `kap_product` ADD KEY `product_manufacturer` (`id_manufacturer`, `id_product`)
1017]]>
1018</sqlQuery>
1019</request>
1020<request result="ok" sqlfile="1.6.1.0">
1021<sqlQuery>
1022<![CDATA[ DROP TABLE IF EXISTS `kap_smarty_lazy_cache` ]]>
1023</sqlQuery>
1024</request>
1025<request result="ok" sqlfile="1.6.1.0">
1026<sqlQuery>
1027<![CDATA[
1028CREATE TABLE `kap_smarty_lazy_cache` ( `template_hash` varchar(32) NOT NULL DEFAULT '', `cache_id` varchar(255) NOT NULL DEFAULT '', `compile_id` varchar(32) NOT NULL DEFAULT '', `filepath` varchar(255) NOT NULL DEFAULT '', `last_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`template_hash`, `cache_id`, `compile_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1029]]>
1030</sqlQuery>
1031</request>
1032<request result="ok" sqlfile="1.6.1.0">
1033<sqlQuery>
1034<![CDATA[ DROP TABLE IF EXISTS `kap_smarty_last_flush` ]]>
1035</sqlQuery>
1036</request>
1037<request result="ok" sqlfile="1.6.1.0">
1038<sqlQuery>
1039<![CDATA[
1040CREATE TABLE `kap_smarty_last_flush` ( `type` ENUM('compile', 'template'), `last_flush` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`type`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1041]]>
1042</sqlQuery>
1043</request>
1044<request result="ok" sqlfile="1.6.1.0">
1045<sqlQuery>
1046<![CDATA[ DROP TABLE IF EXISTS `kap_modules_perfs` ]]>
1047</sqlQuery>
1048</request>
1049<request result="ok" sqlfile="1.6.1.0">
1050<sqlQuery>
1051<![CDATA[
1052CREATE TABLE `kap_modules_perfs` ( `id_modules_perfs` int(11) unsigned NOT NULL AUTO_INCREMENT, `session` int(11) unsigned NOT NULL, `module` varchar(62) NOT NULL, `method` varchar(126) NOT NULL, `time_start` double unsigned NOT NULL, `time_end` double unsigned NOT NULL, `memory_start` int unsigned NOT NULL, `memory_end` int unsigned NOT NULL, PRIMARY KEY (`id_modules_perfs`), KEY (`session`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1053]]>
1054</sqlQuery>
1055</request>
1056<request result="ok" sqlfile="1.6.1.0">
1057<sqlQuery>
1058<![CDATA[
1059ALTER TABLE `kap_image` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL
1060]]>
1061</sqlQuery>
1062</request>
1063<request result="ok" sqlfile="1.6.1.0">
1064<sqlQuery>
1065<![CDATA[
1066UPDATE `kap_image` SET `cover`=NULL WHERE `cover`=0
1067]]>
1068</sqlQuery>
1069</request>
1070<request result="ok" sqlfile="1.6.1.0">
1071<sqlQuery>
1072<![CDATA[
1073CREATE TEMPORARY TABLE `image_transform` SELECT `id_product`, COUNT(*) c FROM `kap_image` WHERE `cover`=1 GROUP BY `id_product` HAVING c>1
1074]]>
1075</sqlQuery>
1076</request>
1077<request result="ok" sqlfile="1.6.1.0">
1078<sqlQuery>
1079<![CDATA[
1080UPDATE `image_transform` JOIN `kap_image` USING (`id_product`) SET `kap_image`.`cover`=NULL
1081]]>
1082</sqlQuery>
1083</request>
1084<request result="ok" sqlfile="1.6.1.0">
1085<sqlQuery>
1086<![CDATA[
1087ALTER TABLE `kap_image` DROP KEY `id_product_cover`
1088]]>
1089</sqlQuery>
1090</request>
1091<request result="ok" sqlfile="1.6.1.0">
1092<sqlQuery>
1093<![CDATA[
1094ALTER IGNORE TABLE `kap_image` ADD UNIQUE KEY `id_product_cover` (`id_product`,`cover`)
1095]]>
1096</sqlQuery>
1097</request>
1098<request result="ok" sqlfile="1.6.1.0">
1099<sqlQuery>
1100<![CDATA[
1101ALTER TABLE `kap_image_shop` CHANGE `cover` `cover` tinyint(1) unsigned NULL DEFAULT NULL
1102]]>
1103</sqlQuery>
1104</request>
1105<request result="ok" sqlfile="1.6.1.0">
1106<sqlQuery>
1107<![CDATA[
1108UPDATE `kap_image_shop` SET `cover`=NULL WHERE `cover`=0
1109]]>
1110</sqlQuery>
1111</request>
1112<request result="ok" sqlfile="1.6.1.0">
1113<sqlQuery>
1114<![CDATA[
1115CREATE TEMPORARY TABLE `image_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `kap_image_shop` WHERE `cover`=1 GROUP BY `id_product`, `id_shop` HAVING c>1
1116]]>
1117</sqlQuery>
1118</request>
1119<request result="ok" sqlfile="1.6.1.0">
1120<sqlQuery>
1121<![CDATA[
1122UPDATE `image_shop_transform` JOIN `kap_image_shop` USING (`id_product`, `id_shop`) SET `kap_image_shop`.`cover`=NULL
1123]]>
1124</sqlQuery>
1125</request>
1126<request result="ok" sqlfile="1.6.1.0">
1127<sqlQuery>
1128<![CDATA[ ALTER TABLE `kap_image_shop` DROP KEY `id_product` ]]>
1129</sqlQuery>
1130</request>
1131<request result="ok" sqlfile="1.6.1.0">
1132<sqlQuery>
1133<![CDATA[
1134ALTER IGNORE TABLE `kap_image_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `cover`)
1135]]>
1136</sqlQuery>
1137</request>
1138<request result="ok" sqlfile="1.6.1.0">
1139<sqlQuery>
1140<![CDATA[
1141ALTER TABLE `kap_product_attribute` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL
1142]]>
1143</sqlQuery>
1144</request>
1145<request result="ok" sqlfile="1.6.1.0">
1146<sqlQuery>
1147<![CDATA[
1148UPDATE `kap_product_attribute` SET `default_on`=NULL WHERE `default_on`=0
1149]]>
1150</sqlQuery>
1151</request>
1152<request result="ok" sqlfile="1.6.1.0">
1153<sqlQuery>
1154<![CDATA[
1155CREATE TEMPORARY TABLE `attribute_transform` SELECT `id_product`, COUNT(*) c FROM `kap_product_attribute` WHERE `default_on`=1 GROUP BY `id_product` HAVING c>1
1156]]>
1157</sqlQuery>
1158</request>
1159<request result="ok" sqlfile="1.6.1.0">
1160<sqlQuery>
1161<![CDATA[
1162UPDATE `attribute_transform` JOIN `kap_product_attribute` USING (`id_product`) SET `kap_product_attribute`.`default_on`=NULL
1163]]>
1164</sqlQuery>
1165</request>
1166<request result="ok" sqlfile="1.6.1.0">
1167<sqlQuery>
1168<![CDATA[
1169ALTER TABLE `kap_product_attribute` DROP KEY `product_default`
1170]]>
1171</sqlQuery>
1172</request>
1173<request result="ok" sqlfile="1.6.1.0">
1174<sqlQuery>
1175<![CDATA[
1176ALTER IGNORE TABLE `kap_product_attribute` ADD UNIQUE KEY `product_default` (`id_product`,`default_on`)
1177]]>
1178</sqlQuery>
1179</request>
1180<request result="ok" sqlfile="1.6.1.0">
1181<sqlQuery>
1182<![CDATA[
1183ALTER TABLE `kap_product_attribute_shop` CHANGE `default_on` `default_on` tinyint(1) unsigned NULL DEFAULT NULL
1184]]>
1185</sqlQuery>
1186</request>
1187<request result="ok" sqlfile="1.6.1.0">
1188<sqlQuery>
1189<![CDATA[
1190UPDATE `kap_product_attribute_shop` SET `default_on`=NULL WHERE `default_on`=0
1191]]>
1192</sqlQuery>
1193</request>
1194<request result="ok" sqlfile="1.6.1.0">
1195<sqlQuery>
1196<![CDATA[
1197CREATE TEMPORARY TABLE `attribute_shop_transform` SELECT `id_product`, `id_shop`, COUNT(*) c FROM `kap_product_attribute_shop` WHERE `default_on`=1 GROUP BY `id_product`, `id_shop` HAVING c>1
1198]]>
1199</sqlQuery>
1200</request>
1201<request result="ok" sqlfile="1.6.1.0">
1202<sqlQuery>
1203<![CDATA[
1204UPDATE `attribute_shop_transform` JOIN `kap_product_attribute_shop` USING (`id_product`, `id_shop`) SET `kap_product_attribute_shop`.`default_on`=NULL
1205]]>
1206</sqlQuery>
1207</request>
1208<request result="ok" sqlfile="1.6.1.0">
1209<sqlQuery>
1210<![CDATA[
1211ALTER TABLE `kap_product_attribute_shop` DROP KEY `id_product`
1212]]>
1213</sqlQuery>
1214</request>
1215<request result="ok" sqlfile="1.6.1.0">
1216<sqlQuery>
1217<![CDATA[
1218ALTER IGNORE TABLE `kap_product_attribute_shop` ADD UNIQUE KEY `id_product` (`id_product`, `id_shop`, `default_on`)
1219]]>
1220</sqlQuery>
1221</request>
1222<request result="fail" sqlfile="1.6.1.0">
1223<sqlQuery>
1224<![CDATA[
1225ALTER IGNORE TABLE `kap_product_download` ADD UNIQUE KEY `id_product` (`id_product`)
1226]]>
1227</sqlQuery>
1228<sqlMsgError>
1229<![CDATA[ Duplicate key name 'id_product' ]]>
1230</sqlMsgError>
1231<sqlNumberError>
1232<![CDATA[ 1061 ]]>
1233</sqlNumberError>
1234</request>
1235<request result="ok" sqlfile="1.6.1.0">
1236<sqlQuery>
1237<![CDATA[ ALTER TABLE `kap_customer` DROP KEY `id_shop` ]]>
1238</sqlQuery>
1239</request>
1240<request result="ok" sqlfile="1.6.1.0">
1241<sqlQuery>
1242<![CDATA[
1243ALTER TABLE `kap_customer` ADD KEY `id_shop` (`id_shop`, `date_add`)
1244]]>
1245</sqlQuery>
1246</request>
1247<request result="ok" sqlfile="1.6.1.0">
1248<sqlQuery>
1249<![CDATA[ ALTER TABLE `kap_cart` DROP KEY `id_shop` ]]>
1250</sqlQuery>
1251</request>
1252<request result="fail" sqlfile="1.6.1.0">
1253<sqlQuery>
1254<![CDATA[
1255ALTER TABLE `kap_cart` ADD KEY `id_shop_2` (`id_shop`,`date_upd`), ADD KEY `id_shop` (`id_shop`,`date_add`)
1256]]>
1257</sqlQuery>
1258<sqlMsgError>
1259<![CDATA[ Duplicate key name 'id_shop_2' ]]>
1260</sqlMsgError>
1261<sqlNumberError>
1262<![CDATA[ 1061 ]]>
1263</sqlNumberError>
1264</request>
1265<request result="fail" sqlfile="1.6.1.0">
1266<sqlQuery>
1267<![CDATA[
1268ALTER TABLE `kap_product_shop` ADD KEY `indexed` (`indexed`, `active`, `id_product`)
1269]]>
1270</sqlQuery>
1271<sqlMsgError>
1272<![CDATA[ Duplicate key name 'indexed' ]]>
1273</sqlMsgError>
1274<sqlNumberError>
1275<![CDATA[ 1061 ]]>
1276</sqlNumberError>
1277</request>
1278<request result="ok" sqlfile="1.6.1.0">
1279<sqlQuery>
1280<![CDATA[
1281UPDATE `kap_product_shop` SET `date_add` = NOW() WHERE `date_add` = "0000-00-00 00:00:00"
1282]]>
1283</sqlQuery>
1284</request>
1285<request result="ok" sqlfile="1.6.1.0">
1286<sqlQuery>
1287<![CDATA[
1288INSERT IGNORE INTO `kap_hook` (`id_hook`, `name`, `title`, `description`, `position`, `live_edit`) VALUES (NULL, 'actionAdminLoginControllerSetMedia', 'Set media on admin login page header', 'This hook is called after adding media to admin login page header', '1', '0'), (NULL, 'actionOrderEdited', 'Order edited', 'This hook is called when an order is edited.', '1', '0'), (NULL, 'displayAdminNavBarBeforeEnd', 'Admin Nav-bar before end', 'Called before the end of the nav-bar.', '1', '0'), (NULL, 'displayAdminAfterHeader', 'Admin after header', 'Hook called just after the header of the backoffice.', '1', '0'), (NULL, 'displayAdminLogin', 'Admin login', 'Hook called just after login of the backoffice.', '1', '0')
1289]]>
1290</sqlQuery>
1291</request>
1292<request result="fail" sqlfile="1.6.1.0">
1293<sqlQuery>
1294<![CDATA[
1295ALTER TABLE `kap_cart_rule` ADD KEY `id_customer_2` (`id_customer`,`active`,`highlight`,`date_to`)
1296]]>
1297</sqlQuery>
1298<sqlMsgError>
1299<![CDATA[ Duplicate key name 'id_customer_2' ]]>
1300</sqlMsgError>
1301<sqlNumberError>
1302<![CDATA[ 1061 ]]>
1303</sqlNumberError>
1304</request>
1305<request result="fail" sqlfile="1.6.1.0">
1306<sqlQuery>
1307<![CDATA[
1308ALTER TABLE `kap_cart_rule` ADD KEY `group_restriction_2` (`group_restriction`,`active`,`highlight`,`date_to`)
1309]]>
1310</sqlQuery>
1311<sqlMsgError>
1312<![CDATA[ Duplicate key name 'group_restriction_2' ]]>
1313</sqlMsgError>
1314<sqlNumberError>
1315<![CDATA[ 1061 ]]>
1316</sqlNumberError>
1317</request>
1318<request result="ok" sqlfile="1.6.1.0">
1319<sqlQuery>
1320<![CDATA[
1321ALTER TABLE `kap_configuration_kpi` CHANGE `name` `name` varchar(64)
1322]]>
1323</sqlQuery>
1324</request>
1325<request result="ok" sqlfile="1.6.1.0">
1326<sqlQuery>
1327<![CDATA[
1328ALTER TABLE `kap_smarty_lazy_cache` CHANGE `cache_id` `cache_id` varchar(255) NOT NULL DEFAULT ''
1329]]>
1330</sqlQuery>
1331</request>
1332<request result="ok" sqlfile="1.6.1.0">
1333<sqlQuery>
1334<![CDATA[ TRUNCATE TABLE `kap_smarty_lazy_cache` ]]>
1335</sqlQuery>
1336</request>
1337<request result="ok" sqlfile="1.6.1.0">
1338<sqlQuery>
1339<![CDATA[
1340/* Advanced EU Compliance tables */ CREATE TABLE IF NOT EXISTS `kap_cms_role` ( `id_cms_role` int(11) unsigned NOT NULL AUTO_INCREMENT, `name` varchar(50) NOT NULL, `id_cms` int(11) unsigned NOT NULL, PRIMARY KEY (`id_cms_role`, `id_cms`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1341]]>
1342</sqlQuery>
1343</request>
1344<request result="ok" sqlfile="1.6.1.0">
1345<sqlQuery>
1346<![CDATA[
1347CREATE TABLE IF NOT EXISTS `kap_cms_role_lang` ( `id_cms_role` int(11) unsigned NOT NULL, `id_lang` int(11) unsigned NOT NULL, `id_shop` int(11) unsigned NOT NULL, `name` varchar(128) DEFAULT NULL, PRIMARY KEY (`id_cms_role`,`id_lang`, `id_shop`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8
1348]]>
1349</sqlQuery>
1350</request>
1351<request result="fail" sqlfile="1.6.1.0">
1352<sqlQuery>
1353<![CDATA[
1354ALTER TABLE `kap_order_invoice` ADD `company_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl`
1355]]>
1356</sqlQuery>
1357<sqlMsgError>
1358<![CDATA[ Duplicate column name 'company_address' ]]>
1359</sqlMsgError>
1360<sqlNumberError>
1361<![CDATA[ 1060 ]]>
1362</sqlNumberError>
1363</request>
1364<request result="fail" sqlfile="1.6.1.0">
1365<sqlQuery>
1366<![CDATA[
1367ALTER TABLE `kap_order_invoice` ADD `shop_address` TEXT DEFAULT NULL AFTER `total_wrapping_tax_incl`
1368]]>
1369</sqlQuery>
1370<sqlMsgError>
1371<![CDATA[ Duplicate column name 'shop_address' ]]>
1372</sqlMsgError>
1373<sqlNumberError>
1374<![CDATA[ 1060 ]]>
1375</sqlNumberError>
1376</request>
1377<request result="fail" sqlfile="1.6.1.0">
1378<sqlQuery>
1379<![CDATA[
1380ALTER TABLE `kap_order_invoice` ADD `invoice_address` TEXT DEFAULT NULL AFTER `shop_address`
1381]]>
1382</sqlQuery>
1383<sqlMsgError>
1384<![CDATA[ Duplicate column name 'invoice_address' ]]>
1385</sqlMsgError>
1386<sqlNumberError>
1387<![CDATA[ 1060 ]]>
1388</sqlNumberError>
1389</request>
1390<request result="fail" sqlfile="1.6.1.0">
1391<sqlQuery>
1392<![CDATA[
1393ALTER TABLE `kap_order_invoice` ADD `delivery_address` TEXT DEFAULT NULL AFTER `invoice_address`
1394]]>
1395</sqlQuery>
1396<sqlMsgError>
1397<![CDATA[ Duplicate column name 'delivery_address' ]]>
1398</sqlMsgError>
1399<sqlNumberError>
1400<![CDATA[ 1060 ]]>
1401</sqlNumberError>
1402</request>
1403<request result="fail" sqlfile="1.6.1.0">
1404<sqlQuery>
1405<![CDATA[
1406INSERT INTO `kap_hook` (`name`, `title`, `description`) VALUES ('displayInvoiceLegalFreeText', 'PDF Invoice - Legal Free Text', 'This hook allows you to modify the legal free text on PDF invoices')
1407]]>
1408</sqlQuery>
1409<sqlMsgError>
1410<![CDATA[
1411Duplicate entry 'displayInvoiceLegalFreeText' for key 'hook_name'
1412]]>
1413</sqlMsgError>
1414<sqlNumberError>
1415<![CDATA[ 1062 ]]>
1416</sqlNumberError>
1417</request>
1418<request result="ok" sqlfile="1.6.1.0">
1419<sqlQuery>
1420<![CDATA[
1421UPDATE `kap_hook` SET position = 0 WHERE name LIKE 'action%'
1422]]>
1423</sqlQuery>
1424</request>
1425<request result="ok" sqlfile="1.6.1.0">
1426<sqlQuery>
1427<![CDATA[
1428ALTER IGNORE TABLE `kap_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`)
1429]]>
1430</sqlQuery>
1431</request>
1432<request result="ok" sqlfile="1.6.1.0">
1433<sqlQuery>
1434<![CDATA[
1435INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_INVOICE_ADDR_RULES', '{"avoid":["vat_number","phone","phone_mobile"]}', NOW(), NOW())
1436]]>
1437</sqlQuery>
1438</request>
1439<request result="ok" sqlfile="1.6.1.0">
1440<sqlQuery>
1441<![CDATA[
1442INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_DELIVERY_ADDR_RULES', '{"avoid":["vat_number","phone","phone_mobile"]}', NOW(), NOW())
1443]]>
1444</sqlQuery>
1445</request>
1446<request result="fail" sqlfile="1.6.1.0">
1447<sqlQuery>
1448<![CDATA[
1449ALTER TABLE `kap_pack` ADD KEY `product_item` (`id_product_item`,`id_product_attribute_item`)
1450]]>
1451</sqlQuery>
1452<sqlMsgError>
1453<![CDATA[ Duplicate key name 'product_item' ]]>
1454</sqlMsgError>
1455<sqlNumberError>
1456<![CDATA[ 1061 ]]>
1457</sqlNumberError>
1458</request>
1459<request result="fail" sqlfile="1.6.1.0">
1460<sqlQuery>
1461<![CDATA[
1462ALTER TABLE `kap_supply_order_detail` DROP KEY `id_supply_order`, DROP KEY `id_product`, ADD KEY `id_supply_order` (`id_supply_order`, `id_product`)
1463]]>
1464</sqlQuery>
1465<sqlMsgError>
1466<![CDATA[
1467Can't DROP 'id_product'; check that column/key exists
1468]]>
1469</sqlMsgError>
1470<sqlNumberError>
1471<![CDATA[ 1091 ]]>
1472</sqlNumberError>
1473</request>
1474<request result="fail" sqlfile="1.6.1.0">
1475<sqlQuery>
1476<![CDATA[
1477ALTER TABLE `kap_carrier` ADD KEY `reference` (`id_reference`, `deleted`, `active`)
1478]]>
1479</sqlQuery>
1480<sqlMsgError>
1481<![CDATA[ Duplicate key name 'reference' ]]>
1482</sqlMsgError>
1483<sqlNumberError>
1484<![CDATA[ 1061 ]]>
1485</sqlNumberError>
1486</request>
1487<request result="ok" sqlfile="1.6.1.1">
1488<sqlQuery>
1489<![CDATA[ SET NAMES 'utf8' ]]>
1490</sqlQuery>
1491</request>
1492<request result="ok" sqlfile="1.6.1.1">
1493<sqlQuery>
1494<![CDATA[
1495ALTER TABLE `kap_customer_message` CHANGE `message` `message` MEDIUMTEXT NOT NULL
1496]]>
1497</sqlQuery>
1498</request>
1499<request result="ok" sqlfile="1.6.1.1">
1500<sqlQuery>
1501<![CDATA[
1502UPDATE `kap_tax_rules_group` SET `date_add` = NOW(), `date_upd` = NOW() WHERE `date_add` = '0000-00-00 00:00:00'
1503]]>
1504</sqlQuery>
1505</request>
1506<request result="fail" sqlfile="1.6.1.1">
1507<sqlQuery>
1508<![CDATA[
1509ALTER TABLE `kap_order_detail` ADD `original_wholesale_price` DECIMAL( 20, 6 ) NOT NULL DEFAULT '0.000000'
1510]]>
1511</sqlQuery>
1512<sqlMsgError>
1513<![CDATA[ Duplicate column name 'original_wholesale_price' ]]>
1514</sqlMsgError>
1515<sqlNumberError>
1516<![CDATA[ 1060 ]]>
1517</sqlNumberError>
1518</request>
1519<request result="ok" sqlfile="1.6.1.1">
1520<sqlQuery>
1521<![CDATA[
1522/* PHP:alter_ignore_drop_key(specific_price, id_product_2); */
1523]]>
1524</sqlQuery>
1525</request>
1526<request result="ok" sqlfile="1.6.1.1">
1527<sqlQuery>
1528<![CDATA[
1529ALTER TABLE `kap_specific_price` ADD UNIQUE KEY `id_product_2` (`id_cart`, `id_product`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`id_customer`,`id_product_attribute`,`from_quantity`,`id_specific_price_rule`,`from`,`to`)
1530]]>
1531</sqlQuery>
1532</request>
1533<request result="ok" sqlfile="1.6.1.2">
1534<sqlQuery>
1535<![CDATA[ SET NAMES 'utf8' ]]>
1536</sqlQuery>
1537</request>
1538<request result="ok" sqlfile="1.6.1.2">
1539<sqlQuery>
1540<![CDATA[
1541UPDATE `kap_image_shop` ish, `kap_image` i SET ish.id_product = i.id_product WHERE i.id_image=ish.id_image
1542]]>
1543</sqlQuery>
1544</request>
1545<request result="ok" sqlfile="1.6.1.2">
1546<sqlQuery>
1547<![CDATA[
1548REPLACE INTO `kap_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT cg.id_group, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `kap_product_tag` pt INNER JOIN `kap_product_shop` product_shop USING (id_product) JOIN (SELECT DISTINCT id_group FROM `kap_category_group`) cg WHERE product_shop.`active` = 1 AND EXISTS(SELECT 1 FROM `kap_category_product` cp LEFT JOIN `kap_category_group` cgo ON (cp.`id_category` = cgo.`id_category`) WHERE cgo.`id_group` = cg.id_group AND product_shop.`id_product` = cp.`id_product`) GROUP BY pt.id_tag, pt.id_lang, cg.id_group, id_shop ORDER BY NULL
1549]]>
1550</sqlQuery>
1551</request>
1552<request result="ok" sqlfile="1.6.1.2">
1553<sqlQuery>
1554<![CDATA[
1555REPLACE INTO `kap_tag_count` (id_group, id_tag, id_lang, id_shop, counter) SELECT 0, pt.id_tag, pt.id_lang, id_shop, COUNT(pt.id_tag) AS times FROM `kap_product_tag` pt INNER JOIN `kap_product_shop` product_shop USING (id_product) WHERE product_shop.`active` = 1 GROUP BY pt.id_tag, pt.id_lang, id_shop ORDER BY NULL
1556]]>
1557</sqlQuery>
1558</request>
1559<request result="ok" sqlfile="1.6.1.2">
1560<sqlQuery>
1561<![CDATA[ TRUNCATE TABLE `kap_smarty_last_flush` ]]>
1562</sqlQuery>
1563</request>
1564<request result="ok" sqlfile="1.6.1.2">
1565<sqlQuery>
1566<![CDATA[
1567ALTER TABLE `kap_search_index` ADD INDEX(`id_product`)
1568]]>
1569</sqlQuery>
1570</request>
1571<request result="ok" sqlfile="1.6.1.2">
1572<sqlQuery>
1573<![CDATA[
1574ALTER TABLE `kap_specific_price` ADD INDEX(`id_product_attribute`)
1575]]>
1576</sqlQuery>
1577</request>
1578<request result="ok" sqlfile="1.6.1.2">
1579<sqlQuery>
1580<![CDATA[
1581ALTER TABLE `kap_specific_price` ADD INDEX(`id_shop`)
1582]]>
1583</sqlQuery>
1584</request>
1585<request result="ok" sqlfile="1.6.1.2">
1586<sqlQuery>
1587<![CDATA[
1588ALTER TABLE `kap_specific_price` ADD INDEX(`id_customer`)
1589]]>
1590</sqlQuery>
1591</request>
1592<request result="ok" sqlfile="1.6.1.2">
1593<sqlQuery>
1594<![CDATA[ ALTER TABLE `kap_specific_price` ADD INDEX(`from`) ]]>
1595</sqlQuery>
1596</request>
1597<request result="ok" sqlfile="1.6.1.2">
1598<sqlQuery>
1599<![CDATA[ ALTER TABLE `kap_specific_price` ADD INDEX(`to`) ]]>
1600</sqlQuery>
1601</request>
1602<request result="ok" sqlfile="1.6.1.2">
1603<sqlQuery>
1604<![CDATA[
1605ALTER TABLE `kap_specific_price` DROP KEY `id_product_2`
1606]]>
1607</sqlQuery>
1608</request>
1609<request result="ok" sqlfile="1.6.1.2">
1610<sqlQuery>
1611<![CDATA[
1612ALTER TABLE `kap_specific_price` ADD UNIQUE KEY `id_product_2` (`id_product`,`id_product_attribute`,`id_customer`,`id_cart`,`from`,`to`,`id_shop`,`id_shop_group`,`id_currency`,`id_country`,`id_group`,`from_quantity`,`id_specific_price_rule`)
1613]]>
1614</sqlQuery>
1615</request>
1616<request result="ok" sqlfile="1.6.1.2">
1617<sqlQuery>
1618<![CDATA[
1619ALTER TABLE `kap_category_product` ADD INDEX(`id_category`, `position`)
1620]]>
1621</sqlQuery>
1622</request>
1623<request result="ok" sqlfile="1.6.1.2">
1624<sqlQuery>
1625<![CDATA[
1626ALTER TABLE `kap_address` CHANGE `company` `company` VARCHAR(64) NULL
1627]]>
1628</sqlQuery>
1629</request>
1630<request result="ok" sqlfile="1.6.1.5">
1631<sqlQuery>
1632<![CDATA[ SET NAMES 'utf8' ]]>
1633</sqlQuery>
1634</request>
1635<request result="ok" sqlfile="1.6.1.5">
1636<sqlQuery>
1637<![CDATA[
1638UPDATE `kap_configuration` c SET `value` = '{"avoid":[]}' WHERE `name` IN ('PS_INVCE_INVOICE_ADDR_RULES', 'PS_INVCE_DELIVERY_ADDR_RULES')
1639]]>
1640</sqlQuery>
1641</request>
1642<request result="ok" sqlfile="1.6.1.6">
1643<sqlQuery>
1644<![CDATA[ SET NAMES 'utf8' ]]>
1645</sqlQuery>
1646</request>
1647<request result="ok" sqlfile="1.6.1.6">
1648<sqlQuery>
1649<![CDATA[
1650ALTER TABLE `kap_cart_product` CHANGE `id_product_attribute` `id_product_attribute` int(10) unsigned NOT NULL DEFAULT '0'
1651]]>
1652</sqlQuery>
1653</request>
1654</action>