-- MySQL dump 10.13  Distrib 5.7.25, for osx10.9 (x86_64)
--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------
-- Server version	5.7.25

/*!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 (882,'EE.21','EE','Võrumaa','Vorumaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (883,'EE.20','EE','Viljandimaa','Viljandimaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (884,'EE.19','EE','Valgamaa','Valgamaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (885,'EE.18','EE','Tartu','Tartu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (886,'EE.14','EE','Saare','Saare',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (887,'EE.13','EE','Raplamaa','Raplamaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (888,'EE.12','EE','Põlvamaa','Polvamaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (889,'EE.11','EE','Pärnumaa','Paernumaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (890,'EE.08','EE','Lääne-Virumaa','Laeaene-Virumaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (891,'EE.07','EE','Lääne','Laeaene',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (892,'EE.05','EE','Jõgevamaa','Jogevamaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (893,'EE.04','EE','Järvamaa','Jaervamaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (894,'EE.03','EE','Ida-Virumaa','Ida-Virumaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (895,'EE.02','EE','Hiiumaa','Hiiumaa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (896,'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 (12492,'EE.03.0321','EE','EE.03','Kohtla-Järve linn','Kohtla-Jaerve linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12493,'EE.03.0511','EE','EE.03','Narva linn','Narva linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12494,'EE.11.0624','EE','EE.11','Pärnu linn','Paernu linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12495,'EE.03.0735','EE','EE.03','Sillamäe linn','Sillamaee linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12496,'EE.01.0784','EE','EE.01','Tallinn','Tallinn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12497,'EE.07.0184','EE','EE.07','Haapsalu linn','Haapsalu linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12498,'EE.08.0191','EE','EE.08','Haljala vald','Haljala vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12499,'EE.01.0198','EE','EE.01','Harku vald','Harku vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12500,'EE.11.0214','EE','EE.11','Häädemeeste vald','Haeaedemeeste vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12501,'EE.01.0245','EE','EE.01','Jõelähtme vald','Joelaehtme vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12502,'EE.05.0247','EE','EE.05','Jõgeva vald','Jogeva vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12503,'EE.03.0251','EE','EE.03','Jõhvi vald','Johvi vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12504,'EE.08.0272','EE','EE.08','Kadrina vald','Kadrina vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12505,'EE.18.0283','EE','EE.18','Kambja vald','Kambja vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12506,'EE.12.0284','EE','EE.12','Kanepi vald','Kanepi vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12507,'EE.13.0293','EE','EE.13','Kehtna vald','Kehtna vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12508,'EE.01.0296','EE','EE.01','Keila linn','Keila linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12509,'EE.11.0303','EE','EE.11','Kihnu vald','Kihnu vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12510,'EE.01.0304','EE','EE.01','Kiili vald','Kiili vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12511,'EE.13.0317','EE','EE.13','Kohila vald','Kohila vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12512,'EE.01.0338','EE','EE.01','Kose vald','Kose vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12513,'EE.01.0424','EE','EE.01','Loksa linn','Loksa linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12514,'EE.18.0432','EE','EE.18','Luunja vald','Luunja vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12515,'EE.03.0442','EE','EE.03','Lüganuse vald','Lueganuse vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12516,'EE.01.0446','EE','EE.01','Maardu linn','Maardu linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12517,'EE.14.0478','EE','EE.14','Muhu vald','Muhu vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12518,'EE.13.0503','EE','EE.13','Märjamaa vald','Maerjamaa vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12519,'EE.03.0514','EE','EE.03','Narva-Jõesuu linn','Narva-Joesuu linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12520,'EE.18.0528','EE','EE.18','Nõo vald','Noo vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12521,'EE.04.0567','EE','EE.04','Paide linn','Paide linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12522,'EE.18.0586','EE','EE.18','Peipsiääre vald','Peipsiaeaere vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12523,'EE.05.0618','EE','EE.05','Põltsamaa vald','Poltsamaa vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12524,'EE.19.0557','EE','EE.19','Otepää vald','Otepaeae vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12525,'EE.08.0792','EE','EE.08','Tapa vald','Tapa vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12526,'EE.18.0796','EE','EE.18','Tartu vald','Tartu vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12527,'EE.11.0809','EE','EE.11','Tori vald','Tori vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12528,'EE.13.0668','EE','EE.13','Rapla vald','Rapla vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12529,'EE.14.0689','EE','EE.14','Ruhnu vald','Ruhnu vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12530,'EE.21.0698','EE','EE.21','Rõuge vald','Rouge vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12531,'EE.12.0708','EE','EE.12','Räpina vald','Raepina vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12532,'EE.11.0712','EE','EE.11','Saarde vald','Saarde vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12533,'EE.01.0718','EE','EE.01','Saku vald','Saku vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12534,'EE.01.0651','EE','EE.01','Raasiku vald','Raasiku vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12535,'EE.01.0653','EE','EE.01','Rae vald','Rae vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12536,'EE.08.0661','EE','EE.08','Rakvere vald','Rakvere vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12537,'EE.08.0663','EE','EE.08','Rakvere linn','Rakvere linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12538,'EE.01.0726','EE','EE.01','Saue vald','Saue vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12539,'EE.01.0353','EE','EE.01','Kuusalu vald','Kuusalu vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12540,'EE.18.0793','EE','EE.18','Tartu linn','Tartu linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12541,'EE.01.0141','EE','EE.01','Anija vald','Anija vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12542,'EE.21.0142','EE','EE.21','Antsla vald','Antsla vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12543,'EE.01.0890','EE','EE.01','Viimsi vald','Viimsi vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12544,'EE.12.0622','EE','EE.12','Põlva vald','Polva vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12545,'EE.03.0803','EE','EE.03','Toila vald','Toila vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12546,'EE.04.0834','EE','EE.04','Türi vald','Tueri vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12547,'EE.20.0897','EE','EE.20','Viljandi linn','Viljandi linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12548,'EE.08.0901','EE','EE.08','Vinni vald','Vinni vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12549,'EE.08.0903','EE','EE.08','Viru-Nigula vald','Viru-Nigula vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12550,'EE.07.0907','EE','EE.07','Vormsi vald','Vormsi vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12551,'EE.21.0917','EE','EE.21','Võru vald','Voru vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12552,'EE.21.0919','EE','EE.21','Võru linn','Voru linn',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12553,'EE.08.0928','EE','EE.08','Väike-Maarja vald','Vaeike-Maarja vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12554,'EE.20.0899','EE','EE.20','Viljandi vald','Viljandi vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12555,'EE.07.0441','EE','EE.07','Lääne-Nigula vald','Laeaene-Nigula vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12556,'EE.20.0480','EE','EE.20','Mulgi vald','Mulgi vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12557,'EE.19.0855','EE','EE.19','Valga vald','Valga vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12558,'EE.21.0732','EE','EE.21','Setomaa vald','Setomaa vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12559,'EE.02.0205','EE','EE.02','Hiiumaa vald','Hiiumaa vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12560,'EE.18.0171','EE','EE.18','Elva vald','Elva vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12561,'EE.14.0714','EE','EE.14','Saaremaa vald','Saaremaa vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12562,'EE.04.0255','EE','EE.04','Järva vald','Jaerva vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12563,'EE.05.0486','EE','EE.05','Mustvee vald','Mustvee vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12564,'EE.18.0291','EE','EE.18','Kastre vald','Kastre vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12565,'EE.19.0824','EE','EE.19','Tõrva vald','Torva vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12566,'EE.03.0130','EE','EE.03','Alutaguse vald','Alutaguse vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12567,'EE.11.0430','EE','EE.11','Lääneranna vald','Laeaeneranna vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12568,'EE.01.0431','EE','EE.01','Lääne-Harju vald','Laeaene-Harju vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12569,'EE.20.0615','EE','EE.20','Põhja-Sakala vald','Pohja-Sakala vald',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (12570,'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,'2018-08-13 23:00:00','2018-08-13 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,'2019-02-25 23:00:00','2019-02-25 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,'2018-09-06 23:00:00','2018-09-06 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,'2018-10-05 23:00:00','2018-10-05 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,'2019-06-30 23:00:00','2019-06-30 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,'2018-06-21 23:00:00','2018-06-21 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
