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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (923,'ER.01','ER','Anseba','Anseba',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (924,'ER.02','ER','Debub','Debub',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (925,'ER.03','ER','Southern Red Sea','Southern Red Sea',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (926,'ER.04','ER','Gash-Barka','Gash-Barka',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (927,'ER.05','ER','Maekel','Maekel',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (928,'ER.06','ER','Northern Red Sea','Northern Red Sea',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (12638,'ER.02.328827','ER','ER.02','Serayē Āwraja','Seraye Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12639,'ER.06.329423','ER','ER.06','Sahil Āwraja','Sahil Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12640,'ER.04.335174','ER','ER.04','Hamasēn Āwraja','Hamasen Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12641,'ER.02.344451','ER','ER.02','Ākale Guzay Āwraja','Akale Guzay Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12642,'ER.04.413927','ER','ER.04','Barka Āwraja','Barka Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12643,'ER.03.413928','ER','ER.03','Denkel Āwraja','Denkel Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12644,'ER.06.413929','ER','ER.06','Semhar Āwraja','Semhar Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12645,'ER.06.413930','ER','ER.06','Senhit Āwraja','Senhit Awraja',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12646,'ER.06.9165816','ER','ER.06','Af\'abet','Af\'abet',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12647,'ER.04.9165822','ER','ER.04','Dghe','Dghe',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12648,'ER.05.9166015','ER','ER.05','Berikh','Berikh',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12649,'ER.05.9166018','ER','ER.05','Ghala Nefhi','Ghala Nefhi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12650,'ER.05.9166024','ER','ER.05','Serejaka','Serejaka',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12651,'ER.05.9166027','ER','ER.05','South Eastern Subregion','South Eastern Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12652,'ER.05.9166028','ER','ER.05','South Western Subregion','South Western Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12653,'ER.01.9166029','ER','ER.01','Adi Tekelezan Subregion','Adi Tekelezan Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12654,'ER.01.9166032','ER','ER.01','Asmat','Asmat',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12655,'ER.01.9166033','ER','ER.01','Elabered Subregion','Elabered Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12656,'ER.06.9166034','ER','ER.06','North Eastern Subregion','North Eastern Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12657,'ER.01.9166038','ER','ER.01','Hagaz Subregion','Hagaz Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12658,'ER.01.9166039','ER','ER.01','Halhal Subregion','Halhal Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12659,'ER.01.9166040','ER','ER.01','Habero Subregion','Habero Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12660,'ER.01.9166042','ER','ER.01','Kerkebet','Kerkebet',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12661,'ER.01.9166043','ER','ER.01','Keren Subregion','Keren Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12662,'ER.01.9166044','ER','ER.01','Sela Subregion','Sela Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12663,'ER.04.9166045','ER','ER.04','Akurdet Subregion','Akurdet Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12664,'ER.04.9166046','ER','ER.04','Barentu Subregion','Barentu Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12665,'ER.06.9166047','ER','ER.06','Dahlak Subregion','Dahlak Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12666,'ER.06.9166048','ER','ER.06','Ghinda Subregion','Ghinda Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12667,'ER.06.9166050','ER','ER.06','Massawa Subregion','Massawa Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12668,'ER.06.9166052','ER','ER.06','Nakfa Subregion','Nakfa Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12669,'ER.02.9166054','ER','ER.02','Dekemhare Subregion','Dekemhare Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12670,'ER.02.9166055','ER','ER.02','Mendefera Subregion','Mendefera Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12671,'ER.02.9166056','ER','ER.02','Senafe Subregion','Senafe Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12672,'ER.03.9166057','ER','ER.03','Southern Denkalya Subregion','Southern Denkalya Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12673,'ER.02.10114297','ER','ER.02','Mai-Mne Subregion','Mai-Mne Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12674,'ER.04.10172859','ER','ER.04','Logo Anseba','Logo Anseba',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12675,'ER.04.10177504','ER','ER.04','Teseney Subregion','Teseney Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12676,'ER.04.10177509','ER','ER.04','Haykota Subregion','Haykota Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12677,'ER.04.10177510','ER','ER.04','Gogne Subregion','Gogne Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12678,'ER.04.10177511','ER','ER.04','Mogolo Subregion','Mogolo Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12679,'ER.04.10177512','ER','ER.04','Mensura Subregion','Mensura Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12680,'ER.04.10177513','ER','ER.04','Shambuko Subregion','Shambuko Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12681,'ER.02.10177514','ER','ER.02','Areza Subregion','Areza Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12682,'ER.03.10375723','ER','ER.03','Central Denkalya Subregion','Central Denkalya Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12683,'ER.01.10627798','ER','ER.01','Geleb Subregion','Geleb Subregion',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12684,'ER.06.10628668','ER','ER.06','Ghelaelo','Ghelaelo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12685,'ER.06.10628671','ER','ER.06','Foro Sub-Region','Foro Sub-Region',1);

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

INSERT INTO `<<prefix>>cities` VALUES (330546,'ER','Massawa','Massawa',15.6081,39.4745,'P','PPLA','ER.06',NULL,23100,'Africa/Asmara',1,'2012-08-04 23:00:00','2012-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (333287,'ER','Keren','Keren',15.7779,38.4511,'P','PPLA','ER.01',NULL,74800,'Africa/Asmara',1,'2012-09-10 23:00:00','2012-09-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (338345,'ER','Edd','Edd',13.9309,41.6938,'P','PPL','ER.03',NULL,11259,'Africa/Asmara',1,'2012-08-04 23:00:00','2012-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (339537,'ER','Dek’emhāre','Dek\'emhare',15.07,39.0475,'P','PPL','ER.02',NULL,10959,'Africa/Asmara',1,'2012-09-05 23:00:00','2012-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (342711,'ER','Barentu','Barentu',15.1058,37.5907,'P','PPLA','ER.04',NULL,15891,'Africa/Asmara',1,'2012-09-05 23:00:00','2012-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (343300,'ER','Asmara','Asmara',15.338,38.9318,'P','PPLC','ER.05',NULL,563930,'Africa/Asmara',1,'2013-01-10 23:00:00','2013-01-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (343386,'ER','Assab','Assab',13.0092,42.7394,'P','PPLA','ER.03',NULL,21300,'Africa/Asmara',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (344426,'ER','Ak’ordat','Ak\'ordat',15.548,37.8829,'P','PPL','ER.04',NULL,8857,'Africa/Asmara',1,'2012-09-05 23:00:00','2012-09-05 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (344901,'ER','Mendefera','Mendefera',14.8872,38.8153,'P','PPLA','ER.02',NULL,17781,'Africa/Asmara',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (345046,'ER','Adi Keyh','Adi Keyh',14.8444,39.3772,'P','PPL','ER.02',NULL,13061,'Africa/Asmara',1,'2013-06-06 23:00:00','2013-06-06 23:00:00');


