FM / cpmove_failed_mysql

/home/desid573/cpmove_failed_mysql_dbs.1787413258/

/home/desid573/cpmove_failed_mysql_dbs.1787413258

Name	Size	Mode	Actions
exmawjn/	-	0755	rm
hjfltmn/	-	0755	rm
iycwuxz/	-	0755	rm
pioxjd1/	-	0755	rm
desid573_1410_inventory.create	1532	0600	edit dl rm
desid573_1410_inventory.sql	13101	0644	edit dl rm
desid573_ample.create	1496	0600	edit dl rm
desid573_ample.sql	23499	0644	edit dl rm
desid573_angel_drivers.create	1528	0600	edit dl rm
desid573_angel_drivers.sql	46029	0644	edit dl rm
desid573_eway_codes.create	1516	0600	edit dl rm
desid573_eway_codes.sql	280056841	0644	edit dl rm
desid573_famcab_api.create	1516	0600	edit dl rm
desid573_famcab_api.sql	7099373	0644	edit dl rm
desid573_familycab.create	1512	0600	edit dl rm
desid573_familycab.sql	32255236	0644	edit dl rm
desid573_gcdriver.create	1508	0600	edit dl rm
desid573_gcdriver.sql	33498	0644	edit dl rm
desid573_ims.create	1488	0600	edit dl rm
desid573_ims.sql	13928	0644	edit dl rm
desid573_inquiries.create	1512	0600	edit dl rm
desid573_inquiries.sql	5094749	0644	edit dl rm
desid573_magic.create	1496	0600	edit dl rm
desid573_magic.sql	85568	0644	edit dl rm
desid573_magic_site.create	1516	0600	edit dl rm
desid573_magic_site.sql	1442	0644	edit dl rm
desid573_new_pro_api.create	1520	0600	edit dl rm
desid573_new_pro_api.sql	2709995	0644	edit dl rm
desid573_oldvine.create	1504	0600	edit dl rm
desid573_oldvine.sql	18141	0644	edit dl rm
desid573_phewl.create	1496	0600	edit dl rm
desid573_phewl.sql	53985	0644	edit dl rm
desid573_tollster.create	1508	0600	edit dl rm
desid573_tollster.sql	1221097	0644	edit dl rm
desid573_wp38.create	1492	0600	edit dl rm
desid573_wp38.sql	912231	0644	edit dl rm
desid573_wp172.create	1496	0600	edit dl rm
desid573_wp172.sql	175912	0644	edit dl rm
desid573_wp255.create	1500	0600	edit dl rm
desid573_wp255.sql	314501	0644	edit dl rm
desid573_wp676.create	1500	0600	edit dl rm
desid573_wp676.sql	12067179	0644	edit dl rm
desid573_wp_0a5zc.create	1508	0600	edit dl rm
desid573_wp_0a5zc.sql	123538	0644	edit dl rm
desid573_wp_new.create	1500	0600	edit dl rm
desid573_wp_new.sql	7810728	0644	edit dl rm
openfileslimit	5	0600	edit dl rm
wp-cron-darb.php	1659	0644	edit dl rm

Edit: /home/desid573/cpmove_failed_mysql_dbs.1787413258/desid573_angel_drivers.sql (46029B)

-- MySQL dump 10.13  Distrib 8.4.9, for Linux (x86_64)
--
-- Host: localhost    Database: desid573_angel_drivers
-- ------------------------------------------------------
-- 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_angel_drivers`
--

--
-- 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,
  `instructions` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `promo_code` 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,
  `token` 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_stripe` 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=1184 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`, `instructions`, `promo_code`, `spatula_id`, `spatula_link`, `reference`, `type`, `quote`, `quote_km`, `quote_time`, `token`, `xero_inv`, `payment_stripe`, `status`, `driver`) VALUES (1171,659,'','2019-12-03','09:30:00','15 Burns Road, Kalamunda WA, Australia','-31.9637741','116.05563430000007','Maida Vale WA, Australia','-31.9530067','116.02417390000005','','','','','15753360994994','','51.00','4','6','','','','',''),(1172,659,'lwscann@gmail.com','2019-12-03','09:30:00','15 Burns Road, Kalamunda WA, Australia','-31.9637741','116.05563430000007','Maida Vale WA, Australia','-31.9530067','116.02417390000005','','','','','15753360994994','','51.00','4','6','','','','',''),(1173,659,'lwscann@gmail.com','2019-12-10','01:00:00','Perth WA, Australia','-31.9505269','115.86045719999993','Doubleview WA, Australia','-31.8999114','115.78124939999998','fsfgafgfgsdfg','10%/BUCKETLISTBONDI','','','1575910036483','','73.00','12','16','','','','',''),(1174,659,'lwscann@gmail.com','2019-12-10','01:00:00','Perth WA, Australia','-31.9505269','115.86045719999993','Doubleview WA, Australia','-31.8999114','115.78124939999998','fsfgafgfgsdfg','10%/BUCKETLISTBONDI','','','1575910036483','','73.00','12','16','','','','',''),(1175,659,'lwscann@gmail.com','2019-12-10','01:00:00','Perth WA, Australia','-31.9505269','115.86045719999993','Doubleview WA, Australia','-31.8999114','115.78124939999998','fsfgafgfgsdfg','10%/BUCKETLISTBONDI','','','1575910036483','','73.00','12','16','','','','',''),(1176,659,'lwscann@gmail.com','2019-12-10','13:00:00','Perth WA, Australia','-31.9505269','115.86045719999993','Doubleview WA, Australia','-31.8999114','115.78124939999998','','','[','[','15759102373049','','73.00','12','16','','','','',''),(1177,659,'lwscann@gmail.com','2019-12-10','13:00:00','Perth WA, Australia','-31.9505269','115.86045719999993','Doubleview WA, Australia','-31.8999114','115.78124939999998','','','208298760683521','https://vrom.io/tcygEYhZA','15759102373049','','73.00','12','16','','','','dispatched','Lewis'),(1179,659,'lwscann@gmail.com','2020-03-07','21:00:00','Raffles Hotel, Canning Beach Road, Applecross WA, Australia','-32.01076','115.8515179','Doubleview WA, Australia','-31.8999114','115.7812494','','','332724856864769','https://vrom.io/o26AW_44l','15835425422035','','106.10','19','18','cus_GI06drzvhSNFsN','','','dispatched','Lewis'),(1180,659,'lwscann@gmail.com','2020-03-12','11:30:00','Kalamunda WA, Australia','-31.9755983','116.0565936','Doubleview WA, Australia','-31.8999114','115.7812494','','2000/WindsorCastleVICPromo','339937881800705','https://vrom.io/HEOggPyIO','15839833282859','','161.51','38','40','cus_GI06drzvhSNFsN','','','cancelled','Lewis'),(1181,659,'lwscann@gmail.com','2020-03-14','12:00:00','Olive Farm Wines, Great Northern Highway, Millendon WA, Australia','-31.8120504','116.0190673','cancelled','-31.8999114','115.7812494','','','342805127331841','https://vrom.io/8tdZyoYPc','15841582974086','','150.77','34','33','cus_GI06drzvhSNFsN','','','cancelled',''),(1182,659,'lwscann@gmail.com','2020-03-14','12:00:00','Olive Farm Wines, Great Northern Highway, Millendon WA, Australia','-31.8120504','116.0190673','cancelled','-31.8999114','115.7812494','','','342808008556545','https://vrom.io/CR5HDDyKL','15841582974086','','150.77','34','33','cus_GI06drzvhSNFsN','','','cancelled',''),(1183,659,'lwscann@gmail.com','2020-03-14','12:00:00','Olive Farm Wines, Great Northern Highway, Millendon WA, Australia','-31.8120504','116.0190673','cancelled','-31.8999114','115.7812494','','','342808858689537','https://vrom.io/TO1FDF3XI','15841582974086','','150.77','34','33','cus_GI06drzvhSNFsN','','','cancelled','');
/*!40000 ALTER TABLE `booking` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `calendar`
--

DROP TABLE IF EXISTS `calendar`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `calendar` (
  `date` date NOT NULL DEFAULT '0000-00-00',
  PRIMARY KEY (`date`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `calendar`
--

LOCK TABLES `calendar` WRITE;
/*!40000 ALTER TABLE `calendar` DISABLE KEYS */;
/*!40000 ALTER TABLE `calendar` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `conf_sms`
--

DROP TABLE IF EXISTS `conf_sms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `conf_sms` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `sent` tinyint(1) NOT NULL,
  `sent_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  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 `conf_sms`
--

LOCK TABLES `conf_sms` WRITE;
/*!40000 ALTER TABLE `conf_sms` DISABLE KEYS */;
INSERT INTO `conf_sms` (`id`, `ref`, `sent`, `sent_time`) VALUES (1,'15839833282858',1,'2020-03-12 03:34:53'),(2,'15839833282859',1,'2020-03-12 03:48:00');
/*!40000 ALTER TABLE `conf_sms` 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`),
  UNIQUE KEY `cid` (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 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 (1,659,'Doubleview WA, Australia','-31.8999114','115.7812494');
/*!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,
  `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`),
  UNIQUE KEY `cid` (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=625 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`, `access_token_value`, `status`, `created`, `modified`) VALUES (624,659,'cus_GI06drzvhSNFsN','','2019-12-03 12:22:53','2019-12-03 12:22:53');
/*!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=660 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 (659,'Lewis Cann','+61413774931','lwscann@gmail.com','','','',0,0,'2019-12-03 12:22:53','2019-12-03 12:22:53');
/*!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 */;
INSERT INTO `drivers` (`id`, `driver`, `driver_phone`) VALUES ('4754568646','Lewis','0413774931');
/*!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 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 */;
/*!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,
  `message` 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 `flag_val`
--

LOCK TABLES `flag_val` WRITE;
/*!40000 ALTER TABLE `flag_val` DISABLE KEYS */;
INSERT INTO `flag_val` (`id`, `flag`, `message`) VALUES (1,1,'HomeKey drivers are currently unavailable until tomorrow at 8am. Apologies for the inconvenience.');
/*!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 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 */;
/*!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,'https://bookings.perthdesignateddrivers.com.au/test_api/placehold.html');
/*!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 */;
INSERT INTO `homekey_hours` (`id`, `time_start`, `time_end`) VALUES (1,1600,2399);
/*!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 AUTO_INCREMENT=4 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 */;
INSERT INTO `homekey_lat_lng` (`id`, `array`) VALUES (1,'[[-31.86035,115.745], [-32.02627,115.74864], [-32.04125,115.73304], [-32.0561,115.72793], [-32.06366,115.7493], [-32.07763,115.75084], [-32.07743,115.76232], [-32.08132,115.77345], [-32.08152,115.78335], [-32.08657,115.79353], [-32.08969,115.81528], [-32.11745,115.83305], [-32.12198,115.85847], [-32.08489,115.86494], [-32.07819,115.8781], [-32.05432,115.90923], [-32.05255,115.93167], [-32.0362,115.95868], [-32.02386,115.9722], [-32.00385,115.97315], [-31.98711,115.98808], [-31.9638,116.01011], [-31.94079,116.0163], [-31.91602,116.01426], [-31.91193,115.9968], [-31.90173,115.99409], [-31.894,115.98748], [-31.88743,115.95753], [-31.85969,115.95478], [-31.86283,115.91907], [-31.86682,115.88848], [-31.8609,115.83625], [-31.8557,115.80205], [-31.85605,115.77676]]'),(2,'[[-31.88134,115.75221], [-31.98594,115.7529], [-32.06861,115.81453], [-32.06802,115.89195], [-32.00771,115.96019], [-31.8844,115.92267]]'),(3,'[[-31.70976, 115.71308],[-31.98594, 115.71445],[-32.11049, 115.74587],[-32.13085, 115.89744],[-32.04497, 116.01237],[-31.87263, 115.99911],[-31.76072, 115.9007]]');
/*!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 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 `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 AUTO_INCREMENT=2 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 */;
INSERT INTO `lead_time_mess` (`id`, `message`) VALUES (1,'Current lead times are approximately 20-30 mins');
/*!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 */;
INSERT INTO `lead_time_poly` (`zone`, `lead_time`) VALUES ('1','25-35 mins'),('2','30-45 mins'),('3','45-60 mins');
/*!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 (1,'a:6:{i:0;a:2:{i:0;d:-31.94968000000000074578565545380115509033203125;i:1;d:115.974680000000006430127541534602642059326171875;}i:1;a:2:{i:0;d:-31.944469999999999032525010989047586917877197265625;i:1;d:115.9616800000000012005330063402652740478515625;}i:2;a:2:{i:0;d:-31.93460999999999927467797533608973026275634765625;i:1;d:115.952799999999996316546457819640636444091796875;}i:3;a:2:{i:0;d:-31.92972999999999927922544884495437145233154296875;i:1;d:115.958719999999999572537490166723728179931640625;}i:4;a:2:{i:0;d:-31.933440000000000935642674448899924755096435546875;i:1;d:115.9721100000000006957634468562901020050048828125;}i:5;a:2:{i:0;d:-31.94297999999999859710442251525819301605224609375;i:1;d:115.979659999999995534381014294922351837158203125;}}','perth',1),(2,'a:4:{i:0;a:2:{i:0;d:-32.78777699999999839519659872166812419891357421875;i:1;d:115.5567389999999932115315459668636322021484375;}i:1;a:2:{i:0;d:-32.78777699999999839519659872166812419891357421875;i:1;d:116.5455089999999955807652440853416919708251953125;}i:2;a:2:{i:0;d:-31.159265999999998797420630580745637416839599609375;i:1;d:116.5455089999999955807652440853416919708251953125;}i:3;a:2:{i:0;d:-31.159265999999998797420630580745637416839599609375;i:1;d:115.5567389999999932115315459668636322021484375;}}','perth',0),(3,'a:4:{i:0;a:2:{i:0;d:-37.48835799999999807141648489050567150115966796875;i:1;d:145.599866999999989047864801250398159027099609375;}i:1;a:2:{i:0;d:-38.77911900000000144927980727516114711761474609375;i:1;d:145.66277700000000550062395632266998291015625;}i:2;a:2:{i:0;d:-38.36373400000000088994056568481028079986572265625;i:1;d:144.096588999999994484824128448963165283203125;}i:3;a:2:{i:0;d:-37.5108519999999998617568053305149078369140625;i:1;d:144.081869000000011737938621081411838531494140625;}}','melbourne',0),(4,'a:4:{i:0;a:2:{i:0;d:-37.64473799999999670262695872224867343902587890625;i:1;d:144.806608000000011315933079458773136138916015625;}i:1;a:2:{i:0;d:-37.64745599999999825513441464863717555999755859375;i:1;d:144.841753000000011297743185423314571380615234375;}i:2;a:2:{i:0;d:-37.68258399999999852525434107519686222076416015625;i:1;d:144.867378999999999678038875572383403778076171875;}i:3;a:2:{i:0;d:-37.68423200000000150566847878508269786834716796875;i:1;d:144.8387089999999943756847642362117767333984375;}}','melbourne',1),(5,'a:7:{i:0;a:2:{i:0;d:-33.93257299999999787587512400932610034942626953125;i:1;d:151.161661000000009380528354085981845855712890625;}i:1;a:2:{i:0;d:-33.92703000000000201907823793590068817138671875;i:1;d:151.169031999999987192495609633624553680419921875;}i:2;a:2:{i:0;d:-33.92703000000000201907823793590068817138671875;i:1;d:151.169031999999987192495609633624553680419921875;}i:3;a:2:{i:0;d:-33.9267830000000003565219230949878692626953125;i:1;d:151.183499000000011847077985294163227081298828125;}i:4;a:2:{i:0;d:-33.9426940000000030295268516056239604949951171875;i:1;d:151.193342999999998710336512885987758636474609375;}i:5;a:2:{i:0;d:-33.94873400000000174259184859693050384521484375;i:1;d:151.16842900000000327054294757544994354248046875;}i:6;a:2:{i:0;d:-33.9440900000000027603164198808372020721435546875;i:1;d:151.160673000000002730303094722330570220947265625;}}','sydney',1),(6,'a:4:{i:0;a:2:{i:0;d:-34.102451999999999543433659709990024566650390625;i:1;d:150.2033999999999878127709962427616119384765625;}i:1;a:2:{i:0;d:-34.102451999999999543433659709990024566650390625;i:1;d:151.41876800000000002910383045673370361328125;}i:2;a:2:{i:0;d:-33.560597999999998819475877098739147186279296875;i:1;d:151.41876800000000002910383045673370361328125;}i:3;a:2:{i:0;d:-33.560597999999998819475877098739147186279296875;i:1;d:150.2033999999999878127709962427616119384765625;}}','sydney',0),(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,
  `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`, `lat_1st`, `lang_1st`, `lat_2nd`, `lang_2nd`) VALUES (1,'-32.787777','115.556739','-31.159266','116.545509');
/*!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 AUTO_INCREMENT=3 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,10,1574311653),(2,10,1574311809);
/*!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,
  `base` double NOT NULL,
  `km_rate_1` double NOT NULL,
  `km_rate_2` double NOT NULL,
  `time` double 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 `prices`
--

LOCK TABLES `prices` WRITE;
/*!40000 ALTER TABLE `prices` DISABLE KEYS */;
INSERT INTO `prices` (`id`, `base`, `km_rate_1`, `km_rate_2`, `time`) VALUES (0,80,3,2.75,1);
/*!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 AUTO_INCREMENT=162 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 (26,169,'RF1Dpbvi',0.8,'2018-05-30','2018-05-30'),(27,269,'RFY2CA60',0.8,'2018-06-03','2018-06-03'),(28,62,'RFF01S7m',0.8,'2018-06-09','2018-06-09'),(29,273,'RFZec6kd',0.8,'2018-06-10','2018-06-10'),(30,276,'RF1qtl7N',0.8,'2018-06-11','2018-06-11'),(31,272,'RF539loz',0.8,'2018-06-12','2018-06-12'),(32,82,'RFif5hwj',0.8,'2018-06-17','2018-06-17'),(33,280,'RF6W7N4r',0.8,'2018-06-21','2018-06-21'),(34,281,'RFqMY0b6',0.8,'2018-06-21','2018-06-21'),(35,158,'RFBJWnem',0.8,'2018-07-03','2018-07-03'),(36,293,'RFrt4Cpd',0.8,'2018-07-12','2018-07-12'),(37,299,'RF9Y2y8M',0.8,'2018-07-21','2018-07-21'),(38,302,'RF3NZjyK',0.8,'2018-07-27','2018-07-27'),(39,160,'RF9tFr7z',0.8,'2018-07-28','2018-07-28'),(40,306,'RFp43r1t',0.8,'2018-08-11','2018-08-11'),(41,316,'RFN5YkfZ',0.8,'2018-08-18','2018-08-18'),(42,317,'RFrM0dLY',0.8,'2018-08-18','2018-08-18'),(43,321,'RFhx6Cc1',0.8,'2018-08-23','2018-08-23'),(44,324,'RFl1os9E',0.8,'2018-08-25','2018-08-25'),(45,331,'RFthibLr',0.8,'2018-09-02','2018-09-02'),(46,335,'RF65wf31',0.8,'2018-09-06','2018-09-06'),(47,337,'RFHArpyX',0.8,'2018-09-08','2018-09-08'),(48,146,'RFTEOs2n',0.8,'2018-09-12','2018-09-12'),(49,204,'RFkXrUsP',0.8,'2018-09-15','2018-09-15'),(50,346,'RFLtjfqM',0.8,'2018-09-22','2018-09-22'),(51,347,'RFXxw0Yq',0.8,'2018-09-22','2018-09-22'),(52,145,'RF3Qlg!a',0.8,'2018-09-23','2018-09-23'),(53,351,'RFotDfCO',0.8,'2018-09-26','2018-09-26'),(54,353,'RFjeB0qV',0.8,'2018-09-26','2018-09-26'),(55,48,'RF4@PnYl',0.8,'2018-09-26','2018-09-26'),(56,237,'RF@ScBbE',0.8,'2018-09-27','2018-09-27'),(57,354,'RF5r8ht!',0.8,'2018-09-28','2018-09-28'),(58,356,'RFYXe!P9',0.8,'2018-09-29','2018-09-29'),(59,358,'RF3pRCIJ',0.8,'2018-09-29','2018-09-29'),(60,84,'RFq@K34r',0.8,'2018-10-01','2018-10-01'),(61,366,'RFlyJHUB',0.8,'2018-10-09','2018-10-09'),(62,363,'RFcaXPuF',0.8,'2018-10-10','2018-10-10'),(63,368,'RF16wgX3',0.8,'2018-10-11','2018-10-11'),(64,343,'RFu41e5Q',0.8,'2018-10-11','2018-10-11'),(65,371,'RFmG3fCE',0.8,'2018-10-14','2018-10-14'),(66,373,'RFhMQbUN',0.8,'2018-10-18','2018-10-18'),(67,376,'RFyUnteI',0.8,'2018-10-20','2018-10-20'),(68,381,'RFSRTtoO',0.8,'2018-10-23','2018-10-23'),(69,382,'RFfwYgVI',0.8,'2018-10-25','2018-10-25'),(70,370,'RF8BkDJp',0.8,'2018-10-28','2018-10-28'),(71,384,'RF9PxZwK',0.8,'2018-10-30','2018-10-30'),(72,388,'RFnmwbqB',0.8,'2018-11-17','2018-11-17'),(73,385,'RF6zicWm',0.8,'2018-11-18','2018-11-18'),(74,253,'RFvPWOVa',0.8,'2018-11-24','2018-11-24'),(75,408,'RFuDFewG',0.8,'2018-12-19','2018-12-19'),(76,409,'RFH3Yblj',0.8,'2018-12-20','2018-12-20'),(77,410,'RFbvViUh',0.8,'2018-12-21','2018-12-21'),(78,411,'RFaEB3Yh',0.8,'2018-12-21','2018-12-21'),(79,412,'RFQciYuJ',0.8,'2018-12-21','2018-12-21'),(80,415,'RFiQcL81',0.8,'2018-12-21','2018-12-21'),(81,402,'RFj1PNEm',0.8,'2018-12-22','2018-12-22'),(82,419,'RFBbHC5V',0.8,'2018-12-22','2018-12-22'),(83,418,'RFPfGJuh',0.8,'2018-12-22','2018-12-22'),(84,420,'RF9mNH@A',0.8,'2018-12-23','2018-12-23'),(85,424,'RFmE9!ZU',0.8,'2018-12-23','2018-12-23'),(86,436,'RFnMhgHi',0.8,'2018-12-30','2018-12-30'),(87,441,'RFGq9hpU',0.8,'2018-12-31','2018-12-31'),(88,448,'RF4fmIO2',0.8,'2019-01-11','2019-01-11'),(89,449,'RFMin2@X',0.8,'2019-01-11','2019-01-11'),(90,454,'RFtv4KTX',0.8,'2019-01-15','2019-01-15'),(91,456,'RFHRkEJn',0.8,'2019-01-16','2019-01-16'),(92,457,'RFNUkZIv',0.8,'2019-01-17','2019-01-17'),(93,459,'RFxI1G!T',0.8,'2019-01-18','2019-01-18'),(94,464,'RF@DSwWs',0.8,'2019-01-26','2019-01-26'),(95,469,'RFNJWcun',0.8,'2019-01-28','2019-01-28'),(96,473,'RF5GviV3',0.8,'2019-02-07','2019-02-07'),(97,451,'RFeWTvNI',0.8,'2019-02-08','2019-02-08'),(98,249,'RFZMO7eK',0.8,'2019-02-10','2019-02-10'),(99,478,'RFQzS0wD',0.8,'2019-02-17','2019-02-17'),(100,460,'RFw0vECa',0.8,'2019-02-23','2019-02-23'),(101,488,'RF5!F0Lu',0.8,'2019-03-02','2019-03-02'),(102,489,'RF0DA3uQ',0.8,'2019-03-02','2019-03-02'),(103,487,'RF0TNwVz',0.8,'2019-03-02','2019-03-02'),(104,493,'RFIFU7u1',0.8,'2019-03-11','2019-03-11'),(105,494,'RFKGu2Bn',0.8,'2019-03-11','2019-03-11'),(106,496,'RFc1Ugjt',0.8,'2019-03-16','2019-03-16'),(107,60,'RFyYsZPT',0.8,'2019-03-22','2019-03-22'),(108,503,'RF8JW56Y',0.8,'2019-03-23','2019-03-23'),(109,123,'RFmwIzFb',0.8,'2019-03-29','2019-03-29'),(110,510,'RFi1gvZ0',0.8,'2019-04-06','2019-04-06'),(111,517,'RFsGtAeX',0.8,'2019-04-13','2019-04-13'),(112,509,'RF10GDhA',0.8,'2019-04-15','2019-04-15'),(113,508,'RFnTm0B8',0.8,'2019-04-20','2019-04-20'),(114,298,'RFt6dv4i',0.8,'2019-04-21','2019-04-21'),(115,191,'RFKJfN1m',0.8,'2019-04-21','2019-04-21'),(116,524,'RF6TEC1Z',0.8,'2019-04-21','2019-04-21'),(117,375,'RF!wSp5e',0.8,'2019-05-03','2019-05-03'),(118,534,'RFxNeyz6',0.8,'2019-05-04','2019-05-04'),(119,538,'RFctzITe',0.8,'2019-05-09','2019-05-09'),(120,540,'RF45En@Z',0.8,'2019-05-10','2019-05-10'),(121,311,'RF7guL5s',0.8,'2019-05-10','2019-05-10'),(122,546,'RFyJr@mY',0.8,'2019-05-19','2019-05-19'),(123,547,'RFOjVlcb',0.8,'2019-05-19','2019-05-19'),(124,224,'RFgwyFLP',0.8,'2019-05-25','2019-05-25'),(125,567,'RFiqZOwP',0.8,'2019-06-22','2019-06-22'),(126,568,'RFNIpB2G',0.8,'2019-06-27','2019-06-27'),(127,550,'RF!nWAdI',0.8,'2019-07-02','2019-07-02'),(128,572,'RFGa326i',0.8,'2019-07-03','2019-07-03'),(129,577,'RFlPMI1E',0.8,'2019-07-12','2019-07-12'),(130,438,'RF4Ck2ly',0.8,'2019-07-18','2019-07-18'),(131,581,'RFynW!gx',0.8,'2019-07-20','2019-07-20'),(132,583,'RFAm5YrJ',0.8,'2019-07-26','2019-07-26'),(133,584,'RFvBGrK4',0.8,'2019-07-27','2019-07-27'),(134,594,'RFvrGHia',0.8,'2019-08-22','2019-08-22'),(135,595,'RFwtjKO6',0.8,'2019-08-23','2019-08-23'),(136,476,'RFUS1Pmz',0.8,'2019-08-23','2019-08-23'),(137,600,'RFdbLaT7',0.8,'2019-08-31','2019-08-31'),(138,428,'RF7kHqaM',0.8,'2019-09-01','2019-09-01'),(139,602,'RFefGkB3',0.8,'2019-09-03','2019-09-03'),(140,529,'RF8VTjgI',0.8,'2019-09-05','2019-09-05'),(141,605,'RFLNXfaz',0.8,'2019-09-11','2019-09-11'),(142,607,'RFo2aX!A',0.8,'2019-09-14','2019-09-14'),(143,507,'RFSD1r8R',0.8,'2019-09-19','2019-09-19'),(144,612,'RFaAhtvJ',0.8,'2019-09-26','2019-09-26'),(145,613,'RFLCQa5z',0.8,'2019-09-28','2019-09-28'),(146,627,'RFoKYSfH',0.8,'2019-10-18','2019-10-18'),(147,633,'RFHqcGwv',0.8,'2019-10-26','2019-10-26'),(148,532,'RFh@asGd',0.8,'2019-10-26','2019-10-26'),(149,638,'RFSz9Vld',0.8,'2019-10-29','2019-10-29'),(150,639,'RFRp5dLQ',0.8,'2019-11-02','2019-11-02'),(151,352,'RFaZeIx3',0.8,'2019-11-05','2019-11-05'),(152,644,'RFSQIEvN',0.8,'2019-11-07','2019-11-07'),(153,645,'RFIvC2!q',0.8,'2019-11-08','2019-11-08'),(154,649,'RFUEGz3d',0.8,'2019-11-11','2019-11-11'),(155,196,'RF1O5znS',0.8,'2019-11-21','2019-11-21'),(156,319,'RFT43Fb1',0.8,'2019-11-22','2019-11-22'),(157,628,'RFOTkYU9',0.8,'2019-11-23','2019-11-23'),(158,480,'RFGfPMb8',0.8,'2019-11-23','2019-11-23'),(159,573,'RFJzpQ!x',0.8,'2019-11-23','2019-11-23'),(160,657,'RFcVCQoW',0.8,'2019-11-26','2019-11-26'),(161,658,'RFm5fP0R',0.8,'2019-12-02','2019-12-02');
/*!40000 ALTER TABLE `referrals` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping events for database 'desid573_angel_drivers'
--

--
-- Dumping routines for database 'desid573_angel_drivers'
--
/*!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:38:48

cmd: