Last active
February 12, 2016 20:44
-
-
Save molotovbliss/c176f2140232a0ba556f to your computer and use it in GitHub Desktop.
Magento Enterprise 1.13.1.0 Triggers.sql (no definer)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
-- Magento Enterprise 1.13.1.0 Triggers.sql | |
-- mysqldump -u -p -n -d -t --skip-opt --no-create-info --triggers database | sed -e 's/DEFINER=[^*]*\*/\*/' > triggers.sql | |
-- MySQL dump 10.13 Distrib 5.5.38, for debian-linux-gnu (i686) | |
-- Server version 5.5.38-0ubuntu0.12.04.1 | |
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; | |
/*!40103 SET TIME_ZONE='+00:00' */; | |
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; | |
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; | |
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; | |
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_after_insert` AFTER INSERT ON `catalog_category_entity` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_category_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_product_cat_cl` (`category_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_after_update` AFTER UPDATE ON `catalog_category_entity` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_category_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_product_cat_cl` (`category_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_after_delete` AFTER DELETE ON `catalog_category_entity` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_category_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_product_cat_cl` (`category_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_datetime_after_insert` AFTER INSERT ON `catalog_category_entity_datetime` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_datetime_after_update` AFTER UPDATE ON `catalog_category_entity_datetime` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_datetime_after_delete` AFTER DELETE ON `catalog_category_entity_datetime` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_decimal_after_insert` AFTER INSERT ON `catalog_category_entity_decimal` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_decimal_after_update` AFTER UPDATE ON `catalog_category_entity_decimal` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_decimal_after_delete` AFTER DELETE ON `catalog_category_entity_decimal` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_int_after_insert` AFTER INSERT ON `catalog_category_entity_int` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_product_cat_cl` (`category_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_int_after_update` AFTER UPDATE ON `catalog_category_entity_int` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_product_cat_cl` (`category_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_int_after_delete` AFTER DELETE ON `catalog_category_entity_int` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_product_cat_cl` (`category_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_text_after_insert` AFTER INSERT ON `catalog_category_entity_text` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_text_after_update` AFTER UPDATE ON `catalog_category_entity_text` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_text_after_delete` AFTER DELETE ON `catalog_category_entity_text` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_url_key_after_insert` AFTER INSERT ON `catalog_category_entity_url_key` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_category_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_url_key_after_update` AFTER UPDATE ON `catalog_category_entity_url_key` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_category_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_url_key_after_delete` AFTER DELETE ON `catalog_category_entity_url_key` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_category_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_varchar_after_insert` AFTER INSERT ON `catalog_category_entity_varchar` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_varchar_after_update` AFTER UPDATE ON `catalog_category_entity_varchar` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_entity_varchar_after_delete` AFTER DELETE ON `catalog_category_entity_varchar` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_product_after_insert` AFTER INSERT ON `catalog_category_product` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_product_index_cl` (`product_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_product_after_update` AFTER UPDATE ON `catalog_category_product` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_product_index_cl` (`product_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_category_product_after_delete` AFTER DELETE ON `catalog_category_product` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_category_product_index_cl` (`product_id`) VALUES (OLD.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_eav_attribute_after_insert` AFTER INSERT ON `catalog_eav_attribute` FOR EACH ROW BEGIN | |
CASE (NEW.is_searchable = 1) OR (NEW.is_visible_in_advanced_search = 1) OR (NEW.is_filterable > 0) OR (NEW.is_filterable_in_search = 1) OR (NEW.used_for_sort_by = 1) OR (NEW.is_used_for_promo_rules = 1) OR (NEW.used_in_product_listing = 1) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '5'); END; ELSE BEGIN END; END CASE; | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_eav_attribute_after_update` AFTER UPDATE ON `catalog_eav_attribute` FOR EACH ROW BEGIN | |
CASE (NEW.is_searchable IS NOT NULL AND NEW.is_searchable != OLD.is_searchable) OR (NEW.is_visible_in_advanced_search IS NOT NULL | |
AND | |
NEW.is_visible_in_advanced_search != OLD.is_visible_in_advanced_search) OR (NEW.is_filterable IS NOT NULL AND NEW.is_filterable != OLD.is_filterable) OR (NEW.is_filterable_in_search IS NOT NULL | |
AND | |
NEW.is_filterable_in_search != OLD.is_filterable_in_search) OR (NEW.used_for_sort_by IS NOT NULL AND NEW.used_for_sort_by != OLD.used_for_sort_by) OR (NEW.is_used_for_promo_rules IS NOT NULL | |
AND NEW.is_used_for_promo_rules != OLD.is_used_for_promo_rules) OR (NEW.used_in_product_listing IS NOT NULL | |
AND NEW.used_in_product_listing != OLD.used_in_product_listing) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '12'); END; ELSE BEGIN END; END CASE; | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_eav_attribute_after_delete` AFTER DELETE ON `catalog_eav_attribute` FOR EACH ROW BEGIN | |
CASE (OLD.is_searchable = 1) OR (OLD.is_visible_in_advanced_search = 1) OR (OLD.is_filterable > 0) OR (OLD.is_filterable_in_search = 1) OR (OLD.used_for_sort_by = 1) OR (OLD.is_used_for_promo_rules = 1) OR (OLD.used_in_product_listing = 1) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '10'); END; ELSE BEGIN END; END CASE; | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_bundle_selection_after_insert` AFTER INSERT ON `catalog_product_bundle_selection` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`parent_product_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`parent_product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_bundle_selection_after_update` AFTER UPDATE ON `catalog_product_bundle_selection` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`parent_product_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`parent_product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_bundle_selection_after_delete` AFTER DELETE ON `catalog_product_bundle_selection` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (OLD.`parent_product_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`parent_product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_after_insert` AFTER INSERT ON `catalog_product_entity` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_after_update` AFTER UPDATE ON `catalog_product_entity` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_after_delete` AFTER DELETE ON `catalog_product_entity` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_datetime_after_insert` AFTER INSERT ON `catalog_product_entity_datetime` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_datetime_after_update` AFTER UPDATE ON `catalog_product_entity_datetime` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_datetime_after_delete` AFTER DELETE ON `catalog_product_entity_datetime` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_decimal_after_insert` AFTER INSERT ON `catalog_product_entity_decimal` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_decimal_after_update` AFTER UPDATE ON `catalog_product_entity_decimal` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_decimal_after_delete` AFTER DELETE ON `catalog_product_entity_decimal` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_int_after_insert` AFTER INSERT ON `catalog_product_entity_int` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_product_index_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_int_after_update` AFTER UPDATE ON `catalog_product_entity_int` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_product_index_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_int_after_delete` AFTER DELETE ON `catalog_product_entity_int` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_category_product_index_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_text_after_insert` AFTER INSERT ON `catalog_product_entity_text` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_text_after_update` AFTER UPDATE ON `catalog_product_entity_text` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_text_after_delete` AFTER DELETE ON `catalog_product_entity_text` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_url_key_after_insert` AFTER INSERT ON `catalog_product_entity_url_key` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_url_key_after_update` AFTER UPDATE ON `catalog_product_entity_url_key` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_url_key_after_delete` AFTER DELETE ON `catalog_product_entity_url_key` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_product_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_varchar_after_insert` AFTER INSERT ON `catalog_product_entity_varchar` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_varchar_after_update` AFTER UPDATE ON `catalog_product_entity_varchar` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_entity_varchar_after_delete` AFTER DELETE ON `catalog_product_entity_varchar` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`entity_id`); | |
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_link_after_insert` AFTER INSERT ON `catalog_product_link` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`product_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_link_after_update` AFTER UPDATE ON `catalog_product_link` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`product_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_link_after_delete` AFTER DELETE ON `catalog_product_link` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (OLD.`product_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_super_link_after_insert` AFTER INSERT ON `catalog_product_super_link` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`parent_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`parent_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_super_link_after_update` AFTER UPDATE ON `catalog_product_super_link` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`parent_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (NEW.`parent_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_super_link_after_delete` AFTER DELETE ON `catalog_product_super_link` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (OLD.`parent_id`); | |
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`product_id`) VALUES (OLD.`parent_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_website_after_insert` AFTER INSERT ON `catalog_product_website` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`product_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_website_after_update` AFTER UPDATE ON `catalog_product_website` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`product_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalog_product_website_after_delete` AFTER DELETE ON `catalog_product_website` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (OLD.`product_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (OLD.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_cataloginventory_stock_item_after_insert` AFTER INSERT ON `cataloginventory_stock_item` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`product_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_cataloginventory_stock_item_after_update` AFTER UPDATE ON `cataloginventory_stock_item` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (NEW.`product_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_cataloginventory_stock_item_after_delete` AFTER DELETE ON `cataloginventory_stock_item` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `cataloginventory_stock_status_cl` (`product_id`) VALUES (OLD.`product_id`); | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (OLD.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalogrule_product_price_after_insert` AFTER INSERT ON `catalogrule_product_price` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalogrule_product_price_after_update` AFTER UPDATE ON `catalogrule_product_price` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (NEW.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_catalogrule_product_price_after_delete` AFTER DELETE ON `catalogrule_product_price` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `catalog_product_index_price_cl` (`entity_id`) VALUES (OLD.`product_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_config_data_after_insert` AFTER INSERT ON `core_config_data` FOR EACH ROW BEGIN | |
CASE (NEW.path = 'catalog/price/scope') WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '13'); END; ELSE BEGIN END; END CASE; | |
CASE (NEW.path = 'cataloginventory/options/show_out_of_stock') OR (NEW.path = 'cataloginventory/item_options/manage_stock') WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '14'); END; ELSE BEGIN END; END CASE; | |
CASE (NEW.path = 'catalog/frontend/flat_catalog_product') AND (NEW.value = 1) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '15'); END; ELSE BEGIN END; END CASE; | |
CASE (NEW.path = 'catalog/frontend/flat_catalog_category') AND (NEW.value = 1) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '16'); END; ELSE BEGIN END; END CASE; | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_config_data_after_update` AFTER UPDATE ON `core_config_data` FOR EACH ROW BEGIN | |
CASE ((NEW.path = 'catalog/price/scope') AND (NEW.value != OLD.value)) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '13'); END; ELSE BEGIN END; END CASE; | |
CASE ((NEW.path = 'cataloginventory/options/show_out_of_stock') AND (NEW.value != OLD.value)) OR ((NEW.path = 'cataloginventory/item_options/manage_stock') AND (NEW.value != OLD.value)) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '14'); END; ELSE BEGIN END; END CASE; | |
CASE (NEW.path = 'catalog/frontend/flat_catalog_product') AND (NEW.value != OLD.value) AND (NEW.value = 1) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '15'); END; ELSE BEGIN END; END CASE; | |
CASE (NEW.path = 'catalog/frontend/flat_catalog_category') AND (NEW.value != OLD.value) AND (NEW.value = 1) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '16'); END; ELSE BEGIN END; END CASE; | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_config_data_after_delete` AFTER DELETE ON `core_config_data` FOR EACH ROW BEGIN | |
CASE (OLD.path = 'catalog/price/scope') WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '13'); END; ELSE BEGIN END; END CASE; | |
CASE (OLD.path = 'cataloginventory/options/show_out_of_stock') OR (OLD.path = 'cataloginventory/item_options/manage_stock') WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '14'); END; ELSE BEGIN END; END CASE; | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_store_after_insert` AFTER INSERT ON `core_store` FOR EACH ROW BEGIN | |
UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '2'); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_store_after_delete` AFTER DELETE ON `core_store` FOR EACH ROW BEGIN | |
UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '8'); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_store_group_after_insert` AFTER INSERT ON `core_store_group` FOR EACH ROW BEGIN | |
UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '3'); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_store_group_after_update` AFTER UPDATE ON `core_store_group` FOR EACH ROW BEGIN | |
CASE (OLD.root_category_id != NEW.root_category_id) WHEN TRUE THEN BEGIN UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '4'); END; ELSE BEGIN END; END CASE; | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_store_group_after_delete` AFTER DELETE ON `core_store_group` FOR EACH ROW BEGIN | |
UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '9'); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_core_website_after_delete` AFTER DELETE ON `core_website` FOR EACH ROW BEGIN | |
UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '7'); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_customer_group_after_insert` AFTER INSERT ON `customer_group` FOR EACH ROW BEGIN | |
UPDATE `enterprise_mview_metadata` AS `mm` | |
INNER JOIN `enterprise_mview_metadata_event` AS `me` ON mm.metadata_id = me.metadata_id | |
SET `mm`.`status` = 2 | |
WHERE (mview_event_id = '6'); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_enterprise_url_rewrite_redirect_after_insert` AFTER INSERT ON `enterprise_url_rewrite_redirect` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_redirect_cl` (`redirect_id`) VALUES (NEW.`redirect_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_enterprise_url_rewrite_redirect_after_update` AFTER UPDATE ON `enterprise_url_rewrite_redirect` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_redirect_cl` (`redirect_id`) VALUES (NEW.`redirect_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!50003 SET @saved_cs_client = @@character_set_client */ ; | |
/*!50003 SET @saved_cs_results = @@character_set_results */ ; | |
/*!50003 SET @saved_col_connection = @@collation_connection */ ; | |
/*!50003 SET character_set_client = utf8 */ ; | |
/*!50003 SET character_set_results = utf8 */ ; | |
/*!50003 SET collation_connection = utf8_general_ci */ ; | |
/*!50003 SET @saved_sql_mode = @@sql_mode */ ; | |
/*!50003 SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO' */ ; | |
DELIMITER ;; | |
/*!50003 CREATE*/ /*!50017 */ /*!50003 TRIGGER `trg_enterprise_url_rewrite_redirect_after_delete` AFTER DELETE ON `enterprise_url_rewrite_redirect` FOR EACH ROW BEGIN | |
INSERT IGNORE INTO `enterprise_url_rewrite_redirect_cl` (`redirect_id`) VALUES (OLD.`redirect_id`); | |
END */;; | |
DELIMITER ; | |
/*!50003 SET sql_mode = @saved_sql_mode */ ; | |
/*!50003 SET character_set_client = @saved_cs_client */ ; | |
/*!50003 SET character_set_results = @saved_cs_results */ ; | |
/*!50003 SET collation_connection = @saved_col_connection */ ; | |
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; | |
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; | |
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; | |
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; | |
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Latest 1.14.2.3 triggers: https://gist.github.com/molotovbliss/00dd00941126dcd7891d