-- Table structure for table `cms_page_store`
--

CREATE TABLE `cms_page_store` (
  `page_id` smallint(6) NOT NULL COMMENT 'Entity ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`page_id`,`store_id`),
  KEY `CMS_PAGE_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Page To Store Linkage Table';

--
-- Dumping data for table `cms_page_store`
--

INSERT INTO `cms_page_store` VALUES (1,0),(2,0),(3,0),(4,0),(5,0),(6,0),(7,0),(8,0);

--
-- Table structure for table `core_config_data`
--

CREATE TABLE `core_config_data` (
  `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config ID',
  `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope',
  `scope_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Config Scope ID',
  `path` varchar(255) NOT NULL DEFAULT 'general' COMMENT 'Config Path',
  `value` text COMMENT 'Config Value',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB AUTO_INCREMENT=659 DEFAULT CHARSET=utf8 COMMENT='Config Data';

--
-- Dumping data for table `core_config_data`
--

INSERT INTO `core_config_data` VALUES (1,'default',0,'yotpo/module_info/yotpo_installation_date','2024-01-29','2024-01-29 23:31:53'),(2,'default',0,'yotpo/sync_settings/orders_sync_start_date','2024-01-29','2024-01-29 23:31:53'),(3,'default',0,'web/seo/use_rewrites','1','2024-01-29 23:31:54'),(4,'default',0,'web/unsecure/base_url','https://coffeeculture.se/','2024-02-03 17:51:10'),(5,'default',0,'general/locale/code','en_US','2024-01-29 23:31:54'),(6,'default',0,'general/locale/timezone','America/Chicago','2024-01-29 23:31:54'),(7,'default',0,'currency/options/base','SEK','2024-02-02 23:30:00'),(8,'default',0,'currency/options/default','SEK','2024-02-02 23:30:00'),(9,'default',0,'currency/options/allow','SEK','2024-02-02 23:30:00'),(10,'default',0,'general/region/display_all','1','2024-01-29 23:31:54'),(11,'default',0,'general/region/state_required','AU,BR,CA,CN,CO,HR,EE,IN,LV,LT,MX,PL,RO,ES,CH,US','2024-02-02 23:28:54'),(12,'default',0,'catalog/category/root_id','2','2024-01-29 23:31:56'),(13,'default',0,'analytics/subscription/enabled','1','2024-01-29 23:31:57'),(14,'default',0,'crontab/default/jobs/analytics_subscribe/schedule/cron_expr','0 * * * *','2024-01-29 23:31:57'),(15,'default',0,'crontab/default/jobs/analytics_collect_data/schedule/cron_expr','00 02 * * *','2024-01-29 23:31:57'),(16,'default',0,'payment/authorizenet_acceptjs/cctypes','AE,VI,MC,DI,JCB,DN','2024-01-29 23:31:57'),(17,'default',0,'payment/authorizenet_acceptjs/order_status','processing','2024-01-29 23:31:57'),(18,'default',0,'payment/authorizenet_acceptjs/payment_action','authorize','2024-01-29 23:31:57'),(19,'default',0,'payment/authorizenet_acceptjs/currency','USD','2024-01-29 23:31:57'),(20,'websites',1,'payment/authorizenet_acceptjs/cctypes','AE,VI,MC,DI,JCB,DN','2024-01-29 23:31:57'),(21,'websites',1,'payment/authorizenet_acceptjs/order_status','processing','2024-01-29 23:31:57'),(22,'websites',1,'payment/authorizenet_acceptjs/payment_action','authorize','2024-01-29 23:31:57'),(23,'websites',1,'payment/authorizenet_acceptjs/currency','USD','2024-01-29 23:31:57'),(24,'website',0,'connector_configuration/transactional_data/order_statuses','canceled,closed,complete,fraud,holded,payment_review,paypal_canceled_reversal,paypal_reversed,pending,pending_payment,pending_paypal,processing','2024-01-29 23:31:58'),(25,'website',0,'connector_configuration/catalog_sync/catalog_type','simple,virtual,configurable,downloadable,grouped,bundle','2024-01-29 23:31:58'),(26,'website',0,'connector_configuration/catalog_sync/catalog_visibility','1,2,3,4','2024-01-29 23:31:58'),(27,'default',0,'connector_dynamic_content/external_dynamic_content_urls/passcode','UmPu0m2msUtUoaxJ0hCcRJveJ8VV7axN','2024-01-29 23:31:58'),(28,'default',0,'connector_automation/review_settings/allow_non_subscribers','1','2024-01-29 23:31:58'),(29,'default',0,'connector_configuration/abandoned_carts/allow_non_subscribers','1','2024-01-29 23:31:58'),(30,'default',0,'sync_settings/addressbook/allow_non_subscribers','1','2024-01-29 23:31:58'),(31,'default',0,'msp_securitysuite_twofactorauth/duo/application_key','b7xLehTyplVAvfwu6AmJcyq7XkvqbX9W7wS7Ex55RTRaykq6j9fnjn1jNLsfDryL','2024-01-29 23:31:58'),(32,'default',0,'admin/usage/enabled','0','2024-01-29 23:37:03'),(33,'default',0,'payment/amazon_payments/simplepath/publickey','-----BEGIN PUBLIC KEY-----\r\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA1ApgJ2s0/XiYRhmhZ+5p\r\n1ouV5aIqfPqfVNU5X7XtNcw+oxrrsFvdFFlXmv/x/6QQd5MCYncdcHLgGt0xIPPO\r\nAGAu3PifQkfZZa4rB2uFGwwNWE03V7KRu1yFjL/j8NT9lPbn/qYq/UclO2wOocYi\r\nYpyuGulKK7zLAYzQ69BDX3m66wR3O7j18bwKO6QC8tpsSx6K5XYhas+W150COQMx\r\n1tH//m7+rS9ru/vjG4RFyOSs7TnUvp01l6D/C010e+UwJhBwpNRyzY1ti2koeU7m\r\nOjv2VHgcn3vLNkI+yloMTCAtMz+DvWyyjFtMm9XshZQzDWMBUbikvXUx++7Q5bsZ\r\nwQIDAQAB\r\n-----END PUBLIC KEY-----','2024-01-29 23:45:33'),(34,'default',0,'payment/amazon_payments/simplepath/privatekey','0:3:M0pAavBL1GbtkFKXVc/Ybav0K+RKQ7pBuhTbH+Z6vfWKzWVNleDRuDTravo+gYHq5+bG1N4uH9HOLgUrMJQZaML8w/wUe3sh2+63/Y/G+Nn5IbszM3VNLuonn9MIQEKlEL7qiUW655lL7ZHn85ptdRauJjVl9QnNIJG46xyg0AtJGEmCsjzKv7xU+wHhAbeAyk+YkDoP8QKeK+4Bfsv9lWzgts6E/++cXrMH79440QQfQTPAssQu/C0BtQX55j4X0DiYppcWqf8RwcZ8eXZBIRvyh7EPkiHM8p1mIu1iWK9olr1z5CEocJULn2fzTiavRamnb38Rmzji1oPS3jR3e7QTBKzRxxQZvKqL7cZVa+lktWGDP2vUwJGNUxcR+5VQXrUQ7Pb30EvAiLn3lQqWhfqnU6eJTsZvO6WZ40ZwWW/pnKQQFdb+xw2pQUiMK3MCFunLG3i9qZpOGW0By6MCdjFutXU2DXpbANdOz/y7iESM5As4x4qAW0c4CLFCH6Ev4WiSU7xzAjfPJeBCKp2TTHzCPRI3T1SWHhIHw/FhTjV+sgCpevGCHjKcocrkZg8mPM+/dLdaJpOsiInY+A4FXM1DAJBC+NxfkJxGwom/bA1ylQ2vv+eItQHveaxQp0gUU/M2JUFWhuRQGZdV1m0RRg2LeOMKMbyOM/SYsAQicmvO8qRHpBib70Iq/2O82jOyT3KOZkR+K/obVMEAtGKtUJMtLc9LcDuYODV5pC3oSbRTnqX1wjcUEVt6R8xSYY6K728eADIfFvqCaVzy1GM6mSzDxW38P5FfJ06zjkTkeKtEnjo1KZ/zCQ1LxP0EYLBCFUHoKEDW+ZHYNpyPkBvzfvNIZoR94gWwAQevlJ1BJ4IYOeK7L57GafD6t/KKQ039c1n8gXEVHmNoX1QotiWyiUkfA0/mFeMLaemyRLD2PqcVOAG+PlwxdFXIPKdrXGExZghzNiF0mRsIvIEd/I/NdJogRAS2w2K6XUAATOcow7IpRSsNBY8Lr2iODprK7KG4X+4zIeHXFn96nXkNh+CRlRHIFZqLpLgVIv6pruMLhGK+QHcjyOj1EpkNmED/7+BAvtSgijGXwVvztqPhiUYkqE3mwDubTHAoJbHfE1SSVDBPpn9R8R1f12vLnG5i6T8VXo7627t7doGEr6up+Dr0s4TNlBSblRB722CMV/DNWqmMA0vdgLE0rtFJpq4XW6MHGJ2h77IaThXQ8nnFtMqnRXIWyaywol4m2v1xTgX9WlMuJROY3PcOhJnfGxd58WlndASB3XTWJgzLzsBWYHP1jEdc402IRj6Ii8DdF3KJBetXVEUM02H4o6MlgFYdWX78IMiv+Wsas4ak2UZcBx6QE7IYJynLPUx8+PqiPwfQmV6qOR4iTk1dV1rEhsugQppXPwbtYnI9cKkKMRng/V5pQdtFOndv91UA0Tuf3WW4rqDPXm+SUmjk8txh49fFDLSbyNqoMC7uDJtP171RAQflWzPmhpQCjqE049Pzb+MuiCDuVvCjX1n9fDylZRox53e55d8X/D8bCeJLFYpODXu9nvKjg8+Tj9A08NMkat8twp7zOUDHE8wfdEa4HIJvrh3YAGVJLljlCUrAtzneX0PqdxKR7VIV/qVDXCvNmlMn9dgay94G8GaV9JkpA/F3G202AGTVD5tQhoCrB2ZU119j7AFD6aayydxMMON78lhiXF9m0T9yNbJriaX5CXEcqFM+pbSLjYinmxD6gLctOwf/+F2LlNLmHRMvgdc6wHSiB9VQy28pmEazOK5tstJ6NbPoADhTC0OKClbmku6dkzbVjAFu+qAr54zfKkMQ9/17PViUE3/Uhj/bGaG/30CDCoF11hwrXhm/XXbEqPmPkEWZH8EkH3EjvyXZAI1RyESpVkc0ra1g8buC7czMhaI+NPZSLjwW1zFPjPKlk7SocYemthK+LVxxKI7DCZX7oavHHUPqEDsg97PXua2gSTRZ7PMxftCui1hKRW2ScLrhCqzcXewxf1PUa7jgU3yVKxRlhXhbmrl9c7RTpGdgoKJghd2bLNHklaikOmTqzRCJveGJn4WJKloX0fKjvzHNVfcjOhskFITFy1rr6qp+8tJFWctgaZ801Gd2u/M5HbPiVxmjR3AL9Rl6Td66JFbpozQeSt4g/r4HL4xNyc1B3v7HpWH//VUjNuf8boS2RXMO+un46D457VpJKA/rWREA4llSKQyyNDM+jb9qEx1R/NpJlhFrvBA5WwwfLlyOEzx0ffsMCk8M+/F/hR0gY1cZbbjoz4a0Jzl93TNQAv1eBxzX/NNBE/nESA==','2024-01-29 23:45:33'),(35,'default',0,'paypal/general/merchant_country','SE','2024-01-29 23:45:52'),(36,'default',0,'payment/paypal_express/active','0','2024-01-29 23:45:52'),(37,'default',0,'payment/paypal_express/in_context','0','2024-01-29 23:45:52'),(38,'default',0,'paypal/general/business_account',NULL,'2024-01-29 23:45:52'),(39,'default',0,'paypal/wpp/api_authentication','0','2024-01-29 23:45:52'),(40,'default',0,'paypal/wpp/api_username',NULL,'2024-01-29 23:45:52'),(41,'default',0,'paypal/wpp/api_password',NULL,'2024-01-29 23:45:52'),(42,'default',0,'paypal/wpp/api_signature',NULL,'2024-01-29 23:45:52'),(43,'default',0,'paypal/wpp/sandbox_flag','0','2024-01-29 23:45:52'),(44,'default',0,'paypal/wpp/use_proxy','0','2024-01-29 23:45:52'),(45,'default',0,'payment/paypal_express/title','PayPal Express Checkout','2024-01-29 23:45:52'),(46,'default',0,'payment/paypal_express/sort_order',NULL,'2024-01-29 23:45:52'),(47,'default',0,'payment/paypal_express/payment_action','Authorization','2024-01-29 23:45:52'),(48,'default',0,'payment/paypal_express/visible_on_product','1','2024-01-29 23:45:52'),(49,'default',0,'payment/paypal_express/visible_on_cart','1','2024-01-29 23:45:52'),(50,'default',0,'payment/paypal_express/allowspecific','0','2024-01-29 23:45:52'),(51,'default',0,'payment/paypal_express/debug','0','2024-01-29 23:45:52'),(52,'default',0,'payment/paypal_express/verify_peer','1','2024-01-29 23:45:52'),(53,'default',0,'payment/paypal_express/line_items_enabled','1','2024-01-29 23:45:52'),(54,'default',0,'payment/paypal_express/transfer_shipping_options','0','2024-01-29 23:45:52'),(55,'default',0,'paypal/wpp/button_flavor','dynamic','2024-01-29 23:45:52'),(56,'default',0,'payment/paypal_express/solution_type','Mark','2024-01-29 23:45:52'),(57,'default',0,'payment/paypal_express/require_billing_address','0','2024-01-29 23:45:52'),(58,'default',0,'payment/paypal_express/allow_ba_signup','never','2024-01-29 23:45:52'),(59,'default',0,'payment/paypal_express/skip_order_review_step','1','2024-01-29 23:45:52'),(60,'default',0,'payment/paypal_billing_agreement/active','1','2024-01-29 23:45:52'),(61,'default',0,'payment/paypal_billing_agreement/title','PayPal Billing Agreement','2024-01-29 23:45:52'),(62,'default',0,'payment/paypal_billing_agreement/sort_order',NULL,'2024-01-29 23:45:52'),(63,'default',0,'payment/paypal_billing_agreement/payment_action','Authorization','2024-01-29 23:45:52'),(64,'default',0,'payment/paypal_billing_agreement/allowspecific','0','2024-01-29 23:45:52'),(65,'default',0,'payment/paypal_billing_agreement/debug','0','2024-01-29 23:45:52'),(66,'default',0,'payment/paypal_billing_agreement/verify_peer','1','2024-01-29 23:45:52'),(67,'default',0,'payment/paypal_billing_agreement/line_items_enabled','0','2024-01-29 23:45:52'),(68,'default',0,'payment/paypal_billing_agreement/allow_billing_agreement_wizard','1','2024-01-29 23:45:52'),(69,'default',0,'paypal/fetch_reports/ftp_login',NULL,'2024-01-29 23:45:52'),(70,'default',0,'paypal/fetch_reports/ftp_password',NULL,'2024-01-29 23:45:52'),(71,'default',0,'paypal/fetch_reports/ftp_sandbox','0','2024-01-29 23:45:52'),(72,'default',0,'paypal/fetch_reports/ftp_ip',NULL,'2024-01-29 23:45:52'),(73,'default',0,'paypal/fetch_reports/ftp_path',NULL,'2024-01-29 23:45:52'),(74,'default',0,'paypal/fetch_reports/active','0','2024-01-29 23:45:52'),(75,'default',0,'paypal/fetch_reports/schedule','1','2024-01-29 23:45:52'),(76,'default',0,'paypal/fetch_reports/time','00,00,00','2024-01-29 23:45:52'),(77,'default',0,'paypal/style/logo',NULL,'2024-01-29 23:45:52'),(78,'default',0,'paypal/style/page_style',NULL,'2024-01-29 23:45:52'),(79,'default',0,'paypal/style/paypal_hdrimg',NULL,'2024-01-29 23:45:52'),(80,'default',0,'paypal/style/paypal_hdrbackcolor',NULL,'2024-01-29 23:45:52'),(81,'default',0,'paypal/style/paypal_hdrbordercolor',NULL,'2024-01-29 23:45:52'),(82,'default',0,'paypal/style/paypal_payflowcolor',NULL,'2024-01-29 23:45:52'),(83,'default',0,'paypal/style/checkout_page_button_customize','0','2024-01-29 23:45:52'),(84,'default',0,'paypal/style/product_page_button_customize','0','2024-01-29 23:45:52'),(85,'default',0,'paypal/style/cart_page_button_customize','0','2024-01-29 23:45:52'),(86,'default',0,'paypal/style/mini_cart_page_button_customize','0','2024-01-29 23:45:52'),(87,'default',0,'paypal/style/disable_funding_options',NULL,'2024-01-29 23:45:52'),(88,'default',0,'payment/wps_express/active','0','2024-01-29 23:45:52'),(89,'default',0,'klarna/api/api_version','kp_eu','2024-01-29 23:45:52'),(90,'default',0,'klarna/api/merchant_id',NULL,'2024-01-29 23:45:52'),(91,'default',0,'klarna/api/shared_secret',NULL,'2024-01-29 23:45:52'),(92,'default',0,'klarna/api/test_mode','1','2024-01-29 23:45:52'),(93,'default',0,'klarna/api/debug','1','2024-01-29 23:45:52'),(94,'default',0,'payment/klarna_kp/active','0','2024-01-29 23:45:52'),(95,'default',0,'payment/klarna_kp/allowspecific','0','2024-01-29 23:45:52'),(96,'default',0,'payment/klarna_kp/enable_b2b','0','2024-01-29 23:45:52'),(97,'default',0,'payment/klarna_kp/data_sharing','1','2024-01-29 23:45:52'),(98,'default',0,'payment/klarna_kp/data_sharing_onload','1','2024-01-29 23:45:52'),(99,'default',0,'payment/klarna_kp/sort_order',NULL,'2024-01-29 23:45:52'),(100,'default',0,'checkout/klarna_kp_design/color_details',NULL,'2024-01-29 23:45:52'),(101,'default',0,'checkout/klarna_kp_design/color_border',NULL,'2024-01-29 23:45:52'),(102,'default',0,'checkout/klarna_kp_design/color_border_selected',NULL,'2024-01-29 23:45:52'),(103,'default',0,'checkout/klarna_kp_design/color_text',NULL,'2024-01-29 23:45:52'),(104,'default',0,'checkout/klarna_kp_design/color_radius_border',NULL,'2024-01-29 23:45:52'),(105,'default',0,'payment/amazon_payment/merchant_id',NULL,'2024-01-29 23:45:52'),(106,'default',0,'payment/amazon_payment/access_key',NULL,'2024-01-29 23:45:52'),(107,'default',0,'payment/amazon_payment/secret_key',NULL,'2024-01-29 23:45:52'),(108,'default',0,'payment/amazon_payment/client_id',NULL,'2024-01-29 23:45:52'),(109,'default',0,'payment/amazon_payment/client_secret',NULL,'2024-01-29 23:45:52'),(110,'default',0,'payment/amazon_payment/credentials_json',NULL,'2024-01-29 23:45:52'),(111,'default',0,'payment/amazon_payment/payment_region',NULL,'2024-01-29 23:45:52'),(112,'default',0,'payment/amazon_payment/sandbox','0','2024-01-29 23:45:52'),(113,'default',0,'payment/amazon_payment/active','0','2024-01-29 23:45:52'),(114,'default',0,'payment/amazon_payment/lwa_enabled','0','2024-01-29 23:45:52'),(115,'default',0,'payment/amazon_payment/payment_action','authorize','2024-01-29 23:45:52'),(116,'default',0,'payment/amazon_payment/authorization_mode','synchronous','2024-01-29 23:45:52'),(117,'default',0,'payment/amazon_payment/update_mechanism','polling','2024-01-29 23:45:52'),(118,'default',0,'payment/amazon_payment/button_display_language',NULL,'2024-01-29 23:45:52'),(119,'default',0,'payment/amazon_payment/button_color','Gold','2024-01-29 23:45:52'),(120,'default',0,'payment/amazon_payment/button_size','medium','2024-01-29 23:45:52'),(121,'default',0,'payment/amazon_payment/amazon_login_in_popup','1','2024-01-29 23:45:52'),(122,'default',0,'payment/amazon_payment/pwa_pp_button_is_visible','1','2024-01-29 23:45:52'),(123,'default',0,'payment/amazon_payment/minicart_button_is_visible','1','2024-01-29 23:45:52'),(124,'default',0,'payment/amazonlogin/active','0','2024-01-29 23:45:52'),(125,'default',0,'payment/amazon_payment/storename',NULL,'2024-01-29 23:45:52'),(126,'default',0,'payment/amazon_payment/logging','1','2024-01-29 23:45:52'),(127,'default',0,'payment/amazon_payment/allowed_ips',NULL,'2024-01-29 23:45:52'),(128,'default',0,'payment/checkmo/specificcountry',NULL,'2024-01-29 23:45:52'),(129,'default',0,'payment/checkmo/payable_to',NULL,'2024-01-29 23:45:52'),(130,'default',0,'payment/checkmo/mailing_address',NULL,'2024-01-29 23:45:52'),(131,'default',0,'payment/checkmo/min_order_total',NULL,'2024-01-29 23:45:52'),(132,'default',0,'payment/checkmo/max_order_total',NULL,'2024-01-29 23:45:52'),(133,'default',0,'payment/checkmo/sort_order',NULL,'2024-01-29 23:45:52'),(134,'default',0,'payment/cashondelivery/specificcountry',NULL,'2024-01-29 23:45:52'),(135,'default',0,'payment/cashondelivery/instructions',NULL,'2024-01-29 23:45:52'),(136,'default',0,'payment/cashondelivery/min_order_total',NULL,'2024-01-29 23:45:52'),(137,'default',0,'payment/cashondelivery/max_order_total',NULL,'2024-01-29 23:45:52'),(138,'default',0,'payment/cashondelivery/sort_order',NULL,'2024-01-29 23:45:52'),(139,'default',0,'payment/banktransfer/specificcountry',NULL,'2024-01-29 23:45:52'),(140,'default',0,'payment/banktransfer/instructions',NULL,'2024-01-29 23:45:52'),(141,'default',0,'payment/banktransfer/min_order_total',NULL,'2024-01-29 23:45:52'),(142,'default',0,'payment/banktransfer/max_order_total',NULL,'2024-01-29 23:45:52'),(143,'default',0,'payment/banktransfer/sort_order',NULL,'2024-01-29 23:45:52'),(144,'default',0,'payment/free/specificcountry',NULL,'2024-01-29 23:45:52'),(145,'default',0,'payment/purchaseorder/specificcountry',NULL,'2024-01-29 23:45:52'),(146,'default',0,'payment/purchaseorder/min_order_total',NULL,'2024-01-29 23:45:52'),(147,'default',0,'payment/purchaseorder/max_order_total',NULL,'2024-01-29 23:45:52'),(148,'default',0,'payment/purchaseorder/sort_order',NULL,'2024-01-29 23:45:52'),(149,'default',0,'payment/braintree/active','0','2024-01-29 23:45:52'),(150,'default',0,'payment/braintree_paypal/active','0','2024-01-29 23:45:52'),(151,'default',0,'payment/braintree_cc_vault/active','0','2024-01-29 23:45:52'),(152,'default',0,'payment/braintree/title','Credit Card (Braintree)','2024-01-29 23:45:52'),(153,'default',0,'payment/braintree/environment','sandbox','2024-01-29 23:45:52'),(154,'default',0,'payment/braintree/payment_action','authorize','2024-01-29 23:45:52'),(155,'default',0,'payment/braintree/merchant_id',NULL,'2024-01-29 23:45:52'),(156,'default',0,'payment/braintree/public_key',NULL,'2024-01-29 23:45:52'),(157,'default',0,'payment/braintree/private_key',NULL,'2024-01-29 23:45:52'),(158,'default',0,'payment/braintree_cc_vault/title','Stored Cards (Braintree)','2024-01-29 23:45:52'),(159,'default',0,'payment/braintree/merchant_account_id',NULL,'2024-01-29 23:45:52'),(160,'default',0,'payment/braintree/fraudprotection','0','2024-01-29 23:45:52'),(161,'default',0,'payment/braintree/debug','0','2024-01-29 23:45:52'),(162,'default',0,'payment/braintree/useccv','1','2024-01-29 23:45:52'),(163,'default',0,'payment/braintree/cctypes','CUP,AE,VI,MC,DI,JCB,DN,MI','2024-01-29 23:45:52'),(164,'default',0,'payment/braintree/sort_order',NULL,'2024-01-29 23:45:52'),(165,'default',0,'payment/braintree/allowspecific','0','2024-01-29 23:45:52'),(166,'default',0,'payment/braintree/specificcountry',NULL,'2024-01-29 23:45:52'),(167,'default',0,'payment/braintree/countrycreditcard','[]','2024-01-29 23:45:52'),(168,'default',0,'payment/braintree_paypal/title','PayPal (Braintree)','2024-01-29 23:45:52'),(169,'default',0,'payment/braintree_paypal_vault/active','0','2024-01-29 23:45:52'),(170,'default',0,'payment/braintree_paypal/sort_order',NULL,'2024-01-29 23:45:52'),(171,'default',0,'payment/braintree_paypal/merchant_name_override',NULL,'2024-01-29 23:45:52'),(172,'default',0,'payment/braintree_paypal/payment_action','authorize','2024-01-29 23:45:52'),(173,'default',0,'payment/braintree_paypal/allowspecific','0','2024-01-29 23:45:52'),(174,'default',0,'payment/braintree_paypal/specificcountry',NULL,'2024-01-29 23:45:52'),(175,'default',0,'payment/braintree_paypal/require_billing_address','0','2024-01-29 23:45:52'),(176,'default',0,'payment/braintree_paypal/allow_shipping_address_override','1','2024-01-29 23:45:52'),(177,'default',0,'payment/braintree_paypal/debug','0','2024-01-29 23:45:52'),(178,'default',0,'payment/braintree_paypal/display_on_shopping_cart','1','2024-01-29 23:45:52'),(179,'default',0,'payment/braintree_paypal/skip_order_review','0','2024-01-29 23:45:52'),(180,'default',0,'payment/braintree/verify_3dsecure','0','2024-01-29 23:45:52'),(181,'default',0,'payment/braintree/threshold_amount',NULL,'2024-01-29 23:45:52'),(182,'default',0,'payment/braintree/verify_all_countries','0','2024-01-29 23:45:52'),(183,'default',0,'payment/braintree/verify_specific_countries',NULL,'2024-01-29 23:45:52'),(184,'default',0,'payment/braintree/descriptor_name',NULL,'2024-01-29 23:45:52'),(185,'default',0,'payment/braintree/descriptor_phone',NULL,'2024-01-29 23:45:52'),(186,'default',0,'payment/braintree/descriptor_url',NULL,'2024-01-29 23:45:52'),(187,'default',0,'payment/authorizenet_acceptjs/environment','production','2024-01-29 23:45:52'),(188,'default',0,'payment/authorizenet_acceptjs/specificcountry',NULL,'2024-01-29 23:45:52'),(189,'default',0,'payment/authorizenet_acceptjs/min_order_total',NULL,'2024-01-29 23:45:52'),(190,'default',0,'payment/authorizenet_acceptjs/max_order_total',NULL,'2024-01-29 23:45:52'),(191,'default',0,'payment/authorizenet_acceptjs/sort_order',NULL,'2024-01-29 23:45:52'),(192,'default',0,'payment/authorizenet_directpost/login',NULL,'2024-01-29 23:45:52'),(193,'default',0,'payment/authorizenet_directpost/trans_key',NULL,'2024-01-29 23:45:52'),(194,'default',0,'payment/authorizenet_directpost/signature_key',NULL,'2024-01-29 23:45:52'),(195,'default',0,'payment/authorizenet_directpost/trans_md5',NULL,'2024-01-29 23:45:52'),(196,'default',0,'payment/authorizenet_directpost/merchant_email',NULL,'2024-01-29 23:45:52'),(197,'default',0,'payment/authorizenet_directpost/useccv','0','2024-01-29 23:45:52'),(198,'default',0,'payment/authorizenet_directpost/specificcountry',NULL,'2024-01-29 23:45:52'),(199,'default',0,'payment/authorizenet_directpost/min_order_total',NULL,'2024-01-29 23:45:52'),(200,'default',0,'payment/authorizenet_directpost/max_order_total',NULL,'2024-01-29 23:45:52'),(201,'default',0,'payment/authorizenet_directpost/sort_order',NULL,'2024-01-29 23:45:52'),(202,'default',0,'payment/swish/request_payments_url_mss','https://mss.cpc.getswish.net/swish-cpcapi/api/v1/paymentrequests','2024-02-02 23:15:19'),(203,'default',0,'payment/swish/refunds_url_mss','https://mss.cpc.getswish.net/swish-cpcapi/api/v1/refunds','2024-02-02 23:15:19'),(204,'default',0,'payment/swish/qr_code_url_mss','https://mpc.getswish.net/qrg-swish/api/v1/commerce','2024-02-02 23:15:19'),(205,'default',0,'payment/swish/payout_url_mss','https://mss.cpc.getswish.net/swish-cpcapi/api/v1/payouts','2024-02-02 23:15:19'),(206,'default',0,'payment/swish/request_payments_url_sandbox','https://staging.getswish.pub.tds.tieto.com/cpc-swish/api/v1/paymentrequests','2024-02-02 23:15:19'),(207,'default',0,'payment/swish/refunds_url_sandbox','https://staging.getswish.pub.tds.tieto.com/cpc-swish/api/v1/refunds','2024-02-02 23:15:19'),(208,'default',0,'payment/swish/qr_code_url_sandbox','https://staging.getswish.pub.tds.tieto.com/qrg-swish/api/v1/commerce','2024-02-02 23:15:19'),(209,'default',0,'payment/swish/payout_url_sandbox','https://staging.getswish.pub.tds.tieto.com/cpc-swish/api/v1/payouts','2024-02-02 23:15:19'),(210,'default',0,'payment/swish/request_payments_url_live','https://cpc.getswish.net/swish-cpcapi/api/v1/paymentrequests','2024-02-02 23:15:19'),(211,'default',0,'payment/swish/refunds_url_live','https://cpc.getswish.net/swish-cpcapi/api/v1/refunds','2024-02-02 23:15:19'),(212,'default',0,'payment/swish/qr_code_url_live','https://mpc.getswish.net/qrg-swish/api/v1/commerce','2024-02-02 23:15:19'),(213,'default',0,'payment/swish/payout_url_live','https://cpc.getswish.net/swish-cpcapi/api/v1/payouts','2024-02-02 23:15:19'),(214,'default',0,'payment/swish/active','1','2024-02-02 23:20:28'),(215,'default',0,'payment/swish/environment','live','2024-02-02 23:20:28'),(216,'default',0,'payment/swish/title','Swish','2024-02-02 23:20:28'),(217,'default',0,'payment/swish/order_status','processing','2024-02-02 23:20:28'),(218,'default',0,'payment/swish/allowspecific','0','2024-02-02 23:20:28'),(219,'default',0,'payment/swish/specificcountry',NULL,'2024-02-02 23:20:28'),(220,'default',0,'payment/swish/instructions','Instruction.','2024-02-02 23:20:28'),(221,'default',0,'payment/swish/sort_order',NULL,'2024-02-02 23:20:28'),(222,'default',0,'payment/swish/min_order_total',NULL,'2024-02-02 23:20:28'),(223,'default',0,'payment/swish/max_order_total',NULL,'2024-02-02 23:20:28'),(224,'default',0,'payment/swish/swish_number','1236564850','2024-02-02 23:20:28'),(225,'default',0,'payment/swish/cert_pass',NULL,'2024-02-02 23:20:28'),(226,'default',0,'payment/swish/retrieve_request_delay',NULL,'2024-02-02 23:20:28'),(227,'default',0,'payment/swish/create_invoice','0','2024-02-02 23:20:28'),(228,'default',0,'payment/swish/send_invoice','0','2024-02-02 23:20:28'),(229,'default',0,'payment/swish/logger','disabled','2024-02-02 23:20:28'),(230,'default',0,'payment/swish/cert_file','swish_certificate_202402031756.pem','2024-02-03 16:57:18'),(231,'default',0,'payment/swish/cert_key_file','1236564850.key','2024-02-03 16:57:18'),(232,'default',0,'general/country/default','SE','2024-02-02 23:28:54'),(233,'default',0,'general/country/destinations',NULL,'2024-02-02 23:28:54'),(234,'default',0,'general/locale/weight_unit','kgs','2024-02-02 23:28:54'),(235,'default',0,'general/store_information/name',NULL,'2024-02-02 23:28:54'),(236,'default',0,'general/store_information/phone',NULL,'2024-02-02 23:28:54'),(237,'default',0,'general/store_information/hours',NULL,'2024-02-02 23:28:54'),(238,'default',0,'general/store_information/country_id',NULL,'2024-02-02 23:28:54'),(239,'default',0,'general/store_information/region_id',NULL,'2024-02-02 23:28:54'),(240,'default',0,'general/store_information/postcode',NULL,'2024-02-02 23:28:54'),(241,'default',0,'general/store_information/city',NULL,'2024-02-02 23:28:54'),(242,'default',0,'general/store_information/street_line1',NULL,'2024-02-02 23:28:54'),(243,'default',0,'general/store_information/street_line2',NULL,'2024-02-02 23:28:54'),(244,'default',0,'general/store_information/merchant_vat_number',NULL,'2024-02-02 23:28:54'),(245,'default',0,'general/single_store_mode/enabled','0','2024-02-02 23:28:54'),(246,'default',0,'currency/fixerio/api_key',NULL,'2024-02-02 23:30:00'),(247,'default',0,'currency/fixerio/timeout','100','2024-02-02 23:30:00'),(248,'default',0,'currency/currencyconverterapi/api_key',NULL,'2024-02-02 23:30:00'),(249,'default',0,'currency/currencyconverterapi/timeout','100','2024-02-02 23:30:00'),(250,'default',0,'web/url/redirect_to_base','0','2024-02-03 17:51:10'),(251,'default',0,'web/unsecure/base_link_url','https://coffeeculture.se/','2024-02-03 18:25:36'),(252,'default',0,'web/unsecure/base_static_url',NULL,'2024-02-03 17:51:10'),(253,'default',0,'web/unsecure/base_media_url',NULL,'2024-02-03 17:51:10'),(254,'default',0,'web/secure/base_url','https://coffeeculture.se/','2024-02-03 17:51:10'),(255,'default',0,'web/secure/base_link_url','https://coffeeculture.se/','2024-02-03 17:51:10'),(256,'default',0,'web/secure/base_static_url',NULL,'2024-02-04 18:15:40'),(257,'default',0,'web/secure/base_media_url',NULL,'2024-02-04 18:15:40'),(258,'default',0,'web/secure/use_in_frontend','1','2024-02-03 17:51:10'),(259,'default',0,'web/secure/use_in_adminhtml','1','2024-02-03 17:51:10'),(260,'default',0,'web/secure/enable_hsts','0','2024-02-03 17:51:10'),(261,'default',0,'web/secure/enable_upgrade_insecure','0','2024-02-03 17:51:10'),(262,'default',0,'web/default_layouts/default_product_layout',NULL,'2024-02-03 17:51:10'),(263,'default',0,'web/default_layouts/default_category_layout',NULL,'2024-02-03 17:51:10'),(264,'default',0,'web/default_layouts/default_cms_layout','1column','2024-02-03 17:51:10'),(265,'default',0,'web/cookie/cookie_path',NULL,'2024-02-03 17:51:10'),(266,'default',0,'web/cookie/cookie_domain',NULL,'2024-02-03 17:51:10'),(267,'default',0,'web/cookie/cookie_httponly','1','2024-02-03 17:51:10'),(268,'default',0,'system/full_page_cache/varnish/access_list','localhost','2024-02-03 18:28:32'),(269,'default',0,'system/full_page_cache/varnish/backend_host','localhost','2024-02-03 18:28:32'),(270,'default',0,'system/full_page_cache/varnish/backend_port','8080','2024-02-03 18:28:32'),(271,'default',0,'system/full_page_cache/varnish/grace_period','300','2024-02-03 18:28:32'),(272,'default',0,'system/mysqlmq/successful_messages_lifetime','10080','2024-02-03 19:58:36'),(273,'default',0,'system/mysqlmq/retry_inprogress_after','1440','2024-02-03 19:58:36'),(274,'default',0,'system/mysqlmq/failed_messages_lifetime','10080','2024-02-03 19:58:36'),(275,'default',0,'system/mysqlmq/new_messages_lifetime','10080','2024-02-03 19:58:36'),(276,'default',0,'system/smtp/set_return_path','0','2024-02-03 19:58:36'),(277,'default',0,'system/backup/functionality_enabled','1','2024-02-03 19:58:36'),(278,'default',0,'system/backup/enabled','1','2024-02-03 19:58:36'),(279,'default',0,'system/backup/type','snapshot','2024-02-03 19:58:36'),(280,'default',0,'system/backup/time','00,00,00','2024-02-03 19:58:36'),(281,'default',0,'system/backup/frequency','W','2024-02-03 19:58:36'),(282,'default',0,'crontab/default/jobs/system_backup/schedule/cron_expr','0 0 * * 1','2024-02-03 19:58:36'),(283,'default',0,'crontab/default/jobs/system_backup/run/model',NULL,'2024-02-03 19:58:36'),(284,'default',0,'system/backup/maintenance','0','2024-02-03 19:58:36'),(285,'default',0,'system/bulk/lifetime','60','2024-02-03 19:58:36'),(286,'default',0,'system/media_storage_configuration/media_storage','0','2024-02-03 19:58:36'),(287,'default',0,'adobe_stock/integration/enabled','1','2024-02-03 19:58:36'),(288,'default',0,'adobe_ims/integration/api_key',NULL,'2024-02-03 19:58:36'),(289,'default',0,'adobe_ims/integration/private_key',NULL,'2024-02-03 19:58:36'),(290,'default',0,'carriers/flatrate/handling_fee',NULL,'2024-02-03 20:33:46'),(291,'default',0,'carriers/flatrate/specificcountry',NULL,'2024-02-03 20:33:46'),(292,'default',0,'carriers/flatrate/showmethod','0','2024-02-03 20:33:46'),(293,'default',0,'carriers/flatrate/sort_order',NULL,'2024-02-03 20:33:46'),(294,'default',0,'carriers/postnord/active','1','2024-02-04 05:29:26'),(295,'default',0,'carriers/postnord/test_mode','1','2024-02-04 05:29:26'),(296,'default',0,'carriers/postnord/customer_id',NULL,'2024-02-03 20:56:36'),(297,'default',0,'carriers/postnord/client_id','websiteGY58iQRIojl9Au0B7MjhPtd','2024-02-04 05:29:26'),(298,'default',0,'carriers/postnord/client_secret','OqJHhXb7eNuqmpO1TE9moeXjgPt1BjHTdJCjeZtt','2024-02-04 05:29:26'),(299,'default',0,'carriers/postnord/test_client_id','websiteGY58iQRIojl9Au0B7MjhPtd','2024-02-04 05:29:26'),(300,'default',0,'carriers/postnord/test_client_secret','OqJHhXb7eNuqmpO1TE9moeXjgPt1BjHTdJCjeZtt','2024-02-04 05:29:26'),(301,'default',0,'carriers/postnord/dev_sort_order',NULL,'2024-02-03 20:33:46'),(302,'default',0,'carriers/freeshipping/free_shipping_subtotal',NULL,'2024-02-03 20:33:46'),(303,'default',0,'carriers/freeshipping/specificcountry',NULL,'2024-02-03 20:33:46'),(304,'default',0,'carriers/freeshipping/showmethod','0','2024-02-03 20:33:46'),(305,'default',0,'carriers/freeshipping/sort_order',NULL,'2024-02-03 20:33:46'),(306,'default',0,'carriers/tablerate/handling_fee',NULL,'2024-02-03 20:33:46'),(307,'default',0,'carriers/tablerate/specificcountry',NULL,'2024-02-03 20:33:46'),(308,'default',0,'carriers/tablerate/showmethod','0','2024-02-03 20:33:46'),(309,'default',0,'carriers/tablerate/sort_order',NULL,'2024-02-03 20:33:46'),(310,'default',0,'carriers/ups/shipper_number',NULL,'2024-02-03 20:33:46'),(311,'default',0,'carriers/ups/handling_fee',NULL,'2024-02-03 20:33:46'),(312,'default',0,'carriers/ups/free_shipping_enable','0','2024-02-03 20:33:46'),(313,'default',0,'carriers/ups/specificcountry',NULL,'2024-02-03 20:33:46'),(314,'default',0,'carriers/ups/showmethod','0','2024-02-03 20:33:46'),(315,'default',0,'carriers/ups/debug','0','2024-02-03 20:33:46'),(316,'default',0,'carriers/ups/sort_order',NULL,'2024-02-03 20:33:46'),(317,'default',0,'carriers/usps/userid',NULL,'2024-02-03 20:33:46'),(318,'default',0,'carriers/usps/password',NULL,'2024-02-03 20:33:46'),(319,'default',0,'carriers/usps/handling_fee',NULL,'2024-02-03 20:33:46'),(320,'default',0,'carriers/usps/free_shipping_enable','0','2024-02-03 20:33:46'),(321,'default',0,'carriers/usps/specificcountry',NULL,'2024-02-03 20:33:46'),(322,'default',0,'carriers/usps/debug','0','2024-02-03 20:33:46'),(323,'default',0,'carriers/usps/showmethod','0','2024-02-03 20:33:46'),(324,'default',0,'carriers/usps/sort_order',NULL,'2024-02-03 20:33:46'),(325,'default',0,'carriers/fedex/account',NULL,'2024-02-03 20:33:46'),(326,'default',0,'carriers/fedex/meter_number',NULL,'2024-02-03 20:33:46'),(327,'default',0,'carriers/fedex/key',NULL,'2024-02-03 20:33:46'),(328,'default',0,'carriers/fedex/password',NULL,'2024-02-03 20:33:46'),(329,'default',0,'carriers/fedex/handling_fee',NULL,'2024-02-03 20:33:46'),(330,'default',0,'carriers/fedex/residence_delivery','0','2024-02-03 20:33:46'),(331,'default',0,'carriers/fedex/smartpost_hubid',NULL,'2024-02-03 20:33:46'),(332,'default',0,'carriers/fedex/free_shipping_enable','0','2024-02-03 20:33:46'),(333,'default',0,'carriers/fedex/specificcountry',NULL,'2024-02-03 20:33:46'),(334,'default',0,'carriers/fedex/debug','0','2024-02-03 20:33:46'),(335,'default',0,'carriers/fedex/showmethod','0','2024-02-03 20:33:46'),(336,'default',0,'carriers/fedex/sort_order',NULL,'2024-02-03 20:33:46'),(337,'default',0,'carriers/dhl/id',NULL,'2024-02-03 20:33:46'),(338,'default',0,'carriers/dhl/password',NULL,'2024-02-03 20:33:46'),(339,'default',0,'carriers/dhl/handling_fee',NULL,'2024-02-03 20:33:46'),(340,'default',0,'carriers/dhl/free_method_nondoc',NULL,'2024-02-03 20:33:46'),(341,'default',0,'carriers/dhl/free_shipping_enable','0','2024-02-03 20:33:46'),(342,'default',0,'carriers/dhl/specificcountry',NULL,'2024-02-03 20:33:46'),(343,'default',0,'carriers/dhl/showmethod','0','2024-02-03 20:33:46'),(344,'default',0,'carriers/dhl/debug','0','2024-02-03 20:33:46'),(345,'default',0,'carriers/dhl/sandbox_mode','0','2024-02-03 20:33:46'),(346,'default',0,'carriers/dhl/sort_order',NULL,'2024-02-03 20:33:46'),(347,'default',0,'carriers/bring/active','1','2024-02-04 04:58:24'),(348,'default',0,'carriers/bring/title','Bring','2024-02-04 04:58:24'),(349,'default',0,'carriers/bring/organization',NULL,'2024-02-04 04:58:24'),(350,'default',0,'carriers/bring/handling_type','F','2024-02-04 04:58:24'),(351,'default',0,'carriers/bring/handling_fee',NULL,'2024-02-04 04:58:24'),(352,'default',0,'carriers/bring/bring_client_url','https://coffeeculture.se','2024-02-04 04:58:24'),(353,'default',0,'carriers/bring/mybring_client_uid',NULL,'2024-02-04 04:58:24'),(354,'default',0,'carriers/bring/mybring_api_key',NULL,'2024-02-04 04:58:24'),(355,'default',0,'carriers/bring/bring_product_rules','{\"_1707022617811_811\":{\"bring_product\":\"5600\",\"rule\":\"cart_weight\",\"comparison\":\"lt\",\"value\":\"\"},\"_1707022639055_55\":{\"bring_product\":\"5800\",\"rule\":\"cart_weight\",\"comparison\":\"lt\",\"value\":\"\"}}','2024-02-04 04:58:24'),(356,'default',0,'carriers/bring/enabled_methods','5800,5600','2024-02-04 04:58:24'),(357,'default',0,'carriers/bring/affected_free_shipping_methods',NULL,'2024-02-04 04:58:24'),(358,'default',0,'carriers/bring/free_shipping_method_enabled_discount_amount','0','2024-02-04 04:58:24'),(359,'default',0,'carriers/bring/sort_order',NULL,'2024-02-04 04:58:24'),(360,'default',0,'carriers/bring/calculation/custom_method_prices','[]','2024-02-04 04:58:24'),(361,'default',0,'carriers/bring/calculation/show_estimated_delivery','1','2024-02-04 04:58:24'),(362,'default',0,'carriers/bring/calculation/edi','1','2024-02-04 04:58:24'),(363,'default',0,'carriers/bring/calculation/posting_at_post_office','0','2024-02-04 04:58:24'),(364,'default',0,'carriers/bring/calculation/additional_services',NULL,'2024-02-04 04:58:24'),(365,'default',0,'carriers/bring/calculation/default_delivery_option','ONE_DELIVERY_THEN_PIB','2024-02-04 04:58:24'),(366,'default',0,'carriers/bring/calculation/default_customer',NULL,'2024-02-04 04:58:24'),(367,'default',0,'carriers/bring/booking/activate_booking','0','2024-02-04 04:58:24'),(368,'default',0,'carriers/bring/booking/origin/name',NULL,'2024-02-04 04:58:24'),(369,'default',0,'carriers/bring/booking/origin/country_id',NULL,'2024-02-04 04:58:24'),(370,'default',0,'carriers/bring/booking/origin/street_line_1',NULL,'2024-02-04 04:58:24'),(371,'default',0,'carriers/bring/booking/origin/street_line_2',NULL,'2024-02-04 04:58:24'),(372,'default',0,'carriers/bring/booking/origin/postcode',NULL,'2024-02-04 04:58:24'),(373,'default',0,'carriers/bring/booking/origin/city',NULL,'2024-02-04 04:58:24'),(374,'default',0,'carriers/bring/booking/origin/email',NULL,'2024-02-04 04:58:24'),(375,'default',0,'carriers/bring/booking/origin/phone_number',NULL,'2024-02-04 04:58:24'),(376,'default',0,'carriers/bring/package_management/ship_individually_attribute',NULL,'2024-02-04 04:58:24'),(377,'default',0,'carriers/bring/package_management/width_attribute',NULL,'2024-02-04 04:58:24'),(378,'default',0,'carriers/bring/package_management/length_attribute',NULL,'2024-02-04 04:58:24'),(379,'default',0,'carriers/bring/package_management/height_attribute',NULL,'2024-02-04 04:58:24'),(380,'default',0,'carriers/bring/package_management/standard_package_width','31','2024-02-04 04:58:24'),(381,'default',0,'carriers/bring/package_management/standard_package_length','21','2024-02-04 04:58:24'),(382,'default',0,'carriers/bring/package_management/standard_package_height','6','2024-02-04 04:58:24'),(383,'default',0,'carriers/flatrate/active','1','2024-02-04 05:18:13'),(384,'default',0,'trans_email/ident_support/email','sara@coffeeculture.se','2024-02-04 05:07:37'),(385,'default',0,'porto_license/general/purchase_code','ef5ad11d-b72f-4791-b768-c89bdc379464','2024-02-04 17:25:50'),(386,'default',0,'porto_license/general/purchase_code_confirm','ZWY1YWQxMWQtYjcyZi00NzkxLWI3NjgtYzg5YmRjMzc5NDY0','2024-02-04 17:25:53'),(387,'default',0,'design/theme/theme_id','4','2024-02-04 17:26:52'),(388,'default',0,'design/pagination/pagination_frame','5','2024-02-04 17:26:52'),(389,'default',0,'design/pagination/pagination_frame_skip',NULL,'2024-02-04 17:26:52'),(390,'default',0,'design/pagination/anchor_text_for_previous',NULL,'2024-02-04 17:26:52'),(391,'default',0,'design/pagination/anchor_text_for_next',NULL,'2024-02-04 17:26:52'),(392,'default',0,'design/head/default_title','Magento Commerce','2024-02-04 17:26:52'),(393,'default',0,'design/head/title_prefix',NULL,'2024-02-04 17:26:52'),(394,'default',0,'design/head/title_suffix',NULL,'2024-02-04 17:26:52'),(395,'default',0,'design/head/default_description',NULL,'2024-02-04 17:26:52'),(396,'default',0,'design/head/default_keywords',NULL,'2024-02-04 17:26:52'),(397,'default',0,'design/head/includes','<style>\n.home-banner-slider {\n    display: block;\n}\n</style>','2024-02-04 17:40:05'),(398,'default',0,'design/head/demonotice','0','2024-02-04 17:26:52'),(399,'default',0,'design/header/logo_width','110','2024-02-04 17:40:05'),(400,'default',0,'design/header/logo_height','43','2024-02-04 17:40:05'),(401,'default',0,'design/header/logo_alt',NULL,'2024-02-04 17:26:52'),(402,'default',0,'design/header/welcome','Default welcome msg!','2024-02-04 17:26:52'),(403,'default',0,'design/footer/copyright','Copyright © 2013-present Magento, Inc. All rights reserved.','2024-02-04 17:26:52'),(404,'default',0,'design/footer/absolute_footer',NULL,'2024-02-04 17:26:52'),(405,'default',0,'design/footer/report_bugs','1','2024-02-04 17:26:52'),(406,'default',0,'design/search_engine_robots/default_robots','INDEX,FOLLOW','2024-02-04 17:26:52'),(407,'default',0,'design/search_engine_robots/custom_instructions',NULL,'2024-02-04 17:26:52'),(408,'default',0,'design/watermark/image_size',NULL,'2024-02-04 17:26:52'),(409,'default',0,'design/watermark/image_imageOpacity',NULL,'2024-02-04 17:26:52'),(410,'default',0,'design/watermark/image_position','stretch','2024-02-04 17:26:52'),(411,'default',0,'design/watermark/small_image_size',NULL,'2024-02-04 17:26:52'),(412,'default',0,'design/watermark/small_image_imageOpacity',NULL,'2024-02-04 17:26:52'),(413,'default',0,'design/watermark/small_image_position','stretch','2024-02-04 17:26:52'),(414,'default',0,'design/watermark/thumbnail_size',NULL,'2024-02-04 17:26:52'),(415,'default',0,'design/watermark/thumbnail_imageOpacity',NULL,'2024-02-04 17:26:52'),(416,'default',0,'design/watermark/thumbnail_position','stretch','2024-02-04 17:26:52'),(417,'default',0,'design/email/logo_alt',NULL,'2024-02-04 17:26:52'),(418,'default',0,'design/email/logo_width',NULL,'2024-02-04 17:26:52'),(419,'default',0,'design/email/logo_height',NULL,'2024-02-04 17:26:52'),(420,'default',0,'design/email/header_template','design_email_header_template','2024-02-04 17:26:52'),(421,'default',0,'design/email/footer_template','design_email_footer_template','2024-02-04 17:26:52'),(422,'default',0,'web/default/cms_home_page','home','2024-02-04 18:32:07'),(423,'default',0,'web/default/cms_no_route','no-route-2','2024-02-04 17:40:05'),(424,'default',0,'cms/wysiwyg/enabled','enabled','2024-02-04 18:33:51'),(425,'default',0,'design/header/logo_src','default/logo_ecomblack_lg.png','2024-02-04 17:40:05'),(426,'default',0,'dev/js/merge_files','1','2024-02-04 17:40:05'),(427,'default',0,'layered_navigation/general/enable','1','2024-02-04 17:40:05'),(428,'default',0,'porto_settings/general/boxed','wide','2024-02-04 17:40:05'),(429,'default',0,'porto_settings/general/layout','1140','2024-02-04 17:40:05'),(430,'default',0,'porto_settings/general/show_site_notice',NULL,'2024-02-04 18:11:07'),(431,'default',0,'porto_settings/general/show_site_notice_button','1','2024-02-04 17:40:05'),(432,'default',0,'porto_settings/general/custom_notice_day','1','2024-02-04 17:40:05'),(433,'default',0,'porto_settings/general/custom_notice_block','porto_custom_notice','2024-02-04 17:40:05'),(434,'default',0,'porto_settings/general/category_list_on_left','0','2024-02-04 17:40:05'),(435,'default',0,'porto_settings/general/smartlayers','1','2024-02-04 17:40:05'),(436,'default',0,'porto_settings/general/sidebar_sticky','1','2024-02-04 17:40:05'),(437,'default',0,'porto_settings/header/header_type','24','2024-02-04 17:40:05'),(438,'default',0,'porto_settings/header/static_block_top','porto_custom_block_for_header_top9','2024-02-04 17:40:05'),(439,'default',0,'porto_settings/header/static_block','header_social_media','2024-02-04 17:40:05'),(440,'default',0,'porto_settings/header/sticky_header','1','2024-02-04 17:40:05'),(441,'default',0,'porto_settings/header/sticky_header_logo','0','2024-02-04 17:40:05'),(442,'default',0,'porto_settings/header/mobile_sticky_header','1','2024-02-04 17:40:05'),(443,'default',0,'porto_settings/header/currency_short','1','2024-02-04 17:40:05'),(444,'default',0,'porto_settings/header/language_flag','1','2024-02-04 17:40:05'),(445,'default',0,'porto_settings/footer/footer_top','1','2024-02-04 17:40:05'),(446,'default',0,'porto_settings/footer/footer_top_block','custom','2024-02-04 17:40:05'),(447,'default',0,'porto_settings/footer/footer_top_custom','footer_top_block12','2024-02-04 17:40:05'),(448,'default',0,'porto_settings/footer/footer_middle','1','2024-02-04 17:40:05'),(449,'default',0,'porto_settings/footer/footer_ribbon','0','2024-02-04 17:40:05'),(450,'default',0,'porto_settings/footer/footer_ribbon_text','Get in touch','2024-02-04 17:40:05'),(451,'default',0,'porto_settings/footer/footer_middle_column_1','custom','2024-02-04 17:40:05'),(452,'default',0,'porto_settings/footer/footer_middle_column_1_custom','footer_middle_customer_service2','2024-02-04 17:40:05'),(453,'default',0,'porto_settings/footer/footer_middle_column_1_size','2','2024-02-04 17:40:05'),(454,'default',0,'porto_settings/footer/footer_middle_column_2','custom','2024-02-04 17:40:05'),(455,'default',0,'porto_settings/footer/footer_middle_column_2_custom','footer_middle_my_account_2','2024-02-04 17:40:05'),(456,'default',0,'porto_settings/footer/footer_middle_column_2_size','3','2024-02-04 17:40:05'),(457,'default',0,'porto_settings/footer/footer_middle_column_3','custom','2024-02-04 17:40:05'),(458,'default',0,'porto_settings/footer/footer_middle_column_3_custom','footer_middle_more_information','2024-02-04 17:40:05'),(459,'default',0,'porto_settings/footer/footer_middle_column_3_size','3','2024-02-04 17:40:05'),(460,'default',0,'porto_settings/footer/footer_middle_column_4','custom','2024-02-04 17:40:05'),(461,'default',0,'porto_settings/footer/footer_middle_column_4_custom','footer_middle_follow_payment2','2024-02-04 17:40:05'),(462,'default',0,'porto_settings/footer/footer_middle_column_4_size','4','2024-02-04 17:40:05'),(463,'default',0,'porto_settings/footer/footer_middle_2','0','2024-02-04 17:40:05'),(464,'default',0,'porto_settings/footer/footer_middle_2_column_1','custom','2024-02-04 17:40:05'),(465,'default',0,'porto_settings/footer/footer_middle_2_column_1_custom',NULL,'2024-02-04 17:40:05'),(466,'default',0,'porto_settings/footer/footer_middle_2_column_1_size','3','2024-02-04 17:40:05'),(467,'default',0,'porto_settings/footer/footer_middle_2_column_2','custom','2024-02-04 17:40:05'),(468,'default',0,'porto_settings/footer/footer_middle_2_column_2_custom',NULL,'2024-02-04 17:40:05'),(469,'default',0,'porto_settings/footer/footer_middle_2_column_2_size','3','2024-02-04 17:40:05'),(470,'default',0,'porto_settings/footer/footer_middle_2_column_3','custom','2024-02-04 17:40:05'),(471,'default',0,'porto_settings/footer/footer_middle_2_column_3_custom',NULL,'2024-02-04 17:40:05'),(472,'default',0,'porto_settings/footer/footer_middle_2_column_3_size','3','2024-02-04 17:40:05'),(473,'default',0,'porto_settings/footer/footer_middle_2_column_4','custom','2024-02-04 17:40:05'),(474,'default',0,'porto_settings/footer/footer_middle_2_column_4_custom',NULL,'2024-02-04 17:40:05'),(475,'default',0,'porto_settings/footer/footer_middle_2_column_4_size','3','2024-02-04 17:40:05'),(476,'default',0,'porto_settings/footer/footer_bottom','1','2024-02-04 17:40:05'),(477,'default',0,'porto_settings/footer/footer_store_switcher','0','2024-02-04 17:40:05'),(478,'default',0,'porto_settings/footer/footer_logo_src',NULL,'2024-02-04 17:40:05'),(479,'default',0,'porto_settings/footer/footer_bottom_copyrights','© Porto Magento 2023. All Rights Reserved.','2024-02-04 17:40:05'),(480,'default',0,'porto_settings/footer/footer_bottom_custom_1',NULL,'2024-02-04 17:40:05'),(481,'default',0,'porto_settings/footer/footer_bottom_custom_2',NULL,'2024-02-04 17:40:05'),(482,'default',0,'porto_settings/category/alternative_image','1','2024-02-04 17:40:05'),(483,'default',0,'porto_settings/category/aspect_ratio','0','2024-02-04 17:40:05'),(484,'default',0,'porto_settings/category/ratio_width','300','2024-02-04 17:40:05'),(485,'default',0,'porto_settings/category/ratio_height','300','2024-02-04 17:40:05'),(486,'default',0,'porto_settings/category/rating_star','1','2024-02-04 17:40:05'),(487,'default',0,'porto_settings/category/product_price','1','2024-02-04 17:40:05'),(488,'default',0,'porto_settings/category/actions','1','2024-02-04 17:40:05'),(489,'default',0,'porto_settings/category/addtocompare','1','2024-02-04 17:40:05'),(490,'default',0,'porto_settings/category/addtowishlist','1','2024-02-04 17:40:05'),(491,'default',0,'porto_settings/category/qty_field','0','2024-02-04 17:40:05'),(492,'default',0,'porto_settings/category/page_layout','2columns-left','2024-02-04 17:40:05'),(493,'default',0,'porto_settings/category/category_description','full_width','2024-02-04 17:40:05'),(494,'default',0,'porto_settings/category/side_custom_block','porto_category_side_custom_block','2024-02-04 17:40:05'),(495,'default',0,'porto_settings/category_grid/product_type','3','2024-02-04 17:40:05'),(496,'default',0,'porto_settings/category_grid/columns','3','2024-02-04 17:40:05'),(497,'default',0,'porto_settings/category_grid/xs_one_column','0','2024-02-04 17:40:05'),(498,'default',0,'porto_settings/category_grid/infinite_scroller','0','2024-02-04 17:40:05'),(499,'default',0,'porto_settings/product/aspect_ratio','0','2024-02-04 17:40:05'),(500,'default',0,'porto_settings/product/ratio_width','500','2024-02-04 17:40:05'),(501,'default',0,'porto_settings/product/ratio_height','500','2024-02-04 17:40:05'),(502,'default',0,'porto_settings/product/product_image_size','5','2024-02-04 17:40:05'),(503,'default',0,'porto_settings/product/product_page_type',NULL,'2024-02-04 17:40:05'),(504,'default',0,'porto_settings/product/main_custom_block',NULL,'2024-02-04 17:40:05'),(505,'default',0,'porto_settings/product/side_custom_block','porto_product_side_custom_block','2024-02-04 17:40:05'),(506,'default',0,'porto_settings/product/page_layout','1column','2024-02-04 17:40:05'),(507,'default',0,'porto_settings/product/upsell_columns','4','2024-02-04 17:40:05'),(508,'default',0,'porto_settings/product/move_upsell','0','2024-02-04 17:40:05'),(509,'default',0,'porto_settings/product/move_upsell_full','1','2024-02-04 17:40:05'),(510,'default',0,'porto_settings/product/move_addtolinks','1','2024-02-04 17:40:05'),(511,'default',0,'porto_settings/product/tab_full_background','0','2024-02-04 17:40:05'),(512,'default',0,'porto_settings/product/custom_block_next_tab',NULL,'2024-02-04 17:40:05'),(513,'default',0,'porto_settings/newsletter/delay','10000','2024-02-04 17:40:05'),(514,'default',0,'porto_settings/newsletter/logo_src','default/logo_ecomblack_lg.png','2024-02-04 17:40:05'),(515,'default',0,'porto_settings/newsletter/content','<h3 style=\"font-size: 1.125rem;line-height: 1.2\" class=\"vc_custom_heading mb-2 align-left text-uppercase\">Subscribe To Newsletter</h3>\r\n<p style=\"font-size: 0.875rem;line-height: 1.8571;letter-spacing:-.02em\" class=\"vc_custom_heading mb-4 align-left\">Subscribe to the Porto mailing list to receive updates on new arrivals, special offers and our promotions.</p>','2024-02-04 18:11:07'),(516,'default',0,'porto_settings/newsletter/width','740px','2024-02-04 17:40:05'),(517,'default',0,'porto_settings/newsletter/height','320px','2024-02-04 17:40:05'),(518,'default',0,'porto_settings/contacts/enable','0','2024-02-04 18:11:07'),(519,'default',0,'porto_settings/contacts/full_width','0','2024-02-04 17:40:05'),(520,'default',0,'porto_settings/contacts/address','Porto2 Store','2024-02-04 17:40:05'),(521,'default',0,'porto_settings/contacts/latitude','-34.398','2024-02-04 17:40:05'),(522,'default',0,'porto_settings/contacts/longitude','150.884','2024-02-04 17:40:05'),(523,'default',0,'porto_settings/contacts/zoom','18','2024-02-04 17:40:05'),(524,'default',0,'porto_settings/contacts/infoblock','<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n    <i class=\"porto-icon-phone\"></i>\r\n    <p>0201 203 2032</p>\r\n    <p>0201 203 2032</p>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n    <i class=\"porto-icon-mobile\"></i>\r\n    <p>201-123-3922</p>\r\n    <p>302-123-3928</p>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n    <i class=\"porto-icon-mail-alt\"></i>\r\n    <p>porto@gmail.com</p>\r\n    <p>porto@portotemplate.com</p>\r\n</div>\r\n</div>\r\n<div class=\"row\">\r\n<div class=\"col-md-12\">\r\n    <i class=\"porto-icon-skype\"></i>\r\n    <p>porto_skype</p>\r\n    <p>proto_template</p>\r\n</div>\r\n</div>','2024-02-04 18:11:07'),(525,'default',0,'porto_settings/contacts/customblock',NULL,'2024-02-04 17:40:05'),(526,'default',0,'porto_settings/custom_settings/custom_google_fonts','@import url(\'https://fonts.googleapis.com/css2?family=Spectral+SC:ital,wght@0,200;0,300;0,400;0,500;0,600;0,700;0,800;1,200;1,300;1,400;1,500;1,600;1,700;1,800&display=swap\');','2024-02-04 17:40:05'),(527,'default',0,'porto_settings/custom_settings/custom_style','body,li {\r\n    line-height: 24px;\r\n}\r\np {\r\n    line-height: inherit;\r\n    letter-spacing: 0;\r\n}\r\n@media (max-width: 575px){\r\nbody {\r\n    font-size: 13px;\r\n    line-height: 21px;\r\n}\r\n}\r\nh1, h2, h3, h4, h5, h6 {\r\n    color: #222529;\r\n    letter-spacing: normal;\r\n}\r\nh1 {\r\n   font-family: Spectral SC;\r\n    font-weight: 400;\r\n    font-size: 36px;\r\n    line-height: 44px;\r\n    letter-spacing: -0.05em;\r\n    margin: 0 0 32px 0;\r\n}\r\nh2 {\r\n    font-family: Spectral SC;\r\n    font-weight: 400;\r\n    font-size: 30px;\r\n    line-height: 40px;\r\n    letter-spacing: -0.05em;\r\n    margin: 0 0 32px 0;\r\n}\r\nh3 {\r\n    font-family: Poppins;\r\n    font-weight: 400;\r\n    font-size: 25px;\r\n    line-height: 32px;\r\n    letter-spacing: -0.05em;\r\n    margin: 0 0 20px 0;\r\n}\r\nh4 {\r\n    font-family: Spectral SC;\r\n    font-weight: 400;\r\n    font-size: 20px;\r\n    line-height: 20px;\r\n    letter-spacing: -0.05em;\r\n    margin: 0 0 14px 0;\r\n}\r\nh5 {\r\n    font-family: Poppins;\r\n    font-weight: 400;\r\n    font-size: 14px;\r\n    line-height: 18px;\r\n    letter-spacing: -0.05em;\r\n    margin: 0 0 14px 0;\r\n}\r\nh6 {\r\n    font-family: Poppins;\r\n    font-weight: 400;\r\n    font-size: 14px;\r\n    line-height: 18px;\r\n    letter-spacing: -0.05em;\r\n    margin: 0 0 14px 0;\r\n}\r\nhtml .heading-secondary, html .lnk-secondary, html .text-color-secondary {\r\n    color: #ff7272;\r\n}\r\nhtml .action.primary, html .btn {\r\n    font-family: Poppins;\r\n    letter-spacing: normal;\r\n    font-weight: 700;\r\n    line-height: 1.42857;\r\n    padding: .8em 2em;\r\n    border: 1px solid transparent;\r\n    border-radius: 0;\r\n}\r\nhtml .btn-modern {\r\n    text-transform: uppercase;\r\n    font-size: .75rem;\r\n    padding: .75rem 1.5rem;\r\n    font-weight: 600;\r\n    height: auto;\r\n}\r\nhtml .action.primary {\r\n    color: #fff;\r\n    background-color: #9a2948;\r\n    border-color: #9a2948 #9a2948 #9a2948;\r\n}\r\n.btn-default.btn {\r\n    background: #fff;\r\n    box-shadow: none;\r\n    border-color: rgba(0,0,0,0.08);\r\n    border-bottom-color: rgba(0,0,0,.2);\r\n    color: #212529;\r\n}\r\nhtml .btn-xl {\r\n    font-size: 1rem;\r\n    padding: .8rem 2rem;\r\n}\r\nhtml .btn-lg {\r\n    line-height: 1.3333;\r\n    border-radius: 0;\r\n}\r\n.btn-modern.btn-xl {\r\n    font-size: 1rem;\r\n    padding: 1.25em 3.125em;\r\n}\r\n.btn-flat {\r\n    padding: 0!important;\r\n    background: none!important;\r\n    border: none!important;\r\n    border-bottom: 1px solid transparent!important;\r\n    box-shadow: none!important;\r\n    text-transform: uppercase;\r\n    font-size: .75rem;\r\n}\r\nhtml .btn-dark {\r\n    color: #fff;\r\n    background-color: #222529;\r\n    border-color: #222529 #222529 #0b0c0e;\r\n}\r\nhtml .btn-light {\r\n    color: #212529;\r\n    background-color: #fff;\r\n    border-color: #fff #fff #e6e6e6;\r\n}\r\nhtml .btn-quaternary {\r\n    color: #fff;\r\n    background-color: #000;\r\n    border-color: #000 #000 #000;\r\n}\r\nhtml .background-color-secondary {\r\n    background-color: #f4a085 !important;\r\n}\r\n.me-2 {\r\n    margin-right: 0.5rem !important;\r\n}\r\n.ms-1 {\r\n    margin-left: 0.25rem !important;\r\n}\r\n.p-t-xs {\r\n    padding-top: 5px!important;\r\n}\r\n.m-t-sm {\r\n    margin-top: 10px!important;\r\n}\r\n.p-b-xs {\r\n    padding-bottom: 5px!important;\r\n}\r\n.porto-u-heading {\r\n    margin-bottom: 17px;\r\n}\r\n@media (min-width: 768px){\r\n.text-md-start {\r\n    text-align: left !important;\r\n}\r\n.me-md-3 {\r\n    margin-right: 1rem !important;\r\n}\r\n}\r\n@media (min-width: 992px){\r\n.text-lg-end {\r\n    text-align: right !important;\r\n}\r\n.ms-lg-auto {\r\n    margin-left: auto !important;\r\n}\r\n}\r\n.font-weight-extra-bold {\r\n    font-weight: 800;\r\n}\r\n.porto-icon-shopping-cart:before {\r\n    content: \'\\e80d\';\r\n}\r\n.minicart-wrapper .action.showcart .minicart-icon {\r\n    right: 0;\r\n    left: 0;\r\n}\r\n.header.content, .main-panel-top .container {\r\n    max-width: 100%;\r\n    padding-left: 2.77vw;\r\n    padding-right: 2.77vw;\r\n}\r\n.page-header.type24 .header.panel {\r\n    font-family: Spectral SC,sans-serif;\r\n}\r\n@media (min-width: 992px) {\r\n.page-header.type24 .navigation:not(.side-megamenu) > ul,.page-header.type24 .minicart-wrapper .action-subtotal {\r\n    font-family: Spectral SC,sans-serif;\r\n}\r\n.page-header.type24 .minicart-wrapper .action-subtotal .cart-price {\r\n    font-family: \'Poppins\';\r\n}\r\n}\r\n.rtl .page-header.type24 .header-right > * {\r\n    margin-right: 1.125rem;\r\n    margin-left: 0;\r\n}\r\n.rtl .page-header.type24 .header-right > *:firt-child {\r\n    margin-right: 0;\r\n}\r\n.page-header.type24 .header-contact > *:not(:first-child) {\r\n    margin-left: 1.125rem;\r\n}\r\n.rtl .page-header.type24 .header-contact > *:not(:first-child) {\r\n    margin-right: 1.125rem !important;\r\n    margin-left: 0;\r\n}\r\n.page-wrapper > .breadcrumbs .items {\r\n    position: relative;\r\n    margin-bottom: 35px;\r\n    padding-bottom: 13px;\r\n}\r\n.page-wrapper > .breadcrumbs .items:after {\r\n    content: \'\';\r\n    position: absolute;\r\n    left: 10px;\r\n    right: 10px;\r\n    bottom: 0;\r\n    border-bottom: 1px solid #e7e7e7;\r\n}\r\n.checkout-cart-index .page-title-wrapper .page-title {\r\n    font-family: inherit;\r\n    font-style: inherit;\r\n}\r\n.top-icon .porto-sicon-header {\r\n    margin-bottom: .75rem;\r\n}\r\nhtml .background-color-secondary {\r\n    background-color: #ff7272!important;\r\n}\r\n.side-custom-block .custom-block h2 {\r\n    font-size: inherit;\r\n    font-family: inherit;\r\n    font-style: inherit;\r\n}\r\n.main-upsell-product-detail {\r\n    margin-bottom: 30px;\r\n}\r\n.footer, .footer p {\r\n    line-height: 25px;\r\n    letter-spacing: 0;\r\n}\r\n.footer .widgettitle, .footer .widget-title {\r\n    font-size: 15px;\r\n    color: #222529;\r\n    line-height: 1;\r\n    font-weight: 800;\r\n    letter-spacing: 0;\r\n    font-family: \'SPECTRAL SC\';\r\n}\r\n.footer-top {\r\n    padding-bottom: 40px;\r\n}\r\n.footer-top .custom-block:before,.footer-top .custom-block:after {\r\n    margin-bottom: 0;\r\n    border: none;\r\n    margin-top: 0;\r\n}\r\n.footer-middle > .container::before {\r\n    content: \'\';\r\n    display: block;\r\n    position: static;\r\n    left: 10px;\r\n    top: 0;\r\n    right: 10px;\r\n    border-top: 1px solid #e7e7e7;\r\n    margin-bottom: 2.5rem;\r\n}\r\n.footer-middle > .container::after {\r\n     border-color:#e7e7e7;\r\n     margin-top: .625rem;\r\n     position: static;\r\n}\r\n.footer .block.newsletter .form.subscribe {\r\n    margin-left: 34px;\r\n    width: auto;\r\n}\r\n.footer .newsletter input {\r\n    height: 51px;\r\n    padding-left: 1.25rem;\r\n    background: #f4f4f4;\r\n    border-radius: 0;\r\n}\r\n.footer .newsletter .action.subscribe {\r\n    height: 51px;\r\n    font-weight: 600;\r\n    border-radius: 0;\r\n    border: none;\r\n    letter-spacing: 0;\r\n    margin-left: 10px;\r\n    font-size: 13px;\r\n}\r\n.footer .widget>div>ul li {\r\n    margin-bottom: .625rem;\r\n}\r\n.footer-middle > .container {\r\n    padding-top: 0;\r\n    padding-bottom: 0;\r\n}\r\n.footer-bottom address {\r\n    text-align: center;\r\n}\r\n.footer-bottom {\r\n    font-size: 1em;\r\n}','2024-02-04 18:11:07'),(528,'default',0,'porto_settings/custom_settings/custom_style_2',NULL,'2024-02-04 18:11:07'),(529,'default',0,'porto_design/general/theme_color','#9a2948','2024-02-04 17:40:05'),(530,'default',0,'porto_design/font/custom','1','2024-02-04 17:40:05'),(531,'default',0,'porto_design/font/font_size','14px','2024-02-04 17:40:05'),(532,'default',0,'porto_design/font/font_family','google','2024-02-04 17:40:05'),(533,'default',0,'porto_design/font/custom_font_family',NULL,'2024-02-04 17:40:05'),(534,'default',0,'porto_design/font/google_font_family','Poppins','2024-02-04 17:40:05'),(535,'default',0,'porto_design/font/char_latin_ext',NULL,'2024-02-04 17:40:05'),(536,'default',0,'porto_design/font/char_subset',NULL,'2024-02-04 17:40:05'),(537,'default',0,'porto_design/colors/custom','1','2024-02-04 17:40:05'),(538,'default',0,'porto_design/colors/text_color',NULL,'2024-02-04 17:40:05'),(539,'default',0,'porto_design/colors/link_color',NULL,'2024-02-04 17:40:05'),(540,'default',0,'porto_design/colors/link_hover_color',NULL,'2024-02-04 17:40:06'),(541,'default',0,'porto_design/colors/button_bg_color',NULL,'2024-02-04 17:40:06'),(542,'default',0,'porto_design/colors/button_text_color',NULL,'2024-02-04 17:40:06'),(543,'default',0,'porto_design/colors/button_hover_bg_color',NULL,'2024-02-04 17:40:06'),(544,'default',0,'porto_design/colors/button_hover_text_color',NULL,'2024-02-04 17:40:06'),(545,'default',0,'porto_design/colors/breadcrumbs_bg_color','FFFFFF','2024-02-04 17:40:06'),(546,'default',0,'porto_design/colors/breadcrumbs_color','#222529','2024-02-04 17:40:06'),(547,'default',0,'porto_design/colors/breadcrumbs_links_color','#222529','2024-02-04 17:40:06'),(548,'default',0,'porto_design/colors/breadcrumbs_links_hover_color','#222529','2024-02-04 17:40:06'),(549,'default',0,'porto_design/colors/sale_bg_color',NULL,'2024-02-04 17:40:06'),(550,'default',0,'porto_design/colors/sale_font_color',NULL,'2024-02-04 17:40:06'),(551,'default',0,'porto_design/colors/new_bg_color',NULL,'2024-02-04 17:40:06'),(552,'default',0,'porto_design/colors/new_font_color',NULL,'2024-02-04 17:40:06'),(553,'default',0,'porto_design/colors/price_slider_bg_color','#eee','2024-02-04 17:40:06'),(554,'default',0,'porto_design/colors/price_slider_handle_color','#9a2948','2024-02-04 17:40:06'),(555,'default',0,'porto_design/header/custom','1','2024-02-04 17:40:06'),(556,'default',0,'porto_design/header/notice_bgcolor','dark','2024-02-04 17:40:06'),(557,'default',0,'porto_design/header/notice_text_color','light','2024-02-04 17:40:06'),(558,'default',0,'porto_design/header/header_bgcolor','#FFFFFF','2024-02-04 17:40:06'),(559,'default',0,'porto_design/header/header_bg_image',NULL,'2024-02-04 17:40:06'),(560,'default',0,'porto_design/header/header_bordercolor',NULL,'2024-02-04 17:40:06'),(561,'default',0,'porto_design/header/header_textcolor','#222529','2024-02-04 17:40:06'),(562,'default',0,'porto_design/header/header_linkcolor','#222529','2024-02-04 17:40:06'),(563,'default',0,'porto_design/header/header_top_links_bgcolor','#9a2948','2024-02-04 17:40:06'),(564,'default',0,'porto_design/header/header_top_links_color','#fff','2024-02-04 17:40:06'),(565,'default',0,'porto_design/header/header_menu_bgcolor','#FFFFFF','2024-02-04 17:40:06'),(566,'default',0,'porto_design/header/header_menu_color','#333','2024-02-04 17:40:06'),(567,'default',0,'porto_design/header/header_menu_hover_bgcolor','#FFFFFF','2024-02-04 17:40:06'),(568,'default',0,'porto_design/header/header_menu_hover_color','#9a2948','2024-02-04 17:40:06'),(569,'default',0,'porto_design/header/header_sidemenu_color','#333','2024-02-04 17:40:06'),(570,'default',0,'porto_design/header/header_sidemenu_hover_bgcolor','#fff','2024-02-04 17:40:06'),(571,'default',0,'porto_design/header/header_sidemenu_hover_color','#9a2948','2024-02-04 17:40:06'),(572,'default',0,'porto_design/header/header_menu_classicmenu_bgcolor',NULL,'2024-02-04 17:40:06'),(573,'default',0,'porto_design/header/header_menu_classicmenu_bordercolor',NULL,'2024-02-04 17:40:06'),(574,'default',0,'porto_design/header/header_menu_classicmenu_color','#696969','2024-02-04 17:40:06'),(575,'default',0,'porto_design/header/header_menu_classicmenu_hover_bgcolor','#f4f4f4','2024-02-04 17:40:06'),(576,'default',0,'porto_design/header/header_menu_classicmenu_hover_color','#696969','2024-02-04 17:40:06'),(577,'default',0,'porto_design/header/header_menu_megamenu_bgcolor',NULL,'2024-02-04 17:40:06'),(578,'default',0,'porto_design/header/header_menu_megamenu_bordercolor',NULL,'2024-02-04 17:40:06'),(579,'default',0,'porto_design/header/header_menu_megamenu_color','#696969','2024-02-04 17:40:06'),(580,'default',0,'porto_design/header/header_menu_megamenu_hover_color','#696969','2024-02-04 17:40:06'),(581,'default',0,'porto_design/header/header_search_bgcolor','#f7f7f7','2024-02-04 17:40:06'),(582,'default',0,'porto_design/header/header_search_text_color','#8d8d8d','2024-02-04 17:40:06'),(583,'default',0,'porto_design/header/header_search_bordercolor','#e7e7e7','2024-02-04 17:40:06'),(584,'default',0,'porto_design/header/header_minicart_design','1','2024-02-04 17:40:06'),(585,'default',0,'porto_design/header/header_minicart_popup_design','2','2024-02-04 17:40:06'),(586,'default',0,'porto_design/header/header_minicart_color','#FFFFFF','2024-02-04 17:40:06'),(587,'default',0,'porto_design/header/header_minicart_icon_color','#222529','2024-02-04 17:40:06'),(588,'default',0,'porto_design/footer/custom','1','2024-02-04 17:40:06'),(589,'default',0,'porto_design/footer/footer_top_bgcolor','#fff','2024-02-04 17:40:06'),(590,'default',0,'porto_design/footer/footer_top_color','#90969a','2024-02-04 17:40:06'),(591,'default',0,'porto_design/footer/footer_top_link_color','#90969a','2024-02-04 17:40:06'),(592,'default',0,'porto_design/footer/footer_top_link_hover_color','#9a2948','2024-02-04 17:40:06'),(593,'default',0,'porto_design/footer/footer_middle_bgcolor','#fff','2024-02-04 17:40:06'),(594,'default',0,'porto_design/footer/footer_middle_color','#777777','2024-02-04 17:40:06'),(595,'default',0,'porto_design/footer/footer_middle_link_color','#777777','2024-02-04 17:40:06'),(596,'default',0,'porto_design/footer/footer_middle_link_hover_color','#9a2948','2024-02-04 17:40:06'),(597,'default',0,'porto_design/footer/footer_middle_title_color','#222529','2024-02-04 17:40:06'),(598,'default',0,'porto_design/footer/footer_middle_links_icon_color','#777777','2024-02-04 17:40:06'),(599,'default',0,'porto_design/footer/footer_middle_ribbon_bgcolor','#9a2948','2024-02-04 17:40:06'),(600,'default',0,'porto_design/footer/footer_middle_ribbon_shadow_color','#9a2948','2024-02-04 17:40:06'),(601,'default',0,'porto_design/footer/footer_middle_ribbon_color','FFFFFF','2024-02-04 17:40:06'),(602,'default',0,'porto_design/footer/footer_middle_2_bgcolor',NULL,'2024-02-04 17:40:06'),(603,'default',0,'porto_design/footer/footer_middle_2_color',NULL,'2024-02-04 17:40:06'),(604,'default',0,'porto_design/footer/footer_middle_2_link_color',NULL,'2024-02-04 17:40:06'),(605,'default',0,'porto_design/footer/footer_middle_2_link_hover_color',NULL,'2024-02-04 17:40:06'),(606,'default',0,'porto_design/footer/footer_middle_2_title_color',NULL,'2024-02-04 17:40:06'),(607,'default',0,'porto_design/footer/footer_middle_2_links_icon_color',NULL,'2024-02-04 17:40:06'),(608,'default',0,'porto_design/footer/footer_bottom_bgcolor','#fff','2024-02-04 17:40:06'),(609,'default',0,'porto_design/footer/footer_bottom_color','#777','2024-02-04 17:40:06'),(610,'default',0,'porto_design/footer/footer_bottom_link_color','#777','2024-02-04 17:40:06'),(611,'default',0,'porto_design/footer/footer_bottom_link_hover_color','#9a2948','2024-02-04 17:40:06'),(612,'default',0,'porto_design/page/custom','0','2024-02-04 17:40:06'),(613,'default',0,'porto_design/page/page_bgcolor',NULL,'2024-02-04 17:40:06'),(614,'default',0,'porto_design/page/page_bg_image',NULL,'2024-02-04 17:40:06'),(615,'default',0,'porto_design/page/page_custom_style','','2024-02-04 17:40:06'),(616,'default',0,'porto_design/main/custom','0','2024-02-04 17:40:06'),(617,'default',0,'porto_design/main/main_bgcolor',NULL,'2024-02-04 17:40:06'),(618,'default',0,'porto_design/main/main_bg_image',NULL,'2024-02-04 17:40:06'),(619,'default',0,'porto_design/main/main_custom_style','','2024-02-04 17:40:06'),(620,'default',0,'mpsearch/general/enabled','1','2024-02-04 17:40:06'),(621,'default',0,'mpsearch/general/search_version_file','1','2024-02-04 17:55:19'),(622,'default',0,'porto_settings/general/boxed_custom_style',NULL,'2024-02-04 18:11:07'),(623,'default',0,'porto_settings/general/sidebar_second_block',NULL,'2024-02-04 18:11:07'),(624,'default',0,'porto_settings/optimization/bootstrap','0','2024-02-04 18:11:07'),(625,'default',0,'porto_settings/optimization/animate','0','2024-02-04 18:11:07'),(626,'default',0,'porto_settings/optimization/lazyload','0','2024-02-04 18:11:07'),(627,'default',0,'porto_settings/header/header23_text',NULL,'2024-02-04 18:11:07'),(628,'default',0,'porto_settings/header/compare_link','0','2024-02-04 18:11:07'),(629,'default',0,'porto_settings/header/login_popup','0','2024-02-04 18:11:07'),(630,'default',0,'porto_settings/footer/footer_newsletter_title','Be the First to Know','2024-02-04 18:11:07'),(631,'default',0,'porto_settings/footer/footer_newsletter_text','Get all the latest information on Events,<br/>Sales and Offers. Sign up for newsletter today.','2024-02-04 18:11:07'),(632,'default',0,'porto_settings/product/disable_zoom','0','2024-02-04 18:11:07'),(633,'default',0,'porto_settings/product/vertical_thumbnail','0','2024-02-04 18:11:07'),(634,'default',0,'porto_settings/product/prev_text','<em class=\"porto-icon-left-open\"></em>','2024-02-04 18:11:07'),(635,'default',0,'porto_settings/product/next_text','<em class=\"porto-icon-right-open\"></em>','2024-02-04 18:11:07'),(636,'default',0,'porto_settings/product/prev_next','1','2024-02-04 18:11:07'),(637,'default',0,'porto_settings/product/enable_addtocart_sticky','0','2024-02-04 18:11:07'),(638,'default',0,'porto_settings/product/tab_style',NULL,'2024-02-04 18:11:07'),(639,'default',0,'porto_settings/product/move_tab','0','2024-02-04 18:11:07'),(640,'default',0,'porto_settings/product/move_related','0','2024-02-04 18:11:07'),(641,'default',0,'porto_settings/product/custom_cms_tabs','a:0:{}','2024-02-04 18:11:07'),(642,'default',0,'porto_settings/product/custom_attr_tabs','a:0:{}','2024-02-04 18:11:07'),(643,'default',0,'porto_settings/richsnippets/enable','0','2024-02-04 18:11:07'),(644,'default',0,'porto_settings/product_label/new_label','1','2024-02-04 18:11:07'),(645,'default',0,'porto_settings/product_label/new_label_text','NEW','2024-02-04 18:11:07'),(646,'default',0,'porto_settings/product_label/sale_label','1','2024-02-04 18:11:07'),(647,'default',0,'porto_settings/product_label/sale_label_percent','1','2024-02-04 18:11:07'),(648,'default',0,'porto_settings/newsletter/enable','0','2024-02-04 18:11:07'),(649,'default',0,'porto_settings/newsletter/bg_color',NULL,'2024-02-04 18:11:07'),(650,'default',0,'porto_settings/newsletter/custom_style',NULL,'2024-02-04 18:11:07'),(651,'default',0,'porto_settings/newsletter/bg_image',NULL,'2024-02-04 18:11:07'),(652,'default',0,'porto_settings/contacts/api_key',NULL,'2024-02-04 18:11:07'),(653,'default',0,'porto_settings/install/demo_version','0','2024-02-04 18:11:07'),(654,'default',0,'porto_settings/install/overwrite_blocks','0','2024-02-04 18:11:07'),(655,'default',0,'porto_settings/install/overwrite_pages','0','2024-02-04 18:11:07'),(656,'default',0,'web/default/front','cms','2024-02-04 18:16:25'),(657,'default',0,'cms/wysiwyg/editor','mage/adminhtml/wysiwyg/tiny_mce/tinymce4Adapter','2024-02-04 18:33:51'),(658,'default',0,'cms/wysiwyg/use_static_urls_in_catalog','0','2024-02-04 18:33:51');

--
-- Table structure for table `cron_schedule`
--

CREATE TABLE `cron_schedule` (
  `schedule_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Schedule ID',
  `job_code` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Job Code',
  `status` varchar(7) NOT NULL DEFAULT 'pending' COMMENT 'Status',
  `messages` text COMMENT 'Messages',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `scheduled_at` timestamp NULL DEFAULT NULL COMMENT 'Scheduled At',
  `executed_at` timestamp NULL DEFAULT NULL COMMENT 'Executed At',
  `finished_at` timestamp NULL DEFAULT NULL COMMENT 'Finished At',
  PRIMARY KEY (`schedule_id`),
  KEY `CRON_SCHEDULE_JOB_CODE` (`job_code`),
  KEY `CRON_SCHEDULE_SCHEDULED_AT_STATUS` (`scheduled_at`,`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Cron Schedule';

--
-- Dumping data for table `cron_schedule`
--


--
-- Table structure for table `customer_address_entity`
--

CREATE TABLE `customer_address_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent ID',
  `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',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `country_id` varchar(255) NOT NULL COMMENT 'Country',
  `fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
  `firstname` varchar(255) NOT NULL COMMENT 'First Name',
  `lastname` varchar(255) NOT NULL COMMENT 'Last Name',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name',
  `postcode` varchar(255) DEFAULT NULL COMMENT 'Zip/Postal Code',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix',
  `region` varchar(255) DEFAULT NULL COMMENT 'State/Province',
  `region_id` int(10) unsigned DEFAULT NULL COMMENT 'State/Province',
  `street` text NOT NULL COMMENT 'Street Address',
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix',
  `telephone` varchar(255) NOT NULL COMMENT 'Phone Number',
  `vat_id` varchar(255) DEFAULT NULL COMMENT 'VAT number',
  `vat_is_valid` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validity',
  `vat_request_date` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request date',
  `vat_request_id` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request ID',
  `vat_request_success` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validation request success',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_PARENT_ID` (`parent_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity';

--
-- Dumping data for table `customer_address_entity`
--


--
-- Table structure for table `customer_address_entity_datetime`
--

CREATE TABLE `customer_address_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Datetime';

--
-- Dumping data for table `customer_address_entity_datetime`
--


--
-- Table structure for table `customer_address_entity_decimal`
--

CREATE TABLE `customer_address_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Decimal';

--
-- Dumping data for table `customer_address_entity_decimal`
--


--
-- Table structure for table `customer_address_entity_int`
--

CREATE TABLE `customer_address_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Int';

--
-- Dumping data for table `customer_address_entity_int`
--


--
-- Table structure for table `customer_address_entity_text`
--

CREATE TABLE `customer_address_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Text';

--
-- Dumping data for table `customer_address_entity_text`
--


--
-- Table structure for table `customer_address_entity_varchar`
--

CREATE TABLE `customer_address_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Varchar';

--
-- Dumping data for table `customer_address_entity_varchar`
--


--
-- Table structure for table `customer_eav_attribute`
--

CREATE TABLE `customer_eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `is_visible` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Visible',
  `input_filter` varchar(255) DEFAULT NULL COMMENT 'Input Filter',
  `multiline_count` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Multiline Count',
  `validate_rules` text COMMENT 'Validate Rules',
  `is_system` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is System',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `data_model` varchar(255) DEFAULT NULL COMMENT 'Data Model',
  `is_used_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used in Grid',
  `is_visible_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible in Grid',
  `is_filterable_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable in Grid',
  `is_searchable_in_grid` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Searchable in Grid',
  PRIMARY KEY (`attribute_id`),
  KEY `CUSTOMER_EAV_ATTRIBUTE_SORT_ORDER` (`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Eav Attribute';

--
-- Dumping data for table `customer_eav_attribute`
--

INSERT INTO `customer_eav_attribute` VALUES (1,1,NULL,0,NULL,1,10,NULL,1,1,1,0),(2,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(3,1,NULL,0,NULL,1,20,NULL,1,1,0,1),(4,0,NULL,0,NULL,0,30,NULL,0,0,0,0),(5,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,40,NULL,0,0,0,0),(6,0,'trim',0,NULL,0,50,NULL,0,0,0,0),(7,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,60,NULL,0,0,0,0),(8,0,NULL,0,NULL,0,70,NULL,0,0,0,0),(9,1,NULL,0,'{\"input_validation\":\"email\"}',1,80,NULL,1,1,1,1),(10,1,NULL,0,NULL,1,25,NULL,1,1,1,0),(11,0,'date',0,'{\"input_validation\":\"date\"}',0,90,NULL,1,1,1,0),(12,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(13,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(14,0,NULL,0,'{\"input_validation\":\"date\"}',1,0,NULL,0,0,0,0),(15,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(16,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(17,0,NULL,0,'{\"max_text_length\":255}',0,100,NULL,1,1,0,1),(18,0,NULL,0,NULL,1,0,NULL,1,1,1,0),(19,0,NULL,0,NULL,0,0,NULL,1,1,1,0),(20,0,NULL,0,'[]',0,110,NULL,1,1,1,0),(21,1,NULL,0,NULL,1,28,NULL,0,0,0,0),(22,0,NULL,0,NULL,0,10,NULL,0,0,0,0),(23,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,20,NULL,1,0,0,1),(24,0,'trim',0,NULL,0,30,NULL,0,0,0,0),(25,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,40,NULL,1,0,0,1),(26,0,NULL,0,NULL,0,50,NULL,0,0,0,0),(27,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,60,NULL,1,0,0,1),(28,1,NULL,3,'{\"max_text_length\":255,\"min_text_length\":1}',1,70,NULL,1,0,0,1),(29,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,80,NULL,1,0,0,1),(30,1,NULL,0,NULL,1,90,NULL,1,1,1,0),(31,1,NULL,0,NULL,1,100,NULL,1,1,0,1),(32,1,NULL,0,NULL,1,100,NULL,0,0,0,0),(33,1,NULL,0,'[]',1,110,'Magento\\Customer\\Model\\Attribute\\Data\\Postcode',1,1,1,1),(34,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,120,NULL,1,1,1,1),(35,0,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',0,130,NULL,1,0,0,1),(36,1,NULL,0,NULL,1,140,NULL,0,0,0,0),(37,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(38,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(39,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(40,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(41,0,NULL,0,NULL,0,0,NULL,0,0,0,0),(42,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(43,0,NULL,0,NULL,1,0,NULL,0,0,0,0),(44,0,NULL,0,NULL,1,0,NULL,0,0,0,0);

--
-- Table structure for table `customer_eav_attribute_website`
--

CREATE TABLE `customer_eav_attribute_website` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website ID',
  `is_visible` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Visible',
  `is_required` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Required',
  `default_value` text COMMENT 'Default Value',
  `multiline_count` smallint(5) unsigned DEFAULT NULL COMMENT 'Multiline Count',
  PRIMARY KEY (`attribute_id`,`website_id`),
  KEY `CUSTOMER_EAV_ATTRIBUTE_WEBSITE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Eav Attribute Website';

--
-- Dumping data for table `customer_eav_attribute_website`
--

INSERT INTO `customer_eav_attribute_website` VALUES (1,1,NULL,NULL,NULL,NULL),(3,1,NULL,NULL,NULL,NULL),(5,1,NULL,NULL,NULL,NULL),(6,1,NULL,NULL,NULL,NULL),(7,1,NULL,NULL,NULL,NULL),(9,1,NULL,NULL,NULL,NULL),(10,1,NULL,NULL,NULL,NULL),(11,1,NULL,NULL,NULL,NULL),(17,1,NULL,NULL,NULL,NULL),(18,1,NULL,NULL,NULL,NULL),(19,1,NULL,NULL,NULL,NULL),(20,1,NULL,NULL,NULL,NULL),(21,1,NULL,NULL,NULL,NULL),(23,1,NULL,NULL,NULL,NULL),(24,1,NULL,NULL,NULL,NULL),(25,1,NULL,NULL,NULL,NULL),(27,1,NULL,NULL,NULL,NULL),(28,1,NULL,NULL,NULL,NULL),(29,1,NULL,NULL,NULL,NULL),(30,1,NULL,NULL,NULL,NULL),(31,1,NULL,NULL,NULL,NULL),(32,1,NULL,NULL,NULL,NULL),(33,1,NULL,NULL,NULL,NULL),(34,1,NULL,NULL,NULL,NULL),(35,1,NULL,NULL,NULL,NULL),(36,1,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_entity`
--

CREATE TABLE `customer_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `website_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Website ID',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Group ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store ID',
  `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',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active',
  `disable_auto_group_change` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Disable automatic group change based on VAT ID',
  `created_in` varchar(255) DEFAULT NULL COMMENT 'Created From',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix',
  `firstname` varchar(255) DEFAULT NULL COMMENT 'First Name',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name/Initial',
  `lastname` varchar(255) DEFAULT NULL COMMENT 'Last Name',
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix',
  `dob` date DEFAULT NULL COMMENT 'Date of Birth',
  `password_hash` varchar(128) DEFAULT NULL COMMENT 'Password_hash',
  `rp_token` varchar(128) DEFAULT NULL COMMENT 'Reset password token',
  `rp_token_created_at` datetime DEFAULT NULL COMMENT 'Reset password token creation time',
  `default_billing` int(10) unsigned DEFAULT NULL COMMENT 'Default Billing Address',
  `default_shipping` int(10) unsigned DEFAULT NULL COMMENT 'Default Shipping Address',
  `taxvat` varchar(50) DEFAULT NULL COMMENT 'Tax/VAT Number',
  `confirmation` varchar(64) DEFAULT NULL COMMENT 'Is Confirmed',
  `gender` smallint(5) unsigned DEFAULT NULL COMMENT 'Gender',
  `failures_num` smallint(6) DEFAULT '0' COMMENT 'Failure Number',
  `first_failure` timestamp NULL DEFAULT NULL COMMENT 'First Failure',
  `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock Expiration Date',
  `session_cutoff` timestamp NULL DEFAULT NULL COMMENT 'Session Cutoff Time',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_EMAIL_WEBSITE_ID` (`email`,`website_id`),
  KEY `CUSTOMER_ENTITY_STORE_ID` (`store_id`),
  KEY `CUSTOMER_ENTITY_WEBSITE_ID` (`website_id`),
  KEY `CUSTOMER_ENTITY_FIRSTNAME` (`firstname`),
  KEY `CUSTOMER_ENTITY_LASTNAME` (`lastname`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Customer Entity';

--
-- Dumping data for table `customer_entity`
--

INSERT INTO `customer_entity` VALUES (1,1,'levinepeta101@gmail.com',1,NULL,1,'2024-02-04 09:10:45','2024-02-04 09:12:12',1,0,'Default Store View',NULL,'rxoMODaXIi',NULL,'DPVlZneaQGYSUMj',NULL,NULL,'5732de4f8f45009b01901bfb8b71c37649518cd16431b09af0d0553b79aeff5a:ySifAPHUPt1P3Z0PPydsGHvUxpg3FxsB:2','0:3:zY7MwKRqRsFQgb2vkyJfJge/qrxHz74d0gEK4ril7LarRCFCeAgKFWYVTCRHBZB0CG95FBYlr97Pw6pD','2024-02-04 09:10:45',NULL,NULL,NULL,NULL,NULL,6,'2024-02-04 09:11:22',NULL,'2024-02-04 09:11:15');

--
-- Table structure for table `customer_entity_datetime`
--

CREATE TABLE `customer_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Datetime';

--
-- Dumping data for table `customer_entity_datetime`
--


--
-- Table structure for table `customer_entity_decimal`
--

CREATE TABLE `customer_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Decimal';

--
-- Dumping data for table `customer_entity_decimal`
--


--
-- Table structure for table `customer_entity_int`
--

CREATE TABLE `customer_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Int';

--
-- Dumping data for table `customer_entity_int`
--


--
-- Table structure for table `customer_entity_text`
--

CREATE TABLE `customer_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Text';

--
-- Dumping data for table `customer_entity_text`
--


--
-- Table structure for table `customer_entity_varchar`
--

CREATE TABLE `customer_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `CUSTOMER_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Varchar';

--
-- Dumping data for table `customer_entity_varchar`
--


--
-- Table structure for table `customer_form_attribute`
--

CREATE TABLE `customer_form_attribute` (
  `form_code` varchar(32) NOT NULL COMMENT 'Form Code',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  PRIMARY KEY (`form_code`,`attribute_id`),
  KEY `CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Form Attribute';

--
-- Dumping data for table `customer_form_attribute`
--

INSERT INTO `customer_form_attribute` VALUES ('adminhtml_customer',1),('adminhtml_customer',3),('adminhtml_customer',4),('customer_account_create',4),('customer_account_edit',4),('adminhtml_customer',5),('customer_account_create',5),('customer_account_edit',5),('adminhtml_customer',6),('customer_account_create',6),('customer_account_edit',6),('adminhtml_customer',7),('customer_account_create',7),('customer_account_edit',7),('adminhtml_customer',8),('customer_account_create',8),('customer_account_edit',8),('adminhtml_checkout',9),('adminhtml_customer',9),('customer_account_create',9),('customer_account_edit',9),('adminhtml_checkout',10),('adminhtml_customer',10),('adminhtml_checkout',11),('adminhtml_customer',11),('customer_account_create',11),('customer_account_edit',11),('adminhtml_checkout',17),('adminhtml_customer',17),('customer_account_create',17),('customer_account_edit',17),('adminhtml_customer',19),('customer_account_create',19),('customer_account_edit',19),('adminhtml_checkout',20),('adminhtml_customer',20),('customer_account_create',20),('customer_account_edit',20),('adminhtml_customer',21),('adminhtml_customer_address',22),('customer_address_edit',22),('customer_register_address',22),('adminhtml_customer_address',23),('customer_address_edit',23),('customer_register_address',23),('adminhtml_customer_address',24),('customer_address_edit',24),('customer_register_address',24),('adminhtml_customer_address',25),('customer_address_edit',25),('customer_register_address',25),('adminhtml_customer_address',26),('customer_address_edit',26),('customer_register_address',26),('adminhtml_customer_address',27),('customer_address_edit',27),('customer_register_address',27),('adminhtml_customer_address',28),('customer_address_edit',28),('customer_register_address',28),('adminhtml_customer_address',29),('customer_address_edit',29),('customer_register_address',29),('adminhtml_customer_address',30),('customer_address_edit',30),('customer_register_address',30),('adminhtml_customer_address',31),('customer_address_edit',31),('customer_register_address',31),('adminhtml_customer_address',32),('customer_address_edit',32),('customer_register_address',32),('adminhtml_customer_address',33),('customer_address_edit',33),('customer_register_address',33),('adminhtml_customer_address',34),('customer_address_edit',34),('customer_register_address',34),('adminhtml_customer_address',35),('customer_address_edit',35),('customer_register_address',35),('adminhtml_customer_address',36),('customer_address_edit',36),('customer_register_address',36);

--
-- Table structure for table `customer_grid_flat`
--

CREATE TABLE `customer_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `name` text COMMENT 'Name',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` int(11) DEFAULT NULL COMMENT 'Group_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created_at',
  `website_id` int(11) DEFAULT NULL COMMENT 'Website_id',
  `confirmation` varchar(255) DEFAULT NULL COMMENT 'Confirmation',
  `created_in` text COMMENT 'Created_in',
  `dob` date DEFAULT NULL COMMENT 'Dob',
  `gender` int(11) DEFAULT NULL COMMENT 'Gender',
  `taxvat` varchar(255) DEFAULT NULL COMMENT 'Taxvat',
  `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock_expires',
  `shipping_full` text COMMENT 'Shipping_full',
  `billing_full` text COMMENT 'Billing_full',
  `billing_firstname` varchar(255) DEFAULT NULL COMMENT 'Billing_firstname',
  `billing_lastname` varchar(255) DEFAULT NULL COMMENT 'Billing_lastname',
  `billing_telephone` varchar(255) DEFAULT NULL COMMENT 'Billing_telephone',
  `billing_postcode` varchar(255) DEFAULT NULL COMMENT 'Billing_postcode',
  `billing_country_id` varchar(255) DEFAULT NULL COMMENT 'Billing_country_id',
  `billing_region` varchar(255) DEFAULT NULL COMMENT 'Billing_region',
  `billing_region_id` int(11) DEFAULT NULL COMMENT 'Billing_region_id',
  `billing_street` varchar(255) DEFAULT NULL COMMENT 'Billing_street',
  `billing_city` varchar(255) DEFAULT NULL COMMENT 'Billing_city',
  `billing_fax` varchar(255) DEFAULT NULL COMMENT 'Billing_fax',
  `billing_vat_id` varchar(255) DEFAULT NULL COMMENT 'Billing_vat_id',
  `billing_company` varchar(255) DEFAULT NULL COMMENT 'Billing_company',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_GRID_FLAT_GROUP_ID` (`group_id`),
  KEY `CUSTOMER_GRID_FLAT_CREATED_AT` (`created_at`),
  KEY `CUSTOMER_GRID_FLAT_WEBSITE_ID` (`website_id`),
  KEY `CUSTOMER_GRID_FLAT_CONFIRMATION` (`confirmation`),
  KEY `CUSTOMER_GRID_FLAT_DOB` (`dob`),
  KEY `CUSTOMER_GRID_FLAT_GENDER` (`gender`),
  KEY `CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID` (`billing_country_id`),
  FULLTEXT KEY `FTI_8746F705702DD5F6D45B8C7CE7FE9F2F` (`name`,`email`,`created_in`,`taxvat`,`shipping_full`,`billing_full`,`billing_firstname`,`billing_lastname`,`billing_telephone`,`billing_postcode`,`billing_region`,`billing_city`,`billing_fax`,`billing_company`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='customer_grid_flat';

--
-- Dumping data for table `customer_grid_flat`
--

INSERT INTO `customer_grid_flat` VALUES (1,'rxoMODaXIi DPVlZneaQGYSUMj','levinepeta101@gmail.com',1,'2024-02-04 09:10:45',1,NULL,'Default Store View',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `customer_group`
--

CREATE TABLE `customer_group` (
  `customer_group_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `customer_group_code` varchar(32) NOT NULL COMMENT 'Customer Group Code',
  `tax_class_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Tax Class ID',
  PRIMARY KEY (`customer_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Customer Group';

--
-- Dumping data for table `customer_group`
--

INSERT INTO `customer_group` VALUES (0,'NOT LOGGED IN',3),(1,'General',3),(2,'Wholesale',3),(3,'Retailer',3);

--
-- Table structure for table `customer_log`
--

CREATE TABLE `customer_log` (
  `log_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `customer_id` int(11) NOT NULL COMMENT 'Customer ID',
  `last_login_at` timestamp NULL DEFAULT NULL COMMENT 'Last Login Time',
  `last_logout_at` timestamp NULL DEFAULT NULL COMMENT 'Last Logout Time',
  PRIMARY KEY (`log_id`),
  UNIQUE KEY `CUSTOMER_LOG_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Customer Log Table';

--
-- Dumping data for table `customer_log`
--

INSERT INTO `customer_log` VALUES (1,1,'2024-02-04 09:10:46','2024-02-04 09:11:15');

--
-- Table structure for table `customer_visitor`
--

CREATE TABLE `customer_visitor` (
  `visitor_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `session_id` varchar(1) DEFAULT NULL COMMENT 'Deprecated: Session ID value no longer used',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `last_visit_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Visit Time',
  PRIMARY KEY (`visitor_id`),
  KEY `CUSTOMER_VISITOR_CUSTOMER_ID` (`customer_id`),
  KEY `CUSTOMER_VISITOR_LAST_VISIT_AT` (`last_visit_at`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COMMENT='Visitor Table';

--
-- Dumping data for table `customer_visitor`
--

INSERT INTO `customer_visitor` VALUES (1,NULL,NULL,'2024-02-02 23:27:11','2024-02-03 00:00:49'),(2,NULL,NULL,'2024-02-03 16:57:27','2024-02-03 16:57:27'),(3,NULL,NULL,'2024-02-03 16:57:30','2024-02-03 18:58:49'),(4,NULL,NULL,'2024-02-03 20:33:52','2024-02-03 20:50:32'),(5,NULL,NULL,'2024-02-03 21:47:06','2024-02-03 22:07:06'),(6,NULL,NULL,'2024-02-03 22:21:38','2024-02-03 22:21:38'),(7,NULL,NULL,'2024-02-04 02:01:33','2024-02-04 02:01:33'),(8,NULL,NULL,'2024-02-04 03:08:42','2024-02-04 03:31:44'),(9,NULL,NULL,'2024-02-04 05:00:42','2024-02-04 05:00:42'),(10,1,NULL,'2024-02-04 09:11:16','2024-02-04 09:11:15'),(11,NULL,NULL,'2024-02-04 09:11:22','2024-02-04 09:11:51'),(12,NULL,NULL,'2024-02-04 18:23:08','2024-02-04 18:23:55');

--
-- Table structure for table `design_change`
--

CREATE TABLE `design_change` (
  `design_change_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Design Change ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `design` varchar(255) DEFAULT NULL COMMENT 'Design',
  `date_from` date DEFAULT NULL COMMENT 'First Date of Design Activity',
  `date_to` date DEFAULT NULL COMMENT 'Last Date of Design Activity',
  PRIMARY KEY (`design_change_id`),
  KEY `DESIGN_CHANGE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Design Changes';

--
-- Dumping data for table `design_change`
--


--
-- Table structure for table `design_config_grid_flat`
--

CREATE TABLE `design_config_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `store_website_id` int(11) DEFAULT NULL COMMENT 'Store_website_id',
  `store_group_id` int(11) DEFAULT NULL COMMENT 'Store_group_id',
  `store_id` int(11) DEFAULT NULL COMMENT 'Store_id',
  `theme_theme_id` varchar(255) DEFAULT NULL COMMENT 'Theme_theme_id',
  PRIMARY KEY (`entity_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
  KEY `DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
  FULLTEXT KEY `DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='design_config_grid_flat';

--
-- Dumping data for table `design_config_grid_flat`
--

INSERT INTO `design_config_grid_flat` VALUES (0,NULL,NULL,NULL,'4'),(1,1,NULL,NULL,'4'),(2,1,1,1,'4');

--
-- Table structure for table `directory_country`
--

CREATE TABLE `directory_country` (
  `country_id` varchar(2) NOT NULL COMMENT 'Country ID in ISO-2',
  `iso2_code` varchar(2) DEFAULT NULL COMMENT 'Country ISO-2 format',
  `iso3_code` varchar(3) DEFAULT NULL COMMENT 'Country ISO-3',
  PRIMARY KEY (`country_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country';

--
-- Dumping data for table `directory_country`
--

INSERT INTO `directory_country` VALUES ('AD','AD','AND'),('AE','AE','ARE'),('AF','AF','AFG'),('AG','AG','ATG'),('AI','AI','AIA'),('AL','AL','ALB'),('AM','AM','ARM'),('AN','AN','ANT'),('AO','AO','AGO'),('AQ','AQ','ATA'),('AR','AR','ARG'),('AS','AS','ASM'),('AT','AT','AUT'),('AU','AU','AUS'),('AW','AW','ABW'),('AX','AX','ALA'),('AZ','AZ','AZE'),('BA','BA','BIH'),('BB','BB','BRB'),('BD','BD','BGD'),('BE','BE','BEL'),('BF','BF','BFA'),('BG','BG','BGR'),('BH','BH','BHR'),('BI','BI','BDI'),('BJ','BJ','BEN'),('BL','BL','BLM'),('BM','BM','BMU'),('BN','BN','BRN'),('BO','BO','BOL'),('BQ','BQ','BES'),('BR','BR','BRA'),('BS','BS','BHS'),('BT','BT','BTN'),('BV','BV','BVT'),('BW','BW','BWA'),('BY','BY','BLR'),('BZ','BZ','BLZ'),('CA','CA','CAN'),('CC','CC','CCK'),('CD','CD','COD'),('CF','CF','CAF'),('CG','CG','COG'),('CH','CH','CHE'),('CI','CI','CIV'),('CK','CK','COK'),('CL','CL','CHL'),('CM','CM','CMR'),('CN','CN','CHN'),('CO','CO','COL'),('CR','CR','CRI'),('CU','CU','CUB'),('CV','CV','CPV'),('CW','CW','CUW'),('CX','CX','CXR'),('CY','CY','CYP'),('CZ','CZ','CZE'),('DE','DE','DEU'),('DJ','DJ','DJI'),('DK','DK','DNK'),('DM','DM','DMA'),('DO','DO','DOM'),('DZ','DZ','DZA'),('EC','EC','ECU'),('EE','EE','EST'),('EG','EG','EGY'),('EH','EH','ESH'),('ER','ER','ERI'),('ES','ES','ESP'),('ET','ET','ETH'),('FI','FI','FIN'),('FJ','FJ','FJI'),('FK','FK','FLK'),('FM','FM','FSM'),('FO','FO','FRO'),('FR','FR','FRA'),('GA','GA','GAB'),('GB','GB','GBR'),('GD','GD','GRD'),('GE','GE','GEO'),('GF','GF','GUF'),('GG','GG','GGY'),('GH','GH','GHA'),('GI','GI','GIB'),('GL','GL','GRL'),('GM','GM','GMB'),('GN','GN','GIN'),('GP','GP','GLP'),('GQ','GQ','GNQ'),('GR','GR','GRC'),('GS','GS','SGS'),('GT','GT','GTM'),('GU','GU','GUM'),('GW','GW','GNB'),('GY','GY','GUY'),('HK','HK','HKG'),('HM','HM','HMD'),('HN','HN','HND'),('HR','HR','HRV'),('HT','HT','HTI'),('HU','HU','HUN'),('ID','ID','IDN'),('IE','IE','IRL'),('IL','IL','ISR'),('IM','IM','IMN'),('IN','IN','IND'),('IO','IO','IOT'),('IQ','IQ','IRQ'),('IR','IR','IRN'),('IS','IS','ISL'),('IT','IT','ITA'),('JE','JE','JEY'),('JM','JM','JAM'),('JO','JO','JOR'),('JP','JP','JPN'),('KE','KE','KEN'),('KG','KG','KGZ'),('KH','KH','KHM'),('KI','KI','KIR'),('KM','KM','COM'),('KN','KN','KNA'),('KP','KP','PRK'),('KR','KR','KOR'),('KW','KW','KWT'),('KY','KY','CYM'),('KZ','KZ','KAZ'),('LA','LA','LAO'),('LB','LB','LBN'),('LC','LC','LCA'),('LI','LI','LIE'),('LK','LK','LKA'),('LR','LR','LBR'),('LS','LS','LSO'),('LT','LT','LTU'),('LU','LU','LUX'),('LV','LV','LVA'),('LY','LY','LBY'),('MA','MA','MAR'),('MC','MC','MCO'),('MD','MD','MDA'),('ME','ME','MNE'),('MF','MF','MAF'),('MG','MG','MDG'),('MH','MH','MHL'),('MK','MK','MKD'),('ML','ML','MLI'),('MM','MM','MMR'),('MN','MN','MNG'),('MO','MO','MAC'),('MP','MP','MNP'),('MQ','MQ','MTQ'),('MR','MR','MRT'),('MS','MS','MSR'),('MT','MT','MLT'),('MU','MU','MUS'),('MV','MV','MDV'),('MW','MW','MWI'),('MX','MX','MEX'),('MY','MY','MYS'),('MZ','MZ','MOZ'),('NA','NA','NAM'),('NC','NC','NCL'),('NE','NE','NER'),('NF','NF','NFK'),('NG','NG','NGA'),('NI','NI','NIC'),('NL','NL','NLD'),('NO','NO','NOR'),('NP','NP','NPL'),('NR','NR','NRU'),('NU','NU','NIU'),('NZ','NZ','NZL'),('OM','OM','OMN'),('PA','PA','PAN'),('PE','PE','PER'),('PF','PF','PYF'),('PG','PG','PNG'),('PH','PH','PHL'),('PK','PK','PAK'),('PL','PL','POL'),('PM','PM','SPM'),('PN','PN','PCN'),('PS','PS','PSE'),('PT','PT','PRT'),('PW','PW','PLW'),('PY','PY','PRY'),('QA','QA','QAT'),('RE','RE','REU'),('RO','RO','ROU'),('RS','RS','SRB'),('RU','RU','RUS'),('RW','RW','RWA'),('SA','SA','SAU'),('SB','SB','SLB'),('SC','SC','SYC'),('SD','SD','SDN'),('SE','SE','SWE'),('SG','SG','SGP'),('SH','SH','SHN'),('SI','SI','SVN'),('SJ','SJ','SJM'),('SK','SK','SVK'),('SL','SL','SLE'),('SM','SM','SMR'),('SN','SN','SEN'),('SO','SO','SOM'),('SR','SR','SUR'),('ST','ST','STP'),('SV','SV','SLV'),('SX','SX','SXM'),('SY','SY','SYR'),('SZ','SZ','SWZ'),('TC','TC','TCA'),('TD','TD','TCD'),('TF','TF','ATF'),('TG','TG','TGO'),('TH','TH','THA'),('TJ','TJ','TJK'),('TK','TK','TKL'),('TL','TL','TLS'),('TM','TM','TKM'),('TN','TN','TUN'),('TO','TO','TON'),('TR','TR','TUR'),('TT','TT','TTO'),('TV','TV','TUV'),('TW','TW','TWN'),('TZ','TZ','TZA'),('UA','UA','UKR'),('UG','UG','UGA'),('UM','UM','UMI'),('US','US','USA'),('UY','UY','URY'),('UZ','UZ','UZB'),('VA','VA','VAT'),('VC','VC','VCT'),('VE','VE','VEN'),('VG','VG','VGB'),('VI','VI','VIR'),('VN','VN','VNM'),('VU','VU','VUT'),('WF','WF','WLF'),('WS','WS','WSM'),('XK','XK','XKX'),('YE','YE','YEM'),('YT','YT','MYT'),('ZA','ZA','ZAF'),('ZM','ZM','ZMB'),('ZW','ZW','ZWE');

--
-- Table structure for table `directory_country_format`
--

CREATE TABLE `directory_country_format` (
  `country_format_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Country Format ID',
  `country_id` varchar(2) DEFAULT NULL COMMENT 'Country ID in ISO-2',
  `type` varchar(30) DEFAULT NULL COMMENT 'Country Format Type',
  `format` text NOT NULL COMMENT 'Country Format',
  PRIMARY KEY (`country_format_id`),
  UNIQUE KEY `DIRECTORY_COUNTRY_FORMAT_COUNTRY_ID_TYPE` (`country_id`,`type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Format';

--
-- Dumping data for table `directory_country_format`
--


--
-- Table structure for table `directory_country_region`
--

CREATE TABLE `directory_country_region` (
  `region_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Region ID',
  `country_id` varchar(4) NOT NULL DEFAULT '0' COMMENT 'Country ID in ISO-2',
  `code` varchar(32) DEFAULT NULL COMMENT 'Region code',
  `default_name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
  PRIMARY KEY (`region_id`),
  KEY `DIRECTORY_COUNTRY_REGION_COUNTRY_ID` (`country_id`)
) ENGINE=InnoDB AUTO_INCREMENT=702 DEFAULT CHARSET=utf8 COMMENT='Directory Country Region';

--
-- Dumping data for table `directory_country_region`
--

INSERT INTO `directory_country_region` VALUES (1,'US','AL','Alabama'),(2,'US','AK','Alaska'),(3,'US','AS','American Samoa'),(4,'US','AZ','Arizona'),(5,'US','AR','Arkansas'),(6,'US','AE','Armed Forces Africa'),(7,'US','AA','Armed Forces Americas'),(8,'US','AE','Armed Forces Canada'),(9,'US','AE','Armed Forces Europe'),(10,'US','AE','Armed Forces Middle East'),(11,'US','AP','Armed Forces Pacific'),(12,'US','CA','California'),(13,'US','CO','Colorado'),(14,'US','CT','Connecticut'),(15,'US','DE','Delaware'),(16,'US','DC','District of Columbia'),(17,'US','FM','Federated States Of Micronesia'),(18,'US','FL','Florida'),(19,'US','GA','Georgia'),(20,'US','GU','Guam'),(21,'US','HI','Hawaii'),(22,'US','ID','Idaho'),(23,'US','IL','Illinois'),(24,'US','IN','Indiana'),(25,'US','IA','Iowa'),(26,'US','KS','Kansas'),(27,'US','KY','Kentucky'),(28,'US','LA','Louisiana'),(29,'US','ME','Maine'),(30,'US','MH','Marshall Islands'),(31,'US','MD','Maryland'),(32,'US','MA','Massachusetts'),(33,'US','MI','Michigan'),(34,'US','MN','Minnesota'),(35,'US','MS','Mississippi'),(36,'US','MO','Missouri'),(37,'US','MT','Montana'),(38,'US','NE','Nebraska'),(39,'US','NV','Nevada'),(40,'US','NH','New Hampshire'),(41,'US','NJ','New Jersey'),(42,'US','NM','New Mexico'),(43,'US','NY','New York'),(44,'US','NC','North Carolina'),(45,'US','ND','North Dakota'),(46,'US','MP','Northern Mariana Islands'),(47,'US','OH','Ohio'),(48,'US','OK','Oklahoma'),(49,'US','OR','Oregon'),(50,'US','PW','Palau'),(51,'US','PA','Pennsylvania'),(52,'US','PR','Puerto Rico'),(53,'US','RI','Rhode Island'),(54,'US','SC','South Carolina'),(55,'US','SD','South Dakota'),(56,'US','TN','Tennessee'),(57,'US','TX','Texas'),(58,'US','UT','Utah'),(59,'US','VT','Vermont'),(60,'US','VI','Virgin Islands'),(61,'US','VA','Virginia'),(62,'US','WA','Washington'),(63,'US','WV','West Virginia'),(64,'US','WI','Wisconsin'),(65,'US','WY','Wyoming'),(66,'CA','AB','Alberta'),(67,'CA','BC','British Columbia'),(68,'CA','MB','Manitoba'),(69,'CA','NL','Newfoundland and Labrador'),(70,'CA','NB','New Brunswick'),(71,'CA','NS','Nova Scotia'),(72,'CA','NT','Northwest Territories'),(73,'CA','NU','Nunavut'),(74,'CA','ON','Ontario'),(75,'CA','PE','Prince Edward Island'),(76,'CA','QC','Quebec'),(77,'CA','SK','Saskatchewan'),(78,'CA','YT','Yukon Territory'),(79,'DE','NDS','Niedersachsen'),(80,'DE','BAW','Baden-Württemberg'),(81,'DE','BAY','Bayern'),(82,'DE','BER','Berlin'),(83,'DE','BRG','Brandenburg'),(84,'DE','BRE','Bremen'),(85,'DE','HAM','Hamburg'),(86,'DE','HES','Hessen'),(87,'DE','MEC','Mecklenburg-Vorpommern'),(88,'DE','NRW','Nordrhein-Westfalen'),(89,'DE','RHE','Rheinland-Pfalz'),(90,'DE','SAR','Saarland'),(91,'DE','SAS','Sachsen'),(92,'DE','SAC','Sachsen-Anhalt'),(93,'DE','SCN','Schleswig-Holstein'),(94,'DE','THE','Thüringen'),(95,'AT','WI','Wien'),(96,'AT','NO','Niederösterreich'),(97,'AT','OO','Oberösterreich'),(98,'AT','SB','Salzburg'),(99,'AT','KN','Kärnten'),(100,'AT','ST','Steiermark'),(101,'AT','TI','Tirol'),(102,'AT','BL','Burgenland'),(103,'AT','VB','Vorarlberg'),(104,'CH','AG','Aargau'),(105,'CH','AI','Appenzell Innerrhoden'),(106,'CH','AR','Appenzell Ausserrhoden'),(107,'CH','BE','Bern'),(108,'CH','BL','Basel-Landschaft'),(109,'CH','BS','Basel-Stadt'),(110,'CH','FR','Freiburg'),(111,'CH','GE','Genf'),(112,'CH','GL','Glarus'),(113,'CH','GR','Graubünden'),(114,'CH','JU','Jura'),(115,'CH','LU','Luzern'),(116,'CH','NE','Neuenburg'),(117,'CH','NW','Nidwalden'),(118,'CH','OW','Obwalden'),(119,'CH','SG','St. Gallen'),(120,'CH','SH','Schaffhausen'),(121,'CH','SO','Solothurn'),(122,'CH','SZ','Schwyz'),(123,'CH','TG','Thurgau'),(124,'CH','TI','Tessin'),(125,'CH','UR','Uri'),(126,'CH','VD','Waadt'),(127,'CH','VS','Wallis'),(128,'CH','ZG','Zug'),(129,'CH','ZH','Zürich'),(130,'ES','A Coruсa','A Coruña'),(131,'ES','Alava','Alava'),(132,'ES','Albacete','Albacete'),(133,'ES','Alicante','Alicante'),(134,'ES','Almeria','Almeria'),(135,'ES','Asturias','Asturias'),(136,'ES','Avila','Avila'),(137,'ES','Badajoz','Badajoz'),(138,'ES','Baleares','Baleares'),(139,'ES','Barcelona','Barcelona'),(140,'ES','Burgos','Burgos'),(141,'ES','Caceres','Caceres'),(142,'ES','Cadiz','Cadiz'),(143,'ES','Cantabria','Cantabria'),(144,'ES','Castellon','Castellon'),(145,'ES','Ceuta','Ceuta'),(146,'ES','Ciudad Real','Ciudad Real'),(147,'ES','Cordoba','Cordoba'),(148,'ES','Cuenca','Cuenca'),(149,'ES','Girona','Girona'),(150,'ES','Granada','Granada'),(151,'ES','Guadalajara','Guadalajara'),(152,'ES','Guipuzcoa','Guipuzcoa'),(153,'ES','Huelva','Huelva'),(154,'ES','Huesca','Huesca'),(155,'ES','Jaen','Jaen'),(156,'ES','La Rioja','La Rioja'),(157,'ES','Las Palmas','Las Palmas'),(158,'ES','Leon','Leon'),(159,'ES','Lleida','Lleida'),(160,'ES','Lugo','Lugo'),(161,'ES','Madrid','Madrid'),(162,'ES','Malaga','Malaga'),(163,'ES','Melilla','Melilla'),(164,'ES','Murcia','Murcia'),(165,'ES','Navarra','Navarra'),(166,'ES','Ourense','Ourense'),(167,'ES','Palencia','Palencia'),(168,'ES','Pontevedra','Pontevedra'),(169,'ES','Salamanca','Salamanca'),(170,'ES','Santa Cruz de Tenerife','Santa Cruz de Tenerife'),(171,'ES','Segovia','Segovia'),(172,'ES','Sevilla','Sevilla'),(173,'ES','Soria','Soria'),(174,'ES','Tarragona','Tarragona'),(175,'ES','Teruel','Teruel'),(176,'ES','Toledo','Toledo'),(177,'ES','Valencia','Valencia'),(178,'ES','Valladolid','Valladolid'),(179,'ES','Vizcaya','Vizcaya'),(180,'ES','Zamora','Zamora'),(181,'ES','Zaragoza','Zaragoza'),(182,'FR','1','Ain'),(183,'FR','2','Aisne'),(184,'FR','3','Allier'),(185,'FR','4','Alpes-de-Haute-Provence'),(186,'FR','5','Hautes-Alpes'),(187,'FR','6','Alpes-Maritimes'),(188,'FR','7','Ardèche'),(189,'FR','8','Ardennes'),(190,'FR','9','Ariège'),(191,'FR','10','Aube'),(192,'FR','11','Aude'),(193,'FR','12','Aveyron'),(194,'FR','13','Bouches-du-Rhône'),(195,'FR','14','Calvados'),(196,'FR','15','Cantal'),(197,'FR','16','Charente'),(198,'FR','17','Charente-Maritime'),(199,'FR','18','Cher'),(200,'FR','19','Corrèze'),(201,'FR','2A','Corse-du-Sud'),(202,'FR','2B','Haute-Corse'),(203,'FR','21','Côte-d\'Or'),(204,'FR','22','Côtes-d\'Armor'),(205,'FR','23','Creuse'),(206,'FR','24','Dordogne'),(207,'FR','25','Doubs'),(208,'FR','26','Drôme'),(209,'FR','27','Eure'),(210,'FR','28','Eure-et-Loir'),(211,'FR','29','Finistère'),(212,'FR','30','Gard'),(213,'FR','31','Haute-Garonne'),(214,'FR','32','Gers'),(215,'FR','33','Gironde'),(216,'FR','34','Hérault'),(217,'FR','35','Ille-et-Vilaine'),(218,'FR','36','Indre'),(219,'FR','37','Indre-et-Loire'),(220,'FR','38','Isère'),(221,'FR','39','Jura'),(222,'FR','40','Landes'),(223,'FR','41','Loir-et-Cher'),(224,'FR','42','Loire'),(225,'FR','43','Haute-Loire'),(226,'FR','44','Loire-Atlantique'),(227,'FR','45','Loiret'),(228,'FR','46','Lot'),(229,'FR','47','Lot-et-Garonne'),(230,'FR','48','Lozère'),(231,'FR','49','Maine-et-Loire'),(232,'FR','50','Manche'),(233,'FR','51','Marne'),(234,'FR','52','Haute-Marne'),(235,'FR','53','Mayenne'),(236,'FR','54','Meurthe-et-Moselle'),(237,'FR','55','Meuse'),(238,'FR','56','Morbihan'),(239,'FR','57','Moselle'),(240,'FR','58','Nièvre'),(241,'FR','59','Nord'),(242,'FR','60','Oise'),(243,'FR','61','Orne'),(244,'FR','62','Pas-de-Calais'),(245,'FR','63','Puy-de-Dôme'),(246,'FR','64','Pyrénées-Atlantiques'),(247,'FR','65','Hautes-Pyrénées'),(248,'FR','66','Pyrénées-Orientales'),(249,'FR','67','Bas-Rhin'),(250,'FR','68','Haut-Rhin'),(251,'FR','69','Rhône'),(252,'FR','70','Haute-Saône'),(253,'FR','71','Saône-et-Loire'),(254,'FR','72','Sarthe'),(255,'FR','73','Savoie'),(256,'FR','74','Haute-Savoie'),(257,'FR','75','Paris'),(258,'FR','76','Seine-Maritime'),(259,'FR','77','Seine-et-Marne'),(260,'FR','78','Yvelines'),(261,'FR','79','Deux-Sèvres'),(262,'FR','80','Somme'),(263,'FR','81','Tarn'),(264,'FR','82','Tarn-et-Garonne'),(265,'FR','83','Var'),(266,'FR','84','Vaucluse'),(267,'FR','85','Vendée'),(268,'FR','86','Vienne'),(269,'FR','87','Haute-Vienne'),(270,'FR','88','Vosges'),(271,'FR','89','Yonne'),(272,'FR','90','Territoire-de-Belfort'),(273,'FR','91','Essonne'),(274,'FR','92','Hauts-de-Seine'),(275,'FR','93','Seine-Saint-Denis'),(276,'FR','94','Val-de-Marne'),(277,'FR','95','Val-d\'Oise'),(278,'RO','AB','Alba'),(279,'RO','AR','Arad'),(280,'RO','AG','Argeş'),(281,'RO','BC','Bacău'),(282,'RO','BH','Bihor'),(283,'RO','BN','Bistriţa-Năsăud'),(284,'RO','BT','Botoşani'),(285,'RO','BV','Braşov'),(286,'RO','BR','Brăila'),(287,'RO','B','Bucureşti'),(288,'RO','BZ','Buzău'),(289,'RO','CS','Caraş-Severin'),(290,'RO','CL','Călăraşi'),(291,'RO','CJ','Cluj'),(292,'RO','CT','Constanţa'),(293,'RO','CV','Covasna'),(294,'RO','DB','Dâmboviţa'),(295,'RO','DJ','Dolj'),(296,'RO','GL','Galaţi'),(297,'RO','GR','Giurgiu'),(298,'RO','GJ','Gorj'),(299,'RO','HR','Harghita'),(300,'RO','HD','Hunedoara'),(301,'RO','IL','Ialomiţa'),(302,'RO','IS','Iaşi'),(303,'RO','IF','Ilfov'),(304,'RO','MM','Maramureş'),(305,'RO','MH','Mehedinţi'),(306,'RO','MS','Mureş'),(307,'RO','NT','Neamţ'),(308,'RO','OT','Olt'),(309,'RO','PH','Prahova'),(310,'RO','SM','Satu-Mare'),(311,'RO','SJ','Sălaj'),(312,'RO','SB','Sibiu'),(313,'RO','SV','Suceava'),(314,'RO','TR','Teleorman'),(315,'RO','TM','Timiş'),(316,'RO','TL','Tulcea'),(317,'RO','VS','Vaslui'),(318,'RO','VL','Vâlcea'),(319,'RO','VN','Vrancea'),(320,'FI','Lappi','Lappi'),(321,'FI','Pohjois-Pohjanmaa','Pohjois-Pohjanmaa'),(322,'FI','Kainuu','Kainuu'),(323,'FI','Pohjois-Karjala','Pohjois-Karjala'),(324,'FI','Pohjois-Savo','Pohjois-Savo'),(325,'FI','Etelä-Savo','Etelä-Savo'),(326,'FI','Etelä-Pohjanmaa','Etelä-Pohjanmaa'),(327,'FI','Pohjanmaa','Pohjanmaa'),(328,'FI','Pirkanmaa','Pirkanmaa'),(329,'FI','Satakunta','Satakunta'),(330,'FI','Keski-Pohjanmaa','Keski-Pohjanmaa'),(331,'FI','Keski-Suomi','Keski-Suomi'),(332,'FI','Varsinais-Suomi','Varsinais-Suomi'),(333,'FI','Etelä-Karjala','Etelä-Karjala'),(334,'FI','Päijät-Häme','Päijät-Häme'),(335,'FI','Kanta-Häme','Kanta-Häme'),(336,'FI','Uusimaa','Uusimaa'),(337,'FI','Itä-Uusimaa','Itä-Uusimaa'),(338,'FI','Kymenlaakso','Kymenlaakso'),(339,'FI','Ahvenanmaa','Ahvenanmaa'),(340,'EE','EE-37','Harjumaa'),(341,'EE','EE-39','Hiiumaa'),(342,'EE','EE-44','Ida-Virumaa'),(343,'EE','EE-49','Jõgevamaa'),(344,'EE','EE-51','Järvamaa'),(345,'EE','EE-57','Läänemaa'),(346,'EE','EE-59','Lääne-Virumaa'),(347,'EE','EE-65','Põlvamaa'),(348,'EE','EE-67','Pärnumaa'),(349,'EE','EE-70','Raplamaa'),(350,'EE','EE-74','Saaremaa'),(351,'EE','EE-78','Tartumaa'),(352,'EE','EE-82','Valgamaa'),(353,'EE','EE-84','Viljandimaa'),(354,'EE','EE-86','Võrumaa'),(355,'LV','LV-DGV','Daugavpils'),(356,'LV','LV-JEL','Jelgava'),(357,'LV','Jēkabpils','Jēkabpils'),(358,'LV','LV-JUR','Jūrmala'),(359,'LV','LV-LPX','Liepāja'),(360,'LV','LV-LE','Liepājas novads'),(361,'LV','LV-REZ','Rēzekne'),(362,'LV','LV-RIX','Rīga'),(363,'LV','LV-RI','Rīgas novads'),(364,'LV','Valmiera','Valmiera'),(365,'LV','LV-VEN','Ventspils'),(366,'LV','Aglonas novads','Aglonas novads'),(367,'LV','LV-AI','Aizkraukles novads'),(368,'LV','Aizputes novads','Aizputes novads'),(369,'LV','Aknīstes novads','Aknīstes novads'),(370,'LV','Alojas novads','Alojas novads'),(371,'LV','Alsungas novads','Alsungas novads'),(372,'LV','LV-AL','Alūksnes novads'),(373,'LV','Amatas novads','Amatas novads'),(374,'LV','Apes novads','Apes novads'),(375,'LV','Auces novads','Auces novads'),(376,'LV','Babītes novads','Babītes novads'),(377,'LV','Baldones novads','Baldones novads'),(378,'LV','Baltinavas novads','Baltinavas novads'),(379,'LV','LV-BL','Balvu novads'),(380,'LV','LV-BU','Bauskas novads'),(381,'LV','Beverīnas novads','Beverīnas novads'),(382,'LV','Brocēnu novads','Brocēnu novads'),(383,'LV','Burtnieku novads','Burtnieku novads'),(384,'LV','Carnikavas novads','Carnikavas novads'),(385,'LV','Cesvaines novads','Cesvaines novads'),(386,'LV','Ciblas novads','Ciblas novads'),(387,'LV','LV-CE','Cēsu novads'),(388,'LV','Dagdas novads','Dagdas novads'),(389,'LV','LV-DA','Daugavpils novads'),(390,'LV','LV-DO','Dobeles novads'),(391,'LV','Dundagas novads','Dundagas novads'),(392,'LV','Durbes novads','Durbes novads'),(393,'LV','Engures novads','Engures novads'),(394,'LV','Garkalnes novads','Garkalnes novads'),(395,'LV','Grobiņas novads','Grobiņas novads'),(396,'LV','LV-GU','Gulbenes novads'),(397,'LV','Iecavas novads','Iecavas novads'),(398,'LV','Ikšķiles novads','Ikšķiles novads'),(399,'LV','Ilūkstes novads','Ilūkstes novads'),(400,'LV','Inčukalna novads','Inčukalna novads'),(401,'LV','Jaunjelgavas novads','Jaunjelgavas novads'),(402,'LV','Jaunpiebalgas novads','Jaunpiebalgas novads'),(403,'LV','Jaunpils novads','Jaunpils novads'),(404,'LV','LV-JL','Jelgavas novads'),(405,'LV','LV-JK','Jēkabpils novads'),(406,'LV','Kandavas novads','Kandavas novads'),(407,'LV','Kokneses novads','Kokneses novads'),(408,'LV','Krimuldas novads','Krimuldas novads'),(409,'LV','Krustpils novads','Krustpils novads'),(410,'LV','LV-KR','Krāslavas novads'),(411,'LV','LV-KU','Kuldīgas novads'),(412,'LV','Kārsavas novads','Kārsavas novads'),(413,'LV','Lielvārdes novads','Lielvārdes novads'),(414,'LV','LV-LM','Limbažu novads'),(415,'LV','Lubānas novads','Lubānas novads'),(416,'LV','LV-LU','Ludzas novads'),(417,'LV','Līgatnes novads','Līgatnes novads'),(418,'LV','Līvānu novads','Līvānu novads'),(419,'LV','LV-MA','Madonas novads'),(420,'LV','Mazsalacas novads','Mazsalacas novads'),(421,'LV','Mālpils novads','Mālpils novads'),(422,'LV','Mārupes novads','Mārupes novads'),(423,'LV','Naukšēnu novads','Naukšēnu novads'),(424,'LV','Neretas novads','Neretas novads'),(425,'LV','Nīcas novads','Nīcas novads'),(426,'LV','LV-OG','Ogres novads'),(427,'LV','Olaines novads','Olaines novads'),(428,'LV','Ozolnieku novads','Ozolnieku novads'),(429,'LV','LV-PR','Preiļu novads'),(430,'LV','Priekules novads','Priekules novads'),(431,'LV','Priekuļu novads','Priekuļu novads'),(432,'LV','Pārgaujas novads','Pārgaujas novads'),(433,'LV','Pāvilostas novads','Pāvilostas novads'),(434,'LV','Pļaviņu novads','Pļaviņu novads'),(435,'LV','Raunas novads','Raunas novads'),(436,'LV','Riebiņu novads','Riebiņu novads'),(437,'LV','Rojas novads','Rojas novads'),(438,'LV','Ropažu novads','Ropažu novads'),(439,'LV','Rucavas novads','Rucavas novads'),(440,'LV','Rugāju novads','Rugāju novads'),(441,'LV','Rundāles novads','Rundāles novads'),(442,'LV','LV-RE','Rēzeknes novads'),(443,'LV','Rūjienas novads','Rūjienas novads'),(444,'LV','Salacgrīvas novads','Salacgrīvas novads'),(445,'LV','Salas novads','Salas novads'),(446,'LV','Salaspils novads','Salaspils novads'),(447,'LV','LV-SA','Saldus novads'),(448,'LV','Saulkrastu novads','Saulkrastu novads'),(449,'LV','Siguldas novads','Siguldas novads'),(450,'LV','Skrundas novads','Skrundas novads'),(451,'LV','Skrīveru novads','Skrīveru novads'),(452,'LV','Smiltenes novads','Smiltenes novads'),(453,'LV','Stopiņu novads','Stopiņu novads'),(454,'LV','Strenču novads','Strenču novads'),(455,'LV','Sējas novads','Sējas novads'),(456,'LV','LV-TA','Talsu novads'),(457,'LV','LV-TU','Tukuma novads'),(458,'LV','Tērvetes novads','Tērvetes novads'),(459,'LV','Vaiņodes novads','Vaiņodes novads'),(460,'LV','LV-VK','Valkas novads'),(461,'LV','LV-VM','Valmieras novads'),(462,'LV','Varakļānu novads','Varakļānu novads'),(463,'LV','Vecpiebalgas novads','Vecpiebalgas novads'),(464,'LV','Vecumnieku novads','Vecumnieku novads'),(465,'LV','LV-VE','Ventspils novads'),(466,'LV','Viesītes novads','Viesītes novads'),(467,'LV','Viļakas novads','Viļakas novads'),(468,'LV','Viļānu novads','Viļānu novads'),(469,'LV','Vārkavas novads','Vārkavas novads'),(470,'LV','Zilupes novads','Zilupes novads'),(471,'LV','Ādažu novads','Ādažu novads'),(472,'LV','Ērgļu novads','Ērgļu novads'),(473,'LV','Ķeguma novads','Ķeguma novads'),(474,'LV','Ķekavas novads','Ķekavas novads'),(475,'LT','LT-AL','Alytaus Apskritis'),(476,'LT','LT-KU','Kauno Apskritis'),(477,'LT','LT-KL','Klaipėdos Apskritis'),(478,'LT','LT-MR','Marijampolės Apskritis'),(479,'LT','LT-PN','Panevėžio Apskritis'),(480,'LT','LT-SA','Šiaulių Apskritis'),(481,'LT','LT-TA','Tauragės Apskritis'),(482,'LT','LT-TE','Telšių Apskritis'),(483,'LT','LT-UT','Utenos Apskritis'),(484,'LT','LT-VL','Vilniaus Apskritis'),(485,'BR','AC','Acre'),(486,'BR','AL','Alagoas'),(487,'BR','AP','Amapá'),(488,'BR','AM','Amazonas'),(489,'BR','BA','Bahia'),(490,'BR','CE','Ceará'),(491,'BR','ES','Espírito Santo'),(492,'BR','GO','Goiás'),(493,'BR','MA','Maranhão'),(494,'BR','MT','Mato Grosso'),(495,'BR','MS','Mato Grosso do Sul'),(496,'BR','MG','Minas Gerais'),(497,'BR','PA','Pará'),(498,'BR','PB','Paraíba'),(499,'BR','PR','Paraná'),(500,'BR','PE','Pernambuco'),(501,'BR','PI','Piauí'),(502,'BR','RJ','Rio de Janeiro'),(503,'BR','RN','Rio Grande do Norte'),(504,'BR','RS','Rio Grande do Sul'),(505,'BR','RO','Rondônia'),(506,'BR','RR','Roraima'),(507,'BR','SC','Santa Catarina'),(508,'BR','SP','São Paulo'),(509,'BR','SE','Sergipe'),(510,'BR','TO','Tocantins'),(511,'BR','DF','Distrito Federal'),(512,'HR','HR-01','Zagrebačka županija'),(513,'HR','HR-02','Krapinsko-zagorska županija'),(514,'HR','HR-03','Sisačko-moslavačka županija'),(515,'HR','HR-04','Karlovačka županija'),(516,'HR','HR-05','Varaždinska županija'),(517,'HR','HR-06','Koprivničko-križevačka županija'),(518,'HR','HR-07','Bjelovarsko-bilogorska županija'),(519,'HR','HR-08','Primorsko-goranska županija'),(520,'HR','HR-09','Ličko-senjska županija'),(521,'HR','HR-10','Virovitičko-podravska županija'),(522,'HR','HR-11','Požeško-slavonska županija'),(523,'HR','HR-12','Brodsko-posavska županija'),(524,'HR','HR-13','Zadarska županija'),(525,'HR','HR-14','Osječko-baranjska županija'),(526,'HR','HR-15','Šibensko-kninska županija'),(527,'HR','HR-16','Vukovarsko-srijemska županija'),(528,'HR','HR-17','Splitsko-dalmatinska županija'),(529,'HR','HR-18','Istarska županija'),(530,'HR','HR-19','Dubrovačko-neretvanska županija'),(531,'HR','HR-20','Međimurska županija'),(532,'HR','HR-21','Grad Zagreb'),(533,'IN','AN','Andaman and Nicobar Islands'),(534,'IN','AP','Andhra Pradesh'),(535,'IN','AR','Arunachal Pradesh'),(536,'IN','AS','Assam'),(537,'IN','BR','Bihar'),(538,'IN','CH','Chandigarh'),(539,'IN','CT','Chhattisgarh'),(540,'IN','DN','Dadra and Nagar Haveli'),(541,'IN','DD','Daman and Diu'),(542,'IN','DL','Delhi'),(543,'IN','GA','Goa'),(544,'IN','GJ','Gujarat'),(545,'IN','HR','Haryana'),(546,'IN','HP','Himachal Pradesh'),(547,'IN','JK','Jammu and Kashmir'),(548,'IN','JH','Jharkhand'),(549,'IN','KA','Karnataka'),(550,'IN','KL','Kerala'),(551,'IN','LD','Lakshadweep'),(552,'IN','MP','Madhya Pradesh'),(553,'IN','MH','Maharashtra'),(554,'IN','MN','Manipur'),(555,'IN','ML','Meghalaya'),(556,'IN','MZ','Mizoram'),(557,'IN','NL','Nagaland'),(558,'IN','OR','Odisha'),(559,'IN','PY','Puducherry'),(560,'IN','PB','Punjab'),(561,'IN','RJ','Rajasthan'),(562,'IN','SK','Sikkim'),(563,'IN','TN','Tamil Nadu'),(564,'IN','TG','Telangana'),(565,'IN','TR','Tripura'),(566,'IN','UP','Uttar Pradesh'),(567,'IN','UT','Uttarakhand'),(568,'IN','WB','West Bengal'),(569,'AU','ACT','Australian Capital Territory'),(570,'AU','NSW','New South Wales'),(571,'AU','VIC','Victoria'),(572,'AU','QLD','Queensland'),(573,'AU','SA','South Australia'),(574,'AU','TAS','Tasmania'),(575,'AU','WA','Western Australia'),(576,'AU','NT','Northern Territory'),(577,'BE','VAN','Antwerpen'),(578,'BE','WBR','Brabant wallon'),(579,'BE','BRU','Brussels-Capital Region'),(580,'BE','WHT','Hainaut'),(581,'BE','VLI','Limburg'),(582,'BE','WLG','Liège'),(583,'BE','WLX','Luxembourg'),(584,'BE','WNA','Namur'),(585,'BE','VOV','Oost-Vlaanderen'),(586,'BE','VBR','Vlaams-Brabant'),(587,'BE','VWV','West-Vlaanderen'),(588,'CN','CN-AH','Anhui Sheng'),(589,'CN','CN-BJ','Beijing Shi'),(590,'CN','CN-CQ','Chongqing Shi'),(591,'CN','CN-FJ','Fujian Sheng'),(592,'CN','CN-GS','Gansu Sheng'),(593,'CN','CN-GD','Guangdong Sheng'),(594,'CN','CN-GX','Guangxi Zhuangzu Zizhiqu'),(595,'CN','CN-GZ','Guizhou Sheng'),(596,'CN','CN-HI','Hainan Sheng'),(597,'CN','CN-HE','Hebei Sheng'),(598,'CN','CN-HL','Heilongjiang Sheng'),(599,'CN','CN-HA','Henan Sheng'),(600,'CN','CN-HK','Hong Kong SAR'),(601,'CN','CN-HB','Hubei Sheng'),(602,'CN','CN-HN','Hunan Sheng'),(603,'CN','CN-JS','Jiangsu Sheng'),(604,'CN','CN-JX','Jiangxi Sheng'),(605,'CN','CN-JL','Jilin Sheng'),(606,'CN','CN-LN','Liaoning Sheng'),(607,'CN','CN-MO','Macao SAR'),(608,'CN','CN-NM','Nei Mongol Zizhiqu'),(609,'CN','CN-NX','Ningxia Huizi Zizhiqu'),(610,'CN','CN-QH','Qinghai Sheng'),(611,'CN','CN-SN','Shaanxi Sheng'),(612,'CN','CN-SD','Shandong Sheng'),(613,'CN','CN-SH','Shanghai Shi'),(614,'CN','CN-SX','Shanxi Sheng'),(615,'CN','CN-SC','Sichuan Sheng'),(616,'CN','CN-TW','Taiwan Sheng'),(617,'CN','CN-TJ','Tianjin Shi'),(618,'CN','CN-XJ','Xinjiang Uygur Zizhiqu'),(619,'CN','CN-XZ','Xizang Zizhiqu'),(620,'CN','CN-YN','Yunnan Sheng'),(621,'CN','CN-ZJ','Zhejiang Sheng'),(622,'CO','CO-AMA','Amazonas'),(623,'CO','CO-ANT','Antioquia'),(624,'CO','CO-ARA','Arauca'),(625,'CO','CO-ATL','Atlántico'),(626,'CO','CO-BOL','Bolívar'),(627,'CO','CO-BOY','Boyacá'),(628,'CO','CO-CAL','Caldas'),(629,'CO','CO-CAQ','Caquetá'),(630,'CO','CO-CAS','Casanare'),(631,'CO','CO-CAU','Cauca'),(632,'CO','CO-CES','Cesar'),(633,'CO','CO-CHO','Chocó'),(634,'CO','CO-COR','Córdoba'),(635,'CO','CO-CUN','Cundinamarca'),(636,'CO','CO-GUA','Guainía'),(637,'CO','CO-GUV','Guaviare'),(638,'CO','CO-HUL','Huila'),(639,'CO','CO-LAG','La Guajira'),(640,'CO','CO-MAG','Magdalena'),(641,'CO','CO-MET','Meta'),(642,'CO','CO-NAR','Nariño'),(643,'CO','CO-NSA','Norte de Santander'),(644,'CO','CO-PUT','Putumayo'),(645,'CO','CO-QUI','Quindío'),(646,'CO','CO-RIS','Risaralda'),(647,'CO','CO-SAP','San Andrés y Providencia'),(648,'CO','CO-SAN','Santander'),(649,'CO','CO-SUC','Sucre'),(650,'CO','CO-TOL','Tolima'),(651,'CO','CO-VAC','Valle del Cauca'),(652,'CO','CO-VAU','Vaupés'),(653,'CO','CO-VID','Vichada'),(654,'MX','AGU','Aguascalientes'),(655,'MX','BCN','Baja California'),(656,'MX','BCS','Baja California Sur'),(657,'MX','CAM','Campeche'),(658,'MX','CHP','Chiapas'),(659,'MX','CHH','Chihuahua'),(660,'MX','CMX','Ciudad de México'),(661,'MX','COA','Coahuila'),(662,'MX','COL','Colima'),(663,'MX','DUR','Durango'),(664,'MX','MEX','Estado de México'),(665,'MX','GUA','Guanajuato'),(666,'MX','GRO','Guerrero'),(667,'MX','HID','Hidalgo'),(668,'MX','JAL','Jalisco'),(669,'MX','MIC','Michoacán'),(670,'MX','MOR','Morelos'),(671,'MX','NAY','Nayarit'),(672,'MX','NLE','Nuevo León'),(673,'MX','OAX','Oaxaca'),(674,'MX','PUE','Puebla'),(675,'MX','QUE','Querétaro'),(676,'MX','ROO','Quintana Roo'),(677,'MX','SLP','San Luis Potosí'),(678,'MX','SIN','Sinaloa'),(679,'MX','SON','Sonora'),(680,'MX','TAB','Tabasco'),(681,'MX','TAM','Tamaulipas'),(682,'MX','TLA','Tlaxcala'),(683,'MX','VER','Veracruz'),(684,'MX','YUC','Yucatán'),(685,'MX','ZAC','Zacatecas'),(686,'PL','PL-02','dolnośląskie'),(687,'PL','PL-04','kujawsko-pomorskie'),(688,'PL','PL-06','lubelskie'),(689,'PL','PL-08','lubuskie'),(690,'PL','PL-10','łódzkie'),(691,'PL','PL-12','małopolskie'),(692,'PL','PL-14','mazowieckie'),(693,'PL','PL-16','opolskie'),(694,'PL','PL-18','podkarpackie'),(695,'PL','PL-20','podlaskie'),(696,'PL','PL-22','pomorskie'),(697,'PL','PL-24','śląskie'),(698,'PL','PL-26','świętokrzyskie'),(699,'PL','PL-28','warmińsko-mazurskie'),(700,'PL','PL-30','wielkopolskie'),(701,'PL','PL-32','zachodniopomorskie');

--
-- Table structure for table `directory_country_region_name`
--

CREATE TABLE `directory_country_region_name` (
  `locale` varchar(8) NOT NULL COMMENT 'Locale',
  `region_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Region ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
  PRIMARY KEY (`locale`,`region_id`),
  KEY `DIRECTORY_COUNTRY_REGION_NAME_REGION_ID` (`region_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Region Name';

--
-- Dumping data for table `directory_country_region_name`
--

INSERT INTO `directory_country_region_name` VALUES ('en_US',1,'Alabama'),('en_US',2,'Alaska'),('en_US',3,'American Samoa'),('en_US',4,'Arizona'),('en_US',5,'Arkansas'),('en_US',6,'Armed Forces Africa'),('en_US',7,'Armed Forces Americas'),('en_US',8,'Armed Forces Canada'),('en_US',9,'Armed Forces Europe'),('en_US',10,'Armed Forces Middle East'),('en_US',11,'Armed Forces Pacific'),('en_US',12,'California'),('en_US',13,'Colorado'),('en_US',14,'Connecticut'),('en_US',15,'Delaware'),('en_US',16,'District of Columbia'),('en_US',17,'Federated States Of Micronesia'),('en_US',18,'Florida'),('en_US',19,'Georgia'),('en_US',20,'Guam'),('en_US',21,'Hawaii'),('en_US',22,'Idaho'),('en_US',23,'Illinois'),('en_US',24,'Indiana'),('en_US',25,'Iowa'),('en_US',26,'Kansas'),('en_US',27,'Kentucky'),('en_US',28,'Louisiana'),('en_US',29,'Maine'),('en_US',30,'Marshall Islands'),('en_US',31,'Maryland'),('en_US',32,'Massachusetts'),('en_US',33,'Michigan'),('en_US',34,'Minnesota'),('en_US',35,'Mississippi'),('en_US',36,'Missouri'),('en_US',37,'Montana'),('en_US',38,'Nebraska'),('en_US',39,'Nevada'),('en_US',40,'New Hampshire'),('en_US',41,'New Jersey'),('en_US',42,'New Mexico'),('en_US',43,'New York'),('en_US',44,'North Carolina'),('en_US',45,'North Dakota'),('en_US',46,'Northern Mariana Islands'),('en_US',47,'Ohio'),('en_US',48,'Oklahoma'),('en_US',49,'Oregon'),('en_US',50,'Palau'),('en_US',51,'Pennsylvania'),('en_US',52,'Puerto Rico'),('en_US',53,'Rhode Island'),('en_US',54,'South Carolina'),('en_US',55,'South Dakota'),('en_US',56,'Tennessee'),('en_US',57,'Texas'),('en_US',58,'Utah'),('en_US',59,'Vermont'),('en_US',60,'Virgin Islands'),('en_US',61,'Virginia'),('en_US',62,'Washington'),('en_US',63,'West Virginia'),('en_US',64,'Wisconsin'),('en_US',65,'Wyoming'),('en_US',66,'Alberta'),('en_US',67,'British Columbia'),('en_US',68,'Manitoba'),('en_US',69,'Newfoundland and Labrador'),('en_US',70,'New Brunswick'),('en_US',71,'Nova Scotia'),('en_US',72,'Northwest Territories'),('en_US',73,'Nunavut'),('en_US',74,'Ontario'),('en_US',75,'Prince Edward Island'),('en_US',76,'Quebec'),('en_US',77,'Saskatchewan'),('en_US',78,'Yukon Territory'),('en_US',79,'Niedersachsen'),('en_US',80,'Baden-Württemberg'),('en_US',81,'Bayern'),('en_US',82,'Berlin'),('en_US',83,'Brandenburg'),('en_US',84,'Bremen'),('en_US',85,'Hamburg'),('en_US',86,'Hessen'),('en_US',87,'Mecklenburg-Vorpommern'),('en_US',88,'Nordrhein-Westfalen'),('en_US',89,'Rheinland-Pfalz'),('en_US',90,'Saarland'),('en_US',91,'Sachsen'),('en_US',92,'Sachsen-Anhalt'),('en_US',93,'Schleswig-Holstein'),('en_US',94,'Thüringen'),('en_US',95,'Wien'),('en_US',96,'Niederösterreich'),('en_US',97,'Oberösterreich'),('en_US',98,'Salzburg'),('en_US',99,'Kärnten'),('en_US',100,'Steiermark'),('en_US',101,'Tirol'),('en_US',102,'Burgenland'),('en_US',103,'Vorarlberg'),('en_US',104,'Aargau'),('en_US',105,'Appenzell Innerrhoden'),('en_US',106,'Appenzell Ausserrhoden'),('en_US',107,'Bern'),('en_US',108,'Basel-Landschaft'),('en_US',109,'Basel-Stadt'),('en_US',110,'Freiburg'),('en_US',111,'Genf'),('en_US',112,'Glarus'),('en_US',113,'Graubünden'),('en_US',114,'Jura'),('en_US',115,'Luzern'),('en_US',116,'Neuenburg'),('en_US',117,'Nidwalden'),('en_US',118,'Obwalden'),('en_US',119,'St. Gallen'),('en_US',120,'Schaffhausen'),('en_US',121,'Solothurn'),('en_US',122,'Schwyz'),('en_US',123,'Thurgau'),('en_US',124,'Tessin'),('en_US',125,'Uri'),('en_US',126,'Waadt'),('en_US',127,'Wallis'),('en_US',128,'Zug'),('en_US',129,'Zürich'),('en_US',130,'A Coruña'),('en_US',131,'Alava'),('en_US',132,'Albacete'),('en_US',133,'Alicante'),('en_US',134,'Almeria'),('en_US',135,'Asturias'),('en_US',136,'Avila'),('en_US',137,'Badajoz'),('en_US',138,'Baleares'),('en_US',139,'Barcelona'),('en_US',140,'Burgos'),('en_US',141,'Caceres'),('en_US',142,'Cadiz'),('en_US',143,'Cantabria'),('en_US',144,'Castellon'),('en_US',145,'Ceuta'),('en_US',146,'Ciudad Real'),('en_US',147,'Cordoba'),('en_US',148,'Cuenca'),('en_US',149,'Girona'),('en_US',150,'Granada'),('en_US',151,'Guadalajara'),('en_US',152,'Guipuzcoa'),('en_US',153,'Huelva'),('en_US',154,'Huesca'),('en_US',155,'Jaen'),('en_US',156,'La Rioja'),('en_US',157,'Las Palmas'),('en_US',158,'Leon'),('en_US',159,'Lleida'),('en_US',160,'Lugo'),('en_US',161,'Madrid'),('en_US',162,'Malaga'),('en_US',163,'Melilla'),('en_US',164,'Murcia'),('en_US',165,'Navarra'),('en_US',166,'Ourense'),('en_US',167,'Palencia'),('en_US',168,'Pontevedra'),('en_US',169,'Salamanca'),('en_US',170,'Santa Cruz de Tenerife'),('en_US',171,'Segovia'),('en_US',172,'Sevilla'),('en_US',173,'Soria'),('en_US',174,'Tarragona'),('en_US',175,'Teruel'),('en_US',176,'Toledo'),('en_US',177,'Valencia'),('en_US',178,'Valladolid'),('en_US',179,'Vizcaya'),('en_US',180,'Zamora'),('en_US',181,'Zaragoza'),('en_US',182,'Ain'),('en_US',183,'Aisne'),('en_US',184,'Allier'),('en_US',185,'Alpes-de-Haute-Provence'),('en_US',186,'Hautes-Alpes'),('en_US',187,'Alpes-Maritimes'),('en_US',188,'Ardèche'),('en_US',189,'Ardennes'),('en_US',190,'Ariège'),('en_US',191,'Aube'),('en_US',192,'Aude'),('en_US',193,'Aveyron'),('en_US',194,'Bouches-du-Rhône'),('en_US',195,'Calvados'),('en_US',196,'Cantal'),('en_US',197,'Charente'),('en_US',198,'Charente-Maritime'),('en_US',199,'Cher'),('en_US',200,'Corrèze'),('en_US',201,'Corse-du-Sud'),('en_US',202,'Haute-Corse'),('en_US',203,'Côte-d\'Or'),('en_US',204,'Côtes-d\'Armor'),('en_US',205,'Creuse'),('en_US',206,'Dordogne'),('en_US',207,'Doubs'),('en_US',208,'Drôme'),('en_US',209,'Eure'),('en_US',210,'Eure-et-Loir'),('en_US',211,'Finistère'),('en_US',212,'Gard'),('en_US',213,'Haute-Garonne'),('en_US',214,'Gers'),('en_US',215,'Gironde'),('en_US',216,'Hérault'),('en_US',217,'Ille-et-Vilaine'),('en_US',218,'Indre'),('en_US',219,'Indre-et-Loire'),('en_US',220,'Isère'),('en_US',221,'Jura'),('en_US',222,'Landes'),('en_US',223,'Loir-et-Cher'),('en_US',224,'Loire'),('en_US',225,'Haute-Loire'),('en_US',226,'Loire-Atlantique'),('en_US',227,'Loiret'),('en_US',228,'Lot'),('en_US',229,'Lot-et-Garonne'),('en_US',230,'Lozère'),('en_US',231,'Maine-et-Loire'),('en_US',232,'Manche'),('en_US',233,'Marne'),('en_US',234,'Haute-Marne'),('en_US',235,'Mayenne'),('en_US',236,'Meurthe-et-Moselle'),('en_US',237,'Meuse'),('en_US',238,'Morbihan'),('en_US',239,'Moselle'),('en_US',240,'Nièvre'),('en_US',241,'Nord'),('en_US',242,'Oise'),('en_US',243,'Orne'),('en_US',244,'Pas-de-Calais'),('en_US',245,'Puy-de-Dôme'),('en_US',246,'Pyrénées-Atlantiques'),('en_US',247,'Hautes-Pyrénées'),('en_US',248,'Pyrénées-Orientales'),('en_US',249,'Bas-Rhin'),('en_US',250,'Haut-Rhin'),('en_US',251,'Rhône'),('en_US',252,'Haute-Saône'),('en_US',253,'Saône-et-Loire'),('en_US',254,'Sarthe'),('en_US',255,'Savoie'),('en_US',256,'Haute-Savoie'),('en_US',257,'Paris'),('en_US',258,'Seine-Maritime'),('en_US',259,'Seine-et-Marne'),('en_US',260,'Yvelines'),('en_US',261,'Deux-Sèvres'),('en_US',262,'Somme'),('en_US',263,'Tarn'),('en_US',264,'Tarn-et-Garonne'),('en_US',265,'Var'),('en_US',266,'Vaucluse'),('en_US',267,'Vendée'),('en_US',268,'Vienne'),('en_US',269,'Haute-Vienne'),('en_US',270,'Vosges'),('en_US',271,'Yonne'),('en_US',272,'Territoire-de-Belfort'),('en_US',273,'Essonne'),('en_US',274,'Hauts-de-Seine'),('en_US',275,'Seine-Saint-Denis'),('en_US',276,'Val-de-Marne'),('en_US',277,'Val-d\'Oise'),('en_US',278,'Alba'),('en_US',279,'Arad'),('en_US',280,'Argeş'),('en_US',281,'Bacău'),('en_US',282,'Bihor'),('en_US',283,'Bistriţa-Năsăud'),('en_US',284,'Botoşani'),('en_US',285,'Braşov'),('en_US',286,'Brăila'),('en_US',287,'Bucureşti'),('en_US',288,'Buzău'),('en_US',289,'Caraş-Severin'),('en_US',290,'Călăraşi'),('en_US',291,'Cluj'),('en_US',292,'Constanţa'),('en_US',293,'Covasna'),('en_US',294,'Dâmboviţa'),('en_US',295,'Dolj'),('en_US',296,'Galaţi'),('en_US',297,'Giurgiu'),('en_US',298,'Gorj'),('en_US',299,'Harghita'),('en_US',300,'Hunedoara'),('en_US',301,'Ialomiţa'),('en_US',302,'Iaşi'),('en_US',303,'Ilfov'),('en_US',304,'Maramureş'),('en_US',305,'Mehedinţi'),('en_US',306,'Mureş'),('en_US',307,'Neamţ'),('en_US',308,'Olt'),('en_US',309,'Prahova'),('en_US',310,'Satu-Mare'),('en_US',311,'Sălaj'),('en_US',312,'Sibiu'),('en_US',313,'Suceava'),('en_US',314,'Teleorman'),('en_US',315,'Timiş'),('en_US',316,'Tulcea'),('en_US',317,'Vaslui'),('en_US',318,'Vâlcea'),('en_US',319,'Vrancea'),('en_US',320,'Lappi'),('en_US',321,'Pohjois-Pohjanmaa'),('en_US',322,'Kainuu'),('en_US',323,'Pohjois-Karjala'),('en_US',324,'Pohjois-Savo'),('en_US',325,'Etelä-Savo'),('en_US',326,'Etelä-Pohjanmaa'),('en_US',327,'Pohjanmaa'),('en_US',328,'Pirkanmaa'),('en_US',329,'Satakunta'),('en_US',330,'Keski-Pohjanmaa'),('en_US',331,'Keski-Suomi'),('en_US',332,'Varsinais-Suomi'),('en_US',333,'Etelä-Karjala'),('en_US',334,'Päijät-Häme'),('en_US',335,'Kanta-Häme'),('en_US',336,'Uusimaa'),('en_US',337,'Itä-Uusimaa'),('en_US',338,'Kymenlaakso'),('en_US',339,'Ahvenanmaa'),('en_US',340,'Harjumaa'),('en_US',341,'Hiiumaa'),('en_US',342,'Ida-Virumaa'),('en_US',343,'Jõgevamaa'),('en_US',344,'Järvamaa'),('en_US',345,'Läänemaa'),('en_US',346,'Lääne-Virumaa'),('en_US',347,'Põlvamaa'),('en_US',348,'Pärnumaa'),('en_US',349,'Raplamaa'),('en_US',350,'Saaremaa'),('en_US',351,'Tartumaa'),('en_US',352,'Valgamaa'),('en_US',353,'Viljandimaa'),('en_US',354,'Võrumaa'),('en_US',355,'Daugavpils'),('en_US',356,'Jelgava'),('en_US',357,'Jēkabpils'),('en_US',358,'Jūrmala'),('en_US',359,'Liepāja'),('en_US',360,'Liepājas novads'),('en_US',361,'Rēzekne'),('en_US',362,'Rīga'),('en_US',363,'Rīgas novads'),('en_US',364,'Valmiera'),('en_US',365,'Ventspils'),('en_US',366,'Aglonas novads'),('en_US',367,'Aizkraukles novads'),('en_US',368,'Aizputes novads'),('en_US',369,'Aknīstes novads'),('en_US',370,'Alojas novads'),('en_US',371,'Alsungas novads'),('en_US',372,'Alūksnes novads'),('en_US',373,'Amatas novads'),('en_US',374,'Apes novads'),('en_US',375,'Auces novads'),('en_US',376,'Babītes novads'),('en_US',377,'Baldones novads'),('en_US',378,'Baltinavas novads'),('en_US',379,'Balvu novads'),('en_US',380,'Bauskas novads'),('en_US',381,'Beverīnas novads'),('en_US',382,'Brocēnu novads'),('en_US',383,'Burtnieku novads'),('en_US',384,'Carnikavas novads'),('en_US',385,'Cesvaines novads'),('en_US',386,'Ciblas novads'),('en_US',387,'Cēsu novads'),('en_US',388,'Dagdas novads'),('en_US',389,'Daugavpils novads'),('en_US',390,'Dobeles novads'),('en_US',391,'Dundagas novads'),('en_US',392,'Durbes novads'),('en_US',393,'Engures novads'),('en_US',394,'Garkalnes novads'),('en_US',395,'Grobiņas novads'),('en_US',396,'Gulbenes novads'),('en_US',397,'Iecavas novads'),('en_US',398,'Ikšķiles novads'),('en_US',399,'Ilūkstes novads'),('en_US',400,'Inčukalna novads'),('en_US',401,'Jaunjelgavas novads'),('en_US',402,'Jaunpiebalgas novads'),('en_US',403,'Jaunpils novads'),('en_US',404,'Jelgavas novads'),('en_US',405,'Jēkabpils novads'),('en_US',406,'Kandavas novads'),('en_US',407,'Kokneses novads'),('en_US',408,'Krimuldas novads'),('en_US',409,'Krustpils novads'),('en_US',410,'Krāslavas novads'),('en_US',411,'Kuldīgas novads'),('en_US',412,'Kārsavas novads'),('en_US',413,'Lielvārdes novads'),('en_US',414,'Limbažu novads'),('en_US',415,'Lubānas novads'),('en_US',416,'Ludzas novads'),('en_US',417,'Līgatnes novads'),('en_US',418,'Līvānu novads'),('en_US',419,'Madonas novads'),('en_US',420,'Mazsalacas novads'),('en_US',421,'Mālpils novads'),('en_US',422,'Mārupes novads'),('en_US',423,'Naukšēnu novads'),('en_US',424,'Neretas novads'),('en_US',425,'Nīcas novads'),('en_US',426,'Ogres novads'),('en_US',427,'Olaines novads'),('en_US',428,'Ozolnieku novads'),('en_US',429,'Preiļu novads'),('en_US',430,'Priekules novads'),('en_US',431,'Priekuļu novads'),('en_US',432,'Pārgaujas novads'),('en_US',433,'Pāvilostas novads'),('en_US',434,'Pļaviņu novads'),('en_US',435,'Raunas novads'),('en_US',436,'Riebiņu novads'),('en_US',437,'Rojas novads'),('en_US',438,'Ropažu novads'),('en_US',439,'Rucavas novads'),('en_US',440,'Rugāju novads'),('en_US',441,'Rundāles novads'),('en_US',442,'Rēzeknes novads'),('en_US',443,'Rūjienas novads'),('en_US',444,'Salacgrīvas novads'),('en_US',445,'Salas novads'),('en_US',446,'Salaspils novads'),('en_US',447,'Saldus novads'),('en_US',448,'Saulkrastu novads'),('en_US',449,'Siguldas novads'),('en_US',450,'Skrundas novads'),('en_US',451,'Skrīveru novads'),('en_US',452,'Smiltenes novads'),('en_US',453,'Stopiņu novads'),('en_US',454,'Strenču novads'),('en_US',455,'Sējas novads'),('en_US',456,'Talsu novads'),('en_US',457,'Tukuma novads'),('en_US',458,'Tērvetes novads'),('en_US',459,'Vaiņodes novads'),('en_US',460,'Valkas novads'),('en_US',461,'Valmieras novads'),('en_US',462,'Varakļānu novads'),('en_US',463,'Vecpiebalgas novads'),('en_US',464,'Vecumnieku novads'),('en_US',465,'Ventspils novads'),('en_US',466,'Viesītes novads'),('en_US',467,'Viļakas novads'),('en_US',468,'Viļānu novads'),('en_US',469,'Vārkavas novads'),('en_US',470,'Zilupes novads'),('en_US',471,'Ādažu novads'),('en_US',472,'Ērgļu novads'),('en_US',473,'Ķeguma novads'),('en_US',474,'Ķekavas novads'),('en_US',475,'Alytaus Apskritis'),('en_US',476,'Kauno Apskritis'),('en_US',477,'Klaipėdos Apskritis'),('en_US',478,'Marijampolės Apskritis'),('en_US',479,'Panevėžio Apskritis'),('en_US',480,'Šiaulių Apskritis'),('en_US',481,'Tauragės Apskritis'),('en_US',482,'Telšių Apskritis'),('en_US',483,'Utenos Apskritis'),('en_US',484,'Vilniaus Apskritis'),('en_US',485,'Acre'),('en_US',486,'Alagoas'),('en_US',487,'Amapá'),('en_US',488,'Amazonas'),('en_US',489,'Bahia'),('en_US',490,'Ceará'),('en_US',491,'Espírito Santo'),('en_US',492,'Goiás'),('en_US',493,'Maranhão'),('en_US',494,'Mato Grosso'),('en_US',495,'Mato Grosso do Sul'),('en_US',496,'Minas Gerais'),('en_US',497,'Pará'),('en_US',498,'Paraíba'),('en_US',499,'Paraná'),('en_US',500,'Pernambuco'),('en_US',501,'Piauí'),('en_US',502,'Rio de Janeiro'),('en_US',503,'Rio Grande do Norte'),('en_US',504,'Rio Grande do Sul'),('en_US',505,'Rondônia'),('en_US',506,'Roraima'),('en_US',507,'Santa Catarina'),('en_US',508,'São Paulo'),('en_US',509,'Sergipe'),('en_US',510,'Tocantins'),('en_US',511,'Distrito Federal'),('en_US',512,'Zagrebačka županija'),('en_US',513,'Krapinsko-zagorska županija'),('en_US',514,'Sisačko-moslavačka županija'),('en_US',515,'Karlovačka županija'),('en_US',516,'Varaždinska županija'),('en_US',517,'Koprivničko-križevačka županija'),('en_US',518,'Bjelovarsko-bilogorska županija'),('en_US',519,'Primorsko-goranska županija'),('en_US',520,'Ličko-senjska županija'),('en_US',521,'Virovitičko-podravska županija'),('en_US',522,'Požeško-slavonska županija'),('en_US',523,'Brodsko-posavska županija'),('en_US',524,'Zadarska županija'),('en_US',525,'Osječko-baranjska županija'),('en_US',526,'Šibensko-kninska županija'),('en_US',527,'Vukovarsko-srijemska županija'),('en_US',528,'Splitsko-dalmatinska županija'),('en_US',529,'Istarska županija'),('en_US',530,'Dubrovačko-neretvanska županija'),('en_US',531,'Međimurska županija'),('en_US',532,'Grad Zagreb'),('en_US',533,'Andaman and Nicobar Islands'),('en_US',534,'Andhra Pradesh'),('en_US',535,'Arunachal Pradesh'),('en_US',536,'Assam'),('en_US',537,'Bihar'),('en_US',538,'Chandigarh'),('en_US',539,'Chhattisgarh'),('en_US',540,'Dadra and Nagar Haveli'),('en_US',541,'Daman and Diu'),('en_US',542,'Delhi'),('en_US',543,'Goa'),('en_US',544,'Gujarat'),('en_US',545,'Haryana'),('en_US',546,'Himachal Pradesh'),('en_US',547,'Jammu and Kashmir'),('en_US',548,'Jharkhand'),('en_US',549,'Karnataka'),('en_US',550,'Kerala'),('en_US',551,'Lakshadweep'),('en_US',552,'Madhya Pradesh'),('en_US',553,'Maharashtra'),('en_US',554,'Manipur'),('en_US',555,'Meghalaya'),('en_US',556,'Mizoram'),('en_US',557,'Nagaland'),('en_US',558,'Odisha'),('en_US',559,'Puducherry'),('en_US',560,'Punjab'),('en_US',561,'Rajasthan'),('en_US',562,'Sikkim'),('en_US',563,'Tamil Nadu'),('en_US',564,'Telangana'),('en_US',565,'Tripura'),('en_US',566,'Uttar Pradesh'),('en_US',567,'Uttarakhand'),('en_US',568,'West Bengal'),('en_US',569,'Australian Capital Territory'),('en_US',570,'New South Wales'),('en_US',571,'Victoria'),('en_US',572,'Queensland'),('en_US',573,'South Australia'),('en_US',574,'Tasmania'),('en_US',575,'Western Australia'),('en_US',576,'Northern Territory'),('en_US',577,'Antwerpen'),('en_US',578,'Brabant wallon'),('en_US',579,'Brussels-Capital Region'),('en_US',580,'Hainaut'),('en_US',581,'Limburg'),('en_US',582,'Liège'),('en_US',583,'Luxembourg'),('en_US',584,'Namur'),('en_US',585,'Oost-Vlaanderen'),('en_US',586,'Vlaams-Brabant'),('en_US',587,'West-Vlaanderen'),('en_US',588,'Anhui Sheng'),('en_US',589,'Beijing Shi'),('en_US',590,'Chongqing Shi'),('en_US',591,'Fujian Sheng'),('en_US',592,'Gansu Sheng'),('en_US',593,'Guangdong Sheng'),('en_US',594,'Guangxi Zhuangzu Zizhiqu'),('en_US',595,'Guizhou Sheng'),('en_US',596,'Hainan Sheng'),('en_US',597,'Hebei Sheng'),('en_US',598,'Heilongjiang Sheng'),('en_US',599,'Henan Sheng'),('en_US',600,'Hong Kong SAR'),('en_US',601,'Hubei Sheng'),('en_US',602,'Hunan Sheng'),('en_US',603,'Jiangsu Sheng'),('en_US',604,'Jiangxi Sheng'),('en_US',605,'Jilin Sheng'),('en_US',606,'Liaoning Sheng'),('en_US',607,'Macao SAR'),('en_US',608,'Nei Mongol Zizhiqu'),('en_US',609,'Ningxia Huizi Zizhiqu'),('en_US',610,'Qinghai Sheng'),('en_US',611,'Shaanxi Sheng'),('en_US',612,'Shandong Sheng'),('en_US',613,'Shanghai Shi'),('en_US',614,'Shanxi Sheng'),('en_US',615,'Sichuan Sheng'),('en_US',616,'Taiwan Sheng'),('en_US',617,'Tianjin Shi'),('en_US',618,'Xinjiang Uygur Zizhiqu'),('en_US',619,'Xizang Zizhiqu'),('en_US',620,'Yunnan Sheng'),('en_US',621,'Zhejiang Sheng'),('en_US',622,'Amazonas'),('en_US',623,'Antioquia'),('en_US',624,'Arauca'),('en_US',625,'Atlántico'),('en_US',626,'Bolívar'),('en_US',627,'Boyacá'),('en_US',628,'Caldas'),('en_US',629,'Caquetá'),('en_US',630,'Casanare'),('en_US',631,'Cauca'),('en_US',632,'Cesar'),('en_US',633,'Chocó'),('en_US',634,'Córdoba'),('en_US',635,'Cundinamarca'),('en_US',636,'Guainía'),('en_US',637,'Guaviare'),('en_US',638,'Huila'),('en_US',639,'La Guajira'),('en_US',640,'Magdalena'),('en_US',641,'Meta'),('en_US',642,'Nariño'),('en_US',643,'Norte de Santander'),('en_US',644,'Putumayo'),('en_US',645,'Quindío'),('en_US',646,'Risaralda'),('en_US',647,'San Andrés y Providencia'),('en_US',648,'Santander'),('en_US',649,'Sucre'),('en_US',650,'Tolima'),('en_US',651,'Valle del Cauca'),('en_US',652,'Vaupés'),('en_US',653,'Vichada'),('en_US',654,'Aguascalientes'),('en_US',655,'Baja California'),('en_US',656,'Baja California Sur'),('en_US',657,'Campeche'),('en_US',658,'Chiapas'),('en_US',659,'Chihuahua'),('en_US',660,'Ciudad de México'),('en_US',661,'Coahuila'),('en_US',662,'Colima'),('en_US',663,'Durango'),('en_US',664,'Estado de México'),('en_US',665,'Guanajuato'),('en_US',666,'Guerrero'),('en_US',667,'Hidalgo'),('en_US',668,'Jalisco'),('en_US',669,'Michoacán'),('en_US',670,'Morelos'),('en_US',671,'Nayarit'),('en_US',672,'Nuevo León'),('en_US',673,'Oaxaca'),('en_US',674,'Puebla'),('en_US',675,'Querétaro'),('en_US',676,'Quintana Roo'),('en_US',677,'San Luis Potosí'),('en_US',678,'Sinaloa'),('en_US',679,'Sonora'),('en_US',680,'Tabasco'),('en_US',681,'Tamaulipas'),('en_US',682,'Tlaxcala'),('en_US',683,'Veracruz'),('en_US',684,'Yucatán'),('en_US',685,'Zacatecas'),('en_US',686,'dolnośląskie'),('en_US',687,'kujawsko-pomorskie'),('en_US',688,'lubelskie'),('en_US',689,'lubuskie'),('en_US',690,'łódzkie'),('en_US',691,'małopolskie'),('en_US',692,'mazowieckie'),('en_US',693,'opolskie'),('en_US',694,'podkarpackie'),('en_US',695,'podlaskie'),('en_US',696,'pomorskie'),('en_US',697,'śląskie'),('en_US',698,'świętokrzyskie'),('en_US',699,'warmińsko-mazurskie'),('en_US',700,'wielkopolskie'),('en_US',701,'zachodniopomorskie');

--
-- Table structure for table `directory_currency_rate`
--

CREATE TABLE `directory_currency_rate` (
  `currency_from` varchar(3) NOT NULL COMMENT 'Currency Code Convert From',
  `currency_to` varchar(3) NOT NULL COMMENT 'Currency Code Convert To',
  `rate` decimal(24,12) NOT NULL DEFAULT '0.000000000000' COMMENT 'Currency Conversion Rate',
  PRIMARY KEY (`currency_from`,`currency_to`),
  KEY `DIRECTORY_CURRENCY_RATE_CURRENCY_TO` (`currency_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Currency Rate';

--
-- Dumping data for table `directory_currency_rate`
--

INSERT INTO `directory_currency_rate` VALUES ('EUR','EUR',1.000000000000),('EUR','USD',1.415000000000),('SEK','SEK',1.000000000000),('USD','EUR',0.706700000000),('USD','USD',1.000000000000);

--
-- Table structure for table `downloadable_link`
--

CREATE TABLE `downloadable_link` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort order',
  `number_of_downloads` int(11) DEFAULT NULL COMMENT 'Number of downloads',
  `is_shareable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Shareable flag',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Link Url',
  `link_file` varchar(255) DEFAULT NULL COMMENT 'Link File',
  `link_type` varchar(20) DEFAULT NULL COMMENT 'Link Type',
  `sample_url` varchar(255) DEFAULT NULL COMMENT 'Sample Url',
  `sample_file` varchar(255) DEFAULT NULL COMMENT 'Sample File',
  `sample_type` varchar(20) DEFAULT NULL COMMENT 'Sample Type',
  PRIMARY KEY (`link_id`),
  KEY `DOWNLOADABLE_LINK_PRODUCT_ID_SORT_ORDER` (`product_id`,`sort_order`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Table';

--
-- Dumping data for table `downloadable_link`
--


--
-- Table structure for table `downloadable_link_price`
--

CREATE TABLE `downloadable_link_price` (
  `price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `price` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Price',
  PRIMARY KEY (`price_id`),
  KEY `DOWNLOADABLE_LINK_PRICE_LINK_ID` (`link_id`),
  KEY `DOWNLOADABLE_LINK_PRICE_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Price Table';

--
-- Dumping data for table `downloadable_link_price`
--


--
-- Table structure for table `downloadable_link_purchased`
--

CREATE TABLE `downloadable_link_purchased` (
  `purchased_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Purchased ID',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order Item ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date of creation',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of modification',
  `customer_id` int(10) unsigned DEFAULT '0' COMMENT 'Customer ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product name',
  `product_sku` varchar(255) DEFAULT NULL COMMENT 'Product sku',
  `link_section_title` varchar(255) DEFAULT NULL COMMENT 'Link_section_title',
  PRIMARY KEY (`purchased_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ORDER_ID` (`order_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ORDER_ITEM_ID` (`order_item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Table';

--
-- Dumping data for table `downloadable_link_purchased`
--


--
-- Table structure for table `downloadable_link_purchased_item`
--

CREATE TABLE `downloadable_link_purchased_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `purchased_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Purchased ID',
  `order_item_id` int(10) unsigned DEFAULT '0' COMMENT 'Order Item ID',
  `product_id` int(10) unsigned DEFAULT '0' COMMENT 'Product ID',
  `link_hash` varchar(255) DEFAULT NULL COMMENT 'Link hash',
  `number_of_downloads_bought` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads bought',
  `number_of_downloads_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads used',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `link_title` varchar(255) DEFAULT NULL COMMENT 'Link Title',
  `is_shareable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Shareable Flag',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Link Url',
  `link_file` varchar(255) DEFAULT NULL COMMENT 'Link File',
  `link_type` varchar(255) DEFAULT NULL COMMENT 'Link Type',
  `status` varchar(50) DEFAULT NULL COMMENT 'Status',
  `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 (`item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_LINK_HASH` (`link_hash`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_ORDER_ITEM_ID` (`order_item_id`),
  KEY `DOWNLOADABLE_LINK_PURCHASED_ITEM_PURCHASED_ID` (`purchased_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Item Table';

--
-- Dumping data for table `downloadable_link_purchased_item`
--


--
-- Table structure for table `downloadable_link_title`
--

CREATE TABLE `downloadable_link_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `DOWNLOADABLE_LINK_TITLE_LINK_ID_STORE_ID` (`link_id`,`store_id`),
  KEY `DOWNLOADABLE_LINK_TITLE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link Title Table';

--
-- Dumping data for table `downloadable_link_title`
--


--
-- Table structure for table `downloadable_sample`
--

CREATE TABLE `downloadable_sample` (
  `sample_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sample ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `sample_url` varchar(255) DEFAULT NULL COMMENT 'Sample URL',
  `sample_file` varchar(255) DEFAULT NULL COMMENT 'Sample file',
  `sample_type` varchar(20) DEFAULT NULL COMMENT 'Sample Type',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`sample_id`),
  KEY `DOWNLOADABLE_SAMPLE_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Table';

--
-- Dumping data for table `downloadable_sample`
--


--
-- Table structure for table `downloadable_sample_title`
--

CREATE TABLE `downloadable_sample_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `sample_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sample ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID_STORE_ID` (`sample_id`,`store_id`),
  KEY `DOWNLOADABLE_SAMPLE_TITLE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Title Table';

--
-- Dumping data for table `downloadable_sample_title`
--


--
-- Table structure for table `eav_attribute`
--

CREATE TABLE `eav_attribute` (
  `attribute_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_code` varchar(255) NOT NULL COMMENT 'Attribute Code',
  `attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
  `backend_model` varchar(255) DEFAULT NULL COMMENT 'Backend Model',
  `backend_type` varchar(8) NOT NULL DEFAULT 'static' COMMENT 'Backend Type',
  `backend_table` varchar(255) DEFAULT NULL COMMENT 'Backend Table',
  `frontend_model` varchar(255) DEFAULT NULL COMMENT 'Frontend Model',
  `frontend_input` varchar(50) DEFAULT NULL COMMENT 'Frontend Input',
  `frontend_label` varchar(255) DEFAULT NULL COMMENT 'Frontend Label',
  `frontend_class` varchar(255) DEFAULT NULL COMMENT 'Frontend Class',
  `source_model` varchar(255) DEFAULT NULL COMMENT 'Source Model',
  `is_required` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Required',
  `is_user_defined` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is User Defined',
  `default_value` text COMMENT 'Default Value',
  `is_unique` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Defines Is Unique',
  `note` varchar(255) DEFAULT NULL COMMENT 'Note',
  PRIMARY KEY (`attribute_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`),
  KEY `EAV_ATTRIBUTE_FRONTEND_INPUT_ENTITY_TYPE_ID_IS_USER_DEFINED` (`frontend_input`,`entity_type_id`,`is_user_defined`)
) ENGINE=InnoDB AUTO_INCREMENT=162 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute';

--
-- Dumping data for table `eav_attribute`
--

INSERT INTO `eav_attribute` VALUES (1,1,'website_id',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Website','static',NULL,NULL,'select','Associate to Website',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Website',1,0,NULL,0,NULL),(2,1,'store_id',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Store','static',NULL,NULL,'select','Create In',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Store',1,0,NULL,0,NULL),(3,1,'created_in',NULL,NULL,'static',NULL,NULL,'text','Created From',NULL,NULL,0,0,NULL,0,NULL),(4,1,'prefix',NULL,NULL,'static',NULL,NULL,'text','Name Prefix',NULL,NULL,0,0,NULL,0,NULL),(5,1,'firstname',NULL,NULL,'static',NULL,NULL,'text','First Name',NULL,NULL,1,0,NULL,0,NULL),(6,1,'middlename',NULL,NULL,'static',NULL,NULL,'text','Middle Name/Initial',NULL,NULL,0,0,NULL,0,NULL),(7,1,'lastname',NULL,NULL,'static',NULL,NULL,'text','Last Name',NULL,NULL,1,0,NULL,0,NULL),(8,1,'suffix',NULL,NULL,'static',NULL,NULL,'text','Name Suffix',NULL,NULL,0,0,NULL,0,NULL),(9,1,'email',NULL,NULL,'static',NULL,NULL,'text','Email',NULL,NULL,1,0,NULL,0,NULL),(10,1,'group_id',NULL,NULL,'static',NULL,NULL,'select','Group',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Group',1,0,NULL,0,NULL),(11,1,'dob',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','static',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Frontend\\Datetime','date','Date of Birth',NULL,NULL,0,0,NULL,0,NULL),(12,1,'password_hash',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Password','static',NULL,NULL,'hidden',NULL,NULL,NULL,0,0,NULL,0,NULL),(13,1,'rp_token',NULL,NULL,'static',NULL,NULL,'hidden',NULL,NULL,NULL,0,0,NULL,0,NULL),(14,1,'rp_token_created_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,0,0,NULL,0,NULL),(15,1,'default_billing',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Billing','static',NULL,NULL,'text','Default Billing Address',NULL,NULL,0,0,NULL,0,NULL),(16,1,'default_shipping',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Shipping','static',NULL,NULL,'text','Default Shipping Address',NULL,NULL,0,0,NULL,0,NULL),(17,1,'taxvat',NULL,NULL,'static',NULL,NULL,'text','Tax/VAT Number',NULL,NULL,0,0,NULL,0,NULL),(18,1,'confirmation',NULL,NULL,'static',NULL,NULL,'text','Is Confirmed',NULL,NULL,0,0,NULL,0,NULL),(19,1,'created_at',NULL,NULL,'static',NULL,NULL,'date','Created At',NULL,NULL,0,0,NULL,0,NULL),(20,1,'gender',NULL,NULL,'static',NULL,NULL,'select','Gender',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,0,NULL,0,NULL),(21,1,'disable_auto_group_change','Magento\\Customer\\Model\\Attribute','Magento\\Customer\\Model\\Attribute\\Backend\\Data\\Boolean','static',NULL,NULL,'boolean','Disable Automatic Group Change Based on VAT ID',NULL,NULL,0,0,NULL,0,NULL),(22,2,'prefix',NULL,NULL,'static',NULL,NULL,'text','Name Prefix',NULL,NULL,0,0,NULL,0,NULL),(23,2,'firstname',NULL,NULL,'static',NULL,NULL,'text','First Name',NULL,NULL,1,0,NULL,0,NULL),(24,2,'middlename',NULL,NULL,'static',NULL,NULL,'text','Middle Name/Initial',NULL,NULL,0,0,NULL,0,NULL),(25,2,'lastname',NULL,NULL,'static',NULL,NULL,'text','Last Name',NULL,NULL,1,0,NULL,0,NULL),(26,2,'suffix',NULL,NULL,'static',NULL,NULL,'text','Name Suffix',NULL,NULL,0,0,NULL,0,NULL),(27,2,'company',NULL,NULL,'static',NULL,NULL,'text','Company',NULL,NULL,0,0,NULL,0,NULL),(28,2,'street',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\DefaultBackend','static',NULL,NULL,'multiline','Street Address',NULL,NULL,1,0,NULL,0,NULL),(29,2,'city',NULL,NULL,'static',NULL,NULL,'text','City',NULL,NULL,1,0,NULL,0,NULL),(30,2,'country_id',NULL,NULL,'static',NULL,NULL,'select','Country',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Source\\Country',1,0,NULL,0,NULL),(31,2,'region',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Backend\\Region','static',NULL,NULL,'text','State/Province',NULL,NULL,0,0,NULL,0,NULL),(32,2,'region_id',NULL,NULL,'static',NULL,NULL,'hidden','State/Province',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Source\\Region',0,0,NULL,0,NULL),(33,2,'postcode',NULL,NULL,'static',NULL,NULL,'text','Zip/Postal Code',NULL,NULL,0,0,NULL,0,NULL),(34,2,'telephone',NULL,NULL,'static',NULL,NULL,'text','Phone Number',NULL,NULL,1,0,NULL,0,NULL),(35,2,'fax',NULL,NULL,'static',NULL,NULL,'text','Fax',NULL,NULL,0,0,NULL,0,NULL),(36,2,'vat_id','Magento\\Customer\\Model\\Attribute',NULL,'static',NULL,NULL,'text','VAT Number',NULL,NULL,0,0,NULL,0,NULL),(37,2,'vat_is_valid',NULL,NULL,'static',NULL,NULL,'text','VAT number validity',NULL,NULL,0,0,NULL,0,NULL),(38,2,'vat_request_id',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request ID',NULL,NULL,0,0,NULL,0,NULL),(39,2,'vat_request_date',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request date',NULL,NULL,0,0,NULL,0,NULL),(40,2,'vat_request_success',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request success',NULL,NULL,0,0,NULL,0,NULL),(41,1,'updated_at',NULL,NULL,'static',NULL,NULL,'date','Updated At',NULL,NULL,0,0,NULL,0,NULL),(42,1,'failures_num',NULL,NULL,'static',NULL,NULL,'hidden','Failures Number',NULL,NULL,0,0,NULL,0,NULL),(43,1,'first_failure',NULL,NULL,'static',NULL,NULL,'date','First Failure Date',NULL,NULL,0,0,NULL,0,NULL),(44,1,'lock_expires',NULL,NULL,'static',NULL,NULL,'date','Failures Number',NULL,NULL,0,0,NULL,0,NULL),(45,3,'name',NULL,NULL,'varchar',NULL,NULL,'text','Name',NULL,NULL,1,0,NULL,0,NULL),(46,3,'is_active',NULL,NULL,'int',NULL,NULL,'select','Is Active',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',1,0,NULL,0,NULL),(47,3,'description',NULL,NULL,'text',NULL,NULL,'textarea','Description',NULL,NULL,0,0,NULL,0,NULL),(48,3,'image',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Image',NULL,NULL,0,0,NULL,0,NULL),(49,3,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Page Title',NULL,NULL,0,0,NULL,0,NULL),(50,3,'meta_keywords',NULL,NULL,'text',NULL,NULL,'textarea','Meta Keywords',NULL,NULL,0,0,NULL,0,NULL),(51,3,'meta_description',NULL,NULL,'text',NULL,NULL,'textarea','Meta Description',NULL,NULL,0,0,NULL,0,NULL),(52,3,'display_mode',NULL,NULL,'varchar',NULL,NULL,'select','Display Mode',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Mode',0,0,NULL,0,NULL),(53,3,'landing_page',NULL,NULL,'int',NULL,NULL,'select','CMS Block',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Page',0,0,NULL,0,NULL),(54,3,'is_anchor',NULL,NULL,'int',NULL,NULL,'select','Is Anchor',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'1',0,NULL),(55,3,'path',NULL,NULL,'static',NULL,NULL,'text','Path',NULL,NULL,0,0,NULL,0,NULL),(56,3,'position',NULL,NULL,'static',NULL,NULL,'text','Position',NULL,NULL,0,0,NULL,0,NULL),(57,3,'all_children',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(58,3,'path_in_store',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(59,3,'children',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(60,3,'custom_design',NULL,NULL,'varchar',NULL,NULL,'select','Custom Design',NULL,'Magento\\Theme\\Model\\Theme\\Source\\Theme',0,0,NULL,0,NULL),(61,3,'custom_design_from','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Frontend\\Datetime','date','Active From',NULL,NULL,0,0,NULL,0,NULL),(62,3,'custom_design_to',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Active To',NULL,NULL,0,0,NULL,0,NULL),(63,3,'page_layout',NULL,NULL,'varchar',NULL,NULL,'select','Page Layout',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(64,3,'custom_layout_update',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Customlayoutupdate','text',NULL,NULL,'textarea','Custom Layout Update',NULL,NULL,0,0,NULL,0,NULL),(65,3,'level',NULL,NULL,'static',NULL,NULL,'text','Level',NULL,NULL,0,0,NULL,0,NULL),(66,3,'children_count',NULL,NULL,'static',NULL,NULL,'text','Children Count',NULL,NULL,0,0,NULL,0,NULL),(67,3,'available_sort_by',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Sortby','text',NULL,NULL,'multiselect','Available Product Listing Sort By',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Sortby',1,0,NULL,0,NULL),(68,3,'default_sort_by',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Sortby','varchar',NULL,NULL,'select','Default Product Listing Sort By',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Sortby',1,0,NULL,0,NULL),(69,3,'include_in_menu',NULL,NULL,'int',NULL,NULL,'select','Include in Navigation Menu',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',1,0,'1',0,NULL),(70,3,'custom_use_parent_settings',NULL,NULL,'int',NULL,NULL,'select','Use Parent Category Settings',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(71,3,'custom_apply_to_products',NULL,NULL,'int',NULL,NULL,'select','Apply To Products',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(72,3,'filter_price_range',NULL,NULL,'decimal',NULL,NULL,'text','Layered Navigation Price Step',NULL,NULL,0,0,NULL,0,NULL),(73,4,'name','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute',NULL,'varchar',NULL,NULL,'text','Product Name','validate-length maximum-length-255',NULL,1,0,NULL,0,NULL),(74,4,'sku','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Sku','static',NULL,NULL,'text','SKU','validate-length maximum-length-64',NULL,1,0,NULL,1,NULL),(75,4,'description',NULL,NULL,'text',NULL,NULL,'textarea','Description',NULL,NULL,0,0,NULL,0,NULL),(76,4,'short_description',NULL,NULL,'text',NULL,NULL,'textarea','Short Description',NULL,NULL,0,0,NULL,0,NULL),(77,4,'price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Price',NULL,NULL,1,0,NULL,0,NULL),(78,4,'special_price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Special Price',NULL,NULL,0,0,NULL,0,NULL),(79,4,'special_from_date',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Special Price From Date',NULL,NULL,0,0,NULL,0,NULL),(80,4,'special_to_date',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Special Price To Date',NULL,NULL,0,0,NULL,0,NULL),(81,4,'cost',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Cost',NULL,NULL,0,1,NULL,0,NULL),(82,4,'weight',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Weight','decimal',NULL,NULL,'weight','Weight',NULL,NULL,0,0,NULL,0,NULL),(83,4,'manufacturer',NULL,NULL,'int',NULL,NULL,'select','Manufacturer',NULL,NULL,0,1,NULL,0,NULL),(84,4,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Meta Title',NULL,NULL,0,0,NULL,0,NULL),(85,4,'meta_keyword',NULL,NULL,'text',NULL,NULL,'textarea','Meta Keywords',NULL,NULL,0,0,NULL,0,NULL),(86,4,'meta_description',NULL,NULL,'varchar',NULL,NULL,'textarea','Meta Description',NULL,NULL,0,0,NULL,0,'Maximum 255 chars. Meta Description should optimally be between 150-160 characters'),(87,4,'image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Base',NULL,NULL,0,0,NULL,0,NULL),(88,4,'small_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Small',NULL,NULL,0,0,NULL,0,NULL),(89,4,'thumbnail',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Thumbnail',NULL,NULL,0,0,NULL,0,NULL),(90,4,'media_gallery',NULL,NULL,'static',NULL,NULL,'gallery','Media Gallery',NULL,NULL,0,0,NULL,0,NULL),(91,4,'old_id',NULL,NULL,'int',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(92,4,'tier_price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Tierprice','decimal',NULL,NULL,'text','Tier Price',NULL,NULL,0,0,NULL,0,NULL),(93,4,'color',NULL,NULL,'int',NULL,NULL,'select','Color',NULL,NULL,0,1,NULL,0,NULL),(94,4,'news_from_date',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Set Product as New from Date',NULL,NULL,0,0,NULL,0,NULL),(95,4,'news_to_date',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Set Product as New to Date',NULL,NULL,0,0,NULL,0,NULL),(96,4,'gallery',NULL,NULL,'varchar',NULL,NULL,'gallery','Image Gallery',NULL,NULL,0,0,NULL,0,NULL),(97,4,'status',NULL,NULL,'int',NULL,NULL,'select','Enable Product',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Status',0,0,'1',0,NULL),(98,4,'minimal_price',NULL,NULL,'decimal',NULL,NULL,'price','Minimal Price',NULL,NULL,0,0,NULL,0,NULL),(99,4,'visibility',NULL,NULL,'int',NULL,NULL,'select','Visibility',NULL,'Magento\\Catalog\\Model\\Product\\Visibility',0,0,'4',0,NULL),(100,4,'custom_design',NULL,NULL,'varchar',NULL,NULL,'select','New Theme',NULL,'Magento\\Theme\\Model\\Theme\\Source\\Theme',0,0,NULL,0,NULL),(101,4,'custom_design_from',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Active From',NULL,NULL,0,0,NULL,0,NULL),(102,4,'custom_design_to',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Active To',NULL,NULL,0,0,NULL,0,NULL),(103,4,'custom_layout_update',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Customlayoutupdate','text',NULL,NULL,'textarea','Layout Update XML',NULL,NULL,0,0,NULL,0,NULL),(104,4,'page_layout',NULL,NULL,'varchar',NULL,NULL,'select','Layout',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(105,4,'category_ids',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Category','static',NULL,NULL,'text','Categories',NULL,NULL,0,0,NULL,0,NULL),(106,4,'options_container',NULL,NULL,'varchar',NULL,NULL,'select','Display Product Options In',NULL,'Magento\\Catalog\\Model\\Entity\\Product\\Attribute\\Design\\Options\\Container',0,0,'container2',0,NULL),(107,4,'required_options',NULL,NULL,'static',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(108,4,'has_options',NULL,NULL,'static',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(109,4,'image_label',NULL,NULL,'varchar',NULL,NULL,'text','Image Label',NULL,NULL,0,0,NULL,0,NULL),(110,4,'small_image_label',NULL,NULL,'varchar',NULL,NULL,'text','Small Image Label',NULL,NULL,0,0,NULL,0,NULL),(111,4,'thumbnail_label',NULL,NULL,'varchar',NULL,NULL,'text','Thumbnail Label',NULL,NULL,0,0,NULL,0,NULL),(112,4,'created_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,1,0,NULL,0,NULL),(113,4,'updated_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,1,0,NULL,0,NULL),(114,4,'country_of_manufacture',NULL,NULL,'varchar',NULL,NULL,'select','Country of Manufacture',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Countryofmanufacture',0,0,NULL,0,NULL),(115,4,'quantity_and_stock_status',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Stock','int',NULL,NULL,'select','Quantity',NULL,'Magento\\CatalogInventory\\Model\\Source\\Stock',0,0,'1',0,NULL),(116,4,'custom_layout',NULL,NULL,'varchar',NULL,NULL,'select','New Layout',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(117,4,'custom_layout_update_file',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\LayoutUpdate','varchar',NULL,NULL,'select','Custom Layout Update',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\LayoutUpdate',0,0,NULL,0,NULL),(118,3,'custom_layout_update_file',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\LayoutUpdate','varchar',NULL,NULL,'select','Custom Layout Update',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\LayoutUpdate',0,0,NULL,0,NULL),(119,4,'msrp',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Minimum Advertised Price',NULL,NULL,0,0,NULL,0,NULL),(120,4,'msrp_display_actual_price_type',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Boolean','varchar',NULL,NULL,'select','Display Actual Price',NULL,'Magento\\Msrp\\Model\\Product\\Attribute\\Source\\Type\\Price',0,0,'0',0,NULL),(121,3,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(122,3,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(123,4,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(124,4,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(125,4,'links_purchased_separately',NULL,NULL,'int',NULL,NULL,NULL,'Links can be purchased separately',NULL,NULL,1,0,NULL,0,NULL),(126,4,'samples_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Samples title',NULL,NULL,1,0,NULL,0,NULL),(127,4,'links_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Links title',NULL,NULL,1,0,NULL,0,NULL),(128,4,'links_exist',NULL,NULL,'int',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,NULL),(129,4,'gift_message_available',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Boolean','varchar',NULL,NULL,'select','Allow Gift Message',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(130,4,'price_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Price',NULL,NULL,1,0,'0',0,NULL),(131,4,'sku_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic SKU',NULL,NULL,1,0,'0',0,NULL),(132,4,'weight_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Weight',NULL,NULL,1,0,'0',0,NULL),(133,4,'price_view',NULL,NULL,'int',NULL,NULL,'select','Price View',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Price\\View',1,0,NULL,0,NULL),(134,4,'shipment_type',NULL,NULL,'int',NULL,NULL,'select','Ship Bundle Items',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Shipment\\Type',1,0,'0',0,NULL),(135,4,'swatch_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Swatch',NULL,NULL,0,0,NULL,0,NULL),(136,4,'tax_class_id',NULL,NULL,'int',NULL,NULL,'select','Tax Class',NULL,'Magento\\Tax\\Model\\TaxClass\\Source\\Product',0,0,'2',0,NULL),(137,3,'mp_ln_hide_attribute_ids',NULL,'Mageplaza\\LayeredNavigation\\Model\\Category\\Attribute\\Backend\\Attributes','text',NULL,NULL,'multiselect','Hide Filter Attributes on Layered Navigation',NULL,'Mageplaza\\LayeredNavigation\\Model\\Category\\Attribute\\Source\\Attributes',0,0,NULL,0,NULL),(138,4,'sw_featured',NULL,NULL,'int',NULL,NULL,'boolean','Is Featured',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,1,NULL,0,NULL),(139,3,'sw_menu_hide_item',NULL,NULL,'int',NULL,NULL,'select','Hide This Menu Item',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(140,3,'sw_menu_type',NULL,NULL,'varchar',NULL,NULL,'select','Menu Type',NULL,'Smartwave\\Megamenu\\Model\\Attribute\\Menutype',0,0,NULL,0,NULL),(141,3,'sw_menu_static_width',NULL,NULL,'varchar',NULL,NULL,'text','Static Width',NULL,NULL,0,0,NULL,0,NULL),(142,3,'sw_menu_cat_columns',NULL,NULL,'varchar',NULL,NULL,'select','Sub Category Columns',NULL,'Smartwave\\Megamenu\\Model\\Attribute\\Subcatcolumns',0,0,NULL,0,NULL),(143,3,'sw_menu_float_type',NULL,NULL,'varchar',NULL,NULL,'select','Float',NULL,'Smartwave\\Megamenu\\Model\\Attribute\\Floattype',0,0,NULL,0,NULL),(144,3,'sw_menu_cat_label',NULL,NULL,'varchar',NULL,NULL,'select','Category Label',NULL,'Smartwave\\Megamenu\\Model\\Attribute\\Categorylabel',0,0,NULL,0,NULL),(145,3,'sw_menu_icon_img',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Icon Image',NULL,NULL,0,0,NULL,0,NULL),(146,3,'sw_menu_font_icon',NULL,NULL,'varchar',NULL,NULL,'text','Font Icon Class',NULL,NULL,0,0,NULL,0,NULL),(147,3,'sw_menu_block_top_content',NULL,NULL,'text',NULL,NULL,'textarea','Top Block',NULL,NULL,0,0,NULL,0,NULL),(148,3,'sw_menu_block_left_width',NULL,NULL,'varchar',NULL,NULL,'select','Left Block Width',NULL,'Smartwave\\Megamenu\\Model\\Attribute\\Width',0,0,NULL,0,NULL),(149,3,'sw_menu_block_left_content',NULL,NULL,'text',NULL,NULL,'textarea','Left Block',NULL,NULL,0,0,NULL,0,NULL),(150,3,'sw_menu_block_right_width',NULL,NULL,'varchar',NULL,NULL,'select','Right Block Width',NULL,'Smartwave\\Megamenu\\Model\\Attribute\\Width',0,0,NULL,0,NULL),(151,3,'sw_menu_block_right_content',NULL,NULL,'text',NULL,NULL,'textarea','Right Block',NULL,NULL,0,0,NULL,0,NULL),(152,3,'sw_menu_block_bottom_content',NULL,NULL,'text',NULL,NULL,'textarea','Bottom Block',NULL,NULL,0,0,NULL,0,NULL),(153,3,'sw_ocat_hide_this_item',NULL,NULL,'int',NULL,NULL,'select','Hide This Category',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(154,3,'sw_ocat_category_icon_image',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Icon Image',NULL,NULL,0,0,NULL,0,NULL),(155,3,'sw_ocat_category_font_icon',NULL,NULL,'varchar',NULL,NULL,'text','Font Icon Class',NULL,NULL,0,0,NULL,0,'If this category has no \"Icon Image\", font icon will be shown. example to input: icon-dollar'),(156,3,'sw_ocat_category_hoverbgcolor',NULL,NULL,'varchar',NULL,NULL,'text','Category Hover Background Color',NULL,NULL,0,0,NULL,0,'eg: #00d59d'),(157,3,'sw_ocat_additional_content',NULL,NULL,'text',NULL,NULL,'textarea','Additional Content',NULL,NULL,0,0,NULL,0,NULL),(158,4,'product_page_type',NULL,NULL,'varchar',NULL,NULL,'select','Product Page Type',NULL,'Smartwave\\Porto\\Model\\Attribute\\Productpagetype',0,1,NULL,0,NULL),(159,4,'product_image_size',NULL,NULL,'varchar',NULL,NULL,'select','Product Image Size',NULL,'Smartwave\\Porto\\Model\\Attribute\\Productimagesize',0,1,NULL,0,NULL),(160,4,'custom_block',NULL,NULL,'text',NULL,NULL,'textarea','Custom Block',NULL,NULL,0,1,NULL,0,NULL),(161,4,'custom_block_2',NULL,NULL,'text',NULL,NULL,'textarea','Custom Block 2',NULL,NULL,0,1,NULL,0,NULL);

--
-- Table structure for table `eav_attribute_group`
--

CREATE TABLE `eav_attribute_group` (
  `attribute_group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Group ID',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `attribute_group_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Group Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `default_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Default ID',
  `attribute_group_code` varchar(255) NOT NULL COMMENT 'Attribute Group Code',
  `tab_group_code` varchar(255) DEFAULT NULL COMMENT 'Tab Group Code',
  PRIMARY KEY (`attribute_group_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE` (`attribute_set_id`,`attribute_group_code`),
  UNIQUE KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME` (`attribute_set_id`,`attribute_group_name`),
  KEY `EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Group';

--
-- Dumping data for table `eav_attribute_group`
--

INSERT INTO `eav_attribute_group` VALUES (1,1,'General',1,1,'general',NULL),(2,2,'General',1,1,'general',NULL),(3,3,'General',10,1,'general',NULL),(4,3,'General Information',2,0,'general-information',NULL),(5,3,'Display Settings',20,0,'display-settings',NULL),(6,3,'Custom Design',30,0,'custom-design',NULL),(7,4,'Product Details',10,1,'product-details','basic'),(8,4,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(9,4,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(10,4,'Images',20,0,'image-management','basic'),(11,4,'Design',50,0,'design','advanced'),(12,4,'Autosettings',60,0,'autosettings','advanced'),(13,4,'Content',15,0,'content','basic'),(14,4,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(15,5,'General',1,1,'general',NULL),(16,6,'General',1,1,'general',NULL),(17,7,'General',1,1,'general',NULL),(18,8,'General',1,1,'general',NULL),(19,4,'Gift Options',61,0,'gift-options',NULL),(20,4,'Bundle Items',16,0,'bundle-items',NULL),(21,4,'Subscriptions by Stripe',18,0,'subscriptions-by-stripe',NULL),(22,3,'SW Menu',31,0,'sw-menu',NULL),(23,3,'Onepage Category',32,0,'onepage-category',NULL);

--
-- Table structure for table `eav_attribute_label`
--

CREATE TABLE `eav_attribute_label` (
  `attribute_label_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Label ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`attribute_label_id`),
  KEY `EAV_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
  KEY `EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID` (`attribute_id`,`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Label';

--
-- Dumping data for table `eav_attribute_label`
--


--
-- Table structure for table `eav_attribute_option`
--

CREATE TABLE `eav_attribute_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option';

--
-- Dumping data for table `eav_attribute_option`
--

INSERT INTO `eav_attribute_option` VALUES (1,20,0),(2,20,1),(3,20,3);

--
-- Table structure for table `eav_attribute_option_swatch`
--

CREATE TABLE `eav_attribute_option_swatch` (
  `swatch_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Swatch ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `type` smallint(5) unsigned NOT NULL COMMENT 'Swatch type: 0 - text, 1 - visual color, 2 - visual image',
  `value` varchar(255) DEFAULT NULL COMMENT 'Swatch Value',
  PRIMARY KEY (`swatch_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_OPTION_ID` (`store_id`,`option_id`),
  KEY `EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` (`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_SWATCH_SWATCH_ID` (`swatch_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magento Swatches table';

--
-- Dumping data for table `eav_attribute_option_swatch`
--


--
-- Table structure for table `eav_attribute_option_value`
--

CREATE TABLE `eav_attribute_option_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  KEY `EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID` (`option_id`),
  KEY `EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option Value';

--
-- Dumping data for table `eav_attribute_option_value`
--

INSERT INTO `eav_attribute_option_value` VALUES (1,1,0,'Male'),(2,2,0,'Female'),(3,3,0,'Not Specified');

--
-- Table structure for table `eav_attribute_set`
--

CREATE TABLE `eav_attribute_set` (
  `attribute_set_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Set ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_set_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Set Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`attribute_set_id`),
  UNIQUE KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME` (`entity_type_id`,`attribute_set_name`),
  KEY `EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_SORT_ORDER` (`entity_type_id`,`sort_order`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Set';

--
-- Dumping data for table `eav_attribute_set`
--

INSERT INTO `eav_attribute_set` VALUES (1,1,'Default',2),(2,2,'Default',2),(3,3,'Default',1),(4,4,'Default',1),(5,5,'Default',1),(6,6,'Default',1),(7,7,'Default',1),(8,8,'Default',1);

--
-- Table structure for table `eav_entity`
--

CREATE TABLE `eav_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `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',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Defines Is Entity Active',
  PRIMARY KEY (`entity_id`),
  KEY `EAV_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `EAV_ENTITY_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity';

--
-- Dumping data for table `eav_entity`
--


--
-- Table structure for table `eav_entity_attribute`
--

CREATE TABLE `eav_entity_attribute` (
  `entity_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Attribute ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set ID',
  `attribute_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Group ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`entity_attribute_id`),
  UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID` (`attribute_set_id`,`attribute_id`),
  UNIQUE KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID` (`attribute_group_id`,`attribute_id`),
  KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
  KEY `EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Attributes';

--
-- Dumping data for table `eav_entity_attribute`
--

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

--
-- Table structure for table `eav_entity_datetime`
--

CREATE TABLE `eav_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` datetime DEFAULT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_DATETIME_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_DATETIME_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_DATETIME_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `eav_entity_datetime`
--


--
-- Table structure for table `eav_entity_decimal`
--

CREATE TABLE `eav_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_DECIMAL_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `eav_entity_decimal`
--


--
-- Table structure for table `eav_entity_int`
--

CREATE TABLE `eav_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_INT_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_INT_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_INT_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `eav_entity_int`
--


--
-- Table structure for table `eav_entity_store`
--

CREATE TABLE `eav_entity_store` (
  `entity_store_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Store ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `increment_prefix` varchar(20) DEFAULT NULL COMMENT 'Increment Prefix',
  `increment_last_id` varchar(50) DEFAULT NULL COMMENT 'Last Incremented ID',
  PRIMARY KEY (`entity_store_id`),
  KEY `EAV_ENTITY_STORE_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `EAV_ENTITY_STORE_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Store';

--
-- Dumping data for table `eav_entity_store`
--


--
-- Table structure for table `eav_entity_text`
--

CREATE TABLE `eav_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` text NOT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_TEXT_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `EAV_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `EAV_ENTITY_TEXT_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `eav_entity_text`
--


--
-- Table structure for table `eav_entity_type`
--

CREATE TABLE `eav_entity_type` (
  `entity_type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Type ID',
  `entity_type_code` varchar(50) NOT NULL COMMENT 'Entity Type Code',
  `entity_model` varchar(255) NOT NULL COMMENT 'Entity Model',
  `attribute_model` varchar(255) DEFAULT NULL COMMENT 'Attribute Model',
  `entity_table` varchar(255) DEFAULT NULL COMMENT 'Entity Table',
  `value_table_prefix` varchar(255) DEFAULT NULL COMMENT 'Value Table Prefix',
  `entity_id_field` varchar(255) DEFAULT NULL COMMENT 'Entity ID Field',
  `is_data_sharing` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Defines Is Data Sharing',
  `data_sharing_key` varchar(100) DEFAULT 'default' COMMENT 'Data Sharing Key',
  `default_attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Default Attribute Set ID',
  `increment_model` varchar(255) DEFAULT NULL COMMENT 'Increment Model',
  `increment_per_store` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Increment Per Store',
  `increment_pad_length` smallint(5) unsigned NOT NULL DEFAULT '8' COMMENT 'Increment Pad Length',
  `increment_pad_char` varchar(1) NOT NULL DEFAULT '0' COMMENT 'Increment Pad Char',
  `additional_attribute_table` varchar(255) DEFAULT NULL COMMENT 'Additional Attribute Table',
  `entity_attribute_collection` varchar(255) DEFAULT NULL COMMENT 'Entity Attribute Collection',
  PRIMARY KEY (`entity_type_id`),
  KEY `EAV_ENTITY_TYPE_ENTITY_TYPE_CODE` (`entity_type_code`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Type';

--
-- Dumping data for table `eav_entity_type`
--

INSERT INTO `eav_entity_type` VALUES (1,'customer','Magento\\Customer\\Model\\ResourceModel\\Customer','Magento\\Customer\\Model\\Attribute','customer_entity',NULL,NULL,1,'default',1,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',0,8,'0','customer_eav_attribute','Magento\\Customer\\Model\\ResourceModel\\Attribute\\Collection'),(2,'customer_address','Magento\\Customer\\Model\\ResourceModel\\Address','Magento\\Customer\\Model\\Attribute','customer_address_entity',NULL,NULL,1,'default',2,NULL,0,8,'0','customer_eav_attribute','Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Collection'),(3,'catalog_category','Magento\\Catalog\\Model\\ResourceModel\\Category','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','catalog_category_entity',NULL,NULL,1,'default',3,NULL,0,8,'0','catalog_eav_attribute','Magento\\Catalog\\Model\\ResourceModel\\Category\\Attribute\\Collection'),(4,'catalog_product','Magento\\Catalog\\Model\\ResourceModel\\Product','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','catalog_product_entity',NULL,NULL,1,'default',4,NULL,0,8,'0','catalog_eav_attribute','Magento\\Catalog\\Model\\ResourceModel\\Product\\Attribute\\Collection'),(5,'order','Magento\\Sales\\Model\\ResourceModel\\Order',NULL,'sales_order',NULL,NULL,1,'default',5,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL),(6,'invoice','Magento\\Sales\\Model\\ResourceModel\\Order\\Invoice',NULL,'sales_invoice',NULL,NULL,1,'default',6,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL),(7,'creditmemo','Magento\\Sales\\Model\\ResourceModel\\Order\\Creditmemo',NULL,'sales_creditmemo',NULL,NULL,1,'default',7,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL),(8,'shipment','Magento\\Sales\\Model\\ResourceModel\\Order\\Shipment',NULL,'sales_shipment',NULL,NULL,1,'default',8,'Magento\\Eav\\Model\\Entity\\Increment\\NumericValue',1,8,'0',NULL,NULL);

--
-- Table structure for table `eav_entity_varchar`
--

CREATE TABLE `eav_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type ID',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `EAV_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `EAV_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  KEY `EAV_ENTITY_VARCHAR_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `eav_entity_varchar`
--


--
-- Table structure for table `eav_form_element`
--

CREATE TABLE `eav_form_element` (
  `element_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Element ID',
  `type_id` smallint(5) unsigned NOT NULL COMMENT 'Type ID',
  `fieldset_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Fieldset ID',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute ID',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`element_id`),
  UNIQUE KEY `EAV_FORM_ELEMENT_TYPE_ID_ATTRIBUTE_ID` (`type_id`,`attribute_id`),
  KEY `EAV_FORM_ELEMENT_FIELDSET_ID` (`fieldset_id`),
  KEY `EAV_FORM_ELEMENT_ATTRIBUTE_ID` (`attribute_id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COMMENT='Eav Form Element';

--
-- Dumping data for table `eav_form_element`
--

INSERT INTO `eav_form_element` VALUES (1,1,NULL,23,0),(2,1,NULL,25,1),(3,1,NULL,27,2),(4,1,NULL,9,3),(5,1,NULL,28,4),(6,1,NULL,29,5),(7,1,NULL,31,6),(8,1,NULL,33,7),(9,1,NULL,30,8),(10,1,NULL,34,9),(11,1,NULL,35,10),(12,2,NULL,23,0),(13,2,NULL,25,1),(14,2,NULL,27,2),(15,2,NULL,9,3),(16,2,NULL,28,4),(17,2,NULL,29,5),(18,2,NULL,31,6),(19,2,NULL,33,7),(20,2,NULL,30,8),(21,2,NULL,34,9),(22,2,NULL,35,10),(23,3,NULL,23,0),(24,3,NULL,25,1),(25,3,NULL,27,2),(26,3,NULL,28,3),(27,3,NULL,29,4),(28,3,NULL,31,5),(29,3,NULL,33,6),(30,3,NULL,30,7),(31,3,NULL,34,8),(32,3,NULL,35,9),(33,4,NULL,23,0),(34,4,NULL,25,1),(35,4,NULL,27,2),(36,4,NULL,28,3),(37,4,NULL,29,4),(38,4,NULL,31,5),(39,4,NULL,33,6),(40,4,NULL,30,7),(41,4,NULL,34,8),(42,4,NULL,35,9);

--
-- Table structure for table `eav_form_fieldset`
--

CREATE TABLE `eav_form_fieldset` (
  `fieldset_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Fieldset ID',
  `type_id` smallint(5) unsigned NOT NULL COMMENT 'Type ID',
  `code` varchar(64) NOT NULL COMMENT 'Code',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`fieldset_id`),
  UNIQUE KEY `EAV_FORM_FIELDSET_TYPE_ID_CODE` (`type_id`,`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset';

--
-- Dumping data for table `eav_form_fieldset`
--


--
-- Table structure for table `eav_form_fieldset_label`
--

CREATE TABLE `eav_form_fieldset_label` (
  `fieldset_id` smallint(5) unsigned NOT NULL COMMENT 'Fieldset ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `label` varchar(255) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`fieldset_id`,`store_id`),
  KEY `EAV_FORM_FIELDSET_LABEL_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset Label';

--
-- Dumping data for table `eav_form_fieldset_label`
--


--
-- Table structure for table `eav_form_type`
--

CREATE TABLE `eav_form_type` (
  `type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Type ID',
  `code` varchar(64) NOT NULL COMMENT 'Code',
  `label` varchar(255) NOT NULL COMMENT 'Label',
  `is_system` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is System',
  `theme` varchar(64) DEFAULT NULL COMMENT 'Theme',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`type_id`),
  UNIQUE KEY `EAV_FORM_TYPE_CODE_THEME_STORE_ID` (`code`,`theme`,`store_id`),
  KEY `EAV_FORM_TYPE_STORE_ID` (`store_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Eav Form Type';

--
-- Dumping data for table `eav_form_type`
--

INSERT INTO `eav_form_type` VALUES (1,'checkout_onepage_register','checkout_onepage_register',1,'',0),(2,'checkout_onepage_register_guest','checkout_onepage_register_guest',1,'',0),(3,'checkout_onepage_billing_address','checkout_onepage_billing_address',1,'',0),(4,'checkout_onepage_shipping_address','checkout_onepage_shipping_address',1,'',0);

--
-- Table structure for table `eav_form_type_entity`
--

CREATE TABLE `eav_form_type_entity` (
  `type_id` smallint(5) unsigned NOT NULL COMMENT 'Type ID',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type ID',
  PRIMARY KEY (`type_id`,`entity_type_id`),
  KEY `EAV_FORM_TYPE_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Type Entity';

--
-- Dumping data for table `eav_form_type_entity`
--

INSERT INTO `eav_form_type_entity` VALUES (1,1),(2,1),(1,2),(2,2),(3,2),(4,2);

--
-- Table structure for table `email_abandoned_cart`
--

CREATE TABLE `email_abandoned_cart` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `quote_id` int(10) unsigned DEFAULT NULL COMMENT 'Quote Id',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Email',
  `status` varchar(255) NOT NULL DEFAULT '' COMMENT 'Contact Status',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Quote Active',
  `quote_updated_at` timestamp NULL DEFAULT NULL COMMENT 'Quote updated at',
  `abandoned_cart_number` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Abandoned Cart number',
  `items_count` smallint(5) unsigned DEFAULT '0' COMMENT 'Quote items count',
  `items_ids` varchar(255) DEFAULT NULL COMMENT 'Quote item ids',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated at',
  PRIMARY KEY (`id`),
  KEY `EMAIL_ABANDONED_CART_QUOTE_ID` (`quote_id`),
  KEY `EMAIL_ABANDONED_CART_STORE_ID` (`store_id`),
  KEY `EMAIL_ABANDONED_CART_CUSTOMER_ID` (`customer_id`),
  KEY `EMAIL_ABANDONED_CART_EMAIL` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Abandoned Carts Table';

--
-- Dumping data for table `email_abandoned_cart`
--


--
-- Table structure for table `email_automation`
--

CREATE TABLE `email_automation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `automation_type` varchar(255) DEFAULT NULL COMMENT 'Automation Type',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Automation Type',
  `enrolment_status` varchar(255) NOT NULL COMMENT 'Enrolment Status',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `type_id` varchar(255) DEFAULT NULL COMMENT 'Type ID',
  `program_id` varchar(255) DEFAULT NULL COMMENT 'Program ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `message` varchar(255) NOT NULL COMMENT 'Message',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `EMAIL_AUTOMATION_AUTOMATION_TYPE` (`automation_type`),
  KEY `EMAIL_AUTOMATION_ENROLMENT_STATUS` (`enrolment_status`),
  KEY `EMAIL_AUTOMATION_TYPE_ID` (`type_id`),
  KEY `EMAIL_AUTOMATION_EMAIL` (`email`),
  KEY `EMAIL_AUTOMATION_PROGRAM_ID` (`program_id`),
  KEY `EMAIL_AUTOMATION_CREATED_AT` (`created_at`),
  KEY `EMAIL_AUTOMATION_UPDATED_AT` (`updated_at`),
  KEY `EMAIL_AUTOMATION_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Automation Status';

--
-- Dumping data for table `email_automation`
--


--
-- Table structure for table `email_campaign`
--

CREATE TABLE `email_campaign` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `campaign_id` int(10) unsigned NOT NULL COMMENT 'Campaign ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Contact Email',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `sent_at` timestamp NULL DEFAULT NULL COMMENT 'Send Date',
  `order_increment_id` varchar(50) NOT NULL COMMENT 'Order Increment ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Sales Quote ID',
  `message` varchar(255) NOT NULL DEFAULT '' COMMENT 'Error Message',
  `checkout_method` varchar(255) NOT NULL DEFAULT '' COMMENT 'Checkout Method Used',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `event_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Event Name',
  `send_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Send Id',
  `send_status` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Campaign send status',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `EMAIL_CAMPAIGN_STORE_ID` (`store_id`),
  KEY `EMAIL_CAMPAIGN_CAMPAIGN_ID` (`campaign_id`),
  KEY `EMAIL_CAMPAIGN_EMAIL` (`email`),
  KEY `EMAIL_CAMPAIGN_SEND_ID` (`send_id`),
  KEY `EMAIL_CAMPAIGN_SEND_STATUS` (`send_status`),
  KEY `EMAIL_CAMPAIGN_CREATED_AT` (`created_at`),
  KEY `EMAIL_CAMPAIGN_UPDATED_AT` (`updated_at`),
  KEY `EMAIL_CAMPAIGN_SENT_AT` (`sent_at`),
  KEY `EMAIL_CAMPAIGN_EVENT_NAME` (`event_name`),
  KEY `EMAIL_CAMPAIGN_MESSAGE` (`message`),
  KEY `EMAIL_CAMPAIGN_QUOTE_ID` (`quote_id`),
  KEY `EMAIL_CAMPAIGN_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Campaigns';

--
-- Dumping data for table `email_campaign`
--


--
-- Table structure for table `email_catalog`
--

CREATE TABLE `email_catalog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `imported` smallint(5) unsigned DEFAULT NULL COMMENT 'Product imported [deprecated]',
  `modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Product modified [deprecated]',
  `processed` smallint(5) unsigned NOT NULL COMMENT 'Product processed',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  `last_imported_at` timestamp NULL DEFAULT NULL COMMENT 'Last imported date',
  PRIMARY KEY (`id`),
  KEY `EMAIL_CATALOG_PRODUCT_ID` (`product_id`),
  KEY `EMAIL_CATALOG_PROCESSED` (`processed`),
  KEY `EMAIL_CATALOG_CREATED_AT` (`created_at`),
  KEY `EMAIL_CATALOG_UPDATED_AT` (`updated_at`),
  KEY `EMAIL_CATALOG_LAST_IMPORTED_AT` (`last_imported_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Connector Catalog';

--
-- Dumping data for table `email_catalog`
--

INSERT INTO `email_catalog` VALUES (1,1,NULL,NULL,0,'2024-02-02 23:21:22','2024-02-02 23:21:22',NULL);

--
-- Table structure for table `email_contact`
--

CREATE TABLE `email_contact` (
  `email_contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `is_guest` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Guest',
  `contact_id` varchar(15) DEFAULT NULL COMMENT 'Connector Contact ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Customer Email',
  `is_subscriber` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Subscriber',
  `subscriber_status` smallint(5) unsigned DEFAULT NULL COMMENT 'Subscriber status',
  `email_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Imported',
  `subscriber_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Subscriber Imported',
  `suppressed` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Suppressed',
  `last_subscribed_at` timestamp NULL DEFAULT NULL COMMENT 'Last time user subscribed',
  PRIMARY KEY (`email_contact_id`),
  KEY `EMAIL_CONTACT_EMAIL_CONTACT_ID` (`email_contact_id`),
  KEY `EMAIL_CONTACT_IS_GUEST` (`is_guest`),
  KEY `EMAIL_CONTACT_CUSTOMER_ID` (`customer_id`),
  KEY `EMAIL_CONTACT_WEBSITE_ID` (`website_id`),
  KEY `EMAIL_CONTACT_IS_SUBSCRIBER` (`is_subscriber`),
  KEY `EMAIL_CONTACT_SUBSCRIBER_STATUS` (`subscriber_status`),
  KEY `EMAIL_CONTACT_EMAIL_IMPORTED` (`email_imported`),
  KEY `EMAIL_CONTACT_SUBSCRIBER_IMPORTED` (`subscriber_imported`),
  KEY `EMAIL_CONTACT_SUPPRESSED` (`suppressed`),
  KEY `EMAIL_CONTACT_EMAIL` (`email`),
  KEY `EMAIL_CONTACT_CONTACT_ID` (`contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Contacts';

--
-- Dumping data for table `email_contact`
--


--
-- Table structure for table `email_contact_consent`
--

CREATE TABLE `email_contact_consent` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `email_contact_id` int(10) unsigned DEFAULT NULL COMMENT 'Email Contact Id',
  `consent_url` varchar(255) DEFAULT NULL COMMENT 'Contact consent url',
  `consent_datetime` datetime DEFAULT NULL COMMENT 'Contact consent datetime',
  `consent_ip` varchar(255) DEFAULT NULL COMMENT 'Contact consent ip',
  `consent_user_agent` varchar(255) DEFAULT NULL COMMENT 'Contact consent user agent',
  PRIMARY KEY (`id`),
  KEY `EMAIL_CONTACT_CONSENT_EMAIL_CONTACT_ID` (`email_contact_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email contact consent table.';

--
-- Dumping data for table `email_contact_consent`
--


--
-- Table structure for table `email_coupon_attribute`
--

CREATE TABLE `email_coupon_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `salesrule_coupon_id` int(10) unsigned NOT NULL COMMENT 'Coupon ID',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `expires_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon expiration date',
  PRIMARY KEY (`id`),
  KEY `EMAIL_COUPON_ATTRIBUTE_COUPON_ID` (`salesrule_coupon_id`),
  KEY `EMAIL_COUPON_ATTRIBUTE_EMAIL` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Dotdigital coupon attributes table';

--
-- Dumping data for table `email_coupon_attribute`
--


--
-- Table structure for table `email_failed_auth`
--

CREATE TABLE `email_failed_auth` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `failures_num` int(10) unsigned DEFAULT NULL COMMENT 'Number of fails',
  `first_attempt_date` datetime DEFAULT NULL COMMENT 'First attempt date',
  `last_attempt_date` datetime DEFAULT NULL COMMENT 'Last attempt date',
  `url` varchar(255) DEFAULT NULL COMMENT 'URL',
  `store_id` int(10) unsigned DEFAULT NULL COMMENT 'Store Id',
  PRIMARY KEY (`id`),
  KEY `EMAIL_AUTH_EDC_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Failed Auth Table.';

--
-- Dumping data for table `email_failed_auth`
--


--
-- Table structure for table `email_importer`
--

CREATE TABLE `email_importer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `import_type` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Type',
  `website_id` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `import_status` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Import Status',
  `import_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Id',
  `import_data` mediumblob NOT NULL COMMENT 'Import Data',
  `import_mode` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Mode',
  `import_file` text NOT NULL COMMENT 'Import File',
  `message` varchar(255) NOT NULL DEFAULT '' COMMENT 'Error Message',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  `import_started` timestamp NULL DEFAULT NULL COMMENT 'Import Started',
  `import_finished` timestamp NULL DEFAULT NULL COMMENT 'Import Finished',
  PRIMARY KEY (`id`),
  KEY `EMAIL_IMPORTER_IMPORT_TYPE` (`import_type`),
  KEY `EMAIL_IMPORTER_WEBSITE_ID` (`website_id`),
  KEY `EMAIL_IMPORTER_IMPORT_STATUS` (`import_status`),
  KEY `EMAIL_IMPORTER_IMPORT_MODE` (`import_mode`),
  KEY `EMAIL_IMPORTER_CREATED_AT` (`created_at`),
  KEY `EMAIL_IMPORTER_UPDATED_AT` (`updated_at`),
  KEY `EMAIL_IMPORTER_IMPORT_ID` (`import_id`),
  KEY `EMAIL_IMPORTER_IMPORT_STARTED` (`import_started`),
  KEY `EMAIL_IMPORTER_IMPORT_FINISHED` (`import_finished`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Importer';

--
-- Dumping data for table `email_importer`
--


--
-- Table structure for table `email_order`
--

CREATE TABLE `email_order` (
  `email_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_status` varchar(255) NOT NULL COMMENT 'Order Status',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Sales Quote ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `email_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Order Imported',
  `modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Order Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`email_order_id`),
  KEY `EMAIL_ORDER_STORE_ID` (`store_id`),
  KEY `EMAIL_ORDER_QUOTE_ID` (`quote_id`),
  KEY `EMAIL_ORDER_EMAIL_IMPORTED` (`email_imported`),
  KEY `EMAIL_ORDER_ORDER_STATUS` (`order_status`),
  KEY `EMAIL_ORDER_MODIFIED` (`modified`),
  KEY `EMAIL_ORDER_UPDATED_AT` (`updated_at`),
  KEY `EMAIL_ORDER_CREATED_AT` (`created_at`),
  KEY `EMAIL_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Transactional Order Data';

--
-- Dumping data for table `email_order`
--


--
-- Table structure for table `email_review`
--

CREATE TABLE `email_review` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `review_id` int(10) unsigned NOT NULL COMMENT 'Review Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `review_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Review Imported',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `EMAIL_REVIEW_REVIEW_ID` (`review_id`),
  KEY `EMAIL_REVIEW_CUSTOMER_ID` (`customer_id`),
  KEY `EMAIL_REVIEW_STORE_ID` (`store_id`),
  KEY `EMAIL_REVIEW_REVIEW_IMPORTED` (`review_imported`),
  KEY `EMAIL_REVIEW_CREATED_AT` (`created_at`),
  KEY `EMAIL_REVIEW_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Reviews';

--
-- Dumping data for table `email_review`
--


--
-- Table structure for table `email_rules`
--

CREATE TABLE `email_rules` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Rule Name',
  `website_ids` varchar(255) NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `type` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Rule Type',
  `status` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Status',
  `combination` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Rule Condition',
  `conditions` blob NOT NULL COMMENT 'Rule Conditions',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Rules';

--
-- Dumping data for table `email_rules`
--


--
-- Table structure for table `email_sms_order_queue`
--

CREATE TABLE `email_sms_order_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary key',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Type ID',
  `order_id` smallint(5) unsigned NOT NULL COMMENT 'Order ID',
  `phone_number` varchar(255) DEFAULT NULL COMMENT 'Phone number',
  `email` varchar(255) DEFAULT NULL COMMENT 'Customer email',
  `additional_data` text COMMENT 'Additional data',
  `status` smallint(6) DEFAULT NULL COMMENT 'Status',
  `content` text COMMENT 'Message content',
  `message_id` varchar(255) DEFAULT NULL COMMENT 'Message ID',
  `message` text COMMENT 'Delivery message',
  `sent_at` timestamp NULL DEFAULT NULL COMMENT 'Sent at date',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update time',
  PRIMARY KEY (`id`),
  KEY `EMAIL_SMS_ORDER_QUEUE_WEBSITE_ID` (`website_id`),
  KEY `EMAIL_SMS_ORDER_QUEUE_STORE_ID` (`store_id`),
  CONSTRAINT `EMAIL_SMS_ORDER_QUEUE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `EMAIL_SMS_ORDER_QUEUE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Dotdigital SMS order queue table';

--
-- Dumping data for table `email_sms_order_queue`
--


--
-- Table structure for table `email_template`
--

CREATE TABLE `email_template` (
  `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `template_code` varchar(150) NOT NULL COMMENT 'Template Name',
  `template_text` text NOT NULL COMMENT 'Template Content',
  `template_styles` text COMMENT 'Templste Styles',
  `template_type` int(10) unsigned DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) NOT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date of Template Creation',
  `modified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of Template Modification',
  `orig_template_code` varchar(200) DEFAULT NULL COMMENT 'Original Template Code',
  `orig_template_variables` text COMMENT 'Original Template Variables',
  `is_legacy` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Should the template render in legacy mode',
  PRIMARY KEY (`template_id`),
  UNIQUE KEY `EMAIL_TEMPLATE_TEMPLATE_CODE` (`template_code`),
  KEY `EMAIL_TEMPLATE_ADDED_AT` (`added_at`),
  KEY `EMAIL_TEMPLATE_MODIFIED_AT` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Templates';

--
-- Dumping data for table `email_template`
--


--
-- Table structure for table `email_wishlist`
--

CREATE TABLE `email_wishlist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `wishlist_id` int(10) unsigned NOT NULL COMMENT 'Wishlist Id',
  `item_count` int(10) unsigned NOT NULL COMMENT 'Item Count',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `wishlist_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Wishlist Imported',
  `wishlist_modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Wishlist Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `EMAIL_WISHLIST_WISHLIST_ID` (`wishlist_id`),
  KEY `EMAIL_WISHLIST_ITEM_COUNT` (`item_count`),
  KEY `EMAIL_WISHLIST_CUSTOMER_ID` (`customer_id`),
  KEY `EMAIL_WISHLIST_WISHLIST_MODIFIED` (`wishlist_modified`),
  KEY `EMAIL_WISHLIST_WISHLIST_IMPORTED` (`wishlist_imported`),
  KEY `EMAIL_WISHLIST_CREATED_AT` (`created_at`),
  KEY `EMAIL_WISHLIST_UPDATED_AT` (`updated_at`),
  KEY `EMAIL_WISHLIST_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Wishlist';

--
-- Dumping data for table `email_wishlist`
--


--
-- Table structure for table `flag`
--

CREATE TABLE `flag` (
  `flag_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Flag Id',
  `flag_code` varchar(255) NOT NULL COMMENT 'Flag Code',
  `state` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Flag State',
  `flag_data` mediumtext COMMENT 'Flag Data',
  `last_update` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of Last Flag Update',
  PRIMARY KEY (`flag_id`),
  KEY `FLAG_LAST_UPDATE` (`last_update`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Flag';

--
-- Dumping data for table `flag`
--

INSERT INTO `flag` VALUES (1,'analytics_link_attempts_reverse_counter',0,'24','2024-01-29 23:31:57'),(2,'config_hash',0,'{\"scopes\":\"31c4b96937518ac03736150a62a70352c9f40a5b\"}','2024-02-02 23:15:32');

--
-- Table structure for table `gift_message`
--

CREATE TABLE `gift_message` (
  `gift_message_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'GiftMessage ID',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer ID',
  `sender` varchar(255) DEFAULT NULL COMMENT 'Sender',
  `recipient` varchar(255) DEFAULT NULL COMMENT 'Registrant',
  `message` text COMMENT 'Message',
  PRIMARY KEY (`gift_message_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Gift Message';

--
-- Dumping data for table `gift_message`
--


--
-- Table structure for table `googleoptimizer_code`
--

CREATE TABLE `googleoptimizer_code` (
  `code_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Google experiment code ID',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Optimized entity ID product ID or catalog ID',
  `entity_type` varchar(50) DEFAULT NULL COMMENT 'Optimized entity type',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `experiment_script` text COMMENT 'Google experiment script',
  PRIMARY KEY (`code_id`),
  UNIQUE KEY `GOOGLEOPTIMIZER_CODE_STORE_ID_ENTITY_ID_ENTITY_TYPE` (`store_id`,`entity_id`,`entity_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Google Experiment code';

--
-- Dumping data for table `googleoptimizer_code`
--


--
-- Table structure for table `import_history`
--

CREATE TABLE `import_history` (
  `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'History record ID',
  `started_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Started at',
  `user_id` int(10) 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 (`history_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Import history table';

--
-- Dumping data for table `import_history`
--


--
-- Table structure for table `importexport_importdata`
--

CREATE TABLE `importexport_importdata` (
  `id` int(10) 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=utf8 COMMENT='Import Data Table';

--
-- Dumping data for table `importexport_importdata`
--


--
-- Table structure for table `indexer_state`
--

CREATE TABLE `indexer_state` (
  `state_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Indexer State ID',
  `indexer_id` varchar(255) DEFAULT NULL COMMENT 'Indexer ID',
  `status` varchar(16) DEFAULT 'invalid' COMMENT 'Indexer Status',
  `updated` datetime DEFAULT NULL COMMENT 'Indexer Status',
  `hash_config` varchar(32) NOT NULL COMMENT 'Hash of indexer config',
  PRIMARY KEY (`state_id`),
  KEY `INDEXER_STATE_INDEXER_ID` (`indexer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT='Indexer State';

--
-- Dumping data for table `indexer_state`
--

INSERT INTO `indexer_state` VALUES (1,'design_config_grid','valid','2024-02-04 17:50:26','ecf4b9af797ed02a2dc9d32b02ced6f7'),(2,'customer_grid','valid','2024-01-29 23:32:00','6a78cc4105ae6ba058f17f32d705b60d'),(3,'catalog_category_product','invalid','2024-01-29 23:31:56','e61d0c854e7d387a0b310f498bd42405'),(4,'catalog_product_category','invalid','2024-01-29 23:31:56','fc3628ee6bd39863567371649f8bd9ab'),(5,'catalogrule_rule','invalid','2024-01-29 23:31:56','3b8e001d47b1b1dc5a5bf5b35805e505'),(6,'catalog_product_attribute','invalid','2024-01-29 23:31:56','e75cfbb70e3d6b2f580e4270b1b8bc5d'),(7,'cataloginventory_stock','invalid','2024-01-29 23:31:56','a4ccc407c5143e03afcf0d76ed9bff1e'),(8,'inventory','invalid','2024-01-29 23:31:56','f5012114a35df4f15d8b555986a57c7f'),(9,'catalogrule_product','invalid','2024-01-29 23:31:56','ef75d9e354f7d0c196c051c2aee776fd'),(10,'catalog_product_price','invalid','2024-01-29 23:31:56','a8f628eb3fb2781006de8564913aeb37'),(11,'catalogsearch_fulltext','invalid','2024-01-29 23:31:56','53a346e5552fdda9525c91ec98d47a5b');

--
-- Table structure for table `integration`
--

CREATE TABLE `integration` (
  `integration_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Integration ID',
  `name` varchar(255) NOT NULL COMMENT 'Integration name is displayed in the admin interface',
  `email` varchar(255) NOT NULL COMMENT 'Email address of the contact person',
  `endpoint` varchar(255) DEFAULT NULL COMMENT 'Endpoint for posting consumer credentials',
  `status` smallint(5) unsigned NOT NULL COMMENT 'Integration status',
  `consumer_id` int(10) unsigned DEFAULT NULL COMMENT 'Oauth consumer',
  `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',
  `setup_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Integration type - manual or config file',
  `identity_link_url` varchar(255) DEFAULT NULL COMMENT 'Identity linking Url',
  PRIMARY KEY (`integration_id`),
  UNIQUE KEY `INTEGRATION_NAME` (`name`),
  UNIQUE KEY `INTEGRATION_CONSUMER_ID` (`consumer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='integration';

--
-- Dumping data for table `integration`
--


--
-- Table structure for table `inventory_geoname`
--

CREATE TABLE `inventory_geoname` (
  `country_code` varchar(64) NOT NULL,
  `postcode` varchar(64) NOT NULL,
  `city` varchar(180) NOT NULL,
  `region` varchar(100) NOT NULL,
  `province` varchar(64) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inventory_geoname`
--


--
-- Table structure for table `inventory_low_stock_notification_configuration`
--

CREATE TABLE `inventory_low_stock_notification_configuration` (
  `source_code` varchar(255) NOT NULL,
  `sku` varchar(64) NOT NULL,
  `notify_stock_qty` decimal(12,4) DEFAULT NULL,
  PRIMARY KEY (`source_code`,`sku`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `inventory_low_stock_notification_configuration`
--

INSERT INTO `inventory_low_stock_notification_configuration` VALUES ('default','test',NULL);

--
