-- Dumping data for table `magefan_blog_comment`
--


--
-- Table structure for table `magefan_blog_post`
--

CREATE TABLE `magefan_blog_post` (
  `post_id` int NOT NULL AUTO_INCREMENT COMMENT 'Post ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Post Title',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Post Meta Title',
  `meta_keywords` text COMMENT 'Post Meta Keywords',
  `meta_description` text COMMENT 'Post Meta Description',
  `meta_robots` varchar(255) DEFAULT NULL COMMENT 'Default Robots',
  `structure_data_type` smallint NOT NULL DEFAULT '0' COMMENT 'Rich Snippet / Structured Data',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Post String Identifier',
  `og_title` varchar(255) DEFAULT NULL COMMENT 'Post OG Title',
  `og_description` varchar(255) DEFAULT NULL COMMENT 'Post OG Description',
  `og_img` varchar(255) DEFAULT NULL COMMENT 'Post OG Img',
  `og_type` varchar(255) DEFAULT NULL COMMENT 'Post OG Type',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Post Content Heading',
  `content` mediumtext COMMENT 'Post Content',
  `creation_time` timestamp NULL DEFAULT NULL COMMENT 'Post Creation Time',
  `update_time` timestamp NULL DEFAULT NULL COMMENT 'Post Modification Time',
  `publish_time` timestamp NULL DEFAULT NULL COMMENT 'Post Publish Time',
  `is_active` smallint NOT NULL DEFAULT '1' COMMENT 'Is Post Active',
  `include_in_recent` smallint NOT NULL DEFAULT '1' COMMENT 'Include in Recent Posts',
  `position` smallint NOT NULL DEFAULT '0' COMMENT 'Position',
  `featured_img` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Image',
  `featured_img_alt` varchar(255) DEFAULT NULL COMMENT 'Featured Image Alt',
  `author_id` int DEFAULT NULL COMMENT 'Author ID',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Post Layout',
  `layout_update_xml` text COMMENT 'Post Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Post Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Post Custom Template',
  `custom_layout_update_xml` text COMMENT 'Post Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Post Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Post Custom Theme Active To Date',
  `media_gallery` mediumtext COMMENT 'Media Gallery',
  `secret` varchar(32) DEFAULT NULL COMMENT 'Post Secret',
  `views_count` int DEFAULT NULL COMMENT 'Post Views Count',
  `reading_time` int DEFAULT NULL COMMENT 'Post Reading Time',
  `is_recent_posts_skip` smallint DEFAULT NULL COMMENT 'Is Post Skipped From Recent Posts',
  `short_content` mediumtext COMMENT 'Post Short Content',
  `comments_count` int DEFAULT NULL COMMENT 'Post Comment Counts',
  PRIMARY KEY (`post_id`),
  KEY `MAGEFAN_BLOG_POST_IDENTIFIER` (`identifier`),
  KEY `MAGEFAN_BLOG_POST_AUTHOR_ID` (`author_id`),
  KEY `MAGEFAN_BLOG_POST_VIEWS_COUNT` (`views_count`),
  KEY `MAGEFAN_BLOG_POST_IS_RECENT_POSTS_SKIP` (`is_recent_posts_skip`),
  KEY `MAGEFAN_BLOG_POST_IS_ACTIVE` (`is_active`),
  KEY `MAGEFAN_BLOG_POST_INCLUDE_IN_RECENT` (`include_in_recent`),
  KEY `MAGEFAN_BLOG_POST_PUBLISH_TIME` (`publish_time`),
  FULLTEXT KEY `FTI_A5DB7871E89B230F74EDFBECEB4659FA` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Post Table';

--
-- Dumping data for table `magefan_blog_post`
--

INSERT INTO `magefan_blog_post` VALUES (1,'Magento 2 Blog Post Sample',NULL,'magento 2 blog sample','Magento 2 blog default post.',NULL,0,'magento-2-blog-post-sample',NULL,NULL,NULL,NULL,'Magento 2 Blog Post Sample','<p>Welcome to  extension by .\n                        This is your first post. Edit or delete it, then start blogging!\n                </p>','2024-11-14 04:26:02','2024-11-14 04:26:02','2024-11-14 04:26:02',1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `magefan_blog_post_category`
--

CREATE TABLE `magefan_blog_post_category` (
  `post_id` int NOT NULL COMMENT 'Post ID',
  `category_id` int NOT NULL COMMENT 'Category ID',
  PRIMARY KEY (`post_id`,`category_id`),
  KEY `MAGEFAN_BLOG_POST_CATEGORY_CATEGORY_ID` (`category_id`),
  CONSTRAINT `MAGEFAN_BLOG_POST_CATEGORY_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEFAN_BLOG_POST_CTGR_CTGR_ID_MAGEFAN_BLOG_CTGR_CTGR_ID` FOREIGN KEY (`category_id`) REFERENCES `magefan_blog_category` (`category_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Post To Category Linkage Table';

--
-- Dumping data for table `magefan_blog_post_category`
--


--
-- Table structure for table `magefan_blog_post_relatedpost`
--

CREATE TABLE `magefan_blog_post_relatedpost` (
  `post_id` int NOT NULL COMMENT 'Post ID',
  `related_id` int NOT NULL COMMENT 'Related Post ID',
  `position` int NOT NULL COMMENT 'Position',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `FK_9F26E983FE1D7D7063B61D3F3C8D1104` FOREIGN KEY (`post_id`) REFERENCES `magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEFAN_BLOG_POST_RELATEDPRD1_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `magefan_blog_post` (`post_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Post To Post Linkage Table';

--
-- Dumping data for table `magefan_blog_post_relatedpost`
--


--
-- Table structure for table `magefan_blog_post_relatedproduct`
--

CREATE TABLE `magefan_blog_post_relatedproduct` (
  `post_id` int NOT NULL COMMENT 'Post ID',
  `related_id` int unsigned NOT NULL COMMENT 'Related Product ID',
  `position` int NOT NULL COMMENT 'Position',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `MAGEFAN_BLOG_POST_RELATEDPRD_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEFAN_BLOG_POST_RELATEDPRD_RELATED_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`related_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Post To Product Linkage Table';

--
-- Dumping data for table `magefan_blog_post_relatedproduct`
--


--
-- Table structure for table `magefan_blog_post_store`
--

CREATE TABLE `magefan_blog_post_store` (
  `post_id` int NOT NULL COMMENT 'Post ID',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`post_id`,`store_id`),
  KEY `MAGEFAN_BLOG_POST_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAGEFAN_BLOG_POST_STORE_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEFAN_BLOG_POST_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Post To Store Linkage Table';

--
-- Dumping data for table `magefan_blog_post_store`
--

INSERT INTO `magefan_blog_post_store` VALUES (1,0);

--
-- Table structure for table `magefan_blog_post_tag`
--

CREATE TABLE `magefan_blog_post_tag` (
  `post_id` int NOT NULL COMMENT 'Post ID',
  `tag_id` int NOT NULL COMMENT 'Tag ID',
  PRIMARY KEY (`post_id`,`tag_id`),
  KEY `MAGEFAN_BLOG_POST_TAG_TAG_ID` (`tag_id`),
  CONSTRAINT `MAGEFAN_BLOG_POST_TAG_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEFAN_BLOG_POST_TAG_TAG_ID_MAGEFAN_BLOG_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `magefan_blog_tag` (`tag_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Post To Category Linkage Table';

--
-- Dumping data for table `magefan_blog_post_tag`
--


--
-- Table structure for table `magefan_blog_tag`
--

CREATE TABLE `magefan_blog_tag` (
  `tag_id` int NOT NULL AUTO_INCREMENT COMMENT 'Tag ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Tag Title',
  `meta_robots` varchar(255) DEFAULT NULL COMMENT 'Tag Default Robots',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Description',
  `meta_keywords` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Title',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Tag String Identifier',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Tag Layout',
  `is_active` smallint NOT NULL DEFAULT '1' COMMENT 'Is Tag Active',
  `content` mediumtext COMMENT 'Tag Content',
  `layout_update_xml` text COMMENT 'Tag Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Tag Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Tag Custom Template',
  `custom_layout_update_xml` text COMMENT 'Tag Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Tag Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Tag Custom Theme Active To Date',
  `posts_per_page` int DEFAULT NULL COMMENT 'Posts Per Page',
  `posts_list_template` varchar(100) DEFAULT NULL COMMENT 'Posts List Template',
  PRIMARY KEY (`tag_id`),
  KEY `MAGEFAN_BLOG_TAG_IDENTIFIER` (`identifier`),
  KEY `MAGEFAN_BLOG_TAG_IS_ACTIVE` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Tag Table';

--
-- Dumping data for table `magefan_blog_tag`
--


--
-- Table structure for table `magefan_blog_tag_store`
--

CREATE TABLE `magefan_blog_tag_store` (
  `tag_id` int NOT NULL COMMENT 'Tag ID',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`tag_id`,`store_id`),
  KEY `MAGEFAN_BLOG_TAG_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAGEFAN_BLOG_TAG_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEFAN_BLOG_TAG_STORE_TAG_ID_MAGEFAN_BLOG_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `magefan_blog_tag` (`tag_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magefan Blog Tag To Store Linkage Table';

--
-- Dumping data for table `magefan_blog_tag_store`
--


--
-- Table structure for table `magento_acknowledged_bulk`
--

CREATE TABLE `magento_acknowledged_bulk` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Internal ID',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `MAGENTO_ACKNOWLEDGED_BULK_BULK_UUID` (`bulk_uuid`),
  CONSTRAINT `MAGENTO_ACKNOWLEDGED_BULK_BULK_UUID_MAGENTO_BULK_UUID` FOREIGN KEY (`bulk_uuid`) REFERENCES `magento_bulk` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COMMENT='Bulk that was viewed by user from notification area';

--
-- Dumping data for table `magento_acknowledged_bulk`
--

INSERT INTO `magento_acknowledged_bulk` VALUES (1,_binary '5f5b46fe-7a22-4d92-b9b8-df488e2258d8'),(2,_binary '8c0075cd-dfa7-40e2-a1ff-01eb5ae8793c'),(4,_binary '94a31f6b-e45b-495f-a9c5-f58c4f32525a'),(3,_binary 'aae32a43-5716-408b-b5c9-1ccd37898c08');

--
-- Table structure for table `magento_bulk`
--

CREATE TABLE `magento_bulk` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Bulk Internal ID (must not be exposed)',
  `uuid` varbinary(39) DEFAULT NULL COMMENT 'Bulk UUID (can be exposed to reference bulk entity)',
  `user_id` int unsigned DEFAULT NULL COMMENT 'ID of the WebAPI user that performed an action',
  `user_type` int DEFAULT NULL COMMENT 'Which type of user',
  `description` varchar(255) DEFAULT NULL COMMENT 'Bulk Description',
  `operation_count` int unsigned NOT NULL COMMENT 'Total number of operations scheduled within this bulk',
  `start_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Bulk start time',
  PRIMARY KEY (`id`),
  UNIQUE KEY `MAGENTO_BULK_UUID` (`uuid`),
  KEY `MAGENTO_BULK_USER_ID` (`user_id`),
  KEY `MAGENTO_BULK_START_TIME` (`start_time`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8mb3 COMMENT='Bulk entity that represents set of related asynchronous operations';

--
-- Dumping data for table `magento_bulk`
--

INSERT INTO `magento_bulk` VALUES (37,_binary 'f54a0cb6-84c7-481e-a7a3-e6d67e036b22',1,2,'Synchronize website specific attributes values',1,'2024-12-11 11:06:53'),(38,_binary '8c0075cd-dfa7-40e2-a1ff-01eb5ae8793c',5,2,'Synchronize website specific attributes values',1,'2025-01-24 13:59:15'),(39,_binary 'aae32a43-5716-408b-b5c9-1ccd37898c08',5,2,'Synchronize website specific attributes values',1,'2025-01-28 06:56:54'),(40,_binary '94a31f6b-e45b-495f-a9c5-f58c4f32525a',5,2,'Synchronize website specific attributes values',1,'2025-02-03 08:24:01'),(41,_binary '5f5b46fe-7a22-4d92-b9b8-df488e2258d8',5,2,'Update attributes for 20 selected products',1,'2025-02-04 09:55:24'),(42,_binary 'e0bf8896-2d6a-4b7f-a660-e8f6507851a4',5,2,'Synchronize website specific attributes values',1,'2025-02-06 08:04:33'),(43,_binary '7b1c0f25-1408-47ac-9fd8-152da73ce5f6',5,2,'Image resize: /b/l/blanco_vicus_bridge_double_lever-1.jpg',1,'2025-02-11 13:41:29'),(44,_binary '9cfaedfe-840a-4305-83fd-71e1b3ea8cab',5,2,'Image resize: /b/l/blanco_vicus_bridge_double_lever.jpg',1,'2025-02-11 13:41:29'),(45,_binary 'fce0c40b-29e5-4a45-8950-a78753402d7b',5,2,'Image resize: /b/l/blanco-526560.jpg',1,'2025-02-25 11:34:44');

--
-- Table structure for table `magento_login_as_customer_log`
--

CREATE TABLE `magento_login_as_customer_log` (
  `log_id` int NOT NULL AUTO_INCREMENT COMMENT 'Log Id',
  `time` timestamp NULL DEFAULT NULL COMMENT 'Event Date',
  `user_id` int unsigned DEFAULT NULL COMMENT 'User Id',
  `user_name` varchar(40) DEFAULT NULL COMMENT 'User Name',
  `customer_id` int unsigned DEFAULT NULL COMMENT 'Customer Id',
  `customer_email` varchar(40) DEFAULT NULL COMMENT 'Customer email',
  PRIMARY KEY (`log_id`),
  KEY `MAGENTO_LOGIN_AS_CUSTOMER_LOG_USER_ID` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Login as Customer Logging';

--
-- Dumping data for table `magento_login_as_customer_log`
--


--
-- Table structure for table `magento_operation`
--

CREATE TABLE `magento_operation` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Operation ID',
  `operation_key` int unsigned DEFAULT NULL COMMENT 'Operation Key',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  `topic_name` varchar(255) DEFAULT NULL COMMENT 'Name of the related message queue topic',
  `serialized_data` blob COMMENT 'Data (serialized) required to perform an operation',
  `result_serialized_data` blob COMMENT 'Result data (serialized) after perform an operation',
  `status` smallint DEFAULT '0' COMMENT 'Operation status (OPEN | COMPLETE | RETRIABLY_FAILED | NOT_RETRIABLY_FAILED)',
  `error_code` smallint DEFAULT NULL COMMENT 'Code of the error that appeared during operation execution (used to aggregate related failed operations)',
  `result_message` varchar(255) DEFAULT NULL COMMENT 'Operation result message',
  `started_at` timestamp NULL DEFAULT NULL COMMENT 'Datetime the operation started processing',
  PRIMARY KEY (`id`),
  KEY `MAGENTO_OPERATION_BULK_UUID_ERROR_CODE` (`bulk_uuid`,`error_code`),
  KEY `MAGENTO_OPERATION_STATUS_STARTED_AT` (`status`,`started_at`),
  CONSTRAINT `MAGENTO_OPERATION_BULK_UUID_MAGENTO_BULK_UUID` FOREIGN KEY (`bulk_uuid`) REFERENCES `magento_bulk` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=42 DEFAULT CHARSET=utf8mb3 COMMENT='Operation entity';

--
-- Dumping data for table `magento_operation`
--

INSERT INTO `magento_operation` VALUES (18,NULL,_binary 'f54a0cb6-84c7-481e-a7a3-e6d67e036b22','catalog_website_attribute_value_sync',_binary '{\"store_id\":2}',NULL,1,NULL,NULL,NULL),(22,NULL,_binary '8c0075cd-dfa7-40e2-a1ff-01eb5ae8793c','catalog_website_attribute_value_sync',_binary '{\"store_id\":3}',NULL,1,NULL,NULL,NULL),(27,NULL,_binary 'aae32a43-5716-408b-b5c9-1ccd37898c08','catalog_website_attribute_value_sync',_binary '{\"store_id\":4}',NULL,1,NULL,NULL,NULL),(34,NULL,_binary '94a31f6b-e45b-495f-a9c5-f58c4f32525a','catalog_website_attribute_value_sync',_binary '{\"store_id\":5}',NULL,1,NULL,NULL,NULL),(41,NULL,_binary '5f5b46fe-7a22-4d92-b9b8-df488e2258d8','product_action_attribute.website.update',_binary '{\"meta_information\":\"Update website assign\",\"product_ids\":[\"5760\",\"6035\",\"6036\",\"6037\",\"6038\",\"6039\",\"6040\",\"6041\",\"6042\",\"6043\",\"6044\",\"6045\",\"6046\",\"6047\",\"6048\",\"6049\",\"6050\",\"6051\",\"6052\",\"6053\"],\"store_id\":0,\"website_id\":\"0\",\"attributes\":{\"website_assign\":[\"1\",\"2\",\"3\",\"4\"],\"website_detach\":[]}}',NULL,1,NULL,NULL,NULL);

--
-- Table structure for table `mageplaza_fbt_product_link`
--

CREATE TABLE `mageplaza_fbt_product_link` (
  `link_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `linked_product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Linked Product ID',
  `position` int NOT NULL DEFAULT '0' COMMENT 'Position',
  PRIMARY KEY (`link_id`),
  UNIQUE KEY `MAGEPLAZA_FBT_PRODUCT_LINK_PRODUCT_ID_LINKED_PRODUCT_ID` (`product_id`,`linked_product_id`),
  KEY `MAGEPLAZA_FBT_PRODUCT_LINK_PRODUCT_ID` (`product_id`),
  KEY `MAGEPLAZA_FBT_PRODUCT_LINK_LINKED_PRODUCT_ID` (`linked_product_id`),
  CONSTRAINT `MAGEPLAZA_FBT_PRD_LNK_LNKED_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`linked_product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEPLAZA_FBT_PRD_LNK_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Frequently Bought Together Product To Product Linkage Table';

--
-- Dumping data for table `mageplaza_fbt_product_link`
--


--
-- Table structure for table `mageplaza_smtp_abandonedcart`
--

CREATE TABLE `mageplaza_smtp_abandonedcart` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log Id',
  `log_ids` varchar(255) DEFAULT NULL COMMENT 'Log Ids',
  `token` varchar(255) DEFAULT NULL COMMENT 'Token',
  `quote_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Quote Id',
  `status` smallint NOT NULL COMMENT 'Status',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`id`),
  KEY `MAGEPLAZA_SMTP_ABANDONEDCART_QUOTE_ID_QUOTE_ENTITY_ID` (`quote_id`),
  CONSTRAINT `MAGEPLAZA_SMTP_ABANDONEDCART_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='SMTP Abandoned Cart';

--
-- Dumping data for table `mageplaza_smtp_abandonedcart`
--


--
-- Table structure for table `mageplaza_smtp_log`
--

CREATE TABLE `mageplaza_smtp_log` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `subject` varchar(255) DEFAULT NULL COMMENT 'Email Subject',
  `email_content` text COMMENT 'Email Content',
  `status` smallint NOT NULL COMMENT 'Status',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `sender` varchar(255) DEFAULT NULL COMMENT 'Sender',
  `recipient` varchar(255) DEFAULT NULL COMMENT 'Recipient',
  `cc` varchar(255) DEFAULT NULL COMMENT 'Cc',
  `bcc` varchar(255) DEFAULT NULL COMMENT 'Bcc',
  PRIMARY KEY (`id`),
  KEY `MAGEPLAZA_SMTP_LOG_STATUS` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='mageplaza_smtp_log';

--
-- Dumping data for table `mageplaza_smtp_log`
--


--
-- Table structure for table `magepsycho_massimporterpro_import_data`
--

CREATE TABLE `magepsycho_massimporterpro_import_data` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `entity` varchar(50) NOT NULL COMMENT 'Entity',
  `behavior` varchar(10) NOT NULL DEFAULT 'append' COMMENT 'Behavior',
  `data` longtext COMMENT 'Data',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MIP Import Data Table';

--
-- Dumping data for table `magepsycho_massimporterpro_import_data`
--


--
-- Table structure for table `magepsycho_massimporterpro_import_history`
--

CREATE TABLE `magepsycho_massimporterpro_import_history` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'History Record Id',
  `started_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Started At',
  `entity` varchar(50) NOT NULL COMMENT 'Entity',
  `imported_via` varchar(50) NOT NULL COMMENT 'Imported Via',
  `import_source` varchar(50) NOT NULL COMMENT 'Import Source',
  `user_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'User ID',
  `imported_file` varchar(255) DEFAULT NULL COMMENT 'Imported File',
  `execution_time` varchar(255) DEFAULT NULL COMMENT 'Execution Time',
  `summary` varchar(255) DEFAULT NULL COMMENT 'Summary',
  `error_file` varchar(255) NOT NULL COMMENT 'Imported File with Errors',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Import history table';

--
-- Dumping data for table `magepsycho_massimporterpro_import_history`
--


--
-- Table structure for table `mageworx_dynamic_options`
--

CREATE TABLE `mageworx_dynamic_options` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `product_id` int unsigned NOT NULL COMMENT 'Product ID',
  `option_id` int unsigned NOT NULL COMMENT 'Option ID',
  `step` decimal(10,2) unsigned DEFAULT NULL COMMENT 'Step',
  `min_value` decimal(10,2) unsigned DEFAULT NULL COMMENT 'Min Value',
  `max_value` decimal(10,2) unsigned DEFAULT NULL COMMENT 'Max Value',
  `measurement_unit` varchar(255) NOT NULL DEFAULT 'meters' COMMENT 'Measurement Unit',
  PRIMARY KEY (`id`),
  UNIQUE KEY `MAGEWORX_DYNAMIC_OPTIONS_PRODUCT_ID_OPTION_ID` (`product_id`,`option_id`),
  KEY `MAGEWORX_DYNAMIC_OPTIONS_OPTION_ID` (`option_id`),
  CONSTRAINT `MAGEWORX_DYNAMIC_OPTS_OPT_ID_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mageworx Dynamic Options Table';

--
-- Dumping data for table `mageworx_dynamic_options`
--


--
-- Table structure for table `mageworx_option_dependency`
--

CREATE TABLE `mageworx_option_dependency` (
  `dependency_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Dependency Id',
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `group_id` int unsigned DEFAULT NULL COMMENT 'Group Id',
  `dp_child_option_id` int NOT NULL DEFAULT '0',
  `dp_child_option_type_id` int NOT NULL DEFAULT '0',
  `dp_parent_option_id` int NOT NULL DEFAULT '0',
  `dp_parent_option_type_id` int NOT NULL DEFAULT '0',
  `is_processed_dp_columns` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Processed New Columns',
  PRIMARY KEY (`dependency_id`),
  KEY `MAGEWORX_OPTION_DEPENDENCY_DP_CHILD_OPTION_ID` (`dp_child_option_id`),
  KEY `MAGEWORX_OPTION_DEPENDENCY_DP_CHILD_OPTION_TYPE_ID` (`dp_child_option_type_id`),
  KEY `MAGEWORX_OPTION_DEPENDENCY_DP_PARENT_OPTION_ID` (`dp_parent_option_id`),
  KEY `MAGEWORX_OPTION_DEPENDENCY_DP_PARENT_OPTION_TYPE_ID` (`dp_parent_option_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_option_dependency`
--


--
-- Table structure for table `mageworx_optionadvancedpricing_option_type_special_price`
--

CREATE TABLE `mageworx_optionadvancedpricing_option_type_special_price` (
  `option_type_special_price_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Special Price ID',
  `option_type_id` int unsigned NOT NULL COMMENT 'Option Type ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Special Price',
  `price_type` varchar(40) NOT NULL DEFAULT 'fixed' COMMENT 'Special Price Type (fixed, percentage_discount)',
  `comment` varchar(255) NOT NULL DEFAULT '' COMMENT 'Special Price Comment',
  `date_from` date DEFAULT NULL COMMENT 'Special Price Date From',
  `date_to` date DEFAULT NULL COMMENT 'Special Price Date To',
  PRIMARY KEY (`option_type_special_price_id`),
  KEY `MAGEWORX_OPTADVANCEDPRICING_OPT_TYPE_SPECIAL_PRICE_OPT_TYPE_ID` (`option_type_id`),
  CONSTRAINT `FK_22F5BC49C97D769B8BC23E3B4B42BF1C` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optionadvancedpricing_option_type_special_price`
--


--
-- Table structure for table `mageworx_optionadvancedpricing_option_type_tier_price`
--

CREATE TABLE `mageworx_optionadvancedpricing_option_type_tier_price` (
  `option_type_tier_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Special Price ID',
  `option_type_id` int unsigned NOT NULL COMMENT 'Option Type ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  `qty` int unsigned NOT NULL COMMENT 'Tier Price Qty',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Special Price',
  `price_type` varchar(40) NOT NULL DEFAULT 'fixed' COMMENT 'Tier Price Type (fixed, percentage_discount)',
  `date_from` date DEFAULT NULL COMMENT 'Tier Price Date From',
  `date_to` date DEFAULT NULL COMMENT 'Tier Price Date To',
  PRIMARY KEY (`option_type_tier_id`),
  KEY `MAGEWORX_OPTADVANCEDPRICING_OPT_TYPE_TIER_PRICE_OPT_TYPE_ID` (`option_type_id`),
  CONSTRAINT `FK_934663E91DD45B9A64075FDF3E9E73E3` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optionadvancedpricing_option_type_tier_price`
--


--
-- Table structure for table `mageworx_optionbase_product_attributes`
--

CREATE TABLE `mageworx_optionbase_product_attributes` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `dependency_rules` mediumtext NOT NULL COMMENT 'Dependency Rules (Added by MageWorx_OptionDependency)',
  `hidden_dependents` text NOT NULL COMMENT 'Precalculated Hidden Dependents (Added by MageWorx_OptionDependency)',
  `absolute_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Absolute Price Flag',
  `absolute_weight` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Absolute Weight Flag',
  `absolute_cost` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Absolute Cost Flag',
  `hide_additional_product_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Hide Additional Product Price Flag',
  `shareable_link` varchar(20) NOT NULL DEFAULT 'use_config' COMMENT 'Shareable Link (added by MageWorx_OptionFeatures)',
  `sku_policy` varchar(20) NOT NULL DEFAULT 'use_config' COMMENT 'SKU Policy (added by MageWorx Option Sku Policy)',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `MAGEWORX_OPTIONBASE_PRODUCT_ATTRIBUTES_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optionbase_product_attributes`
--


--
-- Table structure for table `mageworx_optionfeatures_option_description`
--

CREATE TABLE `mageworx_optionfeatures_option_description` (
  `option_description_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Description ID',
  `option_id` int unsigned DEFAULT NULL COMMENT 'Option  ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `description` text COMMENT 'Description',
  PRIMARY KEY (`option_description_id`),
  UNIQUE KEY `MAGEWORX_OPTIONFEATURES_OPTION_DESCRIPTION_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `MAGEWORX_OPTIONFEATURES_OPTION_DESCRIPTION_STORE_ID` (`store_id`),
  KEY `MAGEWORX_OPTIONFEATURES_OPTION_DESCRIPTION_OPTION_ID` (`option_id`),
  CONSTRAINT `MAGEWORX_OPTFEATURES_OPT_DESCRIPTION_OPT_ID_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTFEATURES_OPT_DESCRIPTION_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optionfeatures_option_description`
--


--
-- Table structure for table `mageworx_optionfeatures_option_type_description`
--

CREATE TABLE `mageworx_optionfeatures_option_type_description` (
  `option_type_description_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Description ID',
  `option_type_id` int unsigned DEFAULT NULL COMMENT 'Option Type ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `description` text COMMENT 'Description',
  PRIMARY KEY (`option_type_description_id`),
  UNIQUE KEY `MAGEWORX_OPTFEATURES_OPT_TYPE_DESCRIPTION_OPT_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
  KEY `MAGEWORX_OPTIONFEATURES_OPTION_TYPE_DESCRIPTION_STORE_ID` (`store_id`),
  KEY `MAGEWORX_OPTIONFEATURES_OPTION_TYPE_DESCRIPTION_OPTION_TYPE_ID` (`option_type_id`),
  CONSTRAINT `FK_2C15EADD1DD5D6C5E0E61DDFB5C2981B` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_316CA178C7252B45EA5232F8B6DD4437` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optionfeatures_option_type_description`
--


--
-- Table structure for table `mageworx_optionfeatures_option_type_image`
--

CREATE TABLE `mageworx_optionfeatures_option_type_image` (
  `option_type_id` int unsigned DEFAULT NULL COMMENT 'Option Type ID',
  `option_type_image_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Image ID',
  `media_type` varchar(32) DEFAULT 'image' COMMENT 'Media Type',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `title_text` varchar(255) DEFAULT NULL COMMENT 'Title Text',
  `sort_order` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `base_image` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Base Image',
  `tooltip_image` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Tooltip Image',
  `overlay_image` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Overlay Image',
  `color` varchar(6) DEFAULT NULL COMMENT 'color',
  `replace_main_gallery_image` smallint DEFAULT '0' COMMENT 'Use for replacement of the main image in the product gallery (product view page)',
  `disabled` smallint NOT NULL DEFAULT '0' COMMENT 'Should be displayed this image in the Option Gallery or not?',
  PRIMARY KEY (`option_type_image_id`),
  KEY `MAGEWORX_OPTIONFEATURES_OPTION_TYPE_IMAGE_OPTION_TYPE_ID` (`option_type_id`),
  KEY `MAGEWORX_OPTFEATURES_OPT_TYPE_IMAGE_OPT_TYPE_ID_TOOLTIP_IMAGE` (`option_type_id`,`tooltip_image`),
  KEY `MAGEWORX_OPTFEATURES_OPT_TYPE_IMAGE_OPT_TYPE_ID_BASE_IMAGE` (`option_type_id`,`base_image`),
  CONSTRAINT `FK_5DE1F80CFFC2267A0C0FCAF990DCFFBE` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optionfeatures_option_type_image`
--


--
-- Table structure for table `mageworx_optionfeatures_option_type_is_default`
--

CREATE TABLE `mageworx_optionfeatures_option_type_is_default` (
  `option_type_id` int unsigned DEFAULT NULL COMMENT 'Option Type ID',
  `option_type_is_default_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Is Default ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `is_default` smallint unsigned NOT NULL DEFAULT '1' COMMENT 'Is Default',
  PRIMARY KEY (`option_type_is_default_id`),
  UNIQUE KEY `MAGEWORX_OPTFEATURES_OPT_TYPE_IS_DEFAULT_OPT_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
  KEY `MAGEWORX_OPTIONFEATURES_OPTION_TYPE_IS_DEFAULT_OPTION_TYPE_ID` (`option_type_id`),
  KEY `MAGEWORX_OPTIONFEATURES_OPTION_TYPE_IS_DEFAULT_STORE_ID` (`store_id`),
  CONSTRAINT `FK_DA48580A57EF3BBF8C9869E3ACE0E38A` FOREIGN KEY (`option_type_id`) REFERENCES `catalog_product_option_type_value` (`option_type_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTFEATURES_OPT_TYPE_IS_DEFAULT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optionfeatures_option_type_is_default`
--


--
-- Table structure for table `mageworx_optiontemplates_group`
--

CREATE TABLE `mageworx_optiontemplates_group` (
  `dependency_rules` mediumtext NOT NULL COMMENT 'Dependency Rules (Added by MageWorx_OptionDependency)',
  `hidden_dependents` text NOT NULL COMMENT 'Precalculated Hidden Dependents (Added by MageWorx_OptionDependency)',
  `absolute_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Absolute Price Flag',
  `absolute_weight` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Absolute Weight Flag',
  `absolute_cost` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Absolute Cost Flag',
  `hide_additional_product_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Hide Additional Product Price Flag',
  `shareable_link` varchar(20) NOT NULL DEFAULT 'use_config' COMMENT 'Shareable Link (added by MageWorx_OptionFeatures)',
  `group_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Group ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Title',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Last Modify Date',
  `is_active` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `sku_policy` varchar(20) NOT NULL DEFAULT 'use_config' COMMENT 'SKU Policy (added by MageWorx Option Sku Policy)',
  PRIMARY KEY (`group_id`),
  FULLTEXT KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_TITLE` (`title`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option`
--

CREATE TABLE `mageworx_optiontemplates_group_option` (
  `option_title_id` varchar(255) NOT NULL COMMENT 'Option Title Identifier (added by MageWorx Option Dependency)',
  `dependency_type` smallint NOT NULL DEFAULT '0' COMMENT 'Option Dependency Type (added by MageWorx Option Dependency)',
  `qty_input` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Qty Input Flag (added by MageWorx_OptionFeatures)',
  `one_time` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'One Time Option Flag (added by MageWorx_OptionFeatures)',
  `div_class` varchar(255) NOT NULL COMMENT 'Option Div Class (added by MageWorx_OptionFeatures)',
  `mageworx_option_gallery` smallint NOT NULL DEFAULT '0' COMMENT 'MageWorx option gallery display type (added by MageWorx_OptionFeatures)',
  `mageworx_option_image_mode` smallint NOT NULL DEFAULT '0' COMMENT 'Option image mode (added by MageWorx_OptionFeatures)',
  `selection_limit_from` smallint NOT NULL DEFAULT '0' COMMENT 'Option Selection Limit From (added by MageWorx_OptionFeatures)',
  `selection_limit_to` smallint NOT NULL DEFAULT '0' COMMENT 'Option Selection Limit To (added by MageWorx_OptionFeatures)',
  `is_hidden` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Hidden Flag (added by MageWorx_OptionFeatures)',
  `hide_product_page_value_price` int unsigned NOT NULL DEFAULT '0' COMMENT 'Hide Value Price On Product Page(added by MageWorx_OptionFeatures)',
  `group_option_id` int unsigned DEFAULT NULL COMMENT 'Group Option Id (added by MageWorx OptionTemplates)',
  `option_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `group_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Group ID',
  `type` varchar(50) NOT NULL DEFAULT '0' COMMENT 'Type',
  `is_require` int unsigned NOT NULL DEFAULT '1' COMMENT 'Is Required',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `max_characters` int unsigned DEFAULT NULL COMMENT 'Max Characters',
  `file_extension` varchar(50) DEFAULT NULL COMMENT 'File Extension',
  `image_size_x` smallint unsigned DEFAULT NULL COMMENT 'Image Size X',
  `image_size_y` smallint unsigned DEFAULT NULL COMMENT 'Image Size Y',
  `sort_order` int unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `sku_policy` varchar(20) NOT NULL DEFAULT 'use_config' COMMENT 'SKU Policy (added by MageWorx Option Sku Policy)',
  `is_swatch` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Swatch Flag (added by MageWorx Option Swatches)',
  `is_all_groups` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'ALL Customer Group ID (added by MageWorx Option Visibility)',
  `is_all_websites` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'ALL Store ID (added by MageWorx Option Visibility)',
  `disabled` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Disabled (added by MageWorx Option Visibility)',
  `disabled_by_values` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Disabled by values (added by MageWorx Option Visibility)',
  PRIMARY KEY (`option_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_GROUP_ID` (`group_id`),
  CONSTRAINT `FK_DC60D8B1D794DC19AB4DC78EAA931FC7` FOREIGN KEY (`group_id`) REFERENCES `mageworx_optiontemplates_group` (`group_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_customer_group`
--

CREATE TABLE `mageworx_optiontemplates_group_option_customer_group` (
  `visibility_customer_group_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Visibility Customer Group Id',
  `option_id` int unsigned NOT NULL COMMENT 'Option ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  PRIMARY KEY (`visibility_customer_group_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_CUSTOMER_GROUP_OPTION_ID` (`option_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_CSTR_GROUP_CSTR_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `FK_40667043B67EFCB20405D0A50A33E6F6` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_5BE4FABB3D14EB28DABA32BF243D7558` FOREIGN KEY (`option_id`) REFERENCES `mageworx_optiontemplates_group_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mageworx OptionVisibiity Option Customer Group Table';

--
-- Dumping data for table `mageworx_optiontemplates_group_option_customer_group`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_dependency`
--

CREATE TABLE `mageworx_optiontemplates_group_option_dependency` (
  `dependency_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Dependency Id',
  `group_id` int unsigned DEFAULT NULL COMMENT 'Group Id',
  `dp_child_option_id` int NOT NULL DEFAULT '0',
  `dp_child_option_type_id` int NOT NULL DEFAULT '0',
  `dp_parent_option_id` int NOT NULL DEFAULT '0',
  `dp_parent_option_type_id` int NOT NULL DEFAULT '0',
  `is_processed_dp_columns` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Processed New Columns',
  PRIMARY KEY (`dependency_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_DEPENDENCY_DP_CHILD_OPT_ID` (`dp_child_option_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_DEPENDENCY_DP_CHILD_OPT_TYPE_ID` (`dp_child_option_type_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_DEPENDENCY_DP_PARENT_OPT_ID` (`dp_parent_option_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_DEPENDENCY_DP_PARENT_OPT_TYPE_ID` (`dp_parent_option_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_dependency`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_description`
--

CREATE TABLE `mageworx_optiontemplates_group_option_description` (
  `option_description_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Description ID',
  `option_id` int unsigned DEFAULT NULL COMMENT 'Option  ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `description` text COMMENT 'Description',
  PRIMARY KEY (`option_description_id`),
  UNIQUE KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_DESCRIPTION_OPT_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_DESCRIPTION_STORE_ID` (`store_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_DESCRIPTION_OPTION_ID` (`option_id`),
  CONSTRAINT `FK_2884BAC1F673B5DF1ED4C8215B62AA3C` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_800FAB6FDCF4333C814626331172D2FC` FOREIGN KEY (`option_id`) REFERENCES `mageworx_optiontemplates_group_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_description`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_price`
--

CREATE TABLE `mageworx_optiontemplates_group_option_price` (
  `option_price_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Price ID',
  `option_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `price_type` varchar(7) NOT NULL DEFAULT 'fixed' COMMENT 'Price Type',
  PRIMARY KEY (`option_price_id`),
  UNIQUE KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_PRICE_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_PRICE_STORE_ID_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_00D4622D353DCA693DCF7D22F432250E` FOREIGN KEY (`option_id`) REFERENCES `mageworx_optiontemplates_group_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTTEMPLATES_GROUP_OPT_PRICE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_price`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_store_view`
--

CREATE TABLE `mageworx_optiontemplates_group_option_store_view` (
  `visibility_store_view_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Visibility Customer Store View Id',
  `option_id` int unsigned NOT NULL COMMENT 'Option ID',
  `customer_store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`visibility_store_view_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_STORE_VIEW_OPTION_ID` (`option_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_STORE_VIEW_CSTR_STORE_ID` (`customer_store_id`),
  CONSTRAINT `FK_1100129657A3EE2C2C213C9DC14C1B6B` FOREIGN KEY (`customer_store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A4C45D05B947889BEF1D1ED6F4945011` FOREIGN KEY (`option_id`) REFERENCES `mageworx_optiontemplates_group_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mageworx OptionVisibiity Option Store View Table';

--
-- Dumping data for table `mageworx_optiontemplates_group_option_store_view`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_title`
--

CREATE TABLE `mageworx_optiontemplates_group_option_title` (
  `option_title_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Title ID',
  `option_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Title',
  PRIMARY KEY (`option_title_id`),
  UNIQUE KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_TITLE_OPTION_ID_STORE_ID` (`option_id`,`store_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TTL_STORE_ID_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_004C7FAA0F575AFAFA2F57A46D8704EF` FOREIGN KEY (`option_id`) REFERENCES `mageworx_optiontemplates_group_option` (`option_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TTL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_title`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_description`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_description` (
  `option_type_description_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Description ID',
  `option_type_id` int unsigned DEFAULT NULL COMMENT 'Option Type ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `description` text COMMENT 'Description',
  PRIMARY KEY (`option_type_description_id`),
  UNIQUE KEY `UNQ_560609FCF73D09F50F60F68EA57409CB` (`option_type_id`,`store_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_TYPE_DESCRIPTION_STORE_ID` (`store_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TYPE_DESCRIPTION_OPT_TYPE_ID` (`option_type_id`),
  CONSTRAINT `FK_BF65877C6389E239BB64912F69C7B6BF` FOREIGN KEY (`option_type_id`) REFERENCES `mageworx_optiontemplates_group_option_type_value` (`option_type_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E3A8F608DAF40C59653BFE8D3EAAB55B` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_description`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_image`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_image` (
  `option_type_id` int unsigned DEFAULT NULL COMMENT 'Option Type ID',
  `option_type_image_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Image ID',
  `media_type` varchar(32) DEFAULT 'image' COMMENT 'Media Type',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  `title_text` varchar(255) DEFAULT NULL COMMENT 'Title Text',
  `sort_order` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `base_image` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Base Image',
  `tooltip_image` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Tooltip Image',
  `overlay_image` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Overlay Image',
  `color` varchar(6) DEFAULT NULL COMMENT 'color',
  `replace_main_gallery_image` smallint DEFAULT '0' COMMENT 'Use for replacement of the main image in the product gallery (product view page)',
  `disabled` smallint NOT NULL DEFAULT '0' COMMENT 'Should be displayed this image in the Option Gallery or not?',
  PRIMARY KEY (`option_type_image_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_TYPE_IMAGE_OPTION_TYPE_ID` (`option_type_id`),
  KEY `IDX_4E59E98E8571D1EA41ECFA6F5E4F3C8E` (`option_type_id`,`tooltip_image`),
  KEY `IDX_482108B2DF793B7997DBFE07E76B3640` (`option_type_id`,`base_image`),
  CONSTRAINT `FK_F4DBA4CB917B82187359E4224CEF536E` FOREIGN KEY (`option_type_id`) REFERENCES `mageworx_optiontemplates_group_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_image`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_is_default`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_is_default` (
  `option_type_id` int unsigned DEFAULT NULL COMMENT 'Option Type ID',
  `option_type_is_default_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Is Default ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `is_default` smallint unsigned NOT NULL DEFAULT '1' COMMENT 'Is Default',
  PRIMARY KEY (`option_type_is_default_id`),
  UNIQUE KEY `UNQ_B5FAE5E8F28BC20FA3A148DDBA244953` (`option_type_id`,`store_id`),
  KEY `FK_EFC9D6E5DEC2DE48973499377E932B7B` (`store_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TYPE_IS_DEFAULT_OPT_TYPE_ID` (`option_type_id`),
  CONSTRAINT `FK_45B50DCDC4F73ADB5D432A6CAA99CCAD` FOREIGN KEY (`option_type_id`) REFERENCES `mageworx_optiontemplates_group_option_type_value` (`option_type_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_EFC9D6E5DEC2DE48973499377E932B7B` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_is_default`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_price`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_price` (
  `option_type_price_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Price ID',
  `option_type_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Option Type ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  `price_type` varchar(7) NOT NULL DEFAULT 'fixed' COMMENT 'Price Type',
  PRIMARY KEY (`option_type_price_id`),
  UNIQUE KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TYPE_PRICE_OPT_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_TYPE_PRICE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_398A135CCDF9AF3B2387D1790E1104BD` FOREIGN KEY (`option_type_id`) REFERENCES `mageworx_optiontemplates_group_option_type_value` (`option_type_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_7F1E68C9B19BB522C109EA8934F907F7` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_price`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_special_price`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_special_price` (
  `option_type_special_price_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Special Price ID',
  `option_type_id` int unsigned NOT NULL COMMENT 'Option Type ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Special Price',
  `price_type` varchar(40) NOT NULL DEFAULT 'fixed' COMMENT 'Special Price Type (fixed, percentage_discount)',
  `comment` varchar(255) NOT NULL DEFAULT '' COMMENT 'Special Price Comment',
  `date_from` date DEFAULT NULL COMMENT 'Special Price Date From',
  `date_to` date DEFAULT NULL COMMENT 'Special Price Date To',
  PRIMARY KEY (`option_type_special_price_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TYPE_SPECIAL_PRICE_OPT_TYPE_ID` (`option_type_id`),
  CONSTRAINT `FK_B988D9F4DF3153448C14E4AF7EB95EBB` FOREIGN KEY (`option_type_id`) REFERENCES `mageworx_optiontemplates_group_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_special_price`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_tier_price`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_tier_price` (
  `option_type_tier_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Special Price ID',
  `option_type_id` int unsigned NOT NULL COMMENT 'Option Type ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  `qty` int unsigned NOT NULL COMMENT 'Tier Price Qty',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Special Price',
  `price_type` varchar(40) NOT NULL DEFAULT 'fixed' COMMENT 'Special Price Type (fixed, percentage_discount)',
  `date_from` date DEFAULT NULL COMMENT 'Special Price Date From',
  `date_to` date DEFAULT NULL COMMENT 'Special Price Date To',
  PRIMARY KEY (`option_type_tier_id`),
  KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TYPE_TIER_PRICE_OPT_TYPE_ID` (`option_type_id`),
  CONSTRAINT `FK_DA19DBEE57764D5642212445FCFB79E5` FOREIGN KEY (`option_type_id`) REFERENCES `mageworx_optiontemplates_group_option_type_value` (`option_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_tier_price`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_title`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_title` (
  `option_type_title_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type Title ID',
  `option_type_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Option Type ID',
  `store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) NOT NULL DEFAULT '' COMMENT 'Title',
  PRIMARY KEY (`option_type_title_id`),
  UNIQUE KEY `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TYPE_TTL_OPT_TYPE_ID_STORE_ID` (`option_type_id`,`store_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_TYPE_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_4C345341417258E6E959982F889747E3` FOREIGN KEY (`option_type_id`) REFERENCES `mageworx_optiontemplates_group_option_type_value` (`option_type_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTTEMPLATES_GROUP_OPT_TYPE_TTL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_title`
--


--
-- Table structure for table `mageworx_optiontemplates_group_option_type_value`
--

CREATE TABLE `mageworx_optiontemplates_group_option_type_value` (
  `option_type_title_id` varchar(255) NOT NULL COMMENT 'Option Type Title Identifier (added by MageWorx Option Dependency)',
  `dependency_type` smallint NOT NULL DEFAULT '0' COMMENT 'Option Type Dependency Type (added by MageWorx Option Dependency)',
  `cost` decimal(10,2) DEFAULT NULL COMMENT 'Cost (added by MageWorx_OptionFeatures)',
  `weight` decimal(20,6) DEFAULT NULL COMMENT 'Weight (added by MageWorx_OptionFeatures)',
  `weight_type` varchar(7) NOT NULL DEFAULT 'fixed' COMMENT 'Type weight (added by MageWorx_OptionFeatures)',
  `qty_multiplier` int unsigned NOT NULL DEFAULT '0' COMMENT 'Qty Multiplier (added by MageWorx_OptionFeatures)',
  `load_linked_product` int unsigned NOT NULL DEFAULT '0' COMMENT 'Load Linked Product (added by MageWorx_OptionFeatures)',
  `group_option_value_id` int unsigned DEFAULT NULL COMMENT 'Group Option Value Id (added by MageWorx OptionTemplates)',
  `option_type_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Type ID',
  `option_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `sku` varchar(64) DEFAULT NULL COMMENT 'SKU',
  `sort_order` int unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `manage_stock` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Manage Stock (added by MageWorx OptionInventory)',
  `qty` decimal(10,2) DEFAULT NULL COMMENT 'Option Value Qty (added by MageWorx OptionInventory)',
  `disabled` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Disabled (added by MageWorx Option Visibility)',
  `sku_is_valid` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Sku Is Valid (added by MageWorx OptionLink)',
  PRIMARY KEY (`option_type_id`),
  KEY `MAGEWORX_OPTIONTEMPLATES_GROUP_OPTION_TYPE_VALUE_OPTION_ID` (`option_id`),
  CONSTRAINT `FK_2824EF45181E5380DD45A8FBE726180A` FOREIGN KEY (`option_id`) REFERENCES `mageworx_optiontemplates_group_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_optiontemplates_group_option_type_value`
--


--
-- Table structure for table `mageworx_optiontemplates_relation`
--

CREATE TABLE `mageworx_optiontemplates_relation` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `group_id` int unsigned NOT NULL COMMENT 'Group ID',
  `product_id` int unsigned NOT NULL COMMENT 'Product ID',
  `option_id` int unsigned NOT NULL COMMENT 'Option ID',
  `is_changed` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Is Changed Flag',
  PRIMARY KEY (`id`),
  UNIQUE KEY `MAGEWORX_OPTIONTEMPLATES_RELATION_GROUP_ID_PRODUCT_ID` (`group_id`,`product_id`),
  KEY `MAGEWORX_OPTTEMPLATES_RELATION_PRD_ID_CAT_PRD_ENTT_ENTT_ID` (`product_id`),
  CONSTRAINT `FK_8020B13F0E7B338F40D654D6635A2BEB` FOREIGN KEY (`group_id`) REFERENCES `mageworx_optiontemplates_group` (`group_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTTEMPLATES_RELATION_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;

--
-- Dumping data for table `mageworx_optiontemplates_relation`
--


--
-- Table structure for table `mageworx_optionvisibility_option_customer_group`
--

CREATE TABLE `mageworx_optionvisibility_option_customer_group` (
  `visibility_customer_group_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Visibility Customer Group Id',
  `option_id` int unsigned NOT NULL COMMENT 'Option ID',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  PRIMARY KEY (`visibility_customer_group_id`),
  KEY `MAGEWORX_OPTIONVISIBILITY_OPTION_CUSTOMER_GROUP_OPTION_ID` (`option_id`),
  KEY `MAGEWORX_OPTVISIBILITY_OPT_CSTR_GROUP_CSTR_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `FK_B800BD1C991F6DB7E66B7201531A8FC4` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTVISIBILITY_OPT_CSTR_GROUP_OPT_ID_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mageworx OptionVisibiity Option Customer Group Table';

--
-- Dumping data for table `mageworx_optionvisibility_option_customer_group`
--


--
-- Table structure for table `mageworx_optionvisibility_option_store_view`
--

CREATE TABLE `mageworx_optionvisibility_option_store_view` (
  `visibility_store_view_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Visibility Customer Store View Id',
  `option_id` int unsigned NOT NULL COMMENT 'Option ID',
  `customer_store_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  PRIMARY KEY (`visibility_store_view_id`),
  KEY `MAGEWORX_OPTIONVISIBILITY_OPTION_STORE_VIEW_OPTION_ID` (`option_id`),
  KEY `MAGEWORX_OPTIONVISIBILITY_OPTION_STORE_VIEW_CUSTOMER_STORE_ID` (`customer_store_id`),
  CONSTRAINT `FK_8672FBF782C85D4318BC6611709598CD` FOREIGN KEY (`customer_store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_OPTVISIBILITY_OPT_STORE_VIEW_OPT_ID_CAT_PRD_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `catalog_product_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Mageworx OptionVisibiity Option Store View Table';

--
-- Dumping data for table `mageworx_optionvisibility_option_store_view`
--


--
-- Table structure for table `mageworx_shippingrules`
--

CREATE TABLE `mageworx_shippingrules` (
  `rule_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `from_date` date DEFAULT NULL COMMENT 'From',
  `to_date` date DEFAULT NULL COMMENT 'To',
  `days_of_week` text COMMENT 'Days of Week (Available On)',
  `is_active` smallint NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `conditions_serialized` mediumtext COMMENT 'Conditions Serialized',
  `actions_serialized` mediumtext COMMENT 'Actions Serialized',
  `stop_rules_processing` smallint NOT NULL DEFAULT '1' COMMENT 'Stop Rules Processing',
  `shipping_methods` text COMMENT 'Shipping Methods',
  `disabled_shipping_methods` text COMMENT 'Disabled Shipping Methods',
  `enabled_shipping_methods` text COMMENT 'Enabled Shipping Methods',
  `sort_order` int unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order (Priority)',
  `action_type` text COMMENT 'Action Type',
  `simple_action` text COMMENT 'Simple Action',
  `amount` mediumtext COMMENT 'Amount',
  `time_from` int DEFAULT NULL COMMENT 'Time From',
  `time_to` int DEFAULT NULL COMMENT 'Time To',
  `use_time` smallint DEFAULT NULL COMMENT 'Use or not time flag',
  `time_enabled` smallint DEFAULT NULL COMMENT 'Time Range is enabled or disabled time',
  `display_error_message` smallint DEFAULT '0' COMMENT 'Display or not the disabled methods error message',
  `error_message` varchar(255) DEFAULT NULL COMMENT 'Disabled methods error message',
  `store_errmsgs` text COMMENT 'Store Specific Error Messages (serialized)',
  `changed_titles` mediumtext COMMENT 'Shipping Methods Changed Titles',
  `min_price_shipping_methods` text NOT NULL COMMENT 'Shipping Methods Which will be affected by min-price action',
  `display_all_methods_having_min_price` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'If enabled, all shipping methods with the same min price will be shown.',
  PRIMARY KEY (`rule_id`),
  KEY `MAGEWORX_SHIPPINGRULES_IS_ACTIVE_SORT_ORDER_TO_DATE_FROM_DATE` (`is_active`,`sort_order`,`to_date`,`from_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Shippingrules';

--
-- Dumping data for table `mageworx_shippingrules`
--


--
-- Table structure for table `mageworx_shippingrules_carrier`
--

CREATE TABLE `mageworx_shippingrules_carrier` (
  `carrier_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `carrier_code` varchar(64) DEFAULT NULL COMMENT 'Carrier Code',
  `active` smallint NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `sallowspecific` smallint NOT NULL DEFAULT '0' COMMENT 'sallowspecific',
  `model` varchar(47) DEFAULT 'MageWorx\\ShippingRules\\Model\\Carrier\\Artificial' COMMENT 'Corresponding Model',
  `name` text COMMENT 'Carrier Name',
  `title` text COMMENT 'Carrier Title',
  `type` text COMMENT 'Carrier Type',
  `specificerrmsg` text COMMENT 'Carrier Error Message',
  `price` decimal(12,2) DEFAULT NULL COMMENT 'Default Price',
  `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',
  `sort_order` int unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`carrier_id`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_CARRIER_CARRIER_CODE` (`carrier_code`),
  KEY `MAGEWORX_SHIPPINGRULES_CARRIER_CARRIER_ID` (`carrier_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Artificial Carriers Table';

--
-- Dumping data for table `mageworx_shippingrules_carrier`
--


--
-- Table structure for table `mageworx_shippingrules_carrier_label`
--

CREATE TABLE `mageworx_shippingrules_carrier_label` (
  `label_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label Id',
  `carrier_id` int unsigned NOT NULL COMMENT 'Carrier Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store Id',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  PRIMARY KEY (`label_id`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_CARRIER_LABEL_CARRIER_ID_STORE_ID` (`carrier_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_CARRIER_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `FK_5CB5F5698DC3800C85BAF92DBF744485` FOREIGN KEY (`carrier_id`) REFERENCES `mageworx_shippingrules_carrier` (`carrier_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_CARRIER_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Carrier Label';

--
-- Dumping data for table `mageworx_shippingrules_carrier_label`
--


--
-- Table structure for table `mageworx_shippingrules_carrier_store`
--

CREATE TABLE `mageworx_shippingrules_carrier_store` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store View Id',
  PRIMARY KEY (`entity_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_CARRIER_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_0CD9EC57ACEE72A357C020EDCAAFA5D6` FOREIGN KEY (`entity_id`) REFERENCES `mageworx_shippingrules_carrier` (`carrier_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_CARRIER_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Entity To Stores Relations';

--
-- Dumping data for table `mageworx_shippingrules_carrier_store`
--


--
-- Table structure for table `mageworx_shippingrules_customer_group`
--

CREATE TABLE `mageworx_shippingrules_customer_group` (
  `rule_id` int unsigned NOT NULL COMMENT 'Rule Id',
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group Id',
  PRIMARY KEY (`rule_id`,`customer_group_id`),
  KEY `MAGEWORX_SHIPPINGRULES_CUSTOMER_GROUP_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `FK_9B03D94DEF68FED61E6DEF8F3BF0C117` FOREIGN KEY (`customer_group_id`) REFERENCES `customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHPPRULES_CSTR_GROUP_RULE_ID_MAGEWORX_SHPPRULES_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `mageworx_shippingrules` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules To Customer Groups Relations';

--
-- Dumping data for table `mageworx_shippingrules_customer_group`
--


--
-- Table structure for table `mageworx_shippingrules_extended_regions`
--

CREATE TABLE `mageworx_shippingrules_extended_regions` (
  `region_id` int unsigned NOT NULL COMMENT 'Region Id',
  `is_active` int NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `is_custom` int NOT NULL DEFAULT '0' COMMENT 'Custom Region created using module',
  PRIMARY KEY (`region_id`),
  CONSTRAINT `FK_138DA0B3C4EDF5F7E5EFC05453029B68` FOREIGN KEY (`region_id`) REFERENCES `directory_country_region` (`region_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Suite: Extended Regions Data Table';

--
-- Dumping data for table `mageworx_shippingrules_extended_regions`
--


--
-- Table structure for table `mageworx_shippingrules_extended_zone`
--

CREATE TABLE `mageworx_shippingrules_extended_zone` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `priority` int NOT NULL DEFAULT '0' COMMENT 'Priority (Sort Order)',
  `is_active` int NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `countries_id` text NOT NULL COMMENT 'Countries',
  `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`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_EXTENDED_ZONE_NAME` (`name`),
  KEY `MAGEWORX_SHIPPINGRULES_EXTENDED_ZONE_ENTITY_ID` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Zones Table';

--
-- Dumping data for table `mageworx_shippingrules_extended_zone`
--


--
-- Table structure for table `mageworx_shippingrules_extended_zone_labels`
--

CREATE TABLE `mageworx_shippingrules_extended_zone_labels` (
  `label_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label Id',
  `zone_id` int unsigned NOT NULL COMMENT 'Zone Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store Id',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  PRIMARY KEY (`label_id`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_EXTENDED_ZONE_LABELS_ZONE_ID_STORE_ID` (`zone_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_EXTENDED_ZONE_LABELS_STORE_ID` (`store_id`),
  CONSTRAINT `FK_CDDB3B09AD4CF22C93AD0C468A82B223` FOREIGN KEY (`zone_id`) REFERENCES `mageworx_shippingrules_extended_zone` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHPPRULES_EXTENDED_ZONE_LBLS_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Pop-up Zones Label';

--
-- Dumping data for table `mageworx_shippingrules_extended_zone_labels`
--


--
-- Table structure for table `mageworx_shippingrules_extended_zone_store`
--

CREATE TABLE `mageworx_shippingrules_extended_zone_store` (
  `zone_id` int unsigned NOT NULL COMMENT 'Pop-up Zone Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store View Id',
  PRIMARY KEY (`zone_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_EXTENDED_ZONE_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_C490BA33012FB4789D657FD24B4263B6` FOREIGN KEY (`zone_id`) REFERENCES `mageworx_shippingrules_extended_zone` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHPPRULES_EXTENDED_ZONE_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Pop-up Zones To Stores Relations';

--
-- Dumping data for table `mageworx_shippingrules_extended_zone_store`
--


--
-- Table structure for table `mageworx_shippingrules_method_edt_store_specific_message`
--

CREATE TABLE `mageworx_shippingrules_method_edt_store_specific_message` (
  `message_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label Id',
  `method_id` int unsigned NOT NULL COMMENT 'Method Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store Id',
  `message` varchar(255) DEFAULT NULL COMMENT 'Message',
  PRIMARY KEY (`message_id`),
  UNIQUE KEY `UNQ_6E9A553B99F1243D7F2B215C7B19114E` (`method_id`,`store_id`),
  KEY `MAGEWORX_SHPPRULES_METHOD_EDT_STORE_SPECIFIC_MESSAGE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_1C71A6389129223B8E617D8C444F4156` FOREIGN KEY (`method_id`) REFERENCES `mageworx_shippingrules_methods` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_31A76D915F4B9105F45D20EFAB45998D` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Estimated Delivery Time store specific message';

--
-- Dumping data for table `mageworx_shippingrules_method_edt_store_specific_message`
--


--
-- Table structure for table `mageworx_shippingrules_methods`
--

CREATE TABLE `mageworx_shippingrules_methods` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `code` varchar(64) DEFAULT NULL COMMENT 'Method Code',
  `active` smallint NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `title` text COMMENT 'Method Title',
  `price` decimal(14,4) DEFAULT NULL,
  `cost` decimal(14,4) DEFAULT NULL,
  `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',
  `disabled_without_valid_rates` smallint DEFAULT NULL COMMENT 'Method without any valid rate should be disabled',
  `max_price_threshold` decimal(14,4) DEFAULT NULL,
  `min_price_threshold` decimal(14,4) DEFAULT NULL,
  `ignore_virtual_products_price` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Ignore price of virtual products in cart',
  `use_price_with_discount` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Use subtotal with discount in price condition of the Rate',
  `multiple_rates_price` smallint DEFAULT NULL COMMENT 'Multiple Rates price calculation type',
  `replaceable_title` smallint NOT NULL DEFAULT '1' COMMENT 'Replace title from valid rate',
  `description` text COMMENT 'Method description',
  `show_description` smallint NOT NULL DEFAULT '0' COMMENT 'Show description on the frontend flag',
  `image` varchar(255) DEFAULT NULL COMMENT 'Method image',
  `show_image` smallint NOT NULL DEFAULT '0' COMMENT 'Show image on the frontend flag',
  `replaceable_estimated_delivery_time` smallint NOT NULL DEFAULT '1' COMMENT 'Replace Estimated delivery time from a valid rate',
  `estimated_delivery_time_min` decimal(12,2) DEFAULT NULL COMMENT 'Estimated delivery time Min',
  `estimated_delivery_time_max` decimal(12,2) DEFAULT NULL COMMENT 'Estimated delivery time Max',
  `estimated_delivery_time_display_type` smallint NOT NULL DEFAULT '0' COMMENT 'Estimated delivery time data type: Days or Hours',
  `estimated_delivery_time_message` varchar(255) DEFAULT NULL COMMENT 'Estimated delivery time message to display on front-end',
  `show_estimated_delivery_time` smallint NOT NULL DEFAULT '0' COMMENT 'Show estimated delivery time on the frontend flag',
  `allow_free_shipping` smallint NOT NULL DEFAULT '0' COMMENT 'Allow Free Shipping flag (by third-party modules as sales rule)',
  `carrier_code` varchar(64) NOT NULL COMMENT 'Carrier Code (relation)',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_METHODS_CODE_CARRIER_CODE` (`code`,`carrier_code`),
  KEY `FK_BB67FE8B044EF3B3B15D1E0DD3C2668E` (`carrier_code`),
  KEY `MAGEWORX_SHIPPINGRULES_METHODS_ENTITY_ID` (`entity_id`),
  KEY `MAGEWORX_SHIPPINGRULES_METHODS_CODE` (`code`),
  CONSTRAINT `FK_BB67FE8B044EF3B3B15D1E0DD3C2668E` FOREIGN KEY (`carrier_code`) REFERENCES `mageworx_shippingrules_carrier` (`carrier_code`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Artificial Carriers Methods Table';

--
-- Dumping data for table `mageworx_shippingrules_methods`
--


--
-- Table structure for table `mageworx_shippingrules_methods_label`
--

CREATE TABLE `mageworx_shippingrules_methods_label` (
  `label_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label Id',
  `method_id` int unsigned NOT NULL COMMENT 'Method Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store Id',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  PRIMARY KEY (`label_id`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_METHODS_LABEL_METHOD_ID_STORE_ID` (`method_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_METHODS_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `FK_C91E0C78029DE8FF286E437CDA63694F` FOREIGN KEY (`method_id`) REFERENCES `mageworx_shippingrules_methods` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_METHODS_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Method Label';

--
-- Dumping data for table `mageworx_shippingrules_methods_label`
--


--
-- Table structure for table `mageworx_shippingrules_methods_store`
--

CREATE TABLE `mageworx_shippingrules_methods_store` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store View Id',
  PRIMARY KEY (`entity_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_METHODS_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_4DA04BD791FC9A30CAD1C7FD9BBB89EF` FOREIGN KEY (`entity_id`) REFERENCES `mageworx_shippingrules_methods` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_METHODS_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Entity To Stores Relations';

--
-- Dumping data for table `mageworx_shippingrules_methods_store`
--


--
-- Table structure for table `mageworx_shippingrules_rates`
--

CREATE TABLE `mageworx_shippingrules_rates` (
  `rate_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `priority` int NOT NULL DEFAULT '0' COMMENT 'Priority',
  `active` smallint NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `rate_method_price` smallint NOT NULL DEFAULT '0' COMMENT 'Rate price calculation type',
  `title` text COMMENT 'Rate Title',
  `price_from` decimal(14,4) DEFAULT NULL,
  `price_to` decimal(14,4) DEFAULT NULL,
  `qty_from` decimal(14,4) DEFAULT NULL,
  `qty_to` decimal(14,4) DEFAULT NULL,
  `weight_from` decimal(14,4) DEFAULT NULL,
  `weight_to` decimal(14,4) DEFAULT NULL,
  `price` decimal(14,4) DEFAULT NULL,
  `price_per_product` decimal(14,4) DEFAULT NULL,
  `price_per_item` decimal(14,4) DEFAULT NULL,
  `price_percent_per_product` decimal(14,4) DEFAULT NULL,
  `price_percent_per_item` decimal(14,4) DEFAULT NULL,
  `item_price_percent` decimal(14,4) DEFAULT NULL,
  `price_per_weight` decimal(14,4) DEFAULT NULL,
  `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',
  `estimated_delivery_time_min` decimal(12,2) DEFAULT NULL COMMENT 'Estimated delivery time Min',
  `estimated_delivery_time_max` decimal(12,2) DEFAULT NULL COMMENT 'Estimated delivery time Max',
  `method_code` varchar(64) NOT NULL COMMENT 'Method Code (relation)',
  `rate_code` varchar(64) DEFAULT NULL COMMENT 'Rate Code',
  `zip_format` varchar(32) NOT NULL DEFAULT 'numeric' COMMENT 'Zip Code Format',
  `zip_validation_mode` int NOT NULL DEFAULT '0' COMMENT 'Zip Validation Mode',
  PRIMARY KEY (`rate_id`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_RATES_RATE_CODE` (`rate_code`),
  KEY `FK_E1961EF89461BD2F33816CBAF777F7BA` (`method_code`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_RATE_ID` (`rate_id`),
  CONSTRAINT `FK_E1961EF89461BD2F33816CBAF777F7BA` FOREIGN KEY (`method_code`) REFERENCES `mageworx_shippingrules_methods` (`code`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Method Rates Table';

--
-- Dumping data for table `mageworx_shippingrules_rates`
--


--
-- Table structure for table `mageworx_shippingrules_rates_country`
--

CREATE TABLE `mageworx_shippingrules_rates_country` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `country_code` varchar(8) NOT NULL COMMENT 'Country Code',
  PRIMARY KEY (`rate_id`,`country_code`),
  CONSTRAINT `FK_5A291E1902774958099959F18A63A064` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Rates & Countries Relations';

--
-- Dumping data for table `mageworx_shippingrules_rates_country`
--


--
-- Table structure for table `mageworx_shippingrules_rates_dump`
--

CREATE TABLE `mageworx_shippingrules_rates_dump` (
  `rate_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Id',
  `priority` int NOT NULL DEFAULT '0' COMMENT 'Priority',
  `active` smallint NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `rate_method_price` smallint NOT NULL DEFAULT '0' COMMENT 'Rate price calculation type',
  `title` text COMMENT 'Rate Title',
  `price_from` decimal(14,4) DEFAULT NULL,
  `price_to` decimal(14,4) DEFAULT NULL,
  `qty_from` decimal(14,4) DEFAULT NULL,
  `qty_to` decimal(14,4) DEFAULT NULL,
  `weight_from` decimal(14,4) DEFAULT NULL,
  `weight_to` decimal(14,4) DEFAULT NULL,
  `price` decimal(14,4) DEFAULT NULL,
  `price_per_product` decimal(14,4) DEFAULT NULL,
  `price_per_item` decimal(14,4) DEFAULT NULL,
  `price_percent_per_product` decimal(14,4) DEFAULT NULL,
  `price_percent_per_item` decimal(14,4) DEFAULT NULL,
  `item_price_percent` decimal(14,4) DEFAULT NULL,
  `price_per_weight` decimal(14,4) DEFAULT NULL,
  `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',
  `estimated_delivery_time_min` decimal(12,2) DEFAULT NULL COMMENT 'Estimated delivery time Min',
  `estimated_delivery_time_max` decimal(12,2) DEFAULT NULL COMMENT 'Estimated delivery time Max',
  `method_code` varchar(64) NOT NULL COMMENT 'Method Code (relation)',
  `rate_code` varchar(64) DEFAULT NULL COMMENT 'Rate Code',
  `zip_format` varchar(32) NOT NULL DEFAULT 'numeric' COMMENT 'Zip Code Format',
  `zip_validation_mode` int NOT NULL DEFAULT '0' COMMENT 'Zip Validation Mode'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `mageworx_shippingrules_rates_dump`
--


--
-- Table structure for table `mageworx_shippingrules_rates_label`
--

CREATE TABLE `mageworx_shippingrules_rates_label` (
  `label_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Label Id',
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store Id',
  `label` varchar(255) DEFAULT NULL COMMENT 'Label',
  PRIMARY KEY (`label_id`),
  UNIQUE KEY `MAGEWORX_SHIPPINGRULES_RATES_LABEL_RATE_ID_STORE_ID` (`rate_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `FK_5FB101362556A17015F9AA5FFF0667B5` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_RATES_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Rate Labels';

--
-- Dumping data for table `mageworx_shippingrules_rates_label`
--


--
-- Table structure for table `mageworx_shippingrules_rates_region`
--

CREATE TABLE `mageworx_shippingrules_rates_region` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `region` varchar(64) NOT NULL COMMENT 'Region',
  PRIMARY KEY (`rate_id`,`region`),
  CONSTRAINT `FK_F60B217C2E46CF0CAEF15878A0FD5FB0` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Rates & Region Relations';

--
-- Dumping data for table `mageworx_shippingrules_rates_region`
--


--
-- Table structure for table `mageworx_shippingrules_rates_region_id`
--

CREATE TABLE `mageworx_shippingrules_rates_region_id` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `region_id` int unsigned NOT NULL COMMENT 'Region Id',
  PRIMARY KEY (`rate_id`,`region_id`),
  CONSTRAINT `FK_9BE408B5A883474E44936EB06A246F8E` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Rates & Region Ids Relations';

--
-- Dumping data for table `mageworx_shippingrules_rates_region_id`
--


--
-- Table structure for table `mageworx_shippingrules_rates_store`
--

CREATE TABLE `mageworx_shippingrules_rates_store` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store View Id',
  PRIMARY KEY (`entity_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_418629243AD087E35776BDDC6A5869A1` FOREIGN KEY (`entity_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_RATES_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Entity To Stores Relations';

--
-- Dumping data for table `mageworx_shippingrules_rates_store`
--


--
-- Table structure for table `mageworx_shippingrules_rates_zips`
--

CREATE TABLE `mageworx_shippingrules_rates_zips` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `zip` varchar(18) NOT NULL COMMENT 'Zip',
  `inverted` tinyint(1) NOT NULL COMMENT 'Is zip inverted (Not In)',
  PRIMARY KEY (`rate_id`,`zip`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_ZIP` (`zip`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_INVERTED` (`inverted`),
  CONSTRAINT `FK_CFA3AFD72F9D487760886F2D3BD67ED7` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Zips to Rates Relations';

--
-- Dumping data for table `mageworx_shippingrules_rates_zips`
--


--
-- Table structure for table `mageworx_shippingrules_rates_zips_diapason_alphanumeric`
--

CREATE TABLE `mageworx_shippingrules_rates_zips_diapason_alphanumeric` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `from` varchar(12) NOT NULL COMMENT 'Zip From',
  `to` varchar(12) NOT NULL COMMENT 'Zip To',
  `inverted` tinyint(1) NOT NULL COMMENT 'Is diapason inverted (Not In)',
  PRIMARY KEY (`rate_id`,`from`,`to`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_ALPHANUMERIC_INVERTED` (`inverted`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_ALPHANUMERIC_FROM` (`from`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_ALPHANUMERIC_TO` (`to`),
  CONSTRAINT `FK_2583E58E3E1031E961F36DE132BC91C7` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Zips From-To/Rate Relations Table for (Numeric format)';

--
-- Dumping data for table `mageworx_shippingrules_rates_zips_diapason_alphanumeric`
--


--
-- Table structure for table `mageworx_shippingrules_rates_zips_diapason_nl`
--

CREATE TABLE `mageworx_shippingrules_rates_zips_diapason_nl` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `from` varchar(8) NOT NULL COMMENT 'Zip From Link',
  `to` varchar(8) NOT NULL COMMENT 'Zip To Link',
  `from_digit_part` int DEFAULT NULL COMMENT 'From Digit Part Of Zip',
  `from_letter_part` varchar(2) DEFAULT NULL COMMENT 'From Letter Part Of Zip',
  `to_digit_part` int DEFAULT NULL COMMENT 'To Digit Part Of Zip',
  `to_letter_part` varchar(2) DEFAULT NULL COMMENT 'To Letter Part Of Zip',
  `inverted` tinyint(1) NOT NULL COMMENT 'Is diapason inverted (Not In)',
  PRIMARY KEY (`rate_id`,`from`,`to`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NL_INVERTED` (`inverted`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NL_FROM_DIGIT_PART` (`from_digit_part`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NL_FROM_LETTER_PART` (`from_letter_part`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NL_TO_DIGIT_PART` (`to_digit_part`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NL_TO_LETTER_PART` (`to_letter_part`),
  CONSTRAINT `FK_9F9DBC58FBD7B7F199E34CC121582DEB` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Zips From-To/Rate Relations Table for (Numeric format)';

--
-- Dumping data for table `mageworx_shippingrules_rates_zips_diapason_nl`
--


--
-- Table structure for table `mageworx_shippingrules_rates_zips_diapason_numeric`
--

CREATE TABLE `mageworx_shippingrules_rates_zips_diapason_numeric` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `from` int NOT NULL COMMENT 'Zip From',
  `to` int NOT NULL COMMENT 'Zip To',
  `inverted` tinyint(1) NOT NULL COMMENT 'Is diapason inverted (Not In)',
  PRIMARY KEY (`rate_id`,`from`,`to`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NUMERIC_INVERTED` (`inverted`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NUMERIC_FROM` (`from`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_NUMERIC_TO` (`to`),
  CONSTRAINT `FK_8B74DC3471C96A8CA70832BB6A261F3F` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Zips From-To/Rate Relations Table for (Numeric format)';

--
-- Dumping data for table `mageworx_shippingrules_rates_zips_diapason_numeric`
--


--
-- Table structure for table `mageworx_shippingrules_rates_zips_diapason_uk`
--

CREATE TABLE `mageworx_shippingrules_rates_zips_diapason_uk` (
  `rate_id` int unsigned NOT NULL COMMENT 'Rate Id',
  `from` varchar(8) NOT NULL COMMENT 'Zip From As Is',
  `to` varchar(8) NOT NULL COMMENT 'Zip To As Is',
  `from_area` varchar(2) DEFAULT NULL COMMENT 'From UK Zip Area',
  `from_district_number` int DEFAULT NULL COMMENT 'From UK Zip District (Numeric Part)',
  `from_district_letter` varchar(1) DEFAULT NULL COMMENT 'From UK Zip District (Letter Part)',
  `from_sector` int DEFAULT NULL COMMENT 'From UK Zip Sector',
  `from_unit` varchar(2) DEFAULT NULL COMMENT 'From UK Zip Unit',
  `to_area` varchar(2) DEFAULT NULL COMMENT 'To UK Zip Area',
  `to_district_number` int DEFAULT NULL COMMENT 'To UK Zip District (Numeric Part)',
  `to_district_letter` varchar(1) DEFAULT NULL COMMENT 'To UK Zip District (Letter Part)',
  `to_sector` int DEFAULT NULL COMMENT 'To UK Zip Sector',
  `to_unit` varchar(2) DEFAULT NULL COMMENT 'To UK Zip Unit',
  `inverted` tinyint(1) NOT NULL COMMENT 'Is diapason inverted (Not In)',
  PRIMARY KEY (`rate_id`,`from`,`to`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_INVERTED` (`inverted`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_FROM_AREA` (`from_area`),
  KEY `MAGEWORX_SHPPRULES_RATES_ZIPS_DIAPASON_UK_FROM_DISTRICT_NUMBER` (`from_district_number`),
  KEY `MAGEWORX_SHPPRULES_RATES_ZIPS_DIAPASON_UK_FROM_DISTRICT_LETTER` (`from_district_letter`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_FROM_SECTOR` (`from_sector`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_FROM_UNIT` (`from_unit`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_TO_AREA` (`to_area`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_TO_DISTRICT_NUMBER` (`to_district_number`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_TO_DISTRICT_LETTER` (`to_district_letter`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_TO_SECTOR` (`to_sector`),
  KEY `MAGEWORX_SHIPPINGRULES_RATES_ZIPS_DIAPASON_UK_TO_UNIT` (`to_unit`),
  CONSTRAINT `FK_74CF65D3ED66ED496DFE699F4EFE2672` FOREIGN KEY (`rate_id`) REFERENCES `mageworx_shippingrules_rates` (`rate_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules Zips From-To/Rate Relations Table for (Numeric format)';

--
-- Dumping data for table `mageworx_shippingrules_rates_zips_diapason_uk`
--


--
-- Table structure for table `mageworx_shippingrules_store`
--

CREATE TABLE `mageworx_shippingrules_store` (
  `rule_id` int unsigned NOT NULL COMMENT 'Rule Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store View Id',
  PRIMARY KEY (`rule_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHPPRULES_STORE_RULE_ID_MAGEWORX_SHPPRULES_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `mageworx_shippingrules` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Rules To Stores Relations';

--
-- Dumping data for table `mageworx_shippingrules_store`
--


--
-- Table structure for table `mageworx_shippingrules_zone`
--

CREATE TABLE `mageworx_shippingrules_zone` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Id',
  `priority` int NOT NULL DEFAULT '0' COMMENT 'Priority',
  `is_active` int NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `conditions_serialized` mediumtext COMMENT 'Conditions Serialized',
  `default_shipping_method` varchar(255) DEFAULT NULL COMMENT 'Default Shipping Method',
  `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 `MAGEWORX_SHIPPINGRULES_ZONE_ENTITY_ID` (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Zones Table';

--
-- Dumping data for table `mageworx_shippingrules_zone`
--


--
-- Table structure for table `mageworx_shippingrules_zone_store`
--

CREATE TABLE `mageworx_shippingrules_zone_store` (
  `zone_id` int unsigned NOT NULL COMMENT 'Zone Id',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store View Id',
  PRIMARY KEY (`zone_id`,`store_id`),
  KEY `MAGEWORX_SHIPPINGRULES_ZONE_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_2274E462724480C9EE0A77F075BBA545` FOREIGN KEY (`zone_id`) REFERENCES `mageworx_shippingrules_zone` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAGEWORX_SHIPPINGRULES_ZONE_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='MageWorx Shipping Zones To Stores Relations';

--
-- Dumping data for table `mageworx_shippingrules_zone_store`
--


--
-- Table structure for table `magiccart_lookbook`
--

CREATE TABLE `magiccart_lookbook` (
  `lookbook_id` int NOT NULL AUTO_INCREMENT COMMENT 'Lookbook ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `identifier` varchar(255) DEFAULT NULL COMMENT 'Identifier',
  `type_id` smallint NOT NULL DEFAULT '1' COMMENT 'Type',
  `link` varchar(255) DEFAULT NULL COMMENT 'Link',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `options` text COMMENT 'options',
  `stores` varchar(255) DEFAULT NULL COMMENT 'Stores',
  `order` int NOT NULL DEFAULT '0' COMMENT 'Order',
  `status` smallint NOT NULL DEFAULT '1' COMMENT 'Status',
  PRIMARY KEY (`lookbook_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magiccart Lookbook';

--
-- Dumping data for table `magiccart_lookbook`
--


--
-- Table structure for table `magiccart_magicmenu`
--

CREATE TABLE `magiccart_magicmenu` (
  `magicmenu_id` int NOT NULL AUTO_INCREMENT COMMENT 'Magicmenu ID',
  `cat_id` varchar(255) DEFAULT NULL COMMENT 'Category Id',
  `cat_col` varchar(255) DEFAULT NULL COMMENT 'Columns category',
  `cat_proportion` int NOT NULL DEFAULT '0' COMMENT 'Proportion category',
  `top` varchar(255) DEFAULT NULL COMMENT 'Category content top',
  `right` varchar(255) DEFAULT NULL COMMENT 'Category content right',
  `right_proportion` int NOT NULL DEFAULT '0' COMMENT 'Proportion category content right',
  `bottom` varchar(255) DEFAULT NULL COMMENT 'Category content bottom',
  `left` varchar(255) DEFAULT NULL COMMENT 'Category content right',
  `left_proportion` int NOT NULL DEFAULT '0' COMMENT 'Proportion category content left',
  `name` varchar(255) DEFAULT NULL COMMENT 'Extra menu name',
  `magic_label` varchar(255) DEFAULT NULL COMMENT 'Extra menu label',
  `link` varchar(255) DEFAULT NULL COMMENT 'Extra menu link',
  `ext_content` text COMMENT 'Extra menu content',
  `extra` smallint NOT NULL DEFAULT '0' COMMENT 'Is Extra',
  `stores` varchar(255) DEFAULT NULL COMMENT 'Stores',
  `order` int NOT NULL DEFAULT '0' COMMENT 'Order',
  `status` smallint NOT NULL DEFAULT '1' COMMENT 'Status',
  PRIMARY KEY (`magicmenu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magiccart Magicmenu';

--
-- Dumping data for table `magiccart_magicmenu`
--


--
-- Table structure for table `magiccart_magicproduct`
--

CREATE TABLE `magiccart_magicproduct` (
  `magicproduct_id` int NOT NULL AUTO_INCREMENT COMMENT 'Magicproduct ID',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `identifier` varchar(255) DEFAULT NULL COMMENT 'Identifier',
  `type_id` smallint NOT NULL DEFAULT '1' COMMENT 'Type',
  `config` mediumtext COMMENT 'Config',
  `status` smallint NOT NULL DEFAULT '1' COMMENT 'Status',
  PRIMARY KEY (`magicproduct_id`),
  KEY `MAGICPRODUCT_IDENTIFIER_IDENTIFIER` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magiccart Magicproduct';

--
-- Dumping data for table `magiccart_magicproduct`
--


--
-- Table structure for table `magiccart_magicslider`
--

CREATE TABLE `magiccart_magicslider` (
  `magicslider_id` int NOT NULL AUTO_INCREMENT COMMENT 'Magicslider ID',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `identifier` varchar(255) DEFAULT NULL COMMENT 'Identifier',
  `config` mediumtext COMMENT 'Config',
  `status` smallint NOT NULL DEFAULT '1' COMMENT 'Status',
  `created_time` datetime DEFAULT NULL COMMENT 'Created Time',
  `update_time` datetime DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`magicslider_id`),
  KEY `MAGICSLIDER_ID_MAGICSLIDER_ID` (`magicslider_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magiccart Magicslider';

--
-- Dumping data for table `magiccart_magicslider`
--


--
-- Table structure for table `magiccart_shopbrand`
--

CREATE TABLE `magiccart_shopbrand` (
  `shopbrand_id` int NOT NULL AUTO_INCREMENT COMMENT 'Brand ID',
  `title` varchar(255) NOT NULL COMMENT 'Title',
  `urlkey` varchar(255) DEFAULT NULL COMMENT 'Urlkey',
  `meta_key` varchar(255) DEFAULT NULL COMMENT 'Meta_key',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Meta_description',
  `option_id` varchar(255) DEFAULT NULL COMMENT 'Option_id',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `product_ids` mediumtext COMMENT 'product_ids',
  `stores` varchar(255) DEFAULT NULL COMMENT 'Stores',
  `description` varchar(255) DEFAULT NULL COMMENT 'Description',
  `order` smallint NOT NULL DEFAULT '0' COMMENT 'Order',
  `status` smallint NOT NULL DEFAULT '1' COMMENT 'Status',
  PRIMARY KEY (`shopbrand_id`),
  KEY `SHOPBRAND_ID_SHOPBRAND_ID` (`shopbrand_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magiccart Shopbrand';

--
-- Dumping data for table `magiccart_shopbrand`
--


--
-- Table structure for table `magiccart_testimonial`
--

CREATE TABLE `magiccart_testimonial` (
  `testimonial_id` int NOT NULL AUTO_INCREMENT COMMENT 'Testimonial ID',
  `name` varchar(255) NOT NULL COMMENT 'Name',
  `image` varchar(255) DEFAULT NULL COMMENT 'Image',
  `text` mediumtext COMMENT 'product_ids',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `website` varchar(255) DEFAULT NULL COMMENT 'Website',
  `rating_summary` smallint NOT NULL DEFAULT '5' COMMENT 'Rating Summary',
  `stores` varchar(255) DEFAULT '0' COMMENT 'Stores',
  `order` smallint NOT NULL DEFAULT '0' COMMENT 'Order',
  `status` smallint NOT NULL DEFAULT '1' COMMENT 'Status',
  `created_time` datetime DEFAULT NULL COMMENT 'Created Time',
  `update_time` datetime DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`testimonial_id`),
  KEY `TESTIMONIAL_ID_TESTIMONIAL_ID` (`testimonial_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Magiccart Testimonial';

--
-- Dumping data for table `magiccart_testimonial`
--


--
-- Table structure for table `maxmind_country_regions`
--

CREATE TABLE `maxmind_country_regions` (
  `relation_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Relation ID',
  `region_id` varchar(255) DEFAULT NULL COMMENT 'Region ID',
  `country_id` varchar(3) NOT NULL COMMENT 'Country ID',
  `country_name` varchar(255) DEFAULT NULL COMMENT 'Country Name',
  PRIMARY KEY (`relation_id`),
  UNIQUE KEY `MAXMIND_COUNTRY_REGIONS_REGION_ID_COUNTRY_ID` (`region_id`,`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2665 DEFAULT CHARSET=utf8mb3 COMMENT='Maxmind Country Regions Table';

--
-- Dumping data for table `maxmind_country_regions`
--

INSERT INTO `maxmind_country_regions` VALUES (1,'Andorra la Vella','AD','Andorra'),(2,'Canillo','AD','Andorra'),(3,'Encamp','AD','Andorra'),(4,'Escaldes-Engordany','AD','Andorra'),(5,'La Massana','AD','Andorra'),(6,'Ordino','AD','Andorra'),(7,'Sant Julià de Loria','AD','Andorra'),(8,'Abu Dhabi','AE','United Arab Emirates'),(9,'Ajman','AE','United Arab Emirates'),(10,'Al Fujayrah','AE','United Arab Emirates'),(11,'Ash Shariqah','AE','United Arab Emirates'),(12,'Dubai','AE','United Arab Emirates'),(13,'Ra\'s al Khaymah','AE','United Arab Emirates'),(14,'Herat','AF','Afghanistan'),(15,'Kabul','AF','Afghanistan'),(16,'Kandahar','AF','Afghanistan'),(17,'Zabul','AF','Afghanistan'),(18,'Barbuda','AG','Antigua and Barbuda'),(19,'Parish of Saint George','AG','Antigua and Barbuda'),(20,'Parish of Saint John','AG','Antigua and Barbuda'),(21,'Parish of Saint Mary','AG','Antigua and Barbuda'),(22,'Parish of Saint Paul','AG','Antigua and Barbuda'),(23,'Parish of Saint Peter','AG','Antigua and Barbuda'),(24,'Parish of Saint Philip','AG','Antigua and Barbuda'),(25,NULL,'AI','Anguilla'),(26,'Qarku i Beratit','AL','Albania'),(27,'Qarku i Dibres','AL','Albania'),(28,'Qarku i Durresit','AL','Albania'),(29,'Qarku i Elbasanit','AL','Albania'),(30,'Qarku i Fierit','AL','Albania'),(31,'Qarku i Gjirokastres','AL','Albania'),(32,'Qarku i Korces','AL','Albania'),(33,'Qarku i Kukesit','AL','Albania'),(34,'Qarku i Lezhes','AL','Albania'),(35,'Qarku i Shkodres','AL','Albania'),(36,'Qarku i Tiranes','AL','Albania'),(37,'Qarku i Vlores','AL','Albania'),(38,'Aragatsotn Province','AM','Armenia'),(39,'Ararat Province','AM','Armenia'),(40,'Armavir Province','AM','Armenia'),(41,'Gegharkunik Province','AM','Armenia'),(42,'Kotayk Province','AM','Armenia'),(43,'Lori Province','AM','Armenia'),(44,'Shirak Province','AM','Armenia'),(45,'Syunik Province','AM','Armenia'),(46,'Tavush Province','AM','Armenia'),(47,'Yerevan','AM','Armenia'),(48,'Bengo Province','AO','Angola'),(49,'Benguela','AO','Angola'),(50,'Bíe','AO','Angola'),(51,'Cabinda','AO','Angola'),(52,'Cuando Cobango','AO','Angola'),(53,'Cuanza Norte Province','AO','Angola'),(54,'Cunene Province','AO','Angola'),(55,'Huambo','AO','Angola'),(56,'Luanda Norte','AO','Angola'),(57,'Luanda Province','AO','Angola'),(58,'Lunda Sul','AO','Angola'),(59,'Malanje Province','AO','Angola'),(60,'Moxico','AO','Angola'),(61,'Namibe Province','AO','Angola'),(62,'Uíge','AO','Angola'),(63,NULL,'AQ','Antarctica'),(64,'Buenos Aires','AR','Argentina'),(65,'Buenos Aires F.D.','AR','Argentina'),(66,'Catamarca Province','AR','Argentina'),(67,'Chaco Province','AR','Argentina'),(68,'Chubut Province','AR','Argentina'),(69,'Cordoba Province','AR','Argentina'),(70,'Corrientes Province','AR','Argentina'),(71,'Entre Ríos Province','AR','Argentina'),(72,'Formosa Province','AR','Argentina'),(73,'Jujuy Province','AR','Argentina'),(74,'La Pampa Province','AR','Argentina'),(75,'La Rioja Province','AR','Argentina'),(76,'Mendoza Province','AR','Argentina'),(77,'Misiones Province','AR','Argentina'),(78,'Neuquén Province','AR','Argentina'),(79,'Río Negro Province','AR','Argentina'),(80,'Salta Province','AR','Argentina'),(81,'San Juan Province','AR','Argentina'),(82,'San Luis Province','AR','Argentina'),(83,'Santa Cruz Province','AR','Argentina'),(84,'Santa Fe Province','AR','Argentina'),(85,'Santiago del Estero Province','AR','Argentina'),(86,'Tierra del Fuego Province','AR','Argentina'),(87,'Tucumán Province','AR','Argentina'),(88,'Eastern District','AS','American Samoa'),(89,'Burgenland','AT','Austria'),(90,'Carinthia','AT','Austria'),(91,'Lower Austria','AT','Austria'),(92,'Salzburg','AT','Austria'),(93,'Styria','AT','Austria'),(94,'Tyrol','AT','Austria'),(95,'Upper Austria','AT','Austria'),(96,'Vienna','AT','Austria'),(97,'Vorarlberg','AT','Austria'),(98,'Australian Capital Territory','AU','Australia'),(99,'New South Wales','AU','Australia'),(100,'Northern Territory','AU','Australia'),(101,'Queensland','AU','Australia'),(102,'South Australia','AU','Australia'),(103,'Tasmania','AU','Australia'),(104,'Victoria','AU','Australia'),(105,'Western Australia','AU','Australia'),(106,NULL,'AW','Aruba'),(107,NULL,'AX','Åland'),(108,'Baku City','AZ','Azerbaijan'),(109,'Imishli Rayon','AZ','Azerbaijan'),(110,'Nakhichevan','AZ','Azerbaijan'),(111,'Qusar Rayon','AZ','Azerbaijan'),(112,'Sabirabad Rayon','AZ','Azerbaijan'),(113,'Sumqayit City','AZ','Azerbaijan'),(114,'Brčko','BA','Bosnia and Herzegovina'),(115,'Federation of Bosnia and Herzegovina','BA','Bosnia and Herzegovina'),(116,'Republic of Srspka','BA','Bosnia and Herzegovina'),(117,'Christ Church','BB','Barbados'),(118,'Saint Andrew','BB','Barbados'),(119,'Saint George','BB','Barbados'),(120,'Saint James','BB','Barbados'),(121,'Saint Joseph','BB','Barbados'),(122,'Saint Lucy','BB','Barbados'),(123,'Saint Michael','BB','Barbados'),(124,'Saint Philip','BB','Barbados'),(125,'Saint Thomas','BB','Barbados'),(126,'Barisal Division','BD','Bangladesh'),(127,'Chittagong','BD','Bangladesh'),(128,'Dhaka Division','BD','Bangladesh'),(129,'Khulna Division','BD','Bangladesh'),(130,'Rajshahi Division','BD','Bangladesh'),(131,'Rangpur Division','BD','Bangladesh'),(132,'Sylhet Division','BD','Bangladesh'),(133,'Brussels Capital','BE','Belgium'),(134,'Flanders','BE','Belgium'),(135,'Wallonia','BE','Belgium'),(136,'Cascades Region','BF','Burkina Faso'),(137,'Centre','BF','Burkina Faso'),(138,'Hauts-Bassins','BF','Burkina Faso'),(139,'Blagoevgrad','BG','Bulgaria'),(140,'Burgas','BG','Bulgaria'),(141,'Gabrovo','BG','Bulgaria'),(142,'Haskovo','BG','Bulgaria'),(143,'Lovech','BG','Bulgaria'),(144,'Oblast Dobrich','BG','Bulgaria'),(145,'Oblast Kardzhali','BG','Bulgaria'),(146,'Oblast Kyustendil','BG','Bulgaria'),(147,'Oblast Montana','BG','Bulgaria'),(148,'Oblast Pleven','BG','Bulgaria'),(149,'Oblast Razgrad','BG','Bulgaria'),(150,'Oblast Ruse','BG','Bulgaria'),(151,'Oblast Shumen','BG','Bulgaria'),(152,'Oblast Silistra','BG','Bulgaria'),(153,'Oblast Sliven','BG','Bulgaria'),(154,'Oblast Smolyan','BG','Bulgaria'),(155,'Oblast Stara Zagora','BG','Bulgaria'),(156,'Oblast Targovishte','BG','Bulgaria'),(157,'Oblast Veliko Tarnovo','BG','Bulgaria'),(158,'Oblast Vidin','BG','Bulgaria'),(159,'Oblast Vratsa','BG','Bulgaria'),(160,'Oblast Yambol','BG','Bulgaria'),(161,'Pazardzhik','BG','Bulgaria'),(162,'Pernik','BG','Bulgaria'),(163,'Plovdiv','BG','Bulgaria'),(164,'Sofia Province','BG','Bulgaria'),(165,'Sofia-Capital','BG','Bulgaria'),(166,'Varna','BG','Bulgaria'),(167,'Central Governorate','BH','Bahrain'),(168,'Manama','BH','Bahrain'),(169,'Muharraq','BH','Bahrain'),(170,'Southern Governorate','BH','Bahrain'),(171,'Bujumbura Mairie Province','BI','Burundi'),(172,'Atlantique Department','BJ','Benin'),(173,'Littoral','BJ','Benin'),(174,NULL,'BL','Saint-Barthélemy'),(175,'Hamilton city','BM','Bermuda'),(176,'Saint George','BM','Bermuda'),(177,'Sandys Parish','BM','Bermuda'),(178,'Belait District','BN','Brunei'),(179,'Brunei and Muara District','BN','Brunei'),(180,'Temburong District','BN','Brunei'),(181,'Tutong District','BN','Brunei'),(182,'Departamento de Chuquisaca','BO','Bolivia'),(183,'Departamento de Cochabamba','BO','Bolivia'),(184,'Departamento de La Paz','BO','Bolivia'),(185,'Departamento de Pando','BO','Bolivia'),(186,'Departamento de Potosi','BO','Bolivia'),(187,'Departamento de Santa Cruz','BO','Bolivia'),(188,'Departamento de Tarija','BO','Bolivia'),(189,'El Beni','BO','Bolivia'),(190,'Oruro','BO','Bolivia'),(191,'Bonaire','BQ','Bonaire, Sint Eustatius, and Saba'),(192,'Saba','BQ','Bonaire, Sint Eustatius, and Saba'),(193,'Acre','BR','Brazil'),(194,'Alagoas','BR','Brazil'),(195,'Amapa','BR','Brazil'),(196,'Amazonas','BR','Brazil'),(197,'Bahia','BR','Brazil'),(198,'Ceara','BR','Brazil'),(199,'Espirito Santo','BR','Brazil'),(200,'Federal District','BR','Brazil'),(201,'Goias','BR','Brazil'),(202,'Maranhao','BR','Brazil'),(203,'Mato Grosso','BR','Brazil'),(204,'Mato Grosso do Sul','BR','Brazil'),(205,'Minas Gerais','BR','Brazil'),(206,'Para','BR','Brazil'),(207,'Parana','BR','Brazil'),(208,'Paraíba','BR','Brazil'),(209,'Pernambuco','BR','Brazil'),(210,'Piaui','BR','Brazil'),(211,'Rio Grande do Norte','BR','Brazil'),(212,'Rio Grande do Sul','BR','Brazil'),(213,'Rio de Janeiro','BR','Brazil'),(214,'Rondonia','BR','Brazil'),(215,'Roraima','BR','Brazil'),(216,'Santa Catarina','BR','Brazil'),(217,'Sao Paulo','BR','Brazil'),(218,'Sergipe','BR','Brazil'),(219,'Tocantins','BR','Brazil'),(220,'Bimini','BS','Bahamas'),(221,'Central Abaco District','BS','Bahamas'),(222,'City of Freeport District','BS','Bahamas'),(223,'Harbour Island','BS','Bahamas'),(224,'New Providence District','BS','Bahamas'),(225,'North Andros District','BS','Bahamas'),(226,'North Eleuthera','BS','Bahamas'),(227,'Chukha District','BT','Bhutan'),(228,'Mongar District','BT','Bhutan'),(229,'Thimphu Dzongkhag','BT','Bhutan'),(230,'Central District','BW','Botswana'),(231,'Kweneng District','BW','Botswana'),(232,'North-East','BW','Botswana'),(233,'North-West','BW','Botswana'),(234,'South-East','BW','Botswana'),(235,'Brest','BY','Belarus'),(236,'Gomel','BY','Belarus'),(237,'Grodnenskaya','BY','Belarus'),(238,'Minsk','BY','Belarus'),(239,'Minsk City','BY','Belarus'),(240,'Mogilev','BY','Belarus'),(241,'Vitebsk','BY','Belarus'),(242,'Belize District','BZ','Belize'),(243,'Cayo District','BZ','Belize'),(244,'Corozal District','BZ','Belize'),(245,'Orange Walk District','BZ','Belize'),(246,'Stann Creek District','BZ','Belize'),(247,'Toledo District','BZ','Belize'),(248,'Alberta','CA','Canada'),(249,'British Columbia','CA','Canada'),(250,'Manitoba','CA','Canada'),(251,'New Brunswick','CA','Canada'),(252,'Newfoundland and Labrador','CA','Canada'),(253,'Northwest Territories','CA','Canada'),(254,'Nova Scotia','CA','Canada'),(255,'Nunavut','CA','Canada'),(256,'Ontario','CA','Canada'),(257,'Prince Edward Island','CA','Canada'),(258,'Quebec','CA','Canada'),(259,'Saskatchewan','CA','Canada'),(260,'Yukon','CA','Canada'),(261,NULL,'CC','Cocos [Keeling] Islands'),(262,'Bas-Congo','CD','Congo'),(263,'Katanga Province','CD','Congo'),(264,'Kinshasa City','CD','Congo'),(265,'Nord Kivu','CD','Congo'),(266,'South Kivu Province','CD','Congo'),(267,'Bangui','CF','Central African Republic'),(268,'Mbomou','CF','Central African Republic'),(269,'Brazzaville','CG','Republic of the Congo'),(270,'Pointe-Noire','CG','Republic of the Congo'),(271,'Sangha','CG','Republic of the Congo'),(272,'Aargau','CH','Switzerland'),(273,'Appenzell Ausserrhoden','CH','Switzerland'),(274,'Appenzell Innerrhoden','CH','Switzerland'),(275,'Basel-City','CH','Switzerland'),(276,'Basel-Landschaft','CH','Switzerland'),(277,'Bern','CH','Switzerland'),(278,'Fribourg','CH','Switzerland'),(279,'Geneva','CH','Switzerland'),(280,'Glarus','CH','Switzerland'),(281,'Grisons','CH','Switzerland'),(282,'Jura','CH','Switzerland'),(283,'Lucerne','CH','Switzerland'),(284,'Neuchâtel','CH','Switzerland'),(285,'Nidwalden','CH','Switzerland'),(286,'Obwalden','CH','Switzerland'),(287,'Saint Gallen','CH','Switzerland'),(288,'Schaffhausen','CH','Switzerland'),(289,'Schwyz','CH','Switzerland'),(290,'Solothurn','CH','Switzerland'),(291,'Thurgau','CH','Switzerland'),(292,'Ticino','CH','Switzerland'),(293,'Uri','CH','Switzerland'),(294,'Valais','CH','Switzerland'),(295,'Vaud','CH','Switzerland'),(296,'Zug','CH','Switzerland'),(297,'Zurich','CH','Switzerland'),(298,'Abidjan','CI','Ivory Coast'),(299,'Comoe','CI','Ivory Coast'),(300,'District des Montagnes','CI','Ivory Coast'),(301,'Sassandra-Marahoue','CI','Ivory Coast'),(302,NULL,'CK','Cook Islands'),(303,'Antofagasta','CL','Chile'),(304,'Atacama','CL','Chile'),(305,'Aysen','CL','Chile'),(306,'Coquimbo','CL','Chile'),(307,'Los Lagos','CL','Chile'),(308,'Maule','CL','Chile'),(309,'Region de Arica y Parinacota','CL','Chile'),(310,'Region de Los Rios','CL','Chile'),(311,'Region de Magallanes y de la Antartica Chilena','CL','Chile'),(312,'Region de Valparaiso','CL','Chile'),(313,'Region de la Araucania','CL','Chile'),(314,'Region del Biobio','CL','Chile'),(315,'Region del Libertador General Bernardo O\'Higgins','CL','Chile'),(316,'Santiago Metropolitan','CL','Chile'),(317,'Tarapacá','CL','Chile'),(318,'Adamaoua Region','CM','Cameroon'),(319,'Centre','CM','Cameroon'),(320,'Littoral','CM','Cameroon'),(321,'North Region','CM','Cameroon'),(322,'North-West Region','CM','Cameroon'),(323,'South','CM','Cameroon'),(324,'South-West Region','CM','Cameroon'),(325,'West Region','CM','Cameroon'),(326,'Anhui','CN','China'),(327,'Beijing','CN','China'),(328,'Chongqing','CN','China'),(329,'Fujian','CN','China'),(330,'Gansu','CN','China'),(331,'Guangdong','CN','China'),(332,'Guangxi Zhuang Autonomous Region','CN','China'),(333,'Guizhou','CN','China'),(334,'Hainan','CN','China'),(335,'Hebei','CN','China'),(336,'Heilongjiang','CN','China'),(337,'Henan','CN','China'),(338,'Hubei','CN','China'),(339,'Hunan','CN','China'),(340,'Inner Mongolia Autonomous Region','CN','China'),(341,'Jiangsu','CN','China'),(342,'Jiangxi','CN','China'),(343,'Jilin','CN','China'),(344,'Liaoning','CN','China'),(345,'Ningsia Hui Autonomous Region','CN','China'),(346,'Qinghai','CN','China'),(347,'Shaanxi','CN','China'),(348,'Shandong','CN','China'),(349,'Shanghai','CN','China'),(350,'Shanxi','CN','China'),(351,'Sichuan','CN','China'),(352,'Tianjin','CN','China'),(353,'Tibet Autonomous Region','CN','China'),(354,'Xinjiang Uyghur Autonomous Region','CN','China'),(355,'Yunnan','CN','China'),(356,'Zhejiang','CN','China'),(357,'Amazonas','CO','Colombia'),(358,'Antioquia','CO','Colombia'),(359,'Atlántico','CO','Colombia'),(360,'Bogota D.C.','CO','Colombia'),(361,'Cundinamarca','CO','Colombia'),(362,'Departamento de Bolivar','CO','Colombia'),(363,'Departamento de Boyaca','CO','Colombia'),(364,'Departamento de Caldas','CO','Colombia'),(365,'Departamento de Casanare','CO','Colombia'),(366,'Departamento de Cordoba','CO','Colombia'),(367,'Departamento de La Guajira','CO','Colombia'),(368,'Departamento de Narino','CO','Colombia'),(369,'Departamento de Norte de Santander','CO','Colombia'),(370,'Departamento de Risaralda','CO','Colombia'),(371,'Departamento de Santander','CO','Colombia'),(372,'Departamento de Sucre','CO','Colombia'),(373,'Departamento de Tolima','CO','Colombia'),(374,'Departamento del Caqueta','CO','Colombia'),(375,'Departamento del Cauca','CO','Colombia'),(376,'Departamento del Cesar','CO','Colombia'),(377,'Departamento del Choco','CO','Colombia'),(378,'Departamento del Guainia','CO','Colombia'),(379,'Departamento del Guaviare','CO','Colombia'),(380,'Departamento del Huila','CO','Colombia'),(381,'Departamento del Magdalena','CO','Colombia'),(382,'Departamento del Meta','CO','Colombia'),(383,'Departamento del Valle del Cauca','CO','Colombia'),(384,'Departamento del Vichada','CO','Colombia'),(385,'Providencia y Santa Catalina, Departamento de Archipielago de San Andres','CO','Colombia'),(386,'Quindio Department','CO','Colombia'),(387,'Provincia de Alajuela','CR','Costa Rica'),(388,'Provincia de Cartago','CR','Costa Rica'),(389,'Provincia de Guanacaste','CR','Costa Rica'),(390,'Provincia de Heredia','CR','Costa Rica'),(391,'Provincia de Limon','CR','Costa Rica'),(392,'Provincia de Puntarenas','CR','Costa Rica'),(393,'Provincia de San Jose','CR','Costa Rica'),(394,'La Habana','CU','Cuba'),(395,'Provincia de Camagueey','CU','Cuba'),(396,'Provincia de Ciego de Avila','CU','Cuba'),(397,'Provincia de Matanzas','CU','Cuba'),(398,'Provincia de Villa Clara','CU','Cuba'),(399,'Ribeira Grande','CV','Cape Verde'),(400,'Ribeira Grande de Santiago','CV','Cape Verde'),(401,'São Domingos','CV','Cape Verde'),(402,NULL,'CW','Curaçao'),(403,NULL,'CX','Christmas Island'),(404,'Ammochostos','CY','Cyprus'),(405,'Keryneia','CY','Cyprus'),(406,'Larnaka','CY','Cyprus'),(407,'Limassol','CY','Cyprus'),(408,'Nicosia','CY','Cyprus'),(409,'Pafos','CY','Cyprus'),(410,'Central Bohemia','CZ','Czechia'),(411,'Hlavni mesto Praha','CZ','Czechia'),(412,'Jihocesky kraj','CZ','Czechia'),(413,'Karlovarsky kraj','CZ','Czechia'),(414,'Kraj Vysocina','CZ','Czechia'),(415,'Kralovehradecky kraj','CZ','Czechia'),(416,'Liberecky kraj','CZ','Czechia'),(417,'Moravskoslezsky kraj','CZ','Czechia'),(418,'Olomoucky kraj','CZ','Czechia'),(419,'Pardubicky kraj','CZ','Czechia'),(420,'Plzensky kraj','CZ','Czechia'),(421,'South Moravian','CZ','Czechia'),(422,'Ustecky kraj','CZ','Czechia'),(423,'Zlín','CZ','Czechia'),(424,'Baden-Württemberg Region','DE','Germany'),(425,'Bavaria','DE','Germany'),(426,'Brandenburg','DE','Germany'),(427,'Bremen','DE','Germany'),(428,'Hamburg','DE','Germany'),(429,'Hesse','DE','Germany'),(430,'Land Berlin','DE','Germany'),(431,'Lower Saxony','DE','Germany'),(432,'Mecklenburg-Vorpommern','DE','Germany'),(433,'North Rhine-Westphalia','DE','Germany'),(434,'Rheinland-Pfalz','DE','Germany'),(435,'Saarland','DE','Germany'),(436,'Saxony','DE','Germany'),(437,'Saxony-Anhalt','DE','Germany'),(438,'Schleswig-Holstein','DE','Germany'),(439,'Thuringia','DE','Germany'),(440,NULL,'DJ','Djibouti'),(441,'Capital Region','DK','Denmark'),(442,'Central Jutland','DK','Denmark'),(443,'North Denmark','DK','Denmark'),(444,'South Denmark','DK','Denmark'),(445,'Zealand','DK','Denmark'),(446,'Saint Andrew','DM','Dominica'),(447,'Saint David','DM','Dominica'),(448,'Saint George','DM','Dominica'),(449,'Saint John','DM','Dominica'),(450,'Saint Patrick','DM','Dominica'),(451,'Saint Paul','DM','Dominica'),(452,'Nacional','DO','Dominican Republic'),(453,'Provincia Duarte','DO','Dominican Republic'),(454,'Provincia Espaillat','DO','Dominican Republic'),(455,'Provincia Sanchez Ramirez','DO','Dominican Republic'),(456,'Provincia de Barahona','DO','Dominican Republic'),(457,'Provincia de El Seibo','DO','Dominican Republic'),(458,'Provincia de Hato Mayor','DO','Dominican Republic'),(459,'Provincia de Hermanas Mirabal','DO','Dominican Republic'),(460,'Provincia de Independencia','DO','Dominican Republic'),(461,'Provincia de La Altagracia','DO','Dominican Republic'),(462,'Provincia de La Romana','DO','Dominican Republic'),(463,'Provincia de La Vega','DO','Dominican Republic'),(464,'Provincia de Monsenor Nouel','DO','Dominican Republic'),(465,'Provincia de Monte Cristi','DO','Dominican Republic'),(466,'Provincia de Monte Plata','DO','Dominican Republic'),(467,'Provincia de Pedernales','DO','Dominican Republic'),(468,'Provincia de Peravia','DO','Dominican Republic'),(469,'Provincia de San Cristobal','DO','Dominican Republic'),(470,'Provincia de San Jose de Ocoa','DO','Dominican Republic'),(471,'Provincia de San Juan','DO','Dominican Republic'),(472,'Provincia de San Pedro de Macoris','DO','Dominican Republic'),(473,'Provincia de Santiago','DO','Dominican Republic'),(474,'Provincia de Santiago Rodriguez','DO','Dominican Republic'),(475,'Provincia de Santo Domingo','DO','Dominican Republic'),(476,'Puerto Plata','DO','Dominican Republic'),(477,'Adrar','DZ','Algeria'),(478,'Algiers','DZ','Algeria'),(479,'Annaba','DZ','Algeria'),(480,'Aïn Defla','DZ','Algeria'),(481,'Aïn Témouchent','DZ','Algeria'),(482,'Batna','DZ','Algeria'),(483,'Biskra','DZ','Algeria'),(484,'Blida','DZ','Algeria'),(485,'Bouira','DZ','Algeria'),(486,'Boumerdes','DZ','Algeria'),(487,'Béchar','DZ','Algeria'),(488,'Béjaïa','DZ','Algeria'),(489,'Chlef','DZ','Algeria'),(490,'Constantine','DZ','Algeria'),(491,'Djelfa','DZ','Algeria'),(492,'El Bayadh','DZ','Algeria'),(493,'El Tarf','DZ','Algeria'),(494,'Ghardaia','DZ','Algeria'),(495,'Guelma','DZ','Algeria'),(496,'Illizi','DZ','Algeria'),(497,'Jijel','DZ','Algeria'),(498,'Khenchela','DZ','Algeria'),(499,'Laghouat','DZ','Algeria'),(500,'M\'Sila','DZ','Algeria'),(501,'Mascara','DZ','Algeria'),(502,'Medea','DZ','Algeria'),(503,'Mila','DZ','Algeria'),(504,'Mostaganem','DZ','Algeria'),(505,'Naama','DZ','Algeria'),(506,'Oran','DZ','Algeria'),(507,'Ouargla','DZ','Algeria'),(508,'Oum el Bouaghi','DZ','Algeria'),(509,'Relizane','DZ','Algeria'),(510,'Saida','DZ','Algeria'),(511,'Sidi Bel Abbès','DZ','Algeria'),(512,'Skikda','DZ','Algeria'),(513,'Sétif','DZ','Algeria'),(514,'Tamanrasset','DZ','Algeria'),(515,'Tiaret','DZ','Algeria'),(516,'Tindouf','DZ','Algeria'),(517,'Tipaza','DZ','Algeria'),(518,'Tissemsilt','DZ','Algeria'),(519,'Tizi Ouzou','DZ','Algeria'),(520,'Tlemcen','DZ','Algeria'),(521,'Provincia de Bolivar','EC','Ecuador'),(522,'Provincia de Cotopaxi','EC','Ecuador'),(523,'Provincia de El Oro','EC','Ecuador'),(524,'Provincia de Esmeraldas','EC','Ecuador'),(525,'Provincia de Francisco de Orellana','EC','Ecuador'),(526,'Provincia de Imbabura','EC','Ecuador'),(527,'Provincia de Loja','EC','Ecuador'),(528,'Provincia de Los Rios','EC','Ecuador'),(529,'Provincia de Manabi','EC','Ecuador'),(530,'Provincia de Morona-Santiago','EC','Ecuador'),(531,'Provincia de Napo','EC','Ecuador'),(532,'Provincia de Pichincha','EC','Ecuador'),(533,'Provincia de Santa Elena','EC','Ecuador'),(534,'Provincia de Santo Domingo de los Tsachilas','EC','Ecuador'),(535,'Provincia de Sucumbios','EC','Ecuador'),(536,'Provincia de Zamora-Chinchipe','EC','Ecuador'),(537,'Provincia del Azuay','EC','Ecuador'),(538,'Provincia del Canar','EC','Ecuador'),(539,'Provincia del Carchi','EC','Ecuador'),(540,'Provincia del Chimborazo','EC','Ecuador'),(541,'Provincia del Guayas','EC','Ecuador'),(542,'Provincia del Pastaza','EC','Ecuador'),(543,'Provincia del Tungurahua','EC','Ecuador'),(544,'Harjumaa','EE','Estonia'),(545,'Hiiumaa','EE','Estonia'),(546,'Ida-Virumaa','EE','Estonia'),(547,'Järvamaa','EE','Estonia'),(548,'Jõgevamaa','EE','Estonia'),(549,'Lääne','EE','Estonia'),(550,'Lääne-Virumaa','EE','Estonia'),(551,'Pärnumaa','EE','Estonia'),(552,'Põlvamaa','EE','Estonia'),(553,'Raplamaa','EE','Estonia'),(554,'Saare','EE','Estonia'),(555,'Tartu','EE','Estonia'),(556,'Valgamaa','EE','Estonia'),(557,'Viljandimaa','EE','Estonia'),(558,'Võrumaa','EE','Estonia'),(559,'Alexandria','EG','Egypt'),(560,'Aswan','EG','Egypt'),(561,'Asyut','EG','Egypt'),(562,'Beheira','EG','Egypt'),(563,'Beni Suweif','EG','Egypt'),(564,'Cairo Governorate','EG','Egypt'),(565,'Dakahlia','EG','Egypt'),(566,'Damietta Governorate','EG','Egypt'),(567,'Faiyum','EG','Egypt'),(568,'Gharbia','EG','Egypt'),(569,'Giza','EG','Egypt'),(570,'Ismailia Governorate','EG','Egypt'),(571,'Kafr el-Sheikh','EG','Egypt'),(572,'Luxor','EG','Egypt'),(573,'Minya','EG','Egypt'),(574,'Monufia','EG','Egypt'),(575,'North Sinai','EG','Egypt'),(576,'Port Said','EG','Egypt'),(577,'Qalyubia','EG','Egypt'),(578,'Qena','EG','Egypt'),(579,'Red Sea','EG','Egypt'),(580,'Sharqia','EG','Egypt'),(581,'Sohag','EG','Egypt'),(582,'Suez','EG','Egypt'),(583,'Maekel Region','ER','Eritrea'),(584,'Andalusia','ES','Spain'),(585,'Aragon','ES','Spain'),(586,'Balearic Islands','ES','Spain'),(587,'Basque Country','ES','Spain'),(588,'Canary Islands','ES','Spain'),(589,'Cantabria','ES','Spain'),(590,'Castille and León','ES','Spain'),(591,'Castille-La Mancha','ES','Spain'),(592,'Catalonia','ES','Spain'),(593,'Ceuta','ES','Spain'),(594,'Extremadura','ES','Spain'),(595,'Galicia','ES','Spain'),(596,'La Rioja','ES','Spain'),(597,'Madrid','ES','Spain'),(598,'Melilla','ES','Spain'),(599,'Murcia','ES','Spain'),(600,'Navarre','ES','Spain'),(601,'Principality of Asturias','ES','Spain'),(602,'Valencia','ES','Spain'),(603,'Addis Ababa','ET','Ethiopia'),(604,'Afar Region','ET','Ethiopia'),(605,'Amhara','ET','Ethiopia'),(606,'Bīnshangul Gumuz','ET','Ethiopia'),(607,'Dire Dawa','ET','Ethiopia'),(608,'Gambela','ET','Ethiopia'),(609,'Harari Region','ET','Ethiopia'),(610,'Oromiya','ET','Ethiopia'),(611,'Somali','ET','Ethiopia'),(612,'Southern Nations, Nationalities, and People\'s Region','ET','Ethiopia'),(613,'Tigray','ET','Ethiopia'),(614,'Central Finland','FI','Finland'),(615,'Central Ostrobothnia','FI','Finland'),(616,'Haeme','FI','Finland'),(617,'Kainuu','FI','Finland'),(618,'Kymenlaakso','FI','Finland'),(619,'Lapland','FI','Finland'),(620,'Lapponia','FI','Finland'),(621,'North Karelia','FI','Finland'),(622,'Northern Ostrobothnia','FI','Finland'),(623,'Northern Savo','FI','Finland'),(624,'Päijänne Tavastia','FI','Finland'),(625,'Satakunta','FI','Finland'),(626,'South Karelia','FI','Finland'),(627,'Southern Ostrobothnia','FI','Finland'),(628,'Southern Savonia','FI','Finland'),(629,'Southwest Finland','FI','Finland'),(630,'Uusimaa','FI','Finland'),(631,'Western Finland','FI','Finland'),(632,'Central','FJ','Fiji'),(633,'Western','FJ','Fiji'),(634,NULL,'FK','Falkland Islands'),(635,'State of Yap','FM','Federated States of Micronesia'),(636,NULL,'FO','Faroe Islands'),(637,'Ain','FR','France'),(638,'Aisne','FR','France'),(639,'Allier','FR','France'),(640,'Ardennes','FR','France'),(641,'Ardèche','FR','France'),(642,'Ariège','FR','France'),(643,'Aube','FR','France'),(644,'Aude','FR','France'),(645,'Aveyron','FR','France'),(646,'Bas-Rhin','FR','France'),(647,'Brittany','FR','France'),(648,'Calvados','FR','France'),(649,'Cantal','FR','France'),(650,'Centre','FR','France'),(651,'Charente','FR','France'),(652,'Charente-Maritime','FR','France'),(653,'Corrèze','FR','France'),(654,'Corsica','FR','France'),(655,'Cote d\'Or','FR','France'),(656,'Creuse','FR','France'),(657,'Deux-Sèvres','FR','France'),(658,'Dordogne','FR','France'),(659,'Doubs','FR','France'),(660,'Drôme','FR','France'),(661,'Eure','FR','France'),(662,'Gard','FR','France'),(663,'Gers','FR','France'),(664,'Gironde','FR','France'),(665,'Haut-Rhin','FR','France'),(666,'Haute-Loire','FR','France'),(667,'Haute-Marne','FR','France'),(668,'Haute-Savoie','FR','France'),(669,'Haute-Saône','FR','France'),(670,'Haute-Vienne','FR','France'),(671,'Hautes-Pyrénées','FR','France'),(672,'Hérault','FR','France'),(673,'Isère','FR','France'),(674,'Jura','FR','France'),(675,'Landes','FR','France'),(676,'Loire','FR','France'),(677,'Lot','FR','France'),(678,'Lot-et-Garonne','FR','France'),(679,'Lozère','FR','France'),(680,'Manche','FR','France'),(681,'Marne','FR','France'),(682,'Meurthe et Moselle','FR','France'),(683,'Meuse','FR','France'),(684,'Moselle','FR','France'),(685,'Nièvre','FR','France'),(686,'North','FR','France'),(687,'Oise','FR','France'),(688,'Orne','FR','France'),(689,'Pas-de-Calais','FR','France'),(690,'Pays de la Loire','FR','France'),(691,'Provence-Alpes-Côte d\'Azur','FR','France'),(692,'Puy-de-Dôme','FR','France'),(693,'Pyrénées-Atlantiques','FR','France'),(694,'Pyrénées-Orientales','FR','France'),(695,'Rhône','FR','France'),(696,'Savoy','FR','France'),(697,'Saône-et-Loire','FR','France'),(698,'Seine-Maritime','FR','France'),(699,'Somme','FR','France'),(700,'Tarn','FR','France'),(701,'Tarn-et-Garonne','FR','France'),(702,'Territoire de Belfort','FR','France'),(703,'Upper Garonne','FR','France'),(704,'Vienne','FR','France'),(705,'Vosges','FR','France'),(706,'Yonne','FR','France'),(707,'Île-de-France','FR','France'),(708,'Estuaire','GA','Gabon'),(709,'Haut-Ogooué','GA','Gabon'),(710,'Moyen-Ogooué','GA','Gabon'),(711,'Ngouni','GA','Gabon'),(712,'Ogooué-Maritime','GA','Gabon'),(713,'England','GB','United Kingdom'),(714,'Northern Ireland','GB','United Kingdom'),(715,'Scotland','GB','United Kingdom'),(716,'Wales','GB','United Kingdom'),(717,'Saint Andrew','GD','Grenada'),(718,'Saint George','GD','Grenada'),(719,'Saint Mark','GD','Grenada'),(720,'Saint Patrick','GD','Grenada'),(721,'Abkhazia','GE','Georgia'),(722,'Ajaria','GE','Georgia'),(723,'Guria','GE','Georgia'),(724,'Imereti','GE','Georgia'),(725,'K\'alak\'i T\'bilisi','GE','Georgia'),(726,'Kakheti','GE','Georgia'),(727,'Mtskheta-Mtianeti','GE','Georgia'),(728,'Racha-Lechkhumi and Kvemo Svaneti','GE','Georgia'),(729,'Samegrelo and Zemo Svaneti','GE','Georgia'),(730,'Shida Kartli','GE','Georgia'),(731,NULL,'GF','French Guiana'),(732,NULL,'GG','Guernsey'),(733,'Ashanti Region','GH','Ghana'),(734,'Brong-Ahafo','GH','Ghana'),(735,'Central Region','GH','Ghana'),(736,'Eastern Region','GH','Ghana'),(737,'Greater Accra Region','GH','Ghana'),(738,'Upper East Region','GH','Ghana'),(739,'Upper West Region','GH','Ghana'),(740,'Volta Region','GH','Ghana'),(741,'Western Region','GH','Ghana'),(742,NULL,'GI','Gibraltar'),(743,'Kujalleq','GL','Greenland'),(744,'Qaasuitsup','GL','Greenland'),(745,'Qeqqata','GL','Greenland'),(746,'Sermersooq','GL','Greenland'),(747,'City of Banjul','GM','Gambia'),(748,'Western Division','GM','Gambia'),(749,'Boke Region','GN','Guinea'),(750,'Conakry Region','GN','Guinea'),(751,'Faranah','GN','Guinea'),(752,'Kankan Region','GN','Guinea'),(753,'Kindia','GN','Guinea'),(754,'Labe Region','GN','Guinea'),(755,'Mamou Region','GN','Guinea'),(756,'Nzerekore Region','GN','Guinea'),(757,NULL,'GP','Guadeloupe'),(758,'Bioko Norte','GQ','Equatorial Guinea'),(759,'Wele-Nzas','GQ','Equatorial Guinea'),(760,'Attica','GR','Greece'),(761,'Central Greece','GR','Greece'),(762,'Central Macedonia','GR','Greece'),(763,'Crete','GR','Greece'),(764,'East Macedonia and Thrace','GR','Greece'),(765,'Epirus','GR','Greece'),(766,'Ionian Islands','GR','Greece'),(767,'North Aegean','GR','Greece'),(768,'Peloponnese','GR','Greece'),(769,'South Aegean','GR','Greece'),(770,'Thessaly','GR','Greece'),(771,'West Greece','GR','Greece'),(772,'West Macedonia','GR','Greece'),(773,NULL,'GS','South Georgia and the South Sandwich Islands'),(774,'Departamento de Alta Verapaz','GT','Guatemala'),(775,'Departamento de Chimaltenango','GT','Guatemala'),(776,'Departamento de Escuintla','GT','Guatemala'),(777,'Departamento de Guatemala','GT','Guatemala'),(778,'Departamento de Huehuetenango','GT','Guatemala'),(779,'Departamento de Jalapa','GT','Guatemala'),(780,'Departamento de Jutiapa','GT','Guatemala'),(781,'Departamento de Quetzaltenango','GT','Guatemala'),(782,'Departamento de Retalhuleu','GT','Guatemala'),(783,'Departamento de Sacatepequez','GT','Guatemala'),(784,'Departamento de Zacapa','GT','Guatemala'),(785,'Suchitepeque','GT','Guatemala'),(786,NULL,'GU','Guam'),(787,'Bissau','GW','Guinea-Bissau'),(788,'Bolama and Bijagos','GW','Guinea-Bissau'),(789,'Cacheu Region','GW','Guinea-Bissau'),(790,'Demerara-Mahaica Region','GY','Guyana'),(791,'East Berbice-Corentyne Region','GY','Guyana'),(792,'Upper Demerara-Berbice Region','GY','Guyana'),(793,'Central and Western District','HK','Hong Kong'),(794,'Eastern','HK','Hong Kong'),(795,'Kowloon City','HK','Hong Kong'),(796,'North','HK','Hong Kong'),(797,'Sha Tin','HK','Hong Kong'),(798,'Sham Shui Po','HK','Hong Kong'),(799,'Southern','HK','Hong Kong'),(800,'Wanchai','HK','Hong Kong'),(801,'Wong Tai Sin','HK','Hong Kong'),(802,'Yau Tsim Mong','HK','Hong Kong'),(803,'Yuen Long District','HK','Hong Kong'),(804,'Bay Islands','HN','Honduras'),(805,'Departamento de Atlantida','HN','Honduras'),(806,'Departamento de Choluteca','HN','Honduras'),(807,'Departamento de Colon','HN','Honduras'),(808,'Departamento de Comayagua','HN','Honduras'),(809,'Departamento de Copan','HN','Honduras'),(810,'Departamento de Cortes','HN','Honduras'),(811,'Departamento de El Paraiso','HN','Honduras'),(812,'Departamento de Francisco Morazan','HN','Honduras'),(813,'Departamento de Gracias a Dios','HN','Honduras'),(814,'Departamento de La Paz','HN','Honduras'),(815,'Departamento de Lempira','HN','Honduras'),(816,'Departamento de Olancho','HN','Honduras'),(817,'Departamento de Santa Barbara','HN','Honduras'),(818,'Departamento de Valle','HN','Honduras'),(819,'Departamento de Yoro','HN','Honduras'),(820,'Bjelovarsko-Bilogorska Zupanija','HR','Croatia'),(821,'City of Zagreb','HR','Croatia'),(822,'Dubrovacko-Neretvanska Zupanija','HR','Croatia'),(823,'Istarska Zupanija','HR','Croatia'),(824,'Karlovacka Zupanija','HR','Croatia'),(825,'Koprivnicko-Krizevacka Zupanija','HR','Croatia'),(826,'Krapinsko-Zagorska Zupanija','HR','Croatia'),(827,'Licko-Senjska Zupanija','HR','Croatia'),(828,'Megimurska Zupanija','HR','Croatia'),(829,'Osjecko-Baranjska Zupanija','HR','Croatia'),(830,'Pozesko-Slavonska Zupanija','HR','Croatia'),(831,'Primorsko-Goranska Zupanija','HR','Croatia'),(832,'Sibensko-Kninska Zupanija','HR','Croatia'),(833,'Sisacko-Moslavacka Zupanija','HR','Croatia'),(834,'Slavonski Brod-Posavina','HR','Croatia'),(835,'Splitsko-Dalmatinska Zupanija','HR','Croatia'),(836,'Varazdinska Zupanija','HR','Croatia'),(837,'Viroviticko-Podravska Zupanija','HR','Croatia'),(838,'Vukovar-Sirmium','HR','Croatia'),(839,'Zadarska Zupanija','HR','Croatia'),(840,'Zagreb County','HR','Croatia'),(841,'Departement de l\'Ouest','HT','Haiti'),(842,'Nord','HT','Haiti'),(843,'Sud','HT','Haiti'),(844,'Sud-Est','HT','Haiti'),(845,'Baranya','HU','Hungary'),(846,'Bekes','HU','Hungary'),(847,'Borsod-Abaúj-Zemplén','HU','Hungary'),(848,'Budapest','HU','Hungary'),(849,'Bács-Kiskun','HU','Hungary'),(850,'Csongrad megye','HU','Hungary'),(851,'Fejér','HU','Hungary'),(852,'Győr-Moson-Sopron','HU','Hungary'),(853,'Hajdú-Bihar','HU','Hungary'),(854,'Heves megye','HU','Hungary'),(855,'Jász-Nagykun-Szolnok','HU','Hungary'),(856,'Komárom-Esztergom','HU','Hungary'),(857,'Nograd megye','HU','Hungary'),(858,'Pest megye','HU','Hungary'),(859,'Somogy megye','HU','Hungary'),(860,'Szabolcs-Szatmár-Bereg','HU','Hungary'),(861,'Tolna megye','HU','Hungary'),(862,'Vas','HU','Hungary'),(863,'Veszprem megye','HU','Hungary'),(864,'Zala','HU','Hungary'),(865,'Aceh','ID','Indonesia'),(866,'Bali','ID','Indonesia'),(867,'Bangka–Belitung Islands','ID','Indonesia'),(868,'Banten','ID','Indonesia'),(869,'Bengkulu','ID','Indonesia'),(870,'Central Java','ID','Indonesia'),(871,'Central Kalimantan','ID','Indonesia'),(872,'Central Sulawesi','ID','Indonesia'),(873,'East Java','ID','Indonesia'),(874,'East Kalimantan','ID','Indonesia'),(875,'East Nusa Tenggara','ID','Indonesia'),(876,'Gorontalo','ID','Indonesia'),(877,'Jakarta','ID','Indonesia'),(878,'Jambi','ID','Indonesia'),(879,'Lampung','ID','Indonesia'),(880,'Maluku','ID','Indonesia'),(881,'North Kalimantan','ID','Indonesia'),(882,'North Maluku','ID','Indonesia'),(883,'North Sulawesi','ID','Indonesia'),(884,'North Sumatra','ID','Indonesia'),(885,'Papua','ID','Indonesia'),(886,'Riau','ID','Indonesia'),(887,'Riau Islands','ID','Indonesia'),(888,'South Kalimantan','ID','Indonesia'),(889,'South Sulawesi','ID','Indonesia'),(890,'South Sumatra','ID','Indonesia'),(891,'Southeast Sulawesi','ID','Indonesia'),(892,'West Java','ID','Indonesia'),(893,'West Kalimantan','ID','Indonesia'),(894,'West Nusa Tenggara','ID','Indonesia'),(895,'West Sulawesi','ID','Indonesia'),(896,'West Sumatra','ID','Indonesia'),(897,'Yogyakarta','ID','Indonesia'),(898,'Connaught','IE','Ireland'),(899,'Leinster','IE','Ireland'),(900,'Munster','IE','Ireland'),(901,'Ulster','IE','Ireland'),(902,'Central District','IL','Israel'),(903,'Haifa','IL','Israel'),(904,'Jerusalem','IL','Israel'),(905,'Northern District','IL','Israel'),(906,'Southern District','IL','Israel'),(907,'Tel Aviv','IL','Israel'),(908,NULL,'IM','Isle of Man'),(909,'Andhra Pradesh','IN','India'),(910,'Arunachal Pradesh','IN','India'),(911,'Assam','IN','India'),(912,'Bihar','IN','India'),(913,'Chandigarh','IN','India'),(914,'Chhattisgarh','IN','India'),(915,'Dadra and Nagar Haveli','IN','India'),(916,'Daman and Diu','IN','India'),(917,'Goa','IN','India'),(918,'Gujarat','IN','India'),(919,'Haryana','IN','India'),(920,'Himachal Pradesh','IN','India'),(921,'Jharkhand','IN','India'),(922,'Karnataka','IN','India'),(923,'Kashmir','IN','India'),(924,'Kerala','IN','India'),(925,'Laccadives','IN','India'),(926,'Madhya Pradesh','IN','India'),(927,'Maharashtra','IN','India'),(928,'Manipur','IN','India'),(929,'Meghalaya','IN','India'),(930,'Mizoram','IN','India'),(931,'Nagaland','IN','India'),(932,'National Capital Territory of Delhi','IN','India'),(933,'Odisha','IN','India'),(934,'Punjab','IN','India'),(935,'Rajasthan','IN','India'),(936,'Sikkim','IN','India'),(937,'Tamil Nadu','IN','India'),(938,'Telangana','IN','India'),(939,'Tripura','IN','India'),(940,'Union Territory of Andaman and Nicobar Islands','IN','India'),(941,'Union Territory of Puducherry','IN','India'),(942,'Uttar Pradesh','IN','India'),(943,'Uttarakhand','IN','India'),(944,'West Bengal','IN','India'),(945,NULL,'IO','British Indian Ocean Territory'),(946,'An Najaf','IQ','Iraq'),(947,'Anbar','IQ','Iraq'),(948,'Basra Governorate','IQ','Iraq'),(949,'Mayorality of Baghdad','IQ','Iraq'),(950,'Maysan','IQ','Iraq'),(951,'Muhafazat Arbil','IQ','Iraq'),(952,'Muhafazat Babil','IQ','Iraq'),(953,'Muhafazat Karbala\'','IQ','Iraq'),(954,'Muhafazat Kirkuk','IQ','Iraq'),(955,'Muhafazat Ninawa','IQ','Iraq'),(956,'Muhafazat Wasit','IQ','Iraq'),(957,'Muhafazat as Sulaymaniyah','IQ','Iraq'),(958,'Alborz','IR','Iran'),(959,'Bushehr','IR','Iran'),(960,'East Azerbaijan','IR','Iran'),(961,'Fars','IR','Iran'),(962,'Hormozgan','IR','Iran'),(963,'Isfahan','IR','Iran'),(964,'Kerman','IR','Iran'),(965,'Khuzestan','IR','Iran'),(966,'Markazi','IR','Iran'),(967,'Māzandarān','IR','Iran'),(968,'Ostan-e Ardabil','IR','Iran'),(969,'Ostan-e Azarbayjan-e Gharbi','IR','Iran'),(970,'Ostan-e Chahar Mahal va Bakhtiari','IR','Iran'),(971,'Ostan-e Gilan','IR','Iran'),(972,'Ostan-e Golestan','IR','Iran'),(973,'Ostan-e Hamadan','IR','Iran'),(974,'Ostan-e Ilam','IR','Iran'),(975,'Ostan-e Kermanshah','IR','Iran'),(976,'Ostan-e Khorasan-e Shomali','IR','Iran'),(977,'Ostan-e Kordestan','IR','Iran'),(978,'Ostan-e Qazvin','IR','Iran'),(979,'Ostan-e Tehran','IR','Iran'),(980,'Razavi Khorasan','IR','Iran'),(981,'Semnān','IR','Iran'),(982,'Sistan and Baluchestan','IR','Iran'),(983,'Yazd','IR','Iran'),(984,'Zanjan','IR','Iran'),(985,'Capital Region','IS','Iceland'),(986,'East','IS','Iceland'),(987,'Northeast','IS','Iceland'),(988,'Northwest','IS','Iceland'),(989,'South','IS','Iceland'),(990,'Southern Peninsula','IS','Iceland'),(991,'West','IS','Iceland'),(992,'Westfjords','IS','Iceland'),(993,'Abruzzo','IT','Italy'),(994,'Aosta Valley','IT','Italy'),(995,'Apulia','IT','Italy'),(996,'Basilicate','IT','Italy'),(997,'Calabria','IT','Italy'),(998,'Campania','IT','Italy'),(999,'Emilia-Romagna','IT','Italy'),(1000,'Friuli Venezia Giulia','IT','Italy'),(1001,'Latium','IT','Italy'),(1002,'Liguria','IT','Italy'),(1003,'Lombardy','IT','Italy'),(1004,'Molise','IT','Italy'),(1005,'Piedmont','IT','Italy'),(1006,'Sardinia','IT','Italy'),(1007,'Sicily','IT','Italy'),(1008,'The Marches','IT','Italy'),(1009,'Trentino-Alto Adige','IT','Italy'),(1010,'Tuscany','IT','Italy'),(1011,'Umbria','IT','Italy'),(1012,'Veneto','IT','Italy'),(1013,NULL,'JE','Jersey'),(1014,'Clarendon','JM','Jamaica'),(1015,'Kingston','JM','Jamaica'),(1016,'Manchester','JM','Jamaica'),(1017,'Parish of Saint Ann','JM','Jamaica'),(1018,'Portland','JM','Jamaica'),(1019,'Saint Catherine','JM','Jamaica'),(1020,'Saint Elizabeth','JM','Jamaica'),(1021,'Saint James','JM','Jamaica'),(1022,'Saint Mary','JM','Jamaica'),(1023,'Saint Thomas','JM','Jamaica'),(1024,'Westmoreland','JM','Jamaica'),(1025,'Ajloun','JO','Hashemite Kingdom of Jordan'),(1026,'Amman Governorate','JO','Hashemite Kingdom of Jordan'),(1027,'Aqaba','JO','Hashemite Kingdom of Jordan'),(1028,'Balqa','JO','Hashemite Kingdom of Jordan'),(1029,'Irbid','JO','Hashemite Kingdom of Jordan'),(1030,'Jerash','JO','Hashemite Kingdom of Jordan'),(1031,'Karak','JO','Hashemite Kingdom of Jordan'),(1032,'Madaba','JO','Hashemite Kingdom of Jordan'),(1033,'Mafraq','JO','Hashemite Kingdom of Jordan'),(1034,'Ma’an','JO','Hashemite Kingdom of Jordan'),(1035,'Tafielah','JO','Hashemite Kingdom of Jordan'),(1036,'Zarqa','JO','Hashemite Kingdom of Jordan'),(1037,'Aichi','JP','Japan'),(1038,'Akita','JP','Japan'),(1039,'Aomori','JP','Japan'),(1040,'Chiba','JP','Japan'),(1041,'Ehime','JP','Japan'),(1042,'Fukui','JP','Japan'),(1043,'Fukuoka','JP','Japan'),(1044,'Fukushima-ken','JP','Japan'),(1045,'Gifu','JP','Japan'),(1046,'Gunma','JP','Japan'),(1047,'Hiroshima','JP','Japan'),(1048,'Hokkaido','JP','Japan'),(1049,'Hyōgo','JP','Japan'),(1050,'Ibaraki','JP','Japan'),(1051,'Ishikawa','JP','Japan'),(1052,'Iwate','JP','Japan'),(1053,'Kagawa','JP','Japan'),(1054,'Kagoshima','JP','Japan'),(1055,'Kanagawa','JP','Japan'),(1056,'Kochi','JP','Japan'),(1057,'Kumamoto','JP','Japan'),(1058,'Kyoto','JP','Japan'),(1059,'Mie','JP','Japan'),(1060,'Miyagi','JP','Japan'),(1061,'Miyazaki','JP','Japan'),(1062,'Nagano','JP','Japan'),(1063,'Nagasaki','JP','Japan'),(1064,'Nara','JP','Japan'),(1065,'Niigata','JP','Japan'),(1066,'Oita','JP','Japan'),(1067,'Okayama','JP','Japan'),(1068,'Okinawa','JP','Japan'),(1069,'Saga Prefecture','JP','Japan'),(1070,'Saitama','JP','Japan'),(1071,'Shiga Prefecture','JP','Japan'),(1072,'Shimane','JP','Japan'),(1073,'Shizuoka','JP','Japan'),(1074,'Tochigi','JP','Japan'),(1075,'Tokushima','JP','Japan'),(1076,'Tokyo','JP','Japan'),(1077,'Tottori','JP','Japan'),(1078,'Toyama','JP','Japan'),(1079,'Wakayama','JP','Japan'),(1080,'Yamagata','JP','Japan'),(1081,'Yamaguchi','JP','Japan'),(1082,'Yamanashi','JP','Japan'),(1083,'Ōsaka','JP','Japan'),(1084,'Bomet District','KE','Kenya'),(1085,'Garissa District','KE','Kenya'),(1086,'Homa Bay District','KE','Kenya'),(1087,'Kericho District','KE','Kenya'),(1088,'Kiambu District','KE','Kenya'),(1089,'Kilifi District','KE','Kenya'),(1090,'Kisii District','KE','Kenya'),(1091,'Kisumu','KE','Kenya'),(1092,'Kwale District','KE','Kenya'),(1093,'Mandera District','KE','Kenya'),(1094,'Mombasa District','KE','Kenya'),(1095,'Murang\'a District','KE','Kenya'),(1096,'Nairobi Province','KE','Kenya'),(1097,'Nakuru District','KE','Kenya'),(1098,'Nyeri District','KE','Kenya'),(1099,'Siaya District','KE','Kenya'),(1100,'Tharaka District','KE','Kenya'),(1101,'Trans Nzoia District','KE','Kenya'),(1102,'Uasin Gishu','KE','Kenya'),(1103,'Batken','KG','Kyrgyzstan'),(1104,'Chuyskaya Oblast\'','KG','Kyrgyzstan'),(1105,'Gorod Bishkek','KG','Kyrgyzstan'),(1106,'Issyk-Kul Region','KG','Kyrgyzstan'),(1107,'Jalal-Abad oblast','KG','Kyrgyzstan'),(1108,'Naryn oblast','KG','Kyrgyzstan'),(1109,'Osh Oblasty','KG','Kyrgyzstan'),(1110,'Talas','KG','Kyrgyzstan'),(1111,'Banteay Meanchey','KH','Cambodia'),(1112,'Battambang','KH','Cambodia'),(1113,'Kandal','KH','Cambodia'),(1114,'Phnom Penh','KH','Cambodia'),(1115,'Preah Sihanouk','KH','Cambodia'),(1116,'Gilbert Islands','KI','Kiribati'),(1117,'Grande Comore','KM','Comoros'),(1118,'Ndzuwani','KM','Comoros'),(1119,'Saint George Basseterre','KN','Saint Kitts and Nevis'),(1120,'Saint Mary Cayon','KN','Saint Kitts and Nevis'),(1121,'Saint Paul Charlestown','KN','Saint Kitts and Nevis'),(1122,'Chagang-do','KP','North Korea'),(1123,'Pyongyang','KP','North Korea'),(1124,'Busan','KR','Republic of Korea'),(1125,'Chungcheongbuk-do','KR','Republic of Korea'),(1126,'Chungcheongnam-do','KR','Republic of Korea'),(1127,'Daegu','KR','Republic of Korea'),(1128,'Daejeon','KR','Republic of Korea'),(1129,'Gangwon-do','KR','Republic of Korea'),(1130,'Gwangju','KR','Republic of Korea'),(1131,'Gyeonggi-do','KR','Republic of Korea'),(1132,'Gyeongsangbuk-do','KR','Republic of Korea'),(1133,'Gyeongsangnam-do','KR','Republic of Korea'),(1134,'Incheon','KR','Republic of Korea'),(1135,'Jeju-do','KR','Republic of Korea'),(1136,'Jeollabuk-do','KR','Republic of Korea'),(1137,'Jeollanam-do','KR','Republic of Korea'),(1138,'Seoul','KR','Republic of Korea'),(1139,'Ulsan','KR','Republic of Korea'),(1140,'Al Asimah','KW','Kuwait'),(1141,'Al Aḩmadī','KW','Kuwait'),(1142,'Al Farwaniyah','KW','Kuwait'),(1143,'Hawalli','KW','Kuwait'),(1144,NULL,'KY','Cayman Islands'),(1145,'Aktyubinskaya Oblast\'','KZ','Kazakhstan'),(1146,'Almaty Oblysy','KZ','Kazakhstan'),(1147,'Almaty Qalasy','KZ','Kazakhstan'),(1148,'Aqmola Oblysy','KZ','Kazakhstan'),(1149,'Astana Qalasy','KZ','Kazakhstan'),(1150,'Atyrau Oblysy','KZ','Kazakhstan'),(1151,'East Kazakhstan','KZ','Kazakhstan'),(1152,'Mangistauskaya Oblast\'','KZ','Kazakhstan'),(1153,'Pavlodar Oblysy','KZ','Kazakhstan'),(1154,'Qaraghandy Oblysy','KZ','Kazakhstan'),(1155,'Qostanay Oblysy','KZ','Kazakhstan'),(1156,'Qyzylorda Oblysy','KZ','Kazakhstan'),(1157,'Severo-Kazakhstanskaya Oblast\'','KZ','Kazakhstan'),(1158,'Yuzhno-Kazakhstanskaya Oblast\'','KZ','Kazakhstan'),(1159,'Zapadno-Kazakhstanskaya Oblast\'','KZ','Kazakhstan'),(1160,'Zhambyl Oblysy','KZ','Kazakhstan'),(1161,'Khammouan','LA','Laos'),(1162,'Vientiane','LA','Laos'),(1163,'Beyrouth','LB','Lebanon'),(1164,'Mohafazat Aakkar','LB','Lebanon'),(1165,'Mohafazat Baalbek-Hermel','LB','Lebanon'),(1166,'Mohafazat Liban-Nord','LB','Lebanon'),(1167,'Mohafazat Mont-Liban','LB','Lebanon'),(1168,'South Governorate','LB','Lebanon'),(1169,'Anse-la-Raye','LC','Saint Lucia'),(1170,'Castries Quarter','LC','Saint Lucia'),(1171,'Choiseul Quarter','LC','Saint Lucia'),(1172,'Dennery Quarter','LC','Saint Lucia'),(1173,'Gros-Islet','LC','Saint Lucia'),(1174,'Laborie Quarter','LC','Saint Lucia'),(1175,'Micoud Quarter','LC','Saint Lucia'),(1176,'Quarter of Dauphin','LC','Saint Lucia'),(1177,'Quarter of Praslin','LC','Saint Lucia'),(1178,'Soufriere','LC','Saint Lucia'),(1179,'Vieux-Fort','LC','Saint Lucia'),(1180,'Balzers','LI','Liechtenstein'),(1181,'Eschen','LI','Liechtenstein'),(1182,'Gemeinde Gamprin','LI','Liechtenstein'),(1183,'Mauren','LI','Liechtenstein'),(1184,'Ruggell','LI','Liechtenstein'),(1185,'Schaan','LI','Liechtenstein'),(1186,'Schellenberg','LI','Liechtenstein'),(1187,'Triesen','LI','Liechtenstein'),(1188,'Triesenberg','LI','Liechtenstein'),(1189,'Vaduz','LI','Liechtenstein'),(1190,'Central Province','LK','Sri Lanka'),(1191,'Eastern Province','LK','Sri Lanka'),(1192,'North Central Province','LK','Sri Lanka'),(1193,'North Western Province','LK','Sri Lanka'),(1194,'Province of Sabaragamuwa','LK','Sri Lanka'),(1195,'Province of Uva','LK','Sri Lanka'),(1196,'Southern Province','LK','Sri Lanka'),(1197,'Western Province','LK','Sri Lanka'),(1198,'Montserrado County','LR','Liberia'),(1199,'Nimba County','LR','Liberia'),(1200,'Berea','LS','Lesotho'),(1201,'Leribe','LS','Lesotho'),(1202,'Maseru','LS','Lesotho'),(1203,'Alytus County','LT','Republic of Lithuania'),(1204,'Kaunas County','LT','Republic of Lithuania'),(1205,'Klaipėda County','LT','Republic of Lithuania'),(1206,'Marijampolė County','LT','Republic of Lithuania'),(1207,'Panevėžys','LT','Republic of Lithuania'),(1208,'Tauragė County','LT','Republic of Lithuania'),(1209,'Telšiai County','LT','Republic of Lithuania'),(1210,'Utena County','LT','Republic of Lithuania'),(1211,'Vilnius County','LT','Republic of Lithuania'),(1212,'Šiauliai County','LT','Republic of Lithuania'),(1213,'District de Diekirch','LU','Luxembourg'),(1214,'District de Grevenmacher','LU','Luxembourg'),(1215,'District de Luxembourg','LU','Luxembourg'),(1216,'Aizkraukles Rajons','LV','Latvia'),(1217,'Aizpute','LV','Latvia'),(1218,'Aloja','LV','Latvia'),(1219,'Babīte','LV','Latvia'),(1220,'Baldone','LV','Latvia'),(1221,'Balvu Novads','LV','Latvia'),(1222,'Bauskas Novads','LV','Latvia'),(1223,'Brocēni','LV','Latvia'),(1224,'Burtnieki','LV','Latvia'),(1225,'Carnikava','LV','Latvia'),(1226,'Cesu Novads','LV','Latvia'),(1227,'Daugavpils','LV','Latvia'),(1228,'Daugavpils municipality','LV','Latvia'),(1229,'Dobeles Rajons','LV','Latvia'),(1230,'Dundaga','LV','Latvia'),(1231,'Engure','LV','Latvia'),(1232,'Garkalne','LV','Latvia'),(1233,'Grobiņa','LV','Latvia'),(1234,'Gulbenes Rajons','LV','Latvia'),(1235,'Ikšķile','LV','Latvia'),(1236,'Inčukalns','LV','Latvia'),(1237,'Jaunpiebalga','LV','Latvia'),(1238,'Jelgava','LV','Latvia'),(1239,'Jelgavas Rajons','LV','Latvia'),(1240,'Jurmala','LV','Latvia'),(1241,'Jēkabpils Municipality','LV','Latvia'),(1242,'Kandava','LV','Latvia'),(1243,'Koknese','LV','Latvia'),(1244,'Kuldigas Rajons','LV','Latvia'),(1245,'Lecava','LV','Latvia'),(1246,'Lielvārde','LV','Latvia'),(1247,'Liepaja','LV','Latvia'),(1248,'Limbazu Rajons','LV','Latvia'),(1249,'Ludzas Rajons','LV','Latvia'),(1250,'Līvāni','LV','Latvia'),(1251,'Madona Municipality','LV','Latvia'),(1252,'Mārupe','LV','Latvia'),(1253,'Ogre','LV','Latvia'),(1254,'Olaine','LV','Latvia'),(1255,'Ozolnieku Novads','LV','Latvia'),(1256,'Plavinu Novads','LV','Latvia'),(1257,'Preili Municipality','LV','Latvia'),(1258,'Rezekne','LV','Latvia'),(1259,'Riga','LV','Latvia'),(1260,'Rojas Novads','LV','Latvia'),(1261,'Ropazu Novads','LV','Latvia'),(1262,'Rugaju Novads','LV','Latvia'),(1263,'Rujienas Novads','LV','Latvia'),(1264,'Salacgrivas Novads','LV','Latvia'),(1265,'Salaspils Novads','LV','Latvia'),(1266,'Saldus Municipality','LV','Latvia'),(1267,'Saulkrastu Novads','LV','Latvia'),(1268,'Siguldas Novads','LV','Latvia'),(1269,'Skrundas Novads','LV','Latvia'),(1270,'Stopinu Novads','LV','Latvia'),(1271,'Talsi Municipality','LV','Latvia'),(1272,'Tukuma Rajons','LV','Latvia'),(1273,'Vainodes Novads','LV','Latvia'),(1274,'Valka Municipality','LV','Latvia'),(1275,'Valmiera District','LV','Latvia'),(1276,'Varaklanu Novads','LV','Latvia'),(1277,'Ventspils','LV','Latvia'),(1278,'Viesites Novads','LV','Latvia'),(1279,'Zilupes Novads','LV','Latvia'),(1280,'Ādaži','LV','Latvia'),(1281,'Ķegums','LV','Latvia'),(1282,'Ķekava','LV','Latvia'),(1283,'Sha\'biyat Banghazi','LY','Libya'),(1284,'Sha\'biyat Misratah','LY','Libya'),(1285,'Sha\'biyat Sabha','LY','Libya'),(1286,'Sha`biyat Nalut','LY','Libya'),(1287,'Tripoli','LY','Libya'),(1288,'Chaouia-Ouardigha','MA','Morocco'),(1289,'Doukkala-Abda','MA','Morocco'),(1290,'Gharb-Chrarda-Beni Hssen','MA','Morocco'),(1291,'Guelmim-Es Semara','MA','Morocco'),(1292,'Laayoune-Boujdour-Sakia El Hamra','MA','Morocco'),(1293,'Marrakech-Tensift-Al Haouz','MA','Morocco'),(1294,'Oriental','MA','Morocco'),(1295,'Oued-Ed-Dahab','MA','Morocco'),(1296,'Region de Fes-Boulemane','MA','Morocco'),(1297,'Region de Meknes-Tafilalet','MA','Morocco'),(1298,'Region de Rabat-Sale-Zemmour-Zaer','MA','Morocco'),(1299,'Region de Souss-Massa-Draa','MA','Morocco'),(1300,'Region de Tanger-Tetouan','MA','Morocco'),(1301,'Region du Grand Casablanca','MA','Morocco'),(1302,'Tadla-Azilal','MA','Morocco'),(1303,'Taza-Al Hoceima-Taounate','MA','Morocco'),(1304,NULL,'MC','Monaco'),(1305,'Anenii Noi','MD','Republic of Moldova'),(1306,'Basarabeasca','MD','Republic of Moldova'),(1307,'Briceni','MD','Republic of Moldova'),(1308,'Cahul','MD','Republic of Moldova'),(1309,'Cantemir','MD','Republic of Moldova'),(1310,'Cimişlia','MD','Republic of Moldova'),(1311,'Criuleni','MD','Republic of Moldova'),(1312,'Donduşeni','MD','Republic of Moldova'),(1313,'Drochia','MD','Republic of Moldova'),(1314,'Floreşti','MD','Republic of Moldova'),(1315,'Făleşti','MD','Republic of Moldova'),(1316,'Gagauzia','MD','Republic of Moldova'),(1317,'Glodeni','MD','Republic of Moldova'),(1318,'Hînceşti','MD','Republic of Moldova'),(1319,'Laloveni','MD','Republic of Moldova'),(1320,'Leova','MD','Republic of Moldova'),(1321,'Municipiul Balti','MD','Republic of Moldova'),(1322,'Municipiul Bender','MD','Republic of Moldova'),(1323,'Municipiul Chisinau','MD','Republic of Moldova'),(1324,'Nisporeni','MD','Republic of Moldova'),(1325,'Orhei','MD','Republic of Moldova'),(1326,'Raionul Causeni','MD','Republic of Moldova'),(1327,'Raionul Dubasari','MD','Republic of Moldova'),(1328,'Raionul Edineţ','MD','Republic of Moldova'),(1329,'Raionul Ocniţa','MD','Republic of Moldova'),(1330,'Raionul Soroca','MD','Republic of Moldova'),(1331,'Raionul Stefan Voda','MD','Republic of Moldova'),(1332,'Rezina','MD','Republic of Moldova'),(1333,'Rîşcani','MD','Republic of Moldova'),(1334,'Strășeni','MD','Republic of Moldova'),(1335,'Sîngerei','MD','Republic of Moldova'),(1336,'Taraclia','MD','Republic of Moldova'),(1337,'Teleneşti','MD','Republic of Moldova'),(1338,'Ungheni','MD','Republic of Moldova'),(1339,'Unitatea Teritoriala din Stinga Nistrului','MD','Republic of Moldova'),(1340,'Şoldăneşti','MD','Republic of Moldova'),(1341,'Berane','ME','Montenegro'),(1342,'Budva','ME','Montenegro'),(1343,'Danilovgrad','ME','Montenegro'),(1344,'Herceg Novi','ME','Montenegro'),(1345,'Kotor','ME','Montenegro'),(1346,'Podgorica','ME','Montenegro'),(1347,'Ulcinj','ME','Montenegro'),(1348,NULL,'MF','Saint Martin'),(1349,NULL,'MG','Madagascar'),(1350,'Majuro Atoll','MH','Marshall Islands'),(1351,'Bitola','MK','Macedonia'),(1352,'Bogdanci','MK','Macedonia'),(1353,'Bogovinje','MK','Macedonia'),(1354,'Debar','MK','Macedonia'),(1355,'Demir Hisar','MK','Macedonia'),(1356,'Gevgelija','MK','Macedonia'),(1357,'Gostivar','MK','Macedonia'),(1358,'Gradsko','MK','Macedonia'),(1359,'Kavadarci','MK','Macedonia'),(1360,'Kisela Voda','MK','Macedonia'),(1361,'Kratovo','MK','Macedonia'),(1362,'Kumanovo','MK','Macedonia'),(1363,'Makedonski Brod','MK','Macedonia'),(1364,'Negotino','MK','Macedonia'),(1365,'Novo Selo','MK','Macedonia'),(1366,'Ohrid','MK','Macedonia'),(1367,'Opstina Karpos','MK','Macedonia'),(1368,'Opstina Kicevo','MK','Macedonia'),(1369,'Opstina Kocani','MK','Macedonia'),(1370,'Opstina Lipkovo','MK','Macedonia'),(1371,'Opstina Probistip','MK','Macedonia'),(1372,'Opstina Radovis','MK','Macedonia'),(1373,'Opstina Stip','MK','Macedonia'),(1374,'Opstina Vrapciste','MK','Macedonia'),(1375,'Prilep','MK','Macedonia'),(1376,'Resen Municipality','MK','Macedonia'),(1377,'Struga','MK','Macedonia'),(1378,'Strumica','MK','Macedonia'),(1379,'Tetovo','MK','Macedonia'),(1380,'Valandovo Municipality','MK','Macedonia'),(1381,'Veles','MK','Macedonia'),(1382,'Bamako Region','ML','Mali'),(1383,'Kayah State','MM','Myanmar [Burma]'),(1384,'Magway Region','MM','Myanmar [Burma]'),(1385,'Mandalay Region','MM','Myanmar [Burma]'),(1386,'Yangon Region','MM','Myanmar [Burma]'),(1387,'Arhangay Aymag','MN','Mongolia'),(1388,'Bayan-OElgiy Aymag','MN','Mongolia'),(1389,'Bayanhongor Aymag','MN','Mongolia'),(1390,'Central Aimak','MN','Mongolia'),(1391,'East Gobi Aymag','MN','Mongolia'),(1392,'Govi-Altay Aymag','MN','Mongolia'),(1393,'Govi-Sumber','MN','Mongolia'),(1394,'Hentiy Aymag','MN','Mongolia'),(1395,'Hovd','MN','Mongolia'),(1396,'Hovsgol Aymag','MN','Mongolia'),(1397,'Middle Govĭ','MN','Mongolia'),(1398,'Selenge Aymag','MN','Mongolia'),(1399,'Suhbaatar Aymag','MN','Mongolia'),(1400,'Ulaanbaatar Hot','MN','Mongolia'),(1401,'Ömnögovĭ','MN','Mongolia'),(1402,'Övörhangay','MN','Mongolia'),(1403,NULL,'MO','Macao'),(1404,'Saipan','MP','Northern Mariana Islands'),(1405,NULL,'MQ','Martinique'),(1406,'District de Nouakchott','MR','Mauritania'),(1407,NULL,'MS','Montserrat'),(1408,'Attard','MT','Malta'),(1409,'Balzan','MT','Malta'),(1410,'Birkirkara','MT','Malta'),(1411,'Birzebbuga','MT','Malta'),(1412,'Bormla','MT','Malta'),(1413,'Ghajnsielem','MT','Malta'),(1414,'Hal Gharghur','MT','Malta'),(1415,'Hal Ghaxaq','MT','Malta'),(1416,'Haz-Zabbar','MT','Malta'),(1417,'Haz-Zebbug','MT','Malta'),(1418,'Il-Belt Valletta','MT','Malta'),(1419,'Il-Birgu','MT','Malta'),(1420,'Il-Fgura','MT','Malta'),(1421,'Il-Furjana','MT','Malta'),(1422,'Il-Gudja','MT','Malta'),(1423,'Il-Gzira','MT','Malta'),(1424,'Il-Hamrun','MT','Malta'),(1425,'Il-Kalkara','MT','Malta'),(1426,'Il-Marsa','MT','Malta'),(1427,'Il-Mellieha','MT','Malta'),(1428,'Il-Mosta','MT','Malta'),(1429,'Il-Munxar','MT','Malta'),(1430,'Il-Qala','MT','Malta'),(1431,'Il-Qrendi','MT','Malta'),(1432,'In-Naxxar','MT','Malta'),(1433,'Ir-Rabat','MT','Malta'),(1434,'Is-Siggiewi','MT','Malta'),(1435,'Is-Swieqi','MT','Malta'),(1436,'Ix-Xaghra','MT','Malta'),(1437,'Ix-Xewkija','MT','Malta'),(1438,'Iz-Zebbug','MT','Malta'),(1439,'Iz-Zejtun','MT','Malta'),(1440,'Iz-Zurrieq','MT','Malta'),(1441,'Kirkop','MT','Malta'),(1442,'L-Gharb','MT','Malta'),(1443,'L-Ghasri','MT','Malta'),(1444,'L-Iklin','MT','Malta'),(1445,'L-Imdina','MT','Malta'),(1446,'L-Imgarr','MT','Malta'),(1447,'L-Imqabba','MT','Malta'),(1448,'L-Imsida','MT','Malta'),(1449,'L-Imtarfa','MT','Malta'),(1450,'L-Isla','MT','Malta'),(1451,'Lija','MT','Malta'),(1452,'Luqa','MT','Malta'),(1453,'Marsaskala','MT','Malta'),(1454,'Marsaxlokk','MT','Malta'),(1455,'Paola','MT','Malta'),(1456,'Qormi','MT','Malta'),(1457,'Safi','MT','Malta'),(1458,'Saint John','MT','Malta'),(1459,'Saint Julian','MT','Malta'),(1460,'Saint Lawrence','MT','Malta'),(1461,'Saint Lucia','MT','Malta'),(1462,'Saint Paul’s Bay','MT','Malta'),(1463,'Saint Venera','MT','Malta'),(1464,'Sannat','MT','Malta'),(1465,'Ta\' Xbiex','MT','Malta'),(1466,'Tal-Pieta','MT','Malta'),(1467,'Tarxien','MT','Malta'),(1468,'Tas-Sliema','MT','Malta'),(1469,'Victoria','MT','Malta'),(1470,'Black River District','MU','Mauritius'),(1471,'Flacq District','MU','Mauritius'),(1472,'Moka District','MU','Mauritius'),(1473,'Pamplemousses District','MU','Mauritius'),(1474,'Plaines Wilhems District','MU','Mauritius'),(1475,'Port Louis District','MU','Mauritius'),(1476,'Riviere du Rempart District','MU','Mauritius'),(1477,'Rodrigues','MU','Mauritius'),(1478,'Savanne District','MU','Mauritius'),(1479,'Kaafu Atoll','MV','Maldives'),(1480,'Central Region','MW','Malawi'),(1481,'Northern Region','MW','Malawi'),(1482,'Southern Region','MW','Malawi'),(1483,'Aguascalientes','MX','Mexico'),(1484,'Baja California Sur','MX','Mexico'),(1485,'Campeche','MX','Mexico'),(1486,'Chiapas','MX','Mexico'),(1487,'Chihuahua','MX','Mexico'),(1488,'Coahuila','MX','Mexico'),(1489,'Colima','MX','Mexico'),(1490,'Durango','MX','Mexico'),(1491,'Estado de Baja California','MX','Mexico'),(1492,'Estado de Mexico','MX','Mexico'),(1493,'Guanajuato','MX','Mexico'),(1494,'Guerrero','MX','Mexico'),(1495,'Hidalgo','MX','Mexico'),(1496,'Jalisco','MX','Mexico'),(1497,'Mexico City','MX','Mexico'),(1498,'Michoacán','MX','Mexico'),(1499,'Morelos','MX','Mexico'),(1500,'Nayarit','MX','Mexico'),(1501,'Nuevo León','MX','Mexico'),(1502,'Oaxaca','MX','Mexico'),(1503,'Puebla','MX','Mexico'),(1504,'Querétaro','MX','Mexico'),(1505,'Quintana Roo','MX','Mexico'),(1506,'San Luis Potosí','MX','Mexico'),(1507,'Sinaloa','MX','Mexico'),(1508,'Sonora','MX','Mexico'),(1509,'Tabasco','MX','Mexico'),(1510,'Tamaulipas','MX','Mexico'),(1511,'Tlaxcala','MX','Mexico'),(1512,'Veracruz','MX','Mexico'),(1513,'Yucatán','MX','Mexico'),(1514,'Zacatecas','MX','Mexico'),(1515,'Johor','MY','Malaysia'),(1516,'Kedah','MY','Malaysia'),(1517,'Kelantan','MY','Malaysia'),(1518,'Kuala Lumpur','MY','Malaysia'),(1519,'Labuan','MY','Malaysia'),(1520,'Melaka','MY','Malaysia'),(1521,'Negeri Sembilan','MY','Malaysia'),(1522,'Pahang','MY','Malaysia'),(1523,'Penang','MY','Malaysia'),(1524,'Perak','MY','Malaysia'),(1525,'Perlis','MY','Malaysia'),(1526,'Putrajaya','MY','Malaysia'),(1527,'Sabah','MY','Malaysia'),(1528,'Sarawak','MY','Malaysia'),(1529,'Selangor','MY','Malaysia'),(1530,'Terengganu','MY','Malaysia'),(1531,'Cabo Delgado Province','MZ','Mozambique'),(1532,'Cidade de Maputo','MZ','Mozambique'),(1533,'Gaza Province','MZ','Mozambique'),(1534,'Inhambane Province','MZ','Mozambique'),(1535,'Manica Province','MZ','Mozambique'),(1536,'Maputo Province','MZ','Mozambique'),(1537,'Nampula','MZ','Mozambique'),(1538,'Niassa Province','MZ','Mozambique'),(1539,'Provincia de Zambezia','MZ','Mozambique'),(1540,'Sofala Province','MZ','Mozambique'),(1541,'Tete','MZ','Mozambique'),(1542,'Erongo','NA','Namibia'),(1543,'Karas','NA','Namibia'),(1544,'Kavango East','NA','Namibia'),(1545,'Khomas','NA','Namibia'),(1546,'Kunene','NA','Namibia'),(1547,'Omaheke','NA','Namibia'),(1548,'Omusati','NA','Namibia'),(1549,'Oshana','NA','Namibia'),(1550,'Oshikoto','NA','Namibia'),(1551,'Otjozondjupa','NA','Namibia'),(1552,'Zambezi Region','NA','Namibia'),(1553,'South Province','NC','New Caledonia'),(1554,'Niamey','NE','Niger'),(1555,NULL,'NF','Norfolk Island'),(1556,'Abia State','NG','Nigeria'),(1557,'Adamawa','NG','Nigeria'),(1558,'Akwa Ibom State','NG','Nigeria'),(1559,'Anambra','NG','Nigeria'),(1560,'Bauchi','NG','Nigeria'),(1561,'Bayelsa State','NG','Nigeria'),(1562,'Cross River State','NG','Nigeria'),(1563,'Delta','NG','Nigeria'),(1564,'Ebonyi State','NG','Nigeria'),(1565,'Edo','NG','Nigeria'),(1566,'Ekiti State','NG','Nigeria'),(1567,'Enugu State','NG','Nigeria'),(1568,'Federal Capital Territory','NG','Nigeria'),(1569,'Gombe State','NG','Nigeria'),(1570,'Imo State','NG','Nigeria'),(1571,'Kaduna State','NG','Nigeria'),(1572,'Kano State','NG','Nigeria'),(1573,'Katsina State','NG','Nigeria'),(1574,'Kebbi State','NG','Nigeria'),(1575,'Kogi State','NG','Nigeria'),(1576,'Kwara State','NG','Nigeria'),(1577,'Lagos','NG','Nigeria'),(1578,'Nasarawa State','NG','Nigeria'),(1579,'Niger State','NG','Nigeria'),(1580,'Ogun State','NG','Nigeria'),(1581,'Ondo State','NG','Nigeria'),(1582,'Osun State','NG','Nigeria'),(1583,'Oyo State','NG','Nigeria'),(1584,'Plateau State','NG','Nigeria'),(1585,'Rivers State','NG','Nigeria'),(1586,'Sokoto State','NG','Nigeria'),(1587,'Taraba State','NG','Nigeria'),(1588,'Yobe State','NG','Nigeria'),(1589,'Zamfara State','NG','Nigeria'),(1590,'Departamento de Boaco','NI','Nicaragua'),(1591,'Departamento de Carazo','NI','Nicaragua'),(1592,'Departamento de Chinandega','NI','Nicaragua'),(1593,'Departamento de Chontales','NI','Nicaragua'),(1594,'Departamento de Esteli','NI','Nicaragua'),(1595,'Departamento de Granada','NI','Nicaragua'),(1596,'Departamento de Jinotega','NI','Nicaragua'),(1597,'Departamento de Leon','NI','Nicaragua'),(1598,'Departamento de Managua','NI','Nicaragua'),(1599,'Departamento de Masaya','NI','Nicaragua'),(1600,'Departamento de Matagalpa','NI','Nicaragua'),(1601,'Departamento de Nueva Segovia','NI','Nicaragua'),(1602,'Departamento de Rivas','NI','Nicaragua'),(1603,'Region Autonoma Atlantico Sur','NI','Nicaragua'),(1604,'Friesland','NL','Netherlands'),(1605,'Groningen','NL','Netherlands'),(1606,'Limburg','NL','Netherlands'),(1607,'North Brabant','NL','Netherlands'),(1608,'North Holland','NL','Netherlands'),(1609,'Provincie Drenthe','NL','Netherlands'),(1610,'Provincie Flevoland','NL','Netherlands'),(1611,'Provincie Gelderland','NL','Netherlands'),(1612,'Provincie Overijssel','NL','Netherlands'),(1613,'Provincie Utrecht','NL','Netherlands'),(1614,'Provincie Zeeland','NL','Netherlands'),(1615,'South Holland','NL','Netherlands'),(1616,'Akershus','NO','Norway'),(1617,'Aust-Agder','NO','Norway'),(1618,'Buskerud','NO','Norway'),(1619,'Finnmark Fylke','NO','Norway'),(1620,'Hedmark','NO','Norway'),(1621,'Hordaland Fylke','NO','Norway'),(1622,'More og Romsdal fylke','NO','Norway'),(1623,'Nord-Trondelag Fylke','NO','Norway'),(1624,'Nordland Fylke','NO','Norway'),(1625,'Oppland','NO','Norway'),(1626,'Oslo County','NO','Norway'),(1627,'Rogaland Fylke','NO','Norway'),(1628,'Sogn og Fjordane Fylke','NO','Norway'),(1629,'Sor-Trondelag Fylke','NO','Norway'),(1630,'Telemark','NO','Norway'),(1631,'Troms Fylke','NO','Norway'),(1632,'Vest-Agder Fylke','NO','Norway'),(1633,'Vestfold','NO','Norway'),(1634,'Østfold','NO','Norway'),(1635,'Central Region','NP','Nepal'),(1636,'Eastern Region','NP','Nepal'),(1637,'Far Western','NP','Nepal'),(1638,'Western Region','NP','Nepal'),(1639,'Anabar','NR','Nauru'),(1640,NULL,'NU','Niue'),(1641,'Auckland','NZ','New Zealand'),(1642,'Bay of Plenty Region','NZ','New Zealand'),(1643,'Canterbury','NZ','New Zealand'),(1644,'Chatham Islands','NZ','New Zealand'),(1645,'Gisborne','NZ','New Zealand'),(1646,'Hawke\'s Bay','NZ','New Zealand'),(1647,'Manawatu-Wanganui','NZ','New Zealand'),(1648,'Marlborough','NZ','New Zealand'),(1649,'Nelson','NZ','New Zealand'),(1650,'Northland Region','NZ','New Zealand'),(1651,'Otago','NZ','New Zealand'),(1652,'Southland','NZ','New Zealand'),(1653,'Taranaki','NZ','New Zealand'),(1654,'Tasman','NZ','New Zealand'),(1655,'Waikato','NZ','New Zealand'),(1656,'Wellington','NZ','New Zealand'),(1657,'West Coast','NZ','New Zealand'),(1658,'Al Batinah North Governorate','OM','Oman'),(1659,'Muhafazat Masqat','OM','Oman'),(1660,'Muhafazat Zufar','OM','Oman'),(1661,'Muhafazat ad Dakhiliyah','OM','Oman'),(1662,'Embera-Wounaan','PA','Panama'),(1663,'Guna Yala','PA','Panama'),(1664,'Ngoebe-Bugle','PA','Panama'),(1665,'Provincia de Bocas del Toro','PA','Panama'),(1666,'Provincia de Chiriqui','PA','Panama'),(1667,'Provincia de Cocle','PA','Panama'),(1668,'Provincia de Colon','PA','Panama'),(1669,'Provincia de Herrera','PA','Panama'),(1670,'Provincia de Los Santos','PA','Panama'),(1671,'Provincia de Panama','PA','Panama'),(1672,'Provincia de Veraguas','PA','Panama'),(1673,'Provincia del Darien','PA','Panama'),(1674,'Amazonas','PE','Peru'),(1675,'Ancash','PE','Peru'),(1676,'Apurimac','PE','Peru'),(1677,'Arequipa','PE','Peru'),(1678,'Ayacucho','PE','Peru'),(1679,'Cajamarca','PE','Peru'),(1680,'Callao','PE','Peru'),(1681,'Cusco','PE','Peru'),(1682,'Departamento de Moquegua','PE','Peru'),(1683,'Huancavelica','PE','Peru'),(1684,'Ica','PE','Peru'),(1685,'Junín Region','PE','Peru'),(1686,'La Libertad','PE','Peru'),(1687,'Lambayeque','PE','Peru'),(1688,'Lima region','PE','Peru'),(1689,'Loreto','PE','Peru'),(1690,'Pasco Region','PE','Peru'),(1691,'Piura','PE','Peru'),(1692,'Provincia de Lima','PE','Peru'),(1693,'Puno','PE','Peru'),(1694,'Region de Huanuco','PE','Peru'),(1695,'Region de San Martin','PE','Peru'),(1696,'Tacna','PE','Peru'),(1697,'Tumbes','PE','Peru'),(1698,'Ucayali','PE','Peru'),(1699,'Iles du Vent','PF','French Polynesia'),(1700,'Leeward Islands','PF','French Polynesia'),(1701,'Bougainville','PG','Papua New Guinea'),(1702,'Central Province','PG','Papua New Guinea'),(1703,'Chimbu Province','PG','Papua New Guinea'),(1704,'East New Britain Province','PG','Papua New Guinea'),(1705,'East Sepik Province','PG','Papua New Guinea'),(1706,'Eastern Highlands Province','PG','Papua New Guinea'),(1707,'Enga Province','PG','Papua New Guinea'),(1708,'Gulf Province','PG','Papua New Guinea'),(1709,'Madang Province','PG','Papua New Guinea'),(1710,'Manus Province','PG','Papua New Guinea'),(1711,'Milne Bay Province','PG','Papua New Guinea'),(1712,'Morobe Province','PG','Papua New Guinea'),(1713,'National Capital','PG','Papua New Guinea'),(1714,'New Ireland','PG','Papua New Guinea'),(1715,'Northern Province','PG','Papua New Guinea'),(1716,'Southern Highlands Province','PG','Papua New Guinea'),(1717,'West New Britain Province','PG','Papua New Guinea'),(1718,'West Sepik Province','PG','Papua New Guinea'),(1719,'Western Highlands Province','PG','Papua New Guinea'),(1720,'Western Province','PG','Papua New Guinea'),(1721,'Autonomous Region in Muslim Mindanao','PH','Philippines'),(1722,'Bicol','PH','Philippines'),(1723,'Cagayan Valley','PH','Philippines'),(1724,'Calabarzon','PH','Philippines'),(1725,'Caraga','PH','Philippines'),(1726,'Central Luzon','PH','Philippines'),(1727,'Central Visayas','PH','Philippines'),(1728,'Cordillera','PH','Philippines'),(1729,'Davao','PH','Philippines'),(1730,'Eastern Visayas','PH','Philippines'),(1731,'Ilocos','PH','Philippines'),(1732,'Mimaropa','PH','Philippines'),(1733,'National Capital Region','PH','Philippines'),(1734,'Northern Mindanao','PH','Philippines'),(1735,'Soccsksargen','PH','Philippines'),(1736,'Western Visayas','PH','Philippines'),(1737,'Zamboanga Peninsula','PH','Philippines'),(1738,'Azad Kashmir','PK','Pakistan'),(1739,'Balochistan','PK','Pakistan'),(1740,'Federally Administered Tribal Areas','PK','Pakistan'),(1741,'Gilgit-Baltistan','PK','Pakistan'),(1742,'Islamabad Capital Territory','PK','Pakistan'),(1743,'Khyber Pakhtunkhwa','PK','Pakistan'),(1744,'Punjab','PK','Pakistan'),(1745,'Sindh','PK','Pakistan'),(1746,'Greater Poland Voivodeship','PL','Poland'),(1747,'Kujawsko-Pomorskie','PL','Poland'),(1748,'Lesser Poland Voivodeship','PL','Poland'),(1749,'Lower Silesian Voivodeship','PL','Poland'),(1750,'Lublin Voivodeship','PL','Poland'),(1751,'Lubusz','PL','Poland'),(1752,'Masovian Voivodeship','PL','Poland'),(1753,'Opole Voivodeship','PL','Poland'),(1754,'Podlasie','PL','Poland'),(1755,'Pomeranian Voivodeship','PL','Poland'),(1756,'Silesian Voivodeship','PL','Poland'),(1757,'Subcarpathian Voivodeship','PL','Poland'),(1758,'Warmian-Masurian Voivodeship','PL','Poland'),(1759,'West Pomeranian Voivodeship','PL','Poland'),(1760,'Łódź Voivodeship','PL','Poland'),(1761,'Świętokrzyskie','PL','Poland'),(1762,'Commune de Miquelon-Langlade','PM','Saint Pierre and Miquelon'),(1763,'Commune de Saint-Pierre','PM','Saint Pierre and Miquelon'),(1764,NULL,'PN','Pitcairn Islands'),(1765,NULL,'PR','Puerto Rico'),(1766,NULL,'PS','Palestine'),(1767,'Aveiro','PT','Portugal'),(1768,'Azores','PT','Portugal'),(1769,'Beja','PT','Portugal'),(1770,'Braga','PT','Portugal'),(1771,'Bragança','PT','Portugal'),(1772,'Castelo Branco','PT','Portugal'),(1773,'Coimbra','PT','Portugal'),(1774,'Faro','PT','Portugal'),(1775,'Guarda','PT','Portugal'),(1776,'Leiria','PT','Portugal'),(1777,'Lisbon','PT','Portugal'),(1778,'Madeira','PT','Portugal'),(1779,'Portalegre','PT','Portugal'),(1780,'Porto','PT','Portugal'),(1781,'Santarém','PT','Portugal'),(1782,'Setúbal','PT','Portugal'),(1783,'Viana do Castelo','PT','Portugal'),(1784,'Vila Real','PT','Portugal'),(1785,'Viseu','PT','Portugal'),(1786,'Évora','PT','Portugal'),(1787,NULL,'PW','Palau'),(1788,'Asuncion','PY','Paraguay'),(1789,'Departamento Central','PY','Paraguay'),(1790,'Departamento de Alto Paraguay','PY','Paraguay'),(1791,'Departamento de Boqueron','PY','Paraguay'),(1792,'Departamento de Caazapa','PY','Paraguay'),(1793,'Departamento de Itapua','PY','Paraguay'),(1794,'Departamento de Misiones','PY','Paraguay'),(1795,'Departamento de Paraguari','PY','Paraguay'),(1796,'Departamento de la Cordillera','PY','Paraguay'),(1797,'Departamento del Alto Parana','PY','Paraguay'),(1798,'Departamento del Amambay','PY','Paraguay'),(1799,'Al Wakrah','QA','Qatar'),(1800,'Baladiyat Umm Salal','QA','Qatar'),(1801,'Baladiyat ad Dawhah','QA','Qatar'),(1802,'Baladiyat al Khawr wa adh Dhakhirah','QA','Qatar'),(1803,'Baladiyat ar Rayyan','QA','Qatar'),(1804,'Baladiyat ash Shamal','QA','Qatar'),(1805,NULL,'RE','Réunion'),(1806,'Arad','RO','Romania'),(1807,'Bihor','RO','Romania'),(1808,'Bucuresti','RO','Romania'),(1809,'Constanta','RO','Romania'),(1810,'Covasna','RO','Romania'),(1811,'Dolj','RO','Romania'),(1812,'Giurgiu','RO','Romania'),(1813,'Gorj','RO','Romania'),(1814,'Harghita','RO','Romania'),(1815,'Hunedoara','RO','Romania'),(1816,'Ilfov','RO','Romania'),(1817,'Judetul Alba','RO','Romania'),(1818,'Judetul Arges','RO','Romania'),(1819,'Judetul Bacau','RO','Romania'),(1820,'Judetul Bistrita-Nasaud','RO','Romania'),(1821,'Judetul Botosani','RO','Romania'),(1822,'Judetul Braila','RO','Romania'),(1823,'Judetul Brasov','RO','Romania'),(1824,'Judetul Buzau','RO','Romania'),(1825,'Judetul Calarasi','RO','Romania'),(1826,'Judetul Caras-Severin','RO','Romania'),(1827,'Judetul Cluj','RO','Romania'),(1828,'Judetul Dambovita','RO','Romania'),(1829,'Judetul Galati','RO','Romania'),(1830,'Judetul Ialomita','RO','Romania'),(1831,'Judetul Iasi','RO','Romania'),(1832,'Judetul Mehedinti','RO','Romania'),(1833,'Judetul Mures','RO','Romania'),(1834,'Judetul Neamt','RO','Romania'),(1835,'Judetul Salaj','RO','Romania'),(1836,'Judetul Sibiu','RO','Romania'),(1837,'Judetul Timis','RO','Romania'),(1838,'Judetul Valcea','RO','Romania'),(1839,'Maramureş','RO','Romania'),(1840,'Olt County','RO','Romania'),(1841,'Prahova','RO','Romania'),(1842,'Satu Mare','RO','Romania'),(1843,'Suceava','RO','Romania'),(1844,'Teleorman','RO','Romania'),(1845,'Tulcea','RO','Romania'),(1846,'Vaslui','RO','Romania'),(1847,'Vrancea','RO','Romania'),(1848,'Vojvodina','RS','Serbia'),(1849,'Altai Krai','RU','Russia'),(1850,'Altai Republic','RU','Russia'),(1851,'Amurskaya Oblast\'','RU','Russia'),(1852,'Arkhangelskaya','RU','Russia'),(1853,'Astrakhanskaya Oblast\'','RU','Russia'),(1854,'Bashkortostan','RU','Russia'),(1855,'Belgorodskaya Oblast\'','RU','Russia'),(1856,'Bryanskaya Oblast\'','RU','Russia'),(1857,'Chechnya','RU','Russia'),(1858,'Chelyabinsk','RU','Russia'),(1859,'Chukotskiy Avtonomnyy Okrug','RU','Russia'),(1860,'Chuvashia','RU','Russia'),(1861,'Dagestan','RU','Russia'),(1862,'Irkutskaya Oblast\'','RU','Russia'),(1863,'Ivanovskaya Oblast\'','RU','Russia'),(1864,'Jewish Autonomous Oblast','RU','Russia'),(1865,'Kabardino-Balkarskaya Respublika','RU','Russia'),(1866,'Kaliningradskaya Oblast\'','RU','Russia'),(1867,'Kalmykiya','RU','Russia'),(1868,'Kaluzhskaya Oblast\'','RU','Russia'),(1869,'Kamtchatski Kray','RU','Russia'),(1870,'Karachayevo-Cherkesiya','RU','Russia'),(1871,'Kemerovskaya Oblast\'','RU','Russia'),(1872,'Khabarovsk Krai','RU','Russia'),(1873,'Khanty-Mansiyskiy Avtonomnyy Okrug-Yugra','RU','Russia'),(1874,'Kirovskaya Oblast\'','RU','Russia'),(1875,'Komi Republic','RU','Russia'),(1876,'Kostromskaya Oblast\'','RU','Russia'),(1877,'Krasnodarskiy Kray','RU','Russia'),(1878,'Krasnoyarskiy Kray','RU','Russia'),(1879,'Kurganskaya Oblast\'','RU','Russia'),(1880,'Kurskaya Oblast\'','RU','Russia'),(1881,'Leningradskaya Oblast\'','RU','Russia'),(1882,'Lipetskaya Oblast\'','RU','Russia'),(1883,'Magadanskaya Oblast\'','RU','Russia'),(1884,'Moscow','RU','Russia'),(1885,'Moscow Oblast','RU','Russia'),(1886,'Murmansk','RU','Russia'),(1887,'Nenetskiy Avtonomnyy Okrug','RU','Russia'),(1888,'Nizhegorodskaya Oblast\'','RU','Russia'),(1889,'North Ossetia','RU','Russia'),(1890,'Novgorodskaya Oblast\'','RU','Russia'),(1891,'Novosibirskaya Oblast\'','RU','Russia'),(1892,'Omskaya Oblast\'','RU','Russia'),(1893,'Orenburgskaya Oblast\'','RU','Russia'),(1894,'Orlovskaya Oblast\'','RU','Russia'),(1895,'Penzenskaya Oblast\'','RU','Russia'),(1896,'Perm Krai','RU','Russia'),(1897,'Primorskiy Kray','RU','Russia'),(1898,'Pskovskaya Oblast\'','RU','Russia'),(1899,'Republic of Karelia','RU','Russia'),(1900,'Respublika Adygeya','RU','Russia'),(1901,'Respublika Buryatiya','RU','Russia'),(1902,'Respublika Ingushetiya','RU','Russia'),(1903,'Respublika Khakasiya','RU','Russia'),(1904,'Respublika Mariy-El','RU','Russia'),(1905,'Respublika Mordoviya','RU','Russia'),(1906,'Respublika Sakha (Yakutiya)','RU','Russia'),(1907,'Respublika Tyva','RU','Russia'),(1908,'Rostov Oblast','RU','Russia'),(1909,'Ryazanskaya Oblast\'','RU','Russia'),(1910,'Sakhalinskaya Oblast\'','RU','Russia'),(1911,'Samarskaya Oblast\'','RU','Russia'),(1912,'Saratovskaya Oblast\'','RU','Russia'),(1913,'Smolenskaya Oblast\'','RU','Russia'),(1914,'St.-Petersburg','RU','Russia'),(1915,'Stavropol\'skiy Kray','RU','Russia'),(1916,'Sverdlovskaya Oblast\'','RU','Russia'),(1917,'Tambovskaya Oblast\'','RU','Russia'),(1918,'Tatarstan','RU','Russia'),(1919,'Tomskaya Oblast\'','RU','Russia'),(1920,'Transbaikal Territory','RU','Russia'),(1921,'Tul\'skaya Oblast\'','RU','Russia'),(1922,'Tverskaya Oblast\'','RU','Russia'),(1923,'Tyumenskaya Oblast\'','RU','Russia'),(1924,'Udmurtskaya Respublika','RU','Russia'),(1925,'Ulyanovsk Oblast','RU','Russia'),(1926,'Vladimirskaya Oblast\'','RU','Russia'),(1927,'Volgogradskaya Oblast\'','RU','Russia'),(1928,'Vologodskaya Oblast\'','RU','Russia'),(1929,'Voronezhskaya Oblast\'','RU','Russia'),(1930,'Yamalo-Nenetskiy Avtonomnyy Okrug','RU','Russia'),(1931,'Yaroslavskaya Oblast\'','RU','Russia'),(1932,'Kigali','RW','Rwanda'),(1933,'\'Asir','SA','Saudi Arabia'),(1934,'Al Bahah','SA','Saudi Arabia'),(1935,'Al Madinah al Munawwarah','SA','Saudi Arabia'),(1936,'Al-Qassim','SA','Saudi Arabia'),(1937,'Ar Riyāḑ','SA','Saudi Arabia'),(1938,'Eastern Province','SA','Saudi Arabia'),(1939,'Hai\'l Region','SA','Saudi Arabia'),(1940,'Jizan','SA','Saudi Arabia'),(1941,'Makkah Province','SA','Saudi Arabia'),(1942,'Najran','SA','Saudi Arabia'),(1943,'Tabuk','SA','Saudi Arabia'),(1944,'Guadalcanal Province','SB','Solomon Islands'),(1945,'English River','SC','Seychelles'),(1946,'Takamaka','SC','Seychelles'),(1947,'Khartoum','SD','Sudan'),(1948,'Southern Kordofan','SD','Sudan'),(1949,'Blekinge','SE','Sweden'),(1950,'Dalarna','SE','Sweden'),(1951,'Gotland','SE','Sweden'),(1952,'Gävleborg','SE','Sweden'),(1953,'Halland','SE','Sweden'),(1954,'Jämtland','SE','Sweden'),(1955,'Jönköping','SE','Sweden'),(1956,'Kalmar','SE','Sweden'),(1957,'Kronoberg','SE','Sweden'),(1958,'Norrbotten','SE','Sweden'),(1959,'Skåne','SE','Sweden'),(1960,'Stockholm','SE','Sweden'),(1961,'Södermanland','SE','Sweden'),(1962,'Uppsala','SE','Sweden'),(1963,'Värmland','SE','Sweden'),(1964,'Västerbotten','SE','Sweden'),(1965,'Västernorrland','SE','Sweden'),(1966,'Västmanland','SE','Sweden'),(1967,'Västra Götaland','SE','Sweden'),(1968,'Örebro','SE','Sweden'),(1969,'Östergötland','SE','Sweden'),(1970,'Central Singapore Community Development Council','SG','Singapore'),(1971,'North East Community Development Region','SG','Singapore'),(1972,'North West Community Development Council','SG','Singapore'),(1973,'South West Community Development Council','SG','Singapore'),(1974,NULL,'SH','Saint Helena'),(1975,'Beltinci','SI','Slovenia'),(1976,'Bohinj','SI','Slovenia'),(1977,'Borovnica','SI','Slovenia'),(1978,'Brda','SI','Slovenia'),(1979,'Brezovica','SI','Slovenia'),(1980,'Cankova','SI','Slovenia'),(1981,'Celje','SI','Slovenia'),(1982,'Cerknica','SI','Slovenia'),(1983,'Cerkno','SI','Slovenia'),(1984,'Cerkvenjak','SI','Slovenia'),(1985,'Cirkulane','SI','Slovenia'),(1986,'Destrnik','SI','Slovenia'),(1987,'Dobrova-Polhov Gradec','SI','Slovenia'),(1988,'Dol pri Ljubljani','SI','Slovenia'),(1989,'Dolenjske Toplice','SI','Slovenia'),(1990,'Dravograd','SI','Slovenia'),(1991,'Duplek','SI','Slovenia'),(1992,'Gorenja Vas-Poljane','SI','Slovenia'),(1993,'Gornja Radgona','SI','Slovenia'),(1994,'Gornji Grad','SI','Slovenia'),(1995,'Gornji Petrovci','SI','Slovenia'),(1996,'Grosuplje','SI','Slovenia'),(1997,'Hajdina','SI','Slovenia'),(1998,'Horjul','SI','Slovenia'),(1999,'Hrastnik','SI','Slovenia'),(2000,'Hrpelje-Kozina','SI','Slovenia'),(2001,'Idrija','SI','Slovenia'),(2002,'Ig','SI','Slovenia'),(2003,'Ilirska Bistrica','SI','Slovenia'),(2004,'Izola','SI','Slovenia'),(2005,'Jesenice','SI','Slovenia'),(2006,'Kamnik','SI','Slovenia'),(2007,'Komen','SI','Slovenia'),(2008,'Koper','SI','Slovenia'),(2009,'Kostanjevica na Krki','SI','Slovenia'),(2010,'Kostel','SI','Slovenia'),(2011,'Kranj','SI','Slovenia'),(2012,'Kranjska Gora','SI','Slovenia'),(2013,'Kuzma','SI','Slovenia'),(2014,'Lenart','SI','Slovenia'),(2015,'Lendava','SI','Slovenia'),(2016,'Litija','SI','Slovenia'),(2017,'Ljubljana','SI','Slovenia'),(2018,'Ljubno','SI','Slovenia'),(2019,'Ljutomer','SI','Slovenia'),(2020,'Logatec','SI','Slovenia'),(2021,'Log–Dragomer','SI','Slovenia'),(2022,'Lovrenc na Pohorju','SI','Slovenia'),(2023,'Lukovica','SI','Slovenia'),(2024,'Makole','SI','Slovenia'),(2025,'Maribor','SI','Slovenia'),(2026,'Markovci','SI','Slovenia'),(2027,'Medvode','SI','Slovenia'),(2028,'Mestna Obcina Novo mesto','SI','Slovenia'),(2029,'Metlika','SI','Slovenia'),(2030,'Miren-Kostanjevica','SI','Slovenia'),(2031,'Mislinja','SI','Slovenia'),(2032,'Mokronog-Trebelno','SI','Slovenia'),(2033,'Mozirje','SI','Slovenia'),(2034,'Municipality of Cerklje na Gorenjskem','SI','Slovenia'),(2035,'Municipality of Dobrna','SI','Slovenia'),(2036,'Municipality of Šentjur','SI','Slovenia'),(2037,'Murska Sobota','SI','Slovenia'),(2038,'Naklo','SI','Slovenia'),(2039,'Nova Gorica','SI','Slovenia'),(2040,'Obcina Ajdovscina','SI','Slovenia'),(2041,'Obcina Apace','SI','Slovenia'),(2042,'Obcina Bled','SI','Slovenia'),(2043,'Obcina Brezice','SI','Slovenia'),(2044,'Obcina Crna na Koroskem','SI','Slovenia'),(2045,'Obcina Crnomelj','SI','Slovenia'),(2046,'Obcina Domzale','SI','Slovenia'),(2047,'Obcina Gorisnica','SI','Slovenia'),(2048,'Obcina Hoce-Slivnica','SI','Slovenia'),(2049,'Obcina Ivancna Gorica','SI','Slovenia'),(2050,'Obcina Jursinci','SI','Slovenia'),(2051,'Obcina Kidricevo','SI','Slovenia'),(2052,'Obcina Kobarid','SI','Slovenia'),(2053,'Obcina Kocevje','SI','Slovenia'),(2054,'Obcina Krsko','SI','Slovenia'),(2055,'Obcina Lasko','SI','Slovenia'),(2056,'Obcina Loska Dolina','SI','Slovenia'),(2057,'Obcina Majsperk','SI','Slovenia'),(2058,'Obcina Menges','SI','Slovenia'),(2059,'Obcina Mezica','SI','Slovenia'),(2060,'Obcina Miklavz na Dravskem Polju','SI','Slovenia'),(2061,'Obcina Moravce','SI','Slovenia'),(2062,'Obcina Ormoz','SI','Slovenia'),(2063,'Obcina Poljcane','SI','Slovenia'),(2064,'Obcina Race-Fram','SI','Slovenia'),(2065,'Obcina Radece','SI','Slovenia'),(2066,'Obcina Ravne na Koroskem','SI','Slovenia'),(2067,'Obcina Razkrizje','SI','Slovenia'),(2068,'Obcina Recica ob Savinji','SI','Slovenia'),(2069,'Obcina Rogaska Slatina','SI','Slovenia'),(2070,'Obcina Rogasovci','SI','Slovenia'),(2071,'Obcina Ruse','SI','Slovenia'),(2072,'Obcina Semic','SI','Slovenia'),(2073,'Obcina Sempeter-Vrtojba','SI','Slovenia'),(2074,'Obcina Sencur','SI','Slovenia'),(2075,'Obcina Sentilj','SI','Slovenia'),(2076,'Obcina Sentjernej','SI','Slovenia'),(2077,'Obcina Sezana','SI','Slovenia'),(2078,'Obcina Skofljica','SI','Slovenia'),(2079,'Obcina Smartno ob Paki','SI','Slovenia'),(2080,'Obcina Smartno pri Litiji','SI','Slovenia'),(2081,'Obcina Sostanj','SI','Slovenia'),(2082,'Obcina Store','SI','Slovenia'),(2083,'Obcina Straza','SI','Slovenia'),(2084,'Obcina Tisina','SI','Slovenia'),(2085,'Obcina Tolmin','SI','Slovenia'),(2086,'Obcina Trzic','SI','Slovenia'),(2087,'Obcina Velike Lasce','SI','Slovenia'),(2088,'Obcina Zalec','SI','Slovenia'),(2089,'Obcina Zelezniki','SI','Slovenia'),(2090,'Obcina Zirovnica','SI','Slovenia'),(2091,'Obcina Zrece','SI','Slovenia'),(2092,'Obcina Zuzemberk','SI','Slovenia'),(2093,'Odranci','SI','Slovenia'),(2094,'Osilnica','SI','Slovenia'),(2095,'Pesnica','SI','Slovenia'),(2096,'Piran','SI','Slovenia'),(2097,'Pivka','SI','Slovenia'),(2098,'Podlehnik','SI','Slovenia'),(2099,'Polzela','SI','Slovenia'),(2100,'Postojna','SI','Slovenia'),(2101,'Preddvor','SI','Slovenia'),(2102,'Prevalje','SI','Slovenia'),(2103,'Ptuj','SI','Slovenia'),(2104,'Puconci','SI','Slovenia'),(2105,'Radlje ob Dravi','SI','Slovenia'),(2106,'Radovljica','SI','Slovenia'),(2107,'Ribnica','SI','Slovenia'),(2108,'Selnica ob Dravi','SI','Slovenia'),(2109,'Sevnica','SI','Slovenia'),(2110,'Slovenj Gradec','SI','Slovenia'),(2111,'Slovenska Bistrica','SI','Slovenia'),(2112,'Slovenske Konjice','SI','Slovenia'),(2113,'Sveta Ana','SI','Slovenia'),(2114,'Tabor','SI','Slovenia'),(2115,'Trbovlje','SI','Slovenia'),(2116,'Trebnje','SI','Slovenia'),(2117,'Trzin','SI','Slovenia'),(2118,'Velenje','SI','Slovenia'),(2119,'Videm','SI','Slovenia'),(2120,'Vipava','SI','Slovenia'),(2121,'Vransko','SI','Slovenia'),(2122,'Zagorje ob Savi','SI','Slovenia'),(2123,'Škofja Loka','SI','Slovenia'),(2124,'Jan Mayen','SJ','Svalbard and Jan Mayen'),(2125,'Svalbard','SJ','Svalbard and Jan Mayen'),(2126,'Banskobystricky kraj','SK','Slovak Republic'),(2127,'Bratislavsky kraj','SK','Slovak Republic'),(2128,'Kosicky kraj','SK','Slovak Republic'),(2129,'Nitriansky kraj','SK','Slovak Republic'),(2130,'Presovsky kraj','SK','Slovak Republic'),(2131,'Trenciansky kraj','SK','Slovak Republic'),(2132,'Trnavsky kraj','SK','Slovak Republic'),(2133,'Zilinsky kraj','SK','Slovak Republic'),(2134,'Western Area','SL','Sierra Leone'),(2135,'Castello di Borgo Maggiore','SM','San Marino'),(2136,'Castello di Faetano','SM','San Marino'),(2137,'Castello di San Marino Citta','SM','San Marino'),(2138,'Serravalle','SM','San Marino'),(2139,'Dakar','SN','Senegal'),(2140,'Fatick','SN','Senegal'),(2141,'Kaolack','SN','Senegal'),(2142,'Kolda','SN','Senegal'),(2143,'Louga','SN','Senegal'),(2144,'Region de Kaffrine','SN','Senegal'),(2145,'Region de Kedougou','SN','Senegal'),(2146,'Region de Sedhiou','SN','Senegal'),(2147,'Saint-Louis','SN','Senegal'),(2148,'Tambacounda','SN','Senegal'),(2149,'Banaadir','SO','Somalia'),(2150,'Gedo','SO','Somalia'),(2151,'Woqooyi Galbeed','SO','Somalia'),(2152,'Distrikt Brokopondo','SR','Suriname'),(2153,'Distrikt Commewijne','SR','Suriname'),(2154,'Distrikt Coronie','SR','Suriname'),(2155,'Distrikt Marowijne','SR','Suriname'),(2156,'Distrikt Nickerie','SR','Suriname'),(2157,'Distrikt Para','SR','Suriname'),(2158,'Distrikt Paramaribo','SR','Suriname'),(2159,'Distrikt Saramacca','SR','Suriname'),(2160,'Distrikt Sipaliwini','SR','Suriname'),(2161,'Distrikt Wanica','SR','Suriname'),(2162,'Central Equatoria','SS','South Sudan'),(2163,'Principe','ST','São Tomé and Príncipe'),(2164,'São Tomé Island','ST','São Tomé and Príncipe'),(2165,'Departamento de Ahuachapan','SV','El Salvador'),(2166,'Departamento de Cabanas','SV','El Salvador'),(2167,'Departamento de Chalatenango','SV','El Salvador'),(2168,'Departamento de Cuscatlan','SV','El Salvador'),(2169,'Departamento de La Libertad','SV','El Salvador'),(2170,'Departamento de La Paz','SV','El Salvador'),(2171,'Departamento de La Union','SV','El Salvador'),(2172,'Departamento de Morazan','SV','El Salvador'),(2173,'Departamento de San Miguel','SV','El Salvador'),(2174,'Departamento de San Salvador','SV','El Salvador'),(2175,'Departamento de San Vicente','SV','El Salvador'),(2176,'Departamento de Santa Ana','SV','El Salvador'),(2177,'Departamento de Sonsonate','SV','El Salvador'),(2178,'Departamento de Usulutan','SV','El Salvador'),(2179,NULL,'SX','Sint Maarten'),(2180,'Aleppo Governorate','SY','Syria'),(2181,'As-Suwayda Governorate','SY','Syria'),(2182,'Damascus Governorate','SY','Syria'),(2183,'Hama Governorate','SY','Syria'),(2184,'Latakia Governorate','SY','Syria'),(2185,'Quneitra Governorate','SY','Syria'),(2186,'Hhohho District','SZ','Swaziland'),(2187,'Lubombo District','SZ','Swaziland'),(2188,'Manzini District','SZ','Swaziland'),(2189,NULL,'TC','Turks and Caicos Islands'),(2190,'Chari-Baguirmi Region','TD','Chad'),(2191,'Hadjer-Lamis','TD','Chad'),(2192,'Logone Occidental Region','TD','Chad'),(2193,'Ouadaï','TD','Chad'),(2194,NULL,'TF','French Southern Territories'),(2195,'Maritime','TG','Togo'),(2196,'Bangkok','TH','Thailand'),(2197,'Changwat Amnat Charoen','TH','Thailand'),(2198,'Changwat Ang Thong','TH','Thailand'),(2199,'Changwat Bueng Kan','TH','Thailand'),(2200,'Changwat Buriram','TH','Thailand'),(2201,'Changwat Chachoengsao','TH','Thailand'),(2202,'Changwat Chai Nat','TH','Thailand'),(2203,'Changwat Chaiyaphum','TH','Thailand'),(2204,'Changwat Chanthaburi','TH','Thailand'),(2205,'Changwat Chiang Rai','TH','Thailand'),(2206,'Changwat Chon Buri','TH','Thailand'),(2207,'Changwat Chumphon','TH','Thailand'),(2208,'Changwat Kalasin','TH','Thailand'),(2209,'Changwat Kamphaeng Phet','TH','Thailand'),(2210,'Changwat Kanchanaburi','TH','Thailand'),(2211,'Changwat Khon Kaen','TH','Thailand'),(2212,'Changwat Krabi','TH','Thailand'),(2213,'Changwat Lampang','TH','Thailand'),(2214,'Changwat Lamphun','TH','Thailand'),(2215,'Changwat Loei','TH','Thailand'),(2216,'Changwat Lop Buri','TH','Thailand'),(2217,'Changwat Mae Hong Son','TH','Thailand'),(2218,'Changwat Maha Sarakham','TH','Thailand'),(2219,'Changwat Mukdahan','TH','Thailand'),(2220,'Changwat Nakhon Nayok','TH','Thailand'),(2221,'Changwat Nakhon Pathom','TH','Thailand'),(2222,'Changwat Nakhon Phanom','TH','Thailand'),(2223,'Changwat Nakhon Ratchasima','TH','Thailand'),(2224,'Changwat Nakhon Sawan','TH','Thailand'),(2225,'Changwat Nakhon Si Thammarat','TH','Thailand'),(2226,'Changwat Nan','TH','Thailand'),(2227,'Changwat Narathiwat','TH','Thailand'),(2228,'Changwat Nong Bua Lamphu','TH','Thailand'),(2229,'Changwat Nong Khai','TH','Thailand'),(2230,'Changwat Nonthaburi','TH','Thailand'),(2231,'Changwat Pathum Thani','TH','Thailand'),(2232,'Changwat Pattani','TH','Thailand'),(2233,'Changwat Phangnga','TH','Thailand'),(2234,'Changwat Phatthalung','TH','Thailand'),(2235,'Changwat Phayao','TH','Thailand'),(2236,'Changwat Phetchabun','TH','Thailand'),(2237,'Changwat Phetchaburi','TH','Thailand'),(2238,'Changwat Phichit','TH','Thailand'),(2239,'Changwat Phitsanulok','TH','Thailand'),(2240,'Changwat Phra Nakhon Si Ayutthaya','TH','Thailand'),(2241,'Changwat Phrae','TH','Thailand'),(2242,'Changwat Prachin Buri','TH','Thailand'),(2243,'Changwat Prachuap Khiri Khan','TH','Thailand'),(2244,'Changwat Ranong','TH','Thailand'),(2245,'Changwat Ratchaburi','TH','Thailand'),(2246,'Changwat Rayong','TH','Thailand'),(2247,'Changwat Roi Et','TH','Thailand'),(2248,'Changwat Sa Kaeo','TH','Thailand'),(2249,'Changwat Sakon Nakhon','TH','Thailand'),(2250,'Changwat Samut Prakan','TH','Thailand'),(2251,'Changwat Samut Sakhon','TH','Thailand'),(2252,'Changwat Samut Songkhram','TH','Thailand'),(2253,'Changwat Sara Buri','TH','Thailand'),(2254,'Changwat Satun','TH','Thailand'),(2255,'Changwat Sing Buri','TH','Thailand'),(2256,'Changwat Sisaket','TH','Thailand'),(2257,'Changwat Songkhla','TH','Thailand'),(2258,'Changwat Sukhothai','TH','Thailand'),(2259,'Changwat Suphan Buri','TH','Thailand'),(2260,'Changwat Surat Thani','TH','Thailand'),(2261,'Changwat Surin','TH','Thailand'),(2262,'Changwat Tak','TH','Thailand'),(2263,'Changwat Trang','TH','Thailand'),(2264,'Changwat Trat','TH','Thailand'),(2265,'Changwat Ubon Ratchathani','TH','Thailand'),(2266,'Changwat Udon Thani','TH','Thailand'),(2267,'Changwat Uthai Thani','TH','Thailand'),(2268,'Changwat Uttaradit','TH','Thailand'),(2269,'Changwat Yala','TH','Thailand'),(2270,'Changwat Yasothon','TH','Thailand'),(2271,'Chiang Mai Province','TH','Thailand'),(2272,'Phuket','TH','Thailand'),(2273,'Gorno-Badakhshan','TJ','Tajikistan'),(2274,'Viloyati Sughd','TJ','Tajikistan'),(2275,'Nukunonu','TK','Tokelau'),(2276,'Dili','TL','East Timor'),(2277,'Ahal','TM','Turkmenistan'),(2278,'Gafsa','TN','Tunisia'),(2279,'Gouvernorat de Beja','TN','Tunisia'),(2280,'Gouvernorat de Ben Arous','TN','Tunisia'),(2281,'Gouvernorat de Bizerte','TN','Tunisia'),(2282,'Gouvernorat de Gabes','TN','Tunisia'),(2283,'Gouvernorat de Kairouan','TN','Tunisia'),(2284,'Gouvernorat de Kasserine','TN','Tunisia'),(2285,'Gouvernorat de Kef','TN','Tunisia'),(2286,'Gouvernorat de Mahdia','TN','Tunisia'),(2287,'Gouvernorat de Monastir','TN','Tunisia'),(2288,'Gouvernorat de Nabeul','TN','Tunisia'),(2289,'Gouvernorat de Sfax','TN','Tunisia'),(2290,'Gouvernorat de Sidi Bouzid','TN','Tunisia'),(2291,'Gouvernorat de Siliana','TN','Tunisia'),(2292,'Gouvernorat de Sousse','TN','Tunisia'),(2293,'Gouvernorat de Tozeur','TN','Tunisia'),(2294,'Gouvernorat de Tunis','TN','Tunisia'),(2295,'Gouvernorat de Zaghouan','TN','Tunisia'),(2296,'Gouvernorat de l\'Ariana','TN','Tunisia'),(2297,'Tataouine','TN','Tunisia'),(2298,'Vava\'u','TO','Tonga'),(2299,'Adana','TR','Turkey'),(2300,'Adiyaman','TR','Turkey'),(2301,'Afyonkarahisar','TR','Turkey'),(2302,'Aksaray','TR','Turkey'),(2303,'Amasya','TR','Turkey'),(2304,'Ankara','TR','Turkey'),(2305,'Antalya','TR','Turkey'),(2306,'Ardahan','TR','Turkey'),(2307,'Artvin','TR','Turkey'),(2308,'Aydın','TR','Turkey'),(2309,'Ağrı','TR','Turkey'),(2310,'Balıkesir','TR','Turkey'),(2311,'Bartın','TR','Turkey'),(2312,'Batman','TR','Turkey'),(2313,'Bayburt','TR','Turkey'),(2314,'Bilecik','TR','Turkey'),(2315,'Bingöl','TR','Turkey'),(2316,'Bitlis','TR','Turkey'),(2317,'Bolu','TR','Turkey'),(2318,'Burdur','TR','Turkey'),(2319,'Bursa','TR','Turkey'),(2320,'Denizli','TR','Turkey'),(2321,'Diyarbakir','TR','Turkey'),(2322,'Duezce','TR','Turkey'),(2323,'Edirne','TR','Turkey'),(2324,'Elazığ','TR','Turkey'),(2325,'Erzincan','TR','Turkey'),(2326,'Erzurum','TR','Turkey'),(2327,'Eskişehir','TR','Turkey'),(2328,'Gaziantep','TR','Turkey'),(2329,'Giresun','TR','Turkey'),(2330,'Guemueshane','TR','Turkey'),(2331,'Hakkâri','TR','Turkey'),(2332,'Hatay','TR','Turkey'),(2333,'Isparta','TR','Turkey'),(2334,'Istanbul','TR','Turkey'),(2335,'Izmir','TR','Turkey'),(2336,'Iğdır','TR','Turkey'),(2337,'Kahramanmaraş','TR','Turkey'),(2338,'Karabuek','TR','Turkey'),(2339,'Karaman','TR','Turkey'),(2340,'Kars','TR','Turkey'),(2341,'Kastamonu','TR','Turkey'),(2342,'Kayseri','TR','Turkey'),(2343,'Kilis','TR','Turkey'),(2344,'Kocaeli','TR','Turkey'),(2345,'Konya','TR','Turkey'),(2346,'Kütahya','TR','Turkey'),(2347,'Kırklareli','TR','Turkey'),(2348,'Kırıkkale','TR','Turkey'),(2349,'Kırşehir','TR','Turkey'),(2350,'Malatya','TR','Turkey'),(2351,'Manisa','TR','Turkey'),(2352,'Mardin','TR','Turkey'),(2353,'Mersin','TR','Turkey'),(2354,'Muğla','TR','Turkey'),(2355,'Muş','TR','Turkey'),(2356,'Nevsehir','TR','Turkey'),(2357,'Nigde','TR','Turkey'),(2358,'Ordu','TR','Turkey'),(2359,'Osmaniye','TR','Turkey'),(2360,'Rize','TR','Turkey'),(2361,'Sakarya','TR','Turkey'),(2362,'Samsun','TR','Turkey'),(2363,'Siirt','TR','Turkey'),(2364,'Sinop','TR','Turkey'),(2365,'Sivas','TR','Turkey'),(2366,'Tekirdağ','TR','Turkey'),(2367,'Tokat','TR','Turkey'),(2368,'Trabzon','TR','Turkey'),(2369,'Tunceli','TR','Turkey'),(2370,'Uşak','TR','Turkey'),(2371,'Van','TR','Turkey'),(2372,'Yalova','TR','Turkey'),(2373,'Yozgat','TR','Turkey'),(2374,'Zonguldak','TR','Turkey'),(2375,'Çanakkale','TR','Turkey'),(2376,'Çankırı','TR','Turkey'),(2377,'Çorum','TR','Turkey'),(2378,'Şanlıurfa','TR','Turkey'),(2379,'Şırnak','TR','Turkey'),(2380,'Borough of Arima','TT','Trinidad and Tobago'),(2381,'Chaguanas','TT','Trinidad and Tobago'),(2382,'City of Port of Spain','TT','Trinidad and Tobago'),(2383,'City of San Fernando','TT','Trinidad and Tobago'),(2384,'Couva-Tabaquite-Talparo','TT','Trinidad and Tobago'),(2385,'Diego Martin','TT','Trinidad and Tobago'),(2386,'Eastern Tobago','TT','Trinidad and Tobago'),(2387,'Mayaro','TT','Trinidad and Tobago'),(2388,'Penal/Debe','TT','Trinidad and Tobago'),(2389,'Point Fortin','TT','Trinidad and Tobago'),(2390,'Princes Town','TT','Trinidad and Tobago'),(2391,'San Juan/Laventille','TT','Trinidad and Tobago'),(2392,'Sangre Grande','TT','Trinidad and Tobago'),(2393,'Siparia','TT','Trinidad and Tobago'),(2394,'Tobago','TT','Trinidad and Tobago'),(2395,'Tunapuna/Piarco','TT','Trinidad and Tobago'),(2396,'Funafuti','TV','Tuvalu'),(2397,'Vaitupu','TV','Tuvalu'),(2398,'Changhua','TW','Taiwan'),(2399,'Chiayi','TW','Taiwan'),(2400,'Hsinchu','TW','Taiwan'),(2401,'Hsinchu County','TW','Taiwan'),(2402,'Hualien','TW','Taiwan'),(2403,'Kaohsiung','TW','Taiwan'),(2404,'Keelung','TW','Taiwan'),(2405,'Miaoli','TW','Taiwan'),(2406,'Nantou','TW','Taiwan'),(2407,'New Taipei','TW','Taiwan'),(2408,'Pingtung','TW','Taiwan'),(2409,'Taichung City','TW','Taiwan'),(2410,'Tainan','TW','Taiwan'),(2411,'Taitung','TW','Taiwan'),(2412,'Taoyuan','TW','Taiwan'),(2413,'Yilan','TW','Taiwan'),(2414,'Yunlin County','TW','Taiwan'),(2415,'Arusha','TZ','Tanzania'),(2416,'Dar es Salaam Region','TZ','Tanzania'),(2417,'Dodoma','TZ','Tanzania'),(2418,'Iringa','TZ','Tanzania'),(2419,'Kagera','TZ','Tanzania'),(2420,'Kigoma','TZ','Tanzania'),(2421,'Kilimanjaro','TZ','Tanzania'),(2422,'Lindi','TZ','Tanzania'),(2423,'Manyara','TZ','Tanzania'),(2424,'Mara','TZ','Tanzania'),(2425,'Mbeya','TZ','Tanzania'),(2426,'Morogoro','TZ','Tanzania'),(2427,'Mtwara','TZ','Tanzania'),(2428,'Mwanza','TZ','Tanzania'),(2429,'Pemba North','TZ','Tanzania'),(2430,'Pemba South','TZ','Tanzania'),(2431,'Pwani','TZ','Tanzania'),(2432,'Rukwa','TZ','Tanzania'),(2433,'Ruvuma','TZ','Tanzania'),(2434,'Shinyanga','TZ','Tanzania'),(2435,'Singida','TZ','Tanzania'),(2436,'Tabora','TZ','Tanzania'),(2437,'Tanga','TZ','Tanzania'),(2438,'Zanzibar Central/South','TZ','Tanzania'),(2439,'Zanzibar North','TZ','Tanzania'),(2440,'Zanzibar Urban/West','TZ','Tanzania'),(2441,'Cherkas\'ka Oblast\'','UA','Ukraine'),(2442,'Chernihiv','UA','Ukraine'),(2443,'Chernivtsi','UA','Ukraine'),(2444,'Dnipropetrovska Oblast\'','UA','Ukraine'),(2445,'Donets\'ka Oblast\'','UA','Ukraine'),(2446,'Gorod Sevastopol','UA','Ukraine'),(2447,'Ivano-Frankivs\'ka Oblast\'','UA','Ukraine'),(2448,'Kharkivs\'ka Oblast\'','UA','Ukraine'),(2449,'Khersons\'ka Oblast\'','UA','Ukraine'),(2450,'Khmel\'nyts\'ka Oblast\'','UA','Ukraine'),(2451,'Kirovohrads\'ka Oblast\'','UA','Ukraine'),(2452,'Kyiv City','UA','Ukraine'),(2453,'Kyiv Oblast','UA','Ukraine'),(2454,'L\'vivs\'ka Oblast\'','UA','Ukraine'),(2455,'Luhans\'ka Oblast\'','UA','Ukraine'),(2456,'Mykolayivs\'ka Oblast\'','UA','Ukraine'),(2457,'Odessa','UA','Ukraine'),(2458,'Poltavs\'ka Oblast\'','UA','Ukraine'),(2459,'Republic of Crimea','UA','Ukraine'),(2460,'Rivnens\'ka Oblast\'','UA','Ukraine'),(2461,'Sums\'ka Oblast\'','UA','Ukraine'),(2462,'Ternopil\'s\'ka Oblast\'','UA','Ukraine'),(2463,'Vinnyts\'ka Oblast\'','UA','Ukraine'),(2464,'Volyns\'ka Oblast\'','UA','Ukraine'),(2465,'Zakarpattia Oblast','UA','Ukraine'),(2466,'Zaporizhia','UA','Ukraine'),(2467,'Zhytomyrs\'ka Oblast\'','UA','Ukraine'),(2468,'Central Region','UG','Uganda'),(2469,NULL,'UM','U.S. Minor Outlying Islands'),(2470,'Alabama','US','United States'),(2471,'Alaska','US','United States'),(2472,'Arizona','US','United States'),(2473,'Arkansas','US','United States'),(2474,'California','US','United States'),(2475,'Colorado','US','United States'),(2476,'Connecticut','US','United States'),(2477,'Delaware','US','United States'),(2478,'District of Columbia','US','United States'),(2479,'Florida','US','United States'),(2480,'Georgia','US','United States'),(2481,'Hawaii','US','United States'),(2482,'Idaho','US','United States'),(2483,'Illinois','US','United States'),(2484,'Indiana','US','United States'),(2485,'Iowa','US','United States'),(2486,'Kansas','US','United States'),(2487,'Kentucky','US','United States'),(2488,'Louisiana','US','United States'),(2489,'Maine','US','United States'),(2490,'Maryland','US','United States'),(2491,'Massachusetts','US','United States'),(2492,'Michigan','US','United States'),(2493,'Minnesota','US','United States'),(2494,'Mississippi','US','United States'),(2495,'Missouri','US','United States'),(2496,'Montana','US','United States'),(2497,'Nebraska','US','United States'),(2498,'Nevada','US','United States'),(2499,'New Hampshire','US','United States'),(2500,'New Jersey','US','United States'),(2501,'New Mexico','US','United States'),(2502,'New York','US','United States'),(2503,'North Carolina','US','United States'),(2504,'North Dakota','US','United States'),(2505,'Ohio','US','United States'),(2506,'Oklahoma','US','United States'),(2507,'Oregon','US','United States'),(2508,'Pennsylvania','US','United States'),(2509,'Rhode Island','US','United States'),(2510,'South Carolina','US','United States'),(2511,'South Dakota','US','United States'),(2512,'Tennessee','US','United States'),(2513,'Texas','US','United States'),(2514,'Utah','US','United States'),(2515,'Vermont','US','United States'),(2516,'Virginia','US','United States'),(2517,'Washington','US','United States'),(2518,'West Virginia','US','United States'),(2519,'Wisconsin','US','United States'),(2520,'Wyoming','US','United States'),(2521,'Artigas','UY','Uruguay'),(2522,'Canelones','UY','Uruguay'),(2523,'Cerro Largo','UY','Uruguay'),(2524,'Colonia','UY','Uruguay'),(2525,'Departamento de Montevideo','UY','Uruguay'),(2526,'Departamento de Paysandu','UY','Uruguay'),(2527,'Departamento de Rio Negro','UY','Uruguay'),(2528,'Departamento de Rivera','UY','Uruguay'),(2529,'Departamento de San Jose','UY','Uruguay'),(2530,'Departamento de Tacuarembo','UY','Uruguay'),(2531,'Florida','UY','Uruguay'),(2532,'Lavalleja','UY','Uruguay'),(2533,'Maldonado','UY','Uruguay'),(2534,'Soriano','UY','Uruguay'),(2535,'Qashqadaryo','UZ','Uzbekistan'),(2536,'Samarqand Viloyati','UZ','Uzbekistan'),(2537,'Toshkent Shahri','UZ','Uzbekistan'),(2538,NULL,'VA','Vatican City'),(2539,'Grenadines','VC','Saint Vincent and the Grenadines'),(2540,'Parish of Charlotte','VC','Saint Vincent and the Grenadines'),(2541,'Parish of Saint George','VC','Saint Vincent and the Grenadines'),(2542,'Amazonas','VE','Venezuela'),(2543,'Anzoátegui','VE','Venezuela'),(2544,'Apure','VE','Venezuela'),(2545,'Aragua','VE','Venezuela'),(2546,'Barinas','VE','Venezuela'),(2547,'Bolívar','VE','Venezuela'),(2548,'Capital','VE','Venezuela'),(2549,'Carabobo','VE','Venezuela'),(2550,'Cojedes','VE','Venezuela'),(2551,'Delta Amacuro','VE','Venezuela'),(2552,'Dependencias Federales','VE','Venezuela'),(2553,'Estado Trujillo','VE','Venezuela'),(2554,'Falcón','VE','Venezuela'),(2555,'Guárico','VE','Venezuela'),(2556,'Lara','VE','Venezuela'),(2557,'Miranda','VE','Venezuela'),(2558,'Monagas','VE','Venezuela'),(2559,'Mérida','VE','Venezuela'),(2560,'Nueva Esparta','VE','Venezuela'),(2561,'Portuguesa','VE','Venezuela'),(2562,'Sucre','VE','Venezuela'),(2563,'Táchira','VE','Venezuela'),(2564,'Vargas','VE','Venezuela'),(2565,'Yaracuy','VE','Venezuela'),(2566,'Zulia','VE','Venezuela'),(2567,NULL,'VG','British Virgin Islands'),(2568,'Saint Croix Island','VI','U.S. Virgin Islands'),(2569,'Saint John Island','VI','U.S. Virgin Islands'),(2570,'Saint Thomas Island','VI','U.S. Virgin Islands'),(2571,'An Giang','VN','Vietnam'),(2572,'Dak Nong','VN','Vietnam'),(2573,'Gia Lai','VN','Vietnam'),(2574,'Hau Giang','VN','Vietnam'),(2575,'Ho Chi Minh City','VN','Vietnam'),(2576,'Kon Tum','VN','Vietnam'),(2577,'Long An','VN','Vietnam'),(2578,'Thanh Pho Can Tho','VN','Vietnam'),(2579,'Thanh Pho GJa Nang','VN','Vietnam'),(2580,'Thanh Pho Ha Noi','VN','Vietnam'),(2581,'Thanh Pho Hai Phong','VN','Vietnam'),(2582,'Tinh Ba Ria-Vung Tau','VN','Vietnam'),(2583,'Tinh Bac Giang','VN','Vietnam'),(2584,'Tinh Bac Lieu','VN','Vietnam'),(2585,'Tinh Bac Ninh','VN','Vietnam'),(2586,'Tinh Ben Tre','VN','Vietnam'),(2587,'Tinh Binh Duong','VN','Vietnam'),(2588,'Tinh Binh GJinh','VN','Vietnam'),(2589,'Tinh Binh Thuan','VN','Vietnam'),(2590,'Tinh Ca Mau','VN','Vietnam'),(2591,'Tinh Cao Bang','VN','Vietnam'),(2592,'Tinh Dien Bien','VN','Vietnam'),(2593,'Tinh GJak Lak','VN','Vietnam'),(2594,'Tinh GJong Nai','VN','Vietnam'),(2595,'Tinh GJong Thap','VN','Vietnam'),(2596,'Tinh Ha Giang','VN','Vietnam'),(2597,'Tinh Ha Nam','VN','Vietnam'),(2598,'Tinh Ha Tinh','VN','Vietnam'),(2599,'Tinh Hai Duong','VN','Vietnam'),(2600,'Tinh Hoa Binh','VN','Vietnam'),(2601,'Tinh Hung Yen','VN','Vietnam'),(2602,'Tinh Khanh Hoa','VN','Vietnam'),(2603,'Tinh Kien Giang','VN','Vietnam'),(2604,'Tinh Lai Chau','VN','Vietnam'),(2605,'Tinh Lam GJong','VN','Vietnam'),(2606,'Tinh Lang Son','VN','Vietnam'),(2607,'Tinh Lao Cai','VN','Vietnam'),(2608,'Tinh Nam GJinh','VN','Vietnam'),(2609,'Tinh Nghe An','VN','Vietnam'),(2610,'Tinh Ninh Binh','VN','Vietnam'),(2611,'Tinh Phu Tho','VN','Vietnam'),(2612,'Tinh Phu Yen','VN','Vietnam'),(2613,'Tinh Quang Binh','VN','Vietnam'),(2614,'Tinh Quang Nam','VN','Vietnam'),(2615,'Tinh Quang Ngai','VN','Vietnam'),(2616,'Tinh Quang Tri','VN','Vietnam'),(2617,'Tinh Soc Trang','VN','Vietnam'),(2618,'Tinh Son La','VN','Vietnam'),(2619,'Tinh Tay Ninh','VN','Vietnam'),(2620,'Tinh Thai Binh','VN','Vietnam'),(2621,'Tinh Thai Nguyen','VN','Vietnam'),(2622,'Tinh Thanh Hoa','VN','Vietnam'),(2623,'Tinh Thua Thien-Hue','VN','Vietnam'),(2624,'Tinh Tien Giang','VN','Vietnam'),(2625,'Tinh Tra Vinh','VN','Vietnam'),(2626,'Tinh Tuyen Quang','VN','Vietnam'),(2627,'Tinh Vinh Long','VN','Vietnam'),(2628,'Tinh Vinh Phuc','VN','Vietnam'),(2629,'Tinh Yen Bai','VN','Vietnam'),(2630,'Penama Province','VU','Vanuatu'),(2631,'Shefa Province','VU','Vanuatu'),(2632,NULL,'WF','Wallis and Futuna'),(2633,'Atua','WS','Samoa'),(2634,'Tuamasaga','WS','Samoa'),(2635,NULL,'XK','Kosovo'),(2636,'Aden','YE','Yemen'),(2637,'Dhamār','YE','Yemen'),(2638,'Muhafazat Hadramawt','YE','Yemen'),(2639,'Muhafazat al Hudaydah','YE','Yemen'),(2640,'Sanaa','YE','Yemen'),(2641,NULL,'YT','Mayotte'),(2642,'Eastern Cape','ZA','South Africa'),(2643,'Gauteng','ZA','South Africa'),(2644,'KwaZulu-Natal','ZA','South Africa'),(2645,'Limpopo','ZA','South Africa'),(2646,'Mpumalanga','ZA','South Africa'),(2647,'Province of North West','ZA','South Africa'),(2648,'Northern Cape','ZA','South Africa'),(2649,'Orange Free State','ZA','South Africa'),(2650,'Province of the Western Cape','ZA','South Africa'),(2651,'Copperbelt','ZM','Zambia'),(2652,'Luapula Province','ZM','Zambia'),(2653,'Lusaka Province','ZM','Zambia'),(2654,'Muchinga Province','ZM','Zambia'),(2655,'North-Western Province','ZM','Zambia'),(2656,'Northern Province','ZM','Zambia'),(2657,'Southern Province','ZM','Zambia'),(2658,'Western Province','ZM','Zambia'),(2659,'Bulawayo','ZW','Zimbabwe'),(2660,'Harare','ZW','Zimbabwe'),(2661,'Mashonaland West','ZW','Zimbabwe'),(2662,'Matabeleland North','ZW','Zimbabwe'),(2663,'Matabeleland South Province','ZW','Zimbabwe'),(2664,'Midlands Province','ZW','Zimbabwe');

--
-- Table structure for table `media_content_asset`
--

CREATE TABLE `media_content_asset` (
  `asset_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `entity_type` varchar(255) NOT NULL COMMENT 'Content type',
  `entity_id` varchar(255) NOT NULL COMMENT 'Content entity id',
  `field` varchar(255) NOT NULL COMMENT 'Content field',
  PRIMARY KEY (`entity_type`,`entity_id`,`field`,`asset_id`),
  KEY `MEDIA_CONTENT_ASSET_ASSET_ID` (`asset_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Relation between media content and media asset';

--
-- Dumping data for table `media_content_asset`
--

INSERT INTO `media_content_asset` VALUES (10,'cms_block','4','content'),(12,'cms_block','5','content'),(12,'cms_block','56','content'),(14,'cms_block','57','content'),(14,'cms_block','7','content'),(16,'cms_block','8','content'),(17,'cms_block','8','content'),(18,'cms_block','8','content'),(19,'cms_block','8','content'),(20,'cms_block','8','content'),(21,'cms_block','8','content'),(22,'cms_block','8','content'),(23,'cms_block','8','content'),(25,'cms_block','8','content'),(26,'cms_block','31','content'),(26,'cms_block','9','content'),(29,'cms_block','13','content'),(30,'cms_block','13','content'),(36,'cms_page','11','content'),(36,'cms_page','21','content'),(37,'cms_page','11','content'),(37,'cms_page','21','content'),(38,'cms_page','11','content'),(38,'cms_page','21','content'),(39,'cms_page','11','content'),(39,'cms_page','21','content'),(40,'cms_page','11','content'),(40,'cms_page','21','content'),(41,'cms_page','11','content'),(41,'cms_page','21','content'),(42,'cms_page','11','content'),(42,'cms_page','21','content'),(43,'cms_page','11','content'),(43,'cms_page','21','content'),(44,'cms_page','11','content'),(44,'cms_page','21','content'),(45,'cms_page','11','content'),(45,'cms_page','21','content'),(46,'cms_page','11','content'),(46,'cms_page','21','content'),(47,'cms_page','11','content'),(47,'cms_page','21','content'),(48,'cms_block','4','content'),(49,'cms_block','4','content'),(50,'cms_block','4','content'),(51,'cms_block','4','content'),(52,'cms_block','4','content'),(53,'cms_block','4','content'),(65,'cms_block','31','content'),(65,'cms_block','8','content'),(65,'cms_block','9','content'),(97,'cms_page','13','content'),(98,'cms_page','13','content'),(99,'cms_block','32','content'),(100,'cms_block','32','content'),(102,'cms_page','13','content'),(103,'cms_block','34','content'),(103,'cms_page','13','content'),(104,'cms_page','13','content'),(105,'cms_page','13','content'),(106,'cms_page','13','content'),(107,'cms_page','13','content'),(108,'cms_page','13','content'),(110,'cms_block','49','content'),(112,'cms_block','40','content'),(112,'cms_block','42','content'),(113,'cms_block','40','content'),(113,'cms_block','42','content'),(113,'cms_block','49','content'),(113,'cms_block','54','content'),(114,'cms_block','40','content'),(114,'cms_block','42','content'),(114,'cms_block','49','content'),(114,'cms_block','54','content'),(115,'cms_block','40','content'),(119,'cms_block','53','content'),(120,'cms_block','54','content'),(122,'cms_block','53','content'),(123,'cms_block','53','content');

--
-- Table structure for table `media_gallery_asset`
--

CREATE TABLE `media_gallery_asset` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `path` text COMMENT 'Path',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `description` text COMMENT 'Description',
  `source` varchar(255) DEFAULT NULL COMMENT 'Source',
  `hash` varchar(255) DEFAULT NULL COMMENT 'File hash',
  `content_type` varchar(255) DEFAULT NULL COMMENT 'Content Type',
  `width` int unsigned NOT NULL DEFAULT '0' COMMENT 'Width',
  `height` int unsigned NOT NULL DEFAULT '0' COMMENT 'Height',
  `size` int unsigned NOT NULL COMMENT 'Asset file size in bytes',
  `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',
  PRIMARY KEY (`id`),
  KEY `MEDIA_GALLERY_ASSET_ID` (`id`),
  FULLTEXT KEY `MEDIA_GALLERY_ASSET_TITLE` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=124 DEFAULT CHARSET=utf8mb3 COMMENT='Media Gallery Asset';

--
-- Dumping data for table `media_gallery_asset`
--

INSERT INTO `media_gallery_asset` VALUES (1,'wysiwyg/Icon.png','Icon',NULL,'Local','0c865a25115c4d30e493475f048240dea10f826a','image/png',203,38,3681,'2024-08-11 14:07:11','2024-08-11 14:07:11'),(2,'wysiwyg/XMLID_7_.png','XMLID_7_',NULL,'Local','f8dd8c7bee837d4a00bfef3590d8400b460f728a','image/png',38,33,1097,'2024-08-11 14:08:53','2024-08-11 14:08:53'),(5,'wysiwyg/pexels-binyamin-mellish-106399.jpg','pexels-binyamin-mellish-106399',NULL,'Local','d7fb76ed3a6d4ff5b2b0a615452e4a7d2d4fa321','image/jpg',1280,853,135901,'2024-08-19 11:27:35','2024-08-19 11:27:35'),(6,'wysiwyg/pexels-binyamin-mellish-106399_1.jpg','pexels-binyamin-mellish-106399_1',NULL,'Local','ef97f9397778846a5e43b5bcda76021a1ff5ec54','image/jpg',200,133,6345,'2024-08-19 11:30:17','2024-08-19 11:30:17'),(8,'wysiwyg/slider1.jpeg','slider1',NULL,'Local','c0f750496f6c15d490a54ef421b35ced0d68f85e','image/jpeg',2440,746,141621,'2024-08-19 15:42:01','2024-08-19 15:42:01'),(9,'wysiwyg/slider1-mobile.jpeg','slider1-mobile',NULL,'Local','90eefa574d8afd20211c25a5652fe89601a32b57','image/jpeg',1639,2460,249758,'2024-08-19 15:42:02','2024-08-19 15:42:02'),(10,'wysiwyg/bath.jpeg','bath',NULL,'Local','c62d816e80dd166a6adb462cc72128e6d0cf01ec','image/jpeg',4096,4096,779401,'2024-08-20 06:04:40','2024-08-20 06:04:40'),(11,'wysiwyg/kitchen1.png','kitchen1',NULL,'Local','684ac9c14179bd2a2ef89395b256c5b0f4c5ee2d','image/png',1080,1080,237082,'2024-08-20 06:15:41','2024-08-20 06:15:41'),(12,'wysiwyg/decor.png','decor',NULL,'Local','8622c2bd4bc1fd6320f49a249107453e6ee4637c','image/png',1080,1920,846055,'2024-08-20 06:15:42','2024-08-20 06:15:42'),(13,'wysiwyg/Star-ratings.png','Star-ratings',NULL,'Local','9029dd2100e35272eff58e965ec835c817b517d8','image/png',87,13,921,'2024-08-20 06:21:13','2024-08-20 06:21:13'),(14,'wysiwyg/comfort.png','comfort',NULL,'Local','19daf9ffbdf7640c12591a3e7cd240238d148203','image/png',1080,1920,223616,'2024-08-20 06:41:06','2024-08-20 06:41:06'),(15,'wysiwyg/bathroom.png','bathroom',NULL,'Local','b8d86eb2df3fc8cd1627dfae2d76abd638a04d58','image/png',1000,765,148191,'2024-08-20 06:41:07','2024-08-20 06:41:07'),(16,'wysiwyg/2.png','2',NULL,'Local','6d4125036f0c1693a2ca175c6b2f856ad67e9195','image/png',1100,737,229469,'2024-08-20 07:06:51','2024-08-20 07:06:51'),(17,'wysiwyg/4.png','4',NULL,'Local','41a007d725805ab256d337ed7f7d404fbf3f1c01','image/png',1192,507,140829,'2024-08-20 07:06:53','2024-08-20 07:06:53'),(18,'wysiwyg/3.png','3',NULL,'Local','71dbd43c4b1612d21c78c92fc76891ec8136442a','image/png',1200,1200,374402,'2024-08-20 07:06:53','2024-08-20 07:06:53'),(19,'wysiwyg/1.png','1',NULL,'Local','12fb0e95e75d345e5b55de41dc54dc99e0be81f9','image/png',2000,2000,676230,'2024-08-20 07:06:58','2024-08-20 07:06:58'),(20,'wysiwyg/5.png','5',NULL,'Local','c017487c6b55f8d085cec71614ab58a30cd06d59','image/png',1920,1080,311890,'2024-08-20 07:07:00','2024-08-20 07:07:00'),(21,'wysiwyg/crosswater.png','crosswater',NULL,'Local','63b8c6cc88dad6da5c1b6df6675a71f2029eef21','image/png',108,51,3941,'2024-08-20 07:12:08','2024-08-20 07:12:08'),(22,'wysiwyg/duravit.png','duravit',NULL,'Local','a0fee8154b896ae9bd4306a2c70a001f45b648fa','image/png',108,51,5747,'2024-08-20 07:12:08','2024-08-20 07:12:08'),(23,'wysiwyg/geberit.png','geberit',NULL,'Local','f9eac635080b0a4ab0660bb6a71492e0e6822cf4','image/png',108,51,3950,'2024-08-20 07:12:08','2024-08-20 07:12:08'),(24,'wysiwyg/joseph.png','joseph',NULL,'Local','2499aec5480eb052b819294958fd70b117b1610b','image/png',107,51,3604,'2024-08-20 07:12:08','2024-08-20 07:12:08'),(25,'wysiwyg/rak.png','rak',NULL,'Local','c815116c74adff12d6192ad3452d5e8c0b55ad3c','image/png',108,51,4114,'2024-08-20 07:12:08','2024-08-20 07:12:08'),(26,'wysiwyg/small.jpeg','small',NULL,'Local','e26c1c9b2651cb1c0b407fed4756e8acf3a982eb','image/jpeg',4096,2731,239824,'2024-08-20 07:29:04','2024-08-20 07:29:04'),(27,'wysiwyg/delivery_icon_1.png','delivery_icon_1',NULL,'Local','1e37d71e0885c8b58f98e58f19c91d7079b4d34f','image/png',73,50,1718,'2024-08-20 08:14:04','2024-08-20 08:14:04'),(28,'wysiwyg/trust_icon_1.png','trust_icon_1',NULL,'Local','4a9b3387431cd80dbbe39ec20ca84ec92c2c45a3','image/png',148,58,2549,'2024-08-20 08:14:43','2024-08-20 08:14:43'),(29,'wysiwyg/quote-large.png','quote-large',NULL,'Local','42831363953b2798b2366b460a59a73274e0d953','image/png',40,26,766,'2024-08-20 08:27:06','2024-08-20 08:27:06'),(30,'wysiwyg/full-rating.png','full-rating',NULL,'Local','975cf9a3f1177942e929cbd700b56f3aeb38e3c9','image/png',124,21,592,'2024-08-20 08:30:06','2024-08-20 08:30:06'),(31,'catalog/category/bath.jpeg','bath',NULL,'Local','c62d816e80dd166a6adb462cc72128e6d0cf01ec','image/jpeg',4096,4096,779401,'2024-08-20 11:19:10','2024-08-20 11:19:10'),(32,'wysiwyg/Banner-01.jpg','Banner-01',NULL,'Local','e142948e898e30cc99f0e79ea6e6e0829687cf17','image/jpg',1441,441,90832,'2024-08-21 11:11:04','2024-08-21 11:11:04'),(33,'wysiwyg/Banner-02.jpg','Banner-02',NULL,'Local','8ce3f3054c6c2de443d5bfd59b920efaae8bc93d','image/jpg',1441,441,71644,'2024-08-21 11:11:08','2024-08-21 11:11:08'),(34,'wysiwyg/Web-03.jpg','Web-03',NULL,'Local','fc1f37745b57ef99d8e3fc90c03aa7dbb15652f9','image/jpg',814,526,70523,'2024-08-21 11:38:45','2024-08-21 11:38:45'),(35,'wysiwyg/Web-04.jpg','Web-04',NULL,'Local','c651c4cf58f07df3655efed6c9bbe46ab468b026','image/jpg',814,526,58145,'2024-08-21 11:38:46','2024-08-21 11:38:46'),(36,'wysiwyg/Group_27164.png','Group_27164',NULL,'Local','29cd03abe4d1348f2e5acd0777a8dbc2eeeff8a3','image/png',51,64,2316,'2024-08-21 11:49:30','2024-08-21 11:49:30'),(37,'wysiwyg/Group_27144.png','Group_27144',NULL,'Local','b45eea4a2effc628135ca62e72bfec9c6d9a9ca5','image/png',50,64,2823,'2024-08-21 11:49:30','2024-08-21 11:49:30'),(38,'wysiwyg/Group_27167.png','Group_27167',NULL,'Local','c032a81cb226151781f2b0bb886e76b210071638','image/png',69,62,2292,'2024-08-21 11:49:31','2024-08-21 11:49:31'),(39,'wysiwyg/Group_27298.png','Group_27298',NULL,'Local','a50978349a538c6ecd27b5fcfee754a22381ae79','image/png',64,64,2273,'2024-08-21 11:49:31','2024-08-21 11:49:31'),(40,'wysiwyg/Group_27299.png','Group_27299',NULL,'Local','4ba67fd21ff9884ea7552aff8ce65e433140de8d','image/png',59,64,2693,'2024-08-21 11:49:31','2024-08-21 11:49:31'),(41,'wysiwyg/Group.png','Group',NULL,'Local','900e61db5d7df48404d10da96ba7b7a375aedd4d','image/png',86,55,1677,'2024-08-21 11:49:31','2024-08-21 11:49:31'),(42,'wysiwyg/Mask_group_1_.png','Mask_group_1_',NULL,'Local','ac53d11f3afcca20180612d34f019c115fb34b97','image/png',382,251,124421,'2024-08-21 11:49:32','2024-08-21 11:49:32'),(43,'wysiwyg/Mask_group_3_.png','Mask_group_3_',NULL,'Local','e2f893c52600a502d8e001aec8df63e073a61fd9','image/png',382,251,158842,'2024-08-21 11:49:32','2024-08-21 11:49:32'),(44,'wysiwyg/Mask_group.png','Mask_group',NULL,'Local','ddbd7331445ace6971bcb5f962ae3af23533dc55','image/png',288,413,177515,'2024-08-21 11:49:32','2024-08-21 11:49:32'),(45,'wysiwyg/view-small-bathroom-with-modern-style-decor-furniture_1.png','view-small-bathroom-with-modern-style-decor-furniture_1',NULL,'Local','4f079b00d0432c1c5b24b234cb8f715f0e8ae504','image/png',288,413,178636,'2024-08-21 11:49:34','2024-08-21 11:49:34'),(46,'wysiwyg/luxurious-modern-living-room-with-sleek-minimalist-design-elegant-fireplace_1.png','luxurious-modern-living-room-with-sleek-minimalist-design-elegant-fireplace_1',NULL,'Local','f3476615787a4a6bdf726693400d4e732e7ff254','image/png',1440,441,1200564,'2024-08-21 11:49:35','2024-08-21 11:49:35'),(47,'wysiwyg/Mask_group_2_.png','Mask_group_2_',NULL,'Local','84cc6697483828d72f6b0439e1a44a3265b8b3af','image/png',382,251,186784,'2024-08-21 11:49:35','2024-08-21 11:49:35'),(48,'wysiwyg/Bathtub.H03.2k..png','Bathtub.H03.2k.',NULL,'Local','29856d434f2e76d12955560f1b76b3c733ed8418','image/png',2048,2048,3209251,'2024-08-21 11:59:12','2024-08-21 11:59:12'),(49,'wysiwyg/White_Wall_Hung_Toilet_With_Soft_Close_Seat.G03.2k.png','White_Wall_Hung_Toilet_With_Soft_Close_Seat.G03.2k',NULL,'Local','c188056e79d3962e62666b8c1c0432f347ac1a16','image/png',2048,2048,6338255,'2024-08-21 11:59:47','2024-08-21 11:59:47'),(50,'wysiwyg/Classic_Pedestal_Bathroom_Sink.H03.2k.png','Classic_Pedestal_Bathroom_Sink.H03.2k',NULL,'Local','8d8aef0f16d1ae6ca574d3b9406fb75fbf9bc560','image/png',2048,2048,5315029,'2024-08-21 11:59:58','2024-08-21 11:59:58'),(51,'wysiwyg/Bathroom_Classical_Style_Shower_System.H03.2k.png','Bathroom_Classical_Style_Shower_System.H03.2k',NULL,'Local','f802a8a019ea2052a450c2b4858833e044e8b2e7','image/png',2048,2048,2184322,'2024-08-21 12:00:19','2024-08-21 12:00:19'),(52,'wysiwyg/Classical_Chrome_Shower.H03.2k.png','Classical_Chrome_Shower.H03.2k',NULL,'Local','ed1e202bab1ae1c11c2935c32300e30e257cb98f','image/png',2048,2048,4650371,'2024-08-21 12:00:48','2024-08-21 12:00:48'),(53,'wysiwyg/Kitchen_Sink.F16.2k.png','Kitchen_Sink.F16.2k',NULL,'Local','45d278ad443403978a55d5e83c924e54eeaed1b8','image/png',2048,2048,3122759,'2024-08-21 12:01:21','2024-08-21 12:01:21'),(54,'catalog/category/bath_1.jpeg','bath_1',NULL,'Local','c62d816e80dd166a6adb462cc72128e6d0cf01ec','image/jpeg',4096,4096,779401,'2024-08-22 09:33:08','2024-08-22 09:33:08'),(55,'catalog/category/enclosures.jpeg','enclosures',NULL,'Local','ff29d12313f8412dd68d91e3d2dfa63f1a93d95d','image/jpeg',3300,3300,572752,'2024-08-22 10:03:19','2024-08-22 10:03:19'),(56,'catalog/category/kitchen-sink.jpeg','kitchen-sink',NULL,'Local','148e8c76b12b7c981853ac86db4de01745169eec','image/jpeg',3000,3000,258946,'2024-08-22 10:04:02','2024-08-22 10:04:02'),(57,'catalog/category/fires.jpg','fires',NULL,'Local','4a350905e9f7bb9f5ba18a03dc81d41935f4a43f','image/jpg',235,235,16854,'2024-08-22 10:09:36','2024-08-22 10:09:36'),(58,'catalog/category/designer-radiator.jpeg','designer-radiator',NULL,'Local','17d40ce29da6815c3af5614be9161bb776b2713d','image/jpeg',4096,4096,389067,'2024-08-22 10:12:59','2024-08-22 10:12:59'),(59,'catalog/category/taps.jpeg','taps',NULL,'Local','5db19319598fdc4eb063daf5f0aa8cf4986565e5','image/jpeg',4096,4096,1963092,'2024-08-22 10:13:39','2024-08-22 10:13:39'),(60,'catalog/category/showers.jpeg','showers',NULL,'Local','9f86ec08fab70ec8ca9e2e6d8a2e869e0e01327f','image/jpeg',4096,4096,1501177,'2024-08-22 10:15:50','2024-08-22 10:15:50'),(61,'catalog/category/bathroom-accesories.jpeg','bathroom-accesories',NULL,'Local','664d30e4bf65c3abdca7462e62becb76a9339a25','image/jpeg',2500,2500,178554,'2024-08-22 10:16:52','2024-08-22 10:16:52'),(62,'catalog/category/kitchen1_1.png','kitchen1_1',NULL,'Local','684ac9c14179bd2a2ef89395b256c5b0f4c5ee2d','image/png',1080,1080,237082,'2024-08-22 10:18:18','2024-08-22 10:18:18'),(63,'catalog/category/joseph.png','joseph',NULL,'Local','2499aec5480eb052b819294958fd70b117b1610b','image/png',107,51,3604,'2024-08-22 10:19:35','2024-08-22 10:19:35'),(64,'catalog/category/towel-rails.jpeg','towel-rails',NULL,'Local','1bb8c3d9fd599507ea75f6a895cc4855d041500b','image/jpeg',4096,4096,505489,'2024-08-22 10:20:51','2024-08-22 10:20:51'),(65,'wysiwyg/test_image.jpg','test_image',NULL,'Local','055dc3ac9f1caa9ebff5de0d65fc57f1c8a12423','image/jpg',1000,1000,403254,'2024-08-22 14:59:21','2024-08-22 14:59:21'),(68,'wysiwyg/banner3.png','banner3',NULL,'Local','535b5fb38b62e7470980d8021f77563352d09f59','image/png',1440,441,61994,'2024-08-23 10:25:32','2024-08-23 10:25:32'),(69,'catalog/category/kitchen-sink_1.jpeg','kitchen-sink_1',NULL,'Local','148e8c76b12b7c981853ac86db4de01745169eec','image/jpeg',3000,3000,258946,'2024-08-23 10:33:10','2024-08-23 10:33:10'),(70,'catalog/category/straight-bath.png','straight-bath',NULL,'Local','d469443e8341ddbccfc2ffb579bb7c24c5d1ef6b','image/png',1024,1024,251623,'2024-08-29 05:38:07','2024-08-29 05:38:07'),(71,'catalog/category/counter-top_1.png','counter-top_1',NULL,'Local','c0a378572f0ea6be7b84c7dc918dbe06178d9e96','image/png',1280,1024,231464,'2024-08-29 05:41:44','2024-08-29 05:41:44'),(72,'catalog/category/shower-bath.png','shower-bath',NULL,'Local','7e09f33918189b5057b3c4e6032aea168ce86201','image/png',1000,1000,259326,'2024-08-29 05:49:40','2024-08-29 05:49:40'),(73,'catalog/category/straight-bath_1.png','straight-bath_1',NULL,'Local','d469443e8341ddbccfc2ffb579bb7c24c5d1ef6b','image/png',1024,1024,251623,'2024-08-29 05:50:35','2024-08-29 05:50:35'),(74,'catalog/category/counter-top_1_1.png','counter-top_1_1',NULL,'Local','c0a378572f0ea6be7b84c7dc918dbe06178d9e96','image/png',1280,1024,231464,'2024-08-29 05:51:38','2024-08-29 05:51:38'),(75,'catalog/category/straight-bath_2.png','straight-bath_2',NULL,'Local','d469443e8341ddbccfc2ffb579bb7c24c5d1ef6b','image/png',1024,1024,251623,'2024-08-29 05:52:03','2024-08-29 05:52:03'),(76,'catalog/category/whirlpool-bath.png','whirlpool-bath',NULL,'Local','122294cf21e8657d329f21687d72260fca8fefce','image/png',1000,679,111951,'2024-08-29 05:53:01','2024-08-29 05:53:01'),(77,'catalog/category/counter-top_1_2.png','counter-top_1_2',NULL,'Local','c0a378572f0ea6be7b84c7dc918dbe06178d9e96','image/png',1280,1024,231464,'2024-08-29 05:53:49','2024-08-29 05:53:49'),(78,'catalog/category/bathroom-menu.jpeg','bathroom-menu',NULL,'Local','7948d666d911130b2e80b84efd5c96f721598a47','image/jpeg',4096,2731,295097,'2024-08-29 09:16:59','2024-08-29 09:16:59'),(80,'wysiwyg/bath-tub.png','bath-tub',NULL,'Local','d15380dbb64cf0cde9e182aec6e6055c1669fb77','image/png',726,376,170334,'2024-08-30 07:03:50','2024-08-30 07:03:50'),(82,'wysiwyg/bath2.png','bath2',NULL,'Local','68c62200387ee65338b7c996a2f5ecb27f19915b','image/png',582,348,168223,'2024-08-30 08:04:28','2024-08-30 08:04:28'),(83,'wysiwyg/bath3.png','bath3',NULL,'Local','45089d3daecb238ed3e80f3d506757cc26bbabf7','image/png',582,348,408808,'2024-08-30 08:27:46','2024-08-30 08:27:46'),(84,'wysiwyg/bath5.png','bath5',NULL,'Local','0607209dfecdb2e59053cbfd97eb3393b617c1b8','image/png',582,348,260135,'2024-08-30 09:29:03','2024-08-30 09:29:03'),(85,'wysiwyg/bath4.png','bath4',NULL,'Local','59247a4a71a954c0aff9ea72dc40235d1d3d8694','image/png',582,348,354866,'2024-08-30 09:30:15','2024-08-30 09:30:15'),(86,'wysiwyg/play.png','play',NULL,'Local','72353f8deeb703b941e74fb09bf735f271968858','image/png',100,72,1380,'2024-08-30 12:10:19','2024-08-30 12:10:19'),(87,'wysiwyg/video1.png','video1',NULL,'Local','6c3d743e658ead319e8ffdaedb18b142b6a98659','image/png',444,250,172510,'2024-08-30 12:10:33','2024-08-30 12:10:33'),(88,'catalog/category/bathroom-menu_1.jpeg','bathroom-menu_1',NULL,'Local','7948d666d911130b2e80b84efd5c96f721598a47','image/jpeg',4096,2731,295097,'2024-09-02 06:48:05','2024-09-02 06:48:05'),(89,'wysiwyg/cartbox.png','cartbox',NULL,'Local','c036c4fd2b2f052ed7c2c5b2e853f5df523053bc','image/png',80,71,1470,'2024-09-03 05:54:58','2024-09-03 05:54:58'),(90,'wysiwyg/arrow.png','arrow',NULL,'Local','de4badedfe8ad550b75bf636bbb54c496be80ae6','image/png',98,64,2107,'2024-09-03 05:54:58','2024-09-03 05:54:58'),(91,'wysiwyg/document-bx.png','document-bx',NULL,'Local','2b2c8dfb9900994df127b83976ee9e9103f80eea','image/png',70,70,2367,'2024-09-03 05:54:58','2024-09-03 05:54:58'),(92,'wysiwyg/infobx.png','infobx',NULL,'Local','7f421cc02f5e8a09677451fdfcce85239c12f851','image/png',35,56,925,'2024-09-03 05:54:58','2024-09-03 05:54:58'),(93,'wysiwyg/moneybx.png','moneybx',NULL,'Local','8679e4efc8754dcf6429daa5ba82162319cf0d02','image/png',58,54,1552,'2024-09-03 05:54:58','2024-09-03 05:54:58'),(94,'wysiwyg/paypal-logo.png','paypal-logo',NULL,'Local','b0e9e67a8a88f8efd52adeea2de5a14d16956903','image/png',59,70,1299,'2024-09-03 05:54:59','2024-09-03 05:54:59'),(95,'wysiwyg/Group_27532.png','Group_27532',NULL,'Local','ce2ff3c4d811749c7fed38d1aea6799279790896','image/png',428,851,147125,'2024-09-03 05:54:59','2024-09-03 05:54:59'),(96,'wysiwyg/swipebx.png','swipebx',NULL,'Local','a4e0338cd25f94fc7a2e9e34af6e28b1e5146e33','image/png',54,54,1295,'2024-09-03 05:54:59','2024-09-03 05:54:59'),(97,'wysiwyg/paypal.png','paypal',NULL,'Local','1a7a52646c87035b4d02ef867d4d1465b42a31e2','image/png',952,97,55355,'2024-09-03 05:54:59','2024-09-03 05:54:59'),(98,'wysiwyg/girl-right.png','girl-right',NULL,'Local','3c66032e8c0607383ff68d1e6c639cd0385baa13','image/png',307,466,228143,'2024-09-03 05:55:06','2024-09-03 05:55:06'),(99,'wysiwyg/sale-btm1.jpeg','sale-btm1',NULL,'Local','d1baacb81d6cf79f6bad9c62ee980bc51d7af93f','image/jpeg',2304,4096,314698,'2024-09-04 06:37:03','2024-09-04 06:37:03'),(100,'wysiwyg/side-btm.jpeg','side-btm',NULL,'Local','37107aab9c9f4872aed441425d982a18e9752c05','image/jpeg',2304,4096,244248,'2024-09-04 06:37:23','2024-09-04 06:37:23'),(101,'catalog/category/kitchen-sink_2.jpeg','kitchen-sink_2',NULL,'Local','148e8c76b12b7c981853ac86db4de01745169eec','image/jpeg',3000,3000,258946,'2024-09-07 06:56:19','2024-09-07 06:56:19'),(102,'wysiwyg/edit.png','edit',NULL,'Local','2b2c8dfb9900994df127b83976ee9e9103f80eea','image/png',70,70,2367,'2024-09-09 06:48:46','2024-09-09 06:48:46'),(103,'wysiwyg/Group_27495.png','paypal-img','','Local','b0e9e67a8a88f8efd52adeea2de5a14d16956903','image/png',59,70,1299,'2024-09-09 06:48:46','2024-09-09 06:49:10'),(104,'wysiwyg/image_254.png','image_254',NULL,'Local','7314a7dca5c19af1fa32ed5504cf8e51de31142f','image/png',411,522,133475,'2024-09-10 07:16:19','2024-09-10 07:16:19'),(105,'wysiwyg/image_251.png','image_251',NULL,'Local','e924fc71068c1a21169cf00731c38e15bd3d0904','image/png',428,145,8264,'2024-09-10 07:16:33','2024-09-10 07:16:33'),(106,'wysiwyg/image_252.png','image_252',NULL,'Local','b653418e042fdb08c8b02ed0e09da9f21759f448','image/png',428,178,17007,'2024-09-10 07:16:33','2024-09-10 07:16:33'),(107,'wysiwyg/image_253.png','image_253',NULL,'Local','127af93df950183bb961eee5b2581e417558331d','image/png',428,528,121610,'2024-09-10 07:16:34','2024-09-10 07:16:34'),(108,'wysiwyg/apd-feb-finance-logo-paypal_1.png','apd-feb-finance-logo-paypal_1',NULL,'Local','6b62040641bd09f5478b819335ee96f1e5147c5d','image/png',129,46,12505,'2024-09-12 11:18:28','2024-09-12 11:18:28'),(109,'catalog/category/kitchen-sink_3.jpeg','kitchen-sink_3',NULL,'Local','148e8c76b12b7c981853ac86db4de01745169eec','image/jpeg',3000,3000,258946,'2024-10-15 09:46:05','2024-10-15 09:46:05'),(110,'wysiwyg/Banner-01_1.jpg','Banner-01_1',NULL,'Local','21cbbfb2059ab366abc2d2b6f924cef8116814c6','image/jpg',1441,441,539506,'2025-01-28 11:01:48','2025-01-28 11:01:48'),(111,'wysiwyg/Web-03_1.jpg','Web-03_1',NULL,'Local','e428c6418190c5616cc1b2467aff8bf4f9a322a3','image/jpg',814,526,391193,'2025-01-28 11:04:11','2025-01-28 11:04:11'),(112,'wysiwyg/Banner-01_2.jpg','Banner-01_2',NULL,'Local','21cbbfb2059ab366abc2d2b6f924cef8116814c6','image/jpg',1441,441,539506,'2025-01-28 11:09:55','2025-01-28 11:09:55'),(113,'wysiwyg/Banner-02_1.jpg','Banner-02_1',NULL,'Local','acda7634bf6aa7d3f5d26e7e4732c9b7367f1494','image/jpg',1441,441,452560,'2025-01-28 11:10:45','2025-01-28 11:10:45'),(114,'wysiwyg/banner3.jpg','banner3',NULL,'Local','3926cb99b5047b4f5290f83e8f3e5777760df60c','image/jpg',1440,441,149801,'2025-01-28 11:15:20','2025-01-28 11:15:20'),(115,'wysiwyg/Web-03_2.jpg','Web-03_2',NULL,'Local','e428c6418190c5616cc1b2467aff8bf4f9a322a3','image/jpg',814,526,391193,'2025-01-28 11:23:31','2025-01-28 11:23:31'),(116,'wysiwyg/Banner-01_3.jpg','Banner-01_3',NULL,'Local','21cbbfb2059ab366abc2d2b6f924cef8116814c6','image/jpg',1441,441,539506,'2025-01-28 12:12:05','2025-01-28 12:12:05'),(117,'wysiwyg/hyva_banner_home_test_1.jpg','hyva_banner_home_test_1',NULL,'Local','7ecbab8383115378a8862d5c109a098d0ae2f615','image/jpg',1000,306,229106,'2025-01-28 14:38:14','2025-01-28 14:38:14'),(118,'wysiwyg/hyva_banner_home_test_1_1.jpg','hyva_banner_home_test_1_1',NULL,'Local','7ecbab8383115378a8862d5c109a098d0ae2f615','image/jpg',1000,306,229106,'2025-01-28 14:39:24','2025-01-28 14:39:24'),(119,'wysiwyg/hyva_banner_home_test_1_2.jpg','hyva_banner_home_test_1_2',NULL,'Local','7ecbab8383115378a8862d5c109a098d0ae2f615','image/jpg',1000,306,229106,'2025-01-28 14:42:00','2025-01-28 14:42:00'),(120,'wysiwyg/hyva_banner_home_test_1_3.jpg','hyva_banner_home_test_1_3',NULL,'Local','7ecbab8383115378a8862d5c109a098d0ae2f615','image/jpg',1000,306,229106,'2025-01-28 14:45:11','2025-01-28 14:45:11'),(121,'wysiwyg/nexus_temporary_banner.jpg','nexus_temporary_banner',NULL,'Local','4865ed4bf7a29e11b48bd30f3540ba6c25bc0f18','image/jpg',1000,306,166741,'2025-02-21 10:44:05','2025-02-21 10:44:05'),(122,'wysiwyg/nexus_temporary_banner_1.jpg','nexus_temporary_banner_1',NULL,'Local','4865ed4bf7a29e11b48bd30f3540ba6c25bc0f18','image/jpg',1000,306,166741,'2025-02-21 10:44:53','2025-02-21 10:44:53'),(123,'wysiwyg/14.jpg','14',NULL,'Local','8f677eddbe7690b0f31acf87385b6f934e0def14','image/jpg',1000,306,201525,'2025-02-21 11:00:47','2025-02-21 11:00:47');

--
