-- 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 (386,'BS.35','BS','San Salvador','San Salvador',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (387,'BS.18','BS','Ragged Island','Ragged Island',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (388,'BS.32','BS','Berry Islands','Berry Islands',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (389,'BS.23','BS','New Providence','New Providence',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (390,'BS.16','BS','Mayaguana','Mayaguana',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (391,'BS.15','BS','Long Island','Long Island',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (392,'BS.13','BS','Inagua','Inagua',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (393,'BS.22','BS','Harbour Island','Harbour Island',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (394,'BS.25','BS','Freeport','Freeport',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (395,'BS.10','BS','Exuma','Exuma',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (396,'BS.06','BS','Cat Island','Cat Island',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (397,'BS.05','BS','Bimini','Bimini',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (398,'BS.24','BS','Acklins','Acklins',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (399,'BS.36','BS','Black Point','Black Point',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (400,'BS.37','BS','Central Abaco','Central Abaco',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (401,'BS.38','BS','Central Andros','Central Andros',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (402,'BS.39','BS','Central Eleuthera','Central Eleuthera',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (403,'BS.40','BS','Crooked Island and Long Cay','Crooked Island and Long Cay',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (404,'BS.41','BS','East Grand Bahama','East Grand Bahama',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (405,'BS.42','BS','Grand Cay','Grand Cay',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (406,'BS.43','BS','Hope Town','Hope Town',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (407,'BS.44','BS','Mangrove Cay','Mangrove Cay',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (408,'BS.45','BS','Moore’s Island','Moore\'s Island',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (409,'BS.46','BS','North Abaco','North Abaco',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (410,'BS.47','BS','North Andros','North Andros',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (411,'BS.48','BS','North Eleuthera','North Eleuthera',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (412,'BS.49','BS','Rum Cay','Rum Cay',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (413,'BS.50','BS','South Abaco','South Abaco',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (414,'BS.51','BS','South Andros','South Andros',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (415,'BS.52','BS','South Eleuthera','South Eleuthera',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (416,'BS.53','BS','Spanish Wells','Spanish Wells',1);
INSERT INTO `<<prefix>>subadmin1` VALUES (417,'BS.54','BS','West Grand Bahama','West Grand Bahama',1);
/*!40000 ALTER TABLE `<<prefix>>subadmin1` ENABLE KEYS */;

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

/*!40000 ALTER TABLE `<<prefix>>subadmin2` DISABLE KEYS */;
/*!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 (3571224,'BS','West End','West End',26.6871,-78.977,'P','PPLA','BS.54',NULL,12724,'America/Nassau',1,'2014-09-20 23:00:00','2014-09-20 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571375,'BS','Spanish Wells','Spanish Wells',25.5472,-76.7641,'P','PPLA','BS.53',NULL,1500,'America/Nassau',1,'2014-01-18 23:00:00','2014-01-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571523,'BS','San Andros','San Andros',25.0667,-78.05,'P','PPLA','BS.47',NULL,7800,'America/Nassau',1,'2013-08-07 23:00:00','2013-08-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571650,'BS','Port Nelson','Port Nelson',23.6497,-74.8416,'P','PPLA','BS.49',NULL,91,'America/Nassau',1,'2014-01-17 23:00:00','2014-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571824,'BS','Nassau','Nassau',25.0582,-77.3431,'P','PPLC','BS.23',NULL,227940,'America/Nassau',1,'2017-07-04 23:00:00','2017-07-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571898,'BS','Matthew Town','Matthew Town',20.9498,-73.6735,'P','PPLA','BS.13',NULL,452,'America/Nassau',1,'2014-01-17 23:00:00','2014-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571908,'BS','Masons Bay','Masons Bay',22.5435,-73.8778,'P','PPLA','BS.24',NULL,0,'America/Nassau',1,'2013-07-10 23:00:00','2013-07-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571913,'BS','Marsh Harbour','Marsh Harbour',26.5412,-77.0636,'P','PPLA','BS.37',NULL,5314,'America/Nassau',1,'2014-01-17 23:00:00','2014-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3571971,'BS','Lucaya','Lucaya',26.5333,-78.6667,'P','PPL','BS.25',NULL,46525,'America/Nassau',1,'2012-01-17 23:00:00','2012-01-17 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572189,'BS','High Rock','High Rock',26.61,-78.2786,'P','PPLA','BS.41',NULL,3744,'America/Nassau',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572233,'BS','Hard Bargain','Hard Bargain',26.3167,-77.5667,'P','PPLA','BS.45',NULL,0,'America/Nassau',1,'2012-02-11 23:00:00','2012-02-11 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572313,'BS','Governor’s Harbour','Governor\'s Harbour',25.1667,-76.2333,'P','PPLA','BS.39',NULL,0,'America/Nassau',1,'2013-07-06 23:00:00','2013-07-06 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572349,'BS','George Town','George Town',23.5162,-75.7867,'P','PPLA','BS.10',NULL,7314,'America/Nassau',1,'2013-08-01 23:00:00','2013-08-01 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572375,'BS','Freeport','Freeport',26.5333,-78.7,'P','PPLA','BS.25',NULL,26910,'America/Nassau',1,'2019-02-25 23:00:00','2019-02-25 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572467,'BS','Duncan Town','Duncan Town',22.1908,-75.7258,'P','PPLA','BS.18',NULL,70,'America/Nassau',1,'2013-05-04 23:00:00','2013-05-04 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572601,'BS','Cooper’s Town','Cooper\'s Town',26.8714,-77.5113,'P','PPL','BS.46',NULL,8413,'America/Nassau',1,'2016-04-09 23:00:00','2016-04-09 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572620,'BS','Colonel Hill','Colonel Hill',22.7545,-74.2041,'P','PPLA','BS.40',NULL,240,'America/Nassau',1,'2013-05-07 23:00:00','2013-05-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572627,'BS','Cockburn Town','Cockburn Town',24.0518,-74.5314,'P','PPLA','BS.35',NULL,831,'America/Nassau',1,'2015-02-28 23:00:00','2015-02-28 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572640,'BS','Clarence Town','Clarence Town',23.1,-74.9833,'P','PPLA','BS.15',NULL,1752,'America/Nassau',1,'2012-02-18 23:00:00','2012-02-18 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572796,'BS','Black Point','Black Point',24.1,-76.3833,'P','PPLA','BS.36',NULL,0,'America/Nassau',1,'2013-08-07 23:00:00','2013-08-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572897,'BS','Arthur’s Town','Arthur\'s Town',24.6224,-75.6715,'P','PPLA','BS.06',NULL,1175,'America/Nassau',1,'2013-08-07 23:00:00','2013-08-07 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572924,'BS','Alice Town','Alice Town',25.728,-79.2972,'P','PPLA','BS.05',NULL,949,'America/Nassau',1,'2015-08-10 23:00:00','2015-08-10 23:00:00');
INSERT INTO `<<prefix>>cities` VALUES (3572940,'BS','Abraham’s Bay','Abraham\'s Bay',22.3667,-72.9667,'P','PPLA','BS.16',NULL,235,'America/Nassau',1,'2013-08-07 23:00:00','2013-08-07 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
