--
-- Host: localhost    Database: Opa
-- ------------------------------------------------------


--
-- Table structure for table `account_password_resets`
--

CREATE TABLE `account_password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `account_password_resets_email_index` (`email`),
  KEY `account_password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `account_password_resets`
--


--
-- Table structure for table `accounts`
--

CREATE TABLE `accounts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `accounts_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `accounts`
--


--
-- Table structure for table `admin_wallet`
--

CREATE TABLE `admin_wallet` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `transaction_id` int NOT NULL,
  `transaction_alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_type` int DEFAULT NULL COMMENT '1-commission,2-userrecharge,3-tripdebit,4-providerrecharge,5-providersettle,6-fleetrecharge,7-fleetcommission,8-fleetsettle,9-taxcredit,10-discountdebit,11-discountrecharge,12-userreferral,13-providerreferral,14-peakcommission,15-waitingcommission,16-userdispute,17-providerdispute',
  `type` enum('C','D') COLLATE utf8_unicode_ci NOT NULL,
  `amount` double(15,8) NOT NULL DEFAULT '0.00000000',
  `open_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `close_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `payment_mode` enum('BRAINTREE','CARD','PAYPAL','PAYUMONEY','PAYTM') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `admin_wallet`
--


--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `picture` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `admins_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` VALUES (1,'Opa','opadelivery@gmail.com','9876779350','$2y$10$ptTenKVXrW9zotXt/bleCOa6IghQ4T5jsuVVa2GNMmgZebty7/VfC','admin/profile/6hCg1oDG9TNEMvglETa2kwfQmAnuSmXGaEzOw0CU.jpeg','en',NULL,'2021-09-07 10:11:29','2021-09-10 16:55:13'),(2,'Demo Dispatcher','dispatcher@demo.com',NULL,'$2y$10$GfcNCN3nmAMGZlyKUTFeZ.YxUWe3ZkTPWi/Lx9HUfNawZ9dXlOUKK',NULL,NULL,NULL,'2021-09-07 10:11:29','2021-09-07 10:11:29'),(3,'Demo Account','account@demo.com',NULL,'$2y$10$ZtODDK4EUBxvU1zDJ70n.eeZTG5d7VjQakcKFHvajNYmzU/b2.U0K',NULL,NULL,NULL,'2021-09-07 10:11:29','2021-09-07 10:11:29'),(4,'Demo Dispute','dispute@demo.com',NULL,'$2y$10$YOMyWbJWCIngeDSTj1wZv.QJXBhr6hESDdqmU9Oqq19HUVb9aP.xu',NULL,NULL,NULL,'2021-09-07 10:11:29','2021-09-07 10:11:29');

--
-- Table structure for table `cards`
--

CREATE TABLE `cards` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `last_four` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `card_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `brand` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_default` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `cards`
--


--
-- Table structure for table `chats`
--

CREATE TABLE `chats` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int NOT NULL,
  `user_id` int NOT NULL,
  `provider_id` int NOT NULL,
  `message` text COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('up','pu') COLLATE utf8_unicode_ci NOT NULL,
  `delivered` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `chats`
--


--
-- Table structure for table `custom_pushes`
--

CREATE TABLE `custom_pushes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `send_to` enum('ALL','USERS','PROVIDERS') COLLATE utf8_unicode_ci NOT NULL,
  `condition` enum('ACTIVE','LOCATION','RIDES','AMOUNT') COLLATE utf8_unicode_ci NOT NULL,
  `condition_data` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sent_to` int NOT NULL DEFAULT '0',
  `schedule_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `custom_pushes`
--


--
-- Table structure for table `dispatcher_password_resets`
--

CREATE TABLE `dispatcher_password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `dispatcher_password_resets_email_index` (`email`),
  KEY `dispatcher_password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dispatcher_password_resets`
--


--
-- Table structure for table `dispatchers`
--

CREATE TABLE `dispatchers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `dispatchers_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `dispatchers`
--


--
-- Table structure for table `disputes`
--

CREATE TABLE `disputes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `dispute_type` enum('user','provider') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user',
  `dispute_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `disputes`
--

INSERT INTO `disputes` VALUES (1,'provider','User not familiar with route and changed route','active','2021-09-07 10:11:43','2021-09-07 10:11:43'),(2,'provider','User arrogant and rude','active','2021-09-07 10:11:43','2021-09-07 10:11:43'),(3,'provider','User not paid amount','active','2021-09-07 10:11:43','2021-09-07 10:11:43'),(4,'user','I didn\'t feel safe during the ride','active','2021-09-07 10:11:43','2021-09-07 10:11:43'),(5,'user','Driver Unprofessional','active','2021-09-07 10:11:43','2021-09-07 10:11:43'),(6,'user','Driver took long and incorrect route','active','2021-09-07 10:11:43','2021-09-07 10:11:43'),(7,'user','Driver Delayed Pickup','active','2021-09-07 10:11:43','2021-09-07 10:11:43'),(8,'user','Driver changed route and charged extra amont','active','2021-09-07 10:11:43','2021-09-07 10:11:43');

--
-- Table structure for table `documents`
--

CREATE TABLE `documents` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `type` enum('DRIVER','VEHICLE') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `documents`
--


--
-- Table structure for table `eventcontacts`
--

CREATE TABLE `eventcontacts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `location` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `eventcontacts`
--


--
-- Table structure for table `favourite_locations`
--

CREATE TABLE `favourite_locations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` double(15,8) DEFAULT NULL,
  `longitude` double(15,8) DEFAULT NULL,
  `type` enum('home','work','recent','others') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'others',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `favourite_locations`
--

INSERT INTO `favourite_locations` VALUES (1,103,'Sector 15, Panchkula, Haryana, India',30.68493300,76.83894130,'home','2021-09-10 12:04:07','2021-09-10 12:04:07'),(2,103,'Sector 10, Budanpur, Panchkula, Haryana, India',30.68988130,76.84836770,'work','2021-09-10 12:04:19','2021-09-10 12:04:19');

--
-- Table structure for table `fleet_cards`
--

CREATE TABLE `fleet_cards` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `last_four` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `brand` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_default` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fleet_cards`
--


--
-- Table structure for table `fleet_password_resets`
--

CREATE TABLE `fleet_password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `fleet_password_resets_email_index` (`email`),
  KEY `fleet_password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fleet_password_resets`
--


--
-- Table structure for table `fleet_wallet`
--

CREATE TABLE `fleet_wallet` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `fleet_id` int NOT NULL,
  `transaction_id` int NOT NULL,
  `transaction_alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('C','D') COLLATE utf8_unicode_ci NOT NULL,
  `amount` double(15,8) NOT NULL DEFAULT '0.00000000',
  `open_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `close_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `payment_mode` enum('BRAINTREE','CARD','PAYPAL','PAYUMONEY','PAYTM') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fleet_wallet`
--


--
-- Table structure for table `fleets`
--

CREATE TABLE `fleets` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `company` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `commission` double(5,2) NOT NULL DEFAULT '0.00',
  `wallet_balance` double(10,2) NOT NULL DEFAULT '0.00',
  `stripe_cust_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `language` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `fleets_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `fleets`
--

INSERT INTO `fleets` VALUES (1,'Demo','fleet@demo.com','$2y$10$7pVAtfdhVoAQjpoA/uErQe4RKpEZ2WwY8TOPuU9wUjgF3WRtoMN4q',NULL,NULL,NULL,NULL,0.00,0.00,NULL,NULL,'2021-09-07 10:11:29','2021-09-07 10:11:29');

--
-- Table structure for table `geo_fencings`
--

CREATE TABLE `geo_fencings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `city_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `ranges` longtext COLLATE utf8_unicode_ci NOT 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=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `geo_fencings`
--

INSERT INTO `geo_fencings` VALUES (1,'Georgia','[{\"lat\":\"43.634627\",\"lng\":\"39.891790\"},{\"lat\":\"41.201951\",\"lng\":\"41.693548\"},{\"lat\":\"40.870475\",\"lng\":\"50.702337\"},{\"lat\":\"43.983471\",\"lng\":\"40.990423\"},{\"lat\":\"43.602813\",\"lng\":\"39.584173\"}]','2021-09-07 11:15:35','2021-09-07 11:15:35',NULL),(2,'India','[{\"lat\":\"35.211495\",\"lng\":\"73.733388\"},{\"lat\":\"24.648990\",\"lng\":\"94.211903\"},{\"lat\":\"7.843765\",\"lng\":\"78.127919\"},{\"lat\":\"29.651755\",\"lng\":\"61.780263\"}]','2021-09-09 12:07:26','2021-09-09 12:07:26',NULL);

--
-- Table structure for table `ltm_translations`
--

CREATE TABLE `ltm_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status` int NOT NULL DEFAULT '0',
  `locale` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `group` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `ltm_translations`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `batch` int NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (1,'2014_04_02_193005_create_translations_table',1),(2,'2014_10_12_000000_create_users_table',1),(3,'2014_10_12_100000_create_password_resets_table',1),(4,'2015_08_25_172600_create_settings_table',1),(5,'2016_06_01_000001_create_oauth_auth_codes_table',1),(6,'2016_06_01_000002_create_oauth_access_tokens_table',1),(7,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(8,'2016_06_01_000004_create_oauth_clients_table',1),(9,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(10,'2016_12_03_000000_create_payu_payments_table',1),(11,'2016_12_03_000000_create_permission_tables',1),(12,'2017_01_11_180503_create_admins_table',1),(13,'2017_01_11_180511_create_providers_table',1),(14,'2017_01_11_181312_create_cards_table',1),(15,'2017_01_11_181357_create_chats_table',1),(16,'2017_01_11_181558_create_promocodes_table',1),(17,'2017_01_11_182454_create_provider_documents_table',1),(18,'2017_01_11_182536_create_provider_services_table',1),(19,'2017_01_11_182649_create_user_requests_table',1),(20,'2017_01_11_182717_create_request_filters_table',1),(21,'2017_01_11_182738_create_service_types_table',1),(22,'2017_01_25_172422_create_documents_table',1),(23,'2017_01_31_122021_create_provider_devices_table',1),(24,'2017_02_02_192703_create_user_request_ratings_table',1),(25,'2017_02_06_080124_create_user_request_payments_table',1),(26,'2017_02_14_135859_create_provider_profiles_table',1),(27,'2017_02_21_131429_create_promocode_usages_table',1),(28,'2017_06_17_151030_create_dispatchers_table',1),(29,'2017_06_17_151031_create_dispatcher_password_resets_table',1),(30,'2017_06_17_151145_create_fleets_table',1),(31,'2017_06_17_151146_create_fleet_password_resets_table',1),(32,'2017_06_20_154148_create_accounts_table',1),(33,'2017_06_20_154149_create_account_password_resets_table',1),(34,'2017_08_03_194354_create_custom_pushes_table',1),(35,'2017_09_01_190333_create_wallet_passbooks_table',1),(36,'2017_09_01_190355_create_promocode_passbooks_table',1),(37,'2017_09_26_160101_create_favourite_locations_table',1),(38,'2018_06_29_174517_create_works_table',1),(39,'2018_08_28_163357_create_geo_fencing_table',1),(40,'2018_08_28_201840_create_service_types_geo_fencing_table',1),(41,'2018_09_07_151624_create_admin_wallet_table',1),(42,'2018_09_07_151631_create_user_wallet_table',1),(43,'2018_09_07_151636_create_provider_wallet_table',1),(44,'2018_09_07_151645_create_fleet_wallet_table',1),(45,'2018_09_14_160535_create_wallet_requests_table',1),(46,'2018_09_24_164552_create_provider_cards_table',1),(47,'2018_09_26_143905_create_fleet_cards_table',1),(48,'2018_09_27_195450_create_eventcontacts_table',1),(49,'2018_12_07_132532_create_referral_histroy_table',1),(50,'2018_12_07_132536_create_referral_earnings_table',1),(51,'2018_12_18_171537_create_reasons_table',1),(52,'2018_12_27_125550_create_request_waiting_time_table',1),(53,'2018_12_27_125553_create_service_peak_hours_table',1),(54,'2018_12_27_125556_create_peak_hours_table',1),(55,'2019_01_07_135142_create_disputes_table',1),(56,'2019_01_07_135145_create_user_request_disputes_table',1),(57,'2019_01_07_135146_create_user_request_lost_items_table',1),(58,'2019_01_07_135148_create_notifications_table',1),(59,'2019_01_28_145133_create_push_subscriptions_table',1),(60,'2019_01_31_104045_create_payment_logs_table',1),(61,'2020_02_21_055400_update_fare_tables',1),(62,'2020_04_15_121806_update_user_requests',1);

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` int unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `model_has_permissions`
--


--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` int unsigned NOT NULL,
  `model_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `model_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` VALUES (1,'App\\Admin',1),(5,'App\\Fleet',1),(2,'App\\Admin',2),(4,'App\\Admin',3),(3,'App\\Admin',4);

--
-- Table structure for table `notifications`
--

CREATE TABLE `notifications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `notify_type` enum('all','user','provider') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all',
  `image` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `expiry_date` timestamp NULL DEFAULT NULL,
  `status` enum('active','inactive') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `notifications`
--


--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `client_id` int unsigned NOT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `scopes` text COLLATE utf8_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` VALUES ('63cfa6f59b8f621de5032f4a239e3e1a42e9bdcaaa3780bbdacd65931a5f70db631e7931e59aced8',101,2,NULL,'[]',0,'2021-09-09 15:53:53','2021-09-09 15:53:53','2021-09-24 15:53:53'),('75125b6ac991374294f2be69bd2f6e3d0084403690fc9831101291c93404723ad7a5b5a1df26d9c7',100,2,NULL,'[]',0,'2021-09-09 11:39:16','2021-09-09 11:39:16','2021-09-24 11:39:16'),('7c21594ff47c31f81f9534a93e82b051fc442c2fbbae5e2b621fcff8656ebd5084b476e4373a7122',104,2,NULL,'[]',0,'2021-09-09 16:43:03','2021-09-09 16:43:03','2021-09-24 16:43:03'),('a35cdedc335c3d425ad0159790bc008422a0947325c07204449d5953e6eca39c11f6039df24c7225',103,2,NULL,'[]',0,'2021-09-11 18:57:21','2021-09-11 18:57:21','2021-09-26 18:57:21');

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `client_id` int unsigned NOT NULL,
  `scopes` text COLLATE utf8_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `secret` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `redirect` text COLLATE utf8_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` VALUES (1,NULL,'Opa Personal Access Client','AOMCwDU3A9PiwfhG5UOOl2juN0S7YKD4zQ1MBYsR','http://localhost',1,0,0,'2021-09-08 23:41:14','2021-09-08 23:41:14'),(2,NULL,'Opa Password Grant Client','Tof4S00Z8T6SSzQXurybcjNJTMwvvZZq54QyaLTh','http://localhost',0,1,0,'2021-09-08 23:41:14','2021-09-08 23:41:14');

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `client_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_personal_access_clients_client_id_index` (`client_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` VALUES (1,1,'2021-09-08 23:41:14','2021-09-08 23:41:14');

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `access_token_id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--

INSERT INTO `oauth_refresh_tokens` VALUES ('2f267c43ab2a3ccb85acaa94a7adbda21efc34b54bfe070338019bd6bda0b3f60ab0112b7321d815','a35cdedc335c3d425ad0159790bc008422a0947325c07204449d5953e6eca39c11f6039df24c7225',0,'2021-12-10 18:57:21'),('9a3ca8ce153721ce881c62083dc4bca1993e29d0f9ca1cbe110fd19d021c539c71078bc6922c5f85','75125b6ac991374294f2be69bd2f6e3d0084403690fc9831101291c93404723ad7a5b5a1df26d9c7',0,'2021-12-08 11:39:16'),('a47d58c132ce53c7d888f35c70f245d8ca8302f895b5a3d3882c5e2e2213d3cf397a2515a149618e','63cfa6f59b8f621de5032f4a239e3e1a42e9bdcaaa3780bbdacd65931a5f70db631e7931e59aced8',0,'2021-12-08 15:53:53'),('f6871b3199d27c0bfe38d916e97cf36ff97bbe76de5cd3c09b4e760b5327783766169ed6d3f89edc','7c21594ff47c31f81f9534a93e82b051fc442c2fbbae5e2b621fcff8656ebd5084b476e4373a7122',0,'2021-12-08 16:43:03');

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`),
  KEY `password_resets_token_index` (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payment_logs`
--

CREATE TABLE `payment_logs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `is_wallet` int NOT NULL DEFAULT '0',
  `user_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'user or provider',
  `payment_mode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL COMMENT 'user id or provider id',
  `amount` double(8,2) NOT NULL DEFAULT '0.00',
  `transaction_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Random code generated during payment',
  `transaction_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Foreign key of the user request or wallet table',
  `response` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payment_logs`
--


--
-- Table structure for table `payu_payments`
--

CREATE TABLE `payu_payments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `account` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payable_id` int unsigned DEFAULT NULL,
  `payable_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `txnid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mihpayid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `firstname` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `lastname` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `phone` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `amount` double NOT NULL,
  `discount` double NOT NULL DEFAULT '0',
  `net_amount_debit` double NOT NULL DEFAULT '0',
  `data` text COLLATE utf8_unicode_ci NOT NULL,
  `status` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `unmappedstatus` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `mode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bank_ref_num` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bankcode` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cardnum` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `name_on_card` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `issuing_bank` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `payu_payments`
--


--
-- Table structure for table `peak_hours`
--

CREATE TABLE `peak_hours` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `start_time` time DEFAULT NULL,
  `end_time` time DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `peak_hours`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `display_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `group_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=98 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'dashboard-menus','Box Menus','admin','Dashboard',NULL,NULL),(2,'wallet-summary','Wallet Summary','admin','Dashboard',NULL,NULL),(3,'recent-rides','Recent Rides','admin','Dashboard',NULL,NULL),(4,'dispatcher-panel','Dispatcher Menu','admin','Dispatcher Panel',NULL,NULL),(5,'dispatcher-panel-add','Add Rides','admin','Dispatcher Panel',NULL,NULL),(6,'dispute-list','Dispute list','admin','Dispute',NULL,NULL),(7,'dispute-create','Create Dispute','admin','Dispute',NULL,NULL),(8,'dispute-edit','Edit Dispute','admin','Dispute',NULL,NULL),(9,'dispute-delete','Delete Dispute','admin','Dispute',NULL,NULL),(10,'heat-map','Heat Map','admin','Map',NULL,NULL),(11,'god-eye','Gods Eye','admin','Map',NULL,NULL),(12,'user-list','User list','admin','Users',NULL,NULL),(13,'user-history','User History','admin','Users',NULL,NULL),(14,'user-create','Create User','admin','Users',NULL,NULL),(15,'user-edit','Edit User','admin','Users',NULL,NULL),(16,'user-delete','Delete User','admin','Users',NULL,NULL),(17,'provider-list','Provider list','admin','Providers',NULL,NULL),(18,'provider-create','Create Provider','admin','Providers',NULL,NULL),(19,'provider-edit','Edit Provider','admin','Providers',NULL,NULL),(20,'provider-delete','Delete Provider','admin','Providers',NULL,NULL),(21,'provider-status','Provider Status','admin','Providers',NULL,NULL),(22,'provider-history','Ride History','admin','Providers',NULL,NULL),(23,'provider-statements','Statements','admin','Providers',NULL,NULL),(24,'provider-services','Provider Services','admin','Providers',NULL,NULL),(25,'provider-service-update','Provider Service Update','admin','Providers',NULL,NULL),(26,'provider-service-delete','Provider Service Delete','admin','Providers',NULL,NULL),(27,'provider-documents','Provider Documents','admin','Providers',NULL,NULL),(28,'provider-document-edit','Provider Document Edit','admin','Providers',NULL,NULL),(29,'provider-document-delete','Provider Document Delete','admin','Providers',NULL,NULL),(30,'dispatcher-list','Dispatcher list','admin','Dispatcher',NULL,NULL),(31,'dispatcher-create','Create Dispatcher','admin','Dispatcher',NULL,NULL),(32,'dispatcher-edit','Edit Dispatcher','admin','Dispatcher',NULL,NULL),(33,'dispatcher-delete','Delete Dispatcher','admin','Dispatcher',NULL,NULL),(34,'fleet-list','Fleet Owner list','admin','Fleet Owner',NULL,NULL),(35,'fleet-create','Create Fleet Owner','admin','Fleet Owner',NULL,NULL),(36,'fleet-edit','Edit Fleet Owner','admin','Fleet Owner',NULL,NULL),(37,'fleet-delete','Delete Fleet Owner','admin','Fleet Owner',NULL,NULL),(38,'fleet-providers','Fleet Owners Providers list','admin','Fleet Owner',NULL,NULL),(39,'account-manager-list','Account Manager list','admin','Account Manager',NULL,NULL),(40,'account-manager-create','Create Account Manager','admin','Account Manager',NULL,NULL),(41,'account-manager-edit','Edit Account Manager','admin','Account Manager',NULL,NULL),(42,'account-manager-delete','Delete Account Manager','admin','Account Manager',NULL,NULL),(43,'dispute-manager-list','Dispute Manager list','admin','Dispute Manager',NULL,NULL),(44,'dispute-manager-create','Create Dispute Manager','admin','Dispute Manager',NULL,NULL),(45,'dispute-manager-edit','Edit Dispute Manager','admin','Dispute Manager',NULL,NULL),(46,'dispute-manager-delete','Delete Dispute Manager','admin','Dispute Manager',NULL,NULL),(47,'statements','Statements','admin','Statements',NULL,NULL),(48,'settlements','Settlements','admin','Settlements',NULL,NULL),(49,'ratings','Ratings','admin','Ratings',NULL,NULL),(50,'ride-history','Ride History','admin','Rides',NULL,NULL),(51,'ride-delete','Delete Ride','admin','Rides',NULL,NULL),(52,'schedule-rides','Schedule Rides','admin','Rides',NULL,NULL),(53,'promocodes-list','Promocodes List','admin','Promocodes',NULL,NULL),(54,'promocodes-create','Create Promocode','admin','Promocodes',NULL,NULL),(55,'promocodes-edit','Edit Promocode','admin','Promocodes',NULL,NULL),(56,'promocodes-delete','Delete Promocode','admin','Promocodes',NULL,NULL),(57,'service-types-list','Service Types List','admin','Service Types',NULL,NULL),(58,'service-types-create','Create Service Type','admin','Service Types',NULL,NULL),(59,'service-types-edit','Edit Service Type','admin','Service Types',NULL,NULL),(60,'service-types-delete','Delete Service Type','admin','Service Types',NULL,NULL),(61,'peak-hour-list','Peak Hour List','admin','Service Types',NULL,NULL),(62,'peak-hour-create','Create Peak Hour','admin','Service Types',NULL,NULL),(63,'peak-hour-edit','Edit Peak Hour','admin','Service Types',NULL,NULL),(64,'peak-hour-delete','Delete Peak Hour','admin','Service Types',NULL,NULL),(65,'documents-list','Documents List','admin','Documents',NULL,NULL),(66,'documents-create','Create Document','admin','Documents',NULL,NULL),(67,'documents-edit','Edit Document','admin','Documents',NULL,NULL),(68,'documents-delete','Delete Document','admin','Documents',NULL,NULL),(69,'cancel-reasons-list','Cancel Reason List','admin','Cancel Reasons',NULL,NULL),(70,'cancel-reasons-create','Create Reason','admin','Cancel Reasons',NULL,NULL),(71,'cancel-reasons-edit','Edit Reason','admin','Cancel Reasons',NULL,NULL),(72,'cancel-reasons-delete','Delete Reason','admin','Cancel Reasons',NULL,NULL),(73,'notification-list','Notifications List','admin','Notifications',NULL,NULL),(74,'notification-create','Create Notification','admin','Notifications',NULL,NULL),(75,'notification-edit','Edit Notification','admin','Notifications',NULL,NULL),(76,'notification-delete','Delete Notification','admin','Notifications',NULL,NULL),(77,'lost-item-list','Lost Item List','admin','Lost Items',NULL,NULL),(78,'lost-item-create','Create Lost Item','admin','Lost Items',NULL,NULL),(79,'lost-item-edit','Edit Lost Item','admin','Lost Items',NULL,NULL),(80,'role-list','Role list','admin','Role',NULL,NULL),(81,'role-create','Create Role','admin','Role',NULL,NULL),(82,'role-edit','Edit Role','admin','Role',NULL,NULL),(83,'role-delete','Delete Role','admin','Role',NULL,NULL),(84,'sub-admin-list','Sub Admins List','admin','Sub Admins',NULL,NULL),(85,'sub-admin-create','Create Sub Admin','admin','Sub Admins',NULL,NULL),(86,'sub-admin-edit','Edit Sub Admin','admin','Sub Admins',NULL,NULL),(87,'sub-admin-delete','Delete Sub Admin','admin','Sub Admins',NULL,NULL),(88,'payment-history','Payment History List','admin','Payment',NULL,NULL),(89,'payment-settings','Payment Settings List','admin','Payment',NULL,NULL),(90,'site-settings','Site Settings','admin','Settings',NULL,NULL),(91,'account-settings','Account Settings','admin','Settings',NULL,NULL),(92,'transalations','Translations','admin','Settings',NULL,NULL),(93,'change-password','Change Password','admin','Settings',NULL,NULL),(94,'cms-pages','CMS Pages','admin','Pages',NULL,NULL),(95,'help','Help','admin','Pages',NULL,NULL),(96,'custom-push','Custom Push','admin','Others',NULL,NULL),(97,'db-backup','DB Backup','admin','Others',NULL,NULL);

--
-- Table structure for table `promocode_passbooks`
--

CREATE TABLE `promocode_passbooks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `promocode_id` int NOT NULL,
  `status` enum('ADDED','USED','EXPIRED') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `promocode_passbooks`
--


--
-- Table structure for table `promocode_usages`
--

CREATE TABLE `promocode_usages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `promocode_id` int NOT NULL,
  `status` enum('ADDED','USED','EXPIRED') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `promocode_usages`
--


--
-- Table structure for table `promocodes`
--

CREATE TABLE `promocodes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `promo_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `percentage` double(5,2) NOT NULL DEFAULT '0.00',
  `max_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `promo_description` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `expiration` datetime NOT NULL,
  `status` enum('ADDED','EXPIRED') COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `promocodes`
--

INSERT INTO `promocodes` VALUES (1,'CPD01',10.00,50.00,'10% off, Max discount is 50','2021-11-07 10:11:43','ADDED',NULL,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(2,'CPD02',20.00,75.00,'20% off, Max discount is 75','2021-11-07 10:11:43','ADDED',NULL,'2021-09-07 10:11:43','2021-09-07 10:11:43');

--
-- Table structure for table `provider_cards`
--

CREATE TABLE `provider_cards` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int DEFAULT NULL,
  `last_four` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `card_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `brand` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_default` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `provider_cards`
--


--
-- Table structure for table `provider_devices`
--

CREATE TABLE `provider_devices` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int NOT NULL,
  `udid` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `sns_arn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('android','ios') COLLATE utf8_unicode_ci NOT NULL,
  `jwt_token` text COLLATE utf8_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `provider_devices`
--

INSERT INTO `provider_devices` VALUES (1,101,'17edeae438ce4618','drtCnVBripo:APA91bG3sGCnJEG4KY0bjhgmuuIJQf4JZ8nyWgVxs4PbShwJUaXd5bOZEBMghd3O6E6Vq20vuWZssuZjHTGRCikZGPO35930_JXp_Y94gLTtIuGIPhHAAwJT9zfIOITUfX0k7P-d6J1Y',NULL,'android','eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjEwMSwiaXNzIjoiaHR0cHM6Ly9kZW1vLm1vemlsaXQuY29tL3N1cGVyQWRtaW5Mb2dpbi9PcGEvcHVibGljL2FwaS9wcm92aWRlci9vYXV0aC90b2tlbiIsImlhdCI6MTYzMTE5NTg2MywiZXhwIjoxNjMxNTU1ODYzLCJuYmYiOjE2MzExOTU4NjMsImp0aSI6Ik5HeU1NOFhmQ3VKa1pQOUoifQ.cgSkrdTsiXNpVbFpR7gBrwbnDm1ntbxN0sefVS1Q0Ns','2021-09-09 14:01:47','2021-09-09 17:57:43'),(2,103,'a095a99573ad9bbf','d1CC-ngdPbY:APA91bGL030gRhiggqpzrl8tdsny0weoQAKdmMEiV2xK5I0AnQnkVkFLxnSD8_IX7cST48VIVDcmP_g5Ki_fP7JgEIywYx3cGpwjsY-rjTOhp7uhAPLd5pLSSQxC7GbV-_TW-_PSMmBW',NULL,'android','eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJzdWIiOjEwMywiaXNzIjoiaHR0cHM6Ly9kZW1vLm1vemlsaXQuY29tL3N1cGVyQWRtaW5Mb2dpbi9PcGEvcHVibGljL2FwaS9wcm92aWRlci9vYXV0aC90b2tlbiIsImlhdCI6MTYzMTI2MDk1MiwiZXhwIjoxNjMxNjIwOTUyLCJuYmYiOjE2MzEyNjA5NTIsImp0aSI6IjBTZFRhZ0lJcjQ1YTV4MW4ifQ.MD4Z9fDu_RLXRlXEE_r2bQ09uzZkK31LCpiYNF_tVGc','2021-09-09 17:09:34','2021-09-10 12:02:32');

--
-- Table structure for table `provider_documents`
--

CREATE TABLE `provider_documents` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int NOT NULL,
  `document_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `url` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `unique_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` enum('ASSESSING','ACTIVE') COLLATE utf8_unicode_ci NOT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `provider_documents`
--


--
-- Table structure for table `provider_profiles`
--

CREATE TABLE `provider_profiles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int NOT NULL,
  `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address_secondary` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `country` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `postal_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `provider_profiles`
--


--
-- Table structure for table `provider_services`
--

CREATE TABLE `provider_services` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int NOT NULL,
  `service_type_id` int NOT NULL,
  `status` enum('active','offline','riding','hold','balance') COLLATE utf8_unicode_ci NOT NULL,
  `service_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `service_model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `provider_services`
--

INSERT INTO `provider_services` VALUES (1,1,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(2,2,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(3,3,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(4,4,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(5,5,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(6,6,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(7,7,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(8,8,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(9,9,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(10,10,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(11,11,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(12,12,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(13,13,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(14,14,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(15,15,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(16,16,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(17,17,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(18,18,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(19,19,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(20,20,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(21,21,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(22,22,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(23,23,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(24,24,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(25,25,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(26,26,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(27,27,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(28,28,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(29,29,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(30,30,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(31,31,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(32,32,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(33,33,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(34,34,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(35,35,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(36,36,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(37,37,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(38,38,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(39,39,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(40,40,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(41,41,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(42,42,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(43,43,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(44,44,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(45,45,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(46,46,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(47,47,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(48,48,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(49,49,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(50,50,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(51,51,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(52,52,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(53,53,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(54,54,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(55,55,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(56,56,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(57,57,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(58,58,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(59,59,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(60,60,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(61,61,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(62,62,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(63,63,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(64,64,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(65,65,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(66,66,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(67,67,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(68,68,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(69,69,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(70,70,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(71,71,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(72,72,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(73,73,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(74,74,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(75,75,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(76,76,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(77,77,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(78,78,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(79,79,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(80,80,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(81,81,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(82,82,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(83,83,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(84,84,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(85,85,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(86,86,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(87,87,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(88,88,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(89,89,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(90,90,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(91,91,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(92,92,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(93,93,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(94,94,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(95,95,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(96,96,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(97,97,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(98,98,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(99,99,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(100,100,1,'offline','TN 01 A 1234','Audi R8','2021-09-07 10:11:43','2021-09-07 10:11:43'),(101,101,2,'active','bbbb','vvv','2021-09-09 14:01:47','2021-09-09 22:08:53'),(102,103,1,'active','2474','honda city','2021-09-09 17:09:34','2021-09-10 12:07:24');

--
-- Table structure for table `provider_wallet`
--

CREATE TABLE `provider_wallet` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `provider_id` int NOT NULL,
  `transaction_id` int NOT NULL,
  `transaction_alias` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('C','D') COLLATE utf8_unicode_ci NOT NULL,
  `amount` double(15,8) NOT NULL DEFAULT '0.00000000',
  `open_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `close_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `payment_mode` enum('BRAINTREE','CARD','PAYPAL','PAYUMONEY','PAYTM') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `provider_wallet`
--


--
-- Table structure for table `providers`
--

CREATE TABLE `providers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gender` enum('MALE','FEMALE') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'MALE',
  `country_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `rating` decimal(4,2) NOT NULL DEFAULT '5.00',
  `status` enum('document','card','onboarding','approved','banned','balance') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'document',
  `fleet` int NOT NULL DEFAULT '0',
  `latitude` double(15,8) DEFAULT NULL,
  `longitude` double(15,8) DEFAULT NULL,
  `stripe_acc_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `stripe_cust_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `paypal_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `login_by` enum('manual','facebook','google') COLLATE utf8_unicode_ci NOT NULL,
  `social_unique_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `otp` mediumint NOT NULL DEFAULT '0',
  `wallet_balance` double(10,2) NOT NULL DEFAULT '0.00',
  `referral_unique_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qrcode_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `providers_email_unique` (`email`),
  UNIQUE KEY `providers_mobile_unique` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=104 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `providers`
--

INSERT INTO `providers` VALUES (101,'Pralabh','Gupta','pralabh@gmail.com','MALE','+91','8171992625','$2y$10$mlek135VmzEreAW96NpSju3NJqkxwOtVlanRnU4ZyKlZP4kWBu2Sq',NULL,5.00,'approved',0,28.43944980,77.52456370,NULL,NULL,NULL,'manual',NULL,0,0.00,'A50490','uploads/1631181707960723001_8171992625.png',NULL,'2021-09-09 14:01:47','2021-09-09 22:08:53'),(103,'Mohit','Jain','mohitjain0206@gmail.com','MALE','+91','9876479350','$2y$10$TRq2IylR3aH.qwkewAyu1O6fxmZA7LrSxhj3HyDiS8b1XuVEkRGWa',NULL,5.00,'approved',0,30.66711060,76.86465450,NULL,NULL,NULL,'manual',NULL,0,0.00,'E9B3D4','uploads/16311929741958166095_9876479350.png',NULL,'2021-09-09 17:09:34','2021-09-10 12:12:23');

--
-- Table structure for table `push_subscriptions`
--

CREATE TABLE `push_subscriptions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `guard` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `admin_id` int unsigned DEFAULT NULL,
  `endpoint` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `public_key` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `auth_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `push_subscriptions_endpoint_unique` (`endpoint`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `push_subscriptions`
--


--
-- Table structure for table `reasons`
--

CREATE TABLE `reasons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `type` enum('USER','PROVIDER') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'USER',
  `reason` text COLLATE utf8_unicode_ci,
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `reasons`
--

INSERT INTO `reasons` VALUES (1,'PROVIDER','Take long time to reach pickup point',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(2,'PROVIDER','Heavy Traffic',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(3,'PROVIDER','User choose wrong location',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(4,'PROVIDER','My reason not listed',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(5,'PROVIDER','User Unavailable',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(6,'USER','My reason not listed',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(7,'USER','Unable to contact driver',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(8,'USER','Expected a shoter wait time',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(9,'USER','Driver denied to come and pikcup',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(10,'USER','Driver denied to go to destination',1,'2021-09-07 10:11:43','2021-09-07 10:11:43'),(11,'USER','Driver Charged Extra',1,'2021-09-07 10:11:43','2021-09-07 10:11:43');

--
-- Table structure for table `referral_earnings`
--

CREATE TABLE `referral_earnings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `referrer_id` int NOT NULL,
  `type` tinyint NOT NULL DEFAULT '1' COMMENT '1-user,2-provider',
  `amount` double(10,2) NOT NULL DEFAULT '0.00',
  `count` mediumint NOT NULL DEFAULT '0',
  `referral_histroy_id` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `referral_earnings`
--


--
-- Table structure for table `referral_histroy`
--

CREATE TABLE `referral_histroy` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `referrer_id` int NOT NULL,
  `type` tinyint NOT NULL DEFAULT '1' COMMENT '1-user,2-provider',
  `referral_id` int NOT NULL,
  `referral_data` longtext COLLATE utf8_unicode_ci,
  `status` enum('P','C') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'C',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `referral_histroy`
--


--
-- Table structure for table `request_filters`
--

CREATE TABLE `request_filters` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int NOT NULL,
  `provider_id` int NOT NULL,
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `request_filters`
--


--
-- Table structure for table `request_waiting_time`
--

CREATE TABLE `request_waiting_time` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int NOT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `ended_at` timestamp NULL DEFAULT NULL,
  `waiting_mins` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `request_waiting_time`
--

INSERT INTO `request_waiting_time` VALUES (1,1,'2021-09-10 12:06:35','2021-09-10 12:06:38',3,'2021-09-10 12:06:35','2021-09-10 12:06:38'),(2,1,'2021-09-10 12:06:39','2021-09-10 12:06:40',1,'2021-09-10 12:06:39','2021-09-10 12:06:40'),(3,1,'2021-09-10 12:06:44','2021-09-10 12:06:50',6,'2021-09-10 12:06:44','2021-09-10 12:06:50');

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` int unsigned NOT NULL,
  `role_id` int unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(53,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(60,1),(61,1),(62,1),(63,1),(64,1),(65,1),(66,1),(67,1),(68,1),(69,1),(70,1),(71,1),(72,1),(73,1),(74,1),(75,1),(76,1),(77,1),(78,1),(79,1),(80,1),(81,1),(82,1),(83,1),(84,1),(85,1),(86,1),(87,1),(88,1),(89,1),(90,1),(91,1),(92,1),(93,1),(94,1),(95,1),(96,1),(97,1),(4,2),(5,2),(57,2),(91,2),(93,2),(6,3),(7,3),(8,3),(9,3),(91,3),(93,3),(1,4),(2,4),(3,4),(47,4),(91,4),(93,4),(1,5),(2,5),(3,5),(4,5),(5,5),(6,5),(7,5),(8,5),(9,5),(10,5),(11,5),(12,5),(13,5),(14,5),(15,5),(16,5),(17,5),(18,5),(19,5),(20,5),(21,5),(22,5),(23,5),(24,5),(25,5),(26,5),(27,5),(28,5),(29,5),(30,5),(31,5),(32,5),(33,5),(34,5),(35,5),(36,5),(37,5),(38,5),(39,5),(40,5),(41,5),(42,5),(43,5),(44,5),(45,5),(46,5),(47,5),(48,5),(49,5),(50,5),(51,5),(52,5),(53,5),(54,5),(55,5),(56,5),(57,5),(58,5),(59,5),(60,5),(61,5),(62,5),(63,5),(64,5),(65,5),(66,5),(67,5),(68,5),(69,5),(70,5),(71,5),(72,5),(73,5),(74,5),(75,5),(76,5),(77,5),(78,5),(79,5),(80,5),(81,5),(82,5),(83,5),(84,5),(85,5),(86,5),(87,5),(88,5),(89,5),(90,5),(91,5),(92,5),(93,5),(94,5),(95,5),(96,5),(97,5);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'ADMIN','admin',NULL,NULL),(2,'DISPATCHER','admin',NULL,NULL),(3,'DISPUTE','admin',NULL,NULL),(4,'ACCOUNT','admin',NULL,NULL),(5,'FLEET','fleet',NULL,NULL);

--
-- Table structure for table `service_peak_hours`
--

CREATE TABLE `service_peak_hours` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `service_type_id` int NOT NULL,
  `peak_hours_id` int NOT NULL,
  `min_price` double(10,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_peak_hours`
--


--
-- Table structure for table `service_types`
--

CREATE TABLE `service_types` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `provider_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `marker` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `capacity` int NOT NULL DEFAULT '0',
  `fixed` int NOT NULL,
  `price` int NOT NULL,
  `minute` int NOT NULL,
  `hour` int DEFAULT NULL,
  `distance` int NOT NULL,
  `calculator` enum('MIN','HOUR','DISTANCE','DISTANCEMIN','DISTANCEHOUR') COLLATE utf8_unicode_ci NOT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `waiting_free_mins` int NOT NULL DEFAULT '0',
  `waiting_min_charge` double(10,2) NOT NULL DEFAULT '0.00',
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_types`
--

INSERT INTO `service_types` VALUES (1,'Sedan','Driver','https://demo.mozilit.com/superAdminLogin/Opa/public/uploads/9a332f005b7270a94962f9808937c038b8ebbad2.png','https://demo.mozilit.com/superAdminLogin/Opa/public/uploads/5bf31be60d4008ee7ab7bc10f03ac1e3d4d8ac44.png',4,20,10,0,0,1,'DISTANCE',NULL,0,0.00,1,'2021-09-07 10:11:29','2021-09-07 10:48:29'),(2,'Hatchback','Driver','https://demo.mozilit.com/superAdminLogin/Opa/public/uploads/20f68cb5d42c76c01ba45d6e8ff8a7a396dc541e.png','https://demo.mozilit.com/superAdminLogin/Opa/public/uploads/bc600dc61b0a60d8700c27aaf102dc331bc70f72.png',2,20,10,0,0,1,'DISTANCE',NULL,0,0.00,1,'2021-09-07 10:11:29','2021-09-09 12:07:40'),(3,'SUV','Driver','https://demo.mozilit.com/superAdminLogin/Opa/public/uploads/d134a190674af631f81b607f8f2db7cd8378dc7a.png','https://demo.mozilit.com/superAdminLogin/Opa/public/uploads/efb0d18c6ad43df7d87b3c9494ce37c12978214f.png',5,20,10,0,0,1,'DISTANCE',NULL,0,0.00,1,'2021-09-07 10:11:29','2021-09-07 10:51:21');

--
-- Table structure for table `service_types_geo_fencings`
--

CREATE TABLE `service_types_geo_fencings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `geo_fencing_id` int NOT NULL,
  `service_type_id` int NOT NULL,
  `distance` double(8,2) NOT NULL,
  `price` double(8,2) NOT NULL,
  `minute` double(8,2) NOT NULL,
  `hour` int DEFAULT NULL,
  `non_geo_price` double(8,2) NOT NULL,
  `city_limits` double(8,2) NOT NULL,
  `fixed` double(8,2) NOT NULL,
  `old_ranges_price` double(8,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `service_types_geo_fencings`
--

INSERT INTO `service_types_geo_fencings` VALUES (1,1,1,1.00,10.00,0.00,0,0.00,0.00,20.00,0.00,'2021-09-07 11:15:35','2021-09-07 11:15:35'),(2,1,2,1.00,10.00,0.00,0,0.00,0.00,20.00,0.00,'2021-09-07 11:15:35','2021-09-07 11:15:35'),(3,1,3,1.00,10.00,0.00,0,0.00,0.00,20.00,0.00,'2021-09-07 11:15:35','2021-09-07 11:15:35'),(4,2,1,1.00,10.00,0.00,0,0.00,0.00,20.00,0.00,'2021-09-09 12:07:26','2021-09-09 12:07:26'),(5,2,2,1.00,10.00,0.00,0,0.00,0.00,20.00,0.00,'2021-09-09 12:07:26','2021-09-09 12:07:26'),(6,2,3,1.00,10.00,0.00,0,0.00,0.00,20.00,0.00,'2021-09-09 12:07:26','2021-09-09 12:07:26');

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `value` text COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `settings_key_index` (`key`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'demo_mode','0'),(2,'help','<p>Help page</p>'),(3,'page_privacy','<p>Privacy Policy</p>'),(4,'terms','<p><strong>Passenger Terms of Use</strong></p>\r\n\r\n<p>These terms of use govern the use by passengers (<strong>&quot;You, Your&quot;</strong>, <strong>&quot;Passenger&quot;</strong>) of certain Bolt software and transport services (<strong>&quot;Passenger Terms&quot;</strong>).</p>\r\n\r\n<p><strong>1. WELCOME TO BOLT</strong></p>\r\n\r\n<p>1.1 These Passenger Terms apply between You and:</p>\r\n\r\n<ul>\r\n	<li>(a) <strong>Hopp Operations Limited</strong> trading as &ldquo;Bolt&rdquo; (a company registered in the United Kingdom, with company number 11063356) (<strong>&quot;Bolt&quot;</strong>) in relation to the provision of the Service (as defined in clause 2.1 below); and</li>\r\n	<li>(b) Bolt Operations O&Uuml; a corporation organised and existing under the laws of the Estonia, having its registered office in Vana-L&otilde;una 39/1, Tallinn 10134, Estonia (<strong>&quot;Bolt Operations&quot;</strong>) in relation to the payment services relating to the Service (as defined in clause 2.1 below), from such time as You register and set up an account with Bolt.</li>\r\n</ul>\r\n\r\n<p>1.2 It is important that You read and understand the Passenger Terms before using the Service (as defined in 2.1 below). By using and accessing the Service, You agree to these Passenger Terms. If You do not agree to these Passenger Terms, please do not use the Service.</p>\r\n\r\n<p><strong>2. BOLT SERVICE</strong></p>\r\n\r\n<p>2.1 Bolt operates a free platform (the <strong>&quot;Service&quot;</strong>) that allows You to request, book and pay for passenger transportation services (<strong>&quot;Journeys&quot;</strong>) using the Bolt application (the <strong>&quot;App&quot;</strong>) available for download on Your mobile device and for licensed private hire vehicle drivers (<strong>&quot;Drivers&quot;</strong>) to provide the Journey to You.</p>\r\n\r\n<p>2.2 When You submit a booking request for a Journey through the App, Bolt will process Your request and may accept Your booking (depending on Your location and payment history) for the purpose of finding and allocating You a Driver who is willing and able to fulfil Your Journey request.</p>\r\n\r\n<p>2.3 Once an individual Driver confirms that they will accept Your Journey request, You will enter into a separate agreement with the Driver for the provision of the Journey on such terms and conditions as You agree with the Driver. Bolt does not provide Journeys and is not a party to Your agreement with the relevant Driver.</p>\r\n\r\n<p>2.4 Bolt will provide the following as part of the Service in connection with the Journey;</p>\r\n\r\n<ul>\r\n	<li>(a) Accepting and processing bookings as they are made by You;</li>\r\n	<li>(b) Identifying a Driver to complete Your Journey;</li>\r\n	<li>(c) Keeping records of bookings;</li>\r\n	<li>(d) Monitoring trips booked through the App remotely to ensure the safety of Drivers and Passengers, and the effective functioning of the App;</li>\r\n	<li>(e) Processing and managing complaints, questions, requests regarding lost and found items, and feedback through our customer support team. We encourage any and all feedback about Journeys to be provided through the App, in accordance with applicable law and in line with the expectations of Transport for London.</li>\r\n</ul>\r\n\r\n<p>2.5 You may cancel Your booking request for a Journey any time before You begin Your Journey by informing the Driver through the App. However, if You:</p>\r\n\r\n<ul>\r\n	<li>(a) cancel Your booking request more than 4 minutes after Your Journey was successfully allocated by Bolt to a Driver; or</li>\r\n	<li>(b) are late to meet Your Driver at the pick-up location and time You selected on the App when booking the Journey, Bolt Operations may collect a cancellation or late show-up fee from You of up to &pound;10 on behalf of the Driver.</li>\r\n</ul>\r\n\r\n<p>2.6 Bolt may, from time to time, provide social features on the Service, such as the ability to contact, rate and review the Driver. Any use of such social features should comply with our Rules of Acceptable Use below.</p>\r\n\r\n<p><strong>3. Accessing the Service</strong></p>\r\n\r\n<p>3.1 To access the Service, You must:</p>\r\n\r\n<ul>\r\n	<li>(a) download the App on Your mobile device (the App is free from either the Google App Store or the Apple App Store);</li>\r\n	<li>(b) accept these Passenger Terms and any relevant app store terms;</li>\r\n	<li>(c) be at least 18 years old;</li>\r\n	<li>(d) treat Your Driver with respect, courtesy and decency &ndash; as You would expect to be treated as a Passenger; and</li>\r\n	<li>(e) register and set up a Bolt account with a user ID and password (Your <strong>&quot;Account&quot;</strong>).</li>\r\n</ul>\r\n\r\n<p>3.2 You may connect to the Service using a third-party service (e.g. LinkedIn, Facebook or Twitter) . You acknowledge that Bolt may access and use Your information from that service (including Your personal, data) as permitted by that service and as set out in Bolt&rsquo;s Privacy Policy: (<a href=\"https://bolt.eu/en-gb/legal/gb/privacy-for-riders/\">https://bolt.eu/en-gb/legal/gb/privacy-for-riders/</a>).</p>\r\n\r\n<p>3.3 During the installation of the App, the Passenger&rsquo;s mobile number is linked to the respective Bolt Account and added to our database. If You are no longer using Your mobile number, You must notify Bolt within 7 days so we can anonymise Your Account data. If You do not notify us about any change to Your number, Your mobile operator may issue the same mobile number to another of their users and when using the App, this new person may be able to access Your data on the App.</p>\r\n\r\n<p>3.4 You must provide Bolt Operations with valid and up-to-date credit or debit card details in order to use Your Account to utilise the Service. You authorise Bolt Operations to collect from such credit or debit card the Fares incurred via Your Account and hereby confirm that the details You provide are accurate and that You have the right to use the credit or debit card provided.</p>\r\n\r\n<p>3.5 You are responsible for maintaining the confidentiality of Your login details and any activities that occur under Your Account. If You have any concerns that Your Account may have been misused, You should contact Bolt at london@bolt.eu straight away to let Bolt know.</p>\r\n\r\n<p>3.6 Your privacy is important to Bolt and Bolt Operations. You should read the Bolt&rsquo;s Privacy Policy (<a href=\"https://bolt.eu/en-gb/legal/gb/privacy-for-riders/\">https://bolt.eu/en-gb/legal/gb/privacy-for-riders/</a>) to understand how Bolt and Bolt Operations collect, use and share information about You. By using the App and the Service, You acknowledge that Your personal data will be processed in accordance with Bolt&rsquo;s Privacy Policy. Please note that Bolt is committed to proactively and reactively cooperating and assisting law enforcement officials in relation to incidence which occur on a Journey or between a Passenger and Driver. At our discretion and in accordance with applicable data protection laws and regulation, we may provide information regarding You, Your Account, and Your trip history to law enforcement officers and agents &ndash; further information about such disclosures can be found in Bolt&rsquo;s Privacy Policy.</p>\r\n\r\n<p><strong>4. Your Right to Use the Service</strong></p>\r\n\r\n<p>4.1 As long as You comply with these Passenger Terms, Bolt agrees to grant You a royalty free, revocable, non-exclusive right to access and use the Service in accordance with these Passenger Terms, Bolt&rsquo;s Privacy Policy (<a href=\"https://bolt.eu/en-gb/legal/gb/privacy-for-riders/\">https://bolt.eu/en-gb/legal/gb/privacy-for-riders/</a>) and the applicable app-store terms (incorporated into these Passenger Terms by reference). You may not transfer or sub-license this right to use the Service.</p>\r\n\r\n<p>4.2 Unless allowed by these Passenger Terms and as permitted by the functionality of the Service, You agree:</p>\r\n\r\n<ul>\r\n	<li>(a) not to copy the App or any portion of the Service;</li>\r\n	<li>(b) not to give or sell or otherwise make available our App or any portion of the Service to anybody else;</li>\r\n	<li>(c) not to change the App or any portion of the Service in any way; and</li>\r\n	<li>(d) not to look for or access the code of the App or any portion of the Service that Bolt has not expressly published publicly for general use.</li>\r\n</ul>\r\n\r\n<p>4.3 You agree that You have no rights in or to the App or any portion of the Service other than the right to use them in accordance with these Passenger Terms.</p>\r\n\r\n<p>4.4 All intellectual property rights in the Service, its content and any related documentation existing anywhere in the world belong to Bolt or its licensors (and are protected by copyright and/or trade secret laws and other international treaty provisions) and may not be copied, distributed, uploaded, republished, decompiled, disassembled or transmitted in any way without Bolt&rsquo;s prior written consent. You will not have any rights of ownership in the Service, its content or any related documents other than the right to use it in accordance with these Passenger Terms.</p>\r\n\r\n<p><strong>5. Taking a Journey</strong></p>\r\n\r\n<p>5.1 By requesting to book a Journey which is accepted by Bolt, You agree to enter into a further agreement with Your Driver to take (or to authorise another person to take) and pay for the Journey You have requested.</p>\r\n\r\n<p>5.2 You acknowledge that while undertaking the Journey:</p>\r\n\r\n<ul>\r\n	<li>(a) Your Driver may take any reasonable route to Your requested destination and Bolt does not set any route restrictions;</li>\r\n	<li>(b) You may amend Your route in consultation with Your Driver;</li>\r\n	<li>(c) an extraordinary situation (such as mechanical breakdown or civil emergencies) may result in Your Driver being unable to complete Your Journey;</li>\r\n	<li>(d) You will not consume or carry drugs or alcohol in the vehicle;</li>\r\n	<li>(e) You will not carry or use weapons in the vehicle; and</li>\r\n	<li>(f) You will not use, incite or encourage violence, racism or discrimination in any form.</li>\r\n</ul>\r\n\r\n<p>5.3 You agree that while You are a Passenger of any Journey You will treat Your Driver with respect, courtesy and decency &ndash; as You would expect to be treated as a Passenger. Any failure to abide by these Passenger Terms may affect Your ratings, entitle Bolt to suspend or terminate Your access to the Service or may be escalated to Bolt or the relevant authorities.</p>\r\n\r\n<p>5.4 You agree that if You or Your co-passengers damage the vehicle including its furnishing (including by staining the vehicle or causing the vehicle to smell) we may, on behalf of the Driver, require you to pay a cleaning fee of &pound;60 or, if greater, the costs of cleaning or repairing the vehicle (the &ldquo;Repair or Cleaning Charge&rdquo;). If You do not pay the Repair or Cleaning Charge when notified, You authorise us to deduct that amount from Your credit or debit card.</p>\r\n\r\n<p>5.5 Drivers commit to a high standard of service and professionalism towards Passengers. Please let us know at london@bolt.eu or through the App if You have not had a satisfactory Journey.</p>\r\n\r\n<p><strong>6. Fares and Payment Services from Bolt Operations</strong></p>\r\n\r\n<p>6.1 Bolt Operations processes all payments in relation to the App, including invoicing, collecting payments from You, refunding Passengers (where appropriate) and remitting payments to Drivers (<strong>&quot;Payment Services&quot;</strong>).</p>\r\n\r\n<p>6.2 Once a Driver has completed Your Journey, Bolt Operations will collect a fare from You on behalf of the Driver for each completed Journey taken through the Service (<strong>&quot;Fare&quot;</strong>). The Fare will be determined by the Software, having regard to the actual journey time, any peak pricing, cancellation fees, and distance travelled.</p>\r\n\r\n<p>6.3 As part of Your request for a Journey, the App will provide You with an estimate of the fare You will be charged for the provision of the Journey (the <strong>&quot;Estimate&quot;</strong>). This Estimate is provided for Your reference only and the actual Fare may vary due to journey time, distance travelled, any changes agreed with Your Driver or any peak pricing.</p>\r\n\r\n<p>6.4 Once You have completed a Journey, Bolt Operations will invoice You on behalf of the Driver and charge Your nominated credit or debit card for the amount of the Fare. Bolt Operations will then create a receipt on behalf of Your Driver setting out the route, Fare, time and other relevant information relating to that particular Journey.</p>\r\n\r\n<p>6.5 If, due to no fault of Bolt Operations or the Service, Bolt Operations is unsuccessful in collecting a Fare or any other amount from Your credit or debit card, Bolt will inform You and Bolt may suspend or temporarily disable all or part of Your access to the Service (without any responsibility to You), and Bolt shall be under no obligation to provide any or all of the Service while the amount concerned is unpaid. This does not affect any other rights and remedies available to either Bolt or Bolt Operations (as the Payment Services provider).</p>\r\n\r\n<p><strong>7. Promotional Codes</strong></p>\r\n\r\n<p>7.1 Bolt and any entity that is directly or indirectly under the control of Bolt and/or Bolt Operations (an &quot;Affiliate Company&quot;), may send You promotional codes on a per promotion basis. Promotional code credit can be applied towards payment on completion of a journey or other features or benefits related to the service and/or a third party&rsquo;s service and are subject any additional terms that are established on a per promotional code basis. Expiration dates of promo codes will be reflected in-App once You have applied the promo code to Your Account.</p>\r\n\r\n<p>7.2 If Your trip amount exceeds the redeemable credit allocated to Your journey, the balance will be automatically deducted from Your Account. Similarly, a promotional code credit only applies on a per journey basis and cannot carry over to a next journey / trip and therefore will be forfeited.</p>\r\n\r\n<p>7.3 Bolt reserves the right to cancel any promotional code at any time for any reason. This includes, but is not limited to, if Bolt deems that codes are being used in an unlawful or fraudulent manner, those issued mistakenly, and those which have expired.</p>\r\n\r\n<p><strong>8. Your content</strong></p>\r\n\r\n<p>8.1 You confirm that any text, images or any other information that You provide to Bolt whilst using the Service (&quot;User Content&quot;) will meet the Rules of Acceptable Use (as defined in clause 10 below).</p>\r\n\r\n<p>8.2 Bolt does not claim ownership in Your User Content and ownership will remain with You (or the relevant third party owner). You grant Bolt a worldwide, non-exclusive, royalty-free and perpetual licence to use, copy, reproduce, distribute, adapt, re-format, modify, publish, translate, license, sub-license, and exploit the User Content anywhere and in any form for the purposes of providing the Service (including, where applicable, allowing other users to view Your User Content).</p>\r\n\r\n<p>8.3 You must ensure that You are able to grant us the above licence for any content owned by a third party that You include in Your User Content.</p>\r\n\r\n<p>8.4 Our right to use Your User Content does not in any way affect Your privacy rights. Please see clause 9 of these Passenger Terms for further information about how we use Your personal data.</p>\r\n\r\n<p>8.5 The Services make available third party content, such as User Content. Bolt is not responsible for any such content in any way, but may monitor User Content and reject, refuse or delete any User Content where Bolt considers that it breaches any of the Rules of Acceptable Use.</p>\r\n\r\n<p><strong>9. Processing of Personal Data</strong></p>\r\n\r\n<p>9.1 For details on how Bolt and Bolt Operations collects, stores, discloses and processes Your personal data, please refer to Bolt&rsquo;s Privacy Policy: <a href=\"https://bolt.eu/en-gb/legal/gb/privacy-for-riders/\">https://bolt.eu/en-gb/legal/gb/privacy-for-riders/</a>. By using the App and the Service, You acknowledge that Your personal data will be processed in accordance with Bolt&rsquo;s Privacy Policy, available at: (<a href=\"https://bolt.eu/en-gb/legal/gb/privacy-for-riders/\">https://bolt.eu/en-gb/legal/gb/privacy-for-riders/</a>)</p>\r\n\r\n<p><strong>10. Rules of Acceptable Use</strong></p>\r\n\r\n<p>10.1 In addition to the other requirements within these Passenger Terms, this section describes specific rules that apply to Your use of the Service (the <strong>&quot;Rules of Acceptable Use&quot;</strong>).</p>\r\n\r\n<p>10.2 When using the Service (including, where relevant, during any Journey) You must not:</p>\r\n\r\n<ul>\r\n	<li>(a) circumvent, disable or otherwise interfere with any security related features of the Service;</li>\r\n	<li>(b) permit another person to use the Service on Your behalf unless such person is authorised by You;</li>\r\n	<li>(c) use the Service if Bolt has suspended or banned You from using it;</li>\r\n	<li>(d) advocate, promote or engage in any illegal or unlawful conduct or conduct that causes damage or injury to any person or property;</li>\r\n	<li>(e) modify, interfere, intercept, disrupt or hack the Service;</li>\r\n	<li>(f) misuse the Service by knowingly introducing viruses, trojans, worms, logic bombs or other material which would harm the Service or any user of the Service&rsquo;s own equipment;</li>\r\n	<li>(g) collect any data from the Service other than in accordance with these Passenger Terms;</li>\r\n	<li>(h) submit or contribute any User Content that contains nudity or violence or is abusive, threatening, obscene, misleading, untrue or offensive;</li>\r\n	<li>(i) submit or contribute any User Content that You do not own or have the right to use or otherwise infringe the copyright, trademark or other rights of third parties;</li>\r\n	<li>(j) use any User Content in violation of any licensing terms specified by the owner;</li>\r\n	<li>(k) submit or contribute any information or commentary about another person without that person&rsquo;s permission;</li>\r\n	<li>(l) threaten, abuse or invade another&rsquo;s privacy, or cause annoyance, inconvenience or needless anxiety or be likely to harass, upset, embarrass, alarm or annoy any other person; or</li>\r\n	<li>(m) use any automated system, including without limitation &ldquo;robots&rdquo;, &ldquo;spiders&rdquo; or &ldquo;offline readers&rdquo; to access the Service in a manner that sends more request messages to the Service than a human can reasonably produce in the same period of time.</li>\r\n</ul>\r\n\r\n<p>10.3 Failure to comply with Rules of Acceptable Use constitutes a serious breach of these Passenger Terms, and may result in Bolt and/or Bolt Operations taking all or any of the following actions (with or without notice):</p>\r\n\r\n<ul>\r\n	<li>(a) immediate, temporary or permanent withdrawal of Your right to use the Service;</li>\r\n	<li>(b) immediate, temporary or permanent removal of any User Content;</li>\r\n	<li>(c) issuing of a warning to You;</li>\r\n	<li>(d) legal action against You including proceedings for reimbursement of all costs (including, but not limited to, reasonable administrative and legal costs) resulting from the breach; or</li>\r\n	<li>(e) disclosure of such information to law enforcement authorities, including information about Your personal data, as Bolt and/or Bolt Operations reasonably feel is necessary or as is required (and in accordance with Bolt&rsquo;s Privacy Policy available at: (<a href=\"https://bolt.eu/en-gb/legal/gb/privacy-for-riders/\">https://bolt.eu/en-gb/legal/gb/privacy-for-riders/</a>).</li>\r\n</ul>\r\n\r\n<p>10.4 The responses described in paragraph 10.3 are not limited, and Bolt and/or Bolt Operations may take any other action Bolt and/or Bolt Operations reasonably deems appropriate or as is required. For more information, please review Bolt&rsquo;s Privacy Policy available at: (<a href=\"https://bolt.eu/en-gb/legal/gb/privacy-for-riders/\">https://bolt.eu/en-gb/legal/gb/privacy-for-riders/</a>)</p>\r\n\r\n<p><strong>11. Ending our relationship</strong></p>\r\n\r\n<p>11.1 If at any time You feel that You can no longer agree to these Passenger Terms or any changes made to the Passenger Terms or the Service, You must immediately uninstall the App and stop using the Service.</p>\r\n\r\n<p>11.2 If You would like to delete Your Account, please email Bolt at london@bolt.eu or let us know using the communication feature in the Service. Please note that in order for us to access Your data and delete Your Account, it may be required for You to first verify Your identity.</p>\r\n\r\n<p>11.3 Bolt may immediately end Your use of the Service if You breach these Passenger Terms or Bolt considers it necessary to protect the integrity of Bolt or the safety of Bolt staff or its affiliated Drivers.</p>\r\n\r\n<p>11.4 Bolt may withdraw the Service as long as Bolt gives You a reasonable notice that it plans to do this.</p>\r\n\r\n<p>11.5 If the relationship is terminated or Bolt withdraws the Service as described in this section, Bolt may delete Your User Content or any other information it holds about You. You will also lose any rights You have to use the Service or to access any content provided by us under the Service, any content provided by Drivers or Your User Content. Bolt will not offer You compensation for any resulting losses.</p>\r\n\r\n<p>11.6 The termination of Your use of the Service and the cancellation of Your Account shall not affect any of Your obligations to pay any sums due to Bolt Operations.</p>\r\n\r\n<p><strong>12. Liability</strong></p>\r\n\r\n<p>12.1 Nothing set out in these Passenger Terms limits or excludes Bolt&rsquo;s or Bolt Operations&rsquo; liability to You in relation to:</p>\r\n\r\n<ul>\r\n	<li>(a) death or personal injury arising as a result of Bolt or Bolt Operations&rsquo; negligence;</li>\r\n	<li>(b) fraud on the part of Bolt or Bolt Operations;</li>\r\n	<li>(c) any rights You have under consumer law which cannot be excluded or limited under applicable law;</li>\r\n	<li>(d) any other liability that cannot be excluded or limited under applicable law.</li>\r\n</ul>\r\n\r\n<p>12.2 All Drivers undergo verification, training and checks before they are able to be affiliated with Bolt and provide Journeys to You through the App. However, You acknowledge that riding in vehicles is inherently dangerous and Bolt (and/or any of its affiliates) has no liability or responsibility to You in relation to any Journey provided by Drivers.</p>\r\n\r\n<p>12.3 The Service, its content and functionality, are provided on an &ldquo;as is&rdquo; and &ldquo;as available&rdquo; basis, and, to the fullest extent permitted by applicable law, neither Bolt nor Bolt Operations makes any promises, whether express or implied, with respect to the Service, its content or functionality.</p>\r\n\r\n<p>12.4 Neither Bolt nor Bolt Operations and its affiliate companies makes any promise that access to the Service will be uninterrupted or error free. Neither Bolt nor Bolt Operations makes any representation, warranty or guarantee regarding the reliability, timeliness, suitability or quality of the Service.</p>\r\n\r\n<p>12.5 To the maximum extent permitted under applicable law, neither Bolt nor Bolt Operations will be liable to You in any way, whether for breach of contract, in tort (including negligence) or otherwise, for any damages, loss, costs or other liability, except to the extent that such damages, losses or costs are a foreseeable consequence of Bolt&rsquo;s failing to perform its obligations under the Passenger Terms.</p>\r\n\r\n<p>12.6 If Bolt or Bolt Operations has any liability to You whether for breach of contract, in tort (including negligence) or otherwise, in connection with these Passenger Terms, or as a result of You using the Service (including any Journey contracted for through the App), the maximum liability of Bolt or Bolt Operations (as applicable) will be &pound;250 in aggregate.</p>\r\n\r\n<p><strong>13. Resolving disputes</strong></p>\r\n\r\n<p>13.1 Should You have any dispute, conflict, claim or controversy with Bolt, Bolt Operations or any of its Affiliate Companies relating to the Service or payment processing, including disputing a Fare (&ldquo;Dispute&rdquo;), then in the first instance please contact london@bolt.eu and attempt to resolve the dispute with Bolt, Bolt Operations or any of its Affiliate Companies (as applicable) informally.</p>\r\n\r\n<p>13.2 In the unlikely event that the parties have not been able to resolve a dispute informally, Bolt will discuss and agree with You the most effective way of resolving the dispute and, as a last resort, any Dispute shall be finally resolved in the courts of England.</p>\r\n\r\n<p><strong>14. Contact, feedback and complaints</strong></p>\r\n\r\n<p>14.1 If You need to contact Bolt or Bolt Operations in relation to these Passenger Terms or any other document mentioned in them, You can contact Bolt and Bolt Operations at the support centre by emailing london@bolt.eu</p>\r\n\r\n<p>14.2 Bolt values hearing from its users, and is always interested in learning about ways Bolt can improve the Service. By providing Your feedback You agree that You are giving up any rights You have in Your feedback so that Bolt may use and allow others to use it without any restriction and without any payment to You.</p>\r\n\r\n<p><strong>15. Final Provisions</strong></p>\r\n\r\n<p>15.1 English law will apply to all disputes and the interpretation of these Passenger Terms. The English courts will have non-exclusive jurisdiction over any dispute arising from or related to Your use of the Service.</p>\r\n\r\n<p>15.2 If any provision of these Passenger Terms is held to be unenforceable, the parties shall substitute for the affected provision an enforceable provision that approximates the intent and economic effect of the affected provision. The failure or delay by either party to enforce any term of the Passenger Terms shall not be deemed a waiver of such term.</p>\r\n\r\n<p>15.3 In order to ensure that Bolt is a market leader, it is constantly updating and improving the Service. This may include updating or deleting certain elements of the Service and this may impact on Your use of the Service or Your User Content. If Bolt make any changes to the Service, Your continued use will be deemed acceptance of the changes. You may stop using the Service at any time.</p>\r\n\r\n<p>15.4 Bolt may from time to time also amend these Passenger Terms. Bolt will normally notify You in advance before the new Passenger Terms become effective. Your continued use of the Service after the revised terms become effective will be deemed acceptance of the terms.</p>\r\n\r\n<p>15.5 No provision of these Passenger Terms is enforceable under the Contracts (Rights to Third Parties) Act 1999 by a person who is not a party to these Passenger Terms.</p>\r\n\r\n<p>15.6 Date of entry into force of the General Terms and Conditions: 10.06.2019</p>\r\n\r\n<p>&nbsp;</p>\r\n'),(5,'cancel','<p>Cancelation Policy</p>'),(6,'home','<!-- ====== Section divider ====== -->\r\n<p>home pages</p>\r\n<!-- /.app-mokeup --><!-- /.col-md-6 --><!-- /.row --><!-- /.container --><!-- /.container-large-device --><!-- /.app-block -->');

--
-- Table structure for table `user_request_disputes`
--

CREATE TABLE `user_request_disputes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int NOT NULL,
  `dispute_type` enum('user','provider') COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `provider_id` int NOT NULL,
  `dispute_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `dispute_title` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `refund_amount` double(10,2) NOT NULL DEFAULT '0.00',
  `status` enum('open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'open',
  `is_admin` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_request_disputes`
--


--
-- Table structure for table `user_request_lost_items`
--

CREATE TABLE `user_request_lost_items` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int NOT NULL,
  `parent_id` int DEFAULT NULL,
  `user_id` int NOT NULL,
  `lost_item_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `comments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `comments_by` enum('user','admin') COLLATE utf8_unicode_ci NOT NULL,
  `status` enum('open','closed') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'open',
  `is_admin` tinyint NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_request_lost_items`
--


--
-- Table structure for table `user_request_payments`
--

CREATE TABLE `user_request_payments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int NOT NULL,
  `user_id` int NOT NULL,
  `provider_id` int NOT NULL,
  `fleet_id` int DEFAULT NULL,
  `promocode_id` int DEFAULT NULL,
  `payment_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_mode` varchar(255) COLLATE utf8_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_per` double(5,2) NOT NULL DEFAULT '0.00',
  `fleet` double(10,2) NOT NULL DEFAULT '0.00',
  `fleet_per` double(5,2) NOT NULL DEFAULT '0.00',
  `discount` double(10,2) NOT NULL DEFAULT '0.00',
  `discount_per` double(5,2) NOT NULL DEFAULT '0.00',
  `tax` double(10,2) NOT NULL DEFAULT '0.00',
  `tax_per` double(5,2) NOT NULL DEFAULT '0.00',
  `wallet` double(10,2) NOT NULL DEFAULT '0.00',
  `is_partial` tinyint NOT NULL DEFAULT '0' COMMENT '0-No,1-Yes',
  `cash` double(10,2) NOT NULL DEFAULT '0.00',
  `card` double(10,2) NOT NULL DEFAULT '0.00',
  `online` double(10,2) NOT NULL DEFAULT '0.00',
  `surge` 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',
  `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 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',
  `total` double(10,2) NOT NULL DEFAULT '0.00',
  `payable` double(8,2) NOT NULL DEFAULT '0.00',
  `provider_commission` double(8,2) NOT NULL DEFAULT '0.00',
  `provider_pay` double(8,2) NOT NULL DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_request_payments`
--

INSERT INTO `user_request_payments` VALUES (1,1,103,103,0,NULL,NULL,'CASH',20.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,20.00,0.00,0.00,0.00,0.00,0.00,0.00,0.00,0,0.00,0.00,0.00,20.00,0.00,0.00,20.00,'2021-09-10 12:06:55','2021-09-10 12:07:17');

--
-- Table structure for table `user_request_ratings`
--

CREATE TABLE `user_request_ratings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `request_id` int NOT NULL,
  `user_id` int NOT NULL,
  `provider_id` int NOT NULL,
  `user_rating` int NOT NULL DEFAULT '0',
  `provider_rating` int NOT NULL DEFAULT '0',
  `user_comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `provider_comment` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_request_ratings`
--

INSERT INTO `user_request_ratings` VALUES (1,1,103,103,5,5,'','','2021-09-10 12:07:24','2021-09-10 12:07:29');

--
-- Table structure for table `user_requests`
--

CREATE TABLE `user_requests` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `booking_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `braintree_nonce` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `provider_id` int NOT NULL DEFAULT '0',
  `current_provider_id` int NOT NULL,
  `service_type_id` int NOT NULL,
  `promocode_id` int NOT NULL,
  `rental_hours` int DEFAULT NULL,
  `status` enum('SEARCHING','CANCELLED','ACCEPTED','STARTED','ARRIVED','PICKEDUP','DROPPED','COMPLETED','SCHEDULED') COLLATE utf8_unicode_ci NOT NULL,
  `cancelled_by` enum('NONE','USER','PROVIDER') COLLATE utf8_unicode_ci NOT NULL,
  `cancel_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `payment_mode` enum('BRAINTREE','CASH','CARD','PAYPAL','PAYPAL-ADAPTIVE','PAYUMONEY','PAYTM','WALLET') COLLATE utf8_unicode_ci NOT NULL,
  `paid` tinyint(1) NOT NULL DEFAULT '0',
  `is_track` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  `distance` double(15,8) NOT NULL,
  `travel_time` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unit` enum('Kms','Miles') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'Kms',
  `otp` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `s_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `s_latitude` double(15,8) NOT NULL,
  `s_longitude` double(15,8) NOT NULL,
  `d_address` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `d_latitude` double(15,8) DEFAULT NULL,
  `d_longitude` double(15,8) DEFAULT NULL,
  `track_distance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `track_latitude` double(15,8) NOT NULL DEFAULT '0.00000000',
  `track_longitude` double(15,8) NOT NULL DEFAULT '0.00000000',
  `destination_log` longtext COLLATE utf8_unicode_ci,
  `is_drop_location` tinyint(1) NOT NULL DEFAULT '1',
  `is_instant_ride` tinyint(1) NOT NULL DEFAULT '0',
  `is_dispute` tinyint(1) NOT NULL DEFAULT '0',
  `assigned_at` timestamp NULL DEFAULT NULL,
  `schedule_at` timestamp NULL DEFAULT NULL,
  `started_at` timestamp NULL DEFAULT NULL,
  `finished_at` timestamp NULL DEFAULT NULL,
  `is_scheduled` enum('YES','NO') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NO',
  `user_rated` tinyint(1) NOT NULL DEFAULT '0',
  `provider_rated` tinyint(1) NOT NULL DEFAULT '0',
  `use_wallet` tinyint(1) NOT NULL DEFAULT '0',
  `surge` tinyint(1) NOT NULL DEFAULT '0',
  `route_key` longtext COLLATE utf8_unicode_ci NOT NULL,
  `nonce` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `geo_fencing_id` int NOT NULL,
  `geo_fencing_distance` double(8,2) NOT NULL,
  `geo_time` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `fare` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `is_manual` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_requests`
--

INSERT INTO `user_requests` VALUES (1,'OPA508474',103,NULL,103,103,1,0,NULL,'COMPLETED','NONE',NULL,'CASH',1,'YES',0.00000000,'0','Kms','2560','Sector 10, Budanpur, Panchkula, Haryana, India',30.68988130,76.84836770,'9, Shiv Nagar, Peer Muchalla, Zirakpur, Punjab 140603, India',30.66711749,76.86467708,3160.00000000,30.66711749,30.66711749,'[{\"latitude\":\"30.684933\",\"longitude\":\"76.8389413\",\"address\":\"Sector 15, Panchkula, Haryana, India\"}]',1,0,0,'2021-09-10 12:04:42',NULL,'2021-09-10 12:06:18','2021-09-10 12:06:55','NO',1,1,0,0,'}hvuF|umqO',NULL,2,0.00,'',NULL,'2021-09-10 12:04:43','2021-09-10 12:07:29','30.0',0);

--
-- Table structure for table `user_wallet`
--

CREATE TABLE `user_wallet` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `transaction_id` int NOT NULL,
  `transaction_alias` varchar(25) COLLATE utf8_unicode_ci DEFAULT NULL,
  `transaction_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('C','D') COLLATE utf8_unicode_ci NOT NULL,
  `amount` double(15,8) NOT NULL DEFAULT '0.00000000',
  `open_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `close_balance` double(15,8) NOT NULL DEFAULT '0.00000000',
  `payment_mode` enum('BRAINTREE','CARD','PAYPAL','PAYUMONEY','PAYTM') COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_wallet`
--


--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `payment_mode` enum('BRAINTREE','CASH','CARD','PAYPAL','PAYPAL-ADAPTIVE','PAYUMONEY','PAYTM') COLLATE utf8_unicode_ci NOT NULL,
  `user_type` enum('INSTANT','NORMAL') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'NORMAL',
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `gender` enum('MALE','FEMALE') COLLATE utf8_unicode_ci NOT NULL DEFAULT 'MALE',
  `country_code` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `picture` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `device_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `device_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `device_type` enum('android','ios') COLLATE utf8_unicode_ci NOT NULL,
  `login_by` enum('manual','facebook','google') COLLATE utf8_unicode_ci NOT NULL,
  `social_unique_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `latitude` double(15,8) DEFAULT NULL,
  `longitude` double(15,8) DEFAULT NULL,
  `stripe_cust_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `wallet_balance` double(8,2) NOT NULL DEFAULT '0.00',
  `rating` decimal(4,2) NOT NULL DEFAULT '5.00',
  `otp` mediumint NOT NULL DEFAULT '0',
  `language` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `qrcode_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `referral_unique_id` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `referal_count` mediumint NOT NULL DEFAULT '0',
  `remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_mobile_unique` (`mobile`)
) ENGINE=InnoDB AUTO_INCREMENT=105 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` VALUES (103,'Mohit','Jain','CASH','NORMAL','mohitjain0206@gmail.com','MALE','+91','9876479350','$2y$10$gc0HS1V.04flgB16rwTwt.NqHiv1i19.NUP16ntw4gqVzjYbvnGRy',NULL,'e86G5iUSnKg:APA91bFEjJnjS6_W8Bk7elU_B4oWK1d1TsTlKrw6BD8kxzwzmForkJ0dyEUW1nAIZPrbcme6SKK6qaP1_PEv0iIGpw3op35cSksA3LDakzHEO0Om1VgiQfcwM8OwrL9tzK9iuPAt6Ln2','a095a99573ad9bbf','android','manual',NULL,NULL,NULL,NULL,0.00,5.00,0,NULL,'uploads/1631188938969991697_9876479350.png','6ED0B9',0,NULL,'2021-09-09 16:02:18','2021-09-11 18:57:21'),(104,'Imeda','Darsalia','CASH','NORMAL','opadelivery@gmail.com','MALE','+995','599887444','$2y$10$zD.PEoumgnoDs8Fq3dlF7.1i4TtWsxuGjLsIDDWWp4E/f68Yzhf62','user/profile/6d64JgeQ0cvkzUoY92f3JW401Zt4OfDzi7j0PGII.png','dt9dayrnlX8:APA91bE1bzGPtnvPbu5DS5hDUZNTc6iEAR-2Bk_0LSAeo5-DGcCMuecDrPSNsccR5svS_XPFACiY75tkmwHkNUIiuAMFOkAKmqVxWGDrLGibi47EMQHuaxoZFb3BXGMlIlW30Ahfa91n','d4052c67761b0511','android','manual',NULL,NULL,NULL,NULL,0.00,5.00,0,NULL,'uploads/163118942734786725_599887444.png',NULL,0,NULL,'2021-09-09 16:09:36','2021-09-09 16:43:03');

--
-- Table structure for table `wallet_passbooks`
--

CREATE TABLE `wallet_passbooks` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `amount` int NOT NULL,
  `status` enum('CREDITED','DEBITED') COLLATE utf8_unicode_ci NOT NULL,
  `via` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `wallet_passbooks`
--


--
-- Table structure for table `wallet_requests`
--

CREATE TABLE `wallet_requests` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `alias_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `request_from` varchar(255) COLLATE utf8_unicode_ci NOT NULL COMMENT 'user,provider,fleet',
  `from_id` int NOT NULL,
  `from_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` enum('C','D') COLLATE utf8_unicode_ci NOT NULL,
  `amount` double(15,8) NOT NULL DEFAULT '0.00000000',
  `send_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'online,offline',
  `send_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `status` tinyint NOT NULL DEFAULT '0' COMMENT '0-Pendig,1-Approved,2-cancel',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `wallet_requests`
--


--
-- Table structure for table `works`
--

CREATE TABLE `works` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `age` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `work` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `works`
--



