--
-- Host: localhost    Database: kw
-- ------------------------------------------------------


--
-- 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` VALUES (1,'2.3.3');

--
-- Table structure for table `admin_passwords`
--

CREATE TABLE `admin_passwords` (
  `password_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Password ID',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User ID',
  `password_hash` varchar(100) DEFAULT NULL COMMENT 'Password Hash',
  `expires` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Deprecated',
  `last_updated` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Last Updated',
  PRIMARY KEY (`password_id`),
  KEY `ADMIN_PASSWORDS_USER_ID` (`user_id`),
  CONSTRAINT `ADMIN_PASSWORDS_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Admin Passwords';

--
-- Dumping data for table `admin_passwords`
--

INSERT INTO `admin_passwords` VALUES (3,3,'e5cca82fe4bd2e3919eb1aad31cbabd20a624de7c24c2504c7aa8552fd0a7f0e:ZPDFcSmVp641Lo4flZrzMjHVWXOs04yr:1',0,1540975356),(9,9,'741556a1a8f3e37f3294fbab7936cd1b56e7d6e4d2b93e63e8fa8812f3db41e2:PbUBUtwHNBCsfWCS9wwgOjoFUleh1Nsl:1',0,1620093004);

--
-- 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 `admin_user`
--

CREATE TABLE `admin_user` (
  `user_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'User ID',
  `firstname` varchar(32) DEFAULT NULL COMMENT 'User First Name',
  `lastname` varchar(32) DEFAULT NULL COMMENT 'User Last Name',
  `email` varchar(128) DEFAULT NULL COMMENT 'User Email',
  `username` varchar(40) DEFAULT NULL COMMENT 'User Login',
  `password` varchar(255) NOT NULL COMMENT 'User Password',
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'User Created Time',
  `modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'User Modified Time',
  `logdate` timestamp NULL DEFAULT NULL COMMENT 'User Last Login Time',
  `lognum` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'User Login Number',
  `reload_acl_flag` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Reload ACL',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'User Is Active',
  `extra` text COMMENT 'User Extra Data',
  `rp_token` text COMMENT 'Reset Password Link Token',
  `rp_token_created_at` timestamp NULL DEFAULT NULL COMMENT 'Reset Password Link Token Creation Date',
  `interface_locale` varchar(16) NOT NULL DEFAULT 'en_US' COMMENT 'Backend interface locale',
  `failures_num` smallint(6) DEFAULT '0' COMMENT 'Failure Number',
  `first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure',
  `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Expiration Lock Dates',
  `refresh_token` text COMMENT 'Email connector refresh token',
  PRIMARY KEY (`user_id`),
  UNIQUE KEY `ADMIN_USER_USERNAME` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='Admin User Table';

--
-- Dumping data for table `admin_user`
--

INSERT INTO `admin_user` VALUES (9,'admin','admin','hou0103@gmail.com','admin','741556a1a8f3e37f3294fbab7936cd1b56e7d6e4d2b93e63e8fa8812f3db41e2:PbUBUtwHNBCsfWCS9wwgOjoFUleh1Nsl:1','2021-05-04 01:50:04','2021-05-04 03:20:41','2021-05-04 03:20:41',2,0,1,'{\"configState\":{\"porto_settings_general\":\"0\",\"porto_settings_optimization\":\"0\",\"porto_settings_header\":\"0\",\"porto_settings_footer\":\"0\",\"porto_settings_category\":\"0\",\"porto_settings_category_grid\":\"0\",\"porto_settings_product\":\"0\",\"porto_settings_richsnippets\":\"0\",\"porto_settings_product_label\":\"0\",\"porto_settings_newsletter\":\"0\",\"porto_settings_contacts\":\"0\",\"porto_settings_custom_settings\":\"1\",\"porto_settings_install\":\"1\",\"porto_design_general\":\"1\",\"porto_design_font\":\"0\",\"porto_design_colors\":\"0\",\"porto_design_header\":\"0\",\"porto_design_footer\":\"0\",\"porto_design_page\":\"0\",\"porto_design_main\":\"0\"}}',NULL,NULL,'en_US',0,NULL,NULL,NULL);

--
-- Table structure for table `admin_user_session`
--

CREATE TABLE `admin_user_session` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `session_id` varchar(128) NOT NULL COMMENT 'Session ID value',
  `user_id` int(10) unsigned DEFAULT NULL COMMENT 'Admin User ID',
  `status` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Current Session status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created Time',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
  `ip` varchar(15) NOT NULL COMMENT 'Remote user IP',
  PRIMARY KEY (`id`),
  KEY `ADMIN_USER_SESSION_SESSION_ID` (`session_id`),
  KEY `ADMIN_USER_SESSION_USER_ID` (`user_id`),
  CONSTRAINT `ADMIN_USER_SESSION_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Admin User sessions table';

--
-- Dumping data for table `admin_user_session`
--

INSERT INTO `admin_user_session` VALUES (9,'20ja3to77frc5l8n63o978pgj2',3,1,'2018-10-30 18:43:57','2018-10-30 19:01:58','::1'),(17,'64950e7da4ae9f740ba7e481dc5f2f15',9,1,'2021-05-04 01:58:28','2021-05-04 02:46:57','::1'),(18,'7a272bd4c18c7402fe654865bcc92daf',9,1,'2021-05-04 03:20:41','2021-05-04 03:23:58','::1');

--
-- 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 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=62 DEFAULT CHARSET=utf8 COMMENT='Adminnotification Inbox';

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

INSERT INTO `adminnotification_inbox` VALUES (1,1,'2016-09-20 00:28:28','Important Updates for WeltPixel Products',' In the past months we made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account. Leave a review or report a bug to any of our products, send us an email and you will receive a 10% discount code. Change logs at this link: http://weltpixel.com/blog/2016/09/19/weltpixels-last-30-days-updates/','http://weltpixel.com/blog/2016/09/19/weltpixels-last-30-days-updates/',1,1),(2,4,'2016-08-01 08:56:40','Title for the second push notification','Lorem ipsum, in dolorem content for notification 2/second','http://weltpixel.com/blog/2',1,1),(3,4,'2016-08-01 06:56:40','Title for the first push notification','Lorem ipsum, in dolorem content for notification1','http://weltpixel.com/blog',1,1),(4,4,'2017-01-19 02:59:15','New Magento DevBox Beta Speeds Magento 2 Setup – 1/19/2017','Magento DevBox Beta makes it faster and easier than ever to setup your Magento 2 development environment. Read our blog post to find out more at: https://magento.com/blog/technical/set-your-magento-2-development-environment-faster.','https://magento.com/blog/technical/set-your-magento-2-development-environment-faster',1,0),(5,1,'2017-02-07 06:02:30','Community Editions 2.1.4 and 2.0.12 Resolve Zend Framework Security Issue & Enhance Product Quality – 2/7/2017','Community Editions 2.1.4 and 2.0.12 address the recent Zend Framework 1 security vulnerability and improve catalog, payments, and sales modules. Review the release notes for more information:  http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html','http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html',1,0),(6,4,'2017-02-17 07:09:01','Inspirational athlete, Serena Williams, will join Magento at Imagine 2017.','Imagine 2017 will bring together 3000+ international commerce experts to exchange ideas on the future of commerce. Don’t miss this opportunity to hear from inspirational athlete, Serena Williams, and Stella & Dot CEO, Jessica Herrin. Join us in Las Vegas, April 3-5. Register now at https://imagine.magento.com/\n','https://imagine.magento.com/',1,0),(7,3,'2017-02-08 18:22:00','Enjoy Sweet Valentine at Mageplaza','&quot;Sweet Valentine 2017! Get 25% off with coupon VALENTINE17 at https://www.mageplaza.com&quot;','https://www.mageplaza.com/?utm_source=notification&utm_medium=rss&utm_campaign=Valentine2017',1,0),(8,1,'2017-02-05 23:00:00','Important WeltPixel Product Updates - January 2017',' In the past months we made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account on www.weltpixel.com. We would like to hear from you - leave a review or report a bug to any of our products. Change logs at this link: http://weltpixel.com/blog/2017/02/06/weltpixel-product-updates-january-2017/','http://weltpixel.com/blog/2017/02/06/weltpixel-product-updates-january-2017/',1,0),(9,4,'2017-02-21 03:06:57','Community Editions 2.1.5 and 2.0.13 Update Magento Copyright – 2/21/2017','Community Editions 2.1.5 and 2.0.13 contain 2017 copyright updates. That’s it. Nothing else. Isolating these changes in a single release is intended to simplify future updates and developer workflow. For more information, please review the release notes:   http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html.','http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html',1,0),(10,3,'2017-03-02 18:22:00','HAPPY INTERNATIONAL WOMEN\'s DAY','&quot;Happy International Women\'s Day! Offer discount 30% for each Magento 2 extension at https://www.mageplaza.com&quot;','https://www.mageplaza.com/?utm_source=notification&utm_medium=rss&utm_campaign=WOMEN30',1,0),(11,1,'2017-03-10 16:00:00','Important WeltPixel Product Updates - March 2017',' We made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account on www.weltpixel.com. We would like to hear from you - leave a review or report a bug to any of our products. Change logs at this link: http://weltpixel.com/blog/2017/03/11/weltpixel-product-updates-march-2017/','http://weltpixel.com/blog/2017/03/11/weltpixel-product-updates-march-2017/',1,0),(12,4,'2017-04-11 03:46:39','Community Edition 2.1.6 Accelerates Performance – 4/11/2017','Community Edition 2.1.6 includes several exciting performance enhancements and optimizations to category pages, layered navigation, and image resizing. Review the release notes for more information: http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html','http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html',1,0),(13,3,'2017-04-24 19:22:00','Shop By Brand 2.1.0 for Magento 2 released','&quot;Compatible with Layered Naivgation, brand friendly URL and import CSV file. Learn more https://www.mageplaza.com&quot;\n','https://www.mageplaza.com/magento-2-shop-by-brand/?utm_source=notification&utm_medium=rss&utm_campaign=RELEASED',1,0),(14,3,'2017-04-12 19:22:00','Eggs Hunter','&quot;Hunt Fantastic Easter Eggs with 15% Coupon when Entering EASTER2017 at https://www.mageplaza.com&quot;\n','https://www.mageplaza.com/?utm_source=notification&utm_medium=rss&utm_campaign=EASTER',1,0),(15,3,'2017-04-11 19:22:00','Social Login Updates','&quot;Fixed Facebook, Google login. Update Hybridauth  lib and more. Learn more at https://goo.gl/kw0aoP&quot;\n','https://www.mageplaza.com/magento-2-social-login-extension/?utm_source=notification&utm_medium=rss&utm_campaign=social-login-updates',1,0),(16,1,'2017-04-04 17:00:00','Important WeltPixel Product Updates - April 2017',' We made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account on www.weltpixel.com. We would like to hear from you - leave a review or report a bug to any of our products. Change logs at this link: https://support.weltpixel.com/hc/en-us/articles/115005534328-WeltPixel-Product-Updates-April-2017','https://support.weltpixel.com/hc/en-us/articles/115005534328-WeltPixel-Product-Updates-April-2017',1,0),(17,1,'2017-05-31 07:01:16','Community Editions 2.1.7 and 2.0.14 Security Enhancements – 5/31/2017','Community Edition 2.1.7 and 2.0.14 include critical security enhancements, provide support for MasterCard BIN range updates, and revert image resizing changes from Enterprise 2.1.6. Review the release notes for more information: http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html','http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html',1,0),(18,3,'2017-05-22 19:22:00','SEO Ultimate pack released','&quot;Full features of SEO extension for Magento 2. 20% Off coupon: SEO20&quot;\n','https://www.mageplaza.com/magento-2-seo-extension/?utm_source=notification&utm_medium=rss&utm_campaign=RELEASED',1,0),(19,3,'2017-04-27 19:22:00','Blog v2.3.0 for Magento 2 released','&quot;Improve Sitemap, router and added cloud tags, Comment, Instant search ... Learn more https://www.mageplaza.com&quot;\n','https://www.mageplaza.com/magento-2-blog-extension/?utm_source=notification&utm_medium=rss&utm_campaign=RELEASED',1,0),(20,1,'2017-05-15 17:00:00','Important WeltPixel Product Updates - May 2017',' We made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account on www.weltpixel.com. We would like to hear from you - leave a review or report a bug to any of our products. Change logs at this link: https://support.weltpixel.com/hc/en-us/articles/115007413648-WeltPixel-Product-Updates-May-2017','https://support.weltpixel.com/hc/en-us/articles/115007413648-WeltPixel-Product-Updates-May-2017',1,0),(21,1,'2017-06-21 03:29:32','Magento Community Edition 2.0.15 is Now Available with an Important PayPal Update. Upgrade by June 30, 2017 to Avoid Service Disruptions – 6/21/2017','As of June 30, 2017, PayPal Instant Payment Notifications will no longer allow you to use HTTP to post messages back to PayPal for verification. To avoid service disruptions, all merchants using PayPal and Magento 2.0.x must upgrade to Community Edition 2.0.15 by June 30, 2017. All Magento 2.1.x versions already support this change, so no update is required. The new version is available from  the Community Edition Download Page (https://magento.com/tech-resources/download) and more information is available from PayPal at https://www.paypal-knowledge.com/infocenter/index?page=content&widgetview=true&id=FAQ1916&viewlocale=en_US','https://magento.com/tech-resources/download ',1,0),(22,4,'2017-07-04 20:25:26','Magento Business Intelligence Essentials: Now Available!','Magento Business Intelligence Essentials helps you and your teams to stay on top of the most important metrics to your business. Essentials works directly with your Magento order and customer data, and provides business insights far beyond what standard web analytics tools provide.\n\nWith Essentials, you can get up and running in only a few minutes and access over 75 pre-built reports instantly. Plus, it comes with a free 7-day trial where no credit card information is required. If you decide to stay, Essentials starts at just $100/month.\n\nFor more information, visit magento.com/products/business-intelligence/essentials.','https://magento.com/products/business-intelligence/essentials',1,0),(23,4,'2017-07-27 08:13:00','Listing your products in marketplaces like Amazon? We want your feedback!','If you sell your products in any marketplace/s today and/or are considering it in the future, we invite you to take our short survey. Your feedback will help us to determine the overall interest and need for integration with marketplace and fulfillment services from companies like Amazon.\n\nThank you in advance.\n\nThe Magento Strategy team','https://www.surveymonkey.com/r/3F5MT75',1,0),(24,3,'2017-07-31 19:00:00','SMTP for Magento 2 released. Configure Email Settings never easier.','&quot;Supports 20+ SMTP service providers, Test Email and email logs.&quot;\n','https://www.mageplaza.com/magento-2-smtp/?utm_source=notification&utm_medium=rss&utm_campaign=RELEASED',1,0),(25,3,'2017-06-30 19:00:00','Happy US Independence Day - Save 25%: AMERICAN25','&quot;Happy US Independence Day - Save 25%: AMERICAN25 (Before 4th July)&quot;\n','https://www.mageplaza.com/?utm_source=notification&utm_medium=rss&utm_campaign=us-independence-day',1,0),(26,3,'2017-06-28 19:00:00','Flash Sales - 20% Off: OSC, Layered Navigation, SEO','&quot;Flash Sales coupon: FS20&quot;\n','https://www.mageplaza.com/?utm_source=notification&utm_medium=rss&utm_campaign=RELEASED',1,0),(27,3,'2017-06-28 19:00:00','One Step Checkout: new features released','&quot;Billing address before shipping address feature released, and more.&quot;\n','https://www.mageplaza.com/magento-2-one-step-checkout-extension/?utm_source=notification&utm_medium=rss&utm_campaign=RELEASED',1,0),(28,1,'2017-07-24 17:00:00','Important WeltPixel Product Updates and Magento Partnership Announcement - July 2017',' We made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account on www.weltpixel.com. We would like to hear from you - leave a review or report a bug to any of our products. Change logs at this link: https://support.weltpixel.com/hc/en-us/articles/115000815254-WeltPixel-Product-Updates-and-Magetno-Partnership-Announcement-July-2017','https://support.weltpixel.com/hc/en-us/articles/115000815254-WeltPixel-Product-Updates-and-Magetno-Partnership-Announcement-July-2017',1,0),(29,4,'2017-08-09 04:30:50','Upgrade to Magento Open Source 2.1.8 for Over 90 Enhancements – 8/8/2017','Magento Open Source (formerly Community Edition) 2.1.8 features over 90 improvements, including cache tuning for better performance, mass action performance optimizations, and faster deployments for multi-language sites. \n\nReview the release notes for more information: http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html','http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html',1,0),(30,2,'2017-09-11 09:52:15','USPS Name Change Impacts “First-Class Mail Parcel” Service – 09/11/2017','USPS changed their “First-Class Mail Parcel” Service to “First-Class Package Service – Retail.” Merchants offering this service must change the name, as “First-Class Mail Parcel” will no longer work. Magento is working on a code update to support this change. In the meantime, information about a workaround is available at http://devdocs.magento.com/guides/v2.1/release-notes/tech_bull_USPS-patch-Sept2017.html','http://devdocs.magento.com/guides/v2.1/release-notes/tech_bull_USPS-patch-Sept2017.html ',1,0),(31,1,'2017-09-14 10:12:36','Important Magento Open Source 2.1.9 and 2.0.16 Security Enhancements – 9/14/2017','Magento Open Source 2.1.9 and 2.0.16 include critical security enhancements and address the September 1 changes to USPS shipping. Please update your site as soon as possible. More information is available in the release notes: \n http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html.\n','http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html',1,0),(32,3,'2017-08-28 19:00:00','Happy Vietnam Independence Day! 29% OFF','We’re proud to be one of the most dedicated Vietnamese pioneers in Magento extensions. We’re striving to grow bigger and thrive along with your business. To observe Vietnam national day Sep 2nd, we’re honored to offer you a big sale on all our extensions. All stuff is 29% off in 5 days only. Hurry up!','https://www.mageplaza.com/promo/vietnam-independence-day-2017/?utm_source=notification&utm_medium=rss&utm_campaign=vietnam-independence-day',1,0),(33,3,'2017-08-09 19:00:00','Who Bought This Also Bought Released, 30% OFF','&quot;Mageplaza Who Bought This Also Bought - SALE 30%, valid before 15th August&quot;\n','https://www.mageplaza.com/magento-2-who-bought-this-also-bought/?utm_source=notification&utm_medium=rss&utm_campaign=RELEASED',1,0),(34,1,'2017-09-21 17:00:00','Important WeltPixel Product Updates - September 2017',' We made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account on www.weltpixel.com. We would like to hear from you - leave a review or report a bug to any of our products. Change logs at this link: https://support.weltpixel.com/hc/en-us/articles/115002193954-WeltPixel-Product-Updates-September-2017','https://support.weltpixel.com/hc/en-us/articles/115002193954-WeltPixel-Product-Updates-September-2017',1,0),(35,3,'2017-08-28 19:00:00','Happy Vietnam Independence Day! 29% OFF','We’re proud to be one of the most dedicated Vietnamese pioneers in Magento extensions. We’re striving to grow bigger and thrive along with your business. To observe Vietnam national day Sep 2nd, we’re honored to offer you a big sale on all our extensions. All stuff is 29% off in 5 days only. Hurry up!','https://www.mageplaza.com/promo/vietnam-independence-day-2017/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=vietnam-independence-day',1,0),(36,3,'2017-08-09 19:00:00','Who Bought This Also Bought Released, 30% OFF','&amp;quot;Mageplaza Who Bought This Also Bought - SALE 30%, valid before 15th August&amp;quot;\n','https://www.mageplaza.com/magento-2-who-bought-this-also-bought/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=RELEASED',1,0),(37,3,'2017-07-31 19:00:00','SMTP for Magento 2 released. Configure Email Settings never easier.','&amp;quot;Supports 20+ SMTP service providers, Test Email and email logs.&amp;quot;\n','https://www.mageplaza.com/magento-2-smtp/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=RELEASED',1,0),(38,3,'2017-06-30 19:00:00','Happy US Independence Day - Save 25%: AMERICAN25','&amp;quot;Happy US Independence Day - Save 25%: AMERICAN25 (Before 4th July)&amp;quot;\n','https://www.mageplaza.com/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=us-independence-day',1,0),(39,3,'2017-06-28 19:00:00','Flash Sales - 20% Off: OSC, Layered Navigation, SEO','&amp;quot;Flash Sales coupon: FS20&amp;quot;\n','https://www.mageplaza.com/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=RELEASED',1,0),(40,3,'2017-06-28 19:00:00','One Step Checkout: new features released','&amp;quot;Billing address before shipping address feature released, and more.&amp;quot;\n','https://www.mageplaza.com/magento-2-one-step-checkout-extension/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=RELEASED',1,0),(41,3,'2017-05-22 19:22:00','SEO Ultimate pack released','&amp;quot;Full features of SEO extension for Magento 2. 20% Off coupon: SEO20&amp;quot;\n','https://www.mageplaza.com/magento-2-seo-extension/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=RELEASED',1,0),(42,3,'2017-04-27 19:22:00','Blog v2.3.0 for Magento 2 released','&amp;quot;Improve Sitemap, router and added cloud tags, Comment, Instant search ... Learn more https://www.mageplaza.com&amp;quot;\n','https://www.mageplaza.com/magento-2-blog-extension/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=RELEASED',1,0),(43,3,'2017-04-24 19:22:00','Shop By Brand 2.1.0 for Magento 2 released','&amp;quot;Compatible with Layered Naivgation, brand friendly URL and import CSV file. Learn more https://www.mageplaza.com&amp;quot;\n','https://www.mageplaza.com/magento-2-shop-by-brand/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=RELEASED',1,0),(44,3,'2017-04-12 19:22:00','Eggs Hunter','&amp;quot;Hunt Fantastic Easter Eggs with 15% Coupon when Entering EASTER2017 at https://www.mageplaza.com&amp;quot;\n','https://www.mageplaza.com/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=EASTER',1,0),(45,3,'2017-04-11 19:22:00','Social Login Updates','&amp;quot;Fixed Facebook, Google login. Update Hybridauth  lib and more. Learn more at https://goo.gl/kw0aoP&amp;quot;\n','https://www.mageplaza.com/magento-2-social-login-extension/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=social-login-updates',1,0),(46,3,'2017-03-02 18:22:00','HAPPY INTERNATIONAL WOMEN\'s DAY','&amp;quot;Happy International Women\'s Day! Offer discount 30% for each Magento 2 extension at https://www.mageplaza.com&amp;quot;\n','https://www.mageplaza.com/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=WOMEN30',1,0),(47,3,'2017-02-08 18:22:00','Enjoy Sweet Valentine at Mageplaza','&amp;quot;Sweet Valentine 2017! Get 25% off with coupon VALENTINE17 at https://www.mageplaza.com&amp;quot;\n','https://www.mageplaza.com/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=Valentine2017',1,0),(48,4,'2017-09-26 09:42:42','Magento Open Source 2.2 Delivers Enhanced Commerce Capabilities – 9/26/2017','Magento Open Source 2.2 includes a range of platform enhancements, including a new deployment process that minimizes production downtime, optimized performance, platform updates that improve developer experience, and Magento Social marketing tools. Learn more at http://devdocs.magento.com/guides/v2.2/release-notes/bk-release-notes.html.','http://devdocs.magento.com/guides/v2.2/release-notes/bk-release-notes.html ',1,0),(49,3,'2017-10-22 19:00:00','Creepy Party: up to 100% Off','Mageplaza Creepy Party up to 100% off all extensions ... Explore now','https://services.mageplaza.com/halloween2017/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=halloween',1,0),(50,3,'2017-10-11 19:00:00','Gift Card Statistics You may not know','Global digital gift card sales is projected to hit USD $698 Bilion in ... Explore now','https://www.mageplaza.com/blog/gift-card-statistics.html?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=blog',1,0),(51,3,'2017-09-27 19:00:00','September Flash Sales - 29% OFF','We’re proud to be one of the most dedicated Vietnamese pioneers in Magento extensions. All stuff is 29% off TODAY only. Hurry up!','https://www.mageplaza.com/promo/september-flash-sales-2017/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=september-flash-sales-2017',1,0),(52,3,'2017-08-27 19:00:00','Abandoned Cart Email released','Say goodbye Abandoned Cart','https://www.mageplaza.com/magento-2-abandoned-cart-email/?utm_source=notification&amp;utm_medium=rss&amp;utm_campaign=released',1,0),(53,1,'2017-10-22 17:00:00','Important WeltPixel Product Updates - October 2017',' We made multiple product improvements and added new features, we hope you will find them useful. You can download the latest release from your account on www.weltpixel.com. We would like to hear from you - leave a review or report a bug to any of our products. Change logs at this link: https://support.weltpixel.com/hc/en-us/articles/115002963573-WeltPixel-Product-Updates-October-2017','https://support.weltpixel.com/hc/en-us/articles/115002963573-WeltPixel-Product-Updates-October-2017',1,0),(54,1,'2017-11-07 10:20:37','Magento Open Source 2.2.1, 2.1.10, and 2.0.17 Enhance Security and Functionality – 11/7/2017','Magento Open Source 2.2.1, 2.1.10, and 2.0.17 include critical security enhancements and functional updates. Review the release notes for more information: \n\nMagento Open Source 2.2.1: \nhttp://devdocs.magento.com/guides/v2.2/release-notes/bk-release-notes.html, \n\nMagento Open Source 2.1.10: \nhttp://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html, \n\nMagento Open Source 2.0.17: \nhttp://devdocs.magento.com/guides/v2.0/release-notes/bk-release-notes.html  \n',' http://devdocs.magento.com/guides/v2.2/release-notes/bk-release-notes.html',1,0),(55,1,'2018-10-30 18:44:00','Attention! You use an ancient version of Blog Extension. It is strongly recommended to update Blog Extension to the newest version 2.8.3',' \n                                https://magefan.com/magento2-blog-extension?ancient=2.6.0                             ','https://magefan.com/magento2-blog-extension?ancient=2.6.0',1,0),(56,4,'2018-10-30 18:44:00','FAQ: How to configure &quot;read more&quot; in your Magento 2 blog post',' If you still don\'t know how to configure read more functionality in your magento 2 blog post, please read this article.\n                Online documentation for Magento 2 blog extension is also available on our website. http://goo.gl/XOEdpy ','http://magefan.com/blog/add-read-more-tag-to-blog-post-content/?from=notification1',1,0),(57,1,'2018-10-24 16:00:00','The October 2018 WeltPixel Product Updates are here! Grab them now and bring performance and functionality enhancements to your store.','You can download the latest release from your weltpixel.com account. !Hint: Update extensions before updating Magento to latest version. Change logs at this link: https://support.weltpixel.com/hc/en-us/articles/115002963573-WeltPixel-Product-Updates-Change-Log-and-New-Releases ','https://support.weltpixel.com/hc/en-us/articles/115002963573-WeltPixel-Product-Updates-Change-Log-and-New-Releases',1,0),(58,4,'2019-09-23 04:09:02','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,0),(59,4,'2021-05-04 01:50:02','Disable Notice','To improve performance, collecting statistics for the Magento Report module is disabled by default. \nYou can enable it in System Config.','',0,0),(60,1,'2021-05-04 01:58:31','Attention! Your Blog extension version is extremely outdated. It is strongly recommended to update it to the latest version 2.10.0',' \n                                    https://magefan.com/magento2-blog-extension?ancient=2.9.1                                 ','https://magefan.com/magento2-blog-extension?ancient=2.9.1',0,0),(61,4,'2021-02-24 06:00:00','WeltPixel Product Updates - February 2021. New extension: Google Analytics 4 (GA4). ','Compatibility with Magento 2.4.2 and Google Analytics 4 (GA4) Extension Release, which brings the powerful new GA4 functionality to your Magento 2 store.','https://www.weltpixel.com/blog/post/weltpixel-magento-2-product-updates-and-new-releases?utm_source=Admin&utm_medium=Notifications&utm_campaign=Release1.10.5',0,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 COMMENT 'Access Token',
  `refresh_token` text 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 `amazon_customer`
--

CREATE TABLE `amazon_customer` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity_id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer_id',
  `amazon_id` varchar(255) NOT NULL COMMENT 'Amazon_id',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `AMAZON_CUSTOMER_CUSTOMER_ID_AMAZON_ID` (`customer_id`,`amazon_id`),
  UNIQUE KEY `AMAZON_CUSTOMER_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `AMAZON_CUSTOMER_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='amazon_customer';

--
-- Dumping data for table `amazon_customer`
--


--
-- Table structure for table `amazon_pending_authorization`
--

CREATE TABLE `amazon_pending_authorization` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity_id',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order_id',
  `payment_id` int(10) unsigned NOT NULL COMMENT 'Payment_id',
  `authorization_id` varchar(255) DEFAULT NULL COMMENT 'Authorization_id',
  `created_at` datetime NOT NULL COMMENT 'Created_at',
  `updated_at` datetime DEFAULT NULL COMMENT 'Updated_at',
  `processed` smallint(5) unsigned DEFAULT '0' COMMENT 'Initial authorization processed',
  `capture` smallint(5) unsigned DEFAULT '0' COMMENT 'Initial authorization has capture',
  `capture_id` varchar(255) DEFAULT NULL COMMENT 'Initial authorization capture id',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `UNQ_E6CCA08713FB32BB136A56837009C371` (`order_id`,`payment_id`,`authorization_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='amazon_pending_authorization';

--
-- Dumping data for table `amazon_pending_authorization`
--


--
-- Table structure for table `amazon_pending_capture`
--

CREATE TABLE `amazon_pending_capture` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity_id',
  `capture_id` varchar(255) NOT NULL COMMENT 'Capture_id',
  `created_at` datetime NOT NULL COMMENT 'Created_at',
  `order_id` int(10) unsigned NOT NULL COMMENT 'order id',
  `payment_id` int(10) unsigned NOT NULL COMMENT 'payment id',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `AMAZON_PENDING_CAPTURE_ORDER_ID_PAYMENT_ID_CAPTURE_ID` (`order_id`,`payment_id`,`capture_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='amazon_pending_capture';

--
-- Dumping data for table `amazon_pending_capture`
--


--
-- Table structure for table `amazon_pending_refund`
--

CREATE TABLE `amazon_pending_refund` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity_id',
  `refund_id` varchar(255) NOT NULL COMMENT 'Refund_id',
  `created_at` datetime NOT NULL COMMENT 'Created_at',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order_id',
  `payment_id` int(10) unsigned NOT NULL COMMENT 'Payment_id',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `AMAZON_PENDING_REFUND_ORDER_ID_PAYMENT_ID_REFUND_ID` (`order_id`,`payment_id`,`refund_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='amazon_pending_refund';

--
-- Dumping data for table `amazon_pending_refund`
--


--
-- Table structure for table `amazon_quote`
--

CREATE TABLE `amazon_quote` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote ID',
  `amazon_order_reference_id` varchar(255) NOT NULL COMMENT 'Amazon Order Reference ID',
  `sandbox_simulation_reference` varchar(255) DEFAULT NULL COMMENT 'Sandbox simulation reference',
  `confirmed` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Quote confirmed with Amazon',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `AMAZON_QUOTE_QUOTE_ID` (`quote_id`),
  CONSTRAINT `AMAZON_QUOTE_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='amazon_quote';

--
-- Dumping data for table `amazon_quote`
--


--
-- Table structure for table `amazon_sales_order`
--

CREATE TABLE `amazon_sales_order` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `amazon_order_reference_id` varchar(255) NOT NULL COMMENT 'Amazon Order Reference ID',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `AMAZON_SALES_ORDER_ORDER_ID` (`order_id`),
  CONSTRAINT `AMAZON_SALES_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='amazon_sales_order';

--
-- Dumping data for table `amazon_sales_order`
--


--
-- 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=43 DEFAULT CHARSET=utf8 COMMENT='Admin Role Table';

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

INSERT INTO `authorization_role` VALUES (1,0,1,1,'G',0,'2','Administrators'),(2,1,2,0,'U',1,'2','admin'),(3,1,2,0,'U',2,'2','admin'),(4,1,2,0,'U',3,'2','admin'),(9,1,2,0,'U',4,'2','admin'),(13,1,2,0,'U',5,'2','admin'),(38,0,1,0,'U',32,'1','132'),(39,1,2,0,'U',6,'2','admin'),(40,1,2,0,'U',7,'2','admin'),(41,1,2,0,'U',8,'2','admin'),(42,1,2,0,'U',9,'2','admin');

--
-- 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=21709 DEFAULT CHARSET=utf8 COMMENT='Admin Rule Table';

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

INSERT INTO `authorization_rule` VALUES (1,1,'Magento_Backend::all',NULL,'allow'),(21457,38,'Magento_Backend::all',NULL,'deny'),(21458,38,'Magento_Backend::admin',NULL,'allow'),(21459,38,'Magento_Backend::dashboard',NULL,'deny'),(21460,38,'Magento_Analytics::analytics',NULL,'deny'),(21461,38,'Magento_Analytics::analytics_api',NULL,'deny'),(21462,38,'Magento_Sales::sales',NULL,'deny'),(21463,38,'Magento_Sales::sales_operation',NULL,'deny'),(21464,38,'Magento_Sales::sales_order',NULL,'deny'),(21465,38,'Magento_Sales::actions',NULL,'deny'),(21466,38,'Magento_Sales::create',NULL,'deny'),(21467,38,'Magento_Sales::actions_view',NULL,'deny'),(21468,38,'Magento_Sales::email',NULL,'deny'),(21469,38,'Magento_Sales::reorder',NULL,'deny'),(21470,38,'Magento_Sales::actions_edit',NULL,'deny'),(21471,38,'Magento_Sales::cancel',NULL,'deny'),(21472,38,'Magento_Sales::review_payment',NULL,'deny'),(21473,38,'Magento_Sales::capture',NULL,'deny'),(21474,38,'Magento_Sales::invoice',NULL,'deny'),(21475,38,'Magento_Sales::creditmemo',NULL,'deny'),(21476,38,'Magento_Sales::hold',NULL,'deny'),(21477,38,'Magento_Sales::unhold',NULL,'deny'),(21478,38,'Magento_Sales::ship',NULL,'deny'),(21479,38,'Magento_Sales::comment',NULL,'deny'),(21480,38,'Magento_Sales::emails',NULL,'deny'),(21481,38,'Magento_Paypal::authorization',NULL,'deny'),(21482,38,'Magento_Sales::sales_invoice',NULL,'deny'),(21483,38,'Magento_Sales::shipment',NULL,'deny'),(21484,38,'Temando_Shipping::dispatches',NULL,'deny'),(21485,38,'Magento_Sales::sales_creditmemo',NULL,'deny'),(21486,38,'Magento_Paypal::billing_agreement',NULL,'deny'),(21487,38,'Magento_Paypal::billing_agreement_actions',NULL,'deny'),(21488,38,'Magento_Paypal::billing_agreement_actions_view',NULL,'deny'),(21489,38,'Magento_Paypal::actions_manage',NULL,'deny'),(21490,38,'Magento_Paypal::use',NULL,'deny'),(21491,38,'Magento_Sales::transactions',NULL,'deny'),(21492,38,'Magento_Sales::transactions_fetch',NULL,'deny'),(21493,38,'Magento_Catalog::catalog',NULL,'allow'),(21494,38,'Magento_Catalog::catalog_inventory',NULL,'allow'),(21495,38,'Magento_Catalog::products',NULL,'allow'),(21496,38,'Magento_Catalog::categories',NULL,'deny'),(21497,38,'Magento_Customer::customer',NULL,'deny'),(21498,38,'Magento_Customer::manage',NULL,'deny'),(21499,38,'Magento_Customer::online',NULL,'deny'),(21500,38,'Magento_Cart::cart',NULL,'deny'),(21501,38,'Magento_Cart::manage',NULL,'deny'),(21502,38,'Smartwave_Dailydeals::dailydeals',NULL,'deny'),(21503,38,'Smartwave_Dailydeals::dailydeal',NULL,'deny'),(21504,38,'Magento_Backend::myaccount',NULL,'deny'),(21505,38,'Magento_Backend::marketing',NULL,'deny'),(21506,38,'Magento_CatalogRule::promo',NULL,'deny'),(21507,38,'Magento_CatalogRule::promo_catalog',NULL,'deny'),(21508,38,'Magento_SalesRule::quote',NULL,'deny'),(21509,38,'Dotdigitalgroup_Email::automation',NULL,'deny'),(21510,38,'Dotdigitalgroup_Email::automation_studio',NULL,'deny'),(21511,38,'Dotdigitalgroup_Email::exclusion_rules',NULL,'deny'),(21512,38,'Magento_Backend::marketing_communications',NULL,'deny'),(21513,38,'Magento_Email::template',NULL,'deny'),(21514,38,'Magento_Newsletter::template',NULL,'deny'),(21515,38,'Magento_Newsletter::queue',NULL,'deny'),(21516,38,'Magento_Newsletter::subscriber',NULL,'deny'),(21517,38,'Magento_Backend::marketing_seo',NULL,'deny'),(21518,38,'Magento_Search::search',NULL,'deny'),(21519,38,'Magento_Search::synonyms',NULL,'deny'),(21520,38,'Magento_UrlRewrite::urlrewrite',NULL,'deny'),(21521,38,'Magento_Sitemap::sitemap',NULL,'deny'),(21522,38,'Magento_Backend::marketing_user_content',NULL,'deny'),(21523,38,'Magento_Review::reviews_all',NULL,'deny'),(21524,38,'Magento_Review::pending',NULL,'deny'),(21525,38,'Mageplaza_Core::menu',NULL,'deny'),(21526,38,'Mageplaza_Core::documentation',NULL,'deny'),(21527,38,'Mageplaza_Core::userguide',NULL,'deny'),(21528,38,'Mageplaza_Core::activate',NULL,'deny'),(21529,38,'Magento_Backend::content',NULL,'deny'),(21530,38,'Magento_Backend::content_elements',NULL,'deny'),(21531,38,'Magento_Cms::page',NULL,'deny'),(21532,38,'Magento_Cms::save',NULL,'deny'),(21533,38,'Magento_Cms::page_delete',NULL,'deny'),(21534,38,'Magento_Cms::block',NULL,'deny'),(21535,38,'Magento_Widget::widget_instance',NULL,'deny'),(21536,38,'Magento_Cms::media_gallery',NULL,'deny'),(21537,38,'Magefan_Blog::elements',NULL,'deny'),(21538,38,'Magefan_Blog::post',NULL,'deny'),(21539,38,'Magefan_Blog::category',NULL,'deny'),(21540,38,'Magefan_Blog::import',NULL,'deny'),(21541,38,'Magento_Backend::design',NULL,'deny'),(21542,38,'Magento_Theme::theme',NULL,'deny'),(21543,38,'Magento_Backend::schedule',NULL,'deny'),(21544,38,'Magento_Backend::content_translation',NULL,'deny'),(21545,38,'Magento_Reports::report',NULL,'deny'),(21546,38,'Dotdigitalgroup_Email::reports',NULL,'deny'),(21547,38,'Dotdigitalgroup_Email::contact',NULL,'deny'),(21548,38,'Dotdigitalgroup_Email::order',NULL,'deny'),(21549,38,'Dotdigitalgroup_Email::review',NULL,'deny'),(21550,38,'Dotdigitalgroup_Email::wishlist',NULL,'deny'),(21551,38,'Dotdigitalgroup_Email::catalog',NULL,'deny'),(21552,38,'Dotdigitalgroup_Email::importer',NULL,'deny'),(21553,38,'Dotdigitalgroup_Email::campaign',NULL,'deny'),(21554,38,'Dotdigitalgroup_Email::cron',NULL,'deny'),(21555,38,'Dotdigitalgroup_Email::dashboard',NULL,'deny'),(21556,38,'Dotdigitalgroup_Email::automation_enrollment',NULL,'deny'),(21557,38,'Dotdigitalgroup_Email::logviewer',NULL,'deny'),(21558,38,'Magento_Reports::report_marketing',NULL,'deny'),(21559,38,'Magento_Reports::shopcart',NULL,'deny'),(21560,38,'Magento_Reports::product',NULL,'deny'),(21561,38,'Magento_Reports::abandoned',NULL,'deny'),(21562,38,'Magento_Reports::report_search',NULL,'deny'),(21563,38,'Magento_Newsletter::problem',NULL,'deny'),(21564,38,'Magento_Reports::review',NULL,'deny'),(21565,38,'Magento_Reports::review_customer',NULL,'deny'),(21566,38,'Magento_Reports::review_product',NULL,'deny'),(21567,38,'Magento_Reports::salesroot',NULL,'deny'),(21568,38,'Magento_Reports::salesroot_sales',NULL,'deny'),(21569,38,'Magento_Reports::tax',NULL,'deny'),(21570,38,'Magento_Reports::invoiced',NULL,'deny'),(21571,38,'Magento_Reports::shipping',NULL,'deny'),(21572,38,'Magento_Reports::refunded',NULL,'deny'),(21573,38,'Magento_Reports::coupons',NULL,'deny'),(21574,38,'Magento_Paypal::paypal_settlement_reports',NULL,'deny'),(21575,38,'Magento_Paypal::paypal_settlement_reports_view',NULL,'deny'),(21576,38,'Magento_Paypal::fetch',NULL,'deny'),(21577,38,'Magento_Braintree::settlement_report',NULL,'deny'),(21578,38,'Magento_Reports::customers',NULL,'deny'),(21579,38,'Magento_Reports::totals',NULL,'deny'),(21580,38,'Magento_Reports::customers_orders',NULL,'deny'),(21581,38,'Magento_Reports::accounts',NULL,'deny'),(21582,38,'Magento_Reports::report_products',NULL,'deny'),(21583,38,'Magento_Reports::viewed',NULL,'deny'),(21584,38,'Magento_Reports::bestsellers',NULL,'deny'),(21585,38,'Magento_Reports::lowstock',NULL,'deny'),(21586,38,'Magento_Reports::sold',NULL,'deny'),(21587,38,'Magento_Reports::downloads',NULL,'deny'),(21588,38,'Magento_Reports::statistics',NULL,'deny'),(21589,38,'Magento_Reports::statistics_refresh',NULL,'deny'),(21590,38,'Magento_Analytics::business_intelligence',NULL,'deny'),(21591,38,'Magento_Analytics::advanced_reporting',NULL,'deny'),(21592,38,'Magento_Analytics::bi_essentials',NULL,'deny'),(21593,38,'Magento_Backend::stores',NULL,'allow'),(21594,38,'Magento_Backend::stores_settings',NULL,'allow'),(21595,38,'Magento_Backend::store',NULL,'allow'),(21596,38,'Magento_Config::config',NULL,'deny'),(21597,38,'Magefan_Blog::config_blog',NULL,'deny'),(21598,38,'Magento_Catalog::config_catalog',NULL,'deny'),(21599,38,'Magento_CatalogSearch::config_catalog_search',NULL,'deny'),(21600,38,'Magento_Cms::config_cms',NULL,'deny'),(21601,38,'Magento_GoogleAnalytics::google',NULL,'deny'),(21602,38,'Magento_Newsletter::newsletter',NULL,'deny'),(21603,38,'Magento_Downloadable::downloadable',NULL,'deny'),(21604,38,'Magento_Contact::contact',NULL,'deny'),(21605,38,'Magento_Sales::fraud_protection',NULL,'deny'),(21606,38,'Dotdigitalgroup_Email::config',NULL,'deny'),(21607,38,'Magento_CatalogInventory::cataloginventory',NULL,'deny'),(21608,38,'Magento_Payment::payment_services',NULL,'deny'),(21609,38,'Magento_Payment::payment',NULL,'deny'),(21610,38,'Mageplaza_LayeredNavigation::configuration',NULL,'deny'),(21611,38,'Mageplaza_Search::configuration',NULL,'deny'),(21612,38,'Smartwave_Dailydeals::dailydeals_config',NULL,'deny'),(21613,38,'Smartwave_Porto::theme_settings',NULL,'deny'),(21614,38,'Smartwave_Porto::theme_design',NULL,'deny'),(21615,38,'Smartwave_Porto::activation',NULL,'deny'),(21616,38,'Magento_Shipping::carriers',NULL,'deny'),(21617,38,'Magento_Shipping::shipping_policy',NULL,'deny'),(21618,38,'Magento_Shipping::config_shipping',NULL,'deny'),(21619,38,'Magento_Multishipping::config_multishipping',NULL,'deny'),(21620,38,'Mageplaza_Core::marketplace',NULL,'deny'),(21621,38,'Mageplaza_Core::configuration',NULL,'deny'),(21622,38,'Magento_Config::config_general',NULL,'deny'),(21623,38,'Magento_Config::web',NULL,'deny'),(21624,38,'Magento_Config::config_design',NULL,'deny'),(21625,38,'Magento_Customer::config_customer',NULL,'deny'),(21626,38,'Magento_Paypal::paypal',NULL,'deny'),(21627,38,'Magento_Tax::config_tax',NULL,'deny'),(21628,38,'Magento_Checkout::checkout',NULL,'deny'),(21629,38,'Magento_Persistent::persistent',NULL,'deny'),(21630,38,'Magento_Sales::config_sales',NULL,'deny'),(21631,38,'Magento_Sales::sales_email',NULL,'deny'),(21632,38,'Magento_Sales::sales_pdf',NULL,'deny'),(21633,38,'Magento_Sitemap::config_sitemap',NULL,'deny'),(21634,38,'Magento_Reports::reports',NULL,'deny'),(21635,38,'Magento_Wishlist::config_wishlist',NULL,'deny'),(21636,38,'Magento_Config::config_system',NULL,'deny'),(21637,38,'Magento_Config::advanced',NULL,'deny'),(21638,38,'Magento_SalesRule::config_promo',NULL,'deny'),(21639,38,'Magento_Config::trans_email',NULL,'deny'),(21640,38,'Magento_Config::config_admin',NULL,'deny'),(21641,38,'Magento_Config::dev',NULL,'deny'),(21642,38,'Magento_Config::currency',NULL,'deny'),(21643,38,'Magento_Rss::rss',NULL,'deny'),(21644,38,'Magento_Config::sendfriend',NULL,'deny'),(21645,38,'Magento_Analytics::analytics_settings',NULL,'deny'),(21646,38,'WeltPixel_Quickview::QuickviewSettings',NULL,'deny'),(21647,38,'Magento_NewRelicReporting::config_newrelicreporting',NULL,'deny'),(21648,38,'Magento_CheckoutAgreements::checkoutagreement',NULL,'deny'),(21649,38,'Magento_Sales::order_statuses',NULL,'deny'),(21650,38,'Temando_Shipping::shipping',NULL,'deny'),(21651,38,'Temando_Shipping::carriers',NULL,'deny'),(21652,38,'Temando_Shipping::locations',NULL,'deny'),(21653,38,'Temando_Shipping::packaging',NULL,'deny'),(21654,38,'Magento_Tax::manage_tax',NULL,'deny'),(21655,38,'Magento_CurrencySymbol::system_currency',NULL,'deny'),(21656,38,'Magento_CurrencySymbol::currency_rates',NULL,'deny'),(21657,38,'Magento_CurrencySymbol::symbols',NULL,'deny'),(21658,38,'Magento_Backend::stores_attributes',NULL,'deny'),(21659,38,'Magento_Catalog::attributes_attributes',NULL,'deny'),(21660,38,'Magento_Catalog::update_attributes',NULL,'deny'),(21661,38,'Magento_Catalog::sets',NULL,'deny'),(21662,38,'Magento_Review::ratings',NULL,'deny'),(21663,38,'Magento_Swatches::iframe',NULL,'deny'),(21664,38,'Magento_Backend::stores_other_settings',NULL,'deny'),(21665,38,'Magento_Customer::group',NULL,'deny'),(21666,38,'Magento_Backend::system',NULL,'deny'),(21667,38,'Magento_Backend::convert',NULL,'deny'),(21668,38,'Magento_ImportExport::import',NULL,'deny'),(21669,38,'Magento_ImportExport::export',NULL,'deny'),(21670,38,'Magento_TaxImportExport::import_export',NULL,'deny'),(21671,38,'Magento_ImportExport::history',NULL,'deny'),(21672,38,'Magento_Backend::extensions',NULL,'deny'),(21673,38,'Magento_Backend::local',NULL,'deny'),(21674,38,'Magento_Backend::custom',NULL,'deny'),(21675,38,'Magento_Integration::extensions',NULL,'deny'),(21676,38,'Magento_Integration::integrations',NULL,'deny'),(21677,38,'Magento_Backend::tools',NULL,'deny'),(21678,38,'Magento_Backend::cache',NULL,'deny'),(21679,38,'Magento_Backend::main_actions',NULL,'deny'),(21680,38,'Magento_Backend::flush_cache_storage',NULL,'deny'),(21681,38,'Magento_Backend::flush_magento_cache',NULL,'deny'),(21682,38,'Magento_Backend::mass_actions',NULL,'deny'),(21683,38,'Magento_Backend::toggling_cache_type',NULL,'deny'),(21684,38,'Magento_Backend::refresh_cache_type',NULL,'deny'),(21685,38,'Magento_Backend::additional_cache_management',NULL,'deny'),(21686,38,'Magento_Backend::flush_catalog_images',NULL,'deny'),(21687,38,'Magento_Backend::flush_js_css',NULL,'deny'),(21688,38,'Magento_Backend::flush_static_files',NULL,'deny'),(21689,38,'Magento_Backend::setup_wizard',NULL,'deny'),(21690,38,'Magento_Indexer::index',NULL,'deny'),(21691,38,'Magento_Backup::backup',NULL,'deny'),(21692,38,'Magento_Backup::rollback',NULL,'deny'),(21693,38,'Magento_Indexer::changeMode',NULL,'deny'),(21694,38,'Magento_User::acl',NULL,'deny'),(21695,38,'Magento_User::acl_users',NULL,'deny'),(21696,38,'Magento_User::locks',NULL,'deny'),(21697,38,'Magento_User::acl_roles',NULL,'deny'),(21698,38,'Magento_Backend::system_other_settings',NULL,'deny'),(21699,38,'Magento_AdminNotification::adminnotification',NULL,'deny'),(21700,38,'Magento_AdminNotification::show_toolbar',NULL,'deny'),(21701,38,'Magento_AdminNotification::show_list',NULL,'deny'),(21702,38,'Magento_AdminNotification::mark_as_read',NULL,'deny'),(21703,38,'Magento_AdminNotification::adminnotification_remove',NULL,'deny'),(21704,38,'Magento_Variable::variable',NULL,'deny'),(21705,38,'Magento_EncryptionKey::crypt_key',NULL,'deny'),(21706,38,'Magento_Backend::global_search',NULL,'deny'),(21707,38,'WeltPixel_Backend::WeltPixel',NULL,'deny'),(21708,38,'WeltPixel_Quickview::Quickview',NULL,'deny');

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

CREATE TABLE `cache` (
  `id` varchar(200) NOT NULL COMMENT 'Cache Id',
  `data` mediumblob 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`
--


--
-- 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=24 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Table';

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

INSERT INTO `catalog_category_entity` VALUES (1,0,0,'2016-08-25 14:46:27','2018-01-14 23:17:54','1',0,0,-3),(2,3,1,'2016-08-25 14:46:29','2018-01-14 23:17:54','1/2',1,1,-4),(3,3,2,'2016-08-25 20:00:33','2021-05-04 02:44:05','1/2/3',1,2,18),(4,3,2,'2016-08-25 20:03:41','2018-01-14 23:52:21','1/2/4',2,2,-18),(6,3,3,'2016-08-25 20:08:09','2016-08-25 20:16:41','1/2/3/6',1,3,4),(7,3,3,'2016-08-25 20:09:52','2016-08-25 20:20:28','1/2/3/7',2,3,4),(8,3,3,'2016-08-25 20:11:03','2016-08-25 20:23:04','1/2/3/8',3,3,3),(9,3,3,'2016-08-25 20:12:18','2016-08-25 20:25:28','1/2/3/9',4,3,3),(10,3,6,'2016-08-25 20:13:51','2016-08-25 20:13:51','1/2/3/6/10',1,4,0),(11,3,6,'2016-08-25 20:15:01','2016-08-25 20:15:02','1/2/3/6/11',2,4,0),(12,3,6,'2016-08-25 20:15:51','2016-08-25 20:15:51','1/2/3/6/12',3,4,0),(13,3,6,'2016-08-25 20:16:41','2016-08-25 20:16:42','1/2/3/6/13',4,4,0),(14,3,7,'2016-08-25 20:17:56','2016-08-25 20:17:56','1/2/3/7/14',1,4,0),(15,3,7,'2016-08-25 20:18:43','2016-08-25 20:18:43','1/2/3/7/15',2,4,0),(16,3,7,'2016-08-25 20:19:42','2016-08-25 20:19:42','1/2/3/7/16',3,4,0),(17,3,7,'2016-08-25 20:20:28','2016-08-25 20:20:28','1/2/3/7/17',4,4,0),(18,3,8,'2016-08-25 20:21:20','2016-08-25 20:21:20','1/2/3/8/18',1,4,0),(19,3,8,'2016-08-25 20:22:07','2016-08-25 20:22:07','1/2/3/8/19',2,4,0),(20,3,8,'2016-08-25 20:23:04','2016-08-25 20:23:04','1/2/3/8/20',3,4,0),(21,3,9,'2016-08-25 20:24:00','2016-08-25 20:24:00','1/2/3/9/21',1,4,0),(22,3,9,'2016-08-25 20:24:45','2016-08-25 20:24:45','1/2/3/9/22',2,4,0),(23,3,9,'2016-08-25 20:25:28','2016-08-25 20:25:28','1/2/3/9/23',3,4,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 AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Datetime Attribute Backend Table';

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

INSERT INTO `catalog_category_entity_datetime` VALUES (1,61,0,4,NULL),(2,62,0,4,NULL),(3,61,0,3,NULL),(4,62,0,3,NULL);

--
-- 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=357 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Integer Attribute Backend Table';

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

INSERT INTO `catalog_category_entity_int` VALUES (1,69,0,1,1),(2,46,0,2,1),(3,69,0,2,1),(4,46,0,3,1),(6,54,0,3,1),(7,69,0,3,1),(8,70,0,3,0),(9,71,0,3,0),(10,136,0,3,0),(11,150,0,3,0),(12,46,0,4,1),(13,54,0,4,1),(14,69,0,4,1),(15,70,0,4,0),(16,71,0,4,0),(17,136,0,4,0),(18,150,0,4,0),(26,46,0,6,1),(27,54,0,6,1),(28,69,0,6,1),(29,70,0,6,0),(30,71,0,6,0),(31,136,0,6,0),(32,150,0,6,0),(33,46,0,7,1),(34,54,0,7,1),(35,69,0,7,1),(36,70,0,7,0),(37,71,0,7,0),(38,136,0,7,0),(39,150,0,7,0),(40,46,0,8,1),(41,54,0,8,1),(42,69,0,8,1),(43,70,0,8,0),(44,71,0,8,0),(45,136,0,8,0),(46,150,0,8,0),(47,46,0,9,1),(48,54,0,9,1),(49,69,0,9,1),(50,70,0,9,0),(51,71,0,9,0),(52,136,0,9,0),(53,150,0,9,0),(54,46,0,10,1),(55,54,0,10,1),(56,69,0,10,1),(57,70,0,10,0),(58,71,0,10,0),(59,136,0,10,0),(60,150,0,10,0),(61,46,0,11,1),(62,54,0,11,1),(63,69,0,11,1),(64,70,0,11,0),(65,71,0,11,0),(66,136,0,11,0),(67,150,0,11,0),(68,46,0,12,1),(69,54,0,12,1),(70,69,0,12,1),(71,70,0,12,0),(72,71,0,12,0),(73,136,0,12,0),(74,150,0,12,0),(75,46,0,13,1),(76,54,0,13,1),(77,69,0,13,1),(78,70,0,13,0),(79,71,0,13,0),(80,136,0,13,0),(81,150,0,13,0),(82,46,0,14,1),(83,54,0,14,1),(84,69,0,14,1),(85,70,0,14,0),(86,71,0,14,0),(87,136,0,14,0),(88,150,0,14,0),(89,46,0,15,1),(90,54,0,15,1),(91,69,0,15,1),(92,70,0,15,0),(93,71,0,15,0),(94,136,0,15,0),(95,150,0,15,0),(96,46,0,16,1),(97,54,0,16,1),(98,69,0,16,1),(99,70,0,16,0),(100,71,0,16,0),(101,136,0,16,0),(102,150,0,16,0),(103,46,0,17,1),(104,54,0,17,1),(105,69,0,17,1),(106,70,0,17,0),(107,71,0,17,0),(108,136,0,17,0),(109,150,0,17,0),(110,46,0,18,1),(111,54,0,18,1),(112,69,0,18,1),(113,70,0,18,0),(114,71,0,18,0),(115,136,0,18,0),(116,150,0,18,0),(117,46,0,19,1),(118,54,0,19,1),(119,69,0,19,1),(120,70,0,19,0),(121,71,0,19,0),(122,136,0,19,0),(123,150,0,19,0),(124,46,0,20,1),(125,54,0,20,1),(126,69,0,20,1),(127,70,0,20,0),(128,71,0,20,0),(129,136,0,20,0),(130,150,0,20,0),(131,46,0,21,1),(132,54,0,21,1),(133,69,0,21,1),(134,70,0,21,0),(135,71,0,21,0),(136,136,0,21,0),(137,150,0,21,0),(138,46,0,22,1),(139,54,0,22,1),(140,69,0,22,1),(141,70,0,22,0),(142,71,0,22,0),(143,136,0,22,0),(144,150,0,22,0),(145,46,0,23,1),(146,54,0,23,1),(147,69,0,23,1),(148,70,0,23,0),(149,71,0,23,0),(150,136,0,23,0),(151,150,0,23,0),(355,53,0,4,NULL),(356,53,0,3,NULL);

--
-- 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 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 AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Text Attribute Backend Table';

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

INSERT INTO `catalog_category_entity_text` VALUES (1,64,0,3,'<move element=\"category.cms\" destination=\"content\" before=\"-\"/>'),(2,148,0,3,'<div style=\'background-position: -15px center; background-image: url({{media url=&quot;wysiwyg/smartwave/porto/megamenu/menu-banner.jpg&quot;}}); background-repeat: no-repeat; background-size: cover; width: 100%;height:100%;\'></div>'),(3,154,0,3,'<div class=\"row\" style=\"margin:0 -10px;\">\r\n    <div class=\"col-sm-6\" style=\"padding: 0 10px;\">\r\n        <img src=\"{{media url=\"wysiwyg/smartwave/porto/category/onepagecategory/banner_1_1.jpg\"}}\" alt=\"\" style=\"margin-top: 50px;\">\r\n    </div>\r\n    <div class=\"col-sm-6\" style=\"padding: 0 10px;\">\r\n        <img src=\"{{media url=\"wysiwyg/smartwave/porto/category/onepagecategory/banner_1_2.jpg\"}}\" alt=\"\" style=\"margin-top: 50px;\">\r\n    </div>\r\n</div>'),(4,144,0,4,NULL),(5,148,0,4,NULL),(6,154,0,4,'<div class=\"row\" style=\"margin:0 -10px;\">\r\n    <div class=\"col-sm-6\" style=\"padding: 0 10px;\">\r\n        <img src=\"{{media url=\"wysiwyg/smartwave/porto/category/onepagecategory/banner_2_1.jpg\"}}\" alt=\"\" style=\"margin-top: 50px;\">\r\n    </div>\r\n    <div class=\"col-sm-6\" style=\"padding: 0 10px;\">\r\n        <img src=\"{{media url=\"wysiwyg/smartwave/porto/category/onepagecategory/banner_2_2.jpg\"}}\" alt=\"\" style=\"margin-top: 50px;\">\r\n    </div>\r\n</div>'),(9,47,0,4,'<div class=\"full-width-image-banner\" style=\"background: url({{media url=\"wysiwyg/smartwave/porto/category/banner/full-width-banner1.jpg\"}}) 50% 50% no-repeat;background-size:cover;\">\r\n  <div class=\"container\">            \r\n    <div class=\"content\" style=\"position:absolute;z-index:1;top:35%;text-align:left;color:#1e3636;\">\r\n      <p style=\"color: #1e3636;\">check out over <b style=\"font-size:26px;font-family:\'Oswald\';color:#1e3636;\">200+</b></p>\r\n      <h2 style=\"color: #1e3636;\">incredible deals</h2>\r\n      <a href=\"#\" class=\"btn btn-default\">shop now</a>\r\n    </div>\r\n  </div>\r\n</div>'),(10,50,0,4,NULL),(11,51,0,4,NULL),(12,64,0,4,NULL),(13,146,0,4,NULL),(14,149,0,4,NULL),(15,47,0,3,'<div class=\"row\">\r\n  <div class=\"mb-2 col-lg-12\">\r\n    <div class=\"porto-carousel owl-carousel\">\r\n      <div class=\"porto-ultimate-content-box-container\">\r\n        <div\r\n             class=\"porto-ultimate-content-box vc_custom_1599764578086 has-content-pos justify-content-center\"\r\n             style=\"\r\n                    background-size: cover;\r\n                    background-repeat: no-repeat;\r\n                    background-position: center top;\r\n                    background-color: rgba(0, 0, 0, 0);\r\n                    min-height: 280px;\r\n                    background-image: url(\'{{media url=&quot;wysiwyg/smartwave/porto/homepage/01/shop1_shop_slider1.jpg&quot;}}\');\r\n                    \"\r\n             >\r\n          <h4 style=\"font-size: 0.8675em; color: rgba(255, 255, 255, 0.7); line-height: 1; font-weight: 500;\" class=\"vc_custom_heading ls-80 align-left\">Find the Boundaries. Push Through!</h4>\r\n          <h2 style=\"font-size: 2.524375em; line-height: 1; font-weight: 700; letter-spacing: 0.005em;\" class=\"vc_custom_heading custom-font4 mb-0 align-left heading-light\">Summer Sale</h2>\r\n          <h3 style=\"font-size: 4.38625em; line-height: 1; font-weight: 700;\" class=\"vc_custom_heading mb-3 align-left heading-light\">30% OFF</h3>\r\n          <div class=\"vc_row wpb_row vc_inner row\">\r\n            <div class=\"vc_column_container col-md-12\">\r\n              <div class=\"wpb_wrapper vc_column-inner\">\r\n                <h4 style=\"font-size: 0.75em; line-height: 1; font-weight: 400;\" class=\"vc_custom_heading mr-2 pull-left p-t-sm align-left text-uppercase heading-light\">Starting At</h4>\r\n                <h4 style=\"font-size: 0.8em; color: #ff7272; line-height: 1;\" class=\"vc_custom_heading coupon-sale-text d-inline-block mr-2 align-left\">\r\n                  <b><sup>$</sup>199<sup>99</sup></b>\r\n                </h4>\r\n                <div class=\"btn-container mb-0 d-inline-block\" style=\"margin-left:-4px;\"><button class=\"vc_btn3 vc_btn3-shape-default btn btn-modern btn-lg btn-dark\" style=\"font-size: 11.4px;\">Get Yours!</button></div>\r\n              </div>\r\n            </div>\r\n          </div>\r\n        </div>\r\n      </div>\r\n      <div class=\"porto-ultimate-content-box-container\">\r\n        <div\r\n             class=\"porto-ultimate-content-box vc_custom_1599764587094 has-content-pos justify-content-center\"\r\n             style=\"\r\n                    background-size: cover;\r\n                    background-repeat: no-repeat;\r\n                    background-position: center top;\r\n                    background-color: rgba(0, 0, 0, 0);\r\n                    min-height: 280px;\r\n                    background-image: url(\'{{media url=&quot;wysiwyg/smartwave/porto/homepage/01/shop1_home_slider2.jpg&quot;}}\');\r\n                    \"\r\n             >\r\n          <h4 style=\"font-size: 0.92625em; color: rgba(119, 119, 119, 0.7); line-height: 1; font-weight: 500;\" class=\"vc_custom_heading ls-80 mb-2 align-left\">OVER 200 PRODUCTS WITH DISCOUNTS</h4>\r\n          <h3 style=\"font-size: 3.183125em; line-height: 1; font-weight: 700;\" class=\"vc_custom_heading mb-3 align-left heading-dark\">GREAT DEALS</h3>\r\n          <div class=\"vc_row wpb_row vc_inner row\">\r\n            <div class=\"vc_column_container col-md-12\">\r\n              <div class=\"wpb_wrapper vc_column-inner\">\r\n                <h4 style=\"font-size: 0.875em; line-height: 1.5; font-weight: 700;\" class=\"vc_custom_heading mr-2 pull-left align-left text-uppercase heading-dark\">Starting At</h4>\r\n                <h4 style=\"font-size: 1.625em; line-height: 1;\" class=\"vc_custom_heading pull-left mr-3 align-left heading-dark\">\r\n                  <b><sup>$</sup>299<sup>99</sup></b>\r\n                </h4>\r\n                <div class=\"btn-container mb-0 d-inline-block\"><button class=\"btn btn-modern btn-lg btn-dark\" style=\"font-size: 12.17px;\">Get Yours!</button></div>\r\n              </div>\r\n            </div>\r\n          </div>\r\n        </div>\r\n      </div>\r\n      <div class=\"porto-ultimate-content-box-container\">\r\n        <div\r\n             class=\"porto-ultimate-content-box vc_custom_1599764595067 has-content-pos justify-content-center\"\r\n             style=\"\r\n                    background-size: cover;\r\n                    background-repeat: no-repeat;\r\n                    background-position: center top;\r\n                    background-color: rgba(0, 0, 0, 0);\r\n                    min-height: 280px;\r\n                    background-image: url(\'{{media url=&quot;wysiwyg/smartwave/porto/homepage/01/shop1_home_slider3.jpg&quot;}}\');\r\n                    \"\r\n             >\r\n          <h4 style=\"font-size: 0.95875em; color: rgba(119, 119, 119, 0.7); line-height: 1; font-weight: 500;\" class=\"vc_custom_heading ls-80 mb-2 align-left\">UP TO 70% OFF</h4>\r\n          <h3 style=\"font-size: 2.875625em; line-height: 1; font-weight: 700;\" class=\"vc_custom_heading mb-3 align-left heading-dark\">NEW ARRIVALS</h3>\r\n          <div class=\"vc_row wpb_row vc_inner row\">\r\n            <div class=\"vc_column_container col-md-12\">\r\n              <div class=\"wpb_wrapper vc_column-inner\">\r\n                <h4 style=\"font-size: 0.875em; line-height: 1.5; font-weight: 700;\" class=\"vc_custom_heading mr-2 pull-left align-left text-uppercase heading-dark\">Starting At</h4>\r\n                <h4 style=\"font-size: 1.625em; line-height: 1;\" class=\"vc_custom_heading pull-left m-r-lg align-left heading-dark\">\r\n                  <b><sup>$</sup>299<sup>99</sup></b>\r\n                </h4>\r\n                <div class=\"btn-container mb-0 d-inline-block\"><button class=\"btn btn-modern btn-lg btn-dark\" style=\"font-size: 12.59px;\">Get Yours!</button></div>\r\n              </div>\r\n            </div>\r\n          </div>\r\n        </div>\r\n      </div>\r\n    </div>\r\n  </div>\r\n</div>\r\n<script type=\"text/javascript\">\r\n  require([\"jquery\", \"owl.carousel/owl.carousel.min\"], function ($) {\r\n    var banner_owl = $(\".porto-carousel.owl-carousel\");\r\n    banner_owl.owlCarousel({\r\n      items: 1,\r\n      autoplay: false,\r\n      autoplayTimeout: 5000,\r\n      autoplayHoverPause: true,\r\n      dots: false,\r\n      nav: false,\r\n      navRewind: true,\r\n      animateIn: \"fadeIn\",\r\n      animateOut: \"fadeOut\",\r\n      loop: true,\r\n      lazyLoad: true,\r\n    });\r\n  });\r\n</script>\r\n<style>\r\n  .vc_custom_1599764587094,.vc_custom_1599764578086,.vc_custom_1599764595067 {\r\n    padding-top: 20px;\r\n    padding-bottom: 20px;\r\n    padding-left: 7.25%;\r\n  }\r\n  .porto-ultimate-content-box {\r\n    font-size: 16px;\r\n    position: relative;\r\n  }\r\n  .ls-80 {\r\n    letter-spacing: 0.08em;\r\n  }\r\n  .coupon-sale-text {\r\n    transform: rotate(-2deg);\r\n    letter-spacing: -0.01em;\r\n    position: relative;\r\n    font-weight: 700;\r\n  }\r\n  .coupon-sale-text b {\r\n    display: inline-block;\r\n    font-size: 1.6em;\r\n    padding: 5px 8px;\r\n    background: #fff;\r\n  }\r\n  .btn-modern.btn-lg {\r\n    padding: 0.7rem 2.15rem;\r\n    line-height: 1.3333;\r\n  }\r\n  .category-cms, .category-image, .category-description {\r\n    margin-bottom: 0; \r\n  }\r\n  .m-r-lg {\r\n    margin-right: 30px!important;\r\n  }\r\n</style>\r\n'),(16,50,0,3,NULL),(17,51,0,3,NULL),(18,144,0,3,NULL),(19,146,0,3,NULL),(20,149,0,3,NULL);

--
-- 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=338 DEFAULT CHARSET=utf8 COMMENT='Catalog Category Varchar Attribute Backend Table';

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

INSERT INTO `catalog_category_entity_varchar` VALUES (1,45,0,1,'Root Catalog'),(2,45,0,2,'Default Category'),(3,52,0,2,'PRODUCTS'),(4,45,0,3,'Fashion'),(5,52,0,3,'PRODUCTS_AND_PAGE'),(6,117,0,3,'fashion'),(7,118,0,3,'fashion'),(8,137,0,3,'staticwidth'),(9,138,0,3,'650px'),(10,139,0,3,'2'),(11,141,0,3,NULL),(12,145,0,3,'0'),(13,147,0,3,'4'),(14,152,0,3,'porto-icon-shirt'),(15,153,0,3,'#1bd49e'),(16,45,0,4,'Electronics'),(17,52,0,4,'PRODUCTS'),(18,117,0,4,'electronics'),(19,118,0,4,'electronics'),(20,137,0,4,NULL),(21,139,0,4,NULL),(22,145,0,4,'0'),(23,147,0,4,'0'),(24,152,0,4,'porto-icon-computer'),(25,153,0,4,'#f69a33'),(35,45,0,6,'Women'),(36,52,0,6,'PRODUCTS'),(37,117,0,6,'women'),(38,118,0,6,'fashion/women'),(39,145,0,6,'0'),(40,147,0,6,'0'),(41,45,0,7,'Men'),(42,52,0,7,'PRODUCTS'),(43,117,0,7,'men'),(44,118,0,7,'fashion/men'),(45,145,0,7,'0'),(46,147,0,7,'0'),(47,45,0,8,'Jewellery'),(48,52,0,8,'PRODUCTS'),(49,117,0,8,'jewellery'),(50,118,0,8,'fashion/jewellery'),(51,145,0,8,'0'),(52,147,0,8,'0'),(53,45,0,9,'Kids Fashion'),(54,52,0,9,'PRODUCTS'),(55,117,0,9,'kids-fashion'),(56,118,0,9,'fashion/kids-fashion'),(57,145,0,9,'0'),(58,147,0,9,'0'),(59,45,0,10,'Tops & Blouses'),(60,52,0,10,'PRODUCTS'),(61,117,0,10,'tops-blouses'),(62,118,0,10,'fashion/women/tops-blouses'),(63,145,0,10,'0'),(64,147,0,10,'0'),(65,45,0,11,'Accessories'),(66,52,0,11,'PRODUCTS'),(67,117,0,11,'accessories'),(68,118,0,11,'fashion/women/accessories'),(69,145,0,11,'0'),(70,147,0,11,'0'),(71,45,0,12,'Bottoms & Skirts'),(72,52,0,12,'PRODUCTS'),(73,117,0,12,'bottoms-skirts'),(74,118,0,12,'fashion/women/bottoms-skirts'),(75,145,0,12,'0'),(76,147,0,12,'0'),(77,45,0,13,'Shoes & Boots'),(78,52,0,13,'PRODUCTS'),(79,117,0,13,'shoes-boots'),(80,118,0,13,'fashion/women/shoes-boots'),(81,145,0,13,'0'),(82,147,0,13,'0'),(83,45,0,14,'Accessories'),(84,52,0,14,'PRODUCTS'),(85,117,0,14,'accessories'),(86,118,0,14,'fashion/men/accessories'),(87,145,0,14,'0'),(88,147,0,14,'0'),(89,45,0,15,'Watch Fashion'),(90,52,0,15,'PRODUCTS'),(91,117,0,15,'watch-fashion'),(92,118,0,15,'fashion/men/watch-fashion'),(93,145,0,15,'0'),(94,147,0,15,'0'),(95,45,0,16,'Tees, Knits & Polos'),(96,52,0,16,'PRODUCTS'),(97,117,0,16,'tees-knits-polos'),(98,118,0,16,'fashion/men/tees-knits-polos'),(99,145,0,16,'0'),(100,147,0,16,'0'),(101,45,0,17,'Pants & Denim'),(102,52,0,17,'PRODUCTS'),(103,117,0,17,'pants-denim'),(104,118,0,17,'fashion/men/pants-denim'),(105,145,0,17,'0'),(106,147,0,17,'0'),(107,45,0,18,'Rings'),(108,52,0,18,'PRODUCTS'),(109,117,0,18,'rings'),(110,118,0,18,'fashion/jewellery/rings'),(111,145,0,18,'0'),(112,147,0,18,'0'),(113,45,0,19,'Earrings'),(114,52,0,19,'PRODUCTS'),(115,117,0,19,'earrings'),(116,118,0,19,'fashion/jewellery/earrings'),(117,145,0,19,'0'),(118,147,0,19,'0'),(119,45,0,20,'Pendants & Necklaces'),(120,52,0,20,'PRODUCTS'),(121,117,0,20,'pendants-necklaces'),(122,118,0,20,'fashion/jewellery/pendants-necklaces'),(123,145,0,20,'0'),(124,147,0,20,'0'),(125,45,0,21,'Casual Shoes'),(126,52,0,21,'PRODUCTS'),(127,117,0,21,'casual-shoes'),(128,118,0,21,'fashion/kids-fashion/casual-shoes'),(129,145,0,21,'0'),(130,147,0,21,'0'),(131,45,0,22,'Spring & Autumn'),(132,52,0,22,'PRODUCTS'),(133,117,0,22,'spring-autumn'),(134,118,0,22,'fashion/kids-fashion/spring-autumn'),(135,145,0,22,'0'),(136,147,0,22,'0'),(137,45,0,23,'Winter Sneakers'),(138,52,0,23,'PRODUCTS'),(139,117,0,23,'winter-sneakers'),(140,118,0,23,'fashion/kids-fashion/winter-sneakers'),(141,145,0,23,'0'),(142,147,0,23,'0'),(321,49,0,4,NULL),(322,60,0,4,NULL),(323,63,0,4,NULL),(324,138,0,4,NULL),(325,140,0,4,NULL),(326,141,0,4,NULL),(327,143,0,4,NULL),(329,49,0,3,NULL),(330,60,0,3,NULL),(331,63,0,3,NULL),(332,140,0,3,NULL),(333,143,0,3,NULL),(335,48,0,3,NULL),(336,142,0,3,NULL),(337,151,0,3,NULL);

--
-- 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=170 DEFAULT CHARSET=utf8 COMMENT='Catalog Product To Category Linkage Table';

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

INSERT INTO `catalog_category_product` VALUES (1,2,1,1),(2,3,1,1),(3,6,1,1),(4,10,1,1),(5,2,2,1),(6,3,2,1),(7,6,2,1),(8,10,2,1),(9,2,3,1),(10,3,3,1),(11,6,3,1),(12,10,3,1),(13,2,4,1),(14,3,4,1),(15,6,4,1),(16,10,4,1),(17,2,5,1),(18,3,5,1),(19,6,5,1),(20,10,5,1),(21,2,6,1),(22,3,6,1),(23,6,6,1),(24,10,6,1),(25,2,7,1),(26,3,7,1),(27,6,7,1),(28,10,7,1),(29,2,8,1),(30,3,8,1),(31,6,8,1),(32,10,8,1),(33,2,9,1),(34,3,9,1),(35,6,9,1),(36,10,9,1),(37,2,10,1),(38,3,10,1),(39,6,10,1),(40,2,11,1),(41,3,11,1),(42,6,11,1),(43,2,12,1),(44,3,12,1),(45,6,12,1),(46,2,13,1),(47,3,13,1),(48,6,13,1),(49,2,14,1),(50,3,14,1),(51,6,14,1),(52,2,15,1),(53,3,15,1),(54,6,15,1),(55,4,1,0),(56,4,2,0),(57,4,3,0),(58,4,4,0),(59,4,5,0),(60,4,6,0),(61,4,7,0),(62,4,8,0),(63,4,9,0),(64,4,10,0),(65,4,11,0),(66,4,12,0),(67,4,13,0),(68,4,14,0),(69,4,15,0),(70,2,16,0),(71,3,16,0),(72,4,16,0),(73,6,16,0),(74,2,17,0),(75,3,17,0),(76,4,17,0),(77,6,17,0),(78,2,18,0),(79,3,18,0),(80,4,18,0),(81,6,18,0),(82,2,19,0),(83,3,19,0),(84,4,19,0),(85,6,19,0),(86,2,20,0),(87,3,20,0),(88,4,20,0),(89,6,20,0),(90,2,21,0),(91,3,21,0),(92,4,21,0),(93,6,21,0),(94,2,22,0),(95,3,22,0),(96,4,22,0),(97,6,22,0),(98,2,23,0),(99,3,23,0),(100,4,23,0),(101,6,23,0),(102,2,24,0),(103,3,24,0),(104,4,24,0),(105,6,24,0),(106,2,25,0),(107,3,25,0),(108,4,25,0),(109,6,25,0),(110,2,26,0),(111,3,26,0),(112,4,26,0),(113,6,26,0),(114,2,27,0),(115,3,27,0),(116,4,27,0),(117,6,27,0),(118,2,28,0),(119,3,28,0),(120,4,28,0),(121,6,28,0),(122,2,29,0),(123,3,29,0),(124,4,29,0),(125,6,29,0),(126,2,30,0),(127,3,30,0),(128,4,30,0),(129,6,30,0),(130,2,31,0),(131,3,31,0),(132,4,31,0),(133,6,31,0),(134,2,32,0),(135,3,32,0),(136,4,32,0),(137,6,32,0),(138,2,33,0),(139,3,33,0),(140,4,33,0),(141,6,33,0),(142,2,34,0),(143,3,34,0),(144,4,34,0),(145,6,34,0),(146,2,35,0),(147,3,35,0),(148,4,35,0),(149,6,35,0),(150,2,36,0),(151,3,36,0),(152,4,36,0),(153,6,36,0),(154,2,37,0),(155,3,37,0),(156,4,37,0),(157,6,37,0),(158,2,38,0),(159,3,38,0),(160,4,38,0),(161,6,38,0),(162,2,39,0),(163,3,39,0),(164,4,39,0),(165,6,39,0),(166,2,40,0),(167,3,40,0),(168,4,40,0),(169,6,40,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` VALUES (2,32,0,1,1,4),(2,33,0,1,1,4),(2,34,0,1,1,4),(2,35,0,1,1,4),(2,36,0,1,1,4),(2,1,1,1,1,4),(2,2,1,1,1,4),(2,3,1,1,1,4),(2,4,1,1,1,4),(2,5,1,1,1,4),(2,6,1,1,1,4),(2,7,1,1,1,4),(2,8,1,1,1,4),(2,9,1,1,1,4),(2,15,1,1,1,4),(3,32,0,1,1,4),(3,33,0,1,1,4),(3,34,0,1,1,4),(3,35,0,1,1,4),(3,36,0,1,1,4),(3,1,1,1,1,4),(3,2,1,1,1,4),(3,3,1,1,1,4),(3,4,1,1,1,4),(3,5,1,1,1,4),(3,6,1,1,1,4),(3,7,1,1,1,4),(3,8,1,1,1,4),(3,9,1,1,1,4),(3,15,1,1,1,4),(4,1,0,1,1,4),(4,2,0,1,1,4),(4,3,0,1,1,4),(4,4,0,1,1,4),(4,5,0,1,1,4),(4,6,0,1,1,4),(4,7,0,1,1,4),(4,8,0,1,1,4),(4,9,0,1,1,4),(4,15,0,1,1,4),(4,32,0,1,1,4),(4,33,0,1,1,4),(4,34,0,1,1,4),(4,35,0,1,1,4),(4,36,0,1,1,4),(6,32,0,1,1,4),(6,33,0,1,1,4),(6,34,0,1,1,4),(6,35,0,1,1,4),(6,36,0,1,1,4),(6,1,1,1,1,4),(6,2,1,1,1,4),(6,3,1,1,1,4),(6,4,1,1,1,4),(6,5,1,1,1,4),(6,6,1,1,1,4),(6,7,1,1,1,4),(6,8,1,1,1,4),(6,9,1,1,1,4),(6,15,1,1,1,4),(10,1,1,1,1,4),(10,2,1,1,1,4),(10,3,1,1,1,4),(10,4,1,1,1,4),(10,5,1,1,1,4),(10,6,1,1,1,4),(10,7,1,1,1,4),(10,8,1,1,1,4),(10,9,1,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` VALUES (2,32,0,1,1,4),(2,33,0,1,1,4),(2,34,0,1,1,4),(2,35,0,1,1,4),(2,36,0,1,1,4),(2,1,1,1,1,4),(2,2,1,1,1,4),(2,3,1,1,1,4),(2,4,1,1,1,4),(2,5,1,1,1,4),(2,6,1,1,1,4),(2,7,1,1,1,4),(2,8,1,1,1,4),(2,9,1,1,1,4),(2,15,1,1,1,4),(3,32,0,1,1,4),(3,33,0,1,1,4),(3,34,0,1,1,4),(3,35,0,1,1,4),(3,36,0,1,1,4),(3,1,1,1,1,4),(3,2,1,1,1,4),(3,3,1,1,1,4),(3,4,1,1,1,4),(3,5,1,1,1,4),(3,6,1,1,1,4),(3,7,1,1,1,4),(3,8,1,1,1,4),(3,9,1,1,1,4),(3,15,1,1,1,4),(4,1,0,1,1,4),(4,2,0,1,1,4),(4,3,0,1,1,4),(4,4,0,1,1,4),(4,5,0,1,1,4),(4,6,0,1,1,4),(4,7,0,1,1,4),(4,8,0,1,1,4),(4,9,0,1,1,4),(4,15,0,1,1,4),(4,32,0,1,1,4),(4,33,0,1,1,4),(4,34,0,1,1,4),(4,35,0,1,1,4),(4,36,0,1,1,4),(6,32,0,1,1,4),(6,33,0,1,1,4),(6,34,0,1,1,4),(6,35,0,1,1,4),(6,36,0,1,1,4),(6,1,1,1,1,4),(6,2,1,1,1,4),(6,3,1,1,1,4),(6,4,1,1,1,4),(6,5,1,1,1,4),(6,6,1,1,1,4),(6,7,1,1,1,4),(6,8,1,1,1,4),(6,9,1,1,1,4),(6,15,1,1,1,4),(10,1,1,1,1,4),(10,2,1,1,1,4),(10,3,1,1,1,4),(10,4,1,1,1,4),(10,5,1,1,1,4),(10,6,1,1,1,4),(10,7,1,1,1,4),(10,8,1,1,1,4),(10,9,1,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` VALUES (2,32,0,1,2,4),(2,33,0,1,2,4),(2,34,0,1,2,4),(2,35,0,1,2,4),(2,36,0,1,2,4),(2,1,1,1,2,4),(2,2,1,1,2,4),(2,3,1,1,2,4),(2,4,1,1,2,4),(2,5,1,1,2,4),(2,6,1,1,2,4),(2,7,1,1,2,4),(2,8,1,1,2,4),(2,9,1,1,2,4),(2,15,1,1,2,4),(3,32,0,1,2,4),(3,33,0,1,2,4),(3,34,0,1,2,4),(3,35,0,1,2,4),(3,36,0,1,2,4),(3,1,1,1,2,4),(3,2,1,1,2,4),(3,3,1,1,2,4),(3,4,1,1,2,4),(3,5,1,1,2,4),(3,6,1,1,2,4),(3,7,1,1,2,4),(3,8,1,1,2,4),(3,9,1,1,2,4),(3,15,1,1,2,4),(4,1,0,1,2,4),(4,2,0,1,2,4),(4,3,0,1,2,4),(4,4,0,1,2,4),(4,5,0,1,2,4),(4,6,0,1,2,4),(4,7,0,1,2,4),(4,8,0,1,2,4),(4,9,0,1,2,4),(4,15,0,1,2,4),(4,32,0,1,2,4),(4,33,0,1,2,4),(4,34,0,1,2,4),(4,35,0,1,2,4),(4,36,0,1,2,4),(6,32,0,1,2,4),(6,33,0,1,2,4),(6,34,0,1,2,4),(6,35,0,1,2,4),(6,36,0,1,2,4),(6,1,1,1,2,4),(6,2,1,1,2,4),(6,3,1,1,2,4),(6,4,1,1,2,4),(6,5,1,1,2,4),(6,6,1,1,2,4),(6,7,1,1,2,4),(6,8,1,1,2,4),(6,9,1,1,2,4),(6,15,1,1,2,4),(10,1,1,1,2,4),(10,2,1,1,2,4),(10,3,1,1,2,4),(10,4,1,1,2,4),(10,5,1,1,2,4),(10,6,1,1,2,4),(10,7,1,1,2,4),(10,8,1,1,2,4),(10,9,1,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` VALUES (2,32,0,1,2,4),(2,33,0,1,2,4),(2,34,0,1,2,4),(2,35,0,1,2,4),(2,36,0,1,2,4),(2,1,1,1,2,4),(2,2,1,1,2,4),(2,3,1,1,2,4),(2,4,1,1,2,4),(2,5,1,1,2,4),(2,6,1,1,2,4),(2,7,1,1,2,4),(2,8,1,1,2,4),(2,9,1,1,2,4),(2,15,1,1,2,4),(3,32,0,1,2,4),(3,33,0,1,2,4),(3,34,0,1,2,4),(3,35,0,1,2,4),(3,36,0,1,2,4),(3,1,1,1,2,4),(3,2,1,1,2,4),(3,3,1,1,2,4),(3,4,1,1,2,4),(3,5,1,1,2,4),(3,6,1,1,2,4),(3,7,1,1,2,4),(3,8,1,1,2,4),(3,9,1,1,2,4),(3,15,1,1,2,4),(4,1,0,1,2,4),(4,2,0,1,2,4),(4,3,0,1,2,4),(4,4,0,1,2,4),(4,5,0,1,2,4),(4,6,0,1,2,4),(4,7,0,1,2,4),(4,8,0,1,2,4),(4,9,0,1,2,4),(4,15,0,1,2,4),(4,32,0,1,2,4),(4,33,0,1,2,4),(4,34,0,1,2,4),(4,35,0,1,2,4),(4,36,0,1,2,4),(6,32,0,1,2,4),(6,33,0,1,2,4),(6,34,0,1,2,4),(6,35,0,1,2,4),(6,36,0,1,2,4),(6,1,1,1,2,4),(6,2,1,1,2,4),(6,3,1,1,2,4),(6,4,1,1,2,4),(6,5,1,1,2,4),(6,6,1,1,2,4),(6,7,1,1,2,4),(6,8,1,1,2,4),(6,9,1,1,2,4),(6,15,1,1,2,4),(10,1,1,1,2,4),(10,2,1,1,2,4),(10,3,1,1,2,4),(10,4,1,1,2,4),(10,5,1,1,2,4),(10,6,1,1,2,4),(10,7,1,1,2,4),(10,8,1,1,2,4),(10,9,1,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 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` 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,bundle,downloadable,configurable',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,bundle,downloadable,configurable',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,bundle,downloadable,configurable',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,bundle,downloadable,configurable',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,bundle,downloadable,configurable',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,bundle,downloadable',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,'{\"swatch_input_type\":\"visual\",\"update_product_preview_image\":\"0\",\"use_product_image_for_swatch\":\"0\"}'),(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,bundle,downloadable,configurable',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,grouped,configurable',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,NULL,0,1,1,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(118,NULL,0,0,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(119,NULL,0,1,1,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,1,0,1,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,'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),(122,'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),(123,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(124,NULL,1,1,0,0,0,0,0,0,0,0,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(125,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(126,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(127,NULL,1,1,0,0,0,0,0,0,0,1,0,'bundle',0,0,0,0,0,0,0,0,1,NULL),(128,NULL,1,0,0,0,0,0,0,0,0,1,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(129,NULL,0,0,0,0,0,0,0,0,0,0,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(130,NULL,0,0,0,0,0,0,0,0,0,0,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(131,NULL,1,0,0,0,0,0,0,0,0,1,0,'downloadable',0,0,0,0,0,0,0,0,1,NULL),(132,NULL,0,1,0,0,0,0,0,0,0,1,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(133,NULL,2,1,1,0,0,0,0,0,0,1,0,'simple,virtual,bundle,downloadable,configurable',0,0,0,0,0,1,0,1,1,NULL),(134,'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),(135,NULL,1,1,0,0,0,0,0,0,0,1,0,'simple,configurable,virtual,bundle,downloadable',0,0,0,0,0,0,0,0,1,NULL),(136,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(137,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,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,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(141,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(142,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(143,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(144,NULL,0,1,0,0,0,0,1,0,0,0,0,NULL,0,0,1,0,0,0,0,0,1,NULL),(145,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(146,NULL,0,1,0,0,0,0,1,0,0,0,0,NULL,0,0,1,0,0,0,0,0,1,NULL),(147,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(148,NULL,0,1,0,0,0,0,1,0,0,0,0,NULL,0,0,1,0,0,0,0,0,1,NULL),(149,NULL,0,1,0,0,0,0,1,0,0,0,0,NULL,0,0,1,0,0,0,0,0,1,NULL),(150,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(151,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(152,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(153,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(154,NULL,0,1,0,0,0,0,1,0,0,0,0,NULL,0,0,1,0,0,0,0,0,1,NULL),(155,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,configurable,virtual,bundle,downloadable',0,0,0,0,0,0,0,0,1,NULL),(156,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,configurable,virtual,bundle,downloadable',0,0,0,0,0,0,0,0,1,NULL),(157,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,configurable,virtual,bundle,downloadable',0,0,1,0,0,0,0,0,1,NULL),(158,NULL,1,1,0,0,0,0,0,0,0,0,0,'simple,configurable,virtual,bundle,downloadable',0,0,1,0,0,0,0,0,1,NULL),(159,NULL,1,1,0,1,0,0,1,0,1,0,0,NULL,0,1,0,0,0,0,1,1,1,'{\"swatch_input_type\":\"text\",\"update_product_preview_image\":\"0\",\"use_product_image_for_swatch\":0}'),(163,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),(168,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,1,NULL),(169,NULL,0,1,0,0,0,0,0,0,0,0,0,NULL,0,0,0,0,0,0,0,0,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',
  `parent_product_id` int(10) unsigned NOT NULL COMMENT 'Parent Product ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CAT_PRD_BNDL_OPT_VAL_OPT_ID_PARENT_PRD_ID_STORE_ID` (`option_id`,`parent_product_id`,`store_id`),
  CONSTRAINT `CAT_PRD_BNDL_OPT_VAL_OPT_ID_CAT_PRD_BNDL_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_bundle_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Bundle Option Value';

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


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

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

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


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

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

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


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

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

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


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

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

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


--
-- Table structure for table `catalog_product_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=41 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Table';

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

INSERT INTO `catalog_product_entity` VALUES (1,4,'simple','Women Blouse',0,0,'2016-08-26 02:49:12','2018-06-19 14:33:34'),(2,4,'simple','Fashion Dress',0,0,'2016-08-26 02:49:18','2016-08-26 02:50:31'),(3,4,'simple','Blue Denim Jeans',0,0,'2016-08-26 02:50:34','2016-08-26 02:51:40'),(4,4,'simple','Sheri Collar Shirt',0,0,'2016-08-26 02:51:43','2016-08-26 02:52:54'),(5,4,'simple','Fashion Jacket',0,0,'2016-08-26 02:52:57','2016-08-26 02:53:46'),(6,4,'simple','Sample Product',0,0,'2016-08-26 02:53:49','2016-08-26 02:55:03'),(7,4,'simple','Elizabeth Kint Top',0,0,'2016-08-26 02:55:05','2016-08-26 02:56:11'),(8,4,'simple','Pink Shirt',0,0,'2016-08-26 02:56:13','2016-08-26 02:57:03'),(9,4,'simple','Sample Fashion',0,0,'2016-08-26 02:57:05','2016-08-26 02:59:15'),(10,9,'simple','Sample Configurable-White',0,0,'2016-08-26 03:04:41','2016-08-26 03:04:41'),(11,9,'simple','Sample Configurable-Black',0,0,'2016-08-26 03:04:43','2016-08-26 03:04:43'),(12,9,'simple','Sample Configurable-Red',0,0,'2016-08-26 03:04:44','2016-08-26 03:04:44'),(13,9,'simple','Sample Configurable-Blue',0,0,'2016-08-26 03:04:46','2016-08-26 03:04:46'),(14,9,'simple','Sample Configurable-Green',0,0,'2016-08-26 03:04:47','2016-08-26 03:04:47'),(15,9,'configurable','Sample Configurable',1,1,'2016-08-26 03:04:48','2016-08-26 03:04:48'),(16,9,'simple','P_TYPE_CAROUSEL-Red-Small',0,0,'2018-06-19 14:45:35','2018-06-19 14:45:35'),(17,9,'simple','P_TYPE_CAROUSEL-Red-Medium',0,0,'2018-06-19 14:45:37','2018-06-19 14:45:37'),(18,9,'simple','P_TYPE_CAROUSEL-Red-Large',0,0,'2018-06-19 14:45:37','2018-06-19 14:45:37'),(19,9,'simple','P_TYPE_CAROUSEL-Red-Extra Large',0,0,'2018-06-19 14:45:38','2018-06-19 14:45:38'),(20,9,'simple','P_TYPE_CAROUSEL-Blue-Small',0,0,'2018-06-19 14:45:39','2018-06-19 14:45:39'),(21,9,'simple','P_TYPE_CAROUSEL-Blue-Medium',0,0,'2018-06-19 14:45:40','2018-06-19 14:45:40'),(22,9,'simple','P_TYPE_CAROUSEL-Blue-Large',0,0,'2018-06-19 14:45:40','2018-06-19 14:45:40'),(23,9,'simple','P_TYPE_CAROUSEL-Blue-Extra Large',0,0,'2018-06-19 14:45:41','2018-06-19 14:45:41'),(24,9,'simple','P_TYPE_CAROUSEL-Green-Small',0,0,'2018-06-19 14:45:42','2018-06-19 14:45:42'),(25,9,'simple','P_TYPE_CAROUSEL-Green-Medium',0,0,'2018-06-19 14:45:42','2018-06-19 14:45:42'),(26,9,'simple','P_TYPE_CAROUSEL-Green-Large',0,0,'2018-06-19 14:45:43','2018-06-19 14:45:43'),(27,9,'simple','P_TYPE_CAROUSEL-Green-Extra Large',0,0,'2018-06-19 14:45:43','2018-06-19 14:45:43'),(28,9,'simple','P_TYPE_CAROUSEL-Black-Small',0,0,'2018-06-19 14:45:44','2018-06-19 14:45:44'),(29,9,'simple','P_TYPE_CAROUSEL-Black-Medium',0,0,'2018-06-19 14:45:45','2018-06-19 14:45:45'),(30,9,'simple','P_TYPE_CAROUSEL-Black-Large',0,0,'2018-06-19 14:45:45','2018-06-19 14:45:45'),(31,9,'simple','P_TYPE_CAROUSEL-Black-Extra Large',0,0,'2018-06-19 14:45:46','2018-06-19 14:45:46'),(32,9,'configurable','P_TYPE_CAROUSEL',1,1,'2018-06-19 14:45:47','2018-06-19 17:02:28'),(33,9,'configurable','P_TYPE_FULLWIDTH',1,1,'2018-06-19 15:14:35','2021-05-04 02:46:59'),(34,9,'configurable','P_TYPE_GRID',1,1,'2018-06-19 17:06:07','2018-06-19 17:08:25'),(35,9,'configurable','P_TYPE_STICKY_RIGHT',1,1,'2018-06-19 17:08:28','2018-06-19 17:11:07'),(36,9,'configurable','P_TYPE_VERTICAL_LAYOUT',1,1,'2018-06-19 17:11:09','2018-06-19 17:29:00'),(37,9,'simple','P_TYPE_VERTICAL_LAYOUT-Black',0,0,'2018-06-19 17:13:15','2018-06-19 17:14:23'),(38,9,'simple','P_TYPE_VERTICAL_LAYOUT-Red',0,0,'2018-06-19 17:13:17','2018-06-19 17:14:32'),(39,9,'simple','P_TYPE_VERTICAL_LAYOUT-Blue',0,0,'2018-06-19 17:13:17','2018-06-19 17:14:38'),(40,9,'simple','P_TYPE_VERTICAL_LAYOUT-Green',0,0,'2018-06-19 17:13:18','2018-06-19 17:14:44');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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=`root`@`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=`root`@`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=12 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Datetime Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_datetime` VALUES (1,79,0,6,'2016-08-26 14:55:03'),(2,94,0,6,'2016-08-26 14:55:03'),(3,101,0,6,'2016-08-26 14:55:03'),(5,94,0,7,'2016-08-26 00:00:00'),(6,101,0,7,'2016-08-26 00:00:00'),(9,101,0,8,'2016-08-26 00:00:00'),(11,101,0,9,'2016-08-26 00:00:00');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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=`root`@`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=`root`@`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=90 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Decimal Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_decimal` VALUES (1,77,0,1,70.000000),(2,82,0,1,1.000000),(3,77,0,2,90.000000),(4,82,0,2,1.000000),(6,77,0,3,200.000000),(7,82,0,3,1.000000),(9,77,0,4,70.000000),(10,82,0,4,1.000000),(12,77,0,5,33.000000),(13,82,0,5,1.000000),(15,77,0,6,70.000000),(16,82,0,6,1.000000),(18,78,0,6,50.000000),(19,77,0,7,220.000000),(21,82,0,7,1.000000),(23,77,0,8,90.000000),(24,82,0,8,1.000000),(26,77,0,9,90.000000),(27,82,0,9,1.000000),(29,77,0,10,120.000000),(30,82,0,10,1.000000),(31,77,0,11,120.000000),(32,82,0,11,1.000000),(33,77,0,12,120.000000),(34,82,0,12,1.000000),(35,77,0,13,120.000000),(36,82,0,13,1.000000),(37,77,0,14,120.000000),(38,82,0,14,1.000000),(39,77,0,15,120.000000),(40,82,0,15,1.000000),(41,77,0,16,101.000000),(42,82,0,16,1.000000),(43,77,0,17,101.000000),(44,82,0,17,1.000000),(45,77,0,18,101.000000),(46,82,0,18,1.000000),(47,77,0,19,101.000000),(48,82,0,19,1.000000),(49,77,0,20,101.000000),(50,82,0,20,1.000000),(51,77,0,21,101.000000),(52,82,0,21,1.000000),(53,77,0,22,101.000000),(54,82,0,22,1.000000),(55,77,0,23,101.000000),(56,82,0,23,1.000000),(57,77,0,24,101.000000),(58,82,0,24,1.000000),(59,77,0,25,101.000000),(60,82,0,25,1.000000),(61,77,0,26,101.000000),(62,82,0,26,1.000000),(63,77,0,27,101.000000),(64,82,0,27,1.000000),(65,77,0,28,101.000000),(66,82,0,28,1.000000),(67,77,0,29,101.000000),(68,82,0,29,1.000000),(69,77,0,30,101.000000),(70,82,0,30,1.000000),(71,77,0,31,101.000000),(72,82,0,31,1.000000),(73,82,0,32,1.000000),(74,82,0,33,1.000000),(76,82,0,34,1.000000),(78,82,0,35,1.000000),(80,82,0,36,1.000000),(82,77,0,37,101.000000),(83,82,0,37,1.000000),(84,77,0,38,101.000000),(85,82,0,38,1.000000),(86,77,0,39,101.000000),(87,82,0,39,1.000000),(88,77,0,40,101.000000),(89,82,0,40,1.000000);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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=`root`@`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=`root`@`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=`root`@`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=`root`@`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=`root`@`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=260 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Integer Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_int` VALUES (1,97,0,1,1),(2,99,0,1,4),(3,115,0,1,1),(4,133,0,1,2),(5,135,0,1,1),(6,97,0,2,1),(7,99,0,2,4),(8,115,0,2,1),(9,133,0,2,2),(10,135,0,2,1),(12,97,0,3,1),(13,99,0,3,4),(14,115,0,3,1),(15,133,0,3,2),(16,135,0,3,1),(18,97,0,4,1),(19,99,0,4,4),(20,115,0,4,1),(21,133,0,4,2),(22,135,0,4,1),(24,97,0,5,1),(25,99,0,5,4),(26,115,0,5,1),(27,133,0,5,2),(28,135,0,5,1),(30,97,0,6,1),(31,99,0,6,4),(32,115,0,6,1),(33,133,0,6,2),(34,135,0,6,1),(36,97,0,7,1),(37,99,0,7,4),(38,115,0,7,1),(39,133,0,7,2),(40,135,0,7,1),(42,97,0,8,1),(43,99,0,8,4),(44,115,0,8,1),(45,133,0,8,2),(46,135,0,8,1),(48,97,0,9,1),(49,99,0,9,4),(50,115,0,9,1),(51,133,0,9,2),(52,135,0,9,1),(54,93,0,10,4),(55,97,0,10,1),(56,99,0,10,1),(57,115,0,10,1),(58,133,0,10,2),(59,135,0,10,1),(60,93,0,11,5),(61,97,0,11,1),(62,99,0,11,1),(63,115,0,11,1),(64,133,0,11,2),(65,135,0,11,1),(66,93,0,12,6),(67,97,0,12,1),(68,99,0,12,1),(69,115,0,12,1),(70,133,0,12,2),(71,135,0,12,1),(72,93,0,13,7),(73,97,0,13,1),(74,99,0,13,1),(75,115,0,13,1),(76,133,0,13,2),(77,135,0,13,1),(78,93,0,14,8),(79,97,0,14,1),(80,99,0,14,1),(81,115,0,14,1),(82,133,0,14,2),(83,135,0,14,1),(84,97,0,15,1),(85,99,0,15,4),(86,115,0,15,1),(87,133,0,15,2),(88,135,0,15,1),(89,93,0,16,6),(90,97,0,16,1),(91,99,0,16,1),(92,115,0,16,1),(93,133,0,16,2),(94,135,0,16,0),(95,159,0,16,9),(96,93,0,17,6),(97,97,0,17,1),(98,99,0,17,1),(99,115,0,17,1),(100,133,0,17,2),(101,135,0,17,0),(102,159,0,17,10),(103,93,0,18,6),(104,97,0,18,1),(105,99,0,18,1),(106,115,0,18,1),(107,133,0,18,2),(108,135,0,18,0),(109,159,0,18,11),(110,93,0,19,6),(111,97,0,19,1),(112,99,0,19,1),(113,115,0,19,1),(114,133,0,19,2),(115,135,0,19,0),(116,159,0,19,12),(117,93,0,20,7),(118,97,0,20,1),(119,99,0,20,1),(120,115,0,20,1),(121,133,0,20,2),(122,135,0,20,0),(123,159,0,20,9),(124,93,0,21,7),(125,97,0,21,1),(126,99,0,21,1),(127,115,0,21,1),(128,133,0,21,2),(129,135,0,21,0),(130,159,0,21,10),(131,93,0,22,7),(132,97,0,22,1),(133,99,0,22,1),(134,115,0,22,1),(135,133,0,22,2),(136,135,0,22,0),(137,159,0,22,11),(138,93,0,23,7),(139,97,0,23,1),(140,99,0,23,1),(141,115,0,23,1),(142,133,0,23,2),(143,135,0,23,0),(144,159,0,23,12),(145,93,0,24,8),(146,97,0,24,1),(147,99,0,24,1),(148,115,0,24,1),(149,133,0,24,2),(150,135,0,24,0),(151,159,0,24,9),(152,93,0,25,8),(153,97,0,25,1),(154,99,0,25,1),(155,115,0,25,1),(156,133,0,25,2),(157,135,0,25,0),(158,159,0,25,10),(159,93,0,26,8),(160,97,0,26,1),(161,99,0,26,1),(162,115,0,26,1),(163,133,0,26,2),(164,135,0,26,0),(165,159,0,26,11),(166,93,0,27,8),(167,97,0,27,1),(168,99,0,27,1),(169,115,0,27,1),(170,133,0,27,2),(171,135,0,27,0),(172,159,0,27,12),(173,93,0,28,5),(174,97,0,28,1),(175,99,0,28,1),(176,115,0,28,1),(177,133,0,28,2),(178,135,0,28,0),(179,159,0,28,9),(180,93,0,29,5),(181,97,0,29,1),(182,99,0,29,1),(183,115,0,29,1),(184,133,0,29,2),(185,135,0,29,0),(186,159,0,29,10),(187,93,0,30,5),(188,97,0,30,1),(189,99,0,30,1),(190,115,0,30,1),(191,133,0,30,2),(192,135,0,30,0),(193,159,0,30,11),(194,93,0,31,5),(195,97,0,31,1),(196,99,0,31,1),(197,115,0,31,1),(198,133,0,31,2),(199,135,0,31,0),(200,159,0,31,12),(201,97,0,32,1),(202,99,0,32,4),(203,115,0,32,1),(204,133,0,32,2),(205,135,0,32,0),(207,97,0,33,1),(208,99,0,33,4),(209,115,0,33,1),(210,133,0,33,2),(211,135,0,33,0),(213,97,0,34,1),(214,99,0,34,4),(215,115,0,34,1),(216,133,0,34,2),(217,135,0,34,0),(219,97,0,35,1),(220,99,0,35,4),(221,115,0,35,1),(222,133,0,35,2),(223,135,0,35,0),(225,97,0,36,1),(226,99,0,36,4),(227,115,0,36,1),(228,133,0,36,2),(229,135,0,36,0),(231,93,0,37,5),(232,97,0,37,1),(233,99,0,37,1),(234,115,0,37,1),(235,133,0,37,2),(236,135,0,37,0),(237,93,0,38,6),(238,97,0,38,1),(239,99,0,38,1),(240,115,0,38,1),(241,133,0,38,2),(242,135,0,38,0),(243,93,0,39,7),(244,97,0,39,1),(245,99,0,39,1),(246,115,0,39,1),(247,133,0,39,2),(248,135,0,39,0),(249,93,0,40,8),(250,97,0,40,1),(251,99,0,40,1),(252,115,0,40,1),(253,133,0,40,2),(254,135,0,40,0),(255,159,0,37,9),(256,159,0,38,9),(257,159,0,39,9),(258,159,0,40,9),(259,159,0,36,9);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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=`root`@`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=`root`@`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=29 DEFAULT CHARSET=utf8 COMMENT='Catalog Product Media Gallery Attribute Backend Table';

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

INSERT INTO `catalog_product_entity_media_gallery` VALUES (1,90,'//s/a/sample.jpg','image',0),(2,90,'//s/a/sample_1.jpg','image',0),(3,90,'//s/a/sample_2.jpg','image',0),(4,90,'//s/a/sample_3.jpg','image',0),(5,90,'//s/a/sample_4.jpg','image',0),(6,90,'//s/a/sample_1_1.jpg','image',0),(7,90,'//s/a/sample_2_1.jpg','image',0),(8,90,'//s/a/sample_3_1.jpg','image',0),(9,90,'//s/a/sample_4_1.jpg','image',0),(10,90,'//s/a/sample_1_1_1.jpg','image',0),(11,90,'//s/a/sample_2_1_1.jpg','image',0),(12,90,'//s/a/sample_3_1_1.jpg','image',0),(13,90,'//s/a/sample_4_1_1.jpg','image',0),(14,90,'//s/a/sample_1_1_1_1.jpg','image',0),(15,90,'//s/a/sample_2_1_1_1.jpg','image',0),(16,90,'//s/a/sample_3_1_1_1.jpg','image',0),(25,90,'//s/a/sample1_4.jpg','image',0),(26,90,'//s/a/sample1_1_1.jpg','image',0),(27,90,'//s/a/sample1_2_1.jpg','image',0),(28,90,'//s/a/sample1_3_1.jpg','image',0);

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

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

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

INSERT INTO `catalog_product_entity_media_gallery_value` VALUES (1,0,32,NULL,1,0,17),(2,0,32,NULL,2,0,18),(3,0,32,NULL,3,0,19),(4,0,32,NULL,4,0,20),(9,0,34,NULL,1,0,41),(10,0,34,NULL,2,0,42),(11,0,34,NULL,3,0,43),(12,0,34,NULL,4,0,44),(13,0,35,NULL,1,0,53),(14,0,35,NULL,2,0,54),(15,0,35,NULL,3,0,55),(16,0,35,NULL,4,0,56),(25,0,36,NULL,5,0,69),(26,0,36,NULL,6,0,70),(27,0,36,NULL,7,0,71),(28,0,36,NULL,8,0,72),(5,0,33,NULL,1,0,73),(6,0,33,NULL,2,0,74),(7,0,33,NULL,3,0,75),(8,0,33,NULL,4,0,76);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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=`root`@`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=`root`@`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` VALUES (1,32),(2,32),(3,32),(4,32),(5,33),(6,33),(7,33),(8,33),(9,34),(10,34),(11,34),(12,34),(13,35),(14,35),(15,35),(16,35),(25,36),(26,36),(27,36),(28,36);

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

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

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


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

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

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

INSERT INTO `catalog_product_entity_text` VALUES (1,75,0,1,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(2,76,0,1,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(3,85,0,1,'Women Blouse'),(4,75,0,2,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(5,76,0,2,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(6,85,0,2,'Women Blouse'),(8,75,0,3,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(9,76,0,3,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(10,85,0,3,'Women Blouse'),(12,75,0,4,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(13,76,0,4,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(14,85,0,4,'Women Blouse'),(16,75,0,5,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(17,76,0,5,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(18,85,0,5,'Women Blouse'),(20,75,0,6,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(21,76,0,6,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(22,85,0,6,'Women Blouse'),(24,75,0,7,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(25,76,0,7,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(26,85,0,7,'Women Blouse'),(28,75,0,8,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(29,76,0,8,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(30,85,0,8,'Women Blouse'),(32,75,0,9,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>\r\n\r\n	<ul>\r\n		<li>Any Product types that You want - Simple, Configurable, Bundled and Grouped Products</li>\r\n		<li>Downloadable/Digital Products, Virtual Products</li>\r\n		<li>Inventory Management with Backordered items</li>\r\n		<li>Customer Personalized Products - upload text for embroidery, monogramming, etc.</li>\r\n		<li>Create Store-specific attributes on the fly</li>\r\n		<li>Advanced Pricing Rules and support for Special Prices</li>\r\n		<li>Tax Rates per location, customer group and product type</li>\r\n                <li>Detailed Configuration Options in Theme Admin Penl</li>\r\n	</ul>'),(33,76,0,9,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p>'),(34,85,0,9,'Women Blouse'),(36,85,0,10,'Sample Configurable'),(37,85,0,11,'Sample Configurable'),(38,85,0,12,'Sample Configurable'),(39,85,0,13,'Sample Configurable'),(40,85,0,14,'Sample Configurable'),(41,85,0,15,'Sample Configurable'),(42,75,0,16,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(43,76,0,16,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(44,85,0,16,'Extend Type Product'),(45,157,0,16,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(46,158,0,16,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(47,75,0,17,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(48,76,0,17,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(49,85,0,17,'Extend Type Product'),(50,157,0,17,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(51,158,0,17,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(52,75,0,18,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(53,76,0,18,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(54,85,0,18,'Extend Type Product'),(55,157,0,18,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(56,158,0,18,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(57,75,0,19,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(58,76,0,19,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(59,85,0,19,'Extend Type Product'),(60,157,0,19,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(61,158,0,19,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(62,75,0,20,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(63,76,0,20,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(64,85,0,20,'Extend Type Product'),(65,157,0,20,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(66,158,0,20,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(67,75,0,21,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(68,76,0,21,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(69,85,0,21,'Extend Type Product'),(70,157,0,21,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(71,158,0,21,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(72,75,0,22,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(73,76,0,22,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(74,85,0,22,'Extend Type Product'),(75,157,0,22,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(76,158,0,22,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(77,75,0,23,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(78,76,0,23,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(79,85,0,23,'Extend Type Product'),(80,157,0,23,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(81,158,0,23,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(82,75,0,24,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(83,76,0,24,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(84,85,0,24,'Extend Type Product'),(85,157,0,24,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(86,158,0,24,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(87,75,0,25,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(88,76,0,25,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(89,85,0,25,'Extend Type Product'),(90,157,0,25,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(91,158,0,25,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(92,75,0,26,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(93,76,0,26,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(94,85,0,26,'Extend Type Product'),(95,157,0,26,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(96,158,0,26,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(97,75,0,27,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(98,76,0,27,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(99,85,0,27,'Extend Type Product'),(100,157,0,27,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(101,158,0,27,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(102,75,0,28,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(103,76,0,28,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(104,85,0,28,'Extend Type Product'),(105,157,0,28,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(106,158,0,28,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(107,75,0,29,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(108,76,0,29,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(109,85,0,29,'Extend Type Product'),(110,157,0,29,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(111,158,0,29,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(112,75,0,30,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(113,76,0,30,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(114,85,0,30,'Extend Type Product'),(115,157,0,30,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(116,158,0,30,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(117,75,0,31,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(118,76,0,31,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(119,85,0,31,'Extend Type Product'),(120,157,0,31,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(121,158,0,31,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(122,75,0,32,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(123,76,0,32,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat nonxcepteur sint occaecat cupidatat non. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non'),(124,85,0,32,'Extend Type Product'),(125,157,0,32,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>MONEY BACK<br>GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(126,158,0,32,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(127,75,0,33,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<img src=\"{{media url=\"wysiwyg/smartwave/porto/product/shop1_fullwidth_product_img1-1.jpg\"}}\" alt=\"\" style=\"float:right;width:50%;\" />\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam.</p>\r\n<ul style=\"padding-left: 0;\">\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<div class=\"shop-features\" style=\"background-color:#fff; margin-top:13px;clear:both;\"> \r\n      <div class=\"row\">\r\n        <div class=\"col-md-4\" style=\"margin-bottom: 10px;\">\r\n          <em class=\"porto-icon-star\" style=\"color: #08c;border-color: #08c;\"></em>\r\n          <h3>DEDICATED SERVICE</h3>\r\n          <p>Consult our specialists for help with an order, customization, or design advice.</p>\r\n        </div>\r\n        <div class=\"col-md-4\" style=\"margin-bottom: 10px;\">\r\n          <em class=\"porto-icon-reply\" style=\"color: #08c;border-color: #08c;\"></em>\r\n          <h3>FREE RETURNS</h3>\r\n          <p>We stand behind our goods and services and want you to be satisfied with them.</p>\r\n        </div>\r\n        <div class=\"col-md-4\" style=\"margin-bottom: 10px;\">\r\n          <em class=\"porto-icon-paper-plane\" style=\"color: #08c;border-color: #08c;\"></em>\r\n          <h3>INTERNATIONAL SHIPPING</h3>\r\n          <p>Currently over 50 countries qualify for express international shipping.</p>\r\n        </div>\r\n      </div>\r\n    </div>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore. Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore.Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore.</p>'),(128,76,0,33,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(130,157,0,33,NULL),(131,158,0,33,'<div style=\"background:url({{media url=\"wysiwyg/smartwave/porto/product/extended_product_video.jpg\"}}) no-repeat;background-size: cover;padding:100px 0; text-align:center;margin-top:-50px;\">\r\n    <h3 style=\"font-family:\'Open Sans\';font-size: 35px;font-weight: 600;color: #21293c;\">Concept Film</h3>\r\n    <a style=\"font-weight: 600;color: #7b858a;font-size: 20px;line-height: 36px;text-transform:uppercase;text-decoration:none;\" href=\"javascript:void(0)\">Watch <img src=\"{{media url=\"wysiwyg/smartwave/porto/product/extended_product_playicon.png\"}}\" alt=\"\" style=\"opacity: 0.6;margin-left: 5px;position: relative;top: -2px;width:38px;vertical-align:middle;\"></a>\r\n</div>'),(133,85,0,33,'Fullwidth Type Product'),(134,75,0,34,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(135,76,0,34,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(136,85,0,34,'Grid Type Product'),(140,75,0,35,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(141,76,0,35,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(142,85,0,35,'Right Info Sticky Product'),(144,157,0,35,'<div class=\"custom-block custom-block-1\"> \r\n<div>\r\n<i class=\"porto-icon-shipped\"></i><h3>FREE<br>SHIPPING</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-us-dollar\"></i><h3>100% MONEY<br>BACK GUARANTEE</h3>\r\n</div>\r\n<div>\r\n<i class=\"porto-icon-online-support\"></i><h3>ONLINE<br>SUPPORT 24/7</h3>\r\n</div>\r\n</div>'),(145,75,0,36,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(146,76,0,36,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(147,85,0,36,'Vertical Layout Product'),(150,75,0,37,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(151,76,0,37,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(152,85,0,37,'Vertical Layout Product'),(153,75,0,38,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(154,76,0,38,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(155,85,0,38,'Vertical Layout Product'),(156,75,0,39,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(157,76,0,39,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(158,85,0,39,'Vertical Layout Product'),(159,75,0,40,'<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat.</p>\r\n<ul>\r\n	<li><i class=\"porto-icon-ok\"></i>Any Product types that You want - Simple, Configurable</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Downloadable/Digital Products, Virtual Products</li>\r\n	<li><i class=\"porto-icon-ok\"></i>Inventory Management with Backordered items</li>\r\n</ul>\r\n<p>Sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, <br/>quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. </p>'),(160,76,0,40,'Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.'),(161,85,0,40,'Vertical Layout Product');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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=`root`@`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=`root`@`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',
  `percentage_value` decimal(5,2) DEFAULT NULL COMMENT 'Percentage value',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `UNQ_E8AB433B9ACB00343ABB312AD2FAB087` (`entity_id`,`all_groups`,`customer_group_id`,`qty`,`website_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOG_PRODUCT_ENTITY_TIER_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_CSTR_GROUP_ID_CSTR_GROUP_CSTR_GROUP_ID` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_ENTT_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `CAT_PRD_ENTT_TIER_PRICE_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Tier Price Attribute Backend Table';

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

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_tier_price_after_update` AFTER UPDATE ON `catalog_product_entity_tier_price` FOR EACH ROW BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`all_groups` <=> OLD.`all_groups`) OR NOT(NEW.`customer_group_id` <=> OLD.`customer_group_id`) OR NOT(NEW.`qty` <=> OLD.`qty`) OR NOT(NEW.`value` <=> OLD.`value`) OR NOT(NEW.`percentage_value` <=> OLD.`percentage_value`) OR NOT(NEW.`website_id` <=> OLD.`website_id`)) THEN INSERT IGNORE INTO `scconnector_google_feed_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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 ;

--
