File: /var/www/html/punjabcabs/DB/punjabcf_pun___31012020.sql
-- phpMyAdmin SQL Dump
-- version 4.9.0.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Feb 03, 2020 at 12:58 AM
-- Server version: 5.6.45
-- PHP Version: 7.3.6
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `punjabcf_pun`
--
-- --------------------------------------------------------
--
-- Table structure for table `accounts`
--
CREATE TABLE `accounts` (
`id` int(10) UNSIGNED NOT NULL,
`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,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `accounts`
--
INSERT INTO `accounts` (`id`, `name`, `email`, `mobile`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Love Deep', 'lovedeep79@hotmail.com', '65464653165', '$2y$10$VQbI8tIEw9uZlJpJ7BKJD.mMBfhlrJOybCkyBxKGcDjwA5sGtK0ri', 'CzqB8b0wUcTPDY0KmhMnWZ5uj6XO3JBhmkJLSCZLtEmDIenZEPrAzEEDTGiU', NULL, '2019-11-22 18:26:57');
-- --------------------------------------------------------
--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `admins`
--
CREATE TABLE `admins` (
`id` int(10) UNSIGNED NOT NULL,
`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,
`picture` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `admins`
--
INSERT INTO `admins` (`id`, `name`, `email`, `password`, `picture`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Punjab Cabs', 'lovedeep79@hotmail.com', '$2y$10$cHmoMQk10KEmNszlDKx/Eel6giQX/6WdEJvYm7CN9XBhr3XkblYmK', NULL, 'pYxMdKEJYJViyHLHTusokDDtOvjkucwOpWT58FI00j4ESDe26BWPrAQqil3q', NULL, '2020-01-28 04:23:01');
-- --------------------------------------------------------
--
-- Table structure for table `cards`
--
CREATE TABLE `cards` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(11) 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(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `cards`
--
INSERT INTO `cards` (`id`, `user_id`, `last_four`, `card_id`, `brand`, `is_default`, `created_at`, `updated_at`) VALUES
(1, 3, '4242', 'card_1Fc82kAl0EMC1rAv6b1Rt8g5', 'Visa', 0, '2019-11-07 21:16:49', '2019-11-11 18:53:00'),
(2, 3, '1111', 'card_1FcQ09Al0EMC1rAv3SW7gbx3', 'Visa', 1, '2019-11-08 16:27:19', '2019-11-11 18:53:00'),
(3, 6, '4242', 'card_1FcS29Al0EMC1rAvDOLvm6ZO', 'Visa', 1, '2019-11-08 18:37:31', '2019-11-15 18:20:17'),
(4, 6, '1111', 'card_1FdbTeAl0EMC1rAvQKpOLEv8', 'Visa', 0, '2019-11-11 22:54:42', '2019-11-15 18:20:17');
-- --------------------------------------------------------
--
-- Table structure for table `chats`
--
CREATE TABLE `chats` (
`id` int(10) UNSIGNED NOT NULL,
`request_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`provider_id` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `complaints`
--
CREATE TABLE `complaints` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`complaint_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`complaint_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `complaints`
--
INSERT INTO `complaints` (`id`, `name`, `email`, `phone`, `complaint_type`, `complaint_desc`, `created_at`, `updated_at`) VALUES
(1, 'Felix', 'felix@ngfot.com', '+919943396622', 'Driver behaviour', 'worest', '2019-11-11 23:02:58', '2019-11-11 23:02:58'),
(2, 'Felix', 'felix@ngfot.com', '+919943396622', 'Driver driving skills', 'test\n', '2019-11-15 18:00:45', '2019-11-15 18:00:45'),
(3, 'Felix', 'felix@ngfot.com', '+919943396622', NULL, 'uhhhh\n', '2019-11-15 18:30:26', '2019-11-15 18:30:26'),
(4, 'Felix', 'felix@ngfot.com', '+919943396622', NULL, 'gtbthth ', '2019-11-15 18:30:55', '2019-11-15 18:30:55'),
(5, 'Felix', 'felix@ngfot.com', '+919943396622', NULL, 'bhh', '2019-11-15 18:31:52', '2019-11-15 18:31:52');
-- --------------------------------------------------------
--
-- Table structure for table `contact_lists`
--
CREATE TABLE `contact_lists` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`contact_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`contact_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `contact_lists`
--
INSERT INTO `contact_lists` (`id`, `user_id`, `contact_name`, `contact_number`, `created_at`, `updated_at`) VALUES
(1, 6, 'Distress Number', '112', '2019-11-11 23:03:16', '2019-11-11 23:03:16');
-- --------------------------------------------------------
--
-- Table structure for table `dispatchers`
--
CREATE TABLE `dispatchers` (
`id` int(10) UNSIGNED NOT NULL,
`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,
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `dispatchers`
--
INSERT INTO `dispatchers` (`id`, `name`, `email`, `mobile`, `password`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Punjab Cabs', 'lovedeep79@hotmail.com', '6541616165', '$2y$10$QZ87CQeGdOYuIDN1LSWz9.iWMEn1bo/4M2DTOHdnf5G3PJ04/CA9y', 'ZFR8LYkrZgerX6vnhd7rK44dSf4WnhozRbh9VwxfPruUVCNO1kklnDncDno0', NULL, '2019-11-22 18:24:15');
-- --------------------------------------------------------
--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `documents`
--
CREATE TABLE `documents` (
`id` int(10) UNSIGNED NOT NULL,
`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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `documents`
--
INSERT INTO `documents` (`id`, `name`, `type`, `created_at`, `updated_at`) VALUES
(1, 'Driving license', 'DRIVER', NULL, NULL),
(2, 'Ciertificate of registration', 'VEHICLE', NULL, NULL),
(3, 'Insurance coc', 'VEHICLE', NULL, NULL),
(4, 'Driver certificate/card', 'DRIVER', NULL, NULL),
(5, 'Vehcile taxi/hire car certificate', 'VEHICLE', NULL, NULL),
(6, 'Vehicle photo', 'VEHICLE', NULL, NULL),
(7, 'Vehicle photo', 'VEHICLE', NULL, NULL),
(8, 'Rwc Certificate', 'DRIVER', NULL, NULL);
-- --------------------------------------------------------
--
-- Table structure for table `fleets`
--
CREATE TABLE `fleets` (
`id` int(10) UNSIGNED NOT NULL,
`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,
`fleet_percentage` int(11) NOT NULL DEFAULT '0',
`logo` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `fleets`
--
INSERT INTO `fleets` (`id`, `name`, `email`, `password`, `company`, `mobile`, `fleet_percentage`, `logo`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Love Deep', 'lovedeep79@hotmail.com', '$2y$10$5YBybh8PZqdwOgzMZ2924emnTjwThZ92PEZQu/VUn6pH/kzFfuTce', 'Punjab Cabs', '6495641155', 0, NULL, 'xwDSFrv93eTJ4bgwzCHRGfztUE48ahNBqlPlSD1t60HVNEpBIsSzrpr9cBtr', NULL, '2019-11-22 18:29:11');
-- --------------------------------------------------------
--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `ltm_translations`
--
CREATE TABLE `ltm_translations` (
`id` int(10) UNSIGNED NOT NULL,
`status` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `migrations`
--
CREATE TABLE `migrations` (
`id` int(10) UNSIGNED NOT NULL,
`migration` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `migrations`
--
INSERT INTO `migrations` (`id`, `migration`, `batch`) 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, '2017_01_11_180503_create_admins_table', 1),
(11, '2017_01_11_180511_create_providers_table', 1),
(12, '2017_01_11_181312_create_cards_table', 1),
(13, '2017_01_11_181357_create_chats_table', 1),
(14, '2017_01_11_181558_create_promocodes_table', 1),
(15, '2017_01_11_182454_create_provider_documents_table', 1),
(16, '2017_01_11_182536_create_provider_services_table', 1),
(17, '2017_01_11_182649_create_user_requests_table', 1),
(18, '2017_01_11_182717_create_request_filters_table', 1),
(19, '2017_01_11_182738_create_service_types_table', 1),
(20, '2017_01_25_172422_create_documents_table', 1),
(21, '2017_01_31_122021_create_provider_devices_table', 1),
(22, '2017_02_02_192703_create_user_request_ratings_table', 1),
(23, '2017_02_06_080124_create_user_request_payments_table', 1),
(24, '2017_02_14_135859_create_provider_profiles_table', 1),
(25, '2017_02_21_131429_create_promocode_usages_table', 1),
(26, '2017_06_17_151030_create_dispatchers_table', 1),
(27, '2017_06_17_151031_create_dispatcher_password_resets_table', 1),
(28, '2017_06_17_151145_create_fleets_table', 1),
(29, '2017_06_17_151146_create_fleet_password_resets_table', 1),
(30, '2017_06_20_154148_create_accounts_table', 1),
(31, '2017_06_20_154149_create_account_password_resets_table', 1),
(32, '2018_05_08_172850_create_smsnotification_table', 1),
(33, '2018_10_11_120734_create_contact_lists_table', 1),
(34, '2019_01_02_153531_create_provider_applications_table', 1),
(35, '2019_01_11_152858_create_waypoints_table', 1),
(36, '2019_03_18_105812_create_complaints_table', 1),
(37, '2019_03_20_103227_create_provider_contacts_table', 1);
-- --------------------------------------------------------
--
-- Table structure for table `oauth_access_tokens`
--
CREATE TABLE `oauth_access_tokens` (
`id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`user_id` int(11) DEFAULT NULL,
`client_id` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `oauth_access_tokens`
--
INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('01eec40c1c64dc4459e410e7d597b30246b7d878e1e04b7d965b4346e3bc3733be4f8239f21f4e3e', 5, 1, 'socialLogin', '[]', 0, '2019-11-11 17:20:56', '2019-11-11 17:20:56', '2029-11-11 17:20:56'),
('0cc9332c0183263c058d863b16d767180c2a92ea41b8c26a4717e47b61596e49350c3e88fbbfb68d', 5, 1, 'socialLogin', '[]', 0, '2019-12-02 21:23:56', '2019-12-02 21:23:56', '2029-12-02 21:23:56'),
('0cd6281dae7adc6e84a04485132bbc549011df3403a2f5e26abddf86a97667f463296408c1056037', 5, 1, 'socialLogin', '[]', 0, '2019-11-08 21:52:46', '2019-11-08 21:52:46', '2029-11-08 21:52:46'),
('15b4870fa661753fdc7d150a7281dc3aa847d05e63d1181214605874577c6527f4ba2b8d51777a4f', 6, 2, NULL, '[]', 1, '2019-11-11 23:01:11', '2019-11-11 23:01:11', '2019-11-26 23:01:11'),
('1b5cb4ac4df6970993dcc50f126fa30f9a170f6a7f0ca9425d0776540b767fc239b34a4105a767bc', 5, 1, 'socialLogin', '[]', 0, '2019-11-08 21:51:14', '2019-11-08 21:51:14', '2029-11-08 21:51:14'),
('1cba32c9fe5d862e852b6a6961cd9019a08ed9c0bf9377ecd2f089d484738a296de7c34e1cf4a255', 6, 2, NULL, '[]', 0, '2019-11-11 22:48:29', '2019-11-11 22:48:29', '2019-11-26 22:48:29'),
('1ce32bc561403b1c714ec196830e85085bc87057054d65219083fc5d5dc2d17223951dfb12329b22', 6, 2, NULL, '[]', 0, '2019-11-08 18:37:05', '2019-11-08 18:37:05', '2019-11-23 18:37:05'),
('239c17d3a3a73fbd30f03dfb55cab4024047b5307b4b59ecab053cedd3c43845985ed6a6c3287fa3', 5, 1, 'socialLogin', '[]', 0, '2019-11-11 16:23:06', '2019-11-11 16:23:06', '2029-11-11 16:23:06'),
('29b38c52a4e1bd254195823ef878ccb55a9c326c76168aaaf6fc537f4c97ef77024e1d1c114f0781', 3, 2, NULL, '[]', 0, '2019-11-08 17:28:26', '2019-11-08 17:28:26', '2019-11-23 17:28:26'),
('2a40b47f1409a3cdf9b8dc8e3536941481bc24b79f4df55d0cb17791ca694f26dadf76c5f9235811', 3, 2, NULL, '[]', 0, '2019-11-14 00:50:01', '2019-11-14 00:50:01', '2019-11-29 00:50:01'),
('2f26348d9486025710694a50628803287e2b3c08e18a44a9d66c84b35bb417ec58ff9f5bd7731ddf', 3, 2, NULL, '[]', 0, '2019-11-08 18:05:43', '2019-11-08 18:05:43', '2019-11-23 18:05:43'),
('32057ef3057d3637993dfcfb48b35fd519d7cc8c2765054eaa7d2e5ed0eacb691196ca9878d32962', 5, 1, 'socialLogin', '[]', 0, '2019-11-08 16:28:59', '2019-11-08 16:28:59', '2029-11-08 16:28:59'),
('326da3ae5c5802cf1ba4fc90db3de22c36f5aba88e1ad587858407fcf4525b11de229ddfe7ae63c2', 3, 2, NULL, '[]', 0, '2019-11-08 18:47:49', '2019-11-08 18:47:49', '2019-11-23 18:47:49'),
('3951b4945c8b8e42a5d950d7d08373499871111dc23142e0e639f5c4acf1c16b3d3135466b6509ce', 14, 2, NULL, '[]', 0, '2019-12-31 05:38:23', '2019-12-31 05:38:23', '2020-01-15 05:38:23'),
('4830627c6fb35ea0a6c0f4a6ca723f092ff9452f9c635b987916f5118eccb08f2b2b335bc421e15c', 9, 1, 'socialLogin', '[]', 0, '2019-11-11 16:48:46', '2019-11-11 16:48:46', '2029-11-11 16:48:46'),
('4aeade6a1ac2789f3f07b88d992185556d9fb594a8c138a6a69745f6aa480239926658a9c0e353c4', 5, 1, 'socialLogin', '[]', 0, '2019-11-11 17:16:33', '2019-11-11 17:16:33', '2029-11-11 17:16:33'),
('4eda7cf71c25f67af1a084d93df824888fe8eb59899031e6477d61d4989be2edf00039bc1ff17c9d', 7, 1, 'socialLogin', '[]', 0, '2019-11-13 16:40:54', '2019-11-13 16:40:54', '2029-11-13 16:40:54'),
('50f56b6d3436a892e47c9e19e80289a48e864639288088e373f825458416bcc7a05c68538e7a6df0', 3, 2, NULL, '[]', 0, '2019-11-08 00:49:51', '2019-11-08 00:49:51', '2019-11-23 00:49:51'),
('51942a8705527bf31483058dd7dc131bc8de265ae5c6a38baa55409bf2651926f547112daf02054f', 9, 1, 'socialLogin', '[]', 0, '2019-11-11 17:06:24', '2019-11-11 17:06:24', '2029-11-11 17:06:24'),
('564a36ff83d42a21f305383641ee5b989c9e4aa34da79d97b01efd7ddcd2e42fea138d0e3a6aa368', 3, 2, NULL, '[]', 0, '2019-11-15 01:02:28', '2019-11-15 01:02:28', '2019-11-30 01:02:28'),
('570586a29874fc59cdfc53482716d054ca0e7ae40d28b6016ffa16eeb9fe28905582e62bf6216ac2', 3, 2, NULL, '[]', 0, '2019-11-07 23:14:11', '2019-11-07 23:14:11', '2019-11-22 23:14:11'),
('583ee2b5e2bf35537ade0a5a712b5e0ed9bdec63b7362afe0f186b38953ad2f31b7962990d75e081', 3, 2, NULL, '[]', 0, '2019-11-07 21:15:55', '2019-11-07 21:15:55', '2019-11-22 21:15:55'),
('5cd336fd8756e8dd9280f8262cf1528177585b49be1ad034981fcfe097c7c111a73753cb194a8683', 6, 2, NULL, '[]', 0, '2019-11-11 22:55:25', '2019-11-11 22:55:25', '2019-11-26 22:55:25'),
('613806eb58fa1d4ae1de101a181284ac726b72ec5af240ed3507c2cc7ed628f8377d8c01a6619197', 3, 2, NULL, '[]', 0, '2019-11-07 20:49:30', '2019-11-07 20:49:30', '2019-11-22 20:49:30'),
('6529c7d0b4067fe85e8988e65693eeff08ffc99a3af1d4e2b795313af2868b30d1023cf716c3c277', 6, 2, NULL, '[]', 0, '2019-11-30 01:00:15', '2019-11-30 01:00:15', '2019-12-15 01:00:15'),
('659deb017dd86d061e80db42d3446d894b27c6f13d44af2ff186a405aa5983bae372e5138280555e', 14, 2, NULL, '[]', 1, '2019-11-29 11:45:03', '2019-11-29 11:45:03', '2019-12-14 11:45:03'),
('7e6f8c69690fd132779c202306781dbabff056c0be573f6a4685d0e08b1c173dde2915a1e28b57c0', 5, 1, 'socialLogin', '[]', 0, '2019-11-11 17:21:43', '2019-11-11 17:21:43', '2029-11-11 17:21:43'),
('9896fc4fc311d3fece8c25425a1369a58ef5a6e38b323cffa774c559df320020616802dd919ce816', 6, 2, NULL, '[]', 0, '2019-11-08 18:52:13', '2019-11-08 18:52:13', '2019-11-23 18:52:13'),
('9a094d216cb37527504174f7b0fb7372357d104b8581acbd0a19911db6410a8196589c30306a2cf8', 6, 2, NULL, '[]', 0, '2019-11-12 00:37:17', '2019-11-12 00:37:17', '2019-11-27 00:37:17'),
('9c15350c1b71f5cb935f4d31b35bbaf5e6ed8982f140d4e99c891cfb346d851e6af30d7d5b19ede7', 16, 2, NULL, '[]', 0, '2019-12-28 11:25:06', '2019-12-28 11:25:06', '2020-01-12 11:25:06'),
('9e6dbb29866aa3dd52d635038c5ea4e351f1c99451a6770b8e7174f73aacd4eb062b8116c5c208e2', 7, 1, 'socialLogin', '[]', 0, '2019-11-08 21:00:40', '2019-11-08 21:00:40', '2029-11-08 21:00:40'),
('9ec08fa8bae0af387ed44f3829ec3e616572cb58e7ef1b0a09fa8095399d551abaa1c4eb52abefb6', 3, 2, NULL, '[]', 0, '2019-11-07 23:40:05', '2019-11-07 23:40:05', '2019-11-22 23:40:05'),
('a24f56608f7f016732d69f95582aa91b04cf3ca07e8640bdd0e3e29e401c2ebb0108f5d515fe5ca2', 5, 1, 'socialLogin', '[]', 0, '2019-11-11 17:15:33', '2019-11-11 17:15:33', '2029-11-11 17:15:33'),
('a928f0df374271400e6202881a14f2d227ef2a37d10c182fbfe7bd8fc4e1700f6beb0e5fe4eff1d1', 6, 2, NULL, '[]', 1, '2019-11-30 01:00:13', '2019-11-30 01:00:13', '2019-12-15 01:00:13'),
('b8ee6a3158e5f66d5cf02f25c023023f3cb135f5737de00e86d5299092b3478c3dd12551a4f79287', 5, 1, 'socialLogin', '[]', 0, '2019-11-11 17:22:53', '2019-11-11 17:22:53', '2029-11-11 17:22:53'),
('bc76725a3ad86538bd3c05f0febd22dcb01dc7cbafa183b5c9f35ffb36b653d467436600b43bc56b', 6, 2, NULL, '[]', 1, '2019-11-30 00:47:32', '2019-11-30 00:47:32', '2019-12-15 00:47:31'),
('cbff3254c394fe4eaab982f6e6b2a2edad80d1bb7802a0e85196cf6ef03c5baf6ea54588ccc78672', 3, 2, NULL, '[]', 0, '2019-11-08 18:22:20', '2019-11-08 18:22:20', '2019-11-23 18:22:20'),
('cf49434c9d0346f9f7e7c93deefc0cb860120d75aa42708cea857f217ee51df41438d183ce437c9d', 5, 1, 'socialLogin', '[]', 0, '2019-11-11 17:16:33', '2019-11-11 17:16:33', '2029-11-11 17:16:33'),
('da461acb4a5122311ee52b254d824ca491e47c9ce3aee4a2e61b078607adfa336ea72e4df8901807', 14, 2, NULL, '[]', 1, '2019-12-31 05:38:23', '2019-12-31 05:38:23', '2020-01-15 05:38:23'),
('e12934e925d562c3dfe4a107c99d54d6ed907425d0464d947b309dda569881b9526c8ec531df209b', 9, 1, 'socialLogin', '[]', 0, '2019-11-11 22:40:22', '2019-11-11 22:40:22', '2029-11-11 22:40:22'),
('e46db7d376651791f861b460e184a73212da8c8c0e454eb25a38f5e404321997e88aafe79d4047e4', 8, 1, 'socialLogin', '[]', 0, '2019-11-13 16:43:42', '2019-11-13 16:43:42', '2029-11-13 16:43:42'),
('ece834fb36aba53ab0fe96ff10b0783787943f217c93792d51709036be5f3eebc0c0278e114a8cb4', 7, 1, 'socialLogin', '[]', 0, '2019-11-13 16:45:16', '2019-11-13 16:45:16', '2029-11-13 16:45:16'),
('ef7468f5774d0794d07e5a1ba4fa5d8925219970147b142938fc0e334be8faa5b2dc7c398e71b952', 6, 2, NULL, '[]', 0, '2019-12-26 18:14:52', '2019-12-26 18:14:52', '2020-01-10 18:14:52'),
('f08f39c8a49a1269b022c0bfce5f41d1da929ad647cd430e5a45ed3f675e32b5808e6bcc20c5bbd9', 6, 2, NULL, '[]', 0, '2019-11-08 17:27:00', '2019-11-08 17:27:00', '2019-11-23 17:27:00'),
('f80c2212a4840b51e650700fa1d90dc2b787b02d56cc166fdf101080294ea406732dc1a01888f3d0', 3, 2, NULL, '[]', 0, '2019-11-29 16:45:18', '2019-11-29 16:45:18', '2019-12-14 16:45:18'),
('fd1296b4a44bbab4aa1b14516be3f6ed38b5cca316b35b8b5511c7ec3b030fee56666f6b26d2dc85', 3, 2, NULL, '[]', 1, '2019-11-12 00:41:08', '2019-11-12 00:41:08', '2019-11-27 00:41:08');
-- --------------------------------------------------------
--
-- Table structure for table `oauth_auth_codes`
--
CREATE TABLE `oauth_auth_codes` (
`id` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`user_id` int(11) NOT NULL,
`client_id` int(11) NOT NULL,
`scopes` text COLLATE utf8_unicode_ci,
`revoked` tinyint(1) NOT NULL,
`expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `oauth_clients`
--
CREATE TABLE `oauth_clients` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `oauth_clients`
--
INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Pubjab Cabs Personal Access Client', 'GLHIUfFpad8MRpExiGLmEF9GKAgTXjz1Ys6DlLpk', 'http://localhost', 1, 0, 0, '2019-11-06 00:50:24', '2019-11-06 00:50:24'),
(2, NULL, 'Pubjab Cabs Password Grant Client', 'A4j34fK1UFQipdllydc5K7t2S3Htud1aEW8FqMnM', 'http://localhost', 0, 1, 0, '2019-11-06 00:50:24', '2019-11-06 00:50:24');
-- --------------------------------------------------------
--
-- Table structure for table `oauth_personal_access_clients`
--
CREATE TABLE `oauth_personal_access_clients` (
`id` int(10) UNSIGNED NOT NULL,
`client_id` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `oauth_personal_access_clients`
--
INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2019-11-06 00:50:24', '2019-11-06 00:50:24');
-- --------------------------------------------------------
--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `oauth_refresh_tokens`
--
INSERT INTO `oauth_refresh_tokens` (`id`, `access_token_id`, `revoked`, `expires_at`) VALUES
('06e0894d4d70f72491a0d8ae2443e2f655f284d9a41fdda5a59e6696175fa3d69f8bfa847084ff88', '570586a29874fc59cdfc53482716d054ca0e7ae40d28b6016ffa16eeb9fe28905582e62bf6216ac2', 0, '2020-02-05 23:14:11'),
('0e44c6cd474bd2d7d2aeba50292a5b8ca0350341ae7b37051be50e4cff781a6b1b1eba9deac6ee9e', '2a40b47f1409a3cdf9b8dc8e3536941481bc24b79f4df55d0cb17791ca694f26dadf76c5f9235811', 0, '2020-02-12 00:50:01'),
('0ec3e7d376789149cfd972dc58ebebaf0e3f4655385a6a8fef7f7d601ba73a57e3ad8b54b7aef9c6', 'f80c2212a4840b51e650700fa1d90dc2b787b02d56cc166fdf101080294ea406732dc1a01888f3d0', 0, '2020-02-27 16:45:18'),
('0f5be6db3d9c01a2520346bb550831de0cc8c775f4e9a823e91edafe8a5fcb1bd1a891397d37d685', '613806eb58fa1d4ae1de101a181284ac726b72ec5af240ed3507c2cc7ed628f8377d8c01a6619197', 0, '2020-02-05 20:49:30'),
('107b15bc5357f0284785d3ae5e26dd6dea546b7858a31d470b0d82660042a2c4f8dc073117b995ba', '1ce32bc561403b1c714ec196830e85085bc87057054d65219083fc5d5dc2d17223951dfb12329b22', 0, '2020-02-06 18:37:05'),
('1358619d640fa59621f74e6837d3718ef78d53782512b0dc4b0cad7c1c933e8593b66a1cc59cd1fd', '564a36ff83d42a21f305383641ee5b989c9e4aa34da79d97b01efd7ddcd2e42fea138d0e3a6aa368', 0, '2020-02-13 01:02:28'),
('176cf8f80b75f6628bfb7516f56634b89dd7557cb1c565c33ff7ac85ef94727ef51f24e582ee1cfb', 'fd1296b4a44bbab4aa1b14516be3f6ed38b5cca316b35b8b5511c7ec3b030fee56666f6b26d2dc85', 1, '2020-02-10 00:41:08'),
('1f14fd5af3ff1e34bf3d7b884b5e716445349c10863dd4e9990e38d5c98ba0f442ba830c81721f16', '9a094d216cb37527504174f7b0fb7372357d104b8581acbd0a19911db6410a8196589c30306a2cf8', 0, '2020-02-10 00:37:17'),
('2b0f856511b2c102212d0279a0f071b16235441fca3cbf0e565e7640df47ebf3d8e865493e49af66', '326da3ae5c5802cf1ba4fc90db3de22c36f5aba88e1ad587858407fcf4525b11de229ddfe7ae63c2', 0, '2020-02-06 18:47:49'),
('3ce811808f861ee1fe182aefbd5338a214b8864acfeb69ff360216d1d330ee0799c585852688d22b', 'da461acb4a5122311ee52b254d824ca491e47c9ce3aee4a2e61b078607adfa336ea72e4df8901807', 1, '2020-03-30 05:38:23'),
('5a3469a9f1c08311b92392bfd64ade8419953407c28d682a9702e1a7eaf74dd0035f40bb1bda8b70', '5cd336fd8756e8dd9280f8262cf1528177585b49be1ad034981fcfe097c7c111a73753cb194a8683', 0, '2020-02-09 22:55:25'),
('62cc786a950de319dda1fdd591234bcca9b3e03b4d7ad15a261878d82ef6471e3b8a4a83351664ee', 'bc76725a3ad86538bd3c05f0febd22dcb01dc7cbafa183b5c9f35ffb36b653d467436600b43bc56b', 1, '2020-02-28 00:47:31'),
('6647d6e673c4f9d37323479851a43f119d2d0b5364ca91714e0fdd75b984b5173b13e2ba2a6a5bdb', '9ec08fa8bae0af387ed44f3829ec3e616572cb58e7ef1b0a09fa8095399d551abaa1c4eb52abefb6', 0, '2020-02-05 23:40:05'),
('78051805add02c711c4fab7eb965367585afcdb43105eb0eb2e8f48da06579784c1b5f5c1cc24c5c', 'cbff3254c394fe4eaab982f6e6b2a2edad80d1bb7802a0e85196cf6ef03c5baf6ea54588ccc78672', 0, '2020-02-06 18:22:20'),
('96c85644a0b1fd157c4038bf97453dddb0179266e80354d0ceb7e6ba17155fd3bcd87b29a86ff77a', '9896fc4fc311d3fece8c25425a1369a58ef5a6e38b323cffa774c559df320020616802dd919ce816', 0, '2020-02-06 18:52:13'),
('98aff22d641c02f47ead53cba448e92f245389c550fc0ee2b4663d32069c4028a4cd7d217e24237a', '9c15350c1b71f5cb935f4d31b35bbaf5e6ed8982f140d4e99c891cfb346d851e6af30d7d5b19ede7', 0, '2020-03-27 11:25:06'),
('ae5c30a273700ba019c8f30bc12f7287b4407dc8aae1098e22a0b108a2b456864171913e53c40406', '583ee2b5e2bf35537ade0a5a712b5e0ed9bdec63b7362afe0f186b38953ad2f31b7962990d75e081', 0, '2020-02-05 21:15:55'),
('b398674b05f48052d7867a1af0f2945a0e5480b211206a0123a9f2834936ee451da34ac185a32301', 'ef7468f5774d0794d07e5a1ba4fa5d8925219970147b142938fc0e334be8faa5b2dc7c398e71b952', 0, '2020-03-25 18:14:52'),
('bf56185325cd35d008526d8e814d2b9e5fd5b27c4f16264f61c06b0abecf4d999b158fc8b50d6f45', '3951b4945c8b8e42a5d950d7d08373499871111dc23142e0e639f5c4acf1c16b3d3135466b6509ce', 0, '2020-03-30 05:38:23'),
('bffe5e2a6fc493d1c59252289659bacdb8fd622d55aad57af5dba30672dcbbcc37df56f95e1f87cf', '2f26348d9486025710694a50628803287e2b3c08e18a44a9d66c84b35bb417ec58ff9f5bd7731ddf', 0, '2020-02-06 18:05:43'),
('c066d72102b61aa933b7334dd9df71c56d77f637358422b602b9c42f4bee3db7df3462edf93c5013', '1cba32c9fe5d862e852b6a6961cd9019a08ed9c0bf9377ecd2f089d484738a296de7c34e1cf4a255', 0, '2020-02-09 22:48:29'),
('d4e0a7bf696816f3b387a6a60caebfe30813223ab253c5d756e767b11f76abcc0a940676fd602b4e', '50f56b6d3436a892e47c9e19e80289a48e864639288088e373f825458416bcc7a05c68538e7a6df0', 0, '2020-02-06 00:49:51'),
('dc9b1e0319157ec220ad8319189b518c2ad01858cc804d718aa30e2673d2bc92f789f162efca9826', '29b38c52a4e1bd254195823ef878ccb55a9c326c76168aaaf6fc537f4c97ef77024e1d1c114f0781', 0, '2020-02-06 17:28:26'),
('de905f837286ec5b1e2d6a4bb8e5ea7160d2f4a6fb2a0a843a680ecbbf15592048e3741577a09761', 'f08f39c8a49a1269b022c0bfce5f41d1da929ad647cd430e5a45ed3f675e32b5808e6bcc20c5bbd9', 0, '2020-02-06 17:27:00'),
('e17ec094997f98e93cafeb324373a212b4e194b55565c32780661eb21d95c397ad7dadb770977009', '659deb017dd86d061e80db42d3446d894b27c6f13d44af2ff186a405aa5983bae372e5138280555e', 1, '2020-02-27 11:45:03'),
('f4cc11b682dc08506f5b5204df419fcd95391ec52acc8061d621292cdff839b6f83bbb254c5b236b', '15b4870fa661753fdc7d150a7281dc3aa847d05e63d1181214605874577c6527f4ba2b8d51777a4f', 1, '2020-02-09 23:01:11'),
('f6cf7cb69c868d8b424a0b2c962bd77c8fc8841de6a2912b001a9df3e2ea1bd1380d96272a8228d2', '6529c7d0b4067fe85e8988e65693eeff08ffc99a3af1d4e2b795313af2868b30d1023cf716c3c277', 0, '2020-02-28 01:00:15'),
('fba8c3b9ea0ca97f347776f1a04c49b08afa3f5aaf41ed83eff29c24aacdfac089dc35d4324a1f16', 'a928f0df374271400e6202881a14f2d227ef2a37d10c182fbfe7bd8fc4e1700f6beb0e5fe4eff1d1', 1, '2020-02-28 01:00:13');
-- --------------------------------------------------------
--
-- 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `payout_account`
--
CREATE TABLE `payout_account` (
`id` int(11) NOT NULL,
`account_name` text,
`account_no` int(11) DEFAULT NULL,
`process_date` varchar(255) DEFAULT NULL,
`payPeriod` int(11) DEFAULT NULL,
`payRun` int(11) DEFAULT NULL,
`PaymentTotal` varchar(25) DEFAULT NULL,
`TaxiTotal` varchar(25) DEFAULT NULL,
`ShiftTotal` varchar(25) DEFAULT NULL,
`charge` varchar(25) DEFAULT NULL,
`eftpos` varchar(25) DEFAULT NULL,
`iHail` varchar(50) DEFAULT NULL,
`eTicket` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `payout_driver`
--
CREATE TABLE `payout_driver` (
`did` int(11) NOT NULL,
`tsid` int(11) NOT NULL,
`ClientID` int(11) NOT NULL,
`Taxi` varchar(50) NOT NULL,
`TerminalID` int(11) NOT NULL,
`DriverID` int(11) NOT NULL,
`Reference` varchar(20) NOT NULL,
`dDate` varchar(50) NOT NULL,
`dTime` varchar(50) NOT NULL,
`dDescription` text,
`dEftpos` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `payout_log`
--
CREATE TABLE `payout_log` (
`id` bigint(21) NOT NULL,
`type` varchar(500) DEFAULT NULL,
`description` text,
`file` varchar(500) DEFAULT NULL,
`uploaded_by_id` bigint(21) NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `payout_log`
--
INSERT INTO `payout_log` (`id`, `type`, `description`, `file`, `uploaded_by_id`, `created_at`) VALUES
(1, 'upload', 'csv uploaded', '1580391284m3481107.csv', 1, '2020-01-30 08:34:44'),
(2, 'upload', 'csv uploaded', '158047854238814_d20190925.csv', 1, '2020-01-31 08:49:02');
-- --------------------------------------------------------
--
-- Table structure for table `payout_taxishift`
--
CREATE TABLE `payout_taxishift` (
`tsid` int(11) NOT NULL,
`pa_id` int(11) NOT NULL,
`ClientID` varchar(50) NOT NULL,
`Taxi` int(11) NOT NULL,
`TerminalID` int(11) NOT NULL,
`DriverID` int(11) NOT NULL,
`Reference` int(11) NOT NULL,
`sftDate` varchar(50) NOT NULL,
`sftTime` varchar(50) NOT NULL,
`Description` text NOT NULL,
`TaxiTotal` float NOT NULL,
`ShiftTotal` float NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
-- --------------------------------------------------------
--
-- Table structure for table `promocodes`
--
CREATE TABLE `promocodes` (
`id` int(10) UNSIGNED NOT NULL,
`promo_code` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`discount` double(10,2) NOT NULL DEFAULT '0.00',
`discount_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`user_type` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`use_count` int(11) NOT NULL,
`starting_at` datetime NOT NULL,
`expiration` datetime NOT NULL,
`status` enum('ADDED','EXPIRED') COLLATE utf8_unicode_ci NOT NULL,
`description` 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `promocodes`
--
INSERT INTO `promocodes` (`id`, `promo_code`, `discount`, `discount_type`, `user_type`, `use_count`, `starting_at`, `expiration`, `status`, `description`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'test', 5.00, 'flat', 'all', 2, '2019-11-15 00:00:00', '2019-11-23 00:00:00', 'ADDED', 'test', NULL, '2019-11-15 17:59:50', '2019-11-15 17:59:50');
-- --------------------------------------------------------
--
-- Table structure for table `promocode_usages`
--
CREATE TABLE `promocode_usages` (
`id` int(10) UNSIGNED NOT NULL,
`user_id` int(11) NOT NULL,
`promocode_id` int(11) NOT NULL,
`usage` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `promocode_usages`
--
INSERT INTO `promocode_usages` (`id`, `user_id`, `promocode_id`, `usage`, `status`, `created_at`, `updated_at`) VALUES
(1, 6, 1, 1, 'USED', '2019-11-15 18:00:17', '2019-11-15 18:27:03');
-- --------------------------------------------------------
--
-- Table structure for table `providers`
--
CREATE TABLE `providers` (
`id` int(10) UNSIGNED NOT NULL,
`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,
`mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`avatar` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`printer_no` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`rating` decimal(4,2) NOT NULL DEFAULT '5.00',
`status` enum('onboarding','approved','banned') COLLATE utf8_unicode_ci NOT NULL,
`fleet` int(11) NOT NULL DEFAULT '0',
`latitude` double(15,8) DEFAULT NULL,
`longitude` double(15,8) DEFAULT NULL,
`otp` mediumint(9) NOT NULL DEFAULT '0',
`remember_token` varchar(100) COLLATE utf8_unicode_ci DEFAULT NULL,
`login_status` int(11) DEFAULT NULL,
`login_at` timestamp NULL DEFAULT NULL,
`logout_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `providers`
--
INSERT INTO `providers` (`id`, `first_name`, `last_name`, `email`, `mobile`, `password`, `avatar`, `printer_no`, `rating`, `status`, `fleet`, `latitude`, `longitude`, `otp`, `remember_token`, `login_status`, `login_at`, `logout_at`, `created_at`, `updated_at`, `login_by`, `social_unique_id`) VALUES
(3, 'Muthu', 'Test', 'muthumari@ngfot.com', '+918248961208', '$2y$10$aKXaMEqD2Nx5xSt.Sps9Xudfl1nnUgJQJHZ1o5BTb6GaWsi6LsIRy', NULL, NULL, 3.55, 'banned', 0, 0.00000000, 0.00000000, 0, NULL, 1, '2019-12-12 03:20:11', '2019-12-11 15:59:12', '2019-11-07 20:52:57', '2020-01-03 00:00:06', 'manual', NULL),
(4, 'Felix', 'Marshal', 'felix@ngfot.com', '+919943396622', '$2y$10$21G9rmXnivXERpploozCBOILGrFL7.rILQSHvf2UoF/HeSB5uSh6G', 'provider/profile/33b5391c555ad5a4c0ac59180ec1597f.jpeg', NULL, 3.19, 'approved', 1, 11.02982681, 76.94630739, 0, NULL, 1, '2019-12-27 17:58:37', '2019-12-04 15:55:13', '2019-11-07 20:57:07', '2019-12-27 17:59:29', 'manual', NULL),
(5, 'First', 'Driver', 'driver@punjabcabs.com', '+61534525453', '$2y$10$newewDA8BKcwgyXtEM947.M/pLnd4MkFcVTz0nopI4F3rFjG8oy8y', NULL, '345', 3.00, 'banned', 0, 11.02976970, 76.94631630, 0, NULL, 0, '2019-11-11 21:21:28', '2019-11-11 21:21:38', '2019-11-11 17:45:13', '2019-11-26 16:57:42', 'manual', NULL),
(6, 'lovedeep', 'khangura', 'driver1@punjabcabs.com', '+61401402766', '$2y$10$xGjwZ5zGU7mNrwOPhsuHCeQbVrdibrnGAbYZcWqEHvYwFiFPu.KPW', NULL, '564', 5.00, 'banned', 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, '2019-11-11 17:45:51', '2019-11-26 16:57:40', 'manual', NULL),
(7, 'Muthu', 'Test', 'muthu@ngfot.com', '+918248961208', '$2y$10$msbxWE8jE./kqF8OqAE0zOn0XmMU1qSjKgDo5SSU.4uP0bdlMFWmq', NULL, NULL, 5.00, 'onboarding', 0, 11.02974408, 76.94632801, 0, NULL, 0, '2019-12-25 00:25:48', '2019-12-25 00:26:07', '2019-11-13 16:15:37', '2019-12-25 00:26:07', 'manual', NULL),
(8, 'Lovedeep', 'Khangura', 'lovedeep79@hotmail.com', '+61401402766', '$2y$10$d.rPHlmr3q1dD/v6DlYlIen/4Mka7LC56wt4E2SFgvtGcYX2ZKz5m', NULL, NULL, 3.00, 'approved', 0, 0.00000000, 0.00000000, 0, NULL, 1, '2019-12-10 13:59:41', '2019-11-26 17:13:04', '2019-11-26 16:59:46', '2019-12-14 16:17:09', 'manual', NULL),
(9, 'Love', 'Deep', 'lovedeepkhangura@gmail.com', '+61401402766', '$2y$10$BiowWqSTMoxuInQ5m69rpeYHwEXfHVlKpzEyVU/yND2YC0EEfm2d6', NULL, NULL, 5.00, 'banned', 0, NULL, NULL, 0, NULL, 1, '2019-12-01 11:21:53', NULL, '2019-12-01 11:20:52', '2019-12-14 00:00:03', 'manual', NULL),
(10, 'Test', 'Test', 'test@ngfot.com', '+918248961208', '$2y$10$hXVGKWUi074kqyzX.lV9YuIA1CXf2IihrmVmZIiu7v6bCOJ.4nDZK', NULL, NULL, 5.00, 'onboarding', 0, 11.02977578, 76.94634245, 0, NULL, 0, '2019-12-04 15:56:55', '2019-12-04 15:57:06', '2019-12-04 15:56:31', '2019-12-04 15:57:06', 'manual', NULL),
(11, 'Test', 'Driver', 'test@mail.com', '+918248961208', '$2y$10$hXVGKWUi074kqyzX.lV9YuIA1CXf2IihrmVmZIiu7v6bCOJ.4nDZK', NULL, NULL, 5.00, 'onboarding', 0, 11.02977578, 76.94634245, 0, NULL, 0, '2019-12-04 15:56:55', '2019-12-04 15:57:06', '2019-12-04 15:56:31', '2019-12-04 15:57:06', 'manual', NULL),
(12, 'Driver', 'Test', 'test@mails.com', '+918248961208', '$2y$10$hXVGKWUi074kqyzX.lV9YuIA1CXf2IihrmVmZIiu7v6bCOJ.4nDZK', NULL, NULL, 5.00, 'onboarding', 0, 11.02977578, 76.94634245, 0, NULL, 0, '2019-12-04 15:56:55', '2019-12-04 15:57:06', '2019-12-04 15:56:31', '2019-12-04 15:57:06', 'manual', NULL);
-- --------------------------------------------------------
--
-- Table structure for table `provider_applications`
--
CREATE TABLE `provider_applications` (
`id` int(10) UNSIGNED NOT NULL,
`provider_id` int(11) NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`dob` timestamp NULL DEFAULT NULL,
`ssn` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`driver_license` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`expiration_date` timestamp NULL DEFAULT NULL,
`emergency_person` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`emergency_phone` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`crime` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`crime_explain` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`make` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`model` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`model_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`year` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`color` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`license_plate` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`shift1` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`shift2` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`shift3` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
-- --------------------------------------------------------
--
-- Table structure for table `provider_contacts`
--
CREATE TABLE `provider_contacts` (
`id` int(10) UNSIGNED NOT NULL,
`provider_id` int(11) NOT NULL,
`contact_name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`contact_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `provider_contacts`
--
INSERT INTO `provider_contacts` (`id`, `provider_id`, `contact_name`, `contact_number`, `created_at`, `updated_at`) VALUES
(1, 4, 'Distress Number', '112', '2019-11-07 22:33:45', '2019-11-07 22:33:45'),
(2, 5, 'Distress Number', '112', '2019-11-11 18:58:21', '2019-11-11 18:58:21');
-- --------------------------------------------------------
--
-- Table structure for table `provider_devices`
--
CREATE TABLE `provider_devices` (
`id` int(10) UNSIGNED NOT NULL,
`provider_id` int(11) 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,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `provider_devices`
--
INSERT INTO `provider_devices` (`id`, `provider_id`, `udid`, `token`, `sns_arn`, `type`, `created_at`, `updated_at`) VALUES
(1, 3, 'DD52A2E4-E97F-4564-983B-665C777AE573', 'cxUcpG3HNAQ:APA91bFUNip59J3G_59hazuVbP4oYSBL0LxeSxZFNaFOe9boAn-SCXhTlH2L2296L8YagM3Z8rFJbUdkvqtbcEZu0CMvqwEhWKZPRUA2Z1FXFC1PmuIi-qdfhCJiJvFRaY9qGq9y3_n8CIpMviybxa7brp3coxhEdQ', NULL, 'ios', '2019-11-07 20:52:59', '2019-12-12 03:20:11'),
(2, 4, 'E3CF35C8-EDA1-49DC-B546-4AFDE47F23D0', 'fkZuYLPpgFM:APA91bGB7EDwPUj_YfjXxtl213IZMwrm6DupSwQ3JG_5TvjfvekHBzM1qS6kw5vxClA01rFflGu-i4a7ig0uoDiaRVbjnf5qbWDnlPODi4ZmSA_hSWWsptV6LgcxTUAYntMAfD0HnTgc', NULL, 'ios', '2019-11-07 20:57:08', '2019-12-27 17:58:37'),
(3, 5, '', '', NULL, 'android', '2019-11-11 17:47:49', '2019-11-11 21:21:38'),
(4, 7, '', '', NULL, 'ios', '2019-11-13 16:15:41', '2019-12-25 00:26:07'),
(5, 8, '3ECA5F3F-1061-4B78-AE11-46284B12C753', 'cxUcpG3HNAQ:APA91bFUNip59J3G_59hazuVbP4oYSBL0LxeSxZFNaFOe9boAn-SCXhTlH2L2296L8YagM3Z8rFJbUdkvqtbcEZu0CMvqwEhWKZPRUA2Z1FXFC1PmuIi-qdfhCJiJvFRaY9qGq9y3_n8CIpMviybxa7brp3coxhEdQ', NULL, 'ios', '2019-11-26 16:59:51', '2019-12-10 13:59:41'),
(6, 9, '9299838c76121e77', 'cW_nUmcAFhU:APA91bGSqz7twjQGI-97uQcdGRp9cTYnno59i5hYjvKzEpbFl8-T3RukgcOr8PEKys33LaTpb8GP4vWht3H8qjrbbihOaGcifQmew_UREKRfBl_J5V6nogaMTEVbHs_RiEyv8P8yualn', NULL, 'android', '2019-12-01 11:21:53', '2019-12-01 11:21:53'),
(7, 10, '', '', NULL, 'ios', '2019-12-04 15:56:36', '2019-12-04 15:57:06');
-- --------------------------------------------------------
--
-- Table structure for table `provider_documents`
--
CREATE TABLE `provider_documents` (
`id` int(10) UNSIGNED NOT NULL,
`provider_id` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `provider_documents`
--
INSERT INTO `provider_documents` (`id`, `provider_id`, `document_id`, `url`, `unique_id`, `status`, `expires_at`, `created_at`, `updated_at`) VALUES
(1, 3, '1', 'provider/documents/d4cf13357a17671c6f6d59af63ebba99.jpeg', NULL, 'ACTIVE', NULL, '2019-11-07 20:54:51', '2019-11-07 21:09:45'),
(2, 4, '1', 'provider/documents/f331c34a0192123e09fd406a98067901.jpeg', NULL, 'ASSESSING', NULL, '2019-11-07 20:57:41', '2019-11-29 21:12:55'),
(3, 4, '5', 'provider/documents/b621b0154eca3dfc71a030b4bcbb284e.jpeg', NULL, 'ACTIVE', NULL, '2019-11-07 20:57:54', '2019-11-07 22:32:28'),
(5, 4, '4', 'provider/documents/2fac0c79e7e5b28f3c0d628bfe6df2c3.jpeg', NULL, 'ACTIVE', NULL, '2019-11-07 20:58:26', '2019-11-07 22:32:06'),
(6, 4, '6', 'provider/documents/dfc88733da28603984159288570f893a.jpeg', NULL, 'ACTIVE', NULL, '2019-11-07 20:58:38', '2019-11-07 22:32:20'),
(7, 4, '2', 'provider/documents/0d0b107ac46b48cdd6500b9dcb3551e0.jpeg', NULL, 'ACTIVE', NULL, '2019-11-07 20:58:51', '2019-11-07 22:31:52'),
(8, 4, '7', 'provider/documents/a0abcd045d926db70aff87bd32a20d6f.jpeg', NULL, 'ASSESSING', NULL, '2019-11-07 20:59:01', '2019-11-30 01:01:41'),
(9, 7, '4', 'provider/documents/2476268c0e9b0c50c9a36dcdcd7a81b9.jpeg', NULL, 'ASSESSING', NULL, '2019-11-13 16:16:57', '2019-11-13 16:16:57'),
(11, 8, '1', 'provider/documents/19c8146f20cd2d7b4d4f35808bfbf78e.jpeg', NULL, 'ACTIVE', NULL, '2019-11-26 17:00:33', '2019-11-26 17:07:45'),
(13, 8, '3', 'provider/documents/ad1ff4358cdbc02f6726475d62ce8b21.jpeg', NULL, 'ACTIVE', NULL, '2019-11-26 17:00:56', '2019-11-26 17:09:54'),
(14, 8, '4', 'provider/documents/83c7126d4d63d75c53f6f768970aab28.jpeg', NULL, 'ACTIVE', NULL, '2019-11-26 17:01:07', '2019-11-26 17:10:04'),
(15, 8, '6', 'provider/documents/115b1ec4ddbfe4ac786bb3013dc25a79.jpeg', NULL, 'ACTIVE', NULL, '2019-11-26 17:01:18', '2019-11-26 17:10:31'),
(17, 8, '5', 'provider/documents/042c9d9ef4d046a1aa3b043b7306f421.jpeg', NULL, 'ACTIVE', NULL, '2019-11-26 17:01:58', '2019-11-26 17:10:15'),
(18, 8, '2', 'provider/documents/566489ca4db189501df891eed470b354.jpeg', NULL, 'ACTIVE', NULL, '2019-11-26 17:08:31', '2019-11-26 17:09:47'),
(19, 9, '2', 'provider/documents/54b00b227987fbb35a48260b8b27f412.jpeg', NULL, 'ACTIVE', NULL, '2019-12-01 11:22:28', '2019-12-01 11:31:01'),
(20, 9, '6', 'provider/documents/67a7940122184a2e3a022fe5c0a0e7a3.jpeg', NULL, 'ACTIVE', NULL, '2019-12-01 11:22:47', '2019-12-01 11:31:38'),
(21, 9, '4', 'provider/documents/78d1818960221c01c45390f88515aa1a.jpeg', NULL, 'ACTIVE', NULL, '2019-12-01 11:22:58', '2019-12-01 11:31:28'),
(22, 9, '3', 'provider/documents/77ee41bd8dc94dbbf0b694942da07563.jpeg', NULL, 'ACTIVE', NULL, '2019-12-01 11:23:09', '2019-12-01 11:31:12'),
(23, 9, '5', 'provider/documents/0b6f64d96eb286a16bd55da60fa13bae.jpeg', NULL, 'ACTIVE', NULL, '2019-12-01 11:23:19', '2019-12-01 11:30:30'),
(24, 9, '1', 'provider/documents/02c345af4c8326287bac88c5514edb96.jpeg', NULL, 'ACTIVE', NULL, '2019-12-01 11:23:41', '2019-12-01 11:30:49'),
(25, 9, '7', 'provider/documents/c756355945eee2bcae99aa9e7fd576b2.jpeg', NULL, 'ACTIVE', NULL, '2019-12-01 11:24:02', '2019-12-01 11:31:49'),
(27, 3, '7', 'provider/documents/e09606dc621e0adb7595d033a1ddab05.jpeg', NULL, 'ASSESSING', NULL, '2019-12-02 17:06:32', '2019-12-02 18:17:16');
-- --------------------------------------------------------
--
-- Table structure for table `provider_profiles`
--
CREATE TABLE `provider_profiles` (
`id` int(10) UNSIGNED NOT NULL,
`provider_id` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `provider_profiles`
--
INSERT INTO `provider_profiles` (`id`, `provider_id`, `language`, `address`, `address_secondary`, `city`, `country`, `postal_code`, `created_at`, `updated_at`) VALUES
(1, 4, NULL, NULL, NULL, NULL, NULL, NULL, '2019-11-07 22:34:11', '2019-11-07 22:34:11');
-- --------------------------------------------------------
--
-- Table structure for table `provider_services`
--
CREATE TABLE `provider_services` (
`id` int(10) UNSIGNED NOT NULL,
`provider_id` int(11) NOT NULL,
`service_type_id` int(11) NOT NULL,
`taxi_type` int(11) DEFAULT NULL,
`fleet_id` int(11) DEFAULT NULL,
`status` enum('active','offline','riding') 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,
`license_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`license_expire` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`insurance_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`insurance_expire` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`certificate_number` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`certificate_expire` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`license_status` int(11) NOT NULL,
`insurance_status` int(11) NOT NULL,
`certificate_status` int(11) NOT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `provider_services`
--
INSERT INTO `provider_services` (`id`, `provider_id`, `service_type_id`, `taxi_type`, `fleet_id`, `status`, `service_number`, `service_model`, `license_number`, `license_expire`, `insurance_number`, `insurance_expire`, `certificate_number`, `certificate_expire`, `license_status`, `insurance_status`, `certificate_status`, `created_at`, `updated_at`) VALUES
(1, 1, 1, 0, 0, 'offline', '4ppo3ts', 'Audi R8', '34534', '2020-03-20', '432432', '2020-04-17', '43543543', '2020-03-25', 0, 0, 0, '2019-11-06 00:49:45', '2019-11-11 17:28:20'),
(2, 2, 1, NULL, NULL, 'offline', '4ppo3ts', 'Audi R8', NULL, NULL, NULL, NULL, NULL, NULL, 1, 1, 1, '2019-11-06 00:49:45', '2019-11-12 00:00:02'),
(3, 4, 1, 1, 1, 'riding', 'TN1995', 'Black', '1995', '2020-01-07', '1995', '2020-02-07', '04011995', '2020-03-07', 1, 0, 0, '2019-11-07 21:09:10', '2019-12-27 17:59:10'),
(5, 5, 1, 0, 0, 'offline', '46546', '4564356', '5416', '26-06-2020', '5345345', '29-05-2020', '5674567564', '21-05-2020', 0, 0, 0, '2019-11-11 17:46:34', '2019-11-11 21:21:38'),
(6, 7, 1, 0, 0, 'offline', 'U1276', '7867', '679678', '11-11-2020', '2444654', '30-10-2020', '8769769876', '11-11-2019', 0, 0, 2, '2019-11-11 17:47:23', '2019-11-12 00:00:07'),
(7, 8, 1, 0, 0, 'offline', 'M1439', 'ford falcon', '082071781', '22-01-2020', 'ipo542', '20-02-2020', '522549', '22-01-2020', 0, 0, 0, '2019-11-26 17:12:20', '2019-12-10 14:24:02'),
(8, 9, 1, 0, 0, 'offline', '4702M', 'Camry', '09', '02-12-2019', 'Qw', '13-12-2019', '55', '11-12-2019', 2, 2, 2, '2019-12-01 11:33:59', '2019-12-14 00:00:03'),
(9, 3, 1, 0, 0, 'offline', '54545', '545', '4545', '10-01-2020', '5455', '02-01-2020', '89999', '29-08-2022', 1, 2, 0, '2019-12-02 16:52:23', '2020-01-03 00:00:06'),
(10, 11, 1, 0, 0, 'offline', 'M5232', '545', '4545', '10-01-2020', '5455', '02-01-2020', '89999', '29-08-2022', 1, 2, 0, '2019-12-02 16:52:23', '2020-01-03 00:00:06'),
(11, 12, 1, 0, 0, 'offline', 'M8983', '545', '4545', '10-01-2020', '5455', '02-01-2020', '89999', '29-08-2022', 1, 2, 0, '2019-12-02 16:52:23', '2020-01-03 00:00:06');
-- --------------------------------------------------------
--
-- Table structure for table `request_filters`
--
CREATE TABLE `request_filters` (
`id` int(10) UNSIGNED NOT NULL,
`request_id` int(11) NOT NULL,
`provider_id` int(11) NOT NULL,
`status` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `request_filters`
--
INSERT INTO `request_filters` (`id`, `request_id`, `provider_id`, `status`, `created_at`, `updated_at`) VALUES
(171, 91, 4, 0, '2019-12-27 17:59:05', '2019-12-27 17:59:05');
-- --------------------------------------------------------
--
-- Table structure for table `ride_summary`
--
CREATE TABLE `ride_summary` (
`id` bigint(21) NOT NULL,
`process_date` date NOT NULL,
`account_name` varchar(500) DEFAULT NULL,
`pay_period` varchar(500) DEFAULT NULL,
`account_no` varchar(500) DEFAULT NULL,
`pay_run` varchar(500) DEFAULT NULL,
`payment_total` varchar(500) DEFAULT NULL,
`taxi_total` varchar(500) DEFAULT NULL,
`shift_total` varchar(500) DEFAULT NULL,
`charge` varchar(500) DEFAULT NULL,
`eftpos` varchar(500) DEFAULT NULL,
`i_hail` varchar(500) DEFAULT NULL,
`e_ticket` varchar(500) DEFAULT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ride_summary`
--
INSERT INTO `ride_summary` (`id`, `process_date`, `account_name`, `pay_period`, `account_no`, `pay_run`, `payment_total`, `taxi_total`, `shift_total`, `charge`, `eftpos`, `i_hail`, `e_ticket`, `created_at`) VALUES
(1, '2019-11-07', 'PUNJAB CABS', 'Govt', '38814', NULL, '42.15 ', '42.15 ', '42.15 ', NULL, NULL, NULL, NULL, '2020-01-30 08:34:44'),
(2, '2026-09-19', 'PUNJAB CABS', '1910', '38814', '7', '-56.15', '-56.15', '-56.15', '-254.15', '198', '0', '0', '2020-01-31 08:49:02');
-- --------------------------------------------------------
--
-- Table structure for table `ride_summary_details`
--
CREATE TABLE `ride_summary_details` (
`id` bigint(21) NOT NULL,
`ride_summary_id` bigint(21) NOT NULL,
`tag` varchar(500) DEFAULT NULL,
`taxi` varchar(500) DEFAULT NULL,
`terminal_id` varchar(500) DEFAULT NULL,
`driver_id` varchar(500) DEFAULT NULL,
`reference` varchar(500) DEFAULT NULL,
`date` date DEFAULT NULL,
`time` time DEFAULT NULL,
`description` varchar(500) DEFAULT NULL,
`taxi_total` varchar(500) DEFAULT NULL,
`shift_total` varchar(500) DEFAULT NULL,
`charge` varchar(500) DEFAULT NULL,
`eftpos` varchar(500) DEFAULT NULL,
`i_hail` varchar(500) NOT NULL,
`e_ticket` varchar(500) NOT NULL,
`created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
--
-- Dumping data for table `ride_summary_details`
--
INSERT INTO `ride_summary_details` (`id`, `ride_summary_id`, `tag`, `taxi`, `terminal_id`, `driver_id`, `reference`, `date`, `time`, `description`, `taxi_total`, `shift_total`, `charge`, `eftpos`, `i_hail`, `e_ticket`, `created_at`) VALUES
(1, 1, 'D', 'M5232 ', NULL, '11', NULL, '2019-11-06', '00:34:44', 'Eftpos', '32.95 ', '32.95 ', NULL, '32.95 ', '', '', '2020-01-30 08:34:44'),
(2, 1, 'D', 'M8983 ', NULL, '12', NULL, '2019-11-06', '00:34:44', 'Eftpos', '9.20 ', '9.20 ', NULL, '9.20 ', '', '', '2020-01-30 08:34:44'),
(3, 2, 'D', '4702M', 'V37683', '9', '72', '2025-09-19', '11:51:28', 'Eftpos', '116.35', '116.35', '', '12.9', '', '', '2020-01-31 08:49:02'),
(4, 2, 'D', '4702M', 'V37683', '9', '73', '2025-09-19', '13:09:44', 'Eftpos', '116.35', '116.35', '', '22.5', '', '', '2020-01-31 08:49:02'),
(5, 2, 'D', '4702M', 'V37683', '9', '74', '2025-09-19', '13:34:28', 'Eftpos', '116.35', '116.35', '', '18.5', '', '', '2020-01-31 08:49:02'),
(6, 2, 'D', '4702M', 'V37683', '9', '75', '2025-09-19', '16:30:38', 'Eftpos', '116.35', '116.35', '', '9.2', '', '', '2020-01-31 08:49:02'),
(7, 2, 'D', '4702M', 'V37683', '9', '76', '2025-09-19', '17:00:54', 'Eftpos', '116.35', '116.35', '', '20', '', '', '2020-01-31 08:49:02'),
(8, 2, 'D', '4702M', 'V37683', '9', '77', '2025-09-19', '17:30:34', 'Eftpos', '116.35', '116.35', '', '15.8', '', '', '2020-01-31 08:49:02'),
(9, 2, 'D', '4702M', 'V37683', '9', '80', '2025-09-19', '18:45:30', 'Eftpos', '116.35', '116.35', '', '17.45', '', '', '2020-01-31 08:49:02'),
(10, 2, 'D', 'M1439', 'V37680', '8', '71678', '2025-09-19', '17:47:19', 'Eftpos', '43.85', '43.85', '', '15', '', '', '2020-01-31 08:49:02'),
(11, 2, 'D', 'M1439', 'V37680', '8', '71681', '2025-09-19', '19:35:44', 'Eftpos', '43.85', '43.85', '', '14.65', '', '', '2020-01-31 08:49:02'),
(12, 2, 'D', 'M1439', 'V37680', '8', '71682', '2025-09-19', '20:18:46', 'Eftpos', '43.85', '43.85', '', '14.2', '', '', '2020-01-31 08:49:02'),
(13, 2, 'D', 'M5232', 'V37678', '11', '36113', '2019-08-04', '23:56:00', 'Adjust', '-254.15', '-254.15', '-254.15', '', '', '', '2020-01-31 08:49:02'),
(14, 2, 'D', 'U1276', 'V37682', '7', '625', '2025-09-19', '09:35:04', 'Eftpos', '37.8', '37.8', '', '37.8', '', '', '2020-01-31 08:49:02');
-- --------------------------------------------------------
--
-- Table structure for table `service_types`
--
CREATE TABLE `service_types` (
`id` int(10) UNSIGNED NOT NULL,
`name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`image` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`capacity` int(11) NOT NULL DEFAULT '0',
`p_enable` int(11) NOT NULL DEFAULT '0',
`d_stime` time NOT NULL,
`d_etime` time NOT NULL,
`n_stime` time NOT NULL,
`n_etime` time NOT NULL,
`p_stime` time NOT NULL,
`p_etime` time NOT NULL,
`d_flag` double(10,2) NOT NULL DEFAULT '0.00',
`d_distance` double(10,2) NOT NULL DEFAULT '0.00',
`d_booking` double(10,2) NOT NULL DEFAULT '0.00',
`d_waiting` double(10,2) NOT NULL DEFAULT '0.00',
`n_flag` double(10,2) NOT NULL DEFAULT '0.00',
`n_distance` double(10,2) NOT NULL DEFAULT '0.00',
`n_booking` double(10,2) NOT NULL DEFAULT '0.00',
`n_waiting` double(10,2) NOT NULL DEFAULT '0.00',
`p_flag` double(10,2) NOT NULL DEFAULT '0.00',
`p_distance` double(10,2) NOT NULL DEFAULT '0.00',
`p_booking` double(10,2) NOT NULL DEFAULT '0.00',
`p_waiting` double(10,2) NOT NULL DEFAULT '0.00',
`description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`status` int(11) NOT NULL DEFAULT '0',
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `service_types`
--
INSERT INTO `service_types` (`id`, `name`, `image`, `capacity`, `p_enable`, `d_stime`, `d_etime`, `n_stime`, `n_etime`, `p_stime`, `p_etime`, `d_flag`, `d_distance`, `d_booking`, `d_waiting`, `n_flag`, `n_distance`, `n_booking`, `n_waiting`, `p_flag`, `p_distance`, `p_booking`, `p_waiting`, `description`, `status`, `created_at`, `updated_at`) VALUES
(1, 'sedan', 'https://punjabcabs.unicotaxi.com/uploads/e14889a2b7c24dbadf4a159c38542ec688e9aecc.png', 0, 1, '09:00:00', '16:59:47', '11:45:49', '01:30:53', '13:00:33', '12:10:59', 4.20, 1.62, 2.00, 0.57, 5.20, 1.80, 2.00, 0.63, 6.20, 1.99, 2.00, 0.70, 'test', 0, '2019-03-18 18:53:30', '2019-03-20 11:59:00'),
(2, 'suv', 'https://www.punjabcabs.com.au/uploads/9ed015177bff38f977787800a5461b3b231d2f14.png', 0, 1, '11:40:19', '10:35:45', '11:40:21', '11:35:57', '11:45:23', '11:30:01', 1.00, 2.00, 1.00, 1.00, 1.00, 3.00, 1.00, 1.00, 1.00, 3.00, 1.00, 1.00, 'hgh', 0, '2019-04-30 16:04:22', '2019-11-11 22:30:25'),
(3, 'Wheelchair', 'https://www.punjabcabs.com.au/uploads/a8e7195b31f6b8d830457de77677c91e1fc8e483.png', 0, 1, '08:00:13', '15:25:31', '15:30:55', '18:00:06', '16:45:21', '16:50:23', 4.20, 1.62, 2.00, 0.57, 5.20, 1.80, 2.00, 0.63, 6.20, 1.99, 2.00, 0.70, 'Wheelchair', 0, '2019-05-10 21:03:50', '2019-11-11 22:30:43'),
(4, 'Luxury car', 'https://www.punjabcabs.com.au/uploads/5dfba3ea591fb60a38b48667e2a444cce56ff1ec.png', 0, 1, '16:35:32', '16:50:34', '13:05:05', '14:55:11', '15:55:02', '16:55:00', 15.20, 1.62, 2.00, 0.57, 15.20, 1.80, 2.00, 0.63, 15.20, 1.99, 2.00, 0.70, 'Luxury car', 0, '2019-05-10 21:05:29', '2019-11-11 22:30:56');
-- --------------------------------------------------------
--
-- Table structure for table `settings`
--
CREATE TABLE `settings` (
`id` int(10) UNSIGNED NOT NULL,
`key` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`value` text COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `settings`
--
INSERT INTO `settings` (`id`, `key`, `value`) VALUES
(1, 'site_title', 'Punjab Cabs'),
(2, 'site_logo', 'https://www.punjabcabs.com.au/uploads/bee72740504c2ad4a9d9cd7a4c2b9dc7e3bad47c.png'),
(3, 'site_email_logo', 'https://punjabcabs.unicotaxi.com/logo-white.png'),
(4, 'site_icon', 'https://www.punjabcabs.com.au/uploads/26d0b616d2bde32071447f3d86d3afb11ad7bec3.png'),
(5, 'site_copyright', '© 2020 Punjab Cabs. ABN :: 70 124 673 212'),
(6, 'mail_enable', '1'),
(7, 'sms_enable', '1'),
(8, 'country_code', '+61'),
(9, 'provider_select_timeout', '59'),
(10, 'provider_search_radius', '200'),
(11, 'distance_unit', 'km'),
(12, 'base_price', '50'),
(13, 'price_per_minute', '50'),
(14, 'tax_percentage', '10'),
(15, 'stripe_secret_key', 'sk_test_52Vq0FfFbPcZfLRZMIHla5fH00cnzedARZ'),
(16, 'stripe_publishable_key', 'pk_test_j2WaMr6kft2dhBeuSvxTL8E700WA5iC0nd'),
(17, 'CASH', '1'),
(18, 'CARD', '1'),
(19, 'manual_request', '0'),
(20, 'default_lang', 'en'),
(21, 'currency', 'A$'),
(22, 'distance', 'Km'),
(23, 'scheduled_cancel_time_exceed', '10'),
(24, 'price_per_kilometer', '10'),
(25, 'commission_percentage', '10'),
(26, 'store_link_android', ''),
(27, 'store_link_ios', ''),
(28, 'daily_target', '0'),
(29, 'surge_percentage', '0'),
(30, 'surge_trigger', '0'),
(31, 'demo_mode', '0'),
(32, 'booking_prefix', 'TRNX'),
(33, 'sos_number', '000'),
(34, 'contact_number', '12345678'),
(35, 'contact_email', 'lovedeep79@hotmail.com'),
(36, 'social_login', '1'),
(37, 'country', 'Australia'),
(38, 'state', ''),
(39, 'city', ''),
(40, 'address', '24 Graham Rd, Clayton South VIC, Australia'),
(41, 'address_lat', '-37.952924'),
(42, 'address_long', '145.1358159'),
(43, 'zoom', '11'),
(44, 'transaction_percentage', '5'),
(45, 'sro_levy', '1.1'),
(46, 'commission_enable', '1'),
(47, 'cancellation_min', '5'),
(48, 'cancellation_fare', '5'),
(49, 'wheelchair_service', '3'),
(50, 'wheelchair_discount', '50'),
(51, 'page_privacy', '<h3>PRIVACY POLICY</h3>\r\n\r\n<p>Our Privacy Statement describes how PUNJAB CABS protects the privacy of any of your personal information in accordance with the Australian Privacy Principles as stated in Privacy Act 1988.We will only use or disclose personal information we hold about you in accordance with this Privacy Policy or as otherwise notified to you</p>\r\n\r\n<p>1.Scope of our Privacy Policy</p>\r\n\r\n<p>This Privacy Policy covers PUNJAB CABS use of any personal information that PUNJAB CABS collects when you are PUNJAB CABS on sites, using PUNJAB CABS applications and using PUNJAB CABS services.</p>\r\n\r\n<p>Punjab cabs understand that you value your privacy. When you download the Punjab cabs app onto your phone, we do not access any of your private information, either your Contacts, your Photos or Media or any other personal information that is not provided directly to us or as otherwise stated below.</p>\r\n\r\n<p>To provide the users of our app with a good experience we do use multiple features of the phone’s capabilities. That is why when you install the app you are asked to accept our use of these services. Below we have laid out how we use each feature within our app.</p>\r\n\r\n<p>1.1Device UDID– Punjab cabs stores this against the passenger account. Only used in track of fraudulent activities by any user.</p>\r\n\r\n<p>1.2.Contacts – Punjab cabs does not access your personal contacts</p>\r\n\r\n<p>1.3.Location: Punjab cabs app is a location aware app to assist with placing bookings and subsequent collections.</p>\r\n\r\n<p>1.4.Phone media – Punjab cabs does not access your phone photos or any kind of media stored in it.</p>\r\n\r\n<p>2.Collection and use of personal information</p>\r\n\r\n<p>The personal information Punjab cabs collects and holds is what is reasonably necessary for our business functions and activities, and to enable you to use Punjab cabs applications and services.</p>\r\n\r\n<p>When you register with Punjab cabs as a user on the Punjab cabs website or application, we generally ask for your name, email address and mobile number.</p>\r\n\r\n<p>We may use this information to send you direct marketing communications and information to keep you updated on our progress or to provide you with promotions in relation to your use of our service. This may be in the form of an SMS or email. You may opt-out of receiving marketing communications from us at any time by contacting us. We do not provide your personal information to other organisations for the purposes of direct marketing unless expressly authorised by you.</p>\r\n\r\n<p>When you make a taxi booking, Punjab cabs will request your pickup and drop off address locations and these will be stored with your profile and booking records. We also log your GPS location when you make a booking as per your approval and also when you are picked up and dropped off (via your and the driver’s application) and will store these as part of the booking record and your profile. This information is used to assist in investigating your and your taxi driver’s complaints and enquiries.</p>\r\n\r\n<p>Punjab cabs will share your name and phone no with the driver who has been allocated your booking in order to allow the driver to communicate directly with you and increase the chances of a successful pick-up.</p>\r\n\r\n<p>We also keep a record of your billing information to allow you to make quick taxi payments with your Punjab cabs registered payment method or card and to charge the taxi fare and associated fees to your account. This information is recorded for trip reference only.</p>\r\n\r\n<p>3.Disclose your personal information</p>\r\n\r\n<p>Punjab cabs will not sell or rent your personal information to anyone. Punjab cabs will only share your personal information with 3rd party under following circumstances</p>\r\n\r\n<p>We have your consent to share the information;</p>\r\n\r\n<p>Shared with driver providing you service at any given time</p>\r\n\r\n<p>Corporate account holders, in which case we may share your information with your employer.</p>\r\n\r\n<p>Any legal notices issued by courts as otherwise permitted by law.</p>\r\n\r\n<p>In case of violation of terms of service or any of our usage guidelines for specific products or services.</p>\r\n\r\n<p>4. Stored Data security</p>\r\n\r\n<p>Punjab cabs will take reasonable steps to protect the personal information it holds from misuse and loss and from unauthorised access, modification or disclosure.</p>\r\n\r\n<p>Punjab cabs will take reasonable steps to destroy or permanently de-identify personal information if it is no longer needed for any purpose for which the information may be used or disclosed under Australian Privacy Principles.</p>\r\n\r\n<p>5. Handling of sensitive information</p>\r\n\r\n<p>Punjab cabs will not collect sensitive information about an individual unless:</p>\r\n\r\n<p>The individual has consented; or</p>\r\n\r\n<p>The collection is required by law; or</p>\r\n\r\n<p>The collection is necessary to prevent or lessen a serious and imminent threat to the life or health of any individual, where the individual whom the information concerns:</p>\r\n\r\n<p>5.3.1 is physically or legally incapable of giving consent to the collection; or</p>\r\n\r\n<p>Physically cannot communicate consent to the collection.</p>\r\n\r\n<p>6. Complaints</p>\r\n\r\n<p>If you believe that Punjab cabs has not complied with its obligations concerning your personal information, you should contact Punjab cabs and lodge a complaint.</p>\r\n\r\n<p>AT</p>\r\n\r\n<p>complaints@punjabcabs.com.au</p>'),
(52, 'term_condition', '<h3>Terms and Conditions</h3>\r\n<p>Last updated: March 27, 2019</p>\r\n\r\n<p>Please read these Terms and Conditions (\"Terms\", \"Terms and Conditions\") carefully before using the Punjab cabs mobile application (the \"Service\") operated by Punjab cabs (\"us\", \"we\", or \"our\").</p>\r\n\r\n<p>Your access to and use of the Service is conditioned on your acceptance of and compliance with these Terms. These Terms apply to all visitors, users and others who access or use the Service. You warrant that you are at least 18-years-old and you are legally capable of entering into binding contracts. If you are under 18-years-old, you warrant that you have obtained consent from your parent or guardian and they agree to be bound by these Terms on your behalf.</p>\r\n\r\n<p>By accessing or using the Service you agree to be bound by these Terms. If you disagree with any part of the terms then you may not access the Service.</p>\r\n\r\n<p>Use of Service</p>\r\n\r\n<p>If you wish to use any service made available through the Service (\"Purchase\"), you may be asked to supply certain information relevant to your service including, without limitation, your credit card number, the expiration date of your credit card, your billing address.</p>\r\n\r\n<p>You represent and warrant that: (i) you have the legal right to use any credit card(s) or other payment method(s) in connection with any Purchase; and that (ii) the information you supply to us is true, correct and complete.</p>\r\n\r\n<p>By submitting such information, you grant us the right to provide the information to third parties for purposes of facilitating the completion of Purchases.</p>\r\n\r\n<p>The Service is not designed to provide qualitative advice regarding the fitness for purpose and merchantability of any products or services. We strongly advise you to exercise caution and do your own due diligence in conducting any transactions through the Service.</p>\r\n\r\n<p>Availability, Errors and Inaccuracies</p>\r\n\r\n<p>We are constantly updating our services on the Service. The services available on our Service may be mispriced, described inaccurately, or unavailable, and we may experience delays in updating information on the Service and in our advertising on other web sites.</p>\r\n\r\n<p>We cannot and do not guarantee the accuracy or completeness of any information, including prices, product images, specifications, availability, and services. We reserve the right to change or update information and to correct errors, inaccuracies, or omissions at any time without prior notice.</p>\r\n\r\n<p>The content is provided without warranties or conditions of any kind either express or implied, including but not limited to implied warranties and conditions of merchantability, fitness for a particular purpose or non-infringement.</p>\r\n\r\n<p>Accounts</p>\r\n\r\n<p>When you create an account with us, you must provide us information that is accurate, complete, and current at all times. Failure to do so constitutes a breach of the Terms, which may result in immediate termination of your account on our Service.</p>\r\n\r\n<p>You are responsible for safeguarding the password that you use to access the Service and for any activities or actions under your password, whether your password is with our Service or a third-party service.</p>\r\n\r\n<p>You agree not to disclose your password to any third party. You agree to be fully responsible for activities that relate to your account or your password. You must notify us immediately upon becoming aware of any breach of security or unauthorized use of your account.</p>\r\n\r\n<p>Links To Other Web Sites</p>\r\n\r\n<p>Our Service may contain links to third party web sites or services that are not owned or controlled by Punjab cabs.</p>\r\n\r\n<p>Punjab cabs has no control over, and assumes no responsibility for, the content, privacy policies, or practices of any third party web sites or services. You further acknowledge and agree that punjab cabs shall not be responsible or liable, directly or indirectly, for any damage or loss caused or alleged to be caused by or in connection with use of or reliance on any such content, goods or services available on or through any such web sites or services.</p>\r\n\r\n<p>We only provide links to external websites, as a convenience, and the inclusion of such a link to external websites do not imply our endorsement of those websites. You acknowledge and agree that when you access other websites on the Internet, you do so at your own risk. We strongly advise you to read the terms and conditions and privacy policies of any third-party web sites or services that you visit.</p>\r\n\r\n<p>Termination</p>\r\n\r\n<p>We may terminate or suspend your account immediately, without prior notice or liability, for any reason whatsoever, including without limitation if you breach the Terms.</p>\r\n\r\n<p>Upon termination, your right to use the Service will immediately cease. If you wish to terminate your account, you may simply discontinue using the Service.</p>\r\n\r\n<p>All provisions of the Terms which by their nature should survive termination shall survive termination, including, without limitation, ownership provisions, warranty disclaimers, indemnity and limitations of liability.</p>\r\n\r\n<p>We shall not be liable to you or any third party for any claims or damages arising out of any termination or suspension or any other actions taken by us in connection therewith.</p>\r\n\r\n<p>If applicable law requires us to provide notice of termination or cancellation, we may give prior or subsequent notice by posting it on the Service or by sending a communication to any address (email or otherwise) that we have for you in our records.</p>\r\n\r\n<p>Indemnification</p>\r\n\r\n<p>As a condition of your access to and use of the Service, you agree to indemnify us and our successors and assigns for all damages, costs, expenses and other liabilities, including but not limited to legal fees and expenses, relating to any claim arising out of or related to your access to and use of the Service or your breach of these Terms and any applicable law or the rights of another person or party.</p>\r\n\r\n<p>This indemnification section survives the expiration of your registration, and applies to claims arising both before and after the registration ends.</p>\r\n\r\n<p>Limitation Of Liability</p>\r\n\r\n<p>You agree that we shall not be liable for any damages suffered as a result of using the Service.</p>\r\n\r\n<p>In no event shall we be liable for any indirect, punitive, special, incidental or consequential damage (including loss of business, revenue, profits, use, privacy, data, goodwill or other economic advantage) however it arises, whether for breach of contract or in tort, even if it has been previously advised of the possibility of such damage.</p>\r\n\r\n<p>In no event shall we be liable for any claims by a third party in tort or contract, or pursuant to the Competition and Consumer Act 2010 (Cth) including, but not limited, to any misleading statements made and/or incorporated into any Content provided by third parties, such as manufacturers and wholesalers, and users of the Service. It is your sole responsibility to ensure the accuracy of the data inputted.</p>\r\n\r\n<p>You have sole responsibility for adequate security protection and backup of data and/or equipment used in connection with your usage of the Service and will not make a claim against for lost data, re-run time, inaccurate instruction, work delays or lost profits resulting from the use of the Service.</p>\r\n\r\n<p>Without limiting the foregoing, in no event will our aggregate liability to you exceed, in total, the amounts paid by you to us.</p>\r\n\r\n<p>Disclaimer</p>\r\n\r\n<p>Your use of the Service is at your sole risk. The Service is provided on an \"AS IS\" and \"AS AVAILABLE\" basis. The Service is provided without warranties of any kind, whether express or implied, including, but not limited to, implied warranties of merchantability, fitness for a particular purpose, non-infringement or course of performance.</p>\r\n\r\n<p>punjab cabs its subsidiaries, affiliates, and its licensors do not warrant that a) the Service will function uninterrupted, secure or available at any particular time or location; b) any errors or defects will be corrected; c) the Service is free of viruses or other harmful components; or d) the results of using the Service will meet your requirements.</p>\r\n\r\n<p>This disclaimer of liability applies to any damages or injury caused by any failure of performance, error, omission, interruption, deletion, defect, delay in operation or transmission, computer virus, communication line failure, theft, or destruction or unauthorized access or, alteration of or use of record in connection with the use or operation of the Service, whether for breach of contract, tortious behaviour, negligence or any other cause of action.</p>\r\n\r\n<p>We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the content contained on the Service for any purpose. Any reliance you place on such information is therefore strictly at your own risk. We disclaim any express or implied warranty representation or guarantee as to the effectiveness or profitability of the Service or that the operation of our Service will be uninterrupted or error-free. We are not liable for the consequences of any interruptions or error in the Service.</p>\r\n\r\n<p>Exclusions</p>\r\n\r\nSome jurisdictions do not allow the exclusion of certain warranties or the exclusion or limitation of liability for consequential or incidental damages, so the limitations above may not apply to you.</p>\r\n\r\n<p>Governing Law</p>\r\n\r\n<p>These Terms shall be governed and construed in accordance with the laws of Victoria, Australia, without regard to its conflict of law provisions.</p>\r\n\r\n<p>Our failure to enforce any right or provision of these Terms will not be considered a waiver of those rights. If any provision of these Terms is held to be invalid or unenforceable by a court, the remaining provisions of these Terms will remain in effect. These Terms constitute the entire agreement between us regarding our Service, and supersede and replace any prior agreements we might have between us regarding the Service.</p>\r\n\r\n<p>Changes</p>\r\n\r\n<p>We reserve the right, at our sole discretion, to modify or replace these Terms at any time. If a revision is material we will try to provide at least 30 days notice prior to any new terms taking effect.</p>\r\n\r\n<p>It is your sole responsibility to periodically check these Terms for any changes. If you do not agree with any of the changes to these Terms, it is your sole responsibility to stop using the Service. Your continued use of the Service will be deemed as your acceptance thereof.</p>\r\n\r\n<p>Contact Us</p>\r\n\r\n<p>If you have any questions about these Terms, please contact us.</p>');
-- --------------------------------------------------------
--
-- Table structure for table `smsnotifications`
--
CREATE TABLE `smsnotifications` (
`id` int(10) UNSIGNED NOT NULL,
`message` text COLLATE utf8_unicode_ci,
`mobile_numbers` longtext COLLATE utf8_unicode_ci,
`member` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`notification_type` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `smsnotifications`
--
INSERT INTO `smsnotifications` (`id`, `message`, `mobile_numbers`, `member`, `notification_type`, `created_at`, `updated_at`) VALUES
(1, 'test', '\"+919943396622\"', 'driver', 'sms', '2019-11-11 22:31:43', '2019-11-11 22:31:43'),
(2, 'test', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 22:32:51', '2019-11-11 22:32:51'),
(3, 'test etest', '\"Felix Marshal, Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 22:33:06', '2019-11-11 22:33:06'),
(4, 'testestsetest', '\"Felix Marshal, Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 22:34:14', '2019-11-11 22:34:14'),
(5, 'fdgdfgf fdgfd gfdg fdgfdgsdf gfdg fdgfdgsfdg', '\"Felix Marshal\"', 'driver', 'push', '2019-11-11 22:34:41', '2019-11-11 22:34:41'),
(6, 'test messsgae', '\"driver1 test\"', 'driver', 'push', '2019-11-11 22:36:51', '2019-11-11 22:36:51'),
(7, 'testsetse', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 22:54:34', '2019-11-11 22:54:34'),
(8, 'tests tests', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 22:55:41', '2019-11-11 22:55:41'),
(9, 'ttwtww wtetewtew', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 22:56:33', '2019-11-11 22:56:33'),
(10, 'g jhgg hg jhg hj', '\"Felix Marshal, Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 22:57:12', '2019-11-11 22:57:12'),
(11, 'test test tests ', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-11 23:01:22', '2019-11-11 23:01:22'),
(12, 'fgdh', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-15 17:57:32', '2019-11-15 17:57:32'),
(13, 'fjhdh', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-15 17:57:41', '2019-11-15 17:57:41'),
(14, 'gjhxdfjsgh', '\"Felix Marshal\"', 'driver', 'push', '2019-11-15 17:57:55', '2019-11-15 17:57:55'),
(15, 'gggggg', '\"Felix Marshal (live)\"', 'passenger', 'push', '2019-11-15 17:58:38', '2019-11-15 17:58:38'),
(16, 'ggggggggg', '\"Felix Marshal\"', 'driver', 'push', '2019-11-15 17:59:06', '2019-11-15 17:59:06');
-- --------------------------------------------------------
--
-- Table structure for table `users`
--
CREATE TABLE `users` (
`id` int(10) UNSIGNED NOT NULL,
`first_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`last_name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`payment_mode` enum('CASH','CARD','PAYPAL') COLLATE utf8_unicode_ci NOT NULL,
`email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`mobile` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`password` varchar(255) COLLATE utf8_unicode_ci DEFAULT 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,
`trip_status` int(11) NOT NULL DEFAULT '0',
`stripe_cust_id` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`wallet_balance` double(10,2) NOT NULL DEFAULT '0.00',
`due_balance` double(10,2) NOT NULL DEFAULT '0.00',
`due_trip` int(11) DEFAULT NULL,
`rating` decimal(4,2) NOT NULL DEFAULT '5.00',
`cancel_points` int(11) NOT NULL DEFAULT '5',
`favourite_driver` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`otp` mediumint(9) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`id`, `first_name`, `last_name`, `payment_mode`, `email`, `mobile`, `password`, `picture`, `device_token`, `device_id`, `device_type`, `login_by`, `social_unique_id`, `latitude`, `longitude`, `trip_status`, `stripe_cust_id`, `wallet_balance`, `due_balance`, `due_trip`, `rating`, `cancel_points`, `favourite_driver`, `otp`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Test', 'User', 'CASH', 'test@pubjabcabs.com', '9258632148', '$2y$10$OamUbpCE4ymi5pdaLpLBhO9kG27HZqQUtnnHLzfUU7YWKLVDM5utK', 'http://lorempixel.com/512/512/business/vx', NULL, NULL, 'android', 'manual', NULL, NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 6, NULL, 0, NULL, '2019-11-06 00:49:44', '2019-11-26 17:38:41'),
(2, 'Test1', 'User', 'CASH', 'test1@pubjabcabs.com', '9848522228', '$2y$10$OcZlR1dSJy.ElE8Wr9BQuOFAPYlt2YpKJgVQKK9/vUSv7eWQmP3DK', 'http://lorempixel.com/512/512/business/vx', NULL, NULL, 'android', 'manual', NULL, NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 7, NULL, 0, NULL, '2019-11-06 00:49:45', '2019-11-29 01:33:10'),
(3, 'Muthu', 'Test', 'CASH', 'muthumari@ngfot.com', '+918248961208', '$2y$10$CbmPI6xB95zy0tgI20kSy.UCPPyLbxe10DJcAMPR1aaOJ1vTUm/9K', NULL, 'eKXvBhp7olE:APA91bGnUgaFANkS4YyCutpIY_YaqYL-kIdNQ6Qqb8Es6m9DTV3JxfMviOK8iGBOhYEUO4karGUrlxLcQ_WLSzRKCEKMJi0-r2XEOE5HbSoqTEpMt3ahKk8kkiYqPCieHec3oPkfollz', '135F972F-A77C-412D-940A-3F0114C2DDA1', 'ios', 'manual', NULL, 11.02979882, 76.94631520, 1, 'cus_G8Oqp5ghJdrLwT', 0.00, 0.00, NULL, 5.00, 10, NULL, 579222, NULL, '2019-11-07 20:49:28', '2019-11-29 16:51:26'),
(4, 'Street Ride', 'Client', 'CASH', 'info@punjabcabs.com', '+6112345678', '123456789', NULL, NULL, NULL, 'android', 'manual', NULL, NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 34, NULL, 0, NULL, '2019-11-07 21:20:02', '2019-12-03 17:43:21'),
(5, 'Felix', 'Marshal', 'CASH', 'felixjenith6@gmail.com', NULL, '$2y$10$5i6GuAILMd/H9aS2AwnmUOdI0vthePSTVEwfbjsfJq2ldyV2vca6e', 'https://graph.facebook.com/v2.8/1687762491359358/picture?type=normal', 'drw8Vah2-Jo:APA91bHDRfcHSLFZZwYzIQT5bzjTvwuNG7XPDsUI6o2-Hf1yyTgavBUvJ-KVC7yMzeyThIOhZHRZvBZiGkiAlkLfKywRniQq560giV6TzJm9JsNh5S00MsvoivzBfjbPeCWo-6RUvpvm', 'f19a7f9a67e39b69', 'android', 'facebook', '1687762491359358', 11.02976760, 76.94630560, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-11-08 16:28:59', '2019-12-02 21:40:16'),
(6, 'Felix', 'Marshal (live)', 'CASH', 'felix@ngfot.com', '+919943396622', '$2y$10$wPCqxiAKeYtftFwrTkLJXuZnX9Vj.jwWs9md39nzyxyv3FuHg.HNG', '', 'c9JCcuhIOlc:APA91bFXILaqIPUTVTvNI25etkUVM9-duYp4BKCgZpAupC-aiq1KkISJvxL5w8p2ThLINxBIFgEdZG5rCGOzz5UYLx68Lj3OIQ3cjcZ8QDuZfGOxOUwhiZkIDaWEaRWDzqCrg5n_6SkH', '82CBF110-C9B2-4BBE-83BB-A91BC1CEE4A8', 'ios', 'manual', '', 11.02977911, 76.94634554, 0, 'cus_G8jVbxp8tuKgAB', 30.00, 0.00, NULL, 5.00, 8, '', 0, 'KVlaKWAOnsvJ91WG2x3adv1swrA2NyVKkxBp1nIA8759WVavsvOXvK8Pltfu', '2019-11-08 17:26:59', '2019-12-27 17:58:03'),
(7, 'Muthu', '', 'CASH', 'muthumarielango@gmail.com', NULL, '$2y$10$3Py9N/2oLPS1okL3o6aPYOSQtT7e5Kg0g/5fzJ/jpcgTODlBVwBKO', 'https://graph.facebook.com/v2.8/527674144478926/picture?type=normal', '', '', 'ios', 'google', '111615434792431461380', 11.02980581, 76.94632349, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-11-08 21:00:40', '2019-11-28 16:14:46'),
(8, 'Gurusamy', 'V', 'CASH', 'guru@ngfot.com', NULL, '$2y$10$kAsuIaBvoq.rP/fJJWwW1.M9qdx5idxedKxz3bfsXA3k9ZaodN6Za', 'https://lh3.googleusercontent.com/-WamvjsJSWAs/AAAAAAAAAAI/AAAAAAAAAAA/ACHi3rcxASf6RhlxSvdBL553qFWYUIt7oQ/photo.jpg', '', '', 'ios', 'google', '106478737721883025851', 11.02976818, 76.94628962, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, 'cTQ1QRh4VbntLc8sHXt45oDMVQUqn7MgzjIb88dhZuCG1gHIi1q7Vy3VGXis', '2019-11-11 16:48:25', '2019-11-13 16:44:33'),
(9, 'Ngfot', 'Mobile', 'CASH', 'mobilengfot@gmail.com', NULL, '$2y$10$NUt7lmSW5Cn5V0C/DGQeQOOEr.w3Jb/MZGEGMnGt6M4y7g1RGq.N.', 'https://lh5.googleusercontent.com/-U_7oEPwYbAo/AAAAAAAAAAI/AAAAAAAAAAA/ACHi3rcWzaCEAmnr4KktXnv-Bltsn9B3hQ/photo.jpg', 'drw8Vah2-Jo:APA91bHDRfcHSLFZZwYzIQT5bzjTvwuNG7XPDsUI6o2-Hf1yyTgavBUvJ-KVC7yMzeyThIOhZHRZvBZiGkiAlkLfKywRniQq560giV6TzJm9JsNh5S00MsvoivzBfjbPeCWo-6RUvpvm', 'f19a7f9a67e39b69', 'android', 'google', '106861640309068433967', 11.02979600, 76.94633250, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-11-11 16:48:46', '2019-11-11 22:48:20'),
(10, 'Praveen', 'S', 'CASH', 'praveen@ngfot.com', NULL, '$2y$10$n0z3/dgt.XYMkNLw.dtP4.spAB5hnbNoQZBcBCKXWCADCXzdRKQqe', 'https://graph.facebook.com/v2.8/559294778163389/picture?type=normal', NULL, NULL, 'android', 'facebook', '559294778163389', NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-11-11 17:03:00', '2019-11-11 17:03:00'),
(11, 'sha', 'test', 'CASH', 'shatester@gmail.com', '+919500698960', '$2y$10$recYKzP.jfgaZc4uE4HS8e.z24T75SIC0t0SrQ7M9QuEbEtVcqMV2', NULL, NULL, NULL, 'android', 'manual', NULL, NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, 'FHggV3MY3hyQUYPHOZuX46jgB3zP0B4xA4lBWRweZTWhdvmNb31sKkhwn1G4', '2019-11-11 17:16:19', '2019-11-11 17:16:24'),
(12, 'John', 'Son', 'CASH', 'playstorecnx13@gmail.com', '+916366356726', '$2y$10$KCDZx9hA2Tf4wFgOTJVuyuEYPzMLFEzOTxU5BbVbC3PScHv3dyR92', '', 'e9JZsQ07yFw:APA91bEYTsc5GokFlCi5ZVsOT17YWN1yakqJ1ju4vAWYDMbFh-E67nSCSZX3LpIU8DH1QL4-Dm-sEJWqkP1s3KaLpWLxfh0VPdFe1FSaz8aKe6m0vmg59oILMenoHqOmT1TshLxNp_9g', '6dc31538bb8cf503', 'android', 'manual', '', NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-11-14 18:01:19', '2019-11-14 18:01:19'),
(13, 'james', 'mattis', 'CASH', 'ff@g.com', '+6161401402766', '$2y$10$3ZW3Av8.6X6VR6.O5K4nV.uUu29iT3plOfN3VWq9Kmtkguo96k.ne', NULL, NULL, NULL, 'android', 'manual', NULL, NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 8, NULL, 0, NULL, '2019-11-26 17:40:56', '2019-11-26 17:50:29'),
(14, 'Paramveer', 'Dhaliwal', 'CASH', 'paramdhaliwal@gmail.com', '+61481833614', '$2y$10$kd4vbyWZI2SNEsuyX37C/ugwbz0nzBldMwhtMBVzx0EEcz.Ew5YuG', '', 'eLLdGOoHT_4:APA91bHAys57sbfjQp7KQHhopxjzf8NndKkg_0s5bZwfS8b0ldsSmwOIUu-Ex6vb14trEeRy-Yqp_RSpGIhqN3jytAdUWtHjQh9MBj4Ye0AcoO0g_mp_aINUMsEwHyM8GOT4xW3wORWQ', 'ecc74828e6cb2a99', 'android', 'manual', '', -37.95209710, 145.14017010, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-11-29 11:45:01', '2019-11-29 13:38:44'),
(15, 'Darrell', 'Dear', 'CASH', 'daz3129@gmail.com', '+61402604995', '$2y$10$KN5vXrTtQwMvZbQpnlQaGOL7KTu.gEFQn3JNCFkmKlUvg54yFDMXu', '', 'dqToa-5nJdE:APA91bGhiQIQvZb4rguz7QT34ox516wDPESfchMtoSPsUtWnmb2gjCpOYAkmhQeVnbcxf_1DkSPCPUCWUzdxEQ1CiOMcoSCxhiOINDh-Jy_9XNDpkpmvAG3UKT1I4LvjgVk7s9AiqM2d', 'd216112f1ce20d89', 'android', 'manual', '', NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-12-28 11:23:44', '2019-12-28 11:23:44'),
(16, 'Darrell', 'Dear', 'CASH', 'darrelldear@gmail.com', '+61402604995', '$2y$10$8vWmCzCYhFPCjC5EKdNhT.4ixju09O2GRtJjrl2MCdV.RSSLBRd9q', '', 'dqToa-5nJdE:APA91bGhiQIQvZb4rguz7QT34ox516wDPESfchMtoSPsUtWnmb2gjCpOYAkmhQeVnbcxf_1DkSPCPUCWUzdxEQ1CiOMcoSCxhiOINDh-Jy_9XNDpkpmvAG3UKT1I4LvjgVk7s9AiqM2d', 'd216112f1ce20d89', 'android', 'manual', '', -37.82602020, 144.95771900, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2019-12-28 11:25:04', '2019-12-28 12:49:04'),
(17, 'Kulwinder', 'kaur', 'CASH', 'kk1786688@gmail.com', '+919877996609', '$2y$10$PYHVAkSWJcpcj/TtYmPJCutIliaE3gjhugl8Rw4ByNUQ20HOPl51i', '', 'd4U6yvmwHrE:APA91bHX5CYhM5KizOYs3r50WXSDqc30xMBW9Nx49oN3f4o8BtuJsYEBCY6ynjX5uRm7kq83zThz4qCc4tkDM4CKS8wFn9_7Jf912CGR6qpQMBmL1VehlVItVV45veRGVIRm3pwMUQi1', '710db8d55c5ef10f', 'android', 'manual', '', NULL, NULL, 0, NULL, 0.00, 0.00, NULL, 5.00, 5, NULL, 0, NULL, '2020-01-01 19:43:31', '2020-01-01 19:43:31');
-- --------------------------------------------------------
--
-- Table structure for table `user_requests`
--
CREATE TABLE `user_requests` (
`id` int(10) UNSIGNED NOT NULL,
`booking_id` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
`user_id` int(11) NOT NULL,
`provider_id` int(11) NOT NULL DEFAULT '0',
`current_provider_id` int(11) NOT NULL,
`service_type_id` int(11) NOT NULL,
`status` enum('SEARCHING','CANCELLED','ACCEPTED','STARTED','ARRIVED','PICKEDUP','DROPPED','COMPLETED','SCHEDULED','END') COLLATE utf8_unicode_ci NOT NULL,
`push` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`cancelled_by` enum('NONE','USER','PROVIDER','DISPATCHER','REJECTED','NODRIVER') COLLATE utf8_unicode_ci NOT NULL,
`cancel_reason` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`booking_by` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`payment_mode` enum('CASH','CARD','PAYPAL') COLLATE utf8_unicode_ci NOT NULL,
`paid` tinyint(1) NOT NULL DEFAULT '0',
`distance` double(15,2) NOT 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) NOT NULL,
`d_longitude` double(15,8) NOT NULL,
`driver_message` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`assigned_at` timestamp NULL DEFAULT NULL,
`schedule_at` timestamp NULL DEFAULT NULL,
`accepted_at` timestamp NULL DEFAULT NULL,
`started_at` timestamp NULL DEFAULT NULL,
`finished_at` timestamp NULL DEFAULT NULL,
`waiting_time` time DEFAULT NULL,
`tip_percent` double(8,2) NOT NULL DEFAULT '0.00',
`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,
`deleted_at` timestamp NULL DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `user_requests`
--
INSERT INTO `user_requests` (`id`, `booking_id`, `user_id`, `provider_id`, `current_provider_id`, `service_type_id`, `status`, `push`, `cancelled_by`, `cancel_reason`, `booking_by`, `payment_mode`, `paid`, `distance`, `s_address`, `s_latitude`, `s_longitude`, `d_address`, `d_latitude`, `d_longitude`, `driver_message`, `assigned_at`, `schedule_at`, `accepted_at`, `started_at`, `finished_at`, `waiting_time`, `tip_percent`, `user_rated`, `provider_rated`, `use_wallet`, `surge`, `route_key`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'TRNX704863', 3, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CASH', 1, 0.00, '45/32, Balasubramaniam Road,Coimbatore,India', 11.02974798, 76.94629222, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02973586, 76.94633036, '', '2019-11-07 21:17:24', NULL, '2019-11-07 21:17:33', '2019-11-07 21:18:22', '2019-11-07 21:18:53', '00:00:13', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-07 21:17:24', '2019-11-07 23:15:14'),
(2, 'TRNX939022', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CARD', 1, 0.59, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02982430, 76.94618080, '189, 4th St, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977060, 76.94606470, NULL, '2019-11-07 21:20:02', NULL, NULL, '2019-11-07 21:20:04', '2019-11-07 21:21:56', '00:01:48', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-07 21:20:02', '2019-11-07 21:35:55'),
(3, 'TRNX418178', 4, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.05, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02979617, 76.94638585, NULL, '2019-11-07 21:32:24', NULL, NULL, '2019-11-07 21:32:26', '2019-11-07 21:32:51', '00:00:10', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-07 21:32:24', '2019-11-07 21:33:11'),
(4, 'TRNX288175', 3, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02969430, 76.94635570, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977460, 76.94636160, '', '2019-11-07 23:19:59', NULL, '2019-11-07 23:20:07', '2019-11-07 23:22:23', '2019-11-07 23:23:14', '00:00:43', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-07 23:19:25', '2019-11-07 23:28:35'),
(5, 'TRNX280132', 3, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CARD', 1, 0.01, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02965060, 76.94640310, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02974031, 76.94632751, '', '2019-11-07 23:44:10', NULL, '2019-11-07 23:44:15', '2019-11-07 23:45:06', '2019-11-07 23:45:21', '00:00:08', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-07 23:44:10', '2019-11-07 23:50:46'),
(6, 'TRNX670738', 3, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CASH', 1, 0.00, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02977298, 76.94633611, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02978365, 76.94631999, '', '2019-11-08 00:50:26', NULL, '2019-11-08 00:50:34', '2019-11-08 00:50:47', '2019-11-08 00:50:52', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 00:50:26', '2019-11-08 15:52:12'),
(7, 'TRNX939593', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977130, 76.94631340, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977090, 76.94631500, NULL, '2019-11-08 16:32:17', NULL, NULL, '2019-11-08 16:32:19', '2019-11-08 17:33:36', '00:56:10', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 16:32:17', '2019-11-08 17:34:13'),
(8, 'TRNX115392', 4, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.05, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977383, 76.94626104, NULL, '2019-11-08 16:41:49', NULL, NULL, '2019-11-08 16:41:51', '2019-11-08 16:41:57', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 16:41:49', '2019-11-08 16:42:23'),
(9, 'TRNX264077', 4, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.04, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02975238, 76.94634369, NULL, '2019-11-08 17:09:01', NULL, NULL, '2019-11-08 17:09:03', '2019-11-08 17:09:16', '00:00:09', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 17:09:01', '2019-11-08 17:09:57'),
(10, 'TRNX358920', 6, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CARD', 1, 0.18, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02971500, 76.94632170, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02981060, 76.94628560, '', '2019-11-08 18:38:17', NULL, '2019-11-08 18:38:27', '2019-11-08 18:41:06', '2019-11-08 18:43:47', '00:02:37', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 18:37:51', '2019-11-08 18:44:49'),
(11, 'TRNX218628', 6, 0, 4, 1, 'CANCELLED', NULL, 'USER', '', 'APP', 'CASH', 0, 3.99, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977300, 76.94631190, 'Gandhipuram, Coimbatore, Tamil Nadu, India', 11.01758450, 76.96740750, '', '2019-11-08 18:52:37', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-08 18:52:37', '2019-11-08 18:52:48'),
(12, 'TRNX213752', 6, 0, 4, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CASH', 0, 28.12, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977000, 76.94631550, 'Vadavalli, Tamil Nadu 641104, India', 11.23886150, 76.99757980, '', '2019-11-08 18:53:19', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-08 18:53:07', '2019-11-08 18:53:29'),
(13, 'TRNX847709', 6, 4, 4, 1, 'CANCELLED', NULL, 'USER', '', 'APP', 'CASH', 0, 28.12, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976960, 76.94631620, 'Vadavalli, Tamil Nadu 641104, India', 11.23886150, 76.99757980, '', '2019-11-08 18:54:01', NULL, '2019-11-08 18:54:08', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-08 18:53:51', '2019-11-08 18:54:34'),
(14, 'TRNX451497', 6, 4, 4, 1, 'CANCELLED', NULL, 'PROVIDER', '', 'APP', 'CASH', 0, 12.24, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976970, 76.94631720, 'Kamarajar Rd, Singanallur, Tamil Nadu 641005, India', 11.00253500, 77.02893380, '', '2019-11-08 18:55:31', NULL, '2019-11-08 18:55:39', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-08 18:55:19', '2019-11-08 18:55:53'),
(15, 'TRNX535103', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.37, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02975000, 76.94630830, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977170, 76.94635500, NULL, '2019-11-08 18:56:08', NULL, NULL, '2019-11-08 18:56:11', '2019-11-08 18:56:47', '00:00:33', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 18:56:08', '2019-11-08 18:56:55'),
(16, 'TRNX179881', 6, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CASH', 0, 3.99, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977210, 76.94631440, 'Gandhipuram, Tamil Nadu, India', 11.01758450, 76.96740750, '', '2019-11-08 18:56:21', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-08 18:56:21', '2019-11-08 18:56:28'),
(17, 'TRNX901540', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 11.47, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977170, 76.94633330, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02983650, 76.94656330, NULL, '2019-11-08 19:30:32', NULL, NULL, '2019-11-08 19:30:33', '2019-11-08 20:24:32', '00:52:54', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 19:30:32', '2019-11-08 20:32:01'),
(18, 'TRNX729970', 4, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02976590, 76.94631880, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631460, NULL, '2019-11-08 19:31:46', NULL, NULL, '2019-11-08 19:31:47', '2019-11-08 20:24:29', '00:51:19', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 19:31:46', '2019-11-08 20:25:00'),
(19, 'TRNX711814', 4, 3, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 4.01, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Gandhipuram, Tamil Nadu, India', 11.01758400, 76.96740700, NULL, '2019-11-08 21:13:32', NULL, NULL, '2019-11-08 21:13:33', NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-08 21:13:32', '2019-11-08 21:13:38'),
(20, 'TRNX327398', 4, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.05, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02981071, 76.94632525, NULL, '2019-11-08 21:14:35', NULL, NULL, '2019-11-08 21:14:37', '2019-11-08 21:14:45', '00:00:03', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-08 21:14:35', '2019-11-08 21:15:35'),
(21, 'TRNX940714', 3, 0, 4, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CARD', 0, 28.11, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02978286, 76.94631778, 'Vadavalli, Tamil Nadu 641104, India', 11.23886200, 76.99758000, '', '2019-11-11 17:49:42', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 17:48:42', '2019-11-11 17:50:42'),
(22, 'TRNX251009', 3, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CARD', 0, 3.99, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02978286, 76.94631778, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, '', '2019-11-11 17:52:27', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 17:51:19', '2019-11-11 17:52:57'),
(23, 'TRNX755410', 6, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'DISPATCHER', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02980410, 76.94623730, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02980490, 76.94623190, '', '2019-11-11 17:54:56', NULL, '2019-11-11 17:55:43', '2019-11-11 17:57:25', '2019-11-11 17:57:31', '00:00:03', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 17:54:17', '2019-11-11 17:58:41'),
(24, 'TRNX706988', 3, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CARD', 0, 3.99, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02978286, 76.94631778, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, '', '2019-11-11 17:54:30', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 17:54:18', '2019-11-11 17:55:30'),
(25, 'TRNX829417', 3, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CARD', 0, 0.87, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02978286, 76.94631778, 'Saibaba Colony, Tamil Nadu, India', 11.02375200, 76.94521700, '', '2019-11-11 18:48:52', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 18:48:35', '2019-11-11 18:49:19'),
(26, 'TRNX920824', 6, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', '', 'DISPATCHER', 'CASH', 0, 165.69, 'Coimbatore, Tamil Nadu, India', 11.01684450, 76.95583210, 'Namakkal, Tamil Nadu, India', 11.21943910, 78.16772360, '', '2019-11-11 18:57:01', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, 'cvfbAylutMS_NuKf@_CyFtBwEkIqw@sCqnAd@}Zk@yBlA{QpCcLyJg^_AuOkGiTgIccAyDwe@_La\\qcAswAq`@mw@_Wkn@iYka@o\\in@{Cmz@y[glARE|D`EqByC_LaQqHkPuQe_@{]wn@kq@enAgd@ut@kK}[mHk]}Nsw@me@srAmK__@}Nw_@mPqYmQaSc[{O}MmMsTo\\{Zwc@}JkIgMcCmMsDuQeKgRkM{HkBaZwFun@e]_N{J{Sub@aJcUsMgSae@mg@}e@ig@_Qi[DabAhBij@fQg{@sN}gAiIeOc}@qPwIoE}F}IqSuRaLyO_Qej@_@cp@qDyx@{WqzAiFae@aDyFgMcHk]{HkJeFaGcJyD{j@vFac@~`@aw@fO}Uj@uKpC}hAzLqq@bYqw@zDwl@l@as@sJiWqf@ay@uMwe@qo@}v@_F}MeCaT_Sq_@mJmJqGyNuKe\\gMuLqGmLcRyy@_U}u@oNaXe@mLvBmL`Ou\\JaPyFyQqK_MeS}\\eQic@iH{d@kOo_AcPg^qMaYeJwMe]uOsU_Gqu@}K_u@qPwKcGsI_LsNe\\mIad@qB}x@yA}e@_GyRyRwZyLuPmMcMge@_YsSi\\m^cb@oU_d@mPqWmd@mZe^iDkh@{CqLqLaS}k@mM{KoWmIsx@cOkd@sEsn@}Ouj@{YgQ_BiLjAmn@jR}Q_@_PqFyf@wd@_Vmf@kMye@cEwKiLmL{MsEs[?ai@bGoJyAaImHoAiTlCai@AaVk_@{`B_@cGrBcFpKwKhDgDxC{NxJoVjEyLjAcQqAc[zEqo@lBah@|LeUxFoYnSsb@zHe[xHiT|NgQ|EcMbIsQhEmO|E_G`JwDfB_T\\wMvDaJjFwNvFe[fCuXdAyVtBsPrD}TnGsSdDiLtHeHzEgOrAuLtA{OzGiI~F{GrFiOmBiKuEmBvCaZcBuE[iIxAmXjLgr@dGul@rAeIzGmHtToa@lJ_m@rAc^d@qUjCoMnH{QtDkVpCwXyCsLiAmBMeJlDsAvDE|@uCgCiH`BmRAuSrBwUxK_[xHeZrJi`@fQs_@nCm[h@oR~KgY|b@ul@j]kWhI}K|VgXpi@kiApOy`@fHwc@lIys@z@{\\tLur@pCyXvFsSfLgSdS{e@~[ch@v\\m_@hTiM~t@sY`i@so@n\\mYfLaUzQwy@bM}_@tP{QpXqOvFqQxGuOpTgPlm@yo@fYw`@xE}SvTo}@tKoO|OaGfJuSfMuk@|Kqg@zLsSpTkZrLg]tGmOxAyU`EyPfO_UtWe\\hYmV`HoLlIgGnTwC', NULL, '2019-11-11 18:49:08', '2019-11-11 18:58:01'),
(27, 'TRNX254766', 3, 0, 4, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CARD', 0, 3.99, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02978286, 76.94631778, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, '', '2019-11-11 18:50:44', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 18:50:04', '2019-11-11 18:50:54'),
(28, 'TRNX675120', 3, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'APP', 'CARD', 0, 0.87, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02978286, 76.94631778, 'Saibaba Colony, Tamil Nadu, India', 11.02375200, 76.94521700, '', '2019-11-11 18:51:36', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 18:51:27', '2019-11-11 18:51:47'),
(29, 'TRNX258812', 3, 5, 5, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CARD', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976470, 76.94632400, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977120, 76.94631430, '', '2019-11-11 18:56:55', NULL, '2019-11-11 18:57:02', '2019-11-11 18:57:58', '2019-11-11 18:58:49', '00:00:02', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 18:53:00', '2019-11-11 19:03:06'),
(30, 'TRNX244584', 4, 0, 4, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 28.11, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977420, 76.94632820, 'Vadavalli, Tamil Nadu 641104, India', 11.23886150, 76.99757980, NULL, '2019-11-11 19:02:29', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 19:02:29', '2019-11-11 19:02:54'),
(31, 'TRNX114258', 4, 0, 4, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.86, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02972450, 76.94629200, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 19:05:54', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 19:05:54', '2019-11-11 19:06:27'),
(32, 'TRNX369186', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', '', 'DISPATCHER', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02976840, 76.94631880, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:08:32', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 19:09:05', '2019-11-11 20:08:51'),
(33, 'TRNX615528', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977710, 76.94631000, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:09:40', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:09:40', '2019-11-11 20:10:40'),
(34, 'TRNX790560', 4, 5, 5, 1, 'CANCELLED', NULL, 'PROVIDER', '', 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02978010, 76.94630550, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:13:55', NULL, '2019-11-11 20:14:03', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:13:55', '2019-11-11 20:14:40'),
(35, 'TRNX543243', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977620, 76.94630630, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:14:53', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:14:53', '2019-11-11 20:15:05'),
(36, 'TRNX334813', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977450, 76.94631100, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:23:11', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:23:11', '2019-11-11 20:23:24'),
(37, 'TRNX891919', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977260, 76.94631610, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:26:37', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:26:37', '2019-11-11 20:27:37'),
(38, 'TRNX831435', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976227, 76.94629692, 'Saibaba Colony, Tamil Nadu, India', 11.02375200, 76.94521700, NULL, '2019-11-11 20:28:35', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:28:35', '2019-11-11 20:29:04'),
(39, 'TRNX413420', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02976980, 76.94631860, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:28:55', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:28:55', '2019-11-11 20:29:03'),
(40, 'TRNX683318', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.88, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Saibaba Colony, Tamil Nadu, India', 11.02375200, 76.94521700, NULL, '2019-11-11 20:29:14', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:29:14', '2019-11-11 20:30:16'),
(41, 'TRNX728158', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977010, 76.94631360, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:32:41', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:32:41', '2019-11-11 20:32:56'),
(42, 'TRNX724009', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 1123.57, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Sant Nagar, Moshi Pradhikaran, Pune - Nashik Highway,, Moshi, Sector Number 4, Moshi, Pune, Maharashtra 412105, India', 18.65454000, 73.84850500, NULL, '2019-11-11 20:33:12', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:33:12', '2019-11-11 20:33:23'),
(43, 'TRNX269792', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977020, 76.94631380, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:34:27', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:34:27', '2019-11-11 20:34:59'),
(44, 'TRNX515700', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02976950, 76.94631560, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:35:37', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:35:37', '2019-11-11 20:35:48'),
(45, 'TRNX543924', 4, 0, 5, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India, Coimbatore', 11.02977180, 76.94631560, 'Saibaba Colony, Tamil Nadu, India', 11.02375240, 76.94521730, NULL, '2019-11-11 20:40:00', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:40:00', '2019-11-11 20:40:36'),
(46, 'TRNX192348', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976440, 76.94632410, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976440, 76.94632410, NULL, '2019-11-12 00:37:49', NULL, '2019-11-12 00:38:19', '2019-11-12 00:41:41', '2019-11-12 00:41:43', '00:00:02', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:40:04', '2019-11-12 00:43:31'),
(47, 'TRNX814681', 4, 5, 5, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631470, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631470, NULL, '2019-11-11 20:45:57', NULL, NULL, '2019-11-11 20:45:59', '2019-11-11 20:46:31', '00:00:11', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:45:57', '2019-11-11 20:48:01'),
(48, 'TRNX906900', 4, 5, 5, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977170, 76.94631610, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976510, 76.94632380, NULL, '2019-11-11 20:48:46', NULL, NULL, '2019-11-11 20:48:48', '2019-11-11 20:49:10', '00:00:08', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:48:46', '2019-11-11 20:50:40'),
(49, 'TRNX388961', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977610, 76.94632060, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977570, 76.94630410, NULL, '2019-11-11 20:48:47', NULL, NULL, '2019-11-11 20:48:50', '2019-11-11 20:49:07', '00:00:10', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:48:47', '2019-11-11 20:50:37'),
(50, 'TRNX716099', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 57.90, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Tiruppur, Tamil Nadu, India', 11.10852400, 77.34106600, NULL, '2019-11-11 20:48:47', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:48:47', '2019-11-11 20:49:47'),
(51, 'TRNX834215', 4, 0, 0, 1, 'CANCELLED', NULL, 'NODRIVER', '', 'DISPATCHER', 'CASH', 0, 4.01, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, NULL, '2019-11-12 00:40:17', NULL, '2019-11-12 00:37:03', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-11 20:49:41', '2019-11-12 00:40:17'),
(52, 'TRNX889068', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977240, 76.94631590, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976510, 76.94632390, NULL, '2019-11-11 21:25:22', NULL, '2019-11-11 21:25:41', '2019-11-11 21:26:08', '2019-11-11 21:26:14', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:50:24', '2019-11-11 21:26:22'),
(53, 'TRNX564814', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.18, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977330, 76.94631290, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977310, 76.94633160, NULL, '2019-11-11 20:53:05', NULL, NULL, '2019-11-11 20:53:07', '2019-11-11 20:54:49', '00:01:17', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:53:05', '2019-11-11 20:54:58'),
(54, 'TRNX586443', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.55, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631470, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977480, 76.94632120, NULL, '2019-11-11 20:55:34', NULL, NULL, '2019-11-11 20:55:37', '2019-11-11 20:56:09', '00:00:24', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:55:34', '2019-11-11 20:56:19'),
(55, 'TRNX503101', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631470, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631470, NULL, '2019-11-11 20:56:44', NULL, NULL, '2019-11-11 20:56:47', '2019-11-11 21:22:02', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 20:56:44', '2019-11-11 21:23:40'),
(56, 'TRNX349031', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.17, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976480, 76.94632390, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976520, 76.94632180, NULL, '2019-11-11 21:26:34', NULL, NULL, '2019-11-11 21:26:37', '2019-11-11 21:27:14', '00:00:21', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 21:26:34', '2019-11-11 21:27:21'),
(57, 'TRNX182338', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.17, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631470, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977300, 76.94631490, NULL, '2019-11-11 21:29:54', NULL, NULL, '2019-11-11 21:29:56', '2019-11-11 21:30:23', '00:00:10', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 21:29:54', '2019-11-11 21:30:50'),
(58, 'TRNX898964', 5, 0, 0, 1, 'CANCELLED', NULL, 'REJECTED', '', 'DISPATCHER', 'CASH', 0, 378.71, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976490, 76.94632610, 'Ramamurthy Nagar, Bengaluru, Karnataka 560016, India', 13.01631340, 77.67848120, '', '2019-11-12 00:40:05', NULL, '2019-11-12 00:35:52', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, 'cgibAirstM~PiO`YcP`TkHjMw]eK}KeLugAs@o{AaE_kAeUavBsb@afA}~@yrA{n@izAwr@_mAyGwfAiSww@q}AqvCynAucC_g@kqBsy@}_CmpBazBwrBk}@cfAko@aaAybB_fAokARg`BfLclBkNuw@_TcIygA{f@o]}c@_Ocn@cTaxCsN{dA}RmOuh@uP}Jga@zT_rAlb@ws@fAui@je@ajCtLkcBaTin@i}@}dBquAwmCemAwdDsC_s@hL{]aMcb@ye@ax@eWitAm]qiAeb@ig@mq@{PqhBk`@ki@w~A}@s}@}l@_xAeoAijAegAi_BwrAwWcWwHaa@e|@}`Bu`@yvAc\\ybAkPms@xPoz@me@mm@w|A_W_Vsm@k@{l@lAqFsq@iEaeAw\\_sAwj@ecAmIgeEkZ{kAnFseAeYatAmGslCwFkb@g~@wc@y}@aiActAkgBqTk}AdG}|D}t@ssAaoBuiC}gAoeCg]sT{BoXav@oaCq|AawEykCemF_}A_aE{dAwoAaW_^caA_Yke@wr@{bAuGa^aNkfBuHcgAwc@wt@tD_s@d|@eaA|lAep@jjAapBvhDocAxhAog@nQayBoGymBqd@g}CuHoqBch@mdB}Cex@eNmnA__Ayl@eZcf@jHi|@dn@y~@`~@ebAj^we@bEkd@kScgAkQoSnImMbl@mu@js@_fAq@qm@wT{QvH}a@mMilAmbAqgAcr@g`CewBsk@gt@u`C{h@erGuq@{mBysAusEonAg~AelAk`AqgAy`CktAkdAyWw{@cf@qfB_Vo{@eUaqAmH}e@qVkq@`S}rDeKis@gn@m~BkCujBgn@}bChF_qBeVciCiAci@{Xwy@{NyeAqLepAla@coAvRy`BpWseD_c@o{@iVim@pWwlBjoA}tAn[ek@`c@wPhd@soA`pA{p@`l@ku@neAse@zlAk`@dq@}j@tr@m`@dnAoA`k@qUfdBau@jaAi~@bf@sv@dm@}e@|{Agk@xcCqaAhuBud@t`CmXr{Bim@jxAw[rdCie@|hB{{BtkCcJnx@m[lo@u{@t{CoPdxAu^`u@uZxfA_v@v{@{q@rfAsx@hx@s~@|bAu]viAor@h`Eui@tmBo`@b`@aPh_AmgA~jAm|@lt@e`A|[ukCjcBqyDbjCu_DbbBe_@bPhEsoAwL_e@_d@}f@fLibA{DcfAuf@urA}`AygAi{Bac@oo@yAaf@lVmu@h`@c_Arh@il@vn@e@aQsBqKiNzCxJtS~AtD{Weg@eOvFUZmJzDa_@fWwH@', NULL, '2019-11-11 22:32:49', '2019-11-12 00:42:02'),
(59, 'TRNX124084', 6, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CARD', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977130, 76.94631680, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977270, 76.94631610, '', '2019-11-11 22:52:14', NULL, '2019-11-11 22:52:42', '2019-11-11 22:53:27', '2019-11-11 22:53:36', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 22:52:14', '2019-11-11 22:54:07'),
(60, 'TRNX765778', 6, 4, 4, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CARD', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976550, 76.94632370, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976550, 76.94632400, '', '2019-11-11 23:22:43', NULL, '2019-11-11 23:22:59', '2019-11-11 23:29:03', '2019-11-11 23:29:09', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 23:01:54', '2019-11-12 00:08:57'),
(61, 'TRNX320662', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977250, 76.94631610, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631470, NULL, '2019-11-11 23:11:15', NULL, NULL, '2019-11-11 23:11:17', '2019-11-11 23:15:00', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-11 23:11:15', '2019-11-11 23:21:20'),
(62, 'TRNX946251', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977290, 76.94633100, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977160, 76.94631600, NULL, '2019-11-12 00:30:38', NULL, NULL, '2019-11-12 00:30:40', '2019-11-12 00:32:52', '00:01:13', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-12 00:30:38', '2019-11-12 00:33:01'),
(63, 'TRNX143142', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 4.01, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, NULL, '2019-11-13 15:36:34', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-13 15:36:34', '2019-11-13 15:37:36'),
(64, 'TRNX995049', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977080, 76.94631750, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977060, 76.94631680, NULL, '2019-11-13 15:39:21', NULL, NULL, '2019-11-13 15:39:23', '2019-11-13 15:39:35', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-13 15:39:21', '2019-11-13 15:39:42'),
(65, 'TRNX573976', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 4.01, '101-C, Balasubramaniam 4th cross street, state bank colony, Kuppakonam Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02949447, 76.94676252, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, NULL, '2019-11-13 15:41:40', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-13 15:41:40', '2019-11-13 15:43:01'),
(66, 'TRNX920505', 4, 0, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 0, 3.99, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976922, 76.94628166, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, NULL, '2019-11-13 15:44:55', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-13 15:44:55', '2019-11-13 15:45:55'),
(67, 'TRNX978339', 4, 3, 3, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'STREET', 'CASH', 1, 0.01, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02978800, 76.94624771, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02984617, 76.94630438, NULL, '2019-11-13 15:58:10', NULL, NULL, '2019-11-13 15:58:24', '2019-11-13 15:59:54', '00:00:58', 0.00, 1, 0, 0, 0, '', NULL, '2019-11-13 15:58:10', '2019-11-13 16:00:09'),
(68, 'TRNX518678', 4, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02978569, 76.94629013, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02979051, 76.94631041, NULL, '2019-11-13 16:01:23', NULL, NULL, '2019-11-13 16:01:25', '2019-11-13 16:01:45', '00:00:08', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-13 16:01:23', '2019-11-13 16:12:11'),
(69, 'TRNX500103', 4, 3, 3, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02973125, 76.94630706, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02973125, 76.94630706, NULL, '2019-11-13 16:12:33', NULL, NULL, '2019-11-13 16:12:36', '2019-11-13 16:12:43', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-13 16:12:33', '2019-11-13 16:13:16'),
(70, 'TRNX687034', 6, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976670, 76.94631620, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977000, 76.94631540, '', '2019-11-15 17:43:39', NULL, '2019-11-15 17:44:32', '2019-11-15 17:45:29', '2019-11-15 17:45:51', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-15 17:43:39', '2019-11-15 17:47:02'),
(71, 'TRNX378370', 6, 0, 3, 1, 'CANCELLED', NULL, 'DISPATCHER', '', 'DISPATCHER', 'CASH', 0, 101.94, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977950, 76.94632410, 'Erode, Tamil Nadu, India', 11.34103640, 77.71716420, '', '2019-11-15 17:48:20', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, 'ggibAirstM`MaAnB_An@g@]_JOsLpFW~QwA`TkH`LwChA_@XiAIyG@uHA}Bo@G{GZeBL{AeCYeCpB{D?GBEiLggAo@scAZmMr@mFsA_A@_FdAkGAeFdAeFp@aAf@qAe@q@kC_F_BcG{BsOYiG{@uG_DyIqDsVgDi^cAaYkAqQwBgQ_DgJcHwPwPyVySgZsOyRoYwc@oLuV{Nwc@oQ{]sDaHmGmGkFoGmJgQaOcXyAsGe@}a@eBaUmCwMsUku@g@wDpBjBzB|AeD}DsK{PkUag@gy@syA_m@agAoCqC}E{HqHmMyKw^_DsNBgAgCkJuFa[eFiX_Ow^wAsGcJcTwPgo@oCuFcI}QyCmKqF{J_IoMcJcMiHuEcMsEsMyJsGuF{CiEmWu_@iOsUiGuHgFyEuFeCgKqAoMuEoO{IiRiMgJsBuQsB{f@iWcVkNcGuGaS}a@aLiXeD_GcGwGeJoJmGiJmQyPqQgSgSaSwLkQwAkGIyWAy`@^cJvAcRLkW~CgP|Ji`@^iFcD{YsJup@wB_FmEoDqMsCcp@kLqG{DcNsSiMuIiGqH{FuO{Ls`@cAoLdAml@gAaUsAoRgEyUeKgj@gEsUuAiN_CqVuAkGeDuFcFqDsFeBo^mIeIgF{CgE{AwDiAqG{@uL[sSrAsQnDwPvD_KzG_M~KcSdIaMlFaHxCoHl@}PXwWdCgp@rDsRhGwYfSmj@rDmKxAsLfDiiAq@qHsD_L{LwWaY_a@{DwIaCeJ_B{K{A{EoDgG}M_Q_WeY}G_JaCmFqAkF}@cKmAkH{BqFsKcSoJuJqGaKaEyPcE}LcKyKgEeEiDmF_EsNeGm\\mQsi@cFaVqCgHaCkD}G_LcBgK@_Gp@gFxDoJnHwMzAaH\\aF]aJoBqIsHoLuFcG{GoJgUmd@eFeR}AkLaMws@mD_YyDiMkIiOyG}PsNkYiEuDgLgGqReHgKmCsQgCk[aEi_@iIm\\oHgFuAeGyCwGuGgM}T{EyMaBqHqF}[{@yJm@s]O__@{AmVqAuFyDaJkS_[iMyQmDuDkFqDmTyLkP_L_EgGcGsLmMkNyQwSuRu]cOyZcHwHmGiF{TyMcEcCcAc@Sc@H]Dq@wCiCgKuImU}PqIyImHeFsAw@Hg@DuAOkFKoBw@gAeAw@OeKMcPXcEjDiO_B{OCoCwBqDmAaGGiHb@}JrCuFlAsLdCeRfCgKh@_i@\\kPaAaQeHoRcI}RmHwUgEoU{FsQw@yCp@kI\\wYrBwY`DyUvA{RtCcRTeB', NULL, '2019-11-15 17:47:39', '2019-11-15 17:49:32'),
(72, 'TRNX191971', 2, 4, 4, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976500, 76.94632370, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976500, 76.94632370, 'gfhgfg', '2019-11-15 17:50:59', NULL, '2019-11-15 17:51:19', '2019-11-15 17:51:25', '2019-11-15 17:51:28', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-15 17:50:23', '2019-11-15 17:54:03'),
(73, 'TRNX294845', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976440, 76.94632450, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976490, 76.94632380, NULL, '2019-11-15 17:54:36', NULL, NULL, '2019-11-15 17:54:38', '2019-11-15 17:54:57', '00:00:05', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-15 17:54:36', '2019-11-15 17:55:09'),
(74, 'TRNX628059', 6, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'WEB', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977270, 76.94631570, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977260, 76.94631590, '', '2019-11-15 18:06:12', NULL, '2019-11-15 18:06:31', '2019-11-15 18:06:47', '2019-11-15 18:06:54', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-15 18:06:12', '2019-11-15 18:07:15'),
(75, 'TRNX806718', 6, 0, 0, 4, 'CANCELLED', 'AUTO', 'NONE', '', 'APP', 'CARD', 0, 14.17, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631950, 'Ondi Pudur, Tamil Nadu, India', 11.00328610, 77.04901630, '', '2019-11-15 18:18:43', '2019-11-16 15:18:00', NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-15 18:18:07', '2019-11-16 15:18:02'),
(76, 'TRNX472756', 6, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'APP', 'CARD', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02979785, 76.94630681, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977170, 76.94631610, '', '2019-11-15 18:20:17', NULL, '2019-11-15 18:21:12', '2019-11-15 18:24:10', '2019-11-15 18:27:02', '00:01:15', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-15 18:20:17', '2019-11-15 18:29:08'),
(77, 'TRNX340493', 4, 0, 8, 1, 'CANCELLED', NULL, 'REJECTED', NULL, 'DISPATCHER', 'CASH', 0, 29.18, '24 Graham Road, Clayton South VIC, Australia', -37.95292400, 145.13581590, '300 Collins Street, Melbourne VIC, Australia', -37.81597000, 144.96422500, '', '2019-11-26 17:18:22', NULL, NULL, NULL, NULL, NULL, 0.00, 0, 0, 0, 0, 'trsfFgzytZr@yKaBQcGs@cGo@cDYaDe@iBUaCa@mAWeAOiAScFi@uC_@mC]y@IkBWy@GqAAk@?iABeFLaDM_Gq@eGo@_UaCmIaAuFq@mBOoC[{Ei@iC_@gD]}@OcBg@iAc@Y?g@CUDc@PoFtJyCrFsBlDuAUkC[yKkAmLkAqAImHw@yLuAmD_@mI_AmJcA{Gw@cEi@aGm@yIy@aFg@}BWa@CkGq@}JeA_Go@_CS_@EABMDKFKJm@nAEBK\\c@|Au@jDc@~CYvCEJGFc@zI[jG_@lGmB`^SxC_BfZwAvVQjBc@fDiAdGOp@cBdGq@hBwAlDsArCsAfC_B`DeBdEuA|D_AjDq@vCYvA_@hCq@tFu@lJwAfRqCf\\q@nHu@zHm@zDaAtEmAxEgCtHgAbCqB~DyGrL_DjGyBfEwA~C}DrJe@nAgA|Cm@vBg@nCK~@OdBEtB?tBLpEv@xSHzCAbBC`AUjC]bCOn@u@dC}@|B_AdB_B`CyA|A_BpAkAt@wAt@}OjFeA^cAd@aCrAmBtA_DpCeDxCiA|@_BbAwAp@kBn@kB`@q^dHaHrAgDn@iANyBh@mBh@qAf@_B|@gBjAkA~@cAhA{AxBu@jAuAzCgAjDoA~E_AtDm@jBu@~A}AnCaCbEu@zA_BrD]|@i@xBk@pDiAxIYrBk@rCiAzCQTu@pAu@lA_AhAeA`AiA|@s@d@}Ap@yBl@gBVmBH_IM{AC_CRwAP}Af@oAl@sBzAgAbAkA~Ag@|@mA|Cq@pCg@~CMbCCvBHzCDt@bA|HPnBD`A@xAEtAGx@U`Bg@pBc@jA{@`BqCxCsBhBsFpEmB|AqAnAqD|CgAlA_AxAw@hBYbA]xAc@dDmAxK}BjRQdBE~@CpBD|AH|@VbBXxAfBhGF^\\hCJbB?tACrAMvB_@zEMpBAhCFnAJv@b@zBX`Ap@xArDjGl@nAp@`B~@tCPt@l@hCz@lETrBDnAApAAn@O`Bk@~C}@jEk@nDEZWnBa@fBiAvCy@pA{@dAo@v@kCjCuFpFeCrBgD`CeBxAo@t@}@pAc@z@m@jBYtAaA`IQhC_@`FWxCw@lHWbDe@vIIbAIbBA~@Y`GWlFAdD@pAP~A`@fBlAfFd@vBhAlF\\h@L\\XrAn@vClApFh@nCZjBV`C?TFd@F\\VhAJr@_A|@aA|@_GzFwDzD{AzAgAv@m@XkAXiAL}@FaG^eB^}FvBmGxBgHdCkBp@EY[aBs@uDy@kEsBsKsAeHoAqGI_@|@Y`A]dA]`DiA', NULL, '2019-11-26 17:18:22', '2019-11-26 17:19:33'),
(78, 'TRNX187112', 4, 8, 8, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CASH', 1, 0.02, '24 Graham Rd, Clayton South VIC 3169, Australia', -37.95276101, 145.13577577, '28 Graham Rd, Clayton South VIC 3169, Australia', -37.95279155, 145.13603316, '', '2019-11-26 17:20:07', NULL, '2019-11-26 17:20:15', '2019-11-26 17:20:34', '2019-11-26 17:21:12', '00:00:34', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-26 17:18:23', '2019-11-26 17:24:24'),
(79, 'TRNX114263', 1, 8, 8, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CASH', 1, 0.00, '22 Graham Rd, Clayton South VIC 3169, Australia', -37.95281378, 145.13570082, '22 Graham Rd, Clayton South VIC 3169, Australia', -37.95280724, 145.13572589, '', '2019-11-26 17:38:07', NULL, '2019-11-26 17:38:15', '2019-11-26 17:38:31', '2019-11-26 17:38:36', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-26 17:32:08', '2019-11-26 17:38:54'),
(80, 'TRNX143639', 13, 8, 8, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CASH', 1, 0.00, '24 Graham Rd, Clayton South VIC 3169, Australia', -37.95273897, 145.13584424, '24 Graham Rd, Clayton South VIC 3169, Australia', -37.95279802, 145.13581373, '', '2019-11-26 17:41:34', NULL, '2019-11-26 17:41:38', '2019-11-26 17:41:48', '2019-11-26 17:41:51', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-26 17:40:56', '2019-11-26 17:41:58'),
(81, 'TRNX953658', 4, 8, 8, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.01, '24 Graham Rd, Clayton South VIC 3169, Australia', -37.95293226, 145.13592931, '24 Graham Rd, Clayton South VIC 3169, Australia', -37.95285984, 145.13586042, NULL, '2019-11-26 17:43:09', NULL, NULL, '2019-11-26 17:43:10', '2019-11-26 17:43:18', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-26 17:43:09', '2019-11-26 17:43:27'),
(82, 'TRNX763094', 4, 8, 8, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, '22 Graham Rd, Clayton South VIC 3169, Australia', -37.95284513, 145.13576629, '22 Graham Rd, Clayton South VIC 3169, Australia', -37.95287069, 145.13577224, NULL, '2019-11-26 17:43:58', NULL, NULL, '2019-11-26 17:43:59', '2019-11-26 17:44:03', '00:00:01', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-26 17:43:58', '2019-11-26 17:44:28'),
(83, 'TRNX318307', 13, 8, 8, 1, 'COMPLETED', NULL, 'NONE', '', 'DISPATCHER', 'CASH', 1, 0.00, 'Unit 1/22 Graham Rd, Clayton South VIC 3169, Australia', -37.95274476, 145.13565204, 'Unit 1/22 Graham Rd, Clayton South VIC 3169, Australia', -37.95275611, 145.13566277, '', '2019-11-26 17:47:44', NULL, '2019-11-26 17:48:21', '2019-11-26 17:48:32', '2019-11-26 17:48:34', '00:00:00', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-26 17:46:42', '2019-11-26 17:48:44'),
(84, 'TRNX906575', 13, 8, 8, 1, 'COMPLETED', NULL, 'NONE', NULL, 'DISPATCHER', 'CASH', 1, 0.00, '24 Graham Rd, Clayton South VIC 3169, Australia', -37.95275259, 145.13576335, '24 Graham Rd, Clayton South VIC 3169, Australia', -37.95275259, 145.13576335, '', '2019-11-26 17:49:56', NULL, '2019-11-26 17:50:04', '2019-11-26 17:50:17', '2019-11-26 17:50:23', '00:00:03', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-26 17:49:56', '2019-11-26 17:50:31'),
(85, 'TRNX261647', 2, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'DISPATCHER', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631500, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02977140, 76.94631540, '', '2019-11-29 01:31:43', NULL, '2019-11-29 01:32:01', '2019-11-29 01:32:15', '2019-11-29 01:32:50', '00:00:26', 0.00, 1, 1, 0, 0, '', NULL, '2019-11-29 01:31:43', '2019-11-29 01:33:13'),
(86, 'TRNX108518', 3, 4, 4, 1, 'CANCELLED', NULL, 'PROVIDER', 'Tes', 'APP', 'CASH', 0, 3.99, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02977336, 76.94634124, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, '', '2019-11-29 16:45:33', NULL, '2019-11-29 16:45:40', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-29 16:45:33', '2019-11-29 16:46:08'),
(87, 'TRNX510068', 3, 4, 4, 1, 'CANCELLED', NULL, 'PROVIDER', 'Tes', 'APP', 'CASH', 0, 4.00, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02979882, 76.94631520, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, '', '2019-11-29 16:51:26', NULL, '2019-11-29 16:51:32', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-29 16:51:26', '2019-11-29 17:02:17'),
(88, 'TRNX994124', 6, 4, 4, 1, 'CANCELLED', NULL, 'USER', NULL, 'APP', 'CASH', 0, 3.99, '45A/32A, Balasubramaniam Road,Coimbatore,India', 11.02975367, 76.94633242, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, '', '2019-11-30 00:47:59', NULL, '2019-11-30 00:48:17', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-30 00:47:59', '2019-11-30 00:48:33'),
(89, 'TRNX298630', 6, 4, 4, 1, 'CANCELLED', NULL, 'PROVIDER', 'Tes', 'APP', 'CASH', 0, 0.87, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02976760, 76.94630560, 'Jawahar Nagar, Saibaba Colony, Tamil Nadu 641011, India', 11.02375240, 76.94521730, '', '2019-11-30 01:00:41', NULL, '2019-11-30 01:00:48', NULL, NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-11-30 01:00:41', '2019-11-30 01:01:07'),
(90, 'TRNX733585', 4, 4, 4, 1, 'COMPLETED', NULL, 'NONE', NULL, 'STREET', 'CASH', 1, 0.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02978901, 76.94634930, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02978901, 76.94634930, NULL, '2019-12-03 17:43:03', NULL, NULL, '2019-12-03 17:43:06', '2019-12-03 17:43:13', '00:00:02', 0.00, 1, 1, 0, 0, '', NULL, '2019-12-03 17:43:03', '2019-12-03 17:43:25'),
(91, 'TRNX921368', 4, 4, 4, 1, 'PICKEDUP', NULL, 'NONE', NULL, 'STREET', 'CASH', 0, 4.00, 'Balasubramaniam Road, 63, 6th Cross Rd, Saibaba Colony, K K Pudur, Coimbatore, Tamil Nadu 641038, India', 11.02982681, 76.94630739, 'Gandhipuram, Tamil Nadu 641012, India', 11.01758400, 76.96740700, NULL, '2019-12-27 17:59:05', NULL, NULL, '2019-12-27 17:59:10', NULL, NULL, 0.00, 0, 0, 0, 0, '', NULL, '2019-12-27 17:59:05', '2019-12-27 17:59:10');
-- --------------------------------------------------------
--
-- Table structure for table `user_request_payments`
--
CREATE TABLE `user_request_payments` (
`id` int(10) UNSIGNED NOT NULL,
`request_id` int(11) NOT NULL,
`promocode_id` int(11) 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',
`commision` double(10,2) NOT NULL DEFAULT '0.00',
`discount` double(10,2) NOT NULL DEFAULT '0.00',
`waiting_fare` double(10,2) NOT NULL DEFAULT '0.00',
`booking_fare` double(10,2) NOT NULL DEFAULT '0.00',
`airport_fare` double(10,2) NOT NULL DEFAULT '0.00',
`transaction_fare` double(10,2) NOT NULL DEFAULT '0.00',
`extra_fare` double(10,2) NOT NULL DEFAULT '0.00',
`lifting_fare` double(10,2) NOT NULL DEFAULT '0.00',
`toll` double(10,2) NOT NULL DEFAULT '0.00',
`tax` double(10,2) NOT NULL DEFAULT '0.00',
`wallet` double(10,2) NOT NULL DEFAULT '0.00',
`cash` double(10,2) NOT NULL DEFAULT '0.00',
`sro_fare` double(10,2) NOT NULL DEFAULT '0.00',
`total` double(10,2) NOT NULL DEFAULT '0.00',
`extra_desc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `user_request_payments`
--
INSERT INTO `user_request_payments` (`id`, `request_id`, `promocode_id`, `payment_id`, `payment_mode`, `fixed`, `distance`, `commision`, `discount`, `waiting_fare`, `booking_fare`, `airport_fare`, `transaction_fare`, `extra_fare`, `lifting_fare`, `toll`, `tax`, `wallet`, `cash`, `sro_fare`, `total`, `extra_desc`, `created_at`, `updated_at`) VALUES
(1, 1, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.14, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.34, 11.00, 18.34, NULL, '2019-11-07 21:18:54', '2019-11-07 21:18:54'),
(2, 2, NULL, 'ch_1Fc8L8Al0EMC1rAvTAI8cPgb', 'CARD', 5.20, 0.00, 0.52, 0.00, 1.13, 0.00, 5.00, 1.12, 0.00, 0.00, 0.00, 10.00, 0.00, 22.33, 11.00, 23.45, NULL, '2019-11-07 21:21:56', '2019-11-07 21:35:47'),
(3, 3, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.31, 11.00, 16.31, NULL, '2019-11-07 21:32:51', '2019-11-07 21:32:51'),
(4, 4, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.45, 2.00, 6.00, 0.00, 5.00, 0.00, 6.00, 10.00, 0.00, 35.65, 11.00, 35.65, NULL, '2019-11-07 23:23:14', '2019-11-07 23:23:48'),
(5, 5, NULL, 'ch_1FcAPgAl0EMC1rAvg73JaaZD', 'CARD', 5.20, 0.00, 0.52, 0.00, 0.08, 2.00, 0.00, 0.91, 0.00, 0.00, 0.00, 10.00, 0.00, 20.11, 11.00, 19.19, NULL, '2019-11-07 23:45:22', '2019-11-07 23:48:36'),
(6, 6, NULL, NULL, NULL, 4.20, 0.00, 0.42, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.20, 11.00, 17.20, NULL, '2019-11-08 00:50:53', '2019-11-08 00:50:53'),
(7, 8, NULL, NULL, NULL, 6.20, 0.00, 0.62, 0.00, 0.01, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.21, 11.00, 17.21, NULL, '2019-11-08 16:41:57', '2019-11-08 16:41:57'),
(8, 9, NULL, NULL, NULL, 6.20, 0.00, 0.62, 0.00, 0.10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.31, 11.00, 17.31, NULL, '2019-11-08 17:09:17', '2019-11-08 17:09:17'),
(9, 7, NULL, NULL, NULL, 6.20, 0.00, 0.62, 0.00, 39.32, 0.00, 5.00, 0.00, 0.00, 0.00, 5.00, 10.00, 0.00, 66.52, 11.00, 66.52, NULL, '2019-11-08 17:33:37', '2019-11-08 17:34:03'),
(10, 10, NULL, 'ch_1FcS8hAl0EMC1rAvqRCFitSP', 'CARD', 6.20, 0.00, 0.62, 0.00, 1.83, 2.00, 0.00, 1.05, 0.00, 0.00, 0.00, 10.00, 0.00, 23.13, 11.00, 22.08, NULL, '2019-11-08 18:43:47', '2019-11-08 18:44:15'),
(11, 15, NULL, NULL, NULL, 6.20, 0.00, 0.62, 0.00, 0.38, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.59, 11.00, 17.59, NULL, '2019-11-08 18:56:48', '2019-11-08 18:56:48'),
(12, 18, NULL, NULL, NULL, 6.20, 0.00, 0.62, 0.00, 35.92, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 53.12, 11.00, 53.12, NULL, '2019-11-08 20:24:29', '2019-11-08 20:24:29'),
(13, 17, NULL, NULL, NULL, 6.20, 20.84, 2.70, 0.00, 37.03, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 75.07, 11.00, 75.07, NULL, '2019-11-08 20:24:37', '2019-11-08 20:24:37'),
(14, 17, NULL, NULL, NULL, 6.20, 20.84, 2.70, 0.00, 37.03, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 75.07, 11.00, 75.07, NULL, '2019-11-08 20:24:39', '2019-11-08 20:24:39'),
(15, 17, NULL, NULL, NULL, 6.20, 20.84, 2.70, 0.00, 37.03, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 75.07, 11.00, 75.07, NULL, '2019-11-08 20:24:43', '2019-11-08 20:24:43'),
(16, 17, NULL, NULL, NULL, 6.20, 20.84, 2.70, 0.00, 37.03, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 75.07, 11.00, 75.07, NULL, '2019-11-08 20:24:46', '2019-11-08 20:24:46'),
(17, 20, NULL, NULL, NULL, 6.20, 0.00, 0.62, 0.00, 0.03, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.24, 11.00, 17.24, NULL, '2019-11-08 21:14:46', '2019-11-08 21:14:46'),
(18, 23, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.03, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.23, 11.00, 18.23, NULL, '2019-11-11 17:57:31', '2019-11-11 17:57:31'),
(19, 29, NULL, 'ch_1FdXnzAl0EMC1rAvN3XCagcb', 'CARD', 5.20, 0.00, 0.52, 0.00, 0.02, 2.00, 0.00, 0.91, 0.00, 0.00, 0.00, 10.00, 0.00, 20.04, 11.00, 19.13, NULL, '2019-11-11 18:58:49', '2019-11-11 18:59:23'),
(20, 47, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.12, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.32, 11.00, 16.32, NULL, '2019-11-11 20:46:31', '2019-11-11 20:46:31'),
(21, 49, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.31, 11.00, 16.31, NULL, '2019-11-11 20:49:07', '2019-11-11 20:49:07'),
(22, 48, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.08, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.28, 11.00, 16.28, NULL, '2019-11-11 20:49:10', '2019-11-11 20:49:10'),
(23, 53, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.81, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.01, 11.00, 17.01, NULL, '2019-11-11 20:54:50', '2019-11-11 20:54:50'),
(24, 54, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.25, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.45, 11.00, 16.45, NULL, '2019-11-11 20:56:09', '2019-11-11 20:56:09'),
(25, 54, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.25, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.45, 11.00, 16.45, NULL, '2019-11-11 20:56:12', '2019-11-11 20:56:12'),
(26, 55, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.01, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.21, 11.00, 16.21, NULL, '2019-11-11 21:22:02', '2019-11-11 21:22:02'),
(27, 52, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.20, 11.00, 18.20, NULL, '2019-11-11 21:26:14', '2019-11-11 21:26:14'),
(28, 56, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.22, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.42, 11.00, 16.42, NULL, '2019-11-11 21:27:14', '2019-11-11 21:27:14'),
(29, 57, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.31, 11.00, 16.31, NULL, '2019-11-11 21:30:23', '2019-11-11 21:30:23'),
(30, 57, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.31, 11.00, 16.31, NULL, '2019-11-11 21:30:24', '2019-11-11 21:30:24'),
(31, 57, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.31, 11.00, 16.31, NULL, '2019-11-11 21:30:25', '2019-11-11 21:30:25'),
(32, 57, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.31, 11.00, 16.31, NULL, '2019-11-11 21:30:26', '2019-11-11 21:30:26'),
(33, 59, NULL, 'ch_1FdbSkAl0EMC1rAvHtWDNS5Q', 'CARD', 5.20, 0.00, 0.52, 0.00, 0.01, 2.00, 0.00, 0.91, 0.00, 0.00, 0.00, 10.00, 0.00, 20.03, 11.00, 19.12, NULL, '2019-11-11 22:53:36', '2019-11-11 22:53:42'),
(34, 61, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.01, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.21, 11.00, 16.21, NULL, '2019-11-11 23:15:00', '2019-11-11 23:15:00'),
(36, 62, NULL, NULL, NULL, 4.20, 0.00, 0.42, 0.00, 0.69, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 15.89, 11.00, 15.89, NULL, '2019-11-12 00:32:52', '2019-11-12 00:32:52'),
(37, 46, NULL, NULL, NULL, 4.20, 0.00, 0.42, 0.00, 0.02, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.22, 11.00, 17.22, NULL, '2019-11-12 00:41:43', '2019-11-12 00:41:43'),
(38, 64, NULL, NULL, NULL, 5.20, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.20, 11.00, 16.20, NULL, '2019-11-13 15:39:36', '2019-11-13 15:39:36'),
(39, 67, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.61, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.81, 11.00, 16.81, NULL, '2019-11-13 15:59:54', '2019-11-13 15:59:54'),
(40, 67, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.61, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.81, 11.00, 16.81, NULL, '2019-11-13 15:59:54', '2019-11-13 15:59:54'),
(41, 68, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.08, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.28, 11.00, 16.28, NULL, '2019-11-13 16:01:46', '2019-11-13 16:01:46'),
(42, 69, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.01, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.21, 11.00, 16.21, NULL, '2019-11-13 16:12:43', '2019-11-13 16:12:43'),
(43, 70, NULL, NULL, NULL, 6.20, 0.00, 0.00, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 19.20, 11.00, 19.20, NULL, '2019-11-15 17:45:51', '2019-11-15 17:45:51'),
(44, 72, NULL, NULL, NULL, 6.20, 0.00, 0.00, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 19.20, 11.00, 19.20, NULL, '2019-11-15 17:51:28', '2019-11-15 17:51:28'),
(45, 73, NULL, NULL, NULL, 6.20, 0.00, 0.00, 0.00, 0.06, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 17.26, 11.00, 17.26, NULL, '2019-11-15 17:54:58', '2019-11-15 17:54:58'),
(46, 74, 1, NULL, NULL, 6.20, 0.00, 0.00, 5.00, 0.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 14.20, 11.00, 14.20, NULL, '2019-11-15 18:06:54', '2019-11-15 18:06:54'),
(47, 76, 1, 'ch_1FezDVAl0EMC1rAvWD7a1mbH', 'CARD', 6.20, 0.00, 0.00, 5.00, 0.88, 2.00, 0.00, 0.75, 0.00, 0.00, 0.00, 10.00, 0.00, 16.58, 11.00, 15.82, NULL, '2019-11-15 18:27:03', '2019-11-15 18:27:41'),
(48, 78, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.36, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.56, 11.00, 18.56, NULL, '2019-11-26 17:21:12', '2019-11-26 17:21:12'),
(49, 79, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.20, 11.00, 18.20, NULL, '2019-11-26 17:38:36', '2019-11-26 17:38:36'),
(50, 80, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.01, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.21, 11.00, 18.21, NULL, '2019-11-26 17:41:51', '2019-11-26 17:41:51'),
(51, 81, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.01, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.21, 11.00, 16.21, NULL, '2019-11-26 17:43:18', '2019-11-26 17:43:18'),
(52, 82, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.01, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 16.21, 11.00, 16.21, NULL, '2019-11-26 17:44:03', '2019-11-26 17:44:03'),
(53, 83, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.20, 11.00, 18.20, NULL, '2019-11-26 17:48:34', '2019-11-26 17:48:34'),
(54, 84, NULL, NULL, NULL, 5.20, 0.00, 0.52, 0.00, 0.03, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 18.23, 11.00, 18.23, NULL, '2019-11-26 17:50:23', '2019-11-26 17:50:23'),
(55, 85, NULL, NULL, NULL, 5.20, 0.00, 0.00, 0.00, 0.27, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 8.57, 1.10, 8.57, NULL, '2019-11-29 01:32:50', '2019-11-29 01:32:50'),
(56, 90, NULL, NULL, NULL, 5.20, 0.00, 0.00, 0.00, 0.02, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 10.00, 0.00, 6.32, 1.10, 6.32, NULL, '2019-12-03 17:43:13', '2019-12-03 17:43:13');
-- --------------------------------------------------------
--
-- Table structure for table `user_request_ratings`
--
CREATE TABLE `user_request_ratings` (
`id` int(10) UNSIGNED NOT NULL,
`request_id` int(11) NOT NULL,
`user_id` int(11) NOT NULL,
`provider_id` int(11) NOT NULL,
`user_rating` int(11) NOT NULL DEFAULT '0',
`provider_rating` int(11) 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `user_request_ratings`
--
INSERT INTO `user_request_ratings` (`id`, `request_id`, `user_id`, `provider_id`, `user_rating`, `provider_rating`, `user_comment`, `provider_comment`, `created_at`, `updated_at`) VALUES
(1, 1, 3, 3, 5, 5, '', '', '2019-11-07 21:19:40', '2019-11-07 23:15:14'),
(2, 3, 4, 3, 3, 5, 'STREETRIDE', '', '2019-11-07 21:32:59', '2019-11-07 21:33:11'),
(3, 2, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-07 21:35:26', '2019-11-07 21:35:55'),
(4, 4, 3, 4, 5, 4, '', '', '2019-11-07 23:28:31', '2019-11-07 23:28:35'),
(5, 5, 3, 3, 5, 5, '', '', '2019-11-07 23:48:45', '2019-11-07 23:50:46'),
(6, 6, 3, 3, 5, 5, '', '', '2019-11-08 00:51:12', '2019-11-08 15:52:12'),
(7, 8, 4, 3, 3, 5, 'STREETRIDE', '', '2019-11-08 16:42:05', '2019-11-08 16:42:23'),
(8, 9, 4, 3, 3, 5, 'STREETRIDE', '', '2019-11-08 17:09:21', '2019-11-08 17:09:57'),
(9, 7, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-08 17:34:03', '2019-11-08 17:34:13'),
(10, 10, 6, 4, 5, 4, '', '', '2019-11-08 18:44:18', '2019-11-08 18:44:49'),
(11, 15, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-08 18:56:50', '2019-11-08 18:56:55'),
(12, 18, 4, 3, 3, 4, 'STREETRIDE', '', '2019-11-08 20:24:42', '2019-11-08 20:25:00'),
(13, 17, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-08 20:31:56', '2019-11-08 20:32:01'),
(14, 20, 4, 3, 3, 5, 'STREETRIDE', '', '2019-11-08 21:14:50', '2019-11-08 21:15:35'),
(15, 23, 6, 4, 3, 4, 'DISPATCHERRIDE', '', '2019-11-11 17:57:41', '2019-11-11 17:58:41'),
(16, 29, 3, 5, 3, 4, 'DISPATCHERRIDE', '', '2019-11-11 18:59:18', '2019-11-11 19:03:06'),
(17, 47, 4, 5, 3, 4, 'STREETRIDE', '', '2019-11-11 20:46:33', '2019-11-11 20:48:01'),
(18, 49, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-11 20:49:16', '2019-11-11 20:50:37'),
(19, 48, 4, 5, 3, 4, 'STREETRIDE', '', '2019-11-11 20:49:17', '2019-11-11 20:50:40'),
(20, 53, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-11 20:54:53', '2019-11-11 20:54:58'),
(21, 54, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-11 20:56:13', '2019-11-11 20:56:19'),
(22, 55, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-11 21:22:04', '2019-11-11 21:23:40'),
(23, 52, 4, 4, 3, 4, 'DISPATCHERRIDE', '', '2019-11-11 21:26:18', '2019-11-11 21:26:22'),
(24, 56, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-11 21:27:17', '2019-11-11 21:27:21'),
(25, 57, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-11 21:30:27', '2019-11-11 21:30:50'),
(26, 59, 6, 4, 2, 4, '', '', '2019-11-11 22:53:45', '2019-11-11 22:54:07'),
(27, 61, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-11 23:15:02', '2019-11-11 23:21:20'),
(28, 60, 6, 4, 3, 5, 'DISPATCHERRIDE', '', '2019-11-11 23:40:10', '2019-11-12 00:08:57'),
(29, 62, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-12 00:32:56', '2019-11-12 00:33:01'),
(30, 46, 4, 4, 3, 2, 'DISPATCHERRIDE', '', '2019-11-12 00:42:33', '2019-11-12 00:43:31'),
(31, 64, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-13 15:39:38', '2019-11-13 15:39:42'),
(32, 67, 4, 3, 3, 0, 'STREETRIDE', NULL, '2019-11-13 16:00:03', '2019-11-13 16:00:03'),
(33, 68, 4, 3, 3, 5, 'STREETRIDE', '', '2019-11-13 16:01:52', '2019-11-13 16:12:11'),
(34, 69, 4, 3, 3, 5, 'STREETRIDE', '', '2019-11-13 16:13:02', '2019-11-13 16:13:16'),
(35, 70, 6, 4, 5, 4, 'tedt', 'tredt', '2019-11-15 17:46:49', '2019-11-15 17:47:02'),
(36, 72, 2, 4, 3, 4, 'DISPATCHERRIDE', 'hchj', '2019-11-15 17:52:40', '2019-11-15 17:54:02'),
(37, 73, 4, 4, 3, 4, 'STREETRIDE', '', '2019-11-15 17:55:01', '2019-11-15 17:55:09'),
(38, 74, 6, 4, 1, 4, 'hgj', 'hjdj', '2019-11-15 18:07:11', '2019-11-15 18:07:15'),
(39, 76, 6, 4, 5, 4, 'shshh', 'gggf', '2019-11-15 18:27:57', '2019-11-15 18:29:08'),
(40, 78, 4, 8, 3, 5, 'DISPATCHERRIDE', '', '2019-11-26 17:24:16', '2019-11-26 17:24:24'),
(41, 79, 1, 8, 3, 5, 'DISPATCHERRIDE', '', '2019-11-26 17:38:39', '2019-11-26 17:38:54'),
(42, 80, 13, 8, 3, 5, 'DISPATCHERRIDE', '', '2019-11-26 17:41:54', '2019-11-26 17:41:58'),
(43, 81, 4, 8, 3, 5, 'STREETRIDE', '', '2019-11-26 17:43:21', '2019-11-26 17:43:27'),
(44, 82, 4, 8, 3, 5, 'STREETRIDE', '', '2019-11-26 17:44:16', '2019-11-26 17:44:28'),
(45, 83, 13, 8, 3, 5, 'DISPATCHERRIDE', '', '2019-11-26 17:48:36', '2019-11-26 17:48:44'),
(46, 84, 13, 8, 3, 5, 'DISPATCHERRIDE', '', '2019-11-26 17:50:26', '2019-11-26 17:50:31'),
(47, 85, 2, 4, 3, 4, 'DISPATCHERRIDE', '', '2019-11-29 01:33:07', '2019-11-29 01:33:13'),
(48, 90, 4, 4, 3, 5, 'STREETRIDE', '', '2019-12-03 17:43:16', '2019-12-03 17:43:25');
-- --------------------------------------------------------
--
-- Table structure for table `waypoints`
--
CREATE TABLE `waypoints` (
`id` int(10) UNSIGNED NOT NULL,
`request_id` int(11) NOT NULL,
`coordinates` text COLLATE utf8_unicode_ci,
`created_at` timestamp NULL DEFAULT NULL,
`updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `waypoints`
--
INSERT INTO `waypoints` (`id`, `request_id`, `coordinates`, `created_at`, `updated_at`) VALUES
(1, 2, '[\"11.0297742,76.946306\", \"11.0297742,76.946306\", \"11.029791666666664,76.946245\", \"11.029765000000001,76.94607500000001\"]', '2019-11-07 21:21:56', '2019-11-07 21:21:56'),
(2, 4, '[\"11.0297731,76.9463318\", \"11.0297731,76.9463318\"]', '2019-11-07 23:23:14', '2019-11-07 23:23:14'),
(3, 7, '[\"11.0297747,76.9463082\", \"11.0297747,76.9463082\"]', '2019-11-08 17:33:36', '2019-11-08 17:33:36'),
(4, 10, '[\"11.0297672,76.9463238\", \"11.029818333333333,76.94628833333333\"]', '2019-11-08 18:43:47', '2019-11-08 18:43:47'),
(5, 15, '[\"11.0297672,76.9463238\", \"11.029818333333333,76.94628833333333\", \"11.0297734,76.9463324\", \"11.0297734,76.9463324\"]', '2019-11-08 18:56:47', '2019-11-08 18:56:47'),
(6, 18, '[\"11.0297726,76.9463159\", \"11.0297726,76.9463159\", \"11.0297655,76.9463224\", \"11.0297655,76.9463224\"]', '2019-11-08 20:24:29', '2019-11-08 20:24:29'),
(7, 17, '[\"11.0297672,76.9463238\", \"11.029818333333333,76.94628833333333\", \"11.0297734,76.9463324\", \"11.0297734,76.9463324\", \"11.029776,76.9463088\", \"11.029776,76.9463088\", \"11.029763333333335,76.94623\", \"11.029875,76.94636833333334\", \"11.029778333333335,76.94635166666667\", \"11.029813333333333,76.946265\", \"11.029698333333332,76.946335\", \"11.029623333333332,76.94628166666666\", \"11.029743333333332,76.94624\", \"11.029756666666666,76.94634333333333\", \"11.029776666666665,76.946465\", \"11.029793333333336,76.946285\", \"11.029875,76.94634333333333\", \"11.029748333333336,76.946195\", \"11.029658333333336,76.94615\", \"11.029725000000001,76.94623166666666\", \"11.029788333333332,76.946305\", \"11.029736666666668,76.946215\", \"11.029785,76.94629666666667\", \"11.029778333333335,76.9462\", \"11.029675000000001,76.94610833333333\", \"11.029625,76.94603166666667\", \"11.029718333333335,76.946155\", \"11.029783333333334,76.94624333333333\", \"11.029801666666666,76.94633333333333\", \"11.029838333333332,76.94641833333334\", \"11.029834999999999,76.94632499999999\", \"11.029819999999999,76.94623333333334\", \"11.029783333333334,76.94632833333334\", \"11.029801666666666,76.94641833333334\", \"11.029766666666667,76.94632833333334\", \"11.029743333333332,76.94623499999999\", \"11.029746666666664,76.94613\", \"11.029751666666668,76.94622333333334\", \"11.029716666666666,76.94631333333334\", \"11.029763333333335,76.946395\", \"11.029646666666668,76.946425\", \"11.029549999999999,76.94626333333333\", \"11.029549999999999,76.94626333333333\", \"11.02956,76.94616833333333\", \"11.029653333333332,76.94613\", \"11.02968,76.94601333333334\", \"11.029593333333333,76.94584333333334\", \"11.029593333333333,76.94584333333334\", \"11.029568333333335,76.94593833333333\", \"11.029613333333335,76.94602666666667\", \"11.029654999999998,76.94612000000001\", \"11.029708333333334,76.9462\", \"11.029796666666668,76.94625166666667\", \"11.029789999999998,76.94638666666667\", \"11.029736666666668,76.94630833333333\", \"11.02969,76.94622666666667\", \"11.029791666666664,76.94621000000001\", \"11.029893333333332,76.94620499999999\", \"11.029990000000002,76.94623\", \"11.029948333333333,76.946315\", \"11.029903333333333,76.94640166666666\", \"11.029815000000001,76.94643833333333\", \"11.029673333333335,76.94660833333334\", \"11.029673333333335,76.94660833333334\", \"11.029725000000001,76.94652666666666\", \"11.029741666666666,76.94643166666667\", \"11.029713333333332,76.946275\", \"11.029796666666668,76.94631166666666\", \"11.029720000000001,76.94625166666667\", \"11.029645,76.94619166666666\", \"11.029693333333334,76.94629166666667\", \"11.029815000000001,76.94649333333334\", \"11.029815000000001,76.94649333333334\", \"11.029758333333332,76.94636333333332\", \"11.029785,76.94625500000001\", \"11.029795000000002,76.94616333333333\", \"11.029858333333333,76.94624\", \"11.029895,76.94633\", \"11.029881666666665,76.94642333333333\", \"11.029836666666665,76.94629833333333\", \"11.029691666666668,76.94606999999999\", \"11.029691666666668,76.94606999999999\", \"11.029838333333332,76.94640833333332\", \"11.029838333333332,76.94640833333332\", \"11.029838333333332,76.94640833333332\", \"11.029761666666666,76.94634833333333\", \"11.029741666666666,76.94625500000001\", \"11.029773333333333,76.94634833333333\", \"11.029671666666665,76.94636666666666\", \"11.029635,76.94637833333333\", \"11.029645,76.94647333333334\", \"11.029645,76.94647333333334\", \"11.029803333333332,76.94662666666666\", \"11.029803333333332,76.94662666666666\", \"11.029815000000001,76.94641833333334\", \"11.029815000000001,76.94641833333334\", \"11.029726666666667,76.94650833333334\", \"11.029836666666665,76.94695666666667\", \"11.029836666666665,76.94695666666667\", \"11.029836666666665,76.94695666666667\", \"11.029836666666665,76.94695666666667\", \"11.029821666666665,76.946755\", \"11.029810000000001,76.94665333333334\", \"11.029810000000001,76.94665333333334\"]', '2019-11-08 20:24:32', '2019-11-08 20:24:32'),
(8, 23, '[]', '2019-11-11 17:57:31', '2019-11-11 17:57:31'),
(9, 29, '[\"11.0297721,76.946322\", \"11.0297721,76.946322\"]', '2019-11-11 18:58:49', '2019-11-11 18:58:49'),
(10, 47, '[\"11.0297714,76.9463147\", \"11.0297714,76.9463147\"]', '2019-11-11 20:46:31', '2019-11-11 20:46:31'),
(11, 49, '[]', '2019-11-11 20:49:07', '2019-11-11 20:49:07'),
(12, 48, '[\"11.0297714,76.9463147\", \"11.0297714,76.9463147\", \"11.0297714,76.9463147\", \"11.0297714,76.9463147\"]', '2019-11-11 20:49:10', '2019-11-11 20:49:10'),
(13, 53, '[\"11.02978,76.94624666666667\", \"11.02978,76.94624666666667\", \"11.029828333333334,76.94632833333334\"]', '2019-11-11 20:54:49', '2019-11-11 20:54:49'),
(14, 54, '[\"11.02978,76.94624666666667\", \"11.02978,76.94624666666667\", \"11.029828333333334,76.94632833333334\", \"11.0297742,76.946306\", \"11.0297742,76.946306\", \"11.029798333333334,76.94625666666667\"]', '2019-11-11 20:56:09', '2019-11-11 20:56:09'),
(15, 55, '[\"11.0297714,76.9463147\"]', '2019-11-11 21:22:02', '2019-11-11 21:22:02'),
(16, 52, '[]', '2019-11-11 21:26:14', '2019-11-11 21:26:14'),
(17, 56, '[\"11.0297651,76.9463239\", \"11.0297651,76.9463239\", \"11.0297719,76.9463237\", \"11.0297719,76.9463237\"]', '2019-11-11 21:27:14', '2019-11-11 21:27:14'),
(18, 57, '[\"11.0297651,76.9463239\", \"11.0297651,76.9463239\", \"11.0297719,76.9463237\", \"11.0297719,76.9463237\", \"11.0297722,76.9463159\", \"11.0297722,76.9463159\"]', '2019-11-11 21:30:23', '2019-11-11 21:30:23'),
(19, 59, '[\"11.02978183,76.94632181\", \"11.02978183,76.94632181\"]', '2019-11-11 22:53:36', '2019-11-11 22:53:36'),
(20, 61, '[]', '2019-11-11 23:15:00', '2019-11-11 23:15:00'),
(21, 60, '[]', '2019-11-11 23:29:09', '2019-11-11 23:29:09'),
(22, 62, '[\"11.0297714,76.9463147\", \"11.0297714,76.9463147\"]', '2019-11-12 00:32:52', '2019-11-12 00:32:52'),
(23, 46, '[\"11.0297714,76.9463147\", \"11.0297714,76.9463147\"]', '2019-11-12 00:41:43', '2019-11-12 00:41:43'),
(24, 64, '[\"11.0297715,76.9463161\", \"11.0297715,76.9463161\"]', '2019-11-13 15:39:35', '2019-11-13 15:39:35'),
(25, 70, '[\"11.0297671,76.9463164\", \"11.0297671,76.9463164\"]', '2019-11-15 17:45:51', '2019-11-15 17:45:51'),
(26, 72, '[\"11.0297671,76.9463164\", \"11.0297671,76.9463164\"]', '2019-11-15 17:51:28', '2019-11-15 17:51:28'),
(27, 73, '[\"11.0297671,76.9463164\", \"11.0297671,76.9463164\", \"11.029765,76.9463241\", \"11.029765,76.9463241\", \"11.0297644,76.946324\", \"11.0297644,76.946324\"]', '2019-11-15 17:54:57', '2019-11-15 17:54:57'),
(28, 74, '[]', '2019-11-15 18:06:54', '2019-11-15 18:06:54'),
(29, 76, '[\"11.02977454662323,76.94631636142731\", \"11.02977454662323,76.94631636142731\"]', '2019-11-15 18:27:02', '2019-11-15 18:27:02'),
(30, 85, '[\"11.0297691822052,76.94630563259125\", \"11.0297691822052,76.94630563259125\"]', '2019-11-29 01:32:50', '2019-11-29 01:32:50');
--
-- Indexes for dumped tables
--
--
-- Indexes for table `accounts`
--
ALTER TABLE `accounts`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `accounts_email_unique` (`email`);
--
-- Indexes for table `account_password_resets`
--
ALTER TABLE `account_password_resets`
ADD KEY `account_password_resets_email_index` (`email`),
ADD KEY `account_password_resets_token_index` (`token`);
--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `admins_email_unique` (`email`);
--
-- Indexes for table `cards`
--
ALTER TABLE `cards`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `chats`
--
ALTER TABLE `chats`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `complaints`
--
ALTER TABLE `complaints`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `contact_lists`
--
ALTER TABLE `contact_lists`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `dispatchers`
--
ALTER TABLE `dispatchers`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `dispatchers_email_unique` (`email`);
--
-- Indexes for table `dispatcher_password_resets`
--
ALTER TABLE `dispatcher_password_resets`
ADD KEY `dispatcher_password_resets_email_index` (`email`),
ADD KEY `dispatcher_password_resets_token_index` (`token`);
--
-- Indexes for table `documents`
--
ALTER TABLE `documents`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `fleets`
--
ALTER TABLE `fleets`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `fleets_email_unique` (`email`);
--
-- Indexes for table `fleet_password_resets`
--
ALTER TABLE `fleet_password_resets`
ADD KEY `fleet_password_resets_email_index` (`email`),
ADD KEY `fleet_password_resets_token_index` (`token`);
--
-- Indexes for table `ltm_translations`
--
ALTER TABLE `ltm_translations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_access_tokens_user_id_index` (`user_id`);
--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_clients_user_id_index` (`user_id`);
--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_personal_access_clients_client_id_index` (`client_id`);
--
-- Indexes for table `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
ADD PRIMARY KEY (`id`),
ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);
--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
ADD KEY `password_resets_email_index` (`email`),
ADD KEY `password_resets_token_index` (`token`);
--
-- Indexes for table `payout_account`
--
ALTER TABLE `payout_account`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `payout_driver`
--
ALTER TABLE `payout_driver`
ADD PRIMARY KEY (`did`);
--
-- Indexes for table `payout_log`
--
ALTER TABLE `payout_log`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `payout_taxishift`
--
ALTER TABLE `payout_taxishift`
ADD PRIMARY KEY (`tsid`);
--
-- Indexes for table `promocodes`
--
ALTER TABLE `promocodes`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `promocode_usages`
--
ALTER TABLE `promocode_usages`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `providers`
--
ALTER TABLE `providers`
ADD PRIMARY KEY (`id`),
ADD UNIQUE KEY `providers_email_unique` (`email`);
--
-- Indexes for table `provider_applications`
--
ALTER TABLE `provider_applications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `provider_contacts`
--
ALTER TABLE `provider_contacts`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `provider_devices`
--
ALTER TABLE `provider_devices`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `provider_documents`
--
ALTER TABLE `provider_documents`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `provider_profiles`
--
ALTER TABLE `provider_profiles`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `provider_services`
--
ALTER TABLE `provider_services`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `request_filters`
--
ALTER TABLE `request_filters`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ride_summary`
--
ALTER TABLE `ride_summary`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `ride_summary_details`
--
ALTER TABLE `ride_summary_details`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `service_types`
--
ALTER TABLE `service_types`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
ADD PRIMARY KEY (`id`),
ADD KEY `settings_key_index` (`key`);
--
-- Indexes for table `smsnotifications`
--
ALTER TABLE `smsnotifications`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user_requests`
--
ALTER TABLE `user_requests`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user_request_payments`
--
ALTER TABLE `user_request_payments`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `user_request_ratings`
--
ALTER TABLE `user_request_ratings`
ADD PRIMARY KEY (`id`);
--
-- Indexes for table `waypoints`
--
ALTER TABLE `waypoints`
ADD PRIMARY KEY (`id`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `accounts`
--
ALTER TABLE `accounts`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `cards`
--
ALTER TABLE `cards`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `chats`
--
ALTER TABLE `chats`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `complaints`
--
ALTER TABLE `complaints`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
--
-- AUTO_INCREMENT for table `contact_lists`
--
ALTER TABLE `contact_lists`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `dispatchers`
--
ALTER TABLE `dispatchers`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `documents`
--
ALTER TABLE `documents`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT for table `fleets`
--
ALTER TABLE `fleets`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `ltm_translations`
--
ALTER TABLE `ltm_translations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=38;
--
-- AUTO_INCREMENT for table `oauth_clients`
--
ALTER TABLE `oauth_clients`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `payout_account`
--
ALTER TABLE `payout_account`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payout_driver`
--
ALTER TABLE `payout_driver`
MODIFY `did` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `payout_log`
--
ALTER TABLE `payout_log`
MODIFY `id` bigint(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `payout_taxishift`
--
ALTER TABLE `payout_taxishift`
MODIFY `tsid` int(11) NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `promocodes`
--
ALTER TABLE `promocodes`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `promocode_usages`
--
ALTER TABLE `promocode_usages`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `providers`
--
ALTER TABLE `providers`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT for table `provider_applications`
--
ALTER TABLE `provider_applications`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
--
-- AUTO_INCREMENT for table `provider_contacts`
--
ALTER TABLE `provider_contacts`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `provider_devices`
--
ALTER TABLE `provider_devices`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `provider_documents`
--
ALTER TABLE `provider_documents`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=28;
--
-- AUTO_INCREMENT for table `provider_profiles`
--
ALTER TABLE `provider_profiles`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `provider_services`
--
ALTER TABLE `provider_services`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `request_filters`
--
ALTER TABLE `request_filters`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=172;
--
-- AUTO_INCREMENT for table `ride_summary`
--
ALTER TABLE `ride_summary`
MODIFY `id` bigint(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- AUTO_INCREMENT for table `ride_summary_details`
--
ALTER TABLE `ride_summary_details`
MODIFY `id` bigint(21) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;
--
-- AUTO_INCREMENT for table `service_types`
--
ALTER TABLE `service_types`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
--
-- AUTO_INCREMENT for table `smsnotifications`
--
ALTER TABLE `smsnotifications`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;
--
-- AUTO_INCREMENT for table `user_requests`
--
ALTER TABLE `user_requests`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=92;
--
-- AUTO_INCREMENT for table `user_request_payments`
--
ALTER TABLE `user_request_payments`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=57;
--
-- AUTO_INCREMENT for table `user_request_ratings`
--
ALTER TABLE `user_request_ratings`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=49;
--
-- AUTO_INCREMENT for table `waypoints`
--
ALTER TABLE `waypoints`
MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;