-- MySQL dump 10.13  Distrib 5.7.42, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: gojek_transport
-- ------------------------------------------------------
-- Server version	5.7.42-0ubuntu0.18.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ride_categories`
--

DROP TABLE IF EXISTS `ride_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_categories` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `ride_category_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ride_category_status` tinyint(4) NOT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `ride_categories`
--

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

--
-- Table structure for table `ride_cities`
--

DROP TABLE IF EXISTS `ride_cities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_cities` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int(10) unsigned NOT NULL,
  `city_id` int(10) unsigned NOT NULL,
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ride_category_id` int(10) unsigned DEFAULT NULL,
  `vehicle_service_id` int(10) unsigned DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `comission` decimal(10,2) NOT NULL DEFAULT '0.00',
  `fleet_comission` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `surge` decimal(10,2) NOT NULL DEFAULT '0.00',
  `night_charges` decimal(10,2) NOT NULL DEFAULT '0.00',
  `driver_beta_amount` decimal(10,2) NOT NULL DEFAULT '0.00',
  `waiting_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `peak_percentage` decimal(10,2) NOT NULL DEFAULT '0.00',
  `commission` decimal(10,2) DEFAULT NULL,
  `fleet_commission` decimal(10,2) DEFAULT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ride_cities_ride_category_id_foreign` (`ride_category_id`),
  CONSTRAINT `ride_cities_ride_category_id_foreign` FOREIGN KEY (`ride_category_id`) REFERENCES `ride_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ride_cities`
--

LOCK TABLES `ride_cities` WRITE;
/*!40000 ALTER TABLE `ride_cities` DISABLE KEYS */;
INSERT INTO `ride_cities` VALUES (1,101,3659,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,5963,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,13,6571,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,18,7291,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,38,10449,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,44,11182,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,75,17726,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,102,21497,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,103,21776,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,109,25084,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,111,25174,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(12,113,25506,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,132,26962,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,142,28173,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,160,30697,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,181,36746,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,196,37570,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,202,38074,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,207,38956,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,213,39618,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(21,229,41406,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(22,230,42234,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(23,231,48294,'TRANSPORT',NULL,NULL,1,1.00,1.00,1.00,0.00,1.00,0.00,0.00,0.00,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `ride_cities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ride_city_prices`
--

DROP TABLE IF EXISTS `ride_city_prices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_city_prices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `geofence_id` int(10) unsigned DEFAULT NULL,
  `city_id` int(10) unsigned NOT NULL,
  `vehicle_service_id` int(10) unsigned DEFAULT NULL,
  `ride_category_id` int(10) unsigned DEFAULT NULL,
  `ride_delivery_vehicle_id` int(10) unsigned NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `calculator` enum('DISTANCE','MIN','HOUR','DISTANCEMIN','DISTANCEHOUR') COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_oneway` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1-oneway enabled',
  `is_roundtrip` tinyint(4) NOT NULL DEFAULT '0' COMMENT '1-roundtrip enabled',
  `fixed` decimal(10,2) NOT NULL DEFAULT '0.00',
  `price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `minute` decimal(10,2) NOT NULL DEFAULT '0.00',
  `hour` decimal(10,2) NOT NULL DEFAULT '0.00',
  `distance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `package_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `base_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `base_unit` decimal(10,2) NOT NULL DEFAULT '0.00',
  `base_hour` decimal(10,2) NOT NULL DEFAULT '0.00',
  `per_unit_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `per_minute_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `per_km_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `per_hour` decimal(10,2) NOT NULL DEFAULT '0.00',
  `per_hour_distance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `waiting_free_mins` decimal(10,2) NOT NULL DEFAULT '0.00',
  `waiting_min_charge` decimal(10,2) NOT NULL DEFAULT '0.00',
  `commission` decimal(10,2) NOT NULL DEFAULT '0.00',
  `fleet_commission` decimal(10,2) NOT NULL DEFAULT '0.00',
  `tax` decimal(10,2) NOT NULL DEFAULT '0.00',
  `peak_commission` decimal(10,2) NOT NULL DEFAULT '0.00',
  `waiting_commission` decimal(10,2) NOT NULL DEFAULT '0.00',
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `pricing_differs` tinyint(4) NOT NULL DEFAULT '0',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ride_city_prices_ride_category_id_foreign` (`ride_category_id`),
  CONSTRAINT `ride_city_prices_ride_category_id_foreign` FOREIGN KEY (`ride_category_id`) REFERENCES `ride_categories` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ride_city_prices`
--

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

--
-- Table structure for table `ride_delivery_vehicles`
--

DROP TABLE IF EXISTS `ride_delivery_vehicles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_delivery_vehicles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `ride_type_id` int(10) unsigned DEFAULT NULL,
  `vehicle_type` enum('RIDE','DELIVERY') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicle_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vehicle_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicle_marker` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `capacity` int(10) unsigned DEFAULT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT 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 `ride_delivery_vehicles`
--

LOCK TABLES `ride_delivery_vehicles` WRITE;
/*!40000 ALTER TABLE `ride_delivery_vehicles` DISABLE KEYS */;
INSERT INTO `ride_delivery_vehicles` VALUES (1,1,1,'RIDE','Sedan','https://goxdevwebsite.mi2.in/images/transport/sedan.png','https://goxdevwebsite.mi2.in/images/transport/sedan_marker.png',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,1,1,'RIDE','Premium','https://goxdevwebsite.mi2.in/images/transport/premium.png','https://goxdevwebsite.mi2.in/images/transport/grey-car_marker.png',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,1,1,'RIDE','Hatchback','https://goxdevwebsite.mi2.in/images/transport/hatchback.png','https://goxdevwebsite.mi2.in/images/transport/grey-car_marker.png',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,1,1,'RIDE','Minivan','https://goxdevwebsite.mi2.in/images/transport/business.png','https://goxdevwebsite.mi2.in/images/transport/grey-car_marker.png',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,1,2,'RIDE','Sports Bike','https://goxdevwebsite.mi2.in/images/transport/sports_bike.png','https://goxdevwebsite.mi2.in/images/transport/grey-car_marker.png',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,1,2,'RIDE','Scooter','https://goxdevwebsite.mi2.in/images/transport/scooter.png','https://goxdevwebsite.mi2.in/images/transport/grey-car_marker.png',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,1,2,'RIDE','Cruiser','https://goxdevwebsite.mi2.in/images/transport/cruiser.png','https://goxdevwebsite.mi2.in/images/transport/grey-car_marker.png',NULL,1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
/*!40000 ALTER TABLE `ride_delivery_vehicles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ride_lost_items`
--

DROP TABLE IF EXISTS `ride_lost_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_lost_items` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ride_request_id` int(11) NOT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `user_id` int(11) NOT NULL,
  `lost_item_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments_by` enum('user','admin') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('open','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `is_admin` tinyint(4) NOT NULL DEFAULT '0',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `ride_lost_items`
--

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

--
-- Table structure for table `ride_peak_prices`
--

DROP TABLE IF EXISTS `ride_peak_prices`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_peak_prices` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ride_city_price_id` int(10) unsigned NOT NULL,
  `ride_delivery_id` int(10) unsigned NOT NULL,
  `peak_hour_id` int(10) unsigned NOT NULL,
  `peak_price` double(10,2) DEFAULT '0.00',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `ride_peak_prices`
--

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

--
-- Table structure for table `ride_request_disputes`
--

DROP TABLE IF EXISTS `ride_request_disputes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_request_disputes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `ride_request_id` int(11) NOT NULL,
  `dispute_type` enum('user','provider') COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int(11) NOT NULL,
  `provider_id` int(11) NOT NULL,
  `dispute_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `dispute_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `refund_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `comments_by` enum('user','admin') COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('open','closed') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'open',
  `is_admin` tinyint(4) NOT NULL DEFAULT '0',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `ride_request_disputes`
--

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

--
-- Table structure for table `ride_request_payments`
--

DROP TABLE IF EXISTS `ride_request_payments`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_request_payments` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ride_request_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `provider_id` int(10) unsigned NOT NULL,
  `fleet_id` int(10) unsigned DEFAULT NULL,
  `promocode_id` int(10) unsigned DEFAULT NULL,
  `payment_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fixed` double(10,2) NOT NULL DEFAULT '0.00',
  `distance` double(10,2) NOT NULL DEFAULT '0.00',
  `minute` double(10,2) NOT NULL DEFAULT '0.00',
  `hour` double(10,2) NOT NULL DEFAULT '0.00',
  `commision` double(10,2) NOT NULL DEFAULT '0.00',
  `commision_percent` double(10,2) NOT NULL DEFAULT '0.00',
  `fleet` double(10,2) NOT NULL DEFAULT '0.00',
  `fleet_percent` double(10,2) NOT NULL DEFAULT '0.00',
  `discount` double(10,2) NOT NULL DEFAULT '0.00',
  `discount_percent` double(10,2) NOT NULL DEFAULT '0.00',
  `tax` double(10,2) NOT NULL DEFAULT '0.00',
  `tax_percent` double(10,2) NOT NULL DEFAULT '0.00',
  `wallet` double(10,2) NOT NULL DEFAULT '0.00',
  `is_partial` tinyint(4) DEFAULT NULL,
  `cash` double(10,2) NOT NULL DEFAULT '0.00',
  `card` double(10,2) NOT NULL DEFAULT '0.00',
  `peak_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `peak_comm_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `total_waiting_time` int(11) NOT NULL DEFAULT '0',
  `waiting_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `waiting_comm_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `tips` double(10,2) NOT NULL DEFAULT '0.00',
  `toll_charge` double(10,2) NOT NULL DEFAULT '0.00',
  `round_of` double(10,2) NOT NULL DEFAULT '0.00',
  `geo_fencing_distance` decimal(10,2) NOT NULL DEFAULT '0.00',
  `geo_fencing_minutes` int(11) NOT NULL DEFAULT '0',
  `geo_fencing_total` double(10,2) NOT NULL DEFAULT '0.00',
  `driver_beta_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `night_fare_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `total` double(10,2) NOT NULL DEFAULT '0.00',
  `payable` double(10,2) NOT NULL DEFAULT '0.00',
  `provider_pay` double(10,2) NOT NULL DEFAULT '0.00',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ride_request_payments_ride_request_id_foreign` (`ride_request_id`),
  CONSTRAINT `ride_request_payments_ride_request_id_foreign` FOREIGN KEY (`ride_request_id`) REFERENCES `ride_requests` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ride_request_payments`
--

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

--
-- Table structure for table `ride_request_waiting_times`
--

DROP TABLE IF EXISTS `ride_request_waiting_times`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_request_waiting_times` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ride_request_id` int(11) NOT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `ended_at` timestamp NULL DEFAULT NULL,
  `waiting_mins` int(11) NOT NULL DEFAULT '0',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL 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 `ride_request_waiting_times`
--

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

--
-- Table structure for table `ride_requests`
--

DROP TABLE IF EXISTS `ride_requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_requests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicle_type` enum('RIDE','DELIVERY') COLLATE utf8mb4_unicode_ci NOT NULL,
  `finished_vehicle_type` enum('RIDE','DELIVERY','RENTAL','OUTSTATION','OUTSTATION-ROUNDTRIP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `booking_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `admin_service` enum('TRANSPORT','ORDER','SERVICE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int(10) unsigned DEFAULT NULL,
  `provider_id` int(10) unsigned DEFAULT NULL,
  `provider_vehicle_id` int(10) unsigned DEFAULT NULL,
  `provider_service_id` int(10) unsigned DEFAULT NULL,
  `ride_type_id` int(10) unsigned DEFAULT NULL,
  `geofence_id` int(10) unsigned DEFAULT NULL,
  `rental_package_id` int(10) unsigned DEFAULT NULL,
  `ride_delivery_id` int(10) unsigned NOT NULL,
  `city_id` int(10) unsigned DEFAULT NULL,
  `country_id` int(10) unsigned DEFAULT NULL,
  `promocode_id` int(10) unsigned DEFAULT NULL,
  `company_id` int(10) unsigned NOT NULL,
  `status` enum('SEARCHING','CANCELLED','ACCEPTED','STARTED','ARRIVED','PICKEDUP','DROPPED','COMPLETED','SCHEDULED') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cancelled_by` enum('NONE','USER','PROVIDER') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cancel_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `paid` tinyint(4) NOT NULL DEFAULT '0',
  `is_track` enum('YES','NO') COLLATE utf8mb4_unicode_ci NOT NULL,
  `calculator` enum('DISTANCE','MIN','HOUR','DISTANCEMIN','DISTANCEHOUR','RENTAL','OUTSTATION','OUTSTATION-ROUNDTRIP') COLLATE utf8mb4_unicode_ci NOT NULL,
  `someone` tinyint(4) NOT NULL DEFAULT '0',
  `distance` double(10,2) DEFAULT NULL,
  `someone_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `someone_mobile` double DEFAULT NULL,
  `location_points` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `timezone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `someone_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `travel_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `s_latitude` double(15,8) NOT NULL,
  `s_longitude` double(15,8) NOT NULL,
  `d_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `d_latitude` double(15,8) NOT NULL,
  `d_longitude` double(15,8) NOT NULL,
  `track_distance` double(10,2) NOT NULL,
  `is_drop_location` tinyint(4) NOT NULL DEFAULT '1',
  `destination_log` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `unit` enum('KMS','MILES') COLLATE utf8mb4_unicode_ci NOT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `track_latitude` double(15,8) NOT NULL,
  `track_longitude` double(15,8) NOT NULL,
  `otp` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `assigned_at` timestamp NULL DEFAULT NULL,
  `schedule_at` timestamp NULL DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `finished_at` timestamp NULL DEFAULT NULL,
  `return_date` timestamp NULL DEFAULT NULL,
  `is_scheduled` enum('YES','NO') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NO',
  `request_type` enum('AUTO','MANUAL') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'AUTO',
  `peak_hour_id` int(10) unsigned DEFAULT NULL,
  `user_rated` tinyint(4) NOT NULL DEFAULT '0',
  `provider_rated` tinyint(4) NOT NULL DEFAULT '0',
  `use_wallet` tinyint(4) NOT NULL DEFAULT '0',
  `surge` tinyint(4) DEFAULT '0',
  `route_key` longtext COLLATE utf8mb4_unicode_ci,
  `admin_id` int(10) unsigned DEFAULT NULL,
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `ride_requests`
--

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

--
-- Table structure for table `ride_types`
--

DROP TABLE IF EXISTS `ride_types`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ride_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `company_id` int(10) unsigned NOT NULL,
  `ride_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT '1',
  `created_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(10) unsigned DEFAULT NULL,
  `modified_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `modified_by` int(10) unsigned DEFAULT NULL,
  `deleted_type` enum('ADMIN','USER','PROVIDER','SHOP') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_by` int(10) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL 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 `ride_types`
--

LOCK TABLES `ride_types` WRITE;
/*!40000 ALTER TABLE `ride_types` DISABLE KEYS */;
INSERT INTO `ride_types` VALUES (1,1,'Taxi Ride',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:48','2020-11-18 06:07:48',NULL),(2,1,'Moto Ride',1,NULL,NULL,NULL,NULL,NULL,NULL,'2020-11-18 06:07:48','2020-11-18 06:07:48',NULL);
/*!40000 ALTER TABLE `ride_types` ENABLE KEYS */;
UNLOCK TABLES;
/*!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 2023-09-04 14:55:40
