-- Table structure for table `wal_directory_country_region_name`
--

CREATE TABLE `wal_directory_country_region_name` (
  `locale` varchar(16) 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 `WAL_DIRECTORY_COUNTRY_REGION_NAME_REGION_ID` (`region_id`),
  CONSTRAINT `FK_D2AF67CB8B391ECA84D23DE10076B829` FOREIGN KEY (`region_id`) REFERENCES `wal_directory_country_region` (`region_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Country Region Name';

--
-- Dumping data for table `wal_directory_country_region_name`
--

INSERT INTO `wal_directory_country_region_name` VALUES ('en_US',1,'Alabama'),('en_US',2,'Alaska'),('en_US',3,'American Samoa'),('en_US',4,'Arizona'),('en_US',5,'Arkansas'),('en_US',6,'Armed Forces Africa'),('en_US',7,'Armed Forces Americas'),('en_US',8,'Armed Forces Canada'),('en_US',9,'Armed Forces Europe'),('en_US',10,'Armed Forces Middle East'),('en_US',11,'Armed Forces Pacific'),('en_US',12,'California'),('en_US',13,'Colorado'),('en_US',14,'Connecticut'),('en_US',15,'Delaware'),('en_US',16,'District of Columbia'),('en_US',17,'Federated States Of Micronesia'),('en_US',18,'Florida'),('en_US',19,'Georgia'),('en_US',20,'Guam'),('en_US',21,'Hawaii'),('en_US',22,'Idaho'),('en_US',23,'Illinois'),('en_US',24,'Indiana'),('en_US',25,'Iowa'),('en_US',26,'Kansas'),('en_US',27,'Kentucky'),('en_US',28,'Louisiana'),('en_US',29,'Maine'),('en_US',30,'Marshall Islands'),('en_US',31,'Maryland'),('en_US',32,'Massachusetts'),('en_US',33,'Michigan'),('en_US',34,'Minnesota'),('en_US',35,'Mississippi'),('en_US',36,'Missouri'),('en_US',37,'Montana'),('en_US',38,'Nebraska'),('en_US',39,'Nevada'),('en_US',40,'New Hampshire'),('en_US',41,'New Jersey'),('en_US',42,'New Mexico'),('en_US',43,'New York'),('en_US',44,'North Carolina'),('en_US',45,'North Dakota'),('en_US',46,'Northern Mariana Islands'),('en_US',47,'Ohio'),('en_US',48,'Oklahoma'),('en_US',49,'Oregon'),('en_US',50,'Palau'),('en_US',51,'Pennsylvania'),('en_US',52,'Puerto Rico'),('en_US',53,'Rhode Island'),('en_US',54,'South Carolina'),('en_US',55,'South Dakota'),('en_US',56,'Tennessee'),('en_US',57,'Texas'),('en_US',58,'Utah'),('en_US',59,'Vermont'),('en_US',60,'Virgin Islands'),('en_US',61,'Virginia'),('en_US',62,'Washington'),('en_US',63,'West Virginia'),('en_US',64,'Wisconsin'),('en_US',65,'Wyoming'),('en_US',66,'Alberta'),('en_US',67,'British Columbia'),('en_US',68,'Manitoba'),('en_US',69,'Newfoundland and Labrador'),('en_US',70,'New Brunswick'),('en_US',71,'Nova Scotia'),('en_US',72,'Northwest Territories'),('en_US',73,'Nunavut'),('en_US',74,'Ontario'),('en_US',75,'Prince Edward Island'),('en_US',76,'Quebec'),('en_US',77,'Saskatchewan'),('en_US',78,'Yukon Territory'),('en_US',79,'Niedersachsen'),('en_US',80,'Baden-Württemberg'),('en_US',81,'Bayern'),('en_US',82,'Berlin'),('en_US',83,'Brandenburg'),('en_US',84,'Bremen'),('en_US',85,'Hamburg'),('en_US',86,'Hessen'),('en_US',87,'Mecklenburg-Vorpommern'),('en_US',88,'Nordrhein-Westfalen'),('en_US',89,'Rheinland-Pfalz'),('en_US',90,'Saarland'),('en_US',91,'Sachsen'),('en_US',92,'Sachsen-Anhalt'),('en_US',93,'Schleswig-Holstein'),('en_US',94,'Thüringen'),('en_US',95,'Wien'),('en_US',96,'Niederösterreich'),('en_US',97,'Oberösterreich'),('en_US',98,'Salzburg'),('en_US',99,'Kärnten'),('en_US',100,'Steiermark'),('en_US',101,'Tirol'),('en_US',102,'Burgenland'),('en_US',103,'Vorarlberg'),('en_US',104,'Aargau'),('en_US',105,'Appenzell Innerrhoden'),('en_US',106,'Appenzell Ausserrhoden'),('en_US',107,'Bern'),('en_US',108,'Basel-Landschaft'),('en_US',109,'Basel-Stadt'),('en_US',110,'Freiburg'),('en_US',111,'Genf'),('en_US',112,'Glarus'),('en_US',113,'Graubünden'),('en_US',114,'Jura'),('en_US',115,'Luzern'),('en_US',116,'Neuenburg'),('en_US',117,'Nidwalden'),('en_US',118,'Obwalden'),('en_US',119,'St. Gallen'),('en_US',120,'Schaffhausen'),('en_US',121,'Solothurn'),('en_US',122,'Schwyz'),('en_US',123,'Thurgau'),('en_US',124,'Tessin'),('en_US',125,'Uri'),('en_US',126,'Waadt'),('en_US',127,'Wallis'),('en_US',128,'Zug'),('en_US',129,'Zürich'),('en_US',130,'A Coruña'),('en_US',131,'Alava'),('en_US',132,'Albacete'),('en_US',133,'Alicante'),('en_US',134,'Almeria'),('en_US',135,'Asturias'),('en_US',136,'Avila'),('en_US',137,'Badajoz'),('en_US',138,'Baleares'),('en_US',139,'Barcelona'),('en_US',140,'Burgos'),('en_US',141,'Caceres'),('en_US',142,'Cadiz'),('en_US',143,'Cantabria'),('en_US',144,'Castellon'),('en_US',145,'Ceuta'),('en_US',146,'Ciudad Real'),('en_US',147,'Cordoba'),('en_US',148,'Cuenca'),('en_US',149,'Girona'),('en_US',150,'Granada'),('en_US',151,'Guadalajara'),('en_US',152,'Guipuzcoa'),('en_US',153,'Huelva'),('en_US',154,'Huesca'),('en_US',155,'Jaen'),('en_US',156,'La Rioja'),('en_US',157,'Las Palmas'),('en_US',158,'Leon'),('en_US',159,'Lleida'),('en_US',160,'Lugo'),('en_US',161,'Madrid'),('en_US',162,'Malaga'),('en_US',163,'Melilla'),('en_US',164,'Murcia'),('en_US',165,'Navarra'),('en_US',166,'Ourense'),('en_US',167,'Palencia'),('en_US',168,'Pontevedra'),('en_US',169,'Salamanca'),('en_US',170,'Santa Cruz de Tenerife'),('en_US',171,'Segovia'),('en_US',172,'Sevilla'),('en_US',173,'Soria'),('en_US',174,'Tarragona'),('en_US',175,'Teruel'),('en_US',176,'Toledo'),('en_US',177,'Valencia'),('en_US',178,'Valladolid'),('en_US',179,'Vizcaya'),('en_US',180,'Zamora'),('en_US',181,'Zaragoza'),('en_US',182,'Ain'),('en_US',183,'Aisne'),('en_US',184,'Allier'),('en_US',185,'Alpes-de-Haute-Provence'),('en_US',186,'Hautes-Alpes'),('en_US',187,'Alpes-Maritimes'),('en_US',188,'Ardèche'),('en_US',189,'Ardennes'),('en_US',190,'Ariège'),('en_US',191,'Aube'),('en_US',192,'Aude'),('en_US',193,'Aveyron'),('en_US',194,'Bouches-du-Rhône'),('en_US',195,'Calvados'),('en_US',196,'Cantal'),('en_US',197,'Charente'),('en_US',198,'Charente-Maritime'),('en_US',199,'Cher'),('en_US',200,'Corrèze'),('en_US',201,'Corse-du-Sud'),('en_US',202,'Haute-Corse'),('en_US',203,'Côte-d\'Or'),('en_US',204,'Côtes-d\'Armor'),('en_US',205,'Creuse'),('en_US',206,'Dordogne'),('en_US',207,'Doubs'),('en_US',208,'Drôme'),('en_US',209,'Eure'),('en_US',210,'Eure-et-Loir'),('en_US',211,'Finistère'),('en_US',212,'Gard'),('en_US',213,'Haute-Garonne'),('en_US',214,'Gers'),('en_US',215,'Gironde'),('en_US',216,'Hérault'),('en_US',217,'Ille-et-Vilaine'),('en_US',218,'Indre'),('en_US',219,'Indre-et-Loire'),('en_US',220,'Isère'),('en_US',221,'Jura'),('en_US',222,'Landes'),('en_US',223,'Loir-et-Cher'),('en_US',224,'Loire'),('en_US',225,'Haute-Loire'),('en_US',226,'Loire-Atlantique'),('en_US',227,'Loiret'),('en_US',228,'Lot'),('en_US',229,'Lot-et-Garonne'),('en_US',230,'Lozère'),('en_US',231,'Maine-et-Loire'),('en_US',232,'Manche'),('en_US',233,'Marne'),('en_US',234,'Haute-Marne'),('en_US',235,'Mayenne'),('en_US',236,'Meurthe-et-Moselle'),('en_US',237,'Meuse'),('en_US',238,'Morbihan'),('en_US',239,'Moselle'),('en_US',240,'Nièvre'),('en_US',241,'Nord'),('en_US',242,'Oise'),('en_US',243,'Orne'),('en_US',244,'Pas-de-Calais'),('en_US',245,'Puy-de-Dôme'),('en_US',246,'Pyrénées-Atlantiques'),('en_US',247,'Hautes-Pyrénées'),('en_US',248,'Pyrénées-Orientales'),('en_US',249,'Bas-Rhin'),('en_US',250,'Haut-Rhin'),('en_US',251,'Rhône'),('en_US',252,'Haute-Saône'),('en_US',253,'Saône-et-Loire'),('en_US',254,'Sarthe'),('en_US',255,'Savoie'),('en_US',256,'Haute-Savoie'),('en_US',257,'Paris'),('en_US',258,'Seine-Maritime'),('en_US',259,'Seine-et-Marne'),('en_US',260,'Yvelines'),('en_US',261,'Deux-Sèvres'),('en_US',262,'Somme'),('en_US',263,'Tarn'),('en_US',264,'Tarn-et-Garonne'),('en_US',265,'Var'),('en_US',266,'Vaucluse'),('en_US',267,'Vendée'),('en_US',268,'Vienne'),('en_US',269,'Haute-Vienne'),('en_US',270,'Vosges'),('en_US',271,'Yonne'),('en_US',272,'Territoire-de-Belfort'),('en_US',273,'Essonne'),('en_US',274,'Hauts-de-Seine'),('en_US',275,'Seine-Saint-Denis'),('en_US',276,'Val-de-Marne'),('en_US',277,'Val-d\'Oise'),('en_US',278,'Alba'),('en_US',279,'Arad'),('en_US',280,'Argeş'),('en_US',281,'Bacău'),('en_US',282,'Bihor'),('en_US',283,'Bistriţa-Năsăud'),('en_US',284,'Botoşani'),('en_US',285,'Braşov'),('en_US',286,'Brăila'),('en_US',287,'Bucureşti'),('en_US',288,'Buzău'),('en_US',289,'Caraş-Severin'),('en_US',290,'Călăraşi'),('en_US',291,'Cluj'),('en_US',292,'Constanţa'),('en_US',293,'Covasna'),('en_US',294,'Dâmboviţa'),('en_US',295,'Dolj'),('en_US',296,'Galaţi'),('en_US',297,'Giurgiu'),('en_US',298,'Gorj'),('en_US',299,'Harghita'),('en_US',300,'Hunedoara'),('en_US',301,'Ialomiţa'),('en_US',302,'Iaşi'),('en_US',303,'Ilfov'),('en_US',304,'Maramureş'),('en_US',305,'Mehedinţi'),('en_US',306,'Mureş'),('en_US',307,'Neamţ'),('en_US',308,'Olt'),('en_US',309,'Prahova'),('en_US',310,'Satu-Mare'),('en_US',311,'Sălaj'),('en_US',312,'Sibiu'),('en_US',313,'Suceava'),('en_US',314,'Teleorman'),('en_US',315,'Timiş'),('en_US',316,'Tulcea'),('en_US',317,'Vaslui'),('en_US',318,'Vâlcea'),('en_US',319,'Vrancea'),('en_US',320,'Lappi'),('en_US',321,'Pohjois-Pohjanmaa'),('en_US',322,'Kainuu'),('en_US',323,'Pohjois-Karjala'),('en_US',324,'Pohjois-Savo'),('en_US',325,'Etelä-Savo'),('en_US',326,'Etelä-Pohjanmaa'),('en_US',327,'Pohjanmaa'),('en_US',328,'Pirkanmaa'),('en_US',329,'Satakunta'),('en_US',330,'Keski-Pohjanmaa'),('en_US',331,'Keski-Suomi'),('en_US',332,'Varsinais-Suomi'),('en_US',333,'Etelä-Karjala'),('en_US',334,'Päijät-Häme'),('en_US',335,'Kanta-Häme'),('en_US',336,'Uusimaa'),('en_US',337,'Itä-Uusimaa'),('en_US',338,'Kymenlaakso'),('en_US',339,'Ahvenanmaa'),('en_US',340,'Harjumaa'),('en_US',341,'Hiiumaa'),('en_US',342,'Ida-Virumaa'),('en_US',343,'Jõgevamaa'),('en_US',344,'Järvamaa'),('en_US',345,'Läänemaa'),('en_US',346,'Lääne-Virumaa'),('en_US',347,'Põlvamaa'),('en_US',348,'Pärnumaa'),('en_US',349,'Raplamaa'),('en_US',350,'Saaremaa'),('en_US',351,'Tartumaa'),('en_US',352,'Valgamaa'),('en_US',353,'Viljandimaa'),('en_US',354,'Võrumaa'),('en_US',355,'Daugavpils'),('en_US',356,'Jelgava'),('en_US',357,'Jēkabpils'),('en_US',358,'Jūrmala'),('en_US',359,'Liepāja'),('en_US',360,'Liepājas novads'),('en_US',361,'Rēzekne'),('en_US',362,'Rīga'),('en_US',363,'Rīgas novads'),('en_US',364,'Valmiera'),('en_US',365,'Ventspils'),('en_US',366,'Aglonas novads'),('en_US',367,'Aizkraukles novads'),('en_US',368,'Aizputes novads'),('en_US',369,'Aknīstes novads'),('en_US',370,'Alojas novads'),('en_US',371,'Alsungas novads'),('en_US',372,'Alūksnes novads'),('en_US',373,'Amatas novads'),('en_US',374,'Apes novads'),('en_US',375,'Auces novads'),('en_US',376,'Babītes novads'),('en_US',377,'Baldones novads'),('en_US',378,'Baltinavas novads'),('en_US',379,'Balvu novads'),('en_US',380,'Bauskas novads'),('en_US',381,'Beverīnas novads'),('en_US',382,'Brocēnu novads'),('en_US',383,'Burtnieku novads'),('en_US',384,'Carnikavas novads'),('en_US',385,'Cesvaines novads'),('en_US',386,'Ciblas novads'),('en_US',387,'Cēsu novads'),('en_US',388,'Dagdas novads'),('en_US',389,'Daugavpils novads'),('en_US',390,'Dobeles novads'),('en_US',391,'Dundagas novads'),('en_US',392,'Durbes novads'),('en_US',393,'Engures novads'),('en_US',394,'Garkalnes novads'),('en_US',395,'Grobiņas novads'),('en_US',396,'Gulbenes novads'),('en_US',397,'Iecavas novads'),('en_US',398,'Ikšķiles novads'),('en_US',399,'Ilūkstes novads'),('en_US',400,'Inčukalna novads'),('en_US',401,'Jaunjelgavas novads'),('en_US',402,'Jaunpiebalgas novads'),('en_US',403,'Jaunpils novads'),('en_US',404,'Jelgavas novads'),('en_US',405,'Jēkabpils novads'),('en_US',406,'Kandavas novads'),('en_US',407,'Kokneses novads'),('en_US',408,'Krimuldas novads'),('en_US',409,'Krustpils novads'),('en_US',410,'Krāslavas novads'),('en_US',411,'Kuldīgas novads'),('en_US',412,'Kārsavas novads'),('en_US',413,'Lielvārdes novads'),('en_US',414,'Limbažu novads'),('en_US',415,'Lubānas novads'),('en_US',416,'Ludzas novads'),('en_US',417,'Līgatnes novads'),('en_US',418,'Līvānu novads'),('en_US',419,'Madonas novads'),('en_US',420,'Mazsalacas novads'),('en_US',421,'Mālpils novads'),('en_US',422,'Mārupes novads'),('en_US',423,'Naukšēnu novads'),('en_US',424,'Neretas novads'),('en_US',425,'Nīcas novads'),('en_US',426,'Ogres novads'),('en_US',427,'Olaines novads'),('en_US',428,'Ozolnieku novads'),('en_US',429,'Preiļu novads'),('en_US',430,'Priekules novads'),('en_US',431,'Priekuļu novads'),('en_US',432,'Pārgaujas novads'),('en_US',433,'Pāvilostas novads'),('en_US',434,'Pļaviņu novads'),('en_US',435,'Raunas novads'),('en_US',436,'Riebiņu novads'),('en_US',437,'Rojas novads'),('en_US',438,'Ropažu novads'),('en_US',439,'Rucavas novads'),('en_US',440,'Rugāju novads'),('en_US',441,'Rundāles novads'),('en_US',442,'Rēzeknes novads'),('en_US',443,'Rūjienas novads'),('en_US',444,'Salacgrīvas novads'),('en_US',445,'Salas novads'),('en_US',446,'Salaspils novads'),('en_US',447,'Saldus novads'),('en_US',448,'Saulkrastu novads'),('en_US',449,'Siguldas novads'),('en_US',450,'Skrundas novads'),('en_US',451,'Skrīveru novads'),('en_US',452,'Smiltenes novads'),('en_US',453,'Stopiņu novads'),('en_US',454,'Strenču novads'),('en_US',455,'Sējas novads'),('en_US',456,'Talsu novads'),('en_US',457,'Tukuma novads'),('en_US',458,'Tērvetes novads'),('en_US',459,'Vaiņodes novads'),('en_US',460,'Valkas novads'),('en_US',461,'Valmieras novads'),('en_US',462,'Varakļānu novads'),('en_US',463,'Vecpiebalgas novads'),('en_US',464,'Vecumnieku novads'),('en_US',465,'Ventspils novads'),('en_US',466,'Viesītes novads'),('en_US',467,'Viļakas novads'),('en_US',468,'Viļānu novads'),('en_US',469,'Vārkavas novads'),('en_US',470,'Zilupes novads'),('en_US',471,'Ādažu novads'),('en_US',472,'Ērgļu novads'),('en_US',473,'Ķeguma novads'),('en_US',474,'Ķekavas novads'),('en_US',475,'Alytaus Apskritis'),('en_US',476,'Kauno Apskritis'),('en_US',477,'Klaipėdos Apskritis'),('en_US',478,'Marijampolės Apskritis'),('en_US',479,'Panevėžio Apskritis'),('en_US',480,'Šiaulių Apskritis'),('en_US',481,'Tauragės Apskritis'),('en_US',482,'Telšių Apskritis'),('en_US',483,'Utenos Apskritis'),('en_US',484,'Vilniaus Apskritis'),('en_US',485,'Acre'),('en_US',486,'Alagoas'),('en_US',487,'Amapá'),('en_US',488,'Amazonas'),('en_US',489,'Bahia'),('en_US',490,'Ceará'),('en_US',491,'Espírito Santo'),('en_US',492,'Goiás'),('en_US',493,'Maranhão'),('en_US',494,'Mato Grosso'),('en_US',495,'Mato Grosso do Sul'),('en_US',496,'Minas Gerais'),('en_US',497,'Pará'),('en_US',498,'Paraíba'),('en_US',499,'Paraná'),('en_US',500,'Pernambuco'),('en_US',501,'Piauí'),('en_US',502,'Rio de Janeiro'),('en_US',503,'Rio Grande do Norte'),('en_US',504,'Rio Grande do Sul'),('en_US',505,'Rondônia'),('en_US',506,'Roraima'),('en_US',507,'Santa Catarina'),('en_US',508,'São Paulo'),('en_US',509,'Sergipe'),('en_US',510,'Tocantins'),('en_US',511,'Distrito Federal'),('en_US',512,'Zagrebačka županija'),('en_US',513,'Krapinsko-zagorska županija'),('en_US',514,'Sisačko-moslavačka županija'),('en_US',515,'Karlovačka županija'),('en_US',516,'Varaždinska županija'),('en_US',517,'Koprivničko-križevačka županija'),('en_US',518,'Bjelovarsko-bilogorska županija'),('en_US',519,'Primorsko-goranska županija'),('en_US',520,'Ličko-senjska županija'),('en_US',521,'Virovitičko-podravska županija'),('en_US',522,'Požeško-slavonska županija'),('en_US',523,'Brodsko-posavska županija'),('en_US',524,'Zadarska županija'),('en_US',525,'Osječko-baranjska županija'),('en_US',526,'Šibensko-kninska županija'),('en_US',527,'Vukovarsko-srijemska županija'),('en_US',528,'Splitsko-dalmatinska županija'),('en_US',529,'Istarska županija'),('en_US',530,'Dubrovačko-neretvanska županija'),('en_US',531,'Međimurska županija'),('en_US',532,'Grad Zagreb'),('en_US',533,'Andaman and Nicobar Islands'),('en_US',534,'Andhra Pradesh'),('en_US',535,'Arunachal Pradesh'),('en_US',536,'Assam'),('en_US',537,'Bihar'),('en_US',538,'Chandigarh'),('en_US',539,'Chhattisgarh'),('en_US',540,'Dadra and Nagar Haveli'),('en_US',541,'Daman and Diu'),('en_US',542,'Delhi'),('en_US',543,'Goa'),('en_US',544,'Gujarat'),('en_US',545,'Haryana'),('en_US',546,'Himachal Pradesh'),('en_US',547,'Jammu and Kashmir'),('en_US',548,'Jharkhand'),('en_US',549,'Karnataka'),('en_US',550,'Kerala'),('en_US',551,'Lakshadweep'),('en_US',552,'Madhya Pradesh'),('en_US',553,'Maharashtra'),('en_US',554,'Manipur'),('en_US',555,'Meghalaya'),('en_US',556,'Mizoram'),('en_US',557,'Nagaland'),('en_US',558,'Odisha'),('en_US',559,'Puducherry'),('en_US',560,'Punjab'),('en_US',561,'Rajasthan'),('en_US',562,'Sikkim'),('en_US',563,'Tamil Nadu'),('en_US',564,'Telangana'),('en_US',565,'Tripura'),('en_US',566,'Uttar Pradesh'),('en_US',567,'Uttarakhand'),('en_US',568,'West Bengal'),('en_US',569,'Australian Capital Territory'),('en_US',570,'New South Wales'),('en_US',571,'Victoria'),('en_US',572,'Queensland'),('en_US',573,'South Australia'),('en_US',574,'Tasmania'),('en_US',575,'Western Australia'),('en_US',576,'Northern Territory'),('en_US',577,'Antwerpen'),('en_US',578,'Brabant wallon'),('en_US',579,'Brussels-Capital Region'),('en_US',580,'Hainaut'),('en_US',581,'Limburg'),('en_US',582,'Liège'),('en_US',583,'Luxembourg'),('en_US',584,'Namur'),('en_US',585,'Oost-Vlaanderen'),('en_US',586,'Vlaams-Brabant'),('en_US',587,'West-Vlaanderen'),('en_US',588,'Anhui Sheng'),('en_US',589,'Beijing Shi'),('en_US',590,'Chongqing Shi'),('en_US',591,'Fujian Sheng'),('en_US',592,'Gansu Sheng'),('en_US',593,'Guangdong Sheng'),('en_US',594,'Guangxi Zhuangzu Zizhiqu'),('en_US',595,'Guizhou Sheng'),('en_US',596,'Hainan Sheng'),('en_US',597,'Hebei Sheng'),('en_US',598,'Heilongjiang Sheng'),('en_US',599,'Henan Sheng'),('en_US',600,'Hong Kong SAR'),('en_US',601,'Hubei Sheng'),('en_US',602,'Hunan Sheng'),('en_US',603,'Jiangsu Sheng'),('en_US',604,'Jiangxi Sheng'),('en_US',605,'Jilin Sheng'),('en_US',606,'Liaoning Sheng'),('en_US',607,'Macao SAR'),('en_US',608,'Nei Mongol Zizhiqu'),('en_US',609,'Ningxia Huizi Zizhiqu'),('en_US',610,'Qinghai Sheng'),('en_US',611,'Shaanxi Sheng'),('en_US',612,'Shandong Sheng'),('en_US',613,'Shanghai Shi'),('en_US',614,'Shanxi Sheng'),('en_US',615,'Sichuan Sheng'),('en_US',616,'Taiwan Sheng'),('en_US',617,'Tianjin Shi'),('en_US',618,'Xinjiang Uygur Zizhiqu'),('en_US',619,'Xizang Zizhiqu'),('en_US',620,'Yunnan Sheng'),('en_US',621,'Zhejiang Sheng'),('en_US',622,'Amazonas'),('en_US',623,'Antioquia'),('en_US',624,'Arauca'),('en_US',625,'Atlántico'),('en_US',626,'Bolívar'),('en_US',627,'Boyacá'),('en_US',628,'Caldas'),('en_US',629,'Caquetá'),('en_US',630,'Casanare'),('en_US',631,'Cauca'),('en_US',632,'Cesar'),('en_US',633,'Chocó'),('en_US',634,'Córdoba'),('en_US',635,'Cundinamarca'),('en_US',636,'Guainía'),('en_US',637,'Guaviare'),('en_US',638,'Huila'),('en_US',639,'La Guajira'),('en_US',640,'Magdalena'),('en_US',641,'Meta'),('en_US',642,'Nariño'),('en_US',643,'Norte de Santander'),('en_US',644,'Putumayo'),('en_US',645,'Quindío'),('en_US',646,'Risaralda'),('en_US',647,'San Andrés y Providencia'),('en_US',648,'Santander'),('en_US',649,'Sucre'),('en_US',650,'Tolima'),('en_US',651,'Valle del Cauca'),('en_US',652,'Vaupés'),('en_US',653,'Vichada'),('en_US',654,'Aguascalientes'),('en_US',655,'Baja California'),('en_US',656,'Baja California Sur'),('en_US',657,'Campeche'),('en_US',658,'Chiapas'),('en_US',659,'Chihuahua'),('en_US',660,'Ciudad de México'),('en_US',661,'Coahuila'),('en_US',662,'Colima'),('en_US',663,'Durango'),('en_US',664,'Estado de México'),('en_US',665,'Guanajuato'),('en_US',666,'Guerrero'),('en_US',667,'Hidalgo'),('en_US',668,'Jalisco'),('en_US',669,'Michoacán'),('en_US',670,'Morelos'),('en_US',671,'Nayarit'),('en_US',672,'Nuevo León'),('en_US',673,'Oaxaca'),('en_US',674,'Puebla'),('en_US',675,'Querétaro'),('en_US',676,'Quintana Roo'),('en_US',677,'San Luis Potosí'),('en_US',678,'Sinaloa'),('en_US',679,'Sonora'),('en_US',680,'Tabasco'),('en_US',681,'Tamaulipas'),('en_US',682,'Tlaxcala'),('en_US',683,'Veracruz'),('en_US',684,'Yucatán'),('en_US',685,'Zacatecas'),('en_US',686,'dolnośląskie'),('en_US',687,'kujawsko-pomorskie'),('en_US',688,'lubelskie'),('en_US',689,'lubuskie'),('en_US',690,'łódzkie'),('en_US',691,'małopolskie'),('en_US',692,'mazowieckie'),('en_US',693,'opolskie'),('en_US',694,'podkarpackie'),('en_US',695,'podlaskie'),('en_US',696,'pomorskie'),('en_US',697,'śląskie'),('en_US',698,'świętokrzyskie'),('en_US',699,'warmińsko-mazurskie'),('en_US',700,'wielkopolskie'),('en_US',701,'zachodniopomorskie'),('en_US',702,'Berat'),('en_US',703,'Dibër'),('en_US',704,'Durrës'),('en_US',705,'Elbasan'),('en_US',706,'Fier'),('en_US',707,'Gjirokastër'),('en_US',708,'Korçë'),('en_US',709,'Kukës'),('en_US',710,'Lezhë'),('en_US',711,'Shkodër'),('en_US',712,'Tiranë'),('en_US',713,'Vlorë'),('en_US',714,'Ciudad Autónoma de Buenos Aires'),('en_US',715,'Buenos Aires'),('en_US',716,'Catamarca'),('en_US',717,'Chaco'),('en_US',718,'Chubut'),('en_US',719,'Córdoba'),('en_US',720,'Corrientes'),('en_US',721,'Entre Ríos'),('en_US',722,'Formosa'),('en_US',723,'Jujuy'),('en_US',724,'La Pampa'),('en_US',725,'La Rioja'),('en_US',726,'Mendoza'),('en_US',727,'Misiones'),('en_US',728,'Neuquén'),('en_US',729,'Río Negro'),('en_US',730,'Salta'),('en_US',731,'San Juan'),('en_US',732,'San Luis'),('en_US',733,'Santa Cruz'),('en_US',734,'Santa Fe'),('en_US',735,'Santiago del Estero'),('en_US',736,'Tierra del Fuego'),('en_US',737,'Tucumán'),('en_US',738,'Cochabamba'),('en_US',739,'Chuquisaca'),('en_US',740,'El Beni'),('en_US',741,'La Paz'),('en_US',742,'Oruro'),('en_US',743,'Pando'),('en_US',744,'Potosí'),('en_US',745,'Santa Cruz'),('en_US',746,'Tarija'),('en_US',747,'Blagoevgrad'),('en_US',748,'Burgas'),('en_US',749,'Varna'),('en_US',750,'Veliko Tarnovo'),('en_US',751,'Vidin'),('en_US',752,'Vratsa'),('en_US',753,'Gabrovo'),('en_US',754,'Dobrich'),('en_US',755,'Kardzhali'),('en_US',756,'Kyustendil'),('en_US',757,'Lovech'),('en_US',758,'Montana'),('en_US',759,'Pazardzhik'),('en_US',760,'Pernik'),('en_US',761,'Pleven'),('en_US',762,'Plovdiv'),('en_US',763,'Razgrad'),('en_US',764,'Ruse'),('en_US',765,'Silistra'),('en_US',766,'Sliven'),('en_US',767,'Smolyan'),('en_US',768,'Sofia City'),('en_US',769,'Sofia Province'),('en_US',770,'Stara Zagora'),('en_US',771,'Targovishte'),('en_US',772,'Haskovo'),('en_US',773,'Shumen'),('en_US',774,'Yambol'),('en_US',775,'Aisén del General Carlos Ibañez del Campo'),('en_US',776,'Antofagasta'),('en_US',777,'Arica y Parinacota'),('en_US',778,'La Araucanía'),('en_US',779,'Atacama'),('en_US',780,'Biobío'),('en_US',781,'Coquimbo'),('en_US',782,'Libertador General Bernardo O\'Higgins'),('en_US',783,'Los Lagos'),('en_US',784,'Los Ríos'),('en_US',785,'Magallanes'),('en_US',786,'Maule'),('en_US',787,'Ñuble'),('en_US',788,'Región Metropolitana de Santiago'),('en_US',789,'Tarapacá'),('en_US',790,'Valparaíso'),('en_US',791,'Hovedstaden'),('en_US',792,'Midtjylland'),('en_US',793,'Nordjylland'),('en_US',794,'Sjælland'),('en_US',795,'Syddanmark'),('en_US',796,'Azuay'),('en_US',797,'Bolívar'),('en_US',798,'Cañar'),('en_US',799,'Carchi'),('en_US',800,'Chimborazo'),('en_US',801,'Cotopaxi'),('en_US',802,'El Oro'),('en_US',803,'Esmeraldas'),('en_US',804,'Galápagos'),('en_US',805,'Guayas'),('en_US',806,'Imbabura'),('en_US',807,'Loja'),('en_US',808,'Los Ríos'),('en_US',809,'Manabí'),('en_US',810,'Morona Santiago'),('en_US',811,'Napo'),('en_US',812,'Orellana'),('en_US',813,'Pastaza'),('en_US',814,'Pichincha'),('en_US',815,'Santa Elena'),('en_US',816,'Santo Domingo de los Tsáchilas'),('en_US',817,'Sucumbíos'),('en_US',818,'Tungurahua'),('en_US',819,'Zamora Chinchipe'),('en_US',820,'Anatolikí Makedonía kai Thráki'),('en_US',821,'Attikí'),('en_US',822,'Dytikí Elláda'),('en_US',823,'Dytikí Makedonía'),('en_US',824,'Ionía Nísia'),('en_US',825,'Ípeiros'),('en_US',826,'Kentrikí Makedonía'),('en_US',827,'Kríti'),('en_US',828,'Nótio Aigaío'),('en_US',829,'Pelopónnisos'),('en_US',830,'Stereá Elláda'),('en_US',831,'Thessalía'),('en_US',832,'Vóreio Aigaío'),('en_US',833,'Ágion Óros'),('en_US',834,'Barima-Waini'),('en_US',835,'Cuyuni-Mazaruni'),('en_US',836,'Demerara-Mahaica'),('en_US',837,'East Berbice-Corentyne'),('en_US',838,'Essequibo Islands-West Demerara'),('en_US',839,'Mahaica-Berbice'),('en_US',840,'Pomeroon-Supenaam'),('en_US',841,'Potaro-Siparuni'),('en_US',842,'Upper Demerara-Berbice'),('en_US',843,'Upper Takutu-Upper Essequibo'),('en_US',844,'Höfuðborgarsvæði'),('en_US',845,'Suðurnes'),('en_US',846,'Vesturland'),('en_US',847,'Vestfirðir'),('en_US',848,'Norðurland vestra'),('en_US',849,'Norðurland eystra'),('en_US',850,'Austurland'),('en_US',851,'Suðurland'),('en_US',852,'Agrigento'),('en_US',853,'Alessandria'),('en_US',854,'Ancona'),('en_US',855,'Aosta'),('en_US',856,'L\'Aquila'),('en_US',857,'Arezzo'),('en_US',858,'Ascoli-Piceno'),('en_US',859,'Asti'),('en_US',860,'Avellino'),('en_US',861,'Bari'),('en_US',862,'Barletta-Andria-Trani'),('en_US',863,'Belluno'),('en_US',864,'Benevento'),('en_US',865,'Bergamo'),('en_US',866,'Biella'),('en_US',867,'Bologna'),('en_US',868,'Bolzano'),('en_US',869,'Brescia'),('en_US',870,'Brindisi'),('en_US',871,'Cagliari'),('en_US',872,'Caltanissetta'),('en_US',873,'Campobasso'),('en_US',874,'Carbonia Iglesias'),('en_US',875,'Caserta'),('en_US',876,'Catania'),('en_US',877,'Catanzaro'),('en_US',878,'Chieti'),('en_US',879,'Como'),('en_US',880,'Cosenza'),('en_US',881,'Cremona'),('en_US',882,'Crotone'),('en_US',883,'Cuneo'),('en_US',884,'Enna'),('en_US',885,'Fermo'),('en_US',886,'Ferrara'),('en_US',887,'Firenze'),('en_US',888,'Foggia'),('en_US',889,'Forli-Cesena'),('en_US',890,'Frosinone'),('en_US',891,'Genova'),('en_US',892,'Gorizia'),('en_US',893,'Grosseto'),('en_US',894,'Imperia'),('en_US',895,'Isernia'),('en_US',896,'La-Spezia'),('en_US',897,'Latina'),('en_US',898,'Lecce'),('en_US',899,'Lecco'),('en_US',900,'Livorno'),('en_US',901,'Lodi'),('en_US',902,'Lucca'),('en_US',903,'Macerata'),('en_US',904,'Mantova'),('en_US',905,'Massa-Carrara'),('en_US',906,'Matera'),('en_US',907,'Medio Campidano'),('en_US',908,'Messina'),('en_US',909,'Milano'),('en_US',910,'Modena'),('en_US',911,'Monza-Brianza'),('en_US',912,'Napoli'),('en_US',913,'Novara'),('en_US',914,'Nuoro'),('en_US',915,'Ogliastra'),('en_US',916,'Olbia Tempio'),('en_US',917,'Oristano'),('en_US',918,'Padova'),('en_US',919,'Palermo'),('en_US',920,'Parma'),('en_US',921,'Pavia'),('en_US',922,'Perugia'),('en_US',923,'Pesaro-Urbino'),('en_US',924,'Pescara'),('en_US',925,'Piacenza'),('en_US',926,'Pisa'),('en_US',927,'Pistoia'),('en_US',928,'Pordenone'),('en_US',929,'Potenza'),('en_US',930,'Prato'),('en_US',931,'Ragusa'),('en_US',932,'Ravenna'),('en_US',933,'Reggio-Calabria'),('en_US',934,'Reggio-Emilia'),('en_US',935,'Rieti'),('en_US',936,'Rimini'),('en_US',937,'Roma'),('en_US',938,'Rovigo'),('en_US',939,'Salerno'),('en_US',940,'Sassari'),('en_US',941,'Savona'),('en_US',942,'Siena'),('en_US',943,'Siracusa'),('en_US',944,'Sondrio'),('en_US',945,'Taranto'),('en_US',946,'Teramo'),('en_US',947,'Terni'),('en_US',948,'Torino'),('en_US',949,'Trapani'),('en_US',950,'Trento'),('en_US',951,'Treviso'),('en_US',952,'Trieste'),('en_US',953,'Udine'),('en_US',954,'Varese'),('en_US',955,'Venezia'),('en_US',956,'Verbania'),('en_US',957,'Vercelli'),('en_US',958,'Verona'),('en_US',959,'Vibo-Valentia'),('en_US',960,'Vicenza'),('en_US',961,'Viterbo'),('en_US',962,'Asunción'),('en_US',963,'Alto Paraguay'),('en_US',964,'Alto Paraná'),('en_US',965,'Amambay'),('en_US',966,'Boquerón'),('en_US',967,'Caaguazú'),('en_US',968,'Caazapá'),('en_US',969,'Canindeyú'),('en_US',970,'Central'),('en_US',971,'Concepción'),('en_US',972,'Cordillera'),('en_US',973,'Guairá'),('en_US',974,'Itapúa'),('en_US',975,'Misiones'),('en_US',976,'Ñeembucú'),('en_US',977,'Paraguarí'),('en_US',978,'Presidente Hayes'),('en_US',979,'San Pedro'),('en_US',980,'Municipalidad Metropolitana de Lima'),('en_US',981,'Amazonas'),('en_US',982,'Ancash'),('en_US',983,'Apurímac'),('en_US',984,'Arequipa'),('en_US',985,'Ayacucho'),('en_US',986,'Cajamarca'),('en_US',987,'Cusco'),('en_US',988,'El Callao'),('en_US',989,'Huancavelica'),('en_US',990,'Huánuco'),('en_US',991,'Ica'),('en_US',992,'Junín'),('en_US',993,'La Libertad'),('en_US',994,'Lambayeque'),('en_US',995,'Lima'),('en_US',996,'Loreto'),('en_US',997,'Madre de Dios'),('en_US',998,'Moquegua'),('en_US',999,'Pasco'),('en_US',1000,'Piura'),('en_US',1001,'Puno'),('en_US',1002,'San Martín'),('en_US',1003,'Tacna'),('en_US',1004,'Tumbes'),('en_US',1005,'Ucayali'),('en_US',1006,'Aveiro'),('en_US',1007,'Beja'),('en_US',1008,'Braga'),('en_US',1009,'Bragança'),('en_US',1010,'Castelo Branco'),('en_US',1011,'Coimbra'),('en_US',1012,'Évora'),('en_US',1013,'Faro'),('en_US',1014,'Guarda'),('en_US',1015,'Leiria'),('en_US',1016,'Lisboa'),('en_US',1017,'Portalegre'),('en_US',1018,'Porto'),('en_US',1019,'Santarém'),('en_US',1020,'Setúbal'),('en_US',1021,'Viana do Castelo'),('en_US',1022,'Vila Real'),('en_US',1023,'Viseu'),('en_US',1024,'Região Autónoma dos Açores'),('en_US',1025,'Região Autónoma da Madeira'),('en_US',1026,'Brokopondo'),('en_US',1027,'Commewijne'),('en_US',1028,'Coronie'),('en_US',1029,'Marowijne'),('en_US',1030,'Nickerie'),('en_US',1031,'Para'),('en_US',1032,'Paramaribo'),('en_US',1033,'Saramacca'),('en_US',1034,'Sipaliwini'),('en_US',1035,'Wanica'),('en_US',1036,'Blekinge län'),('en_US',1037,'Dalarnas län'),('en_US',1038,'Gotlands län'),('en_US',1039,'Gävleborgs län'),('en_US',1040,'Hallands län'),('en_US',1041,'Jämtlands län'),('en_US',1042,'Jönköpings län'),('en_US',1043,'Kalmar län'),('en_US',1044,'Kronobergs län'),('en_US',1045,'Norrbottens län'),('en_US',1046,'Skåne län'),('en_US',1047,'Stockholms län'),('en_US',1048,'Södermanlands län'),('en_US',1049,'Uppsala län'),('en_US',1050,'Värmlands län'),('en_US',1051,'Västerbottens län'),('en_US',1052,'Västernorrlands län'),('en_US',1053,'Västmanlands län'),('en_US',1054,'Västra Götalands län'),('en_US',1055,'Örebro län'),('en_US',1056,'Östergötlands län'),('en_US',1057,'Artigas'),('en_US',1058,'Canelones'),('en_US',1059,'Cerro Largo'),('en_US',1060,'Colonia'),('en_US',1061,'Durazno'),('en_US',1062,'Flores'),('en_US',1063,'Florida'),('en_US',1064,'Lavalleja'),('en_US',1065,'Maldonado'),('en_US',1066,'Montevideo'),('en_US',1067,'Paysandu'),('en_US',1068,'Río Negro'),('en_US',1069,'Rivera'),('en_US',1070,'Rocha'),('en_US',1071,'Salto'),('en_US',1072,'San José'),('en_US',1073,'Soriano'),('en_US',1074,'Tacuarembó'),('en_US',1075,'Treinta y Tres'),('en_US',1076,'Dependencias Federales'),('en_US',1077,'Distrito Capital'),('en_US',1078,'Amazonas'),('en_US',1079,'Anzoátegui'),('en_US',1080,'Apure'),('en_US',1081,'Aragua'),('en_US',1082,'Barinas'),('en_US',1083,'Bolívar'),('en_US',1084,'Carabobo'),('en_US',1085,'Cojedes'),('en_US',1086,'Delta Amacuro'),('en_US',1087,'Falcón'),('en_US',1088,'Guárico'),('en_US',1089,'Lara'),('en_US',1090,'Mérida'),('en_US',1091,'Miranda'),('en_US',1092,'Monagas'),('en_US',1093,'Nueva Esparta'),('en_US',1094,'Portuguesa'),('en_US',1095,'Sucre'),('en_US',1096,'Táchira'),('en_US',1097,'Trujillo'),('en_US',1098,'Vargas'),('en_US',1099,'Yaracuy'),('en_US',1100,'Zulia');

--
-- Table structure for table `wal_directory_currency_rate`
--

CREATE TABLE `wal_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 `WAL_DIRECTORY_CURRENCY_RATE_CURRENCY_TO` (`currency_to`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Directory Currency Rate';

--
-- Dumping data for table `wal_directory_currency_rate`
--

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

--
-- Table structure for table `wal_downloadable_link`
--

CREATE TABLE `wal_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 `WAL_DOWNLOADABLE_LINK_PRODUCT_ID_SORT_ORDER` (`product_id`,`sort_order`),
  CONSTRAINT `WAL_DL_LNK_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Table';

--
-- Dumping data for table `wal_downloadable_link`
--


--
-- Table structure for table `wal_downloadable_link_price`
--

CREATE TABLE `wal_downloadable_link_price` (
  `price_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Price ID',
  `link_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Link ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `price` decimal(20,6) NOT NULL DEFAULT '0.000000' COMMENT 'Price',
  PRIMARY KEY (`price_id`),
  KEY `WAL_DOWNLOADABLE_LINK_PRICE_LINK_ID` (`link_id`),
  KEY `WAL_DOWNLOADABLE_LINK_PRICE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `WAL_DL_LNK_PRICE_LNK_ID_WAL_DL_LNK_LNK_ID` FOREIGN KEY (`link_id`) REFERENCES `wal_downloadable_link` (`link_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_DL_LNK_PRICE_WS_ID_WAL_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Price Table';

--
-- Dumping data for table `wal_downloadable_link_price`
--


--
-- Table structure for table `wal_downloadable_link_purchased`
--

CREATE TABLE `wal_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 `WAL_DOWNLOADABLE_LINK_PURCHASED_ORDER_ID` (`order_id`),
  KEY `WAL_DOWNLOADABLE_LINK_PURCHASED_ORDER_ITEM_ID` (`order_item_id`),
  KEY `WAL_DOWNLOADABLE_LINK_PURCHASED_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `WAL_DL_LNK_PURCHASED_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE SET NULL,
  CONSTRAINT `WAL_DL_LNK_PURCHASED_ORDER_ID_WAL_SALES_ORDER_ENTT_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Table';

--
-- Dumping data for table `wal_downloadable_link_purchased`
--


--
-- Table structure for table `wal_downloadable_link_purchased_item`
--

CREATE TABLE `wal_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 `WAL_DOWNLOADABLE_LINK_PURCHASED_ITEM_LINK_HASH` (`link_hash`),
  KEY `WAL_DOWNLOADABLE_LINK_PURCHASED_ITEM_ORDER_ITEM_ID` (`order_item_id`),
  KEY `WAL_DOWNLOADABLE_LINK_PURCHASED_ITEM_PURCHASED_ID` (`purchased_id`),
  CONSTRAINT `FK_7797AA0276E353B8E5A3DC3E689C263C` FOREIGN KEY (`purchased_id`) REFERENCES `wal_downloadable_link_purchased` (`purchased_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_9C6744F9FD9716987EE5E3A6FA33E088` FOREIGN KEY (`order_item_id`) REFERENCES `wal_sales_order_item` (`item_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Link Purchased Item Table';

--
-- Dumping data for table `wal_downloadable_link_purchased_item`
--


--
-- Table structure for table `wal_downloadable_link_title`
--

CREATE TABLE `wal_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 `WAL_DOWNLOADABLE_LINK_TITLE_LINK_ID_STORE_ID` (`link_id`,`store_id`),
  KEY `WAL_DOWNLOADABLE_LINK_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_DL_LNK_TTL_LNK_ID_WAL_DL_LNK_LNK_ID` FOREIGN KEY (`link_id`) REFERENCES `wal_downloadable_link` (`link_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_DOWNLOADABLE_LINK_TITLE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Link Title Table';

--
-- Dumping data for table `wal_downloadable_link_title`
--


--
-- Table structure for table `wal_downloadable_sample`
--

CREATE TABLE `wal_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 `WAL_DOWNLOADABLE_SAMPLE_PRODUCT_ID` (`product_id`),
  CONSTRAINT `WAL_DL_SAMPLE_PRD_ID_WAL_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Table';

--
-- Dumping data for table `wal_downloadable_sample`
--


--
-- Table structure for table `wal_downloadable_sample_title`
--

CREATE TABLE `wal_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 `WAL_DOWNLOADABLE_SAMPLE_TITLE_SAMPLE_ID_STORE_ID` (`sample_id`,`store_id`),
  KEY `WAL_DOWNLOADABLE_SAMPLE_TITLE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_DL_SAMPLE_TTL_SAMPLE_ID_WAL_DL_SAMPLE_SAMPLE_ID` FOREIGN KEY (`sample_id`) REFERENCES `wal_downloadable_sample` (`sample_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_DOWNLOADABLE_SAMPLE_TITLE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Downloadable Sample Title Table';

--
-- Dumping data for table `wal_downloadable_sample_title`
--


--
-- Table structure for table `wal_eav_attribute`
--

CREATE TABLE `wal_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 `WAL_EAV_ATTRIBUTE_ENTITY_TYPE_ID_ATTRIBUTE_CODE` (`entity_type_id`,`attribute_code`),
  KEY `WAL_EAV_ATTRIBUTE_FRONTEND_INPUT_ENTITY_TYPE_ID_IS_USER_DEFINED` (`frontend_input`,`entity_type_id`,`is_user_defined`),
  CONSTRAINT `WAL_EAV_ATTR_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=261 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute';

--
-- Dumping data for table `wal_eav_attribute`
--

INSERT INTO `wal_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','Magento\\Customer\\Model\\Attribute',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','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Price',NULL,NULL,1,0,NULL,0,NULL),(78,4,'special_price','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Special Price',NULL,NULL,0,0,NULL,0,NULL),(79,4,'special_from_date',NULL,'Magento\\Catalog\\Model\\Attribute\\Backend\\Startdate','datetime',NULL,NULL,'date','Special Price From Date',NULL,NULL,0,0,NULL,0,NULL),(80,4,'special_to_date',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Backend\\Datetime','datetime',NULL,NULL,'date','Special Price To Date',NULL,NULL,0,0,NULL,0,NULL),(81,4,'cost',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Cost',NULL,NULL,0,1,NULL,0,NULL),(82,4,'weight',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Weight','decimal',NULL,NULL,'weight','Weight',NULL,NULL,0,0,NULL,0,NULL),(83,4,'manufacturer',NULL,NULL,'int',NULL,NULL,'select','Manufacturer',NULL,NULL,0,1,NULL,0,NULL),(84,4,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Meta Title',NULL,NULL,0,0,NULL,0,NULL),(85,4,'meta_keyword',NULL,NULL,'text',NULL,NULL,'textarea','Meta Keywords',NULL,NULL,0,0,NULL,0,NULL),(86,4,'meta_description',NULL,NULL,'varchar',NULL,NULL,'textarea','Meta Description',NULL,NULL,0,0,NULL,0,'Maximum 255 chars. Meta Description should optimally be between 150-160 characters'),(87,4,'image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Base',NULL,NULL,0,0,NULL,0,NULL),(88,4,'small_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Small',NULL,NULL,0,0,NULL,0,NULL),(89,4,'thumbnail',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Thumbnail',NULL,NULL,0,0,NULL,0,NULL),(90,4,'media_gallery',NULL,NULL,'static',NULL,NULL,'gallery','Media Gallery',NULL,NULL,0,0,NULL,0,NULL),(91,4,'old_id',NULL,NULL,'int',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(92,4,'tier_price',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Tierprice','decimal',NULL,NULL,'text','Tier Price',NULL,NULL,0,0,NULL,0,NULL),(93,4,'color',NULL,NULL,'int',NULL,NULL,'select','Color',NULL,NULL,0,1,'4',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','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute',NULL,'int',NULL,NULL,'select','Enable Product',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\Status',0,0,'1',0,NULL),(98,4,'minimal_price','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','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,'msrp','Magento\\Catalog\\Model\\ResourceModel\\Eav\\Attribute','Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Minimum Advertised Price',NULL,NULL,0,0,NULL,0,NULL),(118,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),(119,3,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(120,3,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(121,4,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','URL Key',NULL,NULL,0,0,NULL,0,NULL),(122,4,'url_path',NULL,NULL,'varchar',NULL,NULL,'text',NULL,NULL,NULL,0,0,NULL,0,NULL),(123,4,'links_purchased_separately',NULL,NULL,'int',NULL,NULL,NULL,'Links can be purchased separately',NULL,NULL,1,0,NULL,0,NULL),(124,4,'samples_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Samples title',NULL,NULL,1,0,NULL,0,NULL),(125,4,'links_title',NULL,NULL,'varchar',NULL,NULL,NULL,'Links title',NULL,NULL,1,0,NULL,0,NULL),(126,4,'links_exist',NULL,NULL,'int',NULL,NULL,NULL,NULL,NULL,NULL,0,0,NULL,0,NULL),(127,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),(128,4,'swatch_image',NULL,NULL,'varchar',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Frontend\\Image','media_image','Swatch',NULL,NULL,0,0,NULL,0,NULL),(129,4,'tax_class_id',NULL,NULL,'int',NULL,NULL,'select','Tax Class',NULL,'Magento\\Tax\\Model\\TaxClass\\Source\\Product',0,0,'2',0,NULL),(130,4,'price_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Price',NULL,NULL,1,0,'0',0,NULL),(131,4,'sku_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic SKU',NULL,NULL,1,0,'0',0,NULL),(132,4,'weight_type',NULL,NULL,'int',NULL,NULL,'boolean','Dynamic Weight',NULL,NULL,1,0,'0',0,NULL),(133,4,'price_view',NULL,NULL,'int',NULL,NULL,'select','Price View',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Price\\View',1,0,NULL,0,NULL),(134,4,'shipment_type',NULL,NULL,'int',NULL,NULL,'select','Ship Bundle Items',NULL,'Magento\\Bundle\\Model\\Product\\Attribute\\Source\\Shipment\\Type',1,0,'0',0,NULL),(138,20,'name',NULL,NULL,'varchar',NULL,NULL,'text','Lookbook name',NULL,NULL,1,0,NULL,0,NULL),(139,20,'is_active',NULL,NULL,'int',NULL,NULL,'select','Is Active',NULL,NULL,1,0,NULL,0,NULL),(140,20,'description',NULL,NULL,'text',NULL,NULL,'textarea','Lookbook description',NULL,NULL,0,0,NULL,0,NULL),(141,20,'thumbnail',NULL,NULL,'varchar',NULL,NULL,'text','Lookbook thumbnail',NULL,NULL,0,0,NULL,0,NULL),(142,20,'cover',NULL,NULL,'varchar',NULL,NULL,'text','Lookbook cover',NULL,NULL,0,0,NULL,0,NULL),(143,20,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','Url key',NULL,NULL,0,0,NULL,0,NULL),(144,20,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Meta title',NULL,NULL,0,0,NULL,0,NULL),(145,20,'meta_description',NULL,NULL,'text',NULL,NULL,'textarea','Meta description',NULL,NULL,0,0,NULL,0,NULL),(146,20,'meta_keywords',NULL,NULL,'varchar',NULL,NULL,'text','Meta keywords',NULL,NULL,0,0,NULL,0,NULL),(147,21,'name',NULL,NULL,'varchar',NULL,NULL,'text','Item name',NULL,NULL,1,0,NULL,0,NULL),(148,21,'is_active',NULL,NULL,'int',NULL,NULL,'select','Is Active',NULL,NULL,1,0,NULL,0,NULL),(149,21,'description',NULL,NULL,'text',NULL,NULL,'textarea','Item description',NULL,NULL,0,0,NULL,0,NULL),(150,21,'item_data',NULL,NULL,'text',NULL,NULL,'textarea','Item data',NULL,NULL,0,0,NULL,0,NULL),(151,22,'name',NULL,NULL,'varchar',NULL,NULL,'text','Category name',NULL,NULL,1,0,NULL,0,NULL),(152,22,'is_active',NULL,NULL,'int',NULL,NULL,'select','Is Active',NULL,NULL,1,0,'1',0,NULL),(153,22,'description',NULL,NULL,'text',NULL,NULL,'textarea','Category description',NULL,NULL,0,0,NULL,0,NULL),(154,22,'thumbnail',NULL,NULL,'varchar',NULL,NULL,'text','Category thumbnail',NULL,NULL,0,0,NULL,0,NULL),(155,22,'cover',NULL,NULL,'varchar',NULL,NULL,'text','Category cover',NULL,NULL,0,0,NULL,0,NULL),(156,22,'url_key',NULL,NULL,'varchar',NULL,NULL,'text','Url key',NULL,NULL,0,0,NULL,0,NULL),(157,22,'meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Meta title',NULL,NULL,0,0,NULL,0,NULL),(158,22,'meta_description',NULL,NULL,'text',NULL,NULL,'textarea','Meta description',NULL,NULL,0,0,NULL,0,NULL),(159,22,'meta_keywords',NULL,NULL,'varchar',NULL,NULL,'text','Meta keywords',NULL,NULL,0,0,NULL,0,NULL),(160,22,'is_anchor',NULL,NULL,'int',NULL,NULL,'select','Is Anchor',NULL,NULL,0,0,'1',0,NULL),(161,22,'url_path',NULL,NULL,'varchar',NULL,NULL,'text','Request Path',NULL,NULL,0,0,NULL,0,NULL),(162,100,'brand_title',NULL,NULL,'varchar',NULL,NULL,'text','Brand Title',NULL,NULL,0,0,NULL,0,NULL),(163,100,'brand_url_key',NULL,NULL,'text',NULL,NULL,'text','Brand URL key',NULL,NULL,0,0,NULL,0,NULL),(164,100,'brand_description',NULL,NULL,'text',NULL,NULL,'textarea','Brand Description',NULL,NULL,0,0,NULL,0,NULL),(165,100,'brand_content',NULL,NULL,'text',NULL,NULL,'textarea','Brand Description',NULL,NULL,0,0,NULL,0,NULL),(166,100,'brand_thumbnail',NULL,NULL,'varchar',NULL,NULL,'text','Brand Thumbnail Image',NULL,NULL,0,0,NULL,0,NULL),(167,100,'brand_cover',NULL,NULL,'varchar',NULL,NULL,'text','Brand Cover Image',NULL,NULL,0,0,NULL,0,NULL),(168,100,'brand_is_featured',NULL,NULL,'int',NULL,NULL,'select','Is Featured',NULL,NULL,0,0,NULL,0,NULL),(169,100,'brand_meta_title',NULL,NULL,'varchar',NULL,NULL,'text','Brand Meta Title',NULL,NULL,0,0,NULL,0,NULL),(170,100,'brand_meta_description',NULL,NULL,'text',NULL,NULL,'textarea','Brand Meta Description',NULL,NULL,0,0,NULL,0,NULL),(171,100,'brand_meta_keyword',NULL,NULL,'varchar',NULL,NULL,'text','Brand Meta Keyword',NULL,NULL,0,0,NULL,0,NULL),(172,101,'content',NULL,NULL,'text',NULL,NULL,'text','Label Content',NULL,NULL,1,0,NULL,0,NULL),(173,101,'custom_class',NULL,NULL,'varchar',NULL,NULL,'text','Custom Class',NULL,NULL,0,0,NULL,0,NULL),(174,101,'custom_css',NULL,NULL,'text',NULL,NULL,'text','Custom CSS',NULL,NULL,0,0,NULL,0,NULL),(175,101,'label_image',NULL,NULL,'varchar',NULL,NULL,'text','Label Image',NULL,NULL,0,0,NULL,0,NULL),(176,101,'label_background',NULL,NULL,'varchar',NULL,NULL,'text','Image',NULL,NULL,0,0,NULL,0,NULL),(177,1,'is_anonymized',NULL,NULL,'int',NULL,NULL,'select','Is Anonymized',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'0',0,NULL),(178,4,'custom_layout_update_file',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\LayoutUpdate','varchar',NULL,NULL,'select','Custom Layout Update',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Source\\LayoutUpdate',0,0,NULL,0,NULL),(179,3,'custom_layout_update_file',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\LayoutUpdate','varchar',NULL,NULL,'select','Custom Layout Update',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Source\\LayoutUpdate',0,0,NULL,0,NULL),(186,4,'price_per_unit',NULL,NULL,'text',NULL,NULL,'text','Price Per Unit',NULL,NULL,0,0,'0',0,NULL),(187,4,'giftcard_amounts',NULL,'Magento\\GiftCard\\Model\\Attribute\\Backend\\Giftcard\\Amount','decimal',NULL,NULL,'price','Amount',NULL,NULL,0,0,NULL,0,NULL),(188,4,'allow_open_amount',NULL,NULL,'int',NULL,NULL,'select','Open Amount',NULL,'Magento\\GiftCard\\Model\\Source\\Open',0,0,NULL,0,NULL),(189,4,'open_amount_min',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Open Amount From',NULL,NULL,0,0,NULL,0,NULL),(190,4,'open_amount_max',NULL,'Magento\\Catalog\\Model\\Product\\Attribute\\Backend\\Price','decimal',NULL,NULL,'price','Open Amount To',NULL,NULL,0,0,NULL,0,NULL),(191,4,'giftcard_type',NULL,NULL,'int',NULL,NULL,'select','Card Type',NULL,'Magento\\GiftCard\\Model\\Source\\Type',1,0,NULL,0,NULL),(192,4,'is_redeemable',NULL,NULL,'int',NULL,NULL,'text','Is Redeemable',NULL,NULL,0,0,NULL,0,NULL),(193,4,'use_config_is_redeemable',NULL,NULL,'int',NULL,NULL,'text','Use Config Is Redeemable',NULL,NULL,0,0,NULL,0,NULL),(194,4,'lifetime',NULL,NULL,'int',NULL,NULL,'text','Lifetime',NULL,NULL,0,0,NULL,0,NULL),(195,4,'use_config_lifetime',NULL,NULL,'int',NULL,NULL,'text','Use Config Lifetime',NULL,NULL,0,0,NULL,0,NULL),(196,4,'email_template',NULL,NULL,'varchar',NULL,NULL,'text','Email Template',NULL,NULL,0,0,NULL,0,NULL),(197,4,'use_config_email_template',NULL,NULL,'int',NULL,NULL,'text','Use Config Email Template',NULL,NULL,0,0,NULL,0,NULL),(198,4,'allow_message',NULL,NULL,'int',NULL,NULL,'text','Allow Message',NULL,NULL,0,0,NULL,0,NULL),(199,4,'use_config_allow_message',NULL,NULL,'int',NULL,NULL,'text','Use Config Allow Message',NULL,NULL,0,0,NULL,0,NULL),(200,5,'reward_points_balance_refunded',NULL,NULL,'integer',NULL,NULL,'text',NULL,NULL,NULL,1,0,NULL,0,NULL),(201,5,'reward_salesrule_points',NULL,NULL,'integer',NULL,NULL,'text',NULL,NULL,NULL,1,0,NULL,0,NULL),(202,1,'reward_update_notification',NULL,NULL,'int',NULL,NULL,'text','Reward update notification',NULL,NULL,0,0,NULL,0,NULL),(203,1,'reward_warning_notification',NULL,NULL,'int',NULL,NULL,'text','Reward warning notification',NULL,NULL,0,0,NULL,0,NULL),(204,3,'automatic_sorting',NULL,NULL,'varchar',NULL,NULL,'text','Automatic Sorting',NULL,NULL,0,1,'none',0,NULL),(205,3,'am_exclude_from_filter',NULL,NULL,'int',NULL,NULL,'boolean','Exclude from Category Filter',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'0',0,NULL),(206,3,'thumbnail',NULL,'Magento\\Catalog\\Model\\Category\\Attribute\\Backend\\Image','varchar',NULL,NULL,'image','Thumbnail',NULL,NULL,0,0,NULL,0,NULL),(207,1,'rewards_subscription',NULL,NULL,'int',NULL,NULL,'select','Subscription to Points Expiring Notification',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'1',0,NULL),(208,1,'mst_rewards_tier_id',NULL,NULL,'int',NULL,NULL,'select','Rewards Tier',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(209,4,'am_offer_item_condition',NULL,NULL,'int',NULL,NULL,'select','Offer Item Condition',NULL,'Amasty\\SeoRichData\\Model\\Source\\Product\\OfferItemCondition',0,1,'1',0,NULL),(210,4,'stripe_sub_enabled',NULL,NULL,'int',NULL,NULL,'boolean','Subscription Enabled',NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,NULL,0,NULL),(211,4,'stripe_sub_interval',NULL,NULL,'varchar',NULL,NULL,'select','Frequency',NULL,'StripeIntegration\\Payments\\Model\\Adminhtml\\Source\\BillingInterval',0,0,NULL,0,NULL),(212,4,'stripe_sub_interval_count',NULL,NULL,'varchar',NULL,NULL,'text','Repeat Every',NULL,NULL,0,0,NULL,0,NULL),(213,4,'stripe_sub_trial',NULL,NULL,'int',NULL,NULL,'text','Trial Days',NULL,NULL,0,0,NULL,0,NULL),(214,4,'stripe_sub_initial_fee',NULL,NULL,'decimal',NULL,NULL,'text','Initial Fee',NULL,NULL,0,0,NULL,0,NULL),(215,4,'google_product_category',NULL,NULL,'varchar',NULL,NULL,'select','Google Product Category',NULL,'Facebook\\BusinessExtension\\Model\\Config\\Source\\Product\\GoogleProductCategory',0,0,NULL,0,NULL),(216,4,'facebook_age_group',NULL,NULL,'text',NULL,NULL,'select','Age Group',NULL,'Facebook\\BusinessExtension\\Model\\Config\\Source\\Product\\AgeGroup',0,1,NULL,0,NULL),(217,4,'facebook_gender',NULL,NULL,'text',NULL,NULL,'select','Gender',NULL,'Facebook\\BusinessExtension\\Model\\Config\\Source\\Product\\Gender',0,1,NULL,0,NULL),(218,4,'facebook_pattern',NULL,NULL,'text',NULL,NULL,'select','Pattern',NULL,'Facebook\\BusinessExtension\\Model\\Config\\Source\\Product\\Pattern',0,1,NULL,0,NULL),(219,4,'facebook_decor_style',NULL,NULL,'text',NULL,NULL,'select','Decor Style',NULL,'Facebook\\BusinessExtension\\Model\\Config\\Source\\Product\\DecorStyle',0,1,NULL,0,NULL),(220,4,'facebook_color',NULL,NULL,'text',NULL,NULL,'text','Color',NULL,NULL,0,1,NULL,0,'Use one or more words to describe the color, not a hex code. \"\n                            . \"Sample Sample value: Royal Blue.'),(221,4,'facebook_capacity',NULL,NULL,'text',NULL,NULL,'text','Capacity',NULL,NULL,0,1,NULL,0,'Sample values: 20 lbs, 10 liters, 4.5 cu ft, 12 oz, 8 oz, 1 Litre'),(222,4,'facebook_material',NULL,NULL,'text',NULL,NULL,'text','Material',NULL,NULL,0,1,NULL,0,'Primary material(s) of the item. Sample values: Plastic, Rubber, Cotton.'),(223,4,'facebook_size',NULL,NULL,'text',NULL,NULL,'text','Size',NULL,NULL,0,1,NULL,0,'Sample Values: Small, Medium, Large, \'2\', 4, 6, One Size, Twin, Full, Queen, King'),(224,4,'facebook_style',NULL,NULL,'text',NULL,NULL,'text','Style',NULL,NULL,0,1,NULL,0,'Sample values: bangle, cuff, engagement ring, stud, hoops, Maxi, \"\n                            .\"Boyfriend, Braided, fashion, fine'),(225,4,'facebook_brand',NULL,NULL,'text',NULL,NULL,'text','Brand',NULL,NULL,0,1,NULL,0,'Brand name, unique manufacturer part number (MPN), or Global Trade \"\n                            .\"Item Number (GTIN) of the item.'),(226,4,'facebook_product_length',NULL,NULL,'text',NULL,NULL,'text','Product Length',NULL,NULL,0,1,NULL,0,'Length of the fully assembled product. Sample values: 5 in, 2 ft, 60 cm'),(227,4,'facebook_product_width',NULL,NULL,'text',NULL,NULL,'text','Product Width',NULL,NULL,0,1,NULL,0,'Length of the fully assembled product. Sample values: 5 in, 2 ft, 60 cm'),(228,4,'facebook_product_height',NULL,NULL,'text',NULL,NULL,'text','Product Height',NULL,NULL,0,1,NULL,0,'Length of the fully assembled product. Sample values: 5 in, 2 ft, 60 cm'),(229,4,'facebook_model',NULL,NULL,'text',NULL,NULL,'text','Model',NULL,NULL,0,1,NULL,0,'Common name of the model of the product. Does not include model numbers. \"\n                            .\"Sample values: iPhone 6, Galaxy S8.'),(230,4,'facebook_product_depth',NULL,NULL,'text',NULL,NULL,'text','Product Depth',NULL,NULL,0,1,NULL,0,'Depth of the fully assembled product. Sample values: 5 in, 2 ft, 60 cm.'),(231,4,'facebook_ingredients',NULL,NULL,'text',NULL,NULL,'text','Ingredients',NULL,NULL,0,1,NULL,0,'List of active ingredients as shown on the item label.'),(232,4,'facebook_resolution',NULL,NULL,'text',NULL,NULL,'text','Resolution',NULL,NULL,0,1,NULL,0,'Resolution of the product screen. Sample values: 1080p, 4k, UHD, 24 MP.'),(233,4,'facebook_age_range',NULL,NULL,'text',NULL,NULL,'text','Age Range',NULL,NULL,0,1,NULL,0,'Minimum and maximum ages for a product, such as the unit of measure in \"\n                        .\"Months, or Years. Sample values: 1-3 yrs, 6-9 mos.'),(234,4,'facebook_screen_size',NULL,NULL,'text',NULL,NULL,'text','Screen Size',NULL,NULL,0,1,NULL,0,'Measurement of the device\'s screen, typically measured diagonally \"\n                            .\"in inches. Sample values: 42 in, 5.5 in.'),(235,4,'facebook_maximum_weight',NULL,NULL,'text',NULL,NULL,'text','Maximum Weight',NULL,NULL,0,1,NULL,0,'Sample values: 35 lb, 45 lb, 15 kg, 20 kg.'),(236,4,'facebook_minimum_weight',NULL,NULL,'text',NULL,NULL,'text','Minimum Weight',NULL,NULL,0,1,NULL,0,'Sample values: 35 lb, 45 lb, 15 kg, 20 kg.'),(237,4,'facebook_display_technology',NULL,NULL,'text',NULL,NULL,'text','Display Technology',NULL,NULL,0,1,NULL,0,'Type of technology that powers the display. Sample values: Analog, Digital, LED, LCD.'),(238,4,'facebook_operating_system',NULL,NULL,'text',NULL,NULL,'text','Operating System',NULL,NULL,0,1,NULL,0,'Type of preloaded operating system software installed on the device. \"\n                        .\"Sample values: Android, iOS, Windows.'),(239,4,'facebook_is_assembly_required',NULL,NULL,'text',NULL,NULL,'select','Is Assembly Required',NULL,'Facebook\\BusinessExtension\\Model\\Config\\Source\\Product\\Assembly',0,1,NULL,0,NULL),(240,4,'facebook_storage_capacity',NULL,NULL,'text',NULL,NULL,'text','Storage Capacity',NULL,NULL,0,1,NULL,0,'Amount of storage space on the item\'s hard drive, typically measured \"\n                            .\"in megabytes, gigabytes or terabytes. Sample values: 1 TB, 16 GB.'),(241,4,'facebook_number_of_licenses',NULL,NULL,'text',NULL,NULL,'text','Number of Licenses',NULL,NULL,0,1,NULL,0,'Maximum number of users or installations Sample under the terms of the \"\n                            .\"software licensing agreement. Sample values: 1, 3, 5.'),(242,4,'facebook_product_form',NULL,NULL,'text',NULL,NULL,'text','Product Form',NULL,NULL,0,1,NULL,0,'Consistency, texture, or formulation of the item and the way it will be consumed \"\n                            .\"or dispensed. Sample values: Oil, Gel, Spray, Cream, Powder, Serum, Liquid.'),(243,4,'facebook_compatible_devices',NULL,NULL,'text',NULL,NULL,'text','Compatible Devices',NULL,NULL,0,1,NULL,0,'Devices compatible with the item. Sample values: iPad, Tablet Computers, \"\n                            .\"Windows Desktop Computers, Apple Computers.'),(244,4,'facebook_video_game_platform',NULL,NULL,'text',NULL,NULL,'text','Video Game Platform',NULL,NULL,0,1,NULL,0,'Type of platform on which video game software is capable of running. Sample values:\"\n                        .\"Xbox 360, Nintendo Wii, PC.'),(245,4,'facebook_system_requirements',NULL,NULL,'text',NULL,NULL,'text','Software System Requirements',NULL,NULL,0,1,NULL,0,'Sample values: Windows 7 or later, Intel Core 2 Duo 1.8 Ghz, 15 GB Free Hard Drive Space.'),(246,4,'facebook_baby_food_stage',NULL,NULL,'text',NULL,NULL,'text','Baby Food Stage',NULL,NULL,0,1,NULL,0,'Sample values: Stage 1, Stage 2, Stage 3, Toddler Food.'),(247,4,'facebook_recommended_use',NULL,NULL,'text',NULL,NULL,'text','Recommended Use',NULL,NULL,0,1,NULL,0,'Recommended use or surface of cleaning product. Multiple values accepted. \"\n                            \".Sample values: carpet, hardwood, tile, glass, porcelain, leather.'),(248,4,'facebook_digital_zoom',NULL,NULL,'text',NULL,NULL,'text','Digital Zoom',NULL,NULL,0,1,NULL,0,'Magnification power provided by a feature that electronically enlarges the image area.\"\n                 .\"Sample values must be numbers (containing only numerals or a decimal point). \"\n                 .\"Sample values: 6x, 160x, 200x. Values such as 20X '),(249,4,'facebook_scent',NULL,NULL,'text',NULL,NULL,'text','Scent',NULL,NULL,0,1,NULL,0,'Scent(s) or fragrance(s) of your item, including items labeled as \"unscented\". Multiple\".\n                            \"values accepted. Sample values: Lavender, Vanilla, Lemon, Coconut, Jasmine, Pine.'),(250,4,'facebook_health_concern',NULL,NULL,'text',NULL,NULL,'text','Health Concern',NULL,NULL,0,1,NULL,0,'Multiple values accepted. Sample values: Fever, Allergies, Cholesterol, Blood Sugar.'),(251,4,'facebook_megapixels',NULL,NULL,'text',NULL,NULL,'text','Megapixels',NULL,NULL,0,1,NULL,0,'Resolution at which this item records images. Sample values: 16.0 MP, 24.2 MP.'),(252,4,'facebook_thread_count',NULL,NULL,'text',NULL,NULL,'text','Thread Count',NULL,NULL,0,1,NULL,0,'Number of threads per square inch of fabric. Sample values: 400, 600, 1000.'),(253,4,'facebook_gemstone',NULL,NULL,'text',NULL,NULL,'text','Gemstone',NULL,NULL,0,1,NULL,0,'Type of gemstone(s) in your item. Sample values: Diamond, \"\n                        .\"Turquoise, Ruby, Emerald, Sapphire.'),(254,4,'facebook_optical_zoom',NULL,NULL,'text',NULL,NULL,'text','Optical Zoom',NULL,NULL,0,1,NULL,0,'Magnification power of a physical optical zoom lens. Sample values: 10x, 20x, 24x.'),(255,4,'facebook_package_quantity',NULL,NULL,'text',NULL,NULL,'text','Package Quantity',NULL,NULL,0,1,NULL,0,'Total number of items included in the package or box. Sample values: 12, 24, 36.'),(256,4,'facebook_shoe_width',NULL,NULL,'text',NULL,NULL,'text','Shoe Width',NULL,NULL,0,1,NULL,0,'Width of shoes. Sample values: A, B, EE, Narrow, Wide.'),(257,4,'facebook_finish',NULL,NULL,'text',NULL,NULL,'text','Finish',NULL,NULL,0,1,NULL,0,'External treatment to the product that usually includes a change in appearance or\" .\n                           \"texture to the item. Commonly used for furniture include wood, metal, and fabric. Sample \".\n                           \".values: Natural/Unfin'),(258,4,'facebook_product_weight',NULL,NULL,'text',NULL,NULL,'text','Product Weight',NULL,NULL,0,1,NULL,0,'Weight of the fully assembled product. Sample values: 45 lb, 120 lb, 54 kg, 80 kg.'),(259,3,'sync_to_facebook_catalog',NULL,NULL,'int',NULL,NULL,'boolean',NULL,NULL,'Magento\\Eav\\Model\\Entity\\Attribute\\Source\\Boolean',0,0,'1',0,NULL),(260,101,'is_active',NULL,NULL,'int',NULL,NULL,'select','Is Active',NULL,NULL,1,0,NULL,0,NULL);

--
-- Table structure for table `wal_eav_attribute_group`
--

CREATE TABLE `wal_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 `WAL_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_CODE` (`attribute_set_id`,`attribute_group_code`),
  UNIQUE KEY `WAL_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_ATTRIBUTE_GROUP_NAME` (`attribute_set_id`,`attribute_group_name`),
  KEY `WAL_EAV_ATTRIBUTE_GROUP_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
  CONSTRAINT `WAL_EAV_ATTR_GROUP_ATTR_SET_ID_WAL_EAV_ATTR_SET_ATTR_SET_ID` FOREIGN KEY (`attribute_set_id`) REFERENCES `wal_eav_attribute_set` (`attribute_set_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Group';

--
-- Dumping data for table `wal_eav_attribute_group`
--

INSERT INTO `wal_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,'General',1,1,'product-details','basic'),(8,4,'Advanced Pricing',7,0,'advanced-pricing','advanced'),(9,4,'Search Engine Optimization',6,0,'search-engine-optimization','basic'),(10,4,'Images',5,0,'image-management','basic'),(11,4,'Design',9,0,'design','advanced'),(12,4,'Autosettings',11,0,'autosettings','advanced'),(13,4,'Content',3,0,'content','basic'),(14,4,'Schedule Design Update',10,0,'schedule-design-update','advanced'),(15,5,'General',1,1,'general',NULL),(16,6,'General',1,1,'general',NULL),(17,7,'General',1,1,'general',NULL),(18,8,'General',1,1,'general',NULL),(19,4,'Gift Options',12,0,'gift-options',NULL),(20,4,'Bundle Items',4,0,'bundle-items',NULL),(21,20,'General',1,1,'general',NULL),(22,20,'Lookbook',2,0,'lookbook',NULL),(23,21,'General',1,1,'general',NULL),(24,21,'Lookbook Item',2,0,'lookbook-item',NULL),(25,21,'Lookbook',3,0,'lookbook',NULL),(26,22,'General',1,1,'general',NULL),(27,22,'Lookbook Category',2,0,'lookbook-category',NULL),(28,22,'Lookbook',3,0,'lookbook',NULL),(29,100,'General',1,1,'general',NULL),(30,100,'Brand Information',2,0,'brand-information',NULL),(31,101,'General',1,1,'general',NULL),(32,101,'Label Information',2,0,'label-information',NULL),(33,4,'Mageworx Dynamic Options',40,0,'mageworx-dynamic-options',NULL),(34,4,'Subscriptions by Stripe',2,0,'subscriptions-by-stripe',NULL),(35,4,'Facebook Attribute Group',2,0,'facebook-attribute-group',NULL);

--
-- Table structure for table `wal_eav_attribute_label`
--

CREATE TABLE `wal_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 `WAL_EAV_ATTRIBUTE_LABEL_STORE_ID` (`store_id`),
  KEY `WAL_EAV_ATTRIBUTE_LABEL_ATTRIBUTE_ID_STORE_ID` (`attribute_id`,`store_id`),
  CONSTRAINT `WAL_EAV_ATTRIBUTE_LABEL_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ATTR_LBL_ATTR_ID_WAL_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `wal_eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Label';

--
-- Dumping data for table `wal_eav_attribute_label`
--


--
-- Table structure for table `wal_eav_attribute_option`
--

CREATE TABLE `wal_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 `WAL_EAV_ATTRIBUTE_OPTION_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `WAL_EAV_ATTR_OPT_ATTR_ID_WAL_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `wal_eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option';

--
-- Dumping data for table `wal_eav_attribute_option`
--

INSERT INTO `wal_eav_attribute_option` VALUES (1,20,0),(2,20,1),(3,20,3),(4,93,1),(5,93,2),(6,93,3);

--
-- Table structure for table `wal_eav_attribute_option_swatch`
--

CREATE TABLE `wal_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 `WAL_EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_OPTION_ID` (`store_id`,`option_id`),
  KEY `WAL_EAV_ATTR_OPT_SWATCH_OPT_ID_WAL_EAV_ATTR_OPT_OPT_ID` (`option_id`),
  KEY `WAL_EAV_ATTRIBUTE_OPTION_SWATCH_SWATCH_ID` (`swatch_id`),
  CONSTRAINT `WAL_EAV_ATTRIBUTE_OPTION_SWATCH_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ATTR_OPT_SWATCH_OPT_ID_WAL_EAV_ATTR_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `wal_eav_attribute_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Magento Swatches table';

--
-- Dumping data for table `wal_eav_attribute_option_swatch`
--

INSERT INTO `wal_eav_attribute_option_swatch` VALUES (1,4,0,0,'default'),(2,4,1,0,'default'),(3,5,0,0,'red'),(4,5,1,0,'red'),(5,6,0,0,'blue'),(6,6,1,0,'blue');

--
-- Table structure for table `wal_eav_attribute_option_value`
--

CREATE TABLE `wal_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 `WAL_EAV_ATTRIBUTE_OPTION_VALUE_OPTION_ID` (`option_id`),
  KEY `WAL_EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_EAV_ATTRIBUTE_OPTION_VALUE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ATTR_OPT_VAL_OPT_ID_WAL_EAV_ATTR_OPT_OPT_ID` FOREIGN KEY (`option_id`) REFERENCES `wal_eav_attribute_option` (`option_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Option Value';

--
-- Dumping data for table `wal_eav_attribute_option_value`
--

INSERT INTO `wal_eav_attribute_option_value` VALUES (1,1,0,'Male'),(2,2,0,'Female'),(3,3,0,'Not Specified'),(4,4,0,'default'),(5,5,0,'red'),(6,6,0,'blue');

--
-- Table structure for table `wal_eav_attribute_set`
--

CREATE TABLE `wal_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 `WAL_EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_ATTRIBUTE_SET_NAME` (`entity_type_id`,`attribute_set_name`),
  KEY `WAL_EAV_ATTRIBUTE_SET_ENTITY_TYPE_ID_SORT_ORDER` (`entity_type_id`,`sort_order`),
  CONSTRAINT `WAL_EAV_ATTR_SET_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COMMENT='Eav Attribute Set';

--
-- Dumping data for table `wal_eav_attribute_set`
--

INSERT INTO `wal_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),(20,20,'Default',1),(21,21,'Default',1),(22,22,'Default',1),(100,100,'Default',1),(101,101,'Default',2);

--
-- Table structure for table `wal_eav_entity`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `WAL_EAV_ENTITY_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_EAV_ENTITY_ENTITY_TYPE_ID_WAL_EAV_ENTITY_TYPE_ENTITY_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTITY_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity';

--
-- Dumping data for table `wal_eav_entity`
--


--
-- Table structure for table `wal_eav_entity_attribute`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_ATTRIBUTE_ID` (`attribute_set_id`,`attribute_id`),
  UNIQUE KEY `WAL_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_GROUP_ID_ATTRIBUTE_ID` (`attribute_group_id`,`attribute_id`),
  KEY `WAL_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_SET_ID_SORT_ORDER` (`attribute_set_id`,`sort_order`),
  KEY `WAL_EAV_ENTITY_ATTRIBUTE_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `WAL_EAV_ENTT_ATTR_ATTR_GROUP_ID_WAL_EAV_ATTR_GROUP_ATTR_GROUP_ID` FOREIGN KEY (`attribute_group_id`) REFERENCES `wal_eav_attribute_group` (`attribute_group_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTT_ATTR_ATTR_ID_WAL_EAV_ATTR_ATTR_ID` FOREIGN KEY (`attribute_id`) REFERENCES `wal_eav_attribute` (`attribute_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=311 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Attributes';

--
-- Dumping data for table `wal_eav_entity_attribute`
--

INSERT INTO `wal_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,100),(30,2,2,2,30,80),(31,2,2,2,31,90),(32,2,2,2,32,90),(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),(90,4,4,7,91,6),(96,4,4,8,98,8),(101,4,4,11,103,10),(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),(117,3,3,4,119,3),(118,3,3,4,120,17),(120,4,4,7,122,11),(121,4,4,7,123,111),(122,4,4,7,124,112),(123,4,4,7,125,113),(124,4,4,7,126,114),(136,20,20,22,138,5),(137,20,20,22,139,6),(138,20,20,22,140,10),(139,20,20,22,141,15),(140,20,20,22,142,20),(141,20,20,22,143,25),(142,20,20,22,144,30),(143,20,20,22,145,35),(144,20,20,22,146,40),(145,21,21,24,147,5),(146,21,21,25,148,6),(147,21,21,24,149,10),(148,21,21,24,150,15),(149,22,22,27,151,5),(150,22,22,28,152,6),(151,22,22,27,153,10),(152,22,22,27,154,15),(153,22,22,27,155,20),(154,22,22,27,156,25),(155,22,22,27,157,30),(156,22,22,27,158,35),(157,22,22,27,159,40),(158,22,22,27,160,50),(159,22,22,27,161,60),(160,100,100,30,162,3),(161,100,100,30,163,4),(162,100,100,30,164,5),(163,100,100,30,165,6),(164,100,100,30,166,7),(165,100,100,30,167,8),(166,100,100,30,168,9),(167,100,100,30,169,11),(168,100,100,30,170,11),(169,100,100,30,171,12),(170,101,101,32,172,3),(171,101,101,32,173,5),(172,101,101,32,174,6),(173,101,101,32,175,7),(174,101,101,32,176,5),(175,1,1,1,177,121),(177,3,3,6,179,51),(185,4,4,8,192,13),(186,4,4,8,193,14),(187,4,4,8,194,15),(188,4,4,8,195,16),(189,4,4,8,196,17),(190,4,4,8,197,18),(191,4,4,8,198,19),(192,4,4,8,199,20),(193,5,5,15,200,1),(194,5,5,15,201,2),(195,1,1,1,202,122),(196,1,1,1,203,123),(197,3,3,4,204,10),(198,3,3,5,205,85),(199,3,3,4,206,45),(200,1,1,1,207,200),(201,1,1,1,208,210),(208,4,4,7,73,2),(209,4,4,7,74,3),(210,4,4,7,77,5),(211,4,4,7,82,15),(212,4,4,7,93,7),(213,4,4,7,94,19),(214,4,4,7,95,20),(215,4,4,7,97,1),(216,4,4,7,99,17),(217,4,4,7,105,18),(218,4,4,7,114,21),(219,4,4,7,115,14),(220,4,4,7,129,13),(221,4,4,7,130,8),(222,4,4,7,131,4),(223,4,4,7,132,16),(224,4,4,7,187,9),(225,4,4,7,188,10),(226,4,4,7,189,11),(227,4,4,7,190,12),(228,4,4,7,191,6),(229,4,4,34,210,1),(230,4,4,34,211,2),(231,4,4,34,212,3),(232,4,4,34,213,4),(233,4,4,34,214,5),(234,4,4,13,75,2),(235,4,4,13,76,1),(236,4,4,20,134,1),(237,4,4,10,87,1),(238,4,4,10,88,2),(239,4,4,10,89,3),(240,4,4,10,90,5),(241,4,4,10,96,6),(242,4,4,10,128,4),(243,4,4,9,84,2),(244,4,4,9,85,3),(245,4,4,9,86,4),(246,4,4,9,121,1),(247,4,4,9,209,5),(248,4,4,8,78,1),(249,4,4,8,79,2),(250,4,4,8,80,3),(251,4,4,8,81,4),(252,4,4,8,92,5),(253,4,4,8,117,6),(254,4,4,8,118,7),(255,4,4,8,133,8),(256,4,4,33,186,20),(257,4,4,11,104,1),(258,4,4,11,106,2),(259,4,4,11,178,3),(260,4,4,14,100,3),(261,4,4,14,101,1),(262,4,4,14,102,2),(263,4,4,14,116,4),(264,4,4,19,127,1),(265,4,4,7,215,10),(266,4,4,35,216,1),(267,4,4,35,217,2),(268,4,4,35,218,3),(269,4,4,35,219,4),(270,4,4,35,220,5),(271,4,4,35,221,6),(272,4,4,35,222,7),(273,4,4,35,223,8),(274,4,4,35,224,9),(275,4,4,35,225,10),(276,4,4,35,226,11),(277,4,4,35,227,12),(278,4,4,35,228,13),(279,4,4,35,229,14),(280,4,4,35,230,15),(281,4,4,35,231,16),(282,4,4,35,232,17),(283,4,4,35,233,18),(284,4,4,35,234,19),(285,4,4,35,235,20),(286,4,4,35,236,21),(287,4,4,35,237,22),(288,4,4,35,238,23),(289,4,4,35,239,24),(290,4,4,35,240,25),(291,4,4,35,241,26),(292,4,4,35,242,27),(293,4,4,35,243,28),(294,4,4,35,244,29),(295,4,4,35,245,30),(296,4,4,35,246,31),(297,4,4,35,247,32),(298,4,4,35,248,33),(299,4,4,35,249,34),(300,4,4,35,250,35),(301,4,4,35,251,36),(302,4,4,35,252,37),(303,4,4,35,253,38),(304,4,4,35,254,39),(305,4,4,35,255,40),(306,4,4,35,256,41),(307,4,4,35,257,42),(308,4,4,35,258,43),(309,3,3,5,259,86),(310,101,101,32,260,4);

--
-- Table structure for table `wal_eav_entity_datetime`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_DATETIME_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `WAL_EAV_ENTITY_DATETIME_STORE_ID` (`store_id`),
  KEY `WAL_EAV_ENTITY_DATETIME_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `WAL_EAV_ENTITY_DATETIME_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `WAL_EAV_ENTITY_DATETIME_ENTITY_ID_WAL_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `wal_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTITY_DATETIME_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTT_DTIME_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `wal_eav_entity_datetime`
--


--
-- Table structure for table `wal_eav_entity_decimal`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_DECIMAL_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `WAL_EAV_ENTITY_DECIMAL_STORE_ID` (`store_id`),
  KEY `WAL_EAV_ENTITY_DECIMAL_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `WAL_EAV_ENTITY_DECIMAL_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `WAL_EAV_ENTITY_DECIMAL_ENTITY_ID_WAL_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `wal_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTITY_DECIMAL_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTT_DEC_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `wal_eav_entity_decimal`
--


--
-- Table structure for table `wal_eav_entity_int`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_INT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `WAL_EAV_ENTITY_INT_STORE_ID` (`store_id`),
  KEY `WAL_EAV_ENTITY_INT_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `WAL_EAV_ENTITY_INT_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `WAL_EAV_ENTITY_INT_ENTITY_ID_WAL_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `wal_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTITY_INT_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTT_INT_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `wal_eav_entity_int`
--


--
-- Table structure for table `wal_eav_entity_store`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_STORE_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `WAL_EAV_ENTITY_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_EAV_ENTITY_STORE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTT_STORE_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Store';

--
-- Dumping data for table `wal_eav_entity_store`
--


--
-- Table structure for table `wal_eav_entity_text`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_TEXT_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `WAL_EAV_ENTITY_TEXT_ENTITY_TYPE_ID` (`entity_type_id`),
  KEY `WAL_EAV_ENTITY_TEXT_ATTRIBUTE_ID` (`attribute_id`),
  KEY `WAL_EAV_ENTITY_TEXT_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_EAV_ENTITY_TEXT_ENTITY_ID_WAL_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `wal_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTITY_TEXT_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTT_TEXT_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `wal_eav_entity_text`
--


--
-- Table structure for table `wal_eav_entity_type`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_TYPE_ENTITY_TYPE_CODE` (`entity_type_code`)
) ENGINE=InnoDB AUTO_INCREMENT=102 DEFAULT CHARSET=utf8 COMMENT='Eav Entity Type';

--
-- Dumping data for table `wal_eav_entity_type`
--

INSERT INTO `wal_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),(20,'cdzlookbook','Codazon\\Lookbookpro\\Model\\ResourceModel\\Lookbook','Codazon\\Lookbookpro\\Model\\LookbookAttribute','cdzlookbook_entity',NULL,NULL,1,'default',20,NULL,0,8,'0',NULL,'Codazon\\Lookbookpro\\Model\\ResourceModel\\LookbookAttribute\\Collection'),(21,'cdzlookbook_item','Codazon\\Lookbookpro\\Model\\ResourceModel\\LookbookItem','Codazon\\Lookbookpro\\Model\\LookbookItemAttribute','cdzlookbook_item_entity',NULL,NULL,1,'default',21,NULL,0,8,'0',NULL,'Codazon\\Lookbookpro\\Model\\ResourceModel\\LookbookItemAttribute\\Collection'),(22,'cdzlookbook_category','Codazon\\Lookbookpro\\Model\\ResourceModel\\LookbookCategory','Codazon\\Lookbookpro\\Model\\LookbookCategoryAttribute','cdzlookbook_category_entity',NULL,NULL,1,'default',22,NULL,0,8,'0',NULL,'Codazon\\Lookbookpro\\Model\\ResourceModel\\LookbookCategoryAttribute\\Collection'),(100,'codazon_product_brand_entity','Codazon\\Shopbybrandpro\\Model\\ResourceModel\\BrandEntity','Codazon\\Shopbybrandpro\\Model\\ResourceModel\\Eav\\Attribute','codazon_product_brand_entity',NULL,NULL,1,'default',100,NULL,0,8,'0',NULL,'Codazon\\Shopbybrandpro\\Model\\ResourceModel\\Attribute\\Collection'),(101,'codazon_product_label_entity','Codazon\\ProductLabel\\Model\\ResourceModel\\ProductLabelEntity','Codazon\\ProductLabel\\Model\\ResourceModel\\Eav\\Attribute','codazon_product_label_entity',NULL,NULL,1,'default',101,NULL,0,8,'0',NULL,'Codazon\\ProductLabel\\Model\\ResourceModel\\ProductLabel\\Attribute\\Collection');

--
-- Table structure for table `wal_eav_entity_varchar`
--

CREATE TABLE `wal_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 `WAL_EAV_ENTITY_VARCHAR_ENTITY_ID_ATTRIBUTE_ID_STORE_ID` (`entity_id`,`attribute_id`,`store_id`),
  KEY `WAL_EAV_ENTITY_VARCHAR_STORE_ID` (`store_id`),
  KEY `WAL_EAV_ENTITY_VARCHAR_ATTRIBUTE_ID_VALUE` (`attribute_id`,`value`),
  KEY `WAL_EAV_ENTITY_VARCHAR_ENTITY_TYPE_ID_VALUE` (`entity_type_id`,`value`),
  CONSTRAINT `WAL_EAV_ENTITY_VARCHAR_ENTITY_ID_WAL_EAV_ENTITY_ENTITY_ID` FOREIGN KEY (`entity_id`) REFERENCES `wal_eav_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTITY_VARCHAR_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_ENTT_VCHR_ENTT_TYPE_ID_WAL_EAV_ENTT_TYPE_ENTT_TYPE_ID` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Entity Value Prefix';

--
-- Dumping data for table `wal_eav_entity_varchar`
--


--
-- Table structure for table `wal_eav_form_element`
--

CREATE TABLE `wal_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 `WAL_EAV_FORM_ELEMENT_TYPE_ID_ATTRIBUTE_ID` (`type_id`,`attribute_id`),
  KEY `WAL_EAV_FORM_ELEMENT_FIELDSET_ID` (`fieldset_id`),
  KEY `WAL_EAV_FORM_ELEMENT_ATTRIBUTE_ID` (`attribute_id`),
  CONSTRAINT `WAL_EAV_FORM_ELEMENT_ATTRIBUTE_ID_WAL_EAV_ATTRIBUTE_ATTRIBUTE_ID` FOREIGN KEY (`attribute_id`) REFERENCES `wal_eav_attribute` (`attribute_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_FORM_ELEMENT_TYPE_ID_WAL_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `wal_eav_form_type` (`type_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_FORM_ELM_FSET_ID_WAL_EAV_FORM_FSET_FSET_ID` FOREIGN KEY (`fieldset_id`) REFERENCES `wal_eav_form_fieldset` (`fieldset_id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8 COMMENT='Eav Form Element';

--
-- Dumping data for table `wal_eav_form_element`
--

INSERT INTO `wal_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 `wal_eav_form_fieldset`
--

CREATE TABLE `wal_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 `WAL_EAV_FORM_FIELDSET_TYPE_ID_CODE` (`type_id`,`code`),
  CONSTRAINT `WAL_EAV_FORM_FIELDSET_TYPE_ID_WAL_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `wal_eav_form_type` (`type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset';

--
-- Dumping data for table `wal_eav_form_fieldset`
--


--
-- Table structure for table `wal_eav_form_fieldset_label`
--

CREATE TABLE `wal_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 `WAL_EAV_FORM_FIELDSET_LABEL_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_EAV_FORM_FIELDSET_LABEL_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_FORM_FSET_LBL_FSET_ID_WAL_EAV_FORM_FSET_FSET_ID` FOREIGN KEY (`fieldset_id`) REFERENCES `wal_eav_form_fieldset` (`fieldset_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Fieldset Label';

--
-- Dumping data for table `wal_eav_form_fieldset_label`
--


--
-- Table structure for table `wal_eav_form_type`
--

CREATE TABLE `wal_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 `WAL_EAV_FORM_TYPE_CODE_THEME_STORE_ID` (`code`,`theme`,`store_id`),
  KEY `WAL_EAV_FORM_TYPE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_EAV_FORM_TYPE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='Eav Form Type';

--
-- Dumping data for table `wal_eav_form_type`
--

INSERT INTO `wal_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 `wal_eav_form_type_entity`
--

CREATE TABLE `wal_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 `WAL_EAV_FORM_TYPE_ENTITY_ENTITY_TYPE_ID` (`entity_type_id`),
  CONSTRAINT `FK_AB56BF0F7C280AFDB152291214F76117` FOREIGN KEY (`entity_type_id`) REFERENCES `wal_eav_entity_type` (`entity_type_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EAV_FORM_TYPE_ENTITY_TYPE_ID_WAL_EAV_FORM_TYPE_TYPE_ID` FOREIGN KEY (`type_id`) REFERENCES `wal_eav_form_type` (`type_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Eav Form Type Entity';

--
-- Dumping data for table `wal_eav_form_type_entity`
--

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

--
-- Table structure for table `wal_email_abandoned_cart`
--

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

--
-- Dumping data for table `wal_email_abandoned_cart`
--


--
-- Table structure for table `wal_email_automation`
--

CREATE TABLE `wal_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 `WAL_EMAIL_AUTOMATION_AUTOMATION_TYPE` (`automation_type`),
  KEY `WAL_EMAIL_AUTOMATION_ENROLMENT_STATUS` (`enrolment_status`),
  KEY `WAL_EMAIL_AUTOMATION_TYPE_ID` (`type_id`),
  KEY `WAL_EMAIL_AUTOMATION_EMAIL` (`email`),
  KEY `WAL_EMAIL_AUTOMATION_PROGRAM_ID` (`program_id`),
  KEY `WAL_EMAIL_AUTOMATION_CREATED_AT` (`created_at`),
  KEY `WAL_EMAIL_AUTOMATION_UPDATED_AT` (`updated_at`),
  KEY `WAL_EMAIL_AUTOMATION_WEBSITE_ID` (`website_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Automation Status';

--
-- Dumping data for table `wal_email_automation`
--


--
-- Table structure for table `wal_email_campaign`
--

CREATE TABLE `wal_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 `WAL_EMAIL_CAMPAIGN_STORE_ID` (`store_id`),
  KEY `WAL_EMAIL_CAMPAIGN_CAMPAIGN_ID` (`campaign_id`),
  KEY `WAL_EMAIL_CAMPAIGN_EMAIL` (`email`),
  KEY `WAL_EMAIL_CAMPAIGN_SEND_ID` (`send_id`),
  KEY `WAL_EMAIL_CAMPAIGN_SEND_STATUS` (`send_status`),
  KEY `WAL_EMAIL_CAMPAIGN_CREATED_AT` (`created_at`),
  KEY `WAL_EMAIL_CAMPAIGN_UPDATED_AT` (`updated_at`),
  KEY `WAL_EMAIL_CAMPAIGN_SENT_AT` (`sent_at`),
  KEY `WAL_EMAIL_CAMPAIGN_EVENT_NAME` (`event_name`),
  KEY `WAL_EMAIL_CAMPAIGN_MESSAGE` (`message`),
  KEY `WAL_EMAIL_CAMPAIGN_QUOTE_ID` (`quote_id`),
  KEY `WAL_EMAIL_CAMPAIGN_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `WAL_EMAIL_CAMPAIGN_STORE_ID_CORE/STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Campaigns';

--
-- Dumping data for table `wal_email_campaign`
--


--
-- Table structure for table `wal_email_catalog`
--

CREATE TABLE `wal_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',
  `processed` smallint(5) unsigned NOT NULL COMMENT 'Product processed',
  `last_imported_at` timestamp NULL DEFAULT NULL COMMENT 'Last imported date',
  PRIMARY KEY (`id`),
  KEY `WAL_EMAIL_CATALOG_PRODUCT_ID` (`product_id`),
  KEY `WAL_EMAIL_CATALOG_IMPORTED` (`imported`),
  KEY `WAL_EMAIL_CATALOG_MODIFIED` (`modified`),
  KEY `WAL_EMAIL_CATALOG_CREATED_AT` (`created_at`),
  KEY `WAL_EMAIL_CATALOG_UPDATED_AT` (`updated_at`),
  KEY `WAL_EMAIL_CATALOG_PROCESSED` (`processed`),
  KEY `WAL_EMAIL_CATALOG_LAST_IMPORTED_AT` (`last_imported_at`),
  CONSTRAINT `WAL_EMAIL_CATALOG_PRODUCT_ID_CATALOG_PRODUCT_ENTITY_ENTITY_ID` FOREIGN KEY (`product_id`) REFERENCES `wal_catalog_product_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Connector Catalog';

--
-- Dumping data for table `wal_email_catalog`
--

INSERT INTO `wal_email_catalog` VALUES (1,1,NULL,NULL,'2020-06-11 02:55:10','2020-06-11 02:55:10',0,NULL);

--
-- Table structure for table `wal_email_contact`
--

CREATE TABLE `wal_email_contact` (
  `email_contact_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `is_guest` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Guest',
  `contact_id` varchar(15) DEFAULT NULL COMMENT 'Connector Contact ID',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `website_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Website ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT 'Customer Email',
  `is_subscriber` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Subscriber',
  `subscriber_status` smallint(5) unsigned DEFAULT NULL COMMENT 'Subscriber status',
  `email_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Imported',
  `subscriber_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Subscriber Imported',
  `suppressed` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Suppressed',
  `last_subscribed_at` timestamp NULL DEFAULT NULL COMMENT 'Last subscribed date',
  PRIMARY KEY (`email_contact_id`),
  KEY `WAL_EMAIL_CONTACT_EMAIL_CONTACT_ID` (`email_contact_id`),
  KEY `WAL_EMAIL_CONTACT_IS_GUEST` (`is_guest`),
  KEY `WAL_EMAIL_CONTACT_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_EMAIL_CONTACT_WEBSITE_ID` (`website_id`),
  KEY `WAL_EMAIL_CONTACT_IS_SUBSCRIBER` (`is_subscriber`),
  KEY `WAL_EMAIL_CONTACT_SUBSCRIBER_STATUS` (`subscriber_status`),
  KEY `WAL_EMAIL_CONTACT_EMAIL_IMPORTED` (`email_imported`),
  KEY `WAL_EMAIL_CONTACT_SUBSCRIBER_IMPORTED` (`subscriber_imported`),
  KEY `WAL_EMAIL_CONTACT_SUPPRESSED` (`suppressed`),
  KEY `WAL_EMAIL_CONTACT_EMAIL` (`email`),
  KEY `WAL_EMAIL_CONTACT_CONTACT_ID` (`contact_id`),
  CONSTRAINT `WAL_EMAIL_CONTACT_WEBSITE_ID_STORE_WEBSITE_WEBSITE_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Contacts';

--
-- Dumping data for table `wal_email_contact`
--


--
-- Table structure for table `wal_email_contact_consent`
--

CREATE TABLE `wal_email_contact_consent` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `email_contact_id` int(10) unsigned DEFAULT NULL COMMENT 'Email Contact Id',
  `consent_url` varchar(255) DEFAULT NULL COMMENT 'Contact consent url',
  `consent_datetime` datetime DEFAULT NULL COMMENT 'Contact consent datetime',
  `consent_ip` varchar(255) DEFAULT NULL COMMENT 'Contact consent ip',
  `consent_user_agent` varchar(255) DEFAULT NULL COMMENT 'Contact consent user agent',
  PRIMARY KEY (`id`),
  KEY `WAL_EMAIL_CONTACT_CONSENT_EMAIL_CONTACT_ID` (`email_contact_id`),
  CONSTRAINT `FK_BA6917F5F056DB3359E9688A33733EA1` FOREIGN KEY (`email_contact_id`) REFERENCES `wal_email_contact` (`email_contact_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email contact consent table.';

--
-- Dumping data for table `wal_email_contact_consent`
--


--
-- Table structure for table `wal_email_coupon_attribute`
--

CREATE TABLE `wal_email_coupon_attribute` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `salesrule_coupon_id` int(10) unsigned NOT NULL COMMENT 'Coupon ID',
  `email` varchar(255) DEFAULT NULL COMMENT 'Email',
  `expires_at` timestamp NULL DEFAULT NULL COMMENT 'Coupon expiration date',
  PRIMARY KEY (`id`),
  KEY `WAL_EMAIL_COUPON_ATTRIBUTE_COUPON_ID` (`salesrule_coupon_id`),
  KEY `WAL_EMAIL_COUPON_ATTRIBUTE_EMAIL` (`email`),
  CONSTRAINT `WAL_EMAIL_COUPON_ATTRIBUTE_COUPON_ID_SALESRULE_COUPON_COUPON_ID` FOREIGN KEY (`salesrule_coupon_id`) REFERENCES `wal_salesrule_coupon` (`coupon_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Dotdigital coupon attributes table';

--
-- Dumping data for table `wal_email_coupon_attribute`
--


--
-- Table structure for table `wal_email_failed_auth`
--

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

--
-- Dumping data for table `wal_email_failed_auth`
--


--
-- Table structure for table `wal_email_importer`
--

CREATE TABLE `wal_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 `WAL_EMAIL_IMPORTER_IMPORT_TYPE` (`import_type`),
  KEY `WAL_EMAIL_IMPORTER_WEBSITE_ID` (`website_id`),
  KEY `WAL_EMAIL_IMPORTER_IMPORT_STATUS` (`import_status`),
  KEY `WAL_EMAIL_IMPORTER_IMPORT_MODE` (`import_mode`),
  KEY `WAL_EMAIL_IMPORTER_CREATED_AT` (`created_at`),
  KEY `WAL_EMAIL_IMPORTER_UPDATED_AT` (`updated_at`),
  KEY `WAL_EMAIL_IMPORTER_IMPORT_ID` (`import_id`),
  KEY `WAL_EMAIL_IMPORTER_IMPORT_STARTED` (`import_started`),
  KEY `WAL_EMAIL_IMPORTER_IMPORT_FINISHED` (`import_finished`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Email Importer';

--
-- Dumping data for table `wal_email_importer`
--


--
-- Table structure for table `wal_email_order`
--

CREATE TABLE `wal_email_order` (
  `email_order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `order_id` int(10) unsigned NOT NULL COMMENT 'Order ID',
  `order_status` varchar(255) NOT NULL COMMENT 'Order Status',
  `quote_id` int(10) unsigned NOT NULL COMMENT 'Sales Quote ID',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store ID',
  `email_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Order Imported',
  `modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Is Order Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`email_order_id`),
  KEY `WAL_EMAIL_ORDER_STORE_ID` (`store_id`),
  KEY `WAL_EMAIL_ORDER_QUOTE_ID` (`quote_id`),
  KEY `WAL_EMAIL_ORDER_EMAIL_IMPORTED` (`email_imported`),
  KEY `WAL_EMAIL_ORDER_ORDER_STATUS` (`order_status`),
  KEY `WAL_EMAIL_ORDER_MODIFIED` (`modified`),
  KEY `WAL_EMAIL_ORDER_UPDATED_AT` (`updated_at`),
  KEY `WAL_EMAIL_ORDER_CREATED_AT` (`created_at`),
  KEY `WAL_EMAIL_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` (`order_id`),
  CONSTRAINT `WAL_EMAIL_ORDER_ORDER_ID_SALES_ORDER_ENTITY_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EMAIL_ORDER_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Transactional Order Data';

--
-- Dumping data for table `wal_email_order`
--


--
-- Table structure for table `wal_email_review`
--

CREATE TABLE `wal_email_review` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `review_id` int(10) unsigned NOT NULL COMMENT 'Review Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `review_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Review Imported',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `WAL_EMAIL_REVIEW_REVIEW_ID` (`review_id`),
  KEY `WAL_EMAIL_REVIEW_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_EMAIL_REVIEW_STORE_ID` (`store_id`),
  KEY `WAL_EMAIL_REVIEW_REVIEW_IMPORTED` (`review_imported`),
  KEY `WAL_EMAIL_REVIEW_CREATED_AT` (`created_at`),
  KEY `WAL_EMAIL_REVIEW_UPDATED_AT` (`updated_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Reviews';

--
-- Dumping data for table `wal_email_review`
--


--
-- Table structure for table `wal_email_rules`
--

CREATE TABLE `wal_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 `wal_email_rules`
--


--
-- Table structure for table `wal_email_template`
--

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

--
-- Dumping data for table `wal_email_template`
--

INSERT INTO `wal_email_template` VALUES (1,'New Pickup Order','<!--@subject {{trans \"Your %store_name order confirmation\" store_name=$store.getFrontendName()}} @-->\n<!--@vars {\n\"var order.getCustomerName()\":\"Customer Name\",\n\"var store.getFrontendName()\":\"Customer Name\",\n\"var is_pickup_order\":\"Check if order is a pickup order\",\n\"var $this.getUrl($store,\'customer/account/\',[_nosid:1]) |raw\":\"Gets the link to the Customer Account\",\n\"var store_email |raw\":\"Defined Email Address for this type of mails\",\n\"var store_phone |raw\":\"Defined Phone Number in the Store Information\",\n\"var store_hours |raw\":\"Defined Opening Hours Phone Number in the Store Information\",\n\"var order.increment_id |raw\":\"Order Id\",\n\"var order.getCreatedAtFormatted(2) |raw\":\"Get the date of order creation\",\n\"var order.getEmailCustomerNote()\":\"Email Order Note\",\n\"var formattedBillingAddress|raw\":\"Billing Address\",\n\"var order.getIsNotVirtual()\":\"Check if shipment exists\",\n\"var pickupAddress|raw\":\"Pickup Location Address\",\n\"var formattedShippingAddress|raw\":\"Customer Shipping Address\",\n\"var payment_html|raw\":\"Payment Details\",\n\"var order.getShippingDescription()\":\"Shipping Description\",\n\"var shipping_msg\":\"Shipping message\",\n\"layout handle=\\\"sales_email_order_items\\\" order=$order area=\\\"frontend\\\"\":\"Order Items Grid\"\n} @-->\n\n{{template config_path=\"design/email/header_template\"}}\n\n<table>\n    <tr class=\"email-intro\">\n        <td>\n            <p class=\"greeting\">{{trans \"%customer_name,\" customer_name=$order.getCustomerName()}}</p>\n            <p>\n                {{trans \"Thank you for your order from %store_name.\" store_name=$store.getFrontendName()}}\n                {{if is_pickup_order}}\n                    {{trans \"We will send you a notification once your items are ready for pickup.\"}}\n                {{else}}\n                    {{trans \"Once your package ships we will send you a tracking number.\"}}\n                {{/if}}\n                {{trans \'You can check the status of your order by <a href=\"%account_url\">logging into your account</a>.\' account_url=$this.getUrl($store,\'customer/account/\',[_nosid:1]) |raw}}\n            </p>\n            <p>\n                {{trans \'If you have questions about your order, you can email us at <a href=\"mailto:%store_email\">%store_email</a>\' store_email=$store_email |raw}}{{depend store_phone}} {{trans \' or call us at <a href=\"tel:%store_phone\">%store_phone</a>\' store_phone=$store_phone |raw}}{{/depend}}.\n                {{depend store_hours}}\n                {{trans \'Our hours are <span class=\"no-link\">%store_hours</span>.\' store_hours=$store_hours |raw}}\n                {{/depend}}\n            </p>\n        </td>\n    </tr>\n    <tr class=\"email-summary\">\n        <td>\n            <h1>{{trans \'Your Order <span class=\"no-link\">#%increment_id</span>\' increment_id=$order.increment_id |raw}}</h1>\n            <p>{{trans \'Placed on <span class=\"no-link\">%created_at</span>\' created_at=$order.getCreatedAtFormatted(2) |raw}}</p>\n        </td>\n    </tr>\n    <tr class=\"email-information\">\n        <td>\n            {{depend order.getEmailCustomerNote()}}\n            <table class=\"message-info\">\n                <tr>\n                    <td>\n                        {{var order.getEmailCustomerNote()|escape|nl2br}}\n                    </td>\n                </tr>\n            </table>\n            {{/depend}}\n            <table class=\"order-details\">\n                <tr>\n                    <td class=\"address-details\">\n                        <h3>{{trans \"Billing Info\"}}</h3>\n                        <p>{{var formattedBillingAddress|raw}}</p>\n                    </td>\n                    {{depend order.getIsNotVirtual()}}\n                    <td class=\"address-details\">\n                        <h3>{{trans \"Shipping Info\"}}</h3>\n                        {{if is_pickup_order}}\n                            <h4>{{trans \"Pickup Location\"}}</h4>\n                            <p>{{var pickupAddress|raw}}</p>\n                            <h4>{{trans \"Recipient Address\"}}</h4>\n                        {{/if}}\n                        <p>{{var formattedShippingAddress|raw}}</p>\n                    </td>\n                    {{/depend}}\n                </tr>\n                <tr>\n                    <td class=\"method-info\">\n                        <h3>{{trans \"Payment Method\"}}</h3>\n                        {{var payment_html|raw}}\n                    </td>\n                    {{depend order.getIsNotVirtual()}}\n                    <td class=\"method-info\">\n                        <h3>{{trans \"Shipping Method\"}}</h3>\n                        <p>{{var order.getShippingDescription()}}</p>\n                        {{if shipping_msg}}\n                        <p>{{var shipping_msg}}</p>\n                        {{/if}}\n                    </td>\n                    {{/depend}}\n                </tr>\n            </table>\n            {{layout handle=\"sales_email_order_items\" order=$order area=\"frontend\"}}\n        </td>\n    </tr>\n</table>\n\n{{template config_path=\"design/email/footer_template\"}}\n',NULL,2,'{{trans \"Your %store_name order confirmation\" store_name=$store.getFrontendName()}}',NULL,NULL,'2020-06-08 06:38:38','2020-06-11 05:40:36','sales_email_order_template','{\"var formattedBillingAddress|raw\":\"Billing Address\",\"var order.getEmailCustomerNote()\":\"Email Order Note\",\"var order.increment_id\":\"Order Id\",\"layout handle=\\\"sales_email_order_items\\\" order=$order area=\\\"frontend\\\"\":\"Order Items Grid\",\"var payment_html|raw\":\"Payment Details\",\"var formattedShippingAddress|raw\":\"Shipping Address\",\"var order.getShippingDescription()\":\"Shipping Description\",\"var shipping_msg\":\"Shipping message\"}',1),(2,'New Pickup Order For Guest','<!--@subject {{trans \"Your %store_name order confirmation\" store_name=$store.getFrontendName()}} @-->\n<!--@vars {\n\"var order.getBillingAddress().getName()\":\"Guest Customer Name\",\n\"var store.getFrontendName()\":\"Customer Name\",\n\"var is_pickup_order\":\"Check if order is a pickup order\",\n\"var store_email |raw\":\"Defined Email Address for this type of mails\",\n\"var store_phone |raw\":\"Defined Phone Number in the Store Information\",\n\"var store_hours |raw\":\"Defined Opening Hours Phone Number in the Store Information\",\n\"var order.increment_id |raw\":\"Order Id\",\n\"var order.getCreatedAtFormatted(2) |raw\":\"Get the date of order creation\",\n\"var order.getEmailCustomerNote()\":\"Email Order Note\",\n\"var formattedBillingAddress|raw\":\"Billing Address\",\n\"var order.getIsNotVirtual()\":\"Check if shipment exists\",\n\"var pickupAddress|raw\":\"Pickup Location Address\",\n\"var formattedShippingAddress|raw\":\"Customer Shipping Address\",\n\"var payment_html|raw\":\"Payment Details\",\n\"var order.getShippingDescription()\":\"Shipping Description\",\n\"var shipping_msg\":\"Shipping message\",\n\"layout handle=\\\"sales_email_order_items\\\" order=$order area=\\\"frontend\\\"\":\"Order Items Grid\"\n} @-->\n\n{{template config_path=\"design/email/header_template\"}}\n\n<table>\n    <tr class=\"email-intro\">\n        <td>\n            <p class=\"greeting\">{{trans \"%name,\" name=$order.getBillingAddress().getName()}}</p>\n            <p>\n                {{trans \"Thank you for your order from %store_name.\" store_name=$store.getFrontendName()}}\n                {{if is_pickup_order}}\n                    {{trans \"We will send you a notification once your items are ready for pickup.\"}}\n                {{else}}\n                    {{trans \"Once your package ships we will send an email with a link to track your order.\"}}\n                {{/if}}\n                {{trans \'If you have questions about your order, you can email us at <a href=\"mailto:%store_email\">%store_email</a>\' store_email=$store_email |raw}}{{depend store_phone}} {{trans \' or call us at <a href=\"tel:%store_phone\">%store_phone</a>\' store_phone=$store_phone |raw}}{{/depend}}.\n                {{depend store_hours}}\n                    {{trans \'Our hours are <span class=\"no-link\">%store_hours</span>.\' store_hours=$store_hours |raw}}\n                {{/depend}}\n            </p>\n        </td>\n    </tr>\n    <tr class=\"email-summary\">\n        <td>\n            <h1>{{trans \'Your Order <span class=\"no-link\">#%increment_id</span>\' increment_id=$order.increment_id |raw}}</h1>\n            <p>{{trans \'Placed on <span class=\"no-link\">%created_at</span>\' created_at=$order.getCreatedAtFormatted(2) |raw}}</p>\n        </td>\n    </tr>\n    <tr class=\"email-information\">\n        <td>\n            {{depend order.getEmailCustomerNote()}}\n            <table class=\"message-info\">\n                <tr>\n                    <td>\n                        {{var order.getEmailCustomerNote()|escape|nl2br}}\n                    </td>\n                </tr>\n            </table>\n            {{/depend}}\n            <table class=\"order-details\">\n                <tr>\n                    <td class=\"address-details\">\n                        <h3>{{trans \"Billing Info\"}}</h3>\n                        <p>{{var formattedBillingAddress|raw}}</p>\n                    </td>\n                    {{depend order.getIsNotVirtual()}}\n                    <td class=\"address-details\">\n                        <h3>{{trans \"Shipping Info\"}}</h3>\n                        {{if is_pickup_order}}\n                            <h4>{{trans \"Pickup Location\"}}</h4>\n                            <p>{{var pickupAddress|raw}}</p>\n                            <h4>{{trans \"Recipient Address\"}}</h4>\n                        {{/if}}\n                        <p>{{var formattedShippingAddress|raw}}</p>\n                    </td>\n                    {{/depend}}\n                </tr>\n                <tr>\n                    <td class=\"method-info\">\n                        <h3>{{trans \"Payment Method\"}}</h3>\n                        {{var payment_html|raw}}\n                    </td>\n                    {{depend order.getIsNotVirtual()}}\n                    <td class=\"method-info\">\n                        <h3>{{trans \"Shipping Method\"}}</h3>\n                        <p>{{var order.getShippingDescription()}}</p>\n                        {{if shipping_msg}}\n                        <p>{{var shipping_msg}}</p>\n                        {{/if}}\n                    </td>\n                    {{/depend}}\n                </tr>\n            </table>\n            {{layout handle=\"sales_email_order_items\" order=$order}}\n        </td>\n    </tr>\n</table>\n\n{{template config_path=\"design/email/footer_template\"}}\n',NULL,2,'{{trans \"Your %store_name order confirmation\" store_name=$store.getFrontendName()}}',NULL,NULL,'2020-06-08 06:38:38','2020-06-11 05:40:36','sales_email_order_guest_template','{\"var formattedBillingAddress|raw\":\"Billing Address\",\"var order.getEmailCustomerNote()\":\"Email Order Note\",\"var order.getBillingAddress().getName()\":\"Guest Customer Name\",\"var order.getCreatedAtFormatted(2)\":\"Order Created At (datetime)\",\"var order.increment_id\":\"Order Id\",\"layout handle=\\\"sales_email_order_items\\\" order=$order\":\"Order Items Grid\",\"var payment_html|raw\":\"Payment Details\",\"var formattedShippingAddress|raw\":\"Shipping Address\",\"var order.getShippingDescription()\":\"Shipping Description\",\"var shipping_msg\":\"Shipping message\"}',1),(3,'Amasty Successful Feed Generation','<!--@subject Amasty Successful Feed Generation  @-->\n<!--@vars\n{\"store url=\\\"\\\"\":\"Store Url\",\n\"var logo_url\":\"Email Logo Image Url\",\n\"var logo_alt\":\"Email Logo Image Alt\",\n\"var store.getFrontendName()\":\"Store Name\",\n\"var feed_id\":\"Feed Id\",\n\"var feed_name\":\"Feed Name\",\n\"var date_time\":\"Date and time of generation feed\",\n\"var generation_error\":\"Generation Error\"\n}\n@-->\n{{template config_path=\"design/email/header_template\"}}\n<table class=\"container bord_color am-winter-template\" cellpadding=\"0\" cellspacing=\"0\">\n    <tr class=\"email-head\">\n        <td align=\"center\" valign=\"top\">\n            <table class=\"table-head am-fullwidth\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tr>\n                    <td class=\"am-head\">\n                        <p class=\"am-email-text\">\n                            Hello,<br/>\n                            Your feed {{var feed_id}}, {{var feed_name}} was generated successfully in {{var date_time}}.<br/>\n                            For download feed manually, please visit admin panel.<br/>\n                            Thanks,<br/>\n                            {{var store.getFrontendName()}}</p>\n                    </td>\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>\n{{template config_path=\"design/email/footer_template\"}}\n',NULL,2,'Amasty Successful Feed Generation',NULL,NULL,'2022-01-28 09:36:06','2022-01-28 09:36:06','amasty_feed_notifications_success_template','{\"store url=\\\"\\\"\":\"Store Url\",\n\"var logo_url\":\"Email Logo Image Url\",\n\"var logo_alt\":\"Email Logo Image Alt\",\n\"var store.getFrontendName()\":\"Store Name\",\n\"var feed_id\":\"Feed Id\",\n\"var feed_name\":\"Feed Name\",\n\"var date_time\":\"Date and time of generation feed\",\n\"var generation_error\":\"Generation Error\"\n}\n',0),(4,'Amasty Unsuccessful Feed Generation','<!--@subject Amasty Unsuccessful Feed Generation  @-->\n<!--@vars\n{\"store url=\\\"\\\"\":\"Store Url\",\n\"var logo_url\":\"Email Logo Image Url\",\n\"var logo_alt\":\"Email Logo Image Alt\",\n\"var store.getFrontendName()\":\"Store Name\",\n\"var feed_id\":\"Feed Id\",\n\"var feed_name\":\"Feed Name\",\n\"var date_time\":\"Date and time of generation feed\",\n\"var generation_error\":\"Generation Error\"\n}\n@-->\n{{template config_path=\"design/email/header_template\"}}\n<table class=\"container bord_color am-winter-template\" cellpadding=\"0\" cellspacing=\"0\">\n    <tr class=\"email-head\">\n        <td align=\"center\" valign=\"top\">\n            <table class=\"table-head am-fullwidth\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">\n                <tr>\n                    <td class=\"am-head\">\n                        <p class=\"am-email-text\">\n                            Hello,<br/>\n                            When generating the feed {{var feed_id}}, {{var feed_name}} dated {{var date_time}}, the errors occurred:<br/>\n                            {{var generation_error}}<br/>\n                            For more details, please visit admin panel.<br/>\n                            Thanks,<br/>\n                            {{var store.getFrontendName()}}</p>\n                    </td>\n                </tr>\n            </table>\n        </td>\n    </tr>\n</table>\n{{template config_path=\"design/email/footer_template\"}}\n',NULL,2,'Amasty Unsuccessful Feed Generation',NULL,NULL,'2022-01-28 09:36:06','2022-01-28 09:36:06','amasty_feed_notifications_unsuccess_template','{\"store url=\\\"\\\"\":\"Store Url\",\n\"var logo_url\":\"Email Logo Image Url\",\n\"var logo_alt\":\"Email Logo Image Alt\",\n\"var store.getFrontendName()\":\"Store Name\",\n\"var feed_id\":\"Feed Id\",\n\"var feed_name\":\"Feed Name\",\n\"var date_time\":\"Date and time of generation feed\",\n\"var generation_error\":\"Generation Error\"\n}\n',0);

--
-- Table structure for table `wal_email_wishlist`
--

CREATE TABLE `wal_email_wishlist` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `wishlist_id` int(10) unsigned NOT NULL COMMENT 'Wishlist Id',
  `item_count` int(10) unsigned NOT NULL COMMENT 'Item Count',
  `customer_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer ID',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `wishlist_imported` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Wishlist Imported',
  `wishlist_modified` smallint(5) unsigned DEFAULT NULL COMMENT 'Wishlist Modified',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Update Time',
  PRIMARY KEY (`id`),
  KEY `WAL_EMAIL_WISHLIST_WISHLIST_ID` (`wishlist_id`),
  KEY `WAL_EMAIL_WISHLIST_ITEM_COUNT` (`item_count`),
  KEY `WAL_EMAIL_WISHLIST_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_EMAIL_WISHLIST_WISHLIST_MODIFIED` (`wishlist_modified`),
  KEY `WAL_EMAIL_WISHLIST_WISHLIST_IMPORTED` (`wishlist_imported`),
  KEY `WAL_EMAIL_WISHLIST_CREATED_AT` (`created_at`),
  KEY `WAL_EMAIL_WISHLIST_UPDATED_AT` (`updated_at`),
  KEY `WAL_EMAIL_WISHLIST_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_EMAIL_WISHLIST_CUSTOMER_ID_CUSTOMER_ENTITY_ENTITY_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_EMAIL_WISHLIST_WISHLIST_ID_WISHLIST_WISHLIST_ID` FOREIGN KEY (`wishlist_id`) REFERENCES `wal_wishlist` (`wishlist_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Connector Wishlist';

--
-- Dumping data for table `wal_email_wishlist`
--


--
-- Table structure for table `wal_facebook_business_extension_config`
--

CREATE TABLE `wal_facebook_business_extension_config` (
  `config_key` varchar(255) NOT NULL COMMENT 'Config Key',
  `config_value` varchar(255) NOT NULL DEFAULT '' COMMENT 'Config Value',
  `creation_time` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  `update_time` timestamp NULL DEFAULT NULL COMMENT 'Modification Time',
  PRIMARY KEY (`config_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_facebook_business_extension_config';

--
-- Dumping data for table `wal_facebook_business_extension_config`
--


--
-- Table structure for table `wal_flag`
--

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

--
-- Dumping data for table `wal_flag`
--

INSERT INTO `wal_flag` VALUES (2,'report_order_aggregated',0,NULL,'2021-08-27 00:00:03'),(3,'report_invoiced_aggregated',0,NULL,'2021-08-27 00:00:03'),(4,'report_refunded_aggregated',0,NULL,'2021-08-27 00:00:03'),(5,'report_bestsellers_aggregated',0,NULL,'2021-08-27 00:00:03'),(6,'report_shipping_aggregated',0,NULL,'2021-08-27 00:00:23'),(7,'report_coupons_aggregated',0,NULL,'2021-08-27 00:00:24'),(8,'report_tax_aggregated',0,NULL,'2021-08-27 00:00:24'),(9,'analytics_file_info',0,'{\"initializationVector\":\"4hnqzGNll8wYaZS4o5EwDA==\",\"path\":\"analytics\\/919943c5673b0489be684fbe214002357b445763e8db8e66cdac406b6b53d7d9\\/data.tgz\"}','2021-03-18 02:00:02'),(13,'log_rotation',0,'1630029663','2021-08-27 02:01:03'),(14,'m55366',0,'\"eyJzdGF0dXMiOiJhY3RpdmUiLCJtZXNzYWdlIjoiIiwiZmxhZyI6InJlYWwiLCJ0aW1lIjoxNjQ4MDkwMTAyfQ==\"','2022-03-24 02:48:22'),(15,'report_points',0,NULL,'2021-12-24 06:29:57'),(16,'config_hash',0,'{\"system\":\"a927238a50d1eb492ab71e4af548382a33b1decc\"}','2024-02-06 06:06:19'),(17,'system_config_snapshot',0,'{\"default\":{\"web\":{\"secure\":{\"base_url\":\"https:\\/\\/djf.wal-land.com.cn\\/magento2-4-3\\/\"}}}}','2024-02-06 06:06:19');

--
-- Table structure for table `wal_flurrybox_enhancedprivacy_cleanup_schedule`
--

CREATE TABLE `wal_flurrybox_enhancedprivacy_cleanup_schedule` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Schedule Id',
  `scheduled_at` timestamp NULL DEFAULT NULL COMMENT 'Scheduled At',
  `customer_id` int(11) NOT NULL COMMENT 'Customer Id',
  `type` varchar(255) NOT NULL COMMENT 'Type',
  `reason_id` int(11) NOT NULL COMMENT 'Reason Id',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_FLURRYBOX_ENHANCEDPRIVACY_CLEANUP_SCHEDULE_CUSTOMER_ID` (`customer_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Account Cleanup Schedule';

--
-- Dumping data for table `wal_flurrybox_enhancedprivacy_cleanup_schedule`
--


--
-- Table structure for table `wal_flurrybox_enhancedprivacy_delete_reasons`
--

CREATE TABLE `wal_flurrybox_enhancedprivacy_delete_reasons` (
  `id` smallint(5) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Reason Id',
  `reason` text NOT NULL COMMENT 'Reason',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Created At',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Deletion Reasons';

--
-- Dumping data for table `wal_flurrybox_enhancedprivacy_delete_reasons`
--


--
-- Table structure for table `wal_gift_message`
--

CREATE TABLE `wal_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 `wal_gift_message`
--


--
-- Table structure for table `wal_googleoptimizer_code`
--

CREATE TABLE `wal_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 `WAL_GOOGLEOPTIMIZER_CODE_STORE_ID_ENTITY_ID_ENTITY_TYPE` (`store_id`,`entity_id`,`entity_type`),
  CONSTRAINT `WAL_GOOGLEOPTIMIZER_CODE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Google Experiment code';

--
-- Dumping data for table `wal_googleoptimizer_code`
--


--
-- Table structure for table `wal_import_history`
--

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

--
-- Dumping data for table `wal_import_history`
--


--
-- Table structure for table `wal_importexport_importdata`
--

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

--
-- Dumping data for table `wal_importexport_importdata`
--


--
-- Table structure for table `wal_indexer_state`
--

CREATE TABLE `wal_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 `WAL_INDEXER_STATE_INDEXER_ID` (`indexer_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COMMENT='Indexer State';

--
-- Dumping data for table `wal_indexer_state`
--

INSERT INTO `wal_indexer_state` VALUES (1,'design_config_grid','valid','2024-02-06 07:19:53','48b045a224ce4c9dc7fa56040ec779c5'),(2,'customer_grid','valid','2024-02-06 07:19:53','7bc4c4cc127965e4ba75670af30bbf3a'),(3,'catalog_category_product','valid','2024-02-06 07:19:54','9d285258fb54a703a519eeec98202751'),(4,'catalog_product_category','valid','2024-02-06 07:19:54','dd4b80120f59a0a5bfdf645f495cff42'),(5,'catalogrule_rule','valid','2024-02-06 07:19:54','a56a1fa49c711ddb5a2735e164351fc0'),(6,'catalog_product_attribute','valid','2024-02-06 07:19:54','0b0ded6904c17a40c47786170eaefdec'),(7,'inventory','valid','2024-02-06 07:19:54','b0a3858bc558264fc5ef72e11ea10c2d'),(8,'catalogrule_product','valid','2024-02-06 07:19:54','c8ac5f6264bc7708ede28ad010eeacc4'),(9,'cataloginventory_stock','valid','2024-02-06 07:19:54','7f1c73f67ce86bd5cd328e5a4cee18f3'),(10,'catalog_product_price','valid','2024-02-06 07:19:54','d58621c9e421e97d47c6d11bc6f4ca8a'),(11,'catalogsearch_fulltext','invalid','2024-02-06 07:19:54','6d118e1420f2a869c67fad17c1a00b70'),(26,'salesrule_rule','valid','2024-02-06 07:19:54','5bd367b9e495ed2a92cd2995a330d3e5'),(27,'amasty_sorting_bestseller','valid','2024-02-06 07:19:55','79cee52cecb149a9756e19026b9ea3f2'),(28,'amasty_sorting_most_viewed','invalid','2024-02-06 07:21:05','90bad66d282ec41057ace7ffc63fe041'),(29,'amasty_sorting_wished','valid','2024-02-06 07:19:55','3f460222bc896818a9f6539e03f5016c'),(30,'amasty_tabs_tab_product','valid','2024-02-06 07:19:54','611f15dae813cc44fcb92d76a217968c'),(31,'amasty_tabs_product_tab','valid','2024-02-06 07:19:54','c7c3aa3c60e5a5687bd651411c10655e'),(34,'amasty_feed_entity','valid','2024-02-06 07:19:55','2c6fec40665e08fb2d824c4464c00487'),(35,'amasty_feed_product','valid','2024-02-06 07:19:55','dbf1c06c0e6f405723cdda40da876f05');

--
-- Table structure for table `wal_integration`
--

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

--
-- Dumping data for table `wal_integration`
--

INSERT INTO `wal_integration` VALUES (1,'Magento Analytics user','',NULL,1,1,'2020-06-08 08:00:07','2020-06-08 08:00:08',0,NULL);

--
-- Table structure for table `wal_inventory_cl`
--

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

--
-- Dumping data for table `wal_inventory_cl`
--


--
-- Table structure for table `wal_inventory_geoname`
--

CREATE TABLE `wal_inventory_geoname` (
  `country_code` varchar(64) NOT NULL,
  `postcode` varchar(64) NOT NULL,
  `city` varchar(180) NOT NULL,
  `region` varchar(100) NOT NULL,
  `province` varchar(64) NOT NULL,
  `latitude` double NOT NULL,
  `longitude` double NOT NULL,
  `entity_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'entity id',
  PRIMARY KEY (`entity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_geoname`
--


--
-- Table structure for table `wal_inventory_low_stock_notification_configuration`
--

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

--
-- Dumping data for table `wal_inventory_low_stock_notification_configuration`
--

INSERT INTO `wal_inventory_low_stock_notification_configuration` VALUES ('default','demo product',NULL);

--
-- Table structure for table `wal_inventory_order_notification`
--

CREATE TABLE `wal_inventory_order_notification` (
  `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Order ID',
  `notification_sent` smallint(6) NOT NULL COMMENT 'Has Notification Been Sent For Order',
  `send_notification` smallint(6) NOT NULL COMMENT 'Should Notification Be Send For Order',
  PRIMARY KEY (`order_id`),
  CONSTRAINT `WAL_INV_ORDER_NTFC_ORDER_ID_WAL_SALES_ORDER_ENTT_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_order_notification`
--


--
-- Table structure for table `wal_inventory_pickup_location_order`
--

CREATE TABLE `wal_inventory_pickup_location_order` (
  `order_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Order ID',
  `pickup_location_code` varchar(255) NOT NULL COMMENT 'Pickup Location Code',
  PRIMARY KEY (`order_id`),
  CONSTRAINT `WAL_INV_PICKUP_LOCATION_ORDER_ORDER_ID_WAL_SALES_ORDER_ENTT_ID` FOREIGN KEY (`order_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_pickup_location_order`
--


--
-- Table structure for table `wal_inventory_pickup_location_quote_address`
--

CREATE TABLE `wal_inventory_pickup_location_quote_address` (
  `address_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Quote Address ID',
  `pickup_location_code` varchar(255) NOT NULL COMMENT 'Pickup Location Code',
  PRIMARY KEY (`address_id`),
  CONSTRAINT `FK_64D43D67B39C4320ED5ED6AB71487677` FOREIGN KEY (`address_id`) REFERENCES `wal_quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_pickup_location_quote_address`
--


--
-- Table structure for table `wal_inventory_reservation`
--

CREATE TABLE `wal_inventory_reservation` (
  `reservation_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stock_id` int(10) unsigned NOT NULL,
  `sku` varchar(64) NOT NULL,
  `quantity` decimal(10,4) NOT NULL DEFAULT '0.0000',
  `metadata` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`reservation_id`),
  KEY `WAL_INVENTORY_RESERVATION_STOCK_ID_SKU_QUANTITY` (`stock_id`,`sku`,`quantity`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_reservation`
--

INSERT INTO `wal_inventory_reservation` VALUES (1,1,'demo product',-1.0000,'{\"event_type\":\"order_placed\",\"object_type\":\"order\",\"object_id\":\"\",\"object_increment_id\":\"000000002\"}');

--
-- Table structure for table `wal_inventory_shipment_source`
--

CREATE TABLE `wal_inventory_shipment_source` (
  `shipment_id` int(10) unsigned NOT NULL,
  `source_code` varchar(255) NOT NULL,
  PRIMARY KEY (`shipment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_shipment_source`
--


--
-- Table structure for table `wal_inventory_source`
--

CREATE TABLE `wal_inventory_source` (
  `source_code` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `enabled` smallint(5) unsigned NOT NULL DEFAULT '1',
  `description` text,
  `latitude` decimal(8,6) DEFAULT NULL,
  `longitude` decimal(9,6) DEFAULT NULL,
  `country_id` varchar(2) NOT NULL,
  `region_id` int(10) unsigned DEFAULT NULL,
  `region` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `street` varchar(255) DEFAULT NULL,
  `postcode` varchar(255) NOT NULL,
  `contact_name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `fax` varchar(255) DEFAULT NULL,
  `use_default_carrier_config` smallint(5) unsigned NOT NULL DEFAULT '1',
  `is_pickup_location_active` tinyint(1) NOT NULL DEFAULT '0',
  `frontend_name` varchar(255) DEFAULT '',
  `frontend_description` text,
  PRIMARY KEY (`source_code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_source`
--

INSERT INTO `wal_inventory_source` VALUES ('default','Default Source',1,'Default Source',0.000000,0.000000,'US',NULL,NULL,NULL,NULL,'00000',NULL,NULL,NULL,NULL,1,0,'',NULL);

--
-- Table structure for table `wal_inventory_source_carrier_link`
--

CREATE TABLE `wal_inventory_source_carrier_link` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `source_code` varchar(255) NOT NULL,
  `carrier_code` varchar(255) NOT NULL,
  `position` smallint(5) unsigned DEFAULT NULL,
  PRIMARY KEY (`link_id`),
  KEY `FK_8AB9C4CDD40D9DF507845C9737A8F019` (`source_code`),
  CONSTRAINT `FK_8AB9C4CDD40D9DF507845C9737A8F019` FOREIGN KEY (`source_code`) REFERENCES `wal_inventory_source` (`source_code`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_source_carrier_link`
--


--
-- Table structure for table `wal_inventory_source_item`
--

CREATE TABLE `wal_inventory_source_item` (
  `source_item_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `source_code` varchar(255) NOT NULL,
  `sku` varchar(64) NOT NULL,
  `quantity` decimal(12,4) NOT NULL DEFAULT '0.0000',
  `status` smallint(5) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`source_item_id`),
  UNIQUE KEY `WAL_INVENTORY_SOURCE_ITEM_SOURCE_CODE_SKU` (`source_code`,`sku`),
  KEY `WAL_INVENTORY_SOURCE_ITEM_SKU_SOURCE_CODE_QUANTITY` (`sku`,`source_code`,`quantity`),
  CONSTRAINT `WAL_INV_SOURCE_ITEM_SOURCE_CODE_WAL_INV_SOURCE_SOURCE_CODE` FOREIGN KEY (`source_code`) REFERENCES `wal_inventory_source` (`source_code`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_source_item`
--

INSERT INTO `wal_inventory_source_item` VALUES (1,'default','demo product',100.0000,1);
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`djfwalland_walland`@`localhost`*/ /*!50003 TRIGGER trg_wal_inventory_source_item_after_insert AFTER INSERT ON wal_inventory_source_item FOR EACH ROW
BEGIN
INSERT IGNORE INTO `wal_inventory_cl` (`entity_id`) VALUES (NEW.`source_item_id`);
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`djfwalland_walland`@`localhost`*/ /*!50003 TRIGGER trg_wal_inventory_source_item_after_update AFTER UPDATE ON wal_inventory_source_item FOR EACH ROW
BEGIN
IF (NOT(NEW.`source_item_id` <=> OLD.`source_item_id`) OR NOT(NEW.`source_code` <=> OLD.`source_code`) OR NOT(NEW.`sku` <=> OLD.`sku`) OR NOT(NEW.`quantity` <=> OLD.`quantity`) OR NOT(NEW.`status` <=> OLD.`status`)) THEN INSERT IGNORE INTO `wal_inventory_cl` (`entity_id`) VALUES (NEW.`source_item_id`); END IF;
END */;;
DELIMITER ;
DELIMITER ;;
/*!50003 CREATE*/ /*!50017 DEFINER=`djfwalland_walland`@`localhost`*/ /*!50003 TRIGGER trg_wal_inventory_source_item_after_delete AFTER DELETE ON wal_inventory_source_item FOR EACH ROW
BEGIN
INSERT IGNORE INTO `wal_inventory_cl` (`entity_id`) VALUES (OLD.`source_item_id`);
END */;;
DELIMITER ;

--
-- Table structure for table `wal_inventory_source_stock_link`
--

CREATE TABLE `wal_inventory_source_stock_link` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `stock_id` int(10) unsigned NOT NULL,
  `source_code` varchar(255) NOT NULL,
  `priority` smallint(5) unsigned NOT NULL,
  PRIMARY KEY (`link_id`),
  UNIQUE KEY `WAL_INVENTORY_SOURCE_STOCK_LINK_STOCK_ID_SOURCE_CODE` (`stock_id`,`source_code`),
  KEY `WAL_INV_SOURCE_STOCK_LNK_SOURCE_CODE_WAL_INV_SOURCE_SOURCE_CODE` (`source_code`),
  KEY `WAL_INVENTORY_SOURCE_STOCK_LINK_STOCK_ID_PRIORITY` (`stock_id`,`priority`),
  CONSTRAINT `WAL_INV_SOURCE_STOCK_LNK_SOURCE_CODE_WAL_INV_SOURCE_SOURCE_CODE` FOREIGN KEY (`source_code`) REFERENCES `wal_inventory_source` (`source_code`) ON DELETE CASCADE,
  CONSTRAINT `WAL_INV_SOURCE_STOCK_LNK_STOCK_ID_WAL_INV_STOCK_STOCK_ID` FOREIGN KEY (`stock_id`) REFERENCES `wal_inventory_stock` (`stock_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_source_stock_link`
--

INSERT INTO `wal_inventory_source_stock_link` VALUES (1,1,'default',1);

--
-- Table structure for table `wal_inventory_stock`
--

CREATE TABLE `wal_inventory_stock` (
  `stock_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`stock_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_stock`
--

INSERT INTO `wal_inventory_stock` VALUES (1,'Default Stock');

--
-- Temporary table structure for view `wal_inventory_stock_1`
--

/*!50001 DROP VIEW IF EXISTS `wal_inventory_stock_1`*/;
/*!50001 CREATE VIEW `wal_inventory_stock_1` AS SELECT 
 1 AS `product_id`,
 1 AS `website_id`,
 1 AS `stock_id`,
 1 AS `quantity`,
 1 AS `is_salable`,
 1 AS `sku`*/;

--
-- Table structure for table `wal_inventory_stock_sales_channel`
--

CREATE TABLE `wal_inventory_stock_sales_channel` (
  `type` varchar(64) NOT NULL,
  `code` varchar(64) NOT NULL,
  `stock_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`type`,`code`),
  KEY `WAL_INV_STOCK_SALES_CHANNEL_STOCK_ID_WAL_INV_STOCK_STOCK_ID` (`stock_id`),
  CONSTRAINT `WAL_INV_STOCK_SALES_CHANNEL_STOCK_ID_WAL_INV_STOCK_STOCK_ID` FOREIGN KEY (`stock_id`) REFERENCES `wal_inventory_stock` (`stock_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `wal_inventory_stock_sales_channel`
--

INSERT INTO `wal_inventory_stock_sales_channel` VALUES ('website','base',1);

--
-- Table structure for table `wal_layout_link`
--

CREATE TABLE `wal_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 `WAL_LAYOUT_LINK_LAYOUT_UPDATE_ID` (`layout_update_id`),
  KEY `WAL_LAYOUT_LINK_STORE_ID_THEME_ID_LAYOUT_UPDATE_ID_IS_TEMPORARY` (`store_id`,`theme_id`,`layout_update_id`,`is_temporary`),
  KEY `WAL_LAYOUT_LINK_THEME_ID_WAL_THEME_THEME_ID` (`theme_id`),
  CONSTRAINT `WAL_LAYOUT_LINK_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_LAYOUT_LINK_THEME_ID_WAL_THEME_THEME_ID` FOREIGN KEY (`theme_id`) REFERENCES `wal_theme` (`theme_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_LYT_LNK_LYT_UPDATE_ID_WAL_LYT_UPDATE_LYT_UPDATE_ID` FOREIGN KEY (`layout_update_id`) REFERENCES `wal_layout_update` (`layout_update_id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Layout Link';

--
-- Dumping data for table `wal_layout_link`
--

INSERT INTO `wal_layout_link` VALUES (1,0,21,1,0),(2,0,21,2,0),(3,0,21,3,0),(4,0,21,4,0),(5,0,21,5,0),(6,0,21,6,0),(7,0,21,7,0),(8,0,21,8,0),(9,0,21,9,0),(10,0,21,10,0);

--
-- Table structure for table `wal_layout_update`
--

CREATE TABLE `wal_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 `WAL_LAYOUT_UPDATE_HANDLE` (`handle`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COMMENT='Layout Updates';

--
-- Dumping data for table `wal_layout_update`
--

INSERT INTO `wal_layout_update` VALUES (1,'default','<body><referenceContainer name=\"menu.container\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"9GPedlD5zDC67IiASUyM57NMcOOgrIlf\" 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>',1,'0000-00-00 00:00:00'),(2,'cms_index_index','<body><referenceContainer name=\"content.top.right\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"IeB6pjpmIheqHSStzGjgGNUPoq4HtR23\" 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'),(3,'cms_index_index','<body><referenceContainer name=\"content\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"sgrtMlWPbVDPbxaJrBulE2cA8WnxuAef\" 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,'cms_index_index','<body><referenceContainer name=\"content\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"sPmKVfQ9y7i3WhiUg9NNQj2utDUvjdTq\" 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>',2,'0000-00-00 00:00:00'),(5,'cms_index_index','<body><referenceContainer name=\"content\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"O9il55Z52sfFR5DsQOMEYjm7g1WRNEcH\" 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>',3,'0000-00-00 00:00:00'),(6,'cms_index_index','<body><referenceContainer name=\"content\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"pI1IKwqkRzfDRMl62l20lGF5iwlx9ehE\" 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>',4,'0000-00-00 00:00:00'),(7,'cms_index_index','<body><referenceContainer name=\"content\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"WeJwg2EuEVxtbLhda1nESnjV636G1mio\" 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>',5,'0000-00-00 00:00:00'),(8,'default','<body><referenceContainer name=\"footer.content.top\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"BrErOMUJVeSaTTIh1GNWJ8jut8tT2ytr\" 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,'default','<body><referenceContainer name=\"footer.container.wrapper\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"XKVwSluOzzHOLZIM6rIvsPN5E3SSiImS\" 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,'default','<body><referenceContainer name=\"footer.custom.block\"><block class=\"Magento\\Cms\\Block\\Widget\\Block\" name=\"9V9hFrFdjlPjNNC0eCuOGs9KsgA6MPSv\" 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>',1,'0000-00-00 00:00:00');

--
-- Table structure for table `wal_login_as_customer`
--

CREATE TABLE `wal_login_as_customer` (
  `secret` varchar(64) NOT NULL COMMENT 'Login Secret',
  `customer_id` int(11) NOT NULL COMMENT 'Customer ID',
  `admin_id` int(11) NOT NULL COMMENT 'Admin ID',
  `created_at` timestamp NULL DEFAULT NULL COMMENT 'Creation Time',
  PRIMARY KEY (`secret`),
  KEY `WAL_LOGIN_AS_CUSTOMER_CREATED_AT` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magento Login as Customer Table';

--
-- Dumping data for table `wal_login_as_customer`
--

INSERT INTO `wal_login_as_customer` VALUES ('fba8e739526e6aeec0e5531090135c5363e4fec1dfbc8d16c4ea551061634a60',1,1,'2022-06-06 08:57:38');

--
-- Table structure for table `wal_login_as_customer_assistance_allowed`
--

CREATE TABLE `wal_login_as_customer_assistance_allowed` (
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer ID',
  PRIMARY KEY (`customer_id`),
  CONSTRAINT `FK_D81990D06C2F9FA1CA3C4F97F18B710C` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magento Login as Customer Assistance Allowed Table';

--
-- Dumping data for table `wal_login_as_customer_assistance_allowed`
--

INSERT INTO `wal_login_as_customer_assistance_allowed` VALUES (1);

--
-- Table structure for table `wal_magefan_blog_category`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_CATEGORY_IDENTIFIER` (`identifier`),
  KEY `WAL_MAGEFAN_BLOG_CATEGORY_INCLUDE_IN_MENU` (`include_in_menu`),
  FULLTEXT KEY `FTI_F218B966762414E326A32F338EF2933C` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Category Table';

--
-- Dumping data for table `wal_magefan_blog_category`
--


--
-- Table structure for table `wal_magefan_blog_category_store`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_CATEGORY_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_MAGEFAN_BLOG_CATEGORY_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGEFAN_BLOG_CTGR_STORE_CTGR_ID_MAGEFAN_BLOG_CTGR_CTGR_ID` FOREIGN KEY (`category_id`) REFERENCES `wal_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 `wal_magefan_blog_category_store`
--


--
-- Table structure for table `wal_magefan_blog_comment`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_COMMENT_PARENT_ID` (`parent_id`),
  KEY `WAL_MAGEFAN_BLOG_COMMENT_POST_ID` (`post_id`),
  KEY `WAL_MAGEFAN_BLOG_COMMENT_CUSTOMER_ID` (`customer_id`),
  KEY `WAL_MAGEFAN_BLOG_COMMENT_ADMIN_ID` (`admin_id`),
  KEY `WAL_MAGEFAN_BLOG_COMMENT_STATUS` (`status`),
  CONSTRAINT `WAL_MAGEFAN_BLOG_COMMENT_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `wal_magefan_blog_post` (`post_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='wal_magefan_blog_comment';

--
-- Dumping data for table `wal_magefan_blog_comment`
--


--
-- Table structure for table `wal_magefan_blog_post`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_POST_IDENTIFIER` (`identifier`),
  KEY `WAL_MAGEFAN_BLOG_POST_AUTHOR_ID` (`author_id`),
  KEY `WAL_MAGEFAN_BLOG_POST_VIEWS_COUNT` (`views_count`),
  KEY `WAL_MAGEFAN_BLOG_POST_IS_RECENT_POSTS_SKIP` (`is_recent_posts_skip`),
  FULLTEXT KEY `FTI_0E1DC8D6FA64A9C7027EAC7804A17F0D` (`title`,`meta_keywords`,`meta_description`,`identifier`,`content`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post Table';

--
-- Dumping data for table `wal_magefan_blog_post`
--

INSERT INTO `wal_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=\"Magento 2 Blog extension\" href=\"https://magefan.com/magento2-blog-extension\" target=\"_blank\">Magento 2 Blog extension</a> by <a title=\"Magento 2 Extensions\" href=\"https://magefan.com/magento2-extensions\" target=\"_blank\">Magefan</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=\"https://magefan.com/blog/magento-2-blog-extension-documentation/\" target=\"_blank\">Online documentation</a>&nbsp;and&nbsp;<a href=\"https://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>','2020-06-08 07:05:14','2020-06-08 07:05:14','2020-06-08 07:05:14',1,1,0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `wal_magefan_blog_post_category`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_POST_CATEGORY_CATEGORY_ID` (`category_id`),
  CONSTRAINT `WAL_MAGEFAN_BLOG_POST_CATEGORY_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `wal_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGEFAN_BLOG_POST_CTGR_CTGR_ID_MAGEFAN_BLOG_CTGR_CTGR_ID` FOREIGN KEY (`category_id`) REFERENCES `wal_magefan_blog_category` (`category_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Category Linkage Table';

--
-- Dumping data for table `wal_magefan_blog_post_category`
--


--
-- Table structure for table `wal_magefan_blog_post_relatedpost`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `FK_078CFC1DBE57A931C61B2FBE9CE53B29` FOREIGN KEY (`post_id`) REFERENCES `wal_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `FK_ABD8C1492E7510B398EE6281D3598716` FOREIGN KEY (`post_id`) REFERENCES `wal_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 `wal_magefan_blog_post_relatedpost`
--


--
-- Table structure for table `wal_magefan_blog_post_relatedproduct`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_POST_RELATEDPRODUCT_RELATED_ID` (`related_id`),
  CONSTRAINT `FK_7F03F204245E846EC3458060386D09A9` FOREIGN KEY (`post_id`) REFERENCES `wal_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGEFAN_BLOG_POST_RELATEDPRD_RELATED_ID_CAT_PRD_ENTT_ENTT_ID` FOREIGN KEY (`related_id`) REFERENCES `wal_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 `wal_magefan_blog_post_relatedproduct`
--


--
-- Table structure for table `wal_magefan_blog_post_store`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_POST_STORE_STORE_ID` (`store_id`),
  CONSTRAINT `WAL_MAGEFAN_BLOG_POST_STORE_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `wal_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGEFAN_BLOG_POST_STORE_STORE_ID_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Post To Store Linkage Table';

--
-- Dumping data for table `wal_magefan_blog_post_store`
--

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

--
-- Table structure for table `wal_magefan_blog_post_tag`
--

CREATE TABLE `wal_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 `WAL_MAGEFAN_BLOG_POST_TAG_TAG_ID` (`tag_id`),
  CONSTRAINT `WAL_MAGEFAN_BLOG_POST_TAG_POST_ID_MAGEFAN_BLOG_POST_POST_ID` FOREIGN KEY (`post_id`) REFERENCES `wal_magefan_blog_post` (`post_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGEFAN_BLOG_POST_TAG_TAG_ID_MAGEFAN_BLOG_TAG_TAG_ID` FOREIGN KEY (`tag_id`) REFERENCES `wal_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 `wal_magefan_blog_post_tag`
--


--
-- Table structure for table `wal_magefan_blog_tag`
--

CREATE TABLE `wal_magefan_blog_tag` (
  `tag_id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Tag ID',
  `title` varchar(255) DEFAULT NULL COMMENT 'Tag Title',
  `meta_robots` varchar(255) DEFAULT NULL COMMENT 'Tag Degault Robots',
  `meta_description` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Description',
  `meta_keywords` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Keywords',
  `meta_title` varchar(255) DEFAULT NULL COMMENT 'Tag Meta Title',
  `identifier` varchar(100) DEFAULT NULL COMMENT 'Tag String Identifier',
  `page_layout` varchar(255) DEFAULT NULL COMMENT 'Tag Layout',
  `is_active` smallint(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 `WAL_MAGEFAN_BLOG_TAG_IDENTIFIER` (`identifier`),
  KEY `WAL_MAGEFAN_BLOG_TAG_IS_ACTIVE` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magefan Blog Tag Table';

--
-- Dumping data for table `wal_magefan_blog_tag`
--


--
-- Table structure for table `wal_magento_acknowledged_bulk`
--

CREATE TABLE `wal_magento_acknowledged_bulk` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Internal ID',
  `bulk_uuid` varbinary(39) DEFAULT NULL COMMENT 'Related Bulk UUID',
  PRIMARY KEY (`id`),
  UNIQUE KEY `WAL_MAGENTO_ACKNOWLEDGED_BULK_BULK_UUID` (`bulk_uuid`),
  CONSTRAINT `WAL_MAGENTO_ACKNOWLEDGED_BULK_BULK_UUID_WAL_MAGENTO_BULK_UUID` FOREIGN KEY (`bulk_uuid`) REFERENCES `wal_magento_bulk` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Bulk that was viewed by user from notification area';

--
-- Dumping data for table `wal_magento_acknowledged_bulk`
--


--
-- Table structure for table `wal_magento_banner`
--

CREATE TABLE `wal_magento_banner` (
  `banner_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Banner Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `is_enabled` int(11) NOT NULL COMMENT 'Is Enabled',
  `types` varchar(255) DEFAULT NULL COMMENT 'Types',
  `is_ga_enabled` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Google Analytics Universals enabled',
  `ga_creative` text COMMENT 'Google Analytics Universals code',
  PRIMARY KEY (`banner_id`),
  FULLTEXT KEY `WAL_MAGENTO_BANNER_NAME` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Banner';

--
-- Dumping data for table `wal_magento_banner`
--


--
-- Table structure for table `wal_magento_banner_catalogrule`
--

CREATE TABLE `wal_magento_banner_catalogrule` (
  `banner_id` int(10) unsigned NOT NULL COMMENT 'Banner Id',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule Id',
  PRIMARY KEY (`banner_id`,`rule_id`),
  KEY `WAL_MAGENTO_BANNER_CATALOGRULE_RULE_ID` (`rule_id`),
  CONSTRAINT `FK_18664848FC1F97F4C01383D7A296270C` FOREIGN KEY (`banner_id`) REFERENCES `wal_magento_banner` (`banner_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_BANNER_CATALOGRULE_RULE_ID_WAL_CATALOGRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_catalogrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Banner Catalogrule';

--
-- Dumping data for table `wal_magento_banner_catalogrule`
--


--
-- Table structure for table `wal_magento_banner_content`
--

CREATE TABLE `wal_magento_banner_content` (
  `banner_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Banner Id',
  `store_id` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Store Id',
  `banner_content` mediumtext COMMENT 'Banner Content',
  PRIMARY KEY (`banner_id`,`store_id`),
  KEY `WAL_MAGENTO_BANNER_CONTENT_STORE_ID` (`store_id`),
  CONSTRAINT `FK_3BBE06B2E0AA9E176061DD495197E60E` FOREIGN KEY (`banner_id`) REFERENCES `wal_magento_banner` (`banner_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_BANNER_CONTENT_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Banner Content';

--
-- Dumping data for table `wal_magento_banner_content`
--


--
-- Table structure for table `wal_magento_banner_salesrule`
--

CREATE TABLE `wal_magento_banner_salesrule` (
  `banner_id` int(10) unsigned NOT NULL COMMENT 'Banner Id',
  `rule_id` int(10) unsigned NOT NULL COMMENT 'Rule Id',
  PRIMARY KEY (`banner_id`,`rule_id`),
  KEY `WAL_MAGENTO_BANNER_SALESRULE_RULE_ID` (`rule_id`),
  CONSTRAINT `FK_BA7CC156C055050BC0ACA032C9B2FCE1` FOREIGN KEY (`banner_id`) REFERENCES `wal_magento_banner` (`banner_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_BANNER_SALESRULE_RULE_ID_WAL_SALESRULE_RULE_ID` FOREIGN KEY (`rule_id`) REFERENCES `wal_salesrule` (`rule_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Banner Salesrule';

--
-- Dumping data for table `wal_magento_banner_salesrule`
--


--
-- Table structure for table `wal_magento_bulk`
--

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

--
-- Dumping data for table `wal_magento_bulk`
--


--
-- Table structure for table `wal_magento_catalogevent_event`
--

CREATE TABLE `wal_magento_catalogevent_event` (
  `event_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Event Id',
  `category_id` int(10) unsigned DEFAULT NULL COMMENT 'Category Id',
  `date_start` datetime DEFAULT NULL COMMENT 'Date Start',
  `date_end` datetime DEFAULT NULL COMMENT 'Date End',
  `display_state` smallint(5) unsigned DEFAULT '0' COMMENT 'Display State',
  `sort_order` int(10) unsigned DEFAULT NULL COMMENT 'Sort Order',
  `status` smallint(5) unsigned NOT NULL DEFAULT '1' COMMENT 'Status',
  PRIMARY KEY (`event_id`),
  UNIQUE KEY `WAL_MAGENTO_CATALOGEVENT_EVENT_CATEGORY_ID` (`category_id`),
  KEY `WAL_MAGENTO_CATALOGEVENT_EVENT_DATE_START_DATE_END` (`date_start`,`date_end`),
  CONSTRAINT `WAL_MAGENTO_CATEVENT_EVENT_CTGR_ID_WAL_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `wal_catalog_category_entity` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Catalogevent Event';

--
-- Dumping data for table `wal_magento_catalogevent_event`
--


--
-- Table structure for table `wal_magento_catalogevent_event_image`
--

CREATE TABLE `wal_magento_catalogevent_event_image` (
  `event_id` int(10) unsigned NOT NULL COMMENT 'Event Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `image` varchar(255) NOT NULL COMMENT 'Image',
  PRIMARY KEY (`event_id`,`store_id`),
  KEY `WAL_MAGENTO_CATALOGEVENT_EVENT_IMAGE_STORE_ID` (`store_id`),
  CONSTRAINT `FK_C2E15EE68F72896BD4240EE56A3CC9C2` FOREIGN KEY (`event_id`) REFERENCES `wal_magento_catalogevent_event` (`event_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_CATALOGEVENT_EVENT_IMAGE_STORE_ID_WAL_STORE_STORE_ID` FOREIGN KEY (`store_id`) REFERENCES `wal_store` (`store_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Catalogevent Event Image';

--
-- Dumping data for table `wal_magento_catalogevent_event_image`
--


--
-- Table structure for table `wal_magento_catalogpermissions`
--

CREATE TABLE `wal_magento_catalogpermissions` (
  `permission_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Permission Id',
  `category_id` int(10) unsigned NOT NULL COMMENT 'Category Id',
  `website_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Website Id',
  `customer_group_id` int(10) unsigned DEFAULT NULL COMMENT 'Customer Group Id',
  `grant_catalog_category_view` smallint(6) NOT NULL COMMENT 'Grant Catalog Category View',
  `grant_catalog_product_price` smallint(6) NOT NULL COMMENT 'Grant Catalog Product Price',
  `grant_checkout_items` smallint(6) NOT NULL COMMENT 'Grant Checkout Items',
  PRIMARY KEY (`permission_id`),
  UNIQUE KEY `WAL_MAGENTO_CATPERMISSIONS_CTGR_ID_WS_ID_CSTR_GROUP_ID` (`category_id`,`website_id`,`customer_group_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_WEBSITE_ID` (`website_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_CUSTOMER_GROUP_ID` (`customer_group_id`),
  CONSTRAINT `FK_66C0C37E2E2A69082FB0C92194D5BF0C` FOREIGN KEY (`customer_group_id`) REFERENCES `wal_customer_group` (`customer_group_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_CATPERMISSIONS_CTGR_ID_WAL_CAT_CTGR_ENTT_ENTT_ID` FOREIGN KEY (`category_id`) REFERENCES `wal_catalog_category_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_CATPERMISSIONS_WS_ID_WAL_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Catalogpermissions';

--
-- Dumping data for table `wal_magento_catalogpermissions`
--


--
-- Table structure for table `wal_magento_catalogpermissions_index`
--

CREATE TABLE `wal_magento_catalogpermissions_index` (
  `category_id` int(10) unsigned NOT NULL COMMENT 'Category Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `customer_group_id` int(10) unsigned NOT NULL,
  `grant_catalog_category_view` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Category View',
  `grant_catalog_product_price` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Product Price',
  `grant_checkout_items` smallint(6) DEFAULT NULL COMMENT 'Grant Checkout Items',
  UNIQUE KEY `WAL_MAGENTO_CATPERMISSIONS_IDX_CTGR_ID_WS_ID_CSTR_GROUP_ID` (`category_id`,`website_id`,`customer_group_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_WEBSITE_ID` (`website_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_CUSTOMER_GROUP_ID` (`customer_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Catalogpermissions Index';

--
-- Dumping data for table `wal_magento_catalogpermissions_index`
--


--
-- Table structure for table `wal_magento_catalogpermissions_index_product`
--

CREATE TABLE `wal_magento_catalogpermissions_index_product` (
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `customer_group_id` int(10) unsigned NOT NULL,
  `grant_catalog_category_view` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Category View',
  `grant_catalog_product_price` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Product Price',
  `grant_checkout_items` smallint(6) DEFAULT NULL COMMENT 'Grant Checkout Items',
  UNIQUE KEY `WAL_MAGENTO_CATPERMISSIONS_IDX_PRD_PRD_ID_STORE_ID_CSTR_GROUP_ID` (`product_id`,`store_id`,`customer_group_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_PRODUCT_STORE_ID` (`store_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_PRODUCT_CUSTOMER_GROUP_ID` (`customer_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Catalogpermissions Index Product';

--
-- Dumping data for table `wal_magento_catalogpermissions_index_product`
--


--
-- Table structure for table `wal_magento_catalogpermissions_index_product_replica`
--

CREATE TABLE `wal_magento_catalogpermissions_index_product_replica` (
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group Id',
  `grant_catalog_category_view` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Category View',
  `grant_catalog_product_price` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Product Price',
  `grant_checkout_items` smallint(6) DEFAULT NULL COMMENT 'Grant Checkout Items',
  UNIQUE KEY `WAL_MAGENTO_CATPERMISSIONS_IDX_PRD_PRD_ID_STORE_ID_CSTR_GROUP_ID` (`product_id`,`store_id`,`customer_group_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_PRODUCT_STORE_ID` (`store_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_PRODUCT_CUSTOMER_GROUP_ID` (`customer_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Magento Catalogpermissions Index Product Replica';

--
-- Dumping data for table `wal_magento_catalogpermissions_index_product_replica`
--


--
-- Table structure for table `wal_magento_catalogpermissions_index_product_tmp`
--

CREATE TABLE `wal_magento_catalogpermissions_index_product_tmp` (
  `product_id` int(10) unsigned NOT NULL COMMENT 'Product Id',
  `store_id` smallint(5) unsigned NOT NULL COMMENT 'Store Id',
  `customer_group_id` int(10) unsigned NOT NULL,
  `grant_catalog_category_view` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Category View',
  `grant_catalog_product_price` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Product Price',
  `grant_checkout_items` smallint(6) DEFAULT NULL COMMENT 'Grant Checkout Items',
  UNIQUE KEY `UNQ_C43B1AB895BD66AB79CCB7592D751E31` (`product_id`,`store_id`,`customer_group_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_PRODUCT_TMP_STORE_ID` (`store_id`),
  KEY `WAL_MAGENTO_CATPERMISSIONS_IDX_PRD_TMP_CSTR_GROUP_ID` (`customer_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Product Permissions Temporary Index';

--
-- Dumping data for table `wal_magento_catalogpermissions_index_product_tmp`
--


--
-- Table structure for table `wal_magento_catalogpermissions_index_replica`
--

CREATE TABLE `wal_magento_catalogpermissions_index_replica` (
  `category_id` int(10) unsigned NOT NULL COMMENT 'Category Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `customer_group_id` int(10) unsigned NOT NULL COMMENT 'Customer Group Id',
  `grant_catalog_category_view` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Category View',
  `grant_catalog_product_price` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Product Price',
  `grant_checkout_items` smallint(6) DEFAULT NULL COMMENT 'Grant Checkout Items',
  UNIQUE KEY `WAL_MAGENTO_CATPERMISSIONS_IDX_CTGR_ID_WS_ID_CSTR_GROUP_ID` (`category_id`,`website_id`,`customer_group_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_WEBSITE_ID` (`website_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_CUSTOMER_GROUP_ID` (`customer_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Catalogpermissions Index';

--
-- Dumping data for table `wal_magento_catalogpermissions_index_replica`
--


--
-- Table structure for table `wal_magento_catalogpermissions_index_tmp`
--

CREATE TABLE `wal_magento_catalogpermissions_index_tmp` (
  `category_id` int(10) unsigned NOT NULL COMMENT 'Category Id',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  `customer_group_id` int(10) unsigned NOT NULL,
  `grant_catalog_category_view` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Category View',
  `grant_catalog_product_price` smallint(6) DEFAULT NULL COMMENT 'Grant Catalog Product Price',
  `grant_checkout_items` smallint(6) DEFAULT NULL COMMENT 'Grant Checkout Items',
  UNIQUE KEY `WAL_MAGENTO_CATPERMISSIONS_IDX_TMP_CTGR_ID_WS_ID_CSTR_GROUP_ID` (`category_id`,`website_id`,`customer_group_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_TMP_WEBSITE_ID` (`website_id`),
  KEY `WAL_MAGENTO_CATALOGPERMISSIONS_INDEX_TMP_CUSTOMER_GROUP_ID` (`customer_group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Catalog Category Permissions Temporary Index';

--
-- Dumping data for table `wal_magento_catalogpermissions_index_tmp`
--


--
-- Table structure for table `wal_magento_customerbalance`
--

CREATE TABLE `wal_magento_customerbalance` (
  `balance_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Balance Id',
  `customer_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer Id',
  `website_id` smallint(5) unsigned DEFAULT NULL COMMENT 'Website Id',
  `amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Balance Amount',
  `base_currency_code` varchar(3) DEFAULT NULL COMMENT 'Base Currency Code',
  PRIMARY KEY (`balance_id`),
  UNIQUE KEY `WAL_MAGENTO_CUSTOMERBALANCE_CUSTOMER_ID_WEBSITE_ID` (`customer_id`,`website_id`),
  KEY `WAL_MAGENTO_CUSTOMERBALANCE_WEBSITE_ID` (`website_id`),
  CONSTRAINT `WAL_MAGENTO_CSTRBALANCE_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_CSTRBALANCE_WS_ID_WAL_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customerbalance';

--
-- Dumping data for table `wal_magento_customerbalance`
--


--
-- Table structure for table `wal_magento_customerbalance_history`
--

CREATE TABLE `wal_magento_customerbalance_history` (
  `history_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'History Id',
  `balance_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Balance Id',
  `updated_at` timestamp NULL DEFAULT NULL COMMENT 'Updated At',
  `action` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Action',
  `balance_amount` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Balance Amount',
  `balance_delta` decimal(20,4) NOT NULL DEFAULT '0.0000' COMMENT 'Balance Delta',
  `additional_info` varchar(255) DEFAULT NULL COMMENT 'Additional Info',
  `is_customer_notified` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Is Customer Notified',
  PRIMARY KEY (`history_id`),
  KEY `WAL_MAGENTO_CUSTOMERBALANCE_HISTORY_BALANCE_ID` (`balance_id`),
  CONSTRAINT `FK_FA9486A3A0080CF5B5BA002FA0CFF714` FOREIGN KEY (`balance_id`) REFERENCES `wal_magento_customerbalance` (`balance_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customerbalance History';

--
-- Dumping data for table `wal_magento_customerbalance_history`
--


--
-- Table structure for table `wal_magento_customercustomattributes_sales_flat_order`
--

CREATE TABLE `wal_magento_customercustomattributes_sales_flat_order` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  PRIMARY KEY (`entity_id`),
  CONSTRAINT `FK_F4B0C8978F6F23690EF6CB0453643391` FOREIGN KEY (`entity_id`) REFERENCES `wal_sales_order` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customer Sales Flat Order';

--
-- Dumping data for table `wal_magento_customercustomattributes_sales_flat_order`
--

INSERT INTO `wal_magento_customercustomattributes_sales_flat_order` VALUES (1);

--
-- Table structure for table `wal_magento_customercustomattributes_sales_flat_order_address`
--

CREATE TABLE `wal_magento_customercustomattributes_sales_flat_order_address` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  PRIMARY KEY (`entity_id`),
  CONSTRAINT `FK_ED86D321CDDDC0F20D2E7A02CCCFC884` FOREIGN KEY (`entity_id`) REFERENCES `wal_sales_order_address` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customer Sales Flat Order Address';

--
-- Dumping data for table `wal_magento_customercustomattributes_sales_flat_order_address`
--

INSERT INTO `wal_magento_customercustomattributes_sales_flat_order_address` VALUES (1),(2);

--
-- Table structure for table `wal_magento_customercustomattributes_sales_flat_quote`
--

CREATE TABLE `wal_magento_customercustomattributes_sales_flat_quote` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  PRIMARY KEY (`entity_id`),
  CONSTRAINT `FK_CE42FCABBBA8A26EC93F7B471EBDF454` FOREIGN KEY (`entity_id`) REFERENCES `wal_quote` (`entity_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customer Sales Flat Quote';

--
-- Dumping data for table `wal_magento_customercustomattributes_sales_flat_quote`
--

INSERT INTO `wal_magento_customercustomattributes_sales_flat_quote` VALUES (3),(4),(5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(15),(16);

--
-- Table structure for table `wal_magento_customercustomattributes_sales_flat_quote_address`
--

CREATE TABLE `wal_magento_customercustomattributes_sales_flat_quote_address` (
  `entity_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT 'Entity Id',
  PRIMARY KEY (`entity_id`),
  CONSTRAINT `FK_C542D76EE9167BB38ECCB00BD1D12FA8` FOREIGN KEY (`entity_id`) REFERENCES `wal_quote_address` (`address_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customer Sales Flat Quote Address';

--
-- Dumping data for table `wal_magento_customercustomattributes_sales_flat_quote_address`
--

INSERT INTO `wal_magento_customercustomattributes_sales_flat_quote_address` VALUES (5),(6),(7),(8),(9),(10),(11),(12),(13),(14),(16),(17),(19),(20),(23),(24),(25),(26),(27),(28),(29),(30),(31),(32),(33),(34),(35),(36);

--
-- Table structure for table `wal_magento_customersegment_customer`
--

CREATE TABLE `wal_magento_customersegment_customer` (
  `segment_id` int(10) unsigned NOT NULL COMMENT 'Segment Id',
  `customer_id` int(10) unsigned NOT NULL COMMENT 'Customer Id',
  `added_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Added Date',
  `updated_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Updated Date',
  `website_id` smallint(5) unsigned NOT NULL COMMENT 'Website Id',
  PRIMARY KEY (`segment_id`,`customer_id`,`website_id`),
  UNIQUE KEY `WAL_MAGENTO_CSTRSEGMENT_CSTR_SEGMENT_ID_WS_ID_CSTR_ID` (`segment_id`,`website_id`,`customer_id`),
  KEY `WAL_MAGENTO_CUSTOMERSEGMENT_CUSTOMER_WEBSITE_ID` (`website_id`),
  KEY `WAL_MAGENTO_CUSTOMERSEGMENT_CUSTOMER_CUSTOMER_ID` (`customer_id`),
  CONSTRAINT `FK_CC4A560B57FB907EF9E37BF9D7EF262F` FOREIGN KEY (`segment_id`) REFERENCES `wal_magento_customersegment_segment` (`segment_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_CSTRSEGMENT_CSTR_CSTR_ID_WAL_CSTR_ENTT_ENTT_ID` FOREIGN KEY (`customer_id`) REFERENCES `wal_customer_entity` (`entity_id`) ON DELETE CASCADE,
  CONSTRAINT `WAL_MAGENTO_CSTRSEGMENT_CSTR_WS_ID_WAL_STORE_WS_WS_ID` FOREIGN KEY (`website_id`) REFERENCES `wal_store_website` (`website_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customersegment Customer';

--
-- Dumping data for table `wal_magento_customersegment_customer`
--


--
-- Table structure for table `wal_magento_customersegment_event`
--

CREATE TABLE `wal_magento_customersegment_event` (
  `segment_id` int(10) unsigned NOT NULL COMMENT 'Segment Id',
  `event` varchar(255) DEFAULT NULL COMMENT 'Event',
  KEY `WAL_MAGENTO_CUSTOMERSEGMENT_EVENT_EVENT` (`event`),
  KEY `WAL_MAGENTO_CUSTOMERSEGMENT_EVENT_SEGMENT_ID` (`segment_id`),
  CONSTRAINT `FK_823DFDAC9EDE0DE248AFDEA2CC583554` FOREIGN KEY (`segment_id`) REFERENCES `wal_magento_customersegment_segment` (`segment_id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customersegment Event';

--
-- Dumping data for table `wal_magento_customersegment_event`
--


--
-- Table structure for table `wal_magento_customersegment_segment`
--

CREATE TABLE `wal_magento_customersegment_segment` (
  `segment_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Segment Id',
  `name` varchar(255) DEFAULT NULL COMMENT 'Name',
  `description` text COMMENT 'Description',
  `is_active` smallint(6) NOT NULL DEFAULT '0' COMMENT 'Is Active',
  `conditions_serialized` mediumtext COMMENT 'Conditions Serialized',
  `processing_frequency` int(11) NOT NULL COMMENT 'Processing Frequency',
  `condition_sql` mediumtext COMMENT 'Condition Sql',
  `apply_to` smallint(5) unsigned NOT NULL DEFAULT '0' COMMENT 'Customer types to which this segment applies',
  PRIMARY KEY (`segment_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Enterprise Customersegment Segment';

--
-- Dumping data for table `wal_magento_customersegment_segment`
--


--
-- Table structure for table `wal_magento_customersegment_website`
--

