--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------


--
-- Dumping data for table `<<prefix>>subadmin1`
--

INSERT INTO `<<prefix>>subadmin1` VALUES (1761,'LU.WI','LU','Wiltz','Wiltz',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1762,'LU.VD','LU','Vianden','Vianden',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1763,'LU.RM','LU','Remich','Remich',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1764,'LU.RD','LU','Redange','Redange',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1765,'LU.ME','LU','Mersch','Mersch',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1766,'LU.LU','LU','Luxembourg','Luxembourg',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1767,'LU.GR','LU','Grevenmacher','Grevenmacher',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1768,'LU.ES','LU','Esch-sur-Alzette','Esch-sur-Alzette',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1769,'LU.EC','LU','Echternach','Echternach',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1770,'LU.DI','LU','Diekirch','Diekirch',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1771,'LU.CL','LU','Clervaux','Clervaux',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1772,'LU.CA','LU','Capellen','Capellen',1);

--
-- Dumping data for table `<<prefix>>subadmin2`
--

INSERT INTO `<<prefix>>subadmin2` VALUES (21359,'LU.WI.11','LU','LU.WI','Wiltz','Wiltz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21360,'LU.CL.09','LU','LU.CL','Troisvierges','Troisvierges',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21361,'LU.ES.14','LU','LU.ES','Schifflange','Schifflange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21362,'LU.ES.13','LU','LU.ES','Sanem','Sanem',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21363,'LU.ES.12','LU','LU.ES','Rumelange','Rumelange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21364,'LU.ES.09','LU','LU.ES','Pétange','Petange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21365,'LU.LU.2960317','LU','LU.LU','Ville de Luxembourg','Ville de Luxembourg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21366,'LU.ES.06','LU','LU.ES','Kayl','Kayl',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21367,'LU.GR.04','LU','LU.GR','Grevenmacher','Grevenmacher',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21368,'LU.DI.07','LU','LU.DI','Ettelbruck','Ettelbruck',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21369,'LU.EC.05','LU','LU.EC','Echternach','Echternach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21370,'LU.ES.03','LU','LU.ES','Dudelange','Dudelange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21371,'LU.ES.02','LU','LU.ES','Differdange','Differdange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21372,'LU.DI.04','LU','LU.DI','Diekirch','Diekirch',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21373,'LU.ES.01','LU','LU.ES','Bettembourg','Bettembourg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21374,'LU.DI.08','LU','LU.DI','Feulen','Feulen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21375,'LU.WI.05','LU','LU.WI','Lac de la Haute-Sûre','Lac de la Haute-Sure',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21376,'LU.CA.03','LU','LU.CA','Dippach','Dippach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21377,'LU.CA.04','LU','LU.CA','Garnich','Garnich',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21378,'LU.CA.05','LU','LU.CA','Hobscheid','Hobscheid',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21379,'LU.CA.06','LU','LU.CA','Kehlen','Kehlen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21380,'LU.CA.07','LU','LU.CA','Koerich','Koerich',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21381,'LU.CA.08','LU','LU.CA','Kopstal','Kopstal',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21382,'LU.CA.09','LU','LU.CA','Mamer','Mamer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21383,'LU.CA.10','LU','LU.CA','Septfontaines','Septfontaines',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21384,'LU.CA.11','LU','LU.CA','Steinfort','Steinfort',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21385,'LU.ES.04','LU','LU.ES','Esch-sur-Alzette','Esch-sur-Alzette',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21386,'LU.ES.05','LU','LU.ES','Frisange','Frisange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21387,'LU.ES.07','LU','LU.ES','Leudelange','Leudelange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21388,'LU.ES.08','LU','LU.ES','Mondercange','Mondercange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21389,'LU.ES.10','LU','LU.ES','Reckange-sur-Mess','Reckange-sur-Mess',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21390,'LU.ES.11','LU','LU.ES','Roeser','Roeser',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21391,'LU.LU.01','LU','LU.LU','Bertrange','Bertrange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21392,'LU.LU.02','LU','LU.LU','Contern','Contern',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21393,'LU.LU.03','LU','LU.LU','Hesperange','Hesperange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21394,'LU.LU.04','LU','LU.LU','Niederanven','Niederanven',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21395,'LU.LU.05','LU','LU.LU','Sandweiler','Sandweiler',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21396,'LU.LU.06','LU','LU.LU','Schuttrange','Schuttrange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21397,'LU.LU.07','LU','LU.LU','Steinsel','Steinsel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21398,'LU.LU.08','LU','LU.LU','Strassen','Strassen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21399,'LU.LU.09','LU','LU.LU','Walferdange','Walferdange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21400,'LU.LU.10','LU','LU.LU','Weiler-la-Tour','Weiler-la-Tour',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21401,'LU.ME.01','LU','LU.ME','Berg','Berg',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21402,'LU.ME.02','LU','LU.ME','Bissen','Bissen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21403,'LU.ME.03','LU','LU.ME','Boevange-sur-Attert','Boevange-sur-Attert',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21404,'LU.ME.04','LU','LU.ME','Fischbach','Fischbach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21405,'LU.ME.05','LU','LU.ME','Heffingen','Heffingen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21406,'LU.ME.06','LU','LU.ME','Larochette','Larochette',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21407,'LU.ME.07','LU','LU.ME','Lintgen','Lintgen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21408,'LU.ME.08','LU','LU.ME','Lorentzweiler','Lorentzweiler',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21409,'LU.ME.09','LU','LU.ME','Mersch','Mersch',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21410,'LU.ME.10','LU','LU.ME','Nommern','Nommern',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21411,'LU.ME.11','LU','LU.ME','Tuntange','Tuntange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21412,'LU.CL.01','LU','LU.CL','Wincrange','Wincrange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21413,'LU.CL.03','LU','LU.CL','Clervaux','Clervaux',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21414,'LU.CL.10','LU','LU.CL','Weiswampach','Weiswampach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21415,'LU.DI.02','LU','LU.DI','Bettendorf','Bettendorf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21416,'LU.DI.03','LU','LU.DI','Bourscheid','Bourscheid',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21417,'LU.DI.06','LU','LU.DI','Erpeldange','Erpeldange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21418,'LU.DI.11','LU','LU.DI','Mertzig','Mertzig',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21419,'LU.DI.12','LU','LU.DI','Reisdorf','Reisdorf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21420,'LU.DI.13','LU','LU.DI','Schieren','Schieren',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21421,'LU.RD.02','LU','LU.RD','Beckerich','Beckerich',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21422,'LU.RD.05','LU','LU.RD','Ell','Ell',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21423,'LU.RD.06','LU','LU.RD','Rambrouch','Rambrouch',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21424,'LU.RD.07','LU','LU.RD','Grosbous','Grosbous',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21425,'LU.RD.09','LU','LU.RD','Redange-sur-Attert','Redange-sur-Attert',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21426,'LU.RD.10','LU','LU.RD','Saeul','Saeul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21427,'LU.RD.11','LU','LU.RD','Useldange','Useldange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21428,'LU.RD.12','LU','LU.RD','Vichten','Vichten',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21429,'LU.RD.13','LU','LU.RD','Wahl','Wahl',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21430,'LU.WI.01','LU','LU.WI','Boulaide','Boulaide',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21431,'LU.WI.02','LU','LU.WI','Esch-sur-Sûre','Esch-sur-Sure',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21432,'LU.WI.04','LU','LU.WI','Goesdorf','Goesdorf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21433,'LU.WI.13','LU','LU.WI','Winseler','Winseler',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21434,'LU.VD.01','LU','LU.VD','Tandel','Tandel',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21435,'LU.VD.02','LU','LU.VD','Putscheid','Putscheid',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21436,'LU.VD.03','LU','LU.VD','Vianden','Vianden',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21437,'LU.EC.01','LU','LU.EC','Beaufort','Beaufort',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21438,'LU.EC.02','LU','LU.EC','Bech','Bech',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21439,'LU.EC.03','LU','LU.EC','Berdorf','Berdorf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21440,'LU.EC.04','LU','LU.EC','Consdorf','Consdorf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21441,'LU.EC.06','LU','LU.EC','Mompach','Mompach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21442,'LU.EC.07','LU','LU.EC','Rosport','Rosport',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21443,'LU.EC.08','LU','LU.EC','Waldbillig','Waldbillig',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21444,'LU.GR.01','LU','LU.GR','Betzdorf','Betzdorf',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21445,'LU.GR.02','LU','LU.GR','Biwer','Biwer',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21446,'LU.GR.03','LU','LU.GR','Flaxweiler','Flaxweiler',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21447,'LU.GR.05','LU','LU.GR','Junglinster','Junglinster',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21448,'LU.GR.06','LU','LU.GR','Manternach','Manternach',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21449,'LU.GR.07','LU','LU.GR','Mertert','Mertert',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21450,'LU.GR.09','LU','LU.GR','Wormeldange','Wormeldange',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21451,'LU.RM.00','LU','LU.RM','Bous','Bous',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21452,'LU.RM.02','LU','LU.RM','Dalheim','Dalheim',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21453,'LU.RM.03','LU','LU.RM','Lenningen','Lenningen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21454,'LU.RM.04','LU','LU.RM','Mondorf-les-Bains','Mondorf-les-Bains',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21455,'LU.RM.05','LU','LU.RM','Schengen','Schengen',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21456,'LU.RM.06','LU','LU.RM','Remich','Remich',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21457,'LU.RM.07','LU','LU.RM','Stadtbredimus','Stadtbredimus',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21458,'LU.RM.08','LU','LU.RM','Waldbredimus','Waldbredimus',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21459,'LU.WI.8641289','LU','LU.WI','Kiischpelt','Kiischpelt',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21460,'LU.RD.8641291','LU','LU.RD','Commune de Préizerdaul','Commune de Preizerdaul',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21461,'LU.DI.8641526','LU','LU.DI','Commune de la Vallée de l’Ernz','Commune de la Vallee de l\'Ernz',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21462,'LU.CA.8641865','LU','LU.CA','Käerjeng','Kaeerjeng',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21463,'LU.CL.63','LU','LU.CL','Parc Hosingen','Parc Hosingen',1);

--
-- Dumping data for table `<<prefix>>cities`
--

INSERT INTO `<<prefix>>cities` VALUES (2959977,'LU','Wiltz','Wiltz',49.9655,5.9339,'P','PPLA','LU.WI','LU.WI.11',4816,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960054,'LU','Strassen','Strassen',49.6206,6.07333,'P','PPLA3','LU.LU','LU.LU.08',6006,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960102,'LU','Schifflange','Schifflange',49.5064,6.01278,'P','PPLA3','LU.ES','LU.ES.14',8155,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960160,'LU','Redange-sur-Attert','Redange-sur-Attert',49.7644,5.88997,'P','PPLA','LU.RD','LU.RD.09',1164,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960187,'LU','Pétange','Petange',49.5583,5.88056,'P','PPLA3','LU.ES','LU.ES.09',7187,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960276,'LU','Mersch','Mersch',49.7489,6.10611,'P','PPLA','LU.ME','LU.ME.09',3464,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960299,'LU','Mamer','Mamer',49.6275,6.02333,'P','PPLA3','LU.CA','LU.CA.09',5017,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960316,'LU','Luxembourg','Luxembourg',49.6117,6.13,'P','PPLC','LU.LU','LU.LU.2960317',76684,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960515,'LU','Grevenmacher','Grevenmacher',49.6775,6.44022,'P','PPLA','LU.GR','LU.GR.04',3958,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960589,'LU','Ettelbruck','Ettelbruck',49.8475,6.10417,'P','PPLA3','LU.DI','LU.DI.07',6364,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960596,'LU','Esch-sur-Alzette','Esch-sur-Alzette',49.4958,5.98056,'P','PPLA2','LU.ES','LU.ES.04',28228,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960634,'LU','Dudelange','Dudelange',49.4806,6.0875,'P','PPLA3','LU.ES','LU.ES.03',18013,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960651,'LU','Differdange','Differdange',49.5242,5.89139,'P','PPLA3','LU.ES','LU.ES.02',5296,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960657,'LU','Diekirch','Diekirch',49.8678,6.15583,'P','PPLA','LU.DI','LU.DI.04',6242,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960777,'LU','Bettembourg','Bettembourg',49.5186,6.10278,'P','PPLA3','LU.ES','LU.ES.01',7437,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960782,'LU','Bertrange','Bertrange',49.6111,6.05,'P','PPLA3','LU.LU','LU.LU.01',5615,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2960800,'LU','Belvaux','Belvaux',49.5101,5.92414,'P','PPL','LU.ES','LU.ES.13',5313,'Europe/Luxembourg',1,'2017-10-01 23:00:00','2017-10-01 23:00:00');


