--
-- 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 `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 `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_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 `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`
--



--
-- 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_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 `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`
--



--
-- 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_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 `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`
--



