API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 23rd, 2016
171
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 53.67 KB | None | 0 0
raw download clone embed print report
  1. This 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[
  11. INSERT 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[
  16. Duplicate 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[
  26. INSERT 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[
  33. UPDATE `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[
  45. CREATE 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[
  58. INSERT 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[
  65. ALTER 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[
  72. ALTER 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[
  79. ALTER 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[
  86. INSERT 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[
  93. ALTER 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[
  106. ALTER 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[
  119. CREATE 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[
  126. ALTER 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[
  139. UPDATE `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[
  146. ALTER 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[
  159. CREATE 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[
  166. INSERT 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[
  173. ALTER 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[
  186. UPDATE `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[
  198. UPDATE `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[
  210. INSERT 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[
  222. SET @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[
  229. INSERT 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[
  236. INSERT 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[
  243. ALTER 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[
  256. ALTER 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[
  269. ALTER 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[
  282. INSERT 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[
  287. Duplicate 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[
  297. ALTER 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[
  310. ALTER 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[
  317. ALTER 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[
  329. INSERT 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[
  343. ALTER 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[
  350. ALTER 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[
  357. ALTER 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[
  364. ALTER 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[
  371. ALTER 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[
  389. INSERT 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[
  396. INSERT 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[
  408. INSERT 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[
  415. INSERT 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[
  422. UPDATE `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[
  429. ALTER 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[
  442. ALTER 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[
  455. ALTER 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[
  478. ALTER 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[
  485. ALTER 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[
  498. ALTER 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[
  511. ALTER 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[
  523. ALTER 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[
  530. ALTER 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[
  543. ALTER 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[
  550. ALTER 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[
  563. ALTER 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[
  570. CREATE 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[
  588. ALTER 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[
  601. ALTER 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[
  613. ALTER 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[
  620. ALTER 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[
  627. ALTER 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[
  634. ALTER 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[
  641. ALTER 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[
  653. UPDATE `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[
  660. UPDATE `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[
  667. ALTER 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[
  681. ALTER 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[
  694. ALTER 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[
  707. UPDATE 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[
  719. CREATE 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[
  726. REPLACE 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[
  729. INNER 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[
  736. REPLACE 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[
  778. ALTER 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[
  796. ALTER 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[
  808. ALTER 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[
  815. ALTER 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[
  822. ALTER 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[
  835. ALTER 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[
  848. ALTER 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[
  861. ALTER 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[
  868. ALTER 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[
  875. ALTER 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[
  893. ALTER 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[
  906. ALTER TABLE `kap_category` DROP KEY nleftright, DROP KEY nleft
  907. ]]>
  908. </sqlQuery>
  909. <sqlMsgError>
  910. <![CDATA[
  911. Can'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[
  921. ALTER 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[
  934. ALTER IGNORE TABLE `kap_image_shop` DROP KEY `id_image`, ADD PRIMARY KEY (`id_image`, `id_shop`, `cover`)
  935. ]]>
  936. </sqlQuery>
  937. <sqlMsgError>
  938. <![CDATA[
  939. Can'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[
  949. ALTER 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[
  962. UPDATE 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[
  969. ALTER 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[
  982. UPDATE 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[
  989. ALTER 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[
  996. ALTER 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[
  1009. ALTER 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[
  1016. ALTER 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[
  1028. CREATE 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[
  1040. CREATE 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[
  1052. CREATE 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[
  1059. ALTER 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[
  1066. UPDATE `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[
  1073. CREATE TEMPORARY TABLE `image_transform` SELECT `id_product`, COUNT(*) c FROM `kap_image` WHERE `cover`=1 GROUP BY `id_product` HAVING c&gt;1
  1074. ]]>
  1075. </sqlQuery>
  1076. </request>
  1077. <request result="ok" sqlfile="1.6.1.0">
  1078. <sqlQuery>
  1079. <![CDATA[
  1080. UPDATE `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[
  1087. ALTER 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[
  1094. ALTER 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[
  1101. ALTER 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[
  1108. UPDATE `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[
  1115. CREATE 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&gt;1
  1116. ]]>
  1117. </sqlQuery>
  1118. </request>
  1119. <request result="ok" sqlfile="1.6.1.0">
  1120. <sqlQuery>
  1121. <![CDATA[
  1122. UPDATE `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[
  1134. ALTER 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[
  1141. ALTER 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[
  1148. UPDATE `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[
  1155. CREATE TEMPORARY TABLE `attribute_transform` SELECT `id_product`, COUNT(*) c FROM `kap_product_attribute` WHERE `default_on`=1 GROUP BY `id_product` HAVING c&gt;1
  1156. ]]>
  1157. </sqlQuery>
  1158. </request>
  1159. <request result="ok" sqlfile="1.6.1.0">
  1160. <sqlQuery>
  1161. <![CDATA[
  1162. UPDATE `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[
  1169. ALTER 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[
  1176. ALTER 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[
  1183. ALTER 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[
  1190. UPDATE `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[
  1197. CREATE 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&gt;1
  1198. ]]>
  1199. </sqlQuery>
  1200. </request>
  1201. <request result="ok" sqlfile="1.6.1.0">
  1202. <sqlQuery>
  1203. <![CDATA[
  1204. UPDATE `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[
  1211. ALTER 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[
  1218. ALTER 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[
  1225. ALTER 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[
  1243. ALTER 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[
  1255. ALTER 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[
  1268. ALTER 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[
  1281. UPDATE `kap_product_shop` SET `date_add` = NOW() WHERE `date_add` = &quot;0000-00-00 00:00:00&quot;
  1282. ]]>
  1283. </sqlQuery>
  1284. </request>
  1285. <request result="ok" sqlfile="1.6.1.0">
  1286. <sqlQuery>
  1287. <![CDATA[
  1288. INSERT 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[
  1295. ALTER 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[
  1308. ALTER 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[
  1321. ALTER 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[
  1328. ALTER 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[
  1347. CREATE 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[
  1354. ALTER 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[
  1367. ALTER 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[
  1380. ALTER 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[
  1393. ALTER 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[
  1406. INSERT 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[
  1411. Duplicate 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[
  1421. UPDATE `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[
  1428. ALTER 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[
  1435. INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_INVOICE_ADDR_RULES', '{&quot;avoid&quot;:[&quot;vat_number&quot;,&quot;phone&quot;,&quot;phone_mobile&quot;]}', NOW(), NOW())
  1436. ]]>
  1437. </sqlQuery>
  1438. </request>
  1439. <request result="ok" sqlfile="1.6.1.0">
  1440. <sqlQuery>
  1441. <![CDATA[
  1442. INSERT INTO `kap_configuration` (`name`, `value`, `date_add`, `date_upd`) VALUES ('PS_INVCE_DELIVERY_ADDR_RULES', '{&quot;avoid&quot;:[&quot;vat_number&quot;,&quot;phone&quot;,&quot;phone_mobile&quot;]}', NOW(), NOW())
  1443. ]]>
  1444. </sqlQuery>
  1445. </request>
  1446. <request result="fail" sqlfile="1.6.1.0">
  1447. <sqlQuery>
  1448. <![CDATA[
  1449. ALTER 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[
  1462. ALTER 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[
  1467. Can'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[
  1477. ALTER 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[
  1495. ALTER 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[
  1502. UPDATE `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[
  1509. ALTER 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[
  1529. ALTER 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[
  1541. UPDATE `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[
  1548. REPLACE 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[
  1555. REPLACE 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[
  1567. ALTER 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[
  1574. ALTER 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[
  1581. ALTER 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[
  1588. ALTER 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[
  1605. ALTER 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[
  1612. ALTER 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[
  1619. ALTER 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[
  1626. ALTER 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[
  1638. UPDATE `kap_configuration` c SET `value` = '{&quot;avoid&quot;:[]}' 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[
  1650. ALTER 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!