--
-- Host: localhost    Database: laraclassified
-- ------------------------------------------------------


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

INSERT INTO `<<prefix>>subadmin1` VALUES (1121,'GU.PI','GU','Piti','Piti',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1122,'GU.SR','GU','Santa Rita','Santa Rita',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1123,'GU.SJ','GU','Sinajana','Sinajana',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1124,'GU.TF','GU','Talofofo','Talofofo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1125,'GU.TM','GU','Tamuning','Tamuning',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1126,'GU.UM','GU','Umatac','Umatac',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1127,'GU.YG','GU','Yigo','Yigo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1128,'GU.YN','GU','Yona','Yona',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1129,'GU.ME','GU','Merizo','Merizo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1130,'GU.MA','GU','Mangilao','Mangilao',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1131,'GU.AH','GU','Agana Heights','Agana Heights',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1132,'GU.CP','GU','Chalan Pago-Ordot','Chalan Pago-Ordot',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1133,'GU.AS','GU','Asan','Asan',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1134,'GU.AT','GU','Agat','Agat',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1135,'GU.DD','GU','Dededo','Dededo',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1136,'GU.BA','GU','Barrigada','Barrigada',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1137,'GU.AN','GU','Hagatna','Hagatna',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1138,'GU.IN','GU','Inarajan','Inarajan',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (1139,'GU.MT','GU','Mongmong-Toto-Maite','Mongmong-Toto-Maite',1);

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


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

INSERT INTO `<<prefix>>cities` VALUES (4038473,'GU','Piti Village','Piti Village',13.4626,144.693,'P','PPLA','GU.PI',NULL,1666,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4038554,'GU','Santa Rita Village','Santa Rita Village',13.3861,144.672,'P','PPLA','GU.SR',NULL,7500,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4038588,'GU','Sinajana Village','Sinajana Village',13.4633,144.754,'P','PPLA','GU.SJ',NULL,2853,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4038647,'GU','Talofofo Village','Talofofo Village',13.3551,144.758,'P','PPLA','GU.TF',NULL,3215,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4038659,'GU','Tamuning-Tumon-Harmon Village','Tamuning-Tumon-Harmon Village',13.4877,144.781,'P','PPLA','GU.TM',NULL,19685,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4038733,'GU','Umatac Village','Umatac Village',13.2984,144.663,'P','PPLA','GU.UM',NULL,903,'Pacific/Guam',1,'2016-07-17 23:00:00','2016-07-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4038794,'GU','Yigo Village','Yigo Village',13.536,144.889,'P','PPLA','GU.YG',NULL,20539,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4038809,'GU','Yona Village','Yona Village',13.4097,144.777,'P','PPLA','GU.YN',NULL,6484,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043399,'GU','Merizo Village','Merizo Village',13.2658,144.669,'P','PPLA','GU.ME',NULL,2152,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043499,'GU','Inarajan Village','Inarajan Village',13.2736,144.748,'P','PPLA','GU.IN',NULL,3052,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043525,'GU','Agana Heights Village','Agana Heights Village',13.4656,144.748,'P','PPLA','GU.AH',NULL,3940,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043547,'GU','Guam Government House','Guam Government House',13.4719,144.75,'P','PPLG','GU.AN',NULL,0,'Pacific/Guam',1,'2011-06-30 23:00:00','2011-06-30 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043615,'GU','Chalan Pago-Ordot Village','Chalan Pago-Ordot Village',13.4474,144.759,'P','PPLA','GU.CP',NULL,6822,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043656,'GU','Barrigada Village','Barrigada Village',13.4691,144.799,'P','PPLA','GU.BA',NULL,8875,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043804,'GU','Agat Village','Agat Village',13.3885,144.659,'P','PPLA','GU.AT',NULL,5656,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043812,'GU','Asan-Maina Village','Asan-Maina Village',13.4721,144.717,'P','PPLA','GU.AS',NULL,2137,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4043909,'GU','Dededo Village','Dededo Village',13.5178,144.839,'P','PPLA','GU.DD',NULL,44943,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (4044012,'GU','Hagåtña','Hagatna',13.4757,144.749,'P','PPLC','GU.AN',NULL,1051,'Pacific/Guam',1,'2011-10-18 23:00:00','2011-10-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7268049,'GU','Mangilao Village','Mangilao Village',13.4476,144.801,'P','PPLA','GU.MA',NULL,15191,'Pacific/Guam',1,'2013-06-29 23:00:00','2013-06-29 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7873866,'GU','Mongmong-Toto-Maite Village','Mongmong-Toto-Maite Village',13.4686,144.782,'P','PPLA','GU.MT',NULL,6825,'Pacific/Guam',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (7874631,'GU','Tamuning','Tamuning',13.4875,144.781,'P','PPLX','GU.TM',NULL,19685,'Pacific/Guam',1,'2017-12-12 23:00:00','2017-12-12 23:00:00');


