text: -- MySQL dump 10.13  Distrib 5.6.35, for osx10.9 (x86_64)
  --
  -- Host: localhost    Database: Quickadclassified
  -- ------------------------------------------------------
  -- Server version	5.6.35
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  /*!40103 SET TIME_ZONE='+00:00' */;
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  
  --
  -- Dumping data for table `<<prefix>>subadmin1`
  --
  
  /*!40000 ALTER TABLE `<<prefix>>subadmin1` DISABLE KEYS */;
  INSERT INTO `<<prefix>>subadmin1` VALUES (3668,'UG.C','UG','Central Region','Central Region',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3669,'UG.E','UG','Eastern Region','Eastern Region',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3670,'UG.N','UG','Northern Region','Northern Region',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (3671,'UG.W','UG','Western Region','Western Region',1);
  /*!40000 ALTER TABLE `<<prefix>>subadmin1` ENABLE KEYS */;
  
  --
  -- Dumping data for table `<<prefix>>subadmin2`
  --
  
  /*!40000 ALTER TABLE `<<prefix>>subadmin2` DISABLE KEYS */;
  INSERT INTO `<<prefix>>subadmin2` VALUES (39329,'UG.C.89','UG','UG.C','Mpigi District','Mpigi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39330,'UG.E.E1','UG','UG.E','Namutumba District','Namutumba District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39331,'UG.E.C3','UG','UG.E','Bukedea District','Bukedea District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39332,'UG.N.26','UG','UG.N','Apac District','Apac District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39333,'UG.N.77','UG','UG.N','Arua District','Arua District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39334,'UG.W.28','UG','UG.W','Bundibugyo District','Bundibugyo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39335,'UG.W.29','UG','UG.W','Bushenyi District','Bushenyi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39336,'UG.N.30','UG','UG.N','Gulu District','Gulu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39337,'UG.W.31','UG','UG.W','Hoima District','Hoima District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39338,'UG.E.78','UG','UG.E','Iganga District','Iganga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39339,'UG.E.33','UG','UG.E','Jinja District','Jinja District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39340,'UG.W.34','UG','UG.W','Kabale District','Kabale District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39341,'UG.W.79','UG','UG.W','Kabarole District','Kabarole District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39342,'UG.C.36','UG','UG.C','Kalangala District','Kalangala District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39343,'UG.C.37','UG','UG.C','Kampala District','Kampala District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39344,'UG.E.38','UG','UG.E','Kamuli District','Kamuli District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39345,'UG.E.39','UG','UG.E','Kapchorwa District','Kapchorwa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39346,'UG.W.40','UG','UG.W','Kasese District','Kasese District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39347,'UG.W.41','UG','UG.W','Kibale District','Kibale District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39348,'UG.C.42','UG','UG.C','Kiboga District','Kiboga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39349,'UG.W.43','UG','UG.W','Kisoro District','Kisoro District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39350,'UG.N.84','UG','UG.N','Kitgum District','Kitgum District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39351,'UG.N.45','UG','UG.N','Kotido District','Kotido District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39352,'UG.E.46','UG','UG.E','Kumi District','Kumi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39353,'UG.N.47','UG','UG.N','Lira District','Lira District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39354,'UG.C.70','UG','UG.C','Luwero District','Luwero District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39355,'UG.W.50','UG','UG.W','Masindi District','Masindi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39356,'UG.E.87','UG','UG.E','Mbale District','Mbale District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39357,'UG.W.52','UG','UG.W','Mbarara District','Mbarara District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39358,'UG.N.88','UG','UG.N','Moroto District','Moroto District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39359,'UG.N.72','UG','UG.N','Moyo District','Moyo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39360,'UG.C.56','UG','UG.C','Mubende District','Mubende District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39361,'UG.C.90','UG','UG.C','Mukono District','Mukono District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39362,'UG.N.58','UG','UG.N','Nebbi District','Nebbi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39363,'UG.W.59','UG','UG.W','Ntungamo District','Ntungamo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39364,'UG.E.60','UG','UG.E','Pallisa District','Pallisa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39365,'UG.C.61','UG','UG.C','Rakai District','Rakai District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39366,'UG.W.93','UG','UG.W','Rukungiri District','Rukungiri District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39367,'UG.E.95','UG','UG.E','Soroti District','Soroti District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39368,'UG.E.76','UG','UG.E','Tororo District','Tororo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39369,'UG.N.65','UG','UG.N','Adjumani District','Adjumani District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39370,'UG.E.66','UG','UG.E','Bugiri District','Bugiri District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39371,'UG.E.67','UG','UG.E','Busia District','Busia District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39372,'UG.E.69','UG','UG.E','Katakwi District','Katakwi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39373,'UG.C.73','UG','UG.C','Nakasongola District','Nakasongola District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39374,'UG.C.74','UG','UG.C','Sembabule District','Sembabule District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39375,'UG.E.80','UG','UG.E','Kaberamaido District','Kaberamaido District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39376,'UG.W.81','UG','UG.W','Kamwenge District','Kamwenge District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39377,'UG.W.82','UG','UG.W','Kanungu District','Kanungu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39378,'UG.C.83','UG','UG.C','Kayunga District','Kayunga District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39379,'UG.W.85','UG','UG.W','Kyenjojo District','Kyenjojo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39380,'UG.E.86','UG','UG.E','Mayuge District','Mayuge District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39381,'UG.N.91','UG','UG.N','Nakapiripirit District','Nakapiripirit District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39382,'UG.N.92','UG','UG.N','Pader District','Pader District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39383,'UG.E.94','UG','UG.E','Sironko District','Sironko District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39384,'UG.C.96','UG','UG.C','Wakiso District','Wakiso District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39385,'UG.N.97','UG','UG.N','Yumbe District','Yumbe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39386,'UG.N.B6','UG','UG.N','Abim District','Abim District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39387,'UG.N.B7','UG','UG.N','Amolatar District','Amolatar District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39388,'UG.E.B8','UG','UG.E','Amuria District','Amuria District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39389,'UG.N.B9','UG','UG.N','Amuru District','Amuru District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39390,'UG.E.C1','UG','UG.E','Budaka District','Budaka District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39391,'UG.E.C2','UG','UG.E','Bududa District','Bududa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39392,'UG.W.C5','UG','UG.W','Bulisa District','Bulisa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39393,'UG.E.C6','UG','UG.E','Butaleja District','Butaleja District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39394,'UG.N.C7','UG','UG.N','Dokolo District','Dokolo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39395,'UG.W.C8','UG','UG.W','Ibanda District','Ibanda District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39396,'UG.W.C9','UG','UG.W','Isingiro District','Isingiro District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39397,'UG.N.D1','UG','UG.N','Kaabong District','Kaabong District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39398,'UG.E.D2','UG','UG.E','Kaliro District','Kaliro District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39399,'UG.W.D3','UG','UG.W','Kiruhura District','Kiruhura District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39400,'UG.N.D4','UG','UG.N','Koboko District','Koboko District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39401,'UG.C.D5','UG','UG.C','Lyantonde District','Lyantonde District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39402,'UG.E.D6','UG','UG.E','Manafwa District','Manafwa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39403,'UG.N.D7','UG','UG.N','Maracha District','Maracha District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39404,'UG.C.D8','UG','UG.C','Mityana District','Mityana District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39405,'UG.C.D9','UG','UG.C','Nakaseke District','Nakaseke District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39406,'UG.N.E2','UG','UG.N','Oyam District','Oyam District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39407,'UG.E.C4','UG','UG.E','Bukwa District','Bukwa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39408,'UG.N.H2','UG','UG.N','Nwoya District','Nwoya District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39409,'UG.C.F5','UG','UG.C','Kalungu District','Kalungu District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39410,'UG.C.F1','UG','UG.C','Butambala District','Butambala District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39411,'UG.N.E5','UG','UG.N','Amudat District','Amudat District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39412,'UG.N.G8','UG','UG.N','Napak District','Napak District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39413,'UG.N.G3','UG','UG.N','Lamwo District','Lamwo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39414,'UG.N.H7','UG','UG.N','Zombo District','Zombo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39415,'UG.W.F7','UG','UG.W','Kiryandongo District','Kiryandongo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39416,'UG.N.F8','UG','UG.N','Kole District','Kole District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39417,'UG.N.E3','UG','UG.N','Agago District','Agago District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39418,'UG.N.H3','UG','UG.N','Otuke District','Otuke District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39419,'UG.N.E4','UG','UG.N','Alebtong District','Alebtong District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39420,'UG.E.H5','UG','UG.E','Serere District','Serere District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39421,'UG.E.G9','UG','UG.E','Ngora District','Ngora District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39422,'UG.E.F3','UG','UG.E','Buyende District','Buyende District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39423,'UG.E.F6','UG','UG.E','Kibuku District','Kibuku District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39424,'UG.E.E9','UG','UG.E','Bulambuli District','Bulambuli District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39425,'UG.E.F9','UG','UG.E','Kween District','Kween District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39426,'UG.E.G7','UG','UG.E','Namayingo District','Namayingo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39427,'UG.C.F2','UG','UG.C','Buvuma District','Buvuma District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39428,'UG.C.E7','UG','UG.C','Buikwe District','Buikwe District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39429,'UG.C.F4','UG','UG.C','Gomba District','Gomba District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39430,'UG.C.E8','UG','UG.C','Bukomansimbi District','Bukomansimbi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39431,'UG.C.G5','UG','UG.C','Lwengo District','Lwengo District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39432,'UG.W.G2','UG','UG.W','Kyegegwa District','Kyegegwa District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39433,'UG.C.G1','UG','UG.C','Kyankwanzi District','Kyankwanzi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39434,'UG.W.H1','UG','UG.W','Ntoroko District','Ntoroko District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39435,'UG.W.H4','UG','UG.W','Rubirizi District','Rubirizi District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39436,'UG.W.E6','UG','UG.W','Buhweju District','Buhweju District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39437,'UG.W.G6','UG','UG.W','Mitoma District','Mitoma District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39438,'UG.W.H6','UG','UG.W','Sheema District','Sheema District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39439,'UG.E.G4','UG','UG.E','Luuka District','Luuka District',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (39440,'UG.C.71','UG','UG.C','Masaka District','Masaka District',1);
  /*!40000 ALTER TABLE `<<prefix>>subadmin2` ENABLE KEYS */;
  
  --
  -- Dumping data for table `<<prefix>>cities`
  --
  
  /*!40000 ALTER TABLE `<<prefix>>cities` DISABLE KEYS */;
  INSERT INTO `<<prefix>>cities` VALUES (225835,'UG','Yumbe','Yumbe',3.46506,31.2469,'P','PPLA2','UG.N','UG.N.97',24300,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (225858,'UG','Wobulenzi','Wobulenzi',0.72833,32.5122,'P','PPL','UG.C','UG.C.70',24415,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (225964,'UG','Wakiso','Wakiso',0.40444,32.4594,'P','PPLA2','UG.C','UG.C.96',20530,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (226110,'UG','Tororo','Tororo',0.69299,34.1809,'P','PPLA2','UG.E','UG.E.76',40400,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (226234,'UG','Soroti','Soroti',1.71464,33.6111,'P','PPLA2','UG.E','UG.E.95',56400,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (226267,'UG','Sironko','Sironko',1.23132,34.2477,'P','PPLA2','UG.E','UG.E.94',14000,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (226600,'UG','Rukungiri','Rukungiri',-0.84111,29.9419,'P','PPLA2','UG.W','UG.W.93',14000,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (226823,'UG','Pallisa','Pallisa',1.145,33.7094,'P','PPLA2','UG.E','UG.E.60',30745,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (226853,'UG','Paidha','Paidha',2.41669,30.9855,'P','PPL','UG.N','UG.N.H7',28348,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (226866,'UG','Pader Palwo','Pader Palwo',2.80056,33.135,'P','PPL','UG.N','UG.N.E3',11152,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (227528,'UG','Nyachera','Nyachera',-0.9,30.4167,'P','PPL','UG.W','UG.W.59',30509,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (227592,'UG','Ntungamo','Ntungamo',-0.88333,29.65,'P','PPL','UG.W','UG.W.82',16915,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (227593,'UG','Ntungamo','Ntungamo',-0.87944,30.2642,'P','PPLA2','UG.W','UG.W.59',15300,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (227812,'UG','Njeru','Njeru',0.44166,33.1792,'P','PPL','UG.C','UG.C.E7',61952,'Africa/Kampala',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (227904,'UG','Nebbi','Nebbi',2.47826,31.0889,'P','PPLA2','UG.N','UG.N.58',30354,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (228227,'UG','Namasuba','Namasuba',0.68944,32.4214,'P','PPL','UG.C','UG.C.D9',22507,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (228418,'UG','Nakasongola','Nakasongola',1.30889,32.4564,'P','PPLA2','UG.C','UG.C.73',6921,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (228853,'UG','Mukono','Mukono',0.35333,32.7553,'P','PPLA2','UG.C','UG.C.90',67290,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (228971,'UG','Mubende','Mubende',0.55849,31.3949,'P','PPLA2','UG.C','UG.C.56',18936,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229024,'UG','Mpigi','Mpigi',0.225,32.3136,'P','PPLA2','UG.C','UG.C.89',11082,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229059,'UG','Moyo','Moyo',3.66088,31.7247,'P','PPLA2','UG.N','UG.N.72',18800,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229112,'UG','Moroto','Moroto',2.53453,34.6666,'P','PPLA2','UG.N','UG.N.88',10300,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229139,'UG','Mityana','Mityana',0.4175,32.0228,'P','PPLA2','UG.C','UG.C.D8',41131,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229268,'UG','Mbarara','Mbarara',-0.60467,30.6485,'P','PPLA','UG.W','UG.W.52',97500,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229278,'UG','Mbale','Mbale',1.08209,34.175,'P','PPLA2','UG.E','UG.E.87',76493,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229292,'UG','Mayuge','Mayuge',0.45972,33.4803,'P','PPLA2','UG.E','UG.E.86',11503,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229361,'UG','Masindi Port','Masindi Port',1.69606,32.0861,'P','PPL','UG.W','UG.W.F7',7828,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229362,'UG','Masindi','Masindi',1.67444,31.715,'P','PPLA2','UG.W','UG.W.50',31486,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229380,'UG','Masaka','Masaka',-0.33379,31.7341,'P','PPLA2','UG.C','UG.C.71',65373,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229599,'UG','Lyantonde','Lyantonde',-0.40306,31.1572,'P','PPLA2','UG.C','UG.C.D5',8039,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229746,'UG','Luwero','Luwero',0.84917,32.4731,'P','PPLA2','UG.C','UG.C.70',28338,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (229911,'UG','Lugazi','Lugazi',0.36788,32.9376,'P','PPL','UG.C','UG.C.E7',35036,'Africa/Kampala',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (230166,'UG','Lira','Lira',2.2499,32.8998,'P','PPLA2','UG.N','UG.N.47',119323,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (230256,'UG','Kyotera','Kyotera',-0.61556,31.5175,'P','PPL','UG.C','UG.C.61',8472,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (230299,'UG','Kyenjojo','Kyenjojo',0.63278,30.6214,'P','PPLA2','UG.W','UG.W.85',18600,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (230584,'UG','Kumi','Kumi',1.46083,33.9361,'P','PPLA2','UG.E','UG.E.46',11400,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (230617,'UG','Kotido','Kotido',2.98056,34.1331,'P','PPLA2','UG.N','UG.N.45',18800,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (230893,'UG','Kitgum','Kitgum',3.27833,32.8867,'P','PPLA2','UG.N','UG.N.84',56891,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (230993,'UG','Kisoro','Kisoro',-1.28538,29.685,'P','PPLA2','UG.W','UG.W.43',12400,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (231103,'UG','Kiruhura','Kiruhura',-0.19664,30.8445,'P','PPLA2','UG.W','UG.W.D3',14000,'Africa/Kampala',1,'2016-11-30 23:00:00','2016-11-30 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (231139,'UG','Kireka','Kireka',0.3475,32.6492,'P','PPL','UG.C','UG.C.96',17947,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (231250,'UG','Kilembe','Kilembe',0.19835,30.013,'P','PPL','UG.W','UG.W.40',7914,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (231426,'UG','Kigorobya','Kigorobya',1.6162,31.3089,'P','PPL','UG.W','UG.W.31',5420,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (231550,'UG','Kiboga','Kiboga',0.91611,31.7742,'P','PPLA2','UG.C','UG.C.42',14512,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (231617,'UG','Kibale','Kibale',0.8,31.0667,'P','PPLA2','UG.W','UG.W.41',5200,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (231696,'UG','Kayunga','Kayunga',0.7025,32.8886,'P','PPLA2','UG.C','UG.C.83',21704,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (232066,'UG','Kasese','Kasese',0.18333,30.0833,'P','PPLA2','UG.W','UG.W.40',67269,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (232235,'UG','Kapchorwa','Kapchorwa',1.40096,34.4504,'P','PPLA2','UG.E','UG.E.39',11300,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (232287,'UG','Kanungu','Kanungu',-0.9575,29.7897,'P','PPLA2','UG.W','UG.W.82',14600,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (232371,'UG','Kamwenge','Kamwenge',0.1866,30.4539,'P','PPLA2','UG.W','UG.W.81',17169,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (232397,'UG','Kamuli','Kamuli',0.94722,33.1197,'P','PPLA2','UG.E','UG.E.38',12764,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (232422,'UG','Kampala','Kampala',0.31628,32.5822,'P','PPLC','UG.C','UG.C.37',1353189,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (232713,'UG','Kajansi','Kajansi',0.21548,32.5345,'P','PPL','UG.C','UG.C.96',7530,'Africa/Kampala',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233070,'UG','Kabale','Kabale',-1.24857,29.9899,'P','PPLA2','UG.W','UG.W.34',43500,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233114,'UG','Jinja','Jinja',0.43902,33.2032,'P','PPLA','UG.E','UG.E.33',93061,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233275,'UG','Iganga','Iganga',0.60917,33.4686,'P','PPLA2','UG.E','UG.E.78',45024,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233299,'UG','Ibanda','Ibanda',-0.13398,30.4962,'P','PPLA2','UG.W','UG.W.C8',31000,'Africa/Kampala',1,'2016-11-30 23:00:00','2016-11-30 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233312,'UG','Hoima','Hoima',1.43314,31.3524,'P','PPLA2','UG.W','UG.W.31',39625,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233346,'UG','Gulu','Gulu',2.77457,32.299,'P','PPLA','UG.N','UG.N.30',146858,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233476,'UG','Fort Portal','Fort Portal',0.66174,30.2748,'P','PPLA2','UG.W','UG.W.79',42670,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233508,'UG','Entebbe','Entebbe',0.05621,32.4795,'P','PPL','UG.C','UG.C.96',62969,'Africa/Kampala',1,'2017-06-05 23:00:00','2017-06-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233725,'UG','Byakabanda','Byakabanda',-0.7425,31.4064,'P','PPL','UG.C','UG.C.61',7608,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233730,'UG','Bwizibwera','Bwizibwera',-0.59167,30.6286,'P','PPL','UG.W','UG.W.52',79157,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233738,'UG','Bweyogerere','Bweyogerere',0.35773,32.6633,'P','PPL','UG.C','UG.C.96',11473,'Africa/Kampala',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (233886,'UG','Buwenge','Buwenge',0.64996,33.1713,'P','PPL','UG.E','UG.E.33',15130,'Africa/Kampala',1,'2017-06-05 23:00:00','2017-06-05 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (234077,'UG','Busia','Busia',0.46588,34.0922,'P','PPLA2','UG.E','UG.E.67',43200,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (234092,'UG','Busembatia','Busembatia',0.77725,33.6236,'P','PPL','UG.E','UG.E.78',15889,'Africa/Kampala',1,'2017-02-03 23:00:00','2017-02-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (234178,'UG','Bundibugyo','Bundibugyo',0.71117,30.0647,'P','PPLA2','UG.W','UG.W.28',16919,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (234565,'UG','Bugiri','Bugiri',0.57139,33.7417,'P','PPLA2','UG.E','UG.E.G7',22500,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (234578,'UG','Bugembe','Bugembe',0.48213,33.2407,'P','PPL','UG.E','UG.E.33',11598,'Africa/Kampala',1,'2016-12-02 23:00:00','2016-12-02 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (235039,'UG','Arua','Arua',3.02013,30.9111,'P','PPLA2','UG.N','UG.N.77',55585,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (235130,'UG','Apac','Apac',1.97556,32.5386,'P','PPLA2','UG.N','UG.N.26',11776,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (235489,'UG','Adjumani','Adjumani',3.37786,31.7909,'P','PPLA2','UG.N','UG.N.65',28700,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (448227,'UG','Pader','Pader',3.05,33.2167,'P','PPLA2','UG.N','UG.N.E3',11600,'Africa/Kampala',1,'2016-06-21 23:00:00','2016-06-21 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (448232,'UG','Margherita','Margherita',0.41861,29.8911,'P','PPL','UG.W','UG.W.40',5109,'Africa/Kampala',1,'2012-04-27 23:00:00','2012-04-27 23:00:00');
  /*!40000 ALTER TABLE `<<prefix>>cities` ENABLE KEYS */;
  /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  
  /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  
  -- Dump completed
  