--
-- Host: localhost    Database: Quickadclassified
-- ------------------------------------------------------


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

INSERT INTO `<<prefix>>subadmin1` VALUES (321,'BJ.18','BJ','Zou','Zou',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (322,'BJ.16','BJ','Ouémé','Oueme',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (323,'BJ.15','BJ','Mono','Mono',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (324,'BJ.10','BJ','Borgou','Borgou',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (325,'BJ.09','BJ','Atlantique','Atlantique',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (326,'BJ.08','BJ','Atakora','Atakora',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (327,'BJ.07','BJ','Alibori','Alibori',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (328,'BJ.11','BJ','Collines','Collines',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (329,'BJ.12','BJ','Kouffo','Kouffo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (330,'BJ.13','BJ','Donga','Donga',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (331,'BJ.14','BJ','Littoral','Littoral',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (332,'BJ.17','BJ','Plateau','Plateau',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (2525,'BJ.12.2391090','BJ','BJ.12','Dogbo Tota','Dogbo Tota',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2526,'BJ.16.7668892','BJ','BJ.16','Commune of Adjohoun','Commune of Adjohoun',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2527,'BJ.16.7668898','BJ','BJ.16','Bonou','Bonou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2528,'BJ.16.7668900','BJ','BJ.16','Dangbo','Dangbo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2529,'BJ.18.7668907','BJ','BJ.18','Commune of Cove','Commune of Cove',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2530,'BJ.18.7668908','BJ','BJ.18','Commune of Ouinhi','Commune of Ouinhi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2531,'BJ.18.7668909','BJ','BJ.18','Commune of Zangnanado','Commune of Zangnanado',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2532,'BJ.08.7668910','BJ','BJ.08','Kouande','Kouande',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2533,'BJ.08.7668916','BJ','BJ.08','Pehonko','Pehonko',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2534,'BJ.08.7668918','BJ','BJ.08','Kerou','Kerou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2535,'BJ.15.7668924','BJ','BJ.15','Lokossa','Lokossa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2536,'BJ.15.7668926','BJ','BJ.15','Commune of Athieme','Commune of Athieme',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2537,'BJ.18.7668931','BJ','BJ.18','Commune of Bohicon','Commune of Bohicon',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2538,'BJ.18.7668932','BJ','BJ.18','Commune of Za-Kpota','Commune of Za-Kpota',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2539,'BJ.18.7668934','BJ','BJ.18','Commune of Zogbodome','Commune of Zogbodome',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2540,'BJ.07.7668935','BJ','BJ.07','Commune of Banikoara','Commune of Banikoara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2541,'BJ.09.7668936','BJ','BJ.09','Commune of Ouidah','Commune of Ouidah',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2542,'BJ.09.7668937','BJ','BJ.09','Commune of Kpomasse','Commune of Kpomasse',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2543,'BJ.09.7668938','BJ','BJ.09','Commune of Tori-Bossito','Commune of Tori-Bossito',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2544,'BJ.16.7668939','BJ','BJ.16','Porto-novo','Porto-novo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2545,'BJ.16.7668940','BJ','BJ.16','Aguégués','Aguegues',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2546,'BJ.16.7668941','BJ','BJ.16','Seme-kpodji','Seme-kpodji',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2547,'BJ.13.7669263','BJ','BJ.13','Ouake','Ouake',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2548,'BJ.10.7669265','BJ','BJ.10','Commune of Tchaourou','Commune of Tchaourou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2549,'BJ.10.7669268','BJ','BJ.10','Commune of Parakou','Commune of Parakou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2550,'BJ.10.7669269','BJ','BJ.10','Ndali','Ndali',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2551,'BJ.10.7669270','BJ','BJ.10','Bembereke','Bembereke',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2552,'BJ.08.7669273','BJ','BJ.08','Natitingou','Natitingou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2553,'BJ.13.7669275','BJ','BJ.13','Copargo','Copargo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2554,'BJ.10.7669349','BJ','BJ.10','Kalalè','Kalale',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2555,'BJ.10.7669352','BJ','BJ.10','Pèrèrè','Perere',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2556,'BJ.10.7669355','BJ','BJ.10','Nikki','Nikki',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2557,'BJ.10.7669357','BJ','BJ.10','Sinendé','Sinende',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2558,'BJ.17.7670840','BJ','BJ.17','Commune of Ketou','Commune of Ketou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2559,'BJ.17.7670841','BJ','BJ.17','Commune of Pobe','Commune of Pobe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2560,'BJ.14.7874113','BJ','BJ.14','Cotonou','Cotonou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2561,'BJ.09.7874152','BJ','BJ.09','Commune of Abomey-Calavi','Commune of Abomey-Calavi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2562,'BJ.09.7874154','BJ','BJ.09','Commune of So-Ava','Commune of So-Ava',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2563,'BJ.07.7874155','BJ','BJ.07','Karimama','Karimama',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2564,'BJ.08.7874156','BJ','BJ.08','Tanguieta','Tanguieta',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2565,'BJ.08.7874157','BJ','BJ.08','Toukountouna','Toukountouna',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2566,'BJ.08.7874158','BJ','BJ.08','Materi','Materi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2567,'BJ.11.7874167','BJ','BJ.11','Commune of Glazoue','Commune of Glazoue',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2568,'BJ.07.7874170','BJ','BJ.07','Malanville','Malanville',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2569,'BJ.07.7911056','BJ','BJ.07','Kandi','Kandi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2570,'BJ.11.8260647','BJ','BJ.11','Commune of Bante','Commune of Bante',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2571,'BJ.11.8260648','BJ','BJ.11','Commune of Dassa-Zoume','Commune of Dassa-Zoume',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2572,'BJ.11.8260649','BJ','BJ.11','Commune of Ouesse','Commune of Ouesse',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2573,'BJ.11.8260650','BJ','BJ.11','Commune of Savalou','Commune of Savalou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2574,'BJ.11.8260651','BJ','BJ.11','Commune of Save','Commune of Save',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2575,'BJ.18.8260652','BJ','BJ.18','Commune of Abomey','Commune of Abomey',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2576,'BJ.18.8260653','BJ','BJ.18','Commune of Agbangnizoun','Commune of Agbangnizoun',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2577,'BJ.18.8260654','BJ','BJ.18','Commune of Djidja','Commune of Djidja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2578,'BJ.09.8260655','BJ','BJ.09','Commune of Allada','Commune of Allada',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2579,'BJ.09.8260656','BJ','BJ.09','Commune of Toffo','Commune of Toffo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2580,'BJ.09.8260657','BJ','BJ.09','Commune of Ze','Commune of Ze',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2581,'BJ.13.8260658','BJ','BJ.13','Commune of Djougou','Commune of Djougou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2582,'BJ.17.8334580','BJ','BJ.17','Commune of Sakete','Commune of Sakete',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2583,'BJ.15.8335018','BJ','BJ.15','Commune of Houeyogbe','Commune of Houeyogbe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2584,'BJ.15.8335019','BJ','BJ.15','Commune of Bopa','Commune of Bopa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2585,'BJ.17.8335162','BJ','BJ.17','Adjaouere','Adjaouere',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2586,'BJ.16.8693304','BJ','BJ.16','Adjara','Adjara',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2587,'BJ.16.9063965','BJ','BJ.16','Akpro-Misserete','Akpro-Misserete',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2588,'BJ.16.9063966','BJ','BJ.16','Avrankou','Avrankou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2589,'BJ.17.9063970','BJ','BJ.17','Ifangni','Ifangni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2590,'BJ.15.9166075','BJ','BJ.15','Grand-Popo','Grand-Popo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2591,'BJ.15.9166076','BJ','BJ.15','Comé','Come',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2592,'BJ.08.10344466','BJ','BJ.08','Cobly','Cobly',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2593,'BJ.08.10344467','BJ','BJ.08','Boukoumbé','Boukoumbe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2594,'BJ.07.10344468','BJ','BJ.07','Ségbana','Segbana',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2595,'BJ.07.10344469','BJ','BJ.07','Gogounou','Gogounou',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2596,'BJ.13.10344470','BJ','BJ.13','Bassila','Bassila',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2597,'BJ.12.10344472','BJ','BJ.12','Aplahoué','Aplahoue',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2598,'BJ.12.10344473','BJ','BJ.12','Djakotomey','Djakotomey',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2599,'BJ.12.10344474','BJ','BJ.12','Klouékanmè','Klouekanme',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2600,'BJ.12.10344475','BJ','BJ.12','Lalo','Lalo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (2601,'BJ.12.10344476','BJ','BJ.12','Toviklin','Toviklin',1);

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

INSERT INTO `<<prefix>>cities` VALUES (2391377,'BJ','Tchaourou','Tchaourou',8.88649,2.59753,'P','PPL','BJ.10','BJ.10.7669265',20971,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2391455,'BJ','Tanguiéta','Tanguieta',10.6212,1.26651,'P','PPL','BJ.08','BJ.08.7874156',19833,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2391893,'BJ','Savé','Save',8.03424,2.4866,'P','PPL','BJ.11',NULL,75970,'Africa/Porto-Novo',1,'2013-05-17 23:00:00','2013-05-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2391895,'BJ','Savalou','Savalou',7.92807,1.97558,'P','PPLA','BJ.11',NULL,30187,'Africa/Porto-Novo',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392009,'BJ','Sakété','Sakete',6.73618,2.65866,'P','PPLA','BJ.17',NULL,30111,'Africa/Porto-Novo',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392087,'BJ','Porto-Novo','Porto-Novo',6.49646,2.60359,'P','PPLC','BJ.16',NULL,234168,'Africa/Porto-Novo',1,'2011-03-03 23:00:00','2011-03-03 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392108,'BJ','Pobé','Pobe',6.98008,2.6649,'P','PPL','BJ.17',NULL,32983,'Africa/Porto-Novo',1,'2012-10-17 23:00:00','2012-10-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392204,'BJ','Parakou','Parakou',9.33716,2.63031,'P','PPLA','BJ.10',NULL,163753,'Africa/Porto-Novo',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392308,'BJ','Ouidah','Ouidah',6.36307,2.08506,'P','PPLA','BJ.09',NULL,83503,'Africa/Porto-Novo',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392505,'BJ','Nikki','Nikki',9.94009,3.21075,'P','PPL','BJ.10','BJ.10.7669355',54009,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392601,'BJ','Natitingou','Natitingou',10.3042,1.37962,'P','PPLA','BJ.08',NULL,80892,'Africa/Porto-Novo',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392837,'BJ','Malanville','Malanville',11.8682,3.38327,'P','PPL','BJ.08',NULL,37117,'Africa/Porto-Novo',1,'2012-04-24 23:00:00','2012-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2392897,'BJ','Lokossa','Lokossa',6.63869,1.71674,'P','PPLA','BJ.15','BJ.15.7668924',86971,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2393551,'BJ','Kétou','Ketou',7.36332,2.59978,'P','PPL','BJ.17','BJ.17.7670840',22341,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2393693,'BJ','Kandi','Kandi',11.1342,2.93861,'P','PPLA','BJ.07',NULL,109701,'Africa/Porto-Novo',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2393887,'BJ','Hévié','Hevie',6.41667,2.25,'P','PPL','BJ.09','BJ.09.7874152',13450,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2393917,'BJ','Guilmaro','Guilmaro',10.5658,1.72444,'P','PPL','BJ.08','BJ.08.7668910',6516,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2393947,'BJ','Grand-Popo','Grand-Popo',6.28036,1.82251,'P','PPL','BJ.15','BJ.15.9166075',9847,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2394545,'BJ','Dogbo','Dogbo',6.79911,1.78073,'P','PPLA','BJ.12',NULL,41312,'Africa/Porto-Novo',1,'2017-12-19 23:00:00','2017-12-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2394560,'BJ','Djougou','Djougou',9.70853,1.66598,'P','PPLA','BJ.13',NULL,237040,'Africa/Porto-Novo',1,'2013-08-16 23:00:00','2013-08-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2394711,'BJ','Dassa-Zoumé','Dassa-Zoume',7.75,2.18333,'P','PPL','BJ.11',NULL,21672,'Africa/Porto-Novo',1,'2012-10-17 23:00:00','2012-10-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2394814,'BJ','Cové','Cove',7.22097,2.34017,'P','PPL','BJ.18',NULL,38566,'Africa/Porto-Novo',1,'2012-10-17 23:00:00','2012-10-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2394819,'BJ','Cotonou','Cotonou',6.36536,2.41833,'P','PPLG','BJ.14',NULL,780000,'Africa/Porto-Novo',1,'2017-08-15 23:00:00','2017-08-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2394824,'BJ','Comé','Come',6.40764,1.88198,'P','PPL','BJ.15',NULL,29208,'Africa/Porto-Novo',1,'2012-10-17 23:00:00','2012-10-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395049,'BJ','Bohicon','Bohicon',7.17826,2.0667,'P','PPL','BJ.18',NULL,125092,'Africa/Porto-Novo',1,'2012-10-17 23:00:00','2012-10-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395127,'BJ','Bétérou','Beterou',9.19916,2.25855,'P','PPL','BJ.10','BJ.10.7669265',13108,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395182,'BJ','Bembèrèkè','Bembereke',10.2283,2.66335,'P','PPL','BJ.10','BJ.10.7669270',24006,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395261,'BJ','Bassila','Bassila',9.00814,1.6654,'P','PPL','BJ.13','BJ.13.10344470',23616,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395317,'BJ','Banikoara','Banikoara',11.2985,2.43856,'P','PPL','BJ.07','BJ.07.7668935',22487,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395568,'BJ','Aplahoué','Aplahoue',6.93333,1.68333,'P','PPL','BJ.12','BJ.12.10344472',19862,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395635,'BJ','Allada','Allada',6.66547,2.15138,'P','PPL','BJ.09','BJ.09.8260655',20094,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395914,'BJ','Abomey-Calavi','Abomey-Calavi',6.44852,2.35566,'P','PPL','BJ.09','BJ.09.7874152',385755,'Africa/Porto-Novo',1,'2017-12-27 23:00:00','2017-12-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (2395915,'BJ','Abomey','Abomey',7.18286,1.99119,'P','PPLA','BJ.18',NULL,82154,'Africa/Porto-Novo',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');


