--
-- Host: localhost    Database: vickogr_vicko
-- ------------------------------------------------------


--
-- Table structure for table `admin_analytics_usage_version_log`
--

CREATE TABLE `admin_analytics_usage_version_log` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `last_viewed_in_version` varchar(50) NOT NULL COMMENT 'Viewer last viewed on product version',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ADMIN_ANALYTICS_USAGE_VERSION_LOG_LAST_VIEWED_IN_VERSION` (`last_viewed_in_version`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Admin Notification Viewer Log Table';

--
-- Dumping data for table `admin_analytics_usage_version_log`
--

INSERT INTO `admin_analytics_usage_version_log` (`id`, `last_viewed_in_version`) VALUES (1,'2.3.4');

--
-- Table structure for table `admin_system_messages`
--

CREATE TABLE `admin_system_messages` (
  `identity` varchar(100) NOT NULL COMMENT 'Message ID',
  `severity` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Problem type',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Create date',
  PRIMARY KEY (`identity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Admin System Messages';

--
-- Dumping data for table `admin_system_messages`
--


--
-- Table structure for table `adminnotification_inbox`
--

CREATE TABLE `adminnotification_inbox` (
  `notification_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Notification ID',
  `severity` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Problem type',
  `date_added` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Create date',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `description` text DEFAULT NULL COMMENT 'Description',
  `url` varchar(255) DEFAULT NULL COMMENT 'Url',
  `is_read` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Flag if notification read',
  `is_remove` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Flag if notification might be removed',
  PRIMARY KEY (`notification_id`),
  KEY `ADMINNOTIFICATION_INBOX_SEVERITY` (`severity`),
  KEY `ADMINNOTIFICATION_INBOX_IS_READ` (`is_read`),
  KEY `ADMINNOTIFICATION_INBOX_IS_REMOVE` (`is_remove`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COMMENT='Adminnotification Inbox';

--
-- Dumping data for table `adminnotification_inbox`
--

INSERT INTO `adminnotification_inbox` (`notification_id`, `severity`, `date_added`, `title`, `description`, `url`, `is_read`, `is_remove`) VALUES (1,4,'2019-05-09 10:47:27','Deprecation Notice','Catalog Search is currently configured to use the MySQL engine, which has been deprecated. Consider migrating to one of\nthe Elasticsearch engines now to ensure there are no service interruptions during your next upgrade.','',1,1),(2,4,'2019-06-03 19:54:35','Drive cart conversion and revenue with Magento Shipping','Provide the shipping and pickup options required to compete. Meet customer expectations, drive conversion, increase revenue, and lower abandonment. Learn more: http://bit.ly/2DtWitd','http://bit.ly/2DtWitd',1,1),(3,1,'2019-06-25 16:09:17','Important Security and Performance Updates Released in Magento 2.3.2','The latest releases of Magento include important security enhancements along with performance and productivity improvements. We strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements and information on security updates included in these versions of Magento at our Security Center: https://magento.com/security/','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',1,1),(4,4,'2019-08-27 14:06:49','Breaking news! Adobe (Magento) is recognized by Gartner as a Leader based on Magento Commerce in the 2019 Magic Quadrant for Digital Commerce. ','Learn why Magento Commerce is a Leader for a third year in a row and continues to move because of our ability to execute. Read the full report: http://bit.ly/2Zj3CVs','http://bit.ly/2Zj3CVs',1,1),(5,4,'2019-10-01 16:15:34','It’s time to take your operations in a new direction by diversifying your revenue streams. ','We’ve got five ways you can effortlessly boost sales while reaching a wider audience. Download this informative guide and start fast-tracking your revenue growth today. Link: http://bit.ly/2m6svAN','http://bit.ly/2m6svAN',1,1),(6,4,'2019-10-08 18:50:49','It’s time to get your digital business out of the slow lane. ','Accelerate your revenue growth and drive customer satisfaction with these 5 must-have eCommerce features. Download this informative guide: http://bit.ly/2lLFOX6','http://bit.ly/2lLFOX6',1,1),(7,4,'2019-12-09 18:08:56','Online B2B purchases are set to skyrocket to $9 trillion in the US alone this year. Get in on the action with B2B and B2C selling.','The lines between B2B and B2C commerce are blurring. Here’s 5 reasons to go hybrid with your commerce strategy in 2020. http://bit.ly/2DPgAx0','http://bit.ly/2DPgAx0',1,1),(8,4,'2019-12-16 18:39:06','Did you know? A whopping 89% of B2B businesses now rely on digital content to guide their purchasing process.','Learn how you can integrate compelling content into your B2B sales strategy with our latest eBook. Download Now: http://bit.ly/368QIbu','http://bit.ly/368QIbu',1,1),(9,4,'2020-01-02 18:26:08','Are you set up to achieve your eCommerce goals? Make upgrading your resolution for 2020.','Upgrading to Magento Commerce might cost less than you think. Watch our webinar to learn the true cost savings of upgrading to Magento Commerce 2. Watch Now: http://bit.ly/2BcYK5A','http://bit.ly/2BcYK5A',1,1),(10,4,'2020-01-13 18:02:52','eCommerce is an ocean of opportunity. Take our quiz and find out if you are a pilot fish, octopus, or shark.','Find out if you’re ready to sell with the big fish by taking our brief quiz designed to identify your competitive selling potential. Answer our set of quick questions to see where you stack up and receive personalized resources to give your digital growth strategy some teeth. http://bit.ly/2NkNvhS','http://bit.ly/2NkNvhS',1,1),(11,4,'2020-01-27 16:01:40','Learn The 6 Sweet Features Behind Every Irresistible eCommerce Experience. ','92% percent of online shoppers call it quits before checkout over poor site performance. Discover the six essential features your commerce platform needs to create truly memorable customer moments. Link here: http://bit.ly/2RrcS4d\n','http://bit.ly/2RrcS4d',1,1),(12,1,'2020-01-28 20:09:22','Magento Open Source 2.3.4 delivers important security updates and features to help you build a more engaging customer experience – 1/28/2020','The latest releases of Magento Open Source – 2.3.4, 2.3.3-p1, and 2.2.11 – are now generally available. The latest release of Magento Open Source includes important security enhancements along with new functionality and platform quality improvements. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements. Learn how this release can help you build a more engaging customer experience at Magento.com/blog.','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',1,1),(13,4,'2020-02-03 19:53:41','You are invited: Seize the New Year– 5 Growth Strategies for 2020.','Join us for a live webinar on February 13th with Magento experts Shannon Hane and Matthew Wasley from Adobe to learn the latest eCommerce strategies to accelerate revenue growth in 2020. Register today: http://bit.ly/2GPpb4b','http://bit.ly/2GPpb4b',1,1),(14,4,'2020-02-10 16:41:26','Are you putting off integrating your ERP and eCommerce?','Get started on the journey to a more integrated and profitable eCommerce business. Download our comprehensive guide, eCommerce + ERP: Better Together. http://bit.ly/33XMHVV','http://bit.ly/33XMHVV',1,1),(15,4,'2020-02-12 15:11:23','Join Tomorrow\'s Webinar: Seize the New Year– 5 Growth Strategies for 2020.','Join us for a live webinar tomorrow, February 13th with Magento experts Shannon Hane and Matthew Wasley from Adobe to learn the latest eCommerce strategies to accelerate revenue growth in 2020. Register today: http://bit.ly/2GPpb4b','http://bit.ly/2GPpb4b',1,1),(16,4,'2020-02-28 14:39:26','2020 goal: Is your product content keeping up with your customers?','Magento Page Builder gives you fast content updates and even faster growth. Download our eBook to learn more. Link here: http://bit.ly/2NyTuQf','http://bit.ly/2NyTuQf',1,1),(17,1,'2020-03-05 21:25:23','Retrieving data. Wait a few seconds and try to cut or copy again.','&quot;We have discovered an error in Magento 2.3.4 that can prevent a shopper from completing an order when using PayPal Express Checkout. The issue occurs for any country where the region field in the address section is a text field (as opposed to a drop-down menu).\nWe have released a hotfix to resolve this issue and recommend that merchants on Magento version 2.3.4 who are also using PayPal Express Checkout download and apply this hotfix as soon as possible to prevent further errors. Please refer to our help center for instructions and troubleshooting. A fix for this issue will be included in Magento 2.3.5.','https://support.magento.com/hc/en-us/articles/360039451972',1,1),(18,4,'2019-09-02 00:00:00','Big sale on Vietnam Independence Day','20% off on all extensions from Sep 02 - 04. Grab your deals now! Happy Independence Day xxx','https://www.mageplaza.com/magento-2-extensions/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale',1,1),(19,4,'2019-09-30 00:00:00','Flash sale - TODAY only','15% off on all extensions TODAY ONLY (Sep 30). Find your extensions now','https://www.mageplaza.com/magento-2-extensions/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale',1,1),(20,4,'2019-09-30 00:00:00','BLACK FRIDAY CYBER WEEK SUPER SALES','Up to 30% off on ALL extensions PLUS up to 15% off when buying from 2 modules. Check it out NOW.','https://www.mageplaza.com/magento-2-extensions/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale',1,1),(21,4,'2019-12-11 00:00:00','Last chance 2019','30% ALL extensions on everything. Check it out NOW.','https://www.mageplaza.com/magento-2-extensions/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale-12',1,1),(22,4,'2019-12-11 00:00:00','Holiday Announcement &amp; Christmas sale','Some important notes about holiday supports and Christmas sales in 3 days. Read more here','https://www.mageplaza.com/blog/holiday-announcement.html/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale-12',1,1),(23,4,'2020-01-14 00:00:00','Releases &amp; updates in 2019 December on Mageplaza','15 hot releases and 33 important updates last month. Read more here','https://www.mageplaza.com/blog/releases-2019-12/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale-12',1,1),(24,4,'2020-03-16 00:00:00','St. Patrick\'s Day Sale Announcement','20% discount on every extension is on NOW. Ends on March 18th, don\'t miss out','https://www.mageplaza.com/deals/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale-12',1,1),(25,4,'2020-03-18 06:00:00',' Important WeltPixel Product Updates - March 2020 ','Hope you and your loved ones are safe during this period. We want to announce that all WeltPixel Products received updates recently! As usual, your feedback translates into our latest product updates. Get your updates from the Downloadable Products section of your weltpixel.com account.','https://support.weltpixel.com/hc/en-us/articles/115002963573-WeltPixel-Product-Updates-Change-Log-and-New-Releases?utm_source=Admin&amp;utm_medium=Notifications&amp;utm_campaign=Release1.9.5',1,1),(26,4,'2020-03-23 14:26:27','Disable Notice','To improve performance, collecting statistics for the Magento Report module is disabled by default. \nYou can enable it in System Config.','',1,1),(27,4,'2020-02-12 15:11:23','Join Tomorrow&#039;s Webinar: Seize the New Year– 5 Growth Strategies for 2020.','Join us for a live webinar tomorrow, February 13th with Magento experts Shannon Hane and Matthew Wasley from Adobe to learn the latest eCommerce strategies to accelerate revenue growth in 2020. Register today: http://bit.ly/2GPpb4b','http://bit.ly/2GPpb4b',1,1),(28,4,'2020-03-16 00:00:00','St. Patrick&#039;s Day Sale Announcement','20% discount on every extension is on NOW. Ends on March 18th, don&#039;t miss out','https://www.mageplaza.com/deals/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale-12',1,1),(29,4,'2020-03-25 00:00:00','COVID-19 Mageplaza Support Campaign','25% discount on all extensions for young business during the coronavirus pandemic. Check it out','https://www.mageplaza.com/blog/covid-mageplaza-support-young-ebusiness-during-pandemic.html?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=sale-12',1,0);

--
-- Table structure for table `adobe_stock_asset`
--

CREATE TABLE `adobe_stock_asset` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `media_gallery_id` int(10) unsigned DEFAULT NULL COMMENT 'Media gallery ID',
  `category_id` int(10) unsigned DEFAULT NULL COMMENT 'Category ID',
  `creator_id` int(10) unsigned DEFAULT NULL COMMENT 'Creator ID',
  `is_licensed` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Licensed',
  `creation_date` varchar(255) DEFAULT NULL COMMENT 'Creation Date',
  PRIMARY KEY (`id`),
  KEY `ADOBE_STOCK_ASSET_MEDIA_GALLERY_ID_MEDIA_GALLERY_ASSET_ID` (`media_gallery_id`),
  KEY `ADOBE_STOCK_ASSET_ID` (`id`),
  KEY `ADOBE_STOCK_ASSET_CATEGORY_ID` (`category_id`),
  KEY `ADOBE_STOCK_ASSET_CREATOR_ID` (`creator_id`),
  CONSTRAINT `ADOBE_STOCK_ASSET_CATEGORY_ID_ADOBE_STOCK_CATEGORY_ID` FOREIGN KEY (`category_id`) REFERENCES `adobe_stock_category` (`id`) ON DELETE SET NULL,
  CONSTRAINT `ADOBE_STOCK_ASSET_CREATOR_ID_ADOBE_STOCK_CREATOR_ID` FOREIGN KEY (`creator_id`) REFERENCES `adobe_stock_creator` (`id`) ON DELETE SET NULL,
  CONSTRAINT `ADOBE_STOCK_ASSET_MEDIA_GALLERY_ID_MEDIA_GALLERY_ASSET_ID` FOREIGN KEY (`media_gallery_id`) REFERENCES `media_gallery_asset` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Adobe Stock Asset';

--
-- Dumping data for table `adobe_stock_asset`
--


--
-- Table structure for table `adobe_stock_category`
--

CREATE TABLE `adobe_stock_category` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  PRIMARY KEY (`id`),
  KEY `ADOBE_STOCK_CATEGORY_ID` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Adobe Stock Category';

--
-- Dumping data for table `adobe_stock_category`
--


--
-- Table structure for table `adobe_stock_creator`
--

CREATE TABLE `adobe_stock_creator` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Asset creator''s name',
  PRIMARY KEY (`id`),
  KEY `ADOBE_STOCK_CREATOR_ID` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Adobe Stock Creator';

--
-- Dumping data for table `adobe_stock_creator`
--


--
-- Table structure for table `adobe_user_profile`
--

CREATE TABLE `adobe_user_profile` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `admin_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Admin User Id',
  `name` varchar(255) NOT NULL COMMENT 'Display Name',
  `email` varchar(255) NOT NULL COMMENT 'user profile email',
  `image` varchar(255) NOT NULL COMMENT 'user profile avatar',
  `account_type` varchar(255) DEFAULT NULL COMMENT 'Account Type',
  `access_token` text DEFAULT NULL COMMENT 'Access Token',
  `refresh_token` text DEFAULT NULL COMMENT 'Refresh Token',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp() COMMENT 'Updated At',
  `access_token_expires_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Access Token Expires At',
  PRIMARY KEY (`id`),
  KEY `ADOBE_USER_PROFILE_ADMIN_USER_ID_ADMIN_USER_USER_ID` (`admin_user_id`),
  KEY `ADOBE_USER_PROFILE_ID` (`id`),
  CONSTRAINT `ADOBE_USER_PROFILE_ADMIN_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Adobe IMS User Profile';

--
-- Dumping data for table `adobe_user_profile`
--


--
-- Table structure for table `authorization_role`
--

CREATE TABLE `authorization_role` (
  `role_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Role ID',
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Parent Role ID',
  `tree_level` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Role Tree Level',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Role Sort Order',
  `role_type` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Role Type',
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'User ID',
  `user_type` varchar(16) DEFAULT NULL COMMENT 'User Type',
  `role_name` varchar(50) DEFAULT NULL COMMENT 'Role Name',
  PRIMARY KEY (`role_id`),
  KEY `AUTHORIZATION_ROLE_PARENT_ID_SORT_ORDER` (`parent_id`,`sort_order`),
  KEY `AUTHORIZATION_ROLE_TREE_LEVEL` (`tree_level`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COMMENT='Admin Role Table';

--
-- Dumping data for table `authorization_role`
--

INSERT INTO `authorization_role` (`role_id`, `parent_id`, `tree_level`, `sort_order`, `role_type`, `user_id`, `user_type`, `role_name`) VALUES (1,0,1,1,'G',0,'2','Administrators'),(2,1,2,0,'U',1,'2','sofia'),(3,1,2,0,'U',2,'2','jason'),(5,1,2,0,'U',3,'2','design'),(6,0,1,0,'U',1,'1','11'),(7,1,2,0,'U',4,'2','George');

--
-- Table structure for table `authorization_rule`
--

CREATE TABLE `authorization_rule` (
  `rule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule ID',
  `role_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Role ID',
  `resource_id` varchar(255) DEFAULT NULL COMMENT 'Resource ID',
  `privileges` varchar(20) DEFAULT NULL COMMENT 'Privileges',
  `permission` varchar(10) DEFAULT NULL COMMENT 'Permission',
  PRIMARY KEY (`rule_id`),
  KEY `AUTHORIZATION_RULE_RESOURCE_ID_ROLE_ID` (`resource_id`,`role_id`),
  KEY `AUTHORIZATION_RULE_ROLE_ID_RESOURCE_ID` (`role_id`,`resource_id`),
  CONSTRAINT `AUTHORIZATION_RULE_ROLE_ID_AUTHORIZATION_ROLE_ROLE_ID` FOREIGN KEY (`role_id`) REFERENCES `authorization_role` (`role_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=626 DEFAULT CHARSET=utf8 COMMENT='Admin Rule Table';

--
-- Dumping data for table `authorization_rule`
--

INSERT INTO `authorization_rule` (`rule_id`, `role_id`, `resource_id`, `privileges`, `permission`) VALUES (1,1,'Magento_Backend::all',NULL,'allow'),(314,6,'Magento_Backend::all',NULL,'deny'),(315,6,'Magento_Backend::admin',NULL,'allow'),(316,6,'Magento_Backend::dashboard',NULL,'deny'),(317,6,'Magento_Analytics::analytics',NULL,'allow'),(318,6,'Magento_Analytics::analytics_api',NULL,'allow'),(319,6,'Magento_Sales::sales',NULL,'deny'),(320,6,'Magento_Sales::sales_operation',NULL,'deny'),(321,6,'Magento_Sales::sales_order',NULL,'deny'),(322,6,'Magento_Sales::actions',NULL,'deny'),(323,6,'Magento_Sales::create',NULL,'deny'),(324,6,'Magento_Sales::actions_view',NULL,'deny'),(325,6,'Magento_Sales::email',NULL,'deny'),(326,6,'Magento_Sales::reorder',NULL,'deny'),(327,6,'Magento_Sales::actions_edit',NULL,'deny'),(328,6,'Magento_Sales::cancel',NULL,'deny'),(329,6,'Magento_Sales::review_payment',NULL,'deny'),(330,6,'Magento_Sales::capture',NULL,'deny'),(331,6,'Magento_Sales::invoice',NULL,'deny'),(332,6,'Magento_Sales::creditmemo',NULL,'deny'),(333,6,'Magento_Sales::hold',NULL,'deny'),(334,6,'Magento_Sales::unhold',NULL,'deny'),(335,6,'Magento_Sales::ship',NULL,'deny'),(336,6,'Magento_Sales::comment',NULL,'deny'),(337,6,'Magento_Sales::emails',NULL,'deny'),(338,6,'Magento_Paypal::authorization',NULL,'deny'),(339,6,'Magento_Sales::sales_invoice',NULL,'deny'),(340,6,'Magento_Sales::shipment',NULL,'deny'),(341,6,'Temando_Shipping::dispatches',NULL,'deny'),(342,6,'Temando_Shipping::pickups',NULL,'deny'),(343,6,'Temando_Shipping::batches',NULL,'deny'),(344,6,'Magento_Sales::sales_creditmemo',NULL,'deny'),(345,6,'Magento_Paypal::billing_agreement',NULL,'deny'),(346,6,'Magento_Paypal::billing_agreement_actions',NULL,'deny'),(347,6,'Magento_Paypal::billing_agreement_actions_view',NULL,'deny'),(348,6,'Magento_Paypal::actions_manage',NULL,'deny'),(349,6,'Magento_Paypal::use',NULL,'deny'),(350,6,'Magento_Sales::transactions',NULL,'deny'),(351,6,'Magento_Sales::transactions_fetch',NULL,'deny'),(352,6,'Magento_Catalog::catalog',NULL,'deny'),(353,6,'Magento_Catalog::catalog_inventory',NULL,'deny'),(354,6,'Magento_Catalog::products',NULL,'deny'),(355,6,'Magento_Catalog::update_attributes',NULL,'deny'),(356,6,'Magento_Catalog::edit_product_design',NULL,'deny'),(357,6,'Magento_Catalog::categories',NULL,'deny'),(358,6,'Magento_Catalog::edit_category_design',NULL,'deny'),(359,6,'Magento_Customer::customer',NULL,'deny'),(360,6,'Magento_Customer::manage',NULL,'deny'),(361,6,'Magento_Customer::actions',NULL,'deny'),(362,6,'Magento_Customer::delete',NULL,'deny'),(363,6,'Magento_Customer::reset_password',NULL,'deny'),(364,6,'Magento_Customer::invalidate_tokens',NULL,'deny'),(365,6,'Magento_Customer::online',NULL,'deny'),(366,6,'Magento_Customer::group',NULL,'deny'),(367,6,'Magento_Cart::cart',NULL,'deny'),(368,6,'Magento_Cart::manage',NULL,'deny'),(369,6,'Magento_Backend::myaccount',NULL,'deny'),(370,6,'Magento_Backend::marketing',NULL,'deny'),(371,6,'Magento_CatalogRule::promo',NULL,'deny'),(372,6,'Magento_CatalogRule::promo_catalog',NULL,'deny'),(373,6,'Magento_SalesRule::quote',NULL,'deny'),(374,6,'Dotdigitalgroup_Email::automation',NULL,'deny'),(375,6,'Dotdigitalgroup_Email::automation_studio',NULL,'deny'),(376,6,'Dotdigitalgroup_Email::exclusion_rules',NULL,'deny'),(377,6,'Magento_Backend::marketing_communications',NULL,'deny'),(378,6,'Magento_Email::template',NULL,'deny'),(379,6,'Dotdigitalgroup_Chat::iframe',NULL,'deny'),(380,6,'Magento_Newsletter::template',NULL,'deny'),(381,6,'Magento_Newsletter::queue',NULL,'deny'),(382,6,'Magento_Newsletter::subscriber',NULL,'deny'),(383,6,'Magento_GoogleShoppingAds::scconnector',NULL,'deny'),(384,6,'Magento_GoogleShoppingAds::scconnector_google',NULL,'deny'),(385,6,'Magento_Backend::marketing_seo',NULL,'deny'),(386,6,'Magento_Search::search',NULL,'deny'),(387,6,'Magento_Search::synonyms',NULL,'deny'),(388,6,'Magento_UrlRewrite::urlrewrite',NULL,'deny'),(389,6,'Magento_Sitemap::sitemap',NULL,'deny'),(390,6,'Magento_Backend::marketing_user_content',NULL,'deny'),(391,6,'Magento_Review::reviews_all',NULL,'deny'),(392,6,'Magento_Review::pending',NULL,'deny'),(393,6,'Yotpo_Yotpo::yotpo_report_reviews',NULL,'deny'),(394,6,'Mageplaza_Core::menu',NULL,'deny'),(395,6,'Mageplaza_Core::documentation',NULL,'deny'),(396,6,'Mageplaza_Core::userguide',NULL,'deny'),(397,6,'Mageplaza_Core::activate',NULL,'deny'),(398,6,'Magento_Backend::content',NULL,'deny'),(399,6,'Magento_Backend::content_elements',NULL,'deny'),(400,6,'Magento_Cms::page',NULL,'deny'),(401,6,'Magento_Cms::save',NULL,'deny'),(402,6,'Magento_Cms::save_design',NULL,'deny'),(403,6,'Magento_Cms::page_delete',NULL,'deny'),(404,6,'Magento_Cms::block',NULL,'deny'),(405,6,'Magento_Widget::widget_instance',NULL,'deny'),(406,6,'Magento_Cms::media_gallery',NULL,'deny'),(407,6,'Magento_AdobeStockImageAdminUi::media_gallery',NULL,'deny'),(408,6,'Magento_AdobeStockImageAdminUi::save_preview_images',NULL,'deny'),(409,6,'Magento_AdobeStockImageAdminUi::license_images',NULL,'deny'),(410,6,'Magento_Backend::design',NULL,'deny'),(411,6,'Magento_Theme::theme',NULL,'deny'),(412,6,'Magento_Backend::schedule',NULL,'deny'),(413,6,'Magento_Backend::content_translation',NULL,'deny'),(414,6,'Magento_Reports::report',NULL,'deny'),(415,6,'Dotdigitalgroup_Email::reports',NULL,'deny'),(416,6,'Dotdigitalgroup_Email::contact',NULL,'deny'),(417,6,'Dotdigitalgroup_Email::order',NULL,'deny'),(418,6,'Dotdigitalgroup_Email::review',NULL,'deny'),(419,6,'Dotdigitalgroup_Email::wishlist',NULL,'deny'),(420,6,'Dotdigitalgroup_Email::catalog',NULL,'deny'),(421,6,'Dotdigitalgroup_Email::importer',NULL,'deny'),(422,6,'Dotdigitalgroup_Email::campaign',NULL,'deny'),(423,6,'Dotdigitalgroup_Email::cron',NULL,'deny'),(424,6,'Dotdigitalgroup_Email::dashboard',NULL,'deny'),(425,6,'Dotdigitalgroup_Email::automation_enrollment',NULL,'deny'),(426,6,'Dotdigitalgroup_Email::logviewer',NULL,'deny'),(427,6,'Dotdigitalgroup_Email::abandoned',NULL,'deny'),(428,6,'Magento_Reports::report_marketing',NULL,'deny'),(429,6,'Magento_Reports::shopcart',NULL,'deny'),(430,6,'Magento_Reports::product',NULL,'deny'),(431,6,'Magento_Reports::abandoned',NULL,'deny'),(432,6,'Magento_Reports::report_search',NULL,'deny'),(433,6,'Magento_Newsletter::problem',NULL,'deny'),(434,6,'Magento_Reports::review',NULL,'deny'),(435,6,'Magento_Reports::review_customer',NULL,'deny'),(436,6,'Magento_Reports::review_product',NULL,'deny'),(437,6,'Yotpo_Yotpo::yotpo_reviews_external',NULL,'deny'),(438,6,'Magento_Reports::salesroot',NULL,'deny'),(439,6,'Magento_Reports::salesroot_sales',NULL,'deny'),(440,6,'Magento_Reports::tax',NULL,'deny'),(441,6,'Magento_Reports::invoiced',NULL,'deny'),(442,6,'Magento_Reports::shipping',NULL,'deny'),(443,6,'Magento_Reports::refunded',NULL,'deny'),(444,6,'Magento_Reports::coupons',NULL,'deny'),(445,6,'Magento_Paypal::paypal_settlement_reports',NULL,'deny'),(446,6,'Magento_Paypal::paypal_settlement_reports_view',NULL,'deny'),(447,6,'Magento_Paypal::fetch',NULL,'deny'),(448,6,'Magento_Reports::customers',NULL,'deny'),(449,6,'Magento_Reports::totals',NULL,'deny'),(450,6,'Magento_Reports::customers_orders',NULL,'deny'),(451,6,'Magento_Reports::accounts',NULL,'deny'),(452,6,'Magento_Reports::report_products',NULL,'deny'),(453,6,'Magento_Reports::viewed',NULL,'deny'),(454,6,'Magento_Reports::bestsellers',NULL,'deny'),(455,6,'Magento_Reports::lowstock',NULL,'deny'),(456,6,'Magento_Reports::sold',NULL,'deny'),(457,6,'Magento_Reports::downloads',NULL,'deny'),(458,6,'Magento_Reports::statistics',NULL,'deny'),(459,6,'Magento_Reports::statistics_refresh',NULL,'deny'),(460,6,'Magento_Analytics::business_intelligence',NULL,'deny'),(461,6,'Magento_Analytics::advanced_reporting',NULL,'deny'),(462,6,'Magento_Analytics::bi_essentials',NULL,'deny'),(463,6,'Yotpo_Yotpo::yotpo_analytics_external',NULL,'deny'),(464,6,'Magento_Backend::stores',NULL,'deny'),(465,6,'Magento_Backend::stores_settings',NULL,'deny'),(466,6,'Magento_Backend::store',NULL,'deny'),(467,6,'Magento_Config::config',NULL,'deny'),(468,6,'Magento_Newsletter::newsletter',NULL,'deny'),(469,6,'Magento_Cms::config_cms',NULL,'deny'),(470,6,'Dotdigitalgroup_Email::config',NULL,'deny'),(471,6,'Magento_GoogleAnalytics::google',NULL,'deny'),(472,6,'Magento_Downloadable::downloadable',NULL,'deny'),(473,6,'Magento_Contact::contact',NULL,'deny'),(474,6,'Magento_Payment::payment_services',NULL,'deny'),(475,6,'Magento_Payment::payment',NULL,'deny'),(476,6,'Magento_Catalog::config_catalog',NULL,'deny'),(477,6,'Magento_CatalogSearch::config_catalog_search',NULL,'deny'),(478,6,'Magento_CatalogInventory::cataloginventory',NULL,'deny'),(479,6,'WeltPixel_Backend::DocumentationSettings',NULL,'deny'),(480,6,'KiwiCommerce_CronScheduler::cronscheduler_configuration',NULL,'deny'),(481,6,'WeltPixel_OwlCarouselSlider::owlcarouselslider_settings',NULL,'deny'),(482,6,'Magento_Shipping::shipping_policy',NULL,'deny'),(483,6,'Magento_Shipping::carriers',NULL,'deny'),(484,6,'Magento_Shipping::config_shipping',NULL,'deny'),(485,6,'Magento_Multishipping::config_multishipping',NULL,'deny'),(486,6,'Mageplaza_Core::configuration',NULL,'deny'),(487,6,'Mageplaza_Core::marketplace',NULL,'deny'),(488,6,'Magento_Config::config_general',NULL,'deny'),(489,6,'Magento_Config::web',NULL,'deny'),(490,6,'MSP_SecuritySuite::config',NULL,'deny'),(491,6,'MSP_ReCaptcha::config',NULL,'deny'),(492,6,'MSP_TwoFactorAuth::config',NULL,'deny'),(493,6,'Magento_Config::config_design',NULL,'deny'),(494,6,'Magento_Customer::config_customer',NULL,'deny'),(495,6,'Magento_Paypal::paypal',NULL,'deny'),(496,6,'Magento_Tax::config_tax',NULL,'deny'),(497,6,'Magento_Checkout::checkout',NULL,'deny'),(498,6,'Magento_Persistent::persistent',NULL,'deny'),(499,6,'Magento_Sales::config_sales',NULL,'deny'),(500,6,'Magento_Sales::sales_email',NULL,'deny'),(501,6,'Magento_Sales::sales_pdf',NULL,'deny'),(502,6,'Magento_Reports::reports',NULL,'deny'),(503,6,'Magento_Sitemap::config_sitemap',NULL,'deny'),(504,6,'Magento_Wishlist::config_wishlist',NULL,'deny'),(505,6,'Yotpo_Core::config',NULL,'deny'),(506,6,'Yotpo_Yotpo::config',NULL,'deny'),(507,6,'Magento_Config::config_system',NULL,'deny'),(508,6,'Magento_SalesRule::config_promo',NULL,'deny'),(509,6,'Magento_Config::trans_email',NULL,'deny'),(510,6,'Magento_Config::config_admin',NULL,'deny'),(511,6,'Magento_Config::dev',NULL,'deny'),(512,6,'Magento_Config::currency',NULL,'deny'),(513,6,'Magento_Rss::rss',NULL,'deny'),(514,6,'Magento_Config::sendfriend',NULL,'deny'),(515,6,'Magento_Analytics::analytics_settings',NULL,'deny'),(516,6,'WeltPixel_Backend::DeveloperSettings',NULL,'deny'),(517,6,'Magento_NewRelicReporting::config_newrelicreporting',NULL,'deny'),(518,6,'Magento_CheckoutAgreements::checkoutagreement',NULL,'deny'),(519,6,'Magento_Sales::order_statuses',NULL,'deny'),(520,6,'Magento_InventoryApi::inventory',NULL,'deny'),(521,6,'Magento_InventoryApi::source',NULL,'deny'),(522,6,'Magento_InventoryApi::source_edit',NULL,'deny'),(523,6,'Magento_InventoryApi::stock',NULL,'deny'),(524,6,'Magento_InventoryApi::stock_edit',NULL,'deny'),(525,6,'Magento_InventoryApi::stock_delete',NULL,'deny'),(526,6,'Magento_InventoryApi::stock_source_link',NULL,'deny'),(527,6,'Magento_InventorySalesApi::stock',NULL,'deny'),(528,6,'Temando_Shipping::shipping',NULL,'deny'),(529,6,'Temando_Shipping::packaging',NULL,'deny'),(530,6,'Temando_Shipping::portal',NULL,'deny'),(531,6,'Temando_Shipping::product',NULL,'deny'),(532,6,'Magento_Tax::manage_tax',NULL,'deny'),(533,6,'Magento_CurrencySymbol::system_currency',NULL,'deny'),(534,6,'Magento_CurrencySymbol::currency_rates',NULL,'deny'),(535,6,'Magento_CurrencySymbol::symbols',NULL,'deny'),(536,6,'Magento_Backend::stores_attributes',NULL,'deny'),(537,6,'Magento_Catalog::attributes_attributes',NULL,'deny'),(538,6,'Magento_Catalog::sets',NULL,'deny'),(539,6,'Magento_Review::ratings',NULL,'deny'),(540,6,'Magento_Swatches::iframe',NULL,'deny'),(541,6,'Magento_Backend::stores_other_settings',NULL,'deny'),(542,6,'Magento_Backend::system',NULL,'deny'),(543,6,'Magento_AdobeStockAsset::adobe_stock_asset',NULL,'deny'),(544,6,'Magento_AdobeStockAsset::actions',NULL,'deny'),(545,6,'Magento_AdobeStockAsset::actions_delete',NULL,'deny'),(546,6,'Magento_AdobeStockAsset::actions_save',NULL,'deny'),(547,6,'Magento_AdobeStockAsset::actions_view',NULL,'deny'),(548,6,'Magento_AdobeStockAsset::actions_get',NULL,'deny'),(549,6,'Magento_AdobeIms::adobe_ims',NULL,'deny'),(550,6,'Magento_AdobeIms::actions',NULL,'deny'),(551,6,'Magento_AdobeIms::login',NULL,'deny'),(552,6,'Magento_AdobeIms::logout',NULL,'deny'),(553,6,'Magento_AdobeIms::profile',NULL,'deny'),(554,6,'Magento_Backend::convert',NULL,'deny'),(555,6,'Magento_ImportExport::import',NULL,'deny'),(556,6,'Magento_ImportExport::export',NULL,'deny'),(557,6,'Magento_TaxImportExport::import_export',NULL,'deny'),(558,6,'Magento_ImportExport::history',NULL,'deny'),(559,6,'Magento_Backend::extensions',NULL,'deny'),(560,6,'Magento_Backend::local',NULL,'deny'),(561,6,'Magento_Backend::custom',NULL,'deny'),(562,6,'Magento_Integration::extensions',NULL,'deny'),(563,6,'Magento_Integration::integrations',NULL,'deny'),(564,6,'Magento_Backend::tools',NULL,'deny'),(565,6,'Magento_Backend::cache',NULL,'deny'),(566,6,'Magento_Backend::main_actions',NULL,'deny'),(567,6,'Magento_Backend::flush_cache_storage',NULL,'deny'),(568,6,'Magento_Backend::flush_magento_cache',NULL,'deny'),(569,6,'Magento_Backend::mass_actions',NULL,'deny'),(570,6,'Magento_Backend::toggling_cache_type',NULL,'deny'),(571,6,'Magento_Backend::refresh_cache_type',NULL,'deny'),(572,6,'Magento_Backend::additional_cache_management',NULL,'deny'),(573,6,'Magento_Backend::flush_catalog_images',NULL,'deny'),(574,6,'Magento_Backend::flush_js_css',NULL,'deny'),(575,6,'Magento_Backend::flush_static_files',NULL,'deny'),(576,6,'Magento_Backend::setup_wizard',NULL,'deny'),(577,6,'Magento_Backup::backup',NULL,'deny'),(578,6,'Magento_Backup::rollback',NULL,'deny'),(579,6,'Magento_Indexer::index',NULL,'deny'),(580,6,'Magento_Indexer::changeMode',NULL,'deny'),(581,6,'Magento_User::acl',NULL,'deny'),(582,6,'Magento_User::acl_users',NULL,'deny'),(583,6,'MSP_TwoFactorAuth::tfa',NULL,'deny'),(584,6,'Magento_User::locks',NULL,'deny'),(585,6,'Magento_User::acl_roles',NULL,'deny'),(586,6,'Magento_Logging::magento_logging',NULL,'deny'),(587,6,'Magento_Logging::magento_logging_events',NULL,'deny'),(588,6,'Magento_Logging::system_magento_logging_bulk_operations',NULL,'deny'),(589,6,'Magento_Backend::system_other_settings',NULL,'deny'),(590,6,'Magento_AdminNotification::adminnotification',NULL,'deny'),(591,6,'Magento_AdminNotification::show_toolbar',NULL,'deny'),(592,6,'Magento_AdminNotification::show_list',NULL,'deny'),(593,6,'Magento_AdminNotification::mark_as_read',NULL,'deny'),(594,6,'Magento_AdminNotification::adminnotification_remove',NULL,'deny'),(595,6,'Magento_Variable::variable',NULL,'deny'),(596,6,'Magento_EncryptionKey::crypt_key',NULL,'deny'),(597,6,'KiwiCommerce_CronScheduler::menu',NULL,'deny'),(598,6,'KiwiCommerce_CronScheduler::job_listing',NULL,'deny'),(599,6,'KiwiCommerce_CronScheduler::job_schedule_listing',NULL,'deny'),(600,6,'KiwiCommerce_CronScheduler::job_schedule_timeline',NULL,'deny'),(601,6,'KiwiCommerce_CronScheduler::schedule_massdelete',NULL,'deny'),(602,6,'KiwiCommerce_CronScheduler::schedule_masskill',NULL,'deny'),(603,6,'KiwiCommerce_CronScheduler::job_massschedule',NULL,'deny'),(604,6,'KiwiCommerce_CronScheduler::job_massstatuschange',NULL,'deny'),(605,6,'KiwiCommerce_CronScheduler::job_addnewjob',NULL,'deny'),(606,6,'KiwiCommerce_CronScheduler::job_editjob',NULL,'deny'),(607,6,'KiwiCommerce_CronScheduler::job_deletejob',NULL,'deny'),(608,6,'Magento_Backend::global_search',NULL,'deny'),(609,6,'WeltPixel_Backend::WeltPixel',NULL,'deny'),(610,6,'WeltPixel_Backend::WeltPixel_Documentation',NULL,'deny'),(611,6,'WeltPixel_Backend::WeltPixel_HelpCenter',NULL,'deny'),(612,6,'WeltPixel_Backend::WeltPixel_Licenses',NULL,'deny'),(613,6,'WeltPixel_Backend::Modules_License',NULL,'deny'),(614,6,'WeltPixel_Backend::WeltPixel_Debugger',NULL,'deny'),(615,6,'WeltPixel_Backend::WeltPixel_Debugger_Rewrites',NULL,'deny'),(616,6,'WeltPixel_Backend::WeltPixel_Debugger_Modules',NULL,'deny'),(617,6,'WeltPixel_Backend::WeltPixel_Debugger_Developer',NULL,'deny'),(618,6,'WeltPixel_Backend::Pearl_Theme_Options',NULL,'deny'),(619,6,'WeltPixel_OwlCarouselSlider::owlcarouselslider',NULL,'deny'),(620,6,'WeltPixel_OwlCarouselSlider::owlcarouselslider_general_configuration_carousel',NULL,'deny'),(621,6,'WeltPixel_OwlCarouselSlider::owlcarouselslider_products_sliders',NULL,'deny'),(622,6,'WeltPixel_OwlCarouselSlider::owlsliders',NULL,'deny'),(623,6,'WeltPixel_OwlCarouselSlider::owlcarouselslider_general_configuration_slider',NULL,'deny'),(624,6,'WeltPixel_OwlCarouselSlider::owlcarouselslider_custom_sliders',NULL,'deny'),(625,6,'WeltPixel_OwlCarouselSlider::owlcarouselslider_custom_banners',NULL,'deny');

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `id` varchar(200) NOT NULL COMMENT 'Cache Id',
  `data` mediumblob DEFAULT NULL COMMENT 'Cache Data',
  `create_time` int(11) DEFAULT NULL COMMENT 'Cache Creation Time',
  `update_time` int(11) DEFAULT NULL COMMENT 'Time of Cache Updating',
  `expire_time` int(11) DEFAULT NULL COMMENT 'Cache Expiration Time',
  PRIMARY KEY (`id`),
  KEY `CACHE_EXPIRE_TIME` (`expire_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Caches';

--
-- Dumping data for table `cache`
--


--
-- Table structure for table `cache_tag`
--

CREATE TABLE `cache_tag` (
  `tag` varchar(100) NOT NULL COMMENT 'Tag',
  `cache_id` varchar(200) NOT NULL COMMENT 'Cache Id',
  PRIMARY KEY (`tag`,`cache_id`),
  KEY `CACHE_TAG_CACHE_ID` (`cache_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Tag Caches';

--
-- Dumping data for table `cache_tag`
--


--
-- Table structure for table `captcha_log`
--

CREATE TABLE `captcha_log` (
  `type` varchar(32) NOT NULL COMMENT 'Type',
  `value` varchar(255) NOT NULL COMMENT 'Value',
  `count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Count',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`type`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Count Login Attempts';

--
-- Dumping data for table `captcha_log`
--

INSERT INTO `captcha_log` (`type`, `value`, `count`, `updated_at`) VALUES ('1','31.7.62.234',3516,'2020-03-27 13:45:57'),('1','81.17.20.10',13592,'2020-03-27 13:45:42'),('2','ALAMSYAH',1,'2020-03-27 13:00:11'),('2','ALAN',1,'2020-03-27 13:02:56'),('2','Alana',1,'2020-03-27 13:05:49'),('2','alanaattew',1,'2020-03-27 13:08:41'),('2','Alanagh',1,'2020-03-27 13:11:38'),('2','Alanah',1,'2020-03-27 13:14:36'),('2','Alanan',1,'2020-03-27 13:17:37'),('2','AlanBao',1,'2020-03-27 13:20:37'),('2','Aland',1,'2020-03-27 13:23:37'),('2','Alanda',1,'2020-03-27 13:26:14'),('2','alanderson',1,'2020-03-27 13:28:54'),('2','ALANDES',1,'2020-03-27 13:31:38'),('2','alandra',1,'2020-03-27 13:34:20'),('2','Alane',1,'2020-03-27 13:37:07'),('2','Alangilan',1,'2020-03-27 13:39:54'),('2','Alani',1,'2020-03-27 13:42:48'),('2','alania',1,'2020-03-27 13:45:42'),('2','ebarrett',1,'2020-03-27 13:01:10'),('2','ebarrettjr',1,'2020-03-27 13:04:09'),('2','ebay',1,'2020-03-27 13:07:12'),('2','ebayraktar',1,'2020-03-27 13:10:18'),('2','ebizsoft',1,'2020-03-27 13:13:22'),('2','eboundhost',1,'2020-03-27 13:16:33'),('2','eboundtech',2,'2020-03-27 13:22:36'),('2','ebru.dundar',1,'2020-03-27 13:25:25'),('2','ebtessam',1,'2020-03-27 13:28:13'),('2','ecadmin',1,'2020-03-27 13:31:07'),('2','ecaradine@veearcdrives.com',1,'2020-03-27 13:34:00'),('2','ecc',2,'2020-03-27 13:39:54'),('2','eccadmin',1,'2020-03-27 13:42:56'),('2','ECCCloud',1,'2020-03-27 13:45:57');

--
-- Table structure for table `catalog_category_entity`
--

CREATE TABLE `catalog_category_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',
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Parent Category ID',
  `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',
  `path` varchar(255) NOT NULL COMMENT 'Tree Path',
  `position` int(11) NOT NULL COMMENT 'Position',
  `level` int(11) NOT NULL DEFAULT 0 COMMENT 'Tree Level',
  `children_count` int(11) NOT NULL COMMENT 'Child Count',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_ENTITY_LEVEL` (`level`),
  KEY `CATALOG_CATEGORY_ENTITY_PATH` (`path`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Table';

--
-- Dumping data for table `catalog_category_entity`
--

INSERT INTO `catalog_category_entity` (`entity_id`, `attribute_set_id`, `parent_id`, `created_at`, `updated_at`, `path`, `position`, `level`, `children_count`) VALUES (1,3,0,'2019-05-09 10:47:27','2019-05-09 11:12:01','1',0,0,10),(2,3,1,'2019-05-09 10:47:27','2019-05-09 11:12:01','1/2',1,1,9),(3,3,2,'2019-05-09 11:09:52','2019-05-09 11:09:52','1/2/3',1,2,0),(4,3,2,'2019-05-09 11:10:05','2019-05-09 11:10:05','1/2/4',2,2,0),(5,3,2,'2019-05-09 11:10:23','2019-05-09 11:10:23','1/2/5',3,2,0),(6,3,2,'2019-05-09 11:10:35','2019-05-09 11:10:35','1/2/6',4,2,0),(7,3,2,'2019-05-09 11:10:54','2019-05-09 11:10:54','1/2/7',5,2,0),(8,3,2,'2019-05-09 11:11:09','2019-05-09 11:11:09','1/2/8',6,2,0),(9,3,2,'2019-05-09 11:11:27','2019-05-09 11:11:27','1/2/9',7,2,0),(10,3,2,'2019-05-09 11:11:43','2019-05-09 11:11:43','1/2/10',8,2,0),(11,3,2,'2019-05-09 11:12:01','2019-05-09 11:12:01','1/2/11',9,2,0);

--
-- Table structure for table `catalog_category_entity_datetime`
--

CREATE TABLE `catalog_category_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_CATEGORY_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_CATEGORY_ENTITY_DATETIME_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_CATEGORY_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_DTIME_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Datetime Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_datetime`
--


--
-- Table structure for table `catalog_category_entity_decimal`
--

CREATE TABLE `catalog_category_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_CATEGORY_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_CATEGORY_ENTITY_DECIMAL_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_CATEGORY_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_CATEGORY_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_DECIMAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_DEC_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Decimal Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_decimal`
--


--
-- Table structure for table `catalog_category_entity_int`
--

CREATE TABLE `catalog_category_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_CATEGORY_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_CATEGORY_ENTITY_INT_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_CATEGORY_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_CATEGORY_ENTITY_INT_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_INT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_INT_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Integer Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_int`
--

INSERT INTO `catalog_category_entity_int` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1,69,0,1,1),(2,46,0,2,1),(3,69,0,2,1),(4,46,0,3,1),(5,54,0,3,1),(6,69,0,3,1),(7,70,0,3,0),(8,71,0,3,0),(9,46,0,4,1),(10,54,0,4,1),(11,69,0,4,1),(12,70,0,4,0),(13,71,0,4,0),(14,46,0,5,1),(15,54,0,5,1),(16,69,0,5,1),(17,70,0,5,0),(18,71,0,5,0),(19,46,0,6,1),(20,54,0,6,1),(21,69,0,6,1),(22,70,0,6,0),(23,71,0,6,0),(24,46,0,7,1),(25,54,0,7,1),(26,69,0,7,1),(27,70,0,7,0),(28,71,0,7,0),(29,46,0,8,1),(30,54,0,8,1),(31,69,0,8,1),(32,70,0,8,0),(33,71,0,8,0),(34,46,0,9,1),(35,54,0,9,1),(36,69,0,9,1),(37,70,0,9,0),(38,71,0,9,0),(39,46,0,10,1),(40,54,0,10,1),(41,69,0,10,1),(42,70,0,10,0),(43,71,0,10,0),(44,46,0,11,1),(45,54,0,11,1),(46,69,0,11,1),(47,70,0,11,0),(48,71,0,11,0);

--
-- Table structure for table `catalog_category_entity_text`
--

CREATE TABLE `catalog_category_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 DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_CATEGORY_ENTITY_TEXT_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_CATEGORY_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_TEXT_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Text Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_text`
--


--
-- Table structure for table `catalog_category_entity_varchar`
--

CREATE TABLE `catalog_category_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_CATEGORY_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `CATALOG_CATEGORY_ENTITY_VARCHAR_ENTITY_ID` (`entity_id`),
  KEY `CATALOG_CATEGORY_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_ENTT_VCHR_ENTT_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Varchar Attribute Backend Table';

--
-- Dumping data for table `catalog_category_entity_varchar`
--

INSERT INTO `catalog_category_entity_varchar` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1,45,0,1,'Root Catalog'),(2,45,0,2,'Default Category'),(3,52,0,2,'PRODUCTS'),(4,45,0,3,'Είδη κουζίνας'),(5,52,0,3,'PRODUCTS'),(6,119,0,3,'eidi-kouzinas'),(7,120,0,3,'eidi-kouzinas'),(8,45,0,4,'Είδη μπάνιου     '),(9,52,0,4,'PRODUCTS'),(10,119,0,4,'eidi-mpaniou'),(11,120,0,4,'eidi-mpaniou'),(12,45,0,5,'Ηλεκτρικά     '),(13,52,0,5,'PRODUCTS'),(14,119,0,5,'ilektrika'),(15,120,0,5,'ilektrika'),(16,45,0,6,'Οργάνωση     '),(17,52,0,6,'PRODUCTS'),(18,119,0,6,'organosi'),(19,120,0,6,'organosi'),(20,45,0,7,'Έπιπλα     '),(21,52,0,7,'PRODUCTS'),(22,119,0,7,'epipla'),(23,120,0,7,'epipla'),(24,45,0,8,'Διακοσμητικά     '),(25,52,0,8,'PRODUCTS'),(26,119,0,8,'diakosmitika'),(27,120,0,8,'diakosmitika'),(28,45,0,9,'Λευκά είδη     '),(29,52,0,9,'PRODUCTS'),(30,119,0,9,'leuka-eidi'),(31,120,0,9,'leuka-eidi'),(32,45,0,10,'Νέα προϊόντα     '),(33,52,0,10,'PRODUCTS'),(34,119,0,10,'nea-proionta'),(35,120,0,10,'nea-proionta'),(36,45,0,11,'Προσφορές'),(37,52,0,11,'PRODUCTS'),(38,119,0,11,'prosfores'),(39,120,0,11,'prosfores');

--
-- Table structure for table `catalog_category_product`
--

CREATE TABLE `catalog_category_product` (
  `entity_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `position` int(11) NOT NULL DEFAULT 0 COMMENT 'Position',
  PRIMARY KEY (`entity_id`,`category_id`,`product_id`),
  UNIQUE KEY `CATALOG_CATEGORY_PRODUCT_CATEGORY_ID_PRODUCT_ID` (`category_id`,`product_id`),
  KEY `CATALOG_CATEGORY_PRODUCT_PRODUCT_ID` (`product_id`),
  CONSTRAINT `CAT_CTGR_PRD_CTGR_ID_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `catalog_category_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_CTGR_PRD_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Catalog Product To Category Linkage Table';

--
-- Dumping data for table `catalog_category_product`
--

INSERT INTO `catalog_category_product` (`entity_id`, `category_id`, `product_id`, `position`) VALUES (1,3,1,0),(2,3,2,0),(3,3,3,0),(4,3,4,0),(5,3,5,0),(6,3,6,0);

--
-- Table structure for table `catalog_category_product_index`
--

CREATE TABLE `catalog_category_product_index` (
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `CAT_CTGR_PRD_IDX_STORE_ID_CTGR_ID_VISIBILITY_IS_PARENT_POSITION` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index';

--
-- Dumping data for table `catalog_category_product_index`
--


--
-- Table structure for table `catalog_category_product_index_replica`
--

CREATE TABLE `catalog_category_product_index_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `CAT_CTGR_PRD_IDX_STORE_ID_CTGR_ID_VISIBILITY_IS_PARENT_POSITION` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index';

--
-- Dumping data for table `catalog_category_product_index_replica`
--


--
-- Table structure for table `catalog_category_product_index_store1`
--

CREATE TABLE `catalog_category_product_index_store1` (
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_4B965DC45C352D6E4C9DC0FF50B1FCF5` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_47AB760CD6A893ACEA69A9C2E0112C60` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store1 Replica';

--
-- Dumping data for table `catalog_category_product_index_store1`
--

INSERT INTO `catalog_category_product_index_store1` (`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`) VALUES (2,223,0,0,1,4),(2,224,0,0,1,4),(2,225,0,0,1,4),(2,226,0,0,1,4),(2,227,0,0,1,4),(2,228,0,0,1,4),(2,229,0,0,1,4),(2,230,0,0,1,4),(2,231,0,0,1,4),(2,232,0,0,1,4),(2,233,0,0,1,4),(2,1,0,1,1,4),(2,2,0,1,1,4),(2,3,0,1,1,4),(2,4,0,1,1,4),(2,5,0,1,1,4),(2,6,0,1,1,4),(3,1,0,1,1,4),(3,2,0,1,1,4),(3,3,0,1,1,4),(3,4,0,1,1,4),(3,5,0,1,1,4),(3,6,0,1,1,4);

--
-- Table structure for table `catalog_category_product_index_store1_replica`
--

CREATE TABLE `catalog_category_product_index_store1_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE1_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_216E521C8AD125E066D2B0BAB4A08412` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store1';

--
-- Dumping data for table `catalog_category_product_index_store1_replica`
--

INSERT INTO `catalog_category_product_index_store1_replica` (`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`) VALUES (2,138,0,0,1,4),(2,139,0,0,1,4),(2,140,0,0,1,4),(2,141,0,0,1,4),(2,142,0,0,1,4),(2,143,0,0,1,4),(2,144,0,0,1,4),(2,145,0,0,1,4),(2,146,0,0,1,4),(2,147,0,0,1,4),(2,148,0,0,1,4),(2,149,0,0,1,4),(2,150,0,0,1,4),(2,151,0,0,1,4),(2,152,0,0,1,4),(2,153,0,0,1,4),(2,154,0,0,1,4),(2,155,0,0,1,4),(2,156,0,0,1,4),(2,157,0,0,1,4),(2,158,0,0,1,4),(2,159,0,0,1,4),(2,160,0,0,1,4),(2,161,0,0,1,4),(2,162,0,0,1,4),(2,163,0,0,1,4),(2,164,0,0,1,4),(2,165,0,0,1,4),(2,166,0,0,1,4),(2,167,0,0,1,4),(2,168,0,0,1,4),(2,169,0,0,1,4),(2,170,0,0,1,4),(2,171,0,0,1,4),(2,172,0,0,1,4),(2,173,0,0,1,4),(2,174,0,0,1,4),(2,175,0,0,1,4),(2,176,0,0,1,4),(2,177,0,0,1,4),(2,178,0,0,1,4),(2,179,0,0,1,4),(2,180,0,0,1,4),(2,181,0,0,1,4),(2,182,0,0,1,4),(2,183,0,0,1,4),(2,184,0,0,1,4),(2,185,0,0,1,4),(2,186,0,0,1,4),(2,187,0,0,1,4),(2,188,0,0,1,4),(2,189,0,0,1,4),(2,190,0,0,1,4),(2,191,0,0,1,4),(2,192,0,0,1,4),(2,193,0,0,1,4),(2,194,0,0,1,4),(2,195,0,0,1,4),(2,196,0,0,1,4),(2,197,0,0,1,4),(2,198,0,0,1,4),(2,199,0,0,1,4),(2,200,0,0,1,4),(2,201,0,0,1,4),(2,202,0,0,1,4),(2,203,0,0,1,4),(2,204,0,0,1,4),(2,205,0,0,1,4),(2,206,0,0,1,4),(2,207,0,0,1,4),(2,208,0,0,1,4),(2,209,0,0,1,4),(2,210,0,0,1,4),(2,1,0,1,1,4),(2,2,0,1,1,4),(2,3,0,1,1,4),(2,4,0,1,1,4),(2,5,0,1,1,4),(2,6,0,1,1,4),(3,1,0,1,1,4),(3,2,0,1,1,4),(3,3,0,1,1,4),(3,4,0,1,1,4),(3,5,0,1,1,4),(3,6,0,1,1,4);

--
-- Table structure for table `catalog_category_product_index_store2`
--

CREATE TABLE `catalog_category_product_index_store2` (
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `IDX_87FCED52F67C72BB6992C79EB4DCFA8A` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_15B841C92B67D986A980051DF109F9D1` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store2 Replica';

--
-- Dumping data for table `catalog_category_product_index_store2`
--

INSERT INTO `catalog_category_product_index_store2` (`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`) VALUES (2,223,0,0,2,4),(2,224,0,0,2,4),(2,225,0,0,2,4),(2,226,0,0,2,4),(2,227,0,0,2,4),(2,228,0,0,2,4),(2,229,0,0,2,4),(2,230,0,0,2,4),(2,231,0,0,2,4),(2,232,0,0,2,4),(2,233,0,0,2,4),(2,1,0,1,2,4),(2,2,0,1,2,4),(2,3,0,1,2,4),(2,4,0,1,2,4),(2,5,0,1,2,4),(2,6,0,1,2,4),(3,1,0,1,2,4),(3,2,0,1,2,4),(3,3,0,1,2,4),(3,4,0,1,2,4),(3,5,0,1,2,4),(3,6,0,1,2,4);

--
-- Table structure for table `catalog_category_product_index_store2_replica`
--

CREATE TABLE `catalog_category_product_index_store2_replica` (
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category Id',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product Id',
  `position` int(11) DEFAULT NULL COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store Id',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_STORE2_PRD_ID_STORE_ID_CTGR_ID_VISIBILITY` (`product_id`,`store_id`,`category_id`,`visibility`),
  KEY `IDX_2AB6FE58F086547FA7E4590837296849` (`store_id`,`category_id`,`visibility`,`is_parent`,`position`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Index Store2';

--
-- Dumping data for table `catalog_category_product_index_store2_replica`
--

INSERT INTO `catalog_category_product_index_store2_replica` (`category_id`, `product_id`, `position`, `is_parent`, `store_id`, `visibility`) VALUES (2,138,0,0,2,4),(2,139,0,0,2,4),(2,140,0,0,2,4),(2,141,0,0,2,4),(2,142,0,0,2,4),(2,143,0,0,2,4),(2,144,0,0,2,4),(2,145,0,0,2,4),(2,146,0,0,2,4),(2,147,0,0,2,4),(2,148,0,0,2,4),(2,149,0,0,2,4),(2,150,0,0,2,4),(2,151,0,0,2,4),(2,152,0,0,2,4),(2,153,0,0,2,4),(2,154,0,0,2,4),(2,155,0,0,2,4),(2,156,0,0,2,4),(2,157,0,0,2,4),(2,158,0,0,2,4),(2,159,0,0,2,4),(2,160,0,0,2,4),(2,161,0,0,2,4),(2,162,0,0,2,4),(2,163,0,0,2,4),(2,164,0,0,2,4),(2,165,0,0,2,4),(2,166,0,0,2,4),(2,167,0,0,2,4),(2,168,0,0,2,4),(2,169,0,0,2,4),(2,170,0,0,2,4),(2,171,0,0,2,4),(2,172,0,0,2,4),(2,173,0,0,2,4),(2,174,0,0,2,4),(2,175,0,0,2,4),(2,176,0,0,2,4),(2,177,0,0,2,4),(2,178,0,0,2,4),(2,179,0,0,2,4),(2,180,0,0,2,4),(2,181,0,0,2,4),(2,182,0,0,2,4),(2,183,0,0,2,4),(2,184,0,0,2,4),(2,185,0,0,2,4),(2,186,0,0,2,4),(2,187,0,0,2,4),(2,188,0,0,2,4),(2,189,0,0,2,4),(2,190,0,0,2,4),(2,191,0,0,2,4),(2,192,0,0,2,4),(2,193,0,0,2,4),(2,194,0,0,2,4),(2,195,0,0,2,4),(2,196,0,0,2,4),(2,197,0,0,2,4),(2,198,0,0,2,4),(2,199,0,0,2,4),(2,200,0,0,2,4),(2,201,0,0,2,4),(2,202,0,0,2,4),(2,203,0,0,2,4),(2,204,0,0,2,4),(2,205,0,0,2,4),(2,206,0,0,2,4),(2,207,0,0,2,4),(2,208,0,0,2,4),(2,209,0,0,2,4),(2,210,0,0,2,4),(2,1,0,1,2,4),(2,2,0,1,2,4),(2,3,0,1,2,4),(2,4,0,1,2,4),(2,5,0,1,2,4),(2,6,0,1,2,4),(3,1,0,1,2,4),(3,2,0,1,2,4),(3,3,0,1,2,4),(3,4,0,1,2,4),(3,5,0,1,2,4),(3,6,0,1,2,4);

--
-- Table structure for table `catalog_category_product_index_tmp`
--

CREATE TABLE `catalog_category_product_index_tmp` (
  `category_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Category ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `position` int(11) NOT NULL DEFAULT 0 COMMENT 'Position',
  `is_parent` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Parent',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `visibility` smallint(5) unsigned NOT NULL COMMENT 'Visibility',
  PRIMARY KEY (`category_id`,`product_id`,`store_id`),
  KEY `CAT_CTGR_PRD_IDX_TMP_PRD_ID_CTGR_ID_STORE_ID` (`product_id`,`category_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Product Indexer temporary table';

--
-- Dumping data for table `catalog_category_product_index_tmp`
--


--
-- Table structure for table `catalog_compare_item`
--

CREATE TABLE `catalog_compare_item` (
  `catalog_compare_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Compare Item ID',
  `visitor_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Visitor ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store ID',
  PRIMARY KEY (`catalog_compare_item_id`),
  KEY `CATALOG_COMPARE_ITEM_PRODUCT_ID` (`product_id`),
  KEY `CATALOG_COMPARE_ITEM_VISITOR_ID_PRODUCT_ID` (`visitor_id`,`product_id`),
  KEY `CATALOG_COMPARE_ITEM_CUSTOMER_ID_PRODUCT_ID` (`customer_id`,`product_id`),
  KEY `CATALOG_COMPARE_ITEM_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_COMPARE_ITEM_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CATALOG_COMPARE_ITEM_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CATALOG_COMPARE_ITEM_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Compare Table';

--
-- Dumping data for table `catalog_compare_item`
--


--
-- Table structure for table `catalog_eav_attribute`
--

CREATE TABLE `catalog_eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `frontend_input_renderer` varchar(255) DEFAULT NULL COMMENT 'Frontend Input Renderer',
  `is_global` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Global',
  `is_visible` smallint(5) unsigned NOT NULL DEFAULT 1 COMMENT 'Is Visible',
  `is_searchable` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Searchable',
  `is_filterable` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Filterable',
  `is_comparable` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Comparable',
  `is_visible_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible On Front',
  `is_html_allowed_on_front` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is HTML Allowed On Front',
  `is_used_for_price_rules` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used For Price Rules',
  `is_filterable_in_search` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Filterable In Search',
  `used_in_product_listing` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used In Product Listing',
  `used_for_sort_by` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used For Sorting',
  `apply_to` varchar(255) DEFAULT NULL COMMENT 'Apply To',
  `is_visible_in_advanced_search` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible In Advanced Search',
  `position` int(11) NOT NULL DEFAULT 0 COMMENT 'Position',
  `is_wysiwyg_enabled` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is WYSIWYG Enabled',
  `is_used_for_promo_rules` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used For Promo Rules',
  `is_required_in_admin_store` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Required In Admin Store',
  `is_used_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Used in Grid',
  `is_visible_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Visible in Grid',
  `is_filterable_in_grid` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Is Filterable in Grid',
  `search_weight` float NOT NULL DEFAULT 1 COMMENT 'Search Weight',
  `additional_data` text DEFAULT NULL COMMENT 'Additional swatch attributes data',
  PRIMARY KEY (`attribute_id`),
  KEY `CATALOG_EAV_ATTRIBUTE_USED_FOR_SORT_BY` (`used_for_sort_by`),
  KEY `CATALOG_EAV_ATTRIBUTE_USED_IN_PRODUCT_LISTING` (`used_in_product_listing`),
  CONSTRAINT `CATALOG_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog EAV Attribute Table';

--
-- Dumping data for table `catalog_eav_attribute`
--

INSERT INTO `catalog_eav_attribute` (`attribute_id`, `frontend_input_renderer`, `is_global`, `is_visible`, `is_searchable`, `is_filterable`, `is_comparable`, `is_visible_on_front`, `is_html_allowed_on_front`, `is_used_for_price_rules`, `is_filterable_in_search`, `used_in_product_listing`, `used_for_sort_by`, `apply_to`, `is_visible_in_advanced_search`, `position`, `is_wysiwyg_enabled`, `is_used_for_promo_rules`, `is_required_in_admin_store`, `is_used_in_grid`, `is_visible_in_grid`, `is_filterable_in_grid`, `search_weight`, `additional_data`) VALUES (45,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(46,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(47,NULL,0,1,0,0,0,0,1,0,0,0,0,NULL,0,0,1,0,0,0,0,0,1,NULL),(48,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(49,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(50,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(51,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(52,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(53,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(54,NULL,1,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(55,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(56,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(57,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(58,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(59,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(60,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(61,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(62,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(63,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(64,NULL,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(65,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(66,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(67,'Magento\\Catalog\\Block\\Adminhtml\\Category\\Helper\\Sortby\\Available',0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(68,'Magento\\Catalog\\Block\\Adminhtml\\Category\\Helper\\Sortby\\DefaultSortby',0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(69,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(70,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(71,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(72,'Magento\\Catalog\\Block\\Adminhtml\\Category\\Helper\\Pricestep',0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(73,NULL,0,1,1,0,0,0,0,0,0,1,1,NULL,1,0,0,0,0,0,0,0,5,NULL),(74,NULL,1,1,1,0,1,0,0,0,0,0,0,NULL,1,0,0,0,0,0,0,0,6,NULL),(75,NULL,0,1,1,0,1,0,1,0,0,0,0,NULL,1,0,1,0,0,0,0,0,1,NULL),(76,NULL,0,1,1,0,1,0,1,0,0,1,0,NULL,1,0,1,0,0,1,0,0,1,NULL),(77,NULL,1,1,1,1,0,0,0,0,0,1,1,'simple,virtual,configurable,downloadable,bundle',1,0,0,0,0,0,0,0,1,NULL),(78,NULL,1,1,0,0,0,0,0,0,0,1,0,'simple,virtual,configurable,downloadable,bundle',0,0,0,0,0,1,0,1,1,NULL),(79,NULL,2,1,0,0,0,0,0,0,0,1,0,'simple,virtual,configurable,downloadable,bundle',0,0,0,0,0,1,0,0,1,NULL),(80,NULL,2,1,0,0,0,0,0,0,0,1,0,'simple,virtual,configurable,downloadable,bundle',0,0,0,0,0,1,0,0,1,NULL),(81,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,virtual,downloadable',0,0,0,0,0,1,0,1,1,NULL),(82,'Magento\\Catalog\\Block\\Adminhtml\\Product\\Helper\\Form\\Weight',1,1,0,0,0,0,0,0,0,0,0,'simple,virtual,configurable,downloadable,bundle',0,0,0,0,0,1,0,1,1,NULL),(83,NULL,1,1,1,1,1,0,0,0,0,0,0,'simple,configurable',1,0,0,0,0,1,0,1,1,NULL),(84,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,1,1,NULL),(85,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,1,1,NULL),(86,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,1,1,NULL),(87,NULL,0,1,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(88,NULL,0,1,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(89,NULL,0,1,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(90,NULL,1,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(91,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(92,NULL,2,1,0,0,0,0,0,0,0,0,0,'simple,virtual,downloadable,bundle',0,0,0,0,0,0,0,0,1,NULL),(93,NULL,1,1,1,1,1,0,0,0,0,0,0,'simple,virtual,configurable',1,0,0,0,0,1,0,1,1,NULL),(94,NULL,2,1,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,1,0,0,1,NULL),(95,NULL,2,1,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,1,0,0,1,NULL),(96,NULL,1,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(97,'Magento\\Framework\\Data\\Form\\Element\\Hidden',2,1,1,0,0,0,0,0,0,1,0,NULL,0,0,0,0,1,0,0,0,1,NULL),(98,NULL,1,0,0,0,0,0,0,0,0,0,0,'simple,virtual,configurable,downloadable,bundle',0,0,0,0,0,0,0,0,1,NULL),(99,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,1,0,0,0,1,NULL),(100,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,1,1,NULL),(101,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,0,1,NULL),(102,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,0,1,NULL),(103,NULL,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(104,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,0,1,NULL),(105,'Magento\\Catalog\\Block\\Adminhtml\\Product\\Helper\\Form\\Category',1,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(106,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(107,NULL,1,0,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(108,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(109,NULL,0,0,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(110,NULL,0,0,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(111,NULL,0,0,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(112,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(113,NULL,1,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(114,NULL,2,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable,grouped',0,0,0,0,0,1,0,1,1,NULL),(115,'Magento\\CatalogInventory\\Block\\Adminhtml\\Form\\Field\\Stock',1,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(116,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,0,1,NULL),(117,'Magento\\Msrp\\Block\\Adminhtml\\Product\\Helper\\Form\\Type',1,1,0,0,0,0,0,0,0,1,0,'simple,virtual,downloadable,bundle,configurable',0,0,0,0,0,1,0,1,1,NULL),(118,'Magento\\Msrp\\Block\\Adminhtml\\Product\\Helper\\Form\\Type\\Price',2,1,0,0,0,0,0,0,0,1,0,'simple,virtual,downloadable,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(119,NULL,0,1,1,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(120,NULL,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(121,NULL,0,1,1,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,1,0,1,1,NULL),(122,NULL,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(123,NULL,1,0,0,0,0,0,0,0,0,1,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(124,NULL,0,0,0,0,0,0,0,0,0,0,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(125,NULL,0,0,0,0,0,0,0,0,0,0,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(126,NULL,1,0,0,0,0,0,0,0,0,1,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(127,'Magento\\GiftMessage\\Block\\Adminhtml\\Product\\Helper\\Form\\Config',1,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,1,0,0,1,NULL),(128,NULL,0,1,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(129,NULL,2,1,1,0,0,0,0,0,0,1,0,'simple,virtual,configurable,downloadable,bundle',0,0,0,0,0,1,0,1,1,NULL),(130,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(131,NULL,1,1,0,0,0,0,0,0,0,0,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(132,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(133,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(134,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(135,NULL,0,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(136,NULL,0,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(137,NULL,0,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(138,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(139,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(140,NULL,1,0,0,0,0,0,0,0,0,0,0,'simple,downloadable,virtual,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(141,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(142,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(143,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(144,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,bundle,configurable',0,0,0,0,0,0,0,0,1,NULL),(145,NULL,0,1,0,0,0,1,1,0,0,1,0,NULL,0,0,0,0,0,1,1,0,1,NULL),(146,NULL,0,1,0,0,0,1,1,0,0,1,0,NULL,0,0,0,0,0,1,1,0,1,NULL),(147,NULL,0,1,1,1,0,0,1,0,1,0,0,NULL,0,0,0,0,0,0,1,0,1,NULL),(148,NULL,1,1,1,0,0,0,1,0,0,0,0,NULL,0,0,0,0,0,1,1,1,1,NULL);

--
-- Table structure for table `catalog_product_bundle_option`
--

CREATE TABLE `catalog_product_bundle_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `required` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Required',
  `position` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Position',
  `type` varchar(255) DEFAULT NULL COMMENT 'Type',
  PRIMARY KEY (`option_id`),
  KEY `CATALOG_PRODUCT_BUNDLE_OPTION_PARENT_ID` (`parent_id`),
  CONSTRAINT `CAT_PRD_BNDL_OPT_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Option';

--
-- 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',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  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`
--


--
-- 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',
  `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',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  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_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=234 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Table';

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

INSERT INTO `catalog_product_entity` (`entity_id`, `attribute_set_id`, `type_id`, `sku`, `has_options`, `required_options`, `created_at`, `updated_at`) VALUES (1,4,'simple','ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ',0,0,'2019-05-09 12:14:33','2019-05-09 12:14:33'),(2,4,'simple','0002',0,0,'2019-05-09 12:14:35','2019-05-09 12:16:10'),(3,4,'simple','0003',0,0,'2019-05-09 12:16:11','2019-05-09 12:18:20'),(4,4,'simple','0004',0,0,'2019-05-09 12:18:21','2019-05-09 12:19:46'),(5,4,'simple','0005',0,0,'2019-05-09 12:19:47','2019-05-10 07:11:10'),(6,4,'simple','0006',0,0,'2019-05-09 12:20:48','2019-05-10 07:08:33'),(223,9,'simple','035-035815',0,0,'2020-03-27 11:14:27','2020-03-27 11:14:27'),(224,9,'simple','371-001',0,0,'2020-03-27 11:14:27','2020-03-27 11:14:28'),(225,9,'simple','351-300304',0,0,'2020-03-27 11:14:28','2020-03-27 11:14:28'),(226,9,'simple','351-315003',0,0,'2020-03-27 11:14:28','2020-03-27 11:14:29'),(227,9,'simple','351-315004',0,0,'2020-03-27 11:14:29','2020-03-27 11:14:29'),(228,9,'simple','351-315005',0,0,'2020-03-27 11:14:30','2020-03-27 11:14:30'),(229,9,'simple','351-315006',0,0,'2020-03-27 11:14:30','2020-03-27 11:14:31'),(230,9,'simple','351-315008',0,0,'2020-03-27 11:14:31','2020-03-27 11:14:31'),(231,9,'simple','351-325201',0,0,'2020-03-27 11:14:31','2020-03-27 11:14:32'),(232,9,'simple','351-325202',0,0,'2020-03-27 11:14:32','2020-03-27 11:14:33'),(233,9,'simple','351-325204',0,0,'2020-03-27 11:14:33','2020-03-27 11:14:33');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_after_insert AFTER INSERT ON catalog_product_entity FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `scconnector_google_remove_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_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 `scconnector_google_remove_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_after_delete AFTER DELETE ON catalog_product_entity FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `scconnector_google_remove_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=21 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Datetime Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_datetime` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1,94,0,1,'2019-05-08 00:00:00'),(2,95,0,1,'2019-05-31 00:00:00'),(3,94,0,2,'2019-05-08 00:00:00'),(4,95,0,2,'2019-05-31 00:00:00'),(6,94,0,3,'2019-05-08 00:00:00'),(7,95,0,3,'2019-05-31 00:00:00'),(9,94,0,4,'2019-05-08 00:00:00'),(10,95,0,4,'2019-05-31 00:00:00'),(12,79,0,4,'2019-05-09 15:19:46'),(13,79,0,5,'2019-05-09 00:00:00'),(14,94,0,5,'2019-05-08 00:00:00'),(15,95,0,5,'2019-05-31 00:00:00'),(17,79,0,6,'2019-05-09 00:00:00'),(18,94,0,6,'2019-05-08 00:00:00'),(19,95,0,6,'2019-05-31 00:00:00');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_datetime_after_insert AFTER INSERT ON catalog_product_entity_datetime FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_datetime_after_delete AFTER DELETE ON catalog_product_entity_datetime FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_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=243 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Decimal Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_decimal` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1,77,0,1,17.900000),(2,77,0,2,17.900000),(4,77,0,3,17.900000),(6,77,0,4,27.900000),(8,78,0,4,17.900000),(9,77,0,5,17.900000),(10,78,0,5,15.000000),(12,77,0,6,17.900000),(15,78,0,6,10.000000),(232,77,0,223,7.000000),(233,77,0,224,4.000000),(234,77,0,225,1.000000),(235,77,0,226,1.000000),(236,77,0,227,1.000000),(237,77,0,228,1.000000),(238,77,0,229,1.000000),(239,77,0,230,1.000000),(240,77,0,231,2.000000),(241,77,0,232,3.000000),(242,77,0,233,2.000000);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_decimal_after_insert AFTER INSERT ON catalog_product_entity_decimal FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_decimal_after_delete AFTER DELETE ON catalog_product_entity_decimal FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_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=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_gallery_after_insert AFTER INSERT ON catalog_product_entity_gallery FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_gallery_after_delete AFTER DELETE ON catalog_product_entity_gallery FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_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`),
  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=2326 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Integer Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_int` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1,97,0,1,1),(2,99,0,1,4),(3,129,0,1,2),(4,97,0,2,1),(5,99,0,2,4),(6,115,0,2,1),(7,129,0,2,2),(9,97,0,3,1),(10,99,0,3,4),(11,115,0,3,1),(12,129,0,3,2),(14,97,0,4,1),(15,99,0,4,4),(16,115,0,4,1),(17,129,0,4,2),(19,97,0,5,1),(20,99,0,5,4),(21,115,0,5,1),(22,129,0,5,2),(24,97,0,6,1),(25,99,0,6,4),(26,115,0,6,1),(27,129,0,6,2),(2183,97,0,223,1),(2184,99,0,223,4),(2185,147,0,223,5431),(2186,97,1,223,1),(2187,97,2,223,1),(2188,99,1,223,4),(2189,129,1,223,2),(2190,129,2,223,2),(2191,147,1,223,5431),(2192,99,2,223,4),(2193,147,2,223,5431),(2194,115,0,223,1),(2195,129,0,223,2),(2196,97,0,224,1),(2197,99,0,224,4),(2198,115,0,224,1),(2199,129,0,224,2),(2200,147,0,224,5431),(2201,97,1,224,1),(2202,97,2,224,1),(2203,99,1,224,4),(2204,129,1,224,2),(2205,129,2,224,2),(2206,147,1,224,5431),(2207,99,2,224,4),(2208,147,2,224,5431),(2209,97,0,225,1),(2210,99,0,225,4),(2211,115,0,225,1),(2212,129,0,225,2),(2213,147,0,225,5431),(2214,97,1,225,1),(2215,97,2,225,1),(2216,99,1,225,4),(2217,129,1,225,2),(2218,129,2,225,2),(2219,147,1,225,5431),(2220,99,2,225,4),(2221,147,2,225,5431),(2222,97,0,226,1),(2223,99,0,226,4),(2224,115,0,226,1),(2225,129,0,226,2),(2226,147,0,226,5431),(2227,97,1,226,1),(2228,97,2,226,1),(2229,99,1,226,4),(2230,129,1,226,2),(2231,129,2,226,2),(2232,147,1,226,5431),(2233,99,2,226,4),(2234,147,2,226,5431),(2235,97,0,227,1),(2236,99,0,227,4),(2237,115,0,227,1),(2238,129,0,227,2),(2239,147,0,227,5431),(2240,97,1,227,1),(2241,97,2,227,1),(2242,99,1,227,4),(2243,129,1,227,2),(2244,129,2,227,2),(2245,147,1,227,5431),(2246,99,2,227,4),(2247,147,2,227,5431),(2248,97,0,228,1),(2249,99,0,228,4),(2250,115,0,228,1),(2251,129,0,228,2),(2252,147,0,228,5431),(2253,97,1,228,1),(2254,97,2,228,1),(2255,99,1,228,4),(2256,129,1,228,2),(2257,129,2,228,2),(2258,147,1,228,5431),(2259,99,2,228,4),(2260,147,2,228,5431),(2261,97,0,229,1),(2262,99,0,229,4),(2263,115,0,229,1),(2264,129,0,229,2),(2265,147,0,229,5431),(2266,97,1,229,1),(2267,97,2,229,1),(2268,99,1,229,4),(2269,129,1,229,2),(2270,129,2,229,2),(2271,147,1,229,5431),(2272,99,2,229,4),(2273,147,2,229,5431),(2274,97,0,230,1),(2275,99,0,230,4),(2276,115,0,230,1),(2277,129,0,230,2),(2278,147,0,230,5431),(2279,97,1,230,1),(2280,97,2,230,1),(2281,99,1,230,4),(2282,129,1,230,2),(2283,129,2,230,2),(2284,147,1,230,5431),(2285,99,2,230,4),(2286,147,2,230,5431),(2287,97,0,231,1),(2288,99,0,231,4),(2289,115,0,231,1),(2290,129,0,231,2),(2291,147,0,231,5431),(2292,97,1,231,1),(2293,97,2,231,1),(2294,99,1,231,4),(2295,129,1,231,2),(2296,129,2,231,2),(2297,147,1,231,5431),(2298,99,2,231,4),(2299,147,2,231,5431),(2300,97,0,232,1),(2301,99,0,232,4),(2302,115,0,232,1),(2303,129,0,232,2),(2304,147,0,232,5431),(2305,97,1,232,1),(2306,97,2,232,1),(2307,99,1,232,4),(2308,129,1,232,2),(2309,129,2,232,2),(2310,147,1,232,5431),(2311,99,2,232,4),(2312,147,2,232,5431),(2313,97,0,233,1),(2314,99,0,233,4),(2315,115,0,233,1),(2316,129,0,233,2),(2317,147,0,233,5431),(2318,97,1,233,1),(2319,97,2,233,1),(2320,99,1,233,4),(2321,129,1,233,2),(2322,129,2,233,2),(2323,147,1,233,5431),(2324,99,2,233,4),(2325,147,2,233,5431);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_int_after_insert AFTER INSERT ON catalog_product_entity_int FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `scconnector_google_remove_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_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 `scconnector_google_remove_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_int_after_delete AFTER DELETE ON catalog_product_entity_int FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `scconnector_google_remove_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=12 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` (`value_id`, `attribute_id`, `value`, `media_type`, `disabled`) VALUES (1,90,'/1/3/134-32322.jpg','image',0),(3,90,'/1/6/165-225201.jpg','image',0),(5,90,'/5/1/519-910265.jpg','image',0),(7,90,'/1/8/182-227224.jpg','image',0),(9,90,'/2/1/213-160214.jpg','image',0),(11,90,'/8/6/863-8079.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=16 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` (`value_id`, `store_id`, `entity_id`, `label`, `position`, `disabled`, `record_id`) VALUES (1,0,1,NULL,1,0,1),(3,0,2,NULL,2,0,3),(5,0,3,NULL,2,0,5),(7,0,4,NULL,2,0,7),(11,0,6,NULL,2,0,14),(9,0,5,NULL,2,0,15);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_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` (`value_id`, `entity_id`) VALUES (1,1),(3,2),(5,3),(7,4),(9,5),(11,6);

--
-- 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 DEFAULT NULL COMMENT 'Video URL',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `description` text DEFAULT NULL COMMENT 'Page Meta Description',
  `metadata` text DEFAULT NULL 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`
--


--
-- 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 DEFAULT NULL 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=703 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Text Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_text` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1,75,0,1,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(2,76,0,1,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(3,85,0,1,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(4,75,0,2,'ΠΙΑΤΟ ΡΗΧΟ ΠΟΡΣΕΛΑΝΗΣ \"ELEGANT MAITRE\" 27εκ.'),(5,76,0,2,'ΠΙΑΤΟ ΡΗΧΟ ΠΟΡΣΕΛΑΝΗΣ \"ELEGANT MAITRE\" 27εκ.'),(6,85,0,2,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(8,75,0,3,'ΣΥΡΤΑΡΙΕΡΑ ΑΠΟΘΗΚΕΥΣΗΣ 91x44x37.5 \"ΔΑΝΤΕΛΑ\" ΜΠΕΖ'),(9,76,0,3,'ΣΥΡΤΑΡΙΕΡΑ ΑΠΟΘΗΚΕΥΣΗΣ 91x44x37.5 \"ΔΑΝΤΕΛΑ\" ΜΠΕΖ'),(10,85,0,3,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(12,75,0,4,'ΗΜΙΧΥΤΡΑ ΑΝΤΙΚΟΛ. ΜΕ ΚΕΡΑΜΙΚΗ ΕΠΙΣΤΡΩΣΗ 28Χ9ΕΚ'),(13,76,0,4,'ΗΜΙΧΥΤΡΑ ΑΝΤΙΚΟΛ. ΜΕ ΚΕΡΑΜΙΚΗ ΕΠΙΣΤΡΩΣΗ 28Χ9ΕΚ'),(14,85,0,4,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(16,75,0,5,'ΣΑΛΑΤΙΕΡΑ ΠΟΡΣΕΛΑΝΗΣ \"ELEGANT MAITER\" 23εκ.'),(17,76,0,5,'ΣΑΛΑΤΙΕΡΑ ΠΟΡΣΕΛΑΝΗΣ \"ELEGANT MAITER\" 23εκ.'),(18,85,0,5,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(20,75,0,6,'ΗΛΕΚΤΡΙΚΗ ΣΚΟΥΠΑ ΚΥΚΛΩΝΙΚΗΣ ΤΕΧΝΟΛΟΓΙΑΣ, \"VICKO\" 700W.'),(21,76,0,6,'ΗΛΕΚΤΡΙΚΗ ΣΚΟΥΠΑ ΚΥΚΛΩΝΙΚΗΣ ΤΕΧΝΟΛΟΓΙΑΣ, \"VICKO\" 700W.'),(22,85,0,6,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(670,75,0,223,'NULL'),(671,75,1,223,'NULL'),(672,75,2,223,'NULL'),(673,75,0,224,'NULL'),(674,75,1,224,'NULL'),(675,75,2,224,'NULL'),(676,75,0,225,'NULL'),(677,75,1,225,'NULL'),(678,75,2,225,'NULL'),(679,75,0,226,'NULL'),(680,75,1,226,'NULL'),(681,75,2,226,'NULL'),(682,75,0,227,'NULL'),(683,75,1,227,'NULL'),(684,75,2,227,'NULL'),(685,75,0,228,'NULL'),(686,75,1,228,'NULL'),(687,75,2,228,'NULL'),(688,75,0,229,'NULL'),(689,75,1,229,'NULL'),(690,75,2,229,'NULL'),(691,75,0,230,'NULL'),(692,75,1,230,'NULL'),(693,75,2,230,'NULL'),(694,75,0,231,'NULL'),(695,75,1,231,'NULL'),(696,75,2,231,'NULL'),(697,75,0,232,'NULL'),(698,75,1,232,'NULL'),(699,75,2,232,'NULL'),(700,75,0,233,'NULL'),(701,75,1,233,'NULL'),(702,75,2,233,'NULL');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_text_after_insert AFTER INSERT ON catalog_product_entity_text FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_text_after_delete AFTER DELETE ON catalog_product_entity_text FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_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',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `percentage_value` decimal(5,2) DEFAULT NULL COMMENT 'Percentage value',
  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=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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.`website_id` <=> OLD.`website_id`) OR NOT(NEW.`percentage_value` <=> OLD.`percentage_value`)) THEN INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_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=3085 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Varchar Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_varchar` (`value_id`, `attribute_id`, `store_id`, `entity_id`, `value`) VALUES (1,73,0,1,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(2,84,0,1,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(3,86,0,1,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(4,87,0,1,'/1/3/134-32322.jpg'),(5,88,0,1,'/1/3/134-32322.jpg'),(6,89,0,1,'/1/3/134-32322.jpg'),(7,106,0,1,'container2'),(8,118,0,1,'0'),(9,121,0,1,'kalathi-aplyton-me-kapaki-67l-dantela-mepz'),(10,127,0,1,'2'),(11,128,0,1,'/1/3/134-32322.jpg'),(16,73,0,2,'ΠΙΑΤΟ ΡΗΧΟ ΠΟΡΣΕΛΑΝΗΣ \"ELEGANT MAITRE\" 27εκ.'),(17,84,0,2,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(18,86,0,2,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(19,87,0,2,'/1/6/165-225201.jpg'),(20,88,0,2,'/1/6/165-225201.jpg'),(21,89,0,2,'/1/6/165-225201.jpg'),(22,106,0,2,'container2'),(23,118,0,2,'0'),(24,121,0,2,'kalathi-aplyton-me-kapaki-67l-dantela-mepz-1'),(25,127,0,2,'2'),(26,128,0,2,'/1/6/165-225201.jpg'),(36,73,0,3,'ΣΥΡΤΑΡΙΕΡΑ ΑΠΟΘΗΚΕΥΣΗΣ 91x44x37.5 \"ΔΑΝΤΕΛΑ\" ΜΠΕΖ'),(37,84,0,3,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(38,86,0,3,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(39,87,0,3,'/5/1/519-910265.jpg'),(40,88,0,3,'/5/1/519-910265.jpg'),(41,89,0,3,'/5/1/519-910265.jpg'),(42,106,0,3,'container2'),(43,118,0,3,'0'),(44,121,0,3,'kalathi-aplyton-me-kapaki-67l-dantela-mepz-2'),(45,127,0,3,'2'),(46,128,0,3,'/5/1/519-910265.jpg'),(56,73,0,4,'ΗΜΙΧΥΤΡΑ ΑΝΤΙΚΟΛ. ΜΕ ΚΕΡΑΜΙΚΗ ΕΠΙΣΤΡΩΣΗ 28Χ9ΕΚ'),(57,84,0,4,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(58,86,0,4,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(59,87,0,4,'/1/8/182-227224.jpg'),(60,88,0,4,'/1/8/182-227224.jpg'),(61,89,0,4,'/1/8/182-227224.jpg'),(62,106,0,4,'container2'),(63,118,0,4,'0'),(64,121,0,4,'kalathi-aplyton-me-kapaki-67l-dantela-mepz-3'),(65,127,0,4,'2'),(66,128,0,4,'/1/8/182-227224.jpg'),(76,73,0,5,'ΣΑΛΑΤΙΕΡΑ ΠΟΡΣΕΛΑΝΗΣ \"ELEGANT MAITER\" 23εκ.'),(77,84,0,5,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(78,86,0,5,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(79,87,0,5,'/2/1/213-160214.jpg'),(80,88,0,5,'/2/1/213-160214.jpg'),(81,89,0,5,'/2/1/213-160214.jpg'),(82,106,0,5,'container2'),(83,118,0,5,'0'),(84,121,0,5,'kalathi-aplyton-me-kapaki-67l-dantela-mepz-4'),(85,127,0,5,'2'),(86,128,0,5,'/2/1/213-160214.jpg'),(96,73,0,6,'ΗΛΕΚΤΡΙΚΗ ΣΚΟΥΠΑ ΚΥΚΛΩΝΙΚΗΣ ΤΕΧΝΟΛΟΓΙΑΣ, \"VICKO\" 700W.'),(97,84,0,6,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(98,86,0,6,'ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ ΚΑΛΑΘΙ ΑΠΛΥΤΩΝ ΜΕ ΚΑΠΑΚΙ 67L \"ΔΑΝΤΕΛΑ\" ΜΕΠΖ'),(99,87,0,6,'/8/6/863-8079.jpg'),(100,88,0,6,'/8/6/863-8079.jpg'),(101,89,0,6,'/8/6/863-8079.jpg'),(102,106,0,6,'container2'),(103,118,0,6,'0'),(104,121,0,6,'kalathi-aplyton-me-kapaki-67l-dantela-mepz-5'),(105,127,0,6,'2'),(106,128,0,6,'/8/6/863-8079.jpg'),(2931,73,0,223,'ΕΙΚΟΝΑ 17χ21εκ. ΠΑΡ/ΜΗ \"ΠΑΝΑΓΙΑ ΓΛΥΚΟΦΙΛΟΥΣΑ\"'),(2932,121,0,223,'ikona-17ch21ek.-parmi-panagia-glikofilousa-035035815'),(2933,148,0,223,'179230'),(2934,73,1,223,'ΕΙΚΟΝΑ 17χ21εκ. ΠΑΡ/ΜΗ \"ΠΑΝΑΓΙΑ ΓΛΥΚΟΦΙΛΟΥΣΑ\"'),(2935,106,1,223,'container2'),(2936,118,1,223,'0'),(2937,118,2,223,'0'),(2938,121,1,223,'ikona-17ch21ek.-parmi-panagia-glikofilousa-035035815'),(2939,73,2,223,'RELIGIOUS 17x21cm PICTURE VIRGIN SILVER RECTANGULAR'),(2940,106,2,223,'container2'),(2941,121,2,223,'ikona-17ch21ek.-parmi-panagia-glikofilousa-035035815'),(2942,106,0,223,'container2'),(2943,118,0,223,'0'),(2944,122,0,223,'ikona-17ch21ek.-parmi-panagia-glikofilousa-035035815'),(2945,73,0,224,'ΜΕΤΑΛΛΙΚΟΣ ΚΑΛΟΓΕΡΟΣ ΓΙΑ ΚΟΥΠΕΣ 36ΕΚ.'),(2946,106,0,224,'container2'),(2947,118,0,224,'0'),(2948,121,0,224,'metallikos-kalogeros-gia-koupes-36ek.-371001'),(2949,148,0,224,'22250'),(2950,73,1,224,'ΜΕΤΑΛΛΙΚΟΣ ΚΑΛΟΓΕΡΟΣ ΓΙΑ ΚΟΥΠΕΣ 36ΕΚ.'),(2951,106,1,224,'container2'),(2952,118,1,224,'0'),(2953,118,2,224,'0'),(2954,121,1,224,'metallikos-kalogeros-gia-koupes-36ek.-371001'),(2955,73,2,224,'IRON WIRE CUP TREE HOLDER 36CM.'),(2956,106,2,224,'container2'),(2957,121,2,224,'metallikos-kalogeros-gia-koupes-36ek.-371001'),(2958,122,0,224,'metallikos-kalogeros-gia-koupes-36ek.-371001'),(2959,73,0,225,'ΣΕΤ 3 ΤΜΧ. ΚΑΛΑΜΑΚΙΑ ΑΝΟΞΕΙΔΩΤΑ 22ΕΚ. & ΒΟΥΡΤΣΑΚΙ ΚΑΘΑΡΙΣΜΟΥ'),(2960,106,0,225,'container2'),(2961,118,0,225,'0'),(2962,121,0,225,'set-3-tmch.-kalamakia-anoxidota-22ek.--vourtsaki-katharismou-351300304'),(2963,148,0,225,'296790'),(2964,73,1,225,'ΣΕΤ 3 ΤΜΧ. ΚΑΛΑΜΑΚΙΑ ΑΝΟΞΕΙΔΩΤΑ 22ΕΚ. & ΒΟΥΡΤΣΑΚΙ ΚΑΘΑΡΙΣΜΟΥ'),(2965,106,1,225,'container2'),(2966,118,1,225,'0'),(2967,118,2,225,'0'),(2968,121,1,225,'set-3-tmch.-kalamakia-anoxidota-22ek.--vourtsaki-katharismou-351300304'),(2969,73,2,225,'SET OF 3 PCS STAINLESS STRAWS 22VM. & CLEANING BRUSH'),(2970,106,2,225,'container2'),(2971,121,2,225,'set-3-tmch.-kalamakia-anoxidota-22ek.--vourtsaki-katharismou-351300304'),(2972,122,0,225,'set-3-tmch.-kalamakia-anoxidota-22ek.--vourtsaki-katharismou-351300304'),(2973,73,0,226,'ΠΗΡΟΥΝΑ ΨΗΤΟΥ ΑΝΟΞΕΙΔΩΤΗ'),(2974,106,0,226,'container2'),(2975,118,0,226,'0'),(2976,121,0,226,'pirouna-psitou-anoxidoti-351315003'),(2977,148,0,226,'252490'),(2978,73,1,226,'ΠΗΡΟΥΝΑ ΨΗΤΟΥ ΑΝΟΞΕΙΔΩΤΗ'),(2979,106,1,226,'container2'),(2980,118,1,226,'0'),(2981,118,2,226,'0'),(2982,121,1,226,'pirouna-psitou-anoxidoti-351315003'),(2983,73,2,226,'STAINLESS STEEL MEAT FORK'),(2984,106,2,226,'container2'),(2985,121,2,226,'pirouna-psitou-anoxidoti-351315003'),(2986,122,0,226,'pirouna-psitou-anoxidoti-351315003'),(2987,73,0,227,'ΚΟΥΤΑΛΑ ΑΝΟΞΕΙΔΩΤΗ'),(2988,106,0,227,'container2'),(2989,118,0,227,'0'),(2990,121,0,227,'koutala-anoxidoti-351315004'),(2991,148,0,227,'252500'),(2992,73,1,227,'ΚΟΥΤΑΛΑ ΑΝΟΞΕΙΔΩΤΗ'),(2993,106,1,227,'container2'),(2994,118,1,227,'0'),(2995,118,2,227,'0'),(2996,121,1,227,'koutala-anoxidoti-351315004'),(2997,73,2,227,'STAINLESS STEEL SPOON'),(2998,106,2,227,'container2'),(2999,121,2,227,'koutala-anoxidoti-351315004'),(3000,122,0,227,'koutala-anoxidoti-351315004'),(3001,73,0,228,'ΣΠΑΤΟΥΛΑ ΑΝΟΞΕΙΔΩΤΗ ΤΡΥΠΗΤΗ'),(3002,106,0,228,'container2'),(3003,118,0,228,'0'),(3004,121,0,228,'spatoula-anoxidoti-tripiti-351315005'),(3005,148,0,228,'252510'),(3006,73,1,228,'ΣΠΑΤΟΥΛΑ ΑΝΟΞΕΙΔΩΤΗ ΤΡΥΠΗΤΗ'),(3007,106,1,228,'container2'),(3008,118,1,228,'0'),(3009,118,2,228,'0'),(3010,121,1,228,'spatoula-anoxidoti-tripiti-351315005'),(3011,73,2,228,'STAINLESS STEEL SLOTTED TURNER'),(3012,106,2,228,'container2'),(3013,121,2,228,'spatoula-anoxidoti-tripiti-351315005'),(3014,122,0,228,'spatoula-anoxidoti-tripiti-351315005'),(3015,73,0,229,'ΚΟΥΤΑΛΑ ΑΝΟΞΕΙΔΩΤΗ ΡΑΓΟΥ'),(3016,106,0,229,'container2'),(3017,118,0,229,'0'),(3018,121,0,229,'koutala-anoxidoti-ragou-351315006'),(3019,148,0,229,'252520'),(3020,73,1,229,'ΚΟΥΤΑΛΑ ΑΝΟΞΕΙΔΩΤΗ ΡΑΓΟΥ'),(3021,106,1,229,'container2'),(3022,118,1,229,'0'),(3023,118,2,229,'0'),(3024,121,1,229,'koutala-anoxidoti-ragou-351315006'),(3025,73,2,229,'STAINLESS STEEL SOLID SPOON'),(3026,106,2,229,'container2'),(3027,121,2,229,'koutala-anoxidoti-ragou-351315006'),(3028,122,0,229,'koutala-anoxidoti-ragou-351315006'),(3029,73,0,230,'ΚΟΥΤΑΛΑ ΣΕΡΒΙΡΙΣΜΑΤΟΣ ΜΑΚΑΡΟΝΙΩΝ ΑΝΟΞΕΙΔΩΤΗ'),(3030,106,0,230,'container2'),(3031,118,0,230,'0'),(3032,121,0,230,'koutala-servirismatos-makaronion-anoxidoti-351315008'),(3033,148,0,230,'252540'),(3034,73,1,230,'ΚΟΥΤΑΛΑ ΣΕΡΒΙΡΙΣΜΑΤΟΣ ΜΑΚΑΡΟΝΙΩΝ ΑΝΟΞΕΙΔΩΤΗ'),(3035,106,1,230,'container2'),(3036,118,1,230,'0'),(3037,118,2,230,'0'),(3038,121,1,230,'koutala-servirismatos-makaronion-anoxidoti-351315008'),(3039,73,2,230,'STAINLESS STEEL SPAGHETTI SERVER'),(3040,106,2,230,'container2'),(3041,121,2,230,'koutala-servirismatos-makaronion-anoxidoti-351315008'),(3042,122,0,230,'koutala-servirismatos-makaronion-anoxidoti-351315008'),(3043,73,0,231,'ΚΟΥΤΑΛΑ ΣΟΥΠΑΣ ΑΝΟΞΕΙΔΩΤΗ 33ΕΚ.'),(3044,106,0,231,'container2'),(3045,118,0,231,'0'),(3046,121,0,231,'koutala-soupas-anoxidoti-33ek.-351325201'),(3047,148,0,231,'252400'),(3048,73,1,231,'ΚΟΥΤΑΛΑ ΣΟΥΠΑΣ ΑΝΟΞΕΙΔΩΤΗ 33ΕΚ.'),(3049,106,1,231,'container2'),(3050,118,1,231,'0'),(3051,118,2,231,'0'),(3052,121,1,231,'koutala-soupas-anoxidoti-33ek.-351325201'),(3053,73,2,231,'STAINLESS STEEL SOUP LADLE 33CM.'),(3054,106,2,231,'container2'),(3055,121,2,231,'koutala-soupas-anoxidoti-33ek.-351325201'),(3056,122,0,231,'koutala-soupas-anoxidoti-33ek.-351325201'),(3057,73,0,232,'ΚΟΥΤΑΛΑ ΞΑΦΡΙΣΜΑΤΟΣ ΤΡΥΠΗΤΗ ΑΝΟΞΕΙΔΩΤΗ 37ΕΚ.'),(3058,106,0,232,'container2'),(3059,118,0,232,'0'),(3060,121,0,232,'koutala-xafrismatos-tripiti-anoxidoti-37ek.-351325202'),(3061,148,0,232,'252410'),(3062,73,1,232,'ΚΟΥΤΑΛΑ ΞΑΦΡΙΣΜΑΤΟΣ ΤΡΥΠΗΤΗ ΑΝΟΞΕΙΔΩΤΗ 37ΕΚ.'),(3063,106,1,232,'container2'),(3064,118,1,232,'0'),(3065,118,2,232,'0'),(3066,121,1,232,'koutala-xafrismatos-tripiti-anoxidoti-37ek.-351325202'),(3067,73,2,232,'STAINLESS STEEL ROUND SKIMMER 37CM.'),(3068,106,2,232,'container2'),(3069,121,2,232,'koutala-xafrismatos-tripiti-anoxidoti-37ek.-351325202'),(3070,122,0,232,'koutala-xafrismatos-tripiti-anoxidoti-37ek.-351325202'),(3071,73,0,233,'ΚΟΥΤΑΛΑ ΑΝΟΞΕΙΔΩΤΗ 29ΕΚ.'),(3072,106,0,233,'container2'),(3073,118,0,233,'0'),(3074,121,0,233,'koutala-anoxidoti-29ek.-351325204'),(3075,148,0,233,'252430'),(3076,73,1,233,'ΚΟΥΤΑΛΑ ΑΝΟΞΕΙΔΩΤΗ 29ΕΚ.'),(3077,106,1,233,'container2'),(3078,118,1,233,'0'),(3079,118,2,233,'0'),(3080,121,1,233,'koutala-anoxidoti-29ek.-351325204'),(3081,73,2,233,'STAINLESS STEEL LADLE 29CM.'),(3082,106,2,233,'container2'),(3083,121,2,233,'koutala-anoxidoti-29ek.-351325204'),(3084,122,0,233,'koutala-anoxidoti-29ek.-351325204');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_varchar_after_insert AFTER INSERT ON catalog_product_entity_varchar FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`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 `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`vickogr_vicko`@`localhost`*/ /*!50003 TRIGGER trg_catalog_product_entity_varchar_after_delete AFTER DELETE ON catalog_product_entity_varchar FOR EACH ROW
BEGIN
INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_product_frontend_action`
--

CREATE TABLE `catalog_product_frontend_action` (
  `action_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product Action ID',
  `type_id` varchar(64) NOT NULL COMMENT 'Type of product action',
  `visitor_id` int(10) unsigned DEFAULT NULL COMMENT 'Visitor ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product ID',
  `added_at` bigint(20) NOT NULL COMMENT 'Added At',
  PRIMARY KEY (`action_id`),
  UNIQUE KEY `CATALOG_PRODUCT_FRONTEND_ACTION_VISITOR_ID_PRODUCT_ID_TYPE_ID` (`visitor_id`,`product_id`,`type_id`),
  UNIQUE KEY `CATALOG_PRODUCT_FRONTEND_ACTION_CUSTOMER_ID_PRODUCT_ID_TYPE_ID` (`customer_id`,`product_id`,`type_id`),
  KEY `CAT_PRD_FRONTEND_ACTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` (`product_id`),
  CONSTRAINT `CAT_PRD_FRONTEND_ACTION_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_FRONTEND_ACTION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Frontend Action Table';

--
-- Dumping data for table `catalog_product_frontend_action`
--


--
-- Table structure for table `catalog_product_index_eav`
--

CREATE TABLE `catalog_product_index_eav` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` int(10) unsigned NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Index Table';

--
-- Dumping data for table `catalog_product_index_eav`
--

INSERT INTO `catalog_product_index_eav` (`entity_id`, `attribute_id`, `store_id`, `value`, `source_id`) VALUES (1,99,1,4,1),(1,99,2,4,1),(2,99,1,4,2),(2,99,2,4,2),(3,99,1,4,3),(3,99,2,4,3),(4,99,1,4,4),(4,99,2,4,4),(5,99,1,4,5),(5,99,2,4,5),(6,99,1,4,6),(6,99,2,4,6),(138,99,1,4,138),(138,99,2,4,138),(139,99,1,4,139),(139,99,2,4,139),(140,99,1,4,140),(140,99,2,4,140),(141,99,1,4,141),(141,99,2,4,141),(142,99,1,4,142),(142,99,2,4,142),(143,99,1,4,143),(143,99,2,4,143),(144,99,1,4,144),(144,99,2,4,144),(145,99,1,4,145),(145,99,2,4,145),(146,99,1,4,146),(146,99,2,4,146),(147,99,1,4,147),(147,99,2,4,147),(148,99,1,4,148),(148,99,2,4,148),(149,99,1,4,149),(149,99,2,4,149),(150,99,1,4,150),(150,99,2,4,150),(151,99,1,4,151),(151,99,2,4,151),(152,99,1,4,152),(152,99,2,4,152),(153,99,1,4,153),(153,99,2,4,153),(154,99,1,4,154),(154,99,2,4,154),(155,99,1,4,155),(155,99,2,4,155),(156,99,1,4,156),(156,99,2,4,156),(157,99,1,4,157),(157,99,2,4,157),(158,99,1,4,158),(158,99,2,4,158),(159,99,1,4,159),(159,99,2,4,159),(160,99,1,4,160),(160,99,2,4,160),(161,99,1,4,161),(161,99,2,4,161),(162,99,1,4,162),(162,99,2,4,162),(163,99,1,4,163),(163,99,2,4,163),(164,99,1,4,164),(164,99,2,4,164),(165,99,1,4,165),(165,99,2,4,165),(166,99,1,4,166),(166,99,2,4,166),(167,99,1,4,167),(167,99,2,4,167),(168,99,1,4,168),(168,99,2,4,168),(169,99,1,4,169),(169,99,2,4,169),(170,99,1,4,170),(170,99,2,4,170),(171,99,1,4,171),(171,99,2,4,171),(172,99,1,4,172),(172,99,2,4,172),(173,99,1,4,173),(173,99,2,4,173),(174,99,1,4,174),(174,99,2,4,174),(175,99,1,4,175),(175,99,2,4,175),(176,99,1,4,176),(176,99,2,4,176),(177,99,1,4,177),(177,99,2,4,177),(178,99,1,4,178),(178,99,2,4,178),(179,99,1,4,179),(179,99,2,4,179),(180,99,1,4,180),(180,99,2,4,180),(181,99,1,4,181),(181,99,2,4,181),(182,99,1,4,182),(182,99,2,4,182),(183,99,1,4,183),(183,99,2,4,183),(184,99,1,4,184),(184,99,2,4,184),(185,99,1,4,185),(185,99,2,4,185),(186,99,1,4,186),(186,99,2,4,186),(187,99,1,4,187),(187,99,2,4,187),(188,99,1,4,188),(188,99,2,4,188),(189,99,1,4,189),(189,99,2,4,189),(190,99,1,4,190),(190,99,2,4,190),(191,99,1,4,191),(191,99,2,4,191),(192,99,1,4,192),(192,99,2,4,192),(193,99,1,4,193),(193,99,2,4,193),(194,99,1,4,194),(194,99,2,4,194),(195,99,1,4,195),(195,99,2,4,195),(196,99,1,4,196),(196,99,2,4,196),(197,99,1,4,197),(197,99,2,4,197),(198,99,1,4,198),(198,99,2,4,198),(199,99,1,4,199),(199,99,2,4,199),(200,99,1,4,200),(200,99,2,4,200),(201,99,1,4,201),(201,99,2,4,201),(202,99,1,4,202),(202,99,2,4,202),(203,99,1,4,203),(203,99,2,4,203),(204,99,1,4,204),(204,99,2,4,204),(205,99,1,4,205),(205,99,2,4,205),(206,99,1,4,206),(206,99,2,4,206),(207,99,1,4,207),(207,99,2,4,207),(208,99,1,4,208),(208,99,2,4,208),(209,99,1,4,209),(209,99,2,4,209),(210,99,1,4,210),(210,99,2,4,210),(212,99,1,4,212),(212,99,2,4,212),(213,99,1,4,213),(213,99,2,4,213),(214,99,1,4,214),(214,99,2,4,214),(215,99,1,4,215),(215,99,2,4,215),(216,99,1,4,216),(216,99,2,4,216),(217,99,1,4,217),(217,99,2,4,217),(218,99,1,4,218),(218,99,2,4,218),(219,99,1,4,219),(219,99,2,4,219),(220,99,1,4,220),(220,99,2,4,220),(221,99,1,4,221),(221,99,2,4,221),(222,99,1,4,222),(222,99,2,4,222),(223,99,1,4,223),(223,99,2,4,223),(223,147,1,5431,223),(223,147,2,5431,223),(224,99,1,4,224),(224,99,2,4,224),(224,147,1,5431,224),(224,147,2,5431,224),(225,99,1,4,225),(225,99,2,4,225),(225,147,1,5431,225),(225,147,2,5431,225),(226,99,1,4,226),(226,99,2,4,226),(226,147,1,5431,226),(226,147,2,5431,226),(227,99,1,4,227),(227,99,2,4,227),(227,147,1,5431,227),(227,147,2,5431,227),(228,99,1,4,228),(228,99,2,4,228),(228,147,1,5431,228),(228,147,2,5431,228),(229,99,1,4,229),(229,99,2,4,229),(229,147,1,5431,229),(229,147,2,5431,229),(230,99,1,4,230),(230,99,2,4,230),(230,147,1,5431,230),(230,147,2,5431,230),(231,99,1,4,231),(231,99,2,4,231),(231,147,1,5431,231),(231,147,2,5431,231),(232,99,1,4,232),(232,99,2,4,232),(232,147,1,5431,232),(232,147,2,5431,232),(233,99,1,4,233),(233,99,2,4,233),(233,147,1,5431,233),(233,147,2,5431,233);

--
-- Table structure for table `catalog_product_index_eav_decimal`
--

CREATE TABLE `catalog_product_index_eav_decimal` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` decimal(12,4) NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Decimal Index Table';

--
-- Dumping data for table `catalog_product_index_eav_decimal`
--


--
-- Table structure for table `catalog_product_index_eav_decimal_idx`
--

CREATE TABLE `catalog_product_index_eav_decimal_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` decimal(12,4) NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_IDX_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Decimal Indexer Index Table';

--
-- Dumping data for table `catalog_product_index_eav_decimal_idx`
--


--
-- Table structure for table `catalog_product_index_eav_decimal_replica`
--

CREATE TABLE `catalog_product_index_eav_decimal_replica` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` decimal(12,4) NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Decimal Index Table';

--
-- Dumping data for table `catalog_product_index_eav_decimal_replica`
--


--
-- Table structure for table `catalog_product_index_eav_decimal_tmp`
--

CREATE TABLE `catalog_product_index_eav_decimal_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` decimal(12,4) NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_DECIMAL_TMP_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Decimal Indexer Temp Table';

--
-- Dumping data for table `catalog_product_index_eav_decimal_tmp`
--


--
-- Table structure for table `catalog_product_index_eav_idx`
--

CREATE TABLE `catalog_product_index_eav_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` int(10) unsigned NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_IDX_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_IDX_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_IDX_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Indexer Index Table';

--
-- Dumping data for table `catalog_product_index_eav_idx`
--


--
-- Table structure for table `catalog_product_index_eav_replica`
--

CREATE TABLE `catalog_product_index_eav_replica` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` int(10) unsigned NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Index Table';

--
-- Dumping data for table `catalog_product_index_eav_replica`
--

INSERT INTO `catalog_product_index_eav_replica` (`entity_id`, `attribute_id`, `store_id`, `value`, `source_id`) VALUES (1,99,1,4,1),(1,99,2,4,1),(2,99,1,4,2),(2,99,2,4,2),(3,99,1,4,3),(3,99,2,4,3),(4,99,1,4,4),(4,99,2,4,4),(5,99,1,4,5),(5,99,2,4,5),(6,99,1,4,6),(6,99,2,4,6),(138,99,1,4,138),(138,99,2,4,138),(139,99,1,4,139),(139,99,2,4,139),(140,99,1,4,140),(140,99,2,4,140),(141,99,1,4,141),(141,99,2,4,141),(142,99,1,4,142),(142,99,2,4,142),(143,99,1,4,143),(143,99,2,4,143),(144,99,1,4,144),(144,99,2,4,144),(145,99,1,4,145),(145,99,2,4,145),(146,99,1,4,146),(146,99,2,4,146),(147,99,1,4,147),(147,99,2,4,147),(148,99,1,4,148),(148,99,2,4,148),(149,99,1,4,149),(149,99,2,4,149),(150,99,1,4,150),(150,99,2,4,150),(151,99,1,4,151),(151,99,2,4,151),(152,99,1,4,152),(152,99,2,4,152),(153,99,1,4,153),(153,99,2,4,153),(154,99,1,4,154),(154,99,2,4,154),(155,99,1,4,155),(155,99,2,4,155),(156,99,1,4,156),(156,99,2,4,156),(157,99,1,4,157),(157,99,2,4,157),(158,99,1,4,158),(158,99,2,4,158),(159,99,1,4,159),(159,99,2,4,159),(160,99,1,4,160),(160,99,2,4,160),(161,99,1,4,161),(161,99,2,4,161),(162,99,1,4,162),(162,99,2,4,162),(163,99,1,4,163),(163,99,2,4,163),(164,99,1,4,164),(164,99,2,4,164),(165,99,1,4,165),(165,99,2,4,165),(166,99,1,4,166),(166,99,2,4,166),(167,99,1,4,167),(167,99,2,4,167),(168,99,1,4,168),(168,99,2,4,168),(169,99,1,4,169),(169,99,2,4,169),(170,99,1,4,170),(170,99,2,4,170),(171,99,1,4,171),(171,99,2,4,171),(172,99,1,4,172),(172,99,2,4,172),(173,99,1,4,173),(173,99,2,4,173),(174,99,1,4,174),(174,99,2,4,174),(175,99,1,4,175),(175,99,2,4,175),(176,99,1,4,176),(176,99,2,4,176),(177,99,1,4,177),(177,99,2,4,177),(178,99,1,4,178),(178,99,2,4,178),(179,99,1,4,179),(179,99,2,4,179),(180,99,1,4,180),(180,99,2,4,180),(181,99,1,4,181),(181,99,2,4,181),(182,99,1,4,182),(182,99,2,4,182),(183,99,1,4,183),(183,99,2,4,183),(184,99,1,4,184),(184,99,2,4,184),(185,99,1,4,185),(185,99,2,4,185),(186,99,1,4,186),(186,99,2,4,186),(187,99,1,4,187),(187,99,2,4,187),(188,99,1,4,188),(188,99,2,4,188),(189,99,1,4,189),(189,99,2,4,189),(190,99,1,4,190),(190,99,2,4,190),(191,99,1,4,191),(191,99,2,4,191),(192,99,1,4,192),(192,99,2,4,192),(193,99,1,4,193),(193,99,2,4,193),(194,99,1,4,194),(194,99,2,4,194),(195,99,1,4,195),(195,99,2,4,195),(196,99,1,4,196),(196,99,2,4,196),(197,99,1,4,197),(197,99,2,4,197),(198,99,1,4,198),(198,99,2,4,198),(199,99,1,4,199),(199,99,2,4,199),(200,99,1,4,200),(200,99,2,4,200),(201,99,1,4,201),(201,99,2,4,201),(202,99,1,4,202),(202,99,2,4,202),(203,99,1,4,203),(203,99,2,4,203),(204,99,1,4,204),(204,99,2,4,204),(205,99,1,4,205),(205,99,2,4,205),(206,99,1,4,206),(206,99,2,4,206),(207,99,1,4,207),(207,99,2,4,207),(208,99,1,4,208),(208,99,2,4,208),(209,99,1,4,209),(209,99,2,4,209),(210,99,1,4,210),(210,99,2,4,210);

--
-- Table structure for table `catalog_product_index_eav_tmp`
--

CREATE TABLE `catalog_product_index_eav_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `value` int(10) unsigned NOT NULL COMMENT 'Value',
  `source_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Original entity ID for attribute value',
  PRIMARY KEY (`entity_id`,`attribute_id`,`store_id`,`value`,`source_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_TMP_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_PRODUCT_INDEX_EAV_TMP_VALUE` (`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product EAV Indexer Temp Table';

--
-- Dumping data for table `catalog_product_index_eav_tmp`
--


--
-- Table structure for table `catalog_product_index_price`
--

CREATE TABLE `catalog_product_index_price` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `final_price` decimal(20,6) DEFAULT NULL COMMENT 'Final Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE` (`min_price`),
  KEY `CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE` (`website_id`,`customer_group_id`,`min_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Index Table';

--
-- Dumping data for table `catalog_product_index_price`
--

INSERT INTO `catalog_product_index_price` (`entity_id`, `customer_group_id`, `website_id`, `tax_class_id`, `price`, `final_price`, `min_price`, `max_price`, `tier_price`) VALUES (1,0,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(1,1,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(1,2,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(1,3,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,0,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,1,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,2,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,3,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,0,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,1,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,2,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,3,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(4,0,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(4,1,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(4,2,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(4,3,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(5,0,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(5,1,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(5,2,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(5,3,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(6,0,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(6,1,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(6,2,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(6,3,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(223,0,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(223,1,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(223,2,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(223,3,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(224,0,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(224,1,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(224,2,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(224,3,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(225,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(225,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(225,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(225,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(226,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(226,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(226,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(226,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(227,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(227,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(227,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(227,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(228,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(228,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(228,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(228,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(229,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(229,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(229,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(229,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(230,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(230,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(230,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(230,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(231,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(231,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(231,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(231,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(232,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(232,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(232,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(232,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(233,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(233,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(233,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(233,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL);

--
-- Table structure for table `catalog_product_index_price_bundle_idx`
--

CREATE TABLE `catalog_product_index_price_bundle_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `price_type` smallint(5) unsigned NOT NULL COMMENT 'Price Type',
  `special_price` decimal(20,6) DEFAULT NULL COMMENT 'Special Price',
  `tier_percent` decimal(20,6) DEFAULT NULL COMMENT 'Tier Percent',
  `orig_price` decimal(20,6) DEFAULT NULL COMMENT 'Orig Price',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  `base_tier` decimal(20,6) DEFAULT NULL COMMENT 'Base Tier',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Idx';

--
-- Dumping data for table `catalog_product_index_price_bundle_idx`
--


--
-- Table structure for table `catalog_product_index_price_bundle_opt_idx`
--

CREATE TABLE `catalog_product_index_price_bundle_opt_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `alt_price` decimal(20,6) DEFAULT NULL COMMENT 'Alt Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  `alt_tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Alt Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Opt Idx';

--
-- Dumping data for table `catalog_product_index_price_bundle_opt_idx`
--


--
-- Table structure for table `catalog_product_index_price_bundle_opt_tmp`
--

CREATE TABLE `catalog_product_index_price_bundle_opt_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `alt_price` decimal(20,6) DEFAULT NULL COMMENT 'Alt Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  `alt_tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Alt Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Opt Tmp';

--
-- Dumping data for table `catalog_product_index_price_bundle_opt_tmp`
--


--
-- Table structure for table `catalog_product_index_price_bundle_sel_idx`
--

CREATE TABLE `catalog_product_index_price_bundle_sel_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `selection_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Selection ID',
  `group_type` smallint(5) unsigned DEFAULT 0 COMMENT 'Group Type',
  `is_required` smallint(5) unsigned DEFAULT 0 COMMENT 'Is Required',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`,`selection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Sel Idx';

--
-- Dumping data for table `catalog_product_index_price_bundle_sel_idx`
--


--
-- Table structure for table `catalog_product_index_price_bundle_sel_tmp`
--

CREATE TABLE `catalog_product_index_price_bundle_sel_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `selection_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Selection ID',
  `group_type` smallint(5) unsigned DEFAULT 0 COMMENT 'Group Type',
  `is_required` smallint(5) unsigned DEFAULT 0 COMMENT 'Is Required',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`,`selection_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Sel Tmp';

--
-- Dumping data for table `catalog_product_index_price_bundle_sel_tmp`
--


--
-- Table structure for table `catalog_product_index_price_bundle_tmp`
--

CREATE TABLE `catalog_product_index_price_bundle_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `price_type` smallint(5) unsigned NOT NULL COMMENT 'Price Type',
  `special_price` decimal(20,6) DEFAULT NULL COMMENT 'Special Price',
  `tier_percent` decimal(20,6) DEFAULT NULL COMMENT 'Tier Percent',
  `orig_price` decimal(20,6) DEFAULT NULL COMMENT 'Orig Price',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  `base_tier` decimal(20,6) DEFAULT NULL COMMENT 'Base Tier',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Index Price Bundle Tmp';

--
-- Dumping data for table `catalog_product_index_price_bundle_tmp`
--


--
-- Table structure for table `catalog_product_index_price_cfg_opt_agr_idx`
--

CREATE TABLE `catalog_product_index_price_cfg_opt_agr_idx` (
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `child_id` int(10) unsigned NOT NULL COMMENT 'Child ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`parent_id`,`child_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Config Option Aggregate Index Table';

--
-- Dumping data for table `catalog_product_index_price_cfg_opt_agr_idx`
--


--
-- Table structure for table `catalog_product_index_price_cfg_opt_agr_tmp`
--

CREATE TABLE `catalog_product_index_price_cfg_opt_agr_tmp` (
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `child_id` int(10) unsigned NOT NULL COMMENT 'Child ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`parent_id`,`child_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Config Option Aggregate Temp Table';

--
-- Dumping data for table `catalog_product_index_price_cfg_opt_agr_tmp`
--


--
-- Table structure for table `catalog_product_index_price_cfg_opt_idx`
--

CREATE TABLE `catalog_product_index_price_cfg_opt_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Config Option Index Table';

--
-- Dumping data for table `catalog_product_index_price_cfg_opt_idx`
--


--
-- Table structure for table `catalog_product_index_price_cfg_opt_tmp`
--

CREATE TABLE `catalog_product_index_price_cfg_opt_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Config Option Temp Table';

--
-- Dumping data for table `catalog_product_index_price_cfg_opt_tmp`
--


--
-- Table structure for table `catalog_product_index_price_downlod_idx`
--

CREATE TABLE `catalog_product_index_price_downlod_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `min_price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Minimum price',
  `max_price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Maximum price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Indexer Table for price of downloadable products';

--
-- Dumping data for table `catalog_product_index_price_downlod_idx`
--


--
-- Table structure for table `catalog_product_index_price_downlod_tmp`
--

CREATE TABLE `catalog_product_index_price_downlod_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(11) NOT NULL,
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `min_price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Minimum price',
  `max_price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Maximum price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Temporary Indexer Table for price of downloadable products';

--
-- Dumping data for table `catalog_product_index_price_downlod_tmp`
--


--
-- Table structure for table `catalog_product_index_price_final_idx`
--

CREATE TABLE `catalog_product_index_price_final_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `orig_price` decimal(20,6) DEFAULT NULL COMMENT 'Original Price',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  `base_tier` decimal(20,6) DEFAULT NULL COMMENT 'Base Tier',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Final Index Table';

--
-- Dumping data for table `catalog_product_index_price_final_idx`
--


--
-- Table structure for table `catalog_product_index_price_final_tmp`
--

CREATE TABLE `catalog_product_index_price_final_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `orig_price` decimal(20,6) DEFAULT NULL COMMENT 'Original Price',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  `base_tier` decimal(20,6) DEFAULT NULL COMMENT 'Base Tier',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Final Temp Table';

--
-- Dumping data for table `catalog_product_index_price_final_tmp`
--


--
-- Table structure for table `catalog_product_index_price_idx`
--

CREATE TABLE `catalog_product_index_price_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `final_price` decimal(20,6) DEFAULT NULL COMMENT 'Final Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_IDX_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_IDX_WEBSITE_ID` (`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_IDX_MIN_PRICE` (`min_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Index Table';

--
-- Dumping data for table `catalog_product_index_price_idx`
--


--
-- Table structure for table `catalog_product_index_price_opt_agr_idx`
--

CREATE TABLE `catalog_product_index_price_opt_agr_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Option Aggregate Index Table';

--
-- Dumping data for table `catalog_product_index_price_opt_agr_idx`
--


--
-- Table structure for table `catalog_product_index_price_opt_agr_tmp`
--

CREATE TABLE `catalog_product_index_price_opt_agr_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`,`option_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Option Aggregate Temp Table';

--
-- Dumping data for table `catalog_product_index_price_opt_agr_tmp`
--


--
-- Table structure for table `catalog_product_index_price_opt_idx`
--

CREATE TABLE `catalog_product_index_price_opt_idx` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Option Index Table';

--
-- Dumping data for table `catalog_product_index_price_opt_idx`
--


--
-- Table structure for table `catalog_product_index_price_opt_tmp`
--

CREATE TABLE `catalog_product_index_price_opt_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Option Temp Table';

--
-- Dumping data for table `catalog_product_index_price_opt_tmp`
--


--
-- Table structure for table `catalog_product_index_price_replica`
--

CREATE TABLE `catalog_product_index_price_replica` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `final_price` decimal(20,6) DEFAULT NULL COMMENT 'Final Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_MIN_PRICE` (`min_price`),
  KEY `CAT_PRD_IDX_PRICE_WS_ID_CSTR_GROUP_ID_MIN_PRICE` (`website_id`,`customer_group_id`,`min_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Index Table';

--
-- Dumping data for table `catalog_product_index_price_replica`
--

INSERT INTO `catalog_product_index_price_replica` (`entity_id`, `customer_group_id`, `website_id`, `tax_class_id`, `price`, `final_price`, `min_price`, `max_price`, `tier_price`) VALUES (1,0,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(1,1,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(1,2,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(1,3,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,0,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,1,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,2,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(2,3,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,0,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,1,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,2,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(3,3,1,2,17.900000,17.900000,17.900000,17.900000,NULL),(4,0,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(4,1,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(4,2,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(4,3,1,2,27.900000,17.900000,17.900000,17.900000,NULL),(5,0,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(5,1,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(5,2,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(5,3,1,2,17.900000,15.000000,15.000000,15.000000,NULL),(6,0,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(6,1,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(6,2,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(6,3,1,2,17.900000,10.000000,10.000000,10.000000,NULL),(138,0,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(138,1,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(138,2,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(138,3,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(139,0,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(139,1,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(139,2,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(139,3,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(140,0,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(140,1,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(140,2,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(140,3,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(141,0,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(141,1,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(141,2,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(141,3,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(142,0,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(142,1,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(142,2,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(142,3,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(143,0,1,2,79.000000,79.000000,79.000000,79.000000,NULL),(143,1,1,2,79.000000,79.000000,79.000000,79.000000,NULL),(143,2,1,2,79.000000,79.000000,79.000000,79.000000,NULL),(143,3,1,2,79.000000,79.000000,79.000000,79.000000,NULL),(144,0,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(144,1,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(144,2,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(144,3,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(145,0,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(145,1,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(145,2,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(145,3,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(146,0,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(146,1,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(146,2,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(146,3,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(147,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(147,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(147,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(147,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(148,0,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(148,1,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(148,2,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(148,3,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(149,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(149,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(149,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(149,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(150,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(150,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(150,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(150,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(151,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(151,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(151,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(151,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(152,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(152,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(152,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(152,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(153,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(153,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(153,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(153,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(154,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(154,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(154,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(154,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(155,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(155,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(155,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(155,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(156,0,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(156,1,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(156,2,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(156,3,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(157,0,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(157,1,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(157,2,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(157,3,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(158,0,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(158,1,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(158,2,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(158,3,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(159,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(159,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(159,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(159,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(160,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(160,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(160,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(160,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(161,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(161,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(161,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(161,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(162,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(162,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(162,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(162,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(163,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(163,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(163,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(163,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(164,0,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(164,1,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(164,2,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(164,3,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(165,0,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(165,1,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(165,2,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(165,3,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(166,0,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(166,1,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(166,2,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(166,3,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(167,0,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(167,1,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(167,2,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(167,3,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(168,0,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(168,1,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(168,2,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(168,3,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(169,0,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(169,1,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(169,2,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(169,3,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(170,0,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(170,1,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(170,2,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(170,3,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(171,0,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(171,1,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(171,2,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(171,3,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(172,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(172,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(172,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(172,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(173,0,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(173,1,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(173,2,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(173,3,1,2,8.000000,8.000000,8.000000,8.000000,NULL),(174,0,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(174,1,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(174,2,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(174,3,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(175,0,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(175,1,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(175,2,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(175,3,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(176,0,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(176,1,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(176,2,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(176,3,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(177,0,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(177,1,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(177,2,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(177,3,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(178,0,1,2,9.000000,9.000000,9.000000,9.000000,NULL),(178,1,1,2,9.000000,9.000000,9.000000,9.000000,NULL),(178,2,1,2,9.000000,9.000000,9.000000,9.000000,NULL),(178,3,1,2,9.000000,9.000000,9.000000,9.000000,NULL),(179,0,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(179,1,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(179,2,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(179,3,1,2,0.000000,0.000000,0.000000,0.000000,NULL),(180,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(180,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(180,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(180,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(181,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(181,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(181,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(181,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(182,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(182,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(182,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(182,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(183,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(183,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(183,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(183,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(184,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(184,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(184,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(184,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(185,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(185,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(185,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(185,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(186,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(186,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(186,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(186,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(187,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(187,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(187,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(187,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(188,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(188,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(188,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(188,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(189,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(189,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(189,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(189,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(190,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(190,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(190,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(190,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(191,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(191,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(191,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(191,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(192,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(192,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(192,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(192,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(193,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(193,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(193,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(193,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(194,0,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(194,1,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(194,2,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(194,3,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(195,0,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(195,1,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(195,2,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(195,3,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(196,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(196,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(196,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(196,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(197,0,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(197,1,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(197,2,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(197,3,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(198,0,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(198,1,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(198,2,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(198,3,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(199,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(199,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(199,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(199,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(200,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(200,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(200,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(200,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(201,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(201,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(201,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(201,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(202,0,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(202,1,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(202,2,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(202,3,1,2,2.000000,2.000000,2.000000,2.000000,NULL),(203,0,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(203,1,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(203,2,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(203,3,1,2,3.000000,3.000000,3.000000,3.000000,NULL),(204,0,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(204,1,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(204,2,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(204,3,1,2,4.000000,4.000000,4.000000,4.000000,NULL),(205,0,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(205,1,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(205,2,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(205,3,1,2,5.000000,5.000000,5.000000,5.000000,NULL),(206,0,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(206,1,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(206,2,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(206,3,1,2,1.000000,1.000000,1.000000,1.000000,NULL),(207,0,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(207,1,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(207,2,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(207,3,1,2,6.000000,6.000000,6.000000,6.000000,NULL),(208,0,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(208,1,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(208,2,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(208,3,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(209,0,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(209,1,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(209,2,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(209,3,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(210,0,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(210,1,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(210,2,1,2,7.000000,7.000000,7.000000,7.000000,NULL),(210,3,1,2,7.000000,7.000000,7.000000,7.000000,NULL);

--
-- Table structure for table `catalog_product_index_price_tmp`
--

CREATE TABLE `catalog_product_index_price_tmp` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `tax_class_id` smallint(5) unsigned DEFAULT 0 COMMENT 'Tax Class ID',
  `price` decimal(20,6) DEFAULT NULL COMMENT 'Price',
  `final_price` decimal(20,6) DEFAULT NULL COMMENT 'Final Price',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  `max_price` decimal(20,6) DEFAULT NULL COMMENT 'Max Price',
  `tier_price` decimal(20,6) DEFAULT NULL COMMENT 'Tier Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_TMP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_TMP_WEBSITE_ID` (`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_PRICE_TMP_MIN_PRICE` (`min_price`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Price Indexer Temp Table';

--
-- Dumping data for table `catalog_product_index_price_tmp`
--


--
-- Table structure for table `catalog_product_index_tier_price`
--

CREATE TABLE `catalog_product_index_tier_price` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `min_price` decimal(20,6) DEFAULT NULL COMMENT 'Min Price',
  PRIMARY KEY (`entity_id`,`customer_group_id`,`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_TIER_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_INDEX_TIER_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CAT_PRD_IDX_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_IDX_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_IDX_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 Index Table';

--
-- Dumping data for table `catalog_product_index_tier_price`
--


--
-- Table structure for table `catalog_product_index_website`
--

CREATE TABLE `catalog_product_index_website` (
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `default_store_id` smallint(5) unsigned NOT NULL COMMENT 'Default store ID for website',
  `website_date` date DEFAULT NULL COMMENT 'Website Date',
  `rate` float DEFAULT 1 COMMENT 'Rate',
  PRIMARY KEY (`website_id`),
  KEY `CATALOG_PRODUCT_INDEX_WEBSITE_WEBSITE_DATE` (`website_date`),
  CONSTRAINT `CAT_PRD_IDX_WS_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 Website Index Table';

--
-- Dumping data for table `catalog_product_index_website`
--

INSERT INTO `catalog_product_index_website` (`website_id`, `default_store_id`, `website_date`, `rate`) VALUES (1,1,'2020-03-27',1);

--
-- Table structure for table `catalog_product_link`
--

CREATE TABLE `catalog_product_link` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `linked_product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Linked Product ID',
  `link_type_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Link Type ID',
  PRIMARY KEY (`link_id`),
  UNIQUE KEY `CATALOG_PRODUCT_LINK_LINK_TYPE_ID_PRODUCT_ID_LINKED_PRODUCT_ID` (`link_type_id`,`product_id`,`linked_product_id`),
  KEY `CATALOG_PRODUCT_LINK_PRODUCT_ID` (`product_id`),
  KEY `CATALOG_PRODUCT_LINK_LINKED_PRODUCT_ID` (`linked_product_id`),
  CONSTRAINT `CATALOG_PRODUCT_LINK_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_LNK_LNKED_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`linked_product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_LNK_LNK_TYPE_ID_CAT_PRD_LNK_TYPE_LNK_TYPE_ID` FOREIGN KEY (`link_type_id`) REFERENCES `catalog_product_link_type` (`link_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product To Product Linkage Table';

--
-- Dumping data for table `catalog_product_link`
--


--
-- Table structure for table `catalog_product_link_attribute`
--

CREATE TABLE `catalog_product_link_attribute` (
  `product_link_attribute_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product Link Attribute ID',
  `link_type_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Link Type ID',
  `product_link_attribute_code` varchar(32) DEFAULT NULL COMMENT 'Product Link Attribute Code',
  `data_type` varchar(32) DEFAULT NULL COMMENT 'Data Type',
  PRIMARY KEY (`product_link_attribute_id`),
  KEY `CATALOG_PRODUCT_LINK_ATTRIBUTE_LINK_TYPE_ID` (`link_type_id`),
  CONSTRAINT `CAT_PRD_LNK_ATTR_LNK_TYPE_ID_CAT_PRD_LNK_TYPE_LNK_TYPE_ID` FOREIGN KEY (`link_type_id`) REFERENCES `catalog_product_link_type` (`link_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Link Attribute Table';

--
-- Dumping data for table `catalog_product_link_attribute`
--

INSERT INTO `catalog_product_link_attribute` (`product_link_attribute_id`, `link_type_id`, `product_link_attribute_code`, `data_type`) VALUES (1,1,'position','int'),(2,4,'position','int'),(3,5,'position','int'),(4,3,'position','int'),(5,3,'qty','decimal');

--
-- Table structure for table `catalog_product_link_attribute_decimal`
--

CREATE TABLE `catalog_product_link_attribute_decimal` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `product_link_attribute_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Product Link Attribute ID',
  `link_id` int(10) unsigned NOT NULL COMMENT 'Link ID',
  `value` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CAT_PRD_LNK_ATTR_DEC_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
  KEY `CATALOG_PRODUCT_LINK_ATTRIBUTE_DECIMAL_LINK_ID` (`link_id`),
  CONSTRAINT `CAT_PRD_LNK_ATTR_DEC_LNK_ID_CAT_PRD_LNK_LNK_ID` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_AB2EFA9A14F7BCF1D5400056203D14B6` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Link Decimal Attribute Table';

--
-- Dumping data for table `catalog_product_link_attribute_decimal`
--


--
-- Table structure for table `catalog_product_link_attribute_int`
--

CREATE TABLE `catalog_product_link_attribute_int` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `product_link_attribute_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Product Link Attribute ID',
  `link_id` int(10) unsigned NOT NULL COMMENT 'Link ID',
  `value` int(11) NOT NULL DEFAULT 0 COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CAT_PRD_LNK_ATTR_INT_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
  KEY `CATALOG_PRODUCT_LINK_ATTRIBUTE_INT_LINK_ID` (`link_id`),
  CONSTRAINT `CAT_PRD_LNK_ATTR_INT_LNK_ID_CAT_PRD_LNK_LNK_ID` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D6D878F8BA2A4282F8DDED7E6E3DE35C` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Link Integer Attribute Table';

--
-- Dumping data for table `catalog_product_link_attribute_int`
--


--
-- Table structure for table `catalog_product_link_attribute_varchar`
--

CREATE TABLE `catalog_product_link_attribute_varchar` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `product_link_attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Product Link Attribute ID',
  `link_id` int(10) unsigned NOT NULL COMMENT 'Link ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CAT_PRD_LNK_ATTR_VCHR_PRD_LNK_ATTR_ID_LNK_ID` (`product_link_attribute_id`,`link_id`),
  KEY `CATALOG_PRODUCT_LINK_ATTRIBUTE_VARCHAR_LINK_ID` (`link_id`),
  CONSTRAINT `CAT_PRD_LNK_ATTR_VCHR_LNK_ID_CAT_PRD_LNK_LNK_ID` FOREIGN KEY (`link_id`) REFERENCES `catalog_product_link` (`link_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DEE9C4DA61CFCC01DFCF50F0D79CEA51` FOREIGN KEY (`product_link_attribute_id`) REFERENCES `catalog_product_link_attribute` (`product_link_attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Link Varchar Attribute Table';

--
-- Dumping data for table `catalog_product_link_attribute_varchar`
--


--
-- Table structure for table `catalog_product_link_type`
--

CREATE TABLE `catalog_product_link_type` (
  `link_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link Type ID',
  `code` varchar(32) DEFAULT NULL COMMENT 'Code',
  PRIMARY KEY (`link_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Link Type Table';

--
-- Dumping data for table `catalog_product_link_type`
--

INSERT INTO `catalog_product_link_type` (`link_type_id`, `code`) VALUES (1,'relation'),(3,'super'),(4,'up_sell'),(5,'cross_sell');

--
-- Table structure for table `catalog_product_option`
--

CREATE TABLE `catalog_product_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `type` varchar(50) DEFAULT NULL COMMENT 'Type',
  `is_require` smallint(6) NOT NULL DEFAULT 1 COMMENT 'Is Required',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `max_characters` int(10) unsigned DEFAULT NULL COMMENT 'Max Characters',
  `file_extension` varchar(50) DEFAULT NULL COMMENT 'File Extension',
  `image_size_x` smallint(5) unsigned DEFAULT NULL COMMENT 'Image Size X',
  `image_size_y` smallint(5) unsigned DEFAULT NULL COMMENT 'Image Size Y',
  `sort_order` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
  PRIMARY KEY (`option_id`),
  KEY `CATALOG_PRODUCT_OPTION_PRODUCT_ID` (`product_id`),
  CONSTRAINT `CAT_PRD_OPT_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 Option Table';

--
-- Dumping data for table `catalog_product_option`
--


--
-- Table structure for table `catalog_product_option_price`
--

CREATE TABLE `catalog_product_option_price` (
  `option_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Price ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Price',
  `price_type` varchar(7) NOT NULL DEFAULT 'fixed' COMMENT 'Price Type',
  PRIMARY KEY (`option_price_id`),
  UNIQUE KEY `CATALOG_PRODUCT_OPTION_PRICE_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `CATALOG_PRODUCT_OPTION_PRICE_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_OPTION_PRICE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_OPT_PRICE_OPT_ID_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Option Price Table';

--
-- Dumping data for table `catalog_product_option_price`
--


--
-- Table structure for table `catalog_product_option_title`
--

CREATE TABLE `catalog_product_option_title` (
  `option_title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Title ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`option_title_id`),
  UNIQUE KEY `CATALOG_PRODUCT_OPTION_TITLE_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `CATALOG_PRODUCT_OPTION_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_OPTION_TITLE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_OPT_TTL_OPT_ID_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Option Title Table';

--
-- Dumping data for table `catalog_product_option_title`
--


--
-- Table structure for table `catalog_product_option_type_price`
--

CREATE TABLE `catalog_product_option_type_price` (
  `option_type_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Price ID',
  `option_type_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option Type ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `price` decimal(20,6) NOT NULL DEFAULT 0.000000 COMMENT 'Price',
  `price_type` varchar(7) NOT NULL DEFAULT 'fixed' COMMENT 'Price Type',
  PRIMARY KEY (`option_type_price_id`),
  UNIQUE KEY `CATALOG_PRODUCT_OPTION_TYPE_PRICE_OPTION_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
  KEY `CATALOG_PRODUCT_OPTION_TYPE_PRICE_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_OPTION_TYPE_PRICE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B523E3378E8602F376CC415825576B7F` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Option Type Price Table';

--
-- Dumping data for table `catalog_product_option_type_price`
--


--
-- Table structure for table `catalog_product_option_type_title`
--

CREATE TABLE `catalog_product_option_type_title` (
  `option_type_title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Title ID',
  `option_type_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option Type ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`option_type_title_id`),
  UNIQUE KEY `CATALOG_PRODUCT_OPTION_TYPE_TITLE_OPTION_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
  KEY `CATALOG_PRODUCT_OPTION_TYPE_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_OPTION_TYPE_TITLE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C085B9CF2C2A302E8043FDEA1937D6A2` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Option Type Title Table';

--
-- Dumping data for table `catalog_product_option_type_title`
--


--
-- Table structure for table `catalog_product_option_type_value`
--

CREATE TABLE `catalog_product_option_type_value` (
  `option_type_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Option ID',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `sort_order` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Sort Order',
  PRIMARY KEY (`option_type_id`),
  KEY `CATALOG_PRODUCT_OPTION_TYPE_VALUE_OPTION_ID` (`option_id`),
  CONSTRAINT `CAT_PRD_OPT_TYPE_VAL_OPT_ID_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Option Type Value Table';

--
-- Dumping data for table `catalog_product_option_type_value`
--


--
-- Table structure for table `catalog_product_relation`
--

CREATE TABLE `catalog_product_relation` (
  `parent_id` int(10) unsigned NOT NULL COMMENT 'Parent ID',
  `child_id` int(10) unsigned NOT NULL COMMENT 'Child ID',
  PRIMARY KEY (`parent_id`,`child_id`),
  KEY `CATALOG_PRODUCT_RELATION_CHILD_ID` (`child_id`),
  CONSTRAINT `CAT_PRD_RELATION_CHILD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`child_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_RELATION_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Relation Table';

--
-- Dumping data for table `catalog_product_relation`
--


--
-- Table structure for table `catalog_product_super_attribute`
--

CREATE TABLE `catalog_product_super_attribute` (
  `product_super_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product Super Attribute ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Attribute ID',
  `position` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Position',
  PRIMARY KEY (`product_super_attribute_id`),
  UNIQUE KEY `CATALOG_PRODUCT_SUPER_ATTRIBUTE_PRODUCT_ID_ATTRIBUTE_ID` (`product_id`,`attribute_id`),
  CONSTRAINT `CAT_PRD_SPR_ATTR_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 Super Attribute Table';

--
-- Dumping data for table `catalog_product_super_attribute`
--


--
-- Table structure for table `catalog_product_super_attribute_label`
--

CREATE TABLE `catalog_product_super_attribute_label` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `product_super_attribute_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product Super Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT 0 COMMENT 'Store ID',
  `use_default` smallint(5) unsigned DEFAULT 0 COMMENT 'Use Default Value',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CAT_PRD_SPR_ATTR_LBL_PRD_SPR_ATTR_ID_STORE_ID` (`product_super_attribute_id`,`store_id`),
  KEY `CATALOG_PRODUCT_SUPER_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `CATALOG_PRODUCT_SUPER_ATTRIBUTE_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_309442281DF7784210ED82B2CC51E5D5` FOREIGN KEY (`product_super_attribute_id`) REFERENCES `catalog_product_super_attribute` (`product_super_attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Super Attribute Label Table';

--
-- Dumping data for table `catalog_product_super_attribute_label`
--


--
-- Table structure for table `catalog_product_super_link`
--

CREATE TABLE `catalog_product_super_link` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Product ID',
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Parent ID',
  PRIMARY KEY (`link_id`),
  UNIQUE KEY `CATALOG_PRODUCT_SUPER_LINK_PRODUCT_ID_PARENT_ID` (`product_id`,`parent_id`),
  KEY `CATALOG_PRODUCT_SUPER_LINK_PARENT_ID` (`parent_id`),
  CONSTRAINT `CAT_PRD_SPR_LNK_PARENT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`parent_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_SPR_LNK_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 Super Link Table';

--
