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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (419,'BT.05','BT','Bumthang','Bumthang',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (420,'BT.06','BT','Chukha','Chukha',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (421,'BT.08','BT','Dagana','Dagana',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (422,'BT.07','BT','Chirang','Chirang',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (423,'BT.09','BT','Geylegphug','Geylegphug',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (424,'BT.10','BT','Haa','Haa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (425,'BT.11','BT','Lhuntse','Lhuntse',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (426,'BT.12','BT','Mongar','Mongar',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (427,'BT.13','BT','Paro','Paro',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (428,'BT.14','BT','Pemagatshel','Pemagatshel',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (429,'BT.15','BT','Punakha','Punakha',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (430,'BT.16','BT','Samchi','Samchi',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (431,'BT.17','BT','Samdrup Jongkhar','Samdrup Jongkhar',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (432,'BT.18','BT','Shemgang','Shemgang',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (433,'BT.19','BT','Tashigang','Tashigang',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (434,'BT.20','BT','Thimphu','Thimphu',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (435,'BT.21','BT','Tongsa','Tongsa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (436,'BT.22','BT','Wangdi Phodrang','Wangdi Phodrang',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (437,'BT.23','BT','Gasa','Gasa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (438,'BT.24','BT','Trashi Yangste','Trashi Yangste',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (8285,'BT.19.1252424','BT','BT.19','Tashigang','Tashigang',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8286,'BT.22.7646447','BT','BT.22','Dangchu','Dangchu',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8287,'BT.08.7646448','BT','BT.08','Tsangkha','Tsangkha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8288,'BT.08.7646449','BT','BT.08','Lajab','Lajab',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8289,'BT.08.7646456','BT','BT.08','Drukgyegang','Drukgyegang',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8290,'BT.14.7646634','BT','BT.14','Khar','Khar',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8291,'BT.14.7646635','BT','BT.14','Chongshing','Chongshing',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8292,'BT.14.7646636','BT','BT.14','Yurung','Yurung',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8293,'BT.19.7647111','BT','BT.19','Radi','Radi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8294,'BT.18.7647112','BT','BT.18','Nangkor','Nangkor',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8295,'BT.06.7647113','BT','BT.06','Phuentsholing','Phuentsholing',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8296,'BT.06.7647116','BT','BT.06','Bongo','Bongo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8297,'BT.18.7647118','BT','BT.18','Goshing','Goshing',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8298,'BT.18.7647122','BT','BT.18','Bardo','Bardo',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8299,'BT.19.7647125','BT','BT.19','Lumang','Lumang',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8300,'BT.19.7647130','BT','BT.19','Thrimshing','Thrimshing',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8301,'BT.06.7647631','BT','BT.06','Chabchha','Chabchha',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8302,'BT.08.7647632','BT','BT.08','Khiphisa','Khiphisa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8303,'BT.21.7647633','BT','BT.21','Nubi','Nubi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8304,'BT.21.7647634','BT','BT.21','Bjakteng','Bjakteng',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8305,'BT.07.7647804','BT','BT.07','Kikhorthang','Kikhorthang',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8306,'BT.07.7647805','BT','BT.07','Beteni','Beteni',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8307,'BT.22.7647808','BT','BT.22','Ruepaisa','Ruepaisa',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8308,'BT.22.7647809','BT','BT.22','Nahi','Nahi',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8309,'BT.18.7647813','BT','BT.18','Trong','Trong',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8310,'BT.13.7647816','BT','BT.13','Mewang','Mewang',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (8311,'BT.20.11287732','BT','BT.20','Lingzhi Gewog','Lingzhi Gewog',1);

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

INSERT INTO `<<prefix>>cities` VALUES (1252395,'BT','Wangdue Phodrang','Wangdue Phodrang',27.4862,89.8991,'P','PPLA','BT.22',NULL,7507,'Asia/Thimphu',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252408,'BT','Trongsa','Trongsa',27.5026,90.5072,'P','PPLA','BT.21',NULL,2805,'Asia/Thimphu',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252416,'BT','Thimphu','Thimphu',27.4661,89.6419,'P','PPLC','BT.20',NULL,98676,'Asia/Thimphu',1,'2017-08-15 23:00:00','2017-08-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252422,'BT','Trashi Yangtse','Trashi Yangtse',27.6116,91.498,'P','PPLA','BT.24',NULL,3025,'Asia/Thimphu',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252423,'BT','Trashigang','Trashigang',27.3331,91.5542,'P','PPLA','BT.19',NULL,872,'Asia/Thimphu',1,'2014-08-18 23:00:00','2014-08-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252433,'BT','Daga','Daga',27.0753,89.8769,'P','PPLA','BT.08',NULL,2243,'Asia/Thimphu',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252451,'BT','Shemgang','Shemgang',27.2169,90.6579,'P','PPLA','BT.18',NULL,852,'Asia/Thimphu',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252460,'BT','Sarpang','Sarpang',26.864,90.2674,'P','PPLA','BT.09',NULL,10416,'Asia/Thimphu',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252479,'BT','Punākha','Punakha',27.5914,89.8774,'P','PPLA','BT.15',NULL,21500,'Asia/Thimphu',1,'2013-08-10 23:00:00','2013-08-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252484,'BT','Phuntsholing','Phuntsholing',26.8516,89.3884,'P','PPL','BT.06',NULL,17043,'Asia/Thimphu',1,'2010-03-30 23:00:00','2010-03-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252490,'BT','Paro','Paro',27.4305,89.4133,'P','PPLA','BT.13',NULL,2169,'Asia/Thimphu',1,'2014-08-17 23:00:00','2014-08-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252514,'BT','Mongar','Mongar',27.2747,91.2396,'P','PPLA','BT.12',NULL,2969,'Asia/Thimphu',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252526,'BT','Lhuentse','Lhuentse',27.6679,91.1839,'P','PPLA','BT.11',NULL,100,'Asia/Thimphu',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252563,'BT','Ha','Ha',27.3875,89.2807,'P','PPLA','BT.10',NULL,1449,'Asia/Thimphu',1,'2013-06-26 23:00:00','2013-06-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252578,'BT','Gasa','Gasa',27.9037,89.7269,'P','PPLA','BT.23',NULL,548,'Asia/Thimphu',1,'2013-08-25 23:00:00','2013-08-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252608,'BT','Tsirang','Tsirang',27.0219,90.1229,'P','PPLA','BT.07',NULL,18667,'Asia/Thimphu',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1252610,'BT','Tsimasham','Tsimasham',27.0989,89.536,'P','PPLA','BT.06',NULL,2855,'Asia/Thimphu',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1337301,'BT','Jakar','Jakar',27.5492,90.7525,'P','PPLA','BT.05',NULL,4829,'Asia/Thimphu',1,'2014-08-19 23:00:00','2014-08-19 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1337360,'BT','Samtse','Samtse',26.899,89.0995,'P','PPLA','BT.16',NULL,5479,'Asia/Thimphu',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1337379,'BT','Pemagatshel','Pemagatshel',27.038,91.4031,'P','PPLA','BT.14',NULL,13864,'Asia/Thimphu',1,'2013-08-07 23:00:00','2013-08-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1337388,'BT','Samdrup Jongkhar','Samdrup Jongkhar',26.8007,91.5052,'P','PPLA','BT.17',NULL,7507,'Asia/Thimphu',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (10172752,'BT','Lungtenzampa','Lungtenzampa',27.4682,89.6444,'P','PPLA','BT.20',NULL,0,'Asia/Thimphu',1,'2015-03-14 23:00:00','2015-03-14 23:00:00');


