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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (2296,'MW.S','MW','Southern Region','Southern Region',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2297,'MW.N','MW','Northern Region','Northern Region',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (2298,'MW.C','MW','Central Region','Central Region',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (22822,'MW.N.04','MW','MW.N','Chitipa District','Chitipa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22823,'MW.S.23','MW','MW.S','Zomba District','Zomba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22824,'MW.C.22','MW','MW.C','Salima District','Salima District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22825,'MW.N.21','MW','MW.N','Rumphi District','Rumphi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22826,'MW.C.20','MW','MW.C','Ntchisi District','Ntchisi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22827,'MW.S.19','MW','MW.S','Nsanje District','Nsanje District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22828,'MW.C.18','MW','MW.C','Nkhotakota District','Nkhotakota District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22829,'MW.N.17','MW','MW.N','Nkhata Bay District','Nkhata Bay District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22830,'MW.C.16','MW','MW.C','Ntcheu District','Ntcheu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22831,'MW.N.15','MW','MW.N','Mzimba District','Mzimba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22832,'MW.S.25','MW','MW.S','Mwanza District','Mwanza District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22833,'MW.S.29','MW','MW.S','Mulanje District','Mulanje District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22834,'MW.C.13','MW','MW.C','Mchinji District','Mchinji District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22835,'MW.S.12','MW','MW.S','Mangochi District','Mangochi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22836,'MW.S.28','MW','MW.S','Machinga District','Machinga District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22837,'MW.C.11','MW','MW.C','Lilongwe District','Lilongwe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22838,'MW.C.09','MW','MW.C','Kasungu District','Kasungu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22839,'MW.N.08','MW','MW.N','Karonga District','Karonga District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22840,'MW.C.07','MW','MW.C','Dowa District','Dowa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22841,'MW.C.06','MW','MW.C','Dedza District','Dedza District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22842,'MW.S.05','MW','MW.S','Thyolo District','Thyolo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22843,'MW.S.03','MW','MW.S','Chiradzulu District','Chiradzulu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22844,'MW.S.02','MW','MW.S','Chikwawa District','Chikwawa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22845,'MW.S.24','MW','MW.S','Blantyre District','Blantyre District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22846,'MW.S.26','MW','MW.S','Balaka District','Balaka District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22847,'MW.N.27','MW','MW.N','Likoma District','Likoma District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22848,'MW.S.30','MW','MW.S','Phalombe District','Phalombe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22849,'MW.S.31','MW','MW.S','Neno District','Neno District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (22850,'MW.N.11238564','MW','MW.N','Mwenemisuku','Mwenemisuku',1);

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

INSERT INTO `<<prefix>>cities` VALUES (235715,'MW','Karonga','Karonga',-9.93333,33.9333,'P','PPLA2','MW.N','MW.N.08',34207,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (235751,'MW','Chitipa','Chitipa',-9.70237,33.2697,'P','PPLA2','MW.N','MW.N.04',8824,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (923295,'MW','Zomba','Zomba',-15.386,35.3188,'P','PPLA2','MW.S','MW.S.23',80932,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (923652,'MW','Thyolo','Thyolo',-16.0678,35.1405,'P','PPLA2','MW.S','MW.S.05',5775,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (924055,'MW','Salima','Salima',-13.7804,34.4587,'P','PPLA2','MW.C','MW.C.22',30052,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (924102,'MW','Rumphi','Rumphi',-11.0186,33.8575,'P','PPLA2','MW.N','MW.N.21',20727,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (924491,'MW','Ntchisi','Ntchisi',-13.5278,33.9149,'P','PPLA2','MW.C','MW.C.20',7918,'Africa/Blantyre',1,'2011-06-01 23:00:00','2011-06-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (924492,'MW','Ntcheu','Ntcheu',-14.8203,34.6359,'P','PPLA2','MW.C','MW.C.16',10445,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (924572,'MW','Nsanje','Nsanje',-16.92,35.262,'P','PPLA2','MW.S','MW.S.19',21774,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (924705,'MW','Nkhotakota','Nkhotakota',-12.9274,34.2961,'P','PPLA2','MW.C','MW.C.18',24865,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (924732,'MW','Nkhata Bay','Nkhata Bay',-11.6066,34.2907,'P','PPLA2','MW.N','MW.N.17',11721,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (925475,'MW','Mzuzu','Mzuzu',-11.4656,34.0207,'P','PPLA','MW.N','MW.N.15',175345,'Africa/Blantyre',1,'2013-08-04 23:00:00','2013-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (925498,'MW','Mzimba','Mzimba',-11.9,33.6,'P','PPLA2','MW.N','MW.N.15',19308,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (925596,'MW','Mwanza','Mwanza',-15.6026,34.5248,'P','PPLA2','MW.S','MW.S.25',11379,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (925789,'MW','Mulanje','Mulanje',-16.0316,35.5,'P','PPLA2','MW.S','MW.S.29',16483,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (926087,'MW','Mponela','Mponela',-13.5319,33.7401,'P','PPL','MW.C','MW.C.07',11222,'Africa/Blantyre',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (926308,'MW','Monkey Bay','Monkey Bay',-14.0824,34.9165,'P','PPL','MW.S','MW.S.12',11619,'Africa/Blantyre',1,'2015-12-12 23:00:00','2015-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (926747,'MW','Mchinji','Mchinji',-13.7984,32.8802,'P','PPLA2','MW.C','MW.C.13',18305,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (927246,'MW','Mangochi','Mangochi',-14.4782,35.2645,'P','PPLA2','MW.S','MW.S.12',40236,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (927792,'MW','Luchenza','Luchenza',-16.0069,35.3095,'P','PPL','MW.S','MW.S.05',11939,'Africa/Blantyre',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (927834,'MW','Liwonde','Liwonde',-15.0667,35.2254,'P','PPL','MW.S','MW.S.28',22469,'Africa/Blantyre',1,'2013-04-26 23:00:00','2013-04-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (927856,'MW','Livingstonia','Livingstonia',-10.606,34.1063,'P','PPL','MW.N','MW.N.21',5552,'Africa/Blantyre',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (927967,'MW','Lilongwe','Lilongwe',-13.9669,33.7873,'P','PPLC','MW.C','MW.C.11',646750,'Africa/Blantyre',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (928534,'MW','Kasungu','Kasungu',-13.0333,33.4833,'P','PPLA2','MW.C','MW.C.09',42555,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (929977,'MW','Dowa','Dowa',-13.654,33.9375,'P','PPLA2','MW.C','MW.C.07',5565,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (930025,'MW','Dedza','Dedza',-14.3779,34.3332,'P','PPLA2','MW.C','MW.C.06',15608,'Africa/Blantyre',1,'2011-04-24 23:00:00','2011-04-24 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (931070,'MW','Chikwawa','Chikwawa',-16.0335,34.8009,'P','PPLA2','MW.S','MW.S.02',6987,'Africa/Blantyre',1,'2011-11-08 23:00:00','2011-11-08 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (931755,'MW','Blantyre','Blantyre',-15.785,35.0085,'P','PPLA','MW.S','MW.S.24',584877,'Africa/Blantyre',1,'2014-07-20 23:00:00','2014-07-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (931865,'MW','Balaka','Balaka',-14.9793,34.9557,'P','PPLA2','MW.S','MW.S.26',18902,'Africa/Blantyre',1,'2011-11-07 23:00:00','2011-11-07 23:00:00');


