/home/desid573/cpmove_failed_mysql_dbs.1787413258/
/home/desid573/cpmove_failed_mysql_dbs.1787413258
NameSizeModeActions
exmawjn/-0755rm
hjfltmn/-0755rm
iycwuxz/-0755rm
pioxjd1/-0755rm
desid573_1410_inventory.create15320600editdlrm
desid573_1410_inventory.sql131010644editdlrm
desid573_ample.create14960600editdlrm
desid573_ample.sql234990644editdlrm
desid573_angel_drivers.create15280600editdlrm
desid573_angel_drivers.sql460290644editdlrm
desid573_eway_codes.create15160600editdlrm
desid573_eway_codes.sql2800568410644editdlrm
desid573_famcab_api.create15160600editdlrm
desid573_famcab_api.sql70993730644editdlrm
desid573_familycab.create15120600editdlrm
desid573_familycab.sql322552360644editdlrm
desid573_gcdriver.create15080600editdlrm
desid573_gcdriver.sql334980644editdlrm
desid573_ims.create14880600editdlrm
desid573_ims.sql139280644editdlrm
desid573_inquiries.create15120600editdlrm
desid573_inquiries.sql50947490644editdlrm
desid573_magic.create14960600editdlrm
desid573_magic.sql855680644editdlrm
desid573_magic_site.create15160600editdlrm
desid573_magic_site.sql14420644editdlrm
desid573_new_pro_api.create15200600editdlrm
desid573_new_pro_api.sql27099950644editdlrm
desid573_oldvine.create15040600editdlrm
desid573_oldvine.sql181410644editdlrm
desid573_phewl.create14960600editdlrm
desid573_phewl.sql539850644editdlrm
desid573_tollster.create15080600editdlrm
desid573_tollster.sql12210970644editdlrm
desid573_wp38.create14920600editdlrm
desid573_wp38.sql9122310644editdlrm
desid573_wp172.create14960600editdlrm
desid573_wp172.sql1759120644editdlrm
desid573_wp255.create15000600editdlrm
desid573_wp255.sql3145010644editdlrm
desid573_wp676.create15000600editdlrm
desid573_wp676.sql120671790644editdlrm
desid573_wp_0a5zc.create15080600editdlrm
desid573_wp_0a5zc.sql1235380644editdlrm
desid573_wp_new.create15000600editdlrm
desid573_wp_new.sql78107280644editdlrm
openfileslimit50600editdlrm
wp-cron-darb.php16590644editdlrm
Edit: /home/desid573/cpmove_failed_mysql_dbs.1787413258/desid573_magic.sql (85568B)
-- MySQL dump 10.13 Distrib 8.4.9, for Linux (x86_64) -- -- Host: localhost Database: desid573_magic -- ------------------------------------------------------ -- Server version 8.4.9-cll-lve /*!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 */; /*!50503 SET NAMES utf8mb4 */; /*!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 */; -- -- Current Database: `desid573_magic` -- -- -- Table structure for table `booking` -- DROP TABLE IF EXISTS `booking`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `booking` ( `id` int NOT NULL AUTO_INCREMENT, `cid` int NOT NULL, `email` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `booking_date` date NOT NULL, `booking_time` time NOT NULL, `pickup_addr` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pickup_lat` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pickup_long` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pickoff_addr` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pickoff_lat` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pickoff_long` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `spatula_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `spatula_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `vehicle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `quote` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `quote_km` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `quote_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `driver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `booking` -- LOCK TABLES `booking` WRITE; /*!40000 ALTER TABLE `booking` DISABLE KEYS */; INSERT INTO `booking` (`id`, `cid`, `email`, `booking_date`, `booking_time`, `pickup_addr`, `pickup_lat`, `pickup_long`, `pickoff_addr`, `pickoff_lat`, `pickoff_long`, `spatula_id`, `spatula_link`, `reference`, `vehicle`, `color`, `quote`, `quote_km`, `quote_time`, `status`, `driver`) VALUES (1,3,'lwscann@gmail.com','2019-03-10','08:25:41','D Mineral Springs Rd, Charlotte, NC 28262, USA','35.2939997','-80.7943732','Fort Mill, SC, USA','35.0073697','-80.94507589999999','','','15522207411352','','Any','108','41','33','expired',''),(2,3,'lwscann@gmail.com','2019-03-10','23:44:36','G G B Hill Rd, Monroe, NC 28110, USA','35.06018829999999','-80.47920739999999','D Mineral Springs Rd, Charlotte, NC 28262, USA','35.2939997','-80.7943732','','','15522758763545','suv','Black','151','57','41','expired',''),(3,6,'johndryves@gmail.com','2019-03-27','06:59:00','145 Remount Rd, Charlotte, NC 28203, USA','35.203291','-80.86706099999999','155 N College St, Charlotte, NC 28202, USA','35.2269974','-80.8411351','','','15534234044391','sedan','Any','11','4','11','',''),(4,6,'johndryves@gmail.com','2019-03-24','06:38:54','155 Cherry Rd, Rock Hill, SC 29732, USA','34.9395447','-81.0369146','IBG Software 333 W Trade St Unit 100, Charlotte, NC 28202, USA','35.2290681','-80.845657','','','1553423934132','suv','Black','103','39','34','cancelled',''),(5,5,'lewis@perthdesignateddrivers.com.au','2019-03-25','04:36:05','G G B Hill Rd, Monroe, NC 28110, USA','35.06018829999999','-80.47920739999999','J J N Pease Pl, Charlotte, NC 28262, USA','35.3188231','-80.7741827','[','[','15535029651282','sedan','Any','137','52','37','cancelled',''),(6,5,'lewis@perthdesignateddrivers.com.au','2019-03-25','04:38:21','Yancey Road Yancey Rd, Charlotte, NC 28217, USA','35.1870347','-80.8813419','University City Boulevard University City Blvd, Charlotte, NC, USA','35.301366','-80.7313293','[','[','15535031012700','vip','Black','58','22','20','cancelled',''),(7,5,'lewis@perthdesignateddrivers.com.au','2019-03-25','04:45:00','Harrisburg, NC, USA','35.3237528','-80.6559017','J J N Pease Pl, Charlotte, NC 28262, USA','35.3188231','-80.7741827','6363403350','https://sptu.la/2W0epdYAs','1553503500757','sedan','Any','42','16','14','cancelled',''),(8,6,'johndryves@gmail.com','2019-03-29','12:47:00','224 N Poplar St, Charlotte, NC 28202, USA','35.2304279','-80.8427503','155 N College St, Charlotte, NC 28202, USA','35.2269974','-80.8411351','6363656225','https://sptu.la/TF8WxoOxq','15535306352235','sedan','Any','0','0','4','',''),(9,6,'johndryves@gmail.com','2019-03-29','13:16:10','2540 Little Rock Rd, Charlotte, NC 28214, USA','35.2447473','-80.9379653','Charlotte Douglas International Airport 5501 Josh Birmingham Pkwy, Charlotte, NC 28208, USA','35.2144026','-80.9473146','6370008906','https://sptu.la/QtxDKRmzC','15538797704426','suv','Any','24','9','10','',''),(10,6,'johndryves@gmail.com','2019-04-03','18:28:52','155 Fox Hunt Dr, Mooresville, NC 28117, USA','35.6403547','-80.91185159999999','Epicentre 210 E Trade St, Charlotte, NC 28202, USA','35.22537920000001','-80.8419644','6376332954','https://sptu.la/f5oY9zZt4','15543305323650','sedan','Any','164','62','44','cancelled',''),(11,6,'johndryves@gmail.com','2019-04-07','09:15:23','1301 Mazant St, New Orleans, LA 70117, USA','29.9673642','-90.0336739','Louis Armstrong New Orleans International Airport 900 Airline Dr, Kenner, LA 70062, USA','29.99220119999999','-90.25901119999999','6380724306','https://sptu.la/ZdzSr7G2U','15546429233242','sedan','Any','71','27','27','',''),(12,6,'johndryves@gmail.com','2019-04-10','21:43:22','155 Fox Hunt Dr, Mooresville, NC 28117, USA','35.6403724','-80.9118456','Charlotte Douglas International Airport 5501 Josh Birmingham Pkwy, Charlotte, NC 28208, USA','35.2144026','-80.9473146','6385700232','https://sptu.la/ZQ2gnE2YB','15549470021511','suv','Black','182','69','48','',''),(13,6,'johndryves@gmail.com','2019-04-12','20:15:00','Del Frisco\'s Double Eagle Steakhouse 4725 Piedmont Row Dr Suite 170, Charlotte, NC 28210, USA','35.1516951','-80.8396454','18329 Harbor Light Blvd, Cornelius, NC 28031, USA','35.46675930000001','-80.9369952','6388253700','https://sptu.la/5bRfq_KV_','15551109242555','suv','Black','129','49','41','',''),(14,5,'lewis@perthdesignateddrivers.com.au','2019-05-11','00:00:33','Lagos, Nigeria','6.5243793','3.3792057','Somolu, Lagos, Nigeria','6.539173','3.3841676','r','r','1557547233586','sedan','Any','5','2','11','expired',''),(15,5,'lewis@perthdesignateddrivers.com.au','2019-06-09','03:36:54','Lagos, Nigeria','6.5243793','3.3792057','Murtala Muhammed International Airport, Lagos, Nigeria','6.5818185','3.3211348','6424423741','https://vrom.io/cjd7KtIOV','1560065814298','magicride','','85.00','14','29','cancelled',''),(16,5,'lewis@perthdesignateddrivers.com.au','2019-06-09','03:51:15','Nigeria','9.081999000000001','8.675277','Lagos, Nigeria','6.5243793','3.3792057','6424425196','https://vrom.io/GLTDwm5YG','15600666752414','magicride','','4477.00','923','785','cancelled',''),(17,5,'lewis@perthdesignateddrivers.com.au','2019-06-09','04:01:03','Lagos, Nigeria','6.5243793','3.3792057','Murtala Muhammed International Airport, Lagos, Nigeria','6.5818185','3.3211348','[','[','15600672634604','magicride','','-','14','29','cancelled',''),(18,5,'lewis@perthdesignateddrivers.com.au','2019-06-09','04:04:45','Lagos, Nigeria','6.5243793','3.3792057','Murtala Muhammed International Airport, Lagos, Nigeria','6.5818185','3.3211348','6424426339','https://vrom.io/we-JQKiFJ','15600674851665','magicbike','','28.25','14','29','',''),(19,5,'lewis@perthdesignateddrivers.com.au','2019-06-09','04:24:38','Lagos, Nigeria','6.5243793','3.3792057','Domestic - Murtala Muhammed Airport Local Airport Rd, Ikeja, Nigeria','6.5897731','3.3314109','6424428521','https://vrom.io/kcnJAkfss','15600686783640','magicride','','75.00','12','27','cancelled',''),(20,14,'hellen.michaell@gmail.com','2019-06-09','13:20:06','Gizaasali St, Dar es Salaam, Tanzania','-6.7251074','39.2234237','Sea Cliff Hotel 10 Toure Dr, Dar es Salaam, Tanzania','-6.739759599999999','39.2844852','6424506555','https://vrom.io/1IqOQ_95S','15601008063837','magicride','','78.00','12','30','cancelled',''),(21,3,'lwscann@gmail.com','2019-06-10','01:06:16','Lagos, Nigeria','6.5243793','3.3792057','Murtala Muhammed International Airport, Lagos, Nigeria','6.5818185','3.3211348','6424667452','https://vrom.io/_pZYIe5Aj','15601431763767','','','28.25','14','29','',''),(22,13,'seyiadebayo@gmail.com','2019-06-10','14:07:06','11b Tokunbo Omisore St, Lekki Phase I, Lagos, Nigeria','6.4477968','3.4556479','11 Ajose Adeogun St, Victoria Island, Lagos, Nigeria','6.4309786','3.436593599999999','6424819010','https://vrom.io/e7n8sZLHm','15601900262567','magicride','','40.00','6','16','expired',''),(23,13,'seyiadebayo@gmail.com','2019-06-24','02:22:28','Unnamed Road, Lekki Penninsula II, Lekki, Nigeria','6.4502611','3.5432174','11b Tokunbo Omisore St, Lekki Phase I, Lagos, Nigeria','6.4477968','3.4556479','6429498905','https://vrom.io/fFaDYmlYG','1561357348902','magicride','','76.00','13','24','',''),(24,13,'seyiadebayo@gmail.com','2019-06-27','06:30:00','Unnamed Road, Lekki Penninsula II, Lekki, Nigeria','6.4502611','3.5432174','11b Tokunbo Omisore St, Lekki Phase I, Lagos, Nigeria','6.4477968','3.4556479','6429499511','https://vrom.io/IojM8K-im','15613574843113','magicride','','76.00','13','24','',''); /*!40000 ALTER TABLE `booking` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `booking_pending` -- DROP TABLE IF EXISTS `booking_pending`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `booking_pending` ( `id` int NOT NULL AUTO_INCREMENT, `cust_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `cust_phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `job_datetime` int NOT NULL, `pickup` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pick_lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pick_lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `dropoff` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `drop_lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `drop_lng` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `vehicle` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_added` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=140 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `booking_pending` -- LOCK TABLES `booking_pending` WRITE; /*!40000 ALTER TABLE `booking_pending` DISABLE KEYS */; INSERT INTO `booking_pending` (`id`, `cust_name`, `cust_phone`, `job_datetime`, `pickup`, `pick_lat`, `pick_lng`, `dropoff`, `drop_lat`, `drop_lng`, `vehicle`, `color`, `date_added`) VALUES (1,'Lewis','',1550160321,'Fort Mill, SC, USA','35.1465534','-80.82097110000001','Fairview Road, Charlotte, NC, USA','','','bentley','','2019-02-15'),(2,'Lewis','[object Object]',1550160883,'Lewis Street, Charlotte, NC, USA','35.3003613','-80.7580041','Fort Mill, SC, USA','35.0073697','-80.9450759','bentley','','2019-02-15'),(3,'Lewis','[object Object]',1550160912,'Lewis Street, Charlotte, NC, USA','35.3003613','-80.7580041','Fort Mill, SC, USA','35.0073697','-80.9450759','bentley','','2019-02-15'),(4,'Lewis','+12025550149',1550160980,'Foundation For the Carolinas, North Tryon Street, Charlotte, NC, USA','35.228281','-80.84098499999999','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','suburban','','2019-02-15'),(5,'Lewis','+12025550149',1550162655,'Foundation For the Carolinas, North Tryon Street, Charlotte, NC, USA','35.228281','-80.84098499999999','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','suburban','','2019-02-15'),(6,'Lewis','+12025550149',1550163046,'Foundation For the Carolinas, North Tryon Street, Charlotte, NC, USA','35.228281','-80.84098499999999','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','suburban','','2019-02-15'),(7,'Lewis','+12025550149',1550163139,'Foundation For the Carolinas, North Tryon Street, Charlotte, NC, USA','35.228281','-80.84098499999999','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','suburban','','2019-02-15'),(8,'Lewis','+12025550149',1550163190,'Foundation For the Carolinas, North Tryon Street, Charlotte, NC, USA','35.228281','-80.84098499999999','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','suburban','','2019-02-15'),(9,'Lewis Cann','+61400227505',1550164073,'Fort Mill, SC, USA','35.0073697','-80.9450759','Discovery Place Science, North Tryon Street, Charlotte, NC, USA','35.229441','-80.84092709999999','tesla','','2019-02-15'),(10,'Lewis Cann','+61400227505',1550164144,'Fort Mill, SC, USA','35.0073697','-80.9450759','Discovery Place Science, North Tryon Street, Charlotte, NC, USA','35.229441','-80.84092709999999','tesla','','2019-02-15'),(11,'Lewis Cann','+61400227505',1550164279,'Fort Mill, SC, USA','35.0073697','-80.9450759','Discovery Place Science, North Tryon Street, Charlotte, NC, USA','35.229441','-80.84092709999999','tesla','','2019-02-15'),(12,'Lewis Cann','+61400227505',1550164316,'Fort Mill, SC, USA','35.0073697','-80.9450759','Discovery Place Science, North Tryon Street, Charlotte, NC, USA','35.229441','-80.84092709999999','tesla','','2019-02-15'),(13,'Lewis Cann','+61400227505',1550164362,'Fort Mill, SC, USA','35.0073697','-80.9450759','Discovery Place Science, North Tryon Street, Charlotte, NC, USA','35.229441','-80.84092709999999','tesla','','2019-02-15'),(14,'john','+19498805325',1550165115,'The Ritz-Carlton, Charlotte, East Trade Street, Charlotte, NC, USA','35.2261569','-80.84145380000001','SIP, North Tryon Street, Charlotte, NC, USA','35.227975','-80.8417086','bentley','','2019-02-15'),(15,'Lewis Cann','+61400227505',1550166193,'Huntersville, NC, USA','35.410694','-80.84285040000003','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','tesla','','2019-02-15'),(16,'Lewis C','+12025553333',1551011400,'A North Community House Road, Charlotte, NC, USA','35.0572626','-80.83607470000004','South Boulevard, Charlotte, NC, USA','35.1604634','-80.87609229999998','tesla','','2019-02-15'),(17,'Lewis C','+12025553333',1552005000,'D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','Discovery Place Science, North Tryon Street, Charlotte, NC, USA','35.229441','-80.84092709999999','suburban','','2019-02-15'),(18,'Lewis Cann','+12125554444',1550688300,'Gastonia, NC, USA','35.262082','-81.18730049999999','Huntersville, NC, USA','35.410694','-80.84285040000003','bentley','','2019-02-15'),(19,'Test john','+19498805325',1550174284,'333 East Trade Street, Charlotte, NC, USA','35.22518549999999','-80.83933580000001','South park mall, Blackvine Drive, Monroe, NC, USA','35.066534','-80.60837879999997','tesla','','2019-02-15'),(20,'Tim Hawkins','+17047062272',1550181139,'333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','Spectrum Center, East Trade Street, Charlotte, NC, USA','35.2251426','-80.8392351','bentley','','2019-02-15'),(21,'Tim Hawkins','+17047062272',1550181197,'333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','Spectrum Center, East Trade Street, Charlotte, NC, USA','35.2251426','-80.8392351','bentley','','2019-02-15'),(22,'Tim Hawkins','+19803680552',1550181213,'333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','Spectrum Center, East Trade Street, Charlotte, NC, USA','35.2251426','-80.8392351','bentley','','2019-02-15'),(23,'Joe Caldwell','+19806777716',1550250900,'CLT AIRPORT / LEVEL, Josh Birmingham Parkway, Charlotte, NC, USA','35.2216679','-80.94487300000003','Sheraton Charlotte Hotel, Charlotte, NC, USA','35.2167464','-80.83879839999997','suburban','','2019-02-15'),(24,'Lewis Cann','+61400227505',1550211955,'Fort Mill, SC, USA','35.0073697','-80.9450759','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','minivan','','2019-02-15'),(25,'Lewis Cann','',1550218161,'Gastonia, NC, USA','35.262082','-81.18730049999999','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','minivan','','2019-02-15'),(26,'Lewis Cann','',1550218402,'D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','Fort Mill, SC, USA','35.0073697','-80.9450759','minivan','','2019-02-15'),(27,'Lewis Cann',' 61400227505',1550218978,'Discovery Place Science, North Tryon Street, Charlotte, NC, USA','35.229441','-80.84092709999999','Dilworth, Charlotte, NC, USA','35.2058551','-80.85161729999999','minivan','','2019-02-15'),(28,'Lewis Cann','+61400227505',1550219052,'Fort Mill, SC, USA','35.0073697','-80.9450759','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','minivan','','2019-02-15'),(29,'Lewis Cann','+61400227505',1550219227,'Fort Mill, SC, USA','35.0073697','-80.9450759','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','minivan','','2019-02-15'),(30,'Lewis Cann','+61400227505',1550219407,'Fort Mill, SC, USA','35.0073697','-80.9450759','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','minivan','','2019-02-15'),(31,'Christian ','+18032363121',1550283084,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','Spectrum Center, East Trade Street, Charlotte, NC, USA','35.2251426','-80.8392351','sedan','','2019-02-16'),(32,'John','+19498805325',1550288567,'Bonterra Dining & Wine Room, Cleveland Avenue, Charlotte, NC, USA','35.2098594','-80.85722299999998','121 South Tryon Street, Charlotte, NC, USA','35.2266283','-80.84386940000002','suv','','2019-02-16'),(33,'Christian ','+18032363121',1550299719,'501 S College St, Charlotte, NC 28202, United States','35.2223511','-80.8456832','6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','sedan','','2019-02-16'),(34,'Christian ','+18032363121',1550299734,'501 S College St, Charlotte, NC 28202, United States','35.2223511','-80.8456832','6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','sedan','','2019-02-16'),(35,'Christian Bankhead','+18032363121',1550299743,'501 S College St, Charlotte, NC 28202, United States','35.2223511','-80.8456832','6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','sedan','','2019-02-16'),(36,'Christian Bankhead','+18032363121',1550299753,'501 S College St, Charlotte, NC 28202, United States','35.2223511','-80.8456832','6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','sedan','','2019-02-16'),(37,'Christian Bankhead','+18032363121',1550299771,'501 S College St, Charlotte, NC 28202, United States','35.2223511','-80.8456832','6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','sedan','','2019-02-16'),(38,'Hannah ','+17045788457',1550324104,'3960 Abingdon Road, Charlotte, NC, USA','35.1579549','-80.80942419999997','214 North Tryon Street, Charlotte, NC, USA','35.2279985','-80.8413468','sedan','','2019-02-16'),(39,'Marshall Monroe','+16789774470',1550348620,'215 North Pine Street, Charlotte, NC, USA','35.2311588','-80.84513090000002','ClubONE, North Carolina Music Factory Boulevard, Charlotte, NC, USA','35.2392995','-80.8453189','sedan','','2019-02-17'),(40,'Hannah ','+ 17045788457',1550349504,'214 North Tryon Street, Charlotte, NC, USA','35.2279985','-80.8413468','1919 Kensal Court, Charlotte, NC, USA','35.18176','-80.81889849999999','sedan','','2019-02-17'),(41,'Hannah ','+ 17045788457',1550349734,'214 North Tryon Street, Charlotte, NC, USA','35.2279985','-80.8413468','1919 Kensal Court, Charlotte, NC, USA','35.18176','-80.81889849999999','sedan','','2019-02-17'),(42,'Christian ','+18032363121',1550353084,'6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','2913 Freedom Dr Charlotte, NC 28208 United States','','','sedan','','2019-02-17'),(43,'Christian ','+18032363121',1550353097,'6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','2913 Freedom Dr Charlotte, NC 28208 United States','','','sedan','','2019-02-17'),(44,'Christian','+18032363121',1550353113,'6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','2913 Freedom Dr Charlotte, NC 28208 United States','','','sedan','','2019-02-17'),(45,'Christian','+18032363121',1550353120,'6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','2913 Freedom Dr Charlotte, NC 28208 United States','','','sedan','','2019-02-17'),(46,'Christian','+18032363121',1550353149,'6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','2913 Freedom Dr Charlotte, NC 28208 United States','','','sedan','','2019-02-17'),(47,'Christian','+18032363121',1550353152,'6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','2913 Freedom Dr Charlotte, NC 28208 United States','','','sedan','','2019-02-17'),(48,'Christian','+18032363121',1550353214,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','2913 Freedom Dr, Charlotte, NC 28208, United States','35.2387361','-80.8884074','sedan','','2019-02-17'),(49,'Christian','+18032363121',1550355109,'3025 Freedom Dr Charlotte, NC 28208 United States','','','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(50,'Christian','+18032363121',1550355140,'3025 Freedom Dr Charlotte, NC 28208 United States','','','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(51,'Christian ','+18032363121',1550355157,'3025 Freedom Dr Charlotte, NC 28208 United States','','','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(52,'Christian ','+18032363121',1550355165,'3025 Freedom Dr Charlotte, NC 28208 United States','','','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(53,'Christian','+18032363121',1550355197,'3025 Freedom Dr, Charlotte, NC 28208, United States','35.2400199','-80.88920159999998','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(54,'Christian','+18032363121',1550355206,'3025 Freedom Dr, Charlotte, NC 28208, United States','35.2400199','-80.88920159999998','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(55,'Christian','+18032363121',1550355239,'3025 Freedom Dr, Charlotte, NC 28208, United States','35.2400199','-80.88920159999998','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(56,'Christian','+18032363121',1550355243,'3025 Freedom Dr, Charlotte, NC 28208, United States','35.2400199','-80.88920159999998','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(57,'Christian','+18032363121',1550355251,'3025 Freedom Dr, Charlotte, NC 28208, United States','35.2400199','-80.88920159999998','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(58,'Christian','+18032363121',1550355254,'3025 Freedom Dr, Charlotte, NC 28208, United States','35.2400199','-80.88920159999998','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-17'),(59,'Christian','+18032363121',1550355398,'3025 Freedom Dr, Charlotte, NC 28208, United States','35.2400199','-80.88920159999998','333 W Trade St D Charlotte, NC 28202 United States','35.2290692','-80.84569620000002','sedan','','2019-02-17'),(60,'Marshall Monroe ','+16789774470',1550361822,'ClubONE, North Carolina Music Factory Boulevard, Charlotte, NC, USA','35.2392995','-80.8453189','Epicentre, East Trade Street, Charlotte, NC, USA','35.2253792','-80.8419644','sedan','','2019-02-17'),(61,'Crissy Lee','+12138847751',1550377469,'1424 Matthew mint hill rd ','35.117916','-80.69913329999997','ClubONE, North Carolina Music Factory Boulevard, Charlotte, NC, USA','35.2392995','-80.8453189','sedan','','2019-02-17'),(62,'Crissy Lee','+12138847751',1550387949,'ClubONE, North Carolina Music Factory Boulevard, Charlotte, NC, USA','35.2392995','-80.8453189','1424 Matthews-Mint Hill Road, Matthews, NC, USA','35.117916','-80.69913329999997','sedan','','2019-02-17'),(63,'Vincent Berry II','+13106637908',1550388201,'AC Hotel by Marriott Charlotte City Center, East Trade Street, Charlotte, NC, USA','35.2253609','-80.84114979999998','515 West 7th Street, Charlotte, NC, USA','35.233225','-80.84441199999998','sedan','','2019-02-17'),(64,'Christian','+18032363121',1550391487,'101–119 S Mint St Charlotte, NC 28202 United States','','','6025 Tyvola Glen Cir Charlotte, NC 28217 United States','','','sedan','','2019-02-17'),(65,'Christian ','+18032363121',1550391582,'BNR Studios, West Trade Street, Charlotte, NC, USA','35.2290681','-80.84565700000002','6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','sedan','','2019-02-17'),(66,'Lonnie','+18038408180',1550433049,'333 W Trade St D Charlotte, NC 28202 United States','35.2290692','-80.84569620000002','6047 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.1641683','-80.89221079999999','sedan','','2019-02-18'),(67,'Briana Cook','+17025617497',1550438664,'1804 Gander Cove Ln, Matthews, NC, USA','35.130868','-80.738517','Oak Room, East Bland Street, Charlotte, NC, USA','35.216355','-80.85467440000002','sedan','','2019-02-18'),(68,'Maurice ','+17045348339',1550446890,'318 W Flint st','42.7847747','-83.24648150000002','Airport Center Parkway, Charlotte, NC, USA','35.2203317','-80.92173600000001','sedan','','2019-02-18'),(69,'Christian ','+18032363121',1550451774,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','1210 Rebecca Bailey Drive, Charlotte, NC 28262, USA','35.3134996','-80.718726','sedan','','2019-02-18'),(70,'Diondre Lewis','+13238068845',1550458079,'Bulla Gastrobar, Sharon Road, Charlotte, NC, USA','35.1529592','-80.8279693','333 w. trade st #2100','','','minivan','','2019-02-18'),(71,'Diondre Lewis','+13238068845',1550458110,'Bulla Gastrobar, Sharon Road, Charlotte, NC, USA','35.1529592','-80.8279693','333 w. trade st #2100','','','minivan','','2019-02-18'),(72,'Diondre Lewis','+13238068845',1550458193,'Bulla Gastrobar, Sharon Road, Charlotte, NC, USA','35.1529592','-80.8279693','333 w. trade st #2100','','','minivan','','2019-02-18'),(73,' Christian','+18032363121',1550478062,'1325 Rebecca Bailey Dr, Charlotte, NC 28262, United States','35.312532','-80.71737100000001','6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','sedan','','2019-02-18'),(74,'Lonnie','+18032363121',1550515368,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-19'),(75,'Lonnie','+18032363121',1550515391,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-19'),(76,'Christian ','+18032363121',1550515410,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-19'),(77,'Christian ','+18032363121',1550515418,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-19'),(78,'Christian ','+18032363121',1550515424,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-19'),(79,'Christian ','+18032363121',1550515455,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','35.2290692','-80.84569620000002','sedan','','2019-02-19'),(80,'Christian','+18032363121',1550516053,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-19'),(81,'Christian ','+18032363121',1550516067,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','','','sedan','','2019-02-19'),(82,'Christian Bankhead','+18032363121',1550516106,'6025 Tyvola Glen Cir, Charlotte, NC 28217, United States','35.16523','-80.89216750000003','333 W Trade St D Charlotte, NC 28202 United States','35.2290692','-80.84569620000002','sedan','','2019-02-19'),(83,'Lonnie','+18038408180',1550516286,'6025 Tyvola Glen Circle, Charlotte, NC, USA','35.16523','-80.89216750000003','333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','sedan','','2019-02-19'),(84,'Mick - Ciroq Executive','+19806777716',1550581200,'Embassy Suites By Hilton Charlotte Uptown, East Martin Luther King Junior Boulevard, Charlotte, NC, USA','35.2219624','-80.8425924','CLT AIRPORT / LEVEL, Josh Birmingham Parkway, Charlotte, NC, USA','35.2216679','-80.94487300000003','suv','','2019-02-19'),(85,'John','+19498805325',1550769167,'1930 Camden Road, Charlotte, NC, USA','35.2110826','-80.86104339999997','333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','sedan','','2019-02-22'),(86,'Thomas','+19802575656',1550771416,'Tilt on Trade, West Trade Street, Charlotte, NC, USA','35.2278742','-80.84410379999997','Family Dollar, Charlotte, NC, USA','35.240577','-80.85801099999998','sedan','','2019-02-22'),(87,'TajahWantsToSmokeCigs','+19806777716',1550779508,'A Mouthful, Tuckaseegee Road, Charlotte, NC, USA','35.238244','-80.87577799999997','333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','sedan','','2019-02-22'),(88,'Thomas','+19802575656',1550845255,'5521 Patton Street, Charlotte, NC, USA','35.3075862','-80.80942419999997','333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','sedan','','2019-02-22'),(89,'Lewis','+12015551234',1550847468,'Fort Mill, SC, USA','35.0073697','-80.9450759','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','luxury','','2019-02-22'),(90,'Lewis','+12015551234',1550847680,'Fort Mill, SC, USA','35.0073697','-80.9450759','South Boulevard, Charlotte, NC, USA','35.1604634','-80.87609229999998','suv','','2019-02-22'),(91,'Lewis','+12015551234',1550847742,'D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','South Boulevard, Charlotte, NC, USA','35.1604634','-80.87609229999998','luxury','','2019-02-22'),(92,'Test, test, test ','+19498805325',1550879136,'Taco Bell, South Boulevard, Charlotte, NC, USA','35.2040937','-80.8633299','IBG Software, West Trade Street, Charlotte, NC, USA','35.2290681','-80.84565700000002','sprinter','','2019-02-23'),(93,'Lewis','+12015551234',1550904653,'D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','South Boulevard, Charlotte, NC, USA','35.1604634','-80.87609229999998','luxury','black','2019-02-23'),(94,'Lewis','+12015551234',1550913239,'Fort Mill, SC, USA','35.0073697','-80.9450759','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','luxury','black','2019-02-23'),(95,'elaine hughes','+15032607979',1553458500,'353 whippoorwill road Mooresville ','','','20517 n main street davidson','','','sedan','','2019-02-24'),(96,'Derek Fitzgerald','+17044992102',1550960478,'Chipotle Mexican Grill, 8509 Concord Mills Boulevard, Concord, NC, USA','35.372146','-80.72259439999999','10825 Twisted Bark Lane, Charlotte, NC, USA','35.300318','-80.68937499999998','sedan','any','2019-02-24'),(97,'Lewis','+12015551234',1551068116,'Fort Mill, SC, USA','35.0073697','-80.9450759','D Mineral Springs Road, Charlotte, NC, USA','35.290311','-80.78618469999998','sedan','','2019-02-25'),(98,'Lewis','+12015551234',1551068158,'Fort Mill, SC, USA','35.0073697','-80.9450759','South Boulevard, Charlotte, NC, USA','35.1604634','-80.87609229999998','luxury','','2019-02-25'),(99,'Diondre lewis','+13238068845',1551182737,'333 w. trade st #2100','35.228893','-80.84577639999998','Cafe Monte, Fairview Road, Charlotte, NC, USA','35.1471502','-80.82898560000001','sedan','any','2019-02-26'),(100,'Mohamad Nader','+17049497165',1552996800,'IBG Software, West Trade Street, Charlotte, NC, USA','35.2290681','-80.84565700000002','3451 Teal Point Drive, Charlotte, NC, USA','35.206387','-80.75953190000001','suv','black','2019-02-27'),(101,'Jeanna martin','+17046205803',1551298007,'8105 south gemini springs dr kannapolis','35.4702405','-80.66311239999999','2459 Wilkinson Boulevard, Charlotte, NC, USA','35.2233812','-80.8817942','sedan','any','2019-02-28'),(102,'Lewis','+12015551234',1551327217,'D Mineral Springs Road, Charlotte, NC, USA','35.299172','-80.79089899999997','Fort Mill, SC, USA','35.0073697','-80.9450759','luxury','','2019-02-28'),(103,'Tim Hawkins','+17047062272',1553171400,'333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','Walmart Supercenter, Wilkinson Boulevard, Charlotte, NC, USA','35.2265914','-80.89454490000003','sedan','','2019-03-01'),(104,'Tim Hawkins','+17047062272',1553531400,'Walmart Supercenter, Wilkinson Boulevard, Charlotte, NC, USA','35.2265914','-80.89454490000003','333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','sedan','','2019-03-01'),(105,'Mohamad Nader','+17049497165',1553169600,'IBG Global Consulting, West Trade Street, Charlotte, NC, USA','35.22899','-80.84545969999999','3451 Teal Point Drive, Charlotte, NC, USA','35.206387','-80.75953190000001','sedan','','2019-03-01'),(106,'John ','+19498805325',1551385709,'IBG Global Consulting, West Trade Street, Charlotte, NC, USA','35.22899','-80.84545969999999','3400 Tuckaseegee Road, Charlotte, NC, USA','35.2446704','-80.88344749999999','suv','black','2019-03-01'),(107,'JimmiVae','+17049773085',1551474840,'8101 Woodscape Drive, Charlotte, NC, USA','35.1606529','-80.7485934','Sea Level NC, East 5th Street, Charlotte, NC, USA','35.2275712','-80.8410996','sedan','','2019-03-02'),(108,'JimmiVae','+17049773085',1551475040,'8101 Woodscape Drive, Charlotte, NC, USA','35.1606529','-80.7485934','Sea Level NC, East 5th Street, Charlotte, NC, USA','35.2275712','-80.8410996','sedan','','2019-03-02'),(109,'Mohamad','+17049497165',1553256000,'IBG Global Consulting, West Trade Street, Charlotte, NC, USA','35.22899','-80.84545969999999','3451 Teal Point Drive, Charlotte, NC, USA','35.206387','-80.75953190000001','sedan','','2019-03-02'),(110,'Tim Hawkins','+ 17047062272',1553257200,'225 South Poplar Street, Charlotte, NC, USA','35.2273745','-80.84686060000001','Charlotte Douglas International Airport (CLT), Josh Birmingham Parkway, Charlotte, NC, USA','35.2144026','-80.94731460000003','sedan','','2019-03-02'),(111,'Brett Wilson','+19516912244',1551493177,'Common Market, 2007 Commonwealth Ave, Charlotte, NC 28205','','','Uptown Cabaret, 108 E Morehead St, Charlotte, NC 28202','','','sedan','any','2019-03-02'),(112,'Brett Wilson','+19516912244',1551493207,'','','','','','','sedan','any','2019-03-02'),(113,'Brett Wilson','+19516912244',1551493773,'Common Market, 2007, Commonwealth Ave, Charlotte, NC 28205, USA','','','Uptown Cabaret, 108 E Morehead St, Charlotte, NC 28202','','','sedan','any','2019-03-02'),(114,'Elaine Hughes','+15032607979',1553342400,'353 whippoorwill road mooresville nc 28117','35.5941803','-80.90575890000002','Fahrenheit, South Caldwell Street, Charlotte, NC, USA','35.22239080000001','-80.84137320000002','suv','black','2019-03-03'),(115,'Tyrell Jenkins','+18039001727',1551559294,'132 McCullough Drive, Charlotte, NC, USA','35.2991289','-80.7530961','Charlotte center city, Charlotte, NC, USA','35.2272302','-80.84608220000001','luxury','any','2019-03-03'),(116,'Tyrell Jenkins','+18039001727',1552625100,'132 McCullough Drive, Charlotte, NC, USA','35.2991289','-80.7530961','Charlotte center city, Charlotte, NC, USA','35.2272302','-80.84608220000001','sprinter','black','2019-03-03'),(117,'brett wilson','+19516912244',1551570394,'Burger King, East Trade Street, Charlotte, NC, USA','35.2245254','-80.8404691','1023 Central Avenue, Charlotte, NC, USA','35.222463','-80.819728','sedan','','2019-03-03'),(118,'brett wilson','+19516912244',1551571812,'Two Scoops Creamery Plaza Midwood, Central Avenue, Charlotte, NC, USA','35.221801','-80.82251099999996','North Carolina Music Factory Boulevard, Charlotte, NC, USA','35.23790140000001','-80.8419341','sedan','','2019-03-03'),(119,'elaine hughes','+15032607979',1554424200,'Farenhe','','','353 whippoorwill road mooresville nc 28117','','','suv','black','2019-03-03'),(120,'Elaine Hughes','+ 15032607979',1554424200,'Fahrenheit, South Caldwell Street, Charlotte, NC, USA','35.22239080000001','-80.84137320000002','353 Whippoorwill road mooresville nc 28117','','','suv','','2019-03-03'),(121,'elaine hughes','+15032607979',1554424200,'Fahrenheit, South Caldwell Street, Charlotte, NC, USA','35.22239080000001','-80.84137320000002','353 whippoorwill road mooresville nc 28117','','','suv','','2019-03-03'),(122,'brett ','+19516912244',1551580237,'255 West Martin Luther King JR Boulevard, Charlotte, NC, USA','35.2259734','-80.84802819999999','2909 North Davidson Street, Charlotte, NC, USA','35.2454231','-80.80944579999999','sedan','','2019-03-03'),(123,'Maynetayn','+19802021875',1551585940,'4406 Raku Court, Charlotte, NC, USA','35.3178519','-80.81025999999997','210 East Trade Street, Charlotte, NC, USA','35.2252754','-80.84202679999999','sedan','','2019-03-03'),(124,'brett ','+19516912244',1551586021,'Heist Brewery, North Davidson Street, Charlotte, NC, USA','35.2452802','-80.8093055','155 Fox Hunt Drive, Moorsville dr','35.0308528','-80.57943649999999','sedan','','2019-03-03'),(125,'Maynetayn','+19802021875',1551636932,'210 East Trade Street, Charlotte, NC, USA','35.2252754','-80.84202679999999','4408 Raku Court, Charlotte, NC, USA','35.3178181','-80.80985859999998','sedan','','2019-03-04'),(126,'Tyrell Jenkins','+18039001727',1551667369,'BNR Studios, West Trade Street, Charlotte, NC, USA','35.228943','-80.84602619999998','132 McCullough Drive, Charlotte, NC, USA','35.2991289','-80.7530961','sedan','','2019-03-04'),(127,'Tyrell Jenkins','+ 18039001727',1551717202,'BNR Studios, West Trade Street, Charlotte, NC, USA','35.228943','-80.84602619999998','South Carolina 97, Camden, SC, USA','34.27602359999999','-80.60946820000004','sprinter','black','2019-03-05'),(128,'Tim Hawkins','+ 17047062272',1551928082,'Charlotte Douglas International Airport (CLT), Josh Birmingham Parkway, Charlotte, NC, USA','35.2144026','-80.94731460000003','225 South Poplar Street, Charlotte, NC, USA','35.2273745','-80.84686060000001','sedan','','2019-03-07'),(129,'John Doyle ','+19789874850',1555560000,'CLT airport (CLT), Josh Birmingham Parkway, Charlotte, NC, USA','35.2144026','-80.94731460000003','155 fox Hunt drive mooresville nc','','','sedan','','2019-03-11'),(130,'Tim Hawkins','+ 17047062272',1552258258,'225 South Poplar Street, Charlotte, NC, USA','35.2273745','-80.84686060000001','Home Depot, Charlotte, NC, USA','35.1937228','-80.79183419999998','sedan','','2019-03-11'),(131,'Lewis ','+12015550123',1552310894,'D Mineral Springs Road, Charlotte, NC, USA','35.299172','-80.79089899999997','Fort Mill, SC, USA','35.0073697','-80.9450759','sedan','','2019-03-11'),(132,'John Doyle ','+19789874850',1555560000,'CLT airport (CLT), Josh Birmingham Parkway, Charlotte, NC, USA','35.2144026','-80.94731460000003','155 Fox Hunt Dr mooresville NC 28117','','','sedan','','2019-03-12'),(133,'John ','+19789874850',1552352826,'CLT airport (CLT), Josh Birmingham Parkway, Charlotte, NC, USA','35.2144026','-80.94731460000003','155 fox Hunt drive mooresville ','','','sedan','','2019-03-12'),(134,'John ','+19789874850',1552391840,'155 Fox Hunt Dr mooresville nc','35.6403547','-80.91185159999998','Charlotte Douglas International Airport (CLT), Josh Birmingham Parkway, Charlotte, NC, USA','35.2144026','-80.94731460000003','sedan','','2019-03-12'),(135,'Lewis Cann','+ 61400227505',1552461910,'G G B Hill Road, Monroe, NC, USA','35.0594998','-80.48299320000001','South Boulevard, Charlotte, NC, USA','35.1604634','-80.87609229999998','sedan','','2019-03-13'),(136,'John ','+19789874850',1557247500,'155 Fox Hunt Dr mooresville nc','35.6403547','-80.91185159999998','CLT airport (CLT), Josh Birmingham Parkway, Charlotte, NC, USA','35.2144026','-80.94731460000003','sedan','','2019-03-14'),(137,'Test ','+19498805325',1552763446,'Boston Market, Providence Road, Charlotte, NC, USA','35.1975338','-80.82609680000002','333 West Trade Street, Charlotte, NC, USA','35.2287821','-80.84577949999999','suv','black','2019-03-17'),(138,'Jermaine spencer ','+17044919749',1552794029,'333 W Trade St unit 100, charlotte, nc, 28202','','','4408 Raku Court Charlotte, NC 28269','','','sedan','','2019-03-17'),(139,'Shamica Colwell ','+19802263462',1557909000,'1411 Mandy Place Court, Charlotte, NC, USA','35.3252881','-80.89581950000002','FedEx Ground, Csx Way, Charlotte, NC, USA','35.2730964','-80.91871980000002','sedan','any','2019-04-04'); /*!40000 ALTER TABLE `booking_pending` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `booking_spatula` -- DROP TABLE IF EXISTS `booking_spatula`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `booking_spatula` ( `id` int NOT NULL AUTO_INCREMENT, `bid` int NOT NULL, `spatula_ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `spatula_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_added` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=71 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `booking_spatula` -- LOCK TABLES `booking_spatula` WRITE; /*!40000 ALTER TABLE `booking_spatula` DISABLE KEYS */; INSERT INTO `booking_spatula` (`id`, `bid`, `spatula_ref`, `spatula_link`, `date_added`) VALUES (1,11,'6310816568','https://sptu.la/77oObe2_-x','2019-02-15 01:11:21'),(2,12,'6310816846','https://sptu.la/kd6823SUf','2019-02-15 01:11:57'),(3,13,'6310817117','https://sptu.la/a5NDTFZL-x','2019-02-15 01:12:44'),(4,14,'6310822148','https://sptu.la/7wogir2Jb','2019-02-15 01:25:16'),(5,15,'6310829618','https://sptu.la/D5FvuOLjY','2019-02-15 01:43:15'),(6,16,'6310855325','https://sptu.la/n8OcpXt3T','2019-02-15 02:21:49'),(7,23,'6311781613','https://sptu.la/iguj4RW51','2019-02-15 12:31:29'),(8,24,'6312012779','https://sptu.la/QnamRivk7','2019-02-15 14:25:56'),(9,30,'6312298187','https://sptu.la/hfXxjq0Gs','2019-02-15 16:30:09'),(10,31,'6313046612','https://sptu.la/zL3EngTt9','2019-02-16 10:11:26'),(11,32,'6313124689','https://sptu.la/CJGaI7sOC','2019-02-16 11:42:50'),(12,37,'6313296618','https://sptu.la/OHOA6uep8','2019-02-16 14:49:32'),(13,38,'6313484838','https://sptu.la/I4-8OzEQa','2019-02-16 21:35:07'),(14,39,'6313761296','https://sptu.la/nHWms2fru','2019-02-17 04:23:42'),(15,40,'6313770347','https://sptu.la/8buHSwgGX','2019-02-17 04:38:28'),(16,41,'6313772700','https://sptu.la/sqEo23KF1','2019-02-17 04:42:16'),(17,48,'6313810334','https://sptu.la/-yszAksta','2019-02-17 05:40:16'),(18,59,'6313833730','https://sptu.la/cxIo15TD9','2019-02-17 06:16:40'),(19,60,'6313884071','https://sptu.la/OVCOHLoAm','2019-02-17 08:03:45'),(20,61,'6314028111','https://sptu.la/CmkXKdb9E','2019-02-17 12:24:31'),(21,62,'6314129465','https://sptu.la/uyKu3P7xo','2019-02-17 15:19:12'),(22,63,'6314130337','https://sptu.la/YqXpvU4_o','2019-02-17 15:23:23'),(23,65,'6314158394','https://sptu.la/oKd61qiAo','2019-02-17 16:19:44'),(24,66,'6314489678','https://sptu.la/T0XFX6Kyi','2019-02-18 03:50:51'),(25,67,'6314556437','https://sptu.la/DLGwdRHf-x','2019-02-18 05:24:25'),(26,68,'6314732168','https://sptu.la/bWuSdFsVs','2019-02-18 07:41:33'),(27,69,'6314923847','https://sptu.la/WzDimfRQL','2019-02-18 09:02:56'),(28,73,'6315763195','https://sptu.la/t6p44bko2','2019-02-18 16:21:04'),(29,79,'6316111048','https://sptu.la/HaCg58azi','2019-02-19 02:44:16'),(30,82,'6316115346','https://sptu.la/lRoXbBEHQ','2019-02-19 02:55:08'),(31,83,'6316116613','https://sptu.la/s5lXF_V3X','2019-02-19 02:58:08'),(32,84,'6317052306','https://sptu.la/w4Kearm6P','2019-02-19 13:36:50'),(33,85,'6320931327','https://sptu.la/avRuCpY99','2019-02-22 01:12:49'),(34,86,'6320944700','https://sptu.la/O_ufZ_Gv2','2019-02-22 01:50:19'),(35,87,'6321020991','https://sptu.la/_KxeIcRi5','2019-02-22 04:05:10'),(36,88,'6322615266','https://sptu.la/1xL8vIbOo','2019-02-22 22:20:58'),(37,89,'6322629642','https://sptu.la/IK6uj_lAW','2019-02-22 22:57:50'),(38,90,'6322638922','https://sptu.la/RMGdySoKW','2019-02-22 23:01:22'),(39,91,'6322639223','https://sptu.la/zkxv5dL3J','2019-02-22 23:02:24'),(40,92,'6322952985','https://sptu.la/X8aHgSx9H','2019-02-23 07:45:39'),(41,91,'6323260814','https://sptu.la/smhPF_huW','2019-02-23 14:38:52'),(42,93,'6323268287','https://sptu.la/w0fMzE_UB','2019-02-23 14:51:46'),(43,94,'6323349975','https://sptu.la/oqD2ZI5AM','2019-02-23 17:15:30'),(44,97,'6325169361','https://sptu.la/jCSe_0Jbp','2019-02-25 12:15:17'),(45,100,'6327770792','https://sptu.la/t0l8JjIGP','2019-02-27 04:24:48'),(46,103,'6331013628','https://sptu.la/7ZYE9ea9h','2019-03-01 02:33:47'),(47,104,'6331050612','https://sptu.la/1ygVr8moE','2019-03-01 03:43:07'),(48,105,'6331051547','https://sptu.la/iqc9z2-Y0','2019-03-01 03:44:56'),(49,106,'6331078304','https://sptu.la/rsPY2_96B','2019-03-01 04:28:31'),(50,107,'6332743427','https://sptu.la/kIPnQLYVt','2019-03-02 05:14:03'),(51,108,'6332744516','https://sptu.la/OF8eRiGXL','2019-03-02 05:17:23'),(52,109,'6332747143','https://sptu.la/sSLEjn8SM','2019-03-02 05:24:27'),(53,110,'6332751161','https://sptu.la/hRIrkeID3','2019-03-02 05:35:08'),(54,114,'6333397979','https://sptu.la/j4GJbi7Rh','2019-03-03 01:54:14'),(55,116,'6333488340','https://sptu.la/2zXp-8OXA','2019-03-03 04:45:16'),(56,117,'6333571629','https://sptu.la/b5QrPfHF2','2019-03-03 07:46:37'),(57,118,'6333578533','https://sptu.la/RJ9f9f42K','2019-03-03 08:10:14'),(58,122,'6333659398','https://sptu.la/jF_oCHu5G','2019-03-03 10:30:39'),(59,123,'6333712455','https://sptu.la/sJ7dx7m2m','2019-03-03 12:05:42'),(60,124,'6333712812','https://sptu.la/C940jiB79','2019-03-03 12:07:05'),(61,125,'6334090855','https://sptu.la/gYHpWz318','2019-03-04 02:15:37'),(62,126,'6334370279','https://sptu.la/Av8Bq25v6','2019-03-04 10:42:53'),(63,127,'6334752388','https://sptu.la/OrPhd1k6d','2019-03-05 00:33:25'),(64,128,'6338543142','https://sptu.la/T9VnCUeOH','2019-03-07 11:08:04'),(65,130,'6342837939','https://sptu.la/fE68xbg7j','2019-03-11 06:51:18'),(66,131,'6344220247','https://sptu.la/hrZDtYILV','2019-03-11 21:28:15'),(67,135,'6347060608','https://sptu.la/rFGrXF_lN','2019-03-13 15:25:11'),(68,136,'6347504295','https://sptu.la/orqniGTGK','2019-03-14 00:44:44'),(69,137,'6351901340','https://sptu.la/bqJn54LkQ','2019-03-17 03:10:49'),(70,139,'6376480981','https://sptu.la/vNUavIrue','2019-04-04 08:00:29'); /*!40000 ALTER TABLE `booking_spatula` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `credits` -- DROP TABLE IF EXISTS `credits`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `credits` ( `id` int NOT NULL AUTO_INCREMENT, `customer_id` int NOT NULL, `value` int NOT NULL, `date_created` date NOT NULL, `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_used` tinyint(1) NOT NULL DEFAULT '0', `date_used` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `credits` -- LOCK TABLES `credits` WRITE; /*!40000 ALTER TABLE `credits` DISABLE KEYS */; /*!40000 ALTER TABLE `credits` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer_details` -- DROP TABLE IF EXISTS `customer_details`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_details` ( `id` int NOT NULL AUTO_INCREMENT, `cid` int NOT NULL, `address` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `addr_lat` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `addr_long` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer_details` -- LOCK TABLES `customer_details` WRITE; /*!40000 ALTER TABLE `customer_details` DISABLE KEYS */; INSERT INTO `customer_details` (`id`, `cid`, `address`, `addr_lat`, `addr_long`) VALUES (2,3,'Fox Hunt Rd, Charlotte, NC 28212, USA','35.196444','-80.7342939'),(3,4,'Charlotte, NC, USA','35.2270869','-80.8431267'),(4,5,'Charlotte, NC, USA','35.2270869','-80.8431267'),(5,6,'155 Fox Hunt Dr, Mooresville, NC 28117, USA','35.6403547','-80.91185159999999'),(6,7,'155 Fox Hunt Dr, Mooresville, NC 28117, USA','35.6403547','-80.91185159999999'),(7,8,'15520 Statesville Rd, Huntersville, NC 28078, USA','35.4274259','-80.860985'),(8,9,'Belo Horizonte, State of Minas Gerais, Brazil','-19.9166813','-43.9344931'),(9,10,'','0.0','0.0'),(10,11,'','0.0','0.0'),(11,12,'','0.0','0.0'),(12,13,'','0.0','0.0'),(13,14,'','0.0','0.0'),(14,15,'','0.0','0.0'); /*!40000 ALTER TABLE `customer_details` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customer_tokens` -- DROP TABLE IF EXISTS `customer_tokens`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customer_tokens` ( `id` int NOT NULL AUTO_INCREMENT, `cid` int NOT NULL, `bt_cust_id` int NOT NULL, `access_token_value` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `status` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, `modified` datetime DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=823 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customer_tokens` -- LOCK TABLES `customer_tokens` WRITE; /*!40000 ALTER TABLE `customer_tokens` DISABLE KEYS */; INSERT INTO `customer_tokens` (`id`, `cid`, `bt_cust_id`, `access_token_value`, `status`, `created`, `modified`) VALUES (810,3,655216104,'k9bf87','1','2019-03-05 10:29:50',NULL),(811,4,523588156,'8pk6kx','1','2019-03-14 11:54:11',NULL),(812,5,475488506,'dm2433','1','2019-03-14 14:14:41',NULL),(813,6,471167763,'9jdn3n','1','2019-03-24 09:37:09',NULL),(814,7,598173031,'7hsd39','1','2019-04-13 07:31:46',NULL),(815,8,660871129,'2v97nv','1','2019-04-13 07:37:05',NULL),(816,9,534819689,'5n7w6q','1','2019-05-03 02:18:09',NULL),(817,10,820739054,'g4qcxv','1','2019-05-12 03:52:11',NULL),(818,11,532196886,'7x75b5','1','2019-06-09 21:03:02',NULL),(819,12,645416329,'6mk2jf','1','2019-06-10 02:14:47',NULL),(820,13,232225059,'hczgxv','1','2019-06-10 02:22:05',NULL),(821,14,519158309,'gwjkgq','1','2019-06-10 03:11:46',NULL),(822,15,540347124,'c8d699','1','2019-07-03 03:35:55',NULL); /*!40000 ALTER TABLE `customer_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `customers` -- DROP TABLE IF EXISTS `customers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `customers` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL, `password` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `firebase_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `promo_code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `promo_used` tinyint(1) NOT NULL DEFAULT '0', `is_delete` tinyint(1) NOT NULL DEFAULT '0', `created` datetime NOT NULL, `modified` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `customers` -- LOCK TABLES `customers` WRITE; /*!40000 ALTER TABLE `customers` DISABLE KEYS */; INSERT INTO `customers` (`id`, `name`, `mobile`, `email`, `password`, `firebase_token`, `promo_code`, `promo_used`, `is_delete`, `created`, `modified`) VALUES (3,'Lewis Cann','+61413774931','lwscann@gmail.com','a8f246b29b40363f946e2d94a3a6d2e1','c_Pm113yur4:APA91bHrrMFxILt5I5UMYLypr1s_-1mh8e_3FA1ZJ7DQUC-NpakG01ABV0pONLcTYJiCo6BkLgdSew99ZL5M9qf4Dazh1ln8PMuTcbZJv4zeMVV4UQP3uK-ilJM_ogMF9iXiOZindnGv','',1,0,'2019-03-05 10:29:50','2019-03-05 10:29:50'),(4,'Mel Cann','+61413774931','mel-cann@live.com.au','d41d8cd98f00b204e9800998ecf8427e','','',1,0,'2019-03-14 11:54:11','2019-03-14 11:54:11'),(5,'Oliver Cann','+61413774931','lewis@perthdesignateddrivers.com.au','d41d8cd98f00b204e9800998ecf8427e','','',1,0,'2019-03-14 14:14:41','2019-03-14 14:14:41'),(6,'John Doyle','+19498805325','johndryves@gmail.com','5f4dcc3b5aa765d61d8327deb882cf99','cVqErz0O9vk:APA91bFbnMB-CIoeWhJ7h4GHNXzqB5IVRA611jMqosmXx16QrwZv9mfxFTBdFAK7XYI32NlSPxCwWtxd97pak3d10V2dSLl7YEoFMtgykrQDBCHT92SRLtEQTSUmC2HuqzydmAgKQv2v','',1,0,'2019-03-24 09:37:09','2019-03-24 09:37:09'),(7,'demo one','+17046588782','jddemoapp@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','cJqEQjfueQM:APA91bHGO8YRwcCZeLdjEGOP2-bJlt4jJ2vP4IXWlai6PVBvIbCS4d1xi4H1ySCqI28Sv89HWJDNV0H7xPjBaCSikAKqTzFL07D7fju2aIS1lqIx1fetkED5MXmxcHZ9opJYMJMfPIym','',1,0,'2019-04-13 07:31:46','2019-04-13 07:31:46'),(8,'demo two','+17042307201','jddemoapp2@gmail.com','827ccb0eea8a706c4c34a16891f84e7b','dhI4MIK74N8:APA91bFP8_-NUQvHc61RLas_rPy1EEBOpkNhKE192VUi7uNWlLdm4RLeeAyjnrKK6XnxQVEE7cssZKKVeBdYgCECKU9x8otsZlGNer7MGqV8RB0gGOnEbIx3TSNvnKA6oo0kWeDiCZBs','',1,0,'2019-04-13 07:37:05','2019-04-13 07:37:05'),(9,'bob bob','+61413774931','lewis@gmail.com','a8f246b29b40363f946e2d94a3a6d2e1','','',1,0,'2019-05-03 02:18:09','2019-05-03 02:18:09'),(10,'Seyi Adebayo-Olubi','+2348029564392','seyivxgroup@gmail.com','2df9e7355fa07cbcb9448e98516ba980','cFBuafOe_2k:APA91bGMafmlrez8sOvZBTzp7Zb1SW9blcodR5f5wGDEmcONQ7UTThJIX3udKqEkSK-TZ1SlRukPGioSa7YLUnoB2HQb7L39nFVV8yFdKC_0VPpA-QzW0AKTFHGwyNy7GDs-sNSoKMk3','',1,0,'2019-05-12 03:52:11','2019-05-12 03:52:11'),(11,'Ahmed Yesufu','+2348188014286','yesufua@aol.com','019caf012d558804b80d6ecf94657ccf','cq8Wqz_IFMM:APA91bHIos4dcXwKfZzZR5YeKBLSW2rpK3ZlhbKQYPRqW0NjYlJQ8eXH9saJsKNSprJAIeYHWkS38AuOsWZZd8SCB71ar75x202IOVX2mJBhrj8uabNkLutQS9BobuZUoyXCsJ96Aj0e','',1,0,'2019-06-09 21:03:02','2019-06-09 21:03:02'),(12,'test test','+61413774931','test@test.com','cc03e747a6afbbcbf8be7668acfebee5','fpUcm8ew-Y8:APA91bGKEFC6xgv7bfqqSgmaHOWpGMxeSt-zmOfE3ZmR3bJf4b4I4pT0940AnlZkMk-rVnl5jPkQLl-iV43PsFE86bGIoX4XxOmLnf8IrW5mKcQeH6jTFZn1Te-odNg-lOpCLFkmCuVL','',1,0,'2019-06-10 02:14:47','2019-06-10 02:14:47'),(13,'Oluseyi Adebayo-Olubi','+2348029564392','seyiadebayo@gmail.com','8f0e35648f2b006c8e83396762e9f6ff','cFBuafOe_2k:APA91bGMafmlrez8sOvZBTzp7Zb1SW9blcodR5f5wGDEmcONQ7UTThJIX3udKqEkSK-TZ1SlRukPGioSa7YLUnoB2HQb7L39nFVV8yFdKC_0VPpA-QzW0AKTFHGwyNy7GDs-sNSoKMk3','',1,0,'2019-06-10 02:22:05','2019-06-10 02:22:05'),(14,'hellen michaell','+255688000016','hellen.michaell@gmail.com','8920672cb1e5e2a45ae5381aa72b53b4','e781ogRVbnA:APA91bG7fUCguQGOt2JYj63jWE6t6azZ4H8XLe4t5TbEBboKSRrbHzTc6hTeKi5aWKEOEOcyOLHxdyjfc2CGxueRV6RdRwHU2RkwGvu2ihclqEfn8qojqZiO0FQjbfsePtEMqKroSGcQ','',1,0,'2019-06-10 03:11:46','2019-06-10 03:11:46'),(15,'Tobi Kuti','+2348088412804','tobbycooty@gmail.com','8b55ecbdff5b6849978a81bb14b696b4','dE0h8OeR66k:APA91bENg5WKT_4HCoRGd1OsbTnN3wSePNtdQbTPnGwDjsMUIw8IOj4CLloZXb7RJ6s3928iDOo9CIi0IJaf--vPzSo3_ftKrFWxD0l9B9cKlpRLt8vZxnR-SHIiq99dKKz3rDicwNHr','',1,0,'2019-07-03 03:35:55','2019-07-03 03:35:55'); /*!40000 ALTER TABLE `customers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `driver_avail` -- DROP TABLE IF EXISTS `driver_avail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `driver_avail` ( `id` int NOT NULL AUTO_INCREMENT, `driver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `week_ending` date NOT NULL, `day1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day7` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_updated` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `driver_avail` -- LOCK TABLES `driver_avail` WRITE; /*!40000 ALTER TABLE `driver_avail` DISABLE KEYS */; /*!40000 ALTER TABLE `driver_avail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `driver_default_avail` -- DROP TABLE IF EXISTS `driver_default_avail`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `driver_default_avail` ( `id` int NOT NULL AUTO_INCREMENT, `driver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day1` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day2` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day3` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day4` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day5` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day6` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `day7` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_updated` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `driver_default_avail` -- LOCK TABLES `driver_default_avail` WRITE; /*!40000 ALTER TABLE `driver_default_avail` DISABLE KEYS */; /*!40000 ALTER TABLE `driver_default_avail` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `driver_onboard` -- DROP TABLE IF EXISTS `driver_onboard`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `driver_onboard` ( `id` int NOT NULL AUTO_INCREMENT, `first_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `last_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `dob` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `licence` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_added` date NOT NULL, `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `driver_onboard` -- LOCK TABLES `driver_onboard` WRITE; /*!40000 ALTER TABLE `driver_onboard` DISABLE KEYS */; INSERT INTO `driver_onboard` (`id`, `first_name`, `last_name`, `dob`, `address`, `licence`, `phone`, `email`, `date_added`, `type`) VALUES (1,'Bob','Brown','21/06/1988','Dolphin Estate, Lagos, Nigeria','45678','09768768567','','2019-05-17',''),(2,'Lewis','Cann','21/06/1988','Dolphin Estate, Lagos, Nigeria','45678','09768768567','lwscann@gmail.com','2019-05-17',''),(3,'Oliver','Cann','21/06/1988','Nnamdi Azikiwe International Airport, Abuja, Abuja, Nigeria','2345678','098765432','lewis@perthdesignateddrivers.com.au','2019-05-20','own'),(4,'Oliver1','Cann','21/06/1988','Nnamdi Azikiwe International Airport, Abuja, Abuja, Nigeria','2345678','098765432','lewis@perthdesignateddrivers.com.au','2019-05-20','own'),(5,'Oliver2','Cann','21/06/1988','Nnamdi Azikiwe International Airport, Abuja, Abuja, Nigeria','2345678','098765432','lewis@perthdesignateddrivers.com.au','2019-05-20','own'),(6,'Oliver3','Cann','21/06/1988','Nnamdi Azikiwe International Airport, Abuja, Abuja, Nigeria','2345678','098765432','lewis@perthdesignateddrivers.com.au','2019-05-20','own'); /*!40000 ALTER TABLE `driver_onboard` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `driver_pin` -- DROP TABLE IF EXISTS `driver_pin`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `driver_pin` ( `id` int NOT NULL AUTO_INCREMENT, `driver_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `pin` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `driver_pin` -- LOCK TABLES `driver_pin` WRITE; /*!40000 ALTER TABLE `driver_pin` DISABLE KEYS */; INSERT INTO `driver_pin` (`id`, `driver_id`, `user_name`, `pin`, `created`) VALUES (1,'4754568646','lwscann@gmail.com','1fffeb2192215ea34ce0aab63650534a','2019-01-12 23:47:51'),(3,'5801125472','marg@ret.com','b59c67bf196a4758191e42f76670ceba','2019-01-13 15:20:02'),(4,'5130290088','perthdesignateddrivers@gmail.com','0332d694daab22e0e0eaf7a5e88433f9','2019-01-14 18:19:36'),(5,'4759752412','bemwarj_1984@hotmail.com','b052e2e0c0ad1b2d5036bd56e27d061c','2019-01-17 09:25:34'),(6,'5775528542','duppal7@gmail.com','4a213d37242bdcad8e7300e202e7caa4','2019-01-17 13:38:05'),(7,'4771301675','nadirechand@yahoo.com','4d8556695c262ab91ff51a943fdd6058','2019-01-17 13:40:35'),(8,'5097175590','dominicmahanya@yahoo.com','81dc9bdb52d04dc20036dbd8313ed055','2019-01-17 18:38:45'),(9,'6262100982','louiwilson@gmail.com','f4f1f13c8289ac1b1ee0ff176b56fc60','2019-01-18 11:48:50'),(10,'6140709576','dajenks67@gmail.com','fd45c64e026040dbcb83395829d2aea5','2019-01-20 17:10:10'),(11,'4765717643','terrazo@iinet.net.au','8336041a6899d0bce657dcd29409cf7e','2019-02-11 20:17:58'); /*!40000 ALTER TABLE `driver_pin` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `drivers` -- DROP TABLE IF EXISTS `drivers`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `drivers` ( `id` int NOT NULL AUTO_INCREMENT, `spat_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `registration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=38 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `drivers` -- LOCK TABLES `drivers` WRITE; /*!40000 ALTER TABLE `drivers` DISABLE KEYS */; INSERT INTO `drivers` (`id`, `spat_id`, `name`, `phone`, `registration`) VALUES (1,'6298963757','John Doyle','+19498805325',''),(2,'6306159692','Tajah','+19806777716',''),(3,'6306287388','Yolanda Haggins','+19802140529',''),(4,'6306292008','Yaphette Mays','+17047635061',''),(5,'6306292503','Patricia Huff','+17044490224',''),(6,'6306292960','Paris Williams','+19803084413',''),(7,'6306295940','Pamela Mays','+17047378761',''),(8,'6306296424','Monica Nail','+17045629755',''),(9,'6306297532','Lalo Bossi','+19806212992',''),(10,'6306299060','Jaylynstreeter0325','+17047134664',''),(11,'6307742963','Test','+17049499203',''),(12,'6310773001','Sami Khoury ','+19724394349',''),(13,'6310773318','Agenmcky','+13472823216',''),(14,'6311380325','Tajah','+16785708117',''),(15,'6311420173','Jerry Pollock ','+19104084770',''),(16,'6311867079','Kevin Smith','+17045248955',''),(17,'6312694407','Dorothy Robinson','+13144581045',''),(18,'6312697204','Joff Philossaint','+13056806786',''),(19,'6312700784','David Celestin','+15615027708',''),(20,'6312701992','Jeff Marley Jacques','+17865769047',''),(21,'6312703009','Estoinio Dolbrun','+17865238064',''),(22,'6312703881','Kliford Flovil','+17863665637',''),(23,'6312706836','Amos Charles','+19543488506',''),(24,'6312763677','Diondre Lewis','+13238068845',''),(25,'6312846604','Jonathan Allison ','',''),(26,'6312926534','Maurice Shareef','+17045348339',''),(27,'6312933248','Jeanna Martin','+17046205803',''),(28,'6314002542','John Expedition 7 seats','+19496825626',''),(29,'6320935179','Thomas Butler','+19802575656',''),(30,'6323873557','Black 2019 Escalade XL 6 Seats','+19498805325',''),(31,'6327721738','Naia ','+13472933265',''),(32,'6327722422','Sheldon Lunan','+14044380257',''),(33,'6332671574','Ken J. Martin','+14045901294',''),(34,'6333487430','Brett','+19492404179',''),(35,'6334966967','Naia','+13472933265',''),(36,'6336276059','Dietta Thompson','+17047131539',''),(37,'6336276721','Tammy Rorie','+17047125808',''); /*!40000 ALTER TABLE `drivers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `facebook_id` -- DROP TABLE IF EXISTS `facebook_id`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `facebook_id` ( `id` int NOT NULL AUTO_INCREMENT, `cid` int NOT NULL, `facebook_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_created` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `facebook_id` -- LOCK TABLES `facebook_id` WRITE; /*!40000 ALTER TABLE `facebook_id` DISABLE KEYS */; INSERT INTO `facebook_id` (`id`, `cid`, `facebook_id`, `date_created`) VALUES (1,3,'10161794941690249','2019-03-13'); /*!40000 ALTER TABLE `facebook_id` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `flag_val` -- DROP TABLE IF EXISTS `flag_val`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `flag_val` ( `id` int NOT NULL AUTO_INCREMENT, `flag` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `flag_val` -- LOCK TABLES `flag_val` WRITE; /*!40000 ALTER TABLE `flag_val` DISABLE KEYS */; INSERT INTO `flag_val` (`id`, `flag`) VALUES (1,1); /*!40000 ALTER TABLE `flag_val` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `forget_otp` -- DROP TABLE IF EXISTS `forget_otp`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `forget_otp` ( `id` int NOT NULL AUTO_INCREMENT, `email` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `otp` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `created` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `forget_otp` -- LOCK TABLES `forget_otp` WRITE; /*!40000 ALTER TABLE `forget_otp` DISABLE KEYS */; /*!40000 ALTER TABLE `forget_otp` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `google_id` -- DROP TABLE IF EXISTS `google_id`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `google_id` ( `id` int NOT NULL AUTO_INCREMENT, `cid` int NOT NULL, `google_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_created` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `google_id` -- LOCK TABLES `google_id` WRITE; /*!40000 ALTER TABLE `google_id` DISABLE KEYS */; INSERT INTO `google_id` (`id`, `cid`, `google_id`, `date_created`) VALUES (1,5,'113949080979846979150','2019-03-14'),(2,6,'110319908553155559001','2019-03-24'); /*!40000 ALTER TABLE `google_id` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `holding_link` -- DROP TABLE IF EXISTS `holding_link`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `holding_link` ( `id` int NOT NULL AUTO_INCREMENT, `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `holding_link` -- LOCK TABLES `holding_link` WRITE; /*!40000 ALTER TABLE `holding_link` DISABLE KEYS */; INSERT INTO `holding_link` (`id`, `link`) VALUES (1,'http://desidrivers.com.au/app/placehold.html'); /*!40000 ALTER TABLE `holding_link` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `invoices` -- DROP TABLE IF EXISTS `invoices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `invoices` ( `id` int NOT NULL AUTO_INCREMENT, `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tokenid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `invname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `tollAmount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `transactionid` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_created` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `type` varchar(3) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `paidby` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `invdesc` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `driver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `invoices` -- LOCK TABLES `invoices` WRITE; /*!40000 ALTER TABLE `invoices` DISABLE KEYS */; /*!40000 ALTER TABLE `invoices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `new_lang_lat` -- DROP TABLE IF EXISTS `new_lang_lat`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `new_lang_lat` ( `id` int NOT NULL AUTO_INCREMENT, `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `lat_1st` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `lang_1st` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `lat_2nd` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `lang_2nd` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `new_lang_lat` -- LOCK TABLES `new_lang_lat` WRITE; /*!40000 ALTER TABLE `new_lang_lat` DISABLE KEYS */; INSERT INTO `new_lang_lat` (`id`, `city`, `lat_1st`, `lang_1st`, `lat_2nd`, `lang_2nd`) VALUES (1,'lagos','6.319655','3.051367','6.818184','3.537589'); /*!40000 ALTER TABLE `new_lang_lat` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `onboard_events` -- DROP TABLE IF EXISTS `onboard_events`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `onboard_events` ( `id` int NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `information` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `start_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `end_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_added` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `onboard_events` -- LOCK TABLES `onboard_events` WRITE; /*!40000 ALTER TABLE `onboard_events` DISABLE KEYS */; INSERT INTO `onboard_events` (`id`, `title`, `information`, `url`, `class`, `start_time`, `end_time`, `date_added`) VALUES (1,'Onboarding Session 3rd June 10am-1pm','Morning onboarding session','register-driver.php','event-important','1559552400000','1559563200000','2019-05-17'),(2,'Onboarding Session 3rd June 2pm - 5pm','Afternoon onboarding session','register-driver.php','event-important','1559566800000','1559577600000','2019-05-18'); /*!40000 ALTER TABLE `onboard_events` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `onboard_register` -- DROP TABLE IF EXISTS `onboard_register`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `onboard_register` ( `id` int NOT NULL AUTO_INCREMENT, `event_id` int NOT NULL, `driver_id` int NOT NULL, `date_signed_up` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `onboard_register` -- LOCK TABLES `onboard_register` WRITE; /*!40000 ALTER TABLE `onboard_register` DISABLE KEYS */; INSERT INTO `onboard_register` (`id`, `event_id`, `driver_id`, `date_signed_up`) VALUES (1,2,1,'2019-05-18 16:22:26'),(10,2,5,'2019-05-20 18:24:15'),(4,1,1,'2019-05-20 15:19:38'),(6,1,2,'2019-05-20 18:10:51'),(7,1,3,'2019-05-20 18:11:35'),(8,1,4,'2019-05-20 18:16:03'); /*!40000 ALTER TABLE `onboard_register` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_reset` -- DROP TABLE IF EXISTS `password_reset`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `password_reset` ( `id` int NOT NULL AUTO_INCREMENT, `customer_id` int NOT NULL, `expiry` int NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_reset` -- LOCK TABLES `password_reset` WRITE; /*!40000 ALTER TABLE `password_reset` DISABLE KEYS */; INSERT INTO `password_reset` (`id`, `customer_id`, `expiry`) VALUES (1,6,1553392386),(2,6,1553392389),(3,6,1553392392),(4,6,1553392700),(5,6,1553392703),(6,6,1557154335),(7,6,1557154337),(8,6,1557154338),(9,6,1557154340),(10,6,1557154341),(11,6,1557154535),(12,10,1560097987),(13,10,1560097993),(14,10,1560097996),(15,10,1560097998),(16,10,1560098002),(17,11,1560781618); /*!40000 ALTER TABLE `password_reset` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `prices` -- DROP TABLE IF EXISTS `prices`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `prices` ( `id` int NOT NULL AUTO_INCREMENT, `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `base` double NOT NULL, `km` double NOT NULL, `large_km` double DEFAULT NULL, `time` double NOT NULL, `min` double DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `prices` -- LOCK TABLES `prices` WRITE; /*!40000 ALTER TABLE `prices` DISABLE KEYS */; INSERT INTO `prices` (`id`, `city`, `base`, `km`, `large_km`, `time`, `min`) VALUES (1,'magicbike',0,1.5,NULL,15,NULL),(2,'magicride',0,4,NULL,60,NULL),(3,'magicplus',0,4.25,NULL,60,NULL); /*!40000 ALTER TABLE `prices` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `promo_codes` -- DROP TABLE IF EXISTS `promo_codes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `promo_codes` ( `id` int NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `code` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` float NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `promo_codes` -- LOCK TABLES `promo_codes` WRITE; /*!40000 ALTER TABLE `promo_codes` DISABLE KEYS */; INSERT INTO `promo_codes` (`id`, `name`, `code`, `value`) VALUES (1,'Facebook Oct 2018 10%','FAC108',0.9),(2,'Internat app promo','WEB518',0.9),(3,'MailChimp Feb','MCF101',0.8),(4,'Web','WEB118',0.9); /*!40000 ALTER TABLE `promo_codes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `promocodes` -- DROP TABLE IF EXISTS `promocodes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `promocodes` ( `id` int NOT NULL AUTO_INCREMENT, `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `is_active` int NOT NULL, `date_added` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `promocodes` -- LOCK TABLES `promocodes` WRITE; /*!40000 ALTER TABLE `promocodes` DISABLE KEYS */; INSERT INTO `promocodes` (`id`, `code`, `value_type`, `value`, `is_active`, `date_added`) VALUES (1,'CIAA19','%','20',1,'2019-02-23'),(2,'NBAA19','-','10',1,'2019-02-23'),(3,'FREE19','%','100',1,'2019-02-25'),(4,'ScoopM','%','100',1,'2019-02-27'),(5,'MINIM5','>','5',1,'2019-03-01'); /*!40000 ALTER TABLE `promocodes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `referal_claim` -- DROP TABLE IF EXISTS `referal_claim`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `referal_claim` ( `id` int NOT NULL AUTO_INCREMENT, `customer_id` int NOT NULL, `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `referrals_generated` int NOT NULL, `date_last_generated` date NOT NULL, `referrals_claimed` int NOT NULL, `reference_claimed` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_last_claimed` date DEFAULT NULL, `value` int NOT NULL DEFAULT '10', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `referal_claim` -- LOCK TABLES `referal_claim` WRITE; /*!40000 ALTER TABLE `referal_claim` DISABLE KEYS */; /*!40000 ALTER TABLE `referal_claim` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `referral_use` -- DROP TABLE IF EXISTS `referral_use`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `referral_use` ( `id` int NOT NULL AUTO_INCREMENT, `referer_id` int NOT NULL, `refered_id` int NOT NULL, `code` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` float NOT NULL, `reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `date_used` date DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `referral_use` -- LOCK TABLES `referral_use` WRITE; /*!40000 ALTER TABLE `referral_use` DISABLE KEYS */; INSERT INTO `referral_use` (`id`, `referer_id`, `refered_id`, `code`, `value`, `reference`, `date_used`) VALUES (1,95,179,'RFFBM5pK',0.8,'',NULL),(2,95,180,'RFFBM5pK',0.8,'',NULL),(3,95,181,'RFFBM5pK',0.8,'',NULL),(4,95,182,'RFFBM5pK',0.8,'',NULL),(5,278,332,'RFY8jDOn',0.8,'',NULL),(6,210,377,'RFenMA@2',0.8,'',NULL),(7,460,483,'RFBa43MG',0.8,'',NULL),(8,306,535,'RFqo0z8K',0.8,'',NULL),(9,557,558,'RFGC1t@h',0.8,'',NULL),(10,637,638,'RFSRHXUP',0.8,'',NULL),(11,408,722,'RFK7guq8',0.8,'',NULL); /*!40000 ALTER TABLE `referral_use` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `referrals` -- DROP TABLE IF EXISTS `referrals`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `referrals` ( `id` int NOT NULL AUTO_INCREMENT, `customer_id` int NOT NULL, `code` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL, `value` float NOT NULL, `date_created` date NOT NULL, `date_modified` date NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `referrals` -- LOCK TABLES `referrals` WRITE; /*!40000 ALTER TABLE `referrals` DISABLE KEYS */; INSERT INTO `referrals` (`id`, `customer_id`, `code`, `value`, `date_created`, `date_modified`) VALUES (1,3,'RFLK2EpI',0.8,'2019-03-08','2019-03-08'),(2,6,'RF7uJHbM',0.8,'2019-03-29','2019-03-29'),(3,10,'RFnIoGK5',0.8,'2019-05-12','2019-05-12'),(4,13,'RFeiaq8A',0.8,'2019-06-10','2019-06-10'); /*!40000 ALTER TABLE `referrals` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'desid573_magic' -- -- -- Dumping routines for database 'desid573_magic' -- /*!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 on 2026-08-23 1:39:03