-- 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`
--

INSERT INTO `mag2_eav_attribute` VALUES (1,1,'website_id',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Website','static',NULL,NULL,'select','Associate to Website',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Website',1,0,NULL,0,NULL),(2,1,'store_id',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Store','static',NULL,NULL,'select','Create In',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Store',1,0,NULL,0,NULL),(3,1,'created_in',NULL,NULL,'static',NULL,NULL,'text','Created From',NULL,NULL,0,0,NULL,0,NULL),(4,1,'prefix',NULL,NULL,'static',NULL,NULL,'text','Name Prefix',NULL,NULL,0,0,NULL,0,NULL),(5,1,'firstname',NULL,NULL,'static',NULL,NULL,'text','First Name',NULL,NULL,1,0,NULL,0,NULL),(6,1,'middlename',NULL,NULL,'static',NULL,NULL,'text','Middle Name/Initial',NULL,NULL,0,0,NULL,0,NULL),(7,1,'lastname',NULL,NULL,'static',NULL,NULL,'text','Last Name',NULL,NULL,1,0,NULL,0,NULL),(8,1,'suffix',NULL,NULL,'static',NULL,NULL,'text','Name Suffix',NULL,NULL,0,0,NULL,0,NULL),(9,1,'email',NULL,NULL,'static',NULL,NULL,'text','Email',NULL,NULL,1,0,NULL,0,NULL),(10,1,'group_id',NULL,NULL,'static',NULL,NULL,'select','Group',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Source\\Group',1,0,NULL,0,NULL),(11,1,'dob',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','static',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Frontend\\Datetime','date','Date of Birth',NULL,NULL,0,0,NULL,0,NULL),(12,1,'password_hash',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Password','static',NULL,NULL,'hidden',NULL,NULL,NULL,0,0,NULL,0,NULL),(13,1,'rp_token',NULL,NULL,'static',NULL,NULL,'hidden',NULL,NULL,NULL,0,0,NULL,0,NULL),(14,1,'rp_token_created_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,0,0,NULL,0,NULL),(15,1,'default_billing',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Billing','static',NULL,NULL,'text','Default Billing Address',NULL,NULL,0,0,NULL,0,NULL),(16,1,'default_shipping',NULL,'Magento\\Customer\\Model\\Customer\\Attribute\\Backend\\Shipping','static',NULL,NULL,'text','Default Shipping Address',NULL,NULL,0,0,NULL,0,NULL),(17,1,'taxvat',NULL,NULL,'static',NULL,NULL,'text','Tax/VAT Number',NULL,NULL,0,0,NULL,0,NULL),(18,1,'confirmation',NULL,NULL,'static',NULL,NULL,'text','Is Confirmed',NULL,NULL,0,0,NULL,0,NULL),(19,1,'created_at',NULL,NULL,'static',NULL,NULL,'date','Created At',NULL,NULL,0,0,NULL,0,NULL),(20,1,'gender',NULL,NULL,'static',NULL,NULL,'select','Gender',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,0,NULL,0,NULL),(21,1,'disable_auto_group_change',NULL,'Magento\\Customer\\Model\\Attribute\\Backend\\Data\\Boolean','static',NULL,NULL,'boolean','Disable Automatic Group Change Based on VAT ID',NULL,NULL,0,0,NULL,0,NULL),(22,2,'prefix',NULL,NULL,'static',NULL,NULL,'text','Name Prefix',NULL,NULL,0,0,NULL,0,NULL),(23,2,'firstname',NULL,NULL,'static',NULL,NULL,'text','First Name',NULL,NULL,1,0,NULL,0,NULL),(24,2,'middlename',NULL,NULL,'static',NULL,NULL,'text','Middle Name/Initial',NULL,NULL,0,0,NULL,0,NULL),(25,2,'lastname',NULL,NULL,'static',NULL,NULL,'text','Last Name',NULL,NULL,1,0,NULL,0,NULL),(26,2,'suffix',NULL,NULL,'static',NULL,NULL,'text','Name Suffix',NULL,NULL,0,0,NULL,0,NULL),(27,2,'company',NULL,NULL,'static',NULL,NULL,'text','Company',NULL,NULL,0,0,NULL,0,NULL),(28,2,'street',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\DefaultBackend','static',NULL,NULL,'multiline','Street Address',NULL,NULL,1,0,NULL,0,NULL),(29,2,'city',NULL,NULL,'static',NULL,NULL,'text','City',NULL,NULL,1,0,NULL,0,NULL),(30,2,'country_id',NULL,NULL,'static',NULL,NULL,'select','Country',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Source\\Country',1,0,NULL,0,NULL),(31,2,'region',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Backend\\Region','static',NULL,NULL,'text','State/Province',NULL,NULL,0,0,NULL,0,NULL),(32,2,'region_id',NULL,NULL,'static',NULL,NULL,'hidden','State/Province',NULL,'Magento\\Customer\\Model\\ResourceModel\\Address\\Attribute\\Source\\Region',0,0,NULL,0,NULL),(33,2,'postcode',NULL,NULL,'static',NULL,NULL,'text','Zip/Postal Code',NULL,NULL,0,0,NULL,0,NULL),(34,2,'telephone',NULL,NULL,'static',NULL,NULL,'text','Phone Number',NULL,NULL,1,0,NULL,0,NULL),(35,2,'fax',NULL,NULL,'static',NULL,NULL,'text','Fax',NULL,NULL,0,0,NULL,0,NULL),(36,2,'vat_id',NULL,NULL,'static',NULL,NULL,'text','VAT Number',NULL,NULL,0,0,NULL,0,NULL),(37,2,'vat_is_valid',NULL,NULL,'static',NULL,NULL,'text','VAT number validity',NULL,NULL,0,0,NULL,0,NULL),(38,2,'vat_request_id',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request ID',NULL,NULL,0,0,NULL,0,NULL),(39,2,'vat_request_date',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request date',NULL,NULL,0,0,NULL,0,NULL),(40,2,'vat_request_success',NULL,NULL,'static',NULL,NULL,'text','VAT number validation request success',NULL,NULL,0,0,NULL,0,NULL),(41,1,'updated_at',NULL,NULL,'static',NULL,NULL,'date','Updated At',NULL,NULL,0,0,NULL,0,NULL),(42,1,'failures_num',NULL,NULL,'static',NULL,NULL,'hidden','Failures Number',NULL,NULL,0,0,NULL,0,NULL),(43,1,'first_failure',NULL,NULL,'static',NULL,NULL,'date','First Failure Date',NULL,NULL,0,0,NULL,0,NULL),(44,1,'lock_expires',NULL,NULL,'static',NULL,NULL,'date','Failures Number',NULL,NULL,0,0,NULL,0,NULL),(45,3,'name',NULL,NULL,'varchar',NULL,NULL,'text','Name',NULL,NULL,1,0,NULL,0,NULL),(46,3,'is_active',NULL,NULL,'int',NULL,NULL,'select','Is Active',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',1,0,NULL,0,NULL),(47,3,'description',NULL,NULL,'text',NULL,NULL,'textarea','Description',NULL,NULL,0,0,NULL,0,NULL),(48,3,'image',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Image',NULL,NULL,0,0,NULL,0,NULL),(49,3,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Page Title',NULL,NULL,0,0,NULL,0,NULL),(50,3,'meta_keywords',NULL,NULL,'text',NULL,NULL,'textarea','Meta Keywords',NULL,NULL,0,0,NULL,0,NULL),(51,3,'meta_description',NULL,NULL,'text',NULL,NULL,'textarea','Meta Description',NULL,NULL,0,0,NULL,0,NULL),(52,3,'display_mode',NULL,NULL,'varchar',NULL,NULL,'select','Display Mode',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Mode',0,0,NULL,0,NULL),(53,3,'landing_page',NULL,NULL,'int',NULL,NULL,'select','CMS Block',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Page',0,0,NULL,0,NULL),(54,3,'is_anchor',NULL,NULL,'int',NULL,NULL,'select','Is Anchor',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'1',0,NULL),(55,3,'path',NULL,NULL,'static',NULL,NULL,'text','Path',NULL,NULL,0,0,NULL,0,NULL),(56,3,'position',NULL,NULL,'static',NULL,NULL,'text','Position',NULL,NULL,0,0,NULL,0,NULL),(57,3,'all_children',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(58,3,'path_in_store',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(59,3,'children',NULL,NULL,'text',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(60,3,'custom_design',NULL,NULL,'varchar',NULL,NULL,'select','Custom Design',NULL,'Magento\\Theme\\Model\\Theme\\Source\\Theme',0,0,NULL,0,NULL),(61,3,'custom_design_from','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Frontend\\Datetime','date','Active From',NULL,NULL,0,0,NULL,0,NULL),(62,3,'custom_design_to',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Active To',NULL,NULL,0,0,NULL,0,NULL),(63,3,'page_layout',NULL,NULL,'varchar',NULL,NULL,'select','Page Layout',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(64,3,'custom_layout_update',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Customlayoutupdate','text',NULL,NULL,'textarea','Custom Layout Update',NULL,NULL,0,0,NULL,0,NULL),(65,3,'level',NULL,NULL,'static',NULL,NULL,'text','Level',NULL,NULL,0,0,NULL,0,NULL),(66,3,'children_count',NULL,NULL,'static',NULL,NULL,'text','Children Count',NULL,NULL,0,0,NULL,0,NULL),(67,3,'available_sort_by',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Sortby','text',NULL,NULL,'multiselect','Available Product Listing Sort By',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Sortby',1,0,NULL,0,NULL),(68,3,'default_sort_by',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Sortby','varchar',NULL,NULL,'select','Default Product Listing Sort By',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\Sortby',1,0,NULL,0,NULL),(69,3,'include_in_menu',NULL,NULL,'int',NULL,NULL,'select','Include in Navigation Menu',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',1,0,'1',0,NULL),(70,3,'custom_use_parent_settings',NULL,NULL,'int',NULL,NULL,'select','Use Parent Category Settings',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(71,3,'custom_apply_to_products',NULL,NULL,'int',NULL,NULL,'select','Apply To Products',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(72,3,'filter_price_range',NULL,NULL,'decimal',NULL,NULL,'text','Layered Navigation Price Step',NULL,NULL,0,0,NULL,0,NULL),(73,4,'name',NULL,NULL,'varchar',NULL,NULL,'text','Product Name','validate-length maximum-length-255',NULL,1,0,NULL,0,NULL),(74,4,'sku',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Sku','static',NULL,NULL,'text','SKU','validate-length maximum-length-64',NULL,1,0,NULL,1,NULL),(75,4,'description',NULL,NULL,'text',NULL,NULL,'textarea','Description',NULL,NULL,0,0,NULL,0,NULL),(76,4,'short_description',NULL,NULL,'text',NULL,NULL,'textarea','Short Description',NULL,NULL,0,0,NULL,0,NULL),(77,4,'price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Price',NULL,NULL,1,0,NULL,0,NULL),(78,4,'special_price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Special Price',NULL,NULL,0,0,NULL,0,NULL),(79,4,'special_from_date',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Special Price From Date',NULL,NULL,0,0,NULL,0,NULL),(80,4,'special_to_date',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Special Price To Date',NULL,NULL,0,0,NULL,0,NULL),(81,4,'cost',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Cost',NULL,NULL,0,1,NULL,0,NULL),(82,4,'weight',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Weight','decimal',NULL,NULL,'weight','Weight',NULL,NULL,0,0,NULL,0,NULL),(83,4,'manufacturer',NULL,NULL,'int',NULL,NULL,'select','Manufacturer',NULL,NULL,0,1,NULL,0,NULL),(84,4,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Meta Title',NULL,NULL,0,0,NULL,0,NULL),(85,4,'meta_keyword',NULL,NULL,'text',NULL,NULL,'textarea','Meta Keywords',NULL,NULL,0,0,NULL,0,NULL),(86,4,'meta_description',NULL,NULL,'varchar',NULL,NULL,'textarea','Meta Description',NULL,NULL,0,0,NULL,0,'Maximum 255 chars. Meta Description should optimally be between 150-160 characters'),(87,4,'image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Base',NULL,NULL,0,0,NULL,0,NULL),(88,4,'small_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Small',NULL,NULL,0,0,NULL,0,NULL),(89,4,'thumbnail',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Thumbnail',NULL,NULL,0,0,NULL,0,NULL),(90,4,'media_gallery',NULL,NULL,'static',NULL,NULL,'gallery','Media Gallery',NULL,NULL,0,0,NULL,0,NULL),(91,4,'old_id',NULL,NULL,'int',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(92,4,'tier_price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Tierprice','decimal',NULL,NULL,'text','Tier Price',NULL,NULL,0,0,NULL,0,NULL),(93,4,'color','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute',NULL,'int',NULL,NULL,'select','Color',NULL,NULL,0,1,'49',0,NULL),(94,4,'news_from_date',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Set Product as New from Date',NULL,NULL,0,0,NULL,0,NULL),(95,4,'news_to_date',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Set Product as New to Date',NULL,NULL,0,0,NULL,0,NULL),(96,4,'gallery',NULL,NULL,'varchar',NULL,NULL,'gallery','Image Gallery',NULL,NULL,0,0,NULL,0,NULL),(97,4,'status',NULL,NULL,'int',NULL,NULL,'select','Enable Product',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Status',0,0,'1',0,NULL),(98,4,'minimal_price',NULL,NULL,'decimal',NULL,NULL,'price','Minimal Price',NULL,NULL,0,0,NULL,0,NULL),(99,4,'visibility',NULL,NULL,'int',NULL,NULL,'select','Visibility',NULL,'Magento\\Catalog\\Model\\Product\\Visibility',0,0,'4',0,NULL),(100,4,'custom_design',NULL,NULL,'varchar',NULL,NULL,'select','New Theme',NULL,'Magento\\Theme\\Model\\Theme\\Source\\Theme',0,0,NULL,0,NULL),(101,4,'custom_design_from',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Active From',NULL,NULL,0,0,NULL,0,NULL),(102,4,'custom_design_to',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Active To',NULL,NULL,0,0,NULL,0,NULL),(103,4,'custom_layout_update',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Customlayoutupdate','text',NULL,NULL,'textarea','Layout Update XML',NULL,NULL,0,0,NULL,0,NULL),(104,4,'page_layout',NULL,NULL,'varchar',NULL,NULL,'select','Layout',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(105,4,'category_ids',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Category','static',NULL,NULL,'text','Categories',NULL,NULL,0,0,NULL,0,NULL),(106,4,'options_container',NULL,NULL,'varchar',NULL,NULL,'select','Display Product Options In',NULL,'Magento\\Catalog\\Model\\Entity\\Product\\Attribute\\Design\\Options\\Container',0,0,'container2',0,NULL),(107,4,'required_options',NULL,NULL,'static',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(108,4,'has_options',NULL,NULL,'static',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(109,4,'image_label',NULL,NULL,'varchar',NULL,NULL,'text','Image Label',NULL,NULL,0,0,NULL,0,NULL),(110,4,'small_image_label',NULL,NULL,'varchar',NULL,NULL,'text','Small Image Label',NULL,NULL,0,0,NULL,0,NULL),(111,4,'thumbnail_label',NULL,NULL,'varchar',NULL,NULL,'text','Thumbnail Label',NULL,NULL,0,0,NULL,0,NULL),(112,4,'created_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,1,0,NULL,0,NULL),(113,4,'updated_at',NULL,NULL,'static',NULL,NULL,'date',NULL,NULL,NULL,1,0,NULL,0,NULL),(114,4,'country_of_manufacture',NULL,NULL,'varchar',NULL,NULL,'select','Country of Manufacture',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Countryofmanufacture',0,0,NULL,0,NULL),(115,4,'quantity_and_stock_status',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Stock','int',NULL,NULL,'select','Quantity',NULL,'Magento\\CatalogInventory\\Model\\Source\\Stock',0,0,'1',0,NULL),(116,4,'custom_layout',NULL,NULL,'varchar',NULL,NULL,'select','New Layout',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Layout',0,0,NULL,0,NULL),(117,4,'price_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Price',NULL,NULL,1,0,'0',0,NULL),(118,4,'sku_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic SKU',NULL,NULL,1,0,'0',0,NULL),(119,4,'weight_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Weight',NULL,NULL,1,0,'0',0,NULL),(120,4,'price_view',NULL,NULL,'int',NULL,NULL,'select','Price View',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Price\\View',1,0,NULL,0,NULL),(121,4,'shipment_type',NULL,NULL,'int',NULL,NULL,'select','Ship Bundle Items',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Shipment\\Type',1,0,'0',0,NULL),(122,4,'msrp',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Manufacturer\'s Suggested Retail Price',NULL,NULL,0,0,NULL,0,NULL),(123,4,'msrp_display_actual_price_type',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Boolean','varchar',NULL,NULL,'select','Display Actual Price',NULL,'Magento\\Msrp\\Model\\Product\\Attribute\\Source\\Type\\Price',0,0,'0',0,NULL),(124,3,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(125,3,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(126,4,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(127,4,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(128,4,'links_purchased_separately',NULL,NULL,'int',NULL,NULL,NULL,'Links can be purchased separately',NULL,NULL,1,0,NULL,0,NULL),(129,4,'samples_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Samples title',NULL,NULL,1,0,NULL,0,NULL),(130,4,'links_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Links title',NULL,NULL,1,0,NULL,0,NULL),(131,4,'links_exist',NULL,NULL,'int',NULL,NULL,NULL,NULL,NULL,NULL,0,0,'0',0,NULL),(132,4,'tax_class_id',NULL,NULL,'int',NULL,NULL,'select','Tax Class',NULL,'Magento\\Tax\\Model\\TaxClass\\Source\\Product',0,0,'2',0,NULL),(133,4,'gift_message_available',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Boolean','varchar',NULL,NULL,'select','Allow Gift Message',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(134,4,'activity',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Activity',NULL,NULL,0,1,'',0,NULL),(135,4,'style_bags',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Style Bags',NULL,NULL,0,1,'',0,NULL),(136,4,'material',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Material',NULL,NULL,0,1,'',0,NULL),(137,4,'strap_bags',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Strap/Handle',NULL,NULL,0,1,'',0,NULL),(138,4,'features_bags',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Features',NULL,NULL,0,1,'',0,NULL),(139,4,'gender',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Gender',NULL,NULL,0,1,'',0,NULL),(140,4,'category_gear',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Category Gear',NULL,NULL,0,1,'',0,NULL),(141,4,'size',NULL,NULL,'int',NULL,NULL,'select','Size',NULL,NULL,0,1,'91',0,NULL),(142,4,'eco_collection',NULL,NULL,'int',NULL,NULL,'boolean','Eco Collection',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,1,'',0,NULL),(143,4,'performance_fabric',NULL,NULL,'int',NULL,NULL,'boolean','Performance Fabric',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,1,'',0,NULL),(144,4,'erin_recommends',NULL,NULL,'int',NULL,NULL,'boolean','Erin Recommends',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,1,'',0,NULL),(145,4,'new',NULL,NULL,'int',NULL,NULL,'boolean','New',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,1,'',0,NULL),(146,4,'sale',NULL,NULL,'int',NULL,NULL,'boolean','Sale',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,1,'',0,NULL),(147,4,'format',NULL,NULL,'int',NULL,NULL,'select','Format',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(148,4,'style_bottom',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Style Bottom',NULL,NULL,0,1,'',0,NULL),(149,4,'style_general',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Style General',NULL,NULL,0,1,'',0,NULL),(150,4,'sleeve',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Sleeve',NULL,NULL,0,1,'',0,NULL),(151,4,'collar',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Collar',NULL,NULL,0,1,'',0,NULL),(152,4,'pattern',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Pattern',NULL,NULL,0,1,'',0,NULL),(153,4,'climate',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','Climate',NULL,NULL,0,1,'',0,NULL),(154,4,'swatch_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Swatch',NULL,NULL,0,0,NULL,0,NULL),(155,4,'ts_dimensions_length',NULL,NULL,'decimal',NULL,NULL,'text','Length',NULL,NULL,0,0,NULL,0,NULL),(156,4,'ts_dimensions_width',NULL,NULL,'decimal',NULL,NULL,'text','Width',NULL,NULL,0,0,NULL,0,NULL),(157,4,'ts_dimensions_height',NULL,NULL,'decimal',NULL,NULL,'text','Height',NULL,NULL,0,0,NULL,0,NULL),(158,4,'thm_featured',NULL,NULL,'int',NULL,NULL,'boolean','Featured Product',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'0',0,NULL),(159,4,'img_hover',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Hover Image',NULL,NULL,0,0,NULL,0,NULL),(160,3,'ys_nav_simple',NULL,NULL,'int',NULL,NULL,'select','Apply simple mode (shows only tree)',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(161,3,'ys_nav_simple_width',NULL,NULL,'text',NULL,NULL,'text','Simple Menu Width',NULL,NULL,0,0,NULL,0,NULL),(162,3,'ys_nav_btm',NULL,NULL,'text',NULL,NULL,'textarea','Html block under menu ',NULL,NULL,0,0,NULL,0,'This field is compatible only with 1st-level category'),(163,3,'ys_nav_top',NULL,NULL,'text',NULL,NULL,'textarea','Top Html',NULL,NULL,0,0,NULL,0,NULL),(164,3,'ys_nav_left',NULL,NULL,'text',NULL,NULL,'textarea','Left Html',NULL,NULL,0,0,NULL,0,NULL),(165,3,'ys_nav_left_width',NULL,NULL,'text',NULL,NULL,'select','Left Html Width',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\Columnsgrid',0,0,'3',0,NULL),(166,3,'ys_nav_right',NULL,NULL,'text',NULL,NULL,'textarea','Megamenu Vertical Right Html',NULL,NULL,0,0,NULL,0,'This field is compatible only with 1st-level category'),(167,3,'ys_nav_right_width',NULL,NULL,'text',NULL,NULL,'select','Right Html Width',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\Columnsgrid',0,0,'3',0,NULL),(168,3,'ys_category_lable',NULL,NULL,'text',NULL,NULL,'text','Category label, for ex. \"Hot!\"',NULL,NULL,0,0,NULL,0,'This field is compatible only with 1st-level category megamenu'),(169,3,'ys_label_color',NULL,NULL,'text',NULL,NULL,'text','Category label background color',NULL,NULL,0,0,NULL,0,'This field is compatible only with 1st-level category megamenu'),(170,3,'ys_data_tm_width',NULL,NULL,'text',NULL,NULL,'select','Top Menu Dropdown Width',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\Menuwidth',0,0,'1170',0,NULL),(171,3,'ys_data_tm_align_vertical',NULL,NULL,'text',NULL,NULL,'select','Top Menu Dropdown Align Vertical',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\Alignvertical',0,0,'menu-bottom',0,NULL),(172,3,'ys_data_tm_align_horizontal',NULL,NULL,'text',NULL,NULL,'select','Top Menu Dropdown Align Horizontal',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\Alignhorizontal',0,0,'menu-left',0,NULL),(173,3,'ys_products_list_type',NULL,NULL,'text',NULL,NULL,'select','Select Gallery Type',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\CarouselType',0,0,'horizontal',0,NULL),(174,3,'ys_gal_proportion',NULL,NULL,'text',NULL,NULL,'select','Gallery-Banner cols width proportion',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\GalleryProp',0,0,'cwc-1-2',0,NULL),(175,3,'ys_gal_order',NULL,NULL,'text',NULL,NULL,'select','Gallery-Banner sort order',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\GalleryOrder',0,0,'ban-gal',0,NULL),(176,3,'ys_products_title',NULL,NULL,'text',NULL,NULL,'text','Product\'s block title',NULL,NULL,0,0,NULL,0,NULL),(177,3,'ys_products_ids',NULL,NULL,'text',NULL,NULL,'text','Product\'s ids, separated by commas',NULL,NULL,0,0,NULL,0,'Minimum two ids, only simple products'),(178,3,'ys_columns',NULL,NULL,'text',NULL,NULL,'select','Columns categories per row',NULL,'Ecomwares\\Wkmegamenu\\Model\\Attribute\\Columns',0,0,'3',0,NULL),(179,3,'ys_cat_image',NULL,NULL,'text',NULL,NULL,'textarea','Insert Image to 2-lvl category',NULL,NULL,0,0,NULL,0,NULL),(180,4,'brand',NULL,NULL,'int',NULL,NULL,'select','Brand',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(181,4,'charachters_collection',NULL,NULL,'int',NULL,NULL,'select','charachters_collection',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL),(182,4,'gend',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\ArrayBackend','varchar',NULL,NULL,'multiselect','gender',NULL,NULL,0,1,'',0,NULL),(183,4,'itemsize',NULL,NULL,'int',NULL,NULL,'select','Size',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Table',0,1,'',0,NULL);

--
-- 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);

--
-- Table structure for table `mag2_eav_entity_varchar`
--

CREATE TABLE `mag2_eav_entity_varchar` (
  `value_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Value Id',
  `entity_type_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Type Id',
  `attribute_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Attribute Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  `value` varchar(255) DEFAULT NULL COMMENT 'Attribute Value',
  PRIMARY KEY (`value_id`),
  UNIQUE KEY `MAG2_EAV_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `MAG2_EAV_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  KEY `MAG2_EAV_ENTITY_VARCHAR_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `MAG2_EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `MAG2_EAV_ENTITY_VARCHAR_ENTITY_ID_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `mag2_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTITY_VARCHAR_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_ENTT_VCHR_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_varchar`
--


--
-- Table structure for table `mag2_eav_form_element`
--

CREATE TABLE `mag2_eav_form_element` (
  `element_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Element Id',
  `type_id` smallint(5) unsigned NOT NULL COMMENT 'Type Id',
  `fieldset_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Fieldset Id',
  `attribute_id` smallint(5) unsigned NOT NULL COMMENT 'Attribute Id',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`element_id`),
  UNIQUE KEY `MAG2_EAV_FORM_ELEMENT_TYPE_ID_ATTRIBUTE_ID` (`type_id`,`attribute_id`),
  KEY `MAG2_EAV_FORM_ELEMENT_FIELDSET_ID` (`fieldset_id`),
  KEY `MAG2_EAV_FORM_ELEMENT_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `MAG2_EAV_FORM_ELEMENT_ATTRIBUTE_ID_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `mag2_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_FORM_ELEMENT_FIELDSET_ID_EAV_FORM_FIELDSET_FIELDSET_ID` FOREIGN KEY (`fieldset_id`) REFERENCES `mag2_eav_form_fieldset` (`fieldset_id`) ON DELETE SET NULL,
  CONSTRAINT `MAG2_EAV_FORM_ELEMENT_TYPE_ID_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `mag2_eav_form_type` (`type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COMMENT='Eav Form Element';

--
-- Dumping data for table `mag2_eav_form_element`
--

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

--
-- Table structure for table `mag2_eav_form_fieldset`
--

CREATE TABLE `mag2_eav_form_fieldset` (
  `fieldset_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Fieldset Id',
  `type_id` smallint(5) unsigned NOT NULL COMMENT 'Type Id',
  `code` varchar(64) NOT NULL COMMENT 'Code',
  `sort_order` int(11) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  PRIMARY KEY (`fieldset_id`),
  UNIQUE KEY `MAG2_EAV_FORM_FIELDSET_TYPE_ID_CODE` (`type_id`,`code`),
  CONSTRAINT `MAG2_EAV_FORM_FIELDSET_TYPE_ID_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `mag2_eav_form_type` (`type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset';

--
-- Dumping data for table `mag2_eav_form_fieldset`
--


--
-- Table structure for table `mag2_eav_form_fieldset_label`
--

CREATE TABLE `mag2_eav_form_fieldset_label` (
  `fieldset_id` smallint(5) unsigned NOT NULL COMMENT 'Fieldset Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `label` varchar(255) NOT NULL COMMENT 'Label',
  PRIMARY KEY (`fieldset_id`,`store_id`),
  KEY `MAG2_EAV_FORM_FIELDSET_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_EAV_FORM_FIELDSET_LABEL_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_FORM_FSET_LBL_FSET_ID_EAV_FORM_FSET_FSET_ID` FOREIGN KEY (`fieldset_id`) REFERENCES `mag2_eav_form_fieldset` (`fieldset_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset Label';

--
-- Dumping data for table `mag2_eav_form_fieldset_label`
--


--
-- Table structure for table `mag2_eav_form_type`
--

CREATE TABLE `mag2_eav_form_type` (
  `type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Type Id',
  `code` varchar(64) NOT NULL COMMENT 'Code',
  `label` varchar(255) NOT NULL COMMENT 'Label',
  `is_system` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is System',
  `theme` varchar(64) DEFAULT NULL COMMENT 'Theme',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  PRIMARY KEY (`type_id`),
  UNIQUE KEY `MAG2_EAV_FORM_TYPE_CODE_THEME_STORE_ID` (`code`,`theme`,`store_id`),
  KEY `MAG2_EAV_FORM_TYPE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_EAV_FORM_TYPE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Eav Form Type';

--
-- Dumping data for table `mag2_eav_form_type`
--

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

--
-- Table structure for table `mag2_eav_form_type_entity`
--

CREATE TABLE `mag2_eav_form_type_entity` (
  `type_id` smallint(5) unsigned NOT NULL COMMENT 'Type Id',
  `entity_type_id` smallint(5) unsigned NOT NULL COMMENT 'Entity Type Id',
  PRIMARY KEY (`type_id`,`entity_type_id`),
  KEY `MAG2_EAV_FORM_TYPE_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  CONSTRAINT `MAG2_EAV_FORM_TYPE_ENTITY_TYPE_ID_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `mag2_eav_form_type` (`type_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EAV_FORM_TYPE_ENTT_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 Form Type Entity';

--
-- Dumping data for table `mag2_eav_form_type_entity`
--

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

--
-- Table structure for table `mag2_email_abandoned_cart`
--

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

--
-- Dumping data for table `mag2_email_abandoned_cart`
--


--
-- Table structure for table `mag2_email_automation`
--

CREATE TABLE `mag2_email_automation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `automation_type` varchar(255) DEFAULT NULL COMMENT 'Automation Type',
  `store_name` varchar(255) DEFAULT NULL COMMENT 'Automation Type',
  `enrolment_status` varchar(255) NOT NULL COMMENT 'Entrolment Status',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `type_id` varchar(255) DEFAULT NULL COMMENT 'Type ID',
  `program_id` varchar(255) DEFAULT NULL COMMENT 'Program ID',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `message` varchar(255) NOT NULL COMMENT 'Message',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `MAG2_EMAIL_AUTOMATION_AUTOMATION_TYPE` (`automation_type`),
  KEY `MAG2_EMAIL_AUTOMATION_ENROLMENT_STATUS` (`enrolment_status`),
  KEY `MAG2_EMAIL_AUTOMATION_TYPE_ID` (`type_id`),
  KEY `MAG2_EMAIL_AUTOMATION_EMAIL` (`email`),
  KEY `MAG2_EMAIL_AUTOMATION_PROGRAM_ID` (`program_id`),
  KEY `MAG2_EMAIL_AUTOMATION_CREATED_AT` (`created_at`),
  KEY `MAG2_EMAIL_AUTOMATION_UPDATED_AT` (`updated_at`),
  KEY `MAG2_EMAIL_AUTOMATION_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Automation Status';

--
-- Dumping data for table `mag2_email_automation`
--


--
-- Table structure for table `mag2_email_campaign`
--

CREATE TABLE `mag2_email_campaign` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `campaign_id` int(10) unsigned NOT NULL COMMENT 'Campaign ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Contact Email',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `sent_at` timestamp NULL DEFAULT NULL COMMENT 'Send Date',
  `order_increment_id` varchar(50) NOT NULL COMMENT 'Order Increment ID',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Sales Quote ID',
  `message` varchar(255) NOT NULL DEFAULT '' COMMENT 'Error Message',
  `checkout_method` varchar(255) NOT NULL DEFAULT '' COMMENT 'Checkout Method Used',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `event_name` varchar(255) NOT NULL DEFAULT '' COMMENT 'Event Name',
  `send_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Send Id',
  `send_status` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Campaign send status',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `MAG2_EMAIL_CAMPAIGN_STORE_ID` (`store_id`),
  KEY `MAG2_EMAIL_CAMPAIGN_CAMPAIGN_ID` (`campaign_id`),
  KEY `MAG2_EMAIL_CAMPAIGN_EMAIL` (`email`),
  KEY `MAG2_EMAIL_CAMPAIGN_SEND_ID` (`send_id`),
  KEY `MAG2_EMAIL_CAMPAIGN_SEND_STATUS` (`send_status`),
  KEY `MAG2_EMAIL_CAMPAIGN_CREATED_AT` (`created_at`),
  KEY `MAG2_EMAIL_CAMPAIGN_UPDATED_AT` (`updated_at`),
  KEY `MAG2_EMAIL_CAMPAIGN_SENT_AT` (`sent_at`),
  KEY `MAG2_EMAIL_CAMPAIGN_EVENT_NAME` (`event_name`),
  KEY `MAG2_EMAIL_CAMPAIGN_MESSAGE` (`message`),
  KEY `MAG2_EMAIL_CAMPAIGN_QUOTE_ID` (`quote_id`),
  KEY `MAG2_EMAIL_CAMPAIGN_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `MAG2_EMAIL_CAMPAIGN_STORE_ID_CORE/STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Campaigns';

--
-- Dumping data for table `mag2_email_campaign`
--


--
-- Table structure for table `mag2_email_catalog`
--

CREATE TABLE `mag2_email_catalog` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `imported` smallint(5) unsigned DEFAULT NULL COMMENT 'Product Imported',
  `modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Product Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `MAG2_EMAIL_CATALOG_PRODUCT_ID` (`product_id`),
  KEY `MAG2_EMAIL_CATALOG_IMPORTED` (`imported`),
  KEY `MAG2_EMAIL_CATALOG_MODIFIED` (`modified`),
  KEY `MAG2_EMAIL_CATALOG_CREATED_AT` (`created_at`),
  KEY `MAG2_EMAIL_CATALOG_UPDATED_AT` (`updated_at`),
  CONSTRAINT `MAG2_EMAIL_CATALOG_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `mag2_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2131 DEFAULT CHARSET=utf8 COMMENT='Connector Catalog';

--
-- Dumping data for table `mag2_email_catalog`
--

INSERT INTO `mag2_email_catalog` VALUES (2100,1,NULL,NULL,'2021-11-15 20:09:29','2021-11-15 20:09:29'),(2105,9,NULL,NULL,'2021-11-16 20:58:45','2021-11-16 20:58:45'),(2106,10,NULL,NULL,'2021-11-16 21:04:25','2021-11-16 21:04:25'),(2107,11,NULL,NULL,'2021-11-16 21:14:34','2021-11-16 21:14:34'),(2109,15,NULL,NULL,'2021-11-17 00:29:54','2021-11-17 00:29:54'),(2110,16,NULL,NULL,'2021-11-17 00:33:02','2021-11-17 00:33:02'),(2111,17,NULL,NULL,'2021-11-17 00:35:52','2021-11-17 00:35:52'),(2112,18,NULL,NULL,'2021-11-17 00:39:16','2021-11-17 00:39:16'),(2114,20,NULL,NULL,'2021-11-17 01:12:49','2021-11-17 01:12:49'),(2115,21,NULL,NULL,'2021-11-17 01:16:06','2021-11-17 01:16:06'),(2116,22,NULL,NULL,'2021-11-17 01:19:21','2021-11-17 01:19:21'),(2117,23,NULL,NULL,'2021-11-17 06:29:04','2021-11-17 06:29:04'),(2118,24,NULL,NULL,'2021-11-17 06:31:44','2021-11-17 06:31:44'),(2119,25,NULL,NULL,'2021-11-17 06:37:16','2021-11-17 06:37:16'),(2120,26,NULL,NULL,'2021-11-17 06:39:57','2021-11-17 06:39:57'),(2121,27,NULL,NULL,'2021-11-17 06:42:41','2021-11-17 06:42:41'),(2122,28,NULL,NULL,'2021-11-17 06:44:53','2021-11-17 06:44:53'),(2123,29,NULL,NULL,'2021-11-17 06:47:54','2021-11-17 06:47:54'),(2124,30,NULL,NULL,'2021-11-17 06:50:02','2021-11-17 06:50:02'),(2125,31,NULL,NULL,'2021-11-17 17:21:54','2021-11-17 17:21:54'),(2126,32,NULL,NULL,'2021-11-17 17:21:57','2021-11-17 17:21:57'),(2127,33,NULL,NULL,'2021-11-17 17:29:00','2021-11-17 17:29:00'),(2128,34,NULL,NULL,'2021-11-17 17:31:30','2021-11-17 17:31:30'),(2129,35,NULL,NULL,'2021-11-17 17:33:28','2021-11-17 17:33:28'),(2130,36,NULL,NULL,'2021-11-17 17:33:29','2021-11-17 17:33:29');

--
-- Table structure for table `mag2_email_contact`
--

CREATE TABLE `mag2_email_contact` (
  `email_contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `is_guest` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Guest',
  `contact_id` varchar(15) DEFAULT NULL COMMENT 'Connector Contact ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Customer Email',
  `is_subscriber` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Subscriber',
  `subscriber_status` smallint(5) unsigned DEFAULT NULL COMMENT 'Subscriber status',
  `email_imported` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Imported',
  `subscriber_imported` smallint(5) unsigned DEFAULT NULL COMMENT 'Subscriber Imported',
  `suppressed` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Suppressed',
  PRIMARY KEY (`email_contact_id`),
  KEY `MAG2_EMAIL_CONTACT_EMAIL_CONTACT_ID` (`email_contact_id`),
  KEY `MAG2_EMAIL_CONTACT_IS_GUEST` (`is_guest`),
  KEY `MAG2_EMAIL_CONTACT_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_EMAIL_CONTACT_WEBSITE_ID` (`website_id`),
  KEY `MAG2_EMAIL_CONTACT_IS_SUBSCRIBER` (`is_subscriber`),
  KEY `MAG2_EMAIL_CONTACT_SUBSCRIBER_STATUS` (`subscriber_status`),
  KEY `MAG2_EMAIL_CONTACT_EMAIL_IMPORTED` (`email_imported`),
  KEY `MAG2_EMAIL_CONTACT_SUBSCRIBER_IMPORTED` (`subscriber_imported`),
  KEY `MAG2_EMAIL_CONTACT_SUPPRESSED` (`suppressed`),
  KEY `MAG2_EMAIL_CONTACT_EMAIL` (`email`),
  KEY `MAG2_EMAIL_CONTACT_CONTACT_ID` (`contact_id`),
  CONSTRAINT `MAG2_EMAIL_CONTACT_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `mag2_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Connector Contacts';

--
-- Dumping data for table `mag2_email_contact`
--

INSERT INTO `mag2_email_contact` VALUES (1,NULL,NULL,1,1,1,'roni_cost@example.com',NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `mag2_email_importer`
--

CREATE TABLE `mag2_email_importer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `import_type` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Type',
  `website_id` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `import_status` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Import Status',
  `import_id` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Id',
  `import_data` mediumblob NOT NULL COMMENT 'Import Data',
  `import_mode` varchar(255) NOT NULL DEFAULT '' COMMENT 'Import Mode',
  `import_file` text NOT NULL COMMENT 'Import File',
  `message` varchar(255) NOT NULL DEFAULT '' COMMENT 'Error Message',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  `import_started` timestamp NULL DEFAULT NULL COMMENT 'Import Started',
  `import_finished` timestamp NULL DEFAULT NULL COMMENT 'Import Finished',
  PRIMARY KEY (`id`),
  KEY `MAG2_EMAIL_IMPORTER_IMPORT_TYPE` (`import_type`),
  KEY `MAG2_EMAIL_IMPORTER_WEBSITE_ID` (`website_id`),
  KEY `MAG2_EMAIL_IMPORTER_IMPORT_STATUS` (`import_status`),
  KEY `MAG2_EMAIL_IMPORTER_IMPORT_MODE` (`import_mode`),
  KEY `MAG2_EMAIL_IMPORTER_CREATED_AT` (`created_at`),
  KEY `MAG2_EMAIL_IMPORTER_UPDATED_AT` (`updated_at`),
  KEY `MAG2_EMAIL_IMPORTER_IMPORT_ID` (`import_id`),
  KEY `MAG2_EMAIL_IMPORTER_IMPORT_STARTED` (`import_started`),
  KEY `MAG2_EMAIL_IMPORTER_IMPORT_FINISHED` (`import_finished`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Importer';

--
-- Dumping data for table `mag2_email_importer`
--


--
-- Table structure for table `mag2_email_order`
--

CREATE TABLE `mag2_email_order` (
  `email_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_status` varchar(255) NOT NULL COMMENT 'Order Status',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Sales Quote ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `email_imported` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Order Imported',
  `modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Order Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`email_order_id`),
  KEY `MAG2_EMAIL_ORDER_STORE_ID` (`store_id`),
  KEY `MAG2_EMAIL_ORDER_QUOTE_ID` (`quote_id`),
  KEY `MAG2_EMAIL_ORDER_EMAIL_IMPORTED` (`email_imported`),
  KEY `MAG2_EMAIL_ORDER_ORDER_STATUS` (`order_status`),
  KEY `MAG2_EMAIL_ORDER_MODIFIED` (`modified`),
  KEY `MAG2_EMAIL_ORDER_UPDATED_AT` (`updated_at`),
  KEY `MAG2_EMAIL_ORDER_CREATED_AT` (`created_at`),
  KEY `MAG2_EMAIL_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` (`order_id`),
  CONSTRAINT `MAG2_EMAIL_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `mag2_sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_EMAIL_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Transactional Order Data';

--
-- Dumping data for table `mag2_email_order`
--

INSERT INTO `mag2_email_order` VALUES (1,1,'processing',1,1,NULL,NULL,'2021-11-10 08:17:26','2021-11-10 08:17:27'),(2,2,'closed',2,1,NULL,NULL,'2021-11-10 08:17:27','2021-11-10 08:17:28');

--
-- Table structure for table `mag2_email_review`
--

CREATE TABLE `mag2_email_review` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `review_id` int(10) unsigned NOT NULL COMMENT 'Review Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `review_imported` smallint(5) unsigned DEFAULT NULL COMMENT 'Review Imported',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `MAG2_EMAIL_REVIEW_REVIEW_ID` (`review_id`),
  KEY `MAG2_EMAIL_REVIEW_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_EMAIL_REVIEW_STORE_ID` (`store_id`),
  KEY `MAG2_EMAIL_REVIEW_REVIEW_IMPORTED` (`review_imported`),
  KEY `MAG2_EMAIL_REVIEW_CREATED_AT` (`created_at`),
  KEY `MAG2_EMAIL_REVIEW_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Reviews';

--
-- Dumping data for table `mag2_email_review`
--


--
-- Table structure for table `mag2_email_rules`
--

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

--
-- Dumping data for table `mag2_email_rules`
--


--
-- Table structure for table `mag2_email_template`
--

CREATE TABLE `mag2_email_template` (
  `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `template_code` varchar(150) NOT NULL COMMENT 'Template Name',
  `template_text` text NOT NULL COMMENT 'Template Content',
  `template_styles` text COMMENT 'Templste Styles',
  `template_type` int(10) unsigned DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) NOT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Date of Template Creation',
  `modified_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Date of Template Modification',
  `orig_template_code` varchar(200) DEFAULT NULL COMMENT 'Original Template Code',
  `orig_template_variables` text COMMENT 'Original Template Variables',
  PRIMARY KEY (`template_id`),
  UNIQUE KEY `MAG2_EMAIL_TEMPLATE_TEMPLATE_CODE` (`template_code`),
  KEY `MAG2_EMAIL_TEMPLATE_ADDED_AT` (`added_at`),
  KEY `MAG2_EMAIL_TEMPLATE_MODIFIED_AT` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Templates';

--
-- Dumping data for table `mag2_email_template`
--


--
-- Table structure for table `mag2_email_wishlist`
--

CREATE TABLE `mag2_email_wishlist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `wishlist_id` int(10) unsigned NOT NULL COMMENT 'Wishlist Id',
  `item_count` int(10) unsigned NOT NULL COMMENT 'Item Count',
  `customer_id` smallint(5) unsigned NOT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `wishlist_imported` smallint(5) unsigned DEFAULT NULL COMMENT 'Wishlist Imported',
  `wishlist_modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Wishlist Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `MAG2_EMAIL_WISHLIST_WISHLIST_ID` (`wishlist_id`),
  KEY `MAG2_EMAIL_WISHLIST_ITEM_COUNT` (`item_count`),
  KEY `MAG2_EMAIL_WISHLIST_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_EMAIL_WISHLIST_WISHLIST_MODIFIED` (`wishlist_modified`),
  KEY `MAG2_EMAIL_WISHLIST_WISHLIST_IMPORTED` (`wishlist_imported`),
  KEY `MAG2_EMAIL_WISHLIST_CREATED_AT` (`created_at`),
  KEY `MAG2_EMAIL_WISHLIST_UPDATED_AT` (`updated_at`),
  KEY `MAG2_EMAIL_WISHLIST_STORE_ID` (`store_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Wishlist';

--
-- Dumping data for table `mag2_email_wishlist`
--


--
-- Table structure for table `mag2_flag`
--

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

--
-- Dumping data for table `mag2_flag`
--

INSERT INTO `mag2_flag` VALUES (1,'analytics_link_attempts_reverse_counter',0,'24','2021-11-10 08:15:09'),(2,'catalog_website_attribute_is_sync_required',0,'2','2021-11-10 12:04:39');

--
-- Table structure for table `mag2_gift_message`
--

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

--
-- Dumping data for table `mag2_gift_message`
--


--
-- Table structure for table `mag2_googleoptimizer_code`
--

CREATE TABLE `mag2_googleoptimizer_code` (
  `code_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Google experiment code id',
  `entity_id` int(10) unsigned NOT NULL COMMENT 'Optimized entity id product id or catalog id',
  `entity_type` varchar(50) DEFAULT NULL COMMENT 'Optimized entity type',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store id',
  `experiment_script` text COMMENT 'Google experiment script',
  PRIMARY KEY (`code_id`),
  UNIQUE KEY `MAG2_GOOGLEOPTIMIZER_CODE_STORE_ID_ENTITY_ID_ENTITY_TYPE` (`store_id`,`entity_id`,`entity_type`),
  CONSTRAINT `MAG2_GOOGLEOPTIMIZER_CODE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Google Experiment code';

--
-- Dumping data for table `mag2_googleoptimizer_code`
--


--
-- Table structure for table `mag2_import_history`
--

CREATE TABLE `mag2_import_history` (
  `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'History record Id',
  `started_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Started at',
  `user_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'User ID',
  `imported_file` varchar(255) DEFAULT NULL COMMENT 'Imported file',
  `execution_time` varchar(255) DEFAULT NULL COMMENT 'Execution time',
  `summary` varchar(255) DEFAULT NULL COMMENT 'Summary',
  `error_file` varchar(255) NOT NULL COMMENT 'Imported file with errors',
  PRIMARY KEY (`history_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='Import history table';

--
-- Dumping data for table `mag2_import_history`
--

INSERT INTO `mag2_import_history` VALUES (1,'2021-11-10 08:15:24',0,NULL,'00:00:20','Created: 1994, Updated: 0, Deleted: 0',''),(2,'2021-11-10 12:50:18',2,'1636548618_catalog_product_20211107_082618.csv','Validation',NULL,'1636548618_catalog_product_20211107_082618_error_report.csv');

--
-- Table structure for table `mag2_importexport_importdata`
--

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

--
-- Dumping data for table `mag2_importexport_importdata`
--

INSERT INTO `mag2_importexport_importdata` VALUES (21,'catalog_product','append','{\"1\":{\"sku\":\"10003\",\"store_view_code\":\"ar\",\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":null,\"product_websites\":null,\"name\":\"\\u0634\\u0627\\u0645\\u064a\\u0648 \\u0645\\u0648\\u064a\\u0633\\u062a\\u0634\\u0648\\u0631 \\u0644\\u0648\\u0643 1000 \\u0645\\u0644\",\"description\":\"<p>\\u0634\\u0627\\u0645\\u0628\\u0648 \\u0644\\u0644\\u0634\\u0639\\u0631 \\u0627\\u0644\\u0645\\u062c\\u0639\\u062f \\u0627\\u0644\\u0645\\u062e\\u0635\\u0628 \\u0628\\u0632\\u064a\\u0648\\u062a \\u0633\\u0628\\u0639\\u0629 \\u0648 \\u062d\\u0645\\u0627\\u064a\\u0629 \\u0627\\u0644\\u0644\\u0648\\u0646 \\u060c \\u0627\\u0644\\u0645\\u0643\\u0648\\u0646 \\u0627\\u0644\\u0646\\u0634\\u0637 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f \\u0644\\u0644\\u0648\\u0646 \\u0645\\u0634\\u0631\\u0642 \\u0648\\u062f\\u0627\\u0626\\u0645. \\u064a\\u0646\\u0638\\u0641 \\u0628\\u0644\\u0637\\u0641 \\u0648\\u064a\\u0639\\u0637\\u064a \\u062a\\u0623\\u062b\\u064a\\u0631\\u064b\\u0627 \\u0633\\u0644\\u0633\\u064b\\u0627 \\u0648\\u0645\\u0642\\u0627\\u0648\\u0645\\u064b\\u0627 \\u0644\\u0644\\u062a\\u062c\\u0639\\u062f.<\\/p>\",\"short_description\":null,\"weight\":null,\"product_online\":null,\"tax_class_name\":null,\"visibility\":null,\"price\":null,\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":null,\"meta_title\":null,\"meta_keywords\":null,\"meta_description\":null,\"base_image\":null,\"base_image_label\":null,\"small_image\":null,\"small_image_label\":null,\"thumbnail_image\":null,\"thumbnail_image_label\":null,\"swatch_image\":null,\"swatch_image_label\":null,\"created_at\":null,\"updated_at\":null,\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":null,\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":null,\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":null,\"country_of_manufacture\":null,\"additional_attributes\":null,\"qty\":null,\"out_of_stock_qty\":null,\"use_config_min_qty\":null,\"is_qty_decimal\":null,\"allow_backorders\":null,\"use_config_backorders\":null,\"min_cart_qty\":null,\"use_config_min_sale_qty\":null,\"max_cart_qty\":null,\"use_config_max_sale_qty\":null,\"is_in_stock\":null,\"notify_on_stock_below\":null,\"use_config_notify_stock_qty\":null,\"manage_stock\":null,\"use_config_manage_stock\":null,\"use_config_qty_increments\":null,\"qty_increments\":null,\"use_config_enable_qty_inc\":null,\"enable_qty_increments\":null,\"is_decimal_divided\":null,\"website_id\":null,\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":null,\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":null,\"image_label\":null,\"thumbnail\":null,\"thumbnail_label\":null,\"_media_image\":null,\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":\"ar\",\"_attribute_set\":\"Default\",\"_product_websites\":null,\"status\":null,\"news_from_date\":null,\"news_to_date\":null,\"options_container\":null,\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":null,\"backorders\":null,\"min_sale_qty\":null,\"max_sale_qty\":null,\"notify_stock_qty\":null,\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":null,\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null},\"5\":{\"sku\":\"10005-2\",\"store_view_code\":\"ar\",\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":null,\"product_websites\":null,\"name\":\"\\u0642\\u0646\\u0627\\u0639 \\u0645\\u062d\\u0633\\u0646 \\u0644\\u0644\\u0634\\u0639\\u0631 500 \\u0645\\u0644 \",\"description\":\"<p>\\u0642\\u0646\\u0627\\u0639 \\u0645\\u064f\\u062d\\u0633\\u0651\\u0646 \\u0633\\u0639\\u0629 500 \\u0645\\u0644 \\u0645\\u064f\\u0642\\u0648\\u0651\\u0649 \\u0628\\u062a\\u0642\\u0646\\u064a\\u0629 AMINO BOND COMPLEX \\u060c \\u0648\\u0647\\u064a \\u062a\\u0631\\u0643\\u064a\\u0628\\u0629 \\u0641\\u0631\\u064a\\u062f\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u0623\\u062d\\u0645\\u0627\\u0636 \\u0627\\u0644\\u0623\\u0645\\u064a\\u0646\\u064a\\u0629 \\u0648\\u0627\\u0644\\u0643\\u064a\\u0631\\u0627\\u062a\\u064a\\u0646 \\u0627\\u0644\\u0645\\u062a\\u062d\\u0644\\u0644 \\u0628\\u0627\\u0644\\u0645\\u0627\\u0621 \\u0648\\u0627\\u0644\\u0645\\u0643\\u0648\\u0646\\u0627\\u062a \\u0627\\u0644\\u0646\\u0634\\u0637\\u0629 \\u060c \\u0644\\u0644\\u062d\\u0635\\u0648\\u0644 \\u0639\\u0644\\u0649 \\u062a\\u0623\\u062b\\u064a\\u0631 \\u0633\\u0644\\u0633 \\u0648\\u0645\\u0642\\u0627\\u0648\\u0645 \\u0644\\u0644\\u062a\\u062c\\u0639\\u062f.<\\/p>\\r\\n\",\"short_description\":null,\"weight\":null,\"product_online\":null,\"tax_class_name\":null,\"visibility\":null,\"price\":null,\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":null,\"meta_title\":null,\"meta_keywords\":null,\"meta_description\":null,\"base_image\":null,\"base_image_label\":null,\"small_image\":null,\"small_image_label\":null,\"thumbnail_image\":null,\"thumbnail_image_label\":null,\"swatch_image\":null,\"swatch_image_label\":null,\"created_at\":null,\"updated_at\":null,\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":null,\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":null,\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":null,\"country_of_manufacture\":null,\"additional_attributes\":null,\"qty\":null,\"out_of_stock_qty\":null,\"use_config_min_qty\":null,\"is_qty_decimal\":null,\"allow_backorders\":null,\"use_config_backorders\":null,\"min_cart_qty\":null,\"use_config_min_sale_qty\":null,\"max_cart_qty\":null,\"use_config_max_sale_qty\":null,\"is_in_stock\":null,\"notify_on_stock_below\":null,\"use_config_notify_stock_qty\":null,\"manage_stock\":null,\"use_config_manage_stock\":null,\"use_config_qty_increments\":null,\"qty_increments\":null,\"use_config_enable_qty_inc\":null,\"enable_qty_increments\":null,\"is_decimal_divided\":null,\"website_id\":null,\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":null,\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":null,\"image_label\":null,\"thumbnail\":null,\"thumbnail_label\":null,\"_media_image\":null,\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":\"ar\",\"_attribute_set\":\"Default\",\"_product_websites\":null,\"status\":null,\"news_from_date\":null,\"news_to_date\":null,\"options_container\":null,\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":null,\"backorders\":null,\"min_sale_qty\":null,\"max_sale_qty\":null,\"notify_stock_qty\":null,\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":null,\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null},\"7\":{\"sku\":\"10003-1\",\"store_view_code\":\"ar\",\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":null,\"product_websites\":null,\"name\":\"\\u0634\\u0627\\u0645\\u0628\\u0648 \\u0645\\u064a\\u0633\\u062a\\u0634\\u0648\\u0631 \\u0644\\u0648\\u0643 250 \\u0645\\u0644\",\"description\":\"<p><span>\\u0634\\u0627\\u0645\\u0628\\u0648 \\u0644\\u0644\\u0634\\u0639\\u0631 \\u0627\\u0644\\u0645\\u062c\\u0639\\u062f \\u0627\\u0644\\u0645\\u062e\\u0635\\u0628 \\u0628\\u0632\\u064a\\u0648\\u062a \\u0633\\u0628\\u0639\\u0629 \\u0648 \\u062d\\u0645\\u0627\\u064a\\u0629 \\u0627\\u0644\\u0644\\u0648\\u0646 \\u060c \\u0627\\u0644\\u0645\\u0643\\u0648\\u0646 \\u0627\\u0644\\u0646\\u0634\\u0637 \\u0627\\u0644\\u062c\\u062f\\u064a\\u062f \\u0644\\u0644\\u0648\\u0646 \\u0645\\u0634\\u0631\\u0642 \\u0648\\u062f\\u0627\\u0626\\u0645. \\u064a\\u0646\\u0638\\u0641 \\u0628\\u0644\\u0637\\u0641 \\u0648\\u064a\\u0639\\u0637\\u064a \\u062a\\u0623\\u062b\\u064a\\u0631\\u064b\\u0627 \\u0633\\u0644\\u0633\\u064b\\u0627 \\u0648\\u0645\\u0642\\u0627\\u0648\\u0645\\u064b\\u0627 \\u0644\\u0644\\u062a\\u062c\\u0639\\u062f.<p><span>\",\"short_description\":null,\"weight\":null,\"product_online\":null,\"tax_class_name\":null,\"visibility\":null,\"price\":null,\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":null,\"meta_title\":null,\"meta_keywords\":null,\"meta_description\":null,\"base_image\":null,\"base_image_label\":null,\"small_image\":null,\"small_image_label\":null,\"thumbnail_image\":null,\"thumbnail_image_label\":null,\"swatch_image\":null,\"swatch_image_label\":null,\"created_at\":null,\"updated_at\":null,\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":null,\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":null,\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":null,\"country_of_manufacture\":null,\"additional_attributes\":null,\"qty\":null,\"out_of_stock_qty\":null,\"use_config_min_qty\":null,\"is_qty_decimal\":null,\"allow_backorders\":null,\"use_config_backorders\":null,\"min_cart_qty\":null,\"use_config_min_sale_qty\":null,\"max_cart_qty\":null,\"use_config_max_sale_qty\":null,\"is_in_stock\":null,\"notify_on_stock_below\":null,\"use_config_notify_stock_qty\":null,\"manage_stock\":null,\"use_config_manage_stock\":null,\"use_config_qty_increments\":null,\"qty_increments\":null,\"use_config_enable_qty_inc\":null,\"enable_qty_increments\":null,\"is_decimal_divided\":null,\"website_id\":null,\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":null,\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":null,\"image_label\":null,\"thumbnail\":null,\"thumbnail_label\":null,\"_media_image\":null,\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":\"ar\",\"_attribute_set\":\"Default\",\"_product_websites\":null,\"status\":null,\"news_from_date\":null,\"news_to_date\":null,\"options_container\":null,\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":null,\"backorders\":null,\"min_sale_qty\":null,\"max_sale_qty\":null,\"notify_stock_qty\":null,\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":null,\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null},\"11\":{\"sku\":\"10011-3\",\"store_view_code\":\"default\",\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":null,\"product_websites\":null,\"name\":null,\"description\":\"<p>Frizz free leave in cream, fortified with Amino Bond Complex.<\\/p>\",\"short_description\":null,\"weight\":null,\"product_online\":null,\"tax_class_name\":null,\"visibility\":null,\"price\":null,\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":null,\"meta_title\":null,\"meta_keywords\":null,\"meta_description\":null,\"base_image\":null,\"base_image_label\":null,\"small_image\":null,\"small_image_label\":null,\"thumbnail_image\":null,\"thumbnail_image_label\":null,\"swatch_image\":null,\"swatch_image_label\":null,\"created_at\":null,\"updated_at\":null,\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":null,\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":null,\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":null,\"country_of_manufacture\":null,\"additional_attributes\":null,\"qty\":null,\"out_of_stock_qty\":null,\"use_config_min_qty\":null,\"is_qty_decimal\":null,\"allow_backorders\":null,\"use_config_backorders\":null,\"min_cart_qty\":null,\"use_config_min_sale_qty\":null,\"max_cart_qty\":null,\"use_config_max_sale_qty\":null,\"is_in_stock\":null,\"notify_on_stock_below\":null,\"use_config_notify_stock_qty\":null,\"manage_stock\":null,\"use_config_manage_stock\":null,\"use_config_qty_increments\":null,\"qty_increments\":null,\"use_config_enable_qty_inc\":null,\"enable_qty_increments\":null,\"is_decimal_divided\":null,\"website_id\":null,\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":null,\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":null,\"image_label\":null,\"thumbnail\":null,\"thumbnail_label\":null,\"_media_image\":null,\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":\"default\",\"_attribute_set\":\"Default\",\"_product_websites\":null,\"status\":null,\"news_from_date\":null,\"news_to_date\":null,\"options_container\":null,\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":null,\"backorders\":null,\"min_sale_qty\":null,\"max_sale_qty\":null,\"notify_stock_qty\":null,\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":null,\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null},\"12\":{\"sku\":\"10011-3\",\"store_view_code\":\"ar\",\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":null,\"product_websites\":null,\"name\":\"\\u0643\\u0631\\u064a\\u0645 \\u0627\\u0643\\u0633\\u062a\\u0646\\u062f\\u0631 \\u0644\\u0644\\u0634\\u0639\\u0631 90 \\u0645\\u0644\",\"description\":\"<p><span>\\u0625\\u062c\\u0627\\u0632\\u0629 \\u062e\\u0627\\u0644\\u064a\\u0629 \\u0645\\u0646 \\u0627\\u0644\\u062a\\u062c\\u0639\\u062f \\u0628\\u0627\\u0644\\u0643\\u0631\\u064a\\u0645\\u0629 \\u060c \\u0645\\u0639\\u0632\\u0632 \\u0628\\u0645\\u0631\\u0643\\u0628 \\u0623\\u0645\\u064a\\u0646\\u0648 \\u0628\\u0648\\u0646\\u062f.<p><span>\",\"short_description\":null,\"weight\":null,\"product_online\":null,\"tax_class_name\":null,\"visibility\":null,\"price\":null,\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":null,\"meta_title\":null,\"meta_keywords\":null,\"meta_description\":null,\"base_image\":null,\"base_image_label\":null,\"small_image\":null,\"small_image_label\":null,\"thumbnail_image\":null,\"thumbnail_image_label\":null,\"swatch_image\":null,\"swatch_image_label\":null,\"created_at\":null,\"updated_at\":null,\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":null,\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":null,\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":null,\"country_of_manufacture\":null,\"additional_attributes\":null,\"qty\":null,\"out_of_stock_qty\":null,\"use_config_min_qty\":null,\"is_qty_decimal\":null,\"allow_backorders\":null,\"use_config_backorders\":null,\"min_cart_qty\":null,\"use_config_min_sale_qty\":null,\"max_cart_qty\":null,\"use_config_max_sale_qty\":null,\"is_in_stock\":null,\"notify_on_stock_below\":null,\"use_config_notify_stock_qty\":null,\"manage_stock\":null,\"use_config_manage_stock\":null,\"use_config_qty_increments\":null,\"qty_increments\":null,\"use_config_enable_qty_inc\":null,\"enable_qty_increments\":null,\"is_decimal_divided\":null,\"website_id\":null,\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":null,\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":null,\"image_label\":null,\"thumbnail\":null,\"thumbnail_label\":null,\"_media_image\":null,\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":\"ar\",\"_attribute_set\":\"Default\",\"_product_websites\":null,\"status\":null,\"news_from_date\":null,\"news_to_date\":null,\"options_container\":null,\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":null,\"backorders\":null,\"min_sale_qty\":null,\"max_sale_qty\":null,\"notify_stock_qty\":null,\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":null,\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null},\"13\":{\"sku\":\"10006-2\",\"store_view_code\":null,\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":\"Default Category\\/Serum,Default Category\\/Mobile Categories (Don\'t Delete)\\/Home Banner List (Mobile)\\/Serum:421:0\",\"product_websites\":\"base\",\"name\":\"Shimmer 30 ML\",\"description\":\"<p>Anti-frizz Serum with Aragn Oil and Amino Bond Complex<\\/p>\\r\\n\",\"short_description\":null,\"weight\":null,\"product_online\":\"1\",\"tax_class_name\":\"0\",\"visibility\":\"Catalog, Search\",\"price\":\"11.0000\",\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":\"shimmer-30-ml\",\"meta_title\":\"Shimmer 30 ML\",\"meta_keywords\":\"Shimmer 30 ML\",\"meta_description\":\"Shimmer 30 ML \\r\\n\\r\\nAnti-frizz Serum with Aragn Oil and Amino Bond Complex\\r\\n\\r\\n\",\"base_image\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"base_image_label\":null,\"small_image\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"small_image_label\":null,\"thumbnail_image\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"thumbnail_image_label\":null,\"swatch_image\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"swatch_image_label\":null,\"created_at\":\"12\\/28\\/20, 11:14 AM\",\"updated_at\":\"1\\/20\\/21, 3:36 PM\",\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":\"Block after Info Column\",\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":\"Use config\",\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":\"Use config\",\"country_of_manufacture\":null,\"additional_attributes\":\"barcode=10006-2,brand=Nika,charachters_collection=A,color=Multi,gender=Women,img_hover=\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg,manufacturer= ,supplier=N\\/A,thm_featured=No\",\"qty\":\"719.0000\",\"out_of_stock_qty\":\"0.0000\",\"use_config_min_qty\":\"1\",\"is_qty_decimal\":\"0\",\"allow_backorders\":\"0\",\"use_config_backorders\":\"1\",\"min_cart_qty\":\"1.0000\",\"use_config_min_sale_qty\":\"1\",\"max_cart_qty\":\"10000.0000\",\"use_config_max_sale_qty\":\"1\",\"is_in_stock\":\"1\",\"notify_on_stock_below\":\"1.0000\",\"use_config_notify_stock_qty\":\"1\",\"manage_stock\":\"1\",\"use_config_manage_stock\":\"1\",\"use_config_qty_increments\":\"1\",\"qty_increments\":\"1.0000\",\"use_config_enable_qty_inc\":\"1\",\"enable_qty_increments\":\"0\",\"is_decimal_divided\":\"0\",\"website_id\":\"0\",\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"image_label\":null,\"thumbnail\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"thumbnail_label\":null,\"_media_image\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":null,\"_attribute_set\":\"Default\",\"_product_websites\":\"base\",\"status\":\"1\",\"news_from_date\":null,\"news_to_date\":null,\"options_container\":\"Block after Info Column\",\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":\"0.0000\",\"backorders\":\"0\",\"min_sale_qty\":\"1.0000\",\"max_sale_qty\":\"10000.0000\",\"notify_stock_qty\":\"1.0000\",\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":\"Shimmer 30 ML\",\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null,\"barcode\":\"10006-2\",\"brand\":\"Nika\",\"charachters_collection\":\"A\",\"color\":\"Multi\",\"gender\":\"Women\",\"img_hover\":\"\\/a\\/r\\/artboard_1_copy_12_2x-100.jpg\",\"manufacturer\":\" \",\"supplier\":\"N\\/A\",\"thm_featured\":\"No\"},\"14\":{\"sku\":\"10006-2\",\"store_view_code\":\"ar\",\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":null,\"product_websites\":null,\"name\":\"\\u0633\\u064a\\u0631\\u0645 \\u0634\\u064a\\u0645\\u0631 30 \\u0645\\u0644\",\"description\":\"<p><span>\\u0633\\u064a\\u0631\\u0648\\u0645 \\u0645\\u0636\\u0627\\u062f \\u0644\\u0644\\u062a\\u062c\\u0639\\u062f \\u0628\\u0632\\u064a\\u062a \\u0627\\u0644\\u0623\\u0631\\u0627\\u062c\\u0646 \\u0648\\u0645\\u0631\\u0643\\u0628 \\u0623\\u0645\\u064a\\u0646\\u0648 \\u0628\\u0648\\u0646\\u062f<p><span>\",\"short_description\":null,\"weight\":null,\"product_online\":null,\"tax_class_name\":null,\"visibility\":null,\"price\":null,\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":null,\"meta_title\":null,\"meta_keywords\":null,\"meta_description\":null,\"base_image\":null,\"base_image_label\":null,\"small_image\":null,\"small_image_label\":null,\"thumbnail_image\":null,\"thumbnail_image_label\":null,\"swatch_image\":null,\"swatch_image_label\":null,\"created_at\":null,\"updated_at\":null,\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":null,\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":null,\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":null,\"country_of_manufacture\":null,\"additional_attributes\":null,\"qty\":null,\"out_of_stock_qty\":null,\"use_config_min_qty\":null,\"is_qty_decimal\":null,\"allow_backorders\":null,\"use_config_backorders\":null,\"min_cart_qty\":null,\"use_config_min_sale_qty\":null,\"max_cart_qty\":null,\"use_config_max_sale_qty\":null,\"is_in_stock\":null,\"notify_on_stock_below\":null,\"use_config_notify_stock_qty\":null,\"manage_stock\":null,\"use_config_manage_stock\":null,\"use_config_qty_increments\":null,\"qty_increments\":null,\"use_config_enable_qty_inc\":null,\"enable_qty_increments\":null,\"is_decimal_divided\":null,\"website_id\":null,\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":null,\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":null,\"image_label\":null,\"thumbnail\":null,\"thumbnail_label\":null,\"_media_image\":null,\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":\"ar\",\"_attribute_set\":\"Default\",\"_product_websites\":null,\"status\":null,\"news_from_date\":null,\"news_to_date\":null,\"options_container\":null,\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":null,\"backorders\":null,\"min_sale_qty\":null,\"max_sale_qty\":null,\"notify_stock_qty\":null,\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":null,\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null},\"18\":{\"sku\":\"40004-1\",\"store_view_code\":\"ar\",\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":null,\"product_websites\":null,\"name\":\"\\u0628\\u0644\\u0633\\u0645 \\u062a\\u0627\\u064a\\u0645\\u0644\\u064a\\u0633 \\u0628\\u0644\\u064a\\u0646\\u062f 100 \\u0645\\u0644\",\"description\":\"<p><span>\\u0628\\u0644\\u0633\\u0645 \\u0645\\u0631\\u0637\\u0628 \\u0645\\u0636\\u0627\\u062f \\u0644\\u0644\\u0634\\u064a\\u062e\\u0648\\u062e\\u0629 \\u0644\\u0644\\u0634\\u0639\\u0631 \\u0627\\u0644\\u062c\\u0627\\u0641 \\u0645\\u0639 REBORN COMPLEX.<p><span>\",\"short_description\":null,\"weight\":null,\"product_online\":null,\"tax_class_name\":null,\"visibility\":null,\"price\":null,\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":null,\"meta_title\":null,\"meta_keywords\":null,\"meta_description\":null,\"base_image\":null,\"base_image_label\":null,\"small_image\":null,\"small_image_label\":null,\"thumbnail_image\":null,\"thumbnail_image_label\":null,\"swatch_image\":null,\"swatch_image_label\":null,\"created_at\":null,\"updated_at\":null,\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":null,\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":null,\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":null,\"country_of_manufacture\":null,\"additional_attributes\":null,\"qty\":null,\"out_of_stock_qty\":null,\"use_config_min_qty\":null,\"is_qty_decimal\":null,\"allow_backorders\":null,\"use_config_backorders\":null,\"min_cart_qty\":null,\"use_config_min_sale_qty\":null,\"max_cart_qty\":null,\"use_config_max_sale_qty\":null,\"is_in_stock\":null,\"notify_on_stock_below\":null,\"use_config_notify_stock_qty\":null,\"manage_stock\":null,\"use_config_manage_stock\":null,\"use_config_qty_increments\":null,\"qty_increments\":null,\"use_config_enable_qty_inc\":null,\"enable_qty_increments\":null,\"is_decimal_divided\":null,\"website_id\":null,\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":null,\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":null,\"image_label\":null,\"thumbnail\":null,\"thumbnail_label\":null,\"_media_image\":null,\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":\"ar\",\"_attribute_set\":\"Default\",\"_product_websites\":null,\"status\":null,\"news_from_date\":null,\"news_to_date\":null,\"options_container\":null,\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":null,\"backorders\":null,\"min_sale_qty\":null,\"max_sale_qty\":null,\"notify_stock_qty\":null,\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":null,\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null},\"23\":{\"sku\":\"40004\",\"store_view_code\":null,\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":\"Default Category\\/Conditioner,Default Category\\/Mobile Categories (Don\'t Delete)\\/Home Banner List (Mobile)\\/Conditioner:419:0\",\"product_websites\":\"base\",\"name\":\"Timless Blend Conditioner 250 ML\",\"description\":\"\\r\\n<p>Moisturizing anti-age\\u00a0Conditioner\\u00a0for dry hair with\\u00a0REBORN COMPLEX.<\\/p>\\r\\n\",\"short_description\":null,\"weight\":null,\"product_online\":\"1\",\"tax_class_name\":\"0\",\"visibility\":\"Catalog, Search\",\"price\":\"8.5000\",\"special_price\":null,\"special_price_from_date\":null,\"special_price_to_date\":null,\"url_key\":\"timless-blend-conditioner-250-ml\",\"meta_title\":\"Timless Blend Conditioner 250 ML\",\"meta_keywords\":\"Timless Blend Conditioner 250 ML\",\"meta_description\":\"Timless Blend Conditioner 250 ML \\r\\n\\r\\nMoisturizing anti-age\\u00a0Conditioner\\u00a0for dry hair with\\u00a0REBORN COMPLEX.\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\\r\\n\",\"base_image\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"base_image_label\":null,\"small_image\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"small_image_label\":null,\"thumbnail_image\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"thumbnail_image_label\":null,\"swatch_image\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"swatch_image_label\":null,\"created_at\":\"12\\/28\\/20, 11:50 AM\",\"updated_at\":\"1\\/20\\/21, 3:35 PM\",\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":\"Block after Info Column\",\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":\"Use config\",\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":\"Use config\",\"country_of_manufacture\":null,\"additional_attributes\":\"barcode=40004,brand=Nika,charachters_collection=A,color=Multi,img_hover=\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg,manufacturer= ,supplier=N\\/A,thm_featured=No\",\"qty\":\"351.0000\",\"out_of_stock_qty\":\"0.0000\",\"use_config_min_qty\":\"1\",\"is_qty_decimal\":\"0\",\"allow_backorders\":\"0\",\"use_config_backorders\":\"1\",\"min_cart_qty\":\"1.0000\",\"use_config_min_sale_qty\":\"1\",\"max_cart_qty\":\"10000.0000\",\"use_config_max_sale_qty\":\"1\",\"is_in_stock\":\"1\",\"notify_on_stock_below\":\"1.0000\",\"use_config_notify_stock_qty\":\"1\",\"manage_stock\":\"1\",\"use_config_manage_stock\":\"1\",\"use_config_qty_increments\":\"1\",\"qty_increments\":\"1.0000\",\"use_config_enable_qty_inc\":\"1\",\"enable_qty_increments\":\"0\",\"is_decimal_divided\":\"0\",\"website_id\":\"0\",\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"image_label\":null,\"thumbnail\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"thumbnail_label\":null,\"_media_image\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":null,\"_attribute_set\":\"Default\",\"_product_websites\":\"base\",\"status\":\"1\",\"news_from_date\":null,\"news_to_date\":null,\"options_container\":\"Block after Info Column\",\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":null,\"special_to_date\":null,\"min_qty\":\"0.0000\",\"backorders\":\"0\",\"min_sale_qty\":\"1.0000\",\"max_sale_qty\":\"10000.0000\",\"notify_stock_qty\":\"1.0000\",\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":\"Timless Blend Conditioner 250 ML\",\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null,\"barcode\":\"40004\",\"brand\":\"Nika\",\"charachters_collection\":\"A\",\"color\":\"Multi\",\"img_hover\":\"\\/a\\/r\\/artboard_1_copy_9_2x-100_1_1.jpg\",\"manufacturer\":\" \",\"supplier\":\"N\\/A\",\"thm_featured\":\"No\"},\"41\":{\"sku\":\"2\",\"store_view_code\":null,\"attribute_set_code\":\"Default\",\"product_type\":\"simple\",\"categories\":\"Default Category\\/Promotion Packages,Default Category\\/Mobile Categories (Don\'t Delete)\\/Home Banner List (Mobile)\\/Promotion Packages:426:0\",\"product_websites\":\"base\",\"name\":\"K-Perfection Package - 1000 ml\",\"description\":\"<p>K-Perfection Package: Shampoo + Conditioner + Serum 1000ml<\\/p>\",\"short_description\":null,\"weight\":null,\"product_online\":\"1\",\"tax_class_name\":\"0\",\"visibility\":\"Catalog, Search\",\"price\":\"75.0000\",\"special_price\":\"65.0000\",\"special_price_from_date\":\"3\\/14\\/21\",\"special_price_to_date\":\"4\\/14\\/21\",\"url_key\":\"k-perfection-package-1000-ml\",\"meta_title\":\"K-Perfection Package - 1000 ml\",\"meta_keywords\":\"K-Perfection Package - 1000 ml\",\"meta_description\":\"K-Perfection Package - 1000 ml K-Perfection Package: Shampoo + Conditioner + Serum 1000ml\",\"base_image\":\"\\/1\\/_\\/1_8_1.jpg\",\"base_image_label\":null,\"small_image\":\"\\/1\\/_\\/1_8_1.jpg\",\"small_image_label\":null,\"thumbnail_image\":\"\\/1\\/_\\/1_8_1.jpg\",\"thumbnail_image_label\":null,\"swatch_image\":\"\\/1\\/_\\/1_8_1.jpg\",\"swatch_image_label\":null,\"created_at\":\"3\\/14\\/21, 11:12 AM\",\"updated_at\":\"3\\/14\\/21, 11:14 AM\",\"new_from_date\":null,\"new_to_date\":null,\"display_product_options_in\":\"Block after Info Column\",\"map_price\":null,\"msrp_price\":null,\"map_enabled\":null,\"gift_message_available\":\"Use config\",\"custom_design\":null,\"custom_design_from\":null,\"custom_design_to\":null,\"custom_layout_update\":null,\"page_layout\":null,\"product_options_container\":null,\"msrp_display_actual_price_type\":\"Use config\",\"country_of_manufacture\":null,\"additional_attributes\":\"barcode=2,brand=Nika,charachters_collection=A,color=Multi,gender=Women,img_hover=\\/1\\/_\\/1_8_1.jpg,manufacturer= ,supplier=N\\/A,thm_featured=No\",\"qty\":\"100.0000\",\"out_of_stock_qty\":\"0.0000\",\"use_config_min_qty\":\"1\",\"is_qty_decimal\":\"0\",\"allow_backorders\":\"0\",\"use_config_backorders\":\"1\",\"min_cart_qty\":\"1.0000\",\"use_config_min_sale_qty\":\"1\",\"max_cart_qty\":\"10000.0000\",\"use_config_max_sale_qty\":\"1\",\"is_in_stock\":\"1\",\"notify_on_stock_below\":\"1.0000\",\"use_config_notify_stock_qty\":\"1\",\"manage_stock\":\"1\",\"use_config_manage_stock\":\"1\",\"use_config_qty_increments\":\"1\",\"qty_increments\":\"1.0000\",\"use_config_enable_qty_inc\":\"1\",\"enable_qty_increments\":\"0\",\"is_decimal_divided\":\"0\",\"website_id\":\"0\",\"related_skus\":null,\"related_position\":null,\"crosssell_skus\":null,\"crosssell_position\":null,\"upsell_skus\":null,\"upsell_position\":null,\"additional_images\":\"\\/1\\/_\\/1_8_1.jpg\",\"additional_image_labels\":null,\"hide_from_product_page\":null,\"custom_options\":null,\"bundle_price_type\":null,\"bundle_sku_type\":null,\"bundle_price_view\":null,\"bundle_weight_type\":null,\"bundle_values\":null,\"bundle_shipment_type\":null,\"configurable_variations\":null,\"configurable_variation_labels\":null,\"associated_skus\":null,\"image\":\"\\/1\\/_\\/1_8_1.jpg\",\"image_label\":null,\"thumbnail\":\"\\/1\\/_\\/1_8_1.jpg\",\"thumbnail_label\":null,\"_media_image\":\"\\/1\\/_\\/1_8_1.jpg\",\"_media_image_label\":null,\"_media_is_disabled\":null,\"_store\":null,\"_attribute_set\":\"Default\",\"_product_websites\":\"base\",\"status\":\"1\",\"news_from_date\":null,\"news_to_date\":null,\"options_container\":\"Block after Info Column\",\"minimal_price\":null,\"msrp\":null,\"msrp_enabled\":null,\"special_from_date\":\"3\\/14\\/21\",\"special_to_date\":\"4\\/14\\/21\",\"min_qty\":\"0.0000\",\"backorders\":\"0\",\"min_sale_qty\":\"1.0000\",\"max_sale_qty\":\"10000.0000\",\"notify_stock_qty\":\"1.0000\",\"_related_sku\":null,\"_related_position\":null,\"_crosssell_sku\":null,\"_crosssell_position\":null,\"_upsell_sku\":null,\"_upsell_position\":null,\"meta_keyword\":\"K-Perfection Package - 1000 ml\",\"price_type\":null,\"shipment_type\":null,\"price_view\":null,\"weight_type\":null,\"sku_type\":null,\"barcode\":\"2\",\"brand\":\"Nika\",\"charachters_collection\":\"A\",\"color\":\"Multi\",\"gender\":\"Women\",\"img_hover\":\"\\/1\\/_\\/1_8_1.jpg\",\"manufacturer\":\" \",\"supplier\":\"N\\/A\",\"thm_featured\":\"No\"}}');

--
-- Table structure for table `mag2_indexer_state`
--

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

--
-- Dumping data for table `mag2_indexer_state`
--

INSERT INTO `mag2_indexer_state` VALUES (1,'design_config_grid','valid','2021-11-17 10:45:13','34ec592bfa6c952bed4d0a1d58c98770'),(2,'customer_grid','valid','2021-11-15 19:57:14','b9632e06cf957d6e8103eb236ca38cc1'),(3,'catalog_category_product','valid','2021-11-15 19:57:14','2124d5bfcd83b609c67eee94a0e4708c'),(4,'catalog_product_category','valid','2021-11-10 08:16:46','77b6356629f3259568a68ea64c773238'),(5,'catalogrule_rule','valid','2021-11-15 19:57:15','c4f8344a2e6a7d8ebc065631454a4724'),(6,'catalog_product_attribute','invalid','2021-11-16 20:59:31','f73cae77ec4dee3b587a60a2f38dd26a'),(7,'cataloginventory_stock','valid','2021-11-15 19:57:15','1bf66e64558a5171e523b32f25cb99ca'),(8,'catalogsearch_fulltext','invalid','2021-11-16 20:59:31','cc2d2701487ee835df4e72b15254852b'),(9,'catalog_product_price','valid','2021-11-15 19:57:15','cbab4723efb02ca24e1db167ef1dfd13'),(10,'catalogrule_product','valid','2021-11-15 19:57:15','667205576ee3764b1ee81c4a076d10ae');

--
-- Table structure for table `mag2_integration`
--

CREATE TABLE `mag2_integration` (
  `integration_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Integration ID',
  `name` varchar(255) NOT NULL COMMENT 'Integration name is displayed in the admin interface',
  `email` varchar(255) NOT NULL COMMENT 'Email address of the contact person',
  `endpoint` varchar(255) DEFAULT NULL COMMENT 'Endpoint for posting consumer credentials',
  `status` smallint(5) unsigned NOT NULL COMMENT 'Integration status',
  `consumer_id` int(10) unsigned DEFAULT NULL COMMENT 'Oauth consumer',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Creation Time',
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Update Time',
  `setup_type` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Integration type - manual or config file',
  `identity_link_url` varchar(255) DEFAULT NULL COMMENT 'Identity linking Url',
  PRIMARY KEY (`integration_id`),
  UNIQUE KEY `MAG2_INTEGRATION_NAME` (`name`),
  UNIQUE KEY `MAG2_INTEGRATION_CONSUMER_ID` (`consumer_id`),
  CONSTRAINT `MAG2_INTEGRATION_CONSUMER_ID_MAG2_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `mag2_oauth_consumer` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='mag2_integration';

--
-- Dumping data for table `mag2_integration`
--

INSERT INTO `mag2_integration` VALUES (13,'Magento Social','social-support@magento.com','https://fbapp.ezsocialshop.com/facebook/index.php/magento_auth',2,13,'2021-11-17 09:46:43','2021-11-17 09:46:43',1,'https://fbapp.ezsocialshop.com/facebook/index.php/magento2/show_magento_success_popup');

--
-- Table structure for table `mag2_klarna_core_order`
--

CREATE TABLE `mag2_klarna_core_order` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `klarna_order_id` varchar(255) DEFAULT NULL COMMENT 'Klarna Order Id',
  `session_id` varchar(255) DEFAULT NULL COMMENT 'Session Id',
  `reservation_id` varchar(255) DEFAULT NULL COMMENT 'Reservation Id',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order Id',
  `is_acknowledged` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Acknowledged',
  PRIMARY KEY (`id`),
  KEY `MAG2_KLARNA_KCO_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` (`order_id`),
  CONSTRAINT `MAG2_KLARNA_KCO_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `mag2_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Klarna Checkout Order';

--
-- Dumping data for table `mag2_klarna_core_order`
--


--
-- Table structure for table `mag2_klarna_payments_quote`
--

CREATE TABLE `mag2_klarna_payments_quote` (
  `payments_quote_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Payments Id',
  `session_id` varchar(255) DEFAULT NULL COMMENT 'Klarna Session Id',
  `client_token` text COMMENT 'Klarna Client Token',
  `authorization_token` varchar(255) DEFAULT NULL COMMENT 'Authorization Token',
  `is_active` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Quote Id',
  `payment_methods` varchar(255) DEFAULT NULL COMMENT 'Payment Method Categories',
  PRIMARY KEY (`payments_quote_id`),
  KEY `MAG2_KLARNA_PAYMENTS_QUOTE_QUOTE_ID_QUOTE_ENTITY_ID` (`quote_id`),
  CONSTRAINT `MAG2_KLARNA_PAYMENTS_QUOTE_QUOTE_ID_QUOTE_ENTITY_ID` FOREIGN KEY (`quote_id`) REFERENCES `mag2_quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Klarna Payments Quote';

--
-- Dumping data for table `mag2_klarna_payments_quote`
--


--
-- Table structure for table `mag2_layout_link`
--

CREATE TABLE `mag2_layout_link` (
  `layout_link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Link Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `theme_id` int(10) unsigned NOT NULL COMMENT 'Theme id',
  `layout_update_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Layout Update Id',
  `is_temporary` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Defines whether Layout Update is Temporary',
  PRIMARY KEY (`layout_link_id`),
  KEY `MAG2_LAYOUT_LINK_LAYOUT_UPDATE_ID` (`layout_update_id`),
  KEY `MAG2_LAYOUT_LINK_STORE_ID_THEME_ID_LAYOUT_UPDATE_ID_IS_TEMPORARY` (`store_id`,`theme_id`,`layout_update_id`,`is_temporary`),
  KEY `MAG2_LAYOUT_LINK_THEME_ID_THEME_THEME_ID` (`theme_id`),
  CONSTRAINT `MAG2_LAYOUT_LINK_LAYOUT_UPDATE_ID_LAYOUT_UPDATE_LAYOUT_UPDATE_ID` FOREIGN KEY (`layout_update_id`) REFERENCES `mag2_layout_update` (`layout_update_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_LAYOUT_LINK_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_LAYOUT_LINK_THEME_ID_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `mag2_theme` (`theme_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Layout Link';

--
-- Dumping data for table `mag2_layout_link`
--

INSERT INTO `mag2_layout_link` VALUES (1,0,2,1,0),(2,0,2,2,0),(3,0,2,3,0),(4,0,2,4,0),(5,0,2,5,0),(6,0,2,6,0),(7,0,2,7,0),(8,0,2,8,0),(9,0,2,9,0),(10,0,2,10,0),(11,0,2,11,0),(12,0,2,12,0),(13,0,2,13,0),(14,0,2,14,0),(15,0,2,15,0),(16,0,2,16,0),(17,0,2,17,0),(18,0,2,18,0);

--
-- Table structure for table `mag2_layout_update`
--

CREATE TABLE `mag2_layout_update` (
  `layout_update_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Layout Update Id',
  `handle` varchar(255) DEFAULT NULL COMMENT 'Handle',
  `xml` text COMMENT 'Xml',
  `sort_order` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Sort Order',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Last Update Timestamp',
  PRIMARY KEY (`layout_update_id`),
  KEY `MAG2_LAYOUT_UPDATE_HANDLE` (`handle`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='Layout Updates';

--
-- Dumping data for table `mag2_layout_update`
--

INSERT INTO `mag2_layout_update` VALUES (1,'contact_index_index','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"ad7d37fdbcda6e2305331f96bef39f98\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">2</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(2,'default','<body><referenceContainer name=\"cms_footer_links_container\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"81c4e55211a2fee37092748035dfd46e\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">1</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(3,'catalog_category_view_id_37','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"a232e69f9f9d6775352640e7d480c6f3\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">3</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(4,'catalog_category_view_id_3','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"3b35514dfa6595676c4665aebdd76e64\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">4</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(5,'catalog_category_view_id_11','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"af26b8e7d1a198181b8548d8282a1ffe\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">5</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(6,'catalog_category_view_id_20','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"4965e1511668b73e8fdfbffa095206b4\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">6</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(7,'catalog_category_view_id_38','<body><referenceContainer name=\"sidebar.main\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"10a7f7471a851a30242f929b540434cd\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">7</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(8,'catalog_category_view_id_20','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"776ea0399446448b7484b0d51fc9b5c8\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">8</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(9,'catalog_category_view_id_9','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"c5f81aa32e2342a02ad08747b0f77e3e\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">9</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(10,'catalog_category_view_id_11','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"2bbaa33b3a1b1415a6c34df34ad374a4\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">10</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(11,'catalog_category_view_id_3','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"b9aa864e8bb3584971525475fe0748c1\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">11</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(12,'catalog_category_view_id_38','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"8106381e8019f99fc6f85066f7a6bd51\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">13</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(13,'catalog_category_view_id_37','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"fc5407c6e036915ec757b17d4edf4480\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">12</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(14,'cms_index_index','<body><referenceContainer name=\"content\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"8953197763e81cebec76665e5b3bfd20\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">14</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(15,'catalog_category_view_id_39','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"65cc2c818efaffa17152c73f45bedcdd\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">15</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(16,'catalog_category_view_id_40','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"38c4d017355878f6161ff6b58affe81b\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">16</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(17,'customer_account_login','<body><referenceContainer name=\"customer.login.container\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"3b6351ef977310765c5a11d07e3038b3\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">18</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00'),(18,'catalog_category_view_id_','<body><referenceContainer name=\"content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"ad37ae1d4c56155ad61b87f41f441f69\" template=\"widget/static_block/default.phtml\"><action method=\"setData\"><argument name=\"name\" xsi:type=\"string\">block_id</argument><argument name=\"value\" xsi:type=\"string\">17</argument></action></block></referenceContainer></body>',0,'0000-00-00 00:00:00');

--
-- Table structure for table `mag2_magefan_blog_category`
--

CREATE TABLE `mag2_magefan_blog_category` (
  `category_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Category ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Category Title',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Category Meta Title',
  `meta_keywords` text COMMENT 'Category Meta Keywords',
  `meta_description` text COMMENT 'Category Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Category String Identifier',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Category Content Heading',
  `content` mediumtext COMMENT 'Category Content',
  `path` varchar(255) DEFAULT NULL COMMENT 'Category Path',
  `position` smallint(6) NOT NULL COMMENT 'Category Position',
  `posts_sort_by` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Post Sort By',
  `include_in_menu` smallint(6) DEFAULT NULL COMMENT 'Category In Menu',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Category Active',
  `display_mode` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Display Mode',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Post Layout',
  `layout_update_xml` text COMMENT 'Post Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Post Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Post Custom Template',
  `custom_layout_update_xml` text COMMENT 'Post Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Post Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Post Custom Theme Active To Date',
  PRIMARY KEY (`category_id`),
  KEY `MAG2_MAGEFAN_BLOG_CATEGORY_IDENTIFIER` (`identifier`),
  KEY `MAG2_MAGEFAN_BLOG_CATEGORY_INCLUDE_IN_MENU` (`include_in_menu`),
  FULLTEXT KEY `FTI_5367C357FDEACFB31584E60ED20AE19B` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Category Table';

--
-- Dumping data for table `mag2_magefan_blog_category`
--


--
-- Table structure for table `mag2_magefan_blog_category_store`
--

CREATE TABLE `mag2_magefan_blog_category_store` (
  `category_id` int(11) NOT NULL COMMENT 'Category ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`category_id`,`store_id`),
  KEY `MAG2_MAGEFAN_BLOG_CATEGORY_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_MAGEFAN_BLOG_CATEGORY_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_MAGEFAN_BLOG_CTGR_STORE_CTGR_ID_MAGEFAN_BLOG_CTGR_CTGR_ID` FOREIGN KEY (`category_id`) REFERENCES `mag2_magefan_blog_category` (`category_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Category To Store Linkage Table';

--
-- Dumping data for table `mag2_magefan_blog_category_store`
--


--
-- Table structure for table `mag2_magefan_blog_comment`
--

CREATE TABLE `mag2_magefan_blog_comment` (
  `comment_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Comment ID',
  `parent_id` int(11) NOT NULL COMMENT 'Parent Comment ID',
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `customer_id` int(11) DEFAULT NULL COMMENT 'Customer ID',
  `admin_id` int(11) DEFAULT NULL COMMENT 'Admin User ID',
  `status` smallint(6) NOT NULL COMMENT 'Comment status',
  `author_type` smallint(6) NOT NULL COMMENT 'Author Type',
  `author_nickname` varchar(255) NOT NULL COMMENT 'Comment Author Nickname',
  `author_email` varchar(255) DEFAULT NULL COMMENT 'Comment Author Email',
  `text` mediumtext COMMENT 'Text',
  `creation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Comment Creation Time',
  `update_time` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Comment Update Time',
  PRIMARY KEY (`comment_id`),
  KEY `MAG2_MAGEFAN_BLOG_COMMENT_PARENT_ID` (`parent_id`),
  KEY `MAG2_MAGEFAN_BLOG_COMMENT_POST_ID` (`post_id`),
  KEY `MAG2_MAGEFAN_BLOG_COMMENT_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_MAGEFAN_BLOG_COMMENT_ADMIN_ID` (`admin_id`),
  KEY `MAG2_MAGEFAN_BLOG_COMMENT_STATUS` (`status`),
  CONSTRAINT `MAG2_MAGEFAN_BLOG_COMMENT_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `mag2_magefan_blog_post` (`post_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='mag2_magefan_blog_comment';

--
-- Dumping data for table `mag2_magefan_blog_comment`
--


--
-- Table structure for table `mag2_magefan_blog_post`
--

CREATE TABLE `mag2_magefan_blog_post` (
  `post_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Post ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Post Title',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Post Meta Title',
  `meta_keywords` text COMMENT 'Post Meta Keywords',
  `meta_description` text COMMENT 'Post Meta Description',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Post String Identifier',
  `og_title` varchar(255) DEFAULT NULL COMMENT 'Post OG Title',
  `og_description` varchar(255) DEFAULT NULL COMMENT 'Post OG Description',
  `og_img` varchar(255) DEFAULT NULL COMMENT 'Post OG Img',
  `og_type` varchar(255) DEFAULT NULL COMMENT 'Post OG Type',
  `content_heading` varchar(255) DEFAULT NULL COMMENT 'Post Content Heading',
  `content` mediumtext COMMENT 'Post Content',
  `creation_time` timestamp NULL DEFAULT NULL COMMENT 'Post Creation Time',
  `update_time` timestamp NULL DEFAULT NULL COMMENT 'Post Modification Time',
  `publish_time` timestamp NULL DEFAULT NULL COMMENT 'Post Publish Time',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Post Active',
  `include_in_recent` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Include in Recent Posts',
  `position` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Position',
  `featured_img` varchar(255) DEFAULT NULL COMMENT 'Thumbnail Image',
  `author_id` int(11) DEFAULT NULL COMMENT 'Author ID',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Post Layout',
  `layout_update_xml` text COMMENT 'Post Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Post Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Post Custom Template',
  `custom_layout_update_xml` text COMMENT 'Post Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Post Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Post Custom Theme Active To Date',
  `media_gallery` mediumtext COMMENT 'Media Gallery',
  `secret` varchar(32) DEFAULT NULL COMMENT 'Post Secret',
  `views_count` int(11) DEFAULT NULL COMMENT 'Post Views Count',
  `is_recent_posts_skip` smallint(6) DEFAULT NULL COMMENT 'Is Post Skipped From Recent Posts',
  `short_content` mediumtext COMMENT 'Post Short Content',
  PRIMARY KEY (`post_id`),
  KEY `MAG2_MAGEFAN_BLOG_POST_IDENTIFIER` (`identifier`),
  KEY `MAG2_MAGEFAN_BLOG_POST_AUTHOR_ID` (`author_id`),
  KEY `MAG2_MAGEFAN_BLOG_POST_VIEWS_COUNT` (`views_count`),
  KEY `MAG2_MAGEFAN_BLOG_POST_IS_RECENT_POSTS_SKIP` (`is_recent_posts_skip`),
  FULLTEXT KEY `FTI_3B0B1081E0B402D759EE15500C6442A3` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post Table';

--
-- Dumping data for table `mag2_magefan_blog_post`
--

INSERT INTO `mag2_magefan_blog_post` VALUES (1,'Hello world!',NULL,'magento 2 blog','Magento 2 blog default post.','hello-world',NULL,NULL,NULL,NULL,'Hello world!','<p>Welcome to <a title=\"Magefan - solutions for Magento 2\" href=\"http://magefan.com/\" target=\"_blank\">Magefan</a> <a title=\"Magento 2 Blog extension\" href=\"https://magefan.com/magento2-blog-extension/\" target=\"_blank\">blog extension for Magento&reg; 2</a>. This is your first post. Edit or delete it, then start blogging!</p>\n<p><!-- pagebreak --></p>\n<p>Please also read&nbsp;<a title=\"Magento 2 Blog online documentation\" href=\"http://magefan.com/docs/magento-2-blog/\" target=\"_blank\">Online documentation</a>&nbsp;and&nbsp;<a href=\"http://magefan.com/blog/add-read-more-tag-to-blog-post-content/\" target=\"_blank\">How to add \"read more\" tag to post content</a></p>\n<p>Follow Magefan on:</p>\n<p><a title=\"Blog Extension for Magento 2 code\" href=\"https://github.com/magefan/module-blog\" target=\"_blank\">GitHub</a>&nbsp;|&nbsp;<a href=\"https://twitter.com/magento2fan\" target=\"_blank\">Twitter</a>&nbsp;|&nbsp;<a href=\"https://www.facebook.com/magefan/\" target=\"_blank\">Facebook</a>&nbsp;|&nbsp;<a href=\"https://plus.google.com/+Magefan_Magento_2/posts/\" target=\"_blank\">Google +</a></p>','2021-11-10 08:23:45','2021-11-10 08:23:45','2021-11-10 08:23:45',1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `mag2_magefan_blog_post_category`
--

CREATE TABLE `mag2_magefan_blog_post_category` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `category_id` int(11) NOT NULL COMMENT 'Category ID',
  PRIMARY KEY (`post_id`,`category_id`),
  KEY `MAG2_MAGEFAN_BLOG_POST_CATEGORY_CATEGORY_ID` (`category_id`),
  CONSTRAINT `MAG2_MAGEFAN_BLOG_POST_CTGR_CTGR_ID_MAGEFAN_BLOG_CTGR_CTGR_ID` FOREIGN KEY (`category_id`) REFERENCES `mag2_magefan_blog_category` (`category_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_MAGEFAN_BLOG_POST_CTGR_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `mag2_magefan_blog_post` (`post_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Category Linkage Table';

--
-- Dumping data for table `mag2_magefan_blog_post_category`
--


--
-- Table structure for table `mag2_magefan_blog_post_relatedpost`
--

CREATE TABLE `mag2_magefan_blog_post_relatedpost` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `related_id` int(11) NOT NULL COMMENT 'Related Post ID',
  `position` int(11) NOT NULL COMMENT 'Position',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `MAG2_MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `FK_2906B0DF479E9B9D25DF7DCA02B4C0AE` FOREIGN KEY (`post_id`) REFERENCES `mag2_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E1E5399F4A3E80D19DA8443E3C08BCBB` FOREIGN KEY (`post_id`) REFERENCES `mag2_magefan_blog_post` (`post_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Post Linkage Table';

--
-- Dumping data for table `mag2_magefan_blog_post_relatedpost`
--


--
-- Table structure for table `mag2_magefan_blog_post_relatedproduct`
--

CREATE TABLE `mag2_magefan_blog_post_relatedproduct` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `related_id` int(10) unsigned NOT NULL COMMENT 'Related Product ID',
  `position` int(11) NOT NULL COMMENT 'Position',
  PRIMARY KEY (`post_id`,`related_id`),
  KEY `MAG2_MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `FK_61E348A8795E1E8FCC9EAF3A9F54DE3F` FOREIGN KEY (`post_id`) REFERENCES `mag2_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_E3CAE9382C88A95490059243EFE2A31F` FOREIGN KEY (`related_id`) REFERENCES `mag2_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Product Linkage Table';

--
-- Dumping data for table `mag2_magefan_blog_post_relatedproduct`
--


--
-- Table structure for table `mag2_magefan_blog_post_store`
--

CREATE TABLE `mag2_magefan_blog_post_store` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store ID',
  PRIMARY KEY (`post_id`,`store_id`),
  KEY `MAG2_MAGEFAN_BLOG_POST_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_MAGEFAN_BLOG_POST_STORE_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `mag2_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_MAGEFAN_BLOG_POST_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Store Linkage Table';

--
-- Dumping data for table `mag2_magefan_blog_post_store`
--

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

--
-- Table structure for table `mag2_magefan_blog_post_tag`
--

CREATE TABLE `mag2_magefan_blog_post_tag` (
  `post_id` int(11) NOT NULL COMMENT 'Post ID',
  `tag_id` int(11) NOT NULL COMMENT 'Tag ID',
  PRIMARY KEY (`post_id`,`tag_id`),
  KEY `MAG2_MAGEFAN_BLOG_POST_TAG_TAG_ID` (`tag_id`),
  CONSTRAINT `MAG2_MAGEFAN_BLOG_POST_TAG_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `mag2_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_MAGEFAN_BLOG_POST_TAG_TAG_ID_MAGEFAN_BLOG_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `mag2_magefan_blog_tag` (`tag_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Category Linkage Table';

--
-- Dumping data for table `mag2_magefan_blog_post_tag`
--


--
-- Table structure for table `mag2_magefan_blog_tag`
--

CREATE TABLE `mag2_magefan_blog_tag` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tag ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Tag Title',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Description',
  `meta_keywords` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Title',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Tag String Identifier',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Tag Layout',
  `is_active` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Is Tag Active',
  `content` mediumtext COMMENT 'Tag Content',
  `layout_update_xml` text COMMENT 'Tag Layout Update Content',
  `custom_theme` varchar(100) DEFAULT NULL COMMENT 'Tag Custom Theme',
  `custom_layout` varchar(255) DEFAULT NULL COMMENT 'Tag Custom Template',
  `custom_layout_update_xml` text COMMENT 'Tag Custom Layout Update Content',
  `custom_theme_from` date DEFAULT NULL COMMENT 'Tag Custom Theme Active From Date',
  `custom_theme_to` date DEFAULT NULL COMMENT 'Tag Custom Theme Active To Date',
  PRIMARY KEY (`tag_id`),
  KEY `MAG2_MAGEFAN_BLOG_TAG_IDENTIFIER` (`identifier`),
  KEY `MAG2_MAGEFAN_BLOG_TAG_IS_ACTIVE` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Tag Table';

--
-- Dumping data for table `mag2_magefan_blog_tag`
--


--
-- Table structure for table `mag2_mageplaza_bannerslider_banner`
--

CREATE TABLE `mag2_mageplaza_bannerslider_banner` (
  `banner_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Banner ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Banner Name',
  `status` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Banner Status',
  `type` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Banner Type',
  `content` text COMMENT 'Custom html, css',
  `image` varchar(255) DEFAULT NULL COMMENT 'Banner Image',
  `url_banner` varchar(255) DEFAULT NULL COMMENT 'Banner Url',
  `title` varchar(255) DEFAULT NULL COMMENT 'Title',
  `newtab` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Open new tab',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Banner Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Banner Updated At',
  PRIMARY KEY (`banner_id`),
  FULLTEXT KEY `MAG2_MAGEPLAZA_BANNERSLIDER_BANNER_NAME_IMAGE_URL_BANNER` (`name`,`image`,`url_banner`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Banner Table';

--
-- Dumping data for table `mag2_mageplaza_bannerslider_banner`
--

INSERT INTO `mag2_mageplaza_bannerslider_banner` VALUES (1,'Banner 1 ',1,0,NULL,'o/p/optimized-bannar.jpg',NULL,NULL,0,'2021-11-15 06:51:17','2021-11-15 06:51:17'),(2,'Banner 2',1,0,NULL,'b/a/bannar2.jpg',NULL,NULL,0,'2021-11-15 06:51:58','2021-11-15 06:51:58'),(3,'Banner 3 ',1,0,NULL,'n/e/new2.jpg',NULL,NULL,0,'2021-11-15 06:52:29','2021-11-15 06:52:29'),(4,'Banner 4',1,0,NULL,'b/4/b4_1.jpg',NULL,NULL,0,'2021-11-15 06:52:58','2021-11-15 06:52:58');

--
-- Table structure for table `mag2_mageplaza_bannerslider_banner_slider`
--

CREATE TABLE `mag2_mageplaza_bannerslider_banner_slider` (
  `slider_id` int(10) unsigned NOT NULL COMMENT 'Slider ID',
  `banner_id` int(10) unsigned NOT NULL COMMENT 'Banner ID',
  `position` int(11) NOT NULL DEFAULT '0' COMMENT 'Position',
  PRIMARY KEY (`slider_id`,`banner_id`),
  UNIQUE KEY `MAG2_MAGEPLAZA_BANNERSLIDER_BANNER_SLIDER_SLIDER_ID_BANNER_ID` (`slider_id`,`banner_id`),
  KEY `MAG2_MAGEPLAZA_BANNERSLIDER_BANNER_SLIDER_SLIDER_ID` (`slider_id`),
  KEY `MAG2_MAGEPLAZA_BANNERSLIDER_BANNER_SLIDER_BANNER_ID` (`banner_id`),
  CONSTRAINT `FK_08778954C5C20AB8E4699A9E075E303C` FOREIGN KEY (`slider_id`) REFERENCES `mag2_mageplaza_bannerslider_slider` (`slider_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_A4EAAB07FC071C8A3373C171B3C306DD` FOREIGN KEY (`banner_id`) REFERENCES `mag2_mageplaza_bannerslider_banner` (`banner_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Slider To Banner Link Table';

--
-- Dumping data for table `mag2_mageplaza_bannerslider_banner_slider`
--

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

--
-- Table structure for table `mag2_mageplaza_bannerslider_slider`
--

CREATE TABLE `mag2_mageplaza_bannerslider_slider` (
  `slider_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Slider ID',
  `name` varchar(255) DEFAULT NULL COMMENT 'Slider Name',
  `status` smallint(6) NOT NULL DEFAULT '1' COMMENT 'Slider Status',
  `location` text COMMENT 'Location',
  `store_ids` varchar(255) DEFAULT NULL COMMENT 'Store_ids',
  `customer_group_ids` varchar(255) DEFAULT NULL COMMENT 'Customer_group_ids',
  `priority` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Priority',
  `effect` varchar(255) DEFAULT NULL COMMENT 'Animation effect',
  `autoWidth` smallint(6) DEFAULT NULL COMMENT 'Auto Width',
  `autoHeight` smallint(6) DEFAULT NULL COMMENT 'Auto Height',
  `design` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Manually design',
  `loop` smallint(6) DEFAULT NULL COMMENT 'Loop slider',
  `lazyLoad` smallint(6) DEFAULT NULL COMMENT 'Lazyload image',
  `autoplay` smallint(6) DEFAULT NULL COMMENT 'Autoplay',
  `autoplayTimeout` varchar(255) DEFAULT '5000' COMMENT 'autoplay Timeout',
  `nav` smallint(6) DEFAULT NULL COMMENT 'Navigation',
  `dots` smallint(6) DEFAULT NULL COMMENT 'Dots',
  `is_responsive` smallint(6) DEFAULT NULL COMMENT 'Responsive',
  `responsive_items` varchar(255) DEFAULT NULL COMMENT 'Max Items Slider',
  `from_date` date DEFAULT NULL COMMENT 'From',
  `to_date` date DEFAULT NULL COMMENT 'To',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Slider Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Slider Updated At',
  PRIMARY KEY (`slider_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Slider Table';

--
-- Dumping data for table `mag2_mageplaza_bannerslider_slider`
--

INSERT INTO `mag2_mageplaza_bannerslider_slider` VALUES (1,'Home Page Slider',1,'cms_index_index.content-top','0','0,1,2,3',0,'slider',0,0,1,0,0,0,'5000',0,0,0,'[]','2019-03-28',NULL,'2021-11-15 06:48:59','2021-11-15 17:19:57');

--
-- Table structure for table `mag2_mview_state`
--

CREATE TABLE `mag2_mview_state` (
  `state_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'View State Id',
  `view_id` varchar(255) DEFAULT NULL COMMENT 'View Id',
  `mode` varchar(16) DEFAULT 'disabled' COMMENT 'View Mode',
  `status` varchar(16) DEFAULT 'idle' COMMENT 'View Status',
  `updated` datetime DEFAULT NULL COMMENT 'View updated time',
  `version_id` int(10) unsigned DEFAULT NULL COMMENT 'View Version Id',
  PRIMARY KEY (`state_id`),
  KEY `MAG2_MVIEW_STATE_VIEW_ID` (`view_id`),
  KEY `MAG2_MVIEW_STATE_MODE` (`mode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='View State';

--
-- Dumping data for table `mag2_mview_state`
--


--
-- Table structure for table `mag2_newsletter_problem`
--

CREATE TABLE `mag2_newsletter_problem` (
  `problem_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Problem Id',
  `subscriber_id` int(10) unsigned DEFAULT NULL COMMENT 'Subscriber Id',
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Id',
  `problem_error_code` int(10) unsigned DEFAULT '0' COMMENT 'Problem Error Code',
  `problem_error_text` varchar(200) DEFAULT NULL COMMENT 'Problem Error Text',
  PRIMARY KEY (`problem_id`),
  KEY `MAG2_NEWSLETTER_PROBLEM_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `MAG2_NEWSLETTER_PROBLEM_QUEUE_ID` (`queue_id`),
  CONSTRAINT `MAG2_NEWSLETTER_PROBLEM_QUEUE_ID_NEWSLETTER_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `mag2_newsletter_queue` (`queue_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_NLTTR_PROBLEM_SUBSCRIBER_ID_NLTTR_SUBSCRIBER_SUBSCRIBER_ID` FOREIGN KEY (`subscriber_id`) REFERENCES `mag2_newsletter_subscriber` (`subscriber_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Problems';

--
-- Dumping data for table `mag2_newsletter_problem`
--


--
-- Table structure for table `mag2_newsletter_queue`
--

CREATE TABLE `mag2_newsletter_queue` (
  `queue_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue Id',
  `template_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Template ID',
  `newsletter_type` int(11) DEFAULT NULL COMMENT 'Newsletter Type',
  `newsletter_text` text COMMENT 'Newsletter Text',
  `newsletter_styles` text COMMENT 'Newsletter Styles',
  `newsletter_subject` varchar(200) DEFAULT NULL COMMENT 'Newsletter Subject',
  `newsletter_sender_name` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Name',
  `newsletter_sender_email` varchar(200) DEFAULT NULL COMMENT 'Newsletter Sender Email',
  `queue_status` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Status',
  `queue_start_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Start At',
  `queue_finish_at` timestamp NULL DEFAULT NULL COMMENT 'Queue Finish At',
  PRIMARY KEY (`queue_id`),
  KEY `MAG2_NEWSLETTER_QUEUE_TEMPLATE_ID` (`template_id`),
  CONSTRAINT `MAG2_NLTTR_QUEUE_TEMPLATE_ID_NLTTR_TEMPLATE_TEMPLATE_ID` FOREIGN KEY (`template_id`) REFERENCES `mag2_newsletter_template` (`template_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue';

--
-- Dumping data for table `mag2_newsletter_queue`
--


--
-- Table structure for table `mag2_newsletter_queue_link`
--

CREATE TABLE `mag2_newsletter_queue_link` (
  `queue_link_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Queue Link Id',
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Id',
  `subscriber_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Subscriber Id',
  `letter_sent_at` timestamp NULL DEFAULT NULL COMMENT 'Letter Sent At',
  PRIMARY KEY (`queue_link_id`),
  KEY `MAG2_NEWSLETTER_QUEUE_LINK_SUBSCRIBER_ID` (`subscriber_id`),
  KEY `MAG2_NEWSLETTER_QUEUE_LINK_QUEUE_ID_LETTER_SENT_AT` (`queue_id`,`letter_sent_at`),
  CONSTRAINT `FK_20FD832E959A0AB5964BCC29DC2535C4` FOREIGN KEY (`subscriber_id`) REFERENCES `mag2_newsletter_subscriber` (`subscriber_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_NEWSLETTER_QUEUE_LINK_QUEUE_ID_NEWSLETTER_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `mag2_newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Link';

--
-- Dumping data for table `mag2_newsletter_queue_link`
--


--
-- Table structure for table `mag2_newsletter_queue_store_link`
--

CREATE TABLE `mag2_newsletter_queue_store_link` (
  `queue_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Queue Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  PRIMARY KEY (`queue_id`,`store_id`),
  KEY `MAG2_NEWSLETTER_QUEUE_STORE_LINK_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_NEWSLETTER_QUEUE_STORE_LINK_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_NLTTR_QUEUE_STORE_LNK_QUEUE_ID_NLTTR_QUEUE_QUEUE_ID` FOREIGN KEY (`queue_id`) REFERENCES `mag2_newsletter_queue` (`queue_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Queue Store Link';

--
-- Dumping data for table `mag2_newsletter_queue_store_link`
--


--
-- Table structure for table `mag2_newsletter_subscriber`
--

CREATE TABLE `mag2_newsletter_subscriber` (
  `subscriber_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Subscriber Id',
  `store_id` smallint(5) unsigned DEFAULT '0' COMMENT 'Store Id',
  `change_status_at` timestamp NULL DEFAULT NULL COMMENT 'Change Status At',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Id',
  `subscriber_email` varchar(150) DEFAULT NULL COMMENT 'Subscriber Email',
  `subscriber_status` int(11) NOT NULL DEFAULT '0' COMMENT 'Subscriber Status',
  `subscriber_confirm_code` varchar(32) DEFAULT 'NULL' COMMENT 'Subscriber Confirm Code',
  PRIMARY KEY (`subscriber_id`),
  KEY `MAG2_NEWSLETTER_SUBSCRIBER_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_NEWSLETTER_SUBSCRIBER_STORE_ID` (`store_id`),
  KEY `MAG2_NEWSLETTER_SUBSCRIBER_SUBSCRIBER_EMAIL` (`subscriber_email`),
  CONSTRAINT `MAG2_NEWSLETTER_SUBSCRIBER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Subscriber';

--
-- Dumping data for table `mag2_newsletter_subscriber`
--


--
-- Table structure for table `mag2_newsletter_template`
--

CREATE TABLE `mag2_newsletter_template` (
  `template_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Template ID',
  `template_code` varchar(150) DEFAULT NULL COMMENT 'Template Code',
  `template_text` text COMMENT 'Template Text',
  `template_styles` text COMMENT 'Template Styles',
  `template_type` int(10) unsigned DEFAULT NULL COMMENT 'Template Type',
  `template_subject` varchar(200) DEFAULT NULL COMMENT 'Template Subject',
  `template_sender_name` varchar(200) DEFAULT NULL COMMENT 'Template Sender Name',
  `template_sender_email` varchar(200) DEFAULT NULL COMMENT 'Template Sender Email',
  `template_actual` smallint(5) unsigned DEFAULT '1' COMMENT 'Template Actual',
  `added_at` timestamp NULL DEFAULT NULL COMMENT 'Added At',
  `modified_at` timestamp NULL DEFAULT NULL COMMENT 'Modified At',
  PRIMARY KEY (`template_id`),
  KEY `MAG2_NEWSLETTER_TEMPLATE_TEMPLATE_ACTUAL` (`template_actual`),
  KEY `MAG2_NEWSLETTER_TEMPLATE_ADDED_AT` (`added_at`),
  KEY `MAG2_NEWSLETTER_TEMPLATE_MODIFIED_AT` (`modified_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Newsletter Template';

--
-- Dumping data for table `mag2_newsletter_template`
--


--
-- Table structure for table `mag2_oauth_consumer`
--

CREATE TABLE `mag2_oauth_consumer` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT '0000-00-00 00:00:00' ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  `name` varchar(255) NOT NULL COMMENT 'Name of consumer',
  `key` varchar(32) NOT NULL COMMENT 'Key code',
  `secret` varchar(32) NOT NULL COMMENT 'Secret code',
  `callback_url` text COMMENT 'Callback URL',
  `rejected_callback_url` text NOT NULL COMMENT 'Rejected callback URL',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `MAG2_OAUTH_CONSUMER_KEY` (`key`),
  UNIQUE KEY `MAG2_OAUTH_CONSUMER_SECRET` (`secret`),
  KEY `MAG2_OAUTH_CONSUMER_CREATED_AT` (`created_at`),
  KEY `MAG2_OAUTH_CONSUMER_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COMMENT='OAuth Consumers';

--
-- Dumping data for table `mag2_oauth_consumer`
--

INSERT INTO `mag2_oauth_consumer` VALUES (1,'2021-11-10 08:14:32','0000-00-00 00:00:00','Integration1','wl1bvhmo3wwk63ritn35skbu84jha0ao','fw6s7qjifwdxms69qh9t224anf6ownu2',NULL,''),(2,'2021-11-10 08:23:45','0000-00-00 00:00:00','Integration2','7xjfcjcs7k4iyw721dvu7dlvgh62fgsh','wdsp0gigneebux9npcmnn435jq831q8i',NULL,''),(3,'2021-11-10 11:39:53','0000-00-00 00:00:00','Integration3','l8yqh5m5o6utrywji96n4gqkrmommw57','8gc3lvh1lnw3uvddhyvmuahqtywkmd9p',NULL,''),(4,'2021-11-15 06:14:17','0000-00-00 00:00:00','Integration4','pf3g8116xgui3cunayrsigv0thdtfdii','d088pn6bq2y5axr9gu62jsm837xj8u33',NULL,''),(5,'2021-11-15 06:27:44','0000-00-00 00:00:00','Integration5','dr1aqj9oly27g65tp8m7ffsakyoe4212','d0fyd70ghexdua0cag8et0v2eb4v44n2',NULL,''),(6,'2021-11-15 07:43:28','0000-00-00 00:00:00','Integration6','18hhsopbtheigx3cjccd6f1hs37ivp0u','v1gign9i5kff87wvp2gve7ehd7ksrdp0',NULL,''),(7,'2021-11-15 08:02:21','0000-00-00 00:00:00','Integration7','vwg6hnmxlb4ln3d1l8x9wyrf4hqfcn40','lkoepth31uryn46xyi184nwd2y13wu8q',NULL,''),(8,'2021-11-17 07:50:39','0000-00-00 00:00:00','Integration8','sli9sp2jj6k3540tlhcx3t8fju36b1rg','7i2b8isb51msqb2jtmgj4omj8pic1bit',NULL,''),(9,'2021-11-17 09:10:05','0000-00-00 00:00:00','Integration9','4ip3la94ewtlvipnwd6eyken9l0c7vro','fdn0xqocgwas5t4u5oh6j16vtc1td1ks',NULL,''),(10,'2021-11-17 09:13:24','0000-00-00 00:00:00','Integration10','5pi57qe599pkq69wsjebw5ou08nelb3d','oyo0fme5un8uhr2geo3e33em1mv3ofc8',NULL,''),(11,'2021-11-17 09:38:37','0000-00-00 00:00:00','Integration11','tpxhvwtu0g6farrh74t6ok8v632l3b48','mydtk8iyo280a0n6tr45pfdsno0j4m6d',NULL,''),(12,'2021-11-17 09:40:31','0000-00-00 00:00:00','Integration12','kfpvsp1tsjnj22agg4w7g9jq2b1ms045','4kunj42mnanc7l8o4gpkjb2qec5vpc66',NULL,''),(13,'2021-11-17 09:46:43','0000-00-00 00:00:00','Integration13','l191ahuix1nufdmgpc6xc7aswjrrn5j1','50qsqdftpe5umc7a9ap13w0y87w4vt7d',NULL,'');

--
-- Table structure for table `mag2_oauth_nonce`
--

CREATE TABLE `mag2_oauth_nonce` (
  `nonce` varchar(32) NOT NULL COMMENT 'Nonce String',
  `timestamp` int(10) unsigned NOT NULL COMMENT 'Nonce Timestamp',
  `consumer_id` int(10) unsigned NOT NULL COMMENT 'Consumer ID',
  UNIQUE KEY `MAG2_OAUTH_NONCE_NONCE_CONSUMER_ID` (`nonce`,`consumer_id`),
  KEY `MAG2_OAUTH_NONCE_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` (`consumer_id`),
  CONSTRAINT `MAG2_OAUTH_NONCE_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `mag2_oauth_consumer` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Nonce';

--
-- Dumping data for table `mag2_oauth_nonce`
--


--
-- Table structure for table `mag2_oauth_token`
--

CREATE TABLE `mag2_oauth_token` (
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `consumer_id` int(10) unsigned DEFAULT NULL COMMENT 'Oauth Consumer ID',
  `admin_id` int(10) unsigned DEFAULT NULL COMMENT 'Admin user ID',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer user ID',
  `type` varchar(16) NOT NULL COMMENT 'Token Type',
  `token` varchar(32) NOT NULL COMMENT 'Token',
  `secret` varchar(32) NOT NULL COMMENT 'Token Secret',
  `verifier` varchar(32) DEFAULT NULL COMMENT 'Token Verifier',
  `callback_url` text NOT NULL COMMENT 'Token Callback URL',
  `revoked` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token revoked',
  `authorized` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Token authorized',
  `user_type` int(11) DEFAULT NULL COMMENT 'User type',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Token creation timestamp',
  PRIMARY KEY (`entity_id`),
  UNIQUE KEY `MAG2_OAUTH_TOKEN_TOKEN` (`token`),
  KEY `MAG2_OAUTH_TOKEN_CONSUMER_ID` (`consumer_id`),
  KEY `MAG2_OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` (`admin_id`),
  KEY `MAG2_OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` (`customer_id`),
  CONSTRAINT `MAG2_OAUTH_TOKEN_ADMIN_ID_ADMIN_USER_USER_ID` FOREIGN KEY (`admin_id`) REFERENCES `mag2_admin_user` (`user_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_OAUTH_TOKEN_CONSUMER_ID_OAUTH_CONSUMER_ENTITY_ID` FOREIGN KEY (`consumer_id`) REFERENCES `mag2_oauth_consumer` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_OAUTH_TOKEN_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='OAuth Tokens';

--
-- Dumping data for table `mag2_oauth_token`
--


--
-- Table structure for table `mag2_oauth_token_request_log`
--

CREATE TABLE `mag2_oauth_token_request_log` (
  `log_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Log Id',
  `user_name` varchar(255) NOT NULL COMMENT 'Customer email or admin login',
  `user_type` smallint(5) unsigned NOT NULL COMMENT 'User type (admin or customer)',
  `failures_count` smallint(5) unsigned DEFAULT '0' COMMENT 'Number of failed authentication attempts in a row',
  `lock_expires_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Lock expiration time',
  PRIMARY KEY (`log_id`),
  UNIQUE KEY `MAG2_OAUTH_TOKEN_REQUEST_LOG_USER_NAME_USER_TYPE` (`user_name`,`user_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Log of token request authentication failures.';

--
-- Dumping data for table `mag2_oauth_token_request_log`
--


--
-- Table structure for table `mag2_password_reset_request_event`
--

CREATE TABLE `mag2_password_reset_request_event` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity ID',
  `request_type` smallint(5) unsigned NOT NULL COMMENT 'Type of the event under a security control',
  `account_reference` varchar(255) DEFAULT NULL COMMENT 'An identifier for existing account or another target',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Timestamp when the event occurs',
  `ip` varchar(15) NOT NULL COMMENT 'Remote user IP',
  PRIMARY KEY (`id`),
  KEY `MAG2_PASSWORD_RESET_REQUEST_EVENT_ACCOUNT_REFERENCE` (`account_reference`),
  KEY `MAG2_PASSWORD_RESET_REQUEST_EVENT_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Password Reset Request Event under a security control';

--
-- Dumping data for table `mag2_password_reset_request_event`
--


--
-- Table structure for table `mag2_paypal_billing_agreement`
--

CREATE TABLE `mag2_paypal_billing_agreement` (
  `agreement_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Agreement Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer Id',
  `method_code` varchar(32) NOT NULL COMMENT 'Method Code',
  `reference_id` varchar(32) NOT NULL COMMENT 'Reference Id',
  `status` varchar(20) NOT NULL COMMENT 'Status',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `store_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Store Id',
  `agreement_label` varchar(255) DEFAULT NULL COMMENT 'Agreement Label',
  PRIMARY KEY (`agreement_id`),
  KEY `MAG2_PAYPAL_BILLING_AGREEMENT_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_PAYPAL_BILLING_AGREEMENT_STORE_ID` (`store_id`),
  CONSTRAINT `MAG2_PAYPAL_BILLING_AGREEMENT_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `mag2_store` (`store_id`) ON DELETE SET NULL,
  CONSTRAINT `MAG2_PAYPAL_BILLING_AGRT_CSTR_ID_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement';

--
-- Dumping data for table `mag2_paypal_billing_agreement`
--


--
-- Table structure for table `mag2_paypal_billing_agreement_order`
--

CREATE TABLE `mag2_paypal_billing_agreement_order` (
  `agreement_id` int(10) unsigned NOT NULL COMMENT 'Agreement Id',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order Id',
  PRIMARY KEY (`agreement_id`,`order_id`),
  KEY `MAG2_PAYPAL_BILLING_AGREEMENT_ORDER_ORDER_ID` (`order_id`),
  CONSTRAINT `FK_31974B9CA6B65D5279CFA17F90D0DD5B` FOREIGN KEY (`agreement_id`) REFERENCES `mag2_paypal_billing_agreement` (`agreement_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_PAYPAL_BILLING_AGRT_ORDER_ORDER_ID_SALES_ORDER_ENTT_ID` FOREIGN KEY (`order_id`) REFERENCES `mag2_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Sales Billing Agreement Order';

--
-- Dumping data for table `mag2_paypal_billing_agreement_order`
--


--
-- Table structure for table `mag2_paypal_cert`
--

CREATE TABLE `mag2_paypal_cert` (
  `cert_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Cert Id',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website Id',
  `content` text COMMENT 'Content',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  PRIMARY KEY (`cert_id`),
  KEY `MAG2_PAYPAL_CERT_WEBSITE_ID` (`website_id`),
  CONSTRAINT `MAG2_PAYPAL_CERT_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='Paypal Certificate Table';

--
-- Dumping data for table `mag2_paypal_cert`
--


--
-- Table structure for table `mag2_paypal_payment_transaction`
--

CREATE TABLE `mag2_paypal_payment_transaction` (
  `transaction_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Entity Id',
  `txn_id` varchar(100) DEFAULT NULL COMMENT 'Txn Id',
  `additional_information` blob COMMENT 'Additional Information',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Created At',
  PRIMARY KEY (`transaction_id`),
  UNIQUE KEY `MAG2_PAYPAL_PAYMENT_TRANSACTION_TXN_ID` (`txn_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='PayPal Payflow Link Payment Transaction';

--
-- Dumping data for table `mag2_paypal_payment_transaction`
--


--
-- Table structure for table `mag2_paypal_settlement_report`
--

CREATE TABLE `mag2_paypal_settlement_report` (
  `report_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Report Id',
  `report_date` date DEFAULT NULL COMMENT 'Report Date',
  `account_id` varchar(64) DEFAULT NULL COMMENT 'Account Id',
  `filename` varchar(24) DEFAULT NULL COMMENT 'Filename',
  `last_modified` timestamp NULL DEFAULT NULL COMMENT 'Last Modified',
  PRIMARY KEY (`report_id`),
  UNIQUE KEY `MAG2_PAYPAL_SETTLEMENT_REPORT_REPORT_DATE_ACCOUNT_ID` (`report_date`,`account_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Table';

--
-- Dumping data for table `mag2_paypal_settlement_report`
--


--
-- Table structure for table `mag2_paypal_settlement_report_row`
--

CREATE TABLE `mag2_paypal_settlement_report_row` (
  `row_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Row Id',
  `report_id` int(10) unsigned NOT NULL COMMENT 'Report Id',
  `transaction_id` varchar(19) DEFAULT NULL COMMENT 'Transaction Id',
  `invoice_id` varchar(127) DEFAULT NULL COMMENT 'Invoice Id',
  `paypal_reference_id` varchar(19) DEFAULT NULL COMMENT 'Paypal Reference Id',
  `paypal_reference_id_type` varchar(3) DEFAULT NULL COMMENT 'Paypal Reference Id Type',
  `transaction_event_code` varchar(5) DEFAULT NULL COMMENT 'Transaction Event Code',
  `transaction_initiation_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Initiation Date',
  `transaction_completion_date` timestamp NULL DEFAULT NULL COMMENT 'Transaction Completion Date',
  `transaction_debit_or_credit` varchar(2) NOT NULL DEFAULT 'CR' COMMENT 'Transaction Debit Or Credit',
  `gross_transaction_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Gross Transaction Amount',
  `gross_transaction_currency` varchar(3) DEFAULT NULL COMMENT 'Gross Transaction Currency',
  `fee_debit_or_credit` varchar(2) DEFAULT NULL COMMENT 'Fee Debit Or Credit',
  `fee_amount` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Fee Amount',
  `fee_currency` varchar(3) DEFAULT NULL COMMENT 'Fee Currency',
  `custom_field` varchar(255) DEFAULT NULL COMMENT 'Custom Field',
  `consumer_id` varchar(127) DEFAULT NULL COMMENT 'Consumer Id',
  `payment_tracking_id` varchar(255) DEFAULT NULL COMMENT 'Payment Tracking ID',
  `store_id` varchar(50) DEFAULT NULL COMMENT 'Store ID',
  PRIMARY KEY (`row_id`),
  KEY `MAG2_PAYPAL_SETTLEMENT_REPORT_ROW_REPORT_ID` (`report_id`),
  CONSTRAINT `FK_3DCE2E83B5C66E0DAE31891D4E4EC770` FOREIGN KEY (`report_id`) REFERENCES `mag2_paypal_settlement_report` (`report_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Paypal Settlement Report Row Table';

--
-- Dumping data for table `mag2_paypal_settlement_report_row`
--


--
-- Table structure for table `mag2_persistent_session`
--

CREATE TABLE `mag2_persistent_session` (
  `persistent_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Session id',
  `key` varchar(50) NOT NULL COMMENT 'Unique cookie key',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer id',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `info` text COMMENT 'Session Data',
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated At',
  PRIMARY KEY (`persistent_id`),
  UNIQUE KEY `MAG2_PERSISTENT_SESSION_KEY` (`key`),
  UNIQUE KEY `MAG2_PERSISTENT_SESSION_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_PERSISTENT_SESSION_UPDATED_AT` (`updated_at`),
  KEY `MAG2_PERSISTENT_SESSION_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `MAG2_PERSISTENT_SESSION_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_PERSISTENT_SESSION_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='Persistent Session';

--
-- Dumping data for table `mag2_persistent_session`
--


--
-- Table structure for table `mag2_product_alert_price`
--

CREATE TABLE `mag2_product_alert_price` (
  `alert_price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert price id',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
  `price` decimal(12,4) NOT NULL DEFAULT '0.0000' COMMENT 'Price amount',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website id',
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Product alert add date',
  `last_send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert last send date',
  `send_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert send count',
  `status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  PRIMARY KEY (`alert_price_id`),
  KEY `MAG2_PRODUCT_ALERT_PRICE_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_PRODUCT_ALERT_PRICE_PRODUCT_ID` (`product_id`),
  KEY `MAG2_PRODUCT_ALERT_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `MAG2_PRD_ALERT_PRICE_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `mag2_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_PRODUCT_ALERT_PRICE_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_PRODUCT_ALERT_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='Product Alert Price';

--
-- Dumping data for table `mag2_product_alert_price`
--


--
-- Table structure for table `mag2_product_alert_stock`
--

CREATE TABLE `mag2_product_alert_stock` (
  `alert_stock_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Product alert stock id',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer id',
  `product_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Product id',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website id',
  `add_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Product alert add date',
  `send_date` timestamp NULL DEFAULT NULL COMMENT 'Product alert send date',
  `send_count` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Send Count',
  `status` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Product alert status',
  PRIMARY KEY (`alert_stock_id`),
  KEY `MAG2_PRODUCT_ALERT_STOCK_CUSTOMER_ID` (`customer_id`),
  KEY `MAG2_PRODUCT_ALERT_STOCK_PRODUCT_ID` (`product_id`),
  KEY `MAG2_PRODUCT_ALERT_STOCK_WEBSITE_ID` (`website_id`),
  CONSTRAINT `MAG2_PRD_ALERT_STOCK_PRD_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `mag2_catalog_product_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_PRODUCT_ALERT_STOCK_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `mag2_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `MAG2_PRODUCT_ALERT_STOCK_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='Product Alert Stock';

--
