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


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

INSERT INTO `<<prefix>>subadmin1` VALUES (1717,'LK.36','LK','Western','Western',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1718,'LK.35','LK','Uva','Uva',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1719,'LK.34','LK','Southern','Southern',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1720,'LK.33','LK','Sabaragamuwa','Sabaragamuwa',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1721,'LK.32','LK','North Western','North Western',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1722,'LK.30','LK','North Central','North Central',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1723,'LK.29','LK','Central','Central',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1724,'LK.38','LK','Northern Province','Northern Province',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1725,'LK.37','LK','Eastern Province','Eastern Province',1);

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

INSERT INTO `<<prefix>>subadmin2` VALUES (21035,'LK.38.1225017','LK','LK.38','Vavuniya District','Vavuniya District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21036,'LK.37.1226258','LK','LK.37','Trincomalee District','Trincomalee District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21037,'LK.33.1228729','LK','LK.33','Ratnapura District','Ratnapura District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21038,'LK.32.1229292','LK','LK.32','Puttalam District','Puttalam District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21039,'LK.30.1229899','LK','LK.30','Polonnaruwa District','Polonnaruwa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21040,'LK.29.1232781','LK','LK.29','Nuwara Eliya District','Nuwara Eliya District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21041,'LK.38.1234392','LK','LK.38','Mullaitivu District','Mullaitivu District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21042,'LK.35.1234818','LK','LK.35','Moneragala District','Moneragala District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21043,'LK.34.1235845','LK','LK.34','Matara District','Matara District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21044,'LK.29.1235854','LK','LK.29','Matale District','Matale District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21045,'LK.38.1236148','LK','LK.38','Mannar District','Mannar District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21046,'LK.32.1237978','LK','LK.32','Kurunegala District','Kurunegala District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21047,'LK.38.1240371','LK','LK.38','Kilinochchi District','Kilinochchi District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21048,'LK.33.1240722','LK','LK.33','Kegalle District','Kegalle District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21049,'LK.29.1241621','LK','LK.29','Kandy District','Kandy District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21050,'LK.36.1241963','LK','LK.36','Kalutara District','Kalutara District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21051,'LK.38.1242831','LK','LK.38','Jaffna District','Jaffna District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21052,'LK.34.1244925','LK','LK.34','Hambantota District','Hambantota District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21053,'LK.36.1246005','LK','LK.36','Gampaha District','Gampaha District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21054,'LK.34.1246292','LK','LK.34','Galle District','Galle District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21055,'LK.36.1248990','LK','LK.36','Colombo District','Colombo District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21056,'LK.37.1250159','LK','LK.37','Batticaloa District','Batticaloa District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21057,'LK.35.1250614','LK','LK.35','Badulla District','Badulla District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21058,'LK.30.1251080','LK','LK.30','Anuradhapura District','Anuradhapura District',1);
INSERT INTO `<<prefix>>subadmin2` VALUES (21059,'LK.37.1251460','LK','LK.37','Ampara District','Ampara District',1);

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

INSERT INTO `<<prefix>>cities` VALUES (1223648,'LK','Welisara','Welisara',7.0281,79.9014,'P','PPL','LK.36',NULL,41306,'Asia/Colombo',1,'2006-01-26 23:00:00','2006-01-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1223738,'LK','Weligama','Weligama',5.97501,80.4297,'P','PPL','LK.34',NULL,22179,'Asia/Colombo',1,'2012-11-07 23:00:00','2012-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1224061,'LK','Wattegama','Wattegama',6.7989,81.4808,'P','PPL','LK.35',NULL,8000,'Asia/Colombo',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1224085,'LK','Wattala','Wattala',6.9779,79.8898,'P','PPL','LK.36',NULL,30725,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1225018,'LK','Vavuniya','Vavuniya',8.7514,80.4971,'P','PPL','LK.38',NULL,60176,'Asia/Colombo',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1225142,'LK','Valvedditturai','Valvedditturai',9.81667,80.1667,'P','PPL','LK.38',NULL,78205,'Asia/Colombo',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1225187,'LK','Vakarai','Vakarai',8.13333,81.4333,'P','PPL','LK.37',NULL,21000,'Asia/Colombo',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1226260,'LK','Trincomalee','Trincomalee',8.5711,81.2335,'P','PPLA','LK.37',NULL,108420,'Asia/Colombo',1,'2012-01-15 23:00:00','2012-01-15 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1227037,'LK','Tangalla','Tangalla',6.02338,80.7974,'P','PPL','LK.34',NULL,10497,'Asia/Colombo',1,'2017-07-16 23:00:00','2017-07-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1228730,'LK','Ratnapura','Ratnapura',6.68278,80.3992,'P','PPLA','LK.33',NULL,47832,'Asia/Colombo',1,'2013-06-27 23:00:00','2013-06-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1229293,'LK','Puttalam','Puttalam',8.0362,79.8283,'P','PPL','LK.32',NULL,45661,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1229901,'LK','Polonnaruwa','Polonnaruwa',7.93965,81.0027,'P','PPL','LK.30',NULL,13900,'Asia/Colombo',1,'2012-11-07 23:00:00','2012-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1229989,'LK','Point Pedro','Point Pedro',9.81667,80.2333,'P','PPL','LK.38',NULL,89810,'Asia/Colombo',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1230089,'LK','Pita Kotte','Pita Kotte',6.8905,79.9015,'P','PPL','LK.36',NULL,118179,'Asia/Colombo',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1230613,'LK','Peliyagoda','Peliyagoda',6.9685,79.8836,'P','PPL','LK.36',NULL,30717,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1231410,'LK','Panadura','Panadura',6.7132,79.9026,'P','PPL','LK.36',NULL,33735,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1232783,'LK','Nuwara Eliya','Nuwara Eliya',6.97078,80.7829,'P','PPL','LK.29','LK.29.1232781',25775,'Asia/Colombo',1,'2013-09-20 23:00:00','2013-09-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1233369,'LK','Negombo','Negombo',7.2083,79.8358,'P','PPL','LK.36',NULL,137223,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1234378,'LK','Mulleriyawa','Mulleriyawa',6.933,79.9297,'P','PPL','LK.36',NULL,33540,'Asia/Colombo',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1234569,'LK','Dehiwala-Mount Lavinia','Dehiwala-Mount Lavinia',6.84019,79.8712,'P','PPL','LK.36','LK.36.1248990',219827,'Asia/Colombo',1,'2015-12-12 23:00:00','2015-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1234633,'LK','Moratuwa','Moratuwa',6.773,79.8816,'P','PPL','LK.36',NULL,185031,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1234808,'LK','Monaragala','Monaragala',6.8714,81.3487,'P','PPL','LK.35',NULL,10236,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1235000,'LK','Minuwangoda','Minuwangoda',7.1663,79.9533,'P','PPL','LK.36',NULL,7772,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1235846,'LK','Matara','Matara',5.94851,80.5353,'P','PPL','LK.34',NULL,76254,'Asia/Colombo',1,'2010-06-14 23:00:00','2010-06-14 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1235855,'LK','Matale','Matale',7.4698,80.6217,'P','PPL','LK.29',NULL,36462,'Asia/Colombo',1,'2017-12-13 23:00:00','2017-12-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1236854,'LK','Maharagama','Maharagama',6.848,79.9265,'P','PPL','LK.36',NULL,66576,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1237980,'LK','Kurunegala','Kurunegala',7.4863,80.3623,'P','PPLA','LK.32',NULL,28571,'Asia/Colombo',1,'2012-01-13 23:00:00','2012-01-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1238427,'LK','Kuliyapitiya','Kuliyapitiya',7.4688,80.0401,'P','PPL','LK.32',NULL,6877,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1238992,'LK','Sri Jayewardenepura Kotte','Sri Jayewardenepura Kotte',6.88297,79.9071,'P','PPL','LK.36',NULL,115826,'Asia/Colombo',1,'2015-04-23 23:00:00','2015-04-23 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1239047,'LK','Kotikawatta','Kotikawatta',6.9269,79.9095,'P','PPL','LK.36',NULL,64565,'Asia/Colombo',1,'2013-04-02 23:00:00','2013-04-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1239593,'LK','Kolonnawa','Kolonnawa',6.9329,79.8848,'P','PPL','LK.36',NULL,58076,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1240372,'LK','Kilinochchi','Kilinochchi',9.3961,80.3982,'P','PPL','LK.38',NULL,13006,'Asia/Colombo',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1240622,'LK','Kelaniya','Kelaniya',6.9553,79.922,'P','PPL','LK.36',NULL,28846,'Asia/Colombo',1,'2013-04-12 23:00:00','2013-04-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1240723,'LK','Kegalle','Kegalle',7.2523,80.3436,'P','PPL','LK.33',NULL,17962,'Asia/Colombo',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1240935,'LK','Katunayaka','Katunayaka',7.16992,79.8884,'P','PPLA3','LK.36',NULL,84643,'Asia/Colombo',1,'2014-08-04 23:00:00','2014-08-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1241076,'LK','Kataragama','Kataragama',6.4134,81.3346,'P','PPL','LK.35',NULL,20935,'Asia/Colombo',1,'2017-06-21 23:00:00','2017-06-21 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1241622,'LK','Kandy','Kandy',7.2955,80.6356,'P','PPLA','LK.29',NULL,111701,'Asia/Colombo',1,'2012-01-13 23:00:00','2012-01-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1241750,'LK','Kandana','Kandana',7.048,79.8937,'P','PPL','LK.36',NULL,33424,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1241964,'LK','Kalutara','Kalutara',6.5831,79.9593,'P','PPL','LK.36',NULL,38000,'Asia/Colombo',1,'2014-02-01 23:00:00','2014-02-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1242110,'LK','Kalmunai','Kalmunai',7.40902,81.8347,'P','PPL','LK.37',NULL,100171,'Asia/Colombo',1,'2014-05-02 23:00:00','2014-05-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1242833,'LK','Jaffna','Jaffna',9.66845,80.0074,'P','PPLA','LK.38',NULL,169102,'Asia/Colombo',1,'2013-06-27 23:00:00','2013-06-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1242835,'LK','Ja Ela','Ja Ela',7.0744,79.8919,'P','PPL','LK.36',NULL,32175,'Asia/Colombo',1,'2006-01-26 23:00:00','2006-01-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1243867,'LK','Horana South','Horana South',6.7159,80.0626,'P','PPL','LK.36',NULL,8982,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1243936,'LK','Homagama','Homagama',6.844,80.0024,'P','PPL','LK.36',NULL,34664,'Asia/Colombo',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1244397,'LK','Hendala','Hendala',6.9909,79.883,'P','PPL','LK.36',NULL,56978,'Asia/Colombo',1,'2006-01-16 23:00:00','2006-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1244596,'LK','Hatton','Hatton',6.8916,80.5955,'P','PPL','LK.29',NULL,15073,'Asia/Colombo',1,'2012-01-18 23:00:00','2012-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1244773,'LK','Hanwella Ihala','Hanwella Ihala',6.9012,80.0852,'P','PPL','LK.36',NULL,22918,'Asia/Colombo',1,'2006-01-26 23:00:00','2006-01-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1246000,'LK','Gampola','Gampola',7.1643,80.5696,'P','PPL','LK.29',NULL,24730,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1246007,'LK','Gampaha','Gampaha',7.0897,79.9925,'P','PPL','LK.36',NULL,9350,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1246294,'LK','Galle','Galle',6.0367,80.217,'P','PPLA','LK.34',NULL,93118,'Asia/Colombo',1,'2012-01-13 23:00:00','2012-01-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1246321,'LK','Galkissa','Galkissa',6.8293,79.863,'P','PPL','LK.36',NULL,215941,'Asia/Colombo',1,'2006-01-26 23:00:00','2006-01-26 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1246924,'LK','Eravur Town','Eravur Town',7.7782,81.6038,'P','PPL','LK.37',NULL,22982,'Asia/Colombo',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1248749,'LK','Dambulla','Dambulla',7.86,80.6517,'P','PPL','LK.29','LK.29.1235854',66716,'Asia/Colombo',1,'2015-04-10 23:00:00','2015-04-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1248991,'LK','Colombo','Colombo',6.93194,79.8478,'P','PPLC','LK.36',NULL,648034,'Asia/Colombo',1,'2007-02-16 23:00:00','2007-02-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1249145,'LK','Chilaw','Chilaw',7.57583,79.7953,'P','PPL','LK.32',NULL,24712,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1249931,'LK','Beruwala','Beruwala',6.4788,79.9828,'P','PPL','LK.36',NULL,34250,'Asia/Colombo',1,'2012-01-31 23:00:00','2012-01-31 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1249978,'LK','Bentota','Bentota',6.42598,79.9958,'P','PPL','LK.34',NULL,37000,'Asia/Colombo',1,'2013-04-12 23:00:00','2013-04-12 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1250161,'LK','Batticaloa','Batticaloa',7.7102,81.6924,'P','PPL','LK.37',NULL,86742,'Asia/Colombo',1,'2012-04-04 23:00:00','2012-04-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1250164,'LK','Battaramulla South','Battaramulla South',6.8964,79.9181,'P','PPL','LK.36',NULL,75633,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1250615,'LK','Badulla','Badulla',6.9895,81.0557,'P','PPLA','LK.35',NULL,47587,'Asia/Colombo',1,'2013-06-27 23:00:00','2013-06-27 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1251081,'LK','Anuradhapura','Anuradhapura',8.31223,80.4131,'P','PPLA','LK.30',NULL,60943,'Asia/Colombo',1,'2013-04-02 23:00:00','2013-04-02 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1251459,'LK','Ampara','Ampara',7.29754,81.682,'P','PPL','LK.37',NULL,18348,'Asia/Colombo',1,'2012-11-07 23:00:00','2012-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (1251574,'LK','Ambalangoda','Ambalangoda',6.2355,80.0538,'P','PPL','LK.34',NULL,20133,'Asia/Colombo',1,'2012-01-16 23:00:00','2012-01-16 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (6285792,'LK','Horawala Junction','Horawala Junction',6.48088,80.1271,'P','PPL','LK.36',NULL,7500,'Asia/Colombo',1,'2011-06-13 23:00:00','2011-06-13 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (8260318,'LK','Shanjeev Home','Shanjeev Home',7.38216,81.842,'P','PPL','LK.37',NULL,20000,'Asia/Colombo',1,'2013-11-07 23:00:00','2013-11-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (9259456,'LK','Mount Lavinia','Mount Lavinia',6.83947,79.8645,'P','PPLX','LK.36','LK.36.1248990',219827,'Asia/Colombo',1,'2015-12-12 23:00:00','2015-12-12 23:00:00');


