/home/desid573/cpmove_failed_mysql_dbs.1787413258
Edit: /home/desid573/cpmove_failed_mysql_dbs.1787413258/desid573_gcdriver.sql (33498B)
-- MySQL dump 10.13 Distrib 8.4.9, for Linux (x86_64)
--
-- Host: localhost Database: desid573_gcdriver
-- ------------------------------------------------------
-- 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_gcdriver`
--
--
-- 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,
`book_pax` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`book_rf` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`book_ff` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`book_b` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`mins_to` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`luggage` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`flight_num` varchar(255) 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,
`type` varchar(2) 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,
`xero_inv` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`payment_eway` 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=8 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`, `book_pax`, `book_rf`, `book_ff`, `book_b`, `mins_to`, `luggage`, `flight_num`, `spatula_id`, `spatula_link`, `reference`, `type`, `quote`, `quote_km`, `quote_time`, `xero_inv`, `payment_eway`, `status`, `driver`) VALUES (1,1213,'','2019-09-23','08:30:00','','-28.1656448','153.50907400000006','','-27.9595695','153.3817795','1','0','0','0','','','N/A','','','1569197955299','GC','97.90','41','37','','','',''),(2,1214,'','2019-09-23','13:15:00','','-27.9595695','153.3817795','','-28.1656448','153.50907400000006','1','1','0','0','','','N/A','','','15692149472239','GC','102.60','44','38','','','',''),(3,1214,'','2019-09-23','13:15:00','','-27.9595695','153.3817795','','-28.1656448','153.50907400000006','1','1','0','0','','','N/A','','','15692149472239','GC','102.60','44','38','','','',''),(4,1214,'','2019-09-23','13:15:00','','-27.9595695','153.3817795','','-28.1656448','153.50907400000006','1','1','0','0','','','N/A','','','15692149472239','GC','102.60','44','38','','','',''),(5,1214,'','2019-09-23','13:15:00','','-27.9595695','153.3817795','','-28.1656448','153.50907400000006','1','1','0','0','','','N/A','','','15692149472239','GC','102.60','44','38','','','',''),(6,1215,'','2019-09-23','13:15:00','','-28.016667','153.39999999999998','','-28.1656448','153.50907400000006','3','1','0','0','','','N/A','','','15692151994805','GC','81.20','30','34','','','',''),(7,1215,'lwscann@gmail.com','2019-09-24','19:30:00','Gold Coast Airport (OOL), Eastern Avenue, Bilinga QLD, Australia','-28.1656448','153.50907400000006','Dreamworld, Dreamworld Parkway, Coomera QLD, Australia','-27.8635076','153.31525310000006','3','0','1','0','','gjhjkljb','N/A','','','15693119744339','GC','106.50','47','38','','10650','','');
/*!40000 ALTER TABLE `booking` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `booking_extras`
--
DROP TABLE IF EXISTS `booking_extras`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `booking_extras` (
`id` int NOT NULL AUTO_INCREMENT,
`bid` int NOT NULL,
`bris_meet` tinyint(1) NOT NULL,
`gc_meet` tinyint(1) NOT NULL,
`bris_minor` tinyint(1) NOT NULL,
`gc_minor` tinyint(1) NOT NULL,
`trailer` tinyint(1) NOT NULL,
`drink` tinyint(1) NOT NULL,
`cover` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `booking_extras`
--
LOCK TABLES `booking_extras` WRITE;
/*!40000 ALTER TABLE `booking_extras` DISABLE KEYS */;
/*!40000 ALTER TABLE `booking_extras` 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,
`no_pax` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`no_rf` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`no_ff` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
`no_b` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
PRIMARY KEY (`id`)
) ENGINE=InnoDB 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 */;
/*!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,
`square_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci 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=7 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`, `square_id`, `access_token_value`, `status`, `created`, `modified`) VALUES (3,1212,'KEDWRB962GXA51F471VVRDEE9G','','','2019-09-23 10:10:14','2019-09-23 10:10:14'),(4,1213,'GMHJQWYHF8RYZ4BQ2W13PEFPC0','ccof:S1WqiyxEkL8MtdWX4GB','','2019-09-23 10:14:02','2019-09-23 10:20:56'),(5,1214,'9VF378C3C8XC5DXAWK5JT0Q36W','ccof:o4g5SoKGB2kB7cPc3GB','','2019-09-23 15:03:18','2019-09-23 15:05:50'),(6,1215,'3AVKBXAH7GZ9Z83X1WJJDR4400','ccof:kwjyZSuVKiVN4IXK3GB','','2019-09-23 15:07:22','2019-09-24 18:00:29');
/*!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=1216 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 (1214,'Lewis Cann','+61400227505','','','','',0,0,'2019-09-23 15:03:18','2019-09-23 15:03:18'),(1213,'Mel Cann','+61421194346','','','','',0,0,'2019-09-23 10:14:02','2019-09-23 10:14:02'),(1212,'Mel Cann','+61421194346','','','','',0,0,'2019-09-23 10:10:14','2019-09-23 10:10:14'),(1215,'Lewis Cann','+61413774931','lwscann@gmail.com','','','',0,0,'2019-09-23 15:07:22','2019-09-23 15:07:22');
/*!40000 ALTER TABLE `customers` 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` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`driver` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`driver_phone` varchar(15) 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 `drivers`
--
LOCK TABLES `drivers` WRITE;
/*!40000 ALTER TABLE `drivers` DISABLE KEYS */;
/*!40000 ALTER TABLE `drivers` 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 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 */;
/*!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 `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 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 */;
/*!40000 ALTER TABLE `holding_link` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `homekey_hours`
--
DROP TABLE IF EXISTS `homekey_hours`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `homekey_hours` (
`id` int NOT NULL,
`time_start` int NOT NULL,
`time_end` int 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 `homekey_hours`
--
LOCK TABLES `homekey_hours` WRITE;
/*!40000 ALTER TABLE `homekey_hours` DISABLE KEYS */;
/*!40000 ALTER TABLE `homekey_hours` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `homekey_lat_lng`
--
DROP TABLE IF EXISTS `homekey_lat_lng`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `homekey_lat_lng` (
`id` int NOT NULL AUTO_INCREMENT,
`array` varchar(2000) 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 `homekey_lat_lng`
--
LOCK TABLES `homekey_lat_lng` WRITE;
/*!40000 ALTER TABLE `homekey_lat_lng` DISABLE KEYS */;
/*!40000 ALTER TABLE `homekey_lat_lng` 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 AUTO_INCREMENT=4 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 */;
INSERT INTO `invoices` (`id`, `reference`, `tokenid`, `invname`, `amount`, `tollAmount`, `email`, `transactionid`, `date_created`, `type`, `paidby`, `invdesc`, `driver`) VALUES (1,'15693119744339','','Lewis Cann','106.5','','','','2019-10-06 15:31:52','GC','token','GC Driver\r\nGold Coast Airport (OOL), Eastern Avenue, Bilinga QLD, Australia\r\nTO\r\nDreamworld, Dreamworld Parkway, Coomera QLD, Australia',''),(2,'15693119744339','','Lewis Cann','106.5','','','','2019-10-06 15:37:08','GC','token','GC Driver\r\nGold Coast Airport (OOL), Eastern Avenue, Bilinga QLD, Australia\r\nTO\r\nDreamworld, Dreamworld Parkway, Coomera QLD, Australia',''),(3,'15703405413750','','cash','39','','','','2019-10-06 15:42:40','GC','card','Pick Up\r\nTO\r\nDestination','');
/*!40000 ALTER TABLE `invoices` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `lead_time_mess`
--
DROP TABLE IF EXISTS `lead_time_mess`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_time_mess` (
`id` int NOT NULL AUTO_INCREMENT,
`message` varchar(200) 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 `lead_time_mess`
--
LOCK TABLES `lead_time_mess` WRITE;
/*!40000 ALTER TABLE `lead_time_mess` DISABLE KEYS */;
/*!40000 ALTER TABLE `lead_time_mess` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `lead_time_poly`
--
DROP TABLE IF EXISTS `lead_time_poly`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `lead_time_poly` (
`zone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`lead_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `lead_time_poly`
--
LOCK TABLES `lead_time_poly` WRITE;
/*!40000 ALTER TABLE `lead_time_poly` DISABLE KEYS */;
/*!40000 ALTER TABLE `lead_time_poly` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `locations`
--
DROP TABLE IF EXISTS `locations`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `locations` (
`id` int NOT NULL AUTO_INCREMENT,
`array` varchar(2555) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`airport` tinyint(1) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `locations`
--
LOCK TABLES `locations` WRITE;
/*!40000 ALTER TABLE `locations` DISABLE KEYS */;
INSERT INTO `locations` (`id`, `array`, `city`, `airport`) VALUES (7,'a:4:{i:0;a:2:{i:0;d:-28.33518000000000114368958747945725917816162109375;i:1;d:151.615935000000007448761607520282268524169921875;}i:1;a:2:{i:0;d:-28.33518000000000114368958747945725917816162109375;i:1;d:154.189780000000013160388334654271602630615234375;}i:2;a:2:{i:0;d:-26.248999999999998777866494492627680301666259765625;i:1;d:154.189780000000013160388334654271602630615234375;}i:3;a:2:{i:0;d:-26.248999999999998777866494492627680301666259765625;i:1;d:151.615935000000007448761607520282268524169921875;}}','queensland',0),(8,'a:4:{i:0;a:2:{i:0;d:-27.399432999999998372686604852788150310516357421875;i:1;d:153.096135000000003856257535517215728759765625;}i:1;a:2:{i:0;d:-27.377604999999999080273482832126319408416748046875;i:1;d:153.11461800000000721411197446286678314208984375;}i:2;a:2:{i:0;d:-27.38385699999999900455804890953004360198974609375;i:1;d:153.124875000000002955857780762016773223876953125;}i:3;a:2:{i:0;d:-27.41457700000000130557964439503848552703857421875;i:1;d:153.1063570000000026993802748620510101318359375;}}','queensland',1),(9,'a:4:{i:0;a:2:{i:0;d:-28.158353000000001742364474921487271785736083984375;i:1;d:153.50522399999999834108166396617889404296875;}i:1;a:2:{i:0;d:-28.166346000000000771024133427999913692474365234375;i:1;d:153.51568900000000894578988663852214813232421875;}i:2;a:2:{i:0;d:-28.17393799999999970395947457291185855865478515625;i:1;d:153.511041000000005851688911207020282745361328125;}i:3;a:2:{i:0;d:-28.15690000000000026147972675971686840057373046875;i:1;d:153.499742999999995163307175971567630767822265625;}}','queensland',1);
/*!40000 ALTER TABLE `locations` 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 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 */;
/*!40000 ALTER TABLE `new_lang_lat` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `pages`
--
DROP TABLE IF EXISTS `pages`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `pages` (
`id` int NOT NULL AUTO_INCREMENT,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`desc` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`is_delete` int NOT NULL DEFAULT '0',
`created` datetime NOT NULL,
`modified` 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 `pages`
--
LOCK TABLES `pages` WRITE;
/*!40000 ALTER TABLE `pages` DISABLE KEYS */;
/*!40000 ALTER TABLE `pages` 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 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 */;
/*!40000 ALTER TABLE `password_reset` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `payments`
--
DROP TABLE IF EXISTS `payments`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `payments` (
`id` int NOT NULL AUTO_INCREMENT,
`transaction_id` int NOT NULL,
`authorisation_code` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`customer_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`amount` decimal(10,2) DEFAULT NULL,
`token_id` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`created` datetime NOT NULL,
`modified` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `id` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `payments`
--
LOCK TABLES `payments` WRITE;
/*!40000 ALTER TABLE `payments` DISABLE KEYS */;
/*!40000 ALTER TABLE `payments` 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=3 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,'goldcoast',20,1,2,0.8,50),(2,'execride',30,2,2.3,1,60);
/*!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 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 */;
/*!40000 ALTER TABLE `promo_codes` 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 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 */;
/*!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 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 */;
/*!40000 ALTER TABLE `referrals` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `terminal_details`
--
DROP TABLE IF EXISTS `terminal_details`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `terminal_details` (
`id` int NOT NULL AUTO_INCREMENT,
`city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`buttonLabel` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `terminal_details`
--
LOCK TABLES `terminal_details` WRITE;
/*!40000 ALTER TABLE `terminal_details` DISABLE KEYS */;
INSERT INTO `terminal_details` (`id`, `city`, `name`, `buttonLabel`, `lat`, `long`) VALUES (10,'queensland','Brisbane International Airport','Bris T1','-27.403067','153.109019'),(11,'queensland','Brisbane Domestic Airport','Bris T2','-27.384630','153.119422'),(12,'queensland','Gold Coast Terminal 1','Gold Coast','-28.167067','153.513742');
/*!40000 ALTER TABLE `terminal_details` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `toll_estimates`
--
DROP TABLE IF EXISTS `toll_estimates`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `toll_estimates` (
`id` int NOT NULL AUTO_INCREMENT,
`reference` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`amount` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
`description` 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 `toll_estimates`
--
LOCK TABLES `toll_estimates` WRITE;
/*!40000 ALTER TABLE `toll_estimates` DISABLE KEYS */;
/*!40000 ALTER TABLE `toll_estimates` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Dumping events for database 'desid573_gcdriver'
--
--
-- Dumping routines for database 'desid573_gcdriver'
--
/*!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:00