-- https://www.phpmyadmin.net/
--

START TRANSACTION;



--
-- Database: `phpparastechnolo_taxi`
--

-- --------------------------------------------------------

--
-- Table structure for table `abouts`
--

CREATE TABLE `abouts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `text` text COLLATE utf8mb4_unicode_ci,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `ChatRoomTb`
--

CREATE TABLE `ChatRoomTb` (
  `ID` int(11) NOT NULL,
  `roomID` varchar(22) NOT NULL,
  `UserJoinID` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  `type` varchar(11) NOT NULL,
  `createdDate` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ChatRoomTb`
--

INSERT INTO `ChatRoomTb` (`ID`, `roomID`, `UserJoinID`, `status`, `type`, `createdDate`) VALUES
(1, '5-9', 9, 0, 'Driver', '2024-01-12 05:58:39'),
(2, '1-1', 1, 0, 'Customer', '2024-01-12 06:22:29'),
(3, '1-1', 1, 0, 'Driver', '2024-01-12 06:22:34'),
(4, '4-4', 4, 0, 'Customer', '2024-01-12 07:52:32'),
(5, '4-4', 4, 0, 'Driver', '2024-01-12 07:52:55'),
(6, '1-4', 4, 0, 'Customer', '2024-01-12 09:10:53'),
(7, '1-4', 1, 0, 'Driver', '2024-01-12 09:11:22'),
(8, '2-2', 2, 0, 'Customer', '2024-01-12 11:04:45'),
(9, '2-2', 2, 0, 'Driver', '2024-01-12 11:05:21'),
(10, '1-5', 5, 0, 'Customer', '2024-01-12 13:48:45'),
(11, '1-5', 1, 0, 'Driver', '2024-01-12 13:48:56'),
(12, '1-139', 1, 1, 'Driver', '2024-01-22 09:29:11'),
(13, '1-140', 1, 0, 'Driver', '2024-01-22 09:30:40');

-- --------------------------------------------------------

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_type` tinyint(1) DEFAULT NULL COMMENT '1 = user, 2 = driver',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `driver_bank_details`
--

CREATE TABLE `driver_bank_details` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `driver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `account_holder_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bank_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `account_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transit_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `institution_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `driver_bank_details`
--

INSERT INTO `driver_bank_details` (`id`, `driver_id`, `account_holder_name`, `bank_name`, `account_number`, `transit_number`, `institution_number`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 'EGthxxtjxtj', 'yfkkgxxky', '726257762726', '826726762726', '726276726722', 0, '2024-01-12 13:07:46', '2024-01-12 13:07:46'),
(2, 2, 'driver one', 'ptb', '9638527415', '8976542', '78965423', 0, '2024-01-12 13:32:29', '2024-01-12 13:32:29'),
(3, 3, 'dycyvu', 'zgrxrhxr', '827283', '53537282', '24835338', 0, '2024-01-12 14:39:05', '2024-01-12 14:39:05'),
(4, 4, 'ankity', 'dd', '424242424242424224', '77777', '77777', 0, '2024-01-12 14:50:23', '2024-01-12 14:50:23'),
(5, 6, 'ddddd', 'HDBF', '7878787', '7878787', '87878787', 0, '2024-01-12 20:15:14', '2024-01-12 20:15:14');

-- --------------------------------------------------------

--
-- Table structure for table `external_accounts`
--

CREATE TABLE `external_accounts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `driver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `accountID` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(4, '2022_12_19_103354_create_customer_table', 1),
(5, '2022_12_19_104415_create_table_abouts', 1),
(6, '2022_12_19_104501_create_table_vehicle_categories', 1),
(7, '2022_12_19_104502_create_table_drivers', 1),
(8, '2022_12_19_105342_create_table_order_settings', 1),
(9, '2022_12_19_105548_create_table_orders', 1),
(10, '2022_12_24_094257_change_plate_number_count_drivers_table', 1),
(11, '2023_05_19_111844_driver_bank_details', 1),
(12, '2023_06_02_092431_contactus', 1),
(13, '2023_06_13_091414_rating', 1),
(14, '2023_06_23_064751_order_reject', 1),
(15, '2023_06_23_070151_reasons', 1),
(16, '2023_08_21_064400_external_account', 2),
(17, '2023_08_24_062845_payments', 3),
(19, '2023_09_05_052151_user_card_details', 4),
(21, '2023_12_27_052112_notifications', 5);

-- --------------------------------------------------------

--
-- Table structure for table `orders`
--

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `driver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `customer_id` bigint(20) UNSIGNED NOT NULL,
  `vehicle_category_id` bigint(20) UNSIGNED NOT NULL,
  `start_coordinate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_coordinate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `distance` double(8,2) NOT NULL DEFAULT '0.00',
  `one_way` tinyint(1) NOT NULL DEFAULT '0',
  `order_time` datetime DEFAULT NULL,
  `start_time` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_time` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `actual_distance` double(8,2) NOT NULL DEFAULT '0.00',
  `actual_time` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `estimated_time` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_method` tinyint(1) NOT NULL DEFAULT '0',
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `pending_amount` double(8,2) DEFAULT '0.00',
  `grand_total` double(8,2) DEFAULT '0.00',
  `total` double(8,2) NOT NULL DEFAULT '0.00',
  `new_total` double(8,2) DEFAULT '0.00',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `driver_id`, `customer_id`, `vehicle_category_id`, `start_coordinate`, `end_coordinate`, `start_address`, `end_address`, `distance`, `one_way`, `order_time`, `start_time`, `end_time`, `actual_distance`, `actual_time`, `estimated_time`, `payment_method`, `status`, `pending_amount`, `grand_total`, `total`, `new_total`, `created_at`, `updated_at`) VALUES
(2, NULL, 10, 1, '30.7046118,76.6843712', '30.698686061566626,76.68123163282871', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXJ+99X, Sector 91, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-17 06:21:22', NULL, NULL, 0.00, '0.00', '3.4', 1, 8, 0.00, 0.00, 10.72, 10.72, '2024-01-17 13:21:22', '2024-01-17 13:21:34'),
(4, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:11:13', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:11:13', '2024-01-18 18:11:13'),
(5, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:12:36', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:12:36', '2024-01-18 18:12:36'),
(6, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:23:29', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:23:29', '2024-01-18 18:23:29'),
(7, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:28:24', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:28:24', '2024-01-18 18:28:24'),
(8, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:30:59', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:30:59', '2024-01-18 18:30:59'),
(9, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:31:08', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:31:08', '2024-01-18 18:31:08'),
(10, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:32:18', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:32:18', '2024-01-18 18:32:18'),
(11, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:33:00', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:33:00', '2024-01-18 18:33:00'),
(12, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:33:39', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:33:39', '2024-01-18 18:33:39'),
(13, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:34:38', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:34:38', '2024-01-18 18:34:38'),
(14, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:36:08', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:36:08', '2024-01-18 18:36:08'),
(15, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:36:16', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:36:16', '2024-01-18 18:36:16'),
(16, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:36:21', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:36:21', '2024-01-18 18:36:21'),
(17, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:38:01', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:38:01', '2024-01-18 18:38:01'),
(18, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:38:10', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:38:10', '2024-01-18 18:38:10'),
(19, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:38:15', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:38:15', '2024-01-18 18:38:15'),
(20, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:39:18', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:39:18', '2024-01-18 18:39:18'),
(21, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:39:20', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:39:20', '2024-01-18 18:39:20'),
(22, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:39:22', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:39:22', '2024-01-18 18:39:22'),
(23, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:40:19', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:40:19', '2024-01-18 18:40:19'),
(24, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:40:22', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:40:22', '2024-01-18 18:40:22'),
(25, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:40:24', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:40:24', '2024-01-18 18:40:24'),
(26, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:41:41', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:41:41', '2024-01-18 18:41:41'),
(27, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:41:43', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:41:43', '2024-01-18 18:41:43'),
(28, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:41:45', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:41:45', '2024-01-18 18:41:45'),
(29, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:44:46', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:44:46', '2024-01-18 18:44:46'),
(30, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:44:48', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:44:48', '2024-01-18 18:44:48'),
(31, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:44:49', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:44:49', '2024-01-18 18:44:49'),
(32, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:45:15', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:45:15', '2024-01-18 18:45:15'),
(33, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:50:54', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:50:54', '2024-01-18 18:50:54'),
(34, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:50:56', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:50:56', '2024-01-18 18:50:56'),
(35, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:50:58', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:50:58', '2024-01-18 18:50:58'),
(36, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:51:12', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:51:12', '2024-01-18 18:51:12'),
(37, 1, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 11:58:47', '', '', 0.50, '', '1.1', 1, 1, 0.00, 0.00, 10.03, 10.03, '2024-01-18 18:58:47', '2024-01-18 18:58:47'),
(38, NULL, 5, 1, '30.7046289,76.6843925', '30.70137088635265,76.68456930667162', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 12:09:06', '', '', 0.50, '', '1.1', 1, 0, 0.00, 0.00, 10.03, 10.03, '2024-01-18 19:09:06', '2024-01-18 19:09:06'),
(39, NULL, 5, 1, '30.7046266,76.6843944', '30.70152454151897,76.68512184172869', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-18 12:17:18', '', '', 0.50, '', '1.2', 1, 0, 0.00, 0.00, 10.06, 10.06, '2024-01-18 19:17:18', '2024-01-18 19:17:18'),
(40, NULL, 5, 1, '30.7046291,76.684391', '30.70086984773156,76.68543566018343', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-18 12:23:43', '', '', 0.60, '', '1.3', 1, 0, 0.00, 0.00, 10.09, 10.09, '2024-01-18 19:23:43', '2024-01-18 19:23:43'),
(41, NULL, 5, 1, '30.7046298,76.6843928', '30.701501767128878,76.6867908462882', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-18 12:25:47', '', '', 0.70, '', '1.4', 1, 0, 0.00, 0.00, 10.12, 10.12, '2024-01-18 19:25:47', '2024-01-18 19:25:47'),
(42, NULL, 5, 1, '30.7046264,76.684392', '30.70069284037009,76.68640796095133', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-18 12:27:27', '', '', 0.70, '', '1.4', 1, 0, 0.00, 0.00, 10.12, 10.12, '2024-01-18 19:27:27', '2024-01-18 19:27:27'),
(43, 1, 5, 1, '30.7046041,76.684362', '30.701029845962914,76.6843131557107', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-19 04:00:10', '', '', 0.50, '', '1.2', 1, 1, 0.00, 0.00, 10.06, 10.06, '2024-01-19 11:00:10', '2024-01-19 11:00:10'),
(44, NULL, 5, 1, '30.7045965,76.6843839', '30.700458751960227,76.6839574277401', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 04:09:21', '', '', 0.60, '', '1.4', 1, 0, 0.00, 0.00, 10.12, 10.12, '2024-01-19 11:09:21', '2024-01-19 11:09:21'),
(45, NULL, 5, 1, '30.7046254,76.6843889', '30.702444737694716,76.68426018208265', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Plot F451, Sector 74, Sahibzada Ajit Singh Nagar', 0.40, 0, '2024-01-19 04:19:03', '', '', 0.40, '', '0.9', 1, 0, 0.00, 0.00, 9.97, 9.97, '2024-01-19 11:19:03', '2024-01-19 11:19:03'),
(46, NULL, 5, 1, '30.7046231,76.6843901', '30.701176871130816,76.68413814157248', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-19 04:22:14', '', '', 0.50, '', '1.1', 1, 8, 0.00, 0.00, 10.03, 10.03, '2024-01-19 11:22:14', '2024-01-19 11:23:35'),
(47, NULL, 5, 1, '30.704624,76.6843895', '30.701437479897542,76.68527472764254', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 04:54:14', '', '', 0.60, '', '1.2', 1, 0, 0.00, 0.00, 10.06, 10.06, '2024-01-19 11:54:14', '2024-01-19 11:54:14'),
(48, NULL, 5, 1, '30.7046288,76.6843914', '30.700412049524772,76.68513659387827', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 04:55:47', '', '', 0.60, '', '1.4', 1, 0, 0.00, 0.00, 10.12, 10.12, '2024-01-19 11:55:47', '2024-01-19 11:55:47'),
(49, NULL, 5, 1, '30.7046147,76.6843836', '30.701293337967545,76.6849173232913', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-19 04:58:29', '', '', 0.00, '', '0.0', 1, 8, 0.00, 0.00, 9.70, 9.70, '2024-01-19 11:58:29', '2024-01-19 11:58:47'),
(50, NULL, 5, 1, '30.7046243,76.6843899', '30.700422716132383,76.68520029634237', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 05:05:50', '', '', 0.60, '', '1.4', 1, 10, 0.00, 0.00, 10.12, 10.12, '2024-01-19 12:05:50', '2024-01-19 12:05:50'),
(51, NULL, 5, 1, '30.7046189,76.6843809', '30.69925255341793,76.68399900197983', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXM+Q6X, Sector 91, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-19 05:12:10', '', '', 1.10, '', '2.7', 1, 10, 0.00, 0.00, 10.51, 10.51, '2024-01-19 12:12:10', '2024-01-19 12:12:10'),
(52, NULL, 5, 1, '30.7046271,76.6843914', '30.7046271,76.6843914', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-19 05:18:46', '', '', 1.10, '', '2.7', 1, 10, 0.00, 0.00, 10.51, 10.51, '2024-01-19 12:18:46', '2024-01-19 12:18:46'),
(53, NULL, 5, 1, '30.70462,76.6843895', '30.70048758061279,76.6843543946743', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 05:21:18', '', '', 0.60, '', '1.4', 1, 10, 0.00, 0.00, 10.12, 10.12, '2024-01-19 12:21:18', '2024-01-19 12:21:18'),
(54, NULL, 5, 1, '30.7046241,76.684391', '30.70037659025315,76.683534309268', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+74Q, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 05:32:09', '', '', 0.60, '', '1.5', 1, 10, 0.00, 0.00, 10.15, 10.15, '2024-01-19 12:32:09', '2024-01-19 12:32:09'),
(55, NULL, 5, 1, '30.7046062,76.6843844', '30.701119790798124,76.6849659383297', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 05:52:23', '', '', 0.60, '', '1.2', 1, 10, 0.00, 0.00, 10.06, 10.06, '2024-01-19 12:52:23', '2024-01-19 12:52:23'),
(56, NULL, 5, 1, '30.7046261,76.6843912', '30.701182060250307,76.6863677278161', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 06:00:15', '', '', 0.60, '', '1.4', 1, 10, 0.00, 0.00, 10.12, 10.12, '2024-01-19 13:00:15', '2024-01-19 13:00:15'),
(57, NULL, 5, 1, '30.7045894,76.6843838', '30.701454488631082,76.6850470751524', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-19 06:02:45', '', '', 0.50, '', '1.2', 1, 10, 0.00, 0.00, 10.06, 10.06, '2024-01-19 13:02:45', '2024-01-19 13:02:45'),
(58, NULL, 5, 1, '30.704592,76.6843832', '30.698464364868073,76.68546248227358', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXP+855, Sector 91, Sahibzada Ajit Singh Nagar', 0.90, 0, '2024-01-19 06:07:22', '', '', 0.90, '', '2.2', 1, 10, 0.00, 0.00, 10.36, 10.36, '2024-01-19 13:07:22', '2024-01-19 13:07:22'),
(59, NULL, 5, 1, '30.7046205,76.6843937', '30.698157621131887,76.68696518987417', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'M.G.Enterprises Plot no. F-411, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-19 06:08:26', '', '', 1.00, '', '2.3', 1, 10, 0.00, 0.00, 10.39, 10.39, '2024-01-19 13:08:26', '2024-01-19 13:08:26'),
(60, NULL, 5, 1, '30.7046293,76.6843891', '30.70134667050673,76.68518520891666', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 06:44:32', '', '', 0.60, '', '1.2', 1, 10, 0.00, 0.00, 10.06, 10.06, '2024-01-19 13:44:32', '2024-01-19 13:44:32'),
(61, NULL, 5, 1, '30.7046346,76.6843931', '30.700152014563546,76.68488010764122', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-19 06:46:49', '', '', 0.70, '', '1.5', 1, 10, 0.00, 0.00, 10.15, 10.15, '2024-01-19 13:46:49', '2024-01-19 13:46:49'),
(62, NULL, 5, 1, '30.7046269,76.6843805', '30.699844411326627,76.68456058949232', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXM+Q6X, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-19 06:48:05', '', '', 0.70, '', '1.5', 1, 10, 0.00, 0.00, 10.15, 10.15, '2024-01-19 13:48:05', '2024-01-19 13:48:05'),
(63, NULL, 5, 1, '30.7046173,76.6843828', '30.700310860837128,76.68598517775536', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-19 06:53:08', '', '', 0.00, '', '1.5', 1, 10, 0.00, 0.00, 10.15, 10.15, '2024-01-19 13:53:08', '2024-01-19 13:53:08'),
(64, NULL, 5, 1, '30.7046257,76.6843837', '30.68953063087844,76.68844778090715', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'B 1134, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.50, 0, '2024-01-19 06:56:48', '', '', 3.50, '', '7.4', 1, 10, 0.00, 0.00, 11.92, 11.92, '2024-01-19 13:56:48', '2024-01-19 13:56:48'),
(65, NULL, 5, 1, '30.7046161,76.6843758', '30.694655080531934,76.68682403862476', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+VMV, Lakhnaur, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-19 07:03:34', '', '', 1.60, '', '3.7', 1, 10, 0.00, 0.00, 10.81, 10.81, '2024-01-19 14:03:34', '2024-01-19 14:03:34'),
(66, 1, 5, 1, '30.7046268,76.684393', '30.70019295137774,76.68508429080248', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-19 07:18:56', '', '', 0.70, '', '1.5', 1, 10, 0.00, 0.00, 10.15, 10.15, '2024-01-19 14:18:56', '2024-01-19 14:18:56'),
(67, NULL, 5, 1, '30.7046298,76.6843922', '30.699425815655935,76.68649278581142', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXP+7F2, Sector 91, Sahibzada Ajit Singh Nagar', 0.80, 0, '2024-01-19 07:19:40', '', '', 0.80, '', '1.6', 1, 10, 0.00, 0.00, 10.18, 10.18, '2024-01-19 14:19:40', '2024-01-19 14:19:40'),
(68, 1, 5, 1, '30.7046284,76.6843912', '30.698083241394865,76.68478019535542', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-19 07:30:03', '', '', 1.00, '', '2.5', 1, 10, 0.00, 0.00, 10.45, 10.45, '2024-01-19 14:30:03', '2024-01-19 14:30:03'),
(69, NULL, 5, 1, '30.7046311,76.6843916', '30.69622026974703,76.687564663589', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 91, Sahibzada Ajit Singh Nagar', 1.30, 0, '2024-01-19 07:43:35', '', '', 1.30, '', '3.0', 1, 10, 0.00, 0.00, 10.60, 10.60, '2024-01-19 14:43:35', '2024-01-19 14:43:35'),
(70, 1, 5, 1, '30.7046321,76.6843922', '30.707041262930556,76.69284995645285', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'D-210, Sector 74, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-19 07:51:55', '', '', 1.10, '', '2.5', 1, 10, 0.00, 0.00, 10.45, 10.45, '2024-01-19 14:51:55', '2024-01-19 14:51:55'),
(71, 1, 5, 1, '30.7046299,76.6843946', '30.690885433348935,76.685989536345', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '97, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.40, 0, '2024-01-19 09:20:33', '', '', 3.40, '', '7.7', 1, 10, 0.00, 0.00, 12.01, 12.01, '2024-01-19 16:20:33', '2024-01-19 16:20:33'),
(72, 1, 5, 1, '30.7046278,76.6843928', '30.7004985354985,76.68485898524523', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-19 09:27:13', '', '', 0.60, '', '1.4', 1, 10, 0.00, 0.00, 10.12, 10.12, '2024-01-19 16:27:13', '2024-01-19 16:27:13'),
(73, 1, 5, 1, '30.7046293,76.6843915', '30.6955367098503,76.68591778725386', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+6HG, Sector 91, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-19 09:34:17', '', '', 1.60, '', '3.4', 1, 10, 0.00, 0.00, 10.72, 10.72, '2024-01-19 16:34:17', '2024-01-19 16:34:17'),
(74, 1, 5, 1, '30.704627,76.6843924', '30.694011295762458,76.6840399056673', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVM+PM6, Sector 91, Sahibzada Ajit Singh Nagar', 1.90, 0, '2024-01-19 09:36:31', '', '', 1.90, '', '4.2', 1, 10, 0.00, 0.00, 10.96, 10.96, '2024-01-19 16:36:31', '2024-01-19 16:36:31'),
(75, 1, 5, 1, '30.7046295,76.6843957', '30.69174143728048,76.68427728116512', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRM+FP, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.10, 0, '2024-01-19 09:37:54', '', '', 2.10, '', '4.8', 1, 10, 0.00, 0.00, 11.14, 11.14, '2024-01-19 16:37:54', '2024-01-19 16:37:54'),
(76, 1, 5, 1, '30.7046314,76.6843922', '30.690989515067642,76.68377503752708', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '3060, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.40, 0, '2024-01-19 09:40:45', '', '', 2.40, '', '6.0', 1, 10, 0.00, 0.00, 11.50, 11.50, '2024-01-19 16:40:45', '2024-01-19 16:40:45'),
(77, 1, 5, 1, '30.7046261,76.6843918', '30.695196802051324,76.68756265193224', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWQ+33H, Lakhnaur, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-19 09:51:24', '', '', 1.50, '', '3.6', 1, 10, 0.00, 0.00, 10.78, 10.78, '2024-01-19 16:51:24', '2024-01-19 16:51:24'),
(78, 1, 5, 1, '30.7046308,76.6843937', '30.69339258947014,76.6860019415617', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+98P, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.10, 0, '2024-01-19 09:53:32', '', '', 2.10, '', '5.9', 1, 10, 0.00, 0.00, 11.47, 11.47, '2024-01-19 16:53:32', '2024-01-19 16:53:32'),
(79, 1, 5, 1, '30.7046287,76.6843937', '30.694609240199973,76.6851731389761', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+V2X, Sector 91, Sahibzada Ajit Singh Nagar', 1.70, 0, '2024-01-19 10:00:01', '', '', 1.70, '', '3.5', 1, 10, 0.00, 0.00, 10.75, 10.75, '2024-01-19 17:00:01', '2024-01-19 17:00:01'),
(80, 1, 5, 1, '30.7046293,76.6843953', '30.69787076872948,76.68793313205242', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXQ+58M, Sector 75, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-19 10:25:40', '', '', 0.00, '', '3.5', 1, 10, 0.00, 0.00, 10.75, 10.75, '2024-01-19 17:25:40', '2024-01-19 17:25:40'),
(81, NULL, 5, 1, '30.7046297,76.6843941', '30.700254644853683,76.6851818561554', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-19 10:29:33', '', '', 0.70, '', '1.5', 1, 10, 0.00, 0.00, 10.15, 10.15, '2024-01-19 17:29:33', '2024-01-19 17:29:33'),
(82, 1, 5, 1, '30.7046293,76.6843937', '30.702166546480605,76.68370999395847', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+Q9H, Sector 91, Sahibzada Ajit Singh Nagar', 0.40, 0, '2024-01-19 10:32:03', '', '', 0.40, '', '0.9', 1, 10, 0.00, 0.00, 9.97, 9.97, '2024-01-19 17:32:03', '2024-01-19 17:32:03'),
(83, 1, 5, 1, '30.7046326,76.6843922', '30.701440651017577,76.68434198945761', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-19 10:33:00', '', '', 0.50, '', '1.1', 1, 10, 0.00, 0.00, 10.03, 10.03, '2024-01-19 17:33:00', '2024-01-19 17:33:00'),
(84, 1, 5, 1, '30.7046299,76.6843941', '30.69120949905121,76.68589666485786', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '97, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.40, 0, '2024-01-19 10:49:53', '', '', 3.40, '', '7.7', 1, 10, 0.00, 0.00, 12.01, 12.01, '2024-01-19 17:49:53', '2024-01-19 17:49:53'),
(85, 1, 5, 1, '30.7046357,76.6843918', '30.692172175357275,76.68626479804516', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'SH12A, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.00, 0, '2024-01-19 10:51:19', '', '', 2.00, '', '5.1', 1, 10, 0.00, 0.00, 11.23, 11.23, '2024-01-19 17:51:19', '2024-01-19 17:51:19'),
(86, 1, 5, 1, '30.7046297,76.6843923', '30.699850465382898,76.68520197272301', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-19 10:57:05', '', '', 0.70, '', '1.6', 1, 10, 0.00, 0.00, 10.18, 10.18, '2024-01-19 17:57:05', '2024-01-19 17:57:05'),
(87, 1, 5, 1, '30.7046286,76.6843912', '30.694926662429427,76.68698128312826', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+XR, Sector 91, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-19 11:00:37', '', '', 1.50, '', '3.2', 1, 10, 0.00, 0.00, 10.66, 10.66, '2024-01-19 18:00:37', '2024-01-19 18:00:37'),
(88, 1, 5, 1, '30.7046131,76.6843619', '30.69168492799257,76.6876370832324', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRQ+R22, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.20, 0, '2024-01-19 11:02:06', '', '', 3.20, '', '6.8', 1, 10, 0.00, 0.00, 11.74, 11.74, '2024-01-19 18:02:06', '2024-01-19 18:02:06'),
(89, 1, 5, 1, '30.704631,76.6843925', '30.692371974896965,76.68649412691593', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Shabad Complex Near water tank, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.00, 0, '2024-01-19 11:04:10', '', '', 2.00, '', '5.1', 1, 10, 0.00, 0.00, 11.23, 11.23, '2024-01-19 18:04:10', '2024-01-19 18:04:10'),
(90, 1, 5, 1, '30.7046294,76.6843844', '30.69197179878021,76.68469469994307', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRM+VP3, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.20, 0, '2024-01-19 11:15:15', '', '', 2.20, '', '5.2', 1, 10, 0.00, 0.00, 11.26, 11.26, '2024-01-19 18:15:15', '2024-01-19 18:15:15'),
(91, 1, 5, 1, '30.7046297,76.6843931', '30.69796215797938,76.68486267328262', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-19 11:24:33', '', '', 1.00, '', '2.5', 1, 10, 0.00, 0.00, 10.45, 10.45, '2024-01-19 18:24:33', '2024-01-19 18:24:33'),
(92, 1, 5, 1, '30.7046253,76.6843875', '30.69145225930051,76.6852368414402', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRM+FP, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.40, 0, '2024-01-19 11:26:14', '', '', 3.40, '', '7.2', 1, 10, 0.00, 0.00, 11.86, 11.86, '2024-01-19 18:26:14', '2024-01-19 18:26:14'),
(93, 1, 5, 1, '30.7046314,76.6843933', '30.692549574140603,76.68408114463091', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRM+VP3, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.00, 0, '2024-01-19 11:27:53', '', '', 2.00, '', '4.7', 1, 10, 0.00, 0.00, 11.11, 11.11, '2024-01-19 18:27:53', '2024-01-19 18:27:53'),
(94, 1, 5, 1, '30.7046342,76.6843937', '30.691609966641252,76.68344043195248', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRM+84P, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.30, 0, '2024-01-19 11:29:11', '', '', 2.30, '', '6.0', 1, 10, 0.00, 0.00, 11.50, 11.50, '2024-01-19 18:29:11', '2024-01-19 18:29:11'),
(95, 1, 5, 1, '30.7046271,76.6843899', '30.693302349124988,76.69035080820322', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Lakhnaur (DC Office Mohali), Sector 76, Sahibzada Ajit Singh Nagar', 2.90, 0, '2024-01-19 11:32:56', '', '', 2.90, '', '6.3', 1, 10, 0.00, 0.00, 11.59, 11.59, '2024-01-19 18:32:56', '2024-01-19 18:32:56'),
(96, 1, 5, 1, '30.7046299,76.6843935', '30.691114931948018,76.68206479400396', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'BLOCK-D, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.90, 0, '2024-01-19 11:34:55', '', '', 3.90, '', '8.2', 1, 10, 0.00, 0.00, 12.23, 12.23, '2024-01-19 18:34:55', '2024-01-19 18:34:55'),
(97, 1, 5, 1, '30.7046285,76.6843905', '30.694584446049088,76.68618969619274', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+XC6, Sector 91, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-19 11:40:56', '', '', 1.60, '', '4.0', 1, 10, 0.00, 0.00, 10.90, 10.90, '2024-01-19 18:40:56', '2024-01-19 18:40:56'),
(98, 1, 5, 1, '30.704632,76.684393', '30.69250949901516,76.68464072048664', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRM+VP3, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.10, 0, '2024-01-19 11:45:19', '', '', 2.10, '', '5.0', 1, 1, 0.00, 0.00, 11.20, 11.20, '2024-01-19 18:45:19', '2024-01-19 18:45:19'),
(99, 1, 5, 1, '30.7046319,76.684392', '30.69156700799445,76.68538872152567', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMRP+MCR, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.40, 0, '2024-01-19 12:20:17', '', '', 3.40, '', '7.1', 1, 10, 0.00, 0.00, 11.83, 11.83, '2024-01-19 19:20:17', '2024-01-19 19:20:17'),
(100, 1, 5, 1, '30.7046278,76.6843836', '30.696009522779267,76.68972853571177', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'E 325 GARDEN ENGINEER PHASE 8 - A, Sector 75, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-19 12:23:53', '', '', 1.60, '', '3.4', 1, 10, 0.00, 0.00, 10.72, 10.72, '2024-01-19 19:23:53', '2024-01-19 19:23:53'),
(101, 1, 5, 1, '30.7046297,76.6843935', '30.693657255554953,76.68593052774668', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'bada gruduwara, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.10, 0, '2024-01-19 12:29:20', '', '', 2.10, '0', '5.9', 1, 10, 0.00, 0.00, 11.47, 11.47, '2024-01-19 19:29:20', '2024-01-19 19:29:20'),
(102, 1, 5, 1, '30.7046288,76.6843936', '30.698373552679342,76.68516911566257', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'F 379, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-19 12:39:20', '', '', 1.00, '0', '2.5', 1, 10, 0.00, 0.00, 10.45, 10.45, '2024-01-19 19:39:20', '2024-01-19 19:39:20'),
(103, 1, 5, 1, '30.7046308,76.6843925', '30.697606114198983,76.68586112558842', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '395, Sector 74, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-19 13:17:10', '', '', 1.10, '0', '2.6', 1, 10, 0.00, 0.00, 10.48, 10.48, '2024-01-19 20:17:10', '2024-01-19 20:17:10'),
(104, 1, 5, 1, '30.7045865,76.6843225', '30.699346824258235,76.68877869844437', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8A, Sector, Sahibzada Ajit Singh Nagar', 1.70, 0, '2024-01-19 13:20:40', '', '', 1.70, '0', '5.3', 1, 10, 0.00, 0.00, 11.29, 11.29, '2024-01-19 20:20:40', '2024-01-19 20:20:40'),
(105, 1, 5, 1, '30.7046302,76.684396', '30.69653480369521,76.68564889580011', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+V99, Sector 91, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-22 04:14:46', '', '', 1.50, '', '3.4', 1, 10, 0.00, 0.00, 10.72, 10.72, '2024-01-22 11:14:46', '2024-01-22 11:14:46'),
(106, NULL, 5, 1, '30.7046173,76.6843845', '30.695768792095727,76.68607134371996', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+6HG, Sector 91, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-22 04:19:10', '', '', 1.60, '', '3.3', 1, 10, 0.00, 0.00, 10.69, 10.69, '2024-01-22 11:19:10', '2024-01-22 11:19:10'),
(107, 1, 5, 1, '30.7046293,76.6843973', '30.695502690294127,76.68710868805647', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+3W3, Sector 91, Sahibzada Ajit Singh Nagar', 1.30, 0, '2024-01-22 04:20:03', '', '', 1.30, '', '3.3', 1, 1, 0.00, 0.00, 10.69, 10.69, '2024-01-22 11:20:03', '2024-01-22 11:20:03'),
(108, NULL, 5, 1, '30.7046248,76.6843883', '30.69624160388774,76.68675933033228', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8-B, Sector 74, Sahibzada Ajit Singh Nagar', 1.40, 0, '2024-01-22 04:38:53', '', '', 1.40, '', '3.6', 1, 10, 0.00, 0.00, 10.78, 10.78, '2024-01-22 11:38:53', '2024-01-22 11:38:53'),
(109, 1, 5, 1, '30.70463,76.6843903', '30.696292921125828,76.68765418231487', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '468, Mohali Village, Sahibzada Ajit Singh Nagar', 1.30, 0, '2024-01-22 04:42:49', '', '', 1.30, '0', '3.0', 1, 7, 0.00, 0.00, 10.60, 10.60, '2024-01-22 11:42:49', '2024-01-22 11:42:49'),
(110, 1, 5, 1, '30.70463,76.6843962', '30.69812706202206,76.68640427291393', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXP+7F2, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 04:44:41', '', '', 1.00, '', '2.2', 1, 1, 0.00, 0.00, 10.36, 10.36, '2024-01-22 11:44:41', '2024-01-22 11:44:41'),
(111, NULL, 5, 1, '30.7046312,76.6843906', '30.698100539013225,76.68740943074226', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'M.G.Enterprises Plot no. F-411, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 05:11:46', '', '', 1.00, '', '1.9', 1, 10, 0.00, 0.00, 10.27, 10.27, '2024-01-22 12:11:46', '2024-01-22 12:11:46'),
(112, NULL, 5, 1, '30.7046292,76.6843891', '30.695966854390523,76.6881949827075', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWQ+99P, Sector 75, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-22 05:13:31', '', '', 1.20, '', '2.7', 1, 10, 0.00, 0.00, 10.51, 10.51, '2024-01-22 12:13:31', '2024-01-22 12:13:31'),
(113, 1, 5, 1, '30.7046298,76.6843949', '30.694418094430148,76.68600898236036', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+XC6, Sector 91, Sahibzada Ajit Singh Nagar', 1.70, 0, '2024-01-22 05:14:15', '', '', 1.70, '', '4.1', 1, 1, 0.00, 0.00, 10.93, 10.93, '2024-01-22 12:14:15', '2024-01-22 12:14:15'),
(114, 1, 5, 1, '30.7046268,76.6843769', '30.697137345242748,76.69063210487366', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Lakhnaur Pind Rd, Sector 75, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-22 05:16:16', '', '', 1.50, '', '3.1', 1, 1, 0.00, 0.00, 10.63, 10.63, '2024-01-22 12:16:16', '2024-01-22 12:16:16'),
(115, 1, 5, 1, '30.7046286,76.6843927', '30.699401887611614,76.68477986007929', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Unnamed Road, Sector 91, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-22 05:23:44', '', '', 1.10, '', '2.7', 1, 1, 0.00, 0.00, 10.51, 10.51, '2024-01-22 12:23:44', '2024-01-22 12:23:44'),
(116, NULL, 5, 1, '30.7046265,76.6843793', '30.698657808959766,76.68656051158905', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXP+7F2, Sector 91, Sahibzada Ajit Singh Nagar', 0.90, 0, '2024-01-22 05:25:12', '', '', 0.90, '', '2.0', 1, 10, 0.00, 0.00, 10.30, 10.30, '2024-01-22 12:25:12', '2024-01-22 12:25:12'),
(117, 1, 5, 1, '30.7046285,76.6843936', '30.694873614645378,76.68750330805779', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+3W3, Sector 91, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-22 05:25:48', '', '', 1.50, '', '3.0', 1, 1, 0.00, 0.00, 10.60, 10.60, '2024-01-22 12:25:48', '2024-01-22 12:25:48'),
(118, NULL, 5, 1, '30.7046265,76.6843819', '30.696851066402388,76.68676402419806', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+QWR, Sector 91, Sahibzada Ajit Singh Nagar', 1.40, 0, '2024-01-22 05:26:52', '', '', 1.40, '', '3.2', 1, 10, 0.00, 0.00, 10.66, 10.66, '2024-01-22 12:26:52', '2024-01-22 12:26:52'),
(119, NULL, 5, 1, '30.7046311,76.6843966', '30.694662288129308,76.68766558170319', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVQ+M5X, Lakhnaur, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-22 05:27:16', '', '', 1.50, '', '3.0', 1, 10, 0.00, 0.00, 10.60, 10.60, '2024-01-22 12:27:16', '2024-01-22 12:27:16'),
(120, 1, 5, 1, '30.7046304,76.6843953', '30.69326429246852,76.68979190289974', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Lakhnaur (DC Office Mohali), Sector 76, Sahibzada Ajit Singh Nagar', 4.20, 0, '2024-01-22 05:27:41', '', '', 4.20, '', '8.3', 1, 1, 0.00, 0.00, 12.65, 12.65, '2024-01-22 12:27:41', '2024-01-22 12:27:41'),
(121, 1, 5, 1, '30.7046292,76.6843849', '30.700368229935176,76.68533273041248', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-22 05:30:45', '', '', 0.70, '0', '1.4', 1, 3, 0.00, 0.00, 10.12, 10.12, '2024-01-22 12:30:45', '2024-01-22 12:30:45'),
(122, 1, 5, 1, '30.7046296,76.6843941', '30.70060116542007,76.68625574558973', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-22 05:32:37', '', '', 0.70, '0', '1.4', 1, 7, 0.00, 0.00, 10.12, 10.12, '2024-01-22 12:32:37', '2024-01-22 12:32:37'),
(123, 1, 5, 1, '30.7046298,76.6843925', '30.69715291325204,76.6868518665433', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+VWP, Sector 91, Sahibzada Ajit Singh Nagar', 1.40, 0, '2024-01-22 05:36:51', '', '', 1.40, '0', '3.1', 1, 7, 0.00, 0.00, 10.63, 10.63, '2024-01-22 12:36:51', '2024-01-22 12:36:51'),
(124, 1, 5, 1, '30.7046255,76.6843802', '30.693402968545964,76.6847687959671', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'H.no 86, Lakhnaur, Sahibzada Ajit Singh Nagar', 2.00, 0, '2024-01-22 05:55:01', '', '', 2.00, '0', '4.8', 1, 5, 0.00, 0.00, 11.14, 11.14, '2024-01-22 12:55:01', '2024-01-22 12:55:01'),
(125, 1, 5, 1, '30.7046287,76.6843852', '30.695047749653337,76.6852331534028', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+V2X, Sector 91, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-22 06:17:52', '', '', 0.00, '0', '0.0', 1, 3, 0.00, 0.00, 9.70, 9.70, '2024-01-22 13:17:52', '2024-01-22 13:17:52'),
(126, 1, 5, 1, '30.7046293,76.6843931', '30.697939382748554,76.68663293123245', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'M.G.Enterprises Plot no. F-411, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 06:31:50', '', '', 1.00, '0', '2.3', 1, 8, 0.00, 0.00, 10.39, 10.39, '2024-01-22 13:31:50', '2024-01-22 13:31:50'),
(127, 1, 5, 1, '30.7046212,76.6843729', '30.695328556107008,76.6868843883276', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+2QR, Sector 91, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-22 06:47:54', '', '', 1.50, '0', '3.2', 1, 8, 0.00, 0.00, 10.66, 10.66, '2024-01-22 13:47:54', '2024-01-22 13:47:54'),
(128, 1, 5, 1, '30.7046282,76.6843913', '30.69733511643308,76.68482277542353', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 91, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-22 06:55:03', '', '', 1.10, '', '2.9', 1, 1, 0.00, 0.00, 10.57, 10.57, '2024-01-22 13:55:03', '2024-01-22 13:55:03'),
(129, 1, 5, 1, '30.7046286,76.6843844', '30.700180555020353,76.68588895350695', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-22 06:57:29', '', '', 0.70, '0', '1.5', 1, 8, 0.00, 0.00, 10.15, 10.15, '2024-01-22 13:57:29', '2024-01-22 13:57:29'),
(130, 1, 5, 1, '30.7046277,76.6843831', '30.700625093166998,76.68436914682388', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-22 07:00:52', '', '', 0.60, '0', '1.4', 1, 8, 0.00, 0.00, 10.12, 10.12, '2024-01-22 14:00:52', '2024-01-22 14:00:52'),
(131, 1, 5, 1, '30.7046252,76.6843777', '30.697730081008427,76.68733667582273', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 07:02:04', '', '', 1.00, '0', '1.9', 1, 8, 0.00, 0.00, 10.27, 10.27, '2024-01-22 14:02:04', '2024-01-22 14:02:04'),
(132, 1, 5, 1, '30.7046275,76.6843933', '30.69478510550601,76.6869792714715', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+XR, Sector 91, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-22 07:07:06', '', '', 1.50, '0', '3.1', 1, 8, 0.00, 0.00, 10.63, 10.63, '2024-01-22 14:07:06', '2024-01-22 14:07:06'),
(133, 1, 5, 1, '30.7046323,76.6843926', '30.696130608644623,76.68691657483578', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8-B, Sector 74, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-22 07:11:18', '', '', 0.00, '0', '0.0', 1, 8, 0.00, 0.00, 9.70, 9.70, '2024-01-22 14:11:18', '2024-01-22 14:11:18'),
(134, 1, 5, 1, '30.7046291,76.6843865', '30.695466940917115,76.68697826564312', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+2QR, Sector 91, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-22 07:14:34', '', '', 1.50, '', '3.2', 1, 1, 0.00, 0.00, 10.66, 10.66, '2024-01-22 14:14:34', '2024-01-22 14:14:34'),
(135, 1, 5, 1, '30.7046312,76.6843935', '30.69617270036224,76.68643847107887', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+6HG, Sector 91, Sahibzada Ajit Singh Nagar', 1.40, 0, '2024-01-22 07:46:39', '', '', 1.40, '0', '3.6', 1, 8, 0.00, 0.00, 10.78, 10.78, '2024-01-22 14:46:39', '2024-01-22 14:46:39'),
(136, 1, 5, 1, '30.7046294,76.6843942', '30.7046294,76.6843942', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 1.40, 0, '2024-01-22 07:56:27', '', '', 1.40, '0', '3.6', 1, 7, 0.00, 0.00, 10.78, 10.78, '2024-01-22 14:56:27', '2024-01-22 14:56:27'),
(137, 1, 5, 1, '30.7046237,76.6843731', '30.701457371466965,76.68634492903948', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-22 09:08:15', '', '', 0.60, '0', '1.4', 1, 8, 0.00, 0.00, 10.12, 10.12, '2024-01-22 16:08:15', '2024-01-22 16:08:15'),
(138, NULL, 5, 1, '30.7046263,76.6843944', '30.7046263,76.6843944', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-22 09:22:46', '', '', 0.60, '', '1.4', 1, 10, 0.00, 0.00, 10.12, 10.12, '2024-01-22 16:22:46', '2024-01-22 16:22:46'),
(139, 1, 5, 1, '30.7046228,76.6843758', '30.69662907719036,76.68452337384224', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8- B, Sector 74, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-22 09:25:40', '', '', 1.20, '', '3.1', 1, 1, 0.00, 0.00, 10.63, 10.63, '2024-01-22 16:25:40', '2024-01-22 16:25:40'),
(140, 1, 5, 1, '30.7046296,76.6843908', '30.696397861909762,76.68515335768461', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWM+8R2, Sector 91, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-22 09:30:22', '', '', 1.20, '0', '2.8', 1, 5, 0.00, 0.00, 10.54, 10.54, '2024-01-22 16:30:22', '2024-01-22 16:30:22'),
(141, 1, 5, 1, '30.7046261,76.6843919', '30.694657675267067,76.68594930320978', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVP+XC6, Sector 91, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-22 09:37:19', '', '', 0.00, '0', '0.0', 1, 8, 0.00, 0.00, 9.70, 9.70, '2024-01-22 16:37:19', '2024-01-22 16:37:19'),
(142, 1, 5, 1, '30.704628,76.6843924', '30.694128347858143,76.69508624821901', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Flat No 101-244, Sector 76, Sahibzada Ajit Singh Nagar', 2.10, 0, '2024-01-22 10:07:24', '', '', 2.10, '0', '4.4', 1, 8, 0.00, 0.00, 11.02, 11.02, '2024-01-22 17:07:24', '2024-01-22 17:07:24'),
(143, 1, 5, 1, '30.7046284,76.6843911', '30.710680852163538,76.69652089476585', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM6W+HJW, Sector 73, Sahibzada Ajit Singh Nagar', 2.60, 0, '2024-01-22 10:19:19', '', '', 2.60, '', '7.0', 1, 1, 0.00, 0.00, 11.80, 11.80, '2024-01-22 17:19:19', '2024-01-22 17:19:19'),
(144, 1, 5, 1, '30.7046299,76.6843911', '30.71036405827192,76.69815704226494', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM5W+PV8, , Sahibzada Ajit Singh Nagar', 1.70, 0, '2024-01-22 10:22:38', '', '', 1.70, '', '4.4', 1, 1, 0.00, 0.00, 11.02, 11.02, '2024-01-22 17:22:38', '2024-01-22 17:22:38'),
(145, 1, 5, 1, '30.7046291,76.6843897', '30.69512357324239,76.68473023921251', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWM+3V4, Sector 91, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-22 10:24:48', '', '', 0.00, '', '0.0', 1, 1, 0.00, 0.00, 9.70, 9.70, '2024-01-22 17:24:48', '2024-01-22 17:24:48'),
(146, 1, 5, 1, '30.7046295,76.6843896', '30.69684184088688,76.68508563190699', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 91, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-22 10:27:17', '', '', 0.00, '', '0.0', 1, 1, 0.00, 0.00, 9.70, 9.70, '2024-01-22 17:27:17', '2024-01-22 17:27:17'),
(147, 1, 5, 1, '30.7046318,76.6843933', '30.6954724186451,76.68368585407734', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWM+5J8, Sector 91, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-22 10:30:34', '', '', 0.00, '', '0.0', 1, 1, 0.00, 0.00, 9.70, 9.70, '2024-01-22 17:30:34', '2024-01-22 17:30:34'),
(148, 1, 5, 1, '30.7046303,76.6843926', '30.69742074027751,76.68514866381884', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 91, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-22 10:33:39', '', '', 1.10, '', '2.6', 1, 1, 0.00, 0.00, 10.48, 10.48, '2024-01-22 17:33:39', '2024-01-22 17:33:39'),
(149, 1, 5, 1, '30.7046321,76.6843869', '30.69386627782147,76.69037193059921', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Lakhnaur (DC Office Mohali), Sector 76, Sahibzada Ajit Singh Nagar', 2.90, 0, '2024-01-22 10:36:41', '', '', 2.90, '', '6.2', 1, 1, 0.00, 0.00, 11.56, 11.56, '2024-01-22 17:36:41', '2024-01-22 17:36:41'),
(150, 1, 5, 1, '30.70463,76.6843899', '30.69604786665308,76.68486937880516', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWM+8R2, Sector 91, Sahibzada Ajit Singh Nagar', 1.80, 0, '2024-01-22 10:46:27', '', '', 1.80, '', '4.1', 1, 1, 0.00, 0.00, 10.93, 10.93, '2024-01-22 17:46:27', '2024-01-22 17:46:27'),
(151, 1, 5, 1, '30.7046265,76.6843779', '30.696129455446638,76.68826673179865', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWQ+99P, Sector 75, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-22 10:51:10', '', '', 1.20, '0', '2.6', 1, 5, 0.00, 0.00, 10.48, 10.48, '2024-01-22 17:51:10', '2024-01-22 17:51:10'),
(152, 1, 5, 1, '30.7046278,76.6843915', '30.6980613310738,76.6845354437828', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'F-425, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 11:02:54', '', '', 1.00, '0', '2.7', 1, 2, 0.00, 0.00, 10.51, 10.51, '2024-01-22 18:02:54', '2024-01-22 18:02:54'),
(153, 1, 5, 1, '30.704629,76.6843938', '30.702185284774107,76.68492738157511', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-22 11:08:52', '', '', 0.60, '', '1.3', 1, 1, 0.00, 0.00, 10.09, 10.09, '2024-01-22 18:08:52', '2024-01-22 18:08:52'),
(154, 1, 5, 1, '30.7046295,76.6843932', '30.693697906817423,76.6893570497632', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVQ+PV7, Lakhnaur, Sahibzada Ajit Singh Nagar', 4.20, 0, '2024-01-22 11:22:42', '', '', 4.20, '0', '8.4', 1, 5, 0.00, 0.00, 12.68, 12.68, '2024-01-22 18:22:42', '2024-01-22 18:22:42'),
(155, 1, 5, 1, '30.7046332,76.6843906', '30.697906805510296,76.6873524338007', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 11:27:51', '', '', 1.00, '0', '1.9', 1, 2, 0.00, 0.00, 10.27, 10.27, '2024-01-22 18:27:51', '2024-01-22 18:27:51'),
(156, 1, 5, 1, '30.7046269,76.6843758', '30.693954787803406,76.68239738792181', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVM+V94, Sector 91, Sahibzada Ajit Singh Nagar', 2.00, 0, '2024-01-22 11:33:57', '', '', 2.00, '0', '4.4', 1, 2, 0.00, 0.00, 11.02, 11.02, '2024-01-22 18:33:57', '2024-01-22 18:33:57'),
(157, 1, 5, 1, '30.7046351,76.6843926', '30.69377661453224,76.68282989412546', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Sector 57 e 287, Sector 91, Sahibzada Ajit Singh Nagar', 2.00, 0, '2024-01-22 11:37:53', '', '', 2.00, '0', '4.5', 1, 2, 0.00, 0.00, 11.05, 11.05, '2024-01-22 18:37:53', '2024-01-22 18:37:53'),
(158, 1, 5, 1, '30.7046353,76.6843926', '30.695313276105367,76.68502930551767', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWM+3V4, Sector 91, Sahibzada Ajit Singh Nagar', 1.80, 0, '2024-01-22 11:42:34', '', '', 1.80, '0', '4.0', 1, 2, 0.00, 0.00, 10.90, 10.90, '2024-01-22 18:42:34', '2024-01-22 18:42:34'),
(159, 1, 5, 1, '30.7046297,76.6843926', '30.693079775133477,76.68931245803833', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'H no 242 Sec 89, Lakhnaur, Sahibzada Ajit Singh Nagar', 4.10, 0, '2024-01-22 11:50:58', '', '', 4.10, '0', '8.2', 1, 2, 0.00, 0.00, 12.49, 12.49, '2024-01-22 18:50:58', '2024-01-22 18:50:58'),
(160, 1, 5, 1, '30.7046308,76.6843913', '30.69793477004292,76.68391350656748', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Unnamed Road, Sector 91, S A S Nagar', 1.50, 0, '2024-01-22 11:54:33', '', '', 1.50, '0', '4.2', 1, 3, 0.00, 0.00, 10.96, 10.96, '2024-01-22 18:54:33', '2024-01-22 18:54:33');
INSERT INTO `orders` (`id`, `driver_id`, `customer_id`, `vehicle_category_id`, `start_coordinate`, `end_coordinate`, `start_address`, `end_address`, `distance`, `one_way`, `order_time`, `start_time`, `end_time`, `actual_distance`, `actual_time`, `estimated_time`, `payment_method`, `status`, `pending_amount`, `grand_total`, `total`, `new_total`, `created_at`, `updated_at`) VALUES
(161, 1, 5, 1, '30.7046275,76.6843893', '30.69830724531297,76.68630570173264', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXP+7F2, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 11:57:32', '', '', 1.00, '0', '2.2', 1, 5, 0.00, 0.00, 10.36, 10.36, '2024-01-22 18:57:32', '2024-01-22 18:57:32'),
(162, 1, 5, 1, '30.7046257,76.6843905', '30.694929833763425,76.69126510620117', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVR+WGF, Sector 76, Sahibzada Ajit Singh Nagar', 1.70, 0, '2024-01-22 12:01:19', '', '', 1.70, '0', '3.8', 1, 7, 0.00, 0.00, 10.84, 10.84, '2024-01-22 19:01:19', '2024-01-22 19:01:19'),
(163, 1, 5, 1, '30.7046287,76.6843929', '30.69570940215809,76.68875724077225', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWQ+99P, Sector 75, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-22 12:03:51', '', '', 1.60, '0', '3.9', 1, 7, 0.00, 0.00, 10.87, 10.87, '2024-01-22 19:03:51', '2024-01-22 19:03:51'),
(164, 1, 5, 1, '30.7046279,76.6843897', '30.69843207609964,76.6875770688057', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXQ+58M, Sector 75, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-22 12:36:27', '', '', 1.00, '0', '1.9', 1, 7, 0.00, 0.00, 10.27, 10.27, '2024-01-22 19:36:27', '2024-01-22 19:36:27'),
(165, 1, 5, 1, '30.7046289,76.6843919', '30.696004333381644,76.69041316956282', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Sector 91 Rd, Lakhnaur, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-22 12:43:16', '', '', 1.60, '0', '3.4', 1, 7, 0.00, 0.00, 10.72, 10.72, '2024-01-22 19:43:16', '2024-01-22 19:43:16'),
(166, 1, 5, 1, '30.7046272,76.68439', '30.697963022861455,76.68331101536751', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'GH 01, Sector 91, Sahibzada Ajit Singh Nagar', 1.70, 0, '2024-01-22 12:52:44', '', '', 1.70, '', '5.2', 1, 1, 0.00, 0.00, 11.26, 11.26, '2024-01-22 19:52:44', '2024-01-22 19:52:44'),
(167, 1, 5, 1, '30.7046171,76.684397', '30.689175997596287,76.68833177536726', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '1134, Lakhnaur, Sahibzada Ajit Singh Nagar', 3.40, 0, '2024-01-23 04:21:36', '', '', 3.40, '0', '7.3', 1, 3, 0.00, 0.00, 11.89, 11.89, '2024-01-23 11:21:36', '2024-01-23 11:21:36'),
(168, 1, 5, 1, '30.7046203,76.6843978', '30.694951168189395,76.68478555977345', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMVM+XV9, Lakhnaur, Sahibzada Ajit Singh Nagar', 1.80, 0, '2024-01-23 04:34:17', '', '', 1.80, '0', '4.0', 1, 7, 0.00, 0.00, 10.90, 10.90, '2024-01-23 11:34:17', '2024-01-23 11:34:17'),
(169, 1, 5, 1, '30.7045924,76.6843844', '30.698153585023594,76.6888615116477', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', '545, Sector 75, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-23 04:48:06', '', '', 1.20, '0', '2.4', 1, 10, 0.00, 0.00, 10.42, 10.42, '2024-01-23 11:48:06', '2024-01-23 11:48:06'),
(170, 1, 5, 1, '30.7046188,76.6843937', '30.695618875678026,76.68831199407578', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWQ+99P, Sector 75, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-23 05:06:41', '', '', 1.60, '0', '3.8', 1, 8, 0.00, 0.00, 10.84, 10.84, '2024-01-23 12:06:41', '2024-01-23 12:06:41'),
(171, NULL, 5, 1, '30.700485562607383,76.67983051389456', '30.70573136923898,76.69171437621117', 'OFFICE, Sector 91, Sahibzada Ajit Singh Nagar', '40A, Extension, Sahibzada Ajit Singh Nagar', 1.40, 0, '2024-01-23 05:15:53', '', '', 1.40, '', '3.5', 1, 0, 0.00, 0.00, 10.75, 10.75, '2024-01-23 12:15:53', '2024-01-23 12:15:53'),
(172, 1, 5, 1, '30.70403430402395,76.68341025710106', '30.70424416864068,76.68685857206583', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 'PM3P+9JC, Sector 74, Sahibzada Ajit Singh Nagar', 0.40, 0, '2024-01-23 05:22:36', '', '', 0.40, '0', '1.1', 1, 7, 0.00, 0.00, 10.03, 10.03, '2024-01-23 12:22:36', '2024-01-23 12:22:36'),
(173, NULL, 5, 1, '30.70488759687308,76.68314773589373', '30.70595045480979,76.68597713112831', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 'C-201, Sector 74, Sahibzada Ajit Singh Nagar', 0.30, 0, '2024-01-23 05:32:21', '', '', 0.30, '0', '0.6', 1, 10, 0.00, 0.00, 9.88, 9.88, '2024-01-23 12:32:21', '2024-01-23 12:32:21'),
(174, 1, 5, 1, '30.701134205026726,76.68154511600733', '30.706519498428516,76.68703727424145', '344, Sector 91, Sahibzada Ajit Singh Nagar', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 0.90, 0, '2024-01-23 05:36:37', '', '', 0.90, '0', '2.4', 1, 3, 0.00, 0.00, 10.42, 10.42, '2024-01-23 12:36:37', '2024-01-23 12:36:37'),
(175, NULL, 5, 1, '30.703528666795,76.68262604624033', '30.705218245823335,76.68507993221283', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', '201-202, Sector 74, Sahibzada Ajit Singh Nagar', 0.30, 0, '2024-01-23 05:54:22', '', '', 0.30, '', '0.6', 1, 10, 0.00, 0.00, 9.88, 9.88, '2024-01-23 12:54:22', '2024-01-23 12:54:22'),
(176, 1, 5, 1, '30.705427243049574,76.6853317245841', '30.700363617345623,76.68510138988495', '201-202, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.80, 0, '2024-01-23 05:55:28', '', '', 0.80, '', '1.7', 1, 1, 0.00, 0.00, 10.21, 10.21, '2024-01-23 12:55:28', '2024-01-23 12:55:28'),
(177, 1, 5, 1, '30.703598141622596,76.68260961771011', '30.70343007587493,76.68671138584614', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', 'PM3P+9JC, Sector 74, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-23 05:59:02', '', '', 0.60, '0', '1.2', 1, 7, 0.00, 0.00, 10.06, 10.06, '2024-01-23 12:59:02', '2024-01-23 12:59:02'),
(178, 1, 5, 1, '30.703119600301825,76.68319970369339', '30.707960829962385,76.68638650327921', 'R-28, Sector 74, Sahibzada Ajit Singh Nagar', 'PM5P+4CJ, Sector 74, Sahibzada Ajit Singh Nagar', 0.90, 0, '2024-01-23 06:05:17', '', '', 0.90, '0', '2.2', 1, 2, 0.00, 0.00, 10.36, 10.36, '2024-01-23 13:05:17', '2024-01-23 13:05:17'),
(179, 1, 5, 1, '30.70599138916389,76.68640695512295', '30.702715432831532,76.68310046195984', 'STOREROOM, Sector 74, Sahibzada Ajit Singh Nagar', '108, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-23 06:09:45', '', '', 0.60, '0', '1.2', 1, 3, 0.00, 0.00, 10.06, 10.06, '2024-01-23 13:09:45', '2024-01-23 13:09:45'),
(180, 1, 5, 1, '30.7045914,76.6843729', '30.703445642869013,76.68305553495884', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'R-28, Sector 74, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-23 06:16:37', '', '', 0.00, '0', '0.0', 1, 7, 0.00, 0.00, 9.70, 9.70, '2024-01-23 13:16:37', '2024-01-23 13:16:37'),
(181, NULL, 5, 1, '30.7046156,76.6843919', '30.704024790919227,76.68733600527048', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM3P+9JC, Sector 74, Sahibzada Ajit Singh Nagar', 0.40, 0, '2024-01-23 06:24:04', '', '', 0.40, '', '1.1', 1, 10, 0.00, 0.00, 10.03, 10.03, '2024-01-23 13:24:04', '2024-01-23 13:24:04'),
(182, 1, 5, 1, '30.704624,76.6843969', '30.69920066117296,76.6843869164586', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Unnamed Road, Sector 91, Sahibzada Ajit Singh Nagar', 1.10, 0, '2024-01-23 06:24:52', '', '', 1.10, '0', '2.7', 1, 2, 0.00, 0.00, 10.51, 10.51, '2024-01-23 13:24:52', '2024-01-23 13:24:52'),
(183, NULL, 5, 1, '30.7046218,76.6843982', '30.70164677359659,76.68454047292471', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-23 06:44:50', '', '', 0.50, '', '1.1', 1, 10, 0.00, 0.00, 10.03, 10.03, '2024-01-23 13:44:50', '2024-01-23 13:44:50'),
(184, NULL, 5, 1, '30.703391446656564,76.68327949941158', '30.708810628943187,76.68812457472086', 'R-28, Sector 74, Sahibzada Ajit Singh Nagar', 'PM5Q+HMH, Sector 74, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-23 06:45:50', '', '', 1.20, '', '3.3', 1, 10, 0.00, 0.00, 10.69, 10.69, '2024-01-23 13:45:50', '2024-01-23 13:45:50'),
(185, 1, 5, 1, '30.706109003267812,76.68522913008928', '30.699349995446973,76.6852331534028', 'C-205, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXP+855, Sector 91, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-23 06:51:34', '', '', 1.20, '', '3.8', 1, 1, 0.00, 0.00, 10.84, 10.84, '2024-01-23 13:51:34', '2024-01-23 13:51:34'),
(186, 1, 5, 1, '30.706354608728354,76.68617762625217', '30.7020463330342,76.68485797941685', 'C-201, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.90, 0, '2024-01-23 06:55:01', '', '', 0.90, '0', '2.0', 1, 2, 0.00, 0.00, 10.30, 10.30, '2024-01-23 13:55:01', '2024-01-23 13:55:01'),
(187, 1, 5, 1, '30.703839717604673,76.68200679123402', '30.705942094974755,76.68828886002302', 'R 33, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 1.20, 0, '2024-01-23 07:00:31', '', '', 1.20, '0', '2.8', 1, 3, 0.00, 0.00, 10.54, 10.54, '2024-01-23 14:00:31', '2024-01-23 14:00:31'),
(188, 1, 5, 1, '30.703536450284393,76.68248690664768', '30.702918958174422,76.68440971523523', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', '236 D, Sector 74, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-23 07:04:40', '', '', 0.50, '', '1.2', 1, 1, 0.00, 0.00, 10.06, 10.06, '2024-01-23 14:04:40', '2024-01-23 14:04:40'),
(189, NULL, 5, 1, '30.703595258850655,76.68251372873783', '30.706604249318598,76.68748419731855', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-23 07:07:49', '', '', 0.60, '', '1.3', 1, 10, 0.00, 0.00, 10.09, 10.09, '2024-01-23 14:07:49', '2024-01-23 14:07:49'),
(190, 1, 5, 1, '30.70323923585455,76.68229848146439', '30.70558463928245,76.68616086244583', 'R-28, Sector 74, Sahibzada Ajit Singh Nagar', 'STOREROOM, Sector 74, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-23 07:08:49', '', '', 0.70, '', '1.8', 1, 1, 0.00, 0.00, 10.24, 10.24, '2024-01-23 14:08:49', '2024-01-23 14:08:49'),
(191, 1, 5, 1, '30.70376015326689,76.68315678834915', '30.707508542445577,76.68653503060341', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', 'PM4P+XFJ, Sector 74, Sahibzada Ajit Singh Nagar', 0.70, 0, '2024-01-23 07:11:38', '', '', 0.70, '0', '1.5', 1, 2, 0.00, 0.00, 10.15, 10.15, '2024-01-23 14:11:38', '2024-01-23 14:11:38'),
(192, 1, 5, 1, '30.703112393336106,76.68201047927141', '30.706780957567652,76.68569013476372', 'R 54, Sector 74, Sahibzada Ajit Singh Nagar', '33, Sector 74, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-23 07:21:34', '', '', 1.00, '0', '3.9', 1, 2, 0.00, 0.00, 10.87, 10.87, '2024-01-23 14:21:34', '2024-01-23 14:21:34'),
(193, 1, 5, 1, '30.703341286305164,76.68252814561129', '30.6951795039125,76.68643075972795', 'R-28, Sector 74, Sahibzada Ajit Singh Nagar', 'MMWP+3G5, Sector 91, Sahibzada Ajit Singh Nagar', 1.40, 0, '2024-01-23 07:39:55', '', '', 1.40, '0', '3.2', 1, 7, 0.00, 0.00, 10.66, 10.66, '2024-01-23 14:39:55', '2024-01-23 14:39:55'),
(194, 1, 5, 1, '30.703481101012812,76.68219555169344', '30.706330105864243,76.68704196810722', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', 'STOREROOM, Sector 74, Sahibzada Ajit Singh Nagar', 0.80, 0, '2024-01-23 07:44:54', '', '', 0.80, '0', '2.2', 1, 5, 0.00, 0.00, 10.36, 10.36, '2024-01-23 14:44:54', '2024-01-23 14:44:54'),
(195, 1, 5, 1, '30.703475912016955,76.68258480727673', '30.706250831849477,76.68665874749422', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', 'STOREROOM, Sector 74, Sahibzada Ajit Singh Nagar', 0.00, 0, '2024-01-23 07:49:36', '', '', 0.00, '0', '0.0', 1, 3, 0.00, 0.00, 9.70, 9.70, '2024-01-23 14:49:36', '2024-01-23 14:49:36'),
(196, 1, 5, 1, '30.70600436131475,76.68613839894533', '30.699348553997556,76.6842246428132', 'STOREROOM, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXM+Q6X, Sector 91, Sahibzada Ajit Singh Nagar', 1.30, 0, '2024-01-23 07:54:20', '', '', 1.30, '0', '3.1', 1, 3, 0.00, 0.00, 10.51, 10.51, '2024-01-23 14:54:20', '2024-01-23 14:54:20'),
(197, 1, 5, 1, '30.707371904499535,76.68921187520027', '30.701934479621016,76.6845666244626', 'F-125, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+HQ3, Sector 91, Sahibzada Ajit Singh Nagar', 0.50, 0, '2024-01-23 08:00:25', '', '', 0.50, '0', '1.2', 1, 5, 0.00, 0.00, 10.06, 10.06, '2024-01-23 15:00:25', '2024-01-23 15:00:25'),
(198, 1, 5, 1, '30.7022729222831,76.68077062815428', '30.706272452041794,76.68866705149412', '373, Sector 91, Greater Mohali', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 1.30, 0, '2024-01-23 08:43:00', '', '', 1.30, '0', '4.2', 1, 7, 0.00, 0.00, 10.96, 10.96, '2024-01-23 15:43:00', '2024-01-23 15:43:00'),
(199, 1, 5, 1, '30.71165659387254,76.69309336692095', '30.70375640566964,76.68294589966536', 'F 256, Sector 74, Sahibzada Ajit Singh Nagar', 'R30, Sector 74, Sahibzada Ajit Singh Nagar', 0.20, 0, '2024-01-23 08:48:04', '', '', 0.20, '0', '0.3', 1, 3, 0.00, 0.00, 9.79, 9.79, '2024-01-23 15:48:04', '2024-01-23 15:48:04'),
(200, 1, 5, 1, '30.707579455733708,76.67787283658981', '30.69872036829243,76.68723542243242', 'Phase 3B-1, , Sahibzada Ajit Singh Nagar', 'M.G.Enterprises Plot no. F-411, Sector 91, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-23 09:18:58', '', '', 1.50, '0', '2.9', 1, 2, 0.00, 0.00, 10.57, 10.57, '2024-01-23 16:18:58', '2024-01-23 16:18:58'),
(201, NULL, 5, 1, '30.710830745180015,76.68885212391615', '30.70015518572582,76.68248690664768', 'knowledge 4 marketz E237 Continental Tower 4th Floor, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXM+X4W, Sector 91, Sahibzada Ajit Singh Nagar', 1.80, 0, '2024-01-23 09:31:58', '', '', 1.80, '', '4.9', 1, 10, 0.00, 0.00, 11.17, 11.17, '2024-01-23 16:31:58', '2024-01-23 16:31:58'),
(202, 1, 5, 1, '30.72241590571061,76.7011721804738', '30.700614138295666,76.67955256998539', '7, Sector 73, Sahibzada Ajit Singh Nagar', 'OFFICE, Sector 91, Sahibzada Ajit Singh Nagar', 4.10, 0, '2024-01-23 09:33:17', '', '', 4.10, '', '8.4', 1, 1, 0.00, 0.00, 12.55, 12.55, '2024-01-23 16:33:17', '2024-01-23 16:33:17'),
(203, NULL, 5, 1, '30.69968354626303,76.67777795344591', '30.71052058168052,76.69032197445631', '613, Sector 91, Sahibzada Ajit Singh Nagar', 'PM6R+424, Sector 74, Sahibzada Ajit Singh Nagar', 2.10, 0, '2024-01-23 09:49:27', '', '', 2.10, '', '5.8', 1, 10, 0.00, 0.00, 11.44, 11.44, '2024-01-23 16:49:27', '2024-01-23 16:49:27'),
(204, 1, 5, 1, '30.70228906602607,76.68069586157799', '30.710470713292462,76.69181026518345', '373, Sector 91, Greater Mohali', 'F-209, Sector 74, Sahibzada Ajit Singh Nagar', 1.80, 0, '2024-01-23 09:50:06', '', '', 1.80, '0', '4.9', 1, 8, 0.00, 0.00, 11.17, 11.17, '2024-01-23 16:50:06', '2024-01-23 16:50:06'),
(205, NULL, 5, 1, '30.70946325102931,76.68852757662535', '30.69763436711375,76.68736148625612', 'E195, Sector 74, Sahibzada Ajit Singh Nagar', '8B, Sector 74, Sahibzada Ajit Singh Nagar', 2.10, 0, '2024-01-23 10:14:51', '', '', 2.10, '', '4.7', 1, 10, 0.00, 0.00, 11.11, 11.11, '2024-01-23 17:14:51', '2024-01-23 17:14:51'),
(206, 1, 5, 1, '30.702440990046373,76.68050307780504', '30.709948390823197,76.69062338769436', '373, Sector 91, Greater Mohali', '209, Sector 74, Sahibzada Ajit Singh Nagar', 1.90, 0, '2024-01-23 10:15:56', '', '', 1.90, '0', '5.3', 1, 2, 0.00, 0.00, 11.29, 11.29, '2024-01-23 17:15:56', '2024-01-23 17:15:56'),
(207, 1, 5, 1, '30.7046198,76.6843971', '30.701947452317356,76.68575819581747', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 0.60, 0, '2024-01-23 10:43:14', '', '', 0.60, '0', '1.4', 1, 7, 0.00, 0.00, 10.12, 10.12, '2024-01-23 17:43:14', '2024-01-23 17:43:14'),
(208, NULL, 5, 1, '30.707635955714583,76.68807830661535', '30.698175207030328,76.6788887232542', 'Sector 74 Bus Stop, Sector 74, Sahibzada Ajit Singh Nagar', '140308, Sector 91, Sahibzada Ajit Singh Nagar', 1.70, 0, '2024-01-23 11:08:42', '', '', 1.70, '', '4.1', 1, 10, 0.00, 0.00, 10.93, 10.93, '2024-01-23 18:08:42', '2024-01-23 18:08:42'),
(209, 1, 5, 1, '30.70436005522518,76.6789822652936', '30.708668227600846,76.69062104076147', 'PM3H+PCG, Sector 91, Sahibzada Ajit Singh Nagar', 'PM5R+G7R, Sector 74, Sahibzada Ajit Singh Nagar', 2.40, 0, '2024-01-23 11:09:21', '', '', 2.40, '', '7.8', 1, 10, 0.00, 0.00, 12.04, 12.04, '2024-01-23 18:09:21', '2024-01-23 18:09:21'),
(210, NULL, 5, 1, '30.704619,76.6843975', '30.70347850651492,76.68308436870575', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'R-28, Sector 74, Sahibzada Ajit Singh Nagar', 0.20, 0, '2024-01-23 11:13:16', '', '', 0.20, '', '0.6', 1, 0, 0.00, 0.00, 9.88, 9.88, '2024-01-23 18:13:16', '2024-01-23 18:13:16'),
(211, NULL, 5, 1, '30.7046222,76.6843972', '30.70032556347354,76.68653469532728', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 1.90, 0, '2024-01-23 11:14:14', '', '', 1.90, '', '6.1', 1, 0, 0.00, 0.00, 11.53, 11.53, '2024-01-23 18:14:14', '2024-01-23 18:14:14'),
(212, NULL, 5, 1, '30.704618,76.6843978', '30.699471365410613,76.68644953519106', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'MMXP+7F2, Sector 91, Sahibzada Ajit Singh Nagar', 0.80, 0, '2024-01-23 11:17:19', '', '', 0.80, '', '1.6', 1, 10, 0.00, 0.00, 10.18, 10.18, '2024-01-23 18:17:19', '2024-01-23 18:17:19'),
(213, 1, 5, 1, '30.7078789629081,76.6871415451169', '30.701837040201816,76.68103247880936', 'PM5P+4Q8, Sector 74, Sahibzada Ajit Singh Nagar', '350, Sector 91, Sahibzada Ajit Singh Nagar', 1.60, 0, '2024-01-23 11:18:41', '', '', 1.60, '0', '4.3', 1, 10, 0.00, 0.00, 10.99, 10.99, '2024-01-23 18:18:41', '2024-01-23 18:18:41'),
(214, 1, 5, 1, '30.702346433947998,76.67977586388588', '30.704042375748415,76.68912637978792', '378, Sector 91, Sahibzada Ajit Singh Nagar', 'E-191 Indus. Area Phase 8B, Sector 75, Sahibzada Ajit Singh Nagar', 2.20, 0, '2024-01-23 11:23:21', '', '', 2.20, '0', '7.3', 1, 8, 0.00, 0.00, 11.89, 11.89, '2024-01-23 18:23:21', '2024-01-23 18:23:21'),
(215, NULL, 5, 1, '30.70237872140663,76.68129332363605', '30.707881557287646,76.6892809420824', 'R/135, Sector 74, Sahibzada Ajit Singh Nagar', 'F-125, Sector 74, Sahibzada Ajit Singh Nagar', 1.30, 0, '2024-01-23 11:33:59', '', '', 1.30, '', '3.7', 1, 10, 0.00, 0.00, 10.81, 10.81, '2024-01-23 18:33:59', '2024-01-23 18:33:59'),
(216, 1, 5, 1, '30.7046214,76.684399', '30.70591701546537,76.69156216084957', 'D235, Sector 74, Sahibzada Ajit Singh Nagar', 'Teleperformance Mohali, Sector 75, Sahibzada Ajit Singh Nagar', 0.90, 0, '2024-01-23 11:34:43', '', '', 0.90, '0', '2.4', 1, 7, 0.00, 0.00, 10.42, 10.42, '2024-01-23 18:34:43', '2024-01-23 18:34:43'),
(217, 1, 5, 1, '30.703613708589554,76.68051548302174', '30.70774549639954,76.68843671679497', '116, Sector 74, Sahibzada Ajit Singh Nagar', '5th, Sector 74, Sahibzada Ajit Singh Nagar', 1.50, 0, '2024-01-23 11:42:24', '', '', 1.50, '0', '4.6', 1, 7, 0.00, 0.00, 11.08, 11.08, '2024-01-23 18:42:24', '2024-01-23 18:42:24'),
(218, 1, 5, 1, '30.703240388967576,76.67936850339174', '30.71234003957235,76.69430539011955', 'BLOCK-B, Sector 91, Sahibzada Ajit Singh Nagar', 'E-200, Sector 74, Sahibzada Ajit Singh Nagar', 3.70, 0, '2024-01-23 11:51:27', '', '', 3.70, '0', '9.7', 1, 8, 0.00, 0.00, 12.61, 12.61, '2024-01-23 18:51:27', '2024-01-23 18:51:27'),
(219, 1, 5, 1, '30.70717098294885,76.68335493654013', '30.700555616198685,76.68596338480711', 'PM4M+R9R, Sector 74, Sahibzada Ajit Singh Nagar', 'PM2M+8VG, Sector 91, Sahibzada Ajit Singh Nagar', 1.00, 0, '2024-01-23 11:56:18', '', '', 1.00, '0', '2.8', 1, 2, 0.00, 0.00, 10.54, 10.54, '2024-01-23 18:56:18', '2024-01-23 18:56:18');

-- --------------------------------------------------------

--
-- Table structure for table `order_history`
--

CREATE TABLE `order_history` (
  `id` int(11) NOT NULL,
  `order_id` int(10) UNSIGNED NOT NULL,
  `pending_amount` double(8,2) DEFAULT '0.00',
  `new_total` double(8,2) DEFAULT '0.00',
  `status` enum('','no','yes') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `order_history`
--

INSERT INTO `order_history` (`id`, `order_id`, `pending_amount`, `new_total`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 0.00, 10.51, 'no', '2024-01-15 16:56:29', '2024-01-15 16:59:36');

-- --------------------------------------------------------

--
-- Table structure for table `order_reject`
--

CREATE TABLE `order_reject` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `driver_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Driver ID',
  `order_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Order ID',
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_reject`
--

INSERT INTO `order_reject` (`id`, `driver_id`, `order_id`, `reason`, `status`, `created_at`, `updated_at`) VALUES
(1, 1, 81, 'Wrong address shown', 1, '2024-01-19 17:31:30', '2024-01-19 17:31:30');

-- --------------------------------------------------------

--
-- Table structure for table `order_settings`
--

CREATE TABLE `order_settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `discount` int(11) NOT NULL DEFAULT '0',
  `min_discount` int(11) NOT NULL DEFAULT '0',
  `night_service` int(11) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_settings`
--

INSERT INTO `order_settings` (`id`, `discount`, `min_discount`, `night_service`, `created_at`, `updated_at`) VALUES
(1, 3, 2, 2, '2023-04-29 08:03:49', '2023-04-29 08:03:49');

-- --------------------------------------------------------

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `driver_id` bigint(20) UNSIGNED DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL,
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tip` double(8,2) NOT NULL DEFAULT '0.00',
  `total` double(8,2) NOT NULL DEFAULT '0.00',
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=pending, 1= payment success, 2= payment cancel',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`id`, `driver_id`, `order_id`, `transaction_id`, `tip`, `total`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 10, '', 0.25, 24.00, 2, '2024-01-12 19:10:32', '2024-01-12 19:10:32');

-- --------------------------------------------------------

--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `sender_id` int(11) DEFAULT NULL,
  `receiver_id` int(11) DEFAULT NULL,
  `order_id` bigint(20) UNSIGNED DEFAULT NULL COMMENT 'Order ID',
  `rating` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `review` text COLLATE utf8mb4_unicode_ci,
  `type` tinyint(1) NOT NULL COMMENT '1 = customer to driver, 2= driver to customer',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `reasons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `reasons` (`id`, `reason`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Wrong Address Shown', 1, NULL, NULL),
(2, 'Any Legal Instructions Violation', 1, NULL, NULL),
(3, 'Other', 1, NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `user_chat`
--

CREATE TABLE `user_chat` (
  `id` bigint(20) NOT NULL,
  `roomID` varchar(22) COLLATE utf8mb4_bin NOT NULL,
  `source_user_id` bigint(20) NOT NULL,
  `target_user_id` bigint(20) NOT NULL,
  `senderType` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `recieverType` varchar(100) COLLATE utf8mb4_bin NOT NULL,
  `message` mediumtext COLLATE utf8mb4_bin NOT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0 => Unread, 1 => Read',
  `MessageType` varchar(22) COLLATE utf8mb4_bin NOT NULL,
  `modified_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `created_on` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin;

--
-- Dumping data for table `user_chat`
--

INSERT INTO `user_chat` (`id`, `roomID`, `source_user_id`, `target_user_id`, `senderType`, `recieverType`, `message`, `status`, `MessageType`, `modified_on`, `created_on`) VALUES
(1, '1-1', 1, 1, 'Customer', 'Driver', 'hu', 1, 'Text', '2024-01-12 06:22:34', '2024-01-12 13:22:32'),
(2, '1-1', 1, 1, 'Driver', 'Customer', 'hh', 1, 'Text', '2024-01-12 13:22:36', '2024-01-12 13:22:36'),
(3, '1-1', 1, 1, 'Driver', 'Customer', 'rr', 1, 'Text', '2024-01-12 06:22:43', '2024-01-12 13:22:39'),
(4, '4-4', 4, 4, 'Customer', 'Driver', 'hu', 1, 'Text', '2024-01-12 07:52:48', '2024-01-12 14:52:36'),
(5, '4-4', 4, 4, 'Customer', 'Driver', 'd55', 1, 'Text', '2024-01-12 07:52:48', '2024-01-12 14:52:45'),
(6, '4-4', 4, 4, 'Customer', 'Driver', 'cy', 1, 'Text', '2024-01-12 14:54:33', '2024-01-12 14:54:33'),
(7, '4-4', 4, 4, 'Customer', 'Driver', '990', 1, 'Text', '2024-01-12 14:54:43', '2024-01-12 14:54:43'),
(8, '4-4', 4, 4, 'Driver', 'Customer', 'iiiiici', 1, 'Text', '2024-01-12 07:55:11', '2024-01-12 14:55:07'),
(9, '4-4', 4, 4, 'Customer', 'Driver', 'chjc', 1, 'Text', '2024-01-12 07:58:08', '2024-01-12 14:57:31'),
(10, '4-4', 4, 4, 'Customer', 'Driver', 'erdddr', 1, 'Text', '2024-01-12 07:58:08', '2024-01-12 14:57:48'),
(11, '4-4', 4, 4, 'Customer', 'Driver', 'errrr', 1, 'Text', '2024-01-12 07:58:08', '2024-01-12 14:57:59'),
(12, '4-4', 4, 4, 'Customer', 'Driver', 'rrrt', 1, 'Text', '2024-01-12 07:58:08', '2024-01-12 14:58:05'),
(13, '4-4', 4, 4, 'Customer', 'Driver', 'pp', 1, 'Text', '2024-01-12 14:58:15', '2024-01-12 14:58:15'),
(14, '4-4', 4, 4, 'Customer', 'Driver', 'rer', 1, 'Text', '2024-01-12 15:01:29', '2024-01-12 15:01:29'),
(15, '4-4', 4, 4, 'Customer', 'Driver', 'yddy', 1, 'Text', '2024-01-12 15:01:31', '2024-01-12 15:01:31'),
(16, '4-4', 4, 4, 'Customer', 'Driver', 'egjreyeyeee', 1, 'Text', '2024-01-12 15:01:36', '2024-01-12 15:01:36'),
(17, '4-4', 4, 4, 'Customer', 'Driver', '3wee3', 1, 'Text', '2024-01-12 15:01:47', '2024-01-12 15:01:47'),
(18, '4-4', 4, 4, 'Customer', 'Driver', 'cu', 1, 'Text', '2024-01-12 15:46:19', '2024-01-12 15:46:19'),
(19, '4-4', 4, 4, 'Driver', 'Customer', '565', 1, 'Text', '2024-01-12 15:46:28', '2024-01-12 15:46:28'),
(20, '4-4', 4, 4, 'Customer', 'Driver', 'fi', 1, 'Text', '2024-01-12 08:46:52', '2024-01-12 15:46:33'),
(21, '4-4', 4, 4, 'Customer', 'Driver', 'h7', 1, 'Text', '2024-01-12 16:02:11', '2024-01-12 16:02:11'),
(22, '4-4', 4, 4, 'Customer', 'Driver', '6yh', 1, 'Text', '2024-01-12 16:02:19', '2024-01-12 16:02:19'),
(23, '4-4', 4, 4, 'Customer', 'Driver', 'bb', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:02:31'),
(24, '4-4', 4, 4, 'Customer', 'Driver', 'h7h7h7', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:02:56'),
(25, '4-4', 4, 4, 'Customer', 'Driver', '7uhh', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:03:04'),
(26, '4-4', 4, 4, 'Customer', 'Driver', 'sddd', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:03:11'),
(27, '4-4', 4, 4, 'Customer', 'Driver', 'cccccccgf', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:03:16'),
(28, '4-4', 4, 4, 'Customer', 'Driver', 'grtttt', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:03:20'),
(29, '4-4', 4, 4, 'Customer', 'Driver', 'gggggy', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:03:22'),
(30, '4-4', 4, 4, 'Customer', 'Driver', 'researchers have been trying for', 1, 'Text', '2024-01-12 09:04:03', '2024-01-12 16:03:32'),
(31, '4-4', 4, 4, 'Customer', 'Driver', 'cucuxuuccu', 1, 'Text', '2024-01-12 09:04:18', '2024-01-12 16:04:09'),
(32, '4-4', 4, 4, 'Customer', 'Driver', 'rrrr', 1, 'Text', '2024-01-12 09:04:18', '2024-01-12 16:04:14'),
(33, '4-4', 4, 4, 'Customer', 'Driver', 'add a few', 1, 'Text', '2024-01-12 09:05:44', '2024-01-12 16:05:09'),
(34, '4-4', 4, 4, 'Customer', 'Driver', 'added a few weeks', 1, 'Text', '2024-01-12 09:05:44', '2024-01-12 16:05:26'),
(35, '1-4', 4, 1, 'Customer', 'Driver', 'hbi', 1, 'Text', '2024-01-12 09:11:23', '2024-01-12 16:10:56'),
(36, '1-4', 4, 1, 'Customer', 'Driver', 'hhh', 1, 'Text', '2024-01-12 09:11:23', '2024-01-12 16:11:03'),
(37, '1-4', 4, 1, 'Customer', 'Driver', '789', 1, 'Text', '2024-01-12 09:11:23', '2024-01-12 16:11:07'),
(38, '1-4', 4, 1, 'Customer', 'Driver', 'h', 1, 'Text', '2024-01-12 09:11:23', '2024-01-12 16:11:11'),
(39, '1-4', 4, 1, 'Customer', 'Driver', 'bu', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:11:27'),
(40, '1-4', 4, 1, 'Customer', 'Driver', 'sdrrtt', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:11:42'),
(41, '1-4', 4, 1, 'Customer', 'Driver', 'y', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:11:46'),
(42, '1-4', 4, 1, 'Customer', 'Driver', 'h', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:11:47'),
(43, '1-4', 4, 1, 'Customer', 'Driver', 'uhvu', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:13:31'),
(44, '1-4', 4, 1, 'Customer', 'Driver', '6778', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:13:39'),
(45, '1-4', 4, 1, 'Customer', 'Driver', 'eeeeeee', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:15:19'),
(46, '1-4', 4, 1, 'Customer', 'Driver', '33eeeeeeee that your boyfriend has been', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:15:29'),
(47, '1-4', 4, 1, 'Customer', 'Driver', '33eeeeeeee that your boyfriend has been', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:15:39'),
(48, '1-4', 4, 1, 'Customer', 'Driver', 'vyv6v6bubub was also', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:16:02'),
(49, '1-4', 4, 1, 'Customer', 'Driver', 'xccvyv6v6bubub is the most important thing to me is a', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:16:19'),
(50, '1-4', 4, 1, 'Customer', 'Driver', 'bub7', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:16:56'),
(51, '1-4', 4, 1, 'Customer', 'Driver', 'lll', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:16:59'),
(52, '1-4', 4, 1, 'Customer', 'Driver', 'j7jm8', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:17:42'),
(53, '1-4', 4, 1, 'Customer', 'Driver', '780', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:17:49'),
(54, '1-4', 4, 1, 'Customer', 'Driver', 'effect of this process in a new way is to', 1, 'Text', '2024-01-12 09:18:32', '2024-01-12 16:18:04'),
(55, '1-4', 4, 1, 'Customer', 'Driver', 'frrrrr', 1, 'Text', '2024-01-12 09:56:08', '2024-01-12 16:18:45'),
(56, '1-4', 4, 1, 'Customer', 'Driver', 'rrr has a lot to offer', 1, 'Text', '2024-01-12 09:56:08', '2024-01-12 16:19:22'),
(57, '1-4', 4, 1, 'Customer', 'Driver', 'gu', 1, 'Text', '2024-01-12 09:59:29', '2024-01-12 16:56:11'),
(58, '1-4', 4, 1, 'Customer', 'Driver', 'givu', 1, 'Text', '2024-01-12 09:59:29', '2024-01-12 16:58:19'),
(59, '1-4', 4, 1, 'Customer', 'Driver', 'fiif', 1, 'Text', '2024-01-12 09:59:29', '2024-01-12 16:58:26'),
(60, '1-4', 1, 4, 'Driver', 'Customer', 'hh', 1, 'Text', '2024-01-12 10:01:00', '2024-01-12 16:59:27'),
(61, '1-4', 4, 1, 'Customer', 'Driver', 'htht', 1, 'Text', '2024-01-12 10:01:54', '2024-01-12 17:00:48'),
(62, '1-4', 1, 4, 'Driver', 'Customer', 'vddv', 1, 'Text', '2024-01-12 12:22:29', '2024-01-12 17:01:03'),
(63, '2-2', 2, 2, 'Customer', 'Driver', '1', 1, 'Text', '2024-01-12 11:05:21', '2024-01-12 18:04:52'),
(64, '2-2', 2, 2, 'Customer', 'Driver', '2', 1, 'Text', '2024-01-12 11:05:21', '2024-01-12 18:05:10'),
(65, '2-2', 2, 2, 'Driver', 'Customer', '2', 1, 'Text', '2024-01-12 11:05:39', '2024-01-12 18:05:32'),
(66, '2-2', 2, 2, 'Driver', 'Customer', '3', 1, 'Text', '2024-01-12 11:06:10', '2024-01-12 18:05:48'),
(67, '2-2', 2, 2, 'Customer', 'Driver', '4', 1, 'Text', '2024-01-12 11:06:52', '2024-01-12 18:06:33'),
(68, '2-2', 2, 2, 'Driver', 'Customer', '5', 1, 'Text', '2024-01-12 18:06:58', '2024-01-12 18:06:58'),
(69, '2-2', 2, 2, 'Driver', 'Customer', '66', 1, 'Text', '2024-01-12 11:37:14', '2024-01-12 18:37:11'),
(70, '2-2', 2, 2, 'Customer', 'Driver', 'yu', 1, 'Text', '2024-01-12 11:37:36', '2024-01-12 18:37:18'),
(71, '2-2', 2, 2, 'Customer', 'Driver', 'fjuf', 1, 'Text', '2024-01-12 11:37:36', '2024-01-12 18:37:19'),
(72, '2-2', 2, 2, 'Driver', 'Customer', 'ydfjfj', 1, 'Text', '2024-01-12 11:41:45', '2024-01-12 18:37:50'),
(73, '2-2', 2, 2, 'Driver', 'Customer', 'cjgj', 1, 'Text', '2024-01-12 11:41:45', '2024-01-12 18:37:53'),
(74, '2-2', 2, 2, 'Driver', 'Customer', 'ydhxhx', 1, 'Text', '2024-01-12 12:04:15', '2024-01-12 19:03:54'),
(75, '2-2', 2, 2, 'Customer', 'Driver', 'yspzydy', 1, 'Text', '2024-01-12 12:04:15', '2024-01-12 19:03:56'),
(76, '2-2', 2, 2, 'Customer', 'Driver', 'udhd', 1, 'Text', '2024-01-12 12:04:15', '2024-01-12 19:04:01'),
(77, '2-2', 2, 2, 'Driver', 'Customer', 'fuuf', 1, 'Text', '2024-01-12 12:05:37', '2024-01-12 19:05:36'),
(78, '2-2', 2, 2, 'Customer', 'Driver', 'udud', 1, 'Text', '2024-01-12 19:05:40', '2024-01-12 19:05:40'),
(79, '2-2', 2, 2, 'Customer', 'Driver', '5555', 1, 'Text', '2024-01-12 19:05:43', '2024-01-12 19:05:43'),
(80, '2-2', 2, 2, 'Customer', 'Driver', 'fgy', 1, 'Text', '2024-01-12 12:06:38', '2024-01-12 19:05:45'),
(81, '2-2', 2, 2, 'Customer', 'Driver', 'rty', 1, 'Text', '2024-01-12 12:06:38', '2024-01-12 19:05:51'),
(82, '2-2', 2, 2, 'Driver', 'Customer', 'xhxh', 1, 'Text', '2024-01-12 19:06:41', '2024-01-12 19:06:41'),
(83, '2-2', 2, 2, 'Customer', 'Driver', 'yyy', 1, 'Text', '2024-01-12 19:06:42', '2024-01-12 19:06:42'),
(84, '1-4', 1, 4, 'Driver', 'Customer', '15', 1, 'Text', '2024-01-12 12:22:29', '2024-01-12 19:22:26'),
(85, '1-4', 4, 1, 'Customer', 'Driver', 'fg', 1, 'Text', '2024-01-12 19:22:33', '2024-01-12 19:22:33'),
(86, '1-4', 1, 4, 'Driver', 'Customer', '4', 1, 'Text', '2024-01-12 12:26:09', '2024-01-12 19:26:01'),
(87, '1-4', 4, 1, 'Customer', 'Driver', 'uc', 0, 'Text', '2024-01-12 19:26:07', '2024-01-12 19:26:07'),
(88, '2-2', 2, 2, 'Customer', 'Driver', 'uffuuf', 1, 'Text', '2024-01-12 12:40:41', '2024-01-12 19:40:28'),
(89, '2-2', 2, 2, 'Customer', 'Driver', 'uffu', 1, 'Text', '2024-01-12 12:40:41', '2024-01-12 19:40:31'),
(90, '2-2', 2, 2, 'Customer', 'Driver', 'tztz', 1, 'Text', '2024-01-12 12:40:41', '2024-01-12 19:40:32'),
(91, '2-2', 2, 2, 'Customer', 'Driver', 'uuf', 1, 'Text', '2024-01-12 12:40:41', '2024-01-12 19:40:37'),
(92, '2-2', 2, 2, 'Driver', 'Customer', 'cjjcjc', 1, 'Text', '2024-01-12 19:40:45', '2024-01-12 19:40:45'),
(93, '2-2', 2, 2, 'Driver', 'Customer', 'cjjc', 1, 'Text', '2024-01-12 12:40:52', '2024-01-12 19:40:46'),
(94, '2-2', 2, 2, 'Driver', 'Customer', 'ufuf', 1, 'Text', '2024-01-12 12:40:52', '2024-01-12 19:40:49'),
(95, '2-2', 2, 2, 'Driver', 'Customer', 'hxxh', 1, 'Text', '2024-01-12 12:41:37', '2024-01-12 19:41:33'),
(96, '2-2', 2, 2, 'Customer', 'Driver', 'uddyys', 1, 'Text', '2024-01-12 19:41:48', '2024-01-12 19:41:48'),
(97, '2-2', 2, 2, 'Customer', 'Driver', 'udud', 1, 'Text', '2024-01-12 12:41:53', '2024-01-12 19:41:52'),
(98, '2-2', 2, 2, 'Customer', 'Driver', 'hxux', 1, 'Text', '2024-01-12 12:44:50', '2024-01-12 19:43:20'),
(99, '2-2', 2, 2, 'Customer', 'Driver', 'ufufuf', 1, 'Text', '2024-01-12 12:44:50', '2024-01-12 19:43:25'),
(100, '2-2', 2, 2, 'Customer', 'Driver', 'yfyf', 1, 'Text', '2024-01-12 12:44:50', '2024-01-12 19:43:28'),
(101, '2-2', 2, 2, 'Customer', 'Driver', 'hxhx', 1, 'Text', '2024-01-12 13:21:46', '2024-01-12 20:21:33'),
(102, '2-2', 2, 2, 'Customer', 'Driver', 'iguf', 1, 'Text', '2024-01-12 13:21:46', '2024-01-12 20:21:43'),
(103, '2-2', 2, 2, 'Driver', 'Customer', 'hddhhd', 1, 'Text', '2024-01-12 20:21:51', '2024-01-12 20:21:51'),
(104, '2-2', 2, 2, 'Driver', 'Customer', 'kfjc', 1, 'Text', '2024-01-12 13:21:57', '2024-01-12 20:21:53'),
(105, '2-2', 2, 2, 'Driver', 'Customer', 'zgzhx', 1, 'Text', '2024-01-12 13:21:57', '2024-01-12 20:21:56'),
(106, '2-2', 2, 2, 'Customer', 'Driver', 'xuudud', 1, 'Text', '2024-01-12 13:23:00', '2024-01-12 20:22:56'),
(107, '2-2', 2, 2, 'Driver', 'Customer', 'yxhxhx', 1, 'Text', '2024-01-12 20:23:07', '2024-01-12 20:23:07'),
(108, '1-5', 5, 1, 'Customer', 'Driver', 'yyy', 1, 'Text', '2024-01-12 13:48:56', '2024-01-12 20:48:48'),
(109, '2-2', 2, 2, 'Driver', 'Customer', 'cjxhhc', 1, 'Text', '2024-01-12 14:42:08', '2024-01-12 21:42:02'),
(110, '2-2', 2, 2, 'Customer', 'Driver', 'hfhd', 1, 'Text', '2024-01-12 14:42:31', '2024-01-12 21:42:12'),
(111, '2-2', 2, 2, 'Customer', 'Driver', 'fihf', 1, 'Text', '2024-01-12 14:42:31', '2024-01-12 21:42:20'),
(112, '2-2', 2, 2, 'Customer', 'Driver', 'ifuf', 1, 'Text', '2024-01-12 14:42:31', '2024-01-12 21:42:23'),
(113, '2-2', 2, 2, 'Driver', 'Customer', 'hxhx', 1, 'Text', '2024-01-12 21:43:36', '2024-01-12 21:43:36'),
(114, '2-2', 2, 2, 'Customer', 'Driver', 'jcxuux', 1, 'Text', '2024-01-12 14:43:55', '2024-01-12 21:43:52'),
(115, '2-2', 2, 2, 'Customer', 'Driver', '8dud', 1, 'Text', '2024-01-12 14:43:55', '2024-01-12 21:43:53'),
(116, '2-2', 2, 2, 'Customer', 'Driver', 'uxud', 1, 'Text', '2024-01-12 14:43:55', '2024-01-12 21:43:54'),
(117, '2-2', 2, 2, 'Customer', 'Driver', 'jxhx', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:07'),
(118, '2-2', 2, 2, 'Customer', 'Driver', 'idir', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:08'),
(119, '2-2', 2, 2, 'Customer', 'Driver', 'ysye', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:10'),
(120, '2-2', 2, 2, 'Driver', 'Customer', 'hfdu', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:16'),
(121, '2-2', 2, 2, 'Driver', 'Customer', 'hdhxhf', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:19'),
(122, '2-2', 2, 2, 'Driver', 'Customer', 'jcuc', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:22'),
(123, '2-2', 2, 2, 'Driver', 'Customer', 'hxufufu', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:26'),
(124, '2-2', 2, 2, 'Customer', 'Driver', 'hii', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:44:55'),
(125, '2-2', 2, 2, 'Driver', 'Customer', 'thggh', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:45:17'),
(126, '2-2', 2, 2, 'Customer', 'Driver', 'fgg', 1, 'Text', '2024-01-12 14:45:38', '2024-01-12 21:45:23'),
(127, '2-2', 2, 2, 'Driver', 'Customer', 'xhhx', 1, 'Text', '2024-01-12 14:46:03', '2024-01-12 21:46:01'),
(128, '2-2', 2, 2, 'Driver', 'Customer', 'uxuf', 1, 'Text', '2024-01-12 14:46:03', '2024-01-12 21:46:03'),
(129, '2-2', 2, 2, 'Driver', 'Customer', 'yxh', 1, 'Text', '2024-01-12 21:46:06', '2024-01-12 21:46:06'),
(130, '2-2', 2, 2, 'Driver', 'Customer', 'hxuf', 1, 'Text', '2024-01-12 21:46:08', '2024-01-12 21:46:08'),
(131, '2-2', 2, 2, 'Driver', 'Customer', 'ycucuf', 1, 'Text', '2024-01-12 14:49:24', '2024-01-12 21:49:23'),
(132, '2-2', 2, 2, 'Driver', 'Customer', 'uu', 1, 'Text', '2024-01-12 21:49:27', '2024-01-12 21:49:27'),
(133, '2-2', 2, 2, 'Customer', 'Driver', 'jxudur', 1, 'Text', '2024-01-12 21:49:30', '2024-01-12 21:49:30'),
(134, '2-2', 2, 2, 'Driver', 'Customer', 'xhu', 1, 'Text', '2024-01-12 21:49:31', '2024-01-12 21:49:31'),
(135, '2-2', 2, 2, 'Customer', 'Driver', 'itit', 1, 'Text', '2024-01-12 21:49:32', '2024-01-12 21:49:32'),
(136, '2-2', 2, 2, 'Customer', 'Driver', '8r8t', 1, 'Text', '2024-01-12 21:49:33', '2024-01-12 21:49:33'),
(137, '2-2', 2, 2, 'Customer', 'Driver', 'fg', 1, 'Text', '2024-01-12 21:49:41', '2024-01-12 21:49:41'),
(138, '2-2', 2, 2, 'Customer', 'Driver', 'fy', 1, 'Text', '2024-01-12 21:49:45', '2024-01-12 21:49:45'),
(139, '2-2', 2, 2, 'Driver', 'Customer', 'ghhh', 1, 'Text', '2024-01-12 21:49:48', '2024-01-12 21:49:48'),
(140, '2-2', 2, 2, 'Driver', 'Customer', 'cc', 1, 'Text', '2024-01-12 21:49:50', '2024-01-12 21:49:50'),
(141, '2-2', 2, 2, 'Driver', 'Customer', 'giivug', 1, 'Text', '2024-01-12 14:50:33', '2024-01-12 21:50:21'),
(142, '2-2', 2, 2, 'Driver', 'Customer', 'ffi', 1, 'Text', '2024-01-12 14:50:33', '2024-01-12 21:50:25'),
(143, '2-2', 2, 2, 'Driver', 'Customer', 'hchc', 1, 'Text', '2024-01-12 14:50:33', '2024-01-12 21:50:27'),
(144, '2-2', 2, 2, 'Customer', 'Driver', 'fkjf', 1, 'Text', '2024-01-12 21:50:38', '2024-01-12 21:50:38'),
(145, '2-2', 2, 2, 'Driver', 'Customer', 'hxuffu', 1, 'Text', '2024-01-12 14:51:26', '2024-01-12 21:50:40'),
(146, '2-2', 2, 2, 'Driver', 'Customer', 'xhh', 1, 'Text', '2024-01-12 14:51:26', '2024-01-12 21:50:53'),
(147, '2-2', 2, 2, 'Driver', 'Customer', 'hchd', 1, 'Text', '2024-01-12 14:51:26', '2024-01-12 21:50:54'),
(148, '2-2', 2, 2, 'Driver', 'Customer', 'ycuf', 1, 'Text', '2024-01-12 14:51:26', '2024-01-12 21:51:23'),
(149, '2-2', 2, 2, 'Customer', 'Driver', 'jcjfif', 1, 'Text', '2024-01-12 21:51:32', '2024-01-12 21:51:32'),
(150, '2-2', 2, 2, 'Driver', 'Customer', 'juc', 1, 'Text', '2024-01-12 21:51:53', '2024-01-12 21:51:53'),
(151, '2-2', 2, 2, 'Driver', 'Customer', 'y', 1, 'Text', '2024-01-12 21:51:56', '2024-01-12 21:51:56'),
(152, '2-2', 2, 2, 'Driver', 'Customer', 'ufuf', 1, 'Text', '2024-01-12 21:51:58', '2024-01-12 21:51:58'),
(153, '2-2', 2, 2, 'Driver', 'Customer', 'icu', 1, 'Text', '2024-01-12 14:52:17', '2024-01-12 21:52:16'),
(154, '2-2', 2, 2, 'Customer', 'Driver', 'jfudyd', 1, 'Text', '2024-01-12 21:52:25', '2024-01-12 21:52:25'),
(155, '2-2', 2, 2, 'Customer', 'Driver', 'usus', 1, 'Text', '2024-01-12 21:52:26', '2024-01-12 21:52:26'),
(156, '2-2', 2, 2, 'Customer', 'Driver', 'hdud', 1, 'Text', '2024-01-12 21:52:28', '2024-01-12 21:52:28'),
(157, '2-2', 2, 2, 'Customer', 'Driver', 'jfhfhd', 1, 'Text', '2024-01-12 14:53:10', '2024-01-12 21:53:06'),
(158, '2-2', 2, 2, 'Driver', 'Customer', 'hcuc', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:14'),
(159, '2-2', 2, 2, 'Driver', 'Customer', 'ih', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:16'),
(160, '2-2', 2, 2, 'Driver', 'Customer', 'jfuf', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:19'),
(161, '2-2', 2, 2, 'Driver', 'Customer', 'jc', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:20'),
(162, '2-2', 2, 2, 'Driver', 'Customer', 'hcfu', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:29'),
(163, '2-2', 2, 2, 'Driver', 'Customer', 'hdhd', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:30'),
(164, '2-2', 2, 2, 'Driver', 'Customer', 'hchc', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:31'),
(165, '2-2', 2, 2, 'Driver', 'Customer', 'yygg', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:33'),
(166, '2-2', 2, 2, 'Driver', 'Customer', 'huu', 1, 'Text', '2024-01-12 14:53:37', '2024-01-12 21:53:36'),
(167, '2-2', 2, 2, 'Driver', 'Customer', 'jx', 1, 'Text', '2024-01-12 21:53:39', '2024-01-12 21:53:39'),
(168, '2-2', 2, 2, 'Driver', 'Customer', 'uf', 1, 'Text', '2024-01-12 21:53:39', '2024-01-12 21:53:39'),
(169, '2-2', 2, 2, 'Customer', 'Driver', 'jfjfuf', 1, 'Text', '2024-01-12 14:58:36', '2024-01-12 21:58:27'),
(170, '2-2', 2, 2, 'Driver', 'Customer', 'yahoo', 1, 'Text', '2024-01-12 15:01:36', '2024-01-12 22:00:54'),
(171, '2-2', 2, 2, 'Driver', 'Customer', 'gh', 1, 'Text', '2024-01-12 15:01:36', '2024-01-12 22:00:58'),
(172, '2-2', 2, 2, 'Driver', 'Customer', 'ggg', 1, 'Text', '2024-01-12 15:01:36', '2024-01-12 22:01:20'),
(173, '2-2', 2, 2, 'Driver', 'Customer', 'yahoo', 1, 'Text', '2024-01-12 15:01:36', '2024-01-12 22:01:23'),
(174, '2-2', 2, 2, 'Customer', 'Driver', 'hii', 1, 'Text', '2024-01-12 22:01:47', '2024-01-12 22:01:47'),
(175, '2-2', 2, 2, 'Customer', 'Driver', 'urt', 1, 'Text', '2024-01-12 22:01:50', '2024-01-12 22:01:50'),
(176, '2-2', 2, 2, 'Customer', 'Driver', 'jy', 1, 'Text', '2024-01-12 15:02:13', '2024-01-12 22:02:03'),
(177, '2-2', 2, 2, 'Customer', 'Driver', 'ggg', 1, 'Text', '2024-01-12 15:02:13', '2024-01-12 22:02:07'),
(178, '2-2', 2, 2, 'Customer', 'Driver', 'ffgt', 1, 'Text', '2024-01-12 15:02:13', '2024-01-12 22:02:09'),
(179, '2-2', 2, 2, 'Customer', 'Driver', 'ggy', 1, 'Text', '2024-01-12 15:02:13', '2024-01-12 22:02:12'),
(180, '2-2', 2, 2, 'Customer', 'Driver', 'jcuv', 1, 'Text', '2024-01-12 15:02:33', '2024-01-12 22:02:23'),
(181, '2-2', 2, 2, 'Customer', 'Driver', 'test', 1, 'Text', '2024-01-12 15:02:33', '2024-01-12 22:02:28'),
(182, '2-2', 2, 2, 'Customer', 'Driver', 'hfhuff', 1, 'Text', '2024-01-12 15:11:46', '2024-01-12 22:11:15'),
(183, '1-5', 1, 5, 'Driver', 'Customer', '15', 1, 'Text', '2024-01-15 07:30:39', '2024-01-15 14:30:37'),
(184, '1-5', 5, 1, 'Customer', 'Driver', 'vy', 1, 'Text', '2024-01-15 14:30:42', '2024-01-15 14:30:42'),
(185, '1-5', 5, 1, 'Customer', 'Driver', 'jv', 1, 'Text', '2024-01-15 07:30:49', '2024-01-15 14:30:46'),
(186, '1-5', 1, 5, 'Driver', 'Customer', '+659+5', 1, 'Text', '2024-01-15 07:39:23', '2024-01-15 14:39:20'),
(187, '1-5', 1, 5, 'Driver', 'Customer', '8888', 1, 'Text', '2024-01-15 07:40:58', '2024-01-15 14:40:29'),
(188, '1-5', 1, 5, 'Driver', 'Customer', '4/8', 1, 'Text', '2024-01-15 08:01:44', '2024-01-15 15:01:41'),
(189, '1-5', 5, 1, 'Customer', 'Driver', 'vj', 1, 'Text', '2024-01-15 15:01:48', '2024-01-15 15:01:48'),
(190, '1-5', 5, 1, 'Customer', 'Driver', 'fu', 1, 'Text', '2024-01-15 09:19:02', '2024-01-15 15:01:52'),
(191, '1-5', 1, 5, 'Driver', 'Customer', '484v4515', 1, 'Text', '2024-01-15 09:19:47', '2024-01-15 16:18:58'),
(192, '1-5', 1, 5, 'Driver', 'Customer', '45', 1, 'Text', '2024-01-15 16:20:02', '2024-01-15 16:20:02'),
(193, '1-5', 1, 5, 'Driver', 'Customer', '5641651', 1, 'Text', '2024-01-15 16:20:13', '2024-01-15 16:20:13'),
(194, '1-5', 1, 5, 'Driver', 'Customer', '471', 1, 'Text', '2024-01-15 16:20:17', '2024-01-15 16:20:17'),
(195, '1-5', 1, 5, 'Driver', 'Customer', '71', 1, 'Text', '2024-01-15 16:20:22', '2024-01-15 16:20:22'),
(196, '1-5', 1, 5, 'Driver', 'Customer', '7', 1, 'Text', '2024-01-15 16:20:24', '2024-01-15 16:20:24'),
(197, '1-5', 1, 5, 'Driver', 'Customer', '588', 1, 'Text', '2024-01-15 09:20:35', '2024-01-15 16:20:30'),
(198, '2-2', 2, 2, 'Driver', 'Customer', 'test', 1, 'Text', '2024-01-15 09:48:39', '2024-01-15 16:48:36'),
(199, '2-2', 2, 2, 'Customer', 'Driver', 'hii', 1, 'Text', '2024-01-15 09:49:04', '2024-01-15 16:48:45'),
(200, '2-2', 2, 2, 'Customer', 'Driver', 'testing', 1, 'Text', '2024-01-15 09:49:04', '2024-01-15 16:48:52'),
(201, '2-2', 2, 2, 'Customer', 'Driver', 'tesr', 1, 'Text', '2024-01-15 09:50:51', '2024-01-15 16:49:59'),
(202, '2-2', 2, 2, 'Customer', 'Driver', 'testing', 1, 'Text', '2024-01-15 09:50:51', '2024-01-15 16:50:09'),
(203, '2-2', 2, 2, 'Customer', 'Driver', 'teee', 1, 'Text', '2024-01-15 09:50:51', '2024-01-15 16:50:12'),
(204, '2-2', 2, 2, 'Customer', 'Driver', 'testing', 1, 'Text', '2024-01-15 09:50:51', '2024-01-15 16:50:19'),
(205, '2-2', 2, 2, 'Customer', 'Driver', 'test', 1, 'Text', '2024-01-15 09:50:51', '2024-01-15 16:50:37'),
(206, '2-2', 2, 2, 'Customer', 'Driver', 'ya', 1, 'Text', '2024-01-15 09:50:51', '2024-01-15 16:50:46'),
(207, '2-2', 2, 2, 'Customer', 'Driver', 'raa', 1, 'Text', '2024-01-15 09:51:13', '2024-01-15 16:51:00'),
(208, '2-2', 2, 2, 'Driver', 'Customer', 'fggg', 1, 'Text', '2024-01-15 16:51:45', '2024-01-15 16:51:45'),
(209, '2-2', 2, 2, 'Driver', 'Customer', 'gggg', 1, 'Text', '2024-01-15 16:51:53', '2024-01-15 16:51:53'),
(210, '2-2', 2, 2, 'Driver', 'Customer', 'fofufu', 1, 'Text', '2024-01-15 09:52:04', '2024-01-15 16:51:57'),
(211, '2-2', 2, 2, 'Driver', 'Customer', 'kfjd', 1, 'Text', '2024-01-15 09:52:04', '2024-01-15 16:51:59'),
(212, '2-2', 2, 2, 'Driver', 'Customer', 'cjfj', 1, 'Text', '2024-01-15 16:52:09', '2024-01-15 16:52:09'),
(213, '2-2', 2, 2, 'Driver', 'Customer', 'fkkk', 1, 'Text', '2024-01-15 09:52:34', '2024-01-15 16:52:15'),
(214, '2-2', 2, 2, 'Customer', 'Driver', 'tesy', 1, 'Text', '2024-01-15 16:52:40', '2024-01-15 16:52:40'),
(215, '2-2', 2, 2, 'Customer', 'Driver', 'ftyu', 1, 'Text', '2024-01-15 16:52:47', '2024-01-15 16:52:47'),
(216, '2-2', 2, 2, 'Customer', 'Driver', 'tyu', 1, 'Text', '2024-01-15 16:52:59', '2024-01-15 16:52:59'),
(217, '2-2', 2, 2, 'Customer', 'Driver', 'gyh', 1, 'Text', '2024-01-15 16:53:03', '2024-01-15 16:53:03'),
(218, '2-2', 2, 2, 'Customer', 'Driver', 'hhh', 1, 'Text', '2024-01-15 09:54:06', '2024-01-15 16:53:16'),
(219, '2-2', 2, 2, 'Customer', 'Driver', 'gggg', 1, 'Text', '2024-01-15 09:54:06', '2024-01-15 16:53:25'),
(220, '2-2', 2, 2, 'Customer', 'Driver', 'ggggy', 1, 'Text', '2024-01-15 09:54:06', '2024-01-15 16:53:30'),
(221, '2-2', 2, 2, 'Driver', 'Customer', 'yyyy', 1, 'Text', '2024-01-15 09:54:06', '2024-01-15 16:53:38'),
(222, '2-2', 2, 2, 'Customer', 'Driver', 'g tc', 1, 'Text', '2024-01-15 09:54:19', '2024-01-15 16:54:10'),
(223, '2-2', 2, 2, 'Customer', 'Driver', '7777', 1, 'Text', '2024-01-15 09:54:19', '2024-01-15 16:54:17'),
(224, '2-2', 2, 2, 'Driver', 'Customer', 'fufufu', 1, 'Text', '2024-01-15 09:56:16', '2024-01-15 16:55:54'),
(225, '1-5', 5, 1, 'Customer', 'Driver', 'hi', 1, 'Text', '2024-01-22 09:38:05', '2024-01-22 14:47:09'),
(226, '1-5', 5, 1, 'Customer', 'Driver', 'gddg', 1, 'Text', '2024-01-22 09:38:05', '2024-01-22 15:01:33'),
(227, '1-5', 5, 1, 'Customer', 'Driver', 'dggd', 1, 'Text', '2024-01-22 09:38:05', '2024-01-22 15:01:43'),
(228, '1-140', 1, 140, 'Driver', 'Customer', '25', 0, 'Text', '2024-01-22 16:30:48', '2024-01-22 16:30:48'),
(229, '1-5', 1, 5, 'Driver', 'Customer', '15', 1, 'Text', '2024-01-22 16:37:56', '2024-01-22 16:37:56'),
(230, '1-5', 5, 1, 'Customer', 'Driver', 'gh', 1, 'Text', '2024-01-22 16:38:02', '2024-01-22 16:38:02'),
(231, '1-5', 5, 1, 'Customer', 'Driver', 'fu', 1, 'Text', '2024-01-22 09:38:28', '2024-01-22 16:38:08'),
(232, '1-5', 1, 5, 'Driver', 'Customer', '51', 1, 'Text', '2024-01-22 10:08:09', '2024-01-22 16:38:17'),
(233, '1-5', 1, 5, 'Driver', 'Customer', '515', 1, 'Text', '2024-01-22 10:08:09', '2024-01-22 16:38:25'),
(234, '1-5', 1, 5, 'Driver', 'Customer', '89', 1, 'Text', '2024-01-22 10:08:09', '2024-01-22 16:38:37'),
(235, '1-5', 1, 5, 'Driver', 'Customer', '50', 1, 'Text', '2024-01-22 10:08:09', '2024-01-22 17:07:59'),
(236, '1-5', 5, 1, 'Customer', 'Driver', 'fugu', 1, 'Text', '2024-01-22 10:08:26', '2024-01-22 17:08:06'),
(237, '1-5', 5, 1, 'Customer', 'Driver', 'vjjv', 1, 'Text', '2024-01-22 10:08:26', '2024-01-22 17:08:22'),
(238, '1-5', 1, 5, 'Driver', 'Customer', '561', 1, 'Text', '2024-01-22 17:08:29', '2024-01-22 17:08:29'),
(239, '1-5', 5, 1, 'Customer', 'Driver', 'ig', 1, 'Text', '2024-01-22 17:08:32', '2024-01-22 17:08:32'),
(240, '1-5', 5, 1, 'Customer', 'Driver', 'gi', 1, 'Text', '2024-01-22 10:11:03', '2024-01-22 17:08:37'),
(241, '1-5', 5, 1, 'Customer', 'Driver', 'vk', 1, 'Text', '2024-01-22 10:51:48', '2024-01-22 17:11:07'),
(242, '1-5', 5, 1, 'Customer', 'Driver', 'uffu', 1, 'Text', '2024-01-22 10:51:48', '2024-01-22 17:11:17'),
(243, '1-5', 1, 5, 'Driver', 'Customer', '4545', 1, 'Text', '2024-01-22 10:51:44', '2024-01-22 17:51:42'),
(244, '1-5', 5, 1, 'Customer', 'Driver', 'dtyf', 1, 'Text', '2024-01-22 10:52:03', '2024-01-22 17:51:53'),
(245, '1-5', 5, 1, 'Customer', 'Driver', 'guvu', 1, 'Text', '2024-01-22 10:52:03', '2024-01-22 17:52:00'),
(246, '1-5', 1, 5, 'Driver', 'Customer', '59', 1, 'Text', '2024-01-23 04:22:05', '2024-01-22 19:37:31'),
(247, '1-5', 1, 5, 'Driver', 'Customer', '515', 1, 'Text', '2024-01-23 08:49:18', '2024-01-23 11:41:13'),
(248, '1-5', 1, 5, 'Driver', 'Customer', '54', 1, 'Text', '2024-01-23 08:49:18', '2024-01-23 15:49:13'),
(249, '1-5', 5, 1, 'Customer', 'Driver', 'hcch', 1, 'Text', '2024-01-23 15:49:21', '2024-01-23 15:49:21'),
(250, '1-5', 5, 1, 'Customer', 'Driver', 'viiv', 1, 'Text', '2024-01-23 09:52:59', '2024-01-23 15:49:26'),
(251, '1-5', 1, 5, 'Driver', 'Customer', '145', 1, 'Text', '2024-01-23 09:52:52', '2024-01-23 16:52:50'),
(252, '1-5', 5, 1, 'Customer', 'Driver', 'giiv', 1, 'Text', '2024-01-23 16:52:56', '2024-01-23 16:52:56'),
(253, '1-5', 1, 5, 'Driver', 'Customer', '45v', 0, 'Text', '2024-01-23 17:44:51', '2024-01-23 17:44:51');

-- --------------------------------------------------------

--
-- Table structure for table `vehicle_categories`
--

CREATE TABLE `vehicle_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_km` double(8,2) NOT NULL DEFAULT '0.00',
  `price_min` double(8,2) NOT NULL,
  `tech_fee` double(8,2) NOT NULL DEFAULT '0.00',
  `base_fare` double(8,2) NOT NULL DEFAULT '0.00',
  `distance` int(11) NOT NULL DEFAULT '0',
  `min_km` double(8,2) NOT NULL DEFAULT '0.00',
  `min_price` double(8,2) NOT NULL DEFAULT '0.00',
  `extra_km` int(11) NOT NULL DEFAULT '0',
  `seat` varchar(11) COLLATE utf8mb4_unicode_ci DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vehicle_categories`
--

INSERT INTO `vehicle_categories` (`id`, `category`, `price_km`, `price_min`, `tech_fee`, `base_fare`, `distance`, `min_km`, `min_price`, `extra_km`, `seat`, `created_at`, `updated_at`, `deleted_at`) VALUES
(1, 'Economy', 1.30, 0.30, 3.00, 1.70, 10, 3.90, 5.00, 0, '4', '2023-06-23 14:41:06', '2023-06-23 14:41:06', NULL),
(2, 'XL', 1.65, 0.35, 3.00, 2.00, 64, 6.10, 10.00, 0, '4-6', '2023-06-23 14:41:06', '2023-06-23 14:41:06', NULL),
(3, 'Tesla', 1.65, 0.35, 3.00, 2.00, 1000, 6.10, 10.00, 0, '4', '2023-06-23 14:41:06', '2023-06-23 14:41:06', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `abouts`
--
ALTER TABLE `abouts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `ChatRoomTb`
--
ALTER TABLE `ChatRoomTb`
  ADD PRIMARY KEY (`ID`);

--
-- Indexes for table `contact_us`
--
ALTER TABLE `contact_us`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `driver_bank_details`
--
ALTER TABLE `driver_bank_details`
  ADD PRIMARY KEY (`id`),
  ADD KEY `driver_bank_details_driver_id_foreign` (`driver_id`);

--
-- Indexes for table `external_accounts`
--
ALTER TABLE `external_accounts`
  ADD PRIMARY KEY (`id`),
  ADD KEY `external_accounts_driver_id_foreign` (`driver_id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`),
  ADD KEY `orders_driver_id_foreign` (`driver_id`),
  ADD KEY `orders_customer_id_foreign` (`customer_id`),
  ADD KEY `orders_vehicle_category_id_foreign` (`vehicle_category_id`);

--
-- Indexes for table `order_history`
--
ALTER TABLE `order_history`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_reject`
--
ALTER TABLE `order_reject`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_reject_driver_id_foreign` (`driver_id`),
  ADD KEY `order_reject_order_id_foreign` (`order_id`);

--
-- Indexes for table `order_settings`
--
ALTER TABLE `order_settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_driver_id_foreign` (`driver_id`),
  ADD KEY `payments_order_id_foreign` (`order_id`);

--
-- Indexes for table `rating`
--
ALTER TABLE `rating`
  ADD PRIMARY KEY (`id`),
  ADD KEY `rating_order_id_foreign` (`order_id`);

--
-- Indexes for table `reasons`
--
ALTER TABLE `reasons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `user_chat`
--
ALTER TABLE `user_chat`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `vehicle_categories`
--
ALTER TABLE `vehicle_categories`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `abouts`
--
ALTER TABLE `abouts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `ChatRoomTb`
--
ALTER TABLE `ChatRoomTb`
  MODIFY `ID` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `driver_bank_details`
--
ALTER TABLE `driver_bank_details`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `external_accounts`
--
ALTER TABLE `external_accounts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=220;

--
-- AUTO_INCREMENT for table `order_history`
--
ALTER TABLE `order_history`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `order_reject`
--
ALTER TABLE `order_reject`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `order_settings`
--
ALTER TABLE `order_settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `rating`
--
ALTER TABLE `rating`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `reasons`
--
ALTER TABLE `reasons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `user_chat`
--
ALTER TABLE `user_chat`
  MODIFY `id` bigint(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=254;

--
-- AUTO_INCREMENT for table `vehicle_categories`
--
ALTER TABLE `vehicle_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- Constraints for table `driver_bank_details`
--
ALTER TABLE `driver_bank_details`
  ADD CONSTRAINT `driver_bank_details_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`);

--
-- Constraints for table `external_accounts`
--
ALTER TABLE `external_accounts`
  ADD CONSTRAINT `external_accounts_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`);

--
-- Constraints for table `orders`
--
ALTER TABLE `orders`
  ADD CONSTRAINT `orders_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`),
  ADD CONSTRAINT `orders_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`),
  ADD CONSTRAINT `orders_vehicle_category_id_foreign` FOREIGN KEY (`vehicle_category_id`) REFERENCES `vehicle_categories` (`id`);

--
-- Constraints for table `order_reject`
--
ALTER TABLE `order_reject`
  ADD CONSTRAINT `order_reject_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  ADD CONSTRAINT `order_reject_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `drivers` (`id`),
  ADD CONSTRAINT `payments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`);

--
-- Constraints for table `rating`
--
ALTER TABLE `rating`
  ADD CONSTRAINT `rating_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
COMMIT;

