-- Dumping data for table `mag2_catalogrule_product`
--


--
-- Table structure for table `mag2_catalogrule_product_price`
--

CREATE TABLE `mag2_catalogrule_product_price` (
  `rule_product_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Product PriceId',
  `rule_date` date NOT NULL COMMENT 'Rule Date',
  `customer_group_id` int(11) DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `rule_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Rule Price',
  `website_id` smallint(5) 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 `MAG2_CATRULE_PRD_PRICE_RULE_DATE_WS_ID_CSTR_GROUP_ID_PRD_ID` (`rule_date`,`website_id`,`customer_group_id`,`product_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_PRICE_WEBSITE_ID` (`website_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_PRICE_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CatalogRule Product Price';

--
-- Dumping data for table `mag2_catalogrule_product_price`
--


--
-- Table structure for table `mag2_catalogrule_product_price_replica`
--

CREATE TABLE `mag2_catalogrule_product_price_replica` (
  `rule_product_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Product PriceId',
  `rule_date` date NOT NULL COMMENT 'Rule Date',
  `customer_group_id` int(11) DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `rule_price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Rule Price',
  `website_id` smallint(5) 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 `MAG2_CATRULE_PRD_PRICE_RULE_DATE_WS_ID_CSTR_GROUP_ID_PRD_ID` (`rule_date`,`website_id`,`customer_group_id`,`product_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_PRICE_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_PRICE_WEBSITE_ID` (`website_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_PRICE_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CatalogRule Product Price';

--
-- Dumping data for table `mag2_catalogrule_product_price_replica`
--


--
-- Table structure for table `mag2_catalogrule_product_replica`
--

CREATE TABLE `mag2_catalogrule_product_replica` (
  `rule_product_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Rule Product Id',
  `rule_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Rule Id',
  `from_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'From Time',
  `to_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'To time',
  `customer_group_id` int(11) DEFAULT NULL,
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product Id',
  `action_operator` varchar(10) DEFAULT 'to_fixed' COMMENT 'Action Operator',
  `action_amount` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Action Amount',
  `action_stop` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Action Stop',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  PRIMARY KEY (`rule_product_id`),
  UNIQUE KEY `IDX_A6EDF2814724CD076C48246480E03265` (`rule_id`,`from_time`,`to_time`,`website_id`,`customer_group_id`,`product_id`,`sort_order`),
  KEY `MAG2_CATALOGRULE_PRODUCT_CUSTOMER_GROUP_ID` (`customer_group_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_WEBSITE_ID` (`website_id`),
  KEY `MAG2_CATALOGRULE_PRODUCT_FROM_TIME` (`from_time`),
  KEY `MAG2_CATALOGRULE_PRODUCT_TO_TIME` (`to_time`),
  KEY `MAG2_CATALOGRULE_PRODUCT_PRODUCT_ID` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CatalogRule Product';

--
-- Dumping data for table `mag2_catalogrule_product_replica`
--


--
-- Table structure for table `mag2_catalogrule_website`
--

CREATE TABLE `mag2_catalogrule_website` (
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  PRIMARY KEY (`rule_id`,`website_id`),
  KEY `MAG2_CATALOGRULE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `MAG2_CATALOGRULE_WEBSITE_RULE_ID_CATALOGRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `mag2_catalogrule` (`rule_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CATALOGRULE_WEBSITE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `mag2_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Rules To Websites Relations';

--
-- Dumping data for table `mag2_catalogrule_website`
--

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

--
-- Table structure for table `mag2_catalogsearch_fulltext_scope1`
--

CREATE TABLE `mag2_catalogsearch_fulltext_scope1` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` int(10) unsigned NOT NULL COMMENT 'Attribute_id',
  `data_index` longtext COMMENT 'Data index',
  PRIMARY KEY (`entity_id`,`attribute_id`),
  FULLTEXT KEY `FTI_FULLTEXT_DATA_INDEX` (`data_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_catalogsearch_fulltext_scope1_tmp';

--
-- Dumping data for table `mag2_catalogsearch_fulltext_scope1`
--

INSERT INTO `mag2_catalogsearch_fulltext_scope1` VALUES (1,73,'Moisture Lock Conditioner 250 ML'),(1,74,'10004-1'),(1,75,'Conditioner fortified with AMINO BOND COMPLEX'),(1,180,'Nika'),(1,181,'A'),(1,183,'250 ML'),(9,73,'Pure Keratin Reconstructing Shampoo 1000 ML'),(9,74,'50003'),(9,75,'Reconstructing Shampoo, fortified with KEROXYNE COMPLEX.'),(9,180,'Nika'),(9,183,'1000 ML'),(10,73,'Shimmer 30 ML'),(10,74,'10006-2'),(10,75,'Anti-frizz Serum with Aragn Oil and Amino Bond Complex'),(10,180,'Nika'),(10,181,'A'),(10,183,'50 ML'),(11,73,'Enhancer Masque 500 ML'),(11,74,'10005-2'),(11,75,'The 500ml Enhancer mask is fortified with AMINO BOND COMPLEX technology, a unique formula of amino acids, hydrolyzed keratin and active ingredients, for a smooth and anti-frizz effect.'),(11,180,'Nika'),(11,181,'A'),(11,183,'500 ML'),(15,73,'Timless Blend Masque 500 ML'),(15,74,'40005-1'),(15,75,'Anti-ageing moisturizer mask for dry hair with Reborn Complex,an exclusive blend of Hyaluronic Acid, A\'achi and moisturizers. It cleans gently giving hydration, softness and shine.'),(15,180,'Nika'),(15,182,'Women'),(15,183,'500 ML'),(16,73,'Miracle Rapid Repair Hair Treatment 100 ML'),(16,74,'50008'),(16,75,'Its formula keroxyne complex is an indispensable ally for damaged hair, thanks to its exclusive mixture consists of pure keratin which allows the product to saldarsi cheratinica structure of the hair making it the best of reconstruction capillary technology ever produced'),(16,180,'Nika'),(16,181,'A'),(16,183,'100 ML'),(17,73,'Timless Blend Shampoo 250 ML'),(17,74,'40003'),(17,75,'Moisturizing anti-age shampoo for dry hair with REBORN COMPLEX.'),(17,180,'Nika'),(17,181,'A'),(17,182,'Women'),(17,183,'250 ML'),(18,73,'Moisture Lock Shampoo 250 ML'),(18,74,'10003-1'),(18,75,'Shampoo for frizzy hair enriched with SEVEN OILS and COLOR GUARD, the new active ingredient for a bright and lasting color. Gently cleanses giving a smooth and anti-frizz effect.'),(18,180,'Nika'),(18,181,'A'),(18,182,'Women'),(18,183,'250 ML'),(20,73,'Pure Keratin Reconstructing Conditioner 1000 ML'),(20,74,'50004'),(20,75,'Reconstructing Conditioner, fortified with KEROXYNE COMPLEX.'),(20,180,'Nika'),(20,181,'A'),(20,183,'1000 ML'),(21,73,'Timless Blend Shampoo 1000 ML'),(21,74,'40003-1'),(21,75,'Moisturizing anti-age shampoo for dry hair with REBORN COMPLEX.'),(21,180,'Nika'),(21,181,'A'),(21,182,'Women'),(21,183,'1000 ML'),(22,73,'Moisture Lock Shampoo 1000 ML'),(22,74,'10003'),(22,75,'Shampoo for frizzy hair enriched with SEVEN OILS and COLOR GUARD, the new active ingredient for a bright and lasting color. Gently cleanses giving a smooth and anti-frizz effect.'),(22,180,'Nika'),(22,181,'A'),(22,182,'Women'),(22,183,'1000 ML'),(23,73,'Deep Intense Hydrating Masque 500 ML'),(23,74,'50005-1'),(23,75,'The Deep Intense mask is ideal for damaged hair. Formulated with KEROXYNE COMPLEX technology, an exclusive blend of pure keratin, it gently nourishes hair by improving its elasticity, resistance and shine. It was specifically created to complement the KPerfection reconstruction treatment.'),(23,180,'Nika'),(23,183,'500 ML'),(24,73,'Timless Blend Conditioner 1000 ML'),(24,74,'40004-1'),(24,75,'Moisturizing anti-age Conditioner for dry hair with REBORN COMPLEX.'),(24,180,'Nika'),(24,181,'A'),(24,182,'Women'),(24,183,'1000 ML'),(25,73,'Moisture Lock Conditioner 1000 ML'),(25,74,'10004'),(25,75,'Conditioner fortified with AMINO BOND COMPLEX'),(25,180,'Nika'),(25,181,'A'),(25,182,'Women'),(25,183,'1000 ML'),(26,73,'Extender 90 ML'),(26,74,'10011-3'),(26,180,'Nika'),(26,183,'60 ML'),(27,73,'Timless Blend Conditioner 250 ML'),(27,74,'40004'),(27,75,'Moisturizing anti-age Conditioner for dry hair with REBORN COMPLEX.'),(27,180,'Nika'),(27,183,'250 ML'),(28,73,'Timless Blend Masque 250 ML'),(28,74,'40005-2'),(28,75,'Anti-ageing moisturizer mask for dry hair with Reborn Complex, an exclusive blend of Hyaluronic Acid, A\'achi and moisturizers. It cleans gently giving hydration, softness and shine.'),(28,180,'Nika'),(28,181,'A'),(28,182,'Women'),(28,183,'250 ML'),(29,73,'Pure Keratin Reconstructing Shampoo 250 ML'),(29,74,'50003-1'),(29,75,'Reconstructing Shampoo, fortified with KEROXYNE COMPLEX.'),(29,180,'Nika'),(29,181,'A'),(29,183,'250 ML'),(30,73,'Pure Keratin Reconstructing Conditioner 250 ML'),(30,74,'50004-1'),(30,75,'Pure Keratin Reconstructing Conditioner 250 ML'),(30,180,'Nika'),(30,181,'A'),(30,183,'250 ML'),(31,73,'Age Restore Package - 1000 ml'),(31,74,'6'),(31,75,'Age Restore Package: Shampoo + Conditioner + Serum 1000 ml'),(31,180,'Nika'),(31,181,'A'),(31,182,'Women'),(31,183,'1000 ML'),(33,73,'K-Perfection Package - 250ml'),(33,74,'1'),(33,75,'K-Perfection Package: Shampoo + Conditioner + Serum'),(33,180,'Nika'),(33,181,'A'),(33,182,'Women'),(33,183,'250 ML'),(34,73,'K-Perfection Package - 1000 ml'),(34,74,'2'),(34,75,'K-Perfection Package: Shampoo + Conditioner + Serum 1000ml'),(34,180,'Nika'),(34,181,'A'),(34,182,'Women'),(34,183,'1000 ML'),(35,73,'Fairy Silk Package - 1000ml'),(35,74,'4'),(35,75,'Fairy Silk Package: Shampoo + Conditioner + Serum 1000ml'),(35,180,'Nika'),(35,183,'1000 ML');

--
-- Table structure for table `mag2_catalogsearch_fulltext_scope2`
--

CREATE TABLE `mag2_catalogsearch_fulltext_scope2` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `attribute_id` int(10) unsigned NOT NULL COMMENT 'Attribute_id',
  `data_index` longtext COMMENT 'Data index',
  PRIMARY KEY (`entity_id`,`attribute_id`),
  FULLTEXT KEY `FTI_FULLTEXT_DATA_INDEX` (`data_index`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_catalogsearch_fulltext_scope2_tmp';

--
-- Dumping data for table `mag2_catalogsearch_fulltext_scope2`
--

INSERT INTO `mag2_catalogsearch_fulltext_scope2` VALUES (1,73,'بلسم مويستشر لوك 250 مل'),(1,74,'10004-1'),(1,75,'بلسم مدعم بأمينو بوند كومبلكس'),(1,180,'Nika'),(1,181,'A'),(1,183,'250 ML'),(9,73,'شامبو بيور كيراتين لإعادة بناء الشعر 1000 مل'),(9,74,'50003'),(9,75,'شامبو لإعادة بناء الشعر ، معزز بـ KEROXYNE COMPLEX.'),(9,180,'Nika'),(9,183,'1000 ML'),(10,73,'شيمر 30 مل'),(10,74,'10006-2'),(10,75,'سيروم مضاد للتجعد بزيت الأرغان ومركب أمينو بوند'),(10,180,'Nika'),(10,181,'A'),(10,183,'50 ML'),(11,73,'قناع محسن 500 مل'),(11,74,'10005-2'),(11,75,'قناع مُحسّن سعة 500 مل مُعزز بتقنية AMINO BOND COMPLEX ، وهي تركيبة فريدة من الأحماض الأمينية والكيراتين المتحلل بالماء والمكونات النشطة ، للحصول على تأثير سلس ومقاوم للتجعد.'),(11,180,'Nika'),(11,181,'A'),(11,183,'500 ML'),(15,73,'تايمليس بليند ماسك 500 مل'),(15,74,'40005-1'),(15,75,'قناع مرطب مضاد للشيخوخة للشعر الجاف مع مركب Reborn ، مزيج حصري من Hyaluronic Acid و A\'achi والمرطبات. ينظف بلطف ويعطي الترطيب والنعومة واللمعان.'),(15,180,'Nika'),(15,182,'نسائي'),(15,183,'500 ML'),(16,73,'علاج الشعر ميراكل رابيد ريبير 100 مل'),(16,74,'50008'),(16,75,'تركيبة مركب keroxyne هي حليف لا غنى عنه للشعر التالف ، وذلك بفضل مزيجها الحصري المكون من الكيراتين النقي الذي يسمح للمنتج بتركيبة saldarsi cheratinica للشعر مما يجعلها أفضل تقنية لإعادة بناء الشعيرات الدموية تم إنتاجها على الإطلاق.'),(16,180,'Nika'),(16,181,'A'),(16,183,'100 ML'),(17,73,'شامبو تايملس بليند 250 مل'),(17,74,'40003'),(17,75,'شامبو مرطب مضاد للشيخوخة للشعر الجاف مع REBORN COMPLEX.'),(17,180,'Nika'),(17,181,'A'),(17,182,'نسائي'),(17,183,'250 ML'),(18,73,'شامبو مويستشر لوك 250 مل'),(18,74,'10003-1'),(18,75,'شامبو للشعر المجعد المخصب بزيوت سبعة وخزان ملون ، المكون النشط الجديد للحصول على لون لامع ودائم. ينظف بلطف ويعطي تأثيرًا سلسًا ومقاومًا للتجعد.'),(18,180,'Nika'),(18,181,'A'),(18,182,'نسائي'),(18,183,'250 ML'),(20,73,'بلسم بيور كيراتين لإعادة بناء الشعر 1000 مل'),(20,74,'50004'),(20,75,'بلسم لإعادة البناء مدعم بـ KEROXYNE COMPLEX.'),(20,180,'Nika'),(20,181,'A'),(20,183,'1000 ML'),(21,73,'شامبو تايملس بليند 1000 مل'),(21,74,'40003-1'),(21,75,'شامبو مرطب مضاد للشيخوخة للشعر الجاف مع REBORN COMPLEX.'),(21,180,'Nika'),(21,181,'A'),(21,182,'نسائي'),(21,183,'1000 ML'),(22,73,'شامبو مويستشر لوك 1000 مل'),(22,74,'10003'),(22,75,'شامبو للشعر المجعد المخصب بزيوت سبعة وخزان ملون ، المكون النشط الجديد للحصول على لون لامع ودائم. ينظف بلطف ويعطي تأثيرًا سلسًا ومقاومًا للتجعد.'),(22,180,'Nika'),(22,181,'A'),(22,182,'نسائي'),(22,183,'1000 ML'),(23,73,'قناع ترطيب مكثف عميق 500 مل'),(23,74,'50005-1'),(23,75,'القناع المكثف العميق مثالي للشعر التالف. تم تركيبه باستخدام تقنية KEROXYNE COMPLEX ، وهي مزيج حصري من الكيراتين النقي ، وهو يغذي الشعر بلطف من خلال تحسين مرونته ومقاومته ولمعانه. تم إنشاؤه خصيصًا لاستكمال علاج إعادة بناء KPerfection.'),(23,180,'Nika'),(23,183,'500 ML'),(24,73,'بلسم تايملس بليند 1000 مل'),(24,74,'40004-1'),(24,75,'بلسم مرطب مضاد لعلامات تقدم العمر للشعر الجاف مع REBORN COMPLEX.'),(24,180,'Nika'),(24,181,'A'),(24,182,'نسائي'),(24,183,'1000 ML'),(25,73,'بلسم قفل الرطوبة 1000 مل'),(25,74,'10004'),(25,75,'بلسم مدعم بأمينو بوند كومبلكس'),(25,180,'Nika'),(25,181,'A'),(25,182,'نسائي'),(25,183,'1000 ML'),(26,73,'موسع 90 مل'),(26,74,'10011-3'),(26,180,'Nika'),(26,183,'60 ML'),(27,73,'بلسم تايمليس بليند 250 مل'),(27,74,'40004'),(27,75,'بلسم مرطب مضاد لعلامات تقدم العمر للشعر الجاف مع REBORN COMPLEX.'),(27,180,'Nika'),(27,183,'250 ML'),(28,73,'تايمليس بليند ماسك 250 مل'),(28,74,'40005-2'),(28,75,'قناع مرطب مضاد للشيخوخة للشعر الجاف مع مركب Reborn ، مزيج حصري من Hyaluronic Acid و A\'achi والمرطبات. ينظف بلطف ويعطي الترطيب والنعومة واللمعان.'),(28,180,'Nika'),(28,181,'A'),(28,182,'نسائي'),(28,183,'250 ML'),(29,73,'شامبو بيور كيراتين لإعادة بناء الشعر 250 مل'),(29,74,'50003-1'),(29,75,'شامبو لإعادة بناء الشعر ، معزز بـ KEROXYNE COMPLEX.'),(29,180,'Nika'),(29,181,'A'),(29,183,'250 ML'),(30,73,'بلسم بيور كيراتين لإعادة بناء الشعر 250 مل'),(30,74,'50004-1'),(30,75,'بلسم بيور كيراتين لإعادة بناء الشعر 250 مل'),(30,180,'Nika'),(30,181,'A'),(30,183,'250 ML'),(31,73,'Age Restore Package - 1000 ml'),(31,74,'6'),(31,75,'Age Restore Package: Shampoo + Conditioner + Serum 1000 ml'),(31,180,'Nika'),(31,181,'A'),(31,182,'نسائي'),(31,183,'1000 ML'),(33,73,'K-Perfection Package - 250ml'),(33,74,'1'),(33,75,'K-Perfection Package: Shampoo + Conditioner + Serum'),(33,180,'Nika'),(33,181,'A'),(33,182,'نسائي'),(33,183,'250 ML'),(34,73,'K-Perfection Package - 1000 ml'),(34,74,'2'),(34,75,'K-Perfection Package: Shampoo + Conditioner + Serum 1000ml'),(34,180,'Nika'),(34,181,'A'),(34,182,'نسائي'),(34,183,'1000 ML'),(35,73,'Fairy Silk Package - 1000ml'),(35,74,'4'),(35,75,'Fairy Silk Package: Shampoo + Conditioner + Serum 1000ml'),(35,180,'Nika'),(35,183,'1000 ML');

--
-- Table structure for table `mag2_checkout_agreement`
--

CREATE TABLE `mag2_checkout_agreement` (
  `agreement_id` int(10) 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(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `is_html` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Html',
  `mode` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Applied mode',
  PRIMARY KEY (`agreement_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Checkout Agreement';

--
-- Dumping data for table `mag2_checkout_agreement`
--


--
-- Table structure for table `mag2_checkout_agreement_store`
--

CREATE TABLE `mag2_checkout_agreement_store` (
  `agreement_id` int(10) unsigned NOT NULL COMMENT 'Agreement Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  PRIMARY KEY (`agreement_id`,`store_id`),
  KEY `MAG2_CHECKOUT_AGREEMENT_STORE_STORE_ID_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_CHECKOUT_AGREEMENT_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CHKT_AGRT_STORE_AGRT_ID_CHKT_AGRT_AGRT_ID` FOREIGN KEY (`agreement_id`) REFERENCES `mag2_checkout_agreement` (`agreement_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Checkout Agreement Store';

--
-- Dumping data for table `mag2_checkout_agreement_store`
--


--
-- Table structure for table `mag2_cms_block`
--

CREATE TABLE `mag2_cms_block` (
  `block_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Block 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(6) NOT NULL DEFAULT '1' COMMENT 'Is Block Active',
  PRIMARY KEY (`block_id`),
  FULLTEXT KEY `MAG2_CMS_BLOCK_TITLE_IDENTIFIER_CONTENT` (`title`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8 COMMENT='CMS Block Table';

--
-- Dumping data for table `mag2_cms_block`
--

INSERT INTO `mag2_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','2021-11-10 08:17:23','2021-11-13 13:46:08',0),(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','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(14,'Home Page Block','home-page-block','<div class=\"blocks-promo\">\n   <a href=\"{{store url=\"\"}}collections/yoga-new.html\" class=\"block-promo home-main\">\n       <img src=\"{{media url=\"wysiwyg/home/home-main.jpg\"}}\" alt=\"\" />\n       <span class=\"content bg-white\">\n           <span class=\"info\">New Luma Yoga Collection</span>\n           <strong class=\"title\">Get fit and look fab in new seasonal styles</strong>\n           <span class=\"action more button\">Shop New Yoga</span>\n       </span>\n   </a>\n   <div class=\"block-promo-wrapper block-promo-hp\">\n       <a href=\"{{store url=\"\"}}promotions/pants-all.html\" class=\"block-promo home-pants\">\n           <img src=\"{{media url=\"wysiwyg/home/home-pants.jpg\"}}\" alt=\"\" />\n           <span class=\"content\">\n               <strong class=\"title\">20% OFF</strong>\n               <span class=\"info\">Luma pants when you shop today*</span>\n               <span class=\"action more icon\">Shop Pants</span>\n           </span>\n       </a>\n       <a href=\"{{store url=\"\"}}promotions/tees-all.html\" class=\"block-promo home-t-shirts\">\n           <span class=\"image\"><img src=\"{{media url=\"wysiwyg/home/home-t-shirts.png\"}}\" alt=\"\" /></span>\n           <span class=\"content\">\n               <strong class=\"title\">Even more ways to mix and match</strong>\n               <span class=\"info\">Buy 3 Luma tees get a 4th free</span>\n               <span class=\"action more icon\">Shop Tees</span>\n           </span>\n       </a>\n       <a href=\"{{store url=\"\"}}collections/erin-recommends.html\" class=\"block-promo home-erin\">\n           <img src=\"{{media url=\"wysiwyg/home/home-erin.jpg\"}}\" alt=\"\" />\n           <span class=\"content\">\n               <strong class=\"title\">Take it from Erin</strong>\n               <span class=\"info\">Luma founder Erin Renny shares her favorites!</span>\n               <span class=\"action more icon\">Shop Erin Recommends</span>\n           </span>\n       </a>\n       <a href=\"{{store url=\"\"}}collections/performance-fabrics.html\" class=\"block-promo home-performance\">\n           <img src=\"{{media url=\"wysiwyg/home/home-performance.jpg\"}}\" alt=\"\" />\n           <span class=\"content bg-white\">\n               <strong class=\"title\">Science meets performance</strong>\n               <span class=\"info\">Wicking to raingear, Luma covers&nbsp;you</span>\n               <span class=\"action more icon\">Shop Performance</span>\n           </span>\n       </a>\n       <a href=\"{{store url=\"\"}}collections/eco-friendly.html\" class=\"block-promo home-eco\">\n           <img src=\"{{media url=\"wysiwyg/home/home-eco.jpg\"}}\" alt=\"\" />\n           <span class=\"content bg-white\">\n               <strong class=\"title\">Twice around, twice as nice</strong>\n               <span class=\"info\">Find conscientious, comfy clothing in our <nobr>eco-friendly</nobr> collection</span>\n               <span class=\"action more icon\">Shop Eco-Friendly</span>\n           </span>\n       </a>\n   </div>\n</div>\n<div class=\"content-heading\">\n   <h2 class=\"title\">Hot Sellers</h2>\n   <p class=\"info\">Here is what`s trending on Luma right now</p>\n</div>\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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(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`^]^]\"}}','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(17,'Giftcard Block','giftcard-block','<div class=\"blocks-promo\">\n    <div class=\"block-promo-wrapper block-promo-2columns\">\n        <a href=\"{{store url=\"\"}}\" class=\"block-promo giftcard-mailed\">\n            <span class=\"content\">\n                <strong class=\"title\">Give it away now</strong>\n                <span class=\"info\">A gift card always beats a blind guess</span>\n                <span class=\"more icon\">Mailed Gift Cards</span>\n            </span>\n            <span class=\"image\"><img src=\"{{media url=\"wysiwyg/giftcards/giftcard-mailed.jpg\"}}\" alt=\"\" /></span>\n        </a>\n        <a href=\"{{store url=\"\"}}\" class=\"block-promo giftcard-virtual\">\n            <img src=\"{{media url=\"wysiwyg/giftcards/giftcard-virtual.png\"}}\" alt=\"\" />\n            <span class=\"content\">\n                <strong class=\"title\">Can\'t decide?</strong>\n                <span class=\"info\">Just remember it\'s the card that counts</span>\n                <span class=\"more icon\">Virtual Gift Cards</span>\n            </span>\n        </a>\n    </div>\n</div>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(18,'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>','2021-11-10 08:17:23','2021-11-13 13:46:09',0),(19,'Footer Links English','ys_footer_links','<div class=\"tt-mobile-collapse\">\r\n<h4 class=\"tt-collapse-title\">Customer Services</h4>\r\n<div class=\"tt-collapse-content\">\r\n<ul class=\"tt-list\">\r\n<li><a href=\"{{store url=\"sales/order/history\"}}\">My Account</a></li>\r\n<li><a href=\"{{store url=\"catalog/product_compare/index/\"}}\">Compare</a></li>\r\n<li><a href=\"{{store url=\"wishlist\"}}\">Wishlist</a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}delivery-information\">Delivery Information </a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}cancelation-and-refund-policy\">Cancelation and Refund Policy</a></li>\r\n</ul>\r\n</div>\r\n</div>','2021-11-13 13:46:50','2021-11-13 13:46:50',1),(20,'Footer Contacts','ys_footer_contacts','<p>k</p>','2021-11-13 13:47:49','2021-11-13 13:47:49',1),(21,'Footer About','ys_footer_about','<div class=\"tt-mobile-collapse\">\r\n<h4 class=\"tt-collapse-title\">ABOUT</h4>\r\n<div class=\"tt-collapse-content\">\r\n<p>Lorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore. Lorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore.</p>\r\n</div>\r\n</div>','2021-11-13 13:48:17','2021-11-13 13:48:17',1),(22,'Header Info','ys_header_info','<div class=\"tt-box-info\">\r\n<ul>\r\n<li><i class=\"icon-f-93\"></i>Delivery within 1 Day</li>\r\n<li><i class=\"icon-f-92\"></i>7 Days a week from 9am to 4pm</li>\r\n</ul>\r\n</div>','2021-11-13 13:48:51','2021-11-13 13:48:51',1),(23,'our offers','our_offers_products','<p>{{block class=\"Magento\\Catalog\\Block\\Product\\ListProduct\" template=\"Ecomwares_Wokiee::homepage/our_offers.phtml\" limit=\"8\" }}</p>','2021-11-13 13:49:47','2021-11-13 13:49:47',1),(24,'new in products','new in products','<p>{{block class=\"Magento\\Catalog\\Block\\Product\\ListProduct\" template=\"Ecomwares_Wokiee::homepage/new_in.phtml\" limit=\"8\"}}</p>','2021-11-13 13:50:15','2021-11-13 13:50:15',1),(25,'best sellers product','best_seller_products','<p>{{block class=\"Magento\\Catalog\\Block\\Product\\ListProduct\" template=\"Ecomwares_Wokiee::homepage/best_seller.phtml\" limit=\"8\"}}</p>','2021-11-13 13:50:43','2021-11-13 13:50:43',1),(26,'Contact us info block','contact_us_info','<div class=\"tt-contact02-col-list\">\r\n<div class=\"row\">\r\n<div class=\"col-sm-12 col-md-4 ml-sm-auto mr-sm-auto\">\r\n<div class=\"tt-contact-info\"><i class=\"tt-icon icon-f-93\"></i>\r\n<h6 class=\"tt-title\">LET’S HAVE A CHAT!</h6>\r\n<address>99994241, 55921477, 66225655, 25617712, 25617713<br /><br /></address></div>\r\n</div>\r\n<div class=\"col-sm-6 col-md-4\">\r\n<div class=\"tt-contact-info\"><i class=\"tt-icon icon-f-24\"></i>\r\n<h6 class=\"tt-title\">VISIT OUR LOCATION</h6>\r\n<address>Kuwait City <br />Salmiya, Block 11 </address></div>\r\n</div>\r\n<div class=\"col-sm-6 col-md-4\">\r\n<div class=\"tt-contact-info\"><i class=\"tt-icon icon-f-92\"></i>\r\n<h6 class=\"tt-title\">WORK TIME</h6>\r\n<address>6 Days a week<br /> From 10 AM to 8 PM</address></div>\r\n</div>\r\n</div>\r\n</div>','2021-11-13 13:51:12','2021-11-13 13:51:12',1),(27,'Footer About Arabic','ys_footer_about','<div class=\"tt-mobile-collapse\">\r\n<h4 class=\"tt-collapse-title\">معلومات عنا</h4>\r\n<div class=\"tt-collapse-content\">\r\n<p>معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا معلومات عنا </p>\r\n</div>\r\n</div>','2021-11-13 13:52:02','2021-11-13 13:52:02',1),(28,'Footer Links Arabic','ys_footer_links','<div class=\"tt-mobile-collapse\">\r\n<h4 class=\"tt-collapse-title\">خدمة العملاء</h4>\r\n<div class=\"tt-collapse-content\">\r\n<ul class=\"tt-list\">\r\n<li><a href=\"{{store url=\"sales/order/history\"}}\">حسابي</a></li>\r\n<li><a href=\"{{store url=\"catalog/product_compare/index\"}}\">مقارنة</a></li>\r\n<li><a href=\"{{store url=\"wishlist\"}}\">قائمة التمني</a></li>\r\n<li><a href=\"{{store url=\"delivery-information_ar\"}}\">معلومات التوصيل</a></li>\r\n<li><a href=\"{{store url=\"cancelation-and-refund-policy_ar\"}}\">سياسة التبديل والاسترجاع</a></li>\r\n</ul>\r\n</div>\r\n</div>','2021-11-13 13:52:33','2021-11-13 13:52:33',1),(29,'new in products','new_in_products','<p>{{block class=\"Magento\\Catalog\\Block\\Product\\ListProduct\" template=\"Ecomwares_Wokiee::homepage/new_in.phtml\" limit=\"8\"}}</p>','2021-11-13 14:43:01','2021-11-13 14:43:01',1),(30,'services free shipping / support / 30 day delivery / 100 payment','footer_services_line','<div class=\"container-indent\">\r\n<div class=\"container\">\r\n<div class=\"row tt-services-listing\">\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-f-48\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">DELIVERY FEES</h4>\r\n<p>Delivery Fees 2 KD, Free Delivery on orders above 50 KD</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-f-35\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">SUPPORT</h4>\r\n<p>Contact us, 7 days a week</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-e-09\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">NO RETURN</h4>\r\n<p>No Return or Exchange Available</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-f-76\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">100% PAYMENT SECURE</h4>\r\n<p>We ensure secure payment with PEV</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','2021-11-13 14:44:36','2021-11-13 14:44:36',1),(31,'services free shipping / support / 30 day delivery / 100 payment arabic','footer_services_line','<div class=\"container-indent\">\r\n<div class=\"container\">\r\n<div class=\"row tt-services-listing\">\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-f-48\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">2 د.ك توصيل</h4>\r\n<p>شحن مجاني لكل طلب فوق 50 د.ك</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-f-35\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">دعم 24/7</h4>\r\n<p>اتصل بنا 24 ساعة في اليوم ، 7 أيام في الأسبوع</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-e-09\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">لا استرجاع او استبدال</h4>\r\n<p>.لا يوجد لدينا استرجاع او استبدال</p>\r\n</div>\r\n</div>\r\n</div>\r\n<div class=\"col-xs-12 col-md-6 col-lg-3\">\r\n<div class=\"tt-services-block\">\r\n<div class=\"tt-col-icon\"><i class=\"icon-f-76\"></i></div>\r\n<div class=\"tt-col-description\">\r\n<h4 class=\"tt-title\">100% دفع امن</h4>\r\n<p>نحن نضمن الدفع الآمن</p>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','2021-11-13 14:45:17','2021-11-13 14:45:17',1),(32,'Contact us info block عربي','contact_us_info','<div class=\"tt-contact02-col-list\">\r\n<div class=\"row\">\r\n<div class=\"col-sm-12 col-md-4 ml-sm-auto mr-sm-auto\">\r\n<div class=\"tt-contact-info\"><i class=\"tt-icon icon-f-93\"></i>\r\n<h6 class=\"tt-title\">تواصل معنا</h6>\r\n<address>99994241<span>, 55921477, 66225655, 25617712, 25617713</span><br /><br /></address></div>\r\n</div>\r\n<div class=\"col-sm-6 col-md-4\">\r\n<div class=\"tt-contact-info\"><i class=\"tt-icon icon-f-24\"></i>\r\n<h6 class=\"tt-title\">قم بزيارة موقعنا</h6>\r\n<address>الكويت ،السالمية , قطعة 11 , قسيمة 906</address></div>\r\n</div>\r\n<div class=\"col-sm-6 col-md-4\">\r\n<div class=\"tt-contact-info\"><i class=\"tt-icon icon-f-92\"></i>\r\n<h6 class=\"tt-title\">اوقات العمل</h6>\r\n<address>6 ايام في الاسبوع  <br /> من 10:00 صباحا الى 8:00 مساء</address></div>\r\n</div>\r\n</div>\r\n</div>','2021-11-13 14:46:27','2021-11-13 14:46:27',1),(33,'footer terms of service Arabic','ys_footer_terms_of_service','<div class=\"tt-mobile-collapse\">\r\n<h4 class=\"tt-collapse-title\">شروط الخدمة</h4>\r\n<div class=\"tt-collapse-content\">\r\n<ul class=\"tt-list\">\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/ar/aboutus_ar\">عن كلير بوتيك </a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/ar/termsandconditions_ar\">الشروط و الاحكام</a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/ar/privacy_ar\">سياسة الخصوصية </a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/ar/contact\">تواصل معنا </a></li>\r\n</ul>\r\n</div>\r\n</div>','2021-11-13 14:46:57','2021-11-13 14:46:57',1),(34,'footer terms of service english','ys_footer_terms_of_service','<div class=\"tt-mobile-collapse\">\r\n<h4 class=\"tt-collapse-title\">Terms of service</h4>\r\n<div class=\"tt-collapse-content\">\r\n<ul class=\"tt-list\">\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/default/about-us\">About us</a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/default/term-and-conditions\">Terms and Conditions</a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/default/privacy-policy\">Privacy Policy</a></li>\r\n<li><a href=\"{{config path=\"web/unsecure/base_url\"}}/default/contact\">Contact us</a></li>\r\n</ul>\r\n</div>\r\n</div>','2021-11-13 14:47:26','2021-11-13 14:47:26',1),(35,'Wokiee Categories Carousel','wk_categories_carousel','<div class=\"container-indent\">\r\n<div class=\"container container-fluid-custom-mobile-padding\">\r\n<div class=\"tt-block-title\">\r\n<h1 class=\"tt-title\">OUR COLLECTIONS</h1>\r\n<div class=\"tt-description\">SUMMER 2018</div>\r\n</div>\r\n<div class=\"tt-carousel-products row arrow-location-tab arrow-location-tab01 tt-alignment-img tt-collection-listing slick-animated-show-js\">\r\n<div class=\"col-2 col-md-4 col-lg-3\">\r\n<div class=\"tt-image-box\"><img src=\"{{media url=wysiwyg/wokiee/product/product-20.jpg}}\" alt=\"\" /></div>\r\n<div class=\"tt-description\">\r\n<h2 class=\"tt-title\">Shirts &amp; Tops</h2>\r\n<ul class=\"tt-add-info\">\r\n<li>45 PRODUCTS</li>\r\n</ul>\r\n</div>\r\n</div>\r\n<div class=\"col-2 col-md-4 col-lg-3\">\r\n<div class=\"tt-image-box\"><img src=\"{{media url=wysiwyg/wokiee/product/product-03.jpg}}\" alt=\"\" /></div>\r\n<div class=\"tt-description\">\r\n<h2 class=\"tt-title\">Jackets &amp; Outerwear</h2>\r\n<ul class=\"tt-add-info\">\r\n<li>35 PRODUCTS</li>\r\n</ul>\r\n</div>\r\n</div>\r\n<div class=\"col-2 col-md-4 col-lg-3\">\r\n<div class=\"tt-image-box\"><img src=\"{{media url=wysiwyg/wokiee/product/product-11.jpg}}\" alt=\"\" /></div>\r\n<div class=\"tt-description\">\r\n<h2 class=\"tt-title\">Sweaters</h2>\r\n<ul class=\"tt-add-info\">\r\n<li>28 PRODUCTS</li>\r\n</ul>\r\n</div>\r\n</div>\r\n<div class=\"col-2 col-md-4 col-lg-3\">\r\n<div class=\"tt-image-box\"><img src=\"{{media url=wysiwyg/wokiee/product/product-23.jpg}}\" alt=\"\" /></div>\r\n<div class=\"tt-description\">\r\n<h2 class=\"tt-title\">Pants</h2>\r\n<ul class=\"tt-add-info\">\r\n<li>22 PRODUCTS</li>\r\n</ul>\r\n</div>\r\n</div>\r\n<div class=\"col-2 col-md-4 col-lg-3\">\r\n<div class=\"tt-image-box\"><img src=\"{{media url=wysiwyg/wokiee/product/product-14.jpg}}\" alt=\"\" /></div>\r\n<div class=\"tt-description\">\r\n<h2 class=\"tt-title\">Sweaters</h2>\r\n<ul class=\"tt-add-info\">\r\n<li>26 PRODUCTS</li>\r\n</ul>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','2021-11-13 14:47:53','2021-11-13 14:47:53',1),(36,'Brands Category','brands_sub_categories_list','<p>{{widget type=\"Ecomwares\\BrandswithimgWidget\\Block\\Widget\\BrandswithimgWidget\" blocktitle=\"BRANDS\" is_category_list=\"1\" parentcat=\"42\"}}</p>','2021-11-13 14:48:23','2021-11-13 14:48:23',1),(37,'klair page','klair_page','<p><iframe src=\"https://www.youtube.com/embed/Feei5HjJuTs\" width=\"560\" height=\"315\" frameborder=\"0\" allowfullscreen=\"\"></iframe></p>\r\n<p></p>\r\n<p>some text to be here here here</p>','2021-11-13 14:49:02','2021-11-13 14:49:02',1);

--
-- Table structure for table `mag2_cms_block_store`
--

CREATE TABLE `mag2_cms_block_store` (
  `block_id` smallint(6) NOT NULL COMMENT 'Block ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`block_id`,`store_id`),
  KEY `MAG2_CMS_BLOCK_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_CMS_BLOCK_STORE_BLOCK_ID_CMS_BLOCK_BLOCK_ID` FOREIGN KEY (`block_id`) REFERENCES `mag2_cms_block` (`block_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CMS_BLOCK_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Block To Store Linkage Table';

--
-- Dumping data for table `mag2_cms_block_store`
--

INSERT INTO `mag2_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),(21,0),(23,0),(24,0),(25,0),(26,0),(29,0),(35,0),(36,0),(37,0),(19,1),(20,1),(22,1),(30,1),(34,1),(27,2),(28,2),(31,2),(32,2),(33,2);

--
-- Table structure for table `mag2_cms_page`
--

CREATE TABLE `mag2_cms_page` (
  `page_id` smallint(6) NOT NULL AUTO_INCREMENT COMMENT 'Page 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(6) NOT NULL DEFAULT '1' COMMENT 'Is Page Active',
  `sort_order` smallint(6) 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',
  `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 `MAG2_CMS_PAGE_IDENTIFIER` (`identifier`),
  FULLTEXT KEY `FTI_5B64B6781E1A07DB3A999BFB4E49010B` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8 COMMENT='CMS Page Table';

--
-- Dumping data for table `mag2_cms_page`
--

INSERT INTO `mag2_cms_page` VALUES (1,'404 Not Found','1column','Page keywords','Page description','no-route','Whoops, our bad...','<dl><dt>The page you requested was not found, and we have a fine guess why.</dt><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>\r\n</dd></dl><dl><dt>What can you do?</dt><dd>Have no fear, help is near! There are many ways you can get back on track with Magento Store.</dd><dd>\r\n<ul class=\"disc\">\r\n<li><a onclick=\"history.go(-1); return false;\" href=\"#\">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>\r\n</ul>\r\n</dd></dl>','2021-11-10 08:14:42','2021-11-13 14:58:42',1,0,'','','',NULL,NULL,NULL,''),(2,'Home Page','empty','','','home','','<p>{{widget type=\"Mageplaza\\BannerSlider\\Block\\Widget\" slider_id=\"1\"}}</p>\r\n<div class=\"tt-tab-wrapper\">\r\n<ul class=\"nav nav-tabs tt-tabs-default\">\r\n<li class=\"nav-item\"><a class=\"nav-link active\" href=\"#tt-tab01-01\" data-toggle=\"tab\">Categories</a></li>\r\n</ul>\r\n</div>\r\n<p>{{widget type=\"Ecomwares\\CatewithimgWidget\\Block\\Widget\\CatewithimgWidget\" blocktitle=\"Categories\" tagline=\"Categories\" parentcat=\"41,42,43,45,46,47\"}} {{block class=\"Magento\\Cms\\Block\\Block\" block_id=\"our_offers_products\"}} {{block class=\"Magento\\Cms\\Block\\Block\" block_id=\"new_in_products\"}} {{block class=\"Magento\\Cms\\Block\\Block\" block_id=\"best_seller_products\"}}</p>\r\n<p>{{block class=\"Magento\\Cms\\Block\\Block\" block_id=\"footer_services_line\"}}</p>\r\n<p>{{block class=\"Magento\\Cms\\Block\\Block\" block_id=\"wk_instagram_fluid\"}}</p>\r\n<style xml=\"space\"><!--\r\n.tb_button {padding:1px;cursor:pointer;border-right: 1px solid #8b8b8b;border-left: 1px solid #FFF;border-bottom: 1px solid #fff;}.tb_button.hover {borer:2px outset #def; background-color: #f8f8f8 !important;}.ws_toolbar {z-index:100000} .ws_toolbar .ws_tb_btn {cursor:pointer;border:1px solid #555;padding:3px}   .tb_highlight{background-color:yellow} .tb_hide {visibility:hidden} .ws_toolbar img {padding:2px;margin:0px}\r\n--></style>','2021-11-10 08:14:42','2021-11-15 17:16:09',1,0,'','','','',NULL,NULL,''),(3,'Enable Cookies','1column','','','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>','2021-11-10 08:14:42','2021-11-13 14:59:30',1,0,'','','',NULL,NULL,NULL,''),(4,'سياسة الخصوصية','1column','','','privacy-policy-cookie-restriction-mode','سياسة الخصوصية','<p style=\"text-align: right;\">أنت تضمن أن المعلومات الشخصية التي تقدمها عند التسجيل على موقع klairboutique.com ومواقع التسوق المرتبطة به صحيحة ودقيقة وحديثة من جميع النواحي.</p>\r\n<p style=\"text-align: right;\">عند التسجيل على klairboutique.com ، فأنت تقبل وتوافق على إرسال بياناتك الشخصية المقدمة أثناء التسجيل إلى قاعدة بياناتنا. إذا كنت لا توافق ، يرجى عدم التسجيل معنا. بمجرد التسوق والشراء عبر الإنترنت على klairboutique.com ، فإنك توافق على الالتزام بالشروط والأحكام وسياسة الخصوصية الخاصة بنا.</p>\r\n<p style=\"text-align: right;\">أنت مسؤول عن الحفاظ على سرية حسابك وكلمة مرورك واتخاذ جميع التدابير المعقولة لمنع الوصول غير المصرح به إلى حسابك. أنت تقبل المسؤولية عن جميع الأنشطة داخل حسابك أو الأنشطة التي تؤثر على كلمة مرورك. يجب عليك الاتصال بنا على الفور إذا كنت تعتقد أن كلمة المرور الخاصة بك قد أصبحت معروفة لشخص آخر ، أو يمكن استخدامها بأي طريقة غير مصرح بها. إذا نسيت كلمة المرور الخاصة بك ، فسنقوم بإعادة تعيينها بناءً على طلبك وإرسالها إلى عنوان البريد الإلكتروني الذي حددته عند التسجيل ، ما عليك سوى الاتصال info@klairboutique.com</p>\r\n<p style=\"text-align: right;\">إذا تغيرت معلوماتك الشخصية أو كنت ترغب في إلغاء حسابك ، فيرجى إخطارنا عن طريق الاتصال بنا.</p>\r\n<p style=\"text-align: right;\">توفر Klair Boutique وشركاؤها ومواقع التسوق إمكانية الوصول إلى الموقع بشكل مؤقت وتحتفظ بالحق في سحب أو تعديل الخدمة التي نقدمها على موقعنا دون إشعار و / أو إنهاء الحسابات دون إشعار مسبق.</p>','2021-11-10 08:14:42','2021-11-13 15:03:19',1,0,'','','','',NULL,NULL,''),(5,'About us','1column','','','about-us','About us','<p><span style=\"font-size: medium;\">A Kuwaiti company founded in 2005 specializing in support</span></p>\r\n<p><span style=\"font-size: medium;\">Beauty makeup, hair care, body care, everything related to cosmetology ((make over)), the Clear Salon company has been ranked first in this field, as our company has been chosen to be the exclusive agent of an Italian global brand NIKA NIKA, a 100% medical brand with a global ISO certification in Daily professional hair treatments managed by the media and beauty expert Claire Nasereddin.</span></p>\r\n<p><span style=\"font-size: medium;\">Claire Salon is located in Salmiya, Block 11, Baghdad Street, opposite Sheikh Saad Palace</span></p>\r\n<p><span style=\"font-size: medium;\"><strong>Email:</strong></span></p>\r\n<p><span style=\"font-size: medium;\">klairsaloncompany@gmail.com</span><br /><span style=\"font-size: medium;\">klair.kuwait.co@gmail.com</span></p>\r\n<p><span style=\"font-size: medium;\"><strong>To contact us:</strong></span></p>\r\n<p><span style=\"font-size: medium;\">0096566225655</span><br /><span style=\"font-size: medium;\">0096555921477</span><br /><span style=\"font-size: medium;\">0096525617712</span><br /><span style=\"font-size: medium;\">0096525617713</span></p>','2021-11-10 08:17:22','2021-11-13 15:07:10',1,0,'','','','',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','2021-11-10 08:17:23','2021-11-10 08:17:23',1,0,'','','','',NULL,NULL,NULL),(7,'عن كلير بوتيك ','1column','','','about-us-old','About us','<p style=\"text-align: right;\"><span style=\"font-size: medium;\">شركة كويتية تأسست فير2005 مختصه في دعم</span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">الجمال مكياج عنايه الشعر  سباه عناية الجسم كل ما يتعلق في التجميل (( make over )) </span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">تصدرت شركة صالون كلير في المرتبة الاولى في هذا المجال جيث تم اخيار شركتنا لتكون الوكيل الحصري لماركة عالمية ايطالية NIKA NIKA </span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">ماركة طبيه 100% حاصله على شهاده الايزو العالمية في علاجات الشعر احترافي يومي بإدارة الاعلاميه وخبيره التجميل كلير ناصر الدين</span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\"> تقع شركه صالون كلير في السالميه  ق 11 شارع بغداد مقابل قصر الشيخ سعد</span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\"><strong>ايميل</strong></span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\"> <a href=\"mailto:klairsaloncompany@gmail.com\">klairsaloncompany@gmail.com</a></span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\"><a href=\"mailto:klairsaloncompany@gmail.com\"></a> <a href=\"mailto:klair.kuwait.co@gmail.com\">klair.kuwait.co@gmail.com</a></span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\"><strong>للتواصل معنا</strong></span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">0096566225655</span><br /><span style=\"font-size: medium;\">0096555921477</span><br /><span style=\"font-size: medium;\">0096525617712</span><br /><span style=\"font-size: medium;\">0096525617713</span></p>\r\n<p style=\"text-align: right;\"><span></span></p>','2021-11-13 15:00:53','2021-11-13 15:00:53',1,0,'','','',NULL,NULL,NULL,''),(9,'الشروط والأحكام','1column','','','wokiee_404','','<p style=\"text-align: right;\">تخبرك هذه الصفحة بالشروط والأحكام  التي يمكنك من خلالها استخدام موقع Klair Boutique سواء كنت ضيفًا أو مستخدمًا مسجلاً. يرجى قراءة هذه الشروط والأحكام بعناية قبل البدء في استخدام الموقع.</p>\r\n<p style=\"text-align: right;\">من خلال الوصول إلى الموقع أو استخدامه ، فإنك تقر بأنك قد قرأت وفهمت ووافقت ، دون قيد أو شرط ، على الالتزام بالشروط والأحكام.</p>\r\n<p style=\"text-align: right;\">يحتفظ Klair Boutique بالحق في ويمكن تغيير هذه الشروط في أي وقت وسوف ينشر هذه التغييرات على الإنترنت. يرجى مراجعة هذه الشروط بانتظام للتأكد من أنك على علم بأي تغييرات حيث أن استمرار استخدامك لموقع klairboutique.com بعد نشر التغييرات يعني موافقتك على الالتزام قانونًا بهذه الشروط كما تم تحديثها و / أو تعديلها.</p>\r\n<p style=\"text-align: right;\">قد يحتوي هذا الموقع على روابط لمواقع وموارد أخرى مقدمة من قبلنا أو من قبل أطراف ثالثة. يتم توفير هذه الروابط فقط لاستخدامك ولراحتك. لا يمثل الرابط أي تأييد أو توصية من جانبنا ولا يعني أن لدينا أي ارتباط بالموقع المرتبط ولا نتحكم في محتويات تلك المواقع المقدمة من أطراف ثالثة ولا نتحمل أي مسؤولية عنها عن أي خسارة أو ضرر قد ينشأ عن استخدامك لها. عندما يتم توفير هذه المواقع وتشغيلها من قبلنا ، فسوف تلتزم بشروطنا وأحكامنا على هذه المواقع.</p>\r\n<p style=\"text-align: right;\">أي علاقة تدخلها مع هذه المواقع تكون على مسؤوليتك الخاصة ونقترح عليك بشدة قراءة الشروط والأحكام وسياسات الخصوصية الخاصة بها.</p>\r\n<p style=\"text-align: right;\">يبذل Klair Boutique كل العناية الممكنة لضمان صحة أوصاف المنتج والعلاج ، والصور ، والجوائز ، والتجارب السريرية ذات الصلة وجميع المعلومات الأخرى في وقت النشر على الموقع. سيتم الاحتفاظ بالموقع محدثًا قدر الإمكان في جميع الأوقات ، ولكن إذا تم إجراء تحديثات للمنتج والمعالجة والموقع والنتائج منذ آخر تحديث على klairboutique.com ، فقد تحدث بعض الاختلافات ، على الرغم من أنها لا تقتصر على الحجم والسعر ، الوصف ونتائج المنتج والتصميم والتعبئة والتوافر.</p>\r\n<p style=\"text-align: right;\">سيبذل Klair Boutique قصارى جهده لضمان أن الموقع متاح ويعمل بشكل صحيح في جميع الأوقات ، لكننا لا نقدم أي ضمانات فيما يتعلق بتوافر الموقع أو إمكانية الوصول إليه ، ولن نتحمل أي مسؤولية عن أي أضرار أو خسائر أو تكاليف أو نفقات التي تكبدتها نتيجة لعدم توفر الموقع أو الوصول إليه.</p>','2021-11-13 15:04:39','2021-11-13 15:04:39',1,0,'\r\n<referenceContainer name=\"page.main.title\" remove=\"1\"/>\r\n<referenceContainer name=\"page.messages\" remove=\"1\"/>\r\n            ','','',NULL,NULL,NULL,''),(11,'FAQ Wokiee','1column','','','wk-faq','About Us ','<div class=\"container-indent\">\r\n<div class=\"container container-fluid-custom-mobile-padding\">\r\n<h1 class=\"tt-title-subpages\">ANSWERS TO YOUR QUESTIONS</h1>\r\n<h2 class=\"tt-base-color small\">Shopping Information</h2>\r\n<div class=\"tt-box-faq-listing\">\r\n<div class=\"row\">\r\n<div class=\"col-sm-12 col-md-6\">\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">WHAT SHIPPING METHODS ARE AVAILABLE?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat.\r\n<p>Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit.</p>\r\n</div>\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">HOW LONG WILL IT TAKE TO GET MY PACKAGE?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.</div>\r\n</div>\r\n<div class=\"col-sm-12 col-md-6\">\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">DO YOU SHIP INTERNATIONALLY?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.</div>\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">WHAT SHIPPING METHODS ARE AVAILABLE?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip. Lorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.</div>\r\n</div>\r\n</div>\r\n</div>\r\n<hr class=\"hr-01\" />\r\n<h2 class=\"tt-base-color small\">Payment Information</h2>\r\n<div class=\"tt-box-faq-listing\">\r\n<div class=\"row\">\r\n<div class=\"col-sm-12 col-md-6\">\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">WHAT PAYMENT METHODS ARE ACCEPTED?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat.</div>\r\n</div>\r\n<div class=\"col-sm-12 col-md-6\">\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">IS BUYING ON-LINE SAFE?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.</div>\r\n</div>\r\n</div>\r\n</div>\r\n<hr class=\"hr-01\" />\r\n<h2 class=\"tt-base-color small\">Orders and Returns</h2>\r\n<div class=\"tt-box-faq-listing\">\r\n<div class=\"row\">\r\n<div class=\"col-sm-12 col-md-6\">\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">HOW DO I PLACE AN ORDER?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</div>\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">DO I NEED AN ACCOUNT TO PLACE AN ORDER?</a></h6>\r\nConse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</div>\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">WHO SHOULD I TO CONTACT IF I HAVE ANY QUERIES?</a></h6>\r\nQuis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.</div>\r\n</div>\r\n<div class=\"col-sm-12 col-md-6\">\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">HOW CAN I CANCEL OR CHANGE MY ORDER?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip.</div>\r\n<div class=\"tt-box-faq\">\r\n<h6 class=\"tt-title\"><a href=\"#\">HOW DO I TRACK MY ORDER?</a></h6>\r\nLorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip. Conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Lorem ipsum dolor sit amet conse ctetur adipisicing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris.test</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>\r\n</div>','2021-11-13 15:08:20','2021-11-13 15:08:20',1,0,'','','',NULL,NULL,NULL,''),(12,'terms & conditions','1column','','','term-and-conditions','Terms & Conditions ','<p>This page tells you the terms and conditions on which you may make use of the Klair Boutique website whether as a guest or a registered user. Please read these Terms and Conditions carefully before you start to use the Site.</p>\r\n<p>By accessing or using the Site, you are acknowledging that you have read, understand, and agree, without limitation or qualification, to be bound by the Terms and Conditions.</p>\r\n<p>Klair Boutique reserves the right to and may change these terms at any time and will post such changes online. Please review these terms regularly to ensure you are aware of any changes as your continued use of Klair Boutique.com after changes are posted means you agree to be legally bound by these terms as updated and/or amended.</p>\r\n<p>This Site may contain links to other sites and resources provided by us or by third parties. Such links are provided solely for your use and convenience. The link does not represent any endorsement or recommendation by us and does not mean we have any association with the linked website and we have no control over the contents of those sites provided by third parties and accept no responsibility for them for any loss or damage which may arise from your use of them. Where such sites are provided and operated by us you will be bound by our terms and conditions on such sites.</p>\r\n<p>Any relationship you enter into with these sites is at your own risk and we strongly suggest you read their terms and conditions and privacy policies.</p>\r\n<p>Klair Boutique takes every care possible to ensure that product and treatment descriptions, imagery, awards, associated clinical trials and all other information is correct at time of publication on the site. The site will be kept as up-to-date as possible at all times however if product, treatment, location, results updates have been made since last update on klairboutique.com some variations may occur in, although not limited to size, price, description, product results, design, packaging and availability.</p>\r\n<p>Klair Boutique will do its best to ensure that the website is available and functions correctly at all times, but we make no warranties as to the availability or accessibility of the website, and we will not be liable for any damages, loss, costs or expenses incurred by you as a result of any lack of availability or accessibility of the website.</p>','2021-11-13 15:09:32','2021-11-13 15:09:32',1,0,'','','',NULL,NULL,NULL,''),(13,'help and support english','1column','','','help_and_support','Help And Support','<div>\r\n<h2>What is Lorem Ipsum?</h2>\r\n<p><strong>Lorem Ipsum</strong> is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>\r\n</div>\r\n<div>\r\n<h2>Why do we use it?</h2>\r\n<p>It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).</p>\r\n</div>\r\n<p></p>\r\n<div>\r\n<h2>Where does it come from?</h2>\r\n<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance. The first line of Lorem Ipsum, \"Lorem ipsum dolor sit amet..\", comes from a line in section 1.10.32.</p>\r\n<p>The standard chunk of Lorem Ipsum used since the 1500s is reproduced below for those interested. Sections 1.10.32 and 1.10.33 from \"de Finibus Bonorum et Malorum\" by Cicero are also reproduced in their exact original form, accompanied by English versions from the 1914 translation by H. Rackham.</p>\r\n</div>\r\n<div>\r\n<h2>Where can I get some?</h2>\r\n<p>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. If you are going to use a passage of Lorem Ipsum, you need to be sure there isn\'t anything embarrassing hidden in the middle of text. All the Lorem Ipsum generators on the Internet tend to repeat predefined chunks as necessary, making this the first true generator on the Internet. It uses a dictionary of over 200 Latin words, combined with a handful of model sentence structures, to generate Lorem Ipsum which looks reasonable. The generated Lorem Ipsum is therefore always free from repetition, injected humour, or non-characteristic words etc.</p>\r\n</div>','2021-11-13 15:10:38','2021-11-13 15:10:38',1,0,'','','',NULL,NULL,NULL,''),(14,'Delivery Information','1column','','','delivery-information','Delivery Information','<p>All products purchased from Klairboutique.com will be delivered to you within one day within working hours mentioned in the website as per the address provided. </p>\r\n<p>In case of any delays or errors in the orders, kindly contact us through info@klairboutique.com or through +<span>0096566225655 / +0096555921477</span></p>','2021-11-14 06:05:24','2021-11-14 06:05:24',1,0,'','','',NULL,NULL,NULL,''),(15,'Cancelation and Refund Policy','1column','','','cancelation-and-refund-policy','Cancelation and Refund Policy','<p>Products must be returned unused, unopened with their seal intact and in the same condition as they were originally purchased from Klair Boutique. We will not accept for exchange or refund any item which has been used or is not in the exact condition in which it was purchased from us. </p>','2021-11-14 06:06:43','2021-11-14 06:06:43',1,0,'','','',NULL,NULL,NULL,''),(16,'سياسة التبديل والاسترجاع','1column','','','cancelation-and-refund-policy_ar','سياسة التبديل والاسترجاع','<p style=\"text-align: right;\">يجب إعادة المنتجات غير مستخدمة وغير مفتوحة وختمها سليمًا وبنفس الحالة التي تم شراؤها في الأصل من كلير بوتيك.</p>\r\n<p style=\"text-align: right;\">لن نقبل استبدال أو استرداد أي عنصر تم استخدامه أو ليس في الحالة المحددة التي تم شراؤها منا.</p>','2021-11-14 22:58:35','2021-11-14 22:58:35',1,0,'','','',NULL,NULL,NULL,''),(17,'معلومات التوصيل','1column','','','delivery-information_ar','معلومات التوصيل','<p style=\"text-align: right;\">سيتم تسليم جميع المنتجات التي تم شراؤها من Klairboutique.com إليك في غضون يوم واحد خلال ساعات العمل المذكورة في الموقع وفقًا للعنوان المقدم.</p>\r\n<p style=\"text-align: right;\">في حال وجود أي تأخير أو أخطاء في الطلبات ، يرجى التواصل معنا عبر info@klairboutique.com أو من خلال 0096566225655 + / 0096555921477</p>','2021-11-14 22:59:42','2021-11-14 22:59:42',1,0,'','','',NULL,NULL,NULL,''),(18,'تواصل معنا','1column','','','contactus_ar','تواصل معنا','<p>تواصل معنا</p>','2021-11-14 23:00:50','2021-11-14 23:00:50',1,0,'','','',NULL,NULL,NULL,''),(19,'Contact Us','1column','','','contact-us','','<p>Contact Us</p>','2021-11-14 23:01:54','2021-11-14 23:01:54',1,0,'','','',NULL,NULL,NULL,''),(20,'الشروط والأحكام','1column','','','termsandconditions_ar','الشروط والأحكام','<p style=\"text-align: right;\">تخبرك هذه الصفحة بالشروط والأحكام  التي يمكنك من خلالها استخدام موقع Klair Boutique سواء كنت ضيفًا أو مستخدمًا مسجلاً. يرجى قراءة هذه الشروط والأحكام بعناية قبل البدء في استخدام الموقع.</p>\r\n<p style=\"text-align: right;\">من خلال الوصول إلى الموقع أو استخدامه ، فإنك تقر بأنك قد قرأت وفهمت ووافقت ، دون قيد أو شرط ، على الالتزام بالشروط والأحكام.</p>\r\n<p style=\"text-align: right;\">يحتفظ Klair Boutique بالحق في ويمكن تغيير هذه الشروط في أي وقت وسوف ينشر هذه التغييرات على الإنترنت. يرجى مراجعة هذه الشروط بانتظام للتأكد من أنك على علم بأي تغييرات حيث أن استمرار استخدامك لموقع klairboutique.com بعد نشر التغييرات يعني موافقتك على الالتزام قانونًا بهذه الشروط كما تم تحديثها و / أو تعديلها.</p>\r\n<p style=\"text-align: right;\">قد يحتوي هذا الموقع على روابط لمواقع وموارد أخرى مقدمة من قبلنا أو من قبل أطراف ثالثة. يتم توفير هذه الروابط فقط لاستخدامك ولراحتك. لا يمثل الرابط أي تأييد أو توصية من جانبنا ولا يعني أن لدينا أي ارتباط بالموقع المرتبط ولا نتحكم في محتويات تلك المواقع المقدمة من أطراف ثالثة ولا نتحمل أي مسؤولية عنها عن أي خسارة أو ضرر قد ينشأ عن استخدامك لها. عندما يتم توفير هذه المواقع وتشغيلها من قبلنا ، فسوف تلتزم بشروطنا وأحكامنا على هذه المواقع.</p>\r\n<p style=\"text-align: right;\">أي علاقة تدخلها مع هذه المواقع تكون على مسؤوليتك الخاصة ونقترح عليك بشدة قراءة الشروط والأحكام وسياسات الخصوصية الخاصة بها.</p>\r\n<p style=\"text-align: right;\">يبذل Klair Boutique كل العناية الممكنة لضمان صحة أوصاف المنتج والعلاج ، والصور ، والجوائز ، والتجارب السريرية ذات الصلة وجميع المعلومات الأخرى في وقت النشر على الموقع. سيتم الاحتفاظ بالموقع محدثًا قدر الإمكان في جميع الأوقات ، ولكن إذا تم إجراء تحديثات للمنتج والمعالجة والموقع والنتائج منذ آخر تحديث على klairboutique.com ، فقد تحدث بعض الاختلافات ، على الرغم من أنها لا تقتصر على الحجم والسعر ، الوصف ونتائج المنتج والتصميم والتعبئة والتوافر.</p>\r\n<p style=\"text-align: right;\">سيبذل Klair Boutique قصارى جهده لضمان أن الموقع متاح ويعمل بشكل صحيح في جميع الأوقات ، لكننا لا نقدم أي ضمانات فيما يتعلق بتوافر الموقع أو إمكانية الوصول إليه ، ولن نتحمل أي مسؤولية عن أي أضرار أو خسائر أو تكاليف أو نفقات التي تكبدتها نتيجة لعدم توفر الموقع أو الوصول إليه.</p>','2021-11-14 23:03:00','2021-11-14 23:03:00',1,0,'','','',NULL,NULL,NULL,''),(21,'عن كلير بوتيك ','1column','','','aboutus_ar','عن كلير بوتيك ','<p style=\"text-align: right;\"><br /><span style=\"font-size: medium;\">شركة كويتية تأسست في 2005 مختصه في دعم </span><span style=\"font-size: medium;\">الجمال مكياج عنايه الشعر سباه عناية الجسم كل ما يتعلق في التجميل (( make over ))</span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\"> تصدرت شركة صالون كلير في المرتبة الاولى في هذا المجال جيث تم اخيار شركتنا لتكون الوكيل الحصري لماركة عالمية ايطالية </span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">NIKA NIKA ماركة طبيه 100% حاصله على شهاده الايزو العالمية في علاجات الشعر احترافي يومي بإدارة الاعلاميه وخبيره التجميل كلير ناصر الدين</span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">تقع شركه صالون كلير في السالميه ق 11 شارع بغداد مقابل قصر الشيخ سعد</span></p>\r\n<h1 style=\"text-align: right;\"><strong><span style=\"font-size: medium; font-family: arial, helvetica, sans-serif;\">ايميل</span></strong></h1>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">klairsaloncompany@gmail.com</span><br /><span style=\"font-size: medium;\">klair.kuwait.co@gmail.com</span></p>\r\n<h1 style=\"text-align: right;\"><strong><span style=\"font-size: medium; font-family: \'arial black\', \'avant garde\';\">للتواصل معنا</span></strong></h1>\r\n<p style=\"text-align: right;\"><span style=\"font-size: medium;\">096566225655 </span><br /><span style=\"font-size: medium;\"> 096555921477</span><br /><span style=\"font-size: medium;\"> 096525617712</span><br /><span style=\"font-size: medium;\"> 096525617713</span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: small; font-family: arial, helvetica, sans-serif;\"></span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: small;\"></span></p>\r\n<p style=\"text-align: right;\"><span style=\"font-size: small;\"></span></p>','2021-11-14 23:04:25','2021-11-14 23:04:25',1,0,'','','',NULL,NULL,NULL,''),(22,'سياسة الخصوصية','1column','','','privacy_ar','سياسة الخصوصية','<p style=\"text-align: right;\">أنت تضمن أن المعلومات الشخصية التي تقدمها عند التسجيل على موقع klairboutique.com ومواقع التسوق المرتبطة به صحيحة ودقيقة وحديثة من جميع النواحي.</p>\r\n<p style=\"text-align: right;\">عند التسجيل على klairboutique.com ، فأنت تقبل وتوافق على إرسال بياناتك الشخصية المقدمة أثناء التسجيل إلى قاعدة بياناتنا. إذا كنت لا توافق ، يرجى عدم التسجيل معنا. بمجرد التسوق والشراء عبر الإنترنت على klairboutique.com ، فإنك توافق على الالتزام بالشروط والأحكام وسياسة الخصوصية الخاصة بنا.</p>\r\n<p style=\"text-align: right;\">أنت مسؤول عن الحفاظ على سرية حسابك وكلمة مرورك واتخاذ جميع التدابير المعقولة لمنع الوصول غير المصرح به إلى حسابك. أنت تقبل المسؤولية عن جميع الأنشطة داخل حسابك أو الأنشطة التي تؤثر على كلمة مرورك. يجب عليك الاتصال بنا على الفور إذا كنت تعتقد أن كلمة المرور الخاصة بك قد أصبحت معروفة لشخص آخر ، أو يمكن استخدامها بأي طريقة غير مصرح بها. إذا نسيت كلمة المرور الخاصة بك ، فسنقوم بإعادة تعيينها بناءً على طلبك وإرسالها إلى عنوان البريد الإلكتروني الذي حددته عند التسجيل ، ما عليك سوى الاتصال info@klairboutique.com</p>\r\n<p style=\"text-align: right;\">إذا تغيرت معلوماتك الشخصية أو كنت ترغب في إلغاء حسابك ، فيرجى إخطارنا عن طريق الاتصال بنا.</p>\r\n<p style=\"text-align: right;\">توفر Klair Boutique وشركاؤها ومواقع التسوق إمكانية الوصول إلى الموقع بشكل مؤقت وتحتفظ بالحق في سحب أو تعديل الخدمة التي نقدمها على موقعنا دون إشعار و / أو إنهاء الحسابات دون إشعار مسبق.</p>','2021-11-14 23:05:28','2021-11-14 23:05:28',1,0,'','','',NULL,NULL,NULL,''),(23,'Come Soon custom','1column','','','come-soon-custom','','<style xml=\"space\"><!--\r\n.tt-desktop-header\r\n{\r\ndisplay:none;\r\n}\r\n--></style>\r\n<p style=\"text-align: center;\"><strong><br /></strong></p>\r\n<p style=\"text-align: center;\"><strong><br /></strong></p>\r\n<p style=\"text-align: center;\"><strong><br /></strong></p>\r\n<h1 class=\"text-uppercase mt-50\" style=\"text-align: center;\"><span style=\"color: #ff0000;\">Coming</span> Soon</h1>\r\n<p class=\"mt-50\" style=\"text-align: center;\"><strong>Our website is almost ready for launch.</strong></p>\r\n<p class=\"mt-50\" style=\"text-align: center;\"><strong><br /></strong></p>\r\n<p class=\"mt-50\" style=\"text-align: center;\"><strong><br /></strong></p>\r\n<p class=\"mt-50\" style=\"text-align: center;\"><strong><br /></strong></p>\r\n<p class=\"mt-50\" style=\"text-align: center;\"><strong><br /></strong></p>\r\n<p class=\"mt-50\" style=\"text-align: center;\"><strong><br /></strong></p>\r\n<div></div>\r\n<div></div>\r\n<div></div>\r\n<div></div>\r\n<div></div>\r\n<p style=\"text-align: center;\"><span style=\"font-size: xx-large;\"><strong></strong></span></p>','2021-11-14 23:06:33','2021-11-14 23:06:33',1,0,'','','',NULL,NULL,NULL,''),(25,'Privacy Policy','1column','','','privacy-policy','Privacy Policy ','<p>You guarantee that the personal information which you provide when you register on klairboutique.com and its associated shopping sites is true, accurate and current in all respects. </p>\r\n<p>When registering on klairboutique.com you accept and agree that your personal data provided during registration will be sent to our database. If you do not agree please do not register with us. Once you shop and purchase online at klairboutique.com, you agree to abide by our terms and conditions and privacy policy. </p>\r\n<p>You are responsible for maintaining the confidentiality of your account and password and taking all reasonable measures to prevent unauthorised access to your account. You accept responsibility for all activities within your account or activities that affect your password. You must contact us immediately if you believe that your password has become known to somebody else, or may be used in any way that is has not be authorised by you. If you forget your password we will reset it upon your request and send it to the email address you specified when you registered, simply contact info@klairboutique.com</p>\r\n<p>If your personal information changes or you would like to cancel your account then please notify us by contacting us.</p>\r\n<p>Klair Boutique and its partners and shopping sites provide access to the site on a temporary basis and reserve the right to withdraw or amend the service we provide on our site without notice and/or terminate accounts without prior notice.</p>','2021-11-15 06:12:00','2021-11-15 06:12:00',1,0,'','','',NULL,NULL,NULL,'');

--
-- Table structure for table `mag2_cms_page_store`
--

CREATE TABLE `mag2_cms_page_store` (
  `page_id` smallint(6) NOT NULL COMMENT 'Page ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`page_id`,`store_id`),
  KEY `MAG2_CMS_PAGE_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_CMS_PAGE_STORE_PAGE_ID_CMS_PAGE_PAGE_ID` FOREIGN KEY (`page_id`) REFERENCES `mag2_cms_page` (`page_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CMS_PAGE_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='CMS Page To Store Linkage Table';

--
-- Dumping data for table `mag2_cms_page_store`
--

INSERT INTO `mag2_cms_page_store` VALUES (1,0),(2,0),(3,0),(4,0),(6,0),(7,0),(9,0),(11,0),(13,0),(14,0),(15,0),(16,0),(17,0),(18,0),(19,0),(23,0),(5,1),(12,1),(25,1),(20,2),(21,2),(22,2);

--
-- Table structure for table `mag2_core_config_data`
--

CREATE TABLE `mag2_core_config_data` (
  `config_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Config Id',
  `scope` varchar(8) NOT NULL DEFAULT 'default' COMMENT 'Config Scope',
  `scope_id` int(11) NOT NULL DEFAULT '0' COMMENT 'Config Scope Id',
  `path` varchar(255) NOT NULL DEFAULT 'general' COMMENT 'Config Path',
  `value` text COMMENT 'Config Value',
  PRIMARY KEY (`config_id`),
  UNIQUE KEY `MAG2_CORE_CONFIG_DATA_SCOPE_SCOPE_ID_PATH` (`scope`,`scope_id`,`path`)
) ENGINE=InnoDB AUTO_INCREMENT=721 DEFAULT CHARSET=utf8 COMMENT='Config Data';

--
-- Dumping data for table `mag2_core_config_data`
--



--
-- Table structure for table `mag2_cron_schedule`
--

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

--
-- Dumping data for table `mag2_cron_schedule`
--


--
-- Table structure for table `mag2_customer_address_entity`
--

CREATE TABLE `mag2_customer_address_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
  `parent_id` int(10) unsigned DEFAULT NULL COMMENT 'Parent Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Is Active',
  `city` varchar(255) NOT NULL COMMENT 'City',
  `company` varchar(255) DEFAULT NULL COMMENT 'Company',
  `country_id` varchar(255) NOT NULL COMMENT 'Country',
  `fax` varchar(255) DEFAULT NULL COMMENT 'Fax',
  `firstname` varchar(255) NOT NULL COMMENT 'First Name',
  `lastname` varchar(255) NOT NULL COMMENT 'Last Name',
  `middlename` varchar(255) DEFAULT NULL COMMENT 'Middle Name',
  `postcode` varchar(255) DEFAULT NULL COMMENT 'Zip/Postal Code',
  `prefix` varchar(40) DEFAULT NULL COMMENT 'Name Prefix',
  `region` varchar(255) DEFAULT NULL COMMENT 'State/Province',
  `region_id` int(10) unsigned DEFAULT NULL COMMENT 'State/Province',
  `street` text NOT NULL COMMENT 'Street Address',
  `suffix` varchar(40) DEFAULT NULL COMMENT 'Name Suffix',
  `telephone` varchar(255) NOT NULL COMMENT 'Phone Number',
  `vat_id` varchar(255) DEFAULT NULL COMMENT 'VAT number',
  `vat_is_valid` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validity',
  `vat_request_date` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request date',
  `vat_request_id` varchar(255) DEFAULT NULL COMMENT 'VAT number validation request ID',
  `vat_request_success` int(10) unsigned DEFAULT NULL COMMENT 'VAT number validation request success',
  PRIMARY KEY (`entity_id`),
  KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_PARENT_ID` (`parent_id`),
  CONSTRAINT `MAG2_CUSTOMER_ADDRESS_ENTITY_PARENT_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`parent_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity';

--
-- Dumping data for table `mag2_customer_address_entity`
--

INSERT INTO `mag2_customer_address_entity` VALUES (1,NULL,1,'2021-11-10 08:17:00','2021-11-10 08:17:00',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);

--
-- Table structure for table `mag2_customer_address_entity_datetime`
--

CREATE TABLE `mag2_customer_address_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CSTR_ADDR_ENTT_DTIME_ENTT_ID_ATTR_ID_VAL` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_DTIME_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Datetime';

--
-- Dumping data for table `mag2_customer_address_entity_datetime`
--


--
-- Table structure for table `mag2_customer_address_entity_decimal`
--

CREATE TABLE `mag2_customer_address_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CSTR_ADDR_ENTT_DEC_ENTT_ID_ATTR_ID_VAL` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_DEC_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Decimal';

--
-- Dumping data for table `mag2_customer_address_entity_decimal`
--


--
-- Table structure for table `mag2_customer_address_entity_int`
--

CREATE TABLE `mag2_customer_address_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_INT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_INT_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Int';

--
-- Dumping data for table `mag2_customer_address_entity_int`
--


--
-- Table structure for table `mag2_customer_address_entity_text`
--

CREATE TABLE `mag2_customer_address_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_TEXT_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Text';

--
-- Dumping data for table `mag2_customer_address_entity_text`
--


--
-- Table structure for table `mag2_customer_address_entity_varchar`
--

CREATE TABLE `mag2_customer_address_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ADDRESS_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CSTR_ADDR_ENTT_VCHR_ENTT_ID_ATTR_ID_VAL` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CSTR_ADDR_ENTT_VCHR_ENTT_ID_CSTR_ADDR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_address_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Address Entity Varchar';

--
-- Dumping data for table `mag2_customer_address_entity_varchar`
--


--
-- Table structure for table `mag2_customer_eav_attribute`
--

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

--
-- Dumping data for table `mag2_customer_eav_attribute`
--

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

--
-- Table structure for table `mag2_customer_eav_attribute_website`
--

CREATE TABLE `mag2_customer_eav_attribute_website` (
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `is_visible` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Visible',
  `is_required` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Required',
  `default_value` text COMMENT 'Default Value',
  `multiline_count` smallint(5) unsigned DEFAULT NULL COMMENT 'Multiline Count',
  PRIMARY KEY (`attribute_id`,`website_id`),
  KEY `MAG2_CUSTOMER_EAV_ATTRIBUTE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `MAG2_CSTR_EAV_ATTR_WS_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CSTR_EAV_ATTR_WS_WS_ID_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `mag2_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Eav Attribute Website';

--
-- Dumping data for table `mag2_customer_eav_attribute_website`
--

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

--
-- Table structure for table `mag2_customer_entity_datetime`
--

CREATE TABLE `mag2_customer_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_DATETIME_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CSTR_ENTT_DTIME_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CSTR_ENTT_DTIME_ENTT_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Datetime';

--
-- Dumping data for table `mag2_customer_entity_datetime`
--


--
-- Table structure for table `mag2_customer_entity_decimal`
--

CREATE TABLE `mag2_customer_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_DECIMAL_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CSTR_ENTT_DEC_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CUSTOMER_ENTITY_DECIMAL_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Decimal';

--
-- Dumping data for table `mag2_customer_entity_decimal`
--


--
-- Table structure for table `mag2_customer_entity_int`
--

CREATE TABLE `mag2_customer_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_INT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CUSTOMER_ENTITY_INT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CUSTOMER_ENTITY_INT_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Int';

--
-- Dumping data for table `mag2_customer_entity_int`
--


--
-- Table structure for table `mag2_customer_entity_text`
--

CREATE TABLE `mag2_customer_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `MAG2_CSTR_ENTT_TEXT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CUSTOMER_ENTITY_TEXT_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Text';

--
-- Dumping data for table `mag2_customer_entity_text`
--


--
-- Table structure for table `mag2_customer_entity_varchar`
--

CREATE TABLE `mag2_customer_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID` (`entity_id`,`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_VARCHAR_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_VALUE` (`entity_id`,`attribute_id`,`value`),
  CONSTRAINT `MAG2_CSTR_ENTT_VCHR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_CUSTOMER_ENTITY_VARCHAR_ENTITY_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Entity Varchar';

--
-- Dumping data for table `mag2_customer_entity_varchar`
--


--
-- Table structure for table `mag2_customer_form_attribute`
--

CREATE TABLE `mag2_customer_form_attribute` (
  `form_code` varchar(32) NOT NULL COMMENT 'Form Code',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  PRIMARY KEY (`form_code`,`attribute_id`),
  KEY `MAG2_CUSTOMER_FORM_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `MAG2_CSTR_FORM_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Customer Form Attribute';

--
-- Dumping data for table `mag2_customer_form_attribute`
--

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

--
-- Table structure for table `mag2_customer_grid_flat`
--

CREATE TABLE `mag2_customer_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `name` text COMMENT 'Name',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `group_id` int(11) DEFAULT NULL COMMENT 'Group_id',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created_at',
  `website_id` int(11) DEFAULT NULL COMMENT 'Website_id',
  `confirmation` varchar(255) DEFAULT NULL COMMENT 'Confirmation',
  `created_in` text COMMENT 'Created_in',
  `dob` date DEFAULT NULL COMMENT 'Dob',
  `gender` int(11) DEFAULT NULL COMMENT 'Gender',
  `taxvat` varchar(255) DEFAULT NULL COMMENT 'Taxvat',
  `lock_expires` timestamp NULL DEFAULT NULL COMMENT 'Lock_expires',
  `shipping_full` text COMMENT 'Shipping_full',
  `billing_full` text COMMENT 'Billing_full',
  `billing_firstname` varchar(255) DEFAULT NULL COMMENT 'Billing_firstname',
  `billing_lastname` varchar(255) DEFAULT NULL COMMENT 'Billing_lastname',
  `billing_telephone` varchar(255) DEFAULT NULL COMMENT 'Billing_telephone',
  `billing_postcode` varchar(255) DEFAULT NULL COMMENT 'Billing_postcode',
  `billing_country_id` varchar(255) DEFAULT NULL COMMENT 'Billing_country_id',
  `billing_region` varchar(255) DEFAULT NULL COMMENT 'Billing_region',
  `billing_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 `MAG2_CUSTOMER_GRID_FLAT_GROUP_ID` (`group_id`),
  KEY `MAG2_CUSTOMER_GRID_FLAT_CREATED_AT` (`created_at`),
  KEY `MAG2_CUSTOMER_GRID_FLAT_WEBSITE_ID` (`website_id`),
  KEY `MAG2_CUSTOMER_GRID_FLAT_CONFIRMATION` (`confirmation`),
  KEY `MAG2_CUSTOMER_GRID_FLAT_DOB` (`dob`),
  KEY `MAG2_CUSTOMER_GRID_FLAT_GENDER` (`gender`),
  KEY `MAG2_CUSTOMER_GRID_FLAT_BILLING_COUNTRY_ID` (`billing_country_id`),
  FULLTEXT KEY `FTI_69DAC03CC92667B4007E78C5AC3238AA` (`name`,`email`,`created_in`,`taxvat`,`shipping_full`,`billing_full`,`billing_firstname`,`billing_lastname`,`billing_telephone`,`billing_postcode`,`billing_region`,`billing_city`,`billing_fax`,`billing_company`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_customer_grid_flat';

--
-- Dumping data for table `mag2_customer_grid_flat`
--

INSERT INTO `mag2_customer_grid_flat` VALUES (1,'Veronica Costello','roni_cost@example.com',1,'2021-11-10 08:17:00',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','6146 Honey Bluff Parkway','Calder',NULL,NULL,NULL);

--
-- Table structure for table `mag2_customer_group`
--

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

--
-- Dumping data for table `mag2_customer_group`
--

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

--
-- Table structure for table `mag2_customer_log`
--

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

--
-- Dumping data for table `mag2_customer_log`
--


--
-- Table structure for table `mag2_design_change`
--

CREATE TABLE `mag2_design_change` (
  `design_change_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Design Change Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `design` varchar(255) DEFAULT NULL COMMENT 'Design',
  `date_from` date DEFAULT NULL COMMENT 'First Date of Design Activity',
  `date_to` date DEFAULT NULL COMMENT 'Last Date of Design Activity',
  PRIMARY KEY (`design_change_id`),
  KEY `MAG2_DESIGN_CHANGE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_DESIGN_CHANGE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Design Changes';

--
-- Dumping data for table `mag2_design_change`
--


--
-- Table structure for table `mag2_design_config_grid_flat`
--

CREATE TABLE `mag2_design_config_grid_flat` (
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Entity ID',
  `store_website_id` int(11) DEFAULT NULL COMMENT 'Store_website_id',
  `store_group_id` int(11) DEFAULT NULL COMMENT 'Store_group_id',
  `store_id` int(11) DEFAULT NULL COMMENT 'Store_id',
  `theme_theme_id` varchar(255) DEFAULT NULL COMMENT 'Theme_theme_id',
  PRIMARY KEY (`entity_id`),
  KEY `MAG2_DESIGN_CONFIG_GRID_FLAT_STORE_WEBSITE_ID` (`store_website_id`),
  KEY `MAG2_DESIGN_CONFIG_GRID_FLAT_STORE_GROUP_ID` (`store_group_id`),
  KEY `MAG2_DESIGN_CONFIG_GRID_FLAT_STORE_ID` (`store_id`),
  FULLTEXT KEY `MAG2_DESIGN_CONFIG_GRID_FLAT_THEME_THEME_ID` (`theme_theme_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_design_config_grid_flat';

--
-- Dumping data for table `mag2_design_config_grid_flat`
--

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

--
-- Table structure for table `mag2_directory_country`
--

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

--
-- Dumping data for table `mag2_directory_country`
--

INSERT INTO `mag2_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'),('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'),('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'),('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'),('YE','YE','YEM'),('YT','YT','MYT'),('ZA','ZA','ZAF'),('ZM','ZM','ZMB'),('ZW','ZW','ZWE');

--
-- Table structure for table `mag2_directory_country_format`
--

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

--
-- Dumping data for table `mag2_directory_country_format`
--


--
-- Table structure for table `mag2_directory_country_region`
--

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

--
-- Dumping data for table `mag2_directory_country_region`
--

INSERT INTO `mag2_directory_country_region` VALUES (1,'US','AL','Alabama'),(2,'US','AK','Alaska'),(3,'US','AS','American Samoa'),(4,'US','AZ','Arizona'),(5,'US','AR','Arkansas'),(6,'US','AE','Armed Forces Africa'),(7,'US','AA','Armed Forces Americas'),(8,'US','AE','Armed Forces Canada'),(9,'US','AE','Armed Forces Europe'),(10,'US','AE','Armed Forces Middle East'),(11,'US','AP','Armed Forces Pacific'),(12,'US','CA','California'),(13,'US','CO','Colorado'),(14,'US','CT','Connecticut'),(15,'US','DE','Delaware'),(16,'US','DC','District of Columbia'),(17,'US','FM','Federated States Of Micronesia'),(18,'US','FL','Florida'),(19,'US','GA','Georgia'),(20,'US','GU','Guam'),(21,'US','HI','Hawaii'),(22,'US','ID','Idaho'),(23,'US','IL','Illinois'),(24,'US','IN','Indiana'),(25,'US','IA','Iowa'),(26,'US','KS','Kansas'),(27,'US','KY','Kentucky'),(28,'US','LA','Louisiana'),(29,'US','ME','Maine'),(30,'US','MH','Marshall Islands'),(31,'US','MD','Maryland'),(32,'US','MA','Massachusetts'),(33,'US','MI','Michigan'),(34,'US','MN','Minnesota'),(35,'US','MS','Mississippi'),(36,'US','MO','Missouri'),(37,'US','MT','Montana'),(38,'US','NE','Nebraska'),(39,'US','NV','Nevada'),(40,'US','NH','New Hampshire'),(41,'US','NJ','New Jersey'),(42,'US','NM','New Mexico'),(43,'US','NY','New York'),(44,'US','NC','North Carolina'),(45,'US','ND','North Dakota'),(46,'US','MP','Northern Mariana Islands'),(47,'US','OH','Ohio'),(48,'US','OK','Oklahoma'),(49,'US','OR','Oregon'),(50,'US','PW','Palau'),(51,'US','PA','Pennsylvania'),(52,'US','PR','Puerto Rico'),(53,'US','RI','Rhode Island'),(54,'US','SC','South Carolina'),(55,'US','SD','South Dakota'),(56,'US','TN','Tennessee'),(57,'US','TX','Texas'),(58,'US','UT','Utah'),(59,'US','VT','Vermont'),(60,'US','VI','Virgin Islands'),(61,'US','VA','Virginia'),(62,'US','WA','Washington'),(63,'US','WV','West Virginia'),(64,'US','WI','Wisconsin'),(65,'US','WY','Wyoming'),(66,'CA','AB','Alberta'),(67,'CA','BC','British Columbia'),(68,'CA','MB','Manitoba'),(69,'CA','NL','Newfoundland and Labrador'),(70,'CA','NB','New Brunswick'),(71,'CA','NS','Nova Scotia'),(72,'CA','NT','Northwest Territories'),(73,'CA','NU','Nunavut'),(74,'CA','ON','Ontario'),(75,'CA','PE','Prince Edward Island'),(76,'CA','QC','Quebec'),(77,'CA','SK','Saskatchewan'),(78,'CA','YT','Yukon Territory'),(79,'DE','NDS','Niedersachsen'),(80,'DE','BAW','Baden-Württemberg'),(81,'DE','BAY','Bayern'),(82,'DE','BER','Berlin'),(83,'DE','BRG','Brandenburg'),(84,'DE','BRE','Bremen'),(85,'DE','HAM','Hamburg'),(86,'DE','HES','Hessen'),(87,'DE','MEC','Mecklenburg-Vorpommern'),(88,'DE','NRW','Nordrhein-Westfalen'),(89,'DE','RHE','Rheinland-Pfalz'),(90,'DE','SAR','Saarland'),(91,'DE','SAS','Sachsen'),(92,'DE','SAC','Sachsen-Anhalt'),(93,'DE','SCN','Schleswig-Holstein'),(94,'DE','THE','Thüringen'),(95,'AT','WI','Wien'),(96,'AT','NO','Niederösterreich'),(97,'AT','OO','Oberösterreich'),(98,'AT','SB','Salzburg'),(99,'AT','KN','Kärnten'),(100,'AT','ST','Steiermark'),(101,'AT','TI','Tirol'),(102,'AT','BL','Burgenland'),(103,'AT','VB','Vorarlberg'),(104,'CH','AG','Aargau'),(105,'CH','AI','Appenzell Innerrhoden'),(106,'CH','AR','Appenzell Ausserrhoden'),(107,'CH','BE','Bern'),(108,'CH','BL','Basel-Landschaft'),(109,'CH','BS','Basel-Stadt'),(110,'CH','FR','Freiburg'),(111,'CH','GE','Genf'),(112,'CH','GL','Glarus'),(113,'CH','GR','Graubünden'),(114,'CH','JU','Jura'),(115,'CH','LU','Luzern'),(116,'CH','NE','Neuenburg'),(117,'CH','NW','Nidwalden'),(118,'CH','OW','Obwalden'),(119,'CH','SG','St. Gallen'),(120,'CH','SH','Schaffhausen'),(121,'CH','SO','Solothurn'),(122,'CH','SZ','Schwyz'),(123,'CH','TG','Thurgau'),(124,'CH','TI','Tessin'),(125,'CH','UR','Uri'),(126,'CH','VD','Waadt'),(127,'CH','VS','Wallis'),(128,'CH','ZG','Zug'),(129,'CH','ZH','Zürich'),(130,'ES','A Coruсa','A Coruña'),(131,'ES','Alava','Alava'),(132,'ES','Albacete','Albacete'),(133,'ES','Alicante','Alicante'),(134,'ES','Almeria','Almeria'),(135,'ES','Asturias','Asturias'),(136,'ES','Avila','Avila'),(137,'ES','Badajoz','Badajoz'),(138,'ES','Baleares','Baleares'),(139,'ES','Barcelona','Barcelona'),(140,'ES','Burgos','Burgos'),(141,'ES','Caceres','Caceres'),(142,'ES','Cadiz','Cadiz'),(143,'ES','Cantabria','Cantabria'),(144,'ES','Castellon','Castellon'),(145,'ES','Ceuta','Ceuta'),(146,'ES','Ciudad Real','Ciudad Real'),(147,'ES','Cordoba','Cordoba'),(148,'ES','Cuenca','Cuenca'),(149,'ES','Girona','Girona'),(150,'ES','Granada','Granada'),(151,'ES','Guadalajara','Guadalajara'),(152,'ES','Guipuzcoa','Guipuzcoa'),(153,'ES','Huelva','Huelva'),(154,'ES','Huesca','Huesca'),(155,'ES','Jaen','Jaen'),(156,'ES','La Rioja','La Rioja'),(157,'ES','Las Palmas','Las Palmas'),(158,'ES','Leon','Leon'),(159,'ES','Lleida','Lleida'),(160,'ES','Lugo','Lugo'),(161,'ES','Madrid','Madrid'),(162,'ES','Malaga','Malaga'),(163,'ES','Melilla','Melilla'),(164,'ES','Murcia','Murcia'),(165,'ES','Navarra','Navarra'),(166,'ES','Ourense','Ourense'),(167,'ES','Palencia','Palencia'),(168,'ES','Pontevedra','Pontevedra'),(169,'ES','Salamanca','Salamanca'),(170,'ES','Santa Cruz de Tenerife','Santa Cruz de Tenerife'),(171,'ES','Segovia','Segovia'),(172,'ES','Sevilla','Sevilla'),(173,'ES','Soria','Soria'),(174,'ES','Tarragona','Tarragona'),(175,'ES','Teruel','Teruel'),(176,'ES','Toledo','Toledo'),(177,'ES','Valencia','Valencia'),(178,'ES','Valladolid','Valladolid'),(179,'ES','Vizcaya','Vizcaya'),(180,'ES','Zamora','Zamora'),(181,'ES','Zaragoza','Zaragoza'),(182,'FR','1','Ain'),(183,'FR','2','Aisne'),(184,'FR','3','Allier'),(185,'FR','4','Alpes-de-Haute-Provence'),(186,'FR','5','Hautes-Alpes'),(187,'FR','6','Alpes-Maritimes'),(188,'FR','7','Ardèche'),(189,'FR','8','Ardennes'),(190,'FR','9','Ariège'),(191,'FR','10','Aube'),(192,'FR','11','Aude'),(193,'FR','12','Aveyron'),(194,'FR','13','Bouches-du-Rhône'),(195,'FR','14','Calvados'),(196,'FR','15','Cantal'),(197,'FR','16','Charente'),(198,'FR','17','Charente-Maritime'),(199,'FR','18','Cher'),(200,'FR','19','Corrèze'),(201,'FR','2A','Corse-du-Sud'),(202,'FR','2B','Haute-Corse'),(203,'FR','21','Côte-d\'Or'),(204,'FR','22','Côtes-d\'Armor'),(205,'FR','23','Creuse'),(206,'FR','24','Dordogne'),(207,'FR','25','Doubs'),(208,'FR','26','Drôme'),(209,'FR','27','Eure'),(210,'FR','28','Eure-et-Loir'),(211,'FR','29','Finistère'),(212,'FR','30','Gard'),(213,'FR','31','Haute-Garonne'),(214,'FR','32','Gers'),(215,'FR','33','Gironde'),(216,'FR','34','Hérault'),(217,'FR','35','Ille-et-Vilaine'),(218,'FR','36','Indre'),(219,'FR','37','Indre-et-Loire'),(220,'FR','38','Isère'),(221,'FR','39','Jura'),(222,'FR','40','Landes'),(223,'FR','41','Loir-et-Cher'),(224,'FR','42','Loire'),(225,'FR','43','Haute-Loire'),(226,'FR','44','Loire-Atlantique'),(227,'FR','45','Loiret'),(228,'FR','46','Lot'),(229,'FR','47','Lot-et-Garonne'),(230,'FR','48','Lozère'),(231,'FR','49','Maine-et-Loire'),(232,'FR','50','Manche'),(233,'FR','51','Marne'),(234,'FR','52','Haute-Marne'),(235,'FR','53','Mayenne'),(236,'FR','54','Meurthe-et-Moselle'),(237,'FR','55','Meuse'),(238,'FR','56','Morbihan'),(239,'FR','57','Moselle'),(240,'FR','58','Nièvre'),(241,'FR','59','Nord'),(242,'FR','60','Oise'),(243,'FR','61','Orne'),(244,'FR','62','Pas-de-Calais'),(245,'FR','63','Puy-de-Dôme'),(246,'FR','64','Pyrénées-Atlantiques'),(247,'FR','65','Hautes-Pyrénées'),(248,'FR','66','Pyrénées-Orientales'),(249,'FR','67','Bas-Rhin'),(250,'FR','68','Haut-Rhin'),(251,'FR','69','Rhône'),(252,'FR','70','Haute-Saône'),(253,'FR','71','Saône-et-Loire'),(254,'FR','72','Sarthe'),(255,'FR','73','Savoie'),(256,'FR','74','Haute-Savoie'),(257,'FR','75','Paris'),(258,'FR','76','Seine-Maritime'),(259,'FR','77','Seine-et-Marne'),(260,'FR','78','Yvelines'),(261,'FR','79','Deux-Sèvres'),(262,'FR','80','Somme'),(263,'FR','81','Tarn'),(264,'FR','82','Tarn-et-Garonne'),(265,'FR','83','Var'),(266,'FR','84','Vaucluse'),(267,'FR','85','Vendée'),(268,'FR','86','Vienne'),(269,'FR','87','Haute-Vienne'),(270,'FR','88','Vosges'),(271,'FR','89','Yonne'),(272,'FR','90','Territoire-de-Belfort'),(273,'FR','91','Essonne'),(274,'FR','92','Hauts-de-Seine'),(275,'FR','93','Seine-Saint-Denis'),(276,'FR','94','Val-de-Marne'),(277,'FR','95','Val-d\'Oise'),(278,'RO','AB','Alba'),(279,'RO','AR','Arad'),(280,'RO','AG','Argeş'),(281,'RO','BC','Bacău'),(282,'RO','BH','Bihor'),(283,'RO','BN','Bistriţa-Năsăud'),(284,'RO','BT','Botoşani'),(285,'RO','BV','Braşov'),(286,'RO','BR','Brăila'),(287,'RO','B','Bucureşti'),(288,'RO','BZ','Buzău'),(289,'RO','CS','Caraş-Severin'),(290,'RO','CL','Călăraşi'),(291,'RO','CJ','Cluj'),(292,'RO','CT','Constanţa'),(293,'RO','CV','Covasna'),(294,'RO','DB','Dâmboviţa'),(295,'RO','DJ','Dolj'),(296,'RO','GL','Galaţi'),(297,'RO','GR','Giurgiu'),(298,'RO','GJ','Gorj'),(299,'RO','HR','Harghita'),(300,'RO','HD','Hunedoara'),(301,'RO','IL','Ialomiţa'),(302,'RO','IS','Iaşi'),(303,'RO','IF','Ilfov'),(304,'RO','MM','Maramureş'),(305,'RO','MH','Mehedinţi'),(306,'RO','MS','Mureş'),(307,'RO','NT','Neamţ'),(308,'RO','OT','Olt'),(309,'RO','PH','Prahova'),(310,'RO','SM','Satu-Mare'),(311,'RO','SJ','Sălaj'),(312,'RO','SB','Sibiu'),(313,'RO','SV','Suceava'),(314,'RO','TR','Teleorman'),(315,'RO','TM','Timiş'),(316,'RO','TL','Tulcea'),(317,'RO','VS','Vaslui'),(318,'RO','VL','Vâlcea'),(319,'RO','VN','Vrancea'),(320,'FI','Lappi','Lappi'),(321,'FI','Pohjois-Pohjanmaa','Pohjois-Pohjanmaa'),(322,'FI','Kainuu','Kainuu'),(323,'FI','Pohjois-Karjala','Pohjois-Karjala'),(324,'FI','Pohjois-Savo','Pohjois-Savo'),(325,'FI','Etelä-Savo','Etelä-Savo'),(326,'FI','Etelä-Pohjanmaa','Etelä-Pohjanmaa'),(327,'FI','Pohjanmaa','Pohjanmaa'),(328,'FI','Pirkanmaa','Pirkanmaa'),(329,'FI','Satakunta','Satakunta'),(330,'FI','Keski-Pohjanmaa','Keski-Pohjanmaa'),(331,'FI','Keski-Suomi','Keski-Suomi'),(332,'FI','Varsinais-Suomi','Varsinais-Suomi'),(333,'FI','Etelä-Karjala','Etelä-Karjala'),(334,'FI','Päijät-Häme','Päijät-Häme'),(335,'FI','Kanta-Häme','Kanta-Häme'),(336,'FI','Uusimaa','Uusimaa'),(337,'FI','Itä-Uusimaa','Itä-Uusimaa'),(338,'FI','Kymenlaakso','Kymenlaakso'),(339,'FI','Ahvenanmaa','Ahvenanmaa'),(340,'EE','EE-37','Harjumaa'),(341,'EE','EE-39','Hiiumaa'),(342,'EE','EE-44','Ida-Virumaa'),(343,'EE','EE-49','Jõgevamaa'),(344,'EE','EE-51','Järvamaa'),(345,'EE','EE-57','Läänemaa'),(346,'EE','EE-59','Lääne-Virumaa'),(347,'EE','EE-65','Põlvamaa'),(348,'EE','EE-67','Pärnumaa'),(349,'EE','EE-70','Raplamaa'),(350,'EE','EE-74','Saaremaa'),(351,'EE','EE-78','Tartumaa'),(352,'EE','EE-82','Valgamaa'),(353,'EE','EE-84','Viljandimaa'),(354,'EE','EE-86','Võrumaa'),(355,'LV','LV-DGV','Daugavpils'),(356,'LV','LV-JEL','Jelgava'),(357,'LV','Jēkabpils','Jēkabpils'),(358,'LV','LV-JUR','Jūrmala'),(359,'LV','LV-LPX','Liepāja'),(360,'LV','LV-LE','Liepājas novads'),(361,'LV','LV-REZ','Rēzekne'),(362,'LV','LV-RIX','Rīga'),(363,'LV','LV-RI','Rīgas novads'),(364,'LV','Valmiera','Valmiera'),(365,'LV','LV-VEN','Ventspils'),(366,'LV','Aglonas novads','Aglonas novads'),(367,'LV','LV-AI','Aizkraukles novads'),(368,'LV','Aizputes novads','Aizputes novads'),(369,'LV','Aknīstes novads','Aknīstes novads'),(370,'LV','Alojas novads','Alojas novads'),(371,'LV','Alsungas novads','Alsungas novads'),(372,'LV','LV-AL','Alūksnes novads'),(373,'LV','Amatas novads','Amatas novads'),(374,'LV','Apes novads','Apes novads'),(375,'LV','Auces novads','Auces novads'),(376,'LV','Babītes novads','Babītes novads'),(377,'LV','Baldones novads','Baldones novads'),(378,'LV','Baltinavas novads','Baltinavas novads'),(379,'LV','LV-BL','Balvu novads'),(380,'LV','LV-BU','Bauskas novads'),(381,'LV','Beverīnas novads','Beverīnas novads'),(382,'LV','Brocēnu novads','Brocēnu novads'),(383,'LV','Burtnieku novads','Burtnieku novads'),(384,'LV','Carnikavas novads','Carnikavas novads'),(385,'LV','Cesvaines novads','Cesvaines novads'),(386,'LV','Ciblas novads','Ciblas novads'),(387,'LV','LV-CE','Cēsu novads'),(388,'LV','Dagdas novads','Dagdas novads'),(389,'LV','LV-DA','Daugavpils novads'),(390,'LV','LV-DO','Dobeles novads'),(391,'LV','Dundagas novads','Dundagas novads'),(392,'LV','Durbes novads','Durbes novads'),(393,'LV','Engures novads','Engures novads'),(394,'LV','Garkalnes novads','Garkalnes novads'),(395,'LV','Grobiņas novads','Grobiņas novads'),(396,'LV','LV-GU','Gulbenes novads'),(397,'LV','Iecavas novads','Iecavas novads'),(398,'LV','Ikšķiles novads','Ikšķiles novads'),(399,'LV','Ilūkstes novads','Ilūkstes novads'),(400,'LV','Inčukalna novads','Inčukalna novads'),(401,'LV','Jaunjelgavas novads','Jaunjelgavas novads'),(402,'LV','Jaunpiebalgas novads','Jaunpiebalgas novads'),(403,'LV','Jaunpils novads','Jaunpils novads'),(404,'LV','LV-JL','Jelgavas novads'),(405,'LV','LV-JK','Jēkabpils novads'),(406,'LV','Kandavas novads','Kandavas novads'),(407,'LV','Kokneses novads','Kokneses novads'),(408,'LV','Krimuldas novads','Krimuldas novads'),(409,'LV','Krustpils novads','Krustpils novads'),(410,'LV','LV-KR','Krāslavas novads'),(411,'LV','LV-KU','Kuldīgas novads'),(412,'LV','Kārsavas novads','Kārsavas novads'),(413,'LV','Lielvārdes novads','Lielvārdes novads'),(414,'LV','LV-LM','Limbažu novads'),(415,'LV','Lubānas novads','Lubānas novads'),(416,'LV','LV-LU','Ludzas novads'),(417,'LV','Līgatnes novads','Līgatnes novads'),(418,'LV','Līvānu novads','Līvānu novads'),(419,'LV','LV-MA','Madonas novads'),(420,'LV','Mazsalacas novads','Mazsalacas novads'),(421,'LV','Mālpils novads','Mālpils novads'),(422,'LV','Mārupes novads','Mārupes novads'),(423,'LV','Naukšēnu novads','Naukšēnu novads'),(424,'LV','Neretas novads','Neretas novads'),(425,'LV','Nīcas novads','Nīcas novads'),(426,'LV','LV-OG','Ogres novads'),(427,'LV','Olaines novads','Olaines novads'),(428,'LV','Ozolnieku novads','Ozolnieku novads'),(429,'LV','LV-PR','Preiļu novads'),(430,'LV','Priekules novads','Priekules novads'),(431,'LV','Priekuļu novads','Priekuļu novads'),(432,'LV','Pārgaujas novads','Pārgaujas novads'),(433,'LV','Pāvilostas novads','Pāvilostas novads'),(434,'LV','Pļaviņu novads','Pļaviņu novads'),(435,'LV','Raunas novads','Raunas novads'),(436,'LV','Riebiņu novads','Riebiņu novads'),(437,'LV','Rojas novads','Rojas novads'),(438,'LV','Ropažu novads','Ropažu novads'),(439,'LV','Rucavas novads','Rucavas novads'),(440,'LV','Rugāju novads','Rugāju novads'),(441,'LV','Rundāles novads','Rundāles novads'),(442,'LV','LV-RE','Rēzeknes novads'),(443,'LV','Rūjienas novads','Rūjienas novads'),(444,'LV','Salacgrīvas novads','Salacgrīvas novads'),(445,'LV','Salas novads','Salas novads'),(446,'LV','Salaspils novads','Salaspils novads'),(447,'LV','LV-SA','Saldus novads'),(448,'LV','Saulkrastu novads','Saulkrastu novads'),(449,'LV','Siguldas novads','Siguldas novads'),(450,'LV','Skrundas novads','Skrundas novads'),(451,'LV','Skrīveru novads','Skrīveru novads'),(452,'LV','Smiltenes novads','Smiltenes novads'),(453,'LV','Stopiņu novads','Stopiņu novads'),(454,'LV','Strenču novads','Strenču novads'),(455,'LV','Sējas novads','Sējas novads'),(456,'LV','LV-TA','Talsu novads'),(457,'LV','LV-TU','Tukuma novads'),(458,'LV','Tērvetes novads','Tērvetes novads'),(459,'LV','Vaiņodes novads','Vaiņodes novads'),(460,'LV','LV-VK','Valkas novads'),(461,'LV','LV-VM','Valmieras novads'),(462,'LV','Varakļānu novads','Varakļānu novads'),(463,'LV','Vecpiebalgas novads','Vecpiebalgas novads'),(464,'LV','Vecumnieku novads','Vecumnieku novads'),(465,'LV','LV-VE','Ventspils novads'),(466,'LV','Viesītes novads','Viesītes novads'),(467,'LV','Viļakas novads','Viļakas novads'),(468,'LV','Viļānu novads','Viļānu novads'),(469,'LV','Vārkavas novads','Vārkavas novads'),(470,'LV','Zilupes novads','Zilupes novads'),(471,'LV','Ādažu novads','Ādažu novads'),(472,'LV','Ērgļu novads','Ērgļu novads'),(473,'LV','Ķeguma novads','Ķeguma novads'),(474,'LV','Ķekavas novads','Ķekavas novads'),(475,'LT','LT-AL','Alytaus Apskritis'),(476,'LT','LT-KU','Kauno Apskritis'),(477,'LT','LT-KL','Klaipėdos Apskritis'),(478,'LT','LT-MR','Marijampolės Apskritis'),(479,'LT','LT-PN','Panevėžio Apskritis'),(480,'LT','LT-SA','Šiaulių Apskritis'),(481,'LT','LT-TA','Tauragės Apskritis'),(482,'LT','LT-TE','Telšių Apskritis'),(483,'LT','LT-UT','Utenos Apskritis'),(484,'LT','LT-VL','Vilniaus Apskritis'),(485,'BR','AC','Acre'),(486,'BR','AL','Alagoas'),(487,'BR','AP','Amapá'),(488,'BR','AM','Amazonas'),(489,'BR','BA','Bahia'),(490,'BR','CE','Ceará'),(491,'BR','ES','Espírito Santo'),(492,'BR','GO','Goiás'),(493,'BR','MA','Maranhão'),(494,'BR','MT','Mato Grosso'),(495,'BR','MS','Mato Grosso do Sul'),(496,'BR','MG','Minas Gerais'),(497,'BR','PA','Pará'),(498,'BR','PB','Paraíba'),(499,'BR','PR','Paraná'),(500,'BR','PE','Pernambuco'),(501,'BR','PI','Piauí'),(502,'BR','RJ','Rio de Janeiro'),(503,'BR','RN','Rio Grande do Norte'),(504,'BR','RS','Rio Grande do Sul'),(505,'BR','RO','Rondônia'),(506,'BR','RR','Roraima'),(507,'BR','SC','Santa Catarina'),(508,'BR','SP','São Paulo'),(509,'BR','SE','Sergipe'),(510,'BR','TO','Tocantins'),(511,'BR','DF','Distrito Federal'),(512,'HR','HR-01','Zagrebačka županija'),(513,'HR','HR-02','Krapinsko-zagorska županija'),(514,'HR','HR-03','Sisačko-moslavačka županija'),(515,'HR','HR-04','Karlovačka županija'),(516,'HR','HR-05','Varaždinska županija'),(517,'HR','HR-06','Koprivničko-križevačka županija'),(518,'HR','HR-07','Bjelovarsko-bilogorska županija'),(519,'HR','HR-08','Primorsko-goranska županija'),(520,'HR','HR-09','Ličko-senjska županija'),(521,'HR','HR-10','Virovitičko-podravska županija'),(522,'HR','HR-11','Požeško-slavonska županija'),(523,'HR','HR-12','Brodsko-posavska županija'),(524,'HR','HR-13','Zadarska županija'),(525,'HR','HR-14','Osječko-baranjska županija'),(526,'HR','HR-15','Šibensko-kninska županija'),(527,'HR','HR-16','Vukovarsko-srijemska županija'),(528,'HR','HR-17','Splitsko-dalmatinska županija'),(529,'HR','HR-18','Istarska županija'),(530,'HR','HR-19','Dubrovačko-neretvanska županija'),(531,'HR','HR-20','Međimurska županija'),(532,'HR','HR-21','Grad Zagreb'),(533,'IN','AN','Andaman and Nicobar Islands'),(534,'IN','AP','Andhra Pradesh'),(535,'IN','AR','Arunachal Pradesh'),(536,'IN','AS','Assam'),(537,'IN','BR','Bihar'),(538,'IN','CH','Chandigarh'),(539,'IN','CT','Chhattisgarh'),(540,'IN','DN','Dadra and Nagar Haveli'),(541,'IN','DD','Daman and Diu'),(542,'IN','DL','Delhi'),(543,'IN','GA','Goa'),(544,'IN','GJ','Gujarat'),(545,'IN','HR','Haryana'),(546,'IN','HP','Himachal Pradesh'),(547,'IN','JK','Jammu and Kashmir'),(548,'IN','JH','Jharkhand'),(549,'IN','KA','Karnataka'),(550,'IN','KL','Kerala'),(551,'IN','LD','Lakshadweep'),(552,'IN','MP','Madhya Pradesh'),(553,'IN','MH','Maharashtra'),(554,'IN','MN','Manipur'),(555,'IN','ML','Meghalaya'),(556,'IN','MZ','Mizoram'),(557,'IN','NL','Nagaland'),(558,'IN','OR','Odisha'),(559,'IN','PY','Puducherry'),(560,'IN','PB','Punjab'),(561,'IN','RJ','Rajasthan'),(562,'IN','SK','Sikkim'),(563,'IN','TN','Tamil Nadu'),(564,'IN','TG','Telangana'),(565,'IN','TR','Tripura'),(566,'IN','UP','Uttar Pradesh'),(567,'IN','UT','Uttarakhand'),(568,'IN','WB','West Bengal');

--
-- Table structure for table `mag2_directory_country_region_name`
--

CREATE TABLE `mag2_directory_country_region_name` (
  `locale` varchar(8) NOT NULL COMMENT 'Locale',
  `region_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Region Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Region Name',
  PRIMARY KEY (`locale`,`region_id`),
  KEY `MAG2_DIRECTORY_COUNTRY_REGION_NAME_REGION_ID` (`region_id`),
  CONSTRAINT `FK_A53F10CEF9F5A8E2A0C05C49233FEDED` FOREIGN KEY (`region_id`) REFERENCES `mag2_directory_country_region` (`region_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Region Name';

--
-- Dumping data for table `mag2_directory_country_region_name`
--

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

--
-- Table structure for table `mag2_directory_currency_rate`
--

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

--
-- Dumping data for table `mag2_directory_currency_rate`
--

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

--
-- Table structure for table `mag2_downloadable_link`
--

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

--
-- Dumping data for table `mag2_downloadable_link`
--


--
-- Table structure for table `mag2_downloadable_link_price`
--

CREATE TABLE `mag2_downloadable_link_price` (
  `price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price',
  PRIMARY KEY (`price_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_PRICE_LINK_ID` (`link_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `MAG2_DOWNLOADABLE_LINK_PRICE_LINK_ID_DOWNLOADABLE_LINK_LINK_ID` FOREIGN KEY (`link_id`) REFERENCES `mag2_downloadable_link` (`link_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_DOWNLOADABLE_LINK_PRICE_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `mag2_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Price Table';

--
-- Dumping data for table `mag2_downloadable_link_price`
--


--
-- Table structure for table `mag2_downloadable_link_purchased`
--

CREATE TABLE `mag2_downloadable_link_purchased` (
  `purchased_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Purchased ID',
  `order_id` int(10) unsigned DEFAULT '0' COMMENT 'Order ID',
  `order_increment_id` varchar(50) DEFAULT NULL COMMENT 'Order Increment ID',
  `order_item_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Order Item ID',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date of creation',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of modification',
  `customer_id` int(10) unsigned DEFAULT '0' COMMENT 'Customer ID',
  `product_name` varchar(255) DEFAULT NULL COMMENT 'Product name',
  `product_sku` varchar(255) DEFAULT NULL COMMENT 'Product sku',
  `link_section_title` varchar(255) DEFAULT NULL COMMENT 'Link_section_title',
  PRIMARY KEY (`purchased_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_PURCHASED_ORDER_ID` (`order_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_PURCHASED_ORDER_ITEM_ID` (`order_item_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_PURCHASED_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `MAG2_DL_LNK_PURCHASED_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `MAG2_DOWNLOADABLE_LINK_PURCHASED_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `mag2_sales_order` (`entity_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Table';

--
-- Dumping data for table `mag2_downloadable_link_purchased`
--


--
-- Table structure for table `mag2_downloadable_link_purchased_item`
--

CREATE TABLE `mag2_downloadable_link_purchased_item` (
  `item_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Item ID',
  `purchased_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Purchased ID',
  `order_item_id` int(10) unsigned DEFAULT '0' COMMENT 'Order Item ID',
  `product_id` int(10) unsigned DEFAULT '0' COMMENT 'Product ID',
  `link_hash` varchar(255) DEFAULT NULL COMMENT 'Link hash',
  `number_of_downloads_bought` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads bought',
  `number_of_downloads_used` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Number of downloads used',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `link_title` varchar(255) DEFAULT NULL COMMENT 'Link Title',
  `is_shareable` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Shareable Flag',
  `link_url` varchar(255) DEFAULT NULL COMMENT 'Link Url',
  `link_file` varchar(255) DEFAULT NULL COMMENT 'Link File',
  `link_type` varchar(255) DEFAULT NULL COMMENT 'Link Type',
  `status` varchar(50) DEFAULT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
  PRIMARY KEY (`item_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_PURCHASED_ITEM_LINK_HASH` (`link_hash`),
  KEY `MAG2_DOWNLOADABLE_LINK_PURCHASED_ITEM_ORDER_ITEM_ID` (`order_item_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_PURCHASED_ITEM_PURCHASED_ID` (`purchased_id`),
  CONSTRAINT `FK_BF0CC271D36E609EB33EACDB0A4C4D34` FOREIGN KEY (`purchased_id`) REFERENCES `mag2_downloadable_link_purchased` (`purchased_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C756D770101388938A2916DE94CBC862` FOREIGN KEY (`order_item_id`) REFERENCES `mag2_sales_order_item` (`item_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Item Table';

--
-- Dumping data for table `mag2_downloadable_link_purchased_item`
--


--
-- Table structure for table `mag2_downloadable_link_title`
--

CREATE TABLE `mag2_downloadable_link_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `MAG2_DOWNLOADABLE_LINK_TITLE_LINK_ID_STORE_ID` (`link_id`,`store_id`),
  KEY `MAG2_DOWNLOADABLE_LINK_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_DOWNLOADABLE_LINK_TITLE_LINK_ID_DOWNLOADABLE_LINK_LINK_ID` FOREIGN KEY (`link_id`) REFERENCES `mag2_downloadable_link` (`link_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_DOWNLOADABLE_LINK_TITLE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link Title Table';

--
-- Dumping data for table `mag2_downloadable_link_title`
--


--
-- Table structure for table `mag2_downloadable_sample`
--

CREATE TABLE `mag2_downloadable_sample` (
  `sample_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Sample ID',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product ID',
  `sample_url` varchar(255) DEFAULT NULL COMMENT 'Sample URL',
  `sample_file` varchar(255) DEFAULT NULL COMMENT 'Sample file',
  `sample_type` varchar(20) DEFAULT NULL COMMENT 'Sample Type',
  `sort_order` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`sample_id`),
  KEY `MAG2_DOWNLOADABLE_SAMPLE_PRODUCT_ID` (`product_id`),
  CONSTRAINT `MAG2_DL_SAMPLE_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `mag2_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Table';

--
-- Dumping data for table `mag2_downloadable_sample`
--


--
-- Table structure for table `mag2_downloadable_sample_title`
--

CREATE TABLE `mag2_downloadable_sample_title` (
  `title_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Title ID',
  `sample_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Sample ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  PRIMARY KEY (`title_id`),
  UNIQUE KEY `MAG2_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID_STORE_ID` (`sample_id`,`store_id`),
  KEY `MAG2_DOWNLOADABLE_SAMPLE_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_DL_SAMPLE_TTL_SAMPLE_ID_DL_SAMPLE_SAMPLE_ID` FOREIGN KEY (`sample_id`) REFERENCES `mag2_downloadable_sample` (`sample_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_DOWNLOADABLE_SAMPLE_TITLE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Title Table';

--
-- Dumping data for table `mag2_downloadable_sample_title`
--


--
-- Table structure for table `mag2_eav_attribute`
--

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

--
-- Dumping data for table `mag2_eav_attribute`
--



--
-- Table structure for table `mag2_eav_attribute_group`
--

CREATE TABLE `mag2_eav_attribute_group` (
  `attribute_group_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Group Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `attribute_group_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Group Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `default_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Default Id',
  `attribute_group_code` varchar(255) NOT NULL COMMENT 'Attribute Group Code',
  `tab_group_code` varchar(255) DEFAULT NULL COMMENT 'Tab Group Code',
  PRIMARY KEY (`attribute_group_id`),
  UNIQUE KEY `MAG2_CAT_CTGR_PRD_ATTR_SET_ID_ATTR_GROUP_CODE` (`attribute_set_id`,`attribute_group_code`),
  UNIQUE KEY `MAG2_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME` (`attribute_set_id`,`attribute_group_name`),
  KEY `MAG2_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
  CONSTRAINT `MAG2_EAV_ATTR_GROUP_ATTR_SET_ID_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `mag2_eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=93 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Group';

--
-- Dumping data for table `mag2_eav_attribute_group`
--

INSERT INTO `mag2_eav_attribute_group` VALUES (1,1,'General',1,1,'general',NULL),(2,2,'General',1,1,'general',NULL),(3,3,'General',10,1,'general',NULL),(4,3,'General Information',2,0,'general-information',NULL),(5,3,'Display Settings',20,0,'display-settings',NULL),(6,3,'Custom Design',30,0,'custom-design',NULL),(7,4,'Product Details',10,1,'product-details','basic'),(8,4,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(9,4,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(10,4,'Image Management',20,0,'image-management','basic'),(11,4,'Design',50,0,'design','advanced'),(12,4,'Autosettings',60,0,'autosettings','advanced'),(13,4,'Content',15,0,'content','basic'),(14,4,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(15,4,'Bundle Items',16,0,'bundle-items',NULL),(16,5,'General',1,1,'general',NULL),(17,6,'General',1,1,'general',NULL),(18,7,'General',1,1,'general',NULL),(19,8,'General',1,1,'general',NULL),(20,4,'Gift Options',61,0,'gift-options',NULL),(21,9,'Gift Options',61,0,'gift-options',NULL),(22,9,'Autosettings',60,0,'autosettings','advanced'),(23,9,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(24,9,'Design',50,0,'design','advanced'),(25,9,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(26,9,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(27,9,'Image Management',20,0,'image-management','basic'),(28,9,'Bundle Items',16,0,'bundle-items',NULL),(29,9,'Content',15,0,'content','basic'),(30,9,'Product Details',10,1,'product-details','basic'),(31,10,'Gift Options',61,0,'gift-options',NULL),(32,10,'Autosettings',60,0,'autosettings','advanced'),(33,10,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(34,10,'Design',50,0,'design','advanced'),(35,10,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(36,10,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(37,10,'Image Management',20,0,'image-management','basic'),(38,10,'Bundle Items',16,0,'bundle-items',NULL),(39,10,'Content',15,0,'content','basic'),(40,10,'Product Details',10,1,'product-details','basic'),(41,11,'Gift Options',61,0,'gift-options',NULL),(42,11,'Autosettings',60,0,'autosettings','advanced'),(43,11,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(44,11,'Design',50,0,'design','advanced'),(45,11,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(46,11,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(47,11,'Image Management',20,0,'image-management','basic'),(48,11,'Bundle Items',16,0,'bundle-items',NULL),(49,11,'Content',15,0,'content','basic'),(50,11,'Product Details',10,1,'product-details','basic'),(51,12,'Gift Options',61,0,'gift-options',NULL),(52,12,'Autosettings',60,0,'autosettings','advanced'),(53,12,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(54,12,'Design',50,0,'design','advanced'),(55,12,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(56,12,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(57,12,'Image Management',20,0,'image-management','basic'),(58,12,'Bundle Items',16,0,'bundle-items',NULL),(59,12,'Content',15,0,'content','basic'),(60,12,'Product Details',10,1,'product-details','basic'),(61,13,'Gift Options',61,0,'gift-options',NULL),(62,13,'Autosettings',60,0,'autosettings','advanced'),(63,13,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(64,13,'Design',50,0,'design','advanced'),(65,13,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(66,13,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(67,13,'Image Management',20,0,'image-management','basic'),(68,13,'Bundle Items',16,0,'bundle-items',NULL),(69,13,'Content',15,0,'content','basic'),(70,13,'Product Details',10,1,'product-details','basic'),(71,14,'Gift Options',61,0,'gift-options',NULL),(72,14,'Autosettings',60,0,'autosettings','advanced'),(73,14,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(74,14,'Design',50,0,'design','advanced'),(75,14,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(76,14,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(77,14,'Image Management',20,0,'image-management','basic'),(78,14,'Bundle Items',16,0,'bundle-items',NULL),(79,14,'Content',15,0,'content','basic'),(80,14,'Product Details',10,1,'product-details','basic'),(81,15,'Gift Options',61,0,'gift-options',NULL),(82,15,'Autosettings',60,0,'autosettings','advanced'),(83,15,'Schedule Design Update',55,0,'schedule-design-update','advanced'),(84,15,'Design',50,0,'design','advanced'),(85,15,'Advanced Pricing',40,0,'advanced-pricing','advanced'),(86,15,'Search Engine Optimization',30,0,'search-engine-optimization','basic'),(87,15,'Image Management',20,0,'image-management','basic'),(88,15,'Bundle Items',16,0,'bundle-items',NULL),(89,15,'Content',15,0,'content','basic'),(90,15,'Product Details',10,1,'product-details','basic'),(91,3,'Wokiee Megamenu',31,0,'wokiee-megamenu',NULL),(92,4,'Attributes',62,0,'attributes',NULL);

--
-- Table structure for table `mag2_eav_attribute_label`
--

CREATE TABLE `mag2_eav_attribute_label` (
  `attribute_label_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Label Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`attribute_label_id`),
  KEY `MAG2_EAV_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
  KEY `MAG2_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID` (`attribute_id`,`store_id`),
  CONSTRAINT `MAG2_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ATTRIBUTE_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Label';

--
-- Dumping data for table `mag2_eav_attribute_label`
--

INSERT INTO `mag2_eav_attribute_label` VALUES (2,135,1,'Style'),(6,140,1,'Category'),(11,148,1,'Style'),(13,149,1,'Style'),(20,180,1,'Brand'),(21,180,2,'الماركة'),(24,181,1,'charachter'),(25,181,2,'الحرف'),(40,139,1,'Gender'),(41,139,2,'الجنس'),(42,182,2,'الجنس'),(43,141,1,'Size'),(44,141,2,'الحجم'),(45,183,2,'الحجم');

--
-- Table structure for table `mag2_eav_attribute_option`
--

CREATE TABLE `mag2_eav_attribute_option` (
  `option_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Option Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `sort_order` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`option_id`),
  KEY `MAG2_EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `MAG2_EAV_ATTR_OPT_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=225 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option';

--
-- Dumping data for table `mag2_eav_attribute_option`
--

INSERT INTO `mag2_eav_attribute_option` VALUES (1,20,0),(2,20,1),(3,20,3),(4,134,0),(5,134,1),(6,134,2),(7,134,3),(8,134,4),(9,134,5),(10,134,6),(11,134,7),(12,134,8),(13,134,9),(14,134,10),(15,134,11),(16,134,12),(17,134,13),(18,134,14),(19,134,15),(20,134,16),(21,134,17),(22,134,18),(23,134,19),(24,135,0),(25,135,1),(26,135,2),(27,135,3),(28,135,4),(29,135,5),(30,135,6),(31,136,0),(32,136,1),(33,136,2),(34,136,3),(35,136,4),(36,136,5),(37,136,6),(38,136,7),(39,136,8),(40,136,9),(41,136,10),(42,136,11),(43,136,12),(44,136,13),(45,136,14),(46,136,15),(47,136,16),(48,136,17),(49,93,0),(50,93,1),(51,93,2),(52,93,3),(53,93,4),(54,93,5),(55,93,6),(56,93,7),(57,93,8),(58,93,9),(59,93,10),(60,93,11),(61,137,0),(62,137,1),(63,137,2),(64,137,3),(65,137,4),(66,137,5),(67,137,6),(68,137,7),(69,138,0),(70,138,1),(71,138,2),(72,138,3),(73,138,4),(74,138,5),(75,138,6),(76,138,7),(77,138,8),(78,138,9),(79,138,10),(80,139,0),(81,139,1),(82,139,2),(85,140,0),(86,140,1),(87,140,2),(88,140,3),(89,140,4),(90,140,5),(91,141,0),(92,141,2),(93,141,4),(97,142,0),(98,143,0),(99,144,0),(100,145,0),(101,146,0),(102,147,0),(103,147,1),(104,147,2),(105,148,0),(106,148,1),(107,148,2),(108,148,3),(109,148,4),(110,148,5),(111,148,6),(112,148,7),(113,148,8),(114,148,9),(115,148,10),(116,148,11),(117,149,0),(118,149,1),(119,149,2),(120,149,3),(121,149,4),(122,149,5),(123,149,6),(124,149,7),(125,149,8),(126,149,9),(127,149,10),(128,149,11),(129,149,12),(130,149,13),(131,149,14),(132,149,15),(133,149,16),(134,149,17),(135,149,18),(136,149,19),(137,149,20),(138,149,21),(139,149,22),(140,149,23),(141,149,24),(142,149,25),(143,136,0),(144,136,1),(145,136,2),(146,136,3),(147,136,4),(148,136,5),(149,136,6),(150,136,7),(151,136,8),(152,136,9),(153,136,10),(154,136,11),(155,136,12),(156,136,13),(157,136,14),(158,136,15),(159,136,16),(160,136,17),(161,150,0),(162,150,1),(163,150,2),(164,150,3),(165,150,4),(166,150,5),(167,141,1),(168,141,3),(169,141,5),(181,151,0),(182,151,1),(183,151,2),(184,151,3),(185,151,4),(186,151,5),(187,151,6),(188,151,7),(189,151,8),(190,151,9),(191,151,10),(192,151,11),(193,152,0),(194,152,1),(195,152,2),(196,152,3),(197,152,4),(198,152,5),(199,152,6),(200,152,7),(201,152,8),(202,153,0),(203,153,1),(204,153,2),(205,153,3),(206,153,4),(207,153,5),(208,153,6),(209,153,7),(210,153,8),(211,153,9),(212,153,10),(213,180,1),(214,181,1),(215,181,2),(216,182,0),(217,182,0),(218,182,0),(219,183,1),(220,183,2),(221,183,3),(222,183,4),(223,183,5),(224,183,6);

--
-- Table structure for table `mag2_eav_attribute_option_swatch`
--

CREATE TABLE `mag2_eav_attribute_option_swatch` (
  `swatch_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Swatch ID',
  `option_id` int(10) unsigned NOT NULL COMMENT 'Option ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  `type` smallint(5) unsigned NOT NULL COMMENT 'Swatch type: 0 - text, 1 - visual color, 2 - visual image',
  `value` varchar(255) DEFAULT NULL COMMENT 'Swatch Value',
  PRIMARY KEY (`swatch_id`),
  UNIQUE KEY `MAG2_EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_OPTION_ID` (`store_id`,`option_id`),
  KEY `MAG2_EAV_ATTRIBUTE_OPTION_SWATCH_SWATCH_ID` (`swatch_id`),
  KEY `MAG2_EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` (`option_id`),
  CONSTRAINT `MAG2_EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ATTR_OPT_SWATCH_OPT_ID_EAV_ATTR_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `mag2_eav_attribute_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=77 DEFAULT CHARSET=utf8 COMMENT='Magento Swatches table';

--
-- Dumping data for table `mag2_eav_attribute_option_swatch`
--

INSERT INTO `mag2_eav_attribute_option_swatch` VALUES (1,49,0,1,'#000000'),(2,50,0,1,'#1857f7'),(3,51,0,1,'#945454'),(4,52,0,1,'#8f8f8f'),(5,53,0,1,'#53a828'),(6,54,0,1,'#ce64d4'),(7,55,0,1,'#ffffff'),(8,56,0,1,'#eb6703'),(9,57,0,1,'#ef3dff'),(10,58,0,1,'#ff0000'),(11,59,0,1,'#ffffff'),(12,60,0,1,'#ffd500'),(13,91,0,0,'50 ML'),(14,91,1,0,'50 ML'),(15,167,0,0,'60 ML'),(16,167,1,0,'60 ML'),(17,92,0,0,'100 ML'),(18,92,1,0,'100 ML'),(19,168,0,0,'250 ML'),(20,168,1,0,'250 ML'),(21,93,0,0,'500 ML'),(22,93,1,0,'500 ML'),(23,169,0,0,'1000 ML'),(24,169,1,0,'1000 ML'),(53,91,2,0,'50 مل'),(54,167,2,0,'60 مل'),(55,92,2,0,'100 مل'),(56,168,2,0,'250 مل'),(57,93,2,0,'500 مل'),(58,169,2,0,'1000 مل'),(59,214,0,0,'A'),(60,214,1,0,'A'),(61,214,2,0,'A'),(62,215,0,0,'B'),(63,215,1,0,'B'),(64,215,2,0,'B'),(65,219,0,0,'50 ML'),(66,219,1,0,'50 ML'),(67,220,0,0,'60 ML'),(68,220,1,0,'60 ML'),(69,221,0,0,'100 ML'),(70,221,1,0,'100 ML'),(71,222,0,0,'250 ML'),(72,222,1,0,'250 ML'),(73,223,0,0,'500 ML'),(74,223,1,0,'500 ML'),(75,224,0,0,'1000 ML'),(76,224,1,0,'1000 ML');

--
-- Table structure for table `mag2_eav_attribute_option_value`
--

CREATE TABLE `mag2_eav_attribute_option_value` (
  `value_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `option_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Option Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Value',
  PRIMARY KEY (`value_id`),
  KEY `MAG2_EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID` (`option_id`),
  KEY `MAG2_EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ATTR_OPT_VAL_OPT_ID_EAV_ATTR_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `mag2_eav_attribute_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=349 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option Value';

--
-- Dumping data for table `mag2_eav_attribute_option_value`
--

INSERT INTO `mag2_eav_attribute_option_value` VALUES (1,1,0,'Male'),(2,2,0,'Female'),(3,3,0,'Not Specified'),(4,4,0,'Hike'),(5,5,0,'Outdoor'),(6,6,0,'Running'),(7,7,0,'Warmup'),(8,8,0,'Yoga'),(9,9,0,'Recreation'),(10,10,0,'Lounge'),(11,11,0,'Gym'),(12,12,0,'Climbing'),(13,13,0,'Crosstraining'),(14,14,0,'Post-workout'),(15,15,0,'Cycling'),(16,16,0,'Athletic'),(17,17,0,'Sports'),(18,18,0,'Hiking'),(19,19,0,'Overnight'),(20,20,0,'School'),(21,21,0,'Trail'),(22,22,0,'Travel'),(23,23,0,'Urban'),(24,24,0,'Backpack'),(25,25,0,'Luggage'),(26,26,0,'Duffel'),(27,27,0,'Messenger'),(28,28,0,'Laptop'),(29,29,0,'Exercise'),(30,30,0,'Tote'),(31,31,0,'Burlap'),(32,32,0,'Canvas'),(33,33,0,'Cotton'),(34,34,0,'Faux Leather'),(35,35,0,'Leather'),(36,36,0,'Mesh'),(37,37,0,'Nylon'),(38,38,0,'Polyester'),(39,39,0,'Rayon'),(40,40,0,'Ripstop'),(41,41,0,'Suede'),(42,42,0,'Foam'),(43,43,0,'Metal'),(44,44,0,'Plastic'),(45,45,0,'Rubber'),(46,46,0,'Synthetic'),(47,47,0,'Stainless Steel'),(48,48,0,'Silicone'),(61,61,0,'Adjustable'),(62,62,0,'Cross Body'),(63,63,0,'Detachable'),(64,64,0,'Double'),(65,65,0,'Padded'),(66,66,0,'Shoulder'),(67,67,0,'Single'),(68,68,0,'Telescoping'),(69,69,0,'Audio Pocket'),(70,70,0,'Wheeled'),(71,71,0,'Hydration Pocket'),(72,72,0,'Audio Pocket'),(73,73,0,'Flapover'),(74,74,0,'Waterproof'),(75,75,0,'Lightweight'),(76,76,0,'TSA Approved'),(77,77,0,'Reflective'),(78,78,0,'Laptop Sleeve'),(79,79,0,'Lockable'),(85,85,0,'Cardio'),(86,86,0,'Electronic'),(87,87,0,'Exercise'),(88,88,0,'Fashion'),(89,89,0,'Hydration'),(90,90,0,'Timepiece'),(97,102,0,'Download'),(98,103,0,'DVD'),(99,105,0,'Base Layer'),(100,106,0,'Basic'),(101,107,0,'Capri'),(102,108,0,'Compression'),(103,109,0,'Leggings'),(104,110,0,'Parachute'),(105,111,0,'Skort'),(106,112,0,'Snug'),(107,113,0,'Sweatpants'),(108,114,0,'Tights'),(109,115,0,'Track Pants'),(110,116,0,'Workout Pants'),(111,117,0,'Insulated'),(112,118,0,'Jacket'),(113,119,0,'Vest'),(114,120,0,'Lightweight'),(115,121,0,'Hooded'),(116,122,0,'Heavy Duty'),(117,123,0,'Rain Coat'),(118,124,0,'Hard Shell'),(119,125,0,'Soft Shell'),(120,126,0,'Windbreaker'),(121,127,0,'&frac12; zip'),(122,128,0,'&frac14; zip'),(123,129,0,'Full Zip'),(124,130,0,'Reversible'),(125,131,0,'Bra'),(126,132,0,'Hoodie'),(127,133,0,'Sweatshirt'),(128,134,0,'Polo'),(129,135,0,'Tank'),(130,136,0,'Tee'),(131,137,0,'Pullover'),(132,138,0,'Hoodie'),(133,139,0,'Cardigan'),(134,140,0,'Henley'),(135,141,0,'Tunic'),(136,142,0,'Camisole'),(137,143,0,'Cocona&reg; performance fabric'),(138,144,0,'Wool'),(139,145,0,'Fleece'),(140,146,0,'Hemp'),(141,147,0,'Jersey'),(142,148,0,'LumaTech&trade;'),(143,149,0,'Lycra&reg;'),(144,150,0,'Microfiber'),(145,151,0,'Spandex'),(146,152,0,'HeatTec&reg;'),(147,153,0,'EverCool&trade;'),(148,154,0,'Organic Cotton'),(149,155,0,'TENCEL'),(150,156,0,'CoolTech&trade;'),(151,157,0,'Khaki'),(152,158,0,'Linen'),(153,159,0,'Wool'),(154,160,0,'Terry'),(155,161,0,'Sleeve'),(156,162,0,'Long-Sleeve'),(157,163,0,'Short-Sleeve'),(158,164,0,'Sleeveless'),(159,165,0,'Tank'),(160,166,0,'Strap'),(175,181,0,'N/A'),(176,182,0,'? zip'),(177,183,0,'Boat Neck'),(178,184,0,'Crew'),(179,185,0,'Full zip'),(180,186,0,'V-neck'),(181,187,0,'Ballet'),(182,188,0,'Scoop'),(183,189,0,'High Collar'),(184,190,0,'Stand Collar'),(185,191,0,'Roll Neck'),(186,192,0,'Square Neck'),(187,193,0,'Color-Blocked'),(188,194,0,'Checked'),(189,195,0,'Color-Blocked'),(190,196,0,'Graphic Print'),(191,197,0,'Solid'),(192,198,0,'Solid-Highlight'),(193,199,0,'Striped'),(194,200,0,'Camo'),(195,201,0,'Geometric'),(196,202,0,'All-Weather'),(197,203,0,'Cold'),(198,204,0,'Cool'),(199,205,0,'Indoor'),(200,206,0,'Mild'),(201,207,0,'Rainy'),(202,208,0,'Spring'),(203,209,0,'Warm'),(204,210,0,'Windy'),(205,211,0,'Wintry'),(206,212,0,'Hot'),(207,49,0,'Black'),(208,50,0,'Blue'),(209,51,0,'Brown'),(210,52,0,'Gray'),(211,53,0,'Green'),(212,54,0,'Lavender'),(213,55,0,'Multi'),(214,56,0,'Orange'),(215,57,0,'Purple'),(216,58,0,'Red'),(217,59,0,'White'),(218,60,0,'Yellow'),(248,213,1,'Nika'),(249,213,0,'Nika'),(250,213,2,'Nika'),(257,214,0,'A'),(258,215,0,'B'),(313,80,1,'Women'),(314,80,0,'Women'),(315,80,2,'نسائي'),(316,81,1,'Kids'),(317,81,0,'Kids'),(318,81,2,'أطفال'),(319,82,1,'Men'),(320,82,0,'Men'),(321,82,2,'رجالي'),(322,216,1,'Women'),(323,216,0,'Women'),(324,216,2,'نسائي'),(325,217,1,'Kids'),(326,217,0,'Kids'),(327,217,2,'اطفال'),(328,218,1,'Men'),(329,218,0,'Men'),(330,218,2,'رجالي'),(331,91,0,'50 ML'),(332,167,0,'60 ML'),(333,92,0,'100 ML'),(334,168,0,'250 ML'),(335,93,0,'500 ML'),(336,169,0,'1000 ML'),(337,219,1,'50 ML'),(338,219,0,'50 ML'),(339,220,1,'60 ML'),(340,220,0,'60 ML'),(341,221,1,'100 ML'),(342,221,0,'100 ML'),(343,222,1,'250 ML'),(344,222,0,'250 ML'),(345,223,1,'500 ML'),(346,223,0,'500 ML'),(347,224,1,'1000 ML'),(348,224,0,'1000 ML');

--
-- Table structure for table `mag2_eav_attribute_set`
--

CREATE TABLE `mag2_eav_attribute_set` (
  `attribute_set_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Attribute Set Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_name` varchar(255) DEFAULT NULL COMMENT 'Attribute Set Name',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`attribute_set_id`),
  UNIQUE KEY `MAG2_EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME` (`entity_type_id`,`attribute_set_name`),
  KEY `MAG2_EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_SORT_ORDER` (`entity_type_id`,`sort_order`),
  CONSTRAINT `MAG2_EAV_ATTR_SET_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `mag2_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Set';

--
-- Dumping data for table `mag2_eav_attribute_set`
--

INSERT INTO `mag2_eav_attribute_set` VALUES (1,1,'Default',2),(2,2,'Default',2),(3,3,'Default',1),(4,4,'Default',1),(5,5,'Default',1),(6,6,'Default',1),(7,7,'Default',1),(8,8,'Default',1),(9,4,'Top',0),(10,4,'Bottom',0),(11,4,'Gear',0),(12,4,'Sprite Stasis Ball',0),(13,4,'Sprite Yoga Strap',0),(14,4,'Downloadable',0),(15,4,'Bag',0);

--
-- Table structure for table `mag2_eav_entity`
--

CREATE TABLE `mag2_eav_entity` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `increment_id` varchar(50) DEFAULT NULL COMMENT 'Increment Id',
  `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Parent Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `is_active` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Defines Is Entity Active',
  PRIMARY KEY (`entity_id`),
  KEY `MAG2_EAV_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `MAG2_EAV_ENTITY_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_EAV_ENTITY_ENTITY_TYPE_ID_EAV_ENTITY_TYPE_ENTITY_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `mag2_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTITY_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity';

--
-- Dumping data for table `mag2_eav_entity`
--


--
-- Table structure for table `mag2_eav_entity_attribute`
--

CREATE TABLE `mag2_eav_entity_attribute` (
  `entity_attribute_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Attribute Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_set_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Set Id',
  `attribute_group_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Group Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`entity_attribute_id`),
  UNIQUE KEY `MAG2_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID` (`attribute_set_id`,`attribute_id`),
  UNIQUE KEY `MAG2_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID` (`attribute_group_id`,`attribute_id`),
  KEY `MAG2_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
  KEY `MAG2_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `MAG2_EAV_ENTT_ATTR_ATTR_GROUP_ID_EAV_ATTR_GROUP_ATTR_GROUP_ID` FOREIGN KEY (`attribute_group_id`) REFERENCES `mag2_eav_attribute_group` (`attribute_group_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTT_ATTR_ATTR_ID_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=731 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Attributes';

--
-- Dumping data for table `mag2_eav_entity_attribute`
--

INSERT INTO `mag2_eav_entity_attribute` VALUES (1,1,1,1,1,10),(2,1,1,1,2,20),(3,1,1,1,3,20),(4,1,1,1,4,30),(5,1,1,1,5,40),(6,1,1,1,6,50),(7,1,1,1,7,60),(8,1,1,1,8,70),(9,1,1,1,9,80),(10,1,1,1,10,25),(11,1,1,1,11,90),(12,1,1,1,12,81),(13,1,1,1,13,115),(14,1,1,1,14,120),(15,1,1,1,15,82),(16,1,1,1,16,83),(17,1,1,1,17,100),(18,1,1,1,18,0),(19,1,1,1,19,0),(20,1,1,1,20,110),(21,1,1,1,21,28),(22,2,2,2,22,10),(23,2,2,2,23,20),(24,2,2,2,24,30),(25,2,2,2,25,40),(26,2,2,2,26,50),(27,2,2,2,27,60),(28,2,2,2,28,70),(29,2,2,2,29,80),(30,2,2,2,30,90),(31,2,2,2,31,100),(32,2,2,2,32,100),(33,2,2,2,33,110),(34,2,2,2,34,120),(35,2,2,2,35,130),(36,2,2,2,36,140),(37,2,2,2,37,132),(38,2,2,2,38,133),(39,2,2,2,39,134),(40,2,2,2,40,135),(41,1,1,1,41,87),(42,1,1,1,42,100),(43,1,1,1,43,110),(44,1,1,1,44,120),(45,3,3,4,45,1),(46,3,3,4,46,2),(47,3,3,4,47,4),(48,3,3,4,48,5),(49,3,3,4,49,6),(50,3,3,4,50,7),(51,3,3,4,51,8),(52,3,3,5,52,10),(53,3,3,5,53,20),(54,3,3,5,54,30),(55,3,3,4,55,12),(56,3,3,4,56,13),(57,3,3,4,57,14),(58,3,3,4,58,15),(59,3,3,4,59,16),(60,3,3,6,60,10),(61,3,3,6,61,30),(62,3,3,6,62,40),(63,3,3,6,63,50),(64,3,3,6,64,60),(65,3,3,4,65,24),(66,3,3,4,66,25),(67,3,3,5,67,40),(68,3,3,5,68,50),(69,3,3,4,69,10),(70,3,3,6,70,5),(71,3,3,6,71,6),(72,3,3,5,72,51),(73,4,4,7,73,10),(74,4,4,7,74,20),(75,4,4,13,75,90),(76,4,4,13,76,100),(77,4,4,7,77,30),(78,4,4,8,78,3),(79,4,4,8,79,4),(80,4,4,8,80,5),(81,4,4,8,81,6),(82,4,4,7,82,70),(83,4,4,9,84,20),(84,4,4,9,85,30),(85,4,4,9,86,40),(86,4,4,10,87,1),(87,4,4,10,88,2),(88,4,4,10,89,3),(89,4,4,10,90,4),(90,4,4,7,91,6),(91,4,4,8,92,7),(92,4,4,7,94,90),(93,4,4,7,95,100),(94,4,4,10,96,5),(95,4,4,7,97,5),(96,4,4,8,98,8),(97,4,4,7,99,80),(98,4,4,14,100,40),(99,4,4,14,101,20),(100,4,4,14,102,30),(101,4,4,11,103,10),(102,4,4,11,104,5),(103,4,4,7,105,80),(104,4,4,11,106,6),(105,4,4,7,107,14),(106,4,4,7,108,15),(107,4,4,7,109,16),(108,4,4,7,110,17),(109,4,4,7,111,18),(110,4,4,7,112,19),(111,4,4,7,113,20),(112,4,4,7,114,110),(113,4,4,7,115,60),(114,4,4,14,116,50),(115,4,4,7,117,31),(116,4,4,7,118,21),(117,4,4,7,119,71),(118,4,4,8,120,9),(119,4,4,15,121,1),(120,4,4,8,122,10),(121,4,4,8,123,11),(122,3,3,4,124,3),(123,3,3,4,125,17),(124,4,4,9,126,10),(125,4,4,7,127,11),(126,4,4,7,128,111),(127,4,4,7,129,112),(128,4,4,7,130,113),(129,4,4,7,131,114),(130,4,4,7,132,40),(131,4,4,20,133,10),(132,4,9,21,133,10),(133,4,9,23,101,20),(134,4,9,23,102,30),(135,4,9,23,100,40),(136,4,9,23,116,50),(137,4,9,24,104,5),(138,4,9,24,106,6),(139,4,9,24,103,10),(140,4,9,25,78,3),(141,4,9,25,79,4),(142,4,9,25,80,5),(143,4,9,25,81,6),(144,4,9,25,92,7),(145,4,9,25,98,8),(146,4,9,25,120,9),(147,4,9,25,122,10),(148,4,9,25,123,11),(149,4,9,26,126,10),(150,4,9,26,84,20),(151,4,9,26,85,30),(152,4,9,26,86,40),(153,4,9,27,87,1),(154,4,9,27,88,2),(155,4,9,27,89,3),(156,4,9,27,90,4),(157,4,9,27,96,5),(158,4,9,28,121,1),(159,4,9,29,75,90),(160,4,9,29,76,100),(161,4,9,30,97,5),(162,4,9,30,91,6),(163,4,9,30,73,10),(164,4,9,30,127,11),(165,4,9,30,107,14),(166,4,9,30,108,15),(167,4,9,30,109,16),(168,4,9,30,110,17),(169,4,9,30,111,18),(170,4,9,30,112,19),(171,4,9,30,74,20),(172,4,9,30,113,20),(173,4,9,30,118,21),(174,4,9,30,77,30),(175,4,9,30,117,31),(176,4,9,30,132,40),(177,4,9,30,115,60),(178,4,9,30,82,70),(179,4,9,30,119,71),(180,4,9,30,105,80),(181,4,9,30,99,80),(182,4,9,30,94,90),(183,4,9,30,95,100),(184,4,9,30,114,110),(185,4,9,30,128,111),(186,4,9,30,129,112),(187,4,9,30,130,113),(188,4,9,30,131,114),(190,4,9,30,134,1000),(191,4,10,31,133,10),(192,4,10,33,101,20),(193,4,10,33,102,30),(194,4,10,33,100,40),(195,4,10,33,116,50),(196,4,10,34,104,5),(197,4,10,34,106,6),(198,4,10,34,103,10),(199,4,10,35,78,3),(200,4,10,35,79,4),(201,4,10,35,80,5),(202,4,10,35,81,6),(203,4,10,35,92,7),(204,4,10,35,98,8),(205,4,10,35,120,9),(206,4,10,35,122,10),(207,4,10,35,123,11),(208,4,10,36,126,10),(209,4,10,36,84,20),(210,4,10,36,85,30),(211,4,10,36,86,40),(212,4,10,37,87,1),(213,4,10,37,88,2),(214,4,10,37,89,3),(215,4,10,37,90,4),(216,4,10,37,96,5),(217,4,10,38,121,1),(218,4,10,39,75,90),(219,4,10,39,76,100),(220,4,10,40,97,5),(221,4,10,40,91,6),(222,4,10,40,73,10),(223,4,10,40,127,11),(224,4,10,40,107,14),(225,4,10,40,108,15),(226,4,10,40,109,16),(227,4,10,40,110,17),(228,4,10,40,111,18),(229,4,10,40,112,19),(230,4,10,40,74,20),(231,4,10,40,113,20),(232,4,10,40,118,21),(233,4,10,40,77,30),(234,4,10,40,117,31),(235,4,10,40,132,40),(236,4,10,40,115,60),(237,4,10,40,82,70),(238,4,10,40,119,71),(239,4,10,40,105,80),(240,4,10,40,99,80),(241,4,10,40,94,90),(242,4,10,40,95,100),(243,4,10,40,114,110),(244,4,10,40,128,111),(245,4,10,40,129,112),(246,4,10,40,130,113),(247,4,10,40,131,114),(249,4,10,40,134,1001),(250,4,11,41,133,10),(251,4,11,43,101,20),(252,4,11,43,102,30),(253,4,11,43,100,40),(254,4,11,43,116,50),(255,4,11,44,104,5),(256,4,11,44,106,6),(257,4,11,44,103,10),(258,4,11,45,78,3),(259,4,11,45,79,4),(260,4,11,45,80,5),(261,4,11,45,81,6),(262,4,11,45,92,7),(263,4,11,45,98,8),(264,4,11,45,120,9),(265,4,11,45,122,10),(266,4,11,45,123,11),(267,4,11,46,126,10),(268,4,11,46,84,20),(269,4,11,46,85,30),(270,4,11,46,86,40),(271,4,11,47,87,1),(272,4,11,47,88,2),(273,4,11,47,89,3),(274,4,11,47,90,4),(275,4,11,47,96,5),(276,4,11,48,121,1),(277,4,11,49,75,90),(278,4,11,49,76,100),(279,4,11,50,97,5),(280,4,11,50,91,6),(281,4,11,50,73,10),(282,4,11,50,127,11),(283,4,11,50,107,14),(284,4,11,50,108,15),(285,4,11,50,109,16),(286,4,11,50,110,17),(287,4,11,50,111,18),(288,4,11,50,112,19),(289,4,11,50,74,20),(290,4,11,50,113,20),(291,4,11,50,118,21),(292,4,11,50,77,30),(293,4,11,50,117,31),(294,4,11,50,132,40),(295,4,11,50,115,60),(296,4,11,50,82,70),(297,4,11,50,119,71),(298,4,11,50,105,80),(299,4,11,50,99,80),(300,4,11,50,94,90),(301,4,11,50,95,100),(302,4,11,50,114,110),(303,4,11,50,128,111),(304,4,11,50,129,112),(305,4,11,50,130,113),(306,4,11,50,131,114),(308,4,11,50,134,1002),(309,4,12,51,133,10),(310,4,12,53,101,20),(311,4,12,53,102,30),(312,4,12,53,100,40),(313,4,12,53,116,50),(314,4,12,54,104,5),(315,4,12,54,106,6),(316,4,12,54,103,10),(317,4,12,55,78,3),(318,4,12,55,79,4),(319,4,12,55,80,5),(320,4,12,55,81,6),(321,4,12,55,92,7),(322,4,12,55,98,8),(323,4,12,55,120,9),(324,4,12,55,122,10),(325,4,12,55,123,11),(326,4,12,56,126,10),(327,4,12,56,84,20),(328,4,12,56,85,30),(329,4,12,56,86,40),(330,4,12,57,87,1),(331,4,12,57,88,2),(332,4,12,57,89,3),(333,4,12,57,90,4),(334,4,12,57,96,5),(335,4,12,58,121,1),(336,4,12,59,75,90),(337,4,12,59,76,100),(338,4,12,60,97,5),(339,4,12,60,91,6),(340,4,12,60,73,10),(341,4,12,60,127,11),(342,4,12,60,107,14),(343,4,12,60,108,15),(344,4,12,60,109,16),(345,4,12,60,110,17),(346,4,12,60,111,18),(347,4,12,60,112,19),(348,4,12,60,74,20),(349,4,12,60,113,20),(350,4,12,60,118,21),(351,4,12,60,77,30),(352,4,12,60,117,31),(353,4,12,60,132,40),(354,4,12,60,115,60),(355,4,12,60,82,70),(356,4,12,60,119,71),(357,4,12,60,105,80),(358,4,12,60,99,80),(359,4,12,60,94,90),(360,4,12,60,95,100),(361,4,12,60,114,110),(362,4,12,60,128,111),(363,4,12,60,129,112),(364,4,12,60,130,113),(365,4,12,60,131,114),(367,4,12,60,134,1003),(368,4,13,61,133,10),(369,4,13,63,101,20),(370,4,13,63,102,30),(371,4,13,63,100,40),(372,4,13,63,116,50),(373,4,13,64,104,5),(374,4,13,64,106,6),(375,4,13,64,103,10),(376,4,13,65,78,3),(377,4,13,65,79,4),(378,4,13,65,80,5),(379,4,13,65,81,6),(380,4,13,65,92,7),(381,4,13,65,98,8),(382,4,13,65,120,9),(383,4,13,65,122,10),(384,4,13,65,123,11),(385,4,13,66,126,10),(386,4,13,66,84,20),(387,4,13,66,85,30),(388,4,13,66,86,40),(389,4,13,67,87,1),(390,4,13,67,88,2),(391,4,13,67,89,3),(392,4,13,67,90,4),(393,4,13,67,96,5),(394,4,13,68,121,1),(395,4,13,69,75,90),(396,4,13,69,76,100),(397,4,13,70,97,5),(398,4,13,70,91,6),(399,4,13,70,73,10),(400,4,13,70,127,11),(401,4,13,70,107,14),(402,4,13,70,108,15),(403,4,13,70,109,16),(404,4,13,70,110,17),(405,4,13,70,111,18),(406,4,13,70,112,19),(407,4,13,70,74,20),(408,4,13,70,113,20),(409,4,13,70,118,21),(410,4,13,70,77,30),(411,4,13,70,117,31),(412,4,13,70,132,40),(413,4,13,70,115,60),(414,4,13,70,82,70),(415,4,13,70,119,71),(416,4,13,70,105,80),(417,4,13,70,99,80),(418,4,13,70,94,90),(419,4,13,70,95,100),(420,4,13,70,114,110),(421,4,13,70,128,111),(422,4,13,70,129,112),(423,4,13,70,130,113),(424,4,13,70,131,114),(426,4,13,70,134,1004),(427,4,14,71,133,10),(428,4,14,73,101,20),(429,4,14,73,102,30),(430,4,14,73,100,40),(431,4,14,73,116,50),(432,4,14,74,104,5),(433,4,14,74,106,6),(434,4,14,74,103,10),(435,4,14,75,78,3),(436,4,14,75,79,4),(437,4,14,75,80,5),(438,4,14,75,81,6),(439,4,14,75,92,7),(440,4,14,75,98,8),(441,4,14,75,120,9),(442,4,14,75,122,10),(443,4,14,75,123,11),(444,4,14,76,126,10),(445,4,14,76,84,20),(446,4,14,76,85,30),(447,4,14,76,86,40),(448,4,14,77,87,1),(449,4,14,77,88,2),(450,4,14,77,89,3),(451,4,14,77,90,4),(452,4,14,77,96,5),(453,4,14,78,121,1),(454,4,14,79,75,90),(455,4,14,79,76,100),(456,4,14,80,97,5),(457,4,14,80,91,6),(458,4,14,80,73,10),(459,4,14,80,127,11),(460,4,14,80,107,14),(461,4,14,80,108,15),(462,4,14,80,109,16),(463,4,14,80,110,17),(464,4,14,80,111,18),(465,4,14,80,112,19),(466,4,14,80,74,20),(467,4,14,80,113,20),(468,4,14,80,118,21),(469,4,14,80,77,30),(470,4,14,80,117,31),(471,4,14,80,132,40),(472,4,14,80,115,60),(473,4,14,80,82,70),(474,4,14,80,119,71),(475,4,14,80,105,80),(476,4,14,80,99,80),(477,4,14,80,94,90),(478,4,14,80,95,100),(479,4,14,80,114,110),(480,4,14,80,128,111),(481,4,14,80,129,112),(482,4,14,80,130,113),(483,4,14,80,131,114),(485,4,14,80,134,1005),(486,4,15,81,133,10),(487,4,15,83,101,20),(488,4,15,83,102,30),(489,4,15,83,100,40),(490,4,15,83,116,50),(491,4,15,84,104,5),(492,4,15,84,106,6),(493,4,15,84,103,10),(494,4,15,85,78,3),(495,4,15,85,79,4),(496,4,15,85,80,5),(497,4,15,85,81,6),(498,4,15,85,92,7),(499,4,15,85,98,8),(500,4,15,85,120,9),(501,4,15,85,122,10),(502,4,15,85,123,11),(503,4,15,86,126,10),(504,4,15,86,84,20),(505,4,15,86,85,30),(506,4,15,86,86,40),(507,4,15,87,87,1),(508,4,15,87,88,2),(509,4,15,87,89,3),(510,4,15,87,90,4),(511,4,15,87,96,5),(512,4,15,88,121,1),(513,4,15,89,75,90),(514,4,15,89,76,100),(515,4,15,90,97,5),(516,4,15,90,91,6),(517,4,15,90,73,10),(518,4,15,90,127,11),(519,4,15,90,107,14),(520,4,15,90,108,15),(521,4,15,90,109,16),(522,4,15,90,110,17),(523,4,15,90,111,18),(524,4,15,90,112,19),(525,4,15,90,74,20),(526,4,15,90,113,20),(527,4,15,90,118,21),(528,4,15,90,77,30),(529,4,15,90,117,31),(530,4,15,90,132,40),(531,4,15,90,115,60),(532,4,15,90,82,70),(533,4,15,90,119,71),(534,4,15,90,105,80),(535,4,15,90,99,80),(536,4,15,90,94,90),(537,4,15,90,95,100),(538,4,15,90,114,110),(539,4,15,90,128,111),(540,4,15,90,129,112),(541,4,15,90,130,113),(542,4,15,90,131,114),(544,4,15,90,134,1006),(546,4,15,90,135,1007),(548,4,11,50,136,1008),(550,4,12,60,136,1009),(552,4,13,70,136,1010),(558,4,15,90,136,1013),(560,4,9,30,93,1014),(562,4,10,40,93,1015),(564,4,15,90,93,1016),(566,4,11,50,93,1017),(568,4,12,60,93,1018),(570,4,13,70,93,1019),(572,4,15,90,137,1020),(574,4,15,90,138,1021),(576,4,11,50,139,1022),(578,4,12,60,139,1023),(580,4,13,70,139,1024),(582,4,11,50,140,1025),(584,4,12,60,140,1026),(586,4,13,70,140,1027),(588,4,12,60,141,1028),(590,4,13,70,141,1029),(592,4,11,50,142,1030),(594,4,15,90,142,1031),(596,4,9,30,142,1032),(598,4,10,40,142,1033),(600,4,11,50,143,1034),(602,4,15,90,143,1035),(604,4,9,30,143,1036),(606,4,10,40,143,1037),(608,4,11,50,144,1038),(610,4,15,90,144,1039),(612,4,9,30,144,1040),(614,4,10,40,144,1041),(616,4,11,50,145,1042),(618,4,15,90,145,1043),(620,4,9,30,145,1044),(622,4,10,40,145,1045),(624,4,11,50,146,1046),(626,4,15,90,146,1047),(628,4,9,30,146,1048),(630,4,10,40,146,1049),(632,4,14,80,147,1000),(634,4,10,40,148,1000),(636,4,9,30,149,1001),(638,4,9,30,136,1002),(640,4,10,40,136,1003),(642,4,9,30,150,1004),(644,4,10,40,141,1005),(646,4,9,30,141,1006),(648,4,9,30,151,1007),(650,4,9,30,152,1008),(652,4,10,40,152,1009),(654,4,9,30,153,1010),(656,4,10,40,153,1011),(657,4,15,90,154,3),(658,4,10,40,154,3),(659,4,4,10,154,3),(660,4,14,80,154,3),(661,4,11,50,154,3),(662,4,12,60,154,3),(663,4,13,70,154,3),(664,4,9,30,154,3),(665,4,15,90,155,65),(666,4,10,40,155,65),(667,4,4,7,155,65),(668,4,14,80,155,65),(669,4,11,50,155,65),(670,4,12,60,155,65),(671,4,13,70,155,65),(672,4,9,30,155,65),(673,4,15,90,156,66),(674,4,10,40,156,66),(675,4,4,7,156,66),(676,4,14,80,156,66),(677,4,11,50,156,66),(678,4,12,60,156,66),(679,4,13,70,156,66),(680,4,9,30,156,66),(681,4,15,90,157,67),(682,4,10,40,157,67),(683,4,4,7,157,67),(684,4,14,80,157,67),(685,4,11,50,157,67),(686,4,12,60,157,67),(687,4,13,70,157,67),(688,4,9,30,157,67),(689,4,15,90,158,3),(690,4,10,40,158,3),(691,4,4,7,158,3),(692,4,14,80,158,3),(693,4,11,50,158,3),(694,4,12,60,158,3),(695,4,13,70,158,3),(696,4,9,30,158,3),(697,4,15,87,159,10),(698,4,10,37,159,10),(699,4,4,10,159,10),(700,4,14,77,159,10),(701,4,11,47,159,10),(702,4,12,57,159,10),(703,4,13,67,159,10),(704,4,9,27,159,10),(705,3,3,91,160,0),(706,3,3,91,161,10),(707,3,3,91,162,20),(708,3,3,91,163,30),(709,3,3,91,164,40),(710,3,3,91,165,50),(711,3,3,91,166,60),(712,3,3,91,167,70),(713,3,3,91,168,80),(714,3,3,91,169,90),(715,3,3,91,170,100),(716,3,3,91,171,110),(717,3,3,91,172,120),(718,3,3,91,173,130),(719,3,3,91,174,140),(720,3,3,91,175,150),(721,3,3,91,176,160),(722,3,3,91,177,170),(723,3,3,91,178,180),(724,3,3,91,179,95),(725,4,4,92,180,1),(726,4,4,92,181,1),(728,4,4,92,182,3),(730,4,4,92,183,5);

--
-- Table structure for table `mag2_eav_entity_datetime`
--

CREATE TABLE `mag2_eav_entity_datetime` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` datetime DEFAULT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_EAV_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `MAG2_EAV_ENTITY_DATETIME_STORE_ID` (`store_id`),
  KEY `MAG2_EAV_ENTITY_DATETIME_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `MAG2_EAV_ENTITY_DATETIME_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `MAG2_EAV_ENTITY_DATETIME_ENTITY_ID_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTITY_DATETIME_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTT_DTIME_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `mag2_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `mag2_eav_entity_datetime`
--


--
-- Table structure for table `mag2_eav_entity_decimal`
--

CREATE TABLE `mag2_eav_entity_decimal` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_EAV_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `MAG2_EAV_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  KEY `MAG2_EAV_ENTITY_DECIMAL_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `MAG2_EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `MAG2_EAV_ENTITY_DECIMAL_ENTITY_ID_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTITY_DECIMAL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTT_DEC_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `mag2_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `mag2_eav_entity_decimal`
--


--
-- Table structure for table `mag2_eav_entity_int`
--

CREATE TABLE `mag2_eav_entity_int` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` int(11) NOT NULL DEFAULT '0' COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_EAV_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `MAG2_EAV_ENTITY_INT_STORE_ID` (`store_id`),
  KEY `MAG2_EAV_ENTITY_INT_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `MAG2_EAV_ENTITY_INT_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `MAG2_EAV_ENTITY_INT_ENTITY_ID_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTITY_INT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTT_INT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `mag2_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `mag2_eav_entity_int`
--


--
-- Table structure for table `mag2_eav_entity_store`
--

CREATE TABLE `mag2_eav_entity_store` (
  `entity_store_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Store Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `increment_prefix` varchar(20) DEFAULT NULL COMMENT 'Increment Prefix',
  `increment_last_id` varchar(50) DEFAULT NULL COMMENT 'Last Incremented Id',
  PRIMARY KEY (`entity_store_id`),
  KEY `MAG2_EAV_ENTITY_STORE_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `MAG2_EAV_ENTITY_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_EAV_ENTITY_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTT_STORE_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `mag2_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Store';

--
-- Dumping data for table `mag2_eav_entity_store`
--


--
-- Table structure for table `mag2_eav_entity_text`
--

CREATE TABLE `mag2_eav_entity_text` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` text NOT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_EAV_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `MAG2_EAV_ENTITY_TEXT_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `MAG2_EAV_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `MAG2_EAV_ENTITY_TEXT_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_EAV_ENTITY_TEXT_ENTITY_ID_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTITY_TEXT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTT_TEXT_ENTT_TYPE_ID_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `mag2_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `mag2_eav_entity_text`
--


--
-- Table structure for table `mag2_eav_entity_type`
--

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

--
-- Dumping data for table `mag2_eav_entity_type`
--

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

--
