-- Dumping data for table `catalog_product_bundle_option`
--


--
-- Table structure for table `catalog_product_bundle_option_value`
--

CREATE TABLE `catalog_product_bundle_option_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CAT_PRD_BNDL_OPT_VAL_OPT_ID_PARENT_PRD_ID_STORE_ID` (`option_id`,`parent_product_id`,`store_id`),
  CONSTRAINT `CAT_PRD_BNDL_OPT_VAL_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Option Value';

--
-- Dumping data for table `catalog_product_bundle_option_value`
--


--
-- Table structure for table `catalog_product_bundle_price_index`
--

CREATE TABLE `catalog_product_bundle_price_index` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  `min_price` decimal(20,6) NOT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) NOT NULL COMMENT 'Max Price',
  PRIMARY KEY (`entity_id`,`website_id`,`customer_group_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_WEBSITE_ID` (`website_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_PRICE_INDEX_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `CAT_PRD_BNDL_PRICE_IDX_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_BNDL_PRICE_IDX_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_BNDL_PRICE_IDX_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Price Index';

--
-- Dumping data for table `catalog_product_bundle_price_index`
--


--
-- Table structure for table `catalog_product_bundle_selection`
--

CREATE TABLE `catalog_product_bundle_selection` (
  `selection_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Selection ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `position` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Position',
  `is_default` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Default',
  `selection_price_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Selection Price Type',
  `selection_price_value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Selection Price Value',
  `selection_qty` decimal(12,4) DEFAULT NULL COMMENT 'Selection Qty',
  `selection_can_change_qty` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Selection Can Change Qty',
  PRIMARY KEY (`selection_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_OPTION_ID` (`option_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_PRODUCT_ID` (`product_id`),
  CONSTRAINT `CAT_PRD_BNDL_SELECTION_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_BNDL_SELECTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Selection';

--
-- Dumping data for table `catalog_product_bundle_selection`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_bundle_selection_after_insert AFTER INSERT ON catalog_product_bundle_selection FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`parent_product_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_bundle_selection_after_update AFTER UPDATE ON catalog_product_bundle_selection FOR EACH ROW
BEGIN
IF (NOT(NEW.`selection_id` <=> OLD.`selection_id`) OR NOT(NEW.`option_id` <=> OLD.`option_id`) OR NOT(NEW.`parent_product_id` <=> OLD.`parent_product_id`) OR NOT(NEW.`product_id` <=> OLD.`product_id`) OR NOT(NEW.`position` <=> OLD.`position`) OR NOT(NEW.`is_default` <=> OLD.`is_default`) OR NOT(NEW.`selection_price_type` <=> OLD.`selection_price_type`) OR NOT(NEW.`selection_price_value` <=> OLD.`selection_price_value`) OR NOT(NEW.`selection_qty` <=> OLD.`selection_qty`) OR NOT(NEW.`selection_can_change_qty` <=> OLD.`selection_can_change_qty`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`parent_product_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_bundle_selection_after_delete AFTER DELETE ON catalog_product_bundle_selection FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`parent_product_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_bundle_selection_price`
--

CREATE TABLE `catalog_product_bundle_selection_price` (
  `selection_id` int(10) unsigned NOT NULL COMMENT 'Selection ID',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `selection_price_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Selection Price Type',
  `selection_price_value` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Selection Price Value',
  PRIMARY KEY (`selection_id`,`parent_product_id`,`website_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_SELECTION_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CAT_PRD_BNDL_SELECTION_PRICE_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DCF37523AA05D770A70AA4ED7C2616E4` FOREIGN KEY (`selection_id`) REFERENCES `catalog_product_bundle_selection` (`selection_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Selection Price';

--
-- Dumping data for table `catalog_product_bundle_selection_price`
--


--
-- Table structure for table `catalog_product_bundle_stock_index`
--

CREATE TABLE `catalog_product_bundle_stock_index` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `stock_id` smallint(5) unsigned NOT NULL COMMENT 'Stock ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `stock_status` smallint(6) DEFAULT '0' COMMENT 'Stock Status',
  PRIMARY KEY (`entity_id`,`website_id`,`stock_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Stock Index';

--
-- Dumping data for table `catalog_product_bundle_stock_index`
--


--
-- Table structure for table `catalog_product_category_cl`
--

CREATE TABLE `catalog_product_category_cl` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=297 DEFAULT CHARSET=utf8 COMMENT='catalog_product_category_cl';

--
-- Dumping data for table `catalog_product_category_cl`
--

INSERT INTO `catalog_product_category_cl` VALUES (1,147),(2,147),(3,147),(4,147),(5,147),(6,147),(7,147),(8,147),(9,147),(10,148),(11,148),(12,148),(13,148),(14,148),(15,148),(16,148),(17,148),(18,148),(19,148),(20,148),(21,149),(22,149),(23,149),(24,149),(25,149),(26,149),(27,149),(28,149),(29,149),(30,149),(31,149),(32,150),(33,150),(34,150),(35,150),(36,150),(37,150),(38,150),(39,150),(40,150),(41,150),(42,150),(43,151),(44,151),(45,151),(46,151),(47,151),(48,151),(49,151),(50,151),(51,151),(52,151),(53,151),(54,152),(55,152),(56,152),(57,152),(58,152),(59,152),(60,152),(61,152),(62,152),(63,152),(64,152),(65,153),(66,153),(67,153),(68,153),(69,153),(70,153),(71,153),(72,153),(73,153),(74,153),(75,153),(76,154),(77,154),(78,154),(79,154),(80,154),(81,154),(82,154),(83,154),(84,154),(85,154),(86,154),(87,155),(88,155),(89,155),(90,155),(91,155),(92,155),(93,155),(94,155),(95,155),(96,155),(97,155),(98,156),(99,156),(100,156),(101,156),(102,156),(103,156),(104,156),(105,156),(106,156),(107,156),(108,156),(109,157),(110,157),(111,157),(112,157),(113,157),(114,157),(115,157),(116,157),(117,157),(118,157),(119,157),(120,158),(121,158),(122,158),(123,158),(124,158),(125,158),(126,158),(127,158),(128,158),(129,158),(130,158),(131,159),(132,159),(133,159),(134,159),(135,159),(136,159),(137,159),(138,159),(139,159),(140,160),(141,160),(142,160),(143,160),(144,160),(145,160),(146,160),(147,160),(148,160),(149,160),(150,160),(151,161),(152,161),(153,161),(154,161),(155,161),(156,161),(157,161),(158,161),(159,161),(160,161),(161,161),(162,162),(163,162),(164,162),(165,162),(166,162),(167,162),(168,162),(169,162),(170,162),(171,162),(172,162),(173,163),(174,163),(175,163),(176,163),(177,163),(178,163),(179,163),(180,163),(181,163),(182,164),(183,164),(184,164),(185,164),(186,164),(187,164),(188,164),(189,164),(190,164),(191,164),(192,165),(193,165),(194,165),(195,165),(196,165),(197,165),(198,165),(199,165),(200,165),(201,165),(202,166),(203,166),(204,166),(205,166),(206,166),(207,166),(208,166),(209,166),(210,166),(211,166),(212,167),(213,167),(214,167),(215,167),(216,167),(217,167),(218,167),(219,167),(220,167),(221,168),(222,168),(223,168),(224,168),(225,168),(226,168),(227,168),(228,168),(229,168),(230,168),(231,169),(232,169),(233,169),(234,169),(235,169),(236,169),(237,169),(238,169),(239,169),(240,169),(241,170),(242,170),(243,170),(244,170),(245,170),(246,170),(247,170),(248,170),(249,170),(250,170),(251,171),(252,171),(253,171),(254,171),(255,171),(256,171),(257,171),(258,171),(259,171),(260,152),(261,167),(262,163),(263,159),(264,171),(265,172),(266,172),(267,172),(268,172),(269,172),(270,172),(271,172),(272,172),(273,173),(274,173),(275,173),(276,173),(277,173),(278,173),(279,173),(280,173),(281,174),(282,174),(283,174),(284,174),(285,174),(286,174),(287,174),(288,174),(289,175),(290,175),(291,175),(292,175),(293,175),(294,175),(295,175),(296,175);

--
-- Table structure for table `catalog_product_entity`
--

CREATE TABLE `catalog_product_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type ID',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Has Options',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Required Options',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_ENTITY_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_ENTITY_SKU` (`sku`)
) ENGINE=InnoDB AUTO_INCREMENT=176 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Table';

--
-- Dumping data for table `catalog_product_entity`
--

INSERT INTO `catalog_product_entity` VALUES (147,4,'configurable','Birthdaycakepackage',1,1,'2021-08-22 20:25:23','2021-12-11 11:07:36'),(148,4,'simple','Birthdaycakepackage-vanilla-white',0,0,'2021-08-22 20:26:53','2021-08-24 21:03:55'),(149,4,'simple','Birthdaycakepackage-vanilla-pink',0,0,'2021-08-22 20:26:53','2021-08-24 21:04:17'),(150,4,'simple','Birthdaycakepackage-chocolate -white',0,0,'2021-08-22 20:26:53','2021-08-24 21:04:17'),(151,4,'simple','Birthdaycakepackage-chocolate -pink',0,0,'2021-08-22 20:26:54','2021-08-24 21:04:17'),(152,4,'simple','Bridalshowerpackage',0,0,'2021-08-23 07:28:13','2021-08-26 08:01:40'),(153,4,'simple','All White-Medium (30 cm diameter)',0,0,'2021-08-23 07:56:42','2021-08-24 21:04:17'),(154,4,'simple','All White-Large (50 cm diameter)',0,0,'2021-08-23 07:56:42','2021-08-24 21:04:17'),(155,4,'simple','Pink hues-Medium (30 cm diameter)',0,0,'2021-08-23 07:56:42','2021-08-24 21:04:17'),(156,4,'simple','Pink hues-Large (50 cm diameter)',0,0,'2021-08-23 07:56:43','2021-08-24 21:04:17'),(157,4,'simple','Special of the day (mix)-Medium (30 cm diameter)',0,0,'2021-08-23 07:56:43','2021-08-24 21:04:17'),(158,4,'simple','Special of the day (mix)-Large (50 cm diameter)',0,0,'2021-08-23 07:56:43','2021-08-24 21:04:17'),(159,4,'configurable','Handtiebouquetinbag',1,1,'2021-08-23 07:56:43','2021-08-26 08:01:30'),(160,4,'simple','Handtiebouquetinvase-All White-Medium (30 cm diameter)',0,0,'2021-08-23 08:08:38','2021-08-24 21:04:17'),(161,4,'simple','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',0,0,'2021-08-23 08:08:39','2021-08-24 21:04:17'),(162,4,'simple','invase-Special of the day (mix)-Medium (30 cm diameter)',0,0,'2021-08-23 08:08:39','2021-08-24 21:04:17'),(163,4,'configurable','Handtiebouquetinvase',1,1,'2021-08-23 08:08:39','2021-08-26 08:01:20'),(164,4,'simple','Flower arrangement in vase-All White',0,0,'2021-08-23 08:17:53','2021-08-24 21:04:17'),(165,4,'simple','Flower arrangement in vase-Pink hues',0,0,'2021-08-23 08:17:54','2021-08-24 21:04:17'),(166,4,'simple','Flower arrangement in vase-Special of the day (mix)',0,0,'2021-08-23 08:17:54','2021-08-24 21:04:17'),(167,4,'configurable','Flower arrangement in vase',1,1,'2021-08-23 08:17:54','2021-08-26 08:00:43'),(168,4,'simple','pa2 plants with 1 small green plant',0,0,'2021-08-23 08:25:03','2021-08-24 21:04:17'),(169,4,'simple','pa3 plants with 2 small green plants',0,0,'2021-08-23 08:25:04','2021-08-24 21:04:17'),(170,4,'simple','pa4 plants with 2 small green plants',0,0,'2021-08-23 08:25:04','2021-08-24 21:04:17'),(171,4,'configurable','Phalaenopsisplantarrangementinvase',1,1,'2021-08-23 08:25:04','2021-08-24 20:07:31'),(172,4,'virtual','Birthdaycakepackage-Pink hues-2 plants with 1 small green plant',0,0,'2021-12-10 11:12:39','2021-12-10 11:12:39'),(173,4,'virtual','Birthdaycakepackage-Pink hues-3 plants with 2 small green plants',0,0,'2021-12-10 11:12:40','2021-12-10 11:12:40'),(174,4,'virtual','Birthdaycakepackage-All White-2 plants with 1 small green plant',0,0,'2021-12-10 11:12:40','2021-12-10 11:12:40'),(175,4,'virtual','Birthdaycakepackage-All White-3 plants with 2 small green plants',0,0,'2021-12-10 11:12:40','2021-12-10 11:12:40');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_after_insert AFTER INSERT ON catalog_product_entity FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_after_update AFTER UPDATE ON catalog_product_entity FOR EACH ROW
BEGIN
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`type_id` <=> OLD.`type_id`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`has_options` <=> OLD.`has_options`) OR NOT(NEW.`required_options` <=> OLD.`required_options`) OR NOT(NEW.`created_at` <=> OLD.`created_at`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`type_id` <=> OLD.`type_id`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`has_options` <=> OLD.`has_options`) OR NOT(NEW.`required_options` <=> OLD.`required_options`) OR NOT(NEW.`created_at` <=> OLD.`created_at`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`type_id` <=> OLD.`type_id`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`has_options` <=> OLD.`has_options`) OR NOT(NEW.`required_options` <=> OLD.`required_options`) OR NOT(NEW.`created_at` <=> OLD.`created_at`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`type_id` <=> OLD.`type_id`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`has_options` <=> OLD.`has_options`) OR NOT(NEW.`required_options` <=> OLD.`required_options`) OR NOT(NEW.`created_at` <=> OLD.`created_at`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_after_delete AFTER DELETE ON catalog_product_entity FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_datetime`
--

CREATE TABLE `catalog_product_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_DATETIME_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DTIME_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=684 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Datetime Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_datetime`
--

INSERT INTO `catalog_product_entity_datetime` VALUES (654,91,0,147,'2021-08-15 00:00:00'),(655,92,0,147,'2021-08-31 00:00:00'),(656,91,0,152,'2021-08-01 00:00:00'),(657,91,0,153,'2021-08-22 00:00:00'),(658,91,0,154,'2021-08-22 00:00:00'),(659,91,0,155,'2021-08-22 00:00:00'),(660,91,0,156,'2021-08-22 00:00:00'),(661,91,0,157,'2021-08-22 00:00:00'),(662,91,0,158,'2021-08-22 00:00:00'),(663,91,0,159,'2021-08-22 00:00:00'),(664,91,0,160,'2021-08-22 00:00:00'),(665,91,0,161,'2021-08-22 00:00:00'),(666,91,0,162,'2021-08-22 00:00:00'),(667,91,0,163,'2021-08-22 00:00:00'),(668,91,0,164,'2021-08-22 00:00:00'),(669,91,0,165,'2021-08-22 00:00:00'),(670,91,0,166,'2021-08-22 00:00:00'),(671,91,0,167,'2021-08-22 00:00:00'),(672,91,0,168,'2021-08-22 00:00:00'),(673,91,0,169,'2021-08-22 00:00:00'),(674,91,0,170,'2021-08-22 00:00:00'),(675,91,0,171,'2021-08-22 00:00:00'),(676,91,0,172,'2021-08-15 00:00:00'),(677,92,0,172,'2021-08-31 00:00:00'),(678,91,0,173,'2021-08-15 00:00:00'),(679,92,0,173,'2021-08-31 00:00:00'),(680,91,0,174,'2021-08-15 00:00:00'),(681,92,0,174,'2021-08-31 00:00:00'),(682,91,0,175,'2021-08-15 00:00:00'),(683,92,0,175,'2021-08-31 00:00:00');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_datetime_after_update AFTER UPDATE ON catalog_product_entity_datetime FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_decimal`
--

CREATE TABLE `catalog_product_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` decimal(20,6) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_DECIMAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_DEC_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=527 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Decimal Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_decimal`
--

INSERT INTO `catalog_product_entity_decimal` VALUES (502,74,0,148,55.000000),(503,74,0,149,55.000000),(504,74,0,150,55.000000),(505,74,0,151,55.000000),(506,74,0,152,80.000000),(507,74,0,153,35.000000),(508,74,0,154,55.000000),(509,74,0,155,35.000000),(510,74,0,156,55.000000),(511,74,0,157,40.000000),(512,74,0,158,60.000000),(513,74,0,160,50.000000),(514,74,0,161,50.000000),(515,74,0,162,50.000000),(516,74,0,164,80.000000),(517,74,0,165,80.000000),(518,74,0,166,80.000000),(519,74,0,168,60.000000),(520,74,0,169,80.000000),(521,74,0,170,100.000000),(523,74,0,172,50.000000),(524,74,0,173,50.000000),(525,74,0,174,50.000000),(526,74,0,175,50.000000);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_decimal_after_update AFTER UPDATE ON catalog_product_entity_decimal FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_gallery`
--

CREATE TABLE `catalog_product_entity_gallery` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_GALLERY_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_GALLERY_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_PRODUCT_ENTITY_GALLERY_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_GALLERY_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_GALLERY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_GLR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_GLR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Gallery Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_gallery`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_gallery_after_insert AFTER INSERT ON catalog_product_entity_gallery FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_gallery_after_update AFTER UPDATE ON catalog_product_entity_gallery FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`position` <=> OLD.`position`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_gallery_after_delete AFTER DELETE ON catalog_product_entity_gallery FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_int`
--

CREATE TABLE `catalog_product_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` int(11) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_INT_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_INT_ATTRIBUTE_ID_STORE_ID_VALUE` (`attribute_id`,`store_id`,`value`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_INT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_INT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1330 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Integer Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_int`
--

INSERT INTO `catalog_product_entity_int` VALUES (1101,94,0,147,1),(1102,96,0,147,4),(1103,129,0,147,2),(1104,134,0,147,1),(1108,94,0,148,1),(1109,96,0,148,1),(1110,129,0,148,2),(1111,134,0,148,1),(1113,153,0,148,5475),(1114,154,0,148,5477),(1117,94,0,149,1),(1118,96,0,149,1),(1119,129,0,149,2),(1120,134,0,149,1),(1122,153,0,149,5475),(1123,154,0,149,5478),(1126,94,0,150,1),(1127,96,0,150,1),(1128,129,0,150,2),(1129,134,0,150,1),(1131,153,0,150,5476),(1132,154,0,150,5477),(1135,94,0,151,1),(1136,96,0,151,1),(1137,129,0,151,2),(1138,134,0,151,1),(1140,153,0,151,5476),(1141,154,0,151,5478),(1144,94,0,152,1),(1145,96,0,152,4),(1146,129,0,152,2),(1147,134,0,152,1),(1152,94,0,153,1),(1153,96,0,153,1),(1154,129,0,153,2),(1155,134,0,153,1),(1157,156,0,153,5482),(1158,157,0,153,5485),(1161,94,0,154,1),(1162,96,0,154,1),(1163,129,0,154,2),(1164,134,0,154,1),(1166,156,0,154,5482),(1167,157,0,154,5486),(1170,94,0,155,1),(1171,96,0,155,1),(1172,129,0,155,2),(1173,134,0,155,1),(1175,156,0,155,5483),(1176,157,0,155,5485),(1179,94,0,156,1),(1180,96,0,156,1),(1181,129,0,156,2),(1182,134,0,156,1),(1184,156,0,156,5483),(1185,157,0,156,5486),(1188,94,0,157,1),(1189,96,0,157,1),(1190,129,0,157,2),(1191,134,0,157,1),(1193,156,0,157,5484),(1194,157,0,157,5485),(1197,94,0,158,1),(1198,96,0,158,1),(1199,129,0,158,2),(1200,134,0,158,1),(1202,156,0,158,5484),(1203,157,0,158,5486),(1206,94,0,159,1),(1207,96,0,159,4),(1208,129,0,159,2),(1209,134,0,159,1),(1213,94,0,160,1),(1214,96,0,160,1),(1215,129,0,160,2),(1216,134,0,160,1),(1218,156,0,160,5482),(1219,157,0,160,5485),(1222,94,0,161,1),(1223,96,0,161,1),(1224,129,0,161,2),(1225,134,0,161,1),(1227,156,0,161,5483),(1228,157,0,161,5485),(1231,94,0,162,1),(1232,96,0,162,1),(1233,129,0,162,2),(1234,134,0,162,1),(1236,156,0,162,5484),(1237,157,0,162,5485),(1240,94,0,163,1),(1241,96,0,163,4),(1242,129,0,163,2),(1243,134,0,163,1),(1247,94,0,164,1),(1248,96,0,164,1),(1249,129,0,164,2),(1250,134,0,164,0),(1252,156,0,164,5482),(1255,94,0,165,1),(1256,96,0,165,1),(1257,129,0,165,2),(1258,134,0,165,0),(1260,156,0,165,5483),(1263,94,0,166,1),(1264,96,0,166,1),(1265,129,0,166,2),(1266,134,0,166,0),(1268,156,0,166,5484),(1271,94,0,167,1),(1272,96,0,167,4),(1273,129,0,167,2),(1274,134,0,167,0),(1278,94,0,168,1),(1279,96,0,168,1),(1280,129,0,168,2),(1281,134,0,168,1),(1283,158,0,168,5487),(1286,94,0,169,1),(1287,96,0,169,1),(1288,129,0,169,2),(1289,134,0,169,1),(1291,158,0,169,5488),(1294,94,0,170,1),(1295,96,0,170,1),(1296,129,0,170,2),(1297,134,0,170,1),(1299,158,0,170,5489),(1302,94,0,171,1),(1303,96,0,171,4),(1304,129,0,171,2),(1305,134,0,171,1),(1306,94,0,172,1),(1307,96,0,172,1),(1308,129,0,172,2),(1309,134,0,172,1),(1310,156,0,172,5483),(1311,158,0,172,5487),(1312,94,0,173,1),(1313,96,0,173,1),(1314,129,0,173,2),(1315,134,0,173,1),(1316,156,0,173,5483),(1317,158,0,173,5488),(1318,94,0,174,1),(1319,96,0,174,1),(1320,129,0,174,2),(1321,134,0,174,1),(1322,156,0,174,5482),(1323,158,0,174,5487),(1324,94,0,175,1),(1325,96,0,175,1),(1326,129,0,175,2),(1327,134,0,175,1),(1328,156,0,175,5482),(1329,158,0,175,5488);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_int_after_insert AFTER INSERT ON catalog_product_entity_int FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_category_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `cataloginventory_stock_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_int_after_update AFTER UPDATE ON catalog_product_entity_int FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_category_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `cataloginventory_stock_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_int_after_delete AFTER DELETE ON catalog_product_entity_int FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_category_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `cataloginventory_stock_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_media_gallery`
--

CREATE TABLE `catalog_product_entity_media_gallery` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `media_type` varchar(32) NOT NULL DEFAULT 'image' COMMENT 'Media entry type',
  `disabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Visibility status',
  PRIMARY KEY (`value_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=448 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Media Gallery Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery`
--

INSERT INTO `catalog_product_entity_media_gallery` VALUES (1,87,'/m/2/m23.jpg','image',0),(2,87,'/m/2/m22.jpg','image',0),(3,87,'/m/2/m23_1.jpg','image',0),(4,87,'/m/2/m24.jpg','image',0),(5,87,'/2/6/26.jpg','image',0),(6,87,'/3/5/35.jpg','image',0),(7,87,'/0/7/07_1.jpg','image',0),(9,87,'/3/4/34_1.jpg','image',0),(15,87,'/1/6/16_1.jpg','image',0),(16,87,'/1/6/16_2.jpg','image',0),(17,87,'/1/6/16_3.jpg','image',0),(18,87,'/1/6/16_4.jpg','image',0),(19,87,'/9/1/91.jpg','image',0),(20,87,'/9/2/92.jpg','image',0),(21,87,'/9/3/93.jpg','image',0),(22,87,'/9/4/94.jpg','image',0),(24,87,'/i/m/image21xxl_1.jpg','image',0),(25,87,'/i/m/image31xxl_1.jpg','image',0),(26,87,'/i/m/image41xxl_1.jpg','image',0),(27,87,'/7/1/71_1.jpg','image',0),(28,87,'/m/9/m9.jpg','image',0),(29,87,'/m/1/m10.jpg','image',0),(30,87,'/m/1/m11.jpg','image',0),(31,87,'/m/1/m12.jpg','image',0),(32,87,'/m/1/m13.jpg','image',0),(33,87,'/m/1/m14.jpg','image',0),(34,87,'/m/1/m15.jpg','image',0),(35,87,'/m/1/m16.jpg','image',0),(36,87,'/m/9/m9_1.jpg','image',0),(38,87,'/m/1/m11_1.jpg','image',0),(39,87,'/m/1/m12_1.jpg','image',0),(40,87,'/m/1/m13_1.jpg','image',0),(41,87,'/m/1/m14_1.jpg','image',0),(42,87,'/m/1/m15_1.jpg','image',0),(43,87,'/m/1/m16_1.jpg','image',0),(52,87,'/5/1/51.jpg','image',0),(53,87,'/5/2/52.jpg','image',0),(54,87,'/5/3/53.jpg','image',0),(55,87,'/5/4/54.jpg','image',0),(56,87,'/6/1/61.jpg','image',0),(57,87,'/6/2/62.jpg','image',0),(58,87,'/6/3/63.jpg','image',0),(59,87,'/6/4/64.jpg','image',0),(60,87,'/a/1/a1.jpg','image',0),(61,87,'/a/2/a2.jpg','image',0),(62,87,'/a/3/a3.jpg','image',0),(63,87,'/a/4/a4.jpg','image',0),(64,87,'/g/_/g_1.jpg','image',0),(65,87,'/g/1/g1.jpg','image',0),(66,87,'/m/j/mj01-orange_main.jpg','image',0),(67,87,'/m/j/mj01-orange_main_1.jpg','image',0),(68,87,'/m/j/mj01-orange_main_2.jpg','image',0),(69,87,'/m/j/mj01-orange_main_3.jpg','image',0),(70,87,'/m/j/mj01-orange_main_4.jpg','image',0),(71,87,'/m/j/mj01-yellow_main_1.jpg','image',0),(72,87,'/m/j/mj01-yellow_main_2.jpg','image',0),(73,87,'/m/j/mj01-yellow_main_3.jpg','image',0),(74,87,'/m/j/mj01-yellow_main_4.jpg','image',0),(75,87,'/m/j/mj01-yellow_main_5.jpg','image',0),(76,87,'/m/j/mj01-red_main.jpg','image',0),(77,87,'/m/j/mj01-red_main_1.jpg','image',0),(78,87,'/m/j/mj01-red_main_2.jpg','image',0),(79,87,'/m/j/mj01-red_main_3.jpg','image',0),(80,87,'/m/j/mj01-red_main_4.jpg','image',0),(81,87,'/m/j/mj01-yellow_main.jpg','image',0),(82,87,'/m/j/mj01-yellow_back.jpg','image',0),(83,87,'/m/j/mj01-yellow_alt1.jpg','image',0),(84,87,'/w/j/wj11-blue_main.jpg','image',0),(85,87,'/w/j/wj11-blue_main_1.jpg','image',0),(86,87,'/w/j/wj11-blue_main_2.jpg','image',0),(87,87,'/w/j/wj11-blue_main_3.jpg','image',0),(88,87,'/w/j/wj11-blue_main_4.jpg','image',0),(89,87,'/w/j/wj11-black_main.jpg','image',0),(90,87,'/w/j/wj11-black_main_1.jpg','image',0),(91,87,'/w/j/wj11-black_main_2.jpg','image',0),(92,87,'/w/j/wj11-black_main_3.jpg','image',0),(93,87,'/w/j/wj11-black_main_4.jpg','image',0),(94,87,'/w/j/wj11-orange_main.jpg','image',0),(95,87,'/w/j/wj11-orange_main_1.jpg','image',0),(96,87,'/w/j/wj11-orange_main_2.jpg','image',0),(97,87,'/w/j/wj11-orange_main_3.jpg','image',0),(98,87,'/w/j/wj11-orange_main_4.jpg','image',0),(99,87,'/w/j/wj11-black_main_5.jpg','image',0),(100,87,'/w/j/wj11-blue_main_5.jpg','image',0),(101,87,'/w/j/wj11-blue_back.jpg','image',0),(102,87,'/w/j/wj11-blue_alt1.jpg','image',0),(103,87,'/m/h/mh13-blue_main_1.jpg','image',0),(104,87,'/m/h/mh13-blue_main_2.jpg','image',0),(105,87,'/m/h/mh13-blue_main_3.jpg','image',0),(106,87,'/m/h/mh13-blue_main_4.jpg','image',0),(107,87,'/m/h/mh13-blue_main_5.jpg','image',0),(108,87,'/m/h/mh13-green_main.jpg','image',0),(109,87,'/m/h/mh13-green_main_1.jpg','image',0),(110,87,'/m/h/mh13-green_main_2.jpg','image',0),(111,87,'/m/h/mh13-green_main_3.jpg','image',0),(112,87,'/m/h/mh13-green_main_4.jpg','image',0),(113,87,'/m/j/mj01-yellow_main_6.jpg','image',0),(114,87,'/m/j/mj01-yellow_main_1_1.jpg','image',0),(115,87,'/m/j/mj01-yellow_main_2_1.jpg','image',0),(116,87,'/m/j/mj01-yellow_main_3_1.jpg','image',0),(117,87,'/m/j/mj01-yellow_main_4_1.jpg','image',0),(118,87,'/m/h/mh13-blue_alt1.jpg','image',0),(119,87,'/m/h/mh13-blue_main.jpg','image',0),(120,87,'/m/h/mh13-blue_back.jpg','image',0),(121,87,'/m/h/mh13-lavender_main.jpg','image',0),(127,87,'/i/m/image1xxl_9__1_1.jpg','image',0),(128,87,'/i/m/image1xxl_10__1.jpg','image',0),(129,87,'/i/m/image2xxl_1_1.jpg','image',0),(130,87,'/i/m/image3xxl_1_1.jpg','image',0),(131,87,'/i/m/image4xxl_1_1.jpg','image',0),(138,87,'/6/2/62_1.jpg','image',0),(139,87,'/6/3/63_1.jpg','image',0),(140,87,'/6/4/64_1.jpg','image',0),(149,87,'/g/_/g_1_1.jpg','image',0),(150,87,'/g/1/g1_1.jpg','image',0),(151,87,'/g/2/g2.jpg','image',0),(152,87,'/g/3/g3.jpg','image',0),(153,87,'/g/4/g4.jpg','image',0),(159,87,'/m/1/m17.jpg','image',0),(160,87,'/m/1/m18.jpg','image',0),(161,87,'/m/1/m19.jpg','image',0),(162,87,'/m/2/m20.jpg','image',0),(163,87,'/4/1/41.jpg','image',0),(164,87,'/4/2/42.jpg','image',0),(165,87,'/4/3/43.jpg','image',0),(166,87,'/4/4/44.jpg','image',0),(167,87,'/9/1/91_1.jpg','image',0),(168,87,'/9/2/92_1.jpg','image',0),(169,87,'/9/3/93_1.jpg','image',0),(170,87,'/9/4/94_1.jpg','image',0),(171,87,'/d/2/d2.jpg','image',0),(172,87,'/3/3/3332.jpg','image',0),(173,87,'/3/3/3333.jpg','image',0),(174,87,'/3/3/3334.jpg','image',0),(175,87,'/m/h/mh13-blue_main_1_1.jpg','image',0),(176,87,'/m/h/mh13-blue_main_2_1.jpg','image',0),(177,87,'/m/h/mh13-blue_main_3_1.jpg','image',0),(178,87,'/m/j/mj01-yellow_main_7.jpg','image',0),(179,87,'/m/j/mj01-yellow_main_1_2.jpg','image',0),(180,87,'/m/j/mj01-orange_main_5.jpg','image',0),(181,87,'/m/h/mh13-green_main_5.jpg','image',0),(182,87,'/m/h/mh13-green_main_1_1.jpg','image',0),(183,87,'/m/h/mh13-green_main_2_1.jpg','image',0),(184,87,'/m/h/mh13-blue_alt1_1.jpg','image',0),(185,87,'/m/h/mh13-blue_back_1.jpg','image',0),(186,87,'/m/h/mh13-blue_main_6.jpg','image',0),(187,87,'/m/h/mh13-lavender_main_1.jpg','image',0),(188,87,'/6/1/61_2.jpg','image',0),(189,87,'/6/2/62_2.jpg','image',0),(190,87,'/6/3/63_2.jpg','image',0),(191,87,'/6/4/64_2.jpg','image',0),(192,87,'/2/7/27_1.jpg','image',0),(194,87,'/0/7/07_1_1.jpg','image',0),(195,87,'/m/1/m13_2.jpg','image',0),(196,87,'/m/1/m14_2.jpg','image',0),(197,87,'/m/1/m15_2.jpg','image',0),(198,87,'/m/1/m16_2.jpg','image',0),(199,87,'/m/1/m17_1.jpg','image',0),(202,87,'/i/m/image122xxl.jpg','image',0),(204,87,'/m/4/m4.jpg','image',0),(205,87,'/1/1/115948552_640.jpg','external-video',0),(206,87,'/w/1/w108176_190920_ns_tt_1.jpg','image',0),(207,87,'/w/1/w108176_190920_ns_tt_2.jpg','image',0),(208,87,'/w/1/w108176_190920_ns_tt_3.jpg','image',0),(209,87,'/w/1/w108176_191001_ns_of_7.jpg','image',0),(210,87,'/w/1/w107099_190920_ns_tt_1.jpg','image',0),(211,87,'/w/1/w107099_190920_ns_tt_2.jpg','image',0),(212,87,'/w/1/w107099_190920_ns_tt_3.jpg','image',0),(213,87,'/w/1/w107099_191001_ns_of_7.jpg','image',0),(214,87,'/w/q/wq08006_1_190823.jpg','image',0),(215,87,'/w/q/wq08006_2_190823.jpg','image',0),(216,87,'/w/q/wq08006_3_190823.jpg','image',0),(217,87,'/w/q/wq08006_4_190823.jpg','image',0),(218,87,'/w/1/w106922_1.jpg','image',0),(219,87,'/w/1/w106922_2.jpg','image',0),(220,87,'/w/1/w106922_3.jpg','image',0),(221,87,'/w/q/wqcd090062_190920_ns_tt_1.jpg','image',0),(222,87,'/w/q/wqcd090062_190920_ns_tt_2.jpg','image',0),(223,87,'/w/q/wqcd090062_190920_ns_tt_3.jpg','image',0),(224,87,'/w/q/wqcd090062_190920_ns_tt_4.jpg','image',0),(225,87,'/w/k/wkc100174_191106_ns_tt_1.jpg','image',0),(226,87,'/w/k/wkc100174_191106_ns_tt_2.jpg','image',0),(227,87,'/w/k/wkc100174_191106_ns_tt_3.jpg','image',0),(228,87,'/w/1/w104619_1.jpg','image',0),(229,87,'/w/1/w104619_2.jpg','image',0),(230,87,'/w/1/w104619_3.jpg','image',0),(231,87,'/h/5/h5919c2bb2aafc.jpg','image',0),(232,87,'/h/5/h5919c2bb2df65.jpg','image',0),(233,87,'/h/5/h5919c2bb28c32.jpg','image',0),(234,87,'/h/5/h5919c2bb301a1.jpg','image',0),(235,87,'/1/0/1051197_1.jpg','image',0),(236,87,'/1/0/1051197_2.jpg','image',0),(237,87,'/1/0/1051197_3.jpg','image',0),(238,87,'/1/0/1051197_4.jpg','image',0),(239,87,'/w/1/w108176_190920_ns_tt_2_1.jpg','image',0),(240,87,'/w/1/w108176_190920_ns_tt_1_1.jpg','image',0),(241,87,'/w/1/w108176_190920_ns_tt_3_1.jpg','image',0),(242,87,'/w/q/wq08006_2_190823_1.jpg','image',0),(243,87,'/w/q/wq08006_3_190823_1.jpg','image',0),(244,87,'/w/q/wq08006_4_190823_1.jpg','image',0),(245,87,'/w/1/w106922_1_1.jpg','image',0),(246,87,'/w/1/w106922_2_1.jpg','image',0),(247,87,'/w/1/w106922_3_1.jpg','image',0),(248,87,'/w/1/w107099_190920_ns_tt_1_1.jpg','image',0),(249,87,'/w/1/w107099_190920_ns_tt_2_1.jpg','image',0),(250,87,'/w/1/w107099_190920_ns_tt_3_1.jpg','image',0),(251,87,'/w/1/w107099_191001_ns_of_7_1.jpg','image',0),(252,87,'/w/q/wqcd090062_190920_ns_tt_1_1.jpg','image',0),(253,87,'/w/q/wqcd090062_190920_ns_tt_2_1.jpg','image',0),(254,87,'/w/q/wqcd090062_190920_ns_tt_3_1.jpg','image',0),(255,87,'/w/q/wqcd090062_190920_ns_tt_4_1.jpg','image',0),(256,87,'/w/1/w104619_1_1.jpg','image',0),(257,87,'/w/1/w104619_2_1.jpg','image',0),(258,87,'/w/1/w104619_3_1.jpg','image',0),(259,87,'/1/-/1-8.jpg','image',0),(260,87,'/2/-/2-6.jpg','image',0),(261,87,'/3/-/3-2.jpg','image',0),(262,87,'/1/-/1-32.jpg','image',0),(263,87,'/2/-/2-35.jpg','image',0),(264,87,'/2/-/2-29.jpg','image',0),(265,87,'/3/-/3-3_1.jpg','image',0),(266,87,'/1/-/1-28.jpg','image',0),(267,87,'/2/-/2-31.jpg','image',0),(268,87,'/1/-/1-30.jpg','image',0),(269,87,'/2/-/2-33.jpg','image',0),(270,87,'/1/-/1-29.jpg','image',0),(271,87,'/2/-/2-32.jpg','image',0),(272,87,'/1/-/1-25.jpg','image',0),(273,87,'/2/-/2-28.jpg','image',0),(274,87,'/1/-/1-27.jpg','image',0),(275,87,'/1/-/1-33.jpg','image',0),(276,87,'/2/-/2-36.jpg','image',0),(277,87,'/3/-/3-4.jpg','image',0),(278,87,'/1/-/1-31.jpg','image',0),(279,87,'/2/-/2-34.jpg','image',0),(280,87,'/1/-/1-25_1.jpg','image',0),(281,87,'/2/-/2-28_1.jpg','image',0),(282,87,'/1/-/1-25_2.jpg','image',0),(283,87,'/2/-/2-28_2.jpg','image',0),(284,87,'/1/-/1-29_1.jpg','image',0),(285,87,'/2/-/2-32_1.jpg','image',0),(286,87,'/1/-/1-30_1.jpg','image',0),(287,87,'/2/-/2-33_1.jpg','image',0),(288,87,'/1/-/1-28_1.jpg','image',0),(289,87,'/2/-/2-31_1.jpg','image',0),(290,87,'/1/-/1-32_1.jpg','image',0),(291,87,'/2/-/2-35_1.jpg','image',0),(292,87,'/2/-/2-29_1.jpg','image',0),(293,87,'/3/-/3-3_1_1.jpg','image',0),(294,87,'/1/-/1-31_1.jpg','image',0),(295,87,'/2/-/2-34_1.jpg','image',0),(296,87,'/1/-/1-25_3.jpg','image',0),(297,87,'/2/-/2-28_3.jpg','image',0),(298,87,'/1/-/1-27_1.jpg','image',0),(299,87,'/1/-/1-33_1.jpg','image',0),(300,87,'/2/-/2-36_1.jpg','image',0),(301,87,'/3/-/3-4_1.jpg','image',0),(302,87,'/2/-/2-29_1_1.jpg','image',0),(303,87,'/3/-/3-3_1_1_1.jpg','image',0),(304,87,'/1/-/1-30_1_1.jpg','image',0),(305,87,'/2/-/2-33_1_1.jpg','image',0),(306,87,'/1/-/1-25_1_1.jpg','image',0),(307,87,'/2/-/2-28_1_1.jpg','image',0),(308,87,'/1/-/1-29_2.jpg','image',0),(309,87,'/2/-/2-32_2.jpg','image',0),(310,87,'/1/-/1-8_1.jpg','image',0),(311,87,'/2/-/2-6_1.jpg','image',0),(312,87,'/3/-/3-2_1.jpg','image',0),(313,87,'/1/-/1-31_2.jpg','image',0),(314,87,'/2/-/2-34_2.jpg','image',0),(315,87,'/1/-/1-30_1_2.jpg','image',0),(316,87,'/2/-/2-33_1_2.jpg','image',0),(317,87,'/1/-/1-28_2.jpg','image',0),(318,87,'/2/-/2-31_2.jpg','image',0),(319,87,'/2/-/2-29_1_2.jpg','image',0),(320,87,'/3/-/3-3_2.jpg','image',0),(321,87,'/1/-/1-19.jpg','image',0),(322,87,'/2/-/2-22.jpg','image',0),(323,87,'/1/-/1-15.jpg','image',0),(324,87,'/2/-/2-18.jpg','image',0),(325,87,'/1/-/1-16.jpg','image',0),(326,87,'/2/-/2-19.jpg','image',0),(327,87,'/1/-/1-22.jpg','image',0),(328,87,'/2/-/2-25.jpg','image',0),(329,87,'/1/-/1-21.jpg','image',0),(330,87,'/2/-/2-24.jpg','image',0),(331,87,'/1/-/1-20.jpg','image',0),(332,87,'/2/-/2-23.jpg','image',0),(333,87,'/1/-/1-18.jpg','image',0),(334,87,'/2/-/2-21.jpg','image',0),(335,87,'/1/-/1-24.jpg','image',0),(336,87,'/2/-/2-27.jpg','image',0),(337,87,'/1/-/1-23.jpg','image',0),(338,87,'/2/-/2-26.jpg','image',0),(339,87,'/1/-/1-17.jpg','image',0),(340,87,'/2/-/2-20.jpg','image',0),(341,87,'/1/-/1-17_1.jpg','image',0),(342,87,'/2/-/2-20_1_1.jpg','image',0),(343,87,'/1/-/1-20_1.jpg','image',0),(344,87,'/2/-/2-23_1.jpg','image',0),(345,87,'/1/-/1-18_1.jpg','image',0),(346,87,'/2/-/2-21_1.jpg','image',0),(347,87,'/1/-/1-24_1.jpg','image',0),(348,87,'/2/-/2-27_1_1.jpg','image',0),(349,87,'/1/-/1-21_1.jpg','image',0),(350,87,'/2/-/2-24_1.jpg','image',0),(351,87,'/1/-/1-22_1.jpg','image',0),(352,87,'/2/-/2-25_1.jpg','image',0),(353,87,'/2/-/2-26_1.jpg','image',0),(354,87,'/2/-/2-20_1.jpg','image',0),(355,87,'/2/-/2-27_1.jpg','image',0),(356,87,'/1/-/1-16_1.jpg','image',0),(357,87,'/2/-/2-19_1.jpg','image',0),(358,87,'/1/-/1-15_1.jpg','image',0),(359,87,'/2/-/2-18_1.jpg','image',0),(360,87,'/1/-/1-22_1_1.jpg','image',0),(361,87,'/2/-/2-25_1_1.jpg','image',0),(362,87,'/1/-/1-21_1_1.jpg','image',0),(363,87,'/2/-/2-24_1_1.jpg','image',0),(364,87,'/1/-/1-48.jpg','image',0),(365,87,'/2/-/2-51.jpg','image',0),(366,87,'/3/-/3-16.jpg','image',0),(367,87,'/4/-/4-4.jpg','image',0),(368,87,'/1/-/1-49.jpg','image',0),(369,87,'/2/-/2-52.jpg','image',0),(370,87,'/3/-/3-17.jpg','image',0),(371,87,'/4/-/4-5.jpg','image',0),(372,87,'/1/-/1-51.jpg','image',0),(373,87,'/2/-/2-54.jpg','image',0),(374,87,'/3/-/3-19.jpg','image',0),(375,87,'/4/-/4-7.jpg','image',0),(376,87,'/1/-/1-46.jpg','image',0),(377,87,'/2/-/2-49.jpg','image',0),(378,87,'/3/-/3-14.jpg','image',0),(379,87,'/4/-/4-2.jpg','image',0),(380,87,'/1/-/1-47.jpg','image',0),(381,87,'/2/-/2-50.jpg','image',0),(382,87,'/3/-/3-15.jpg','image',0),(383,87,'/4/-/4-3.jpg','image',0),(384,87,'/1/-/1-45.jpg','image',0),(385,87,'/2/-/2-48.jpg','image',0),(386,87,'/3/-/3-13.jpg','image',0),(387,87,'/4/-/4-1.jpg','image',0),(388,87,'/5/-/5-1.jpg','image',0),(389,87,'/1/-/1-52.jpg','image',0),(390,87,'/2/-/2-55.jpg','image',0),(391,87,'/1/-/1-53.jpg','image',0),(392,87,'/2/-/2-56.jpg','image',0),(393,87,'/3/-/3-20.jpg','image',0),(394,87,'/4/-/4-8.jpg','image',0),(395,87,'/1/-/1-12.jpg','image',0),(396,87,'/2/-/2-12.jpg','image',0),(397,87,'/3/-/3-12.jpg','image',0),(398,87,'/4/-/4-7_1.jpg','image',0),(399,87,'/1/-/1-44.jpg','image',0),(400,87,'/2/-/2-47.jpg','image',0),(401,87,'/4/_/4.jpg','image',0),(402,87,'/5/_/5.jpg','image',0),(403,87,'/1/-/1-51_1.jpg','image',0),(404,87,'/2/-/2-54_1.jpg','image',0),(405,87,'/4/-/4-7_1_1.jpg','image',0),(406,87,'/1/-/1-45_1.jpg','image',0),(407,87,'/2/-/2-48_1.jpg','image',0),(408,87,'/3/-/3-13_1.jpg','image',0),(409,87,'/5/-/5-1_1.jpg','image',0),(410,87,'/1/-/1-48_1.jpg','image',0),(411,87,'/2/-/2-51_1.jpg','image',0),(412,87,'/4/-/4-4_1.jpg','image',0),(413,87,'/1/-/1-53_1.jpg','image',0),(414,87,'/2/-/2-56_1.jpg','image',0),(415,87,'/3/-/3-20_1.jpg','image',0),(416,87,'/4/-/4-8_1.jpg','image',0),(417,87,'/1/-/1-12_1.jpg','image',0),(418,87,'/2/-/2-12_1.jpg','image',0),(419,87,'/3/-/3-12_1.jpg','image',0),(420,87,'/4/-/4-7_1_2.jpg','image',0),(421,87,'/2/-/2-54_1_1.jpg','image',0),(422,87,'/1/-/1-51_1_1.jpg','image',0),(423,87,'/3/-/3-19_1.jpg','image',0),(424,87,'/1/-/1-46_1.jpg','image',0),(425,87,'/2/-/2-49_1.jpg','image',0),(426,87,'/3/-/3-14_1.jpg','image',0),(427,87,'/1/-/1-47_1.jpg','image',0),(428,87,'/2/-/2-50_1.jpg','image',0),(429,87,'/3/-/3-15_1.jpg','image',0),(430,87,'/1/-/1-48_2.jpg','image',0),(431,87,'/1/-/1-49_1.jpg','image',0),(432,87,'/1/-/1-51_2.jpg','image',0),(433,87,'/1/-/1-45_2.jpg','image',0),(434,87,'/2/-/2-48_2.jpg','image',0),(435,87,'/3/-/3-13_2.jpg','image',0),(436,87,'/4/-/4-1_1.jpg','image',0),(437,87,'/c/a/cake_container_plast_ri9hf.jpg','image',0),(439,87,'/i/l/il_794xn.2959121296_rw5g_1.jpg','image',0),(440,87,'/i/n/indeddddffx.jpg','image',0),(442,87,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg','image',0),(443,87,'/i/n/ingkgkdex_1.jpg','image',0),(444,87,'/i/n/indeddddffx_1.jpg','image',0),(445,87,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg','image',0),(446,87,'/d/a/david_holifield_44ig_d1nji_1.jpg','image',0),(447,87,'/c/a/cake_container_plast_ri9hf_1.jpg','image',0);

--
-- Table structure for table `catalog_product_entity_media_gallery_value`
--

CREATE TABLE `catalog_product_entity_media_gallery_value` (
  `value_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Value ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `position` int(10) unsigned DEFAULT NULL COMMENT 'Position',
  `disabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Disabled',
  `record_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Record ID',
  PRIMARY KEY (`record_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_PRODUCT_ENTITY_MEDIA_GALLERY_VALUE_VALUE_ID` (`value_id`),
  KEY `CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_VAL_ID_STORE_ID` (`entity_id`,`value_id`,`store_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_VAL_ID_CAT_PRD_ENTT_MDA_GLR_VAL_ID` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=957 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Media Gallery Attribute Value Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery_value`
--

INSERT INTO `catalog_product_entity_media_gallery_value` VALUES (442,18,171,NULL,1,0,904),(442,0,171,NULL,1,0,908),(440,0,163,NULL,1,1,915),(444,0,163,NULL,2,0,916),(443,0,167,NULL,2,0,918),(439,0,159,NULL,1,1,921),(445,0,159,NULL,2,0,922),(446,0,152,NULL,2,0,928),(443,18,167,NULL,2,0,941),(440,18,163,NULL,1,1,942),(444,18,163,NULL,2,0,943),(439,18,159,NULL,1,1,944),(445,18,159,NULL,2,0,945),(446,18,152,NULL,2,0,946),(437,18,147,NULL,1,1,947),(447,18,147,NULL,2,0,948),(437,0,147,NULL,1,1,955),(447,0,147,NULL,2,0,956);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_media_gallery_value_after_insert AFTER INSERT ON catalog_product_entity_media_gallery_value FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_media_gallery_value_after_update AFTER UPDATE ON catalog_product_entity_media_gallery_value FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`label` <=> OLD.`label`) OR NOT(NEW.`position` <=> OLD.`position`) OR NOT(NEW.`disabled` <=> OLD.`disabled`) OR NOT(NEW.`record_id` <=> OLD.`record_id`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_media_gallery_value_after_delete AFTER DELETE ON catalog_product_entity_media_gallery_value FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_media_gallery_value_to_entity`
--

CREATE TABLE `catalog_product_entity_media_gallery_value_to_entity` (
  `value_id` int(10) unsigned NOT NULL COMMENT 'Value media Entry ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Product Entity ID',
  UNIQUE KEY `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_VAL_ID_ENTT_ID` (`value_id`,`entity_id`),
  KEY `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` (`entity_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_TO_ENTT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A6C6C8FAA386736921D3A7C4B50B1185` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link Media value to Product entity table';

--
-- Dumping data for table `catalog_product_entity_media_gallery_value_to_entity`
--

INSERT INTO `catalog_product_entity_media_gallery_value_to_entity` VALUES (437,147),(447,147),(446,152),(439,159),(445,159),(440,163),(444,163),(443,167),(442,171);

--
-- Table structure for table `catalog_product_entity_media_gallery_value_video`
--

CREATE TABLE `catalog_product_entity_media_gallery_value_video` (
  `value_id` int(10) unsigned NOT NULL COMMENT 'Media Entity ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `provider` varchar(32) DEFAULT NULL COMMENT 'Video provider ID',
  `url` text COMMENT 'Video URL',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `description` text COMMENT 'Page Meta Description',
  `metadata` text COMMENT 'Video meta data',
  UNIQUE KEY `CAT_PRD_ENTT_MDA_GLR_VAL_VIDEO_VAL_ID_STORE_ID` (`value_id`,`store_id`),
  KEY `CAT_PRD_ENTT_MDA_GLR_VAL_VIDEO_STORE_ID_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `CAT_PRD_ENTT_MDA_GLR_VAL_VIDEO_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6FDF205946906B0E653E60AA769899F8` FOREIGN KEY (`value_id`) REFERENCES `catalog_product_entity_media_gallery` (`value_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Video Table';

--
-- Dumping data for table `catalog_product_entity_media_gallery_value_video`
--

INSERT INTO `catalog_product_entity_media_gallery_value_video` VALUES (205,0,'','https://vimeo.com/18433850','','','');

--
-- Table structure for table `catalog_product_entity_text`
--

CREATE TABLE `catalog_product_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` text COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_TEXT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TEXT_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=610 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Text Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_text`
--

INSERT INTO `catalog_product_entity_text` VALUES (564,82,0,147,'Birthday cake package'),(565,82,0,148,'Birthday cake package'),(566,82,0,149,'Birthday cake package'),(567,82,0,150,'Birthday cake package'),(568,82,0,151,'Birthday cake package'),(569,73,0,147,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>'),(570,73,0,152,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>'),(571,82,0,152,'Bridal shower package '),(572,82,0,153,'Hand tie bouquet in bag'),(573,82,0,154,'Hand tie bouquet in bag'),(574,82,0,155,'Hand tie bouquet in bag'),(575,82,0,156,'Hand tie bouquet in bag'),(576,82,0,157,'Hand tie bouquet in bag'),(577,82,0,158,'Hand tie bouquet in bag'),(578,82,0,159,'Hand tie bouquet in bag'),(579,73,0,160,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>'),(580,82,0,160,'Hand tie bouquet in vase'),(581,73,0,161,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>'),(582,82,0,161,'Hand tie bouquet in vase'),(583,73,0,162,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>'),(584,82,0,162,'Hand tie bouquet in vase'),(585,73,0,163,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>'),(586,82,0,163,'Hand tie bouquet in vase'),(587,73,0,164,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>'),(588,82,0,164,'Flower arrangement in vase'),(589,73,0,165,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>'),(590,82,0,165,'Flower arrangement in vase'),(591,73,0,166,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>'),(592,82,0,166,'Flower arrangement in vase'),(593,73,0,167,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>'),(594,82,0,167,'Flower arrangement in vase'),(595,82,0,168,'Phalaenopsis plant arrangement in vase'),(596,82,0,169,'Phalaenopsis plant arrangement in vase'),(597,82,0,170,'Phalaenopsis plant arrangement in vase'),(598,82,0,171,'Phalaenopsis plant arrangement in vase'),(599,73,18,147,'<p>كعكة عيد الميلاد (نكهة الفانيليا أو الشوكولاتة)<br>بالون كبير 80 سم (لون ابيض او وردي)<br>زهور بيضاء أو ظلال وردية (نوع الزهرة حسب التوافر)<br>حجم علبة الكيك 28 سم مربعة بارتفاع 16 سم<br>طول إكليل الزهور 70-80 سم</p>'),(600,73,18,163,'<p>فازة ارتفاع 20 سم وقطرها 18 سم</p>\r\n<p>ارتفاع المزهرية بالورد 35-40 سم</p>'),(601,73,18,152,'<p>كيك الفانيليا بالكريمة<br>مقاس علبة الكيك عرض 27 سم × ارتفاع 35 سم<br>تنسيق الزهور (اللون حسب التوافر وطلب العميل)</p>'),(602,73,0,172,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>'),(603,82,0,172,'Birthday cake package'),(604,73,0,173,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>'),(605,82,0,173,'Birthday cake package'),(606,73,0,174,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>'),(607,82,0,174,'Birthday cake package'),(608,73,0,175,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>'),(609,82,0,175,'Birthday cake package');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_text_after_update AFTER UPDATE ON catalog_product_entity_text FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_tier_price`
--

CREATE TABLE `catalog_product_entity_tier_price` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `all_groups` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Applicable To All Customer Groups',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Group ID',
  `qty` decimal(12,4) NOT NULL DEFAULT '1.0000' COMMENT 'QTY',
  `value` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Value',
  `percentage_value` decimal(5,2) DEFAULT NULL COMMENT 'Percentage value',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_E8AB433B9ACB00343ABB312AD2FAB087` (`entity_id`,`all_groups`,`customer_group_id`,`qty`,`website_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Tier Price Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_tier_price`
--

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_tier_price_after_insert AFTER INSERT ON catalog_product_entity_tier_price FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_tier_price_after_update AFTER UPDATE ON catalog_product_entity_tier_price FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`all_groups` <=> OLD.`all_groups`) OR NOT(NEW.`customer_group_id` <=> OLD.`customer_group_id`) OR NOT(NEW.`qty` <=> OLD.`qty`) OR NOT(NEW.`value` <=> OLD.`value`) OR NOT(NEW.`percentage_value` <=> OLD.`percentage_value`) OR NOT(NEW.`website_id` <=> OLD.`website_id`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`all_groups` <=> OLD.`all_groups`) OR NOT(NEW.`customer_group_id` <=> OLD.`customer_group_id`) OR NOT(NEW.`qty` <=> OLD.`qty`) OR NOT(NEW.`value` <=> OLD.`value`) OR NOT(NEW.`percentage_value` <=> OLD.`percentage_value`) OR NOT(NEW.`website_id` <=> OLD.`website_id`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`all_groups` <=> OLD.`all_groups`) OR NOT(NEW.`customer_group_id` <=> OLD.`customer_group_id`) OR NOT(NEW.`qty` <=> OLD.`qty`) OR NOT(NEW.`value` <=> OLD.`value`) OR NOT(NEW.`percentage_value` <=> OLD.`percentage_value`) OR NOT(NEW.`website_id` <=> OLD.`website_id`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_tier_price_after_delete AFTER DELETE ON catalog_product_entity_tier_price FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_entity_varchar`
--

CREATE TABLE `catalog_product_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_ENTITY_VARCHAR_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_VCHR_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3651 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Varchar Attribute Backend Table';

--
-- Dumping data for table `catalog_product_entity_varchar`
--

INSERT INTO `catalog_product_entity_varchar` VALUES (3033,70,0,147,'Birthday cake package'),(3034,81,0,147,'Birthday cake package'),(3035,83,0,147,'Birthday cake package '),(3036,84,0,147,'/c/a/cake_container_plast_ri9hf_1.jpg'),(3037,85,0,147,'/c/a/cake_container_plast_ri9hf_1.jpg'),(3038,86,0,147,'/c/a/cake_container_plast_ri9hf_1.jpg'),(3039,103,0,147,'container2'),(3040,115,0,147,'birthdaycakepackage'),(3041,118,0,147,'0'),(3042,128,0,147,'/c/a/cake_container_plast_ri9hf.jpg'),(3043,130,0,147,'2'),(3051,70,0,148,'Birthday cake package-vanilla-white'),(3052,81,0,148,'Birthday cake package'),(3053,83,0,148,'Birthday cake package '),(3054,103,0,148,'container2'),(3055,115,0,148,'birthday-cake-package-vanilla-white'),(3056,118,0,148,'0'),(3057,130,0,148,'0'),(3061,70,0,149,'Birthday cake package-vanilla-pink'),(3062,81,0,149,'Birthday cake package'),(3063,83,0,149,'Birthday cake package '),(3064,103,0,149,'container2'),(3065,115,0,149,'birthday-cake-package-vanilla-pink'),(3066,118,0,149,'0'),(3067,130,0,149,'0'),(3071,70,0,150,'Birthday cake package-chocolate -white'),(3072,81,0,150,'Birthday cake package'),(3073,83,0,150,'Birthday cake package '),(3074,103,0,150,'container2'),(3075,115,0,150,'birthday-cake-package-chocolate-white'),(3076,118,0,150,'0'),(3077,130,0,150,'0'),(3081,70,0,151,'Birthday cake package-chocolate -pink'),(3082,81,0,151,'Birthday cake package'),(3083,83,0,151,'Birthday cake package '),(3084,103,0,151,'container2'),(3085,115,0,151,'birthday-cake-package-chocolate-pink'),(3086,118,0,151,'0'),(3087,130,0,151,'0'),(3103,70,0,152,'Bridal shower package '),(3104,81,0,152,'Bridal shower package '),(3105,83,0,152,'Bridal shower package  '),(3106,84,0,152,'/d/a/david_holifield_44ig_d1nji_1.jpg'),(3107,85,0,152,'/d/a/david_holifield_44ig_d1nji_1.jpg'),(3108,86,0,152,'/d/a/david_holifield_44ig_d1nji_1.jpg'),(3109,103,0,152,'container2'),(3110,115,0,152,'bridal-shower-package'),(3111,118,0,152,'0'),(3112,128,0,152,'/d/a/david_holifield_44ig_d1nji_1.jpg'),(3113,130,0,152,'2'),(3125,70,0,153,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)'),(3126,81,0,153,'Hand tie bouquet in bag'),(3127,83,0,153,'Hand tie bouquet in bag '),(3128,103,0,153,'container2'),(3129,115,0,153,'hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter'),(3130,130,0,153,'0'),(3134,70,0,154,'Hand tie bouquet in bag-All White-Large (50 cm diameter)'),(3135,81,0,154,'Hand tie bouquet in bag'),(3136,83,0,154,'Hand tie bouquet in bag '),(3137,103,0,154,'container2'),(3138,115,0,154,'hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter'),(3139,130,0,154,'0'),(3143,70,0,155,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)'),(3144,81,0,155,'Hand tie bouquet in bag'),(3145,83,0,155,'Hand tie bouquet in bag '),(3146,103,0,155,'container2'),(3147,115,0,155,'hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter'),(3148,130,0,155,'0'),(3152,70,0,156,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)'),(3153,81,0,156,'Hand tie bouquet in bag'),(3154,83,0,156,'Hand tie bouquet in bag '),(3155,103,0,156,'container2'),(3156,115,0,156,'hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter'),(3157,130,0,156,'0'),(3161,70,0,157,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)'),(3162,81,0,157,'Hand tie bouquet in bag'),(3163,83,0,157,'Hand tie bouquet in bag '),(3164,103,0,157,'container2'),(3165,115,0,157,'hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter'),(3166,130,0,157,'0'),(3170,70,0,158,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)'),(3171,81,0,158,'Hand tie bouquet in bag'),(3172,83,0,158,'Hand tie bouquet in bag '),(3173,103,0,158,'container2'),(3174,115,0,158,'hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter'),(3175,130,0,158,'0'),(3179,70,0,159,'Hand tie bouquet in bag'),(3180,81,0,159,'Hand tie bouquet in bag'),(3181,83,0,159,'Hand tie bouquet in bag '),(3182,84,0,159,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg'),(3183,85,0,159,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg'),(3184,86,0,159,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg'),(3185,103,0,159,'container2'),(3186,115,0,159,'handtiebouquetinbag'),(3187,118,0,159,'0'),(3188,128,0,159,'/i/l/il_794xn.2959121296_rw5g_1.jpg'),(3189,130,0,159,'2'),(3197,70,0,160,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)'),(3198,81,0,160,'Hand tie bouquet in vase'),(3199,83,0,160,'Hand tie bouquet in vase '),(3200,103,0,160,'container2'),(3201,115,0,160,'hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter'),(3202,130,0,160,'0'),(3206,70,0,161,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)'),(3207,81,0,161,'Hand tie bouquet in vase'),(3208,83,0,161,'Hand tie bouquet in vase '),(3209,103,0,161,'container2'),(3210,115,0,161,'hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter'),(3211,130,0,161,'0'),(3215,70,0,162,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)'),(3216,81,0,162,'Hand tie bouquet in vase'),(3217,83,0,162,'Hand tie bouquet in vase '),(3218,103,0,162,'container2'),(3219,115,0,162,'hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter'),(3220,130,0,162,'0'),(3224,70,0,163,'Hand tie bouquet in vase'),(3225,81,0,163,'Hand tie bouquet in vase'),(3226,83,0,163,'Hand tie bouquet in vase '),(3227,84,0,163,'/i/n/indeddddffx_1.jpg'),(3228,85,0,163,'/i/n/indeddddffx_1.jpg'),(3229,86,0,163,'/i/n/indeddddffx_1.jpg'),(3230,103,0,163,'container2'),(3231,115,0,163,'handtiebouquetinvase'),(3232,118,0,163,'0'),(3233,128,0,163,'/i/n/indeddddffx.jpg'),(3234,130,0,163,'2'),(3246,70,0,164,'Flower arrangement in vase-All White'),(3247,81,0,164,'Flower arrangement in vase'),(3248,83,0,164,'Flower arrangement in vase '),(3249,103,0,164,'container2'),(3250,115,0,164,'flower-arrangement-in-vase-all-white'),(3251,130,0,164,'0'),(3255,70,0,165,'Flower arrangement in vase-Pink hues'),(3256,81,0,165,'Flower arrangement in vase'),(3257,83,0,165,'Flower arrangement in vase '),(3258,103,0,165,'container2'),(3259,115,0,165,'flower-arrangement-in-vase-pink-hues'),(3260,130,0,165,'0'),(3264,70,0,166,'Flower arrangement in vase-Special of the day (mix)'),(3265,81,0,166,'Flower arrangement in vase'),(3266,83,0,166,'Flower arrangement in vase '),(3267,103,0,166,'container2'),(3268,115,0,166,'flower-arrangement-in-vase-special-of-the-day-mix'),(3269,130,0,166,'0'),(3273,70,0,167,'Flower arrangement in vase'),(3274,81,0,167,'Flower arrangement in vase'),(3275,83,0,167,'Flower arrangement in vase '),(3276,84,0,167,'/i/n/ingkgkdex_1.jpg'),(3277,85,0,167,'/i/n/ingkgkdex_1.jpg'),(3278,86,0,167,'/i/n/ingkgkdex_1.jpg'),(3279,103,0,167,'container2'),(3280,115,0,167,'flower-arrangement-in-vase'),(3281,118,0,167,'0'),(3282,130,0,167,'2'),(3289,70,0,168,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant'),(3290,81,0,168,'Phalaenopsis plant arrangement in vase'),(3291,83,0,168,'Phalaenopsis plant arrangement in vase '),(3292,103,0,168,'container2'),(3293,115,0,168,'phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant'),(3294,130,0,168,'0'),(3298,70,0,169,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants'),(3299,81,0,169,'Phalaenopsis plant arrangement in vase'),(3300,83,0,169,'Phalaenopsis plant arrangement in vase '),(3301,103,0,169,'container2'),(3302,115,0,169,'phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants'),(3303,130,0,169,'0'),(3307,70,0,170,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants'),(3308,81,0,170,'Phalaenopsis plant arrangement in vase'),(3309,83,0,170,'Phalaenopsis plant arrangement in vase '),(3310,103,0,170,'container2'),(3311,115,0,170,'phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants'),(3312,130,0,170,'0'),(3316,70,0,171,'Phalaenopsis plant arrangement in vase'),(3317,81,0,171,'Phalaenopsis plant arrangement in vase'),(3318,83,0,171,'Phalaenopsis plant arrangement in vase '),(3319,84,0,171,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg'),(3320,85,0,171,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg'),(3321,86,0,171,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg'),(3322,103,0,171,'container2'),(3323,115,0,171,'phalaenopsis-plant-arrangement-in-vase'),(3324,118,0,171,'0'),(3325,130,0,171,'2'),(3332,70,18,147,'باقة كعكة عيد الميلاد'),(3333,84,18,147,'/c/a/cake_container_plast_ri9hf.jpg'),(3334,85,18,147,'/c/a/cake_container_plast_ri9hf.jpg'),(3335,86,18,147,'/c/a/cake_container_plast_ri9hf.jpg'),(3336,118,18,147,'0'),(3337,118,20,147,'0'),(3338,118,21,147,'0'),(3339,118,22,147,'0'),(3340,118,23,147,'0'),(3341,118,24,147,'0'),(3342,118,25,147,'0'),(3343,118,26,147,'0'),(3344,118,29,147,'0'),(3345,118,31,147,'0'),(3346,118,33,147,'0'),(3347,118,35,147,'0'),(3348,118,39,147,'0'),(3349,118,40,147,'0'),(3350,118,41,147,'0'),(3351,118,1,147,'0'),(3352,118,27,147,'0'),(3353,118,30,147,'0'),(3354,118,32,147,'0'),(3355,118,34,147,'0'),(3356,118,36,147,'0'),(3357,118,37,147,'0'),(3358,118,38,147,'0'),(3359,118,16,147,'0'),(3360,118,4,147,'0'),(3361,118,6,147,'0'),(3362,118,14,147,'0'),(3363,118,8,147,'0'),(3364,118,10,147,'0'),(3365,118,12,147,'0'),(3367,118,5,147,'0'),(3368,118,7,147,'0'),(3369,118,9,147,'0'),(3370,118,11,147,'0'),(3371,118,13,147,'0'),(3372,118,15,147,'0'),(3373,118,17,147,'0'),(3374,118,28,147,'0'),(3375,118,3,147,'0'),(3376,128,18,147,'/c/a/cake_container_plast_ri9hf.jpg'),(3381,70,18,167,'تنسيق الزهور في مزهرية'),(3382,84,18,167,'no_selection'),(3383,85,18,167,'no_selection'),(3384,86,18,167,'no_selection'),(3385,118,18,167,'0'),(3386,118,20,167,'0'),(3387,118,21,167,'0'),(3388,118,22,167,'0'),(3389,118,23,167,'0'),(3390,118,24,167,'0'),(3391,118,25,167,'0'),(3392,118,26,167,'0'),(3393,118,29,167,'0'),(3394,118,31,167,'0'),(3395,118,33,167,'0'),(3396,118,35,167,'0'),(3397,118,39,167,'0'),(3398,118,40,167,'0'),(3399,118,41,167,'0'),(3400,118,1,167,'0'),(3401,118,27,167,'0'),(3402,118,30,167,'0'),(3403,118,32,167,'0'),(3404,118,34,167,'0'),(3405,118,36,167,'0'),(3406,118,37,167,'0'),(3407,118,38,167,'0'),(3408,118,16,167,'0'),(3409,118,4,167,'0'),(3410,118,6,167,'0'),(3411,118,14,167,'0'),(3412,118,8,167,'0'),(3413,118,10,167,'0'),(3414,118,12,167,'0'),(3416,118,5,167,'0'),(3417,118,7,167,'0'),(3418,118,9,167,'0'),(3419,118,11,167,'0'),(3420,118,13,167,'0'),(3421,118,15,167,'0'),(3422,118,17,167,'0'),(3423,118,28,167,'0'),(3424,118,3,167,'0'),(3428,70,18,163,'باقة ربطة في مزهرية'),(3429,84,18,163,'/i/n/indeddddffx.jpg'),(3430,85,18,163,'/i/n/indeddddffx.jpg'),(3431,86,18,163,'/i/n/indeddddffx.jpg'),(3432,118,18,163,'0'),(3433,118,20,163,'0'),(3434,118,21,163,'0'),(3435,118,22,163,'0'),(3436,118,23,163,'0'),(3437,118,24,163,'0'),(3438,118,25,163,'0'),(3439,118,26,163,'0'),(3440,118,29,163,'0'),(3441,118,31,163,'0'),(3442,118,33,163,'0'),(3443,118,35,163,'0'),(3444,118,39,163,'0'),(3445,118,40,163,'0'),(3446,118,41,163,'0'),(3447,118,1,163,'0'),(3448,118,27,163,'0'),(3449,118,30,163,'0'),(3450,118,32,163,'0'),(3451,118,34,163,'0'),(3452,118,36,163,'0'),(3453,118,37,163,'0'),(3454,118,38,163,'0'),(3455,118,16,163,'0'),(3456,118,4,163,'0'),(3457,118,6,163,'0'),(3458,118,14,163,'0'),(3459,118,8,163,'0'),(3460,118,10,163,'0'),(3461,118,12,163,'0'),(3463,118,5,163,'0'),(3464,118,7,163,'0'),(3465,118,9,163,'0'),(3466,118,11,163,'0'),(3467,118,13,163,'0'),(3468,118,15,163,'0'),(3469,118,17,163,'0'),(3470,118,28,163,'0'),(3471,118,3,163,'0'),(3472,128,18,163,'/i/n/indeddddffx.jpg'),(3477,70,18,159,'باقة ربطة  في حقيبة'),(3478,84,18,159,'/i/l/il_794xn.2959121296_rw5g_1.jpg'),(3479,85,18,159,'/i/l/il_794xn.2959121296_rw5g_1.jpg'),(3480,86,18,159,'/i/l/il_794xn.2959121296_rw5g_1.jpg'),(3481,118,18,159,'0'),(3482,118,20,159,'0'),(3483,118,21,159,'0'),(3484,118,22,159,'0'),(3485,118,23,159,'0'),(3486,118,24,159,'0'),(3487,118,25,159,'0'),(3488,118,26,159,'0'),(3489,118,29,159,'0'),(3490,118,31,159,'0'),(3491,118,33,159,'0'),(3492,118,35,159,'0'),(3493,118,39,159,'0'),(3494,118,40,159,'0'),(3495,118,41,159,'0'),(3496,118,1,159,'0'),(3497,118,27,159,'0'),(3498,118,30,159,'0'),(3499,118,32,159,'0'),(3500,118,34,159,'0'),(3501,118,36,159,'0'),(3502,118,37,159,'0'),(3503,118,38,159,'0'),(3504,118,16,159,'0'),(3505,118,4,159,'0'),(3506,118,6,159,'0'),(3507,118,14,159,'0'),(3508,118,8,159,'0'),(3509,118,10,159,'0'),(3510,118,12,159,'0'),(3512,118,5,159,'0'),(3513,118,7,159,'0'),(3514,118,9,159,'0'),(3515,118,11,159,'0'),(3516,118,13,159,'0'),(3517,118,15,159,'0'),(3518,118,17,159,'0'),(3519,118,28,159,'0'),(3520,118,3,159,'0'),(3521,128,18,159,'/i/l/il_794xn.2959121296_rw5g_1.jpg'),(3526,70,18,152,'حزمة العروس'),(3527,84,18,152,'no_selection'),(3528,85,18,152,'no_selection'),(3529,86,18,152,'no_selection'),(3530,118,18,152,'0'),(3531,118,20,152,'0'),(3532,118,21,152,'0'),(3533,118,22,152,'0'),(3534,118,23,152,'0'),(3535,118,24,152,'0'),(3536,118,25,152,'0'),(3537,118,26,152,'0'),(3538,118,29,152,'0'),(3539,118,31,152,'0'),(3540,118,33,152,'0'),(3541,118,35,152,'0'),(3542,118,39,152,'0'),(3543,118,40,152,'0'),(3544,118,41,152,'0'),(3545,118,1,152,'0'),(3546,118,27,152,'0'),(3547,118,30,152,'0'),(3548,118,32,152,'0'),(3549,118,34,152,'0'),(3550,118,36,152,'0'),(3551,118,37,152,'0'),(3552,118,38,152,'0'),(3553,118,16,152,'0'),(3554,118,4,152,'0'),(3555,118,6,152,'0'),(3556,118,14,152,'0'),(3557,118,8,152,'0'),(3558,118,10,152,'0'),(3559,118,12,152,'0'),(3561,118,5,152,'0'),(3562,118,7,152,'0'),(3563,118,9,152,'0'),(3564,118,11,152,'0'),(3565,118,13,152,'0'),(3566,118,15,152,'0'),(3567,118,17,152,'0'),(3568,118,28,152,'0'),(3569,118,3,152,'0'),(3570,128,18,152,'no_selection'),(3575,70,18,171,'ترتيب نبات فالاينوبسيس في إناء'),(3576,84,18,171,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg'),(3577,85,18,171,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg'),(3578,86,18,171,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg'),(3579,118,18,171,'0'),(3580,118,20,171,'0'),(3581,118,21,171,'0'),(3582,118,22,171,'0'),(3583,118,23,171,'0'),(3584,118,24,171,'0'),(3585,118,25,171,'0'),(3586,118,26,171,'0'),(3587,118,29,171,'0'),(3588,118,31,171,'0'),(3589,118,33,171,'0'),(3590,118,35,171,'0'),(3591,118,39,171,'0'),(3592,118,40,171,'0'),(3593,118,41,171,'0'),(3594,118,1,171,'0'),(3595,118,27,171,'0'),(3596,118,30,171,'0'),(3597,118,32,171,'0'),(3598,118,34,171,'0'),(3599,118,36,171,'0'),(3600,118,37,171,'0'),(3601,118,38,171,'0'),(3602,118,16,171,'0'),(3603,118,4,171,'0'),(3604,118,6,171,'0'),(3605,118,14,171,'0'),(3606,118,8,171,'0'),(3607,118,10,171,'0'),(3608,118,12,171,'0'),(3610,118,5,171,'0'),(3611,118,7,171,'0'),(3612,118,9,171,'0'),(3613,118,11,171,'0'),(3614,118,13,171,'0'),(3615,118,15,171,'0'),(3616,118,17,171,'0'),(3617,118,28,171,'0'),(3618,118,3,171,'0'),(3623,70,0,172,'Birthday cake package-Pink hues-2 plants with 1 small green plant'),(3624,81,0,172,'Birthday cake package'),(3625,83,0,172,'Birthday cake package '),(3626,103,0,172,'container2'),(3627,115,0,172,'birthday-cake-package-pink-hues-2-plants-with-1-small-green-plant'),(3628,118,0,172,'0'),(3629,130,0,172,'0'),(3630,70,0,173,'Birthday cake package-Pink hues-3 plants with 2 small green plants'),(3631,81,0,173,'Birthday cake package'),(3632,83,0,173,'Birthday cake package '),(3633,103,0,173,'container2'),(3634,115,0,173,'birthday-cake-package-pink-hues-3-plants-with-2-small-green-plants'),(3635,118,0,173,'0'),(3636,130,0,173,'0'),(3637,70,0,174,'Birthday cake package-All White-2 plants with 1 small green plant'),(3638,81,0,174,'Birthday cake package'),(3639,83,0,174,'Birthday cake package '),(3640,103,0,174,'container2'),(3641,115,0,174,'birthday-cake-package-all-white-2-plants-with-1-small-green-plant'),(3642,118,0,174,'0'),(3643,130,0,174,'0'),(3644,70,0,175,'Birthday cake package-All White-3 plants with 2 small green plants'),(3645,81,0,175,'Birthday cake package'),(3646,83,0,175,'Birthday cake package '),(3647,103,0,175,'container2'),(3648,115,0,175,'birthday-cake-package-all-white-3-plants-with-2-small-green-plants'),(3649,118,0,175,'0'),(3650,130,0,175,'0');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_varchar_after_update AFTER UPDATE ON catalog_product_entity_varchar FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!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` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_flat_1`
--

CREATE TABLE `catalog_product_flat_1` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_1_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 1)';

--
-- Dumping data for table `catalog_product_flat_1`
--

INSERT INTO `catalog_product_flat_1` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_10`
--

CREATE TABLE `catalog_product_flat_10` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_10_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 10)';

--
-- Dumping data for table `catalog_product_flat_10`
--

INSERT INTO `catalog_product_flat_10` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_11`
--

CREATE TABLE `catalog_product_flat_11` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_11_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 11)';

--
-- Dumping data for table `catalog_product_flat_11`
--

INSERT INTO `catalog_product_flat_11` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_12`
--

CREATE TABLE `catalog_product_flat_12` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_12_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 12)';

--
-- Dumping data for table `catalog_product_flat_12`
--

INSERT INTO `catalog_product_flat_12` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_13`
--

CREATE TABLE `catalog_product_flat_13` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_13_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 13)';

--
-- Dumping data for table `catalog_product_flat_13`
--

INSERT INTO `catalog_product_flat_13` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_14`
--

CREATE TABLE `catalog_product_flat_14` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_14_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 14)';

--
-- Dumping data for table `catalog_product_flat_14`
--

INSERT INTO `catalog_product_flat_14` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_15`
--

CREATE TABLE `catalog_product_flat_15` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_15_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 15)';

--
-- Dumping data for table `catalog_product_flat_15`
--

INSERT INTO `catalog_product_flat_15` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_16`
--

CREATE TABLE `catalog_product_flat_16` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_16_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 16)';

--
-- Dumping data for table `catalog_product_flat_16`
--

INSERT INTO `catalog_product_flat_16` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
-- Table structure for table `catalog_product_flat_17`
--

CREATE TABLE `catalog_product_flat_17` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `type_id` varchar(32) NOT NULL DEFAULT 'simple' COMMENT 'Type Id',
  `birthday_cake` int(11) DEFAULT NULL COMMENT 'birthday_cake column',
  `birthday_cake_value` varchar(255) DEFAULT NULL COMMENT 'birthday_cake column',
  `cake_color` int(11) DEFAULT NULL COMMENT 'cake_color column',
  `cake_color_value` varchar(255) DEFAULT NULL COMMENT 'cake_color column',
  `cost` decimal(12,4) DEFAULT NULL COMMENT 'cost',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'created_at',
  `description` longtext COMMENT 'description',
  `featured` int(11) DEFAULT NULL COMMENT 'featured',
  `gift_message_available` smallint(6) DEFAULT NULL COMMENT 'gift_message_available column',
  `has_options` smallint(6) NOT NULL DEFAULT '0' COMMENT 'has_options',
  `image` varchar(255) DEFAULT NULL COMMENT 'image',
  `image_label` varchar(255) DEFAULT NULL COMMENT 'image_label',
  `links_exist` int(11) DEFAULT NULL COMMENT 'links_exist',
  `links_purchased_separately` int(11) DEFAULT NULL COMMENT 'links_purchased_separately',
  `links_title` varchar(255) DEFAULT NULL COMMENT 'links_title',
  `msrp` decimal(12,4) DEFAULT NULL COMMENT 'msrp',
  `msrp_display_actual_price_type` text COMMENT 'msrp_display_actual_price_type',
  `name` varchar(255) DEFAULT NULL COMMENT 'name',
  `news_from_date` datetime DEFAULT NULL COMMENT 'news_from_date',
  `news_to_date` datetime DEFAULT NULL COMMENT 'news_to_date',
  `price` decimal(12,4) DEFAULT NULL COMMENT 'price',
  `price_type` int(11) DEFAULT NULL COMMENT 'price_type',
  `price_view` int(11) DEFAULT NULL COMMENT 'Bundle Price View price_view column',
  `required_options` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'required_options',
  `short_description` longtext COMMENT 'short_description',
  `sku` varchar(64) DEFAULT NULL COMMENT 'sku',
  `sku_type` int(11) DEFAULT NULL COMMENT 'sku_type',
  `small_image` varchar(255) DEFAULT NULL COMMENT 'small_image',
  `small_image_label` varchar(255) DEFAULT NULL COMMENT 'small_image_label',
  `special_from_date` datetime DEFAULT NULL COMMENT 'special_from_date',
  `special_price` decimal(12,4) DEFAULT NULL COMMENT 'special_price',
  `special_to_date` datetime DEFAULT NULL COMMENT 'special_to_date',
  `swatch_image` varchar(255) DEFAULT NULL COMMENT 'swatch_image',
  `tax_class_id` int(10) unsigned DEFAULT NULL COMMENT 'tax_class_id tax column',
  `thumbnail` varchar(255) DEFAULT NULL COMMENT 'thumbnail',
  `thumbnail_label` varchar(255) DEFAULT NULL COMMENT 'thumbnail_label',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'updated_at',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'url_key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'url_path',
  `visibility` smallint(5) unsigned DEFAULT NULL COMMENT 'Catalog Product Visibility visibility column',
  `weight` decimal(12,4) DEFAULT NULL COMMENT 'weight',
  `weight_type` int(11) DEFAULT NULL COMMENT 'weight_type',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_TYPE_ID` (`type_id`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_ATTRIBUTE_SET_ID` (`attribute_set_id`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_BIRTHDAY_CAKE` (`birthday_cake`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_BIRTHDAY_CAKE_VALUE` (`birthday_cake_value`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_CAKE_COLOR` (`cake_color`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_CAKE_COLOR_VALUE` (`cake_color_value`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_NAME` (`name`),
  KEY `CATALOG_PRODUCT_FLAT_17_TMP_INDEXER_PRICE` (`price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Flat (Store 17)';

--
-- Dumping data for table `catalog_product_flat_17`
--

INSERT INTO `catalog_product_flat_17` VALUES (147,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-22 20:25:23',NULL,1,2,1,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package','2021-08-15 00:00:00','2021-08-31 00:00:00',NULL,NULL,NULL,1,'<ol>\r\n<li>Birthday cake (vanilla or chocolate flavor)</li>\r\n<li>Large balloon 80 cm (white or pink color)</li>\r\n<li>Flowers white or pink shades (type of flower based on availability)</li>\r\n<li>Size of cake box 28 cm square with height 16 cm</li>\r\n<li>Length of flower garland 70 – 80 cm</li>\r\n</ol>','Birthdaycakepackage',NULL,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,NULL,NULL,NULL,'/c/a/cake_container_plast_ri9hf.jpg',2,'/c/a/cake_container_plast_ri9hf_1.jpg',NULL,'2021-08-26 08:01:51','birthdaycakepackage',NULL,4,NULL,NULL),(148,4,'simple',5475,'vanilla',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:03:55','birthday-cake-package-vanilla-white',NULL,1,NULL,NULL),(149,4,'simple',5475,'vanilla',5478,'pink',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-vanilla-pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-vanilla-pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-vanilla-pink',NULL,1,NULL,NULL),(150,4,'simple',5476,'chocolate ',5477,'white',NULL,'2021-08-22 20:26:53',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -white',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -white',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-white',NULL,1,NULL,NULL),(151,4,'simple',5476,'chocolate ',5478,'pink',NULL,'2021-08-22 20:26:54',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'0','Birthday cake package-chocolate -pink',NULL,NULL,55.0000,NULL,NULL,0,NULL,'Birthdaycakepackage-chocolate -pink',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','birthday-cake-package-chocolate-pink',NULL,1,NULL,NULL),(152,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:28:13',NULL,1,2,0,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Bridal shower package ','2021-08-01 00:00:00',NULL,80.0000,NULL,NULL,0,'<ol>\r\n<li>Vanilla infused cream cake</li>\r\n<li>Size of cake box width 27 cm x height 35 cm</li>\r\n<li>Flower arrangement (color based on availability and customer request)</li>\r\n</ol>','Bridalshowerpackage',NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,NULL,NULL,NULL,'/d/a/david_holifield_44ig_d1nji_1.jpg',2,'/d/a/david_holifield_44ig_d1nji_1.jpg',NULL,'2021-08-26 08:01:40','bridal-shower-package',NULL,4,NULL,NULL),(153,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(154,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-All White-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'All White-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-all-white-large-50-cm-diameter',NULL,1,NULL,NULL),(155,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:42',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,35.0000,NULL,NULL,0,NULL,'Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(156,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Pink hues-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,55.0000,NULL,NULL,0,NULL,'Pink hues-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-pink-hues-large-50-cm-diameter',NULL,1,NULL,NULL),(157,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,40.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(158,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in bag-Special of the day (mix)-Large (50 cm diameter)','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'Special of the day (mix)-Large (50 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-bag-special-of-the-day-mix-large-50-cm-diameter',NULL,1,NULL,NULL),(159,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 07:56:43',NULL,1,2,1,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in bag','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Handtiebouquetinbag',NULL,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,NULL,NULL,NULL,'/i/l/il_794xn.2959121296_rw5g_1.jpg',2,'/i/l/il_794xn.2959121296_rw5g_1_1.jpg',NULL,'2021-08-26 08:01:30','handtiebouquetinbag',NULL,4,NULL,NULL),(160,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:38',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-All White-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-All White-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-all-white-medium-30-cm-diameter',NULL,1,NULL,NULL),(161,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Pink hues-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase-Pink hues-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-pink-hues-medium-30-cm-diameter',NULL,1,NULL,NULL),(162,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Hand tie bouquet in vase-Special of the day (mix)-Medium (30 cm diameter)','2021-08-22 00:00:00',NULL,50.0000,NULL,NULL,0,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','invase-Special of the day (mix)-Medium (30 cm diameter)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','hand-tie-bouquet-in-vase-special-of-the-day-mix-medium-30-cm-diameter',NULL,1,NULL,NULL),(163,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:08:39',NULL,1,2,1,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Hand tie bouquet in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 20 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 35 – 40 cm</p>','Handtiebouquetinvase',NULL,'/i/n/indeddddffx_1.jpg',NULL,NULL,NULL,NULL,'/i/n/indeddddffx.jpg',2,'/i/n/indeddddffx_1.jpg',NULL,'2021-08-26 08:01:20','handtiebouquetinvase',NULL,4,NULL,NULL),(164,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:53',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-All White','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-All White',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-all-white',NULL,1,NULL,NULL),(165,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Pink hues','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Pink hues',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-pink-hues',NULL,1,NULL,NULL),(166,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Flower arrangement in vase-Special of the day (mix)','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase-Special of the day (mix)',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','flower-arrangement-in-vase-special-of-the-day-mix',NULL,1,NULL,NULL),(167,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:17:54',NULL,0,2,1,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,'0','Flower arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,'<p>Vase height 24 cm and diameter 18 cm</p>\r\n<p>Height of vase with flowers 55 – 60 cm</p>','Flower arrangement in vase',NULL,'/i/n/ingkgkdex_1.jpg',NULL,NULL,NULL,NULL,NULL,2,'/i/n/ingkgkdex_1.jpg',NULL,'2021-08-26 08:00:43','flower-arrangement-in-vase',NULL,4,NULL,NULL),(168,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:03',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-2 plants with 1 small green plant','2021-08-22 00:00:00',NULL,60.0000,NULL,NULL,0,NULL,'pa2 plants with 1 small green plant',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-2-plants-with-1-small-green-plant',NULL,1,NULL,NULL),(169,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-3 plants with 2 small green plants','2021-08-22 00:00:00',NULL,80.0000,NULL,NULL,0,NULL,'pa3 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-3-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(170,4,'simple',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,0,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Phalaenopsis plant arrangement in vase-4 plants with 2 small green plants','2021-08-22 00:00:00',NULL,100.0000,NULL,NULL,0,NULL,'pa4 plants with 2 small green plants',NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL,NULL,'2021-08-24 21:04:17','phalaenopsis-plant-arrangement-in-vase-4-plants-with-2-small-green-plants',NULL,1,NULL,NULL),(171,4,'configurable',NULL,NULL,NULL,NULL,NULL,'2021-08-23 08:25:04',NULL,1,2,1,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,'0','Phalaenopsis plant arrangement in vase','2021-08-22 00:00:00',NULL,NULL,NULL,NULL,1,NULL,'Phalaenopsisplantarrangementinvase',NULL,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,NULL,NULL,NULL,NULL,2,'/1/3/1300b9b72caeff092a5a4fbe9d934ba7.jpg',NULL,'2021-08-24 20:07:31','phalaenopsis-plant-arrangement-in-vase',NULL,4,NULL,NULL);

--
