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 (881,'EE.21','EE','Võrumaa','Vorumaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (882,'EE.20','EE','Viljandimaa','Viljandimaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (883,'EE.19','EE','Valgamaa','Valgamaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (884,'EE.18','EE','Tartu','Tartu',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (885,'EE.14','EE','Saare','Saare',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (886,'EE.13','EE','Raplamaa','Raplamaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (887,'EE.12','EE','Põlvamaa','Polvamaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (888,'EE.11','EE','Pärnumaa','Paernumaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (889,'EE.08','EE','Lääne-Virumaa','Laeaene-Virumaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (890,'EE.07','EE','Lääne','Laeaene',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (891,'EE.05','EE','Jõgevamaa','Jogevamaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (892,'EE.04','EE','Järvamaa','Jaervamaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (893,'EE.03','EE','Ida-Virumaa','Ida-Virumaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (894,'EE.02','EE','Hiiumaa','Hiiumaa',1);
  INSERT INTO `<<prefix>>subadmin1` VALUES (895,'EE.01','EE','Harjumaa','Harjumaa',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 (12427,'EE.03.0321','EE','EE.03','Kohtla-Järve linn','Kohtla-Jaerve linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12428,'EE.03.0511','EE','EE.03','Narva linn','Narva linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12429,'EE.11.0624','EE','EE.11','Pärnu linn','Paernu linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12430,'EE.03.0735','EE','EE.03','Sillamäe linn','Sillamaee linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12431,'EE.01.0784','EE','EE.01','Tallinn','Tallinn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12432,'EE.07.0184','EE','EE.07','Haapsalu linn','Haapsalu linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12433,'EE.08.0191','EE','EE.08','Haljala vald','Haljala vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12434,'EE.01.0198','EE','EE.01','Harku vald','Harku vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12435,'EE.11.0214','EE','EE.11','Häädemeeste vald','Haeaedemeeste vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12436,'EE.01.0245','EE','EE.01','Jõelähtme vald','Joelaehtme vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12437,'EE.05.0247','EE','EE.05','Jõgeva vald','Jogeva vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12438,'EE.03.0251','EE','EE.03','Jõhvi vald','Johvi vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12439,'EE.08.0272','EE','EE.08','Kadrina vald','Kadrina vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12440,'EE.18.0283','EE','EE.18','Kambja vald','Kambja vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12441,'EE.12.0284','EE','EE.12','Kanepi vald','Kanepi vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12442,'EE.13.0293','EE','EE.13','Kehtna vald','Kehtna vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12443,'EE.01.0296','EE','EE.01','Keila linn','Keila linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12444,'EE.11.0303','EE','EE.11','Kihnu vald','Kihnu vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12445,'EE.01.0304','EE','EE.01','Kiili vald','Kiili vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12446,'EE.13.0317','EE','EE.13','Kohila vald','Kohila vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12447,'EE.01.0338','EE','EE.01','Kose vald','Kose vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12448,'EE.01.0424','EE','EE.01','Loksa linn','Loksa linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12449,'EE.18.0432','EE','EE.18','Luunja vald','Luunja vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12450,'EE.03.0442','EE','EE.03','Lüganuse vald','Lueganuse vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12451,'EE.01.0446','EE','EE.01','Maardu linn','Maardu linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12452,'EE.14.0478','EE','EE.14','Muhu vald','Muhu vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12453,'EE.13.0503','EE','EE.13','Märjamaa vald','Maerjamaa vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12454,'EE.03.0514','EE','EE.03','Narva-Jõesuu linn','Narva-Joesuu linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12455,'EE.18.0528','EE','EE.18','Nõo vald','Noo vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12456,'EE.04.0567','EE','EE.04','Paide linn','Paide linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12457,'EE.18.0586','EE','EE.18','Peipsiääre vald','Peipsiaeaere vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12458,'EE.05.0618','EE','EE.05','Põltsamaa vald','Poltsamaa vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12459,'EE.19.0557','EE','EE.19','Otepää vald','Otepaeae vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12460,'EE.08.0792','EE','EE.08','Tapa vald','Tapa vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12461,'EE.18.0796','EE','EE.18','Tartu vald','Tartu vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12462,'EE.11.0809','EE','EE.11','Tori vald','Tori vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12463,'EE.13.0668','EE','EE.13','Rapla vald','Rapla vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12464,'EE.14.0689','EE','EE.14','Ruhnu vald','Ruhnu vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12465,'EE.21.0698','EE','EE.21','Rõuge vald','Rouge vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12466,'EE.12.0708','EE','EE.12','Räpina vald','Raepina vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12467,'EE.11.0712','EE','EE.11','Saarde vald','Saarde vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12468,'EE.01.0718','EE','EE.01','Saku vald','Saku vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12469,'EE.01.0651','EE','EE.01','Raasiku vald','Raasiku vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12470,'EE.01.0653','EE','EE.01','Rae vald','Rae vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12471,'EE.08.0661','EE','EE.08','Rakvere vald','Rakvere vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12472,'EE.08.0663','EE','EE.08','Rakvere linn','Rakvere linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12473,'EE.01.0726','EE','EE.01','Saue vald','Saue vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12474,'EE.01.0353','EE','EE.01','Kuusalu vald','Kuusalu vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12475,'EE.18.0793','EE','EE.18','Tartu linn','Tartu linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12476,'EE.01.0141','EE','EE.01','Anija vald','Anija vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12477,'EE.21.0142','EE','EE.21','Antsla vald','Antsla vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12478,'EE.01.0890','EE','EE.01','Viimsi vald','Viimsi vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12479,'EE.12.0622','EE','EE.12','Põlva vald','Polva vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12480,'EE.03.0803','EE','EE.03','Toila vald','Toila vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12481,'EE.04.0834','EE','EE.04','Türi vald','Tueri vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12482,'EE.20.0897','EE','EE.20','Viljandi linn','Viljandi linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12483,'EE.08.0901','EE','EE.08','Vinni vald','Vinni vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12484,'EE.08.0903','EE','EE.08','Viru-Nigula vald','Viru-Nigula vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12485,'EE.07.0907','EE','EE.07','Vormsi vald','Vormsi vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12486,'EE.21.0917','EE','EE.21','Võru vald','Voru vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12487,'EE.21.0919','EE','EE.21','Võru linn','Voru linn',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12488,'EE.08.0928','EE','EE.08','Väike-Maarja vald','Vaeike-Maarja vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12489,'EE.20.0899','EE','EE.20','Viljandi vald','Viljandi vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12490,'EE.07.0441','EE','EE.07','Lääne-Nigula vald','Laeaene-Nigula vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12491,'EE.20.0480','EE','EE.20','Mulgi vald','Mulgi vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12492,'EE.19.0855','EE','EE.19','Valga vald','Valga vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12493,'EE.21.0732','EE','EE.21','Setomaa vald','Setomaa vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12494,'EE.02.0205','EE','EE.02','Hiiumaa vald','Hiiumaa vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12495,'EE.18.0171','EE','EE.18','Elva vald','Elva vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12496,'EE.14.0714','EE','EE.14','Saaremaa vald','Saaremaa vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12497,'EE.04.0255','EE','EE.04','Järva vald','Jaerva vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12498,'EE.05.0486','EE','EE.05','Mustvee vald','Mustvee vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12499,'EE.18.0291','EE','EE.18','Kastre vald','Kastre vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12500,'EE.19.0824','EE','EE.19','Tõrva vald','Torva vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12501,'EE.03.0130','EE','EE.03','Alutaguse vald','Alutaguse vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12502,'EE.11.0430','EE','EE.11','Lääneranna vald','Laeaeneranna vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12503,'EE.01.0431','EE','EE.01','Lääne-Harju vald','Laeaene-Harju vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12504,'EE.20.0615','EE','EE.20','Põhja-Sakala vald','Pohja-Sakala vald',1);
  INSERT INTO `<<prefix>>subadmin2` VALUES (12505,'EE.11.0638','EE','EE.11','Põhja-Pärnumaa vald','Pohja-Paernumaa vald',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 (587450,'EE','Võru','Voru',57.8339,27.0194,'P','PPLA','EE.21','EE.21.0919',14631,'Europe/Tallinn',1,'2016-03-12 23:00:00','2016-03-12 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (587577,'EE','Viljandi','Viljandi',58.3639,25.59,'P','PPLA','EE.20','EE.20.0897',20309,'Europe/Tallinn',1,'2016-03-12 23:00:00','2016-03-12 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (587876,'EE','Valga','Valga',57.7778,26.0473,'P','PPLA','EE.19','EE.19.0855',13945,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (588153,'EE','Türi','Tueri',58.8086,25.4325,'P','PPL','EE.04','EE.04.0834',6138,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (588335,'EE','Tartu','Tartu',58.3806,26.7251,'P','PPLA','EE.18','EE.18.0793',101092,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (588348,'EE','Tapa','Tapa',59.2606,25.9586,'P','PPLA2','EE.08','EE.08.0792',6551,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (588409,'EE','Tallinn','Tallinn',59.437,24.7535,'P','PPLC','EE.01','EE.01.0784',394024,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (588686,'EE','Sillamäe','Sillamaee',59.397,27.7633,'P','PPLA2','EE.03','EE.03.0735',16672,'Europe/Tallinn',1,'2017-07-03 23:00:00','2017-07-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (588780,'EE','Saue','Saue',59.3226,24.5497,'P','PPLA2','EE.01','EE.01.0726',5022,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (589116,'EE','Rapla','Rapla',59.0072,24.7928,'P','PPLA','EE.13','EE.13.0668',5684,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (589165,'EE','Rakvere','Rakvere',59.3464,26.3558,'P','PPLA','EE.08','EE.08.0663',16736,'Europe/Tallinn',1,'2016-03-12 23:00:00','2016-03-12 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (589375,'EE','Põlva','Polva',58.0603,27.0694,'P','PPLA','EE.12','EE.12.0622',6504,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (589580,'EE','Pärnu','Paernu',58.3859,24.4971,'P','PPLA','EE.11','EE.11.0624',44192,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (589709,'EE','Paide','Paide',58.8856,25.5572,'P','PPLA','EE.04','EE.04.0567',9735,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (590031,'EE','Narva','Narva',59.3772,28.1903,'P','PPLA2','EE.03','EE.03.0511',66980,'Europe/Tallinn',1,'2017-07-03 23:00:00','2017-07-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (590447,'EE','Maardu','Maardu',59.4653,24.9821,'P','PPLA2','EE.01','EE.01.0446',16630,'Europe/Tallinn',1,'2017-07-03 23:00:00','2017-07-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (590939,'EE','Kuressaare','Kuressaare',58.2481,22.5039,'P','PPLA','EE.14','EE.14.0714',14921,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (591260,'EE','Kohtla-Järve','Kohtla-Jaerve',59.3986,27.2731,'P','PPLA2','EE.03','EE.03.0321',46060,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (591313,'EE','Kiviõli','Kivioli',59.3531,26.9711,'P','PPLA2','EE.03','EE.03.0442',6953,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (591472,'EE','Keila','Keila',59.3036,24.4131,'P','PPLA2','EE.01','EE.01.0296',9411,'Europe/Tallinn',1,'2017-07-03 23:00:00','2017-07-03 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (591632,'EE','Kärdla','Kaerdla',58.9978,22.7492,'P','PPLA','EE.02','EE.02.0205',3763,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (591893,'EE','Jõhvi','Johvi',59.3592,27.4211,'P','PPLA','EE.03','EE.03.0251',11469,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (591902,'EE','Jõgeva','Jogeva',58.7467,26.3939,'P','PPLA','EE.05','EE.05.0247',6396,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (592225,'EE','Haapsalu','Haapsalu',58.9431,23.5414,'P','PPLA','EE.07','EE.07.0184',11805,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 23:00:00');
  INSERT INTO `<<prefix>>cities` VALUES (592279,'EE','Elva','Elva',58.2225,26.4211,'P','PPLA2','EE.18','EE.18.0171',5819,'Europe/Tallinn',1,'2017-11-24 23:00:00','2017-11-24 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
  