38 lines
2.0 KiB
SQL
38 lines
2.0 KiB
SQL
SET NAMES 'utf8';
|
|
|
|
UPDATE `PREFIX_image_shop` ish, `PREFIX_image` i SET ish.id_product = i.id_product WHERE i.id_image=ish.id_image;
|
|
|
|
REPLACE INTO `PREFIX_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 `PREFIX_product_tag` pt
|
|
INNER JOIN `PREFIX_product_shop` product_shop
|
|
USING (id_product)
|
|
JOIN (SELECT DISTINCT id_group FROM `PREFIX_category_group`) cg
|
|
WHERE product_shop.`active` = 1
|
|
AND EXISTS(SELECT 1 FROM `PREFIX_category_product` cp
|
|
LEFT JOIN `PREFIX_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;
|
|
REPLACE INTO `PREFIX_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 `PREFIX_product_tag` pt
|
|
INNER JOIN `PREFIX_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;
|
|
|
|
TRUNCATE TABLE `PREFIX_smarty_last_flush`;
|
|
|
|
ALTER TABLE `PREFIX_search_index` ADD INDEX(`id_product`);
|
|
ALTER TABLE `PREFIX_specific_price` ADD INDEX(`id_product_attribute`);
|
|
ALTER TABLE `PREFIX_specific_price` ADD INDEX(`id_shop`);
|
|
ALTER TABLE `PREFIX_specific_price` ADD INDEX(`id_customer`);
|
|
ALTER TABLE `PREFIX_specific_price` ADD INDEX(`from`);
|
|
ALTER TABLE `PREFIX_specific_price` ADD INDEX(`to`);
|
|
ALTER TABLE `PREFIX_specific_price` DROP KEY `id_product_2`;
|
|
ALTER TABLE `PREFIX_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`);
|
|
ALTER TABLE `PREFIX_category_product` ADD INDEX(`id_category`, `position`);
|
|
|
|
|
|
ALTER TABLE `PREFIX_address` CHANGE `company` `company` VARCHAR(64) NULL;
|