--
-- Host: localhost    Database: tique
-- ------------------------------------------------------


--
-- 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=4 DEFAULT CHARSET=utf8 COMMENT='Admin Passwords';

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

INSERT INTO `admin_passwords` VALUES (3,5,'21e1370ea08aa7726e78db4a22aec64c27763e3ebd305fbefb8369308445e4a4:GxOKcpDnOweLt2nj:2',0,1637232561);

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



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

INSERT INTO `admin_user` VALUES (5,'tique','tique','admin@tique.com','tique','21e1370ea08aa7726e78db4a22aec64c27763e3ebd305fbefb8369308445e4a4:GxOKcpDnOweLt2nj:2','2021-11-18 10:49:21','2022-01-24 10:33:03','2022-01-24 10:33:03',26,0,1,'{\"configState\":{\"customer_create_account\":\"1\",\"customer_account_information\":\"1\",\"customer_address_templates\":\"1\",\"customer_startup\":\"1\",\"customer_address\":\"1\",\"customer_account_share\":\"1\",\"customer_online_customers\":\"1\",\"wishusucess_signin_phone_number_module\":\"1\",\"wishusucess_signin_phone_number_options\":\"1\",\"faqtab_general\":\"1\",\"faqtab_design\":\"1\",\"faqtab_seo\":\"1\",\"faqtab_faq_info\":\"0\",\"mobileloginfree_general\":\"1\",\"webapi_webapisecurity\":\"1\",\"webapi_soap\":\"1\",\"payment_other_myfatoorah_gateway\":\"1\"}}',NULL,NULL,'en_US',0,NULL,NULL,NULL);

--
-- Table structure for table `admin_user_expiration`
--

CREATE TABLE `admin_user_expiration` (
  `user_id` int(10) unsigned NOT NULL COMMENT 'User ID',
  `expires_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'User Expiration Date',
  PRIMARY KEY (`user_id`),
  CONSTRAINT `ADMIN_USER_EXPIRATION_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Admin User expiration dates table';

--
-- Dumping data for table `admin_user_expiration`
--


--
-- 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=200 DEFAULT CHARSET=utf8 COMMENT='Admin User sessions table';

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

INSERT INTO `admin_user_session` VALUES (175,'5j058mk22tr6epipufld0r6293',5,1,'2021-11-18 10:49:35','2021-11-18 10:49:35','78.89.175.74'),(176,'mkts7u5t5dlu2elqr7t477aqg3',5,1,'2021-11-22 05:44:29','2021-11-22 05:44:29','78.89.175.74'),(177,'mcgdaotob5fvl626l1mbl6nmq5',5,1,'2021-11-22 07:44:19','2021-11-22 07:44:19','37.39.138.59'),(178,'4hqublsaeaq50kk4rhh5aahmoq',5,1,'2021-12-09 19:36:15','2021-12-09 19:51:56','188.71.193.124'),(179,'50kn1vk58vag19li6e5tvngtoa',5,1,'2021-12-09 20:56:11','2021-12-09 20:57:06','188.71.193.124'),(180,'svf1q7ale5cv21m3uce6eh2lvm',5,1,'2021-12-10 10:56:44','2021-12-10 11:12:53','188.71.208.209'),(181,'rs65aubetu9dv80lrvta3q9mph',5,1,'2021-12-10 12:22:58','2021-12-10 12:25:57','188.71.208.209'),(182,'u95ace1jk855ogn8luou5pgj3v',5,1,'2021-12-10 15:00:00','2021-12-10 15:02:46','94.128.81.0'),(183,'k23m6ltlh3vd8j5cbket324ngj',5,1,'2021-12-11 03:38:09','2021-12-11 03:55:03','94.128.81.0'),(184,'3dd0huqi5n8953sfrf0gu9c7db',5,1,'2021-12-11 10:00:39','2021-12-11 11:07:06','94.128.81.0'),(185,'nq9lq2sa13qfo6b5qoi6aphbnf',5,1,'2021-12-11 14:38:41','2021-12-11 14:42:00','94.128.81.0'),(186,'rjkefuse9qtjacqqra91d170cf',5,1,'2021-12-11 16:53:24','2021-12-11 16:55:00','94.128.81.0'),(187,'8vj6c9puek6ou1foa31bomlfi8',5,1,'2021-12-11 19:26:40','2021-12-11 20:08:02','94.128.81.0'),(188,'8t2jbjdi5mktialo6rs1sl49o2',5,1,'2021-12-12 07:28:03','2021-12-12 07:28:03','78.89.175.74'),(189,'csu6vq2n329js8bsl2glc8qs5g',5,1,'2021-12-12 17:57:36','2021-12-12 17:57:36','94.128.81.0'),(190,'l30ng5lu2ifohgevd15kt4v00i',5,1,'2021-12-12 18:58:56','2021-12-12 20:03:16','94.128.81.0'),(191,'ullsscvmclpkn88bo0708cdn4q',5,1,'2021-12-14 17:34:34','2021-12-14 18:33:04','94.128.81.0'),(192,'7kpc8j5avdmlmbmcg66bduepfg',5,1,'2021-12-14 19:54:50','2021-12-14 20:00:30','94.128.81.0'),(193,'cu2g2kehptp4u8ptgq50cf67kk',5,1,'2021-12-15 04:50:34','2021-12-15 04:50:34','78.89.175.74'),(194,'2125u7deve63598me7r0viec4b',5,1,'2022-01-04 10:51:34','2022-01-04 10:51:34','188.70.53.247'),(195,'fp9grle5oupktlrmme0cj4ilqs',5,1,'2022-01-04 10:53:21','2022-01-04 10:53:21','37.231.13.27'),(196,'2soq3b611e1af33tm6n1u2btdn',5,1,'2022-01-04 11:46:34','2022-01-04 11:55:26','168.187.74.170'),(197,'dfsr95n70elgdl9o1rd0bp4jn9',5,1,'2022-01-16 10:40:25','2022-01-16 10:40:25','168.187.74.170'),(198,'o4nqhfq9kjectponnahecjnkde',5,1,'2022-01-16 13:23:12','2022-01-16 13:26:08','168.187.74.170'),(199,'lk76nkk4su8scd4rkl0ql0ra2m',5,1,'2022-01-24 10:33:03','2022-01-24 10:33:03','168.187.74.170');

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

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

INSERT INTO `adminnotification_inbox` VALUES (1,1,'2016-05-17 05:43:59','Community Edition 2.0.6 Provides Important Security and Functional Updates – 5/18/2016','Magento Community Edition 2.0.6 is now available and contains important security and functional improvements. More information on the security updates can be found on the Magento Security Center at https://magento.com/security/patches/magento-206-security-update. More information on the functional enhancements is provided in the release notes: http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.6CE.html','https://magento.com/security/patches/magento-206-security-update',0,0),(2,4,'2016-01-12 18:52:11','Have questions? Magento has big answers at Imagine Commerce.','Big news, bigger experts, and an even bigger ecosystem. Will you be at Imagine Commerce? Join us. ','http://imagine.magento.com',0,0),(3,1,'2016-01-19 18:17:09','Important: Install Magento Community Edition 2.0.1 for Security & Functional Updates – 1/20/2016','Today, we are releasing Magento Community Edition 2.0.1 to improve the security and functionality of Magento 2.0 sites. There are no confirmed attacks related to the security issues, but certain vulnerabilities can potentially be exploited to access customer information or take over administrator sessions. Community Edition 2.0.1 also includes USPS API updates and support for PHP7.0.2, which enables dramatic performance improvements and other benefits. You can download the release from the Community Edition Download Page or by using Composer. Learn more at https://magento.com/security/patches/magento-201-security-update. \n','https://magento.com/security/patches/magento-201-security-update',0,0),(4,1,'2016-01-27 20:08:45','Important: Magento Community Edition 2.0.2 Addresses Upgrade Issues – January 28, 2016','Newly released Magento Community Edition 2.0.2 resolves issues encountered by some users when upgrading Magento Community Edition 2.0.0 and 2.0.1. The issues occur with products that were installed from a compressed archive (.tar.gz, .zip, and .bz2); merchants who used other installation options are not affected. More information is available in the Technical Bulletin at http://devdocs.magento.com/guides/v2.0/release-notes/tech_bull_201-upgrade.html. ','http://devdocs.magento.com/guides/v2.0/release-notes/tech_bull_201-upgrade.html',0,0),(5,1,'2016-03-29 20:24:35','Magento Community Edition 2.0.3 Includes Functional and Security Updates – 3/30/2016','Magento Community Edition 2.0.3 is now available and contains important security updates, as well as performance improvements and functional enhancements. Full details on the functional enhancements are included in the release notes at http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.3CE.html. More information on the security updates can be found on the Magento Security Center at https://magento.com/security/patches/magento-203-security-update.','https://magento.com/security/patches/magento-203-security-update',0,0),(6,1,'2016-03-31 02:40:23','New Release: Magento Community Edition 2.0.4 – 3/31/2016','We have released Magento Community Edition 2.0.4 to address a packaging issue with yesterday’s release. If you have already installed Enterprise Edition 2.0.3, you must replace it with the new version to ensure that your site receives all security enhancements. Learn more at https://magento.com/security/patches/magento-204-security-update','https://magento.com/security/patches/magento-204-security-update',0,0),(7,4,'2016-03-29 20:25:07','FAQ: How to configure \"read more\" 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.\nOnline 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',0,0),(8,4,'2016-05-21 21:41:58','Repo.magento.com is currently unavailable. We are working to resolve this issue as quickly as possible – 5/22/16, 11:40 am PT','Users currently cannot access Magento 2 code updates from Repo.magento.com. We are investigating the issue and will update you when it is resolved. As an alternative, you can still access Magento 2 code from GitHub (https://github.com/magento/magento2) or from the Community Edition download page (https://www.magentocommerce.com/download). ','https://github.com/magento/magento2',0,0),(9,4,'2016-05-22 02:12:08','Issue with repo.magento.com has been resolved - 5/22/16, 4 pm PT','The issue with repo.magento.com has been resolved. You should be able to access Magento 2 code updates at this time.','http://devdocs.magento.com/guides/v2.0/install-gde/prereq/integrator_install.html',0,0),(10,4,'2016-05-23 17:08:30','New release: Magento Community Edition 2.0.7 Resolves Payment Gateway Issues – 5/24/16 ','Magento Community Edition 2.0.7 is now available. It resolves payment gateway issues experienced when using PHP 7.0.3. Review the release notes for more information: http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.7CE.html.','http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.7CE.html',0,0),(11,4,'2016-06-06 00:44:09','New Community Edition 2.0.7 Patch (MDVA-449) for Merchants Using PHP 5.5.x – June 6, 2016 ','A new patch, MDVA-449, enables merchants using Community Edition 2.0.7 and PHP 5.5.x to upgrade to future releases. It corrects a line of code in the Setup application that is packaged with Community Edition 2.0.7 that is not compatible with PHP 5.5.x. Merchants using Community Edition 2.0.7 with PHP 5.6.x and 7.0.x DO NOT need this patch. Learn more at http://devdocs.magento.com/guides/v2.0/release-notes/tech_bull_207-upgrade.html ','http://devdocs.magento.com/guides/v2.0/release-notes/tech_bull_207-upgrade.html ',0,0),(12,4,'2016-06-22 01:29:31','New Community Edition 2.0.x Patch (MDVA-532) Enables Upgrades to Magento 2.1 – June 22, 2016','A new patch, MDVA-532, enables merchants using Magento Community Edition 2.0.x to upgrade to Magento 2.1 Community Edition Release Candidates or GA software. More information about the patch and important instructions for command-line upgrades to Magento 2.1 when sample data is installed are available in a technical bulletin posted at http://devdocs.magento.com/guides/v2.0/release-notes/tech_bull_21-upgrade.html.','http://devdocs.magento.com/guides/v2.0/release-notes/tech_bull_21-upgrade.html',0,0),(13,4,'2016-06-22 19:44:46','Increase your sales and productivity, while simplifying PCI compliance with exciting new Magento Community Edition 2.1 features.','Shoppers can now check out faster using credit cards stored with PayPal and a redesigned PayPal checkout. PCI compliance is easier thanks to Braintree Hosted Fields. Admin tools are redesigned to help you work more efficiently. Upgrade to Enterprise Edition for new Content Staging and Preview and Enhanced Site Search capabilities.','https://magento.com/blog/magento-news/magento-enterprise-edition-21-unleashes-power-marketers-and-merchandisers ',0,0),(14,4,'2016-07-21 21:56:40','Community Edition 2.0.8 improves installation, configurable product creation and more – 7/19/2016','Magento Community Edition 2.0.8 makes several functional improvements that address issues with application installation, duplication of url keys during configurable product creation, and other issues described in the release notes posted at http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.8CE.html.','http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.8CE.html',0,0),(15,4,'2016-08-10 01:27:44','Community Edition 2.0.9 Improves Performance and Product Quality ','Community Edition 2.0.9 is now available and improves storefront performance when a large number of configurable product variations are used and resolves issues with price and tax calculations, mini-cart displays and more. You can learn more in the release notes at http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.9CE.html ','http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.9CE.html',0,0),(16,4,'2016-08-29 19:36:54','Community Edition 2.1.1 Features Performance and Functional Improvements – 8/30/2016','Community Edition 2.1.1 improves storefront performance when using many configurable product variations and addresses upgrade and installation issues. You can learn more in the release notes at http://devdocs.magento.com/guides/v2.1/release-notes/ReleaseNotes2.1.1CE.html.','http://devdocs.magento.com/guides/v2.1/release-notes/ReleaseNotes2.1.1CE.html ',0,0),(17,1,'2016-10-11 23:27:35','Community Edition 2.0.10 and 2.1.2 Resolve Critical Security Issues – 10/12/2016','Magento Community Edition 2.0.10 and 2.1.2 resolve multiple security issues, including critical vulnerabilities with certain payment methods and Zend Framework libraries. The releases also make several functional improvements and API enhancements. Learn more about the security issues in the Magento Security Center at https://magento.com/security/patches/magento-2010-and-212-security-update and functional updates at http://devdocs.magento.com/guides/v2.1/release-notes/bk-release-notes.html.','https://magento.com/security/patches/magento-2010-and-212-security-update',0,0),(18,1,'2016-10-24 19:53:36','Dirty COW Linux OS Vulnerability – 10/25/2016','Dirty COW (CVE-2016-5195) is a serious vulnerability affecting most Linux Operating Systems that can be exploited to gain root access to the server. More information on how to immediately update your Linux OS is available in the Magento Security Center at https://magento.com/security/vulnerabilities/new-linux-operating-system-vulnerability. ','https://magento.com/security/vulnerabilities/new-linux-operating-system-vulnerability',0,0),(19,4,'2016-12-14 04:39:37','New Magento 2 Releases Feature Payment, Performance & Quality Enhancements – 12/14/2016','Community Editions 2.1.3 and 2.0.11 feature new payment functionality, accelerated performance, and enhanced product quality. Learn more in the release notes at 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',0,0),(20,4,'2016-12-15 16:16:21','Are you a Magento Developer? Take our developer experience survey by December 21.','As a Magento developer, your feedback is critical to the success of the Magento platform. We invite you to complete a survey about your experience developing on the Magento 2 platform. The results will help us improve our product and resources to enable your continued success. The survey should take no more than 10 minutes and all information you provide will remain strictly confidential. https://www.research.net/r/SL7VVNR','https://www.research.net/r/SL7VVNR',0,0),(21,1,'2017-01-13 12:33:07','New Zend Framework Security Vulnerability – 1/13/2017','We’ve found a new vulnerability in a Zend Framework 1 and 2 email component used by all Magento 1 and Magento 2 software (as well as other PHP solutions). This vulnerability is serious and can lead to a remote code execution attack if your servers use Sendmail as a mail transport agent. Learn how to protect your sites at https://magento.com/security/news/new-zend-framework-1-security-vulnerability\n\n','https://magento.com/security/news/new-zend-framework-1-security-vulnerability',0,0),(22,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',0,0),(23,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',0,0),(24,4,'2017-02-21 10: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',0,0),(25,4,'2017-02-17 14: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/',0,0),(26,4,'2017-04-11 09: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',0,0),(27,1,'2017-06-21 09: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 ',0,0),(28,4,'2017-08-09 10: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',0,0),(29,4,'2017-08-18 07:41:03','Join the Magento BI Essentials Webinar: Make Data Easy ','Join our webinar on Tuesday, August 22nd and learn about why merchants like you are choosing Magento BI  Essentials to make it easier to harness the power of your data. \n\nBob Moore, Head of Magento BI, will be discussing the value of the reporting and dashboards that comes out-of-the-box with Essentials and the insights you can gain from them. \n\nRegister today. \n\nhttps://magento.com/resources/magento-bi-essentials-making-data-easy?lsdet=MBI-Webinar-RSS\n','https://magento.com/resources/magento-bi-essentials-making-data-easy?lsdet=MBI-Webinar-RSS',0,0),(30,2,'2017-09-11 15: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 ',0,0),(31,1,'2017-09-14 16: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',0,0),(32,4,'2017-09-26 15: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 ',0,0),(33,1,'2017-11-07 17: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',0,0),(34,4,'2017-12-12 13:00:41','Magento Open Source 2.2.2 Accelerates Growth with Instant Purchase Checkout, Integrated Email Marketing Automation, Advanced Reporting, and More – 12/12/2017','Our newest release of Magento Open Source equips merchants with powerful tools to accelerate growth and improve operational efficiency. It boosts conversion rates with a streamlined Instant Purchase checkout, jump-starts sales with integrated dotmailer email marketing automation, delivers actionable insights through Advanced Reporting, and provides integrated multi-carrier shipping and fulfillment capabilities with Magento Shipping. https://magento.com/blog/magento-news/new-instant-purchase-checkout-boosts-sales ','https://magento.com/blog/magento-news/new-instant-purchase-checkout-boosts-sales ',0,0),(35,4,'2017-12-17 16:53:44','Survey: Do you use site personalization and optimization tools? If yes, we\'d to hear from you!','We\'d like to invite you to take our online survey on site personalization and optimization tools. Your input is valuable and will help to inform the products we bring to market.\n\nThe survey should take no more than 5 minutes to complete. \n\nTo get started, go to: \nhttps://www.surveymonkey.com/r/NF9ZH8D\n\nThank you in advance for your participation.','https://www.surveymonkey.com/r/NF9ZH8D',0,0),(36,4,'2017-12-20 03:55:28','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.\nOnline 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',0,0),(37,4,'2018-02-07 04:34:34','Are you a Magento Developer? Please participate in our developer survey. ','As a Magento developer, your feedback is critical to the success of the Magento platform. We invite you to complete a survey about your experience developing on the Magento 2 platform. The results will help us improve our product and services to enable your continued success. The survey should take no more than 5-7 minutes to complete and the information you provide will remain strictly confidential. \n\nThanks in advance for your participation. \n\nhttps://www.surveymonkey.com/r/X3KHNV3\n','https://www.surveymonkey.com/r/X3KHNV3',0,0),(38,4,'2018-02-07 06:56:41','New Magento Security Scan Tool is available!','Magento has rolled out a new security scan tool that enables you to regularly monitor your sites and receive updates regarding known security risks, malware, and unauthorized access. Our  goal is to assist in ensuring the on-going security of your Magento sites. \n\nSecurity Scan is a free service of Magento, and provides over 30 security tests to identify potential vulnerabilities, such as missing Magento patches, configuration issues, and failure to follow security best practices. In addition, you\'ll receive real-time security status of your Magento sites and how to fix potential vulnerabilities.\n\nYou and your team, including authorized developers, can access the new tool directly within your Magento Account. And it is very easy to set up. \n\nTo learn more about the Security Scan Tool, \nlog into your Magento Account at https://account.magento.com/customer/account/.\n\nMy Account &gt; Security Scan','https://account.magento.com/customer/account/',0,0),(39,3,'2018-02-22 21:28:14','New version 2.7.1 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                https://magefan.com/magento2-blog-extension?version=2.7.1\n             ','https://magefan.com/magento2-blog-extension?version=2.7.1',0,0),(40,1,'2018-04-10 03:44:24','Attention! You use an ancient version of Blog Extension. It is strongly recommended to update Blog Extension to the newest version 2.8.0',' \n                                https://magefan.com/magento2-blog-extension?ancient=2.6.0                             ','https://magefan.com/magento2-blog-extension?ancient=2.6.0',0,0),(41,4,'2018-04-18 16:49:05','We want your opinion! Take our Digital Ad Tools survey.','We\'d like to invite you to take our online survey on digital advertising tools. Your input is valuable to us and will help to inform future products.\n\nThe survey should take no more than 5 minutes to complete. \n\nTo get started, go to: \n\nhttps://www.surveymonkey.com/r/9QQLV67\n\nThank you in advance for your participation.','https://www.surveymonkey.com/r/9QQLV67',0,0),(42,4,'2018-05-02 21:07:10','Magento Open Source 2.2.4 Enables Better Shopping Experiences with Integrated Payment, Tax, and Shipping Solutions – 5/2/2018','The latest release of Magento Open Source empowers merchants to create better shopping experiences with performance enhancements and integrations with Amazon Pay, Klarna, and Vertex. Learn how these features can help you reduce cart abandonment and increase average order value, while simplifying your operations at https://magento.com/blog/magento-news/create-better-shopping-experiences-magento-commerce','https://magento.com/blog/magento-news/create-better-shopping-experiences-magento-commerce',0,0),(43,3,'2018-05-03 01:43:22','New version 2.8.0 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                https://magefan.com/magento2-blog-extension?version=2.8.0\n                             ','https://magefan.com/magento2-blog-extension?version=2.8.0',0,0),(44,1,'2018-02-27 19:45:24','Magento Open Source 2.2.3, 2.1.12, and 2.0.18 Enhance Security and Functionality – 2/27/2018','Magento Open Source 2.2.3, 2.1.12, and 2.0.18 include critical security enhancements and feature updates, including support for recent USPS API changes. Review the release notes for more information: http://devdocs.magento.com/guides/v2.2/release-notes/ReleaseNotes2.2.3CE.html, http://devdocs.magento.com/guides/v2.1/release-notes/ReleaseNotes2.1.12CE.html, http://devdocs.magento.com/guides/v2.0/release-notes/ReleaseNotes2.0.18CE.html  \n','http://devdocs.magento.com/guides/v2.2/release-notes/ReleaseNotes2.2.3CE.html',0,0),(45,1,'2018-04-09 05:04:15','Take Steps to Protect Your Site ','Our goal is to help you deliver the highest level of security to your Magento site. \n\nYou now have access to a security scan tool that enables you to regularly monitor your sites and receive updates regarding known security risks, malware, and unauthorized access. It provides over 30 security tests to identify potential vulnerabilities, such as missing Magento patches, configuration issues, and failure to follow security best practices. Please be sure to set your site up for security scanning – activation is quick and easy. Access today in your Magento account.\n\nYou should also visit our Security Center which provides alerts around potential issues as well as best practices to help you protect your site against issues, such as brute force attacks. Brute-force password guessing attacks continue to target Magento Open Source (formerly Community Edition) sites worldwide and we have published an  article that explains multiple actions you can take to protect your site from such attacks. In some cases, these attacks have resulted in unauthorized administrative access, so it is important to implement these recommendations.\n\nTo visit the Magento Security Center:\nwww.magento.com/security\n\nTo view steps you can take to protect against issues like brute force, go to:\nwww.magento.com/security/best-practices/5-immediate-actions-protect-against-brute-force-attacks','https://magento.com/security/best-practices/5-immediate-actions-protect-against-brute-force-attacks',0,0),(46,1,'2018-06-27 18:45:34','Magento Open Source 2.2.5 delivers important security updates along with performance and functionality enhancements – 6/27/2018','The latest release of Magento Open Source includes important security enhancements along with performance and functionality improvements. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements. For more information about security updates included in these versions of Magento please see our Security Center: https://magento.com/security/patches/magento-2.2.5-and-2.1.14-security-update','https://devdocs.magento.com/guides/v2.2/release-notes/bk-release-notes.html',0,0),(47,4,'2018-07-17 00:00:20','Survey: Help us improve the Admin Panel usability by taking this 5 minute survey.','We\'d like to invite you to take our online survey on Admin Panel Usability. Your input is valuable to us and will help to inform the user experience direction. The survey should take no more than 5 minutes to complete.\n \nTo get started, go to:\nhttps://www.surveymonkey.com/r/SUS-AdHoc-M2','https://www.surveymonkey.com/r/SUS-AdHoc-M2',0,0),(48,3,'2018-08-02 06:55:59','New version 2.8.1 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                https://magefan.com/magento2-blog-extension?version=2.8.1\n                             ','https://magefan.com/magento2-blog-extension?version=2.8.1',0,0),(49,1,'2018-09-18 23:21:46','Magento Open Source 2.2.6 delivers important security updates along with performance and functionality enhancements – 9/18/2018','The latest release of Magento Open Source includes important security enhancements along with performance and functionality improvements. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements. For more information about security updates included in these versions of Magento please see our Security Center: https://magento.com/security/patches/magento-2.2.6-and-2.1.15-security-update','https://devdocs.magento.com/guides/v2.2/release-notes/bk-release-notes.html',0,0),(50,3,'2018-10-08 17:19:46','New version 2.8.2 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                https://magefan.com/magento2-blog-extension?version=2.8.2\n                             ','https://magefan.com/magento2-blog-extension?version=2.8.2',0,0),(51,4,'2019-01-06 11:12:13','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.','',0,0),(52,1,'2019-03-01 20:19:18','Action required: Update Authorize.Net Direct Post from MD5 to SHA-512 – 3/1/2019','Magento\'s implementation of the Authorize.Net Direct Post payment method uses MD5 based hash, and on March 14, 2019 Authorize.net will stop supporting MD5 based hash usage. This will result in Magento merchants not being able to process payments using Authorize.Net Direct Post. To avoid disruption and to continue processing payments, merchants need to apply a patch provided by Magento and add a Signature Key (SHA-512) in the Magento Admin configuration settings. For information on applying this patch please see the Magento Help Center.\n\nhttps://support.magento.com/hc/en-us/articles/360024368392','https://support.magento.com/hc/en-us/articles/360024368392',0,0),(53,4,'2019-03-20 03:53:15','Is it time to take your Magento Open Source commerce to the next level? ','We’re here to help! Magento Commerce Cloud gives you access to Page Builder, a powerful drag-and-drop content creation and editing tool that allows you to quickly design, test and launch new content with no coding or developer support required. Check it out with a free demo today.  http://bit.ly/2HwGsBs ','http://bit.ly/2HwGsBs',0,0),(54,1,'2019-03-26 18:05:01','Magento Open Source 2.3.1 delivers Powerful New Merchant and Developer Experience Enhancements – 3/26/2019','The latest release of Magento Open Source empowers merchants to act more quickly, operate more efficiently, and scale their businesses. Magento 2.3.1 also delivers important security enhancements and performance improvements. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements.','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',0,0),(55,4,'2019-05-10 21:29:49','Magento Shipping easily connects you with global shipping carriers ','Provide the shipping and pickup options required to compete. Meet customer expectations, drive conversion, increase revenue, and lower abandonment. Learn more: http://bit.ly/2DtWitd','http://bit.ly/2DtWitd',0,0),(56,4,'2019-05-13 17:49:35','New Google Shopping Ads Channel Extension Available','Connect with a new, powerful Magento-developed extension for Open Source 2.2.4+ users via the Magento Marketplace: Google Shopping Ads Channel! With Google Shopping Ads Channel you can connect your Magento store with Google Merchant Center and Google Ads seamlessly; and run Smart Shopping campaigns to cost-effectively reach and convert more shoppers. Download the extension for free. ','http://marketplace.magento.com/magento-google-shopping-ads.html',0,0),(57,4,'2019-05-20 17:12:35','Seamlessly add intelligent, global shipping to your Magento store ','Provide the shipping and pickup options required to compete. Meet customer expectations, drive conversion, increase revenue, and lower abandonment. Learn more: http://bit.ly/2DtWitd','http://bit.ly/2DtWitd',0,0),(58,4,'2019-05-22 18:55:29','New Amazon Sales Channel Extension Available','Connect with a new, powerful Magento-developed extension for Open Source 2.2.4+ users via the Magento Marketplace: Amazon Sales Channel! Merchants around the world can use this extension to sell their products to millions of shoppers on the U.S., Canada, and Mexico Amazon marketplaces. The extension allows for seamless integration of your product catalog, inventory, and order information with Amazon. Download the extension for free. ','http://marketplace.magento.com/magento-module-amazon.html',0,0),(59,3,'2019-05-29 06:14:00','New version 2.8.9 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                https://magefan.com/magento2-blog-extension?version=2.8.9\n                             ','https://magefan.com/magento2-blog-extension?version=2.8.9',0,0),(60,3,'2019-05-30 09:12:20','New version 2.8.10 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                https://magefan.com/magento2-blog-extension?version=2.8.10\n                             ','https://magefan.com/magento2-blog-extension?version=2.8.10',0,0),(61,4,'2019-06-03 19:54:35','Drive cart conversion and revenue with Magento Shipping','Provide the shipping and pickup options required to compete. Meet customer expectations, drive conversion, increase revenue, and lower abandonment. Learn more: http://bit.ly/2DtWitd','http://bit.ly/2DtWitd',0,0),(62,1,'2019-06-25 16:09:17','Important Security and Performance Updates Released in Magento 2.3.2','The latest releases of Magento include important security enhancements along with performance and productivity improvements. We strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements and information on security updates included in these versions of Magento at our Security Center: https://magento.com/security/','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',0,0),(63,4,'2019-07-16 15:39:08','Webinar: Power Your Marketing in Magento with Google Shopping ads Channel','Join us on Wednesday, July 31, 2019 to discover how to reach more customers and improve ROI while simplifying your Google advertising operations – all from the Magento admin – with Google Shopping ads Channel. During this 45-minute webinar you’ll learn how you can seamlessly connect your Magento store with Google Merchant Center (GMC) and Google Ads, sync your product catalog and inventory with GMC so you never have to worry about advertising out-of-stock products or inaccurate pricing, and get the most out of your Smart Shopping campaigns with our campaign’s best practices. Two convenient webinar times – 8:00am PDT and 5:00pm PDT. Register today!','https://magento.com/resources/power-your-marketing-in-magento-google-shopping-ads-channel',0,0),(64,3,'2019-08-05 04:17:46','New version 2.9.0 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                https://magefan.com/magento2-blog-extension?version=2.9.0\n                             ','https://magefan.com/magento2-blog-extension?version=2.9.0',0,0),(65,1,'2019-08-08 13:28:15','PSD2 Compliance Deadline: 09/14/2019','On September 14, the new Payment Services Directive (PSD2) will go into effect for all merchants who sell to customers in the EU. For information on compliance, PSD2 Authentication Standards, and actions that need to be taken prior to the deadline, please see the Magento DevBlog. https://community.magento.com/t5/Magento-DevBlog/3D-Secure-2-0-changes/ba-p/136460','https://community.magento.com/t5/Magento-DevBlog/3D-Secure-2-0-changes/ba-p/136460',0,0),(66,4,'2019-08-27 14:06:49','Breaking news! Adobe (Magento) is recognized by Gartner as a Leader based on Magento Commerce in the 2019 Magic Quadrant for Digital Commerce. ','Learn why Magento Commerce is a Leader for a third year in a row and continues to move because of our ability to execute. Read the full report: http://bit.ly/2Zj3CVs','http://bit.ly/2Zj3CVs',0,0),(67,4,'2019-10-01 16:15:34','It’s time to take your operations in a new direction by diversifying your revenue streams. ','We’ve got five ways you can effortlessly boost sales while reaching a wider audience. Download this informative guide and start fast-tracking your revenue growth today. Link: http://bit.ly/2m6svAN','http://bit.ly/2m6svAN',0,0),(68,4,'2019-10-08 18:50:49','It’s time to get your digital business out of the slow lane. ','Accelerate your revenue growth and drive customer satisfaction with these 5 must-have eCommerce features. Download this informative guide: http://bit.ly/2lLFOX6','http://bit.ly/2lLFOX6',0,0),(69,1,'2019-10-09 19:59:13','Magento Open Source 2.3.3 delivers important security updates along with performance and functionality enhancements – 10/9/2019 ','The latest release of Magento Open Source 2.3.3, Magento Open Source 2.2.10 and our new security-only patch 2.3.2-p2 are now available. Magento Open Source 2.3.3 includes important security enhancements along with new features, improved performance, and quality. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements. For more information about security updates included in these versions of Magento please see our Security Center: https://magento.com/security/','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',0,0),(70,1,'2019-10-14 15:58:01','Important hotfix for Magento Open Source 2.3.3','A hotfix for Magento Open Source 2.3.3 has been published to address an issue related to Elasticsearch that may present itself during or after upgrading to our latest 2.3.3 release. We strongly recommend that everyone upgrading to 2.3.3, download and apply this hotfix prior to deployment. For more information please visit our release notes. https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html ','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',0,0),(71,4,'2019-10-23 12:49:48','eBook: Advanced Strategies for Fast-Tracking Revenue Growth','Take your business in a new direction by selling more to a larger audience. Our guide explains 5 ways you can quickly add new revenue streams to your business. Link here: http://bit.ly/2m6svAN','http://bit.ly/2m6svAN',0,0),(72,3,'2019-11-02 07:31:49','New version 2.9.1 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                https://magefan.com/magento2-blog-extension?version=2.9.1\n                             ','https://magefan.com/magento2-blog-extension?version=2.9.1',0,0),(73,4,'2019-11-02 07:31:49','NEW Magento 2 Alternate Hreflang Tags Extension with Better Store Switcher\n',' Do you manage Magento multi-language store without using Hreflang tags? You should definitely enable them. ','https://magefan.com/magento2-alternate-hreflang-extension',0,0),(74,4,'2019-12-02 15:09:11','2020: The Year You Reimagine Your Mobile Platform','Smarter, faster mobile shopping experiences are now achievable with Progressive Web App technology. Forrester reveals how to leverage this next-generation technology, now available on Magento Commerce 2. Reimagine your mobile environment with this exclusive report.  Link here: http://bit.ly/2W5r4zg','http://bit.ly/2W5r4zg ',0,0),(75,4,'2019-12-09 18:08:56','Online B2B purchases are set to skyrocket to $9 trillion in the US alone this year. Get in on the action with B2B and B2C selling.','The lines between B2B and B2C commerce are blurring. Here’s 5 reasons to go hybrid with your commerce strategy in 2020. http://bit.ly/2DPgAx0','http://bit.ly/2DPgAx0',0,0),(76,4,'2019-12-16 18:39:06','Did you know? A whopping 89% of B2B businesses now rely on digital content to guide their purchasing process.','Learn how you can integrate compelling content into your B2B sales strategy with our latest eBook. Download Now: http://bit.ly/368QIbu','http://bit.ly/368QIbu',0,0),(77,4,'2020-01-02 18:26:08','Are you set up to achieve your eCommerce goals? Make upgrading your resolution for 2020.','Upgrading to Magento Commerce might cost less than you think. Watch our webinar to learn the true cost savings of upgrading to Magento Commerce 2. Watch Now: http://bit.ly/2BcYK5A','http://bit.ly/2BcYK5A',0,0),(78,4,'2020-01-13 18:02:52','eCommerce is an ocean of opportunity. Take our quiz and find out if you are a pilot fish, octopus, or shark.','Find out if you’re ready to sell with the big fish by taking our brief quiz designed to identify your competitive selling potential. Answer our set of quick questions to see where you stack up and receive personalized resources to give your digital growth strategy some teeth. http://bit.ly/2NkNvhS','http://bit.ly/2NkNvhS',0,0),(79,4,'2020-01-21 17:05:32','2020 goal: Is your product content keeping up with your customers?','Magento Page Builder gives you fast content updates and even faster growth. Download our eBook to learn more. Link here: http://bit.ly/2NyTuQf','http://bit.ly/2NyTuQf',0,0),(80,4,'2020-01-27 16:01:40','Learn The 6 Sweet Features Behind Every Irresistible eCommerce Experience. ','92% percent of online shoppers call it quits before checkout over poor site performance. Discover the six essential features your commerce platform needs to create truly memorable customer moments. Link here: http://bit.ly/2RrcS4d\n','http://bit.ly/2RrcS4d',0,0),(81,1,'2020-01-28 20:09:22','Magento Open Source 2.3.4 delivers important security updates and features to help you build a more engaging customer experience – 1/28/2020','The latest releases of Magento Open Source – 2.3.4, 2.3.3-p1, and 2.2.11 – are now generally available. The latest release of Magento Open Source includes important security enhancements along with new functionality and platform quality improvements. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements. Learn how this release can help you build a more engaging customer experience at Magento.com/blog.','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',0,0),(82,3,'2020-01-31 10:47:55','New version 2.9.2 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.9.2\n                                 ','https://magefan.com/magento2-blog-extension?version=2.9.2',0,0),(83,4,'2020-01-31 10:47:55','NEW  Magento 2 CMS Display Rules Extension.','Magento 2 CMS Display Rules is the extension for Magento 2 stores that allows online merchants to manage the display of CMS Pages and CMS Block for different customer groups, on different dates, days of the week, the exact time during the day and even conditions based on product attributes and shopping cart items and total.','https://magefan.com/magento-2-cms-display-rules-extension?from=ntf-new',0,0),(84,4,'2020-03-16 07:28:06','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),(85,4,'2020-02-03 19:53:41','You are invited: Seize the New Year– 5 Growth Strategies for 2020.','Join us for a live webinar on February 13th with Magento experts Shannon Hane and Matthew Wasley from Adobe to learn the latest eCommerce strategies to accelerate revenue growth in 2020. Register today: http://bit.ly/2GPpb4b','http://bit.ly/2GPpb4b',0,0),(86,4,'2020-02-10 16:41:26','Are you putting off integrating your ERP and eCommerce?','Get started on the journey to a more integrated and profitable eCommerce business. Download our comprehensive guide, eCommerce + ERP: Better Together. http://bit.ly/33XMHVV','http://bit.ly/33XMHVV',0,0),(87,4,'2020-02-12 15:11:23','Join Tomorrow&#039;s Webinar: Seize the New Year– 5 Growth Strategies for 2020.','Join us for a live webinar tomorrow, February 13th with Magento experts Shannon Hane and Matthew Wasley from Adobe to learn the latest eCommerce strategies to accelerate revenue growth in 2020. Register today: http://bit.ly/2GPpb4b','http://bit.ly/2GPpb4b',0,0),(88,1,'2020-03-05 21:25:23','Retrieving data. Wait a few seconds and try to cut or copy again.','&quot;We have discovered an error in Magento 2.3.4 that can prevent a shopper from completing an order when using PayPal Express Checkout. The issue occurs for any country where the region field in the address section is a text field (as opposed to a drop-down menu).\nWe have released a hotfix to resolve this issue and recommend that merchants on Magento version 2.3.4 who are also using PayPal Express Checkout download and apply this hotfix as soon as possible to prevent further errors. Please refer to our help center for instructions and troubleshooting. A fix for this issue will be included in Magento 2.3.5.','https://support.magento.com/hc/en-us/articles/360039451972',0,0),(89,3,'2020-03-16 08:36:31','New version 2.9.3 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.9.3\n                                 ','https://magefan.com/magento2-blog-extension?version=2.9.3',0,0),(90,4,'2020-03-20 15:03:20','Simplify and accelerate your content updates with Page Builder','Content is critical to eCommerce engagement. In fact, 87 percent of shoppers say product content has a high impact on their purchasing decisions. Page Builder delivers a drag-and-drop content creation and management tool which simplifies your website updates from start to finish. Learn how this powerful creative tool can grow your business. Link here: http://bit.ly/2NyTuQf','http://bit.ly/2NyTuQf',0,0),(91,1,'2020-03-24 16:02:43','Important Hot Fix Available for Magento Commerce 2.3','A new Hot Fix is available to close a security issue in Magento Open Source 2.3, all versions. We recommend that users of potentially affected deployments take immediate action by updating your Magento installation with the latest patch. Please review our Security Blog via the included link for more information about the bug and how to apply the Hot Fix.','https://magento.com/security/hot-fix-available-cve-2019-8118',0,0),(92,4,'2020-04-08 16:41:38','Watch On-Demand Webinar: Seize the New Year– 5 Growth Strategies for 2020.','Magento experts Shannon Hane and Matthew Wasley from Adobe will share the latest eCommerce strategies to accelerate revenue growth in 2020. Watch now: http://bit.ly/2GPpb4b','http://bit.ly/2GPpb4b',0,0),(93,4,'2020-04-10 17:14:30','Watch On-On Demand: The True Cost Savings of Magento Commerce 2.','Join us for The True Cost Savings of Magento Commerce 2 webinar on April 23rd. John Glasgow and Matt Boland from Adobe will discuss how your business can reduce operating costs and grow revenue. Leading solution partner Atwix will also share how they are helping customers launch innovative solutions to meet expectations in today’s environment. Register Now: https://bit.ly/2JRgJCX','https://bit.ly/2JRgJCX',0,0),(94,4,'2020-04-14 22:03:09','Upgrade to Magento Commerce with no payments for the first 3 months. ','Adobe is committed to supporting merchants during this challenging time. Upgrade to Magento Commerce 2 quickly and affordably with limited time offers. Pay nothing for the first 3 months, and our Magento Commerce launch package will get you up and running fast. Free Magento U classes will ensure your teams are fully equipped to take their digital operations to the next level. Learn more: https://bit.ly/2RBnk8M','https://bit.ly/2RBnk8M',0,0),(95,1,'2020-04-28 18:29:06','Magento Open Source 2.3.5-p1 delivers important security updates and features ','The latest releases of Magento Open Source – 2.3.5-p1 and 2.3.4-p2 – are now generally available. The latest release of Magento Open Source includes important security enhancements along with new functionality and platform quality improvements. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements. Learn how this release can help you save time and maximize resources at Magento.com/blog. ','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html',0,0),(96,4,'2020-05-04 18:02:10','One Platform to Rule them All','The lines between B2B and B2C commerce are blurring. B2C companies are adding wholesale storefronts while their traditionally B2B counterparts are increasingly selling direct to consumers.','http://bit.ly/2DPgAx0',0,0),(97,4,'2020-05-11 23:43:35','5 Ways You Can Deliver Commerce to Your Customers','Now more than ever, eCommerce is helping individuals and communities satisfy their most essential needs. Discover the 5 ways brands are bringing commerce to their customers in our eGuide, The New Everywhere (and Every Device) Commerce. Learn more: https://bit.ly/2YIrL6l','https://bit.ly/2YIrL6l',0,0),(98,4,'2020-07-03 02:21:59','NEW Magento 2 Multi-Blog Extension ',' Magento 2 Multi Blog extension is the extension that allows you to have 2 separate blogs on your Magento 2 store and manage them from one admin panel. This extension could be useful for those who already use Magento 2 Blog and want to improve their store with the second blog. ','https://magefan.com/magento-2-multi-blog-extension',0,0),(99,4,'2020-05-19 23:51:00','Watch our live webinar on-demand: Fast-Track Your Move to Magento Commerce.','Watch our on-demand webinar: Fast-Track Your Move to Magento Commerce. 5x Magento Master, Brent Peterson, will share insider advice on getting your new Magento Commerce site to market in 30 days or less. Also, Tricia Lee from Adobe will cover limited-time offers designed to help merchants upgrade quickly and affordably. View now: https://bit.ly/2L1lxpW','https://bit.ly/2L1lxpW',0,0),(100,4,'2020-06-08 16:43:12','Find out why Forrester positioned Adobe as a Leader in their latest B2B commerce report.','Read why Adobe was named a Leader in the “Forrester Wave: B2B Commerce Suites, Q2 2020,” and discover how we can support your business with our global partner ecosystem. https://bit.ly/2z845hk','https://bit.ly/2z845hk',0,0),(101,4,'2020-06-11 18:19:15','Ask us your questions during our upcoming webinar, The True Cost Savings of Magento Commerce 2.','Join us on Tuesday, June 23rd, for a new session of The True Cost Savings of Magento Commerce 2 now with extended time for live Q&amp;A. John Glasgow from Adobe will share how your business can reduce operating costs and grow revenue. And Slava Kravchuk from Atwix, # 1 Contributing Partner, will share a customer case study leading the way in innovative B2B retail experiences. Register Now: https://bit.ly/3dLYlsN','https://bit.ly/3dLYlsN',0,0),(102,4,'2020-06-16 19:19:54','Your input requested: Shipping &amp; Fulfillment','We would like to get your feedback on how you think about and manage your shipping &amp; fulfillment so we can build great features for you! http://selfserve.decipherinc.com/survey/selfserve/9d5/200603','http://selfserve.decipherinc.com/survey/selfserve/9d5/200603',0,0),(103,4,'2020-06-25 21:45:31','We’re proud to be recognized as Leader in B2C commerce by Forrester in their latest report. ','Read the latest “Forrester Wave: B2C Commerce Suites, Q2 2020” report to learn why “Adobe leads with flexibility, supported by a strong global partner ecosystem.” https://bit.ly/370vz4V','https://bit.ly/370vz4V',0,0),(104,4,'2020-06-26 17:15:35','Embrace digital change with insights from eCommerce leaders at Adobe Experience Maker&#039;s Live July 22-23.','Take part in 40+ diverse sessions at Experience Makers Live July 22-23, with topics including Magento Commerce product roadmap, delivered by John Stockton, Sr. Director of Product Marketing at Adobe, customer case studies highlighting real-world applications of Magento Commerce features and functionality, and how Magento Commerce is helping merchants adapt to the challenges of a new digital reality. Register today! https://adobe.ly/3i7XGnK','https://adobe.ly/3i7XGnK',0,0),(105,4,'2020-07-10 00:56:40','Is Your Website Selling as Much as It Can? Take our commerce self-assessment and uncover opportunities to improve conversion rates.','An engaging user experience is essential to converting casual visitors into loyal customers. Find out if your eCommerce environment inspires long-term loyalty with our commerce self-assessment which asks, Is Your Website Selling as Much as It Can? Download now: https://bit.ly/3gt16Qk','https://bit.ly/3gt16Qk',0,0),(106,3,'2020-07-15 10:34:48','New version 2.9.5 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.9.5\n                                 ','https://magefan.com/magento2-blog-extension?version=2.9.5',0,0),(107,4,'2020-07-21 15:55:36','Meet the Magento Commerce Interactive Product Experience.','Meet the world’s most flexible eCommerce platform by immersing yourself in the Magento Commerce Interactive Product Experience. This interactive simulation demonstrates the powerful functionality helping merchants sustain – and grow – their business. Start Product Tour: https://adobe.ly/3eR7kZ3','https://adobe.ly/3eR7kZ3',0,0),(108,4,'2020-07-28 16:12:12','Tell us about your experience with Magento','We want to hear from you! Please take a short survey about your experience using Magento Admin. Your feedback will help us improve our products and develop new features.  http://selfserve.decipherinc.com/survey/selfserve/9d5/200508?list=1','http://selfserve.decipherinc.com/survey/selfserve/9d5/200508?list=1',0,0),(109,1,'2020-07-28 16:17:11','Magento Open Source 2.4 delivers important security updates and features to accelerate your business in the changing commerce landscape – 7/28/2020','The latest releases of Magento Open Source – 2.4 and 2.3.5-p2 – are now available. The latest release of Magento Open Source includes important security enhancements along with new functionality and platform quality improvements. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the enhancements. Learn how this release can help you adapt to the changing commerce landscape at Magento.com/blog.','https://devdocs.magento.com/guides/v2.4/release-notes/bk-release-notes.html',0,0),(110,4,'2020-07-31 16:37:31','Is Your Website Selling as Much as It Can? Join our upcoming webinar and learn how to turn your website into a conversion machine.','Join us on August 13 for our webinar: Is Your Website Selling As Much As It Can? Digital Strategist Ereika Stimley and eCommerce Consultant Corey Gelato will walk you through a website self-assessment and live demo that will help you uncover opportunities to increase conversions and grow revenues. Register now: https://bit.ly/2PcjcL3','https://bit.ly/2PcjcL3',0,0),(111,4,'2020-08-07 20:57:02','The Essentials of an Unforgettable Customer Experience','Learning what’s shaping tomorrow’s shopping experiences is essential for growth. Download our eBook full of advice about crafting a better buying journey using Magento Commerce and other key technologies. Download now: https://bit.ly/31tNXkq','https://bit.ly/31tNXkq',0,0),(112,4,'2020-08-24 17:19:20','We would love your input on Magento Payments','We value the perspective of our users and we would appreciate if you took this short survey on Magento Payments. Your response will influence the design of the next generation Magento Payments solution. https://bit.ly/2CXZro2','https://bit.ly/2CXZro2',0,0),(113,3,'2020-09-14 02:19:34','New version 2.9.6 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.9.6\n                                 ','https://magefan.com/magento2-blog-extension?version=2.9.6',0,0),(114,4,'2020-09-14 13:33:10','Get real-time insights into the security status of the store​ with Enhanced Security Scan Tool.','The Enhanced Magento Security Scan Tool provides our on-prem and cloud merchants with real-time insights into the security status of their store by proactively notifying them if their store is vulnerable. ','https://account.magento.com/scanner ',0,0),(115,4,'2020-09-14 13:37:29','Now Available: Magento Quality Patch (MQP) tool to identify and resolve issues more quickly','The introduction of the MQP tool provides a way for you to know which quality patches are available for you installed version and apply or revert them giving you self-service access to resolve issues more quickly.','https://support.magento.com/hc/en-us/articles/360047139492-Magento-Quality-Patches-released-a-new-tool-to-self-serve-quality-patches',0,0),(116,4,'2020-09-16 18:03:56','Free 25-Point Website Evaluation for Magento Open Source Users','​Reach out to us today to get your free 25-point site assessment to identify top conversion drivers and turn your website into a conversion machine.​ Our team of experts will evaluate your site and identify specific areas for conversion improvements. https://bit.ly/3lcgILt','https://bit.ly/3lcgILt',0,0),(117,4,'2020-09-21 17:18:39','New resource updates to the Open Source page on Magento.com. ','Check out the updated Open Source page on Magento.com. Learn how to maximize your Open Source store, discover offers for Open Source merchants, and view comparison charts between Open Source and Magento Commerce. Go to page: https://adobe.ly/3kCB5jW','https://adobe.ly/3kCB5jW',0,0),(118,4,'2020-09-25 01:48:09','Don&#039;t miss Adobe Developer&#039;s Live: Commerce which brings together developers and experience builders in a one-day free conference on Monday, Sept 28th. ','The one-day free conference will feature important Magento developer updates, technical sessions and community networking opportunities. Adobe product teams across Adobe Experience Cloud will showcase the latest tech advances and developer tools powering customer experience management across industries. Register now: https://bit.ly/3hYzbrX','https://bit.ly/3hYzbrX',0,0),(119,4,'2020-08-11 16:54:10','Turn your website into a conversion machine. ','Join us on Aug 13 for our webinar: Is Your Website Selling As Much As It Can? Adobe Digital Strategist Ereika Stimley and eCommerce Consultant Corey Gelato will walk you through a website self-assessment and live demo that will help you uncover opportunities to increase conversions and grow revenues. Register now: https://bit.ly/2PcjcL3','https://bit.ly/2PcjcL3',0,0),(120,4,'2020-09-28 22:07:26','Is Your Website Selling as Much as It Can? Watch our on-demand webinar and learn how to turn your website into a conversion machine.','Watch our on-demand webinar: Is Your Website Selling As Much As It Can? Digital Strategist Ereika Stimley and eCommerce Consultant Corey Gelato will walk you through a website self-assessment and live demo that will help you uncover opportunities to increase conversions and grow revenues. Watch now: https://bit.ly/2EAujMc','https://bit.ly/2EAujMc',0,0),(121,4,'2020-10-06 16:53:57','[Webinar] Is your site to ready to handle spikes in traffic and transactions? ','Your site speed can make or break your conversion rate this holiday season and beyond. Join us on October 15th for a fireside chat &quot;Is Your Website Ready for the 2020 Holiday Season?&quot; to learn what Commerce features you must have, and how to scale your webstore to maximize conversion rates. If you can&#039;t make the live webinar, be sure to register anyway and we&#039;ll send you the recording and slides afterward. Register today: https://bit.ly/33wzXbC','https://bit.ly/33wzXbC',0,0),(122,4,'2020-11-02 16:19:52','2021 Planning - reach out to us today to get your free site assessment to identify top conversion drivers.  ','Considering moving to Magento Commerce in 2021? Would you like a demo or free site assessment? Our team of experts would love to help. Get started now. https://bit.ly/3lcgILt','https://bit.ly/3lcgILt',0,0),(123,4,'2020-11-04 14:28:07','Please help prioritize our roadmap - SHORT survey','We are looking to better understand how we can help you manage all of your digital ecommerce from one place. Please help us prioritize our roadmap! Very short survey is here! http://selfserve.decipherinc.com/survey/selfserve/9d5/201000','http://selfserve.decipherinc.com/survey/selfserve/9d5/201000',0,0),(124,4,'2020-11-10 17:55:47','Webinar : Merry Marketing - Best Practices for the Holiday Season and Beyond','As we approach the holiday season and prepare for 2021, we are bringing together best practices from Adobe and a few of our key partners Wagento and Leadous. Join our executives on Thurs, Nov 12th as we have an open discussion on how to leverage digital performance to drive results for the holidays and into the new year. Save your Seat: https://bit.ly/38w0pF9','https://bit.ly/38w0pF9',0,0),(125,3,'2020-11-13 02:01:54','New version 2.9.7 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.9.7\n                                 ','https://magefan.com/magento2-blog-extension?version=2.9.7',0,0),(126,4,'2020-11-23 19:59:51','Upgrade to Magento Commerce quickly with Rapid Deployment Packages','Our experienced solution partners offer special design and implementation packages for businesses to upgrade their site quickly and cost effectively. Learn More: https://adobe.ly/3nqaXKx','https://adobe.ly/3nqaXKx',0,0),(127,4,'2020-12-01 22:02:47','[Video] Fuel Your Business Growth with Magento Commerce','Follow along as our friends at Goodacre Farm &amp; Supply transform their business into a cloud-based eCommerce machine with easy content creation, support for multiple web stores, and personalized product recommendations. Watch Now: https://bit.ly/3m8S2mW','https://bit.ly/3m8S2mW',0,0),(128,4,'2020-12-07 16:29:27','SURVEY: Business Financing and Support','Please complete if you are responsible for your business finances. We&#039;d like to hear from you about your past and future business financing needs. Strictly confidential.','http://selfserve.decipherinc.com/survey/selfserve/9d5/g30c/201100',0,0),(129,4,'2020-12-11 00:37:39','Experience the new Interactive Tour to compare Open Source and Magento Commerce.','Create closer consumer connections in the New Year. Explore our interactive product simulation and learn how Magento Commerce delivers everything you need to drive growth in an increasingly competitive online market. https://adobe.ly/3okS1wS','https://adobe.ly/3okS1wS',0,0),(130,4,'2021-01-08 21:35:55','Happy new year! Is Your Website Selling as Much as It Can? Watch our on-demand webinar and learn how to turn your website into a conversion machine.','Watch our on-demand webinar: Is Your Website Selling As Much As It Can? Digital Strategist Ereika Stimley and eCommerce Consultant Corey Gelato will walk you through a website self-assessment and live demo that will help you uncover opportunities to increase conversions and grow revenues. Watch now: https://bit.ly/2EAujMc','https://bit.ly/2EAujMc',0,0),(131,4,'2021-01-14 01:32:42','You&#039;re invited to our webinar: Is Magento Commerce or Open Source right for you? ','Magento Commerce and Magento Open Source may sound alike, but each offers sharply distinct benefits. To get the facts, sign up for our webinar Is Magento Commerce or Open Source right for you? at 10:00 AM PT on February 4th. Register now: http://bit.ly/3icfnTM','http://bit.ly/3icfnTM',0,0),(132,4,'2021-02-03 16:14:08','NEW Magento 2 Zero Downtime Deployment Extension.',' Do you hate to see when your store is broken while running Magento 2 deployment commands? Install New Zero Downtime Deployment extension and forget about it. Deploy new features and bug fixes without interrupting your customers.','https://magefan.com/magento-2-zero-downtime-deployment?from=ntf-new',0,0),(133,4,'2021-02-22 23:52:27','Quarterly Business Planning - reach out to us today to get your free site assessment.','Would you like a free site assessment? Our best-in-breed commerce solution gives your business unmatched agility and scalability. It&#039;s time to experience limitless eCommerce with no comprises. Learn more: https://bit.ly/3lcgILt','https://bit.ly/3lcgILt',0,0),(134,4,'2021-03-23 00:33:54','You&#039;re invited to our webinar this week: How digital commerce can scale B2B selling','Digital commerce is fast becoming the default way to buy—even for B2B customers. In just 8 weeks, Byrne Electrical, the leading manufacturer of power and data solutions for numerous industries, launched an eCommerce portal for more than 1,100 of their customers. To learn how they did it, join George Fabis, Director of IT for Byrne, and Slava Kravchuk, CEO &amp; Founder of Atwix, a Magento Commerce solutions partner, for a live discussion on Thursday, March 25. Register Now: https://bit.ly/3r1MCvG','https://bit.ly/3r1MCvG',0,0),(135,4,'2021-05-11 20:44:41','Magento Open Source 2.4.2-p1 &amp; 2.3.7 deliver important security updates','The latest releases of Magento Open Source – 2.3.7 and 2.4.2-p1 – are now generally available. The latest release of Magento Open Source includes important security updates. With these important updates we strongly recommend that you upgrade to ensure your sites maintain the highest level of security. You can review the release notes for more information about all of the updates. Learn how this release can help you save time and maximize resources at Magento.com/blog.','https://devdocs.magento.com/guides/v2.3/release-notes/bk-release-notes.html ',0,0),(136,4,'2021-08-10 17:53:11','Magento Open Source 2.4.3 available today!','Magento Open Source 2.4.3, along with security-only patches 2.4.2-p1 and 2.3.7-p2, is now generally available. Magento Open Source 2.4.3 includes 33 security and 370+ quality improvements, along with performance and scale enhancements.  With these important updates, we strongly recommend that you upgrade to maintain the highest level of security for your sites. Learn how this release can help you save time and maximize resources in our release blog. ','http://magento.com/blog/magento-news/get-ready-your-peak-season-adobe-commerce-243',0,0),(137,3,'2021-08-22 11:27:08','New version 2.10.2 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.10.2\n                                 ','https://magefan.com/magento2-blog-extension?version=2.10.2',0,0),(138,3,'2021-08-03 00:00:00','New FREE Magento 2 Facebook Pixel Extension','Integrate Facebook Pixel just in a few clicks with the new FREE Magento 2 Facebook Pixel Extension. Hurry up to try it out! https://magefan.com/magento-2-facebook-pixel-extension','https://magefan.com/magento-2-facebook-pixel-extension?utm_source=website&amp;utm_medium=admin_notification&amp;utm_campaign=new_extension_fb_pixel',0,0),(139,4,'2021-10-01 14:44:47','New, Simplified Upgrade Process and Lifecycle Policy Helps Reduce Your TCO ','Adobe Commerce developed a new release strategy and updated its lifecycle policy in effort to help Merchants lower their total cost of ownership and accelerate their time to innovation. Learn more about how upgrades are now more predictable and easier to implement in our blog.','https://magento.com/blog/accelerating-innovation-through-simplified-release-strategy',0,0),(140,4,'2021-10-22 19:06:48','Magento Technology Stack Evaluation Survey','Please take a few minutes to fill out this survey https://forms.office.com/r/DLN8K3h2h0. We appreciate your effort to support the future of Adobe Commerce!','https://forms.office.com/r/DLN8K3h2h0',0,0),(141,3,'2021-10-27 11:45:20','New version 2.10.3 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.10.3\n                                 ','https://magefan.com/magento2-blog-extension?version=2.10.3',0,0),(142,3,'2021-11-18 10:49:36','New version 2.10.4 of Magefan Magento 2 Blog Extension is now available.',' You can download the new version from Magefan Store or update it via composer. Get us in touch if you need our help with an update or you have any questions.\n                                    https://magefan.com/magento2-blog-extension?version=2.10.4\n                                 ','https://magefan.com/magento2-blog-extension?version=2.10.4',0,0),(143,4,'2021-11-17 00:00:00','Guess whose birthday it is today? Magefan&#039;s!','Hurry up to get FREE Installation Service with any of Magento 2 extension purchased on November 2021! ','https://magefan.com/magento2-extensions?utm_source=website_admin&amp;utm_medium=a_notification&amp;utm_campaign=magefan6&amp;utm_id=magefan%27sbday',0,0),(144,4,'2021-12-06 00:00:00','NEW Magento 2 AMP Blog Release! ','This extension integrates our Magento 2 Blog Extension with Magento 2 AMP extension by  Plumrocket, our trusted partner.  Improve your Blog on mobile devices for better user engagement!  https://bit.ly/3y2Yy5z','https://magefan.com/magento-2-amp-blog-extension?utm_source=admin&amp;utm_medium=notifications&amp;utm_id=new-release-ampblog',0,0),(145,4,'2021-12-15 00:00:00','Save up to 15% OFF select M2 extensions - Happy Holidays from the Magefan team!  ','Wishing you and your families peaceful and joyful holidays! Check out our Christmas Sale https://bit.ly/3s51aPw','https://magefan.com/magento2-extensions?utm_source=admin-notif&amp;utm_medium=ntf&amp;utm_campaign=christmas-sale&amp;utm_id=15off ',0,0),(146,4,'2022-01-11 00:00:00','NEW Magento 2 Coupon Code Extension has been released! ','Provide discounts to your customers faster than in 1 click. Check out more details about our latest product release https://bit.ly/3I0tcjE','https://magefan.com/magento-2-coupon-code-link?utm_source=admin&amp;utm_medium=ntf&amp;utm_campaign=new-release&amp;utm_id=new-cce ',0,0),(147,1,'2022-01-24 10:33:06','Attention! Your Blog extension version is extremely outdated. It is strongly recommended to update it to the latest version 2.10.5',' \n                                    https://magefan.com/magento2-blog-extension?ancient=2.9.8                                 ','https://magefan.com/magento2-blog-extension?ancient=2.9.8',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=21 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'),(12,0,1,0,'U',10,'1','110'),(14,1,2,0,'U',2,'2','Nguyen'),(15,1,2,0,'U',1,'2','admin'),(16,1,2,0,'U',3,'2','shopadmin'),(17,1,2,0,'U',4,'2','tqiue'),(18,1,2,0,'U',5,'2','tique'),(19,0,1,0,'U',11,'1','111'),(20,0,1,0,'U',12,'1','112');

--
-- 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=7469 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'),(7201,12,'Magento_Backend::all',NULL,'deny'),(7202,12,'Magento_Backend::admin',NULL,'allow'),(7203,12,'Magento_Backend::dashboard',NULL,'deny'),(7204,12,'Magento_Analytics::analytics',NULL,'deny'),(7205,12,'Magento_Analytics::analytics_api',NULL,'deny'),(7206,12,'Magiccart_Shopbrand::magiccart',NULL,'deny'),(7207,12,'Magiccart_Shopbrand::shopbrand',NULL,'deny'),(7208,12,'Magiccart_Shopbrand::shopbrand_brand',NULL,'deny'),(7209,12,'Magiccart_Magicslider::magiccart',NULL,'deny'),(7210,12,'Magiccart_Magicslider::magicslider',NULL,'deny'),(7211,12,'Magiccart_Magicslider::magicslider_index',NULL,'deny'),(7212,12,'Magiccart_Magicproduct::magiccart',NULL,'deny'),(7213,12,'Magiccart_Magicproduct::magicproduct',NULL,'deny'),(7214,12,'Magiccart_Magicproduct::magicproduct_product',NULL,'deny'),(7215,12,'Magiccart_Magicproduct::magicproduct_category',NULL,'deny'),(7216,12,'Magiccart_Magicproduct::magicproduct_miscellaneous',NULL,'deny'),(7217,12,'Magiccart_Magicmenu::magiccart',NULL,'deny'),(7218,12,'Magiccart_Magicmenu::magicmenu',NULL,'deny'),(7219,12,'Magiccart_Magicmenu::magicmenu_menu',NULL,'deny'),(7220,12,'Magiccart_Magicmenu::magicmenu_extra',NULL,'deny'),(7221,12,'Magiccart_Alothemes::magiccart',NULL,'deny'),(7222,12,'Magiccart_Alothemes::alothemes',NULL,'deny'),(7223,12,'Magiccart_Alothemes::alothemes_config',NULL,'deny'),(7224,12,'Magiccart_Alothemes::alothemes_import',NULL,'deny'),(7225,12,'Magiccart_Testimonial::magiccart',NULL,'deny'),(7226,12,'Magiccart_Testimonial::testimonial',NULL,'deny'),(7227,12,'Magiccart_Testimonial::testimonial_index',NULL,'deny'),(7228,12,'Magento_Sales::sales',NULL,'deny'),(7229,12,'Magento_Sales::sales_operation',NULL,'deny'),(7230,12,'Magento_Sales::sales_order',NULL,'deny'),(7231,12,'Magento_Sales::actions',NULL,'deny'),(7232,12,'Magento_Sales::create',NULL,'deny'),(7233,12,'Magento_Sales::actions_view',NULL,'deny'),(7234,12,'Magento_Sales::email',NULL,'deny'),(7235,12,'Magento_Sales::reorder',NULL,'deny'),(7236,12,'Magento_Sales::actions_edit',NULL,'deny'),(7237,12,'Magento_Sales::cancel',NULL,'deny'),(7238,12,'Magento_Sales::review_payment',NULL,'deny'),(7239,12,'Magento_Sales::capture',NULL,'deny'),(7240,12,'Magento_Sales::invoice',NULL,'deny'),(7241,12,'Magento_Sales::creditmemo',NULL,'deny'),(7242,12,'Magento_Sales::hold',NULL,'deny'),(7243,12,'Magento_Sales::unhold',NULL,'deny'),(7244,12,'Magento_Sales::ship',NULL,'deny'),(7245,12,'Magento_Sales::comment',NULL,'deny'),(7246,12,'Magento_Sales::emails',NULL,'deny'),(7247,12,'Magento_Paypal::authorization',NULL,'deny'),(7248,12,'Magento_Sales::sales_invoice',NULL,'deny'),(7249,12,'Magento_Sales::shipment',NULL,'deny'),(7250,12,'Temando_Shipping::dispatches',NULL,'deny'),(7251,12,'Magento_Sales::sales_creditmemo',NULL,'deny'),(7252,12,'Magento_Paypal::billing_agreement',NULL,'deny'),(7253,12,'Magento_Paypal::billing_agreement_actions',NULL,'deny'),(7254,12,'Magento_Paypal::billing_agreement_actions_view',NULL,'deny'),(7255,12,'Magento_Paypal::actions_manage',NULL,'deny'),(7256,12,'Magento_Paypal::use',NULL,'deny'),(7257,12,'Magento_Sales::transactions',NULL,'deny'),(7258,12,'Magento_Sales::transactions_fetch',NULL,'deny'),(7259,12,'Magento_Catalog::catalog',NULL,'allow'),(7260,12,'Magento_Catalog::catalog_inventory',NULL,'allow'),(7261,12,'Magento_Catalog::products',NULL,'allow'),(7262,12,'Magento_Catalog::categories',NULL,'deny'),(7263,12,'Magento_Customer::customer',NULL,'deny'),(7264,12,'Magento_Customer::manage',NULL,'deny'),(7265,12,'Magento_Customer::online',NULL,'deny'),(7266,12,'Magento_Cart::cart',NULL,'deny'),(7267,12,'Magento_Cart::manage',NULL,'deny'),(7268,12,'Magento_Backend::marketing',NULL,'deny'),(7269,12,'Magento_CatalogRule::promo',NULL,'deny'),(7270,12,'Magento_CatalogRule::promo_catalog',NULL,'deny'),(7271,12,'Magento_SalesRule::quote',NULL,'deny'),(7272,12,'Dotdigitalgroup_Email::automation',NULL,'deny'),(7273,12,'Dotdigitalgroup_Email::automation_studio',NULL,'deny'),(7274,12,'Dotdigitalgroup_Email::exclusion_rules',NULL,'deny'),(7275,12,'Magento_Backend::marketing_communications',NULL,'deny'),(7276,12,'Magento_Email::template',NULL,'deny'),(7277,12,'Magento_Newsletter::template',NULL,'deny'),(7278,12,'Magento_Newsletter::queue',NULL,'deny'),(7279,12,'Magento_Newsletter::subscriber',NULL,'deny'),(7280,12,'Magento_Backend::marketing_seo',NULL,'deny'),(7281,12,'Magento_Search::search',NULL,'deny'),(7282,12,'Magento_Search::synonyms',NULL,'deny'),(7283,12,'Magento_UrlRewrite::urlrewrite',NULL,'deny'),(7284,12,'Magento_Sitemap::sitemap',NULL,'deny'),(7285,12,'Magento_Backend::marketing_user_content',NULL,'deny'),(7286,12,'Magento_Review::reviews_all',NULL,'deny'),(7287,12,'Magento_Review::pending',NULL,'deny'),(7288,12,'Magento_Backend::myaccount',NULL,'deny'),(7289,12,'Magento_Backend::content',NULL,'deny'),(7290,12,'Magento_Backend::content_elements',NULL,'deny'),(7291,12,'Magento_Cms::page',NULL,'deny'),(7292,12,'Magento_Cms::save',NULL,'deny'),(7293,12,'Magento_Cms::page_delete',NULL,'deny'),(7294,12,'Magento_Cms::block',NULL,'deny'),(7295,12,'Magento_Widget::widget_instance',NULL,'deny'),(7296,12,'Magento_Cms::media_gallery',NULL,'deny'),(7297,12,'Magefan_Blog::elements',NULL,'deny'),(7298,12,'Magefan_Blog::post',NULL,'deny'),(7299,12,'Magefan_Blog::category',NULL,'deny'),(7300,12,'Magefan_Blog::comment',NULL,'deny'),(7301,12,'Magefan_Blog::import',NULL,'deny'),(7302,12,'Magento_Backend::design',NULL,'deny'),(7303,12,'Magento_Theme::theme',NULL,'deny'),(7304,12,'Magento_Backend::schedule',NULL,'deny'),(7305,12,'Magento_Backend::content_translation',NULL,'deny'),(7306,12,'Magento_Reports::report',NULL,'deny'),(7307,12,'Dotdigitalgroup_Email::reports',NULL,'deny'),(7308,12,'Dotdigitalgroup_Email::contact',NULL,'deny'),(7309,12,'Dotdigitalgroup_Email::order',NULL,'deny'),(7310,12,'Dotdigitalgroup_Email::review',NULL,'deny'),(7311,12,'Dotdigitalgroup_Email::wishlist',NULL,'deny'),(7312,12,'Dotdigitalgroup_Email::catalog',NULL,'deny'),(7313,12,'Dotdigitalgroup_Email::importer',NULL,'deny'),(7314,12,'Dotdigitalgroup_Email::campaign',NULL,'deny'),(7315,12,'Dotdigitalgroup_Email::cron',NULL,'deny'),(7316,12,'Dotdigitalgroup_Email::dashboard',NULL,'deny'),(7317,12,'Dotdigitalgroup_Email::automation_enrollment',NULL,'deny'),(7318,12,'Dotdigitalgroup_Email::logviewer',NULL,'deny'),(7319,12,'Magento_Reports::report_marketing',NULL,'deny'),(7320,12,'Magento_Reports::shopcart',NULL,'deny'),(7321,12,'Magento_Reports::product',NULL,'deny'),(7322,12,'Magento_Reports::abandoned',NULL,'deny'),(7323,12,'Magento_Reports::report_search',NULL,'deny'),(7324,12,'Magento_Newsletter::problem',NULL,'deny'),(7325,12,'Magento_Reports::review',NULL,'deny'),(7326,12,'Magento_Reports::review_customer',NULL,'deny'),(7327,12,'Magento_Reports::review_product',NULL,'deny'),(7328,12,'Magento_Reports::salesroot',NULL,'deny'),(7329,12,'Magento_Reports::salesroot_sales',NULL,'deny'),(7330,12,'Magento_Reports::tax',NULL,'deny'),(7331,12,'Magento_Reports::invoiced',NULL,'deny'),(7332,12,'Magento_Reports::shipping',NULL,'deny'),(7333,12,'Magento_Reports::refunded',NULL,'deny'),(7334,12,'Magento_Reports::coupons',NULL,'deny'),(7335,12,'Magento_Paypal::paypal_settlement_reports',NULL,'deny'),(7336,12,'Magento_Paypal::paypal_settlement_reports_view',NULL,'deny'),(7337,12,'Magento_Paypal::fetch',NULL,'deny'),(7338,12,'Magento_Braintree::settlement_report',NULL,'deny'),(7339,12,'Magento_Reports::customers',NULL,'deny'),(7340,12,'Magento_Reports::totals',NULL,'deny'),(7341,12,'Magento_Reports::customers_orders',NULL,'deny'),(7342,12,'Magento_Reports::accounts',NULL,'deny'),(7343,12,'Magento_Reports::report_products',NULL,'deny'),(7344,12,'Magento_Reports::viewed',NULL,'deny'),(7345,12,'Magento_Reports::bestsellers',NULL,'deny'),(7346,12,'Magento_Reports::lowstock',NULL,'deny'),(7347,12,'Magento_Reports::sold',NULL,'deny'),(7348,12,'Magento_Reports::downloads',NULL,'deny'),(7349,12,'Magento_Reports::statistics',NULL,'deny'),(7350,12,'Magento_Reports::statistics_refresh',NULL,'deny'),(7351,12,'Magento_Analytics::business_intelligence',NULL,'deny'),(7352,12,'Magento_Analytics::advanced_reporting',NULL,'deny'),(7353,12,'Magento_Analytics::bi_essentials',NULL,'deny'),(7354,12,'Magento_Backend::stores',NULL,'allow'),(7355,12,'Magento_Backend::stores_settings',NULL,'allow'),(7356,12,'Magento_Backend::store',NULL,'allow'),(7357,12,'Magento_Config::config',NULL,'deny'),(7358,12,'Magiccart_Testimonial::config_testimonial',NULL,'deny'),(7359,12,'Magento_Contact::contact',NULL,'deny'),(7360,12,'Magiccart_Shopbrand::config_shopbrand',NULL,'deny'),(7361,12,'Magiccart_Magicslider::config_magicslider',NULL,'deny'),(7362,12,'Magiccart_Magicproduct::config_magicproduct',NULL,'deny'),(7363,12,'Magiccart_Magicmenu::config_magicmenu',NULL,'deny'),(7364,12,'Magiccart_Alothemes::config_alodesign',NULL,'deny'),(7365,12,'Magiccart_Alothemes::config_alothemes',NULL,'deny'),(7366,12,'Dotdigitalgroup_Email::config',NULL,'deny'),(7367,12,'Magento_Sales::fraud_protection',NULL,'deny'),(7368,12,'Magefan_Blog::config_blog',NULL,'deny'),(7369,12,'Magento_Cms::config_cms',NULL,'deny'),(7370,12,'Magento_Newsletter::newsletter',NULL,'deny'),(7371,12,'Magento_Downloadable::downloadable',NULL,'deny'),(7372,12,'Magento_GoogleAnalytics::google',NULL,'deny'),(7373,12,'Magento_CatalogInventory::cataloginventory',NULL,'deny'),(7374,12,'Magento_Payment::payment_services',NULL,'deny'),(7375,12,'Magento_Payment::payment',NULL,'deny'),(7376,12,'Magento_Catalog::config_catalog',NULL,'deny'),(7377,12,'Magento_CatalogSearch::config_catalog_search',NULL,'deny'),(7378,12,'Magento_Shipping::carriers',NULL,'deny'),(7379,12,'Magento_Shipping::shipping_policy',NULL,'deny'),(7380,12,'Magento_Shipping::config_shipping',NULL,'deny'),(7381,12,'Magento_Multishipping::config_multishipping',NULL,'deny'),(7382,12,'Magento_Config::config_general',NULL,'deny'),(7383,12,'Magento_Config::web',NULL,'deny'),(7384,12,'Magento_Config::config_design',NULL,'deny'),(7385,12,'Magento_Customer::config_customer',NULL,'deny'),(7386,12,'Magento_Paypal::paypal',NULL,'deny'),(7387,12,'Magento_Tax::config_tax',NULL,'deny'),(7388,12,'Magento_Checkout::checkout',NULL,'deny'),(7389,12,'Magento_Persistent::persistent',NULL,'deny'),(7390,12,'Magento_Sales::config_sales',NULL,'deny'),(7391,12,'Magento_Sales::sales_email',NULL,'deny'),(7392,12,'Magento_Sales::sales_pdf',NULL,'deny'),(7393,12,'Magento_Sitemap::config_sitemap',NULL,'deny'),(7394,12,'Magento_Reports::reports',NULL,'deny'),(7395,12,'Magento_Config::config_system',NULL,'deny'),(7396,12,'Magento_Wishlist::config_wishlist',NULL,'deny'),(7397,12,'Magento_SalesRule::config_promo',NULL,'deny'),(7398,12,'Magento_Config::advanced',NULL,'deny'),(7399,12,'Magento_Config::trans_email',NULL,'deny'),(7400,12,'Magento_Config::config_admin',NULL,'deny'),(7401,12,'Magento_Config::dev',NULL,'deny'),(7402,12,'Magento_Config::currency',NULL,'deny'),(7403,12,'Magento_Rss::rss',NULL,'deny'),(7404,12,'Magento_Config::sendfriend',NULL,'deny'),(7405,12,'Magento_Analytics::analytics_settings',NULL,'deny'),(7406,12,'Magento_NewRelicReporting::config_newrelicreporting',NULL,'deny'),(7407,12,'Magento_CheckoutAgreements::checkoutagreement',NULL,'deny'),(7408,12,'Magento_Sales::order_statuses',NULL,'deny'),(7409,12,'Temando_Shipping::shipping',NULL,'deny'),(7410,12,'Temando_Shipping::carriers',NULL,'deny'),(7411,12,'Temando_Shipping::locations',NULL,'deny'),(7412,12,'Temando_Shipping::packaging',NULL,'deny'),(7413,12,'Magento_Tax::manage_tax',NULL,'deny'),(7414,12,'Magento_CurrencySymbol::system_currency',NULL,'deny'),(7415,12,'Magento_CurrencySymbol::currency_rates',NULL,'deny'),(7416,12,'Magento_CurrencySymbol::symbols',NULL,'deny'),(7417,12,'Magento_Backend::stores_attributes',NULL,'deny'),(7418,12,'Magento_Catalog::attributes_attributes',NULL,'deny'),(7419,12,'Magento_Catalog::update_attributes',NULL,'deny'),(7420,12,'Magento_Catalog::sets',NULL,'deny'),(7421,12,'Magento_Review::ratings',NULL,'deny'),(7422,12,'Magento_Swatches::iframe',NULL,'deny'),(7423,12,'Magento_Backend::stores_other_settings',NULL,'deny'),(7424,12,'Magento_Customer::group',NULL,'deny'),(7425,12,'Magento_Backend::system',NULL,'deny'),(7426,12,'Magento_Backend::convert',NULL,'deny'),(7427,12,'Magento_ImportExport::import',NULL,'deny'),(7428,12,'Magento_ImportExport::export',NULL,'deny'),(7429,12,'Magento_TaxImportExport::import_export',NULL,'deny'),(7430,12,'Magento_ImportExport::history',NULL,'deny'),(7431,12,'Magento_Backend::extensions',NULL,'deny'),(7432,12,'Magento_Backend::local',NULL,'deny'),(7433,12,'Magento_Backend::custom',NULL,'deny'),(7434,12,'Magento_Integration::extensions',NULL,'deny'),(7435,12,'Magento_Integration::integrations',NULL,'deny'),(7436,12,'Magento_Backend::tools',NULL,'deny'),(7437,12,'Magento_Backend::cache',NULL,'deny'),(7438,12,'Magento_Backend::main_actions',NULL,'deny'),(7439,12,'Magento_Backend::flush_cache_storage',NULL,'deny'),(7440,12,'Magento_Backend::flush_magento_cache',NULL,'deny'),(7441,12,'Magento_Backend::mass_actions',NULL,'deny'),(7442,12,'Magento_Backend::toggling_cache_type',NULL,'deny'),(7443,12,'Magento_Backend::refresh_cache_type',NULL,'deny'),(7444,12,'Magento_Backend::additional_cache_management',NULL,'deny'),(7445,12,'Magento_Backend::flush_catalog_images',NULL,'deny'),(7446,12,'Magento_Backend::flush_js_css',NULL,'deny'),(7447,12,'Magento_Backend::flush_static_files',NULL,'deny'),(7448,12,'Magento_Backend::setup_wizard',NULL,'deny'),(7449,12,'Magento_Indexer::index',NULL,'deny'),(7450,12,'Magento_Backup::backup',NULL,'deny'),(7451,12,'Magento_Backup::rollback',NULL,'deny'),(7452,12,'Magento_Indexer::changeMode',NULL,'deny'),(7453,12,'Magento_User::acl',NULL,'deny'),(7454,12,'Magento_User::acl_users',NULL,'deny'),(7455,12,'Magento_User::locks',NULL,'deny'),(7456,12,'Magento_User::acl_roles',NULL,'deny'),(7457,12,'Magento_Backend::system_other_settings',NULL,'deny'),(7458,12,'Magento_AdminNotification::adminnotification',NULL,'deny'),(7459,12,'Magento_AdminNotification::show_toolbar',NULL,'deny'),(7460,12,'Magento_AdminNotification::show_list',NULL,'deny'),(7461,12,'Magento_AdminNotification::mark_as_read',NULL,'deny'),(7462,12,'Magento_AdminNotification::adminnotification_remove',NULL,'deny'),(7463,12,'Magento_Variable::variable',NULL,'deny'),(7464,12,'Magento_EncryptionKey::crypt_key',NULL,'deny'),(7465,12,'Magento_Backend::global_search',NULL,'deny'),(7467,19,'Magento_Backend::all',NULL,'allow'),(7468,20,'Magento_Backend::all',NULL,'allow');

--
-- Table structure for table `braintree_credit_prices`
--

CREATE TABLE `braintree_credit_prices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row ID',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `term` int(11) NOT NULL COMMENT 'Credit Term',
  `monthly_payment` decimal(12,2) NOT NULL COMMENT 'Monthly Payment',
  `instalment_rate` decimal(12,2) NOT NULL COMMENT 'Instalment Rate',
  `cost_of_purchase` decimal(12,2) NOT NULL COMMENT 'Cost of purchase',
  `total_inc_interest` decimal(12,2) NOT NULL COMMENT 'Total Inc Interest',
  PRIMARY KEY (`id`),
  UNIQUE KEY `BRAINTREE_CREDIT_PRICES_PRODUCT_ID_TERM` (`product_id`,`term`),
  KEY `BRAINTREE_CREDIT_PRICES_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Braintree credit rates';

--
-- Dumping data for table `braintree_credit_prices`
--


--
-- Table structure for table `braintree_transaction_details`
--

CREATE TABLE `braintree_transaction_details` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order Id',
  `transaction_source` varchar(12) DEFAULT NULL COMMENT 'Transaction Source',
  PRIMARY KEY (`entity_id`),
  KEY `BRAINTREE_TRANSACTION_DETAILS_ORDER_ID` (`order_id`),
  CONSTRAINT `BRAINTREE_TRANSACTION_DETAILS_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Braintree transaction details table';

--
-- Dumping data for table `braintree_transaction_details`
--


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

INSERT INTO `captcha_log` VALUES ('1','135.148.2.82',1,'2021-02-26 23:13:56'),('1','149.28.40.13',18,'2021-03-02 01:19:14'),('1','168.90.12.2',1,'2020-06-24 22:51:40'),('1','91.243.100.9',2,'2021-02-23 07:29:29'),('1','94.181.47.232',1,'2021-02-16 11:26:14'),('2','1WIN_Paxia',1,'2021-02-21 10:43:07'),('2','90025529',2,'2021-12-11 03:50:51'),('2','AndrewMix',1,'2021-02-10 16:36:43'),('2','casino-androidcexia',1,'2021-02-22 08:19:42'),('2','Doublebtc-Oxime',1,'2021-02-10 07:45:16'),('2','DramXrenCebra',1,'2021-02-14 03:32:38'),('2','Invillflita',1,'2021-02-18 17:30:26'),('2','InvillNualo',1,'2021-02-16 07:09:05'),('2','James20210tubox',1,'2021-02-13 04:28:52'),('2','Jamesdyext',1,'2021-02-22 05:31:45'),('2','joncasasq@gmail.com',1,'2020-06-24 22:51:40'),('2','Larryrep',1,'2021-02-25 19:35:34'),('2','LewisGyday',1,'2021-03-02 01:19:14'),('2','palo@visibleone.com',2,'2021-02-24 10:44:45'),('2','pinupcasinoo',1,'2021-02-20 02:54:21'),('2','Richardzen',1,'2021-02-26 13:50:52'),('2','Ronaldgorma',1,'2021-02-26 23:13:56'),('2','samuelKink',3,'2021-03-01 00:59:59'),('2','TerrySak',1,'2021-02-23 07:29:29'),('2','test@gmail.com',1,'2021-01-24 20:13:15'),('2','vanphuthanhtri1212@gmail.com',4,'2018-10-09 03:36:36'),('2','WayneJoymn',2,'2021-02-16 11:26:14');

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

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

INSERT INTO `catalog_category_entity` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5),(92,3,1,'2019-12-10 03:28:47','2021-08-31 08:17:10','1/92',2,1,0),(124,3,1,'2019-12-11 09:43:38','2021-08-31 08:17:22','1/124',3,1,0),(157,3,1,'2019-12-13 01:29:59','2021-08-31 08:17:34','1/157',4,1,0),(189,3,1,'2019-12-13 10:00:01','2021-08-31 08:17:45','1/189',5,1,0),(217,3,2,'2021-08-22 08:18:27','2021-12-14 17:37:11','1/2/217',1,2,0),(218,3,2,'2021-08-22 08:18:49','2021-12-14 17:37:33','1/2/218',2,2,0),(219,3,2,'2021-08-24 20:05:01','2021-12-14 17:38:42','1/2/219',3,2,0),(220,3,2,'2021-08-30 18:52:37','2021-12-14 17:39:22','1/2/220',4,2,0),(224,3,2,'2021-08-30 18:56:00','2021-12-14 17:40:40','1/2/224',5,2,0);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_after_insert AFTER INSERT ON catalog_category_entity FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_after_update AFTER UPDATE ON catalog_category_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.`parent_id` <=> OLD.`parent_id`) OR NOT(NEW.`created_at` <=> OLD.`created_at`) OR NOT(NEW.`path` <=> OLD.`path`) OR NOT(NEW.`position` <=> OLD.`position`) OR NOT(NEW.`level` <=> OLD.`level`) OR NOT(NEW.`children_count` <=> OLD.`children_count`)) THEN INSERT IGNORE INTO `catalog_category_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`parent_id` <=> OLD.`parent_id`) OR NOT(NEW.`created_at` <=> OLD.`created_at`) OR NOT(NEW.`path` <=> OLD.`path`) OR NOT(NEW.`position` <=> OLD.`position`) OR NOT(NEW.`level` <=> OLD.`level`) OR NOT(NEW.`children_count` <=> OLD.`children_count`)) THEN INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_after_delete AFTER DELETE ON catalog_category_entity FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- 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=248 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,58,0,1,NULL),(2,58,0,2,NULL),(221,58,0,92,NULL),(222,59,0,92,NULL),(231,58,0,189,NULL),(232,59,0,189,NULL),(233,58,0,124,NULL),(234,59,0,124,NULL),(235,58,0,157,NULL),(236,59,0,157,NULL),(237,58,0,217,NULL),(238,59,0,217,NULL),(239,58,0,218,NULL),(240,59,0,218,NULL),(241,58,0,219,NULL),(242,59,0,219,NULL),(243,59,0,2,NULL),(244,58,0,220,NULL),(245,59,0,220,NULL),(246,58,0,224,NULL),(247,59,0,224,NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_datetime_after_insert AFTER INSERT ON catalog_category_entity_datetime FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_datetime_after_update AFTER UPDATE ON catalog_category_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 `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_datetime_after_delete AFTER DELETE ON catalog_category_entity_datetime FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

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

DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_decimal_after_insert AFTER INSERT ON catalog_category_entity_decimal FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_decimal_after_update AFTER UPDATE ON catalog_category_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 `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_decimal_after_delete AFTER DELETE ON catalog_category_entity_decimal FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- 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=1274 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,66,0,1,1),(2,43,0,2,1),(3,66,0,2,1),(592,43,0,92,0),(593,51,0,92,1),(594,66,0,92,0),(595,67,0,92,0),(596,68,0,92,0),(662,50,0,92,NULL),(754,43,0,124,0),(755,51,0,124,1),(756,66,0,124,0),(757,67,0,124,0),(758,68,0,124,0),(921,43,0,157,0),(922,51,0,157,1),(923,66,0,157,0),(924,67,0,157,0),(925,68,0,157,0),(1082,43,0,189,0),(1083,51,0,189,1),(1084,66,0,189,0),(1085,67,0,189,0),(1086,68,0,189,0),(1087,50,0,189,NULL),(1223,50,0,124,NULL),(1224,50,0,157,NULL),(1225,43,0,217,1),(1226,51,0,217,1),(1227,66,0,217,0),(1228,67,0,217,0),(1229,68,0,217,0),(1230,43,0,218,1),(1231,51,0,218,1),(1232,66,0,218,0),(1233,67,0,218,0),(1234,68,0,218,0),(1235,43,0,219,1),(1236,51,0,219,1),(1237,66,0,219,0),(1238,67,0,219,0),(1239,68,0,219,0),(1240,50,0,217,NULL),(1241,50,0,218,NULL),(1242,50,0,219,NULL),(1243,43,0,220,1),(1244,51,0,220,1),(1245,66,0,220,0),(1246,67,0,220,0),(1247,68,0,220,0),(1258,50,0,2,NULL),(1259,51,0,2,1),(1260,67,0,2,0),(1261,68,0,2,0),(1267,43,0,224,1),(1268,51,0,224,1),(1269,66,0,224,0),(1270,67,0,224,0),(1271,68,0,224,0),(1272,50,0,220,NULL),(1273,50,0,224,NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_int_after_insert AFTER INSERT ON catalog_category_entity_int FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_int_after_update AFTER UPDATE ON catalog_category_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 `catalog_category_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_int_after_delete AFTER DELETE ON catalog_category_entity_int FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- 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=580 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,1,NULL),(532,44,0,92,NULL),(533,47,0,92,NULL),(534,48,0,92,NULL),(552,44,0,189,NULL),(553,47,0,189,NULL),(554,48,0,189,NULL),(556,44,0,124,NULL),(557,47,0,124,NULL),(558,48,0,124,NULL),(559,44,0,157,NULL),(560,47,0,157,NULL),(561,48,0,157,NULL),(562,44,0,217,NULL),(563,47,0,217,NULL),(564,48,0,217,NULL),(565,44,0,218,NULL),(566,47,0,218,NULL),(567,48,0,218,NULL),(568,44,0,219,NULL),(569,47,0,219,NULL),(570,48,0,219,NULL),(571,44,0,2,NULL),(572,47,0,2,NULL),(573,48,0,2,NULL),(574,44,0,220,NULL),(575,47,0,220,NULL),(576,48,0,220,NULL),(577,44,0,224,NULL),(578,47,0,224,NULL),(579,48,0,224,NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_text_after_insert AFTER INSERT ON catalog_category_entity_text FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_text_after_update AFTER UPDATE ON catalog_category_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 `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_text_after_delete AFTER DELETE ON catalog_category_entity_text FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- 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=1659 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,42,0,1,'Root Catalog'),(2,42,0,2,'Default'),(3,49,0,2,'PRODUCTS'),(993,42,0,92,'Jewelry'),(994,49,0,92,'PRODUCTS'),(995,113,0,92,'jewellry'),(1048,45,0,92,NULL),(1049,46,0,92,NULL),(1050,57,0,92,NULL),(1051,60,0,92,NULL),(1052,114,0,92,NULL),(1053,131,0,92,NULL),(1054,132,0,92,NULL),(1055,133,0,92,NULL),(1136,42,0,124,'Flower'),(1137,49,0,124,'PRODUCTS'),(1138,113,0,124,'flower'),(1283,42,0,157,'Pet'),(1284,49,0,157,'PRODUCTS'),(1285,113,0,157,'pet'),(1418,42,0,189,'Kid'),(1419,49,0,189,'PRODUCTS'),(1420,113,0,189,'kid'),(1421,45,0,189,NULL),(1422,46,0,189,NULL),(1423,57,0,189,NULL),(1424,60,0,189,NULL),(1425,114,0,189,NULL),(1426,131,0,189,NULL),(1427,132,0,189,NULL),(1428,133,0,189,NULL),(1537,45,0,124,NULL),(1538,46,0,124,NULL),(1539,57,0,124,NULL),(1540,60,0,124,NULL),(1541,114,0,124,NULL),(1542,131,0,124,NULL),(1543,132,0,124,NULL),(1544,133,0,124,NULL),(1545,45,0,157,NULL),(1546,46,0,157,NULL),(1547,57,0,157,NULL),(1548,60,0,157,NULL),(1549,114,0,157,NULL),(1550,131,0,157,NULL),(1551,132,0,157,NULL),(1552,133,0,157,NULL),(1553,42,0,217,'Floral designs '),(1554,49,0,217,'PRODUCTS'),(1555,113,0,217,'floral'),(1556,114,0,217,'floral'),(1557,42,0,218,'Bouquets'),(1558,49,0,218,'PRODUCTS'),(1559,113,0,218,'bouquets'),(1560,114,0,218,'bouquets'),(1561,42,18,218,'باقات'),(1562,131,18,218,NULL),(1563,132,18,218,NULL),(1564,133,18,218,NULL),(1565,42,18,217,'تصاميم الأزهار'),(1566,131,18,217,NULL),(1567,132,18,217,NULL),(1568,133,18,217,NULL),(1569,42,0,219,'Tops'),(1570,49,0,219,'PRODUCTS'),(1571,113,0,219,'flowers'),(1572,114,0,219,'flowers'),(1573,42,18,219,'حفلات الزفاف '),(1574,131,18,219,NULL),(1575,132,18,219,NULL),(1576,133,18,219,NULL),(1578,45,0,217,'/pub/media/catalog/category/Banner_1_Photo_1.jpg'),(1579,46,0,217,NULL),(1580,57,0,217,NULL),(1581,60,0,217,NULL),(1582,131,0,217,NULL),(1583,132,0,217,NULL),(1584,133,0,217,NULL),(1586,45,0,218,'/pub/media/catalog/category/Banner_1_Photo_1_1.jpg'),(1587,46,0,218,NULL),(1588,57,0,218,NULL),(1589,60,0,218,NULL),(1590,131,0,218,NULL),(1591,132,0,218,NULL),(1592,133,0,218,NULL),(1594,45,0,219,'/pub/media/catalog/category/index.jpg'),(1595,46,0,219,NULL),(1596,57,0,219,NULL),(1597,60,0,219,NULL),(1598,131,0,219,NULL),(1599,132,0,219,NULL),(1600,133,0,219,NULL),(1601,42,0,220,'shoes'),(1602,49,0,220,'PRODUCTS'),(1603,113,0,220,'plant-arrangements'),(1604,114,0,220,'plant-arrangements'),(1615,45,0,2,NULL),(1616,46,0,2,NULL),(1617,57,0,2,NULL),(1618,60,0,2,NULL),(1619,113,0,2,'packages'),(1620,114,0,2,NULL),(1621,131,0,2,NULL),(1622,132,0,2,NULL),(1623,133,0,2,NULL),(1628,42,0,224,'shirts'),(1629,49,0,224,'PRODUCTS'),(1630,113,0,224,'packagesshop'),(1631,114,0,224,'packagesshop'),(1632,42,18,224,'باقات'),(1633,131,18,224,NULL),(1634,132,18,224,NULL),(1635,133,18,224,NULL),(1636,42,18,220,'ترتيب النباتات'),(1637,131,18,220,NULL),(1638,132,18,220,NULL),(1639,133,18,220,NULL),(1644,45,0,220,'/pub/media/catalog/category/index_1.jpg'),(1645,46,0,220,NULL),(1646,57,0,220,NULL),(1647,60,0,220,NULL),(1648,131,0,220,NULL),(1649,132,0,220,NULL),(1650,133,0,220,NULL),(1652,45,0,224,'/pub/media/catalog/category/2_91cd261056-asket_tee_white_slide_01-original.jpg'),(1653,46,0,224,NULL),(1654,57,0,224,NULL),(1655,60,0,224,NULL),(1656,131,0,224,NULL),(1657,132,0,224,NULL),(1658,133,0,224,NULL);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_varchar_after_insert AFTER INSERT ON catalog_category_entity_varchar FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_varchar_after_update AFTER UPDATE ON catalog_category_entity_varchar FOR EACH ROW
BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`dotzeror`@`localhost`*/ /*!50003 TRIGGER trg_catalog_category_entity_varchar_after_delete AFTER DELETE ON catalog_category_entity_varchar FOR EACH ROW
BEGIN
INSERT IGNORE INTO `catalog_category_flat_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_category_flat_cl`
--

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

--
-- Dumping data for table `catalog_category_flat_cl`
--

INSERT INTO `catalog_category_flat_cl` VALUES (1,1),(2,2),(3,219),(4,219),(5,219),(6,219),(7,219),(8,219),(9,219),(10,219),(11,219),(12,219),(13,219),(14,219),(15,219),(16,219),(17,219),(18,217),(19,217),(20,217),(21,217),(22,217),(23,217),(24,217),(25,217),(26,217),(27,217),(28,217),(29,217),(30,217),(31,217),(32,217),(33,219),(34,218),(35,218),(36,218),(37,218),(38,218),(39,218),(40,218),(41,218),(42,218),(43,218),(44,218),(45,218),(46,218),(47,218),(48,218),(49,219),(50,219),(51,219),(52,219),(53,219),(54,219),(55,219),(56,219),(57,219),(58,219),(59,219),(60,219),(61,219),(62,219),(63,1),(64,2),(65,220),(66,220),(67,220),(68,220),(69,220),(70,220),(71,220),(72,220),(73,220),(74,220),(75,220),(102,218),(103,218),(104,217),(105,217),(106,2),(107,2),(108,2),(109,2),(110,2),(111,2),(112,2),(113,2),(114,2),(115,2),(116,2),(117,2),(118,2),(119,2),(120,2),(121,2),(122,2),(123,2),(124,2),(125,2),(139,1),(140,2),(141,224),(142,224),(143,224),(144,224),(145,224),(146,224),(147,224),(148,224),(149,224),(150,224),(151,224),(152,224),(153,224),(154,224),(155,224),(156,220),(157,220),(158,220),(159,220),(160,92),(161,124),(162,157),(163,189),(164,217),(165,218),(166,219),(167,220),(168,220),(169,220),(170,220),(171,220),(172,220),(173,220),(174,220),(175,220),(176,220),(177,220),(178,220),(179,220),(180,220),(181,224),(182,224),(183,224),(184,224),(185,224),(186,224),(187,224),(188,224),(189,224),(190,224),(191,224),(192,224),(193,224),(194,224),(195,217),(196,218),(197,219),(198,219),(199,220),(200,220),(201,224),(202,224);

--
-- Table structure for table `catalog_category_flat_store_1`
--

CREATE TABLE `catalog_category_flat_store_1` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_1_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_1_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_1_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_1`
--

INSERT INTO `catalog_category_flat_store_1` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,1,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_10`
--

CREATE TABLE `catalog_category_flat_store_10` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_10_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_10_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_10_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_10`
--

INSERT INTO `catalog_category_flat_store_10` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,10,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,10,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,10,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,10,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,10,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,10,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,10,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_11`
--

CREATE TABLE `catalog_category_flat_store_11` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_11_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_11_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_11_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_11`
--

INSERT INTO `catalog_category_flat_store_11` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,11,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,11,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,11,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,11,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,11,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,11,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_12`
--

CREATE TABLE `catalog_category_flat_store_12` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_12_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_12_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_12_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_12`
--

INSERT INTO `catalog_category_flat_store_12` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,12,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,12,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,12,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,12,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,12,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,12,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,12,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_13`
--

CREATE TABLE `catalog_category_flat_store_13` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_13_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_13_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_13_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_13`
--

INSERT INTO `catalog_category_flat_store_13` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,13,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,13,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,13,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,13,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,13,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,13,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_14`
--

CREATE TABLE `catalog_category_flat_store_14` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_14_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_14_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_14_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_14`
--

INSERT INTO `catalog_category_flat_store_14` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,14,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,14,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,14,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,14,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,14,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,14,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_15`
--

CREATE TABLE `catalog_category_flat_store_15` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_15_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_15_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_15_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_15`
--

INSERT INTO `catalog_category_flat_store_15` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,15,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,15,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,15,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,15,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,15,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,15,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,15,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_16`
--

CREATE TABLE `catalog_category_flat_store_16` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_16_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_16_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_16_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_16`
--

INSERT INTO `catalog_category_flat_store_16` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,16,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,16,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,16,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,16,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,16,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,16,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_17`
--

CREATE TABLE `catalog_category_flat_store_17` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'entity_id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'attribute_set_id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'parent_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_17_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_17_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_17_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_17`
--

INSERT INTO `catalog_category_flat_store_17` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,17,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,17,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,17,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,17,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,17,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,17,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,17,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_18`
--

CREATE TABLE `catalog_category_flat_store_18` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_18_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_18_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_18_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_18`
--

INSERT INTO `catalog_category_flat_store_18` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,18,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,18,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'تصاميم الأزهار',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,18,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'باقات',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,18,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'حفلات الزفاف ',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,18,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'ترتيب النباتات',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,18,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'باقات',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_20`
--

CREATE TABLE `catalog_category_flat_store_20` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_20_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_20_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_20_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_20`
--

INSERT INTO `catalog_category_flat_store_20` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,20,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,20,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,20,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,20,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,20,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,20,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,20,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_21`
--

CREATE TABLE `catalog_category_flat_store_21` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_21_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_21_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_21_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_21`
--

INSERT INTO `catalog_category_flat_store_21` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,21,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,21,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,21,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,21,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,21,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,21,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,21,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_22`
--

CREATE TABLE `catalog_category_flat_store_22` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_22_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_22_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_22_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_22`
--

INSERT INTO `catalog_category_flat_store_22` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,22,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,22,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,22,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,22,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,22,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,22,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,22,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_23`
--

CREATE TABLE `catalog_category_flat_store_23` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_23_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_23_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_23_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_23`
--

INSERT INTO `catalog_category_flat_store_23` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,23,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,23,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,23,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,23,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,23,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,23,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,23,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_24`
--

CREATE TABLE `catalog_category_flat_store_24` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_24_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_24_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_24_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_24`
--

INSERT INTO `catalog_category_flat_store_24` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,24,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,24,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,24,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,24,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,24,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,24,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,24,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_25`
--

CREATE TABLE `catalog_category_flat_store_25` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_25_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_25_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_25_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_25`
--

INSERT INTO `catalog_category_flat_store_25` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,25,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,25,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,25,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,25,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,25,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,25,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_26`
--

CREATE TABLE `catalog_category_flat_store_26` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_26_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_26_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_26_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_26`
--

INSERT INTO `catalog_category_flat_store_26` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,26,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,26,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,26,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,26,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,26,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,26,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,26,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_27`
--

CREATE TABLE `catalog_category_flat_store_27` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_27_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_27_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_27_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_27`
--

INSERT INTO `catalog_category_flat_store_27` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,27,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,27,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,27,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,27,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,27,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,27,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_28`
--

CREATE TABLE `catalog_category_flat_store_28` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_28_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_28_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_28_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_28`
--

INSERT INTO `catalog_category_flat_store_28` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,28,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,28,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,28,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,28,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,28,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,28,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,28,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
-- Table structure for table `catalog_category_flat_store_29`
--

CREATE TABLE `catalog_category_flat_store_29` (
  `entity_id` int(10) unsigned NOT NULL 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_id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'created_at',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'updated_at',
  `path` varchar(255) NOT NULL DEFAULT '' COMMENT 'path',
  `position` int(11) NOT NULL COMMENT 'position',
  `level` int(11) NOT NULL DEFAULT '0' COMMENT 'level',
  `children_count` int(11) NOT NULL COMMENT 'children_count',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `all_children` text COMMENT 'All Children',
  `available_sort_by` text COMMENT 'Available Product Listing Sort By',
  `children` text COMMENT 'Children',
  `custom_apply_to_products` int(11) DEFAULT NULL COMMENT 'Apply To Products',
  `custom_design` varchar(255) DEFAULT NULL COMMENT 'Custom Design',
  `custom_design_from` datetime DEFAULT NULL COMMENT 'Active From',
  `custom_design_to` datetime DEFAULT NULL COMMENT 'Active To',
  `custom_layout_update` text COMMENT 'Custom Layout Update',
  `custom_layout_update_file` varchar(255) DEFAULT NULL COMMENT 'Custom Layout Update',
  `custom_use_parent_settings` int(11) DEFAULT NULL COMMENT 'Use Parent Category Settings',
  `default_sort_by` varchar(255) DEFAULT NULL COMMENT 'Default Product Listing Sort By',
  `description` text COMMENT 'Description',
  `display_mode` varchar(255) DEFAULT NULL COMMENT 'Display Mode',
  `filter_price_range` decimal(12,4) DEFAULT NULL COMMENT 'Layered Navigation Price Step',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `include_in_menu` int(11) DEFAULT NULL COMMENT 'Include in Navigation Menu',
  `is_active` int(11) DEFAULT NULL COMMENT 'Is Active',
  `is_anchor` int(11) DEFAULT NULL COMMENT 'Is Anchor',
  `landing_page` int(11) DEFAULT NULL COMMENT 'CMS Block',
  `magic_image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Label',
  `magic_thumbnail` varchar(255) DEFAULT NULL COMMENT 'Thumbnail',
  `meta_description` text COMMENT 'Meta Description',
  `meta_keywords` text COMMENT 'Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `path_in_store` text COMMENT 'Path In Store',
  `url_key` varchar(255) DEFAULT NULL COMMENT 'URL Key',
  `url_path` varchar(255) DEFAULT NULL COMMENT 'Url Path',
  PRIMARY KEY (`entity_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_29_TMP_STORE_ID` (`store_id`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_29_TMP_PATH` (`path`),
  KEY `CATALOG_CATEGORY_FLAT_STORE_29_TMP_LEVEL` (`level`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Flat';

--
-- Dumping data for table `catalog_category_flat_store_29`
--

INSERT INTO `catalog_category_flat_store_29` VALUES (1,0,0,'2016-04-04 15:47:43','2021-08-30 18:56:00','1',0,0,10,29,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Root Catalog',NULL,NULL,NULL,NULL),(2,3,1,'2016-04-04 15:47:45','2021-08-30 18:56:00','1/2',1,1,5,29,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,1,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Default',NULL,NULL,'packages',NULL),(217,3,2,'2021-08-22 08:18:27','2021-08-31 08:22:53','1/2/217',1,2,0,29,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Floral designs ',NULL,NULL,'floral','floral'),(218,3,2,'2021-08-22 08:18:49','2021-08-31 08:23:05','1/2/218',2,2,0,29,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Bouquets',NULL,NULL,'bouquets','bouquets'),(219,3,2,'2021-08-24 20:05:01','2021-08-31 08:23:21','1/2/219',3,2,0,29,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Orchidaceae weddings',NULL,NULL,'flowers','flowers'),(220,3,2,'2021-08-30 18:52:37','2021-08-31 08:23:33','1/2/220',4,2,0,29,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Plant arrangements',NULL,NULL,'plant-arrangements','plant-arrangements'),(224,3,2,'2021-08-30 18:56:00','2021-08-31 08:23:47','1/2/224',5,2,0,29,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,'PRODUCTS',NULL,NULL,0,1,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'Packages',NULL,NULL,'packagesshop','packagesshop');

--
