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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (3947,'ZW.02','ZW','Midlands','Midlands',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3948,'ZW.07','ZW','Matabeleland South','Matabeleland South',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3949,'ZW.06','ZW','Matabeleland North','Matabeleland North',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3950,'ZW.08','ZW','Masvingo','Masvingo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3951,'ZW.05','ZW','Mashonaland West','Mashonaland West',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3952,'ZW.04','ZW','Mashonaland East','Mashonaland East',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3953,'ZW.03','ZW','Mashonaland Central','Mashonaland Central',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3954,'ZW.01','ZW','Manicaland','Manicaland',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3955,'ZW.09','ZW','Bulawayo','Bulawayo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (3956,'ZW.10','ZW','Harare','Harare',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (44417,'ZW.02.878548','ZW','ZW.02','Zvishavane District','Zvishavane District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44418,'ZW.04.879178','ZW','ZW.04','Hwedza District','Hwedza District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44419,'ZW.07.879611','ZW','ZW.07','Umzingwane District','Umzingwane District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44420,'ZW.02.881163','ZW','ZW.02','Shurugwi District','Shurugwi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44421,'ZW.03.881344','ZW','ZW.03','Shamva District','Shamva District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44422,'ZW.04.881519','ZW','ZW.04','Seke District','Seke District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44423,'ZW.03.882083','ZW','ZW.03','Rushinga District','Rushinga District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44424,'ZW.01.883480','ZW','ZW.01','Nyanga District','Nyanga District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44425,'ZW.06.883763','ZW','ZW.06','Tsholotsho District','Tsholotsho District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44426,'ZW.06.884216','ZW','ZW.06','Nkayi District','Nkayi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44427,'ZW.08.884594','ZW','ZW.08','Zaka','Zaka',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44428,'ZW.08.884756','ZW','ZW.08','Mwenezi District','Mwenezi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44429,'ZW.04.884926','ZW','ZW.04','Mutoko District','Mutoko District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44430,'ZW.01.884977','ZW','ZW.01','Mutasa District','Mutasa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44431,'ZW.01.884978','ZW','ZW.01','Mutare District','Mutare District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44432,'ZW.04.885172','ZW','ZW.04','Murehwa District','Murehwa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44433,'ZW.04.885457','ZW','ZW.04','Mudzi District','Mudzi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44434,'ZW.02.886328','ZW','ZW.02','Mberengwa District','Mberengwa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44435,'ZW.03.886383','ZW','ZW.03','Mazowe District','Mazowe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44436,'ZW.07.886636','ZW','ZW.07','Matobo','Matobo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44437,'ZW.08.886762','ZW','ZW.08','Masvingo District','Masvingo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44438,'ZW.04.886989','ZW','ZW.04','Marondera District','Marondera District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44439,'ZW.01.887718','ZW','ZW.01','Makoni District','Makoni District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44440,'ZW.05.887723','ZW','ZW.05','Makonde District','Makonde District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44441,'ZW.06.888223','ZW','ZW.06','Lupane District','Lupane District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44442,'ZW.02.888708','ZW','ZW.02','Kwekwe District','Kwekwe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44443,'ZW.05.889214','ZW','ZW.05','Kariba District','Kariba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44444,'ZW.05.889452','ZW','ZW.05','Kadoma District','Kadoma District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44445,'ZW.07.889793','ZW','ZW.07','Insiza District','Insiza District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44446,'ZW.06.889941','ZW','ZW.06','Hwange District','Hwange District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44447,'ZW.05.889953','ZW','ZW.05','Hurungwe District','Hurungwe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44448,'ZW.10.890298','ZW','ZW.10','Harare District','Harare District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44449,'ZW.02.890420','ZW','ZW.02','Gweru District','Gweru District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44450,'ZW.07.890515','ZW','ZW.07','Gwanda District','Gwanda District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44451,'ZW.08.890589','ZW','ZW.08','Gutu District','Gutu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44452,'ZW.03.890599','ZW','ZW.03','Guruve District','Guruve District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44453,'ZW.04.890848','ZW','ZW.04','Goromonzi District','Goromonzi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44454,'ZW.02.890981','ZW','ZW.02','Gokwe North District','Gokwe North District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44455,'ZW.03.892597','ZW','ZW.03','Mount Darwin','Mount Darwin',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44456,'ZW.08.893171','ZW','ZW.08','Chivi District','Chivi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44457,'ZW.02.893405','ZW','ZW.02','Chirumanzu District','Chirumanzu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44458,'ZW.08.893482','ZW','ZW.08','Chiredzi District','Chiredzi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44459,'ZW.01.893548','ZW','ZW.01','Chipinge District','Chipinge District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44460,'ZW.01.893811','ZW','ZW.01','Chimanimani District','Chimanimani District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44461,'ZW.05.894238','ZW','ZW.05','Chegutu District','Chegutu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44462,'ZW.04.894293','ZW','ZW.04','Chikomba District','Chikomba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44463,'ZW.03.894459','ZW','ZW.03','Centenary District','Centenary District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44464,'ZW.09.894700','ZW','ZW.09','Bulawayo District','Bulawayo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44465,'ZW.07.894702','ZW','ZW.07','Mangwe District','Mangwe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44466,'ZW.01.894711','ZW','ZW.01','Buhera District','Buhera District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44467,'ZW.06.894741','ZW','ZW.06','Bubi District','Bubi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44468,'ZW.06.895055','ZW','ZW.06','Binga District','Binga District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44469,'ZW.03.895060','ZW','ZW.03','Bindura District','Bindura District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44470,'ZW.08.895080','ZW','ZW.08','Bikita District','Bikita District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44471,'ZW.07.895268','ZW','ZW.07','Beitbridge District','Beitbridge District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44472,'ZW.02.8260609','ZW','ZW.02','Gokwe South District','Gokwe South District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44473,'ZW.08.10172877','ZW','ZW.08','Zaka District','Zaka District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44474,'ZW.07.10800403','ZW','ZW.07','Bulilima District','Bulilima District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44475,'ZW.05.10800410','ZW','ZW.05','Zvimba District','Zvimba District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44476,'ZW.04.10800411','ZW','ZW.04','Uzumba-Maramba-Pfungwe District','Uzumba-Maramba-Pfungwe District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44477,'ZW.06.10800412','ZW','ZW.06','Umguza District','Umguza District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (44478,'ZW.01.11204515','ZW','ZW.01','Mossurize District','Mossurize District',1);

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

INSERT INTO `<<prefix>>cities` VALUES (878549,'ZW','Zvishavane','Zvishavane',-20.3267,30.0665,'P','PPL','ZW.08',NULL,35896,'Africa/Harare',1,'2014-05-11 23:00:00','2014-05-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (879431,'ZW','Victoria Falls','Victoria Falls',-17.9328,25.8307,'P','PPL','ZW.06','ZW.06.889941',35761,'Africa/Harare',1,'2015-01-13 23:00:00','2015-01-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (881164,'ZW','Shurugwi','Shurugwi',-19.6702,30.0059,'P','PPL','ZW.02',NULL,17075,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (881345,'ZW','Shamva','Shamva',-17.3116,31.5756,'P','PPL','ZW.03',NULL,10317,'Africa/Harare',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (882100,'ZW','Rusape','Rusape',-18.5278,32.1284,'P','PPL','ZW.01',NULL,29292,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (882599,'ZW','Redcliff','Redcliff',-19.0333,29.7833,'P','PPL','ZW.02',NULL,33197,'Africa/Harare',1,'2013-03-11 23:00:00','2013-03-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (882955,'ZW','Penhalonga','Penhalonga',-18.8911,32.6978,'P','PPL','ZW.01',NULL,7681,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (884141,'ZW','Norton','Norton',-17.8833,30.7,'P','PPL','ZW.05',NULL,52054,'Africa/Harare',1,'2013-03-11 23:00:00','2013-03-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (884798,'ZW','Mvurwi','Mvurwi',-17.0333,30.85,'P','PPL','ZW.03',NULL,7970,'Africa/Harare',1,'2013-03-11 23:00:00','2013-03-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (884927,'ZW','Mutoko','Mutoko',-17.397,32.2268,'P','PPL','ZW.04',NULL,9532,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (884979,'ZW','Mutare','Mutare',-18.9707,32.6709,'P','PPLA','ZW.01',NULL,184205,'Africa/Harare',1,'2010-08-02 23:00:00','2010-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (885159,'ZW','Murehwa','Murehwa',-17.6432,31.784,'P','PPL','ZW.04',NULL,8559,'Africa/Harare',1,'2014-05-11 23:00:00','2014-05-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (885800,'ZW','Mount Darwin','Mount Darwin',-16.7725,31.5838,'P','PPL','ZW.03',NULL,6349,'Africa/Harare',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (886146,'ZW','Mhangura','Mhangura',-16.8939,30.1683,'P','PPL','ZW.05',NULL,6503,'Africa/Harare',1,'2014-04-05 23:00:00','2014-04-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (886384,'ZW','Mazowe','Mazowe',-17.504,30.9739,'P','PPL','ZW.03',NULL,9966,'Africa/Harare',1,'2014-03-18 23:00:00','2014-03-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (886763,'ZW','Masvingo','Masvingo',-20.0637,30.8277,'P','PPLA','ZW.08',NULL,76290,'Africa/Harare',1,'2010-08-02 23:00:00','2010-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (886864,'ZW','Mashava','Mashava',-20.0366,30.4823,'P','PPL','ZW.08',NULL,12994,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (886990,'ZW','Marondera','Marondera',-18.1853,31.5519,'P','PPLA','ZW.04',NULL,57082,'Africa/Harare',1,'2010-08-02 23:00:00','2010-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (888225,'ZW','Lupane','Lupane',-18.9315,27.807,'P','PPLA','ZW.06',NULL,1200,'Africa/Harare',1,'2010-08-12 23:00:00','2010-08-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (888710,'ZW','Kwekwe','Kwekwe',-18.9281,29.8149,'P','PPL','ZW.02',NULL,99149,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (889191,'ZW','Karoi','Karoi',-16.8099,29.6925,'P','PPL','ZW.05',NULL,25030,'Africa/Harare',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (889215,'ZW','Kariba','Kariba',-16.5167,28.8,'P','PPL','ZW.05',NULL,25531,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (889453,'ZW','Kadoma','Kadoma',-18.3333,29.9153,'P','PPL','ZW.05',NULL,79174,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (889723,'ZW','Inyati','Inyati',-19.6756,28.8469,'P','PPL','ZW.06',NULL,8402,'Africa/Harare',1,'2014-03-22 23:00:00','2014-03-22 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (889942,'ZW','Hwange','Hwange',-18.3645,26.4988,'P','PPL','ZW.06','ZW.06.889941',33210,'Africa/Harare',1,'2014-11-15 23:00:00','2014-11-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (890299,'ZW','Harare','Harare',-17.8277,31.0534,'P','PPLC','ZW.10',NULL,1542813,'Africa/Harare',1,'2015-06-02 23:00:00','2015-06-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (890422,'ZW','Gweru','Gweru',-19.45,29.8167,'P','PPLA','ZW.02',NULL,146073,'Africa/Harare',1,'2009-06-29 23:00:00','2009-06-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (890516,'ZW','Gwanda','Gwanda',-20.9333,29,'P','PPLA','ZW.07',NULL,14450,'Africa/Harare',1,'2009-06-29 23:00:00','2009-06-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (890983,'ZW','Gokwe','Gokwe',-18.2048,28.9349,'P','PPL','ZW.02',NULL,18942,'Africa/Harare',1,'2012-05-04 23:00:00','2012-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (891099,'ZW','Glendale','Glendale',-17.3551,31.0672,'P','PPL','ZW.03',NULL,9768,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (893172,'ZW','Chivhu','Chivhu',-19.0211,30.8922,'P','PPL','ZW.04',NULL,10369,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (893485,'ZW','Chiredzi','Chiredzi',-21.05,31.6667,'P','PPL','ZW.08',NULL,28205,'Africa/Harare',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (893549,'ZW','Chipinge','Chipinge',-20.1883,32.6236,'P','PPL','ZW.01',NULL,18860,'Africa/Harare',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (893697,'ZW','Chinhoyi','Chinhoyi',-17.3667,30.2,'P','PPLA','ZW.05',NULL,61739,'Africa/Harare',1,'2009-06-29 23:00:00','2009-06-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (894239,'ZW','Chegutu','Chegutu',-18.1302,30.1407,'P','PPL','ZW.05',NULL,47294,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (894413,'ZW','Chakari','Chakari',-18.0629,29.8925,'P','PPL','ZW.05',NULL,6472,'Africa/Harare',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (894701,'ZW','Bulawayo','Bulawayo',-20.15,28.5833,'P','PPLA','ZW.09',NULL,699385,'Africa/Harare',1,'2010-08-02 23:00:00','2010-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (895061,'ZW','Bindura','Bindura',-17.3019,31.3306,'P','PPLA','ZW.03',NULL,37423,'Africa/Harare',1,'2010-08-02 23:00:00','2010-08-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (895269,'ZW','Beitbridge','Beitbridge',-22.2167,30,'P','PPL','ZW.07',NULL,26459,'Africa/Harare',1,'2013-03-11 23:00:00','2013-03-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (895417,'ZW','Banket','Banket',-17.3833,30.4,'P','PPL','ZW.05',NULL,9641,'Africa/Harare',1,'2013-03-11 23:00:00','2013-03-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1085510,'ZW','Epworth','Epworth',-17.89,31.1475,'P','PPLX','ZW.10',NULL,123250,'Africa/Harare',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1106542,'ZW','Chitungwiza','Chitungwiza',-18.0127,31.0756,'P','PPL','ZW.10',NULL,340360,'Africa/Harare',1,'2012-01-19 23:00:00','2012-01-19 23:00:00');


