-- Table structure for table `catalogrule_product_price_replica`
--

CREATE TABLE `catalogrule_product_price_replica` (
  `rule_product_price_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Product PriceId',
  `rule_date` date NOT NULL COMMENT 'Rule Date',
  `customer_group_id` int DEFAULT NULL,
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `rule_price` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Rule Price',
  `website_id` smallint unsigned NOT NULL COMMENT 'Website ID',
  `latest_start_date` date DEFAULT NULL COMMENT 'Latest StartDate',
  `earliest_end_date` date DEFAULT NULL COMMENT 'Earliest EndDate',
  PRIMARY KEY (`rule_product_price_id`),
  UNIQUE KEY `CATRULE_PRD_PRICE_RULE_DATE_WS_ID_CSTR_GROUP_ID_PRD_ID` (`rule_date`,`website_id`,`customer_group_id`,`product_id`),
  KEY `CATALOGRULE_PRODUCT_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOGRULE_PRODUCT_PRICE_WEBSITE_ID` (`website_id`),
  KEY `CATALOGRULE_PRODUCT_PRICE_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='CatalogRule Product Price';

--
-- Dumping data for table `catalogrule_product_price_replica`
--


--
-- Table structure for table `catalogrule_product_replica`
--

CREATE TABLE `catalogrule_product_replica` (
  `rule_product_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Product ID',
  `rule_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Rule ID',
  `from_time` int unsigned NOT NULL DEFAULT '0' COMMENT 'From Time',
  `to_time` int unsigned NOT NULL DEFAULT '0' COMMENT 'To time',
  `customer_group_id` int DEFAULT NULL,
  `product_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `action_operator` varchar(10) DEFAULT 'to_fixed' COMMENT 'Action Operator',
  `action_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Action Amount',
  `action_stop` smallint NOT NULL DEFAULT '0' COMMENT 'Action Stop',
  `sort_order` int unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `website_id` smallint unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`rule_product_id`),
  UNIQUE KEY `UNQ_EAA51B56FF092A0DCB795D1CEF812B7B` (`rule_id`,`from_time`,`to_time`,`website_id`,`customer_group_id`,`product_id`,`sort_order`),
  KEY `CATALOGRULE_PRODUCT_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `CATALOGRULE_PRODUCT_WEBSITE_ID` (`website_id`),
  KEY `CATALOGRULE_PRODUCT_FROM_TIME` (`from_time`),
  KEY `CATALOGRULE_PRODUCT_TO_TIME` (`to_time`),
  KEY `CATALOGRULE_PRODUCT_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='CatalogRule Product';

--
-- Dumping data for table `catalogrule_product_replica`
--


--
-- Table structure for table `catalogrule_rule_cl`
--

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

--
-- Dumping data for table `catalogrule_rule_cl`
--


--
-- Table structure for table `catalogrule_website`
--

CREATE TABLE `catalogrule_website` (
  `rule_id` int unsigned NOT NULL COMMENT 'Rule ID',
  `website_id` smallint unsigned NOT NULL COMMENT 'Website ID',
  PRIMARY KEY (`rule_id`,`website_id`),
  KEY `CATALOGRULE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CATALOGRULE_WEBSITE_RULE_ID_CATALOGRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `catalogrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `CATALOGRULE_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Catalog Rules To Websites Relations';

--
-- Dumping data for table `catalogrule_website`
--

INSERT INTO `catalogrule_website` VALUES (1,1);

--
-- Table structure for table `catalogsearch_fulltext_cl`
--

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

--
-- Dumping data for table `catalogsearch_fulltext_cl`
--

INSERT INTO `catalogsearch_fulltext_cl` VALUES (1,1841),(2,1842),(3,1843),(4,1844),(5,1845),(6,1846),(7,1847),(8,1848),(9,1849),(10,1850),(11,1851),(12,1852),(13,1853),(14,1854),(15,1855),(16,1856),(17,1857),(18,1858),(19,1859),(20,1860),(21,1861),(22,1862),(23,1863),(24,1864),(25,1865),(26,1866),(27,1867),(28,1868),(29,1869),(30,1870),(31,1871),(32,1872),(33,1873),(34,1874),(35,1875),(36,1876),(37,1877),(38,1878),(39,1879),(40,1880),(41,1881),(42,1882),(43,1883),(44,1884),(45,1885),(46,1886),(47,1887),(48,1888),(49,1889),(50,1890),(51,1891),(52,1892),(53,1893),(54,1894),(55,1895),(56,1896),(57,1897),(58,1898),(59,1899),(60,1900),(61,1901),(62,1902),(63,1903),(64,1904),(65,1905),(66,1906),(67,1907),(68,1908),(69,1909),(70,1910),(71,1911),(72,1912),(73,1913),(74,1914),(75,1915),(76,1916),(77,1917),(78,1918),(79,1919),(80,1920),(81,1921),(82,1922),(83,1923),(84,1924),(85,1925),(86,1926),(87,1927),(88,1928),(89,1929),(90,1930),(91,1931),(92,1932),(93,1933),(94,1934),(95,1935),(96,1936),(97,1937),(98,1938),(99,1939),(100,1940),(101,1941),(102,1942),(103,1943),(104,1944),(105,1945),(106,1946),(107,1947),(108,1948),(109,1949),(110,1950),(111,1951),(112,1952),(113,1953),(114,1954),(115,1955),(116,1956),(117,1957),(118,1958),(119,1959),(120,1960),(121,1961),(122,1962),(123,1963),(124,1964),(125,1965),(126,1966),(127,1967),(128,1968),(129,1969),(130,1970),(131,1971),(132,1972),(133,1973),(134,1974),(135,1975),(136,1976),(137,1977),(138,1978),(139,1979),(140,1980),(141,1981),(142,1982),(143,1983),(144,1984),(145,1985),(146,1986),(147,1987),(148,1988),(149,1989),(150,1990),(151,1991),(152,1992),(153,1993),(154,1994),(155,1995),(156,1996),(157,1997),(158,1998),(159,1999),(160,2000),(161,2001),(162,2002),(163,2003),(164,2004),(165,2005),(166,2006),(167,2007),(168,2008),(169,2009),(170,2010),(171,2011),(172,2012),(173,2013),(174,2014),(175,2015),(176,2016),(177,2017),(178,2018),(179,2019),(180,2020),(181,2021),(182,2022),(183,2023),(184,2024),(185,2025),(186,2026),(187,2027),(188,2028),(189,2029),(190,2030),(191,2031),(192,2032),(193,2033),(194,2034),(195,2035),(196,2036),(197,2037),(198,2038),(199,2039),(200,2040),(201,2041),(202,2041),(203,2041),(204,2041),(205,2041),(206,2041),(207,2041),(208,2041),(209,2041),(210,2041),(211,2041),(212,2041),(213,2041),(214,2041),(215,2041),(216,2041),(217,2041),(218,2041),(219,2041),(220,2041),(221,2041),(222,2041),(223,2041),(224,2041),(225,2041),(226,2041),(227,2041),(247,2043),(248,2043),(249,2043),(250,2043),(251,2043),(252,2043),(253,2043),(254,2043),(255,2043),(256,2043),(257,2043),(258,2043),(259,2043),(260,2043),(261,2043),(262,2043),(263,2043),(264,2043),(265,2043),(266,2043),(267,2043),(268,2043),(269,2043);

--
-- Table structure for table `catalogsearch_recommendations`
--

CREATE TABLE `catalogsearch_recommendations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `query_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Query ID',
  `relation_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Relation ID',
  PRIMARY KEY (`id`),
  KEY `CATALOGSEARCH_RECOMMENDATIONS_QUERY_ID_SEARCH_QUERY_QUERY_ID` (`query_id`),
  KEY `CATALOGSEARCH_RECOMMENDATIONS_RELATION_ID_SEARCH_QUERY_QUERY_ID` (`relation_id`),
  CONSTRAINT `CATALOGSEARCH_RECOMMENDATIONS_QUERY_ID_SEARCH_QUERY_QUERY_ID` FOREIGN KEY (`query_id`) REFERENCES `search_query` (`query_id`) ON DELETE CASCADE,
  CONSTRAINT `CATALOGSEARCH_RECOMMENDATIONS_RELATION_ID_SEARCH_QUERY_QUERY_ID` FOREIGN KEY (`relation_id`) REFERENCES `search_query` (`query_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Advanced Search Recommendations';

--
-- Dumping data for table `catalogsearch_recommendations`
--


--
-- Table structure for table `checkout_agreement`
--

CREATE TABLE `checkout_agreement` (
  `agreement_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Agreement ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `content` text COMMENT 'Content',
  `content_height` varchar(25) DEFAULT NULL COMMENT 'Content Height',
  `checkbox_text` text COMMENT 'Checkbox Text',
  `is_active` smallint NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `is_html` smallint NOT NULL DEFAULT '0' COMMENT 'Is Html',
  `mode` smallint NOT NULL DEFAULT '0' COMMENT 'Applied mode',
  PRIMARY KEY (`agreement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Checkout Agreement';

--
-- Dumping data for table `checkout_agreement`
--


--
-- Table structure for table `checkout_agreement_store`
--

CREATE TABLE `checkout_agreement_store` (
  `agreement_id` int unsigned NOT NULL COMMENT 'Agreement ID',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`agreement_id`,`store_id`),
  KEY `CHECKOUT_AGREEMENT_STORE_STORE_ID_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `CHECKOUT_AGREEMENT_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `CHKT_AGRT_STORE_AGRT_ID_CHKT_AGRT_AGRT_ID` FOREIGN KEY (`agreement_id`) REFERENCES `checkout_agreement` (`agreement_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Checkout Agreement Store';

--
-- Dumping data for table `checkout_agreement_store`
--


--
-- Table structure for table `cms_block`
--

CREATE TABLE `cms_block` (
  `block_id` smallint NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `title` varchar(255) NOT NULL COMMENT 'Block Title',
  `identifier` varchar(255) NOT NULL COMMENT 'Block String Identifier',
  `content` mediumtext COMMENT 'Block Content',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Block Creation Time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Block Modification Time',
  `is_active` smallint NOT NULL DEFAULT '1' COMMENT 'Is Block Active',
  PRIMARY KEY (`block_id`),
  KEY `CMS_BLOCK_IDENTIFIER` (`identifier`),
  FULLTEXT KEY `CMS_BLOCK_TITLE_IDENTIFIER_CONTENT` (`title`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb3 COMMENT='CMS Block Table';

--
-- Dumping data for table `cms_block`
--

INSERT INTO `cms_block` VALUES (1,'Footer Links Block','footer_links_block','<ul class=\"footer links\">\n    <li class=\"nav item\"><a href=\"{{store url=\"about-us\"}}\">About us</a></li>\n    <li class=\"nav item\"><a href=\"{{store url=\"customer-service\"}}\">Customer Service</a></li>\n</ul>\n','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(2,'Contact us info','contact-us-info','<div class=\"contact-info cms-content\">\n   <p class=\"cms-content-important\">We love hearing from you, our Luma customers. Please contact us about anything at all. Your latest passion, unique health experience or request for a specific product. We’ll do everything we can to make your Luma experience unforgettable every time. Reach us however you like</p>\n   <div class=\"block block-contact-info\">\n       <div class=\"block-title\">\n           <strong>Contact Us Info</strong>\n       </div>\n       <div class=\"block-content\">\n           <div class=\"box box-phone\">\n               <strong class=\"box-title\">\n                   <span>Phone</span>\n               </strong>\n               <div class=\"box-content\">\n                   <span class=\"contact-info-number\">1-800-403-8838</span>\n                   <p>Call the Luma Helpline for concerns, product questions, or anything else. We’re here for you 24 hours a day - 365 days a year.</p>\n               </div>\n           </div>\n           <div class=\"box box-design-inquiries\">\n               <strong class=\"box-title\">\n                   <span>Apparel Design Inquiries</span>\n               </strong>\n               <div class=\"box-content\">\n                   <p>Are you an independent clothing designer? Feature your products on the Luma website! Please direct all inquiries via email to: <a href=\"mailto:cs@luma.com\">cs@luma.com</a></p>\n               </div>\n           </div>\n           <div class=\"box box-press-inquiries\">\n               <strong class=\"box-title\">\n                   <span>Press Inquiries</span>\n               </strong>\n               <div class=\"box-content\">\n                   <p>Please direct all media inquiries via email to: <a href=\"mailto:pr@luma.com\">pr@luma.com</a></p>\n               </div>\n           </div>\n       </div>\n   </div>\n</div>\n','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(3,'Sale Left Menu Block','sale-left-menu-block','<div class=\"categories-menu\"><strong class=\"title\"><span>Women\'s Deals</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/hoodies-and-sweatshirts-women.html\">Hoodies and Sweatshirts</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/jackets-women.html\">Jackets</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/tees-women.html\">Tees</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/tanks-women.html\">Bras & Tanks</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/bottoms-women/pants-women.html\">Pants</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/bottoms-women/shorts-women.html\">Shorts</a></li>\n</ul>\n\n<strong class=\"title\"><span>Mens\'s Deals</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/hoodies-and-sweatshirts-men.html\">Hoodies and Sweatshirts</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/jackets-men.html\">Jackets</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/tees-men.html\">Tees</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/bottoms-men/pants-men.html\">Pants</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/bottoms-men/shorts-men.html\">Shorts</a></li>\n</ul>\n\n<strong class=\"title\"><span>Gear Deals</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}gear/bags.html\">Bags</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}gear/fitness-equipment.html\">Fitness Equipment</a></li>\n</ul>\n</div>','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(4,'Gear Left Menu Block','gear-left-menu-block','<div class=\"categories-menu\"><strong class=\"title\"><span></span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}gear/bags.html\">Bags</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}gear/fitness-equipment.html\">Fitness Equipment</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}gear/watches.html\">Watches</a></li>\n</ul>\n</div>','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(5,'Men Left Menu Block','men-left-menu-block','<div class=\"categories-menu\"><strong class=\"title\"><span>Tops</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/hoodies-and-sweatshirts-men.html\">Hoodies & Sweatshirts</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/jackets-men.html\">Jackets</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/tees-men.html\">Tees</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/tanks-men.html\">Tanks</a></li>\n</ul>\n\n<strong class=\"title\"><span>Bottoms</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/bottoms-men/pants-men.html\">Pants</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/bottoms-men/shorts-men.html\">Shorts</a></li>\n</ul>\n</div>','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(6,'Women Left Menu Block','women-left-menu-block','<div class=\"categories-menu\"><strong class=\"title\"><span>Tops</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/hoodies-and-sweatshirts-women.html\">Hoodies & Sweatshirts</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/jackets-women.html\">Jackets</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/tees-women.html\">Tees</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/tanks-women.html\">Bras & Tanks</a></li>\n</ul>\n\n<strong class=\"title\"><span>Bottoms</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/bottoms-women/pants-women.html\">Pants</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/bottoms-women/shorts-women.html\">Shorts</a></li>\n</ul>\n</div>','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(7,'New Left Menu Block','new-left-menu-block','<div class=\"categories-menu\"><strong class=\"title\"><span>New in women\'s</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/hoodies-and-sweatshirts-women.html\">Hoodies & Sweatshirts</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/jackets-women.html\">Jackets</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/tees-women.html\">Tees</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/tops-women/tanks-women.html\">Bras & Tanks</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/bottoms-women/pants-women.html\">Pants</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}women/bottoms-women/shorts-women.html\">Shorts</a></li>\n</ul>\n\n<strong class=\"title\"><span>New in men\'s</span></strong>\n<ul class=\"items\">\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/hoodies-and-sweatshirts-men.html\">Hoodies & Sweatshirts</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/jackets-men.html\">Jackets</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/tees-men.html\">Tees</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/tops-men/tanks-men.html\">Tanks</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/bottoms-men/pants-men.html\">Pants</a></li>\n    <li class=\"item\"><a href=\"{{store url=\"\"}}men/bottoms-men/shorts-men.html\">Shorts</a></li>\n</ul>\n</div>','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(8,'Women Block','women-block','<div class=\"blocks-promo\">\n    <a href=\"{{store url=\"\"}}women.html\" class=\"block-promo womens-main\">\n        <img src=\"{{media url=\"wysiwyg/womens/womens-main.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <span class=\"info\">New Luma Yoga Collection</span>\n            <strong class=\"title\">Yoga is ancient<br />Clothing shouldn’t be</strong>\n            <span class=\"more button\">Shop New Yoga</span>\n        </span>\n    </a>\n    <div class=\"block-promo-wrapper block-promo-2columns\">\n        <a href=\"{{store url=\"\"}}women/tops-women/tees-women.html\" class=\"block-promo womens-t-shirts\">\n            <span class=\"content\">\n                <strong class=\"title\">You can’t have too many tees</strong>\n                <img src=\"{{media url=\"wysiwyg/womens/womens-t-shirts.png\"}}\" alt=\"\" />\n                <span class=\"info\">4 tees for the price of 3. Right now</span>\n                <span class=\"more icon\">Women’s Tees</span>\n            </span>\n        </a>\n        <a href=\"{{store url=\"\"}}women/bottoms-women/pants-women.html\" class=\"block-promo womens-pants\">\n            <img src=\"{{media url=\"wysiwyg/womens/womens-pants.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Hot pants<br />Hot deals</strong>\n                <span class=\"info\"><span>20% OFF</span>Luma pants when you shop today*</span>\n                <span class=\"more icon\">Shop Pants</span>\n            </span>\n        </a>\n    </div>\n    <a href=\"{{store url=\"\"}}collections/erin-recommends.html\" class=\"block-promo womens-erin\">\n        <span class=\"content\">\n            <strong class=\"title\">What would Erin wear?</strong>\n            <span class=\"info\">It’s no secret: see Luma founder Erin Renny’s wardrobe go-to’s</span>\n            <span class=\"more icon\">Shop Erin Recommends</span>\n        </span>\n        <span class=\"image\"><img src=\"{{media url=\"wysiwyg/womens/womens-erin.jpg\"}}\" alt=\"\" /></span>\n    </a>\n    <div class=\"block-promo-wrapper block-promo-3columns\">\n        <a href=\"{{store url=\"\"}}women/bottoms-women/pants-women.html\" class=\"block-promo womens-category-pants\">\n            <span class=\"content\">\n                <strong class=\"title\">Luma pants</strong>\n                <span class=\"info\">Pants for yoga, gym and outdoors</span>\n                <span class=\"more icon\">Shop Pants</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/womens/womens-category-pants.jpg\"}}\" alt=\"\" /></span>\n        </a>\n        <a href=\"{{store url=\"\"}}women/bottoms-women/shorts-women.html\" class=\"block-promo womens-category-shorts\">\n            <span class=\"content\">\n                <strong class=\"title\">Luma shorts</strong>\n                <span class=\"info\">Exercise comfort</span>\n                <span class=\"more icon\">Shop Shorts</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/womens/womens-category-shorts.jpg\"}}\" alt=\"\" /></span>\n        </a>\n        <a href=\"{{store url=\"\"}}women/tops-women/tanks-women.html\" class=\"block-promo womens-category-tanks\">\n            <span class=\"content\">\n                <strong class=\"title\">Luma Bras<br />Tanks</strong>\n                <span class=\"info\">Stock up for summer!</span>\n                <span class=\"more icon\">Shop Now</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/womens/womens-category-tanks.jpg\"}}\" alt=\"\" /></span>\n        </a>\n    </div>\n</div>\n<div class=\"content-heading\">\n    <h2 class=\"title\">Hot Sellers</h2>\n    <p class=\"info\">Favorites from Luma shoppers</p>\n</div>\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_per_page=\"4\" products_count=\"4\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`sku`,`operator`:`()`,`value`:`WS12, WT09, WH05, WP12`^]^]\"}}','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(9,'Training Block','training-block','<div class=\"blocks-promo\">\n\n    <a href=\"{{store url=\"\"}}training.html\" class=\"block-promo training-main\">\n        <img src=\"{{media url=\"wysiwyg/training/training-main.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <strong class=\"title\">\n                <span>Motivate</span> yourself.<br />\n                <span>Reach</span> goals.<br />\n                <span>Boost</span> ambition.<br />\n                <span>Max</span> fitness.<br />\n                <span>Upgrade</span> lifestyle.\n            </strong>\n        </span>\n    </a>\n    <a href=\"{{store url=\"\"}}collections/erin-recommends.html\" class=\"block-promo training-erin\">\n        <img src=\"{{media url=\"wysiwyg/training/training-erin.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <strong class=\"title\">Before creating Luma, pro trainer Erin Renny helped world-class athletes reach peak fitness</strong>\n            <span class=\"info\">Hand-selected by Erin, our training downloads reflect a commitment to yoga, health and wellness.</span>\n        </span>\n    </a>\n    <a href=\"{{store url=\"\"}}training/training-video.html\" class=\"block-promo training-on-demand\">\n        <span class=\"content\">\n            <span class=\"icon download\"><span>Download</span></span>\n            <strong class=\"title\">Training on demand</strong>\n            <span class=\"info\">Luma downloads to inspire and&nbsp;challenge.<br />Your space, your pace</span>\n            <span class=\"more icon\">Videos</span>\n        </span>\n    </a>\n</div>\n<div class=\"content-heading\">\n    <h2 class=\"title\">Top Videos</h2>\n    <p class=\"info\">Stream free with subscription</p>\n</div>\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_count=\"4\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`sku`,`operator`:`()`,`value`:`241-MB08, 240-LV05, 240-LV09, 240-LV07`^]^]\"}}','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(10,'Men Block','men-block','<div class=\"blocks-promo\">\n    <a href=\"{{store url=\"\"}}men.html\" class=\"block-promo mens-main\">\n        <img src=\"{{media url=\"wysiwyg/mens/mens-main.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <span class=\"info\">Luma’s Performance Fabric collection</span>\n            <strong class=\"title\">Going the extra mile just got extra comfortable</strong>\n            <span class=\"more button\">Shop Performance</span>\n        </span>\n    </a>\n    <div class=\"block-promo-wrapper block-promo-2columns\">\n        <a href=\"{{store url=\"\"}}men/tops-men/tees-men.html\" class=\"block-promo mens-t-shirts\">\n            <span class=\"content\">\n                <strong class=\"title\">Save up to $24!</strong>\n                <img src=\"{{media url=\"wysiwyg/mens/mens-t-shirts.png\"}}\" alt=\"\" />\n                <span class=\"info\">Buy 3 Luma tees, get 4 instead</span>\n                <span class=\"more icon\">Shop Tees</span>\n            </span>\n        </a>\n        <a href=\"{{store url=\"\"}}men/bottoms-men/pants-men.html\" class=\"block-promo mens-pants\">\n            <img src=\"{{media url=\"wysiwyg/mens/mens-pants.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Last chance<br />for pants</strong>\n                <span class=\"info\">Take <span>20% OFF</span>and save bigtime*</span>\n                <span class=\"more icon\">Shop Pants</span>\n            </span>\n        </a>\n    </div>\n    <div class=\"block-promo-wrapper block-promo-3columns\">\n        <a href=\"{{store url=\"\"}}men/bottoms-men/shorts-men.html\" class=\"block-promo mens-category-shorts\">\n            <span class=\"content\">\n                <strong class=\"title\">Luma shorts</strong>\n                <span class=\"info\">Cool it now</span>\n                <span class=\"more icon\">Shop Shorts</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/mens/mens-category-shorts.jpg\"}}\" alt=\"\" /></span>\n        </a>\n        <a href=\"{{store url=\"\"}}men/tops-men/tees-men.html\" class=\"block-promo mens-category-tees\">\n            <span class=\"content\">\n                <strong class=\"title\">Luma tees</strong>\n                <span class=\"info\">Grab a tee or two!</span>\n                <span class=\"more icon\">Shop Tees</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/mens/mens-category-tees.jpg\"}}\" alt=\"\" /></span>\n        </a>\n        <a href=\"{{store url=\"\"}}men/tops-men/hoodies-and-sweatshirts-men.html\" class=\"block-promo mens-category-hoodies\">\n            <span class=\"content\">\n                <strong class=\"title\">Luma hoodies</strong>\n                <span class=\"info\">Dress for fitness</span>\n                <span class=\"more icon\">Shop Hoodies</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/mens/mens-category-hoodies.jpg\"}}\" alt=\"\" /></span>\n        </a>\n    </div>\n</div>\n<div class=\"content-heading\">\n    <h2 class=\"title\">Hot Sellers</h2>\n    <p class=\"info\">Favorites from Luma shoppers</p>\n</div>\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_per_page=\"4\" products_count=\"4\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`sku`,`operator`:`()`,`value`:`MT07, MH07, MSH03, MP03`^]^]\"}}','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(11,'Gear Block','gear-block','<div class=\"blocks-promo\">\n    <a href=\"{{store url=\"\"}}gear.html\" class=\"block-promo gear-main\">\n        <img src=\"{{media url=\"wysiwyg/gear/gear-main.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <strong class=\"title\">Sprite Yoga Companion Kit</strong>\n            <span class=\"info\">Save up to 20% on a&nbsp;bundle!</span>\n            <span class=\"more button\">Shop Yoga Kit</span>\n        </span>\n    </a>\n    <div class=\"block-promo-wrapper block-promo-2columns\">\n        <a href=\"{{store url=\"\"}}gear/fitness-equipment.html\" class=\"block-promo gear-fitnes\">\n            <img src=\"{{media url=\"wysiwyg/gear/gear-fitnes.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Loosen Up</strong>\n                <span class=\"info\">Extend your training with yoga straps, tone bands,<br />and jump ropes</span>\n                <span class=\"more icon\">Shop Fitness</span>\n            </span>\n        </a>\n        <a href=\"{{store url=\"\"}}gear/fitness-equipment.html\" class=\"block-promo gear-equipment\">\n            <img src=\"{{media url=\"wysiwyg/gear/gear-equipment.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Here’s to you!</strong>\n                <span class=\"info\">$4 Luma water bottle<br />(save&nbsp;70%)</span>\n                <span class=\"note\">Enter promo code H2O<br />at check out</span>\n            </span>\n        </a>\n    </div>\n    <div class=\"block-promo-wrapper block-promo-3columns\">\n        <a href=\"{{store url=\"\"}}gear/bags.html\" class=\"block-promo gear-category-bags\">\n            <span class=\"content\">\n                <strong class=\"title\">Tote, cart or carry</strong>\n                <span class=\"info\">Luma bags go the distance</span>\n                <span class=\"more icon\">Shop Bags</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/gear/gear-category-bags.jpg\"}}\" alt=\"\" /></span>\n        </a>\n        <a href=\"{{store url=\"\"}}gear/fitness-equipment.html\" class=\"block-promo gear-category-equipment\">\n            <span class=\"content\">\n                <strong class=\"title\">Let’s get after it!</strong>\n                <span class=\"info\">Luma gym equipment fits your goals and&nbsp;style</span>\n                <span class=\"more icon\">Shop Equipment</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/gear/gear-category-equipment.jpg\"}}\" alt=\"\" /></span>\n        </a>\n        <a href=\"{{store url=\"\"}}gear/watches.html\" class=\"block-promo gear-category-watches\">\n            <span class=\"content\">\n                <strong class=\"title\">Luma watches</strong>\n                <span class=\"info\">Keeping pace has never been more stylish</span>\n                <span class=\"more icon\">Shop Watches</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/gear/gear-category-watches.jpg\"}}\" alt=\"\" /></span>\n        </a>\n    </div>\n</div>\n<div class=\"content-heading\">\n    <h2 class=\"title\">Hot Sellers</h2>\n    <p class=\"info\">Favorites from Luma shoppers</p>\n</div>\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_per_page=\"4\" products_count=\"4\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`sku`,`operator`:`()`,`value`:`24-MB02, 24-WB04, 24-UG06, 24-WG080`^]^]\"}}','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(12,'Sale Block','sale-block','<div class=\"blocks-promo\">\n    <a href=\"{{store url=\"\"}}promotions/women-sale.html\" class=\"block-promo sale-main\">\n        <img src=\"{{media url=\"wysiwyg/sale/sale-main.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <span class=\"info\">Women’s Deals</span>\n            <strong class=\"title\">Pristine prices on pants, tanks and bras.</strong>\n            <span class=\"more button\">Shop Women’s Deals</span>\n        </span>\n    </a>\n    <div class=\"block-promo-wrapper block-promo-2columns\">\n        <a href=\"{{store url=\"\"}}promotions/men-sale.html\" class=\"block-promo sale-mens\">\n            <img src=\"{{media url=\"wysiwyg/sale/sale-mens.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Men’s Bargains</strong>\n                <span class=\"info\">Stretch your budget with active attire</span>\n                <span class=\"more icon\">Shop Men’s Deals</span>\n            </span>\n        </a>\n        <a href=\"{{store url=\"\"}}gear.html\" class=\"block-promo sale-women\">\n            <img src=\"{{media url=\"wysiwyg/sale/sale-gear.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Luma Gear Steals</strong>\n                <span class=\"info\">Your best efforts deserve a deal</span>\n                <span class=\"more icon\">Shop Luma Gear</span>\n            </span>\n        </a>\n    </div>\n    <div class=\"block-promo-wrapper block-promo-3columns\">\n        <a class=\"block-promo sale-20-off\">\n            <span class=\"content\">\n                <strong class=\"title\">20% OFF</strong>\n                <span class=\"info\">Every $200-plus purchase!</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/sale/sale-20-off.png\"}}\" alt=\"\" /></span>\n        </a>\n        <a class=\"block-promo sale-free-shipping\">\n            <span class=\"content\">\n                <strong class=\"title\">Spend $50 or more&nbsp;&mdash; shipping is free!</strong>\n                <img src=\"{{media url=\"wysiwyg/sale/sale-free-shipping.png\"}}\" alt=\"\" />\n                <span class=\"info\">Buy more, save more</span>\n            </span>\n        </a>\n        <a href=\"{{store url=\"\"}}women/tops-women/tees-women.html\" class=\"block-promo sale-womens-t-shirts\">\n            <span class=\"content\">\n                <strong class=\"title\">You can\'t have too many tees</strong>\n                <span class=\"info\">4 tees for the price of 3. Right now</span>\n                <span class=\"more icon\">Tees on sale</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/womens/womens-t-shirts.png\"}}\" alt=\"\" /></span>\n        </a>\n    </div>\n</div>','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(13,'New Block','new-block','<div class=\"blocks-promo\">\n    <a href=\"{{store url=\"\"}}collections/yoga-new.html\" class=\"block-promo new-main\">\n        <img src=\"{{media url=\"wysiwyg/new/new-main.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <span class=\"info\">New Luma Yoga Collection</span>\n            <strong class=\"title\">The very latest yoga styles  plus twists on timeless classics</strong>\n            <span class=\"more button\">Shop New Yoga</span>\n        </span>\n    </a>\n\n    <div class=\"block-promo-wrapper block-promo-2columns\">\n        <a href=\"{{store url=\"\"}}collections/performance-new.html\" class=\"block-promo new-performance\">\n            <img src=\"{{media url=\"wysiwyg/new/new-performance.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Whatever day brings</strong>\n                <span class=\"info\">Luma Cocona<sup>™</sup> for breathability, CoolTech<sup>™</sup> for wicking, or a blend of&nbsp;both.</span>\n                <span class=\"more icon\">Performance Fabrics</span>\n            </span>\n        </a>\n        <a href=\"{{store url=\"\"}}collections/eco-new.html\" class=\"block-promo new-eco\">\n            <img src=\"{{media url=\"wysiwyg/new/new-eco.jpg\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">A sense of renewal</strong>\n                <span class=\"info\">Enjoy comfort of body and mind with Luma eco-friendly choices</span>\n                <span class=\"more icon\">Shop Eco Friendly </span>\n            </span>\n        </a>\n    </div>\n</div>\n<div class=\"content-heading\">\n    <h2 class=\"title\">Luma\'s Latest</h2>\n    <p class=\"info\">Just in time for the new season!</p>\n</div>\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_per_page=\"4\" products_count=\"4\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`new`,`operator`:`==`,`value`:`1`^]^]\"}}','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(14,'Home Page Block','home-page-block','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"blocks-promo\"&gt;\r\n   &lt;a href=\"{{store url=\"\"}}collections/yoga-new.html\" class=\"block-promo home-main\"&gt;\r\n       &lt;img src=\"{{media url=wysiwyg/home/home-main.jpg}}\" alt=\"\" /&gt;\r\n       &lt;span class=\"content bg-white\"&gt;\r\n           &lt;span class=\"info\"&gt;New Luma Yoga Collection&lt;/span&gt;\r\n           &lt;strong class=\"title\"&gt;Get fit and look fab in new seasonal styles&lt;/strong&gt;\r\n           &lt;span class=\"action more button\"&gt;Shop New Yoga&lt;/span&gt;\r\n       &lt;/span&gt;\r\n   &lt;/a&gt;\r\n   &lt;div class=\"block-promo-wrapper block-promo-hp\"&gt;\r\n       &lt;a href=\"{{store url=\"\"}}promotions/pants-all.html\" class=\"block-promo home-pants\"&gt;\r\n           &lt;img src=\"{{media url=wysiwyg/home/home-pants.jpg}}\" alt=\"\" /&gt;\r\n           &lt;span class=\"content\"&gt;\r\n               &lt;strong class=\"title\"&gt;20% OFF&lt;/strong&gt;\r\n               &lt;span class=\"info\"&gt;Luma pants when you shop today*&lt;/span&gt;\r\n               &lt;span class=\"action more icon\"&gt;Shop Pants&lt;/span&gt;\r\n           &lt;/span&gt;\r\n       &lt;/a&gt;\r\n       &lt;a href=\"{{store url=\"\"}}promotions/tees-all.html\" class=\"block-promo home-t-shirts\"&gt;\r\n           &lt;span class=\"image\"&gt;&lt;img src=\"{{media url=wysiwyg/home/home-t-shirts.png}}\" alt=\"\" /&gt;&lt;/span&gt;\r\n           &lt;span class=\"content\"&gt;\r\n               &lt;strong class=\"title\"&gt;Even more ways to mix and match&lt;/strong&gt;\r\n               &lt;span class=\"info\"&gt;Buy 3 Luma tees get a 4th free&lt;/span&gt;\r\n               &lt;span class=\"action more icon\"&gt;Shop Tees&lt;/span&gt;\r\n           &lt;/span&gt;\r\n       &lt;/a&gt;\r\n       &lt;a href=\"{{store url=\"\"}}collections/erin-recommends.html\" class=\"block-promo home-erin\"&gt;\r\n           &lt;img src=\"{{media url=wysiwyg/home/home-erin.jpg}}\" alt=\"\" /&gt;\r\n           &lt;span class=\"content\"&gt;\r\n               &lt;strong class=\"title\"&gt;Take it from Erin&lt;/strong&gt;\r\n               &lt;span class=\"info\"&gt;Luma founder Erin Renny shares her favorites!&lt;/span&gt;\r\n               &lt;span class=\"action more icon\"&gt;Shop Erin Recommends&lt;/span&gt;\r\n           &lt;/span&gt;\r\n       &lt;/a&gt;\r\n       &lt;a href=\"{{store url=\"\"}}collections/performance-fabrics.html\" class=\"block-promo home-performance\"&gt;\r\n           &lt;img src=\"{{media url=wysiwyg/home/home-performance.jpg}}\" alt=\"\" /&gt;\r\n           &lt;span class=\"content bg-white\"&gt;\r\n               &lt;strong class=\"title\"&gt;Science meets performance&lt;/strong&gt;\r\n               &lt;span class=\"info\"&gt;Wicking to raingear, Luma covers&amp;nbsp;you&lt;/span&gt;\r\n               &lt;span class=\"action more icon\"&gt;Shop Performance&lt;/span&gt;\r\n           &lt;/span&gt;\r\n       &lt;/a&gt;\r\n       &lt;a href=\"{{store url=\"\"}}collections/eco-friendly.html\" class=\"block-promo home-eco\"&gt;\r\n           &lt;img src=\"{{media url=wysiwyg/home/home-eco.jpg}}\" alt=\"\" /&gt;\r\n           &lt;span class=\"content bg-white\"&gt;\r\n               &lt;strong class=\"title\"&gt;Twice around, twice as nice&lt;/strong&gt;\r\n               &lt;span class=\"info\"&gt;Find conscientious, comfy clothing in our &lt;nobr&gt;eco-friendly&lt;/nobr&gt; collection&lt;/span&gt;\r\n               &lt;span class=\"action more icon\"&gt;Shop Eco-Friendly&lt;/span&gt;\r\n           &lt;/span&gt;\r\n       &lt;/a&gt;\r\n   &lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;div class=\"content-heading\"&gt;\r\n   &lt;h2 class=\"title\"&gt;Hot Sellers&lt;/h2&gt;\r\n   &lt;p class=\"info\"&gt;Here is what`s trending on Luma right now&lt;/p&gt;\r\n&lt;/div&gt;\r\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_per_page=\"8\" products_count=\"8\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`sku`,`operator`:`()`,`value`:`WS12, WT09, MT07, MH07, 24-MB02, 24-WB04, 241-MB08, 240-LV05`^]^]\"}}</div>','2024-02-29 10:29:46','2024-03-18 07:52:35',1),(15,'Performance Fabrics Block','performance-fabrics-block','<div class=\"blocks-promo\">\n   <div class=\"block-promo collection-performance\">\n       <img src=\"{{media url=\"wysiwyg/collection/collection-performance.jpg\"}}\" alt=\"\" />\n       <span class=\"content\">\n           <strong class=\"title\">You\'re the best</strong>\n           <span class=\"info\">Make a strong statement with Luma Performance sportswear</span>\n       </span>\n   </div>\n</div>\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_count=\"5\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`performance_fabric`,`operator`:`==`,`value`:`1`^],`1--2`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`new`,`operator`:`==`,`value`:`1`^]^]\"}}','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(16,'Eco Friendly Block','eco-friendly-block','<div class=\"blocks-promo\">\n    <div class=\"block-promo collection-eco\">\n        <img src=\"{{media url=\"wysiwyg/collection/collection-eco.jpg\"}}\" alt=\"\" />\n        <span class=\"content\">\n            <strong class=\"title\">Eco-friendly, ego-friendly</strong>\n            <span class=\"info\">Recycled polyester, hemp and organic cotton apperel</span>\n        </span>\n    </div>\n</div>\n{{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" products_count=\"5\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`eco_collection`,`operator`:`==`,`value`:`1`^],`1--2`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`new`,`operator`:`==`,`value`:`1`^]^]\"}}','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(17,'Login Info Block','login-data','<div class=\"message info\" style=\"margin-top: 50px;\">\n    <p><strong>Try Demo Customer Access</strong></p>\n    <p><span style=\"display:inline-block; width: 80px; padding-right: 10px;\">Email:</span>roni_cost@example.com</p>\n    <p><span style=\"display:inline-block; width: 80px; padding-right: 10px;\">Password:</span>roni_cost3@example.com</p>\n</div>','2024-02-29 10:29:46','2024-02-29 10:29:46',1),(18,'Payments Icons','payment-icons','<span class=\"payment-icons\">\n    <ul>\n        <li><a href=\"#\"><img class=\"image-responsive middle-block\" src=\"{{media url=\"wysiwyg/paymet/americanexpress.png\"}}\" alt=\"americanexpress\" /></a></li>\n        <li><a href=\"#\"><img class=\"image-responsive middle-block\" src=\"{{media url=\"wysiwyg/paymet/discover.png\"}}\" alt=\"discover\" /></a></li>\n        <li><a href=\"#\"><img class=\"image-responsive middle-block\" src=\"{{media url=\"wysiwyg/paymet/maestro.png\"}}\" alt=\"maestro\" /></a></li>\n        <li><a href=\"#\"><img class=\"image-responsive middle-block\" src=\"{{media url=\"wysiwyg/paymet/master.png\"}}\" alt=\"master\" /></a></li>\n        <li><a href=\"#\"><img class=\"image-responsive middle-block\" src=\"{{media url=\"wysiwyg/paymet/visa.png\"}}\" alt=\"visa\" /></a></li>\n    </ul>\n</span>','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(19,'Home Slider','home-slider','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"home-slider-wrapper slider\"&gt;\r\n    &lt;div class=\"home-slider-main below-padding\"&gt;\r\n        &lt;ul class=\"home-slider\"&gt;\r\n            &lt;li&gt;&lt;img class=\"image-responsive middle-block\" src=\"{{media url=wysiwyg/slider/banner-image.jpg}}\" alt=\"home banner\" /&gt;\r\n&lt;div class=\"caption\"&gt;\r\n                        &lt;div class=\"container\"&gt;\r\n                            &lt;div class=\"row\"&gt;\r\n                                &lt;div class=\"col-12 col-lg-4 col-md-6\"&gt;\r\n                                    &lt;h1 class=\"h1\"&gt;Find &lt;span class=\"secondary-color\"&gt;Everything&lt;/span&gt; Your Office\r\n                                        &lt;br /&gt;Needs.\r\n                                    &lt;/h1&gt;\r\n                                    &lt;a href=\"#\" class=\"btn-custom\"&gt;Choose Your Packaging Style &lt;/a&gt;\r\n                                &lt;/div&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt; &lt;/li&gt;\r\n            &lt;li style=\"display:none;\"&gt;&lt;img class=\"image-responsive middle-block\" src=\"{{media url=wysiwyg/slider/banner-image-1.jpg}}\" alt=\"home banner\" /&gt; \r\n&lt;div class=\"caption\"&gt;\r\n                        &lt;div class=\"container\"&gt;\r\n                            &lt;div class=\"row\"&gt;\r\n                                &lt;div class=\"col-12  col-lg-4 col-md-6\"&gt;\r\n                                    &lt;h1 class=\"h1\"&gt;Find &lt;span class=\"secondary-color\"&gt;Everything&lt;/span&gt; Your Office\r\n                                        &lt;br /&gt; Needs.\r\n                                    &lt;/h1&gt;\r\n                                    &lt;a href=\"#\" class=\"btn-custom\"&gt;Choose Your Packaging Style &lt;/a&gt;\r\n                                &lt;/div&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n&lt;/li&gt;\r\n        &lt;/ul&gt;\r\n    &lt;/div&gt;\r\n    &lt;script type=\"text/javascript\"&gt;\r\n        require([\'jquery\', \'bizkickowlcarousel\'], function() {\r\n            jQuery(document).ready(function() {\r\n                jQuery(\".home-slider\").owlCarousel({\r\n                    items: 1,\r\n                    itemsDesktop: [1198, 1],\r\n                    itemsDesktopSmall: [1023, 1],\r\n                    itemsTablet: [768, 1],\r\n                    itemsTabletSmall: [767, 1],\r\n                    itemsMobile: [479, 1],\r\n                    pagination: true,\r\n                    navigationText: [\"&lt;div class=\'left-arrow\'&gt;&lt;i class=\'fa fa-angle-left\'&gt;&lt;/i&gt;&lt;/div&gt;\", \"&lt;div class=\'right-arrow\'&gt;&lt;i class=\'fa fa-angle-right\'&gt;&lt;/div&gt;\"],\r\n                    navigation: true,\r\n                });\r\n                jQuery(\".home-slider li\").show();\r\n            });\r\n        });\r\n    &lt;/script&gt;\r\n&lt;/div&gt;</div>','2024-03-06 11:30:00','2024-03-20 10:49:51',1),(20,'Bizkick Above','bizkick-above','{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"home-slider\"}}','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(21,'Home Images Block','home-images-one','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"home-images-wrapper above-padding below-padding\"&gt;\r\n    &lt;div class=\"page-main\"&gt;\r\n        &lt;div class=\"home-image-main\"&gt;\r\n            &lt;div class=\"home-image-inner\"&gt;\r\n                &lt;a href=\"#\"&gt;\r\n                    &lt;img class=\"image-responsive middle-block\" src=\"{{media url=wysiwyg/advertisement/bizkick-male-watch1.png}}\" alt=\"bizkick-fashion-image\" /&gt;\r\n                &lt;/a&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"home-image-inner\"&gt;\r\n                &lt;a href=\"#\"&gt;\r\n                    &lt;img class=\"image-responsive middle-block\" src=\"{{media url=wysiwyg/advertisement/bizkick-male-watch2.png}}\" alt=\"bizkick-fashion-image\" /&gt;\r\n                &lt;/a&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"home-image-inner\"&gt;\r\n                &lt;a href=\"#\"&gt;\r\n                    &lt;img class=\"image-responsive middle-block\" src=\"{{media url=wysiwyg/advertisement/bizkick-male-watch3.png}}\" alt=\"bizkick-fashion-image\" /&gt;\r\n                &lt;/a&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/div&gt;</div>','2024-03-06 11:30:00','2024-03-18 07:54:05',0),(22,'Bizkick Below','bizkick-below','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"home-images-one\"}}\r\n&lt;div class=\"page-main\"&gt;\r\n{{widget type=\"Magento\\Catalog\\Block\\Product\\Widget\\NewWidget\" display_type=\"all_products\" show_pager=\"0\" products_count=\"10\" template=\"product/widget/new/content/new_grid.phtml\"}}\r\n&lt;/div&gt;\r\n{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"home-images-two\"}}\r\n&lt;div class=\"page-main\"&gt;\r\n    {{widget type=\"Magento\\CatalogWidget\\Block\\Product\\ProductsList\" title=\"Featured Products\" show_pager=\"0\" products_count=\"10\" template=\"product/widget/content/grid.phtml\" conditions_encoded=\"^[`1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Combine`,`aggregator`:`all`,`value`:`1`,`new_child`:``^],`1--1`:^[`type`:`Magento||CatalogWidget||Model||Rule||Condition||Product`,`attribute`:`is_featured`,`operator`:`==`,`value`:`1`^]^]\"}}    \r\n&lt;/div&gt;\r\n{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"home-services\"}}\r\n{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"home_testimonials\"}}\r\n{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"home_blogs\"}}\r\n{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"home-brands\"}}</div>','2024-03-06 11:30:00','2024-03-18 13:00:12',0),(23,'Home Testimonials','home_testimonials','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"hb-wrapper above-padding below-padding above-margin below-margin\"&gt;\r\n    &lt;div class=\"page-main\"&gt;\r\n        &lt;div class=\"page-title-main\"&gt;&lt;strong&gt;What Our Customer Says&lt;/strong&gt;&lt;/div&gt;\r\n        &lt;div class=\"hb-row\"&gt;\r\n            &lt;div class=\"hb-testimonoals\"&gt;\r\n                &lt;ul id=\"hb-testimonials\"&gt;\r\n                    &lt;li style=\"display: none;\"&gt;\r\n                        &lt;div class=\"hb-inner\"&gt;\r\n                            &lt;div class=\"hb-content\"&gt;\r\n                                &lt;p&gt;It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. Lorem Ipsum is simply dummy text of the printing and typesetting industry.&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"hb-image\"&gt;\r\n                                &lt;img src=\"{{media url=wysiwyg/testimonial/testimonial-1.png}}\" alt=\"testimonial-image\" /&gt;\r\n                                &lt;span&gt;\r\n                                    &lt;h4&gt;Joh Doe&lt;/h4&gt;\r\n                                    &lt;p&gt;Web Designer&lt;/p&gt;\r\n                                &lt;/span&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/li&gt;\r\n                    &lt;li style=\"display: none;\"&gt;\r\n                        &lt;div class=\"hb-inner\"&gt;\r\n                            &lt;div class=\"hb-content\"&gt;\r\n                                &lt;p&gt;There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable.&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"hb-image\"&gt;\r\n                                &lt;img src=\"{{media url=wysiwyg/testimonial/testimonial-2.png}}\" alt=\"testimonial-image\" /&gt;\r\n                                &lt;span&gt;\r\n                                    &lt;h4&gt;Joh Doe&lt;/h4&gt;\r\n                                    &lt;p&gt;Web Designer&lt;/p&gt;\r\n                                &lt;/span&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/li&gt;\r\n                    &lt;li style=\"display: none;\"&gt;\r\n                        &lt;div class=\"hb-inner\"&gt;\r\n                            &lt;div class=\"hb-content\"&gt;\r\n                                &lt;p&gt;It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. Lorem Ipsum is simply dummy text of the printing and typesetting industry.&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"hb-image\"&gt;\r\n                                &lt;img src=\"{{media url=wysiwyg/testimonial/testimonial-3.png}}\" alt=\"testimonial-image\" /&gt;\r\n                                &lt;span&gt;&lt;h4&gt;Joh Doe&lt;/h4&gt;\r\n                                    &lt;p&gt;Web Designer&lt;/p&gt;\r\n                                &lt;/span&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/li&gt;\r\n                &lt;/ul&gt;\r\n                &lt;script type=\"text/javascript\" xml=\"space\"&gt;\r\n                    require([\'jquery\', \'bizkickowlcarousel\'], function() {\r\n                        jQuery(document).ready(function() {\r\n                            jQuery(\"#hb-testimonials\").owlCarousel({\r\n                                items: 2,\r\n                                itemsDesktop: [1198, 2],\r\n                                itemsDesktopSmall: [1023, 2],\r\n                                itemsTablet: [768, 1],\r\n                                itemsTabletSmall: [767, 1],\r\n                                itemsMobile: [479, 1],\r\n                                pagination: false,\r\n                                navigationText: [\"&lt;div class=\'left-arrow\'&gt;&lt;i class=\'fa fa-angle-left\'&gt;&lt;/i&gt;&lt;/div&gt;\", \"&lt;div class=\'right-arrow\'&gt;&lt;i class=\'fa fa-angle-right\'&gt;&lt;/div&gt;\"],\r\n                                navigation: true,\r\n                            });\r\n                            jQuery(\"#hb-testimonials li\").show();\r\n                        });\r\n                    });\r\n                &lt;/script&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/div&gt;</div>','2024-03-06 11:30:00','2024-03-18 07:54:44',0),(24,'Home Brands','home-brands','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"brands-wrapper above-padding below-padding\"&gt;\r\n    &lt;div class=\"page-main\"&gt;\r\n        &lt;div class=\"brands-main\"&gt;\r\n            &lt;ul class=\"brands-slider\"&gt;\r\n                &lt;li style=\"display: none;\"&gt;&lt;a href=\"#\"&gt;&lt;img src=\"{{media url=wysiwyg/brand/brand-1.jpg}}\" alt=\"brand-image\" /&gt;&lt;/a&gt;&lt;/li&gt;\r\n                &lt;li style=\"display: none;\"&gt;&lt;a href=\"#\"&gt;&lt;img src=\"{{media url=wysiwyg/brand/brand-2.jpg}}\" alt=\"brand-image\" /&gt;&lt;/a&gt;&lt;/li&gt;\r\n                &lt;li style=\"display: none;\"&gt;&lt;a href=\"#\"&gt;&lt;img src=\"{{media url=wysiwyg/brand/brand-3.jpg}}\" alt=\"brand-image\" /&gt;&lt;/a&gt;&lt;/li&gt;\r\n                &lt;li style=\"display: none;\"&gt;&lt;a href=\"#\"&gt;&lt;img src=\"{{media url=wysiwyg/brand/brand-4.jpg}}\" alt=\"brand-image\" /&gt;&lt;/a&gt;&lt;/li&gt;\r\n                &lt;li style=\"display: none;\"&gt;&lt;a href=\"#\"&gt;&lt;img src=\"{{media url=wysiwyg/brand/brand-5.jpg}}\" alt=\"brand-image\" /&gt;&lt;/a&gt;&lt;/li&gt;\r\n                &lt;li style=\"display: none;\"&gt;&lt;a href=\"#\"&gt;&lt;img src=\"{{media url=wysiwyg/brand/brand-6.jpg}}\" alt=\"brand-image\" /&gt;&lt;/a&gt;&lt;/li&gt;\r\n            &lt;/ul&gt;\r\n            &lt;script type=\"text/javascript\" xml=\"space\"&gt;\r\n                require([\'jquery\', \'bizkickowlcarousel\'], function() {\r\n                    jQuery(document).ready(function() {\r\n                        jQuery(\".brands-slider\").owlCarousel({\r\n                            items: 6,\r\n                            itemsDesktop: [1198, 5],\r\n                            itemsDesktopSmall: [1023, 5],\r\n                            itemsTablet: [768, 4],\r\n                            itemsTabletSmall: [767, 4],\r\n                            itemsMobile: [479, 2],\r\n                            pagination: false,\r\n                            navigationText: [\"&lt;div class=\'left-arrow\'&gt;&lt;i class=\'fa fa-angle-left\'&gt;&lt;/i&gt;&lt;/div&gt;\", \"&lt;div class=\'right-arrow\'&gt;&lt;i class=\'fa fa-angle-right\'&gt;&lt;/div&gt;\"],\r\n                            navigation: false,\r\n                        });\r\n                        jQuery(\".brands-slider li\").show();\r\n                    });\r\n                });\r\n            &lt;/script&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/div&gt;</div>','2024-03-06 11:30:00','2024-03-19 05:58:38',1),(25,'Footer My Account Block','footer_myaccount','<div class=\"footer-colum-title\">\n                                    <h3>\n                                        My Account\n                                    </h3>\n                                </div>\n                                <div class=\"footer-column-content\">\n<ul class=\"footer links\">\n<li class=\"nav item\"><a href=\"#\">My Account</a></li>\n<li class=\"nav item\"><a href=\"#\">Login</a></li>\n<li class=\"nav item\"><a href=\"#\">My Cart</a></li>\n<li class=\"nav item\"><a href=\"#\">My Compare</a></li>\n<li class=\"nav item\"><a href=\"#\">My Wishlist</a></li>\n</ul>\n</div>','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(26,'Footer Payment & Shipping','footer_payment_shipping','<div class=\"footer-colum-title\">\n                            <h3>\n                                Payment & Shipping\n                            </h3>\n                        </div>\n                        <div class=\"footer-column-content\">\n<ul class=\"footer links\">\n<li class=\"nav item\"><a href=\"#\">Terms of Use</a></li>\n<li class=\"nav item\"><a href=\"#\">Payment Methods</a></li>\n<li class=\"nav item\"><a href=\"#\">Shipping Guide</a></li>\n<li class=\"nav item\"><a href=\"#\">Order Tracking</a></li>\n<li class=\"nav item\"><a href=\"#\">Return % Exchange</a></li>\n</ul>\n</div>','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(27,'Home Blogs','home_blogs','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"hb-wrapper above-padding below-padding\" style=\"background: #ffffff;\"&gt;\r\n&lt;div class=\"page-main\"&gt;\r\n&lt;div class=\"page-title-main\"&gt;&lt;strong&gt;Latest Posts&lt;/strong&gt;&lt;/div&gt;\r\n&lt;div class=\"hb-row\"&gt;\r\n&lt;div class=\"hb-blog\"&gt;\r\n&lt;ul id=\"hb-blogs\"&gt;\r\n&lt;li style=\"display:none;\"&gt;\r\n&lt;div class=\"hb-inner\"&gt;\r\n&lt;div class=\"hb-img\"&gt;&lt;img src=\"{{media url=wysiwyg/blog/bizkick-blog-1.png}}\" alt=\"blog-image\" /&gt;&lt;/div&gt;\r\n&lt;div class=\"hb-content\"&gt;\r\n&lt;h3&gt;Lorem ipsum is dolor sit amet.&lt;/h3&gt;\r\n&lt;p&gt;Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet.&lt;/p&gt;\r\n&lt;span&gt; 25 Jul 2016 &lt;/span&gt;&lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;/li&gt;\r\n&lt;li style=\"display:none;\"&gt;\r\n&lt;div class=\"hb-inner\"&gt;\r\n&lt;div class=\"hb-img\"&gt;&lt;img src=\"{{media url=wysiwyg/blog/bizkick-blog-2.png}}\" alt=\"blog-image\" /&gt;&lt;/div&gt;\r\n&lt;div class=\"hb-content\"&gt;\r\n&lt;h3&gt;Lorem ipsum is dolor sit amet.&lt;/h3&gt;\r\n&lt;p&gt;Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet.&lt;/p&gt;\r\n&lt;span&gt; 25 Jul 2016 &lt;/span&gt;&lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;/li&gt;\r\n&lt;li style=\"display:none;\"&gt;\r\n&lt;div class=\"hb-inner\"&gt;\r\n&lt;div class=\"hb-img\"&gt;&lt;img src=\"{{media url=wysiwyg/blog/bizkick-blog-3.png}}\" alt=\"blog-image\" /&gt;&lt;/div&gt;\r\n&lt;div class=\"hb-content\"&gt;\r\n&lt;h3&gt;Lorem ipsum is dolor sit amet.&lt;/h3&gt;\r\n&lt;p&gt;Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet. Lorem ipsum is dolor sit amet.&lt;/p&gt;\r\n&lt;span&gt; 25 Jul 2016 &lt;/span&gt;&lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;/li&gt;\r\n&lt;/ul&gt;\r\n&lt;script type=\"text/javascript\" xml=\"space\"&gt;\r\n                    require([\'jquery\', \'bizkickowlcarousel\'], function() {\r\n                        jQuery(document).ready(function() {\r\n                            jQuery(\"#hb-blogs\").owlCarousel({\r\n                                items: 2,\r\n                                itemsDesktop: [1198, 2],\r\n                                itemsDesktopSmall: [1023, 2],\r\n                                itemsTablet: [768, 1],\r\n                                itemsTabletSmall: [767, 1],\r\n                                itemsMobile: [479, 1],\r\n                                pagination: false,\r\n                                navigationText: [\"&lt;div class=\'left-arrow\'&gt;&lt;i class=\'fa fa-angle-left\'&gt;&lt;/i&gt;&lt;/div&gt;\", \"&lt;div class=\'right-arrow\'&gt;&lt;i class=\'fa fa-angle-right\'&gt;&lt;/div&gt;\"],\r\n                                navigation: true,\r\n                            });\r\njQuery(\"#hb-blogs li\").show();\r\n                        });\r\n                    });\r\n&lt;/script&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;\r\n&lt;/div&gt;</div>','2024-03-06 11:30:00','2024-03-18 13:12:19',0),(28,'Footer Socials Block','footer-socials','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"socials-block\"&gt;\r\n    &lt;ul class=\"social-links mb-0 ps-0\"&gt;\r\n        &lt;li&gt;&lt;a href=\"\"&gt;&lt;i class=\"fa fa-facebook-f\"&gt;&lt;/i&gt;&lt;/a&gt;&lt;/li&gt;\r\n        &lt;li&gt;&lt;a href=\"\"&gt;&lt;i class=\"fa fa-twitter\"&gt;&lt;/i&gt;&lt;/a&gt;&lt;/li&gt;\r\n        &lt;li&gt;&lt;a href=\"\"&gt;&lt;i class=\"fa fa-youtube\"&gt;&lt;/i&gt;&lt;/a&gt;&lt;/li&gt;\r\n        &lt;li&gt;&lt;a href=\"\"&gt;&lt;i class=\"fa fa-instagram\"&gt;&lt;/i&gt;&lt;/a&gt;&lt;/li&gt;\r\n    &lt;/ul&gt;         \r\n&lt;/div&gt;\r\n</div>','2024-03-06 11:30:00','2024-03-19 10:15:19',1),(29,'Home Images Block','home-images-two','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"home-parallax-block above-margin below-margin\"&gt;\r\n&lt;p&gt;ONLY THIS MONTH&lt;/p&gt;\r\n&lt;h1&gt;SAVE 60% OFF SALE&lt;/h1&gt;\r\n&lt;a class=\"action primary\" href=\"http://a2zsupplies.yirondemos.com/sale.html\" target=\"_blank\"&gt;Shop Now&lt;/a&gt;\r\n&lt;/div&gt;</div>','2024-03-06 11:30:00','2024-03-18 13:12:17',0),(30,'Home Services Block','home-services','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"home-advantage-block\"&gt;\r\n    &lt;div class=\"page-main\"&gt;\r\n        &lt;div class=\"hab-row\"&gt;\r\n            &lt;div class=\"hab-inner\"&gt;\r\n                &lt;div class=\"home-advantage-block-inner\"&gt;\r\n                    &lt;span&gt; \r\n                        &lt;em class=\"fa fa-usd\"&gt;&lt;/em&gt; \r\n                    &lt;/span&gt;\r\n                    &lt;p&gt;30-Day Money Back&lt;/p&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"hab-inner\"&gt;\r\n                &lt;div class=\"home-advantage-block-inner\"&gt;\r\n                    &lt;span&gt; \r\n                        &lt;em class=\"fa fa-headphones\"&gt;&lt;/em&gt; \r\n                    &lt;/span&gt;\r\n                    &lt;p&gt;1 year Free Support&lt;/p&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"hab-inner\"&gt;\r\n                &lt;div class=\"home-advantage-block-inner\"&gt;\r\n                    &lt;span&gt; \r\n                        &lt;em class=\"fa fa-undo\"&gt;&lt;/em&gt; \r\n                    &lt;/span&gt;\r\n                    &lt;p&gt;Free Lifetime Update&lt;/p&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"hab-inner\"&gt;\r\n                &lt;div class=\"home-advantage-block-inner\"&gt;\r\n                    &lt;span&gt; \r\n                        &lt;em class=\"fa fa-thumbs-up\"&gt;&lt;/em&gt; \r\n                    &lt;/span&gt;\r\n                    &lt;p&gt;100% Satisfaction&lt;/p&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/div&gt;</div>','2024-03-06 11:30:00','2024-03-18 13:12:13',0),(31,'Home Single Images Block','home-single-images-block','<div class=\"home-images-wrapper above-padding below-padding\">\n<div class=\"page-main\">\n<div class=\"home-image-main\">\n<div class=\"home-image-inner\"><a href=\"#\"> <img class=\"image-responsive middle-block\" src=\"{{media url=\"wysiwyg/advertisement/advt-block2.png\"}}\" alt=\"bizkick-fashion-image\" /> </a></div>\n</div>\n</div>\n</div>','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(32,'Sidebar add banner','sidebar-add-banner','<img src=\"{{media url=\"wysiwyg/advertisement/sidebar-banner.png\"}}\" alt=\"\" />','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(33,'Footer Quicklinks Block','footer_quicklinks','<div class=\"footer-colum-title\">\n<h3>Quick Links</h3>\n</div>\n<div class=\"footer-column-content\">\n<ul class=\"footer links\">\n<li class=\"nav item\"><a href=\"{{store url=\'privacy-policy-cookie-restriction-mode\'}}\"> Privacy and Cookie Policy </a></li>\n<li class=\"nav item\"><a href=\"{{store url=\'search/term/popular\'}}\"> Search Terms </a></li>\n<li class=\"nav item\"><a href=\"{{store url=\'contact\'}}\"> Contact Us </a></li>\n<li class=\"nav item\"><a href=\"{{store url=\'sales/guest/form\'}}\"> Orders and Returns </a></li>\n<li class=\"nav item\"><a href=\"{{store url=\'catalogsearch/advanced\'}}\" data-action=\"advanced-search\"> Advanced Search </a></li>\n</ul>\n</div>','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(34,'Home ContactUs Block','home-contactus-block','<div class=\"header-content-info\">\n    <span class=\"contact-text\">\n        Contact Us\n        <strong>\n            <a href=\"tel:+123456789\">+1234567890</a>\n        </strong>\n    </span>\n</div>','2024-03-06 11:30:00','2024-03-06 11:30:00',1),(35,'Footer Useful Links','footer_useful_links','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"col-12 ps-5\"&gt;\r\n &lt;h3 class=\"h5\"&gt;Useful Links&lt;/h3&gt;\r\n &lt;ul class=\"useful links\"&gt;\r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"about-us\"}}\"&gt;About us&lt;/a&gt;&lt;/li&gt;\r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"customer-service\"}}\"&gt;Customer Service&lt;/a&gt;&lt;/li&gt;\r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"\"}}\"&gt;Delivery Policy&lt;/a&gt;&lt;/li&gt;\r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"\"}}\"&gt;Faq’s&lt;/a&gt;&lt;/li&gt;\r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"\"}}\"&gt;Privacy Policy&lt;/a&gt;&lt;/li&gt;\r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"\"}}\"&gt;Return Policy&lt;/a&gt;&lt;/li&gt;\r\n &lt;/ul&gt;\r\n&lt;/div&gt;</div>','2024-03-15 09:17:13','2024-03-19 09:50:47',1),(36,'Footer Shop Links','footer_shoplinks','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"col-12 ps-5\"&gt;\r\n &lt;h3 class=\"h5\"&gt; Shop&lt;/h3&gt;\r\n  &lt;ul class=\"shop links\"&gt;  \r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"#\"}}\"&gt;Shop&lt;/a&gt;&lt;/li&gt; \r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"#\"}}\"&gt;Blog News&lt;/a&gt;&lt;/li&gt; \r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"#\"}}\"&gt;New Arrivals&lt;/a&gt;&lt;/li&gt; \r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"#\"}}\"&gt;Keywords&lt;/a&gt;&lt;/li&gt; \r\n    &lt;li class=\"nav item\"&gt;&lt;a href=\"{{store url=\"#\"}}\"&gt;Sitemap&lt;/a&gt;&lt;/li&gt; \r\n &lt;/ul&gt;\r\n&lt;/div&gt;</div>','2024-03-15 09:39:49','2024-03-19 09:51:02',1),(37,'Footer About Company','footer_about_company','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;div class=\"col-12\"&gt;\r\n&lt;div  class=\"mb-4\"&gt;\r\n    &lt;a href=\"{{store url=\"\"}}\"&gt;&lt;img src=\"{{media url=wysiwyg/home/footer_logo.png}}\" alt=\"logo\" &gt;&lt;/a&gt;\r\n&lt;/div&gt;\r\n&lt;p class=\"white\"&gt;We promise we’ll get back to you&lt;br /&gt; promptly - your gifting needs are always &lt;br /&gt;on our minds!&lt;/p&gt;\r\n\r\n&lt;/div&gt;</div><div data-content-type=\"block\" data-appearance=\"default\" data-element=\"main\">{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"28\" type_name=\"CMS Static Block\"}}</div>','2024-03-15 10:11:59','2024-03-19 10:28:31',1);

--
-- Table structure for table `cms_block_store`
--

CREATE TABLE `cms_block_store` (
  `block_id` smallint NOT NULL,
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`block_id`,`store_id`),
  KEY `CMS_BLOCK_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `CMS_BLOCK_STORE_BLOCK_ID_CMS_BLOCK_BLOCK_ID` FOREIGN KEY (`block_id`) REFERENCES `cms_block` (`block_id`) ON DELETE CASCADE,
  CONSTRAINT `CMS_BLOCK_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='CMS Block To Store Linkage Table';

--
-- Dumping data for table `cms_block_store`
--

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

--
-- Table structure for table `cms_page`
--

CREATE TABLE `cms_page` (
  `page_id` smallint NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Page Title',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Page Layout',
  `meta_keywords` text COMMENT 'Page Meta Keywords',
  `meta_description` text COMMENT 'Page Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Page String Identifier',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Page Content Heading',
  `content` mediumtext COMMENT 'Page Content',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Page Creation Time',
  `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Page Modification Time',
  `is_active` smallint NOT NULL DEFAULT '1' COMMENT 'Is Page Active',
  `sort_order` smallint NOT NULL DEFAULT '0' COMMENT 'Page Sort Order',
  `layout_update_xml` text COMMENT 'Page Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Page Custom Theme',
  `custom_root_template` varchar(255) DEFAULT NULL COMMENT 'Page Custom Template',
  `custom_layout_update_xml` text COMMENT 'Page Custom Layout Update Content',
  `layout_update_selected` varchar(128) DEFAULT NULL COMMENT 'Page Custom Layout File',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Page Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Page Custom Theme Active To Date',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Page Meta Title',
  PRIMARY KEY (`page_id`),
  KEY `CMS_PAGE_IDENTIFIER` (`identifier`),
  FULLTEXT KEY `CMS_PAGE_TITLE_META_KEYWORDS_META_DESCRIPTION_IDENTIFIER_CONTENT` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COMMENT='CMS Page Table';

--
-- Dumping data for table `cms_page`
--

INSERT INTO `cms_page` VALUES (1,'404 Not Found','2columns-right','Page keywords','Page description','no-route','Whoops, our bad...','<dl>\r\n<dt>The page you requested was not found, and we have a fine guess why.</dt>\r\n<dd>\r\n<ul class=\"disc\">\r\n<li>If you typed the URL directly, please make sure the spelling is correct.</li>\r\n<li>If you clicked on a link to get here, the link is outdated.</li>\r\n</ul></dd>\r\n</dl>\r\n<dl>\r\n<dt>What can you do?</dt>\r\n<dd>Have no fear, help is near! There are many ways you can get back on track with Magento Store.</dd>\r\n<dd>\r\n<ul class=\"disc\">\r\n<li><a href=\"#\" onclick=\"history.go(-1); return false;\">Go back</a> to the previous page.</li>\r\n<li>Use the search bar at the top of the page to search for your products.</li>\r\n<li>Follow these links to get you back on track!<br /><a href=\"{{store url=\"\"}}\">Store Home</a> <span class=\"separator\">|</span> <a href=\"{{store url=\"customer/account\"}}\">My Account</a></li></ul></dd></dl>\r\n','2024-02-29 10:14:53','2024-02-29 10:14:53',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'A2Z Supplies','1column','','','home','','<div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;section class=\"delivery-section py-4\"&gt;\r\n            &lt;div class=\"container\"&gt;\r\n                &lt;div class=\"row align-items-center\"&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6  \"&gt;\r\n                        &lt;div class=\"d-flex\"&gt;\r\n                            &lt;figure class=\"mb-0 me-3\"&gt;&lt;img src=\"./media/wysiwyg/home/truck.jpg\" alt=\"truck\"&gt;&lt;/figure&gt;\r\n                            &lt;div&gt;\r\n                                &lt;h2 class=\"h6\"&gt;Fast Delivery&lt;/h2&gt;\r\n                                &lt;p class=\"mb-0\"&gt;For All Orders Over $120&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6  \"&gt;\r\n                        &lt;div class=\"d-flex\"&gt;\r\n                            &lt;figure class=\"mb-0 me-3\"&gt;&lt;img src=\"./media/wysiwyg/home/card.jpg\" alt=\"truck\"&gt;&lt;/figure&gt;\r\n                            &lt;div&gt;\r\n                                &lt;h2 class=\"h6\"&gt;Safe Payments&lt;/h2&gt;\r\n                                &lt;p class=\"mb-0\"&gt;100% Secure Payments&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6  \"&gt;\r\n                        &lt;div class=\"d-flex\"&gt;\r\n                            &lt;figure class=\"mb-0 me-3\"&gt;&lt;img src=\"./media/wysiwyg/home/gift.jpg\" alt=\"truck\"&gt;&lt;/figure&gt;\r\n                            &lt;div&gt;\r\n                                &lt;h2 class=\"h6\"&gt;Discount Coupons&lt;/h2&gt;\r\n                                &lt;p class=\"mb-0\"&gt;Enjoy Huge Promotions&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6  \"&gt;\r\n                        &lt;div class=\"d-flex\"&gt;\r\n                            &lt;figure class=\"mb-0 me-3\"&gt;&lt;img src=\"../media/wysiwyg/home/comments.jpg\" alt=\"truck\"&gt;&lt;/figure&gt;\r\n                            &lt;div&gt;\r\n                                &lt;h2 class=\"h6\"&gt;Quality Support&lt;/h2&gt;\r\n                                &lt;p class=\"mb-0\"&gt;Dedicated 24/7 support&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n        &lt;/section&gt;\r\n&lt;style&gt;\r\n.delivery-section {\r\n    border-bottom: 1px solid var(--border);\r\n}\r\n.delivery-section .h6 {\r\n    margin: 0px;\r\n    font-weight: 600;\r\n    line-height: 140%;\r\n}\r\n.delivery-section p {\r\n    font-size: 15px;\r\n}\r\n&lt;/style&gt;</div><div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;section class=\"category-section py-4\"&gt;\r\n            &lt;div class=\"container\"&gt;\r\n                &lt;div class=\"row align-items-center\"&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6 card border-0\"&gt;\r\n                        &lt;div class=\"d-flex align-items-center justify-content-between category--inner first card-body\"&gt;\r\n                            &lt;div class=\"category-left\"&gt;\r\n                                &lt;h2 class=\"h5\"&gt;New Arrivals&lt;/h2&gt;\r\n                                &lt;p class=\"m-0\"&gt;Discover them all &lt;br /&gt; year round. &lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/new-arrivals.png\" alt=\"\"&gt;&lt;/figure&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6 card border-0\"&gt;\r\n                        &lt;div class=\"d-flex align-items-center justify-content-between category--inner second card-body\"&gt;\r\n                            &lt;div class=\"category-left\"&gt;\r\n                                &lt;h2 class=\"h5\"&gt;Special Offers&lt;/h2&gt;\r\n                                &lt;p class=\"m-0\"&gt;All our super deals &lt;br /&gt; in one place.&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/special-offers.png\" alt=\"\"&gt;&lt;/figure&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6 card border-0\"&gt;\r\n                        &lt;div class=\"d-flex align-items-center justify-content-between category--inner third card-body\"&gt;\r\n                            &lt;div class=\"category-left \"&gt;\r\n                                &lt;h2 class=\"h5\"&gt;Clearance Sales&lt;/h2&gt;\r\n                                &lt;p class=\"m-0\"&gt;End of Series. &lt;br /&gt; All must go.&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/clearance-sales.png\" alt=\"\"&gt;&lt;/figure&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"col-12 col-lg-3 col-md-6 card border-0\"&gt;\r\n                        &lt;div class=\"d-flex align-items-center justify-content-between category--inner forth card-body\"&gt;\r\n                            &lt;div class=\"category-left\"&gt;\r\n                                &lt;h2 class=\"h5\"&gt;Best Sellers&lt;/h2&gt;\r\n                                &lt;p class=\"m-0\"&gt;Spotlight on our top &lt;br /&gt; selling products.&lt;/p&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/best-sellers.png\" alt=\"\"&gt;&lt;/figure&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n        &lt;/section&gt;\r\n&lt;style&gt;\r\n.category--inner{\r\n    padding: 15px;\r\n    border-radius: 5px;\r\n}\r\n.first{\r\n    background-color: var(--blue);\r\n}\r\n.second{\r\n    background-color: var(--orange);\r\n}\r\n.third{\r\n    background-color: var(--purple);\r\n}\r\n.forth{\r\n    background-color: var(--green);\r\n}\r\n.category-section .h5 {\r\n    color: var(--white);\r\n    font-weight: 600;\r\n    margin: 0px 0px 8px;\r\n}\r\n.category-section p {\r\n    color:var(--white);\r\n    line-height: 160%;\r\n}\r\n&lt;/style&gt;</div><div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;section class=\"product-section\"&gt;\r\n            &lt;div class=\"container\"&gt;\r\n                &lt;div class=\"row\"&gt;\r\n                    &lt;div class=\"col-12 col-lg-3\"&gt;\r\n                        &lt;div class=\"product--category\"&gt;\r\n                            &lt;h2 class=\"h5 product-title\"&gt;Product Categories&lt;/h2&gt;\r\n                            &lt;div class=\"accordion Product-accordion mb-4\" id=\"accordionExample\"&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingOne\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseOne\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseOne\"&gt;\r\n                                            Office Paper\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseOne\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingOne\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Bristol Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Carbon Film&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Coloured Copy Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Continuous Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Flip Chart Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Kraft Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Other Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Register &amp; Fax Rolls&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;White Copy Paper&lt;/a&gt;&lt;/li&gt;\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingTwo\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseTwo\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseTwo\"&gt;Specialty Paper\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseTwo\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingTwo\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Certificate Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Colour Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Eco Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Embossed Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Fine Art Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Graphic Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Metallic Paper&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Packaging Paper&lt;/a&gt;&lt;/li&gt;\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingThree\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseThree\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseThree\"&gt;\r\n                                            Office Supplies\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseThree\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingThree\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Binding &amp; Laminating&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Boards &amp; Flip Charts&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Clips and Pins&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Computer Supplies&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Counting &amp; Measuring Devices&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Cut, Sharp &amp; Trim Supplies&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Desktop Accessories&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Envelopes&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Erasers &amp; Correction Fluids&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Files, Pockets &amp; Folders&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Labels, Indexes &amp; Post-it&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Notebooks &amp; Pads&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Office Accessories&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Packaging, Storage &amp; Archiving&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Pen, Pencils &amp; Markers&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Stamps &amp; Supplies&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Staplers and Hole Punches&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Tape, Glue &amp; Adhesives&lt;/a&gt;&lt;/li&gt;\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingFour\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseFour\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseFour\"&gt;\r\n                                            Office Equipment\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseFour\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingFour\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Binding Machine&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Laminating Machines&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Printers&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Projectors&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Shredders&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Trimmers&lt;/a&gt;&lt;/li&gt;\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingFive\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseFive\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseFive\"&gt;\r\n                                            Food\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseFive\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingFive\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Appliances&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Biscuits and Snacks&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Food Storage&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Others&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Spices and Condiments&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Spreads&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Utensils &amp; Kitchen Accessories&lt;/a&gt;&lt;/li&gt;\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingSix\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseSix\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseSix\"&gt;\r\n                                            Beverages\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseSix\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingSix\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Cups, Mugs &amp; Glasses&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Dairy Products&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Juices and Syrups&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Pots &amp; Strainers&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Tea, Coffee and Infusion&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Water and Soft Drinks&lt;/a&gt;&lt;/li&gt;\r\n\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingSeven\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseSeven\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseSeven\"&gt;\r\n                                            Cleaning Supplies\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseSeven\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingSeven\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Cleaning Products&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Cleaning Tools&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Holders &amp; Dispensers&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Scourers, Sponges &amp; Cloths&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Soap &amp; Hand Cleaners&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Towels, Napkins &amp; Tissues&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Trash Bins, Bags &amp; Liners&lt;/a&gt;&lt;/li&gt;\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\" id=\"headingEight\"&gt;\r\n                                        &lt;button class=\"accordion-button collapsed\" type=\"button\"\r\n                                            data-bs-toggle=\"collapse\" data-bs-target=\"#collapseEight\"\r\n                                            aria-expanded=\"false\" aria-controls=\"collapseEight\"&gt;\r\n                                            Ink &amp; Toners\r\n                                        &lt;/button&gt;\r\n                                    &lt;/h2&gt;\r\n                                    &lt;div id=\"collapseEight\" class=\"accordion-collapse collapse\"\r\n                                        aria-labelledby=\"headingEight\" data-bs-parent=\"#accordionExample\"&gt;\r\n                                        &lt;div class=\"accordion-body\"&gt;\r\n                                            &lt;ul class=\"m-0 p-0\"&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;Epson&lt;/a&gt;&lt;/li&gt;\r\n                                                &lt;li&gt;&lt;a href=\"#\"&gt;HP&lt;/a&gt;&lt;/li&gt;\r\n                                            &lt;/ul&gt;\r\n                                        &lt;/div&gt;\r\n                                    &lt;/div&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\"&gt;\r\n                                        &lt;a href=\"#\"&gt;Printing Services&lt;/a&gt;\r\n                                    &lt;/h2&gt;\r\n                                &lt;/div&gt;\r\n                                &lt;div class=\"accordion-item\"&gt;\r\n                                    &lt;h2 class=\"accordion-header\"&gt;\r\n                                        &lt;a href=\"#\"&gt;School Supplies&lt;/a&gt;\r\n                                    &lt;/h2&gt;\r\n                                &lt;/div&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"ads-image\"&gt;\r\n                                &lt;figure class=\"mb-4\"&gt;&lt;img src=\"./media/wysiwyg/home/ads-1.png\" alt=\"ads\"&gt;&lt;/figure&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"ads-image\"&gt;\r\n                                &lt;figure class=\"mb-4\"&gt;&lt;img src=\"./media/wysiwyg/home/ads-2.png\" alt=\"ads\"&gt;&lt;/figure&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"ads-image\"&gt;\r\n                                &lt;figure class=\"mb-4\"&gt;&lt;img src=\"./media/wysiwyg/home/ads-3.png\" alt=\"ads\"&gt;&lt;/figure&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                    &lt;div class=\"col-12 col-lg-9 px-0\"&gt;\r\n                        &lt;div class=\"row m-0\"&gt;\r\n                            &lt;div class=\"col-12  \"&gt;\r\n                                &lt;h2 class=\"h5 product-title\"&gt;Featured Products&lt;/h2&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                        &lt;div class=\" row mx-0 mt-4 product-item\"&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-1.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Staedtler Sketching Set 12pc - 61 100&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-2.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Samsung 1610 Toner Cartridge&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-3.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;PVC Lever Arch Index File&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-4.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Century Star 75 GSM A4 Paper 500 Sheets&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-5.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Epson Ecotank L3210 Black All-In-One Multifunction Ink Tank&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-6.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;IBS T6 4700lm White Mini Wi-Fi LED Full HD LCD Corded Portab&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-7.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;CP Plus 2.4MP White &amp; Black 6 Pcs Outdoor, 2 Pcs Indoor Came&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-8.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;HP M438NDA LaserJet Pro All-in-One Printer with Network Dupl&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-9.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Worldone Binder Clip 25 Mm –Pack of 12&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-10.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Kangaro Punch - 280&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-11\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-11.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Toilet Roll 300 Pulls&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-12\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-12.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;House Keeping Supplies&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-13.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Bectosil Alcoholic Hand Rub 5 ltr&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-14.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Kangaro HP-10 stapler&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                            &lt;div class=\"col-12 col-lg-4 col-md-4 mb-5\"&gt;\r\n                                &lt;figure&gt;&lt;img src=\"./media/wysiwyg/home/product-15.jpg\"&gt;&lt;/figure&gt;\r\n                                &lt;h6&gt;Neo Display File 40 Pocket A4 - 202&lt;/h6&gt;\r\n                            &lt;/div&gt;\r\n                        &lt;/div&gt;\r\n                    &lt;/div&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n        &lt;/section&gt;\r\n&lt;style&gt;\r\n.product-title {\r\n    background: var(--secondary);\r\n    padding: 12px 20px;\r\n    border-radius: 5px 5px 0px 0px;\r\n    color: var(--white);\r\n    font-weight: 600;\r\n    margin: 0px;\r\n    line-height: 150%;\r\n}\r\n.col-lg-9 .product-title{\r\n    border-radius: 5px;\r\n}\r\n.Product-accordion .accordion-item:first-of-type {\r\n    border-top-left-radius:0;\r\n    border-top-right-radius: 0;\r\n}\r\n.product-item figure{\r\n    background-color: var(--gray-light);\r\n}\r\n.product-item h6 {\r\n    line-height: 150%;\r\n}\r\n.Product-accordion .accordion-button {\r\n    color: var(--gray);\r\n    padding: 1rem;\r\n}\r\n.Product-accordion .accordion-button::after {\r\n    background-size: 17px auto;\r\n    display: flex;\r\n    align-items: center;\r\n    justify-content: center;\r\n}\r\n.Product-accordion h2.accordion-header a {\r\n    font-size: 1rem;\r\n    padding: 1rem;\r\n    display: inline-flex;\r\n    color: var(--gray);\r\n    font-weight: 400;\r\n}\r\n.Product-accordion ul li {\r\n    padding: 5px 0px;\r\n}\r\n.Product-accordion ul li a{\r\n    padding:  0px;\r\n    color: var(--gray);\r\n    font-size: 1rem;\r\n    line-height: 150%;\r\n\r\n}\r\n.Product-accordion ul li a:hover{\r\n    color: var(--primary);\r\n}\r\n&lt;/style&gt;</div><div data-content-type=\"html\" data-appearance=\"default\" data-element=\"main\">&lt;section class=\"buying-section\"&gt;\r\n    &lt;div class=\"container\"&gt;\r\n        &lt;div class=\"row justify-content-center mb-5\"&gt;\r\n            &lt;div class=\"col-12 col-lg-6 text-center\"&gt;\r\n                &lt;h2 class=\"h3\"&gt;Buying Guide&lt;/h2&gt;\r\n                &lt;p class=\"mb-0\"&gt;Our mission is to offer our customers outstanding service and quality products\r\n                    with a fast delivery service.&lt;/p&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n        &lt;div class=\"row\"&gt;\r\n            &lt;div class=\"col-12 col-lg-4 col-md-6 position-relative  mb-4\"&gt;\r\n                &lt;div class=\"guide--item\"&gt;\r\n                    &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/guide-1.jpg\" alt=\"guide\" width=\"447\" height=\"290\"&gt;\r\n                    &lt;/figure&gt;\r\n                    &lt;h3 class=\"h4\"&gt;Art &amp; Craft &lt;br /&gt; Supplies&lt;/h3&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"col-12 col-lg-4 col-md-6 position-relative mb-4\"&gt;\r\n                &lt;div class=\"guide--item\"&gt;\r\n                    &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/guide-2.jpg\" alt=\"guide\" width=\"447\" height=\"290\"&gt;\r\n                    &lt;/figure&gt;\r\n                    &lt;h3 class=\"h4\"&gt;House Hold &lt;br /&gt;&amp; Cleaning&lt;/h3&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"col-12 col-lg-4 col-md-6 position-relative mb-4\"&gt;\r\n                &lt;div class=\"guide--item\"&gt;\r\n                    &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/guide-3.jpg\" alt=\"guide\" width=\"447\" height=\"290\"&gt;\r\n                    &lt;/figure&gt;\r\n                    &lt;h3 class=\"h4\"&gt;IT &amp;&lt;br /&gt; Electronics&lt;/h3&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"col-12 col-lg-4 col-md-6 position-relative mb-4\"&gt;\r\n                &lt;div class=\"guide--item\"&gt;\r\n                    &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/guide-4.jpg\" alt=\"guide\" width=\"447\" height=\"290\"&gt;\r\n                    &lt;/figure&gt;\r\n                    &lt;h3 class=\"h4\"&gt;Office &lt;br /&gt;Statinary&lt;/h3&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n            &lt;div class=\"col-12 col-lg-4 col-md-6 position-relative mb-4\"&gt;\r\n                &lt;div class=\"guide--item\"&gt;\r\n                    &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/guide-5.jpg\" alt=\"guide\" width=\"447\" height=\"290\"&gt;\r\n                    &lt;/figure&gt;\r\n                    &lt;h3 class=\"h4\"&gt;Pantry &lt;br /&gt;Supplies&lt;/h3&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n\r\n            &lt;div class=\"col-12 col-lg-4 col-md-6 position-relative mb-4\"&gt;\r\n                &lt;div class=\"guide--item\"&gt;\r\n                    &lt;figure class=\"mb-0\"&gt;&lt;img src=\"./media/wysiwyg/home/guide-6.jpg\" alt=\"guide\" width=\"447\" height=\"290\"&gt;\r\n                    &lt;/figure&gt;\r\n                    &lt;h3 class=\"h4\"&gt;Safety &lt;br /&gt;Supplies&lt;/h3&gt;\r\n                &lt;/div&gt;\r\n            &lt;/div&gt;\r\n        &lt;/div&gt;\r\n    &lt;/div&gt;\r\n&lt;/section&gt;</div><div data-content-type=\"block\" data-appearance=\"default\" data-element=\"main\">{{widget type=\"Magento\\Cms\\Block\\Widget\\Block\" template=\"widget/static_block/default.phtml\" block_id=\"24\" type_name=\"CMS Static Block\"}}</div>','2024-02-29 10:14:53','2024-03-19 06:32:26',1,0,NULL,'','',NULL,NULL,NULL,NULL,''),(3,'Enable Cookies','1column',NULL,NULL,'enable-cookies','What are Cookies?','<div class=\"enable-cookies cms-content\">\r\n<p>\"Cookies\" are little pieces of data we send when you visit our store. Cookies help us get to know you better and personalize your experience. Plus they help protect you and other shoppers from fraud.</p>\r\n<p style=\"margin-bottom: 20px;\">Set your browser to accept cookies so you can buy items, save items, and receive customized recommendations. Here’s how:</p>\r\n<ul>\r\n<li><a href=\"https://support.google.com/accounts/answer/61416?hl=en\" target=\"_blank\">Google Chrome</a></li>\r\n<li><a href=\"http://windows.microsoft.com/en-us/internet-explorer/delete-manage-cookies\" target=\"_blank\">Internet Explorer</a></li>\r\n<li><a href=\"http://support.apple.com/kb/PH19214\" target=\"_blank\">Safari</a></li>\r\n<li><a href=\"https://support.mozilla.org/en-US/kb/enable-and-disable-cookies-website-preferences\" target=\"_blank\">Mozilla/Firefox</a></li>\r\n</ul>\r\n</div>','2024-02-29 10:14:53','2024-02-29 10:14:53',1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'Privacy Policy','1column','','','privacy-policy-cookie-restriction-mode','Privacy Policy','<div class=\"privacy-policy cms-content\">\n    <div class=\"privacy-policy-content\">\n        <p>This website (\"website\") is operated by Luma Inc., which includes Luma stores, and Luma Private Sales. This privacy policy only covers information collected at this website, and does not cover any information collected offline by Luma. All Luma websites are covered by this privacy policy.</p>\n\n        <h2 id=\"privacy-policy-title-1\">Luma Security</h2>\n        <p>Personal information provided on the website and online credit card transactions are transmitted through a secure server. We are committed to handling your personal information with high standards of information security. We take appropriate physical, electronic, and administrative steps to maintain the security and accuracy of personally identifiable information we collect, including limiting the number of people who have physical access to our database servers, as well as employing electronic security systems and password protections that guard against unauthorized access.</p>\n\n        <p>Our website uses encryption technology, like Secure Sockets Layer (SSL), to protect your personal information during data transport. SSL encrypts ordering information such as your name, address, and credit card number. Our Customer Care center and stores also operate over a private, secure network. Please note that email is not encrypted and is not considered to be a secure means of transmitting credit card information.</p>\n\n        <h2 id=\"privacy-policy-title-2\">Luma Privacy Policy</h2>\n        <p>To help us achieve our goal of providing the highest quality products and services, we use information from our interactions with you and other customers, as well as from other parties. Because we respect your privacy, we have implemented procedures to ensure that your personal information is handled in a safe, secure, and responsible manner. We have posted this privacy policy in order to explain our information collection practices and the choices you have about the way information is collected and used.</p>\n\n        <p>As we continue to develop the Luma website and take advantage of advances in technology to improve the services we offer, this privacy policy likely will change. We therefore encourage you to refer to this policy on an ongoing basis so that you understand our current privacy policy.</p>\n\n        <h2 id=\"privacy-policy-title-3\">The Information We Collect</h2>\n        <p>Generally, you may browse the Luma website without providing any personally identifiable information. However, we may ask you to provide personally identifiable information at various times and places on this website. In some cases, if you choose not to provide us with the requested information, you may not be able to access all parts of this website or participate in all of its features, pricing, and product selection.</p>\n\n        <p>We may collect the following information:</p>\n        <ul>\n            <li>name</li>\n            <li>contact information including email address</li>\n            <li>demographic information such as postcode, preferences and interests</li>\n            <li>other information relevant to customer surveys and/or offers</li>\n        </ul>\n        <p>For the exhaustive list of cookies we collect see the <a href=\"#privacy-policy-title-10\">List of cookies we collect</a> section. From your purchases and other interactions with us, we obtain information concerning the specific products or services you purchase or use. When you visit this website, our web server automatically collects anonymous information such as log data and IP addresses, and may collect general information concerning your location. We may use the automatically collected information for a number of purposes, such as improving our site design, product assortments, customer service, and special promotions.</p>\n        <h2 id=\"privacy-policy-title-4\">How We Use The Information We Collect</h2>\n        <p>We require this information to understand your needs and provide you with a better service, and in particular for the following reasons:</p>\n        <ul>\n            <li>Internal record keeping.</li>\n            <li>We may use the information to improve our products and services.</li>\n            <li>We may periodically send promotional emails about new products, special offers or other information which we think you may find interesting using the email address which you have provided.</li>\n            <li>From time to time, we may also use your information to contact you for market research purposes. We may contact you by email, phone, fax or mail. We may use the information to customize the website according to your interests.</li>\n        </ul>\n\n        <h2 id=\"privacy-policy-title-5\">Security</h2>\n        <p>We are committed to ensuring that your information is secure. In order to prevent unauthorized access or disclosure, we have put in place suitable physical, electronic and managerial procedures to safeguard and secure the information we collect online.</p>\n\n        <h2 id=\"privacy-policy-title-6\">Others With Whom We Share Your Information.</h2>\n        <p><b>The Luma Group:</b> All of the above information that we collect, as described  above, may be shared among all Luma entities, including Luma Venia and Luma  Terra stores, website and Private Sales.</p>\n\n        <p><b>Service Providers:</b> We also may disclose information to outside companies that  help us bring you the products and services we offer. For example, we may work  with an outside company to: (a) manage a database of customer information; (b)  assist us in distributing emails; (c) assist us with direct marketing and data  collection; (d) provide us storage and analysis; (d) provide fraud prevention; and  (e) provide other services designed to assist us in maximizing our business potential. We require that these outside companies agree to keep confidential all information we share with them and to use the information only to perform their obligations in our agreements with them.</p>\n\n        <p><b>Other Companies:</b> We may provide information to carefully selected outside companies when we believe their products or services may be of interest to you.</p>\n\n        <p><b>Business Transitions:</b> We may transfer or share a copy of personal information about you in the event that Luma or one of its properties, affiliates, or subsidiaries goes through a business transition, such as a merger, being acquired by another company, or selling a portion of its assets. You will be notified via email or prominent notice on our website prior to a change of ownership or control of your personal information, if your personal information will be used contrary to this policy. However, nothing in this Privacy Policy is intended to interfere with the ability of Luma to transfer all or part of its business and/or assets to an affiliate or independent third party at any time, for any purpose, without any limitation whatsoever.</p>\n\n        <p>Luma specifically reserves the right to transfer or share a copy of personally identifiable information collected from its websites to the buyer of that portion of its business relating to that information.</p>\n\n        <p><b>Compliance with Law:</b> We may provide access to information when legally required to do so, to cooperate with police investigations or other legal proceedings, to protect against misuse or unauthorized use of our website, to limit our legal liability, and to protect our rights or to protect the rights, property, or safety of visitors of this website or the public.</p>\n\n        <p>Luma partners with advertising companies to place our advertising on publisher websites on the Internet. These advertising companies collect anonymous information about your visits to our web site. This technology involves the use of third party cookies that allow them to develop personalized advertising so that it directly relates to offers that may be of interest to you. You may choose to opt-out of this service we have with our third-party advertising partner. We may also use Luma cookies to provide similar enhanced online marketing to you based on your interests and preferences. You may also choose to opt out of these enhanced online marketing ads.</p>\n\n        <h2 id=\"privacy-policy-title-7\">Your Choices Regarding Use Of The Information We Collect</h2>\n\n        <p>You have several choices regarding our handling of your nonpublic personally identifiable information.</p>\n\n        <p>\n            <b>Direct Mail or Telephone Marketing:</b> If you shop at the Luma or Private Sales stores and wish to be removed from the list of customers that receive direct mail or telemarketing calls, please either write to Luma Customer Care at 112 West  34th Street, 18th Flr. New York, NY 10120 or call +1 800-403-8838. If you choose to write to us, please include your name, address, and credit card account number (if you have one), and state one of the following:\n            <ul>\n                <li>\"NO MAIL OFFERS\" (if you don\'t want to receive offers by mail);</li>\n                <li>\"NO PHONE OFFERS\" (if you don\'t want to receive offers by phone);</li>\n                <li>\"NO PHONE OR MAIL OFFERS\" (if you don\'t want to receive either).</li>\n            </ul>\n        </p>\n\n        <p>Because customer lists often are prepared well in advance of an offering  (sometimes a few months before the offer is made), you may continue to receive  some offers after you send us a request not to use your information for specified  marketing purposes. We appreciate your patience and understanding in giving us  time to carry out your request.</p>\n\n        <h2 id=\"privacy-policy-title-8\">Your California Privacy Rights</h2>\n        <p>Under California Civil Code sections 1798.83-1798.84, California residents are  entitled to ask us for a notice describing what categories of personal customer  information we share with third parties or corporate affiliates for those third  parties or corporate affiliates\' direct marketing purposes. That notice will identify  the categories of information shared and will include a list of the third parties and  affiliates with which it was shared, along with their names and addresses. If you  are a California resident and would like a copy of this notice, please submit a  written request to the following address: Luma Customer Care, 112 West 34th  Street, 18th Floor, New York, NY 10120. Please allow 30 days for a response.</p>\n\n        <h2 id=\"privacy-policy-title-9\">Cookies, Web Beacons, and How We Use Them</h2>\n        <p>A cookie is a small file which asks permission to be placed on your computer\'s hard drive. Once you agree, the file is added and the cookie helps analyze web traffic or lets you know when you visit a particular site. Cookies allow web applications to respond to you as an individual. The web application can tailor its operations to your needs, likes and dislikes by gathering and remembering information about your preferences.</p>\n\n        <p>We use traffic log cookies to identify which pages are being used. This helps us analyze data about web page traffic and improve our website in order to tailor it to customer needs. We only use this information for statistical analysis purposes and then the data is removed from the system.</p>\n\n        <p>Overall, cookies help us provide you with a better website, by enabling us to monitor which pages you find useful and which you do not. A cookie in no way gives us access to your computer or any information about you, other than the data you choose to share with us. You can choose to accept or decline cookies. Most web browsers automatically accept cookies, but you can usually modify your browser setting to decline cookies if you prefer. This may prevent you from taking full advantage of the website.</p>\n\n        <p>A \"web beacon\" or \"pixel tag\" or \"clear gif\" is typically a one-pixel image, used to pass information from your computer or mobile device to a website.</p>\n\n        <p>We use cookies and web beacons to keep track of what you have in your shopping cart and to remember you when you return to the website as well as to identify the pages you click on during your visit to our site and the name of the website you visited immediately before clicking to the Luma website. We use this information to improve our site design, product assortments, customer service, and special promotions. You can, of course, disable cookies and web beacons on your computer by indicating this in the preferences or options menus in your browser. However, it is possible that some parts of our website will not operate correctly if you disable cookies. We may also use web beacons, and other technologies, to help track whether our communications are reaching you, to measure their effectiveness, or to collect certain non-personal information about your computer, device, or browser in order to allow us to better design future communications to you.</p>\n\n        <p>We may contract with third parties who may use cookies and web beacons and collect information on our behalf or provide services such as credit card processing, shipping, promotional services, or data management. We call them our Customer Care Partners. These third parties are prohibited by our contract with them from sharing that information with anyone other than us or our other Customer Care Partners.</p>\n\n        <h2 id=\"privacy-policy-title-10\">List of cookies we collect</h2>\n        <p>The table below lists the cookies we collect and the information they store.</p>\n        <table class=\"data-table\">\n            <thead>\n                <tr>\n                    <th>COOKIE name</th>\n                    <th>COOKIE Description</th>\n                </tr>\n            </thead>\n            <tbody>\n                <tr>\n                    <th>CART</th>\n                    <td>The association with your shopping cart.</td>\n                </tr>\n                <tr>\n                    <th>CATEGORY_INFO</th>\n                    <td>Allows pages to be displayed more quickly.</td>\n                </tr>\n                <tr>\n                    <th>COMPARE</th>\n                    <td>The items that you have in the Compare Products list.</td>\n                </tr>\n                <tr>\n                    <th>CUSTOMER</th>\n                    <td>An encrypted version of your customer id.</td>\n                </tr>\n                <tr>\n                    <th>CUSTOMER_AUTH</th>\n                    <td>An indicator if you are signed into the store.</td>\n                </tr>\n                <tr>\n                    <th>CUSTOMER_INFO</th>\n                    <td>An encrypted version of the customer group you belong to.</td>\n                </tr>\n                <tr>\n                    <th>CUSTOMER_SEGMENT_IDS</th>\n                    <td>Stores your Customer Segment ID</td>\n                </tr>\n                <tr>\n                    <th>EXTERNAL_NO_CACHE</th>\n                    <td>A flag that, indicates whether caching is on or off.</td>\n                </tr>\n                <tr>\n                    <th>FRONTEND</th>\n                    <td>Your session ID on the server.</td>\n                </tr>\n                <tr>\n                    <th>GUEST-VIEW</th>\n                    <td>Allows guests to edit their orders.</td>\n                </tr>\n                <tr>\n                    <th>LAST_CATEGORY</th>\n                    <td>The last category you visited.</td>\n                </tr>\n                <tr>\n                    <th>LAST_PRODUCT</th>\n                    <td>The last product you looked at.</td>\n                </tr>\n                <tr>\n                    <th>NEWMESSAGE</th>\n                    <td>Indicates whether a new message has been received.</td>\n                </tr>\n                <tr>\n                    <th>NO_CACHE</th>\n                    <td>Indicates whether it is allowed to use cache.</td>\n                </tr>\n                <tr>\n                    <th>PERSISTENT_SHOPPING_CART</th>\n                    <td>A link to information about your cart and viewing history if you have asked the site.</td>\n                </tr>\n                <tr>\n                    <th>RECENTLYCOMPARED</th>\n                    <td>The items you recently compared.</td>\n                </tr>\n                <tr>\n                    <th>STF</th>\n                    <td>Information on products you emailed to friends.</td>\n                </tr>\n                <tr>\n                    <th>STORE</th>\n                    <td>The store view or language you have selected.</td>\n                </tr>\n                <tr>\n                    <th>USER_ALLOWED_SAVE_COOKIE</th>\n                    <td>Indicates whether a customer authorized cookies.</td>\n                </tr>\n                <tr>\n                    <th>VIEWED_PRODUCT_IDS</th>\n                    <td>The products that you recently looked at.</td>\n                </tr>\n                <tr>\n                    <th>WISHLIST</th>\n                    <td>An encrypted list of products added to your wish list.</td>\n                </tr>\n                <tr>\n                    <th>WISHLIST_CNT</th>\n                    <td>The number of items in your wish list.</td>\n                </tr>\n            </tbody>\n        </table>\n\n        <h2 id=\"privacy-policy-title-11\">Online Account Registration</h2>\n        <p>To make online shopping faster and easier, you may register on the Luma website. As a registered customer, you only have to enter your shipping addresses and billing information once; they will be securely stored with us for your future use. Using your name and a password of your choice, you may access your account online at any time to add, delete, or change information. If you are using a public computer, we strongly encourage you to Sign Out when you finish shopping. Your information will still be stored with us but it will not be accessible to anyone else from that computer.</p>\n\n        <h2 id=\"privacy-policy-title-12\">Emails</h2>\n        <p>You will receive promotional emails from us only if you have asked to receive them. If you do not want to receive email from Luma or its affiliates you can click on the \"Unsubscribe\" link at the bottom of any email communication sent by us. Please allow us 3 business days from when the request was received to complete the removal, as some of our promotions may already have been in process before you submitted your request.</p>\n\n        <h2 id=\"privacy-policy-title-13\">Acceptance</h2>\n        <p>By using this website, you accept the policies set forth in this Privacy Policy.</p>\n\n        <h2 id=\"privacy-policy-title-14\">Questions for Luma?</h2>\n        <p><a href=\"{{store url=\"contact\"}}\">Contact Us</a></p>\n    </div>\n    <div class=\"block block-collapsible-nav\">\n        <div class=\"title block-collapsible-nav-title\" data-mage-init=\"{&quot;toggleAdvanced&quot;: {&quot;toggleContainers&quot;: &quot;#privacy-policy-nav-content&quot;, &quot;selectorsToggleClass&quot;: &quot;active&quot;}}\">Privacy Menu</div>\n        <div class=\"block-collapsible-content content\" id=\"privacy-policy-nav-content\">\n            <ul class=\"items\">\n                <li class=\"item current\"><a href=\"#privacy-policy-title-1\">Luma Security</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-2\">Luma Privacy Policy</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-3\">The Information We Collect</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-4\">How We Use The Information We Collect</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-5\">Security</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-6\">Others With Whom We Share Your Information.</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-7\">Your Choices Regarding Use Of The Information We Collect</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-8\">Your California Privacy Rights</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-9\">Cookies, Web Beacons, and How We Use Them</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-10\">List of cookies we collect</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-11\">Online Account Registration</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-12\">Emails</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-13\">Acceptance</a></li>\n                <li class=\"item\"><a href=\"#privacy-policy-title-14\">Questions for Luma?</a></li>\n            </ul>\n        </div>\n    </div>\n</div>\n','2024-02-29 10:14:53','2024-02-29 10:29:46',1,0,'','','',NULL,NULL,NULL,NULL,NULL),(5,'About us','1column','','','about-us','About us','<div class=\"about-info cms-content\">\n      <p class=\"cms-content-important\">With more than 230 stores spanning 43 states and growing, Luma is a nationally recognized active wear manufacturer and retailer. We’re passionate about active lifestyles – and it goes way beyond apparel.</p>\n\n      <p>At Luma, wellness is a way of life. We don’t believe age, gender or past actions define you, only your ambition and desire for wholeness... today.</p>\n\n      <p>We differentiate ourselves through a combination of unique designs and styles merged with unequaled standards of quality and authenticity. Our founders have deep roots in yoga and health communities and our selections serve amateur practitioners and professional athletes alike.</p>\n\n      <ul style=\"list-style: none; margin-top: 20px; padding: 0;\">\n          <li><a href=\"{{store url=\"contact\"}}\">Contact Luma</a></li>\n          <li><a href=\"{{store url=\"customer-service\"}}\">Customer Service</a></li>\n          <li><a href=\"{{store url=\"privacy-policy\"}}\">Luma Privacy Policy</a></li>\n          <li><a href=\"{{store url=\"\"}}\">Shop Luma</a></li>\n      </ul>\n  </div>\n','2024-02-29 10:29:46','2024-02-29 10:29:46',1,0,'','','',NULL,NULL,NULL,NULL,NULL),(6,'Customer Service','1column','','','customer-service','Customer Service','<div class=\"customer-service cms-content\">\n  <div class=\"cms-content-important\">\n      <h2>Luma Delivery and Returns</h2>\n      <p>We hope you love shopping with Luma. Here are our delivery and returns policies to help make sure we meet your expectations. <a href=\"{{store url=\"contact\"}}\">Contact Us.</a></p>\n  </div>\n\n  <h2>Shipping and Delivery</h2>\n  <p>Shipping and Delivery is the charge for internet order processing, item selection, packaging, transport and handling. We don’t guarantee delivery times, but we do our best to provide accurate estimates.</p>\n\n  <p>Deliveries occur only on weekdays. Shipping and Delivery charges are subject to change and are determined when you order. Estimated delivery time assumes orders are placed before 12:00 noon (PST). Orders you place with Luma late on Friday or on Saturday will not be processed until Monday. Charges may be added to orders with Priority, Overnight and International shipping if we try unsuccessfully to deliver your order more than once.</p>\n\n  <p>Delivery addresses in Alaska, Hawaii, Puerto Rico, and Guam should add an additional $5.00 charge for standard Shipping & Delivery. Orders arrive in 7 to 9 business days when ordered before 12:00 noon (PST).</p>\n\n  <div class=\"table-wrapper\">\n      <table>\n          <caption>Shipping and Delivery</caption>\n          <thead>\n              <tr>\n                  <th><strong>Merchandise total *</strong></th>\n                  <th><strong>STANDARD</strong><br />5&mdash;7 day shipping **</th>\n                  <th><strong>PRIORITY</strong><br />2&mdash;3 day shipping **</th>\n                  <th><strong>OVERNIGHT</strong><br />Next business day **</th>\n              </tr>\n          </thead>\n          <tbody>\n              <tr>\n                  <th>Up to $200</th>\n                  <td>$16</td>\n                  <td>$26</td>\n                  <td>$33</td>\n              </tr>\n              <tr>\n                  <th>$200.01&mdash;500.00</th>\n                  <td>$21</td>\n                  <td>$31</td>\n                  <td>$38</td>\n              </tr>\n              <tr>\n                  <th>$500.01&mdash;1000.00</th>\n                  <td>$29</td>\n                  <td>$39</td>\n                  <td>$46</td>\n              </tr>\n              <tr>\n                  <th>Over $1000.00</th>\n                  <td>$34</td>\n                  <td>$44</td>\n                  <td>$51</td>\n              </tr>\n          </tbody>\n      </table>\n  </div>\n\n  <p>\n      <small>*before tax and additional charges</small><br />\n      <small>**after processing if ordered by 12:00 noon PST</small>\n  </p>\n\n  <h2 style=\"margin-top: 40px;\">Returns and Replacements</h2>\n  <p>We want you to be completely happy with your Luma order. If for any reason you are not satisfied, we will gladly accept your timely return of unworn, unwashed, or defective merchandise. Used merchandise cannot be returned unless defective. Returned merchandise should include the vendor packaging and tags and be in the same condition as when it was received. A pickup and/or restock fee may apply. Merchandise must be returned within 30 days of receipt of merchandise.</p>\n\n  <h3>Returning Gifts</h3>\n  <p>When returning a gift, a Luma Gift Card will be issued to the gift recipient for the amount of the returned merchandise. The card can be used for purchases from any Luma store, and online. In compliance with Federal law, for gifts valued at more than $2,000.00, the recipient will receive a check rather than an Luma Gift Card.</p>\n\n  <h3>Returning Merchandise by Mail</h3>\n  <p>On the back of the packing slip enclosed with your Luma order, please note the reason(s) for return and whether you wish to  exchange the item(s) or receive a credit/refund (depending on the original form of  payment).</p>\n  <p>Enclose the return section of the packing slip with your item(s). Please use one  of the return labels provided on the front of your packing slip to ensure proper  return address and credit information. Restricted items must be returned using  ground transportation.</p>\n  <p>Please allow 10 to 14 days for Luma to process your return.</p>\n</div>\n','2024-02-29 10:29:46','2024-02-29 10:29:46',1,0,'','','',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `cms_page_store`
--

CREATE TABLE `cms_page_store` (
  `page_id` smallint NOT NULL COMMENT 'Entity ID',
  `store_id` smallint unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`page_id`,`store_id`),
  KEY `CMS_PAGE_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `CMS_PAGE_STORE_PAGE_ID_CMS_PAGE_PAGE_ID` FOREIGN KEY (`page_id`) REFERENCES `cms_page` (`page_id`) ON DELETE CASCADE,
  CONSTRAINT `CMS_PAGE_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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);

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

CREATE TABLE `core_config_data` (
  `config_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config ID',
  `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope',
  `scope_id` int 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=467 DEFAULT CHARSET=utf8mb3 COMMENT='Config Data';

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

INSERT INTO `core_config_data` VALUES (1,'default',0,'web/seo/use_rewrites','1','2024-02-29 10:14:48'),(2,'default',0,'web/unsecure/base_url','http://a2zsupplies.yirondemos.com/','2024-02-29 10:14:48'),(3,'default',0,'general/locale/code','en_US','2024-02-29 10:14:48'),(4,'default',0,'general/locale/timezone','America/Chicago','2024-02-29 10:14:48'),(5,'default',0,'currency/options/base','USD','2024-02-29 10:14:48'),(6,'default',0,'currency/options/default','USD','2024-02-29 10:14:48'),(7,'default',0,'currency/options/allow','USD','2024-02-29 10:14:48'),(8,'default',0,'general/region/display_all','1','2024-02-29 10:14:49'),(9,'default',0,'general/region/state_required','AL,AR,AU,BG,BO,BR,BY,CA,CH,CL,CN,CO,CZ,DK,EC,EE,ES,GR,GY,HR,IN,IS,IT,LT,LV,MX,PE,PL,PT,PY,RO,SE,SR,US,UY,VE','2024-02-29 10:14:52'),(10,'default',0,'catalog/category/root_id','2','2024-02-29 10:14:53'),(11,'default',0,'analytics/subscription/enabled','1','2024-02-29 10:14:54'),(12,'default',0,'crontab/default/jobs/analytics_subscribe/schedule/cron_expr','0 * * * *','2024-02-29 10:14:54'),(13,'default',0,'crontab/default/jobs/analytics_collect_data/schedule/cron_expr','00 02 * * *','2024-02-29 10:14:54'),(14,'default',0,'msp_securitysuite_recaptcha/frontend/enabled','0','2024-02-29 10:14:54'),(15,'default',0,'msp_securitysuite_recaptcha/backend/enabled','0','2024-02-29 10:14:54'),(16,'default',0,'twofactorauth/duo/application_key','0jh7OtPxYi1EphMgF9azX9G6sxK9UfAV1DCSHOiSmdbu3sBFpbb3inyp0xH46oh7','2024-02-29 10:14:55'),(17,'default',0,'admin/usage/enabled','0','2024-02-29 10:21:10'),(18,'default',0,'design/theme/theme_id','4','2024-02-29 10:28:15'),(19,'default',0,'design/head/includes','<link  rel=\"stylesheet\" type=\"text/css\"  media=\"all\" href=\"{{MEDIA_URL}}styles.css\" />','2024-02-29 10:28:15'),(20,'default',0,'carriers/tablerate/active','1','2024-02-29 10:29:32'),(21,'default',0,'carriers/tablerate/condition_name','package_value_with_discount','2024-02-29 10:29:32'),(22,'default',0,'sales/msrp/enabled','1','2024-02-29 10:29:36'),(23,'default',0,'free/module/email','palak.bansal@yirontechnologies.com','2024-03-04 09:33:17'),(24,'default',0,'free/module/name','Palak','2024-03-04 09:33:17'),(25,'default',0,'free/module/create','1','2024-03-04 09:33:17'),(26,'default',0,'free/module/subscribe','1','2024-03-04 09:33:17'),(27,'default',0,'smtp/module/active','1','2024-03-04 09:33:17'),(28,'default',0,'smtp/module/product_key','SMTP-1R6YXT2JQRFV7JPVWQ1J','2024-03-05 10:44:43'),(29,'default',0,'smtp/module/email','palak.bansal@yirontechnologies.com','2024-03-04 09:33:17'),(30,'default',0,'smtp/module/name','Palak','2024-03-04 09:33:17'),(31,'default',0,'smtp/module/create','1','2024-03-04 09:33:17'),(32,'default',0,'smtp/module/subscribe','1','2024-03-04 09:33:17'),(33,'default',0,'smtp/general/enabled','0','2024-03-06 12:09:20'),(34,'default',0,'smtp/general/log_email','1','2024-03-04 10:29:10'),(35,'default',0,'smtp/general/clean_email','10','2024-03-04 10:29:10'),(36,'default',0,'smtp/general/blacklist',NULL,'2024-03-04 10:29:10'),(37,'default',0,'smtp/configuration_option/host','mail.yirondemos.com','2024-03-05 08:06:56'),(38,'default',0,'smtp/configuration_option/port','465','2024-03-06 12:04:55'),(39,'default',0,'smtp/configuration_option/protocol','ssl','2024-03-06 12:04:55'),(40,'default',0,'smtp/configuration_option/authentication','plain','2024-03-06 12:08:40'),(41,'default',0,'smtp/configuration_option/username','a2z@yirondemos.com','2024-03-04 10:29:10'),(42,'default',0,'smtp/configuration_option/password','0:3:4aawGqeSXmMgNKvUNf8u+UA05L6r5iQ0gMI3di34pxmymoBjELe/3A==','2024-03-06 12:04:55'),(43,'default',0,'smtp/configuration_option/return_path_email',NULL,'2024-03-04 10:29:10'),(44,'default',0,'smtp/configuration_option/test_email/from','general','2024-03-05 08:17:09'),(45,'default',0,'smtp/configuration_option/test_email/to','harvinder.singh@yirontechnologies.com','2024-03-06 11:53:09'),(46,'default',0,'smtp/developer/developer_mode','0','2024-03-05 07:09:48'),(47,'default',0,'system/full_page_cache/varnish/access_list','localhost','2024-03-04 12:55:43'),(48,'default',0,'system/full_page_cache/varnish/backend_host','localhost','2024-03-04 12:55:43'),(49,'default',0,'system/full_page_cache/varnish/backend_port','8080','2024-03-04 12:55:43'),(50,'default',0,'system/full_page_cache/varnish/grace_period','300','2024-03-04 12:55:43'),(51,'default',0,'system/mysqlmq/successful_messages_lifetime','10080','2024-03-04 12:57:15'),(52,'default',0,'system/mysqlmq/retry_inprogress_after','1440','2024-03-04 12:57:15'),(53,'default',0,'system/mysqlmq/failed_messages_lifetime','10080','2024-03-04 12:57:15'),(54,'default',0,'system/mysqlmq/new_messages_lifetime','10080','2024-03-04 12:57:15'),(59,'default',0,'system/smtp/username',NULL,'2024-03-04 13:07:04'),(60,'default',0,'system/smtp/password',NULL,'2024-03-04 13:07:04'),(61,'default',0,'system/backup/functionality_enabled','0','2024-03-04 12:57:15'),(62,'default',0,'system/bulk/lifetime','60','2024-03-04 12:57:15'),(63,'default',0,'system/media_storage_configuration/media_storage','0','2024-03-04 12:57:15'),(64,'default',0,'system/media_gallery/enabled','1','2024-03-04 12:57:15'),(65,'default',0,'system/media_gallery_renditions/enabled','1','2024-03-04 12:57:15'),(66,'default',0,'system/media_gallery_renditions/width','1000','2024-03-04 12:57:15'),(67,'default',0,'system/media_gallery_renditions/height','1000','2024-03-04 12:57:15'),(68,'default',0,'adobe_stock/integration/enabled','1','2024-03-04 12:57:15'),(69,'default',0,'adobe_ims/integration/admin_enabled','0','2024-03-04 12:57:15'),(70,'default',0,'adobe_ims/integration/api_key',NULL,'2024-03-04 12:57:15'),(71,'default',0,'adobe_ims/integration/private_key',NULL,'2024-03-04 12:57:15'),(72,'default',0,'trans_email/ident_general/name','Owner','2024-03-04 13:02:42'),(73,'default',0,'trans_email/ident_general/email','a2z@yirondemos.com','2024-03-04 13:02:42'),(74,'default',0,'admin/security/admin_account_sharing','1','2024-03-04 13:46:11'),(75,'default',0,'trans_email/ident_sales/email','a2z@yirondemos.com','2024-03-05 04:43:30'),(76,'default',0,'trans_email/ident_support/email','a2z@yirondemos.com','2024-03-05 04:43:30'),(77,'default',0,'trans_email/ident_custom1/email','a2z@yirondemos.com','2024-03-05 04:43:30'),(78,'default',0,'trans_email/ident_custom2/email','a2z@yirondemos.com','2024-03-05 04:43:30'),(79,'default',0,'paypal/general/merchant_country',NULL,'2024-03-05 04:43:56'),(80,'default',0,'payment/paypal_express/active','0','2024-03-05 04:43:56'),(81,'default',0,'payment/paypal_express/in_context','0','2024-03-05 04:43:56'),(82,'default',0,'payment/paypal_paylater/experience_active','0','2024-03-05 04:43:56'),(83,'default',0,'paypal/general/business_account',NULL,'2024-03-05 04:43:56'),(84,'default',0,'paypal/wpp/api_authentication','0','2024-03-05 04:43:56'),(85,'default',0,'paypal/wpp/api_username',NULL,'2024-03-05 04:43:56'),(86,'default',0,'paypal/wpp/api_password',NULL,'2024-03-05 04:43:56'),(87,'default',0,'paypal/wpp/api_signature',NULL,'2024-03-05 04:43:56'),(88,'default',0,'paypal/wpp/sandbox_flag','0','2024-03-05 04:43:56'),(89,'default',0,'paypal/wpp/use_proxy','0','2024-03-05 04:43:56'),(90,'default',0,'payment/paypal_express_bml/publisher_id',NULL,'2024-03-05 04:43:56'),(91,'default',0,'payment/paypal_express_bml/homepage_display','0','2024-03-05 04:43:56'),(92,'default',0,'payment/paypal_express_bml/homepage_position','0','2024-03-05 04:43:56'),(93,'default',0,'payment/paypal_express_bml/homepage_size','190x100','2024-03-05 04:43:56'),(94,'default',0,'payment/paypal_express_bml/categorypage_display','0','2024-03-05 04:43:56'),(95,'default',0,'payment/paypal_express_bml/categorypage_position','0','2024-03-05 04:43:56'),(96,'default',0,'payment/paypal_express_bml/categorypage_size','190x100','2024-03-05 04:43:56'),(97,'default',0,'payment/paypal_express_bml/productpage_display','0','2024-03-05 04:43:56'),(98,'default',0,'payment/paypal_express_bml/productpage_position','0','2024-03-05 04:43:56'),(99,'default',0,'payment/paypal_express_bml/productpage_size','190x100','2024-03-05 04:43:56'),(100,'default',0,'payment/paypal_express_bml/checkout_display','0','2024-03-05 04:43:56'),(101,'default',0,'payment/paypal_express_bml/checkout_position','0','2024-03-05 04:43:56'),(102,'default',0,'payment/paypal_express_bml/checkout_size','234x60','2024-03-05 04:43:56'),(103,'default',0,'payment/paypal_express/title','PayPal Express Checkout','2024-03-05 04:43:56'),(104,'default',0,'payment/paypal_express/sort_order',NULL,'2024-03-05 04:43:56'),(105,'default',0,'payment/paypal_express/payment_action','Authorization','2024-03-05 04:43:56'),(106,'default',0,'payment/paypal_express/visible_on_product','1','2024-03-05 04:43:56'),(107,'default',0,'payment/paypal_express/visible_on_cart','1','2024-03-05 04:43:56'),(108,'default',0,'payment/paypal_express/allowspecific','0','2024-03-05 04:43:56'),(109,'default',0,'payment/paypal_express/debug','0','2024-03-05 04:43:56'),(110,'default',0,'payment/paypal_express/verify_peer','1','2024-03-05 04:43:56'),(111,'default',0,'payment/paypal_express/line_items_enabled','1','2024-03-05 04:43:56'),(112,'default',0,'payment/paypal_express/transfer_shipping_options','0','2024-03-05 04:43:56'),(113,'default',0,'paypal/wpp/button_flavor','dynamic','2024-03-05 04:43:56'),(114,'default',0,'payment/paypal_express/solution_type','Mark','2024-03-05 04:43:56'),(115,'default',0,'payment/paypal_express/require_billing_address','0','2024-03-05 04:43:56'),(116,'default',0,'payment/paypal_express/allow_ba_signup','never','2024-03-05 04:43:56'),(117,'default',0,'payment/paypal_express/skip_order_review_step','1','2024-03-05 04:43:56'),(118,'default',0,'payment/paypal_billing_agreement/active','1','2024-03-05 04:43:56'),(119,'default',0,'payment/paypal_billing_agreement/title','PayPal Billing Agreement','2024-03-05 04:43:56'),(120,'default',0,'payment/paypal_billing_agreement/sort_order',NULL,'2024-03-05 04:43:56'),(121,'default',0,'payment/paypal_billing_agreement/payment_action','Authorization','2024-03-05 04:43:56'),(122,'default',0,'payment/paypal_billing_agreement/allowspecific','0','2024-03-05 04:43:56'),(123,'default',0,'payment/paypal_billing_agreement/debug','0','2024-03-05 04:43:56'),(124,'default',0,'payment/paypal_billing_agreement/verify_peer','1','2024-03-05 04:43:56'),(125,'default',0,'payment/paypal_billing_agreement/line_items_enabled','0','2024-03-05 04:43:56'),(126,'default',0,'payment/paypal_billing_agreement/allow_billing_agreement_wizard','1','2024-03-05 04:43:56'),(127,'default',0,'paypal/fetch_reports/ftp_login',NULL,'2024-03-05 04:43:56'),(128,'default',0,'paypal/fetch_reports/ftp_password',NULL,'2024-03-05 04:43:56'),(129,'default',0,'paypal/fetch_reports/ftp_sandbox','0','2024-03-05 04:43:56'),(130,'default',0,'paypal/fetch_reports/ftp_ip',NULL,'2024-03-05 04:43:56'),(131,'default',0,'paypal/fetch_reports/ftp_path',NULL,'2024-03-05 04:43:56'),(132,'default',0,'paypal/fetch_reports/active','0','2024-03-05 04:43:56'),(133,'default',0,'paypal/fetch_reports/schedule','1','2024-03-05 04:43:56'),(134,'default',0,'paypal/fetch_reports/time','00,00,00','2024-03-05 04:43:56'),(135,'default',0,'paypal/style/logo',NULL,'2024-03-05 04:43:56'),(136,'default',0,'paypal/style/page_style',NULL,'2024-03-05 04:43:56'),(137,'default',0,'paypal/style/paypal_hdrimg',NULL,'2024-03-05 04:43:56'),(138,'default',0,'paypal/style/paypal_hdrbackcolor',NULL,'2024-03-05 04:43:56'),(139,'default',0,'paypal/style/paypal_hdrbordercolor',NULL,'2024-03-05 04:43:56'),(140,'default',0,'paypal/style/paypal_payflowcolor',NULL,'2024-03-05 04:43:56'),(141,'default',0,'paypal/style/checkout_page_button_customize','0','2024-03-05 04:43:56'),(142,'default',0,'paypal/style/product_page_button_customize','0','2024-03-05 04:43:56'),(143,'default',0,'paypal/style/cart_page_button_customize','0','2024-03-05 04:43:56'),(144,'default',0,'paypal/style/mini_cart_page_button_customize','0','2024-03-05 04:43:56'),(145,'default',0,'paypal/style/disable_funding_options',NULL,'2024-03-05 04:43:56'),(146,'default',0,'payment/braintree/active','0','2024-03-05 04:43:56'),(147,'default',0,'payment/braintree_cc_vault/active','0','2024-03-05 04:43:56'),(148,'default',0,'payment/braintree/title','Credit Card','2024-03-05 04:43:56'),(149,'default',0,'payment/braintree/environment','sandbox','2024-03-05 04:43:56'),(150,'default',0,'payment/braintree/payment_action','authorize','2024-03-05 04:43:56'),(151,'default',0,'payment/braintree/sandbox_merchant_id',NULL,'2024-03-05 04:43:56'),(152,'default',0,'payment/braintree/sandbox_public_key',NULL,'2024-03-05 04:43:56'),(153,'default',0,'payment/braintree/sandbox_private_key',NULL,'2024-03-05 04:43:56'),(154,'default',0,'payment/braintree_cc_vault/title','Stored Cards','2024-03-05 04:43:56'),(155,'default',0,'payment/braintree/merchant_account_id',NULL,'2024-03-05 04:43:56'),(156,'default',0,'payment/braintree/skip_admin','0','2024-03-05 04:43:56'),(157,'default',0,'payment/braintree/fraudprotection_threshold',NULL,'2024-03-05 04:43:56'),(158,'default',0,'payment/braintree/debug','0','2024-03-05 04:43:56'),(159,'default',0,'payment/braintree/useccv','1','2024-03-05 04:43:56'),(160,'default',0,'payment/braintree/send_line_items','1','2024-03-05 04:43:56'),(161,'default',0,'payment/braintree/cctypes','AE,VI,MC,DI,JCB,DN,MI','2024-03-05 04:43:56'),(162,'default',0,'payment/braintree/sort_order',NULL,'2024-03-05 04:43:56'),(163,'default',0,'payment/braintree_webhook/enabled','0','2024-03-05 04:43:56'),(164,'default',0,'payment/braintree_webhook/approve_order_status','processing','2024-03-05 04:43:56'),(165,'default',0,'payment/braintree_webhook/reject_order_status','canceled','2024-03-05 04:43:56'),(166,'default',0,'payment/braintree/allowspecific','0','2024-03-05 04:43:56'),(167,'default',0,'payment/braintree/specificcountry',NULL,'2024-03-05 04:43:56'),(168,'default',0,'payment/braintree/countrycreditcard','[]','2024-03-05 04:43:56'),(169,'default',0,'payment/braintree_ach_direct_debit/active','0','2024-03-05 04:43:56'),(170,'default',0,'payment/braintree_ach_direct_debit/sort_order',NULL,'2024-03-05 04:43:56'),(171,'default',0,'payment/braintree_applepay/active','0','2024-03-05 04:43:56'),(172,'default',0,'payment/braintree_applepay/payment_action','authorize','2024-03-05 04:43:56'),(173,'default',0,'payment/braintree_applepay/merchant_name','Store','2024-03-05 04:43:56'),(174,'default',0,'payment/braintree_applepay/sort_order',NULL,'2024-03-05 04:43:56'),(175,'default',0,'payment/braintree_local_payment/active','0','2024-03-05 04:43:56'),(176,'default',0,'payment/braintree_local_payment/sort_order',NULL,'2024-03-05 04:43:56'),(177,'default',0,'payment/braintree_googlepay/active','0','2024-03-05 04:43:56'),(178,'default',0,'payment/braintree_googlepay/payment_action','authorize','2024-03-05 04:43:56'),(179,'default',0,'payment/braintree_googlepay/btn_color','0','2024-03-05 04:43:56'),(180,'default',0,'payment/braintree_googlepay/merchant_id','testmode','2024-03-05 04:43:56'),(181,'default',0,'payment/braintree_googlepay/cctypes','VISA,MASTERCARD,AMEX','2024-03-05 04:43:56'),(182,'default',0,'payment/braintree_googlepay/sort_order',NULL,'2024-03-05 04:43:56'),(183,'default',0,'payment/braintree_venmo/active','0','2024-03-05 04:43:56'),(184,'default',0,'payment/braintree_venmo/sort_order',NULL,'2024-03-05 04:43:56'),(185,'default',0,'payment/braintree_paypal/active','0','2024-03-05 04:43:56'),(186,'default',0,'payment/braintree_paypal_credit/active','0','2024-03-05 04:43:56'),(187,'default',0,'payment/braintree_paypal_paylater/active','0','2024-03-05 04:43:56'),(188,'default',0,'payment/braintree_paypal/title','PayPal','2024-03-05 04:43:56'),(189,'default',0,'payment/braintree_paypal_vault/active','0','2024-03-05 04:43:56'),(190,'default',0,'payment/braintree_paypal/sort_order','2','2024-03-05 04:43:56'),(191,'default',0,'payment/braintree_paypal/merchant_name_override',NULL,'2024-03-05 04:43:56'),(192,'default',0,'payment/braintree_paypal/payment_action','authorize','2024-03-05 04:43:56'),(193,'default',0,'payment/braintree_paypal/allowspecific','0','2024-03-05 04:43:56'),(194,'default',0,'payment/braintree_paypal/specificcountry',NULL,'2024-03-05 04:43:56'),(195,'default',0,'payment/braintree_paypal/require_billing_address','0','2024-03-05 04:43:56'),(196,'default',0,'payment/braintree_paypal/debug','0','2024-03-05 04:43:56'),(197,'default',0,'payment/braintree_paypal/display_on_shopping_cart','1','2024-03-05 04:43:56'),(198,'default',0,'payment/braintree_paypal/payment_location','cart','2024-03-05 04:43:56'),(199,'default',0,'payment/braintree_paypal/paypal_button_type','paypal','2024-03-05 04:43:56'),(200,'default',0,'payment/braintree_paypal/button_location_cart_type_paypal_show','1','2024-03-05 04:43:56'),(201,'default',0,'payment/braintree_paypal/button_location_cart_type_paypal_label','paypal','2024-03-05 04:43:56'),(202,'default',0,'payment/braintree_paypal/button_location_cart_type_paypal_color','gold','2024-03-05 04:43:56'),(203,'default',0,'payment/braintree_paypal/button_location_cart_type_paypal_shape','rect','2024-03-05 04:43:56'),(204,'default',0,'payment/braintree_paypal/button_location_cart_type_paypal_size','responsive','2024-03-05 04:43:56'),(205,'default',0,'payment/braintree_paypal/button_location_cart_type_paylater_show','1','2024-03-05 04:43:56'),(206,'default',0,'payment/braintree_paypal/button_location_cart_type_paylater_label','paypal','2024-03-05 04:43:56'),(207,'default',0,'payment/braintree_paypal/button_location_cart_type_paylater_color','gold','2024-03-05 04:43:56'),(208,'default',0,'payment/braintree_paypal/button_location_cart_type_paylater_shape','rect','2024-03-05 04:43:56'),(209,'default',0,'payment/braintree_paypal/button_location_cart_type_paylater_size','responsive','2024-03-05 04:43:56'),(210,'default',0,'payment/braintree_paypal/button_location_cart_type_credit_show','1','2024-03-05 04:43:56'),(211,'default',0,'payment/braintree_paypal/button_location_cart_type_credit_label','paypal','2024-03-05 04:43:56'),(212,'default',0,'payment/braintree_paypal/button_location_cart_type_credit_color','gold','2024-03-05 04:43:56'),(213,'default',0,'payment/braintree_paypal/button_location_cart_type_credit_shape','rect','2024-03-05 04:43:56'),(214,'default',0,'payment/braintree_paypal/button_location_cart_type_credit_size','responsive','2024-03-05 04:43:56'),(215,'default',0,'payment/braintree_paypal/button_location_cart_type_messaging_show','1','2024-03-05 04:43:56'),(216,'default',0,'payment/braintree_paypal/button_location_cart_type_messaging_layout','text','2024-03-05 04:43:56'),(217,'default',0,'payment/braintree_paypal/button_location_cart_type_messaging_logo','inline','2024-03-05 04:43:56'),(218,'default',0,'payment/braintree_paypal/button_location_cart_type_messaging_logo_position','left','2024-03-05 04:43:56'),(219,'default',0,'payment/braintree_paypal/button_location_cart_type_messaging_text_color','black','2024-03-05 04:43:56'),(220,'default',0,'payment/braintree_paypal/button_location_checkout_type_paypal_show','1','2024-03-05 04:43:56'),(221,'default',0,'payment/braintree_paypal/button_location_checkout_type_paypal_label','paypal','2024-03-05 04:43:56'),(222,'default',0,'payment/braintree_paypal/button_location_checkout_type_paypal_color','gold','2024-03-05 04:43:56'),(223,'default',0,'payment/braintree_paypal/button_location_checkout_type_paypal_shape','rect','2024-03-05 04:43:56'),(224,'default',0,'payment/braintree_paypal/button_location_checkout_type_paypal_size','responsive','2024-03-05 04:43:56'),(225,'default',0,'payment/braintree_paypal/button_location_checkout_type_paylater_show','1','2024-03-05 04:43:56'),(226,'default',0,'payment/braintree_paypal/button_location_checkout_type_paylater_label','paypal','2024-03-05 04:43:56'),(227,'default',0,'payment/braintree_paypal/button_location_checkout_type_paylater_color','gold','2024-03-05 04:43:56'),(228,'default',0,'payment/braintree_paypal/button_location_checkout_type_paylater_shape','rect','2024-03-05 04:43:56'),(229,'default',0,'payment/braintree_paypal/button_location_checkout_type_paylater_size','responsive','2024-03-05 04:43:56'),(230,'default',0,'payment/braintree_paypal/button_location_checkout_type_credit_show','1','2024-03-05 04:43:56'),(231,'default',0,'payment/braintree_paypal/button_location_checkout_type_credit_label','paypal','2024-03-05 04:43:56'),(232,'default',0,'payment/braintree_paypal/button_location_checkout_type_credit_color','gold','2024-03-05 04:43:56'),(233,'default',0,'payment/braintree_paypal/button_location_checkout_type_credit_shape','rect','2024-03-05 04:43:56'),(234,'default',0,'payment/braintree_paypal/button_location_checkout_type_credit_size','responsive','2024-03-05 04:43:56'),(235,'default',0,'payment/braintree_paypal/button_location_checkout_type_messaging_show','1','2024-03-05 04:43:56'),(236,'default',0,'payment/braintree_paypal/button_location_checkout_type_messaging_layout','text','2024-03-05 04:43:56'),(237,'default',0,'payment/braintree_paypal/button_location_checkout_type_messaging_logo','inline','2024-03-05 04:43:56'),(238,'default',0,'payment/braintree_paypal/button_location_checkout_type_messaging_logo_position','left','2024-03-05 04:43:56'),(239,'default',0,'payment/braintree_paypal/button_location_checkout_type_messaging_text_color','black','2024-03-05 04:43:56'),(240,'default',0,'payment/braintree_paypal/button_location_productpage_type_paypal_show','1','2024-03-05 04:43:56'),(241,'default',0,'payment/braintree_paypal/button_location_productpage_type_paypal_label','paypal','2024-03-05 04:43:56'),(242,'default',0,'payment/braintree_paypal/button_location_productpage_type_paypal_color','gold','2024-03-05 04:43:56'),(243,'default',0,'payment/braintree_paypal/button_location_productpage_type_paypal_shape','rect','2024-03-05 04:43:56'),(244,'default',0,'payment/braintree_paypal/button_location_productpage_type_paypal_size','responsive','2024-03-05 04:43:56'),(245,'default',0,'payment/braintree_paypal/button_location_productpage_type_paylater_show','1','2024-03-05 04:43:56'),(246,'default',0,'payment/braintree_paypal/button_location_productpage_type_paylater_label','paypal','2024-03-05 04:43:56'),(247,'default',0,'payment/braintree_paypal/button_location_productpage_type_paylater_color','gold','2024-03-05 04:43:56'),(248,'default',0,'payment/braintree_paypal/button_location_productpage_type_paylater_shape','rect','2024-03-05 04:43:56'),(249,'default',0,'payment/braintree_paypal/button_location_productpage_type_paylater_size','responsive','2024-03-05 04:43:56'),(250,'default',0,'payment/braintree_paypal/button_location_productpage_type_credit_show','1','2024-03-05 04:43:56'),(251,'default',0,'payment/braintree_paypal/button_location_productpage_type_credit_label','paypal','2024-03-05 04:43:56'),(252,'default',0,'payment/braintree_paypal/button_location_productpage_type_credit_color','gold','2024-03-05 04:43:56'),(253,'default',0,'payment/braintree_paypal/button_location_productpage_type_credit_shape','rect','2024-03-05 04:43:56'),(254,'default',0,'payment/braintree_paypal/button_location_productpage_type_credit_size','responsive','2024-03-05 04:43:56'),(255,'default',0,'payment/braintree_paypal/button_location_productpage_type_messaging_show','1','2024-03-05 04:43:56'),(256,'default',0,'payment/braintree_paypal/button_location_productpage_type_messaging_layout','text','2024-03-05 04:43:56'),(257,'default',0,'payment/braintree_paypal/button_location_productpage_type_messaging_logo','inline','2024-03-05 04:43:56'),(258,'default',0,'payment/braintree_paypal/button_location_productpage_type_messaging_logo_position','left','2024-03-05 04:43:56'),(259,'default',0,'payment/braintree_paypal/button_location_productpage_type_messaging_text_color','black','2024-03-05 04:43:56'),(260,'default',0,'payment/braintree/verify_3dsecure','0','2024-03-05 04:43:56'),(261,'default',0,'payment/braintree/threshold_amount',NULL,'2024-03-05 04:43:56'),(262,'default',0,'payment/braintree/verify_all_countries','0','2024-03-05 04:43:56'),(263,'default',0,'payment/braintree/verify_specific_countries',NULL,'2024-03-05 04:43:56'),(264,'default',0,'payment/braintree/descriptor_name',NULL,'2024-03-05 04:43:56'),(265,'default',0,'payment/braintree/descriptor_phone',NULL,'2024-03-05 04:43:56'),(266,'default',0,'payment/braintree/descriptor_url',NULL,'2024-03-05 04:43:56'),(267,'default',0,'payment/payflow_express/active','0','2024-03-05 04:43:56'),(268,'default',0,'payment/payflow_advanced/active','0','2024-03-05 04:43:56'),(269,'default',0,'payment/payflow_express_bml/active','0','2024-03-05 04:43:56'),(270,'default',0,'payment/payflow_advanced/partner','PayPal','2024-03-05 04:43:56'),(271,'default',0,'payment/payflow_advanced/vendor','PayPal','2024-03-05 04:43:56'),(272,'default',0,'payment/payflow_advanced/user',NULL,'2024-03-05 04:43:56'),(273,'default',0,'payment/payflow_advanced/pwd',NULL,'2024-03-05 04:43:56'),(274,'default',0,'payment/payflow_advanced/sandbox_flag','0','2024-03-05 04:43:56'),(275,'default',0,'payment/payflow_advanced/use_proxy','0','2024-03-05 04:43:56'),(276,'default',0,'payment/payflow_advanced/title','Credit Card (Payflow Advanced)','2024-03-05 04:43:56'),(277,'default',0,'payment/payflow_advanced/sort_order',NULL,'2024-03-05 04:43:56'),(278,'default',0,'payment/payflow_advanced/payment_action','Authorization','2024-03-05 04:43:56'),(279,'default',0,'payment/payflow_advanced/allowspecific','0','2024-03-05 04:43:56'),(280,'default',0,'payment/payflow_advanced/debug','0','2024-03-05 04:43:56'),(281,'default',0,'payment/payflow_advanced/verify_peer','1','2024-03-05 04:43:56'),(282,'default',0,'payment/payflow_advanced/csc_editable','1','2024-03-05 04:43:56'),(283,'default',0,'payment/payflow_advanced/csc_required','1','2024-03-05 04:43:56'),(284,'default',0,'payment/payflow_advanced/email_confirmation','0','2024-03-05 04:43:56'),(285,'default',0,'payment/payflow_advanced/url_method','GET','2024-03-05 04:43:56'),(286,'default',0,'payment/payflow_express/title','PayPal Express Checkout Payflow Edition','2024-03-05 04:43:56'),(287,'default',0,'payment/payflow_express/sort_order',NULL,'2024-03-05 04:43:56'),(288,'default',0,'payment/payflow_express/payment_action','Authorization','2024-03-05 04:43:56'),(289,'default',0,'payment/payflow_express/visible_on_product','1','2024-03-05 04:43:56'),(290,'default',0,'payment/payflow_express/visible_on_cart','1','2024-03-05 04:43:56'),(291,'default',0,'payment/payflow_express/allowspecific','0','2024-03-05 04:43:56'),(292,'default',0,'payment/payflow_express/debug','0','2024-03-05 04:43:56'),(293,'default',0,'payment/payflow_express/verify_peer','1','2024-03-05 04:43:56'),(294,'default',0,'payment/payflow_express/line_items_enabled','1','2024-03-05 04:43:56'),(295,'default',0,'payment/paypal_payment_pro/active','0','2024-03-05 04:43:56'),(296,'default',0,'payment/payflowpro_cc_vault/active','0','2024-03-05 04:43:56'),(297,'default',0,'payment/payflowpro/partner',NULL,'2024-03-05 04:43:56'),(298,'default',0,'payment/payflowpro/user',NULL,'2024-03-05 04:43:56'),(299,'default',0,'payment/payflowpro/vendor',NULL,'2024-03-05 04:43:56'),(300,'default',0,'payment/payflowpro/pwd',NULL,'2024-03-05 04:43:56'),(301,'default',0,'payment/payflowpro/sandbox_flag','0','2024-03-05 04:43:56'),(302,'default',0,'payment/payflowpro/use_proxy','0','2024-03-05 04:43:56'),(303,'default',0,'payment/payflowpro/title','Credit Card (Payflow Pro)','2024-03-05 04:43:56'),(304,'default',0,'payment/payflowpro_cc_vault/title','Stored Cards (Payflow Pro)','2024-03-05 04:43:56'),(305,'default',0,'payment/payflowpro/sort_order',NULL,'2024-03-05 04:43:56'),(306,'default',0,'payment/payflowpro/payment_action','Authorization','2024-03-05 04:43:56'),(307,'default',0,'payment/payflowpro/cctypes','AE,VI','2024-03-05 04:43:56'),(308,'default',0,'payment/payflowpro/allowspecific','0','2024-03-05 04:43:56'),(309,'default',0,'payment/payflowpro/debug','0','2024-03-05 04:43:56'),(310,'default',0,'payment/payflowpro/verify_peer','1','2024-03-05 04:43:56'),(311,'default',0,'payment/payflowpro/useccv','1','2024-03-05 04:43:56'),(312,'default',0,'payment/payflowpro/fmf','0','2024-03-05 04:43:56'),(313,'default',0,'payment/payflowpro/avs_street','0','2024-03-05 04:43:56'),(314,'default',0,'payment/payflowpro/avs_zip','0','2024-03-05 04:43:56'),(315,'default',0,'payment/payflowpro/avs_international','0','2024-03-05 04:43:56'),(316,'default',0,'payment/payflowpro/avs_security_code','1','2024-03-05 04:43:56'),(317,'default',0,'payment/wps_express/active','0','2024-03-05 04:43:56'),(318,'default',0,'payment/wps_express_bml/active','0','2024-03-05 04:43:56'),(319,'default',0,'payment/payflowpro/active','0','2024-03-05 04:43:56'),(320,'default',0,'payment/payflow_link/active','0','2024-03-05 04:43:56'),(321,'default',0,'payment/payflow_link/partner','PayPal','2024-03-05 04:43:56'),(322,'default',0,'payment/payflow_link/vendor',NULL,'2024-03-05 04:43:56'),(323,'default',0,'payment/payflow_link/user',NULL,'2024-03-05 04:43:56'),(324,'default',0,'payment/payflow_link/pwd',NULL,'2024-03-05 04:43:56'),(325,'default',0,'payment/payflow_link/sandbox_flag','0','2024-03-05 04:43:56'),(326,'default',0,'payment/payflow_link/use_proxy','0','2024-03-05 04:43:56'),(327,'default',0,'payment/payflow_link/title','Credit Card (Payflow Link)','2024-03-05 04:43:56'),(328,'default',0,'payment/payflow_link/sort_order',NULL,'2024-03-05 04:43:56'),(329,'default',0,'payment/payflow_link/payment_action','Authorization','2024-03-05 04:43:56'),(330,'default',0,'payment/payflow_link/allowspecific','0','2024-03-05 04:43:56'),(331,'default',0,'payment/payflow_link/debug','0','2024-03-05 04:43:56'),(332,'default',0,'payment/payflow_link/verify_peer','1','2024-03-05 04:43:56'),(333,'default',0,'payment/payflow_link/csc_editable','1','2024-03-05 04:43:56'),(334,'default',0,'payment/payflow_link/csc_required','1','2024-03-05 04:43:56'),(335,'default',0,'payment/payflow_link/email_confirmation','0','2024-03-05 04:43:56'),(336,'default',0,'payment/payflow_link/url_method','GET','2024-03-05 04:43:56'),(337,'default',0,'payment/free/specificcountry',NULL,'2024-03-05 04:43:56'),(338,'default',0,'payment/checkmo/specificcountry',NULL,'2024-03-05 04:43:56'),(339,'default',0,'payment/checkmo/payable_to',NULL,'2024-03-05 04:43:57'),(340,'default',0,'payment/checkmo/mailing_address',NULL,'2024-03-05 04:43:57'),(341,'default',0,'payment/checkmo/min_order_total',NULL,'2024-03-05 04:43:57'),(342,'default',0,'payment/checkmo/max_order_total',NULL,'2024-03-05 04:43:57'),(343,'default',0,'payment/checkmo/sort_order',NULL,'2024-03-05 04:43:57'),(344,'default',0,'payment/banktransfer/specificcountry',NULL,'2024-03-05 04:43:57'),(345,'default',0,'payment/banktransfer/instructions',NULL,'2024-03-05 04:43:57'),(346,'default',0,'payment/banktransfer/min_order_total',NULL,'2024-03-05 04:43:57'),(347,'default',0,'payment/banktransfer/max_order_total',NULL,'2024-03-05 04:43:57'),(348,'default',0,'payment/banktransfer/sort_order',NULL,'2024-03-05 04:43:57'),(349,'default',0,'payment/cashondelivery/active','1','2024-03-05 04:43:57'),(350,'default',0,'payment/cashondelivery/specificcountry',NULL,'2024-03-05 04:43:57'),(351,'default',0,'payment/cashondelivery/instructions',NULL,'2024-03-05 04:43:57'),(352,'default',0,'payment/cashondelivery/min_order_total',NULL,'2024-03-05 04:43:57'),(353,'default',0,'payment/cashondelivery/max_order_total',NULL,'2024-03-05 04:43:57'),(354,'default',0,'payment/cashondelivery/sort_order',NULL,'2024-03-05 04:43:57'),(355,'default',0,'payment/purchaseorder/specificcountry',NULL,'2024-03-05 04:43:57'),(356,'default',0,'payment/purchaseorder/min_order_total',NULL,'2024-03-05 04:43:57'),(357,'default',0,'payment/purchaseorder/max_order_total',NULL,'2024-03-05 04:43:57'),(358,'default',0,'payment/purchaseorder/sort_order',NULL,'2024-03-05 04:43:57'),(359,'default',0,'catalog/productalert_cron/frequency','D','2024-03-05 09:27:32'),(360,'default',0,'crontab/default/jobs/catalog_product_alert/schedule/cron_expr','0 0 * * *','2024-03-05 09:27:32'),(361,'default',0,'crontab/default/jobs/catalog_product_alert/run/model',NULL,'2024-03-05 09:27:32'),(362,'default',0,'catalog/productalert_cron/time','00,00,00','2024-03-05 09:27:32'),(363,'default',0,'catalog/productalert_cron/error_email',NULL,'2024-03-05 09:27:32'),(364,'default',0,'catalog/product_video/youtube_api_key',NULL,'2024-03-05 09:27:32'),(365,'default',0,'catalog/price/scope','0','2024-03-05 09:27:32'),(367,'default',0,'catalog/search/opensearch_server_hostname','localhost','2024-03-05 09:27:32'),(368,'default',0,'catalog/search/opensearch_server_port','9200','2024-03-05 09:27:32'),(369,'default',0,'catalog/search/opensearch_index_prefix','magento2','2024-03-05 09:27:32'),(370,'default',0,'catalog/search/opensearch_enable_auth','0','2024-03-05 09:27:32'),(371,'default',0,'catalog/search/opensearch_server_timeout','15','2024-03-05 09:27:32'),(372,'default',0,'catalog/search/opensearch_minimum_should_match',NULL,'2024-03-05 09:27:32'),(373,'default',0,'catalog/custom_options/use_calendar','0','2024-03-05 09:27:32'),(374,'default',0,'catalog/custom_options/year_range',',','2024-03-05 09:27:32'),(375,'default',0,'catalog/placeholder/image_placeholder',NULL,'2024-03-05 09:27:32'),(376,'default',0,'catalog/placeholder/small_image_placeholder',NULL,'2024-03-05 09:27:32'),(377,'default',0,'catalog/placeholder/thumbnail_placeholder',NULL,'2024-03-05 09:27:32'),(378,'default',0,'catalog/placeholder/swatch_image_placeholder',NULL,'2024-03-05 09:27:32'),(379,'default',0,'design/pagination/pagination_frame','5','2024-03-06 11:33:08'),(380,'default',0,'design/pagination/pagination_frame_skip',NULL,'2024-03-06 11:33:08'),(381,'default',0,'design/pagination/anchor_text_for_previous',NULL,'2024-03-06 11:33:08'),(382,'default',0,'design/pagination/anchor_text_for_next',NULL,'2024-03-06 11:33:08'),(383,'default',0,'design/head/default_title','Magento Commerce','2024-03-06 11:33:08'),(384,'default',0,'design/head/title_prefix',NULL,'2024-03-06 11:33:08'),(385,'default',0,'design/head/title_suffix',NULL,'2024-03-06 11:33:08'),(386,'default',0,'design/head/default_description',NULL,'2024-03-06 11:33:08'),(387,'default',0,'design/head/default_keywords',NULL,'2024-03-06 11:33:08'),(388,'default',0,'design/head/demonotice','0','2024-03-06 11:33:08'),(389,'default',0,'design/header/logo_width',NULL,'2024-03-06 11:33:08'),(390,'default',0,'design/header/logo_height',NULL,'2024-03-06 11:33:08'),(391,'default',0,'design/header/logo_alt',NULL,'2024-03-06 11:33:08'),(392,'default',0,'design/header/welcome','Default welcome msg!','2024-03-06 11:33:08'),(393,'default',0,'design/header/translate_title','1','2024-03-06 11:33:08'),(394,'default',0,'design/footer/copyright','Copyright © 2013-present Magento, Inc. All rights reserved.','2024-03-06 11:33:08'),(395,'default',0,'design/footer/absolute_footer',NULL,'2024-03-06 11:33:08'),(396,'default',0,'design/footer/report_bugs','1','2024-03-06 11:33:08'),(397,'default',0,'design/search_engine_robots/default_robots','INDEX,FOLLOW','2024-03-06 11:33:08'),(398,'default',0,'design/search_engine_robots/custom_instructions',NULL,'2024-03-06 11:33:08'),(399,'default',0,'design/watermark/image_size',NULL,'2024-03-06 11:33:08'),(400,'default',0,'design/watermark/image_imageOpacity',NULL,'2024-03-06 11:33:08'),(401,'default',0,'design/watermark/image_position','stretch','2024-03-06 11:33:08'),(402,'default',0,'design/watermark/small_image_size',NULL,'2024-03-06 11:33:08'),(403,'default',0,'design/watermark/small_image_imageOpacity',NULL,'2024-03-06 11:33:08'),(404,'default',0,'design/watermark/small_image_position','stretch','2024-03-06 11:33:08'),(405,'default',0,'design/watermark/thumbnail_size',NULL,'2024-03-06 11:33:08'),(406,'default',0,'design/watermark/thumbnail_imageOpacity',NULL,'2024-03-06 11:33:08'),(407,'default',0,'design/watermark/thumbnail_position','stretch','2024-03-06 11:33:08'),(408,'default',0,'design/email/logo_alt',NULL,'2024-03-06 11:33:08'),(409,'default',0,'design/email/logo_width',NULL,'2024-03-06 11:33:08'),(410,'default',0,'design/email/logo_height',NULL,'2024-03-06 11:33:08'),(411,'default',0,'design/email/header_template','design_email_header_template','2024-03-06 11:33:08'),(412,'default',0,'design/email/footer_template','design_email_footer_template','2024-03-06 11:33:08'),(416,'default',0,'catalog/search/enable_eav_indexer','1','2024-03-06 12:56:02'),(418,'default',0,'catalog/search/search_recommendations_enabled','1','2024-03-06 12:56:02'),(419,'default',0,'catalog/search/search_recommendations_count','5','2024-03-06 12:56:02'),(420,'default',0,'catalog/search/search_recommendations_count_results_enabled','0','2024-03-06 12:56:02'),(421,'default',0,'catalog/search/search_suggestion_enabled','1','2024-03-06 12:56:02'),(422,'default',0,'catalog/search/search_suggestion_count','2','2024-03-06 12:56:02'),(423,'default',0,'catalog/search/search_suggestion_count_results_enabled','0','2024-03-06 12:56:02'),(424,'default',0,'bizkicksettings/navigation_settings/enable','1','2024-03-07 05:41:18'),(425,'default',0,'bizkicksettings/promotion_settings/enable_promotion','0','2024-03-07 05:41:19'),(426,'default',0,'bizkicksettings/category_settings/show_border','0','2024-03-07 05:41:19'),(427,'default',0,'bizkicksettings/category_settings/show_new_label','0','2024-03-07 05:41:19'),(428,'default',0,'bizkicksettings/category_settings/show_sale_label','0','2024-03-07 05:41:19'),(429,'default',0,'bizkicksettings/product_settings/show_new_label','0','2024-03-07 05:42:46'),(430,'default',0,'bizkicksettings/product_settings/show_sale_label','0','2024-03-07 05:41:19'),(431,'default',0,'bizkicksettings/newsletter_settings/enable','0','2024-03-15 08:09:28'),(432,'default',0,'bizkicksettings/newsletter_settings/newsletter_static',NULL,'2024-03-15 08:09:28'),(433,'default',0,'bizkicksettings/footer_columns/enable_footer_columns','1','2024-03-18 09:29:51'),(434,'default',0,'bizkicksettings/footer_columns/footer_st_column_select','staticblock','2024-03-18 09:29:41'),(435,'default',0,'bizkicksettings/footer_columns/footer_st_column','footer_about_company','2024-03-18 09:36:08'),(436,'default',0,'bizkicksettings/footer_columns/footer_nd_column','footer_useful_links','2024-03-18 09:36:08'),(437,'default',0,'bizkicksettings/footer_columns/footer_rd_column','footer_shoplinks','2024-03-18 09:36:08'),(438,'default',0,'bizkicksettings/footer_contant/address','265, Lorem Street, New York, 32456, United States','2024-03-07 05:41:19'),(439,'default',0,'bizkicksettings/footer_contant/email','info@a2zsupplies.com','2024-03-07 09:21:38'),(440,'default',0,'bizkicksettings/footer_contant/phone','+1 234 567 8901','2024-03-07 05:41:19'),(441,'default',0,'bizkicksettings/footer_bottom/enable_footer_bottom','1','2024-03-07 05:41:19'),(442,'default',0,'bizkicksettings/footer_bottom/copyright_text','Copyright © 2024 - A2Z Supplies . All rights reserved. @ Powered by Yiron Technologies','2024-03-15 11:27:53'),(443,'default',0,'bizkicksettings/footer_bottom/copyright_right_block',NULL,'2024-03-19 10:29:54'),(444,'default',0,'bizkicksettings/customcss/custom_css',NULL,'2024-03-18 06:23:26'),(445,'default',0,'bizkicksettings/newsletter_settings/title','Sign Up For Newsletter','2024-03-07 05:41:36'),(446,'default',0,'design/head/shortcut_icon','default/logo-v3_1.jpg','2024-03-07 08:13:27'),(447,'default',0,'design/header/logo_src','default/logo-v4_1.jpg','2024-03-07 08:13:27'),(448,'websites',1,'design/head/shortcut_icon','websites/1/logo-v3_1.jpg','2024-03-07 08:13:43'),(449,'websites',1,'design/header/logo_src','websites/1/logo-v4_1.jpg','2024-03-07 08:13:43'),(450,'stores',1,'design/head/shortcut_icon','stores/1/logo-v3_1.jpg','2024-03-07 08:14:00'),(451,'stores',1,'design/header/logo_src','stores/1/logo-v4_1.jpg','2024-03-07 08:14:00'),(452,'default',0,'catalog/search/min_query_length','3','2024-03-08 06:26:16'),(453,'default',0,'catalog/search/max_query_length','128','2024-03-08 06:26:16'),(454,'default',0,'catalog/search/max_count_cacheable_search_terms','100','2024-03-08 06:26:16'),(455,'default',0,'catalog/search/autocomplete_limit','8','2024-03-08 06:26:16'),(456,'default',0,'catalog/search/engine','elasticsearch7','2024-03-12 14:51:34'),(457,'default',0,'catalog/frontend/list_allow_all','0','2024-03-08 08:36:22'),(458,'default',0,'catalog/search/elasticsearch7_server_hostname','localhost','2024-03-12 07:20:33'),(459,'default',0,'catalog/search/elasticsearch7_server_port','9200','2024-03-12 07:20:33'),(460,'default',0,'catalog/search/elasticsearch7_index_prefix','magento2','2024-03-12 07:20:33'),(461,'default',0,'catalog/search/elasticsearch7_enable_auth','0','2024-03-12 07:20:33'),(462,'default',0,'catalog/search/elasticsearch7_server_timeout','15','2024-03-12 07:20:33'),(463,'default',0,'catalog/search/elasticsearch7_minimum_should_match',NULL,'2024-03-12 07:20:33'),(464,'default',0,'cataloginventory/options/show_out_of_stock','1','2024-03-12 07:23:07'),(465,'default',0,'cataloginventory/source_selection_distance_based_google/api_key',NULL,'2024-03-12 07:23:08'),(466,'default',0,'catalog/navigation/max_depth','10','2024-03-12 11:08:12');

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

CREATE TABLE `cron_schedule` (
  `schedule_id` int 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_STATUS_SCHEDULED_AT` (`job_code`,`status`,`scheduled_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Cron Schedule';

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


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

CREATE TABLE `customer_address_entity` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `parent_id` int 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 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 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 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 unsigned DEFAULT NULL COMMENT 'VAT number validation request success',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_ADDRESS_ENTITY_PARENT_ID` (`parent_id`),
  CONSTRAINT `CUSTOMER_ADDRESS_ENTITY_PARENT_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COMMENT='Customer Address Entity';

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

INSERT INTO `customer_address_entity` VALUES (1,NULL,1,'2024-02-29 10:29:44','2024-02-29 10:29:44',1,'Calder',NULL,'US',NULL,'Veronica','Costello',NULL,'49628-7978',NULL,'Michigan',33,'6146 Honey Bluff Parkway',NULL,'(555) 229-3326',NULL,NULL,NULL,NULL,NULL),(2,NULL,2,'2024-03-05 04:46:11','2024-03-05 04:46:11',1,'WESTLANDS','Test','MU',NULL,'Amit','kamboj',NULL,'33122',NULL,NULL,0,'Test',NULL,'7307163659',NULL,NULL,NULL,NULL,NULL),(3,NULL,3,'2024-03-05 10:58:57','2024-03-05 10:58:57',1,'WESTLANDS','Test','MU',NULL,'Amit','kamboj',NULL,'33122',NULL,NULL,0,'Test',NULL,'7307163659',NULL,NULL,NULL,NULL,NULL),(4,NULL,4,'2024-03-06 12:18:00','2024-03-06 12:18:00',1,'chandigarh',NULL,'IN',NULL,'palak','bansal',NULL,'160101',NULL,'Chandigarh',574,'fcs',NULL,'827828968',NULL,NULL,NULL,NULL,NULL),(5,NULL,5,'2024-03-06 12:22:23','2024-03-06 12:22:23',1,'chandigarh',NULL,'IN',NULL,'palak','gupta',NULL,'160101',NULL,'Chandigarh',574,'fcs',NULL,'8278289868',NULL,NULL,NULL,NULL,NULL),(6,NULL,7,'2024-08-30 09:51:39','2024-08-30 09:51:39',1,'ddfdf',NULL,'US',NULL,'Robin','Sharma',NULL,'458596',NULL,'Alaska',2,'dfd',NULL,'258965896',NULL,NULL,NULL,NULL,NULL),(7,NULL,7,'2024-08-30 12:36:03','2024-08-30 12:36:03',1,'town',NULL,'US',NULL,'sdfsd','Sharmff',NULL,'12345-6789',NULL,'Delaware',15,'43\n3',NULL,'7896859685',NULL,NULL,NULL,NULL,NULL);

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

CREATE TABLE `customer_address_entity_datetime` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int 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`),
  CONSTRAINT `CSTR_ADDR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CSTR_ADDR_ENTT_DTIME_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int 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`),
  CONSTRAINT `CSTR_ADDR_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CSTR_ADDR_ENTT_DEC_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` int 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`),
  CONSTRAINT `CSTR_ADDR_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CSTR_ADDR_ENTT_INT_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int 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`),
  CONSTRAINT `CSTR_ADDR_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CSTR_ADDR_ENTT_TEXT_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `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`),
  CONSTRAINT `CSTR_ADDR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CSTR_ADDR_ENTT_VCHR_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Customer Address Entity Varchar';

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


--
-- Table structure for table `customer_dummy_cl`
--

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

--
-- Dumping data for table `customer_dummy_cl`
--


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

CREATE TABLE `customer_eav_attribute` (
  `attribute_id` smallint unsigned NOT NULL COMMENT 'Attribute ID',
  `is_visible` smallint unsigned NOT NULL DEFAULT '1' COMMENT 'Is Visible',
  `input_filter` varchar(255) DEFAULT NULL COMMENT 'Input Filter',
  `multiline_count` smallint unsigned NOT NULL DEFAULT '1' COMMENT 'Multiline Count',
  `validate_rules` text COMMENT 'Validate Rules',
  `is_system` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is System',
  `sort_order` int unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `data_model` varchar(255) DEFAULT NULL COMMENT 'Data Model',
  `is_used_in_grid` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Used in Grid',
  `is_visible_in_grid` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Visible in Grid',
  `is_filterable_in_grid` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Filterable in Grid',
  `is_searchable_in_grid` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Is Searchable in Grid',
  `grid_filter_condition_type` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Grid Filter Condition Type',
  PRIMARY KEY (`attribute_id`),
  KEY `CUSTOMER_EAV_ATTRIBUTE_SORT_ORDER` (`sort_order`),
  CONSTRAINT `CUSTOMER_EAV_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='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,0),(2,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(3,1,NULL,0,NULL,1,20,NULL,1,1,0,1,0),(4,0,NULL,0,NULL,0,30,NULL,0,0,0,0,0),(5,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,40,NULL,0,0,0,0,0),(6,0,'trim',0,NULL,0,50,NULL,0,0,0,0,0),(7,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,60,NULL,0,0,0,0,0),(8,0,NULL,0,NULL,0,70,NULL,0,0,0,0,0),(9,1,NULL,0,'{\"input_validation\":\"email\"}',1,80,NULL,1,1,1,1,0),(10,1,NULL,0,NULL,1,25,NULL,1,1,1,0,0),(11,0,'date',0,'{\"input_validation\":\"date\"}',0,90,NULL,1,1,1,0,0),(12,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(13,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(14,0,NULL,0,'{\"input_validation\":\"date\"}',1,0,NULL,0,0,0,0,0),(15,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(16,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(17,0,NULL,0,'{\"max_text_length\":255}',0,100,NULL,1,1,0,1,0),(18,0,NULL,0,NULL,1,0,NULL,1,1,1,0,0),(19,0,NULL,0,NULL,0,0,NULL,1,1,1,0,0),(20,0,NULL,0,'[]',0,110,NULL,1,1,1,0,0),(21,1,NULL,0,NULL,1,28,NULL,0,0,0,0,0),(22,0,NULL,0,NULL,0,10,NULL,0,0,0,0,0),(23,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,20,NULL,1,0,0,1,0),(24,0,'trim',0,NULL,0,30,NULL,0,0,0,0,0),(25,1,'trim',0,'{\"max_text_length\":255,\"min_text_length\":1}',1,40,NULL,1,0,0,1,0),(26,0,NULL,0,NULL,0,50,NULL,0,0,0,0,0),(27,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,60,NULL,1,0,0,1,0),(28,1,NULL,2,'{\"max_text_length\":255,\"min_text_length\":1}',1,70,NULL,1,0,0,1,0),(29,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,100,NULL,1,0,0,1,0),(30,1,NULL,0,NULL,1,80,NULL,1,1,1,0,0),(31,1,NULL,0,NULL,1,90,NULL,1,1,0,1,0),(32,1,NULL,0,NULL,1,90,NULL,0,0,0,0,0),(33,1,NULL,0,'[]',1,110,'Magento\\Customer\\Model\\Attribute\\Data\\Postcode',1,1,1,1,0),(34,1,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',1,120,NULL,1,1,1,1,0),(35,0,NULL,0,'{\"max_text_length\":255,\"min_text_length\":1}',0,130,NULL,1,0,0,1,0),(36,1,NULL,0,NULL,1,140,NULL,0,0,0,0,0),(37,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(38,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(39,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(40,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(41,0,NULL,0,NULL,0,0,NULL,0,0,0,0,0),(42,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(43,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(44,0,NULL,0,NULL,1,0,NULL,0,0,0,0,0),(157,0,NULL,0,NULL,0,90,NULL,0,0,0,0,0);

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

CREATE TABLE `customer_eav_attribute_website` (
  `attribute_id` smallint unsigned NOT NULL COMMENT 'Attribute ID',
  `website_id` smallint unsigned NOT NULL COMMENT 'Website ID',
  `is_visible` smallint unsigned DEFAULT NULL COMMENT 'Is Visible',
  `is_required` smallint unsigned DEFAULT NULL COMMENT 'Is Required',
  `default_value` text COMMENT 'Default Value',
  `multiline_count` smallint unsigned DEFAULT NULL COMMENT 'Multiline Count',
  PRIMARY KEY (`attribute_id`,`website_id`),
  KEY `CUSTOMER_EAV_ATTRIBUTE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `CSTR_EAV_ATTR_WS_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CSTR_EAV_ATTR_WS_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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),(157,1,NULL,NULL,NULL,NULL);

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

CREATE TABLE `customer_entity` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `website_id` smallint unsigned DEFAULT NULL COMMENT 'Website ID',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Group ID',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment ID',
  `store_id` smallint 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 unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active',
  `disable_auto_group_change` smallint 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 unsigned DEFAULT NULL COMMENT 'Default Billing Address',
  `default_shipping` int 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 unsigned DEFAULT NULL COMMENT 'Gender',
  `failures_num` smallint 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',
  `mp_smtp_email_marketing_synced` smallint DEFAULT '0' COMMENT 'Mp SMTP Email Marketing synced',
  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`),
  CONSTRAINT `CUSTOMER_ENTITY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE SET NULL,
  CONSTRAINT `CUSTOMER_ENTITY_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `store_website` (`website_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb3 COMMENT='Customer Entity';

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

INSERT INTO `customer_entity` VALUES (1,1,'roni_cost@example.com',1,NULL,1,'2024-02-29 10:29:43','2024-02-29 10:29:44',1,0,'Default Store View',NULL,'Veronica',NULL,'Costello',NULL,'1973-12-15','e9273b2760dbfd97c2561f7d54f866e0e3d598146acbe606b2a9881c7788c8a6:mLaH5XkqE0gnxPzc8pR8ctQqi6V75BjY:3_32_2_67108864','0:3:VG4sEv5aMs4pR6/LEwGYLrQX4XOZ8a83AKJXrNg5AQTrlxUPIhJfrhlu2LseMR3yWRwYqhIzRgU/N3rU','2024-02-29 10:29:44',1,1,NULL,NULL,2,0,NULL,NULL,NULL,0),(2,1,'amit.kumar@yirontechnologies.com',1,NULL,1,'2024-03-05 04:45:45','2024-03-05 04:46:11',1,0,'Default Store View',NULL,'Amit',NULL,'kamboj',NULL,NULL,'12a125f8eb3b2d4647568d9863d214d824699aa8a98063a973909b949ce7e899:zjzav02jvljBQrkjTLBaPWxHKcIDQZc6:3_32_2_67108864','0:3:qCwq8dDN4FcTDfpT2UZu/e87EImnBUYkI7lM18a/+8YqAbB4+G/Vhmi6Y9H6zgLkLi4781pY2eno5BOe','2024-03-05 04:45:46',2,2,NULL,NULL,NULL,0,NULL,NULL,NULL,0),(3,1,'alert@jamboshop.com',1,NULL,1,'2024-03-05 10:58:32','2024-03-05 10:58:57',1,0,'Default Store View',NULL,'Amit',NULL,'kamboj',NULL,NULL,'0d834a2b896d7d6e1bbc8004d12a090c38e5a9a316fea0f7540addf914614c8a:QZSUSHneXgLXbIpPfslb60K2gsNao2JI:3_32_2_67108864','0:3:BhjIot8R41ztrV25Z7OIRN28divO/v3jDaC2PLmpd07ymvt7NJ1qr78P0MesL1ITsBIsQfbIOmUeVOff','2024-03-05 10:58:32',3,3,NULL,NULL,NULL,0,NULL,NULL,NULL,0),(4,1,'plkbansal28@gmail.com',1,NULL,1,'2024-03-06 12:16:15','2024-03-06 12:18:00',1,0,'Default Store View',NULL,'palak',NULL,'bansal',NULL,NULL,'6682192f4af5afa286a995364f3dfd50141e98f8e947cbc8ae52c0fa9f28f933:6j4rVwSKa1hLWvTx05wWZfmvxtrYmUtj:3_32_2_67108864','0:3:uM9P7T6P78K5tofGPuQ0jVthjl/oaUjs0SiC900fVrg4TfUcYfmR6l05BQbUzqgRy41vSyfmS542cQhL','2024-03-06 12:16:15',4,4,NULL,NULL,NULL,0,NULL,NULL,NULL,0),(5,1,'palak.bansal@yirontechnologies.com',1,NULL,1,'2024-03-06 12:20:58','2024-03-06 12:22:23',1,0,'Default Store View',NULL,'palak',NULL,'gupta',NULL,NULL,'074e6a7bb0bee6b8e61313b46ac6db3a25e345eb27703f92e78b3338cfc0e134:VIE3fkDAXEc2OYQnHsJ59BoXcxMPcEyp:3_32_2_67108864','0:3:1RVOJwvcMDPUWs9pBez0XhKmBSlZgxvTbcsq9OoVFosN06rpjkyZ/cHaYRZB0pP7bQIgwq4zY4idMaFr','2024-03-06 12:20:58',5,5,NULL,NULL,NULL,0,NULL,NULL,NULL,0),(6,1,'test@gmail.com',1,NULL,1,'2024-08-30 07:54:32','2024-08-30 07:54:35',1,0,'Default Store View',NULL,'test',NULL,'test',NULL,NULL,'cfcdf2e6ea0f411b5268cd23ae8da97ac8923fd0002f435792860dd71cd1c170:C1tBa5sAs4Wfg4RO190fAsOK9oPKZwL4:3_32_2_67108864','0:3:aDmKxTqOBPOcnsPH2egE4YPDPZ3eP9FyQFthN/PxKiXwlmN2HeoMBz46lZ+lkHWrOjRWXHStD8OSHB4P','2024-08-30 07:54:35',NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,0),(7,1,'testankush@yopmail.com',1,NULL,1,'2024-08-30 09:25:21','2024-08-30 09:51:39',1,0,'Default Store View',NULL,'Robin',NULL,'Sharma',NULL,NULL,'a6101b71ee7be252d58c17e22cc9585e7ef97d810d3d73580cf73a1a316af1f0:dnT8v5Kw7JqNGnrhp4a0GqO0jEbIPJal:3_32_2_67108864','0:3:cr+1L5gIZ1KHnY7n9hn4plSyVx2atI6UFMiIbBzQNoqo7jzczj9R+OHvgclPRYFuGFO6kpfTYd3FkBlP','2024-08-30 09:25:22',6,6,NULL,NULL,NULL,0,NULL,NULL,NULL,0);

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

CREATE TABLE `customer_entity_datetime` (
  `value_id` int NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int 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`),
  CONSTRAINT `CUSTOMER_ENTITY_DATETIME_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CUSTOMER_ENTITY_DATETIME_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int 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`),
  CONSTRAINT `CUSTOMER_ENTITY_DECIMAL_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` int 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`),
  CONSTRAINT `CUSTOMER_ENTITY_INT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CUSTOMER_ENTITY_INT_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int 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`),
  CONSTRAINT `CUSTOMER_ENTITY_TEXT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CUSTOMER_ENTITY_TEXT_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 NOT NULL AUTO_INCREMENT COMMENT 'Value ID',
  `attribute_id` smallint unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute ID',
  `entity_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Entity ID',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `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`),
  CONSTRAINT `CUSTOMER_ENTITY_VARCHAR_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 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 unsigned NOT NULL COMMENT 'Attribute ID',
  PRIMARY KEY (`form_code`,`attribute_id`),
  KEY `CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='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),('adminhtml_customer',157);

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

CREATE TABLE `customer_grid_flat` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `name` text COMMENT 'Name',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` int DEFAULT NULL COMMENT 'Group_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created_at',
  `website_id` int 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 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 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=utf8mb3 COMMENT='customer_grid_flat';

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

INSERT INTO `customer_grid_flat` VALUES (1,'Veronica Costello','roni_cost@example.com',1,'2024-02-29 10:29:43',1,NULL,'Default Store View','1973-12-15',2,NULL,NULL,'6146 Honey Bluff Parkway Calder Michigan 49628-7978','6146 Honey Bluff Parkway Calder Michigan 49628-7978','Veronica','Costello','(555) 229-3326','49628-7978','US','Michigan',33,'6146 Honey Bluff Parkway','Calder',NULL,NULL,NULL),(2,'Amit kamboj','amit.kumar@yirontechnologies.com',1,'2024-03-05 04:45:45',1,NULL,'Default Store View',NULL,NULL,NULL,NULL,'Test WESTLANDS 33122','Test WESTLANDS 33122','Amit','kamboj','7307163659','33122','MU',NULL,0,'Test','WESTLANDS',NULL,NULL,'Test'),(3,'Amit kamboj','alert@jamboshop.com',1,'2024-03-05 10:58:32',1,NULL,'Default Store View',NULL,NULL,NULL,NULL,'Test WESTLANDS 33122','Test WESTLANDS 33122','Amit','kamboj','7307163659','33122','MU',NULL,0,'Test','WESTLANDS',NULL,NULL,'Test'),(4,'palak bansal','plkbansal28@gmail.com',1,'2024-03-06 12:16:15',1,NULL,'Default Store View',NULL,NULL,NULL,NULL,'fcs chandigarh Chandigarh 160101','fcs chandigarh Chandigarh 160101','palak','bansal','827828968','160101','IN','Chandigarh',574,'fcs','chandigarh',NULL,NULL,NULL),(5,'palak gupta','palak.bansal@yirontechnologies.com',1,'2024-03-06 12:20:58',1,NULL,'Default Store View',NULL,NULL,NULL,NULL,'fcs chandigarh Chandigarh 160101','fcs chandigarh Chandigarh 160101','palak','gupta','8278289868','160101','IN','Chandigarh',574,'fcs','chandigarh',NULL,NULL,NULL),(6,'test test','test@gmail.com',1,'2024-08-30 07:54:32',1,NULL,'Default Store View',NULL,NULL,NULL,NULL,'','',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,'Robin Sharma','testankush@yopmail.com',1,'2024-08-30 09:25:21',1,NULL,'Default Store View',NULL,NULL,NULL,NULL,'dfd ddfdf Alaska 458596','dfd ddfdf Alaska 458596','Robin','Sharma','258965896','458596','US','Alaska',2,'dfd','ddfdf',NULL,NULL,NULL);

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

CREATE TABLE `customer_group` (
  `customer_group_id` int unsigned NOT NULL AUTO_INCREMENT,
  `customer_group_code` varchar(32) NOT NULL COMMENT 'Customer Group Code',
  `tax_class_id` int unsigned NOT NULL DEFAULT '0' COMMENT 'Tax Class ID',
  PRIMARY KEY (`customer_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 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_group_excluded_website`
--

CREATE TABLE `customer_group_excluded_website` (
  `entity_id` int unsigned NOT NULL AUTO_INCREMENT,
  `customer_group_id` int unsigned NOT NULL COMMENT 'Customer Group ID',
  `website_id` smallint unsigned NOT NULL COMMENT 'Excluded Website ID from Customer Group',
  PRIMARY KEY (`entity_id`),
  KEY `CUSTOMER_GROUP_EXCLUDED_WEBSITE_CUSTOMER_GROUP_ID_WEBSITE_ID` (`customer_group_id`,`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Excluded Websites From Customer Group';

--
-- Dumping data for table `customer_group_excluded_website`
--


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

CREATE TABLE `customer_log` (
  `log_id` int NOT NULL AUTO_INCREMENT COMMENT 'Log ID',
  `customer_id` int 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=13 DEFAULT CHARSET=utf8mb3 COMMENT='Customer Log Table';

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

INSERT INTO `customer_log` VALUES (1,2,'2024-03-05 04:45:57',NULL),(2,3,'2024-03-06 11:20:38',NULL),(5,4,'2024-03-06 12:16:15','2024-03-06 12:20:01'),(7,5,'2024-03-06 12:20:58',NULL),(8,6,'2024-08-30 09:53:42','2024-08-30 07:55:33'),(10,7,'2024-08-30 12:31:45',NULL);

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

CREATE TABLE `customer_visitor` (
  `visitor_id` bigint unsigned NOT NULL AUTO_INCREMENT COMMENT 'Visitor ID',
  `customer_id` int 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=18 DEFAULT CHARSET=utf8mb3 COMMENT='Visitor Table';

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

INSERT INTO `customer_visitor` VALUES (1,NULL,NULL,'2024-02-29 10:51:16','2024-02-29 11:02:54'),(2,2,NULL,'2024-03-05 04:45:45','2024-03-05 04:46:28'),(3,NULL,NULL,'2024-03-05 10:46:15','2024-03-05 10:49:04'),(4,3,NULL,'2024-03-05 10:58:32','2024-03-05 10:59:15'),(5,3,NULL,'2024-03-06 10:37:15','2024-03-06 10:37:36'),(6,3,NULL,'2024-03-06 11:20:25','2024-03-06 12:59:14'),(7,4,NULL,'2024-03-06 12:04:07','2024-03-06 12:20:01'),(8,5,NULL,'2024-03-06 12:20:18','2024-03-06 12:21:44'),(9,NULL,NULL,'2024-03-07 09:33:57','2024-03-07 09:34:22'),(10,NULL,NULL,'2024-03-07 11:20:07','2024-03-07 11:20:07'),(11,NULL,NULL,'2024-03-07 12:23:01','2024-03-07 12:23:01'),(12,NULL,NULL,'2024-03-13 06:24:27','2024-03-13 06:24:27'),(13,6,NULL,'2024-08-30 06:53:10','2024-08-30 07:55:33'),(14,7,NULL,'2024-08-30 08:50:10','2024-08-30 10:13:12'),(15,6,NULL,'2024-08-30 09:52:55','2024-08-30 10:23:52'),(16,NULL,NULL,'2024-08-30 11:42:35','2024-08-30 11:42:35'),(17,7,NULL,'2024-08-30 12:31:33','2024-08-30 12:36:02');

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

CREATE TABLE `design_change` (
  `design_change_id` int NOT NULL AUTO_INCREMENT COMMENT 'Design Change ID',
  `store_id` smallint 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`),
  CONSTRAINT `DESIGN_CHANGE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COMMENT='Design Changes';

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


--
-- Table structure for table `design_config_dummy_cl`
--

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

--
-- Dumping data for table `design_config_dummy_cl`
--


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

CREATE TABLE `design_config_grid_flat` (
  `entity_id` int unsigned NOT NULL COMMENT 'Entity ID',
  `store_website_id` int DEFAULT NULL COMMENT 'Store_website_id',
  `store_group_id` int DEFAULT NULL COMMENT 'Store_group_id',
  `store_id` int 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=utf8mb3 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=utf8mb3 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 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=utf8mb3 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 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=1122 DEFAULT CHARSET=utf8mb3 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','Friburg'),(111,'CH','GE','Geneva'),(112,'CH','GL','Glarus'),(113,'CH','GR','Graubünden'),(114,'CH','JU','Jura'),(115,'CH','LU','Lucerne'),(116,'CH','NE','Neuchâtel'),(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','Ticino'),(125,'CH','UR','Uri'),(126,'CH','VD','Vaud'),(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,'AL','AL-01','Berat'),(513,'AL','AL-09','Dibër'),(514,'AL','AL-02','Durrës'),(515,'AL','AL-03','Elbasan'),(516,'AL','AL-04','Fier'),(517,'AL','AL-05','Gjirokastër'),(518,'AL','AL-06','Korçë'),(519,'AL','AL-07','Kukës'),(520,'AL','AL-08','Lezhë'),(521,'AL','AL-10','Shkodër'),(522,'AL','AL-11','Tiranë'),(523,'AL','AL-12','Vlorë'),(524,'AR','AR-C','Ciudad Autónoma de Buenos Aires'),(525,'AR','AR-B','Buenos Aires'),(526,'AR','AR-K','Catamarca'),(527,'AR','AR-H','Chaco'),(528,'AR','AR-U','Chubut'),(529,'AR','AR-X','Córdoba'),(530,'AR','AR-W','Corrientes'),(531,'AR','AR-E','Entre Ríos'),(532,'AR','AR-P','Formosa'),(533,'AR','AR-Y','Jujuy'),(534,'AR','AR-L','La Pampa'),(535,'AR','AR-F','La Rioja'),(536,'AR','AR-M','Mendoza'),(537,'AR','AR-N','Misiones'),(538,'AR','AR-Q','Neuquén'),(539,'AR','AR-R','Río Negro'),(540,'AR','AR-A','Salta'),(541,'AR','AR-J','San Juan'),(542,'AR','AR-D','San Luis'),(543,'AR','AR-Z','Santa Cruz'),(544,'AR','AR-S','Santa Fe'),(545,'AR','AR-G','Santiago del Estero'),(546,'AR','AR-V','Tierra del Fuego'),(547,'AR','AR-T','Tucumán'),(548,'HR','HR-01','Zagrebačka županija'),(549,'HR','HR-02','Krapinsko-zagorska županija'),(550,'HR','HR-03','Sisačko-moslavačka županija'),(551,'HR','HR-04','Karlovačka županija'),(552,'HR','HR-05','Varaždinska županija'),(553,'HR','HR-06','Koprivničko-križevačka županija'),(554,'HR','HR-07','Bjelovarsko-bilogorska županija'),(555,'HR','HR-08','Primorsko-goranska županija'),(556,'HR','HR-09','Ličko-senjska županija'),(557,'HR','HR-10','Virovitičko-podravska županija'),(558,'HR','HR-11','Požeško-slavonska županija'),(559,'HR','HR-12','Brodsko-posavska županija'),(560,'HR','HR-13','Zadarska županija'),(561,'HR','HR-14','Osječko-baranjska županija'),(562,'HR','HR-15','Šibensko-kninska županija'),(563,'HR','HR-16','Vukovarsko-srijemska županija'),(564,'HR','HR-17','Splitsko-dalmatinska županija'),(565,'HR','HR-18','Istarska županija'),(566,'HR','HR-19','Dubrovačko-neretvanska županija'),(567,'HR','HR-20','Međimurska županija'),(568,'HR','HR-21','Grad Zagreb'),(569,'IN','AN','Andaman and Nicobar Islands'),(570,'IN','AP','Andhra Pradesh'),(571,'IN','AR','Arunachal Pradesh'),(572,'IN','AS','Assam'),(573,'IN','BR','Bihar'),(574,'IN','CH','Chandigarh'),(575,'IN','CT','Chhattisgarh'),(576,'IN','DN','Dadra and Nagar Haveli'),(577,'IN','DD','Daman and Diu'),(578,'IN','DL','Delhi'),(579,'IN','GA','Goa'),(580,'IN','GJ','Gujarat'),(581,'IN','HR','Haryana'),(582,'IN','HP','Himachal Pradesh'),(583,'IN','JK','Jammu and Kashmir'),(584,'IN','JH','Jharkhand'),(585,'IN','KA','Karnataka'),(586,'IN','KL','Kerala'),(587,'IN','LD','Lakshadweep'),(588,'IN','MP','Madhya Pradesh'),(589,'IN','MH','Maharashtra'),(590,'IN','MN','Manipur'),(591,'IN','ML','Meghalaya'),(592,'IN','MZ','Mizoram'),(593,'IN','NL','Nagaland'),(594,'IN','OR','Odisha'),(595,'IN','PY','Puducherry'),(596,'IN','PB','Punjab'),(597,'IN','RJ','Rajasthan'),(598,'IN','SK','Sikkim'),(599,'IN','TN','Tamil Nadu'),(600,'IN','TG','Telangana'),(601,'IN','TR','Tripura'),(602,'IN','UP','Uttar Pradesh'),(603,'IN','UT','Uttarakhand'),(604,'IN','WB','West Bengal'),(605,'AU','ACT','Australian Capital Territory'),(606,'AU','NSW','New South Wales'),(607,'AU','VIC','Victoria'),(608,'AU','QLD','Queensland'),(609,'AU','SA','South Australia'),(610,'AU','TAS','Tasmania'),(611,'AU','WA','Western Australia'),(612,'AU','NT','Northern Territory'),(613,'BY','BY-BR','Bresckaja voblasć'),(614,'BY','BY-HO','Homieĺskaja voblasć'),(615,'BY','BY-HM','Horad Minsk'),(616,'BY','BY-HR','Hrodzienskaja voblasć'),(617,'BY','BY-MA','Mahilioŭskaja voblasć'),(618,'BY','BY-MI','Minskaja voblasć'),(619,'BY','BY-VI','Viciebskaja voblasć'),(620,'BE','VAN','Antwerpen'),(621,'BE','WBR','Brabant wallon'),(622,'BE','BRU','Brussels-Capital Region'),(623,'BE','WHT','Hainaut'),(624,'BE','VLI','Limburg'),(625,'BE','WLG','Liège'),(626,'BE','WLX','Luxembourg'),(627,'BE','WNA','Namur'),(628,'BE','VOV','Oost-Vlaanderen'),(629,'BE','VBR','Vlaams-Brabant'),(630,'BE','VWV','West-Vlaanderen'),(631,'BO','BO-C','Cochabamba'),(632,'BO','BO-H','Chuquisaca'),(633,'BO','BO-B','El Beni'),(634,'BO','BO-L','La Paz'),(635,'BO','BO-O','Oruro'),(636,'BO','BO-N','Pando'),(637,'BO','BO-P','Potosí'),(638,'BO','BO-S','Santa Cruz'),(639,'BO','BO-T','Tarija'),(640,'BG','BG-01','Blagoevgrad'),(641,'BG','BG-02','Burgas'),(642,'BG','BG-03','Varna'),(643,'BG','BG-04','Veliko Tarnovo'),(644,'BG','BG-05','Vidin'),(645,'BG','BG-06','Vratsa'),(646,'BG','BG-07','Gabrovo'),(647,'BG','BG-08','Dobrich'),(648,'BG','BG-09','Kardzhali'),(649,'BG','BG-10','Kyustendil'),(650,'BG','BG-11','Lovech'),(651,'BG','BG-12','Montana'),(652,'BG','BG-13','Pazardzhik'),(653,'BG','BG-14','Pernik'),(654,'BG','BG-15','Pleven'),(655,'BG','BG-16','Plovdiv'),(656,'BG','BG-17','Razgrad'),(657,'BG','BG-18','Ruse'),(658,'BG','BG-19','Silistra'),(659,'BG','BG-20','Sliven'),(660,'BG','BG-21','Smolyan'),(661,'BG','BG-22','Sofia City'),(662,'BG','BG-23','Sofia Province'),(663,'BG','BG-24','Stara Zagora'),(664,'BG','BG-25','Targovishte'),(665,'BG','BG-26','Haskovo'),(666,'BG','BG-27','Shumen'),(667,'BG','BG-28','Yambol'),(668,'CL','CL-AI','Aisén del General Carlos Ibañez del Campo'),(669,'CL','CL-AN','Antofagasta'),(670,'CL','CL-AP','Arica y Parinacota'),(671,'CL','CL-AR','La Araucanía'),(672,'CL','CL-AT','Atacama'),(673,'CL','CL-BI','Biobío'),(674,'CL','CL-CO','Coquimbo'),(675,'CL','CL-LI','Libertador General Bernardo O\'Higgins'),(676,'CL','CL-LL','Los Lagos'),(677,'CL','CL-LR','Los Ríos'),(678,'CL','CL-MA','Magallanes'),(679,'CL','CL-ML','Maule'),(680,'CL','CL-NB','Ñuble'),(681,'CL','CL-RM','Región Metropolitana de Santiago'),(682,'CL','CL-TA','Tarapacá'),(683,'CL','CL-VS','Valparaíso'),(684,'CN','CN-AH','Anhui Sheng'),(685,'CN','CN-BJ','Beijing Shi'),(686,'CN','CN-CQ','Chongqing Shi'),(687,'CN','CN-FJ','Fujian Sheng'),(688,'CN','CN-GS','Gansu Sheng'),(689,'CN','CN-GD','Guangdong Sheng'),(690,'CN','CN-GX','Guangxi Zhuangzu Zizhiqu'),(691,'CN','CN-GZ','Guizhou Sheng'),(692,'CN','CN-HI','Hainan Sheng'),(693,'CN','CN-HE','Hebei Sheng'),(694,'CN','CN-HL','Heilongjiang Sheng'),(695,'CN','CN-HA','Henan Sheng'),(696,'CN','CN-HK','Hong Kong SAR'),(697,'CN','CN-HB','Hubei Sheng'),(698,'CN','CN-HN','Hunan Sheng'),(699,'CN','CN-JS','Jiangsu Sheng'),(700,'CN','CN-JX','Jiangxi Sheng'),(701,'CN','CN-JL','Jilin Sheng'),(702,'CN','CN-LN','Liaoning Sheng'),(703,'CN','CN-MO','Macao SAR'),(704,'CN','CN-NM','Nei Mongol Zizhiqu'),(705,'CN','CN-NX','Ningxia Huizi Zizhiqu'),(706,'CN','CN-QH','Qinghai Sheng'),(707,'CN','CN-SN','Shaanxi Sheng'),(708,'CN','CN-SD','Shandong Sheng'),(709,'CN','CN-SH','Shanghai Shi'),(710,'CN','CN-SX','Shanxi Sheng'),(711,'CN','CN-SC','Sichuan Sheng'),(712,'CN','CN-TW','Taiwan Sheng'),(713,'CN','CN-TJ','Tianjin Shi'),(714,'CN','CN-XJ','Xinjiang Uygur Zizhiqu'),(715,'CN','CN-XZ','Xizang Zizhiqu'),(716,'CN','CN-YN','Yunnan Sheng'),(717,'CN','CN-ZJ','Zhejiang Sheng'),(718,'CO','CO-AMA','Amazonas'),(719,'CO','CO-ANT','Antioquia'),(720,'CO','CO-ARA','Arauca'),(721,'CO','CO-ATL','Atlántico'),(722,'CO','CO-BOL','Bolívar'),(723,'CO','CO-BOY','Boyacá'),(724,'CO','CO-CAL','Caldas'),(725,'CO','CO-CAQ','Caquetá'),(726,'CO','CO-CAS','Casanare'),(727,'CO','CO-CAU','Cauca'),(728,'CO','CO-CES','Cesar'),(729,'CO','CO-CHO','Chocó'),(730,'CO','CO-COR','Córdoba'),(731,'CO','CO-CUN','Cundinamarca'),(732,'CO','CO-GUA','Guainía'),(733,'CO','CO-GUV','Guaviare'),(734,'CO','CO-HUL','Huila'),(735,'CO','CO-LAG','La Guajira'),(736,'CO','CO-MAG','Magdalena'),(737,'CO','CO-MET','Meta'),(738,'CO','CO-NAR','Nariño'),(739,'CO','CO-NSA','Norte de Santander'),(740,'CO','CO-PUT','Putumayo'),(741,'CO','CO-QUI','Quindío'),(742,'CO','CO-RIS','Risaralda'),(743,'CO','CO-SAP','San Andrés y Providencia'),(744,'CO','CO-SAN','Santander'),(745,'CO','CO-SUC','Sucre'),(746,'CO','CO-TOL','Tolima'),(747,'CO','CO-VAC','Valle del Cauca'),(748,'CO','CO-VAU','Vaupés'),(749,'CO','CO-VID','Vichada'),(750,'CZ','CZ-10','Praha, Hlavní město'),(751,'CZ','CZ-20','Středočeský kraj'),(752,'CZ','CZ-31','Jihočeský kraj'),(753,'CZ','CZ-32','Plzeňský kraj'),(754,'CZ','CZ-41','Karlovarský kraj'),(755,'CZ','CZ-42','Ústecký kraj'),(756,'CZ','CZ-51','Liberecký kraj'),(757,'CZ','CZ-52','Královéhradecký kraj'),(758,'CZ','CZ-53','Pardubický kraj'),(759,'CZ','CZ-63','Kraj Vysočina'),(760,'CZ','CZ-64','Jihomoravský kraj'),(761,'CZ','CZ-71','Olomoucký kraj'),(762,'CZ','CZ-72','Zlínský kraj'),(763,'CZ','CZ-80','Moravskoslezský kraj'),(764,'DK','DK-84','Hovedstaden'),(765,'DK','DK-82','Midtjylland'),(766,'DK','DK-81','Nordjylland'),(767,'DK','DK-85','Sjælland'),(768,'DK','DK-83','Syddanmark'),(769,'EC','EC-A','Azuay'),(770,'EC','EC-B','Bolívar'),(771,'EC','EC-F','Cañar'),(772,'EC','EC-C','Carchi'),(773,'EC','EC-H','Chimborazo'),(774,'EC','EC-X','Cotopaxi'),(775,'EC','EC-O','El Oro'),(776,'EC','EC-E','Esmeraldas'),(777,'EC','EC-W','Galápagos'),(778,'EC','EC-G','Guayas'),(779,'EC','EC-I','Imbabura'),(780,'EC','EC-L','Loja'),(781,'EC','EC-R','Los Ríos'),(782,'EC','EC-M','Manabí'),(783,'EC','EC-S','Morona Santiago'),(784,'EC','EC-N','Napo'),(785,'EC','EC-D','Orellana'),(786,'EC','EC-Y','Pastaza'),(787,'EC','EC-P','Pichincha'),(788,'EC','EC-SE','Santa Elena'),(789,'EC','EC-SD','Santo Domingo de los Tsáchilas'),(790,'EC','EC-U','Sucumbíos'),(791,'EC','EC-T','Tungurahua'),(792,'EC','EC-Z','Zamora Chinchipe'),(793,'GR','GR-A','Anatolikí Makedonía kai Thráki'),(794,'GR','GR-I','Attikí'),(795,'GR','GR-G','Dytikí Elláda'),(796,'GR','GR-C','Dytikí Makedonía'),(797,'GR','GR-F','Ionía Nísia'),(798,'GR','GR-D','Ípeiros'),(799,'GR','GR-B','Kentrikí Makedonía'),(800,'GR','GR-M','Kríti'),(801,'GR','GR-L','Nótio Aigaío'),(802,'GR','GR-J','Pelopónnisos'),(803,'GR','GR-H','Stereá Elláda'),(804,'GR','GR-E','Thessalía'),(805,'GR','GR-K','Vóreio Aigaío'),(806,'GR','GR-69','Ágion Óros'),(807,'GY','GY-BA','Barima-Waini'),(808,'GY','GY-CU','Cuyuni-Mazaruni'),(809,'GY','GY-DE','Demerara-Mahaica'),(810,'GY','GY-EB','East Berbice-Corentyne'),(811,'GY','GY-ES','Essequibo Islands-West Demerara'),(812,'GY','GY-MA','Mahaica-Berbice'),(813,'GY','GY-PM','Pomeroon-Supenaam'),(814,'GY','GY-PT','Potaro-Siparuni'),(815,'GY','GY-UD','Upper Demerara-Berbice'),(816,'GY','GY-UT','Upper Takutu-Upper Essequibo'),(817,'IS','IS-01','Höfuðborgarsvæði'),(818,'IS','IS-02','Suðurnes'),(819,'IS','IS-03','Vesturland'),(820,'IS','IS-04','Vestfirðir'),(821,'IS','IS-05','Norðurland vestra'),(822,'IS','IS-06','Norðurland eystra'),(823,'IS','IS-07','Austurland'),(824,'IS','IS-08','Suðurland'),(825,'IT','AG','Agrigento'),(826,'IT','AL','Alessandria'),(827,'IT','AN','Ancona'),(828,'IT','AO','Aosta'),(829,'IT','AQ','L\'Aquila'),(830,'IT','AR','Arezzo'),(831,'IT','AP','Ascoli-Piceno'),(832,'IT','AT','Asti'),(833,'IT','AV','Avellino'),(834,'IT','BA','Bari'),(835,'IT','BT','Barletta-Andria-Trani'),(836,'IT','BL','Belluno'),(837,'IT','BN','Benevento'),(838,'IT','BG','Bergamo'),(839,'IT','BI','Biella'),(840,'IT','BO','Bologna'),(841,'IT','BZ','Bolzano'),(842,'IT','BS','Brescia'),(843,'IT','BR','Brindisi'),(844,'IT','CA','Cagliari'),(845,'IT','CL','Caltanissetta'),(846,'IT','CB','Campobasso'),(847,'IT','CI','Carbonia Iglesias'),(848,'IT','CE','Caserta'),(849,'IT','CT','Catania'),(850,'IT','CZ','Catanzaro'),(851,'IT','CH','Chieti'),(852,'IT','CO','Como'),(853,'IT','CS','Cosenza'),(854,'IT','CR','Cremona'),(855,'IT','KR','Crotone'),(856,'IT','CN','Cuneo'),(857,'IT','EN','Enna'),(858,'IT','FM','Fermo'),(859,'IT','FE','Ferrara'),(860,'IT','FI','Firenze'),(861,'IT','FG','Foggia'),(862,'IT','FC','Forli-Cesena'),(863,'IT','FR','Frosinone'),(864,'IT','GE','Genova'),(865,'IT','GO','Gorizia'),(866,'IT','GR','Grosseto'),(867,'IT','IM','Imperia'),(868,'IT','IS','Isernia'),(869,'IT','SP','La-Spezia'),(870,'IT','LT','Latina'),(871,'IT','LE','Lecce'),(872,'IT','LC','Lecco'),(873,'IT','LI','Livorno'),(874,'IT','LO','Lodi'),(875,'IT','LU','Lucca'),(876,'IT','MC','Macerata'),(877,'IT','MN','Mantova'),(878,'IT','MS','Massa-Carrara'),(879,'IT','MT','Matera'),(880,'IT','VS','Medio Campidano'),(881,'IT','ME','Messina'),(882,'IT','MI','Milano'),(883,'IT','MO','Modena'),(884,'IT','MB','Monza-Brianza'),(885,'IT','NA','Napoli'),(886,'IT','NO','Novara'),(887,'IT','NU','Nuoro'),(888,'IT','OG','Ogliastra'),(889,'IT','OT','Olbia Tempio'),(890,'IT','OR','Oristano'),(891,'IT','PD','Padova'),(892,'IT','PA','Palermo'),(893,'IT','PR','Parma'),(894,'IT','PV','Pavia'),(895,'IT','PG','Perugia'),(896,'IT','PU','Pesaro-Urbino'),(897,'IT','PE','Pescara'),(898,'IT','PC','Piacenza'),(899,'IT','PI','Pisa'),(900,'IT','PT','Pistoia'),(901,'IT','PN','Pordenone'),(902,'IT','PZ','Potenza'),(903,'IT','PO','Prato'),(904,'IT','RG','Ragusa'),(905,'IT','RA','Ravenna'),(906,'IT','RC','Reggio-Calabria'),(907,'IT','RE','Reggio-Emilia'),(908,'IT','RI','Rieti'),(909,'IT','RN','Rimini'),(910,'IT','RM','Roma'),(911,'IT','RO','Rovigo'),(912,'IT','SA','Salerno'),(913,'IT','SS','Sassari'),(914,'IT','SV','Savona'),(915,'IT','SI','Siena'),(916,'IT','SR','Siracusa'),(917,'IT','SO','Sondrio'),(918,'IT','TA','Taranto'),(919,'IT','TE','Teramo'),(920,'IT','TR','Terni'),(921,'IT','TO','Torino'),(922,'IT','TP','Trapani'),(923,'IT','TN','Trento'),(924,'IT','TV','Treviso'),(925,'IT','TS','Trieste'),(926,'IT','UD','Udine'),(927,'IT','VA','Varese'),(928,'IT','VE','Venezia'),(929,'IT','VB','Verbania'),(930,'IT','VC','Vercelli'),(931,'IT','VR','Verona'),(932,'IT','VV','Vibo-Valentia'),(933,'IT','VI','Vicenza'),(934,'IT','VT','Viterbo'),(935,'MX','AGU','Aguascalientes'),(936,'MX','BCN','Baja California'),(937,'MX','BCS','Baja California Sur'),(938,'MX','CAM','Campeche'),(939,'MX','CHP','Chiapas'),(940,'MX','CHH','Chihuahua'),(941,'MX','CMX','Ciudad de México'),(942,'MX','COA','Coahuila'),(943,'MX','COL','Colima'),(944,'MX','DUR','Durango'),(945,'MX','MEX','Estado de México'),(946,'MX','GUA','Guanajuato'),(947,'MX','GRO','Guerrero'),(948,'MX','HID','Hidalgo'),(949,'MX','JAL','Jalisco'),(950,'MX','MIC','Michoacán'),(951,'MX','MOR','Morelos'),(952,'MX','NAY','Nayarit'),(953,'MX','NLE','Nuevo León'),(954,'MX','OAX','Oaxaca'),(955,'MX','PUE','Puebla'),(956,'MX','QUE','Querétaro'),(957,'MX','ROO','Quintana Roo'),(958,'MX','SLP','San Luis Potosí'),(959,'MX','SIN','Sinaloa'),(960,'MX','SON','Sonora'),(961,'MX','TAB','Tabasco'),(962,'MX','TAM','Tamaulipas'),(963,'MX','TLA','Tlaxcala'),(964,'MX','VER','Veracruz'),(965,'MX','YUC','Yucatán'),(966,'MX','ZAC','Zacatecas'),(967,'PY','PY-ASU','Asunción'),(968,'PY','PY-16','Alto Paraguay'),(969,'PY','PY-10','Alto Paraná'),(970,'PY','PY-13','Amambay'),(971,'PY','PY-19','Boquerón'),(972,'PY','PY-5','Caaguazú'),(973,'PY','PY-6','Caazapá'),(974,'PY','PY-14','Canindeyú'),(975,'PY','PY-11','Central'),(976,'PY','PY-1','Concepción'),(977,'PY','PY-3','Cordillera'),(978,'PY','PY-4','Guairá'),(979,'PY','PY-7','Itapúa'),(980,'PY','PY-8','Misiones'),(981,'PY','PY-12','Ñeembucú'),(982,'PY','PY-9','Paraguarí'),(983,'PY','PY-15','Presidente Hayes'),(984,'PY','PY-2','San Pedro'),(985,'PE','PE-LMA','Municipalidad Metropolitana de Lima'),(986,'PE','PE-AMA','Amazonas'),(987,'PE','PE-ANC','Ancash'),(988,'PE','PE-APU','Apurímac'),(989,'PE','PE-ARE','Arequipa'),(990,'PE','PE-AYA','Ayacucho'),(991,'PE','PE-CAJ','Cajamarca'),(992,'PE','PE-CUS','Cusco'),(993,'PE','PE-CAL','El Callao'),(994,'PE','PE-HUV','Huancavelica'),(995,'PE','PE-HUC','Huánuco'),(996,'PE','PE-ICA','Ica'),(997,'PE','PE-JUN','Junín'),(998,'PE','PE-LAL','La Libertad'),(999,'PE','PE-LAM','Lambayeque'),(1000,'PE','PE-LIM','Lima'),(1001,'PE','PE-LOR','Loreto'),(1002,'PE','PE-MDD','Madre de Dios'),(1003,'PE','PE-MOQ','Moquegua'),(1004,'PE','PE-PAS','Pasco'),(1005,'PE','PE-PIU','Piura'),(1006,'PE','PE-PUN','Puno'),(1007,'PE','PE-SAM','San Martín'),(1008,'PE','PE-TAC','Tacna'),(1009,'PE','PE-TUM','Tumbes'),(1010,'PE','PE-UCA','Ucayali'),(1011,'PL','PL-02','dolnośląskie'),(1012,'PL','PL-04','kujawsko-pomorskie'),(1013,'PL','PL-06','lubelskie'),(1014,'PL','PL-08','lubuskie'),(1015,'PL','PL-10','łódzkie'),(1016,'PL','PL-12','małopolskie'),(1017,'PL','PL-14','mazowieckie'),(1018,'PL','PL-16','opolskie'),(1019,'PL','PL-18','podkarpackie'),(1020,'PL','PL-20','podlaskie'),(1021,'PL','PL-22','pomorskie'),(1022,'PL','PL-24','śląskie'),(1023,'PL','PL-26','świętokrzyskie'),(1024,'PL','PL-28','warmińsko-mazurskie'),(1025,'PL','PL-30','wielkopolskie'),(1026,'PL','PL-32','zachodniopomorskie'),(1027,'PT','PT-01','Aveiro'),(1028,'PT','PT-02','Beja'),(1029,'PT','PT-03','Braga'),(1030,'PT','PT-04','Bragança'),(1031,'PT','PT-05','Castelo Branco'),(1032,'PT','PT-06','Coimbra'),(1033,'PT','PT-07','Évora'),(1034,'PT','PT-08','Faro'),(1035,'PT','PT-09','Guarda'),(1036,'PT','PT-10','Leiria'),(1037,'PT','PT-11','Lisboa'),(1038,'PT','PT-12','Portalegre'),(1039,'PT','PT-13','Porto'),(1040,'PT','PT-14','Santarém'),(1041,'PT','PT-15','Setúbal'),(1042,'PT','PT-16','Viana do Castelo'),(1043,'PT','PT-17','Vila Real'),(1044,'PT','PT-18','Viseu'),(1045,'PT','PT-20','Região Autónoma dos Açores'),(1046,'PT','PT-30','Região Autónoma da Madeira'),(1047,'SR','SR-BR','Brokopondo'),(1048,'SR','SR-CM','Commewijne'),(1049,'SR','SR-CR','Coronie'),(1050,'SR','SR-MA','Marowijne'),(1051,'SR','SR-NI','Nickerie'),(1052,'SR','SR-PR','Para'),(1053,'SR','SR-PM','Paramaribo'),(1054,'SR','SR-SA','Saramacca'),(1055,'SR','SR-SI','Sipaliwini'),(1056,'SR','SR-WA','Wanica'),(1057,'SE','SE-K','Blekinge län'),(1058,'SE','SE-W','Dalarnas län'),(1059,'SE','SE-I','Gotlands län'),(1060,'SE','SE-X','Gävleborgs län'),(1061,'SE','SE-N','Hallands län'),(1062,'SE','SE-Z','Jämtlands län'),(1063,'SE','SE-F','Jönköpings län'),(1064,'SE','SE-H','Kalmar län'),(1065,'SE','SE-G','Kronobergs län'),(1066,'SE','SE-BD','Norrbottens län'),(1067,'SE','SE-M','Skåne län'),(1068,'SE','SE-AB','Stockholms län'),(1069,'SE','SE-D','Södermanlands län'),(1070,'SE','SE-C','Uppsala län'),(1071,'SE','SE-S','Värmlands län'),(1072,'SE','SE-AC','Västerbottens län'),(1073,'SE','SE-Y','Västernorrlands län'),(1074,'SE','SE-U','Västmanlands län'),(1075,'SE','SE-O','Västra Götalands län'),(1076,'SE','SE-T','Örebro län'),(1077,'SE','SE-E','Östergötlands län'),(1078,'UY','UY-AR','Artigas'),(1079,'UY','UY-CA','Canelones'),(1080,'UY','UY-CL','Cerro Largo'),(1081,'UY','UY-CO','Colonia'),(1082,'UY','UY-DU','Durazno'),(1083,'UY','UY-FS','Flores'),(1084,'UY','UY-FD','Florida'),(1085,'UY','UY-LA','Lavalleja'),(1086,'UY','UY-MA','Maldonado'),(1087,'UY','UY-MO','Montevideo'),(1088,'UY','UY-PA','Paysandu'),(1089,'UY','UY-RN','Río Negro'),(1090,'UY','UY-RV','Rivera'),(1091,'UY','UY-RO','Rocha'),(1092,'UY','UY-SA','Salto'),(1093,'UY','UY-SJ','San José'),(1094,'UY','UY-SO','Soriano'),(1095,'UY','UY-TA','Tacuarembó'),(1096,'UY','UY-TT','Treinta y Tres'),(1097,'VE','VE-W','Dependencias Federales'),(1098,'VE','VE-A','Distrito Capital'),(1099,'VE','VE-Z','Amazonas'),(1100,'VE','VE-B','Anzoátegui'),(1101,'VE','VE-C','Apure'),(1102,'VE','VE-D','Aragua'),(1103,'VE','VE-E','Barinas'),(1104,'VE','VE-F','Bolívar'),(1105,'VE','VE-G','Carabobo'),(1106,'VE','VE-H','Cojedes'),(1107,'VE','VE-Y','Delta Amacuro'),(1108,'VE','VE-I','Falcón'),(1109,'VE','VE-J','Guárico'),(1110,'VE','VE-K','Lara'),(1111,'VE','VE-L','Mérida'),(1112,'VE','VE-M','Miranda'),(1113,'VE','VE-N','Monagas'),(1114,'VE','VE-O','Nueva Esparta'),(1115,'VE','VE-P','Portuguesa'),(1116,'VE','VE-R','Sucre'),(1117,'VE','VE-S','Táchira'),(1118,'VE','VE-T','Trujillo'),(1119,'VE','VE-X','Vargas'),(1120,'VE','VE-U','Yaracuy'),(1121,'VE','VE-V','Zulia');

--
