--
-- Host: localhost    Database: jflexy
-- ------------------------------------------------------


--
-- Table structure for table `admin_adobe_ims_webapi`
--

CREATE TABLE `admin_adobe_ims_webapi` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `admin_user_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Admin User Id',
  `access_token_hash` varchar(255) DEFAULT NULL COMMENT 'Access Token Hash',
  `access_token` text COMMENT 'Access 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',
  `last_check_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Last check time',
  `access_token_expires_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Access Token Expires At',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ADMIN_ADOBE_IMS_WEBAPI_ACCESS_TOKEN_HASH` (`access_token_hash`),
  KEY `ADMIN_ADOBE_IMS_WEBAPI_ADMIN_USER_ID` (`admin_user_id`),
  CONSTRAINT `ADMIN_ADOBE_IMS_WEBAPI_ADMIN_USER_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_user_id`) REFERENCES `admin_user` (`user_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Admin Adobe IMS Webapi';

--
-- Dumping data for table `admin_adobe_ims_webapi`
--


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

CREATE TABLE `admin_analytics_usage_version_log` (
  `id` int 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=utf8mb3 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.4.7-p3');

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

CREATE TABLE `admin_passwords` (
  `password_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Password ID',
  `user_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'User ID',
  `password_hash` varchar(255) DEFAULT NULL COMMENT 'Password Hash',
  `expires` int unsigned NOT NULL DEFAULT '0' COMMENT 'Deprecated',
  `last_updated` int 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=3 DEFAULT CHARSET=utf8mb3 COMMENT='Admin Passwords';

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

INSERT INTO `admin_passwords` VALUES (1,1,'8e53084487ba8155f6fc55b4af96b577d9b51cc0195694693dcd8a45924b6c40:i7tpq95n2w9YOFZ7hf3rYD579f970UCu:3_32_2_67108864',0,1738820352),(2,1,'5d62265cec67d4b8a3bdbca22b4fccd5110e21b5dc41e6b92171a70ea4ce0c90:lsIQt4e5hST7Wx9Xxpj86VwfT6wYLakC:3_32_2_67108864',0,1739532126);

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

CREATE TABLE `admin_system_messages` (
  `identity` varchar(100) NOT NULL COMMENT 'Message ID',
  `severity` smallint 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=utf8mb3 COMMENT='Admin System Messages';

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


--
-- Table structure for table `admin_user`
--

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

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

INSERT INTO `admin_user` VALUES (1,'admin','admin','sandeep@trailzyztech.com','admin','5d62265cec67d4b8a3bdbca22b4fccd5110e21b5dc41e6b92171a70ea4ce0c90:lsIQt4e5hST7Wx9Xxpj86VwfT6wYLakC:3_32_2_67108864','2025-02-06 05:39:12','2025-03-22 07:05:14','2025-03-22 07:05:14',36,0,1,'{\"configState\":{\"porto_settings_newsletter\":\"0\",\"porto_settings_general\":\"0\",\"porto_settings_optimization\":\"1\",\"porto_settings_header\":\"0\",\"porto_settings_footer\":\"0\",\"porto_settings_category\":\"0\",\"porto_settings_category_grid\":\"0\",\"porto_settings_product\":\"0\",\"porto_settings_richsnippets\":\"0\",\"porto_settings_product_label\":\"0\",\"porto_settings_contacts\":\"0\",\"porto_settings_custom_settings\":\"0\",\"porto_settings_install\":\"0\",\"sw_megamenu_custom_links\":\"1\",\"sw_megamenu_general\":\"1\",\"sw_megamenu_cat_labels\":\"1\",\"system_currency\":\"0\",\"system_adminnotification\":\"0\",\"system_adobe_stock_integration\":\"0\",\"system_smtp\":\"0\",\"currency_options\":\"1\",\"currency_fixerio\":\"0\",\"currency_fixerio_apilayer\":\"0\",\"currency_currencyconverterapi\":\"0\",\"currency_import\":\"0\",\"web_default\":\"0\",\"web_unsecure\":\"0\",\"web_seo\":\"0\",\"web_url\":\"0\",\"catalog_seo\":\"0\",\"catalog_fields_masks\":\"0\",\"catalog_frontend\":\"0\",\"catalog_review\":\"0\",\"catalog_productalert\":\"0\",\"catalog_productalert_cron\":\"0\",\"catalog_placeholder\":\"1\",\"catalog_recently_products\":\"0\",\"catalog_product_video\":\"0\",\"catalog_price\":\"0\",\"catalog_layered_navigation\":\"0\",\"catalog_search\":\"0\",\"catalog_navigation\":\"0\",\"catalog_downloadable\":\"0\",\"catalog_custom_options\":\"0\",\"payment_us_cashondelivery\":\"1\",\"payment_us_account\":\"1\",\"payment_us_recommended_solutions\":\"1\",\"payment_us_other_paypal_payment_solutions\":\"0\",\"payment_us_paypal_group_all_in_one\":\"1\",\"payment_us_paypal_payment_gateways\":\"1\",\"payment_us_other_payment_methods\":\"1\",\"payment_us_free\":\"0\",\"payment_us_checkmo\":\"0\",\"payment_us_banktransfer\":\"0\",\"payment_us_purchaseorder\":\"0\",\"system_mysqlmq\":\"0\",\"system_cron\":\"1\",\"system_security\":\"0\",\"system_backup\":\"0\",\"system_full_page_cache\":\"0\",\"system_bulk\":\"0\",\"system_media_storage_configuration\":\"0\",\"system_upload_configuration\":\"0\",\"system_media_gallery\":\"0\",\"system_media_gallery_renditions\":\"0\",\"sw_socialfeeds_instagram_photos\":\"1\",\"sw_socialfeeds_flickr_photos\":\"0\",\"sw_socialfeeds_facebook_fanbox\":\"0\",\"mpsearch_general\":\"1\",\"mpsearch_algolia_search\":\"0\",\"quickrfq_option\":\"1\",\"quickrfq_email\":\"1\",\"quickrfq_upload\":\"1\",\"quickrfq_google_options\":\"1\",\"quickrfq_quote_process\":\"1\"}}',NULL,NULL,'en_US',0,NULL,NULL);

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

CREATE TABLE `admin_user_expiration` (
  `user_id` int unsigned NOT NULL COMMENT 'User ID',
  `expires_at` datetime 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=utf8mb3 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 unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `session_id` varchar(1) DEFAULT NULL COMMENT 'Deprecated: Session ID value no longer used',
  `user_id` int unsigned DEFAULT NULL COMMENT 'Admin User ID',
  `status` smallint 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=37 DEFAULT CHARSET=utf8mb3 COMMENT='Admin User sessions table';

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

INSERT INTO `admin_user_session` VALUES (27,NULL,1,2,'2025-03-05 07:25:20','2025-03-05 08:10:33','127.0.0.1'),(28,NULL,1,2,'2025-03-05 08:10:33','2025-03-05 08:45:36','127.0.0.1'),(29,NULL,1,2,'2025-03-05 08:45:36','2025-03-06 07:00:09','127.0.0.1'),(30,NULL,1,1,'2025-03-06 07:00:09','2025-03-06 07:15:29','127.0.0.1'),(31,NULL,1,1,'2025-03-10 05:35:30','2025-03-10 05:35:30','127.0.0.1'),(32,NULL,1,2,'2025-03-11 13:16:47','2025-03-11 14:10:28','127.0.0.1'),(33,NULL,1,2,'2025-03-11 14:10:28','2025-03-11 14:53:31','127.0.0.1'),(34,NULL,1,1,'2025-03-11 14:53:31','2025-03-11 15:51:08','127.0.0.1'),(35,NULL,1,1,'2025-03-19 08:23:56','2025-03-19 08:24:47','127.0.0.1'),(36,NULL,1,1,'2025-03-22 07:05:15','2025-03-22 07:06:02','127.0.0.1');

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

CREATE TABLE `adminnotification_inbox` (
  `notification_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Notification ID',
  `severity` smallint 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 unsigned NOT NULL DEFAULT '0' COMMENT 'Flag if notification read',
  `is_remove` smallint 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=2 DEFAULT CHARSET=utf8mb3 COMMENT='Adminnotification Inbox';

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

INSERT INTO `adminnotification_inbox` VALUES (1,4,'2025-02-06 05:39:10','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);

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

CREATE TABLE `adobe_stock_asset` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `media_gallery_id` int unsigned DEFAULT NULL COMMENT 'Media gallery ID',
  `category_id` int unsigned DEFAULT NULL COMMENT 'Category ID',
  `creator_id` int unsigned DEFAULT NULL COMMENT 'Creator ID',
  `is_licensed` int 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=utf8mb3 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 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=utf8mb3 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 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=utf8mb3 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 unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `admin_user_id` int 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_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=utf8mb3 COMMENT='Adobe IMS User Profile';

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


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

CREATE TABLE `authorization_role` (
  `role_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Role ID',
  `parent_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Parent Role ID',
  `tree_level` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Role Tree Level',
  `sort_order` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Role Sort Order',
  `role_type` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Role Type',
  `user_id` int 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=5 DEFAULT CHARSET=utf8mb3 COMMENT='Admin Role Table';

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

INSERT INTO `authorization_role` VALUES (1,0,1,1,'G',0,'2','Administrators'),(3,1,2,0,'U',1,'2','admin'),(4,0,1,0,'U',1,'1','11');

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

CREATE TABLE `authorization_rule` (
  `rule_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule ID',
  `role_id` int 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=572 DEFAULT CHARSET=utf8mb3 COMMENT='Admin Rule Table';

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

INSERT INTO `authorization_rule` VALUES (1,1,'Magento_Backend::all',NULL,'allow'),(287,4,'Magento_Backend::all',NULL,'deny'),(288,4,'Magento_Backend::admin',NULL,'allow'),(289,4,'Magento_Backend::dashboard',NULL,'deny'),(290,4,'Magento_Analytics::analytics',NULL,'allow'),(291,4,'Magento_Analytics::analytics_api',NULL,'allow'),(292,4,'Magento_Sales::sales',NULL,'deny'),(293,4,'Magento_Sales::sales_operation',NULL,'deny'),(294,4,'Magento_Sales::sales_order',NULL,'deny'),(295,4,'Magento_Sales::actions',NULL,'deny'),(296,4,'Magento_Sales::create',NULL,'deny'),(297,4,'Magento_PaymentServicesPaypal::ordercreate',NULL,'deny'),(298,4,'Magento_Sales::actions_view',NULL,'deny'),(299,4,'Magento_Sales::email',NULL,'deny'),(300,4,'Magento_Sales::reorder',NULL,'deny'),(301,4,'Magento_Sales::actions_edit',NULL,'deny'),(302,4,'Magento_Sales::cancel',NULL,'deny'),(303,4,'Magento_Sales::review_payment',NULL,'deny'),(304,4,'Magento_Sales::capture',NULL,'deny'),(305,4,'Magento_Sales::invoice',NULL,'deny'),(306,4,'Magento_Sales::creditmemo',NULL,'deny'),(307,4,'Magento_Sales::hold',NULL,'deny'),(308,4,'Magento_Sales::unhold',NULL,'deny'),(309,4,'Magento_Sales::ship',NULL,'deny'),(310,4,'Magento_Sales::comment',NULL,'deny'),(311,4,'Magento_Sales::emails',NULL,'deny'),(312,4,'Magento_Paypal::authorization',NULL,'deny'),(313,4,'Magento_PaymentServicesDashboard::paymentservices',NULL,'deny'),(314,4,'Magento_PaymentServicesDashboard::paymentservicesdashboard',NULL,'deny'),(315,4,'Magento_ServiceProxy::services',NULL,'deny'),(316,4,'Magento_Sales::sales_invoice',NULL,'deny'),(317,4,'Magento_Sales::shipment',NULL,'deny'),(318,4,'Magento_Sales::sales_creditmemo',NULL,'deny'),(319,4,'Magento_Paypal::billing_agreement',NULL,'deny'),(320,4,'Magento_Paypal::billing_agreement_actions',NULL,'deny'),(321,4,'Magento_Paypal::billing_agreement_actions_view',NULL,'deny'),(322,4,'Magento_Paypal::actions_manage',NULL,'deny'),(323,4,'Magento_Paypal::use',NULL,'deny'),(324,4,'Magento_Sales::transactions',NULL,'deny'),(325,4,'Magento_Sales::transactions_fetch',NULL,'deny'),(326,4,'Magento_Catalog::catalog',NULL,'deny'),(327,4,'Magento_Catalog::catalog_inventory',NULL,'deny'),(328,4,'Magento_Catalog::products',NULL,'deny'),(329,4,'Magento_Catalog::update_attributes',NULL,'deny'),(330,4,'Magento_Catalog::edit_product_design',NULL,'deny'),(331,4,'Magento_Catalog::categories',NULL,'deny'),(332,4,'Magento_Catalog::edit_category_design',NULL,'deny'),(333,4,'Magento_Customer::customer',NULL,'deny'),(334,4,'Magento_Customer::manage',NULL,'deny'),(335,4,'Magento_Customer::actions',NULL,'deny'),(336,4,'Magento_Customer::delete',NULL,'deny'),(337,4,'Magento_Customer::reset_password',NULL,'deny'),(338,4,'Magento_Customer::invalidate_tokens',NULL,'deny'),(339,4,'Magento_LoginAsCustomer::allow_shopping_assistance',NULL,'deny'),(340,4,'Magento_Customer::online',NULL,'deny'),(341,4,'Magento_Customer::group',NULL,'deny'),(342,4,'Magento_LoginAsCustomer::login',NULL,'deny'),(343,4,'Magento_LoginAsCustomerLog::login_log',NULL,'deny'),(344,4,'Magento_Cart::cart',NULL,'deny'),(345,4,'Magento_Cart::manage',NULL,'deny'),(346,4,'Smartwave_Dailydeals::dailydeals',NULL,'deny'),(347,4,'Smartwave_Dailydeals::dailydeal',NULL,'deny'),(348,4,'Magento_Backend::myaccount',NULL,'deny'),(349,4,'Magento_Backend::marketing',NULL,'deny'),(350,4,'Magento_CatalogRule::promo',NULL,'deny'),(351,4,'Magento_CatalogRule::promo_catalog',NULL,'deny'),(352,4,'Magento_SalesRule::quote',NULL,'deny'),(353,4,'Magento_Backend::marketing_communications',NULL,'deny'),(354,4,'Magento_Email::template',NULL,'deny'),(355,4,'Magento_Newsletter::template',NULL,'deny'),(356,4,'Magento_Newsletter::queue',NULL,'deny'),(357,4,'Magento_Newsletter::subscriber',NULL,'deny'),(358,4,'Magento_Backend::marketing_seo',NULL,'deny'),(359,4,'Magento_Search::search',NULL,'deny'),(360,4,'Magento_Search::synonyms',NULL,'deny'),(361,4,'Magento_UrlRewrite::urlrewrite',NULL,'deny'),(362,4,'Magento_Sitemap::sitemap',NULL,'deny'),(363,4,'Magento_Backend::marketing_user_content',NULL,'deny'),(364,4,'Magento_Review::reviews_all',NULL,'deny'),(365,4,'Magento_Review::pending',NULL,'deny'),(366,4,'Mageplaza_Core::menu',NULL,'deny'),(367,4,'Mageplaza_Core::documentation',NULL,'deny'),(368,4,'Mageplaza_Core::userguide',NULL,'deny'),(369,4,'Mageplaza_Core::activate',NULL,'deny'),(370,4,'Magento_Backend::content',NULL,'deny'),(371,4,'Magento_Backend::content_elements',NULL,'deny'),(372,4,'Magento_Cms::page',NULL,'deny'),(373,4,'Magento_Cms::save',NULL,'deny'),(374,4,'Magento_Cms::save_design',NULL,'deny'),(375,4,'Magento_Cms::page_delete',NULL,'deny'),(376,4,'Magento_Cms::block',NULL,'deny'),(377,4,'Magento_Widget::widget_instance',NULL,'deny'),(378,4,'Magento_Cms::media_gallery',NULL,'deny'),(379,4,'Magento_MediaGalleryUiApi::insert_assets',NULL,'deny'),(380,4,'Magento_MediaGalleryUiApi::upload_assets',NULL,'deny'),(381,4,'Magento_MediaGalleryUiApi::edit_assets',NULL,'deny'),(382,4,'Magento_AdobeStockImageAdminUi::media_gallery',NULL,'deny'),(383,4,'Magento_AdobeStockImageAdminUi::save_preview_images',NULL,'deny'),(384,4,'Magento_AdobeStockImageAdminUi::license_images',NULL,'deny'),(385,4,'Magento_MediaGalleryUiApi::delete_assets',NULL,'deny'),(386,4,'Magento_MediaGalleryUiApi::create_folder',NULL,'deny'),(387,4,'Magento_MediaGalleryUiApi::delete_folder',NULL,'deny'),(388,4,'Magento_PageBuilder::templates',NULL,'deny'),(389,4,'Magento_PageBuilder::template_save',NULL,'deny'),(390,4,'Magento_PageBuilder::template_apply',NULL,'deny'),(391,4,'Magento_PageBuilder::template_delete',NULL,'deny'),(392,4,'Magento_Backend::design',NULL,'deny'),(393,4,'Magento_Theme::theme',NULL,'deny'),(394,4,'Magento_Backend::schedule',NULL,'deny'),(395,4,'Magento_Backend::content_translation',NULL,'deny'),(396,4,'Magento_Reports::report',NULL,'deny'),(397,4,'Magento_Reports::report_marketing',NULL,'deny'),(398,4,'Magento_Reports::shopcart',NULL,'deny'),(399,4,'Magento_Reports::product',NULL,'deny'),(400,4,'Magento_Reports::abandoned',NULL,'deny'),(401,4,'Magento_Reports::report_search',NULL,'deny'),(402,4,'Magento_Newsletter::problem',NULL,'deny'),(403,4,'Magento_Reports::review',NULL,'deny'),(404,4,'Magento_Reports::review_customer',NULL,'deny'),(405,4,'Magento_Reports::review_product',NULL,'deny'),(406,4,'Magento_Reports::salesroot',NULL,'deny'),(407,4,'Magento_Reports::salesroot_sales',NULL,'deny'),(408,4,'Magento_Reports::tax',NULL,'deny'),(409,4,'Magento_Reports::invoiced',NULL,'deny'),(410,4,'Magento_Reports::shipping',NULL,'deny'),(411,4,'Magento_Reports::refunded',NULL,'deny'),(412,4,'Magento_Reports::coupons',NULL,'deny'),(413,4,'Magento_Paypal::paypal_settlement_reports',NULL,'deny'),(414,4,'Magento_Paypal::paypal_settlement_reports_view',NULL,'deny'),(415,4,'Magento_Paypal::fetch',NULL,'deny'),(416,4,'PayPal_Braintree::settlement_report',NULL,'deny'),(417,4,'Magento_Reports::customers',NULL,'deny'),(418,4,'Magento_Reports::totals',NULL,'deny'),(419,4,'Magento_Reports::customers_orders',NULL,'deny'),(420,4,'Magento_Reports::accounts',NULL,'deny'),(421,4,'Magento_Reports::report_products',NULL,'deny'),(422,4,'Magento_Reports::viewed',NULL,'deny'),(423,4,'Magento_Reports::bestsellers',NULL,'deny'),(424,4,'Magento_Reports::lowstock',NULL,'deny'),(425,4,'Magento_Reports::sold',NULL,'deny'),(426,4,'Magento_Reports::downloads',NULL,'deny'),(427,4,'Magento_Reports::statistics',NULL,'deny'),(428,4,'Magento_Reports::statistics_refresh',NULL,'deny'),(429,4,'Magento_Analytics::business_intelligence',NULL,'deny'),(430,4,'Magento_Analytics::advanced_reporting',NULL,'deny'),(431,4,'Magento_Analytics::bi_essentials',NULL,'deny'),(432,4,'Magento_Backend::stores',NULL,'deny'),(433,4,'Magento_Backend::stores_settings',NULL,'deny'),(434,4,'Magento_Backend::store',NULL,'deny'),(435,4,'Magento_Config::config',NULL,'deny'),(436,4,'Magento_Cms::config_cms',NULL,'deny'),(437,4,'Magento_Catalog::config_catalog',NULL,'deny'),(438,4,'Magento_CatalogInventory::cataloginventory',NULL,'deny'),(439,4,'Magento_Payment::payment',NULL,'deny'),(440,4,'Magento_Payment::payment_services',NULL,'deny'),(441,4,'Magento_Contact::contact',NULL,'deny'),(442,4,'Magento_Downloadable::downloadable',NULL,'deny'),(443,4,'Magento_Newsletter::newsletter',NULL,'deny'),(444,4,'Magento_GoogleAnalytics::google',NULL,'deny'),(445,4,'Magento_LoginAsCustomer::config_section',NULL,'deny'),(446,4,'Mageplaza_LayeredNavigation::configuration',NULL,'deny'),(447,4,'Mageplaza_Search::configuration',NULL,'deny'),(448,4,'Smartwave_Dailydeals::dailydeals_config',NULL,'deny'),(449,4,'Smartwave_Porto::theme_settings',NULL,'deny'),(450,4,'Smartwave_Porto::theme_design',NULL,'deny'),(451,4,'Smartwave_Porto::activation',NULL,'deny'),(452,4,'Magento_Shipping::carriers',NULL,'deny'),(453,4,'Magento_InventoryInStorePickupApi::inStorePickup',NULL,'deny'),(454,4,'Magento_InventoryInStorePickupApi::notify_orders_are_ready_for_pickup',NULL,'deny'),(455,4,'Magento_Shipping::config_shipping',NULL,'deny'),(456,4,'Magento_Multishipping::config_multishipping',NULL,'deny'),(457,4,'Magento_ReCaptchaUi::config',NULL,'deny'),(458,4,'Magento_Securitytxt::config',NULL,'deny'),(459,4,'Mageplaza_Core::configuration',NULL,'deny'),(460,4,'Mageplaza_Core::marketplace',NULL,'deny'),(461,4,'Magento_Config::config_general',NULL,'deny'),(462,4,'Magento_Integration::config_oauth',NULL,'deny'),(463,4,'Magento_Webapi::config_webapi',NULL,'deny'),(464,4,'Magento_Config::web',NULL,'deny'),(465,4,'Magento_Config::config_design',NULL,'deny'),(466,4,'Magento_Customer::config_customer',NULL,'deny'),(467,4,'Magento_Paypal::paypal',NULL,'deny'),(468,4,'Magento_Tax::config_tax',NULL,'deny'),(469,4,'Magento_Checkout::checkout',NULL,'deny'),(470,4,'Magento_Sales::config_sales',NULL,'deny'),(471,4,'Magento_Persistent::persistent',NULL,'deny'),(472,4,'Magento_Sales::sales_email',NULL,'deny'),(473,4,'Magento_Sales::sales_pdf',NULL,'deny'),(474,4,'Magento_Reports::reports',NULL,'deny'),(475,4,'Magento_Sitemap::config_sitemap',NULL,'deny'),(476,4,'Magento_Config::config_system',NULL,'deny'),(477,4,'Magento_Wishlist::config_wishlist',NULL,'deny'),(478,4,'Magento_SalesRule::config_promo',NULL,'deny'),(479,4,'Magento_Config::config_admin',NULL,'deny'),(480,4,'Magento_Config::trans_email',NULL,'deny'),(481,4,'Magento_Config::dev',NULL,'deny'),(482,4,'Magento_Config::currency',NULL,'deny'),(483,4,'Magento_Rss::rss',NULL,'deny'),(484,4,'Magento_Config::sendfriend',NULL,'deny'),(485,4,'Magento_Csp::config',NULL,'deny'),(486,4,'Magento_Analytics::analytics_settings',NULL,'deny'),(487,4,'Magento_NewRelicReporting::config_newrelicreporting',NULL,'deny'),(488,4,'Magento_CheckoutAgreements::checkoutagreement',NULL,'deny'),(489,4,'Magento_Sales::order_statuses',NULL,'deny'),(490,4,'Magento_InventoryApi::inventory',NULL,'deny'),(491,4,'Magento_InventoryApi::source',NULL,'deny'),(492,4,'Magento_InventoryApi::source_edit',NULL,'deny'),(493,4,'Magento_InventoryApi::ship_source_selection',NULL,'deny'),(494,4,'Magento_InventorySourceSelectionApi::source_selection_algorithm',NULL,'deny'),(495,4,'Magento_InventorySourceSelectionApi::source_selection_algorithm_post',NULL,'deny'),(496,4,'Magento_InventoryApi::stock',NULL,'deny'),(497,4,'Magento_InventoryApi::stock_edit',NULL,'deny'),(498,4,'Magento_InventoryApi::stock_delete',NULL,'deny'),(499,4,'Magento_InventoryLowQuantityNotificationApi::low_quantity_notification',NULL,'deny'),(500,4,'Magento_InventoryLowQuantityNotificationApi::stock_create_low_quantity_notification',NULL,'deny'),(501,4,'Magento_InventoryLowQuantityNotificationApi::stock_delete_low_quantity_notification',NULL,'deny'),(502,4,'Magento_InventoryApi::stock_source_link',NULL,'deny'),(503,4,'Magento_InventoryApi::stock_source_item_assign',NULL,'deny'),(504,4,'Magento_InventorySalesApi::stock',NULL,'deny'),(505,4,'Magento_Tax::manage_tax',NULL,'deny'),(506,4,'Magento_CurrencySymbol::system_currency',NULL,'deny'),(507,4,'Magento_CurrencySymbol::currency_rates',NULL,'deny'),(508,4,'Magento_CurrencySymbol::symbols',NULL,'deny'),(509,4,'Magento_Backend::stores_attributes',NULL,'deny'),(510,4,'Magento_Catalog::attributes_attributes',NULL,'deny'),(511,4,'Magento_Catalog::sets',NULL,'deny'),(512,4,'Magento_Review::ratings',NULL,'deny'),(513,4,'Magento_Swatches::iframe',NULL,'deny'),(514,4,'Magento_Backend::stores_other_settings',NULL,'deny'),(515,4,'Magento_Backend::system',NULL,'deny'),(516,4,'Magento_AdobeIms::adobe_ims',NULL,'deny'),(517,4,'Magento_AdobeIms::actions',NULL,'deny'),(518,4,'Magento_AdobeIms::login',NULL,'deny'),(519,4,'Magento_AdobeIms::logout',NULL,'deny'),(520,4,'Magento_AdobeStockAsset::adobe_stock_asset',NULL,'deny'),(521,4,'Magento_AdobeStockAsset::actions',NULL,'deny'),(522,4,'Magento_AdobeStockAsset::actions_delete',NULL,'deny'),(523,4,'Magento_AdobeStockAsset::actions_save',NULL,'deny'),(524,4,'Magento_AdobeStockAsset::actions_view',NULL,'deny'),(525,4,'Magento_AdobeStockAsset::actions_get',NULL,'deny'),(526,4,'Magento_Backend::convert',NULL,'deny'),(527,4,'Magento_ImportExport::import',NULL,'deny'),(528,4,'Magento_ImportExport::export',NULL,'deny'),(529,4,'Magento_TaxImportExport::import_export',NULL,'deny'),(530,4,'Magento_ImportExport::history',NULL,'deny'),(531,4,'Magento_Backend::extensions',NULL,'deny'),(532,4,'Magento_Backend::local',NULL,'deny'),(533,4,'Magento_Backend::custom',NULL,'deny'),(534,4,'Magento_GraphQlServer::admin_graphql',NULL,'deny'),(535,4,'Magento_Integration::extensions',NULL,'deny'),(536,4,'Magento_Integration::integrations',NULL,'deny'),(537,4,'Magento_Backend::tools',NULL,'deny'),(538,4,'Magento_Backend::cache',NULL,'deny'),(539,4,'Magento_Backend::main_actions',NULL,'deny'),(540,4,'Magento_Backend::flush_cache_storage',NULL,'deny'),(541,4,'Magento_Backend::flush_magento_cache',NULL,'deny'),(542,4,'Magento_Backend::mass_actions',NULL,'deny'),(543,4,'Magento_Backend::toggling_cache_type',NULL,'deny'),(544,4,'Magento_Backend::refresh_cache_type',NULL,'deny'),(545,4,'Magento_Backend::additional_cache_management',NULL,'deny'),(546,4,'Magento_Backend::flush_catalog_images',NULL,'deny'),(547,4,'Magento_Backend::flush_js_css',NULL,'deny'),(548,4,'Magento_Backend::flush_static_files',NULL,'deny'),(549,4,'Magento_Backup::backup',NULL,'deny'),(550,4,'Magento_Backup::rollback',NULL,'deny'),(551,4,'Magento_Indexer::index',NULL,'deny'),(552,4,'Magento_Indexer::changeMode',NULL,'deny'),(553,4,'Magento_Indexer::invalidate',NULL,'deny'),(554,4,'Magento_User::acl',NULL,'deny'),(555,4,'Magento_User::acl_users',NULL,'deny'),(556,4,'Magento_User::locks',NULL,'deny'),(557,4,'Magento_User::acl_roles',NULL,'deny'),(558,4,'Magento_Logging::magento_logging',NULL,'deny'),(559,4,'Magento_Logging::magento_logging_events',NULL,'deny'),(560,4,'Magento_Logging::system_magento_logging_bulk_operations',NULL,'deny'),(561,4,'Magento_Backend::system_other_settings',NULL,'deny'),(562,4,'Magento_AdminNotification::adminnotification',NULL,'deny'),(563,4,'Magento_AdminNotification::show_toolbar',NULL,'deny'),(564,4,'Magento_AdminNotification::show_list',NULL,'deny'),(565,4,'Magento_AdminNotification::mark_as_read',NULL,'deny'),(566,4,'Magento_AdminNotification::adminnotification_remove',NULL,'deny'),(567,4,'Magento_Variable::variable',NULL,'deny'),(568,4,'Magento_EncryptionKey::crypt_key',NULL,'deny'),(569,4,'Magento_ServicesId::services',NULL,'deny'),(570,4,'Magento_ServicesId::configuration',NULL,'deny'),(571,4,'Magento_Backend::global_search',NULL,'deny');

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

CREATE TABLE `braintree_credit_prices` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row ID',
  `product_id` int unsigned NOT NULL COMMENT 'Product Id',
  `term` int 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=utf8mb3 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 unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `order_id` int 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=utf8mb3 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 DEFAULT NULL COMMENT 'Cache Creation Time',
  `update_time` int DEFAULT NULL COMMENT 'Time of Cache Updating',
  `expire_time` int DEFAULT NULL COMMENT 'Cache Expiration Time',
  PRIMARY KEY (`id`),
  KEY `CACHE_EXPIRE_TIME` (`expire_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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=utf8mb3 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 unsigned NOT NULL DEFAULT '0' COMMENT 'Count',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`type`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Count Login Attempts';

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


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

CREATE TABLE `catalog_category_entity` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `attribute_set_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `parent_id` int 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 NOT NULL COMMENT 'Position',
  `level` int NOT NULL DEFAULT '0' COMMENT 'Tree Level',
  `children_count` int 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=25 DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Category Table';

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

INSERT INTO `catalog_category_entity` VALUES (1,3,0,'2025-02-06 05:39:05','2025-02-28 08:45:28','1',0,0,23),(2,3,1,'2025-02-06 05:39:05','2025-02-28 08:45:28','1/2',1,1,22),(3,3,2,'2025-02-14 11:26:02','2025-02-14 11:26:02','1/2/3',1,2,0),(4,3,2,'2025-02-14 11:26:21','2025-02-14 11:26:21','1/2/4',2,2,0),(5,3,2,'2025-02-14 11:39:51','2025-02-14 11:39:51','1/2/5',3,2,0),(6,3,2,'2025-02-14 11:40:08','2025-02-14 11:40:08','1/2/6',4,2,0),(7,3,2,'2025-02-14 11:40:28','2025-02-14 11:40:28','1/2/7',5,2,0),(8,3,2,'2025-02-14 11:40:48','2025-02-14 11:40:48','1/2/8',6,2,0),(9,3,2,'2025-02-14 11:41:18','2025-02-14 11:41:18','1/2/9',7,2,0),(10,3,2,'2025-02-14 11:41:47','2025-02-14 11:41:47','1/2/10',8,2,0),(11,3,2,'2025-02-14 11:42:06','2025-02-14 11:42:06','1/2/11',9,2,0),(12,3,2,'2025-02-14 11:42:45','2025-02-14 11:42:46','1/2/12',10,2,0),(13,3,2,'2025-02-14 11:43:11','2025-02-14 11:43:11','1/2/13',11,2,0),(14,3,2,'2025-02-14 11:43:35','2025-02-14 11:43:35','1/2/14',12,2,0),(15,3,2,'2025-02-14 11:43:57','2025-02-14 11:43:57','1/2/15',13,2,0),(16,3,2,'2025-02-14 11:44:22','2025-02-14 11:44:22','1/2/16',14,2,0),(17,3,2,'2025-02-14 11:51:11','2025-02-14 11:51:11','1/2/17',15,2,0),(18,3,2,'2025-02-14 11:51:35','2025-02-14 12:07:30','1/2/18',16,2,0),(19,3,2,'2025-02-14 11:51:57','2025-02-14 12:07:00','1/2/19',17,2,0),(20,3,2,'2025-02-14 11:52:39','2025-02-14 12:07:44','1/2/20',18,2,0),(21,3,2,'2025-02-28 08:45:28','2025-02-28 08:45:28','1/2/21',19,2,0),(22,3,2,'2025-02-28 08:45:28','2025-02-28 08:45:28','1/2/22',20,2,0),(23,3,2,'2025-02-28 08:45:28','2025-02-28 08:45:28','1/2/23',21,2,0),(24,3,2,'2025-02-28 08:45:28','2025-02-28 08:45:28','1/2/24',22,2,0);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`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`);
END */;;
DELIMITER ;

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

CREATE TABLE `catalog_category_entity_datetime` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int 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 `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,
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_DATETIME_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Category Datetime Attribute Backend Table';

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

INSERT INTO `catalog_category_entity_datetime` VALUES (1,61,0,19,NULL),(2,62,0,19,NULL),(3,61,0,18,NULL),(4,62,0,18,NULL),(5,61,0,20,NULL),(6,62,0,20,NULL);

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

CREATE TABLE `catalog_category_entity_decimal` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int 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 `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,
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_DECIMAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Category Decimal Attribute Backend Table';

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


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

CREATE TABLE `catalog_category_entity_int` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` int 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 `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,
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_INT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=145 DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Category Integer Attribute Backend Table';

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

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

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

CREATE TABLE `catalog_category_entity_text` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` mediumtext 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 `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,
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_TEXT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Category Text Attribute Backend Table';

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

INSERT INTO `catalog_category_entity_text` VALUES (1,47,0,19,NULL),(2,51,0,19,NULL),(3,50,0,19,NULL),(4,137,0,19,NULL),(5,152,0,19,NULL),(6,149,0,19,NULL),(7,151,0,19,NULL),(8,147,0,19,NULL),(9,157,0,19,NULL),(10,47,0,18,NULL),(11,51,0,18,NULL),(12,50,0,18,NULL),(13,137,0,18,NULL),(14,152,0,18,NULL),(15,149,0,18,NULL),(16,151,0,18,NULL),(17,147,0,18,NULL),(18,157,0,18,NULL),(19,47,0,20,NULL),(20,51,0,20,NULL),(21,50,0,20,NULL),(22,137,0,20,NULL),(23,152,0,20,NULL),(24,149,0,20,NULL),(25,151,0,20,NULL),(26,147,0,20,NULL),(27,157,0,20,NULL);

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

CREATE TABLE `catalog_category_entity_varchar` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int 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 `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,
  CONSTRAINT `CATALOG_CATEGORY_ENTITY_VARCHAR_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=184 DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Category Varchar Attribute Backend Table';

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

INSERT INTO `catalog_category_entity_varchar` VALUES (1,45,0,1,'Root Catalog'),(2,52,0,2,'PRODUCTS'),(3,45,0,2,'Default Category'),(4,52,0,3,'PRODUCTS'),(5,45,0,3,'Bags'),(6,63,0,3,'category-full-width'),(7,148,0,3,'0'),(8,150,0,3,'0'),(9,119,0,3,'bags'),(10,120,0,3,'bags'),(11,52,0,4,'PRODUCTS'),(12,45,0,4,'Containers'),(13,63,0,4,'category-full-width'),(14,148,0,4,'0'),(15,150,0,4,'0'),(16,119,0,4,'containers'),(17,120,0,4,'containers'),(18,52,0,5,'PRODUCTS'),(19,45,0,5,'Tape'),(20,63,0,5,'category-full-width'),(21,148,0,5,'0'),(22,150,0,5,'0'),(23,119,0,5,'tape'),(24,120,0,5,'tape'),(25,52,0,6,'PRODUCTS'),(26,45,0,6,'Nano Machine Film'),(27,63,0,6,'category-full-width'),(28,148,0,6,'0'),(29,150,0,6,'0'),(30,119,0,6,'nano-machine-film'),(31,120,0,6,'nano-machine-film'),(32,52,0,7,'PRODUCTS'),(33,45,0,7,'CAST Machine Film'),(34,63,0,7,'category-full-width'),(35,148,0,7,'0'),(36,150,0,7,'0'),(37,119,0,7,'cast-machine-film'),(38,120,0,7,'cast-machine-film'),(39,52,0,8,'PRODUCTS'),(40,45,0,8,'Strap'),(41,63,0,8,'category-full-width'),(42,148,0,8,'0'),(43,150,0,8,'0'),(44,119,0,8,'strap'),(45,120,0,8,'strap'),(46,52,0,9,'PRODUCTS'),(47,45,0,9,'Hand Film'),(48,63,0,9,'category-full-width'),(49,148,0,9,'0'),(50,150,0,9,'0'),(51,119,0,9,'hand-film'),(52,120,0,9,'hand-film'),(53,52,0,10,'PRODUCTS'),(54,45,0,10,'Hand Rolls'),(55,63,0,10,'category-full-width'),(56,148,0,10,'0'),(57,150,0,10,'0'),(58,119,0,10,'hand-rolls'),(59,120,0,10,'hand-rolls'),(60,52,0,11,'PRODUCTS'),(61,45,0,11,'Black Hand Rolls'),(62,63,0,11,'category-full-width'),(63,148,0,11,'0'),(64,150,0,11,'0'),(65,119,0,11,'black-hand-rolls'),(66,120,0,11,'black-hand-rolls'),(67,52,0,12,'PRODUCTS'),(68,45,0,12,'Black CAST Machine Film'),(69,63,0,12,'category-full-width'),(70,148,0,12,'0'),(71,150,0,12,'0'),(72,119,0,12,'black-cast-machine-film'),(73,120,0,12,'black-cast-machine-film'),(74,52,0,13,'PRODUCTS'),(75,45,0,13,'Cling Wrap'),(76,63,0,13,'category-full-width'),(77,148,0,13,'0'),(78,150,0,13,'0'),(79,119,0,13,'cling-wrap'),(80,120,0,13,'cling-wrap'),(81,52,0,14,'PRODUCTS'),(82,45,0,14,'Towels & Napkins'),(83,63,0,14,'category-full-width'),(84,148,0,14,'0'),(85,150,0,14,'0'),(86,119,0,14,'towels-napkins'),(87,120,0,14,'towels-napkins'),(88,52,0,15,'PRODUCTS'),(89,45,0,15,'Cups & Containers'),(90,63,0,15,'category-full-width'),(91,148,0,15,'0'),(92,150,0,15,'0'),(93,119,0,15,'cups-containers'),(94,120,0,15,'cups-containers'),(95,52,0,16,'PRODUCTS'),(96,45,0,16,'Gloves'),(97,63,0,16,'category-full-width'),(98,148,0,16,'0'),(99,150,0,16,'0'),(100,119,0,16,'gloves'),(101,120,0,16,'gloves'),(102,52,0,17,'PRODUCTS'),(103,45,0,17,'PPE'),(104,63,0,17,'category-full-width'),(105,148,0,17,'0'),(106,150,0,17,'0'),(107,119,0,17,'ppe'),(108,120,0,17,'ppe'),(109,52,0,18,'PRODUCTS'),(110,45,0,18,'Others'),(111,63,0,18,'category-full-width'),(112,148,0,18,'0'),(113,150,0,18,'0'),(114,119,0,18,'others'),(115,120,0,18,'others'),(116,52,0,19,'PRODUCTS'),(117,45,0,19,'Toilet Paper & Rolls'),(118,63,0,19,'category-full-width'),(119,148,0,19,'0'),(120,150,0,19,'0'),(121,119,0,19,'toilet-paper-rolls'),(122,120,0,19,'toilet-paper-rolls'),(123,52,0,20,'PRODUCTS'),(124,45,0,20,'Hand Wrap'),(125,63,0,20,'category-full-width'),(126,148,0,20,'0'),(127,150,0,20,'0'),(128,119,0,20,'hand-wrap'),(129,120,0,20,'hand-wrap'),(131,60,0,19,NULL),(132,48,0,19,NULL),(133,49,0,19,NULL),(134,142,0,19,NULL),(135,144,0,19,NULL),(136,143,0,19,NULL),(137,146,0,19,NULL),(138,145,0,19,NULL),(139,141,0,19,NULL),(140,140,0,19,NULL),(141,155,0,19,NULL),(142,156,0,19,NULL),(143,154,0,19,NULL),(145,60,0,18,NULL),(146,48,0,18,NULL),(147,49,0,18,NULL),(148,142,0,18,NULL),(149,144,0,18,NULL),(150,143,0,18,NULL),(151,146,0,18,NULL),(152,145,0,18,NULL),(153,141,0,18,NULL),(154,140,0,18,NULL),(155,155,0,18,NULL),(156,156,0,18,NULL),(157,154,0,18,NULL),(159,60,0,20,NULL),(160,48,0,20,NULL),(161,49,0,20,NULL),(162,142,0,20,NULL),(163,144,0,20,NULL),(164,143,0,20,NULL),(165,146,0,20,NULL),(166,145,0,20,NULL),(167,141,0,20,NULL),(168,140,0,20,NULL),(169,155,0,20,NULL),(170,156,0,20,NULL),(171,154,0,20,NULL),(172,45,0,21,'Black Hand Roll'),(173,119,0,21,'black-hand-roll'),(174,120,0,21,'black-hand-roll'),(175,45,0,22,'Hand Roll'),(176,119,0,22,'hand-roll'),(177,120,0,22,'hand-roll'),(178,45,0,23,'Other'),(179,119,0,23,'other'),(180,120,0,23,'other'),(181,45,0,24,'Container'),(182,119,0,24,'container'),(183,120,0,24,'container');

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

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

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

INSERT INTO `catalog_category_product` VALUES (1,10,1,0),(2,10,2,0),(3,10,3,0),(5,6,4,0),(7,5,5,0),(8,5,6,0),(9,3,7,-1),(10,3,8,-2),(11,3,9,-3),(12,4,10,-1),(13,4,11,-2),(14,5,12,-1),(15,5,13,-2),(16,5,14,-3),(17,5,15,-4),(18,5,16,-5),(19,6,17,-1),(20,6,18,-2),(21,6,19,-3),(22,3,20,-4),(23,3,21,-5),(24,7,22,-1),(25,7,23,-2),(26,8,24,-1),(27,7,25,-3),(28,8,26,-2),(29,9,27,-1),(30,7,28,-4),(31,9,29,-2),(32,7,30,-5),(33,7,31,-6),(34,7,32,-7),(35,11,33,-1),(36,10,34,-1),(37,10,35,-2),(38,7,36,-8),(39,21,37,-1),(40,12,38,-1),(41,22,39,-1),(42,7,40,-9),(43,7,41,-10),(44,13,42,-1),(45,23,43,-1),(46,23,44,-2),(47,3,45,-6),(48,20,46,-1),(49,3,47,-7),(50,3,48,-8),(51,3,49,-9),(52,3,50,-10),(53,13,51,-2),(54,14,52,-1),(55,15,53,-1),(56,15,54,-2),(57,8,55,-3),(58,8,56,-4),(59,15,57,-3),(60,16,58,-1),(61,15,59,-4),(62,15,60,-5),(63,14,61,-2),(64,17,62,-1),(65,16,63,-2),(66,16,64,-3),(67,16,65,-4),(68,16,66,-5),(69,3,67,-11),(70,14,68,-3),(71,8,69,-5),(72,24,70,-1),(73,24,71,-2),(74,19,72,-1),(75,5,73,-6);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_category_product_after_insert` AFTER INSERT ON `catalog_category_product` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`product_id`);
INSERT IGNORE INTO `catalog_product_category_cl` (`entity_id`) VALUES (NEW.`product_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`product_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_category_product_after_update` AFTER UPDATE ON `catalog_category_product` FOR EACH ROW BEGIN
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`category_id` <=> OLD.`category_id`) OR NOT(NEW.`product_id` <=> OLD.`product_id`) OR NOT(NEW.`position` <=> OLD.`position`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`product_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`category_id` <=> OLD.`category_id`) OR NOT(NEW.`product_id` <=> OLD.`product_id`) OR NOT(NEW.`position` <=> OLD.`position`)) THEN INSERT IGNORE INTO `catalog_product_category_cl` (`entity_id`) VALUES (NEW.`product_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`category_id` <=> OLD.`category_id`) OR NOT(NEW.`product_id` <=> OLD.`product_id`) OR NOT(NEW.`position` <=> OLD.`position`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`product_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_category_product_after_delete` AFTER DELETE ON `catalog_category_product` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`product_id`);
INSERT IGNORE INTO `catalog_product_category_cl` (`entity_id`) VALUES (OLD.`product_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`product_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `catalog_category_product_cl`
--

CREATE TABLE `catalog_category_product_cl` (
  `version_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=233 DEFAULT CHARSET=utf8mb3 COMMENT='catalog_category_product_cl';

--
-- Dumping data for table `catalog_category_product_cl`
--

INSERT INTO `catalog_category_product_cl` VALUES (232,24);

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

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

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


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

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

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


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

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

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

INSERT INTO `catalog_category_product_index_store1` VALUES (2,67,-11,1,1,4),(2,41,-10,1,1,4),(2,50,-10,1,1,4),(2,40,-9,1,1,4),(2,49,-9,1,1,4),(2,36,-8,1,1,4),(2,48,-8,1,1,4),(2,32,-7,1,1,4),(2,47,-7,1,1,4),(2,31,-6,1,1,4),(2,45,-6,1,1,4),(2,73,-6,1,1,4),(2,16,-5,1,1,4),(2,21,-5,1,1,4),(2,30,-5,1,1,4),(2,60,-5,1,1,4),(2,66,-5,1,1,4),(2,69,-5,1,1,4),(2,15,-4,1,1,4),(2,20,-4,1,1,4),(2,28,-4,1,1,4),(2,56,-4,1,1,4),(2,59,-4,1,1,4),(2,65,-4,1,1,4),(2,9,-3,1,1,4),(2,14,-3,1,1,4),(2,19,-3,1,1,4),(2,25,-3,1,1,4),(2,55,-3,1,1,4),(2,57,-3,1,1,4),(2,64,-3,1,1,4),(2,68,-3,1,1,4),(2,8,-2,1,1,4),(2,11,-2,1,1,4),(2,13,-2,1,1,4),(2,18,-2,1,1,4),(2,23,-2,1,1,4),(2,26,-2,1,1,4),(2,29,-2,1,1,4),(2,35,-2,1,1,4),(2,44,-2,1,1,4),(2,51,-2,1,1,4),(2,54,-2,1,1,4),(2,61,-2,1,1,4),(2,63,-2,1,1,4),(2,71,-2,1,1,4),(2,7,-1,1,1,4),(2,10,-1,1,1,4),(2,12,-1,1,1,4),(2,17,-1,1,1,4),(2,22,-1,1,1,4),(2,24,-1,1,1,4),(2,27,-1,1,1,4),(2,33,-1,1,1,4),(2,34,-1,1,1,4),(2,37,-1,1,1,4),(2,38,-1,1,1,4),(2,39,-1,1,1,4),(2,42,-1,1,1,4),(2,43,-1,1,1,4),(2,46,-1,1,1,4),(2,52,-1,1,1,4),(2,53,-1,1,1,4),(2,58,-1,1,1,4),(2,62,-1,1,1,4),(2,70,-1,1,1,4),(2,72,-1,1,1,4),(2,1,0,1,1,4),(2,2,0,1,1,4),(2,3,0,1,1,4),(2,4,0,1,1,4),(2,5,0,1,1,4),(2,6,0,1,1,4),(3,67,-11,1,1,4),(3,50,-10,1,1,4),(3,49,-9,1,1,4),(3,48,-8,1,1,4),(3,47,-7,1,1,4),(3,45,-6,1,1,4),(3,21,-5,1,1,4),(3,20,-4,1,1,4),(3,9,-3,1,1,4),(3,8,-2,1,1,4),(3,7,-1,1,1,4),(4,11,-2,1,1,4),(4,10,-1,1,1,4),(5,73,-6,1,1,4),(5,16,-5,1,1,4),(5,15,-4,1,1,4),(5,14,-3,1,1,4),(5,13,-2,1,1,4),(5,12,-1,1,1,4),(5,5,0,1,1,4),(5,6,0,1,1,4),(6,19,-3,1,1,4),(6,18,-2,1,1,4),(6,17,-1,1,1,4),(6,4,0,1,1,4),(7,41,-10,1,1,4),(7,40,-9,1,1,4),(7,36,-8,1,1,4),(7,32,-7,1,1,4),(7,31,-6,1,1,4),(7,30,-5,1,1,4),(7,28,-4,1,1,4),(7,25,-3,1,1,4),(7,23,-2,1,1,4),(7,22,-1,1,1,4),(8,69,-5,1,1,4),(8,56,-4,1,1,4),(8,55,-3,1,1,4),(8,26,-2,1,1,4),(8,24,-1,1,1,4),(9,29,-2,1,1,4),(9,27,-1,1,1,4),(10,35,-2,1,1,4),(10,34,-1,1,1,4),(10,1,0,1,1,4),(10,2,0,1,1,4),(10,3,0,1,1,4),(11,33,-1,1,1,4),(12,38,-1,1,1,4),(13,51,-2,1,1,4),(13,42,-1,1,1,4),(14,68,-3,1,1,4),(14,61,-2,1,1,4),(14,52,-1,1,1,4),(15,60,-5,1,1,4),(15,59,-4,1,1,4),(15,57,-3,1,1,4),(15,54,-2,1,1,4),(15,53,-1,1,1,4),(16,66,-5,1,1,4),(16,65,-4,1,1,4),(16,64,-3,1,1,4),(16,63,-2,1,1,4),(16,58,-1,1,1,4),(17,62,-1,1,1,4),(19,72,-1,1,1,4),(20,46,-1,1,1,4),(21,37,-1,1,1,4),(22,39,-1,1,1,4),(23,44,-2,1,1,4),(23,43,-1,1,1,4),(24,71,-2,1,1,4),(24,70,-1,1,1,4);

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

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

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

INSERT INTO `catalog_category_product_index_store1_replica` VALUES (2,67,-11,1,1,4),(2,41,-10,1,1,4),(2,50,-10,1,1,4),(2,40,-9,1,1,4),(2,49,-9,1,1,4),(2,36,-8,1,1,4),(2,48,-8,1,1,4),(2,32,-7,1,1,4),(2,47,-7,1,1,4),(2,31,-6,1,1,4),(2,45,-6,1,1,4),(2,73,-6,1,1,4),(2,16,-5,1,1,4),(2,21,-5,1,1,4),(2,30,-5,1,1,4),(2,60,-5,1,1,4),(2,66,-5,1,1,4),(2,69,-5,1,1,4),(2,15,-4,1,1,4),(2,20,-4,1,1,4),(2,28,-4,1,1,4),(2,56,-4,1,1,4),(2,59,-4,1,1,4),(2,65,-4,1,1,4),(2,9,-3,1,1,4),(2,14,-3,1,1,4),(2,19,-3,1,1,4),(2,25,-3,1,1,4),(2,55,-3,1,1,4),(2,57,-3,1,1,4),(2,64,-3,1,1,4),(2,68,-3,1,1,4),(2,8,-2,1,1,4),(2,11,-2,1,1,4),(2,13,-2,1,1,4),(2,18,-2,1,1,4),(2,23,-2,1,1,4),(2,26,-2,1,1,4),(2,29,-2,1,1,4),(2,35,-2,1,1,4),(2,44,-2,1,1,4),(2,51,-2,1,1,4),(2,54,-2,1,1,4),(2,61,-2,1,1,4),(2,63,-2,1,1,4),(2,71,-2,1,1,4),(2,7,-1,1,1,4),(2,10,-1,1,1,4),(2,12,-1,1,1,4),(2,17,-1,1,1,4),(2,22,-1,1,1,4),(2,24,-1,1,1,4),(2,27,-1,1,1,4),(2,33,-1,1,1,4),(2,34,-1,1,1,4),(2,37,-1,1,1,4),(2,38,-1,1,1,4),(2,39,-1,1,1,4),(2,42,-1,1,1,4),(2,43,-1,1,1,4),(2,46,-1,1,1,4),(2,52,-1,1,1,4),(2,53,-1,1,1,4),(2,58,-1,1,1,4),(2,62,-1,1,1,4),(2,70,-1,1,1,4),(2,72,-1,1,1,4),(2,1,0,1,1,4),(2,2,0,1,1,4),(2,3,0,1,1,4),(2,4,0,1,1,4),(2,5,0,1,1,4),(2,6,0,1,1,4),(3,67,-11,1,1,4),(3,50,-10,1,1,4),(3,49,-9,1,1,4),(3,48,-8,1,1,4),(3,47,-7,1,1,4),(3,45,-6,1,1,4),(3,21,-5,1,1,4),(3,20,-4,1,1,4),(3,9,-3,1,1,4),(3,8,-2,1,1,4),(3,7,-1,1,1,4),(4,11,-2,1,1,4),(4,10,-1,1,1,4),(5,73,-6,1,1,4),(5,16,-5,1,1,4),(5,15,-4,1,1,4),(5,14,-3,1,1,4),(5,13,-2,1,1,4),(5,12,-1,1,1,4),(5,5,0,1,1,4),(5,6,0,1,1,4),(6,19,-3,1,1,4),(6,18,-2,1,1,4),(6,17,-1,1,1,4),(6,4,0,1,1,4),(7,41,-10,1,1,4),(7,40,-9,1,1,4),(7,36,-8,1,1,4),(7,32,-7,1,1,4),(7,31,-6,1,1,4),(7,30,-5,1,1,4),(7,28,-4,1,1,4),(7,25,-3,1,1,4),(7,23,-2,1,1,4),(7,22,-1,1,1,4),(8,69,-5,1,1,4),(8,56,-4,1,1,4),(8,55,-3,1,1,4),(8,26,-2,1,1,4),(8,24,-1,1,1,4),(9,29,-2,1,1,4),(9,27,-1,1,1,4),(10,35,-2,1,1,4),(10,34,-1,1,1,4),(10,1,0,1,1,4),(10,2,0,1,1,4),(10,3,0,1,1,4),(11,33,-1,1,1,4),(12,38,-1,1,1,4),(13,51,-2,1,1,4),(13,42,-1,1,1,4),(14,68,-3,1,1,4),(14,61,-2,1,1,4),(14,52,-1,1,1,4),(15,60,-5,1,1,4),(15,59,-4,1,1,4),(15,57,-3,1,1,4),(15,54,-2,1,1,4),(15,53,-1,1,1,4),(16,66,-5,1,1,4),(16,65,-4,1,1,4),(16,64,-3,1,1,4),(16,63,-2,1,1,4),(16,58,-1,1,1,4),(17,62,-1,1,1,4),(19,72,-1,1,1,4),(20,46,-1,1,1,4),(21,37,-1,1,1,4),(22,39,-1,1,1,4),(23,44,-2,1,1,4),(23,43,-1,1,1,4),(24,71,-2,1,1,4),(24,70,-1,1,1,4);

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

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

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


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

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

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


--
-- Table structure for table `catalog_compare_list`
--

CREATE TABLE `catalog_compare_list` (
  `list_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Compare List ID',
  `list_id_mask` varchar(32) DEFAULT NULL COMMENT 'Masked ID',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer ID',
  PRIMARY KEY (`list_id`),
  UNIQUE KEY `CATALOG_COMPARE_LIST_CUSTOMER_ID` (`customer_id`),
  KEY `CATALOG_COMPARE_LIST_LIST_ID_MASK` (`list_id_mask`),
  CONSTRAINT `CATALOG_COMPARE_LIST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Compare List with hash Table';

--
-- Dumping data for table `catalog_compare_list`
--


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

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

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

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

--
-- Table structure for table `catalog_product_attribute_cl`
--

CREATE TABLE `catalog_product_attribute_cl` (
  `version_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Version ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  PRIMARY KEY (`version_id`)
) ENGINE=InnoDB AUTO_INCREMENT=867 DEFAULT CHARSET=utf8mb3 COMMENT='catalog_product_attribute_cl';

--
-- Dumping data for table `catalog_product_attribute_cl`
--

INSERT INTO `catalog_product_attribute_cl` VALUES (866,73);

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

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

--
-- Dumping data for table `catalog_product_bundle_option`
--


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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

INSERT INTO `catalog_product_category_cl` VALUES (453,73);

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

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

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

INSERT INTO `catalog_product_entity` VALUES (1,4,'simple','MPHRBHS',0,0,'2025-02-14 12:30:42','2025-02-16 14:16:45'),(2,4,'simple','MPMRCMPHD',0,0,'2025-02-14 14:41:48','2025-02-16 14:25:03'),(3,4,'simple','MPHRCHS-1',0,0,'2025-02-14 14:44:47','2025-02-18 11:16:07'),(4,4,'simple','MPMRCMSF',0,0,'2025-02-14 14:53:41','2025-02-22 03:42:49'),(5,4,'simple','MPTABPST',0,0,'2025-02-14 14:57:48','2025-02-18 10:54:40'),(6,4,'simple','MPTAPS',0,0,'2025-02-14 15:03:08','2025-02-22 03:41:13'),(7,4,'simple','JFX001',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(8,4,'simple','JFX002',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(9,4,'simple','JFX003',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(10,4,'simple','JFX008',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(11,4,'simple','JFX009',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(12,4,'simple','JFX011',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(13,4,'simple','JFX012',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(14,4,'simple','JFX013',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(15,4,'simple','JFX014',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(16,4,'simple','JFX015',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(17,4,'simple','JFX016',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(18,4,'simple','JFX017',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(19,4,'simple','JFX018',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(20,4,'simple','JFX019',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(21,4,'simple','JFX022',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(22,4,'simple','JFX023',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(23,4,'simple','JFX024',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(24,4,'simple','JFX025',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(25,4,'simple','JFX026',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(26,4,'simple','JFX027',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(27,4,'simple','JFX028',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(28,4,'simple','JFX029',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(29,4,'simple','JFX030',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(30,4,'simple','JFX031',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(31,4,'simple','JFX033',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(32,4,'simple','JFX034',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(33,4,'simple','JFX035',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(34,4,'simple','JFX036',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(35,4,'simple','JFX037',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(36,4,'simple','JFX038',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(37,4,'simple','JFX041',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(38,4,'simple','JFX043',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(39,4,'simple','JFX044',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(40,4,'simple','JFX045',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(41,4,'simple','JFX048',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(42,4,'simple','JFX050',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(43,4,'simple','JFX051',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(44,4,'simple','JFX052',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(45,4,'simple','JFX053',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(46,4,'simple','JFX056',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(47,4,'simple','JFX058',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(48,4,'simple','JFX059',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(49,4,'simple','JFX060',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(50,4,'simple','JFX061',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(51,4,'simple','JFX063',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(52,4,'simple','JFX064',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(53,4,'simple','JFX066',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(54,4,'simple','JFX067',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(55,4,'simple','JFX068',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(56,4,'simple','JFX069',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(57,4,'simple','JFX070',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(58,4,'simple','JFX071',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(59,4,'simple','JFX078',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(60,4,'simple','JFX079',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(61,4,'simple','JFX082',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(62,4,'simple','JFX085',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(63,4,'simple','JFX090',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(64,4,'simple','JFX098',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(65,4,'simple','JFX101',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(66,4,'simple','JFX111',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(67,4,'simple','JFX114',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(68,4,'simple','JFX115',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(69,4,'simple','JFX116',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(70,4,'simple','JFX127',0,0,'2025-02-28 08:45:28','2025-02-28 08:45:28'),(71,4,'simple','JFX128',0,0,'2025-02-28 08:45:29','2025-02-28 08:45:29'),(72,4,'simple','JFX129',0,0,'2025-02-28 08:45:29','2025-02-28 08:45:29'),(73,4,'simple','JFX130',0,0,'2025-02-28 08:45:29','2025-02-28 08:45:29');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_after_insert` AFTER INSERT ON `catalog_product_entity` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_after_update` AFTER UPDATE ON `catalog_product_entity` FOR EACH ROW BEGIN
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`type_id` <=> OLD.`type_id`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`has_options` <=> OLD.`has_options`) OR NOT(NEW.`required_options` <=> OLD.`required_options`) OR NOT(NEW.`created_at` <=> OLD.`created_at`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`type_id` <=> OLD.`type_id`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`has_options` <=> OLD.`has_options`) OR NOT(NEW.`required_options` <=> OLD.`required_options`) OR NOT(NEW.`created_at` <=> OLD.`created_at`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`attribute_set_id` <=> OLD.`attribute_set_id`) OR NOT(NEW.`type_id` <=> OLD.`type_id`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`has_options` <=> OLD.`has_options`) OR NOT(NEW.`required_options` <=> OLD.`required_options`) OR NOT(NEW.`created_at` <=> OLD.`created_at`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_after_delete` AFTER DELETE ON `catalog_product_entity` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

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

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

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

INSERT INTO `catalog_product_entity_datetime` VALUES (1,79,0,1,'2025-02-14 00:00:00'),(2,79,0,6,'2025-02-21 00:00:00'),(3,79,0,4,'2025-02-21 00:00:00');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_datetime_after_insert` AFTER INSERT ON `catalog_product_entity_datetime` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_datetime_after_update` AFTER UPDATE ON `catalog_product_entity_datetime` FOR EACH ROW BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_datetime_after_delete` AFTER DELETE ON `catalog_product_entity_datetime` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

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

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

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

INSERT INTO `catalog_product_entity_decimal` VALUES (1,77,0,1,10.000000),(2,82,0,1,1.000000),(3,81,0,1,NULL),(4,77,0,2,10.000000),(5,82,0,2,1.000000),(6,81,0,2,NULL),(7,77,0,3,10.000000),(8,82,0,3,1.000000),(9,81,0,3,NULL),(10,77,0,4,10.000000),(11,82,0,4,1.000000),(12,81,0,4,NULL),(13,77,0,5,10.000000),(14,82,0,5,1.000000),(15,81,0,5,NULL),(16,77,0,6,10.000000),(17,82,0,6,1.000000),(18,81,0,6,NULL),(19,78,0,1,8.500000),(20,78,0,6,7.500000),(21,78,0,4,8.500000),(22,77,0,7,11.000000),(23,82,0,7,1.000000),(24,77,0,8,12.000000),(25,82,0,8,1.000000),(26,77,0,9,13.000000),(27,82,0,9,1.000000),(28,77,0,10,14.000000),(29,82,0,10,1.000000),(30,77,0,11,15.000000),(31,82,0,11,1.000000),(32,77,0,12,16.000000),(33,82,0,12,1.000000),(34,77,0,13,17.000000),(35,82,0,13,1.000000),(36,77,0,14,18.000000),(37,82,0,14,1.000000),(38,77,0,15,19.000000),(39,82,0,15,1.000000),(40,77,0,16,20.000000),(41,82,0,16,1.000000),(42,77,0,17,21.000000),(43,82,0,17,1.000000),(44,77,0,18,22.000000),(45,82,0,18,1.000000),(46,77,0,19,23.000000),(47,82,0,19,1.000000),(48,77,0,20,24.000000),(49,82,0,20,1.000000),(50,77,0,21,25.000000),(51,82,0,21,1.000000),(52,77,0,22,26.000000),(53,82,0,22,1.000000),(54,77,0,23,27.000000),(55,82,0,23,1.000000),(56,77,0,24,28.000000),(57,82,0,24,1.000000),(58,77,0,25,29.000000),(59,82,0,25,1.000000),(60,77,0,26,30.000000),(61,82,0,26,1.000000),(62,77,0,27,31.000000),(63,82,0,27,1.000000),(64,77,0,28,32.000000),(65,82,0,28,1.000000),(66,77,0,29,33.000000),(67,82,0,29,1.000000),(68,77,0,30,34.000000),(69,82,0,30,1.000000),(70,77,0,31,35.000000),(71,82,0,31,1.000000),(72,77,0,32,36.000000),(73,82,0,32,1.000000),(74,77,0,33,37.000000),(75,82,0,33,1.000000),(76,77,0,34,38.000000),(77,82,0,34,1.000000),(78,77,0,35,39.000000),(79,82,0,35,1.000000),(80,77,0,36,40.000000),(81,82,0,36,1.000000),(82,77,0,37,41.000000),(83,82,0,37,1.000000),(84,77,0,38,42.000000),(85,82,0,38,1.000000),(86,77,0,39,43.000000),(87,82,0,39,1.000000),(88,77,0,40,44.000000),(89,82,0,40,1.000000),(90,77,0,41,45.000000),(91,82,0,41,1.000000),(92,77,0,42,46.000000),(93,82,0,42,1.000000),(94,77,0,43,47.000000),(95,82,0,43,1.000000),(96,77,0,44,48.000000),(97,82,0,44,1.000000),(98,77,0,45,49.000000),(99,82,0,45,1.000000),(100,77,0,46,50.000000),(101,82,0,46,1.000000),(102,77,0,47,51.000000),(103,82,0,47,1.000000),(104,77,0,48,52.000000),(105,82,0,48,1.000000),(106,77,0,49,53.000000),(107,82,0,49,1.000000),(108,77,0,50,54.000000),(109,82,0,50,1.000000),(110,77,0,51,55.000000),(111,82,0,51,1.000000),(112,77,0,52,56.000000),(113,82,0,52,1.000000),(114,77,0,53,57.000000),(115,82,0,53,1.000000),(116,77,0,54,58.000000),(117,82,0,54,1.000000),(118,77,0,55,59.000000),(119,82,0,55,1.000000),(120,77,0,56,60.000000),(121,82,0,56,1.000000),(122,77,0,57,61.000000),(123,82,0,57,1.000000),(124,77,0,58,62.000000),(125,82,0,58,1.000000),(126,77,0,59,63.000000),(127,82,0,59,1.000000),(128,77,0,60,64.000000),(129,82,0,60,1.000000),(130,77,0,61,65.000000),(131,82,0,61,1.000000),(132,77,0,62,66.000000),(133,82,0,62,1.000000),(134,77,0,63,67.000000),(135,82,0,63,1.000000),(136,77,0,64,68.000000),(137,82,0,64,1.000000),(138,77,0,65,69.000000),(139,82,0,65,1.000000),(140,77,0,66,70.000000),(141,82,0,66,1.000000),(142,77,0,67,71.000000),(143,82,0,67,1.000000),(144,77,0,68,72.000000),(145,82,0,68,1.000000),(146,77,0,69,73.000000),(147,82,0,69,1.000000),(148,77,0,70,74.000000),(149,82,0,70,1.000000),(150,77,0,71,75.000000),(151,82,0,71,1.000000),(152,77,0,72,76.000000),(153,82,0,72,1.000000),(154,77,0,73,77.000000),(155,82,0,73,1.000000);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_decimal_after_insert` AFTER INSERT ON `catalog_product_entity_decimal` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_decimal_after_update` AFTER UPDATE ON `catalog_product_entity_decimal` FOR EACH ROW BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_decimal_after_delete` AFTER DELETE ON `catalog_product_entity_decimal` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_price_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

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

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

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


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

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

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

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

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

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

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

INSERT INTO `catalog_product_entity_media_gallery` VALUES (1,90,'/1/_/1_2.jpg','image',0),(2,90,'/b/l/bl1-600x600_2.jpg','image',0),(6,90,'/p/4/p4-1-600x600_1.jpg','image',0),(7,90,'/m/a/machineroll_1.png','image',0),(9,90,'/m/e/metro-600x600_1.jpg','image',0),(11,90,'/6/-/6-600x600.jpg','image',0),(13,90,'/8/-/8-600x600.jpg','image',0);

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

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

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

INSERT INTO `catalog_product_entity_media_gallery_value` VALUES (1,0,1,NULL,0,0,42),(2,0,1,NULL,1,0,43),(7,0,2,NULL,3,0,44),(11,0,5,NULL,4,0,56),(6,0,3,NULL,2,0,57),(13,0,6,NULL,5,0,58),(9,0,4,NULL,3,0,59);

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

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

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

INSERT INTO `catalog_product_entity_media_gallery_value_to_entity` VALUES (1,1),(2,1),(7,2),(6,3),(9,4),(11,5),(13,6);

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

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

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


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

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

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

INSERT INTO `catalog_product_entity_text` VALUES (1,85,0,1,'Black Hand Strech film'),(2,76,0,1,'Minimum Coverage: 300m\r\nQuality type: Heavy Duty'),(3,160,0,1,NULL),(4,161,0,1,NULL),(5,75,0,1,'<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">Hand Films are stretch films that can be rolled onto a pallet by hand. Our hand films weigh less than 3.5 kilos each on average, make them ideal for wrapping and safety. The maximum width of our hand rolls is 500mm, making it easier to grasp.\r\n\r\nOur hand films are available in Clear and Black\r\n\r\nPremium quality transparent hand-grade cast films with heavy-duty compatible material. Black Hand Rolls are available in in thickness of 25 microns or 23 microns and more depending on the specification of the customers. Hand wrap films are applied manually to the products.\r\n</div>'),(6,75,0,2,'<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">Hand Films are stretch films that can be rolled onto a pallet by hand. Our hand films weigh less than 3.5 kilos each on average, make them ideal for wrapping and safety. The maximum width of our hand rolls is 500mm, making it easier to grasp.\r\n\r\nOur hand films are available in Clear and Black\r\n\r\nPremium quality transparent hand-grade cast films with heavy-duty compatible material. Black Hand Rolls are available in in thickness of 25 microns or 23 microns and more depending on the specification of the customers. Hand wrap films are applied manually to the products.\r\n\r\nDurable standards\r\nResistance to heat and moisture\r\nAvailability in varied dimensions and sizes\r\nVariable colors and textures\r\n\r\n15um (MCA-500m, Core 350gm), 17um (MCA-450m, Core 350gm), 20um (MCA-400m, Core 350gm), 23um (MCA-350m, Core 350gm), 25um (MCA-300m, Core 350gm)\r\n</div>'),(7,76,0,2,'Minimum Coverage: 300m\r\nQuality type: Heavy Duty\r\nColor: Transparent/Clear'),(8,160,0,2,NULL),(9,161,0,2,NULL),(10,75,0,3,'<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">Hand Films are stretch films that can be rolled onto a pallet by hand. Our hand films weigh less than 3.5 kilos each on average, make them ideal for wrapping and safety. The maximum width of our hand rolls is 500mm, making it easier to grasp.\r\n\r\nOur hand films are available in Clear and Black\r\n\r\nPremium quality transparent hand-grade cast films with heavy-duty compatible material. Black Hand Rolls are available in in thickness of 25 microns or 23 microns and more depending on the specification of the customers. Hand wrap films are applied manually to the products.\r\n\r\nDurable standards\r\nResistance to heat and moisture\r\nAvailability in varied dimensions and sizes\r\nVariable colors and textures\r\n\r\n15um (MCA-500m, Core 350gm), 17um (MCA-450m, Core 350gm), 20um (MCA-400m, Core 350gm), 23um (MCA-350m, Core 350gm), 25um (MCA-300m, Core 350gm)\r\n</div>'),(11,76,0,3,'Minimum Coverage: 300m\r\nQuality type: Heavy Duty\r\nColor: Transparent/Clear'),(12,160,0,3,NULL),(13,161,0,3,NULL),(14,75,0,4,'<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">Hand Films are stretch films that can be rolled onto a pallet by hand. Our hand films weigh less than 3.5 kilos each on average, make them ideal for wrapping and safety. The maximum width of our hand rolls is 500mm, making it easier to grasp.\r\n\r\nOur hand films are available in Clear and Black\r\n\r\nPremium quality transparent hand-grade cast films with heavy-duty compatible material. Black Hand Rolls are available in in thickness of 25 microns or 23 microns and more depending on the specification of the customers. Hand wrap films are applied manually to the products.\r\n\r\nDurable standards\r\nResistance to heat and moisture\r\nAvailability in varied dimensions and sizes\r\nVariable colors and textures\r\n\r\n15um (MCA-500m, Core 350gm), 17um (MCA-450m, Core 350gm), 20um (MCA-400m, Core 350gm), 23um (MCA-350m, Core 350gm), 25um (MCA-300m, Core 350gm)\r\n</div>'),(15,76,0,4,'Minimum Coverage: 300m\r\nQuality type: Heavy Duty\r\nColor: Transparent/Clear'),(16,160,0,4,NULL),(17,161,0,4,NULL),(18,75,0,5,'<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">Hand Films are stretch films that can be rolled onto a pallet by hand. Our hand films weigh less than 3.5 kilos each on average, make them ideal for wrapping and safety. The maximum width of our hand rolls is 500mm, making it easier to grasp.\r\n\r\nOur hand films are available in Clear and Black\r\n\r\nPremium quality transparent hand-grade cast films with heavy-duty compatible material. Black Hand Rolls are available in in thickness of 25 microns or 23 microns and more depending on the specification of the customers. Hand wrap films are applied manually to the products.\r\n\r\nDurable standards\r\nResistance to heat and moisture\r\nAvailability in varied dimensions and sizes\r\nVariable colors and textures\r\n\r\n15um (MCA-500m, Core 350gm), 17um (MCA-450m, Core 350gm), 20um (MCA-400m, Core 350gm), 23um (MCA-350m, Core 350gm), 25um (MCA-300m, Core 350gm)\r\n</div>'),(19,76,0,5,'Minimum Coverage: 300m\r\nQuality type: Heavy Duty\r\nColor: Transparent/Clear'),(20,160,0,5,NULL),(21,161,0,5,NULL),(22,75,0,6,'<style>#html-body [data-pb-style=E0HI944]{justify-content:flex-start;display:flex;flex-direction:column;background-position:left top;background-size:cover;background-repeat:no-repeat;background-attachment:scroll}#html-body [data-pb-style=TL0K6AQ]{margin-left:10px;margin-right:10px}</style><div data-content-type=\"row\" data-appearance=\"contained\" data-element=\"main\"><div data-enable-parallax=\"0\" data-parallax-speed=\"0.5\" data-background-images=\"{}\" data-background-type=\"image\" data-video-loop=\"true\" data-video-play-only-visible=\"true\" data-video-lazy-load=\"true\" data-video-fallback-src=\"\" data-element=\"inner\" data-pb-style=\"E0HI944\"><div data-content-type=\"text\" data-appearance=\"default\" data-element=\"main\" data-pb-style=\"TL0K6AQ\"><p>Hand Films are stretch films that can be rolled onto a pallet by hand. Our hand films weigh less than 3.5 kilos each on average, make them ideal for wrapping and safety. The maximum width of our hand rolls is 500mm, making it easier to grasp.</p>\r\n<p>Our hand films are available in Clear and Black</p>\r\n<p>Premium quality transparent hand-grade cast films with heavy-duty compatible material. Black Hand Rolls are available in in thickness of 25 microns or 23 microns and more depending on the specification of the customers. Hand wrap films are applied manually to the products.</p>\r\n<p>Durable standards<br>Resistance to heat and moisture<br>Availability in varied dimensions and sizes<br>Variable colors and textures</p>\r\n<p>15um (MCA-500m, Core 350gm), 17um (MCA-450m, Core 350gm), 20um (MCA-400m, Core 350gm), 23um (MCA-350m, Core 350gm), 25um (MCA-300m, Core 350gm)</p></div></div></div>'),(23,76,0,6,'Minimum Coverage: 300m\r\nQuality type: Heavy Duty\r\nColor: Transparent/Clear'),(24,160,0,6,NULL),(25,161,0,6,NULL),(26,75,0,7,'A spacious and durable reusable shopping bag, designed for carrying bulk groceries and heavy items. Made from eco-friendly, long-lasting materials to reduce plastic waste.'),(27,76,0,7,'Sturdy, eco-friendly large tote for carrying bulk items and groceries.'),(28,75,0,8,'A medium-sized reusable tote bag, ideal for everyday shopping trips. Reinforced handles provide comfort and strength for carrying moderate loads.'),(29,76,0,8,'Medium-sized reusable bag for everyday shopping and storage.'),(30,75,0,9,'A compact and lightweight reusable bag, perfect for small shopping hauls, personal use, or carrying lightweight essentials.'),(31,76,0,9,'Compact and durable small tote for light shopping and personal use.'),(32,75,0,10,'Standard food-grade plastic wrap for sealing and preserving food freshness. Stretches easily for secure coverage on bowls and trays.'),(33,76,0,10,'Standard food-safe plastic wrap for keeping food fresh and secure.'),(34,75,0,11,'Extra-thick, industrial-strength cling wrap designed to secure food and packaging in commercial kitchens and storage environments.'),(35,76,0,11,'Extra-thick cling wrap designed for heavy-duty sealing and storage.'),(36,75,0,12,'Strong adhesive tape with \'Top Load Only\' warning print, ensuring proper handling and stacking of sensitive shipments.'),(37,76,0,12,'White and red warning tape ensuring top-loading safety for fragile shipments.'),(38,75,0,13,'High-clarity, extra-strong packing tape for sealing boxes, cartons, and parcels securely.'),(39,76,0,13,'Strong, transparent tape for sealing and securing packages.'),(40,75,0,14,'Heavy-duty machine-compatible tape for automated sealing of shipping boxes and packaging lines.'),(41,76,0,14,'48x1000Mx50Mic /6 – Industrial-grade machine tape for automated packaging systems.'),(42,75,0,15,'Classic brown packing tape with high adhesion, ideal for securing cardboard boxes for shipping and storage.'),(43,76,0,15,'36mic48mm66m – Heavy-duty brown packing tape for secure box sealing.'),(44,75,0,16,'Bright red and white \'Fragile\' tape, designed to clearly mark packages that require gentle handling.'),(45,76,0,16,'36mic48mm66m – Brightly marked tape for handling delicate or breakable shipments.'),(46,75,0,17,'Thin but strong stretch film designed for high-speed machine applications, ideal for lightweight pallet wrapping.'),(47,76,0,17,'Lightweight stretch film for machine-wrapping pallets and securing loads.'),(48,75,0,18,'A mid-strength stretch film offering flexibility and tear resistance for machine-wrapped pallets.'),(49,76,0,18,'Standard-strength stretch film for enhanced load stability in machine wrapping.'),(50,75,0,19,'Heavy-duty stretch film with superior puncture resistance, designed for securely wrapping large and heavy loads.'),(51,76,0,19,'Heavy-duty stretch film for wrapping and protecting palletized goods.'),(52,75,0,20,'Oversized, heavy-duty blue plastic bag for covering entire pallets, protecting contents from dust, moisture, and contamination.'),(53,76,0,20,'Large, heavy-duty blue pallet cover for moisture and dust protection.'),(54,75,0,21,'Large, thick bin liner designed for handling heavy waste in industrial and commercial environments.'),(55,76,0,21,'Strong, tear-resistant bin liner for large waste disposal.'),(56,75,0,22,'Highly stretchable cast film with a 250% elongation capability, offering excellent load retention in machine wrapping.'),(57,76,0,22,'High-stretch cast film for machine wrapping with superior elongation.'),(58,75,0,23,'Extra-thin, ultra-stretchable film with a 300% elongation rate for maximizing material efficiency in machine wrapping.'),(59,76,0,23,'Ultra-stretchable film offering maximum load stability and efficiency.'),(60,75,0,24,'A bulk pack of 12mm plastic buckles used for securing lightweight strapping in packaging applications.'),(61,76,0,24,'Durable 12mm plastic buckles for securing strapping and packaging.'),(62,75,0,25,'Transparent cast stretch film, balancing strength and flexibility for machine-wrapping applications.'),(63,76,0,25,'High-clarity cast stretch film for wrapping and bundling loads.'),(64,75,0,26,'A thick, reinforced strapping material ideal for securing large or heavy loads in transport and storage.'),(65,76,0,26,'Robust 15mm strapping material for securing heavy packages.'),(66,75,0,27,'A versatile hand stretch film, providing medium-strength load stability for manual wrapping.'),(67,76,0,27,'Medium-strength clear hand film for secure wrapping and transport.'),(68,75,0,28,'High-performance stretch film, easy to apply manually with strong cling properties.'),(69,76,0,28,'Versatile stretch wrap for manual application with excellent cling.'),(70,75,0,29,'Premium quality hand stretch film, offering enhanced tear resistance for wrapping larger loads.'),(71,76,0,29,'Strong and flexible hand stretch film for securing large loads.'),(72,75,0,30,'A durable, clear cast stretch film designed for smooth application and secure bundling.'),(73,76,0,30,'Premium cast stretch film for long-lasting load containment.'),(74,75,0,31,'Reinforced clear stretch wrap with excellent puncture resistance for high-value shipments.'),(75,76,0,31,'Reinforced clear stretch film designed for high-load retention.'),(76,75,0,32,'Strong and reliable cast stretch film designed for optimal performance in machine wrapping.'),(77,76,0,32,'Sturdy stretch film for machine-wrapped stability.'),(78,75,0,33,'Opaque black stretch film for added security and privacy during shipping. Prevents product visibility and protects from UV exposure.'),(79,76,0,33,'Opaque black hand stretch film for privacy and secure wrapping.'),(80,75,0,34,'High-quality clear hand wrap for protecting palletized goods while keeping contents visible.'),(81,76,0,34,'High-clarity hand wrap for bundling and securing pallets.'),(82,75,0,35,'A thick hand stretch film with superior cling, reducing shifting during transport.'),(83,76,0,35,'Heavy-duty hand film for extended manual wrapping applications.'),(84,75,0,36,'Machine-applied stretch film, designed for efficient and secure load wrapping.'),(85,76,0,36,'Strong machine-grade stretch film for high-speed packaging.'),(86,75,0,37,'A high-density black hand stretch film offering maximum opacity and security.'),(87,76,0,37,'Heavy-duty black hand roll for secure and discreet pallet wrapping.'),(88,75,0,38,'Machine-grade cast stretch film with high puncture resistance and smooth unwinding.'),(89,76,0,38,'Tough black stretch film for machine-applied wrapping.'),(90,75,0,39,'Thick, transparent stretch film suitable for securing large shipments.'),(91,76,0,39,'Thick, clear stretch film for manual load stabilization.'),(92,75,0,40,'Machine-compatible stretch film ensuring strong and stable load containment.'),(93,76,0,40,'Machine-applied stretch film for enhanced load protection.'),(94,75,0,41,'Ultra-thick stretch film for securing particularly heavy or irregularly shaped loads.'),(95,76,0,41,'Ultra-thick machine stretch film for maximum load security.'),(96,75,0,42,'Transparent plastic film for multiple applications, including food wrapping and light packaging.'),(97,76,0,42,'High-quality transparent film for packaging and protection.'),(98,75,0,43,'Heavy-duty, food-safe butcher paper used for wrapping meat and preserving freshness.'),(99,76,0,43,'Heavy-duty butcher paper for wrapping meats and food products.'),(100,75,0,44,'A set of large, highly absorbent wipes ideal for industrial and commercial cleaning.'),(101,75,0,45,'A food-grade blue liner used to maintain hygiene in food storage bins.'),(102,76,0,45,'Food-safe blue bin liner for hygienic waste disposal.'),(103,75,0,46,'Ergonomic dispenser for quick and efficient manual stretch wrapping.'),(104,76,0,46,'Ergonomic hand dispenser for efficient stretch wrapping.'),(105,75,0,47,'Large-capacity heavy-duty garbage bags suitable for both commercial and residential waste.'),(106,76,0,47,'Large, heavy-duty garbage bags for industrial and household use.'),(107,75,0,48,'Extra-large black garbage bags designed for industrial and outdoor waste collection.'),(108,76,0,48,'Extra-large black garbage bags for commercial and industrial bins.'),(109,75,0,49,'Thick, puncture-resistant bin liners for handling sharp or heavy waste.'),(110,76,0,49,'Tough and tear-resistant bin liner for heavy waste loads.'),(111,75,0,50,'A protective liner designed to keep bread crates clean and food-safe.'),(112,76,0,50,'Food-grade liner for bread crates, ensuring hygiene and freshness.'),(113,75,0,51,'A specialized film for securely wrapping fresh meat, preventing contamination and drying.'),(114,76,0,51,'Specialized film for wrapping and preserving fresh meats.'),(115,75,0,52,'Soft, single-ply napkins for dispenser-based use in cafes and restaurants.'),(116,76,0,52,'Single-ply napkins for dispenser use in food service settings.'),(117,75,0,53,'Disposable cups suitable for hot or cold beverages in bulk quantities.'),(118,76,0,53,'Disposable 12oz drinking cups for hot and cold beverages.'),(119,75,0,54,'Sturdy disposable plates for serving meals at events and restaurants.'),(120,76,0,54,'Sturdy 180mm round plastic plate for food service.'),(121,75,0,55,'Extra-durable strapping for securing bulky or heavy shipments.'),(122,76,0,55,'Reinforced heavy-duty strapping for securing large shipments.'),(123,75,0,56,'High-strength embossed polyester strapping for secure bundling.'),(124,76,0,56,'High-strength polyester strap with embossed texture for secure binding.'),(125,75,0,57,'Eco-friendly, disposable wooden spoon for convenient single-use dining.'),(126,76,0,57,'Disposable 160mm wooden spoon for food service and catering.'),(127,75,0,58,'Powder-free nitrile gloves offering chemical resistance and comfort.'),(128,76,0,58,'Durable, powder-free nitrile gloves for hygiene and protection.'),(129,75,0,59,'Small, disposable cups ideal for serving tea, coffee, or water.'),(130,76,0,59,'Small 6oz paper cup ideal for serving hot or cold beverages.'),(131,75,0,60,'Bulk pack of 8oz disposable paper cups for convenience.'),(132,76,0,60,'Bulk pack of 8oz paper cups for drinks and takeaway service.'),(133,75,0,61,'Soft and absorbent hand towels, perfect for restrooms and workplaces.'),(134,76,0,61,'Soft, absorbent hand towels for hygiene and convenience.'),(135,75,0,62,'Durable, waterproof blue apron for protection in food handling and industrial applications.'),(136,76,0,62,'Lightweight disposable apron for food handling and industrial use.'),(137,75,0,63,'A pack of 12 cotton gloves for general-purpose use, offering comfort and protection.'),(138,76,0,63,'Pack of 12 cotton gloves for general-purpose use.'),(139,75,0,64,'Powder-free black nitrile gloves providing excellent chemical resistance and durability.'),(140,76,0,64,'Tough, chemical-resistant black nitrile gloves for industrial use.'),(141,75,0,65,'White nitrile gloves offering superior protection against chemicals and contaminants.'),(142,76,0,65,'Medical-grade white nitrile gloves for hygiene and protection.'),(143,75,0,66,'A box of 100 vinyl gloves, suitable for food handling and general hygiene purposes.'),(144,76,0,66,'Cost-effective vinyl gloves for light-duty tasks.'),(145,75,0,67,'A set of 9 produce roll bags, ideal for storing and packaging fresh fruits and vegetables.'),(146,76,0,67,'Roll of perforated produce bags for grocery and food packaging.'),(147,75,0,68,'A bulk box of roll towels, each 80 meters long, designed for high-usage environments.'),(148,76,0,68,'Large box of durable roll towels for cleaning and drying.'),(149,75,0,69,'Durable polyethylene strap, 12mm wide and 1000m long, for securing packages and shipments.'),(150,76,0,69,'High-strength polyethylene strapping for securing loads.'),(151,75,0,70,'Eco-friendly, biodegradable sugarcane dinner box with three compartments for meal storage.'),(152,76,0,70,'Eco-friendly, three-compartment sugarcane dinner box.'),(153,75,0,71,'Sustainable, large biodegradable sugarcane dinner box for takeaway and meal storage.'),(154,76,0,71,'Biodegradable large dinner box made from sugarcane fiber.'),(155,75,0,72,'Disposable paper table cover, ideal for restaurants, catering, and special events.'),(156,76,0,72,'Disposable paper table cover for events and catering.'),(157,75,0,73,'High-clarity, strong adhesive tape for packaging and sealing applications.'),(158,76,0,73,'High-clarity clear packing tape for sealing boxes.');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_text_after_insert` AFTER INSERT ON `catalog_product_entity_text` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_text_after_update` AFTER UPDATE ON `catalog_product_entity_text` FOR EACH ROW BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_text_after_delete` AFTER DELETE ON `catalog_product_entity_text` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

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

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

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

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

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

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

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

INSERT INTO `catalog_product_entity_varchar` VALUES (1,134,0,1,'2'),(2,86,0,1,'Black Hand Strech film'),(3,84,0,1,'Black Hand Strech film'),(4,124,0,1,'0'),(5,73,0,1,'Black Hand Strech film'),(6,106,0,1,'container2'),(7,104,0,1,'product-full-width'),(8,159,0,1,'0'),(9,121,0,1,'black-hand-strech-film'),(10,158,0,1,'default'),(11,87,0,1,'/1/_/1_2.jpg'),(12,88,0,1,'/1/_/1_2.jpg'),(13,135,0,1,'/b/l/bl1-600x600_2.jpg'),(14,89,0,1,'/1/_/1_2.jpg'),(15,134,0,2,'2'),(16,87,0,2,'/m/a/machineroll_1.png'),(17,124,0,2,'0'),(18,73,0,2,'Clear Machine stretch film premium HD'),(19,106,0,2,'container2'),(20,104,0,2,'product-full-width'),(21,159,0,2,'0'),(22,158,0,2,'default'),(23,88,0,2,'/m/a/machineroll_1.png'),(24,135,0,2,'no_selection'),(25,89,0,2,'/m/a/machineroll_1.png'),(26,121,0,2,'black-hand-strech-film-1'),(27,134,0,3,'2'),(28,87,0,3,'/p/4/p4-1-600x600_1.jpg'),(29,124,0,3,'0'),(30,73,0,3,'Clear Hand Strech Film'),(31,106,0,3,'container2'),(32,104,0,3,'product-full-width'),(33,159,0,3,'0'),(34,158,0,3,'default'),(35,88,0,3,'/p/4/p4-1-600x600_1.jpg'),(36,135,0,3,'no_selection'),(37,89,0,3,'/p/4/p4-1-600x600_1.jpg'),(38,121,0,3,'clear-hand-strech-film'),(39,134,0,4,'2'),(40,87,0,4,'/m/e/metro-600x600_1.jpg'),(41,124,0,4,'0'),(42,73,0,4,'Colour Machine Stretch Film'),(43,106,0,4,'container2'),(44,104,0,4,'product-full-width'),(45,159,0,4,'0'),(46,158,0,4,'default'),(47,88,0,4,'/m/e/metro-600x600_1.jpg'),(48,135,0,4,'no_selection'),(49,89,0,4,'/m/e/metro-600x600_1.jpg'),(50,121,0,4,'black-hand-strech-film-3'),(51,134,0,5,'2'),(52,87,0,5,'/6/-/6-600x600.jpg'),(53,124,0,5,'0'),(54,73,0,5,'36 Rolls 48mm x 75m x 45mic Brown Packing Sealing Tapes'),(55,106,0,5,'container2'),(56,104,0,5,'product-full-width'),(57,159,0,5,'0'),(58,158,0,5,'default'),(59,88,0,5,'/6/-/6-600x600.jpg'),(60,135,0,5,'no_selection'),(61,89,0,5,'/6/-/6-600x600.jpg'),(62,121,0,5,'brown-packing-sealing-tapes'),(63,134,0,6,'2'),(64,87,0,6,'/8/-/8-600x600.jpg'),(65,124,0,6,'0'),(66,73,0,6,'Polyester Strapping'),(67,106,0,6,'container2'),(68,104,0,6,'product-full-width'),(69,159,0,6,'0'),(70,158,0,6,'default'),(71,88,0,6,'/8/-/8-600x600.jpg'),(72,135,0,6,'no_selection'),(73,89,0,6,'/8/-/8-600x600.jpg'),(74,121,0,6,'polyester-strapping'),(75,73,0,7,'Reusable-Bag - Large'),(76,106,0,7,'container2'),(77,121,0,7,'reusable-bag-large'),(78,124,0,7,'0'),(79,73,0,8,'Reusable-Bag - Medium'),(80,106,0,8,'container2'),(81,121,0,8,'reusable-bag-medium'),(82,124,0,8,'0'),(83,73,0,9,'Reusable-Bag - Small'),(84,106,0,9,'container2'),(85,121,0,9,'reusable-bag-small'),(86,124,0,9,'0'),(87,73,0,10,'Cling Wrap 45cmx600mm'),(88,106,0,10,'container2'),(89,121,0,10,'cling-wrap-45cmx600mm'),(90,124,0,10,'0'),(91,73,0,11,'Heavy Duty Cling Wrap-45cmx600'),(92,106,0,11,'container2'),(93,121,0,11,'heavy-duty-cling-wrap-45cmx600'),(94,124,0,11,'0'),(95,73,0,12,'Top Load Only Tape 36micx48mmx66m'),(96,106,0,12,'container2'),(97,121,0,12,'top-load-only-tape-36micx48mmx66m'),(98,124,0,12,'0'),(99,73,0,13,'CLEAR PACKAGING TAPE 50 Micx48mmx75m'),(100,106,0,13,'container2'),(101,121,0,13,'clear-packaging-tape-50-micx48mmx75m'),(102,124,0,13,'0'),(103,73,0,14,'Machine Tape 48x1000Mx50Mic /6'),(104,106,0,14,'container2'),(105,121,0,14,'machine-tape-48x1000mx50mic-6'),(106,124,0,14,'0'),(107,73,0,15,'Brown Tape 36micx48mmx66m'),(108,106,0,15,'container2'),(109,121,0,15,'brown-tape-36micx48mmx66m'),(110,124,0,15,'0'),(111,73,0,16,'Fragile Tape 36mic*48mm*66m'),(112,106,0,16,'container2'),(113,121,0,16,'fragile-tape-36mic-48mm-66m'),(114,124,0,16,'0'),(115,73,0,17,'10mic Machine Film'),(116,106,0,17,'container2'),(117,121,0,17,'10mic-machine-film'),(118,124,0,17,'0'),(119,73,0,18,'17mic Machine film'),(120,106,0,18,'container2'),(121,121,0,18,'17mic-machine-film'),(122,124,0,18,'0'),(123,73,0,19,'20mic Machine film'),(124,106,0,19,'container2'),(125,121,0,19,'20mic-machine-film'),(126,124,0,19,'0'),(127,73,0,20,'50um Blue Jumbo Pallet Bag'),(128,106,0,20,'container2'),(129,121,0,20,'50um-blue-jumbo-pallet-bag'),(130,124,0,20,'0'),(131,73,0,21,'45mic 125L Bin Liner'),(132,106,0,21,'container2'),(133,121,0,21,'45mic-125l-bin-liner'),(134,124,0,21,'0'),(135,73,0,22,'12 UMx500mmx 2850M CAST 250%'),(136,106,0,22,'container2'),(137,121,0,22,'12-umx500mmx-2850m-cast-250'),(138,124,0,22,'0'),(139,73,0,23,'12UM MACHINE STRETCH FILM 300%'),(140,106,0,23,'container2'),(141,121,0,23,'12um-machine-stretch-film-300'),(142,124,0,23,'0'),(143,73,0,24,'Plastic Buckles 12mm (bag 1000)'),(144,106,0,24,'container2'),(145,121,0,24,'plastic-buckles-12mm-bag-1000'),(146,124,0,24,'0'),(147,73,0,25,'15 UM 500MM X 2200XCLEAR CAST'),(148,106,0,25,'container2'),(149,121,0,25,'15-um-500mm-x-2200xclear-cast'),(150,124,0,25,'0'),(151,73,0,26,'Heavy Duty 15mm'),(152,106,0,26,'container2'),(153,121,0,26,'heavy-duty-15mm'),(154,124,0,26,'0'),(155,73,0,27,'17 UMx500mx3 Kg Clear Hand'),(156,106,0,27,'container2'),(157,121,0,27,'17-umx500mx3-kg-clear-hand'),(158,124,0,27,'0'),(159,73,0,28,'500MM X1980MX 17 UM CAST CLEAR'),(160,106,0,28,'container2'),(161,121,0,28,'500mm-x1980mx-17-um-cast-clear'),(162,124,0,28,'0'),(163,73,0,29,'20 UM 500 mm x 3 Kg CLEAR hand'),(164,106,0,29,'container2'),(165,121,0,29,'20-um-500-mm-x-3-kg-clear-hand'),(166,124,0,29,'0'),(167,73,0,30,'500mmx2200Mx20 UM Clear Cast'),(168,106,0,30,'container2'),(169,121,0,30,'500mmx2200mx20-um-clear-cast'),(170,124,0,30,'0'),(171,73,0,31,'20UMx500mmx2200M Clear PWR'),(172,106,0,31,'container2'),(173,121,0,31,'20umx500mmx2200m-clear-pwr'),(174,124,0,31,'0'),(175,73,0,32,'20UM 500mm x1690m CAST ST'),(176,106,0,32,'container2'),(177,121,0,32,'20um-500mm-x1690m-cast-st'),(178,124,0,32,'0'),(179,73,0,33,'23 UM Black Hand Rolls'),(180,106,0,33,'container2'),(181,121,0,33,'23-um-black-hand-rolls'),(182,124,0,33,'0'),(183,73,0,34,'23-UM Clear Hand Rolls'),(184,106,0,34,'container2'),(185,121,0,34,'23-um-clear-hand-rolls'),(186,124,0,34,'0'),(187,73,0,35,'23um 3.5kg Hand Films'),(188,106,0,35,'container2'),(189,121,0,35,'23um-3-5kg-hand-films'),(190,124,0,35,'0'),(191,73,0,36,'23 MIC MACHINE STRETCH FILM'),(192,106,0,36,'container2'),(193,121,0,36,'23-mic-machine-stretch-film'),(194,124,0,36,'0'),(195,73,0,37,'25 UM- HAND ROLL (HD) BLACK'),(196,106,0,37,'container2'),(197,121,0,37,'25-um-hand-roll-hd-black'),(198,124,0,37,'0'),(199,73,0,38,'25UMX500MMX1450Cast Black Mach'),(200,106,0,38,'container2'),(201,121,0,38,'25umx500mmx1450cast-black-mach'),(202,124,0,38,'0'),(203,73,0,39,'25 um 500mm X 3kg Clear'),(204,106,0,39,'container2'),(205,121,0,39,'25-um-500mm-x-3kg-clear'),(206,124,0,39,'0'),(207,73,0,40,'25 UMX500mm CLEAR Machine'),(208,106,0,40,'container2'),(209,121,0,40,'25-umx500mm-clear-machine'),(210,124,0,40,'0'),(211,73,0,41,'30 MIC MACHINE STRETCH'),(212,106,0,41,'container2'),(213,121,0,41,'30-mic-machine-stretch'),(214,124,0,41,'0'),(215,73,0,42,'45cm Everfilm Clear'),(216,106,0,42,'container2'),(217,121,0,42,'45cm-everfilm-clear'),(218,124,0,42,'0'),(219,73,0,43,'Full Size Butcher paper'),(220,106,0,43,'container2'),(221,121,0,43,'full-size-butcher-paper'),(222,124,0,43,'0'),(223,73,0,44,'CLEANING WIPES(30X50-CM) 6ROLL'),(224,106,0,44,'container2'),(225,121,0,44,'cleaning-wipes-30x50-cm-6roll'),(226,124,0,44,'0'),(227,73,0,45,'Blue Food Bin Liner'),(228,106,0,45,'container2'),(229,121,0,45,'blue-food-bin-liner'),(230,124,0,45,'0'),(231,73,0,46,'Stretch Wrap Dispenser (Hand)'),(232,106,0,46,'container2'),(233,121,0,46,'stretch-wrap-dispenser-hand'),(234,124,0,46,'0'),(235,73,0,47,'GARBAGE BAGS-120-LT (hd)'),(236,106,0,47,'container2'),(237,121,0,47,'garbage-bags-120-lt-hd'),(238,124,0,47,'0'),(239,73,0,48,'240L Garbage Bag Black'),(240,106,0,48,'container2'),(241,121,0,48,'240l-garbage-bag-black'),(242,124,0,48,'0'),(243,73,0,49,'Heavy Duty 82L Garbage Bag'),(244,106,0,49,'container2'),(245,121,0,49,'heavy-duty-82l-garbage-bag'),(246,124,0,49,'0'),(247,73,0,50,'Bread Crate Liner'),(248,106,0,50,'container2'),(249,121,0,50,'bread-crate-liner'),(250,124,0,50,'0'),(251,73,0,51,'MEATFILM 600mmX1300M'),(252,106,0,51,'container2'),(253,121,0,51,'meatfilm-600mmx1300m'),(254,124,0,51,'0'),(255,73,0,52,'Dispenser Napkin 1 Ply'),(256,106,0,52,'container2'),(257,121,0,52,'dispenser-napkin-1-ply'),(258,124,0,52,'0'),(259,73,0,53,'Drinking Cup-320ml/12oz (1000)'),(260,106,0,53,'container2'),(261,121,0,53,'drinking-cup-320ml-12oz-1000'),(262,124,0,53,'0'),(263,73,0,54,'Plastic Plate Round 180mm WH'),(264,106,0,54,'container2'),(265,121,0,54,'plastic-plate-round-180mm-wh'),(266,124,0,54,'0'),(267,73,0,55,'Strap Heavy Duty 15Mmmx0.7'),(268,106,0,55,'container2'),(269,121,0,55,'strap-heavy-duty-15mmmx0-7'),(270,124,0,55,'0'),(271,73,0,56,'Green Polyester Strap Embossed'),(272,106,0,56,'container2'),(273,121,0,56,'green-polyester-strap-embossed'),(274,124,0,56,'0'),(275,73,0,57,'Economy Wooden Spoon 160mm'),(276,106,0,57,'container2'),(277,121,0,57,'economy-wooden-spoon-160mm'),(278,124,0,57,'0'),(279,73,0,58,'Blue Nitrile Gloves S-XL'),(280,106,0,58,'container2'),(281,121,0,58,'blue-nitrile-gloves-s-xl'),(282,124,0,58,'0'),(283,73,0,59,'White paper cup 6oz'),(284,106,0,59,'container2'),(285,121,0,59,'white-paper-cup-6oz'),(286,124,0,59,'0'),(287,73,0,60,'Paper Cups 8oz (1000pcs)'),(288,106,0,60,'container2'),(289,121,0,60,'paper-cups-8oz-1000pcs'),(290,124,0,60,'0'),(291,73,0,61,'210x230 Interleaved Hand Towel'),(292,106,0,61,'container2'),(293,121,0,61,'210x230-interleaved-hand-towel'),(294,124,0,61,'0'),(295,73,0,62,'Blue Apron'),(296,106,0,62,'container2'),(297,121,0,62,'blue-apron'),(298,124,0,62,'0'),(299,73,0,63,'Glove Cotton 12pcs (men)'),(300,106,0,63,'container2'),(301,121,0,63,'glove-cotton-12pcs-men'),(302,124,0,63,'0'),(303,73,0,64,'BLACK Nitrile Gloves S-XL'),(304,106,0,64,'container2'),(305,121,0,64,'black-nitrile-gloves-s-xl'),(306,124,0,64,'0'),(307,73,0,65,'Nitrile GLOVES White S-XL'),(308,106,0,65,'container2'),(309,121,0,65,'nitrile-gloves-white-s-xl'),(310,124,0,65,'0'),(311,73,0,66,'Vinyl-Gloves- S-XL (100)'),(312,106,0,66,'container2'),(313,121,0,66,'vinyl-gloves-s-xl-100'),(314,124,0,66,'0'),(315,73,0,67,'Produce Rolls/9 bags'),(316,106,0,67,'container2'),(317,121,0,67,'produce-rolls-9-bags'),(318,124,0,67,'0'),(319,73,0,68,'Roll Towel/80M-16/box'),(320,106,0,68,'container2'),(321,121,0,68,'roll-towel-80m-16-box'),(322,124,0,68,'0'),(323,73,0,69,'12mm x 1000m PE Strap'),(324,106,0,69,'container2'),(325,121,0,69,'12mm-x-1000m-pe-strap'),(326,124,0,69,'0'),(327,73,0,70,'Sugar cane 3 Comp 9\' Dinnerbox'),(328,106,0,70,'container2'),(329,121,0,70,'sugar-cane-3-comp-9-dinnerbox'),(330,124,0,70,'0'),(331,73,0,71,'SUGARCANE LARGE DINNER BOX 9\''),(332,106,0,71,'container2'),(333,121,0,71,'sugarcane-large-dinner-box-9'),(334,124,0,71,'0'),(335,73,0,72,'Paper Table Cover'),(336,106,0,72,'container2'),(337,121,0,72,'paper-table-cover'),(338,124,0,72,'0'),(339,73,0,73,'PP202 Clear Tape 48 x 75mm 36/'),(340,106,0,73,'container2'),(341,121,0,73,'pp202-clear-tape-48-x-75mm-36'),(342,124,0,73,'0');
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_varchar_after_insert` AFTER INSERT ON `catalog_product_entity_varchar` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_varchar_after_update` AFTER UPDATE ON `catalog_product_entity_varchar` FOR EACH ROW BEGIN
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
IF (NOT(NEW.`value_id` <=> OLD.`value_id`) OR NOT(NEW.`attribute_id` <=> OLD.`attribute_id`) OR NOT(NEW.`store_id` <=> OLD.`store_id`) OR NOT(NEW.`entity_id` <=> OLD.`entity_id`) OR NOT(NEW.`value` <=> OLD.`value`)) THEN INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (NEW.`entity_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`root`@`localhost`*/ /*!50003 TRIGGER `trg_catalog_product_entity_varchar_after_delete` AFTER DELETE ON `catalog_product_entity_varchar` FOR EACH ROW BEGIN
INSERT IGNORE INTO `catalogsearch_fulltext_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalog_product_attribute_cl` (`entity_id`) VALUES (OLD.`entity_id`);
INSERT IGNORE INTO `catalogrule_product_cl` (`entity_id`) VALUES (OLD.`entity_id`);
END */;;
DELIMITER ;

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

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

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


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

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

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

INSERT INTO `catalog_product_index_eav` VALUES (1,99,1,4,1),(2,99,1,4,2),(3,99,1,4,3),(4,99,1,4,4),(5,99,1,4,5),(6,99,1,4,6),(7,99,1,4,7),(8,99,1,4,8),(9,99,1,4,9),(10,99,1,4,10),(11,99,1,4,11),(12,99,1,4,12),(13,99,1,4,13),(14,99,1,4,14),(15,99,1,4,15),(16,99,1,4,16),(17,99,1,4,17),(18,99,1,4,18),(19,99,1,4,19),(20,99,1,4,20),(21,99,1,4,21),(22,99,1,4,22),(23,99,1,4,23),(24,99,1,4,24),(25,99,1,4,25),(26,99,1,4,26),(27,99,1,4,27),(28,99,1,4,28),(29,99,1,4,29),(30,99,1,4,30),(31,99,1,4,31),(32,99,1,4,32),(33,99,1,4,33),(34,99,1,4,34),(35,99,1,4,35),(36,99,1,4,36),(37,99,1,4,37),(38,99,1,4,38),(39,99,1,4,39),(40,99,1,4,40),(41,99,1,4,41),(42,99,1,4,42),(43,99,1,4,43),(44,99,1,4,44),(45,99,1,4,45),(46,99,1,4,46),(47,99,1,4,47),(48,99,1,4,48),(49,99,1,4,49),(50,99,1,4,50),(51,99,1,4,51),(52,99,1,4,52),(53,99,1,4,53),(54,99,1,4,54),(55,99,1,4,55),(56,99,1,4,56),(57,99,1,4,57),(58,99,1,4,58),(59,99,1,4,59),(60,99,1,4,60),(61,99,1,4,61),(62,99,1,4,62),(63,99,1,4,63),(64,99,1,4,64),(65,99,1,4,65),(66,99,1,4,66),(67,99,1,4,67),(68,99,1,4,68),(69,99,1,4,69),(70,99,1,4,70),(71,99,1,4,71),(72,99,1,4,72),(73,99,1,4,73);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

INSERT INTO `catalog_product_index_eav_replica` VALUES (1,99,1,4,1),(2,99,1,4,2),(3,99,1,4,3),(4,99,1,4,4),(5,99,1,4,5),(6,99,1,4,6),(7,99,1,4,7),(8,99,1,4,8),(9,99,1,4,9),(10,99,1,4,10),(11,99,1,4,11),(12,99,1,4,12),(13,99,1,4,13),(14,99,1,4,14),(15,99,1,4,15),(16,99,1,4,16),(17,99,1,4,17),(18,99,1,4,18),(19,99,1,4,19),(20,99,1,4,20),(21,99,1,4,21),(22,99,1,4,22),(23,99,1,4,23),(24,99,1,4,24),(25,99,1,4,25),(26,99,1,4,26),(27,99,1,4,27),(28,99,1,4,28),(29,99,1,4,29),(30,99,1,4,30),(31,99,1,4,31),(32,99,1,4,32),(33,99,1,4,33),(34,99,1,4,34),(35,99,1,4,35),(36,99,1,4,36),(37,99,1,4,37),(38,99,1,4,38),(39,99,1,4,39),(40,99,1,4,40),(41,99,1,4,41),(42,99,1,4,42),(43,99,1,4,43),(44,99,1,4,44),(45,99,1,4,45),(46,99,1,4,46),(47,99,1,4,47),(48,99,1,4,48),(49,99,1,4,49),(50,99,1,4,50),(51,99,1,4,51),(52,99,1,4,52),(53,99,1,4,53),(54,99,1,4,54),(55,99,1,4,55),(56,99,1,4,56),(57,99,1,4,57),(58,99,1,4,58),(59,99,1,4,59),(60,99,1,4,60),(61,99,1,4,61),(62,99,1,4,62),(63,99,1,4,63),(64,99,1,4,64),(65,99,1,4,65),(66,99,1,4,66),(67,99,1,4,67),(68,99,1,4,68),(69,99,1,4,69),(70,99,1,4,70),(71,99,1,4,71),(72,99,1,4,72),(73,99,1,4,73);

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

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

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


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

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

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

INSERT INTO `catalog_product_index_price` VALUES (1,0,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(1,1,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(1,2,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(1,3,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(2,0,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(2,1,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(2,2,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(2,3,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(3,0,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(3,1,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(3,2,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(3,3,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(4,0,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(4,1,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(4,2,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(4,3,1,2,10.000000,8.500000,8.500000,8.500000,NULL),(5,0,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(5,1,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(5,2,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(5,3,1,2,10.000000,10.000000,10.000000,10.000000,NULL),(6,0,1,2,10.000000,7.500000,7.500000,7.500000,NULL),(6,1,1,2,10.000000,7.500000,7.500000,7.500000,NULL),(6,2,1,2,10.000000,7.500000,7.500000,7.500000,NULL),(6,3,1,2,10.000000,7.500000,7.500000,7.500000,NULL),(7,0,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(7,1,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(7,2,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(7,3,1,2,11.000000,11.000000,11.000000,11.000000,NULL),(8,0,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(8,1,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(8,2,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(8,3,1,2,12.000000,12.000000,12.000000,12.000000,NULL),(9,0,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(9,1,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(9,2,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(9,3,1,2,13.000000,13.000000,13.000000,13.000000,NULL),(10,0,1,2,14.000000,14.000000,14.000000,14.000000,NULL),(10,1,1,2,14.000000,14.000000,14.000000,14.000000,NULL),(10,2,1,2,14.000000,14.000000,14.000000,14.000000,NULL),(10,3,1,2,14.000000,14.000000,14.000000,14.000000,NULL),(11,0,1,2,15.000000,15.000000,15.000000,15.000000,NULL),(11,1,1,2,15.000000,15.000000,15.000000,15.000000,NULL),(11,2,1,2,15.000000,15.000000,15.000000,15.000000,NULL),(11,3,1,2,15.000000,15.000000,15.000000,15.000000,NULL),(12,0,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(12,1,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(12,2,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(12,3,1,2,16.000000,16.000000,16.000000,16.000000,NULL),(13,0,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(13,1,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(13,2,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(13,3,1,2,17.000000,17.000000,17.000000,17.000000,NULL),(14,0,1,2,18.000000,18.000000,18.000000,18.000000,NULL),(14,1,1,2,18.000000,18.000000,18.000000,18.000000,NULL),(14,2,1,2,18.000000,18.000000,18.000000,18.000000,NULL),(14,3,1,2,18.000000,18.000000,18.000000,18.000000,NULL),(15,0,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(15,1,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(15,2,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(15,3,1,2,19.000000,19.000000,19.000000,19.000000,NULL),(16,0,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(16,1,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(16,2,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(16,3,1,2,20.000000,20.000000,20.000000,20.000000,NULL),(17,0,1,2,21.000000,21.000000,21.000000,21.000000,NULL),(17,1,1,2,21.000000,21.000000,21.000000,21.000000,NULL),(17,2,1,2,21.000000,21.000000,21.000000,21.000000,NULL),(17,3,1,2,21.000000,21.000000,21.000000,21.000000,NULL),(18,0,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(18,1,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(18,2,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(18,3,1,2,22.000000,22.000000,22.000000,22.000000,NULL),(19,0,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(19,1,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(19,2,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(19,3,1,2,23.000000,23.000000,23.000000,23.000000,NULL),(20,0,1,2,24.000000,24.000000,24.000000,24.000000,NULL),(20,1,1,2,24.000000,24.000000,24.000000,24.000000,NULL),(20,2,1,2,24.000000,24.000000,24.000000,24.000000,NULL),(20,3,1,2,24.000000,24.000000,24.000000,24.000000,NULL),(21,0,1,2,25.000000,25.000000,25.000000,25.000000,NULL),(21,1,1,2,25.000000,25.000000,25.000000,25.000000,NULL),(21,2,1,2,25.000000,25.000000,25.000000,25.000000,NULL),(21,3,1,2,25.000000,25.000000,25.000000,25.000000,NULL),(22,0,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(22,1,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(22,2,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(22,3,1,2,26.000000,26.000000,26.000000,26.000000,NULL),(23,0,1,2,27.000000,27.000000,27.000000,27.000000,NULL),(23,1,1,2,27.000000,27.000000,27.000000,27.000000,NULL),(23,2,1,2,27.000000,27.000000,27.000000,27.000000,NULL),(23,3,1,2,27.000000,27.000000,27.000000,27.000000,NULL),(24,0,1,2,28.000000,28.000000,28.000000,28.000000,NULL),(24,1,1,2,28.000000,28.000000,28.000000,28.000000,NULL),(24,2,1,2,28.000000,28.000000,28.000000,28.000000,NULL),(24,3,1,2,28.000000,28.000000,28.000000,28.000000,NULL),(25,0,1,2,29.000000,29.000000,29.000000,29.000000,NULL),(25,1,1,2,29.000000,29.000000,29.000000,29.000000,NULL),(25,2,1,2,29.000000,29.000000,29.000000,29.000000,NULL),(25,3,1,2,29.000000,29.000000,29.000000,29.000000,NULL),(26,0,1,2,30.000000,30.000000,30.000000,30.000000,NULL),(26,1,1,2,30.000000,30.000000,30.000000,30.000000,NULL),(26,2,1,2,30.000000,30.000000,30.000000,30.000000,NULL),(26,3,1,2,30.000000,30.000000,30.000000,30.000000,NULL),(27,0,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(27,1,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(27,2,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(27,3,1,2,31.000000,31.000000,31.000000,31.000000,NULL),(28,0,1,2,32.000000,32.000000,32.000000,32.000000,NULL),(28,1,1,2,32.000000,32.000000,32.000000,32.000000,NULL),(28,2,1,2,32.000000,32.000000,32.000000,32.000000,NULL),(28,3,1,2,32.000000,32.000000,32.000000,32.000000,NULL),(29,0,1,2,33.000000,33.000000,33.000000,33.000000,NULL),(29,1,1,2,33.000000,33.000000,33.000000,33.000000,NULL),(29,2,1,2,33.000000,33.000000,33.000000,33.000000,NULL),(29,3,1,2,33.000000,33.000000,33.000000,33.000000,NULL),(30,0,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(30,1,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(30,2,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(30,3,1,2,34.000000,34.000000,34.000000,34.000000,NULL),(31,0,1,2,35.000000,35.000000,35.000000,35.000000,NULL),(31,1,1,2,35.000000,35.000000,35.000000,35.000000,NULL),(31,2,1,2,35.000000,35.000000,35.000000,35.000000,NULL),(31,3,1,2,35.000000,35.000000,35.000000,35.000000,NULL),(32,0,1,2,36.000000,36.000000,36.000000,36.000000,NULL),(32,1,1,2,36.000000,36.000000,36.000000,36.000000,NULL),(32,2,1,2,36.000000,36.000000,36.000000,36.000000,NULL),(32,3,1,2,36.000000,36.000000,36.000000,36.000000,NULL),(33,0,1,2,37.000000,37.000000,37.000000,37.000000,NULL),(33,1,1,2,37.000000,37.000000,37.000000,37.000000,NULL),(33,2,1,2,37.000000,37.000000,37.000000,37.000000,NULL),(33,3,1,2,37.000000,37.000000,37.000000,37.000000,NULL),(34,0,1,2,38.000000,38.000000,38.000000,38.000000,NULL),(34,1,1,2,38.000000,38.000000,38.000000,38.000000,NULL),(34,2,1,2,38.000000,38.000000,38.000000,38.000000,NULL),(34,3,1,2,38.000000,38.000000,38.000000,38.000000,NULL),(35,0,1,2,39.000000,39.000000,39.000000,39.000000,NULL),(35,1,1,2,39.000000,39.000000,39.000000,39.000000,NULL),(35,2,1,2,39.000000,39.000000,39.000000,39.000000,NULL),(35,3,1,2,39.000000,39.000000,39.000000,39.000000,NULL),(36,0,1,2,40.000000,40.000000,40.000000,40.000000,NULL),(36,1,1,2,40.000000,40.000000,40.000000,40.000000,NULL),(36,2,1,2,40.000000,40.000000,40.000000,40.000000,NULL),(36,3,1,2,40.000000,40.000000,40.000000,40.000000,NULL),(37,0,1,2,41.000000,41.000000,41.000000,41.000000,NULL),(37,1,1,2,41.000000,41.000000,41.000000,41.000000,NULL),(37,2,1,2,41.000000,41.000000,41.000000,41.000000,NULL),(37,3,1,2,41.000000,41.000000,41.000000,41.000000,NULL),(38,0,1,2,42.000000,42.000000,42.000000,42.000000,NULL),(38,1,1,2,42.000000,42.000000,42.000000,42.000000,NULL),(38,2,1,2,42.000000,42.000000,42.000000,42.000000,NULL),(38,3,1,2,42.000000,42.000000,42.000000,42.000000,NULL),(39,0,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(39,1,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(39,2,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(39,3,1,2,43.000000,43.000000,43.000000,43.000000,NULL),(40,0,1,2,44.000000,44.000000,44.000000,44.000000,NULL),(40,1,1,2,44.000000,44.000000,44.000000,44.000000,NULL),(40,2,1,2,44.000000,44.000000,44.000000,44.000000,NULL),(40,3,1,2,44.000000,44.000000,44.000000,44.000000,NULL),(41,0,1,2,45.000000,45.000000,45.000000,45.000000,NULL),(41,1,1,2,45.000000,45.000000,45.000000,45.000000,NULL),(41,2,1,2,45.000000,45.000000,45.000000,45.000000,NULL),(41,3,1,2,45.000000,45.000000,45.000000,45.000000,NULL),(42,0,1,2,46.000000,46.000000,46.000000,46.000000,NULL),(42,1,1,2,46.000000,46.000000,46.000000,46.000000,NULL),(42,2,1,2,46.000000,46.000000,46.000000,46.000000,NULL),(42,3,1,2,46.000000,46.000000,46.000000,46.000000,NULL),(43,0,1,2,47.000000,47.000000,47.000000,47.000000,NULL),(43,1,1,2,47.000000,47.000000,47.000000,47.000000,NULL),(43,2,1,2,47.000000,47.000000,47.000000,47.000000,NULL),(43,3,1,2,47.000000,47.000000,47.000000,47.000000,NULL),(44,0,1,2,48.000000,48.000000,48.000000,48.000000,NULL),(44,1,1,2,48.000000,48.000000,48.000000,48.000000,NULL),(44,2,1,2,48.000000,48.000000,48.000000,48.000000,NULL),(44,3,1,2,48.000000,48.000000,48.000000,48.000000,NULL),(45,0,1,2,49.000000,49.000000,49.000000,49.000000,NULL),(45,1,1,2,49.000000,49.000000,49.000000,49.000000,NULL),(45,2,1,2,49.000000,49.000000,49.000000,49.000000,NULL),(45,3,1,2,49.000000,49.000000,49.000000,49.000000,NULL),(46,0,1,2,50.000000,50.000000,50.000000,50.000000,NULL),(46,1,1,2,50.000000,50.000000,50.000000,50.000000,NULL),(46,2,1,2,50.000000,50.000000,50.000000,50.000000,NULL),(46,3,1,2,50.000000,50.000000,50.000000,50.000000,NULL),(47,0,1,2,51.000000,51.000000,51.000000,51.000000,NULL),(47,1,1,2,51.000000,51.000000,51.000000,51.000000,NULL),(47,2,1,2,51.000000,51.000000,51.000000,51.000000,NULL),(47,3,1,2,51.000000,51.000000,51.000000,51.000000,NULL),(48,0,1,2,52.000000,52.000000,52.000000,52.000000,NULL),(48,1,1,2,52.000000,52.000000,52.000000,52.000000,NULL),(48,2,1,2,52.000000,52.000000,52.000000,52.000000,NULL),(48,3,1,2,52.000000,52.000000,52.000000,52.000000,NULL),(49,0,1,2,53.000000,53.000000,53.000000,53.000000,NULL),(49,1,1,2,53.000000,53.000000,53.000000,53.000000,NULL),(49,2,1,2,53.000000,53.000000,53.000000,53.000000,NULL),(49,3,1,2,53.000000,53.000000,53.000000,53.000000,NULL),(50,0,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(50,1,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(50,2,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(50,3,1,2,54.000000,54.000000,54.000000,54.000000,NULL),(51,0,1,2,55.000000,55.000000,55.000000,55.000000,NULL),(51,1,1,2,55.000000,55.000000,55.000000,55.000000,NULL),(51,2,1,2,55.000000,55.000000,55.000000,55.000000,NULL),(51,3,1,2,55.000000,55.000000,55.000000,55.000000,NULL),(52,0,1,2,56.000000,56.000000,56.000000,56.000000,NULL),(52,1,1,2,56.000000,56.000000,56.000000,56.000000,NULL),(52,2,1,2,56.000000,56.000000,56.000000,56.000000,NULL),(52,3,1,2,56.000000,56.000000,56.000000,56.000000,NULL),(53,0,1,2,57.000000,57.000000,57.000000,57.000000,NULL),(53,1,1,2,57.000000,57.000000,57.000000,57.000000,NULL),(53,2,1,2,57.000000,57.000000,57.000000,57.000000,NULL),(53,3,1,2,57.000000,57.000000,57.000000,57.000000,NULL),(54,0,1,2,58.000000,58.000000,58.000000,58.000000,NULL),(54,1,1,2,58.000000,58.000000,58.000000,58.000000,NULL),(54,2,1,2,58.000000,58.000000,58.000000,58.000000,NULL),(54,3,1,2,58.000000,58.000000,58.000000,58.000000,NULL),(55,0,1,2,59.000000,59.000000,59.000000,59.000000,NULL),(55,1,1,2,59.000000,59.000000,59.000000,59.000000,NULL),(55,2,1,2,59.000000,59.000000,59.000000,59.000000,NULL),(55,3,1,2,59.000000,59.000000,59.000000,59.000000,NULL),(56,0,1,2,60.000000,60.000000,60.000000,60.000000,NULL),(56,1,1,2,60.000000,60.000000,60.000000,60.000000,NULL),(56,2,1,2,60.000000,60.000000,60.000000,60.000000,NULL),(56,3,1,2,60.000000,60.000000,60.000000,60.000000,NULL),(57,0,1,2,61.000000,61.000000,61.000000,61.000000,NULL),(57,1,1,2,61.000000,61.000000,61.000000,61.000000,NULL),(57,2,1,2,61.000000,61.000000,61.000000,61.000000,NULL),(57,3,1,2,61.000000,61.000000,61.000000,61.000000,NULL),(58,0,1,2,62.000000,62.000000,62.000000,62.000000,NULL),(58,1,1,2,62.000000,62.000000,62.000000,62.000000,NULL),(58,2,1,2,62.000000,62.000000,62.000000,62.000000,NULL),(58,3,1,2,62.000000,62.000000,62.000000,62.000000,NULL),(59,0,1,2,63.000000,63.000000,63.000000,63.000000,NULL),(59,1,1,2,63.000000,63.000000,63.000000,63.000000,NULL),(59,2,1,2,63.000000,63.000000,63.000000,63.000000,NULL),(59,3,1,2,63.000000,63.000000,63.000000,63.000000,NULL),(60,0,1,2,64.000000,64.000000,64.000000,64.000000,NULL),(60,1,1,2,64.000000,64.000000,64.000000,64.000000,NULL),(60,2,1,2,64.000000,64.000000,64.000000,64.000000,NULL),(60,3,1,2,64.000000,64.000000,64.000000,64.000000,NULL),(61,0,1,2,65.000000,65.000000,65.000000,65.000000,NULL),(61,1,1,2,65.000000,65.000000,65.000000,65.000000,NULL),(61,2,1,2,65.000000,65.000000,65.000000,65.000000,NULL),(61,3,1,2,65.000000,65.000000,65.000000,65.000000,NULL),(62,0,1,2,66.000000,66.000000,66.000000,66.000000,NULL),(62,1,1,2,66.000000,66.000000,66.000000,66.000000,NULL),(62,2,1,2,66.000000,66.000000,66.000000,66.000000,NULL),(62,3,1,2,66.000000,66.000000,66.000000,66.000000,NULL),(63,0,1,2,67.000000,67.000000,67.000000,67.000000,NULL),(63,1,1,2,67.000000,67.000000,67.000000,67.000000,NULL),(63,2,1,2,67.000000,67.000000,67.000000,67.000000,NULL),(63,3,1,2,67.000000,67.000000,67.000000,67.000000,NULL),(64,0,1,2,68.000000,68.000000,68.000000,68.000000,NULL),(64,1,1,2,68.000000,68.000000,68.000000,68.000000,NULL),(64,2,1,2,68.000000,68.000000,68.000000,68.000000,NULL),(64,3,1,2,68.000000,68.000000,68.000000,68.000000,NULL),(65,0,1,2,69.000000,69.000000,69.000000,69.000000,NULL),(65,1,1,2,69.000000,69.000000,69.000000,69.000000,NULL),(65,2,1,2,69.000000,69.000000,69.000000,69.000000,NULL),(65,3,1,2,69.000000,69.000000,69.000000,69.000000,NULL),(66,0,1,2,70.000000,70.000000,70.000000,70.000000,NULL),(66,1,1,2,70.000000,70.000000,70.000000,70.000000,NULL),(66,2,1,2,70.000000,70.000000,70.000000,70.000000,NULL),(66,3,1,2,70.000000,70.000000,70.000000,70.000000,NULL),(67,0,1,2,71.000000,71.000000,71.000000,71.000000,NULL),(67,1,1,2,71.000000,71.000000,71.000000,71.000000,NULL),(67,2,1,2,71.000000,71.000000,71.000000,71.000000,NULL),(67,3,1,2,71.000000,71.000000,71.000000,71.000000,NULL),(68,0,1,2,72.000000,72.000000,72.000000,72.000000,NULL),(68,1,1,2,72.000000,72.000000,72.000000,72.000000,NULL),(68,2,1,2,72.000000,72.000000,72.000000,72.000000,NULL),(68,3,1,2,72.000000,72.000000,72.000000,72.000000,NULL),(69,0,1,2,73.000000,73.000000,73.000000,73.000000,NULL),(69,1,1,2,73.000000,73.000000,73.000000,73.000000,NULL),(69,2,1,2,73.000000,73.000000,73.000000,73.000000,NULL),(69,3,1,2,73.000000,73.000000,73.000000,73.000000,NULL),(70,0,1,2,74.000000,74.000000,74.000000,74.000000,NULL),(70,1,1,2,74.000000,74.000000,74.000000,74.000000,NULL),(70,2,1,2,74.000000,74.000000,74.000000,74.000000,NULL),(70,3,1,2,74.000000,74.000000,74.000000,74.000000,NULL),(71,0,1,2,75.000000,75.000000,75.000000,75.000000,NULL),(71,1,1,2,75.000000,75.000000,75.000000,75.000000,NULL),(71,2,1,2,75.000000,75.000000,75.000000,75.000000,NULL),(71,3,1,2,75.000000,75.000000,75.000000,75.000000,NULL),(72,0,1,2,76.000000,76.000000,76.000000,76.000000,NULL),(72,1,1,2,76.000000,76.000000,76.000000,76.000000,NULL),(72,2,1,2,76.000000,76.000000,76.000000,76.000000,NULL),(72,3,1,2,76.000000,76.000000,76.000000,76.000000,NULL),(73,0,1,2,77.000000,77.000000,77.000000,77.000000,NULL),(73,1,1,2,77.000000,77.000000,77.000000,77.000000,NULL),(73,2,1,2,77.000000,77.000000,77.000000,77.000000,NULL),(73,3,1,2,77.000000,77.000000,77.000000,77.000000,NULL);

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


--
