--
-- Host: localhost    Database: go_glide
-- ------------------------------------------------------


--
-- Table structure for table `adonis_schema`
--

CREATE TABLE `adonis_schema` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `batch` int NOT NULL,
  `migration_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `adonis_schema`
--

INSERT INTO `adonis_schema` VALUES (57,'database/migrations/1707383527659_create_user_groups_table',1,'2025-04-29 10:30:21'),(58,'database/migrations/1707383554411_create_users_table',1,'2025-04-29 10:30:21'),(59,'database/migrations/1707386682353_create_user_api_tokens_table',1,'2025-04-29 10:30:22'),(60,'database/migrations/1707386724520_create_user_reset_passwords_table',1,'2025-04-29 10:30:22'),(61,'database/migrations/1707386764916_create_media_table',1,'2025-04-29 10:30:22'),(62,'database/migrations/1707386911174_create_notifications_table',1,'2025-04-29 10:30:22'),(63,'database/migrations/1707386921249_create_notification_settings_table',1,'2025-04-29 10:30:22'),(64,'database/migrations/1707387148824_create_user_device_tokens_table',1,'2025-04-29 10:30:22'),(65,'database/migrations/1715749860153_create_cms_modules_table',1,'2025-04-29 10:30:22'),(66,'database/migrations/1715749948547_create_application_settings_table',1,'2025-04-29 10:30:22'),(67,'database/migrations/1715750022416_create_content_managements_table',1,'2025-04-29 10:30:22'),(68,'database/migrations/1715937724497_create_faqs_table',1,'2025-04-29 10:30:22'),(69,'database/migrations/1740723861013_create_vehicle_categories_table',1,'2025-04-29 10:30:23'),(70,'database/migrations/1740724938845_create_vehicle_colors_table',1,'2025-04-29 10:30:23'),(71,'database/migrations/1740724938846_create_vehicle_makes_table',1,'2025-04-29 10:30:23'),(72,'database/migrations/1740724938847_create_vehicle_models_table',1,'2025-04-29 10:30:23'),(73,'database/migrations/1740724938848_create_user_vehicles_table',1,'2025-04-29 10:30:24'),(74,'database/migrations/1741001457628_create_create_bookings_table',1,'2025-04-29 10:30:24'),(75,'database/migrations/1741001457629_create_reasons_table',1,'2025-04-29 10:30:24'),(76,'database/migrations/1741001457630_create_disputes_table',1,'2025-04-29 10:30:25'),(77,'database/migrations/1741074783862_create_reviews_table',1,'2025-04-29 10:30:25'),(78,'database/migrations/1741084705892_create_user_drivering_details_table',1,'2025-04-29 10:30:26'),(79,'database/migrations/1741091957189_create_contactus_table',1,'2025-04-29 10:30:26'),(80,'database/migrations/1741092595829_create_chat_rooms_table',1,'2025-04-29 10:30:26'),(81,'database/migrations/1741092649802_create_chat_messages_table',1,'2025-04-29 10:30:27'),(82,'database/migrations/1741092661357_create_chat_message_statuses_table',1,'2025-04-29 10:30:27'),(83,'database/migrations/1741092682329_create_chat_room_users_table',1,'2025-04-29 10:30:28'),(84,'database/migrations/1745567105599_create_user_transactions_table',1,'2025-04-29 10:30:28');

--
-- Table structure for table `adonis_schema_versions`
--

CREATE TABLE `adonis_schema_versions` (
  `version` int unsigned NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `adonis_schema_versions`
--

INSERT INTO `adonis_schema_versions` VALUES (2);

--
-- Table structure for table `application_settings`
--

CREATE TABLE `application_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `identifier` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_key` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` text COLLATE utf8mb4_unicode_ci,
  `is_file` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `application_settings_identifier_index` (`identifier`),
  KEY `application_settings_meta_key_index` (`meta_key`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `application_settings`
--

INSERT INTO `application_settings` VALUES (1,'application_setting','favicon','/images/favicon.png','1','2025-04-29 05:30:28',NULL,NULL),(2,'application_setting','logo','/images/logo.jpg','1','2025-04-29 05:30:28',NULL,NULL),(3,'application_setting','application_name','RetroCube','0','2025-04-29 05:30:28',NULL,NULL);

--
-- Table structure for table `bookings`
--

CREATE TABLE `bookings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicle_category_id` int unsigned DEFAULT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `driver_id` int unsigned DEFAULT NULL,
  `stripe_charge_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fare` decimal(11,2) DEFAULT '0.00',
  `waiting_charge` decimal(11,2) DEFAULT '0.00',
  `discount` decimal(11,2) DEFAULT '0.00',
  `pickup_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pickup_latitude` decimal(10,6) NOT NULL,
  `pickup_longitude` decimal(10,6) NOT NULL,
  `drop_off_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `drop_off_latitude` decimal(10,6) NOT NULL,
  `drop_off_longitude` decimal(10,6) NOT NULL,
  `booking_arrived_at` timestamp NULL DEFAULT NULL,
  `booking_started_at` timestamp NULL DEFAULT NULL,
  `booking_completed_at` timestamp NULL DEFAULT NULL,
  `booking_note` text COLLATE utf8mb4_unicode_ci,
  `cancel_reason` text COLLATE utf8mb4_unicode_ci,
  `booking_type` enum('instant','scheduled') COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_user_review` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_driver_review` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `scheduled_time` timestamp NULL DEFAULT NULL,
  `status` enum('initiate','accepted','rejected','arrived','started','completed','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT 'initiate',
  `payment_status` enum('pending','paid','failed') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `bookings_slug_unique` (`slug`),
  KEY `bookings_driver_id_foreign` (`driver_id`),
  KEY `bookings_created_by_index` (`created_by`),
  KEY `bookings_vehicle_category_id_index` (`vehicle_category_id`),
  KEY `bookings_status_index` (`status`),
  KEY `bookings_payment_status_index` (`payment_status`),
  KEY `bookings_is_user_review_index` (`is_user_review`),
  KEY `bookings_is_driver_review_index` (`is_driver_review`),
  KEY `bookings_booking_type_index` (`booking_type`),
  KEY `bookings_status_payment_status_index` (`status`,`payment_status`),
  CONSTRAINT `bookings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bookings_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `bookings_vehicle_category_id_foreign` FOREIGN KEY (`vehicle_category_id`) REFERENCES `vehicle_categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `bookings`
--

INSERT INTO `bookings` VALUES (1,'20250429105010071-6e06bee7691116cb',1,3,NULL,NULL,0.00,0.00,0.00,'cliftion 8',40.769647,-73.983816,'cliftion 9',40.762484,-73.989193,NULL,NULL,NULL,NULL,NULL,'instant','0','0','2025-03-17 07:01:00','initiate','pending','2025-04-29 05:50:10','2025-04-29 05:50:10',NULL),(2,'20250429105131162-ffed5da4c2ffa084',1,3,10,NULL,0.00,0.00,0.00,'cliftion 8',40.769647,-73.983816,'cliftion 9',40.762484,-73.989193,NULL,'2025-04-29 05:59:13',NULL,NULL,NULL,'instant','0','0','2025-03-17 07:01:00','accepted','pending','2025-04-29 05:51:31','2025-04-29 05:51:31',NULL),(3,'20250429110444584-c48918193c06c40b',1,3,NULL,NULL,0.00,0.00,0.00,'cliftion 8',40.769647,-73.983816,'cliftion 9',40.762484,-73.989193,NULL,NULL,NULL,NULL,NULL,'instant','0','0','2025-03-17 07:01:00','initiate','pending','2025-04-29 06:04:44','2025-04-29 06:04:44',NULL);

--
-- Table structure for table `chat_message_status`
--

CREATE TABLE `chat_message_status` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `chat_room_id` int unsigned DEFAULT NULL,
  `chat_message_id` int unsigned DEFAULT NULL,
  `is_read` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chat_message_status_user_id_index` (`user_id`),
  KEY `chat_message_status_chat_room_id_index` (`chat_room_id`),
  KEY `chat_message_status_chat_message_id_index` (`chat_message_id`),
  CONSTRAINT `chat_message_status_chat_message_id_foreign` FOREIGN KEY (`chat_message_id`) REFERENCES `chat_messages` (`id`) ON DELETE CASCADE,
  CONSTRAINT `chat_message_status_chat_room_id_foreign` FOREIGN KEY (`chat_room_id`) REFERENCES `chat_rooms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `chat_message_status_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_message_status`
--


--
-- Table structure for table `chat_messages`
--

CREATE TABLE `chat_messages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `chat_room_id` int unsigned DEFAULT NULL,
  `message_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'text',
  `message` text COLLATE utf8mb4_unicode_ci,
  `file_url` text COLLATE utf8mb4_unicode_ci,
  `file_data` text COLLATE utf8mb4_unicode_ci,
  `custom_data` text COLLATE utf8mb4_unicode_ci,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_anonymous` int DEFAULT '0',
  `status` int DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `chat_messages_slug_unique` (`slug`),
  KEY `chat_messages_slug_index` (`slug`),
  KEY `chat_messages_user_id_index` (`user_id`),
  KEY `chat_messages_chat_room_id_index` (`chat_room_id`),
  CONSTRAINT `chat_messages_chat_room_id_foreign` FOREIGN KEY (`chat_room_id`) REFERENCES `chat_rooms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `chat_messages_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_messages`
--


--
-- Table structure for table `chat_room_users`
--

CREATE TABLE `chat_room_users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `chat_room_id` int unsigned DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `ref_module_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'bookings',
  `ref_module_id` int DEFAULT '0',
  `last_chat_message_id` int DEFAULT '0',
  `last_message_timestamp` datetime DEFAULT NULL,
  `unread_message_counts` int DEFAULT '0',
  `is_anonymous` int DEFAULT '0',
  `status` int DEFAULT '1',
  `is_owner` int DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `chat_room_users_chat_room_id_index` (`chat_room_id`),
  KEY `chat_room_users_user_id_index` (`user_id`),
  CONSTRAINT `chat_room_users_chat_room_id_foreign` FOREIGN KEY (`chat_room_id`) REFERENCES `chat_rooms` (`id`) ON DELETE CASCADE,
  CONSTRAINT `chat_room_users_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_room_users`
--


--
-- Table structure for table `chat_rooms`
--

CREATE TABLE `chat_rooms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int unsigned DEFAULT NULL,
  `ref_module_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'bookings',
  `ref_module_id` int DEFAULT '0',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT 'comments',
  `image_url` text COLLATE utf8mb4_unicode_ci,
  `description` text COLLATE utf8mb4_unicode_ci,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `member_limit` int DEFAULT '1',
  `is_anonymous` int DEFAULT '0',
  `status` int DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `chat_rooms_slug_unique` (`slug`),
  KEY `chat_rooms_slug_index` (`slug`),
  KEY `chat_rooms_created_by_index` (`created_by`),
  KEY `chat_rooms_ref_module_id_index` (`ref_module_id`),
  CONSTRAINT `chat_rooms_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `chat_rooms`
--


--
-- Table structure for table `cms_modules`
--

CREATE TABLE `cms_modules` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int DEFAULT '0',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `route_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `sort_order` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cms_modules`
--

INSERT INTO `cms_modules` VALUES (1,0,'Cms Roles Management','cms-roles-management.index','fa fa-key','0',1.00,'2025-04-29 05:30:28',NULL,NULL),(2,0,'Cms Users Management','cms-users-management.index','fa fa-users','0',2.00,'2025-04-29 05:30:28',NULL,NULL),(3,0,'Application Setting','admin.application-setting','fa fa-cog','1',3.00,'2025-04-29 05:30:28',NULL,NULL),(4,0,'Users Management','app_users.index','fa fa-users','1',4.00,'2025-04-29 05:30:28',NULL,NULL),(5,0,'Content Management','content_management.index','fa fa-tasks','1',5.00,'2025-04-29 05:30:28',NULL,NULL),(6,0,'FAQ\'s','faq.index','fa fa-question-circle-o','1',6.00,'2025-04-29 05:30:28',NULL,NULL);

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

CREATE TABLE `contact_us` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `contact_us_slug_unique` (`slug`),
  KEY `contact_us_slug_index` (`slug`),
  KEY `contact_us_user_id_index` (`user_id`),
  KEY `contact_us_email_index` (`email`),
  CONSTRAINT `contact_us_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contact_us`
--


--
-- Table structure for table `content_managements`
--

CREATE TABLE `content_managements` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text COLLATE utf8mb4_unicode_ci,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `content_managements_slug_unique` (`slug`),
  KEY `content_managements_slug_index` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `content_managements`
--

INSERT INTO `content_managements` VALUES (1,'About US','about-us','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','1','2025-04-29 05:30:28',NULL,NULL),(2,'Privacy Policy','privacy-policy','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','1','2025-04-29 05:30:28',NULL,NULL),(3,'Terms & Conditions','terms-conditions','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','1','2025-04-29 05:30:28',NULL,NULL);

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

CREATE TABLE `disputes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `booking_id` int unsigned NOT NULL,
  `user_id` int unsigned NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `image` text COLLATE utf8mb4_unicode_ci,
  `status` enum('pending','closed') COLLATE utf8mb4_unicode_ci DEFAULT 'pending',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `disputes_slug_unique` (`slug`),
  KEY `disputes_title_index` (`title`),
  KEY `disputes_booking_id_index` (`booking_id`),
  KEY `disputes_user_id_index` (`user_id`),
  KEY `disputes_status_index` (`status`),
  CONSTRAINT `disputes_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE,
  CONSTRAINT `disputes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `faqs`
--

CREATE TABLE `faqs` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `question` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `answer` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `faqs_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `faqs`
--

INSERT INTO `faqs` VALUES (1,'20250429103028981-8a053e16a4813e86','Why choose us?','Go Glide connects you with professional drivers in real time, ensuring you get a ride exactly when you need it. No more long waits or unexpected delays. Enjoy fast, reliable, and hassle-free taxi services, anytime, anywhere!','2025-04-29 05:30:28',NULL,NULL),(2,'20250429103028981-c4a28c2f1e530e0f','How do I book a ride with Go Glide?','To book a ride with Go Glide, simply open the app, enter your pickup and drop-off locations, choose the type of ride you prefer, and hit \'Book\'. A professional driver will be assigned to you instantly, and you\'ll be notified when they arrive.','2025-04-29 05:30:28',NULL,NULL),(3,'20250429103028981-9cab69faa1cb6111','What types of vehicles are available on Go Glide?','Go Glide offers a variety of vehicle types to meet your needs. Whether you\'re looking for a quick ride in an economy car, a premium ride in a luxury vehicle, or even a larger ride for groups, we have you covered. You can select the vehicle type based on your preference during the booking process.','2025-04-29 05:30:28',NULL,NULL);

--
-- Table structure for table `media`
--

CREATE TABLE `media` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `module` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` bigint NOT NULL,
  `filename` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `original_name` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_url` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `file_url_blur` varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `thumbnail_url` text COLLATE utf8mb4_unicode_ci,
  `mime_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file_type` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `driver` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'local',
  `media_type` enum('public','private') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'public',
  `meta` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `media_module_module_id_index` (`module`,`module_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media`
--


--
-- Table structure for table `notification_settings`
--

CREATE TABLE `notification_settings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `meta_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_value` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_settings_user_id_foreign` (`user_id`),
  CONSTRAINT `notification_settings_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification_settings`
--


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

CREATE TABLE `notifications` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `actor_id` int unsigned DEFAULT NULL,
  `target_id` int unsigned DEFAULT NULL,
  `module` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` bigint NOT NULL,
  `module_slug` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference_module` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reference_module_id` bigint DEFAULT NULL,
  `reference_module_slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_read` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_view` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `notifications_actor_id_foreign` (`actor_id`),
  KEY `notifications_target_id_foreign` (`target_id`),
  CONSTRAINT `notifications_actor_id_foreign` FOREIGN KEY (`actor_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `notifications_target_id_foreign` FOREIGN KEY (`target_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


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

CREATE TABLE `reasons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `reasons_slug_unique` (`slug`),
  KEY `reasons_status_index` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `reasons` VALUES (1,'20250429103028975-2437fb17c90f4b31',NULL,'Long Wait','active','2025-04-29 05:30:28',NULL,NULL),(2,'20250429103028975-57add59216c1a22f',NULL,'I changed my mind','active','2025-04-29 05:30:28',NULL,NULL),(3,'20250429103028975-e0161dad2e738e33',NULL,'Driver asked to cancel','active','2025-04-29 05:30:28',NULL,NULL),(4,'20250429103028975-69006d3d1a96f6f5',NULL,'Driver asked to extra pay','active','2025-04-29 05:30:28',NULL,NULL),(5,'20250429103028975-0f0b487a1c50280a',NULL,'Driver rating','active','2025-04-29 05:30:28',NULL,NULL),(6,'20250429103028975-0517707e4a05dcf0',NULL,'Unhappy with car','active','2025-04-29 05:30:28',NULL,NULL),(7,'20250429103028975-3a5327fc068f59ed',NULL,'More','active','2025-04-29 05:30:28',NULL,NULL);

--
-- Table structure for table `user_api_tokens`
--

CREATE TABLE `user_api_tokens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `user_group_id` int unsigned DEFAULT NULL,
  `api_token` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `refresh_token` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `platform_type` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'custom',
  `platform_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_api_tokens_user_id_index` (`user_id`),
  KEY `user_api_tokens_user_group_id_index` (`user_group_id`),
  CONSTRAINT `user_api_tokens_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_api_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_api_tokens`
--

INSERT INTO `user_api_tokens` VALUES (1,3,NULL,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjozLCJuYW1lIjoiSmFpbWUgSGVzc2VsIiwic2x1ZyI6IkthcmlhbmU3OSIsImVtYWlsIjoiVmVyb25pY2EzMUBnbWFpbC5jb20iLCJtb2JpbGVObyI6IisxNTMzMTY1NjM1NCIsImltYWdlVXJsIjoiaHR0cHM6Ly9hdmF0YXJzLmdpdGh1YnVzZXJjb250ZW50LmNvbS91LzUwNjU2OTk4IiwiaWF0IjoxNzQ1OTIzMzc2fQ.7SzWC9CsQR6CL4gqGFrbRyNPM6zBLzx3jJISE_QEvPA','ebevH9j1Chr3pBpqfC5yjQ.TUt0VHZuZ3VhbVFRZVdKTw.h7pnxU4CADJBpUrTPAKbrhgR005XxZwf5KasnyYBKM4','custom',NULL,'2025-04-29 05:42:56','2025-04-29 05:42:56',NULL),(2,10,NULL,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjoxMCwibmFtZSI6IkpvZXkgS2VtbWVyIiwic2x1ZyI6IkdhZ2U4IiwiZW1haWwiOiJWYW5lc3NhX1dpbGxpYW1zb25AaG90bWFpbC5jb20iLCJtb2JpbGVObyI6IisxMDk1ODAwMDQwOSIsImltYWdlVXJsIjoiaHR0cHM6Ly9hdmF0YXJzLmdpdGh1YnVzZXJjb250ZW50LmNvbS91LzU0NTE1MjA4IiwiaWF0IjoxNzQ1OTIzODQwfQ.yeE7FsA6Ke86bbIStQ0HPmw2bf_ltPYop3jcxg-lVG0','XPWYHRDjFAzncH1PaHsf5g.UEZBYXp1N1BJQ2thcy1VdQ.VLzKwZaRX65jzwiHd-X4Ra-1NqcicwCzRBCSodqA1rc','custom',NULL,'2025-04-29 05:50:40','2025-04-29 05:50:40',NULL);

--
-- Table structure for table `user_device_tokens`
--

CREATE TABLE `user_device_tokens` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `device_type` enum('android','ios','web') COLLATE utf8mb4_unicode_ci NOT NULL,
  `device_token` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_device_tokens_user_id_foreign` (`user_id`),
  CONSTRAINT `user_device_tokens_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_device_tokens`
--

INSERT INTO `user_device_tokens` VALUES (1,3,'ios','fe8Ntj8hHU7En--kCOGEoX:APA91bF6ecffhtETh-qPHM0g8N2AYbGoAB-GyI7Fzqyqt597sByevGd9RA9dpHW8UAczfzEpz1qDNIho9oDpzDO8lnaVttvz4UZuvqswht4lMLHg2wJ-_VvWChybi-otWwWF2viHUxTI','2025-04-29 05:42:56','2025-04-29 05:42:56',NULL),(2,10,'ios','fe8Ntj8hHU7En--kCOGEoX:APA91bF6ecffhtETh-qPHM0g8N2AYbGoAB-GyI7Fzqyqt597sByevGd9RA9dpHW8UAczfzEpz1qDNIho9oDpzDO8lnaVttvz4UZuvqswht4lMLHg2wJ-_VvWChybi-otWwWF2viHUxTI','2025-04-29 05:50:40','2025-04-29 05:50:40',NULL);

--
-- Table structure for table `user_driver_details`
--

CREATE TABLE `user_driver_details` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `zip` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_front_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_back_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_front_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_back_image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_driver_details_slug_unique` (`slug`),
  KEY `user_driver_details_user_id_foreign` (`user_id`),
  KEY `user_driver_details_city_index` (`city`),
  KEY `user_driver_details_state_index` (`state`),
  KEY `user_driver_details_country_index` (`country`),
  KEY `user_driver_details_zip_index` (`zip`),
  CONSTRAINT `user_driver_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_driver_details`
--


--
-- Table structure for table `user_groups`
--

CREATE TABLE `user_groups` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_super_admin` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_groups_slug_unique` (`slug`),
  KEY `user_groups_title_index` (`title`),
  KEY `user_groups_slug_index` (`slug`),
  KEY `user_groups_is_super_admin_index` (`is_super_admin`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_groups`
--

INSERT INTO `user_groups` VALUES (1,'Super Admin','super_admin','1','2025-04-29 05:30:28',NULL,NULL),(2,'Admin','admin','0','2025-04-29 05:30:28',NULL,NULL),(3,'Driver','driver','0','2025-04-29 05:30:28',NULL,NULL),(4,'Passenger','passenger','0','2025-04-29 05:30:28',NULL,NULL);

--
-- Table structure for table `user_reset_passwords`
--

CREATE TABLE `user_reset_passwords` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_reset_passwords`
--


--
-- Table structure for table `user_reviews`
--

CREATE TABLE `user_reviews` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `booking_id` int unsigned NOT NULL,
  `created_by` int unsigned NOT NULL,
  `target_id` int unsigned NOT NULL,
  `rating` int unsigned NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_reviews_slug_unique` (`slug`),
  KEY `user_reviews_booking_id_index` (`booking_id`),
  KEY `user_reviews_created_by_index` (`created_by`),
  KEY `user_reviews_target_id_index` (`target_id`),
  KEY `user_reviews_rating_index` (`rating`),
  CONSTRAINT `user_reviews_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_reviews_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_reviews_target_id_foreign` FOREIGN KEY (`target_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_reviews_chk_1` CHECK ((`rating` between 1 and 5))
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_reviews`
--

INSERT INTO `user_reviews` VALUES (1,'20250429111015382-384675e90e248d51',2,3,10,4,'test','2025-04-29 06:10:15','2025-04-29 06:10:15',NULL),(2,'20250429111229374-9264a1715dff71cf',2,10,3,4,'test','2025-04-29 06:12:29','2025-04-29 06:12:29',NULL);

--
-- Table structure for table `user_transactions`
--

CREATE TABLE `user_transactions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(33) DEFAULT NULL,
  `sender_id` int unsigned DEFAULT NULL,
  `receiver_id` int unsigned DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `charge_id` varchar(255) DEFAULT NULL,
  `module_id` int DEFAULT '0',
  `gateway_transaction_id` varchar(255) DEFAULT NULL,
  `total_charges` decimal(11,2) DEFAULT '0.00',
  `admin_tax` decimal(11,2) DEFAULT '0.00',
  `net_amount` decimal(11,2) DEFAULT '0.00',
  `stripe_fee` decimal(11,2) DEFAULT '0.00',
  `gateway_response` text,
  `gateway` enum('stripe','paypal') DEFAULT 'stripe',
  `is_transfer` enum('1','0') DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_transactions_slug_unique` (`slug`),
  KEY `user_transactions_sender_id_foreign` (`sender_id`),
  KEY `user_transactions_receiver_id_foreign` (`receiver_id`),
  CONSTRAINT `user_transactions_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_transactions_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

--
-- Dumping data for table `user_transactions`
--


--
-- Table structure for table `user_vehicle_details`
--

CREATE TABLE `user_vehicle_details` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `vehicle_category_id` int unsigned DEFAULT NULL,
  `vehicle_make_id` int unsigned DEFAULT NULL,
  `vehicle_model_id` int unsigned DEFAULT NULL,
  `vehicle_color_id` int unsigned DEFAULT NULL,
  `vehicle_version` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vehicle_number` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `vehicle_seat_no` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '4',
  `transmission` enum('automatic','manual') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'automatic',
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_vehicle_details_slug_unique` (`slug`),
  UNIQUE KEY `user_vehicle_details_vehicle_number_unique` (`vehicle_number`),
  KEY `user_vehicle_details_user_id_foreign` (`user_id`),
  KEY `user_vehicle_details_vehicle_category_id_foreign` (`vehicle_category_id`),
  KEY `user_vehicle_details_vehicle_make_id_foreign` (`vehicle_make_id`),
  KEY `user_vehicle_details_vehicle_model_id_foreign` (`vehicle_model_id`),
  KEY `user_vehicle_details_vehicle_color_id_foreign` (`vehicle_color_id`),
  CONSTRAINT `user_vehicle_details_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_vehicle_details_vehicle_category_id_foreign` FOREIGN KEY (`vehicle_category_id`) REFERENCES `vehicle_categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_vehicle_details_vehicle_color_id_foreign` FOREIGN KEY (`vehicle_color_id`) REFERENCES `vehicle_colors` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_vehicle_details_vehicle_make_id_foreign` FOREIGN KEY (`vehicle_make_id`) REFERENCES `vehicle_makes` (`id`) ON DELETE CASCADE,
  CONSTRAINT `user_vehicle_details_vehicle_model_id_foreign` FOREIGN KEY (`vehicle_model_id`) REFERENCES `vehicle_models` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_vehicle_details`
--


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

CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_group_id` int unsigned DEFAULT NULL,
  `user_type` enum('admin','user') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'user',
  `name` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(150) COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile_no` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image_url` text COLLATE utf8mb4_unicode_ci,
  `country` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `latitude` decimal(11,6) DEFAULT '0.000000',
  `longitude` decimal(11,6) DEFAULT '0.000000',
  `is_email_verify` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `email_verify_at` datetime DEFAULT NULL,
  `is_mobile_verify` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `mobile_verify_at` datetime DEFAULT NULL,
  `is_admin_approved` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `rating` decimal(11,2) DEFAULT '0.00',
  `gateway_customer_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gateway_connect_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `total_earning` decimal(11,2) DEFAULT '0.00',
  `wallet` decimal(11,2) DEFAULT '0.00',
  `is_payment_enable` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `is_payout_enable` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `default_source` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('2','1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `online_status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_username_unique` (`username`),
  UNIQUE KEY `users_slug_unique` (`slug`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_mobile_no_unique` (`mobile_no`),
  KEY `users_username_index` (`username`),
  KEY `users_slug_index` (`slug`),
  KEY `users_email_index` (`email`),
  KEY `users_mobile_no_index` (`mobile_no`),
  KEY `users_user_group_id_index` (`user_group_id`),
  KEY `users_status_index` (`status`),
  KEY `users_is_email_verify_index` (`is_email_verify`),
  KEY `users_is_mobile_verify_index` (`is_mobile_verify`),
  CONSTRAINT `users_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` VALUES (1,1,'admin','RetroCube','retrocube','20250429103028816-23b096b4ad5646ea','admin@retrocube.com','$scrypt$n=16384,r=8,p=1$0f2j2JNHByiBqczBhTQKnw$JXw7Qae79BZp0YvCmSWytgyz8FanxSmp/MR4mhF1RUzCLIAx02x4RxP15EA6/so436c2h1DAQZ6ZKJK8C4KfEQ','1-8882051816',NULL,NULL,NULL,NULL,NULL,NULL,0.000000,0.000000,'1','2025-04-29 10:30:28','1','2025-04-29 10:30:28','0',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'1','0','2025-04-29 05:30:28',NULL,NULL),(2,2,'admin','GoGlide','go_glide_admin','20250429103028876-7a5e24444f504c91','admin@goglide.com','$scrypt$n=16384,r=8,p=1$98Gfu+KUbM4jeDZC/F5bNQ$75iPrnQAJmZQZgBr+vOgMjzCgQ3RHxpMEgAX62PtzmEr3PwWdwpdY5sQXj0VxpmT/9NOOaEcnBxgw32L9SQ92w','1-8882051817',NULL,NULL,NULL,NULL,NULL,NULL,0.000000,0.000000,'1','2025-04-29 10:30:28','1','2025-04-29 10:30:28','0',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'1','0','2025-04-29 05:30:28',NULL,NULL),(3,4,'user','Jaime Hessel','Marion_Goodwin','Kariane79','Veronica31@gmail.com','$scrypt$n=16384,r=8,p=1$irxJdbzpodKwuY/sAWo0UA$nW8/fhEn67doF30LXwdAPY7nEk9JwGM19Nwsmsm+bYTgAkPlfIdyXc+ePMJZ40EUbaXZwjNbKowW0K5ZhGncBQ','+15331656354','https://avatars.githubusercontent.com/u/50656998','United Arab Emirates','North Dakota','St. George','86996','643 E South Street',40.681111,-74.038881,'1','2024-07-03 04:56:25','1','2025-02-28 20:35:11','1',0.00,'cus_SDcuSQFwjiZjyo','acct_1RJBeBCxGcBT0UGx',0.00,0.00,'0','0',NULL,'2','1','2024-11-02 16:59:14',NULL,NULL),(4,3,'user','Bertha Hahn','Deion.Muller11','Stuart50','Blanche93@hotmail.com','$scrypt$n=16384,r=8,p=1$TgS2t1o/+RbljVOFJz+BzA$/YHdm6Bd2mG14LCw3tW1ZzKaSYER+ccpbXz+jOy+HiEKyr/Died+uHmoeKbzqJeYJRjxcIFaqQwBuwzLBtbB+w','+18149049120','https://avatars.githubusercontent.com/u/9844933','Guernsey','North Carolina','Nikolausfurt','48698','6595 Harold Port',40.762553,-74.050849,'1','2025-04-16 10:48:08','1','2024-05-20 03:46:08','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-03-31 21:19:00',NULL,NULL),(5,3,'user','Ed Schimmel','Maverick_Corkery','Davin_Marquardt-Bednar56','Coty.Crist@hotmail.com','$scrypt$n=16384,r=8,p=1$ADwmwTkesusnZXVwOJo3Lw$Xip9CRvQB7cT8Fq5C9DE0lGfVTAQKrtOOcLciw0a+eEbKuW5OucbvW8qyhNEO/ZYIbtHp0uO6UQoLYBwcqEJig','+10516966528','https://avatars.githubusercontent.com/u/47583936','Tonga','Alabama','South Coopermouth','48881','2923 Willms Loaf',40.809538,-74.097149,'1','2025-01-02 23:06:04','1','2024-12-31 18:18:53','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-31 12:31:26',NULL,NULL),(6,4,'user','Enrique Beer','Giles_Orn','Chaya.Konopelski','Eino.Kuvalis51@hotmail.com','$scrypt$n=16384,r=8,p=1$JrzaA3MH0ttRA8fuazB1iQ$5NDrVIA05PwO050eCb2Ao9XGKdnci6/us7bHuFWfQSAzWyHeHLWr3uTjpxR+NceqiGdgcBuC9jZFiyfarmfUbA','+11376089385','https://avatars.githubusercontent.com/u/91564647','Dominican Republic','New Mexico','East Candice','84465','32837 Manor Way',40.779875,-73.968802,'1','2024-09-12 18:39:30','1','2025-01-01 04:49:30','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-14 02:16:11',NULL,NULL),(7,3,'user','Caroline Daniel','Eunice.Moen','Donny95','Steve.Kihn@gmail.com','$scrypt$n=16384,r=8,p=1$1t+k2Ar47c7AsJunYkgHMw$94e8N/oNBUuLJtXGH1kQxrHs+60b3O07wIA8eDRbDc0ptgq3Z9jltdoqSFDOyOepLNYXftL5tVK+w3+xoJRjmw','+11449691188','https://avatars.githubusercontent.com/u/8230179','Nepal','Virginia','Port Anneworth','47231-1292','74816 The Coppice',40.796888,-73.914100,'1','2024-06-14 22:35:50','1','2025-04-22 02:14:09','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-04-22 01:22:25',NULL,NULL),(8,4,'user','Christian Barrows','Lawrence0','Doyle20','Chadrick.Waters1@yahoo.com','$scrypt$n=16384,r=8,p=1$Ayi1g9LdmYNF980boq428g$vTtzojs5G7zvvzhWFG0pDDxAdx3ZgfWEytFtUlTgbZ4r2IxuG+Xio04yvNAdMVhiUy/sczskTdrHLv3ZP8JThA','+13239152009','https://avatars.githubusercontent.com/u/87368018','Norway','Florida','Ariannaborough','48485','46015 Ledner Key',40.741842,-74.013447,'1','2024-07-26 01:00:55','1','2024-12-10 11:28:41','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-06-18 05:11:48',NULL,NULL),(9,4,'user','Charlie Wolf','Leilani.Anderson41','Norval20','Jaqueline14@gmail.com','$scrypt$n=16384,r=8,p=1$x8KvSOf36ryT5/0hAkDwFA$axVKWugcYyYZbB9Q2g4k4xqym6YAFj9iAhrjO583+v7BEUmraWybYWVJBmc+1f+mGpGQE6+fWNrlA0bTSAHu0Q','+14423099462','https://avatars.githubusercontent.com/u/34833285','United Kingdom','Nebraska','South Yolanda','63935-0736','78965 Tad Ford',40.646181,-74.010263,'1','2025-04-03 11:25:24','1','2025-02-26 21:39:39','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-11 16:33:04',NULL,NULL),(10,3,'user','Joey Kemmer','Margret.Marquardt78','Gage8','Vanessa_Williamson@hotmail.com','$scrypt$n=16384,r=8,p=1$laR/ygIizIvmo4c5hlDI9g$B1PQl4SoN+0uBX5c6IrnKgV92p4qinHXT7aIlvS8BrTPz303gOJPAwwr9/PRcldS20A26cfoQ0LH9Ns3rB5fcw','+10958000409','https://avatars.githubusercontent.com/u/54515208','Cocos (Keeling) Islands','Delaware','Idaho Falls','60951','73563 Corene Crossing',40.767437,-73.965731,'1','2024-09-25 12:54:42','1','2024-07-05 06:11:34','1',0.00,'cus_SDd2rIwjpaCiZ0','acct_1RJBmKE6KWnNhSEJ',0.00,0.00,'0','0',NULL,'2','1','2024-07-21 00:12:29',NULL,NULL),(11,4,'user','Gordon Gleichner','Maverick41','Xavier.Christiansen94','Ashleigh97@hotmail.com','$scrypt$n=16384,r=8,p=1$M7Rlm9153tnhJcOGD/BkzA$3HDLhWulCIOq8/IrV3j3SdaoxGZmZlxoJgLnMnnysaMFLCNseuhg8lQ0PcO391r5WsrYsSl5MtOuJT8dem/cLw','+17551526186','https://avatars.githubusercontent.com/u/98498723','Timor-Leste','Michigan','New Ericacester','26550-2768','99962 Landen Glen',40.634972,-73.918494,'1','2024-12-12 12:43:31','1','2025-01-02 13:05:18','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-19 01:40:21',NULL,NULL),(12,3,'user','Yvette Becker','Bennie10','Ernestine11','Delmer19@yahoo.com','$scrypt$n=16384,r=8,p=1$zNV0ragGZ7g2iBxVziXH0w$xoHZgL6SUcLMCcdh51iLFeq6RQ5EDB8jsYtMHPZW4Btba6AqLjzArh9BZ54NGG64/mF57tHmpexfNJrQ7bguAw','+13348869622','https://avatars.githubusercontent.com/u/50847833','Montserrat','Nebraska','Hicklefurt','94260-8631','709 Towne Valley',40.650769,-74.078677,'1','2024-06-03 13:19:29','1','2025-02-12 22:21:08','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-20 23:16:35',NULL,NULL),(13,4,'user','Joanna Jerde','Garrick_Watsica26','Leonardo_Welch-Dach','Lucile37@yahoo.com','$scrypt$n=16384,r=8,p=1$B5P+Ot9MB3dbYz74pmVCkA$xcBtBmFCS+NoQ4MYU+Cu5yJCumcZG1rLbP4nc0x2IubHROANVpdmk9PmljTgqPz4GWmx8hZ/AS0FerJOmTgrhg','+14561666061','https://avatars.githubusercontent.com/u/36382320','Kyrgyz Republic','Ohio','Lake Giovanni','52546-0421','134 Abdul Squares',40.676705,-74.000943,'1','2024-07-11 03:26:40','1','2024-09-14 21:37:56','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-17 04:02:45',NULL,NULL),(14,3,'user','Billie Johnston','Thurman74','Loraine.Conn','Lois39@hotmail.com','$scrypt$n=16384,r=8,p=1$2lzhM9pMhAhS2tkA20xJXg$AJBR3jO1uXW89qqsxd+BoBNfqOqIjBjLZX7ZRcqnz1q+RfuiU0fOpL3az7xWHrNGsK29nUaQGifFcQYlbn5ymQ','+12124385772','https://avatars.githubusercontent.com/u/35931454','Gabon','Ohio','Port Kellie','57019-4772','44331 Clarence Street',40.653849,-74.065018,'1','2024-07-15 20:26:49','1','2025-01-30 01:25:13','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-05 20:37:08',NULL,NULL),(15,3,'user','Tami Nolan','May_Hickle','Chance.Ward','Nayeli.Hermann@hotmail.com','$scrypt$n=16384,r=8,p=1$lqHdWd9s4vNeJY2BFObNXQ$wxca+sxAeyP8FhUWwUU7N9q/kaXvVVrF7QQBKmtTXoBdRgecn+2jL85l80E9zXLRsZ9mHEn3iueoY59E0D+g9Q','+17819242451','https://avatars.githubusercontent.com/u/42024138','Mauritania','Missouri','Spokane','67028-0879','21603 Icie Island',40.625236,-74.094447,'1','2025-02-03 20:46:34','1','2025-04-27 04:48:44','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-19 03:07:45',NULL,NULL),(16,3,'user','Geraldine Welch','Anita.Auer60','Nettie_Keeling','Kane_Hammes55@yahoo.com','$scrypt$n=16384,r=8,p=1$8a7l8vbrnHkh8U57P0SEGw$qSOoEr5qfwKX14XSyCCLLBsqlWIqR7TDQr78UC24SKNtk450EkhONy0M+y35n8/p3bfrz4DyzYNgRRdTTLbzgg','+11156511633','https://avatars.githubusercontent.com/u/73229262','Tajikistan','Maryland','Aureliaton','47906-6559','60453 Davis Street',40.651510,-74.017051,'1','2024-11-18 08:35:37','1','2024-05-20 03:42:59','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-11 07:07:34',NULL,NULL),(17,4,'user','Mrs. Essie Schroeder','Vernie.Keebler','Dovie69','Darien_Heidenreich-Parisian62@yahoo.com','$scrypt$n=16384,r=8,p=1$0uEt7drBru9CCFGxeIOfLA$TCzGIkvzWZu9yPEYSN/q/PQe3CsJP8zX7iW5hXOAAO9hgLIAPobecx6TkH2bf9KPGbW9k0XMtZX/co2Yh5CV6w','+17486919218','https://avatars.githubusercontent.com/u/32826274','Martinique','North Carolina','West Camilamouth','15528-7921','43160 Gabrielle Course',40.686699,-73.925030,'1','2024-06-05 08:17:14','1','2024-07-15 09:24:09','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-19 01:02:46',NULL,NULL),(18,4,'user','Everett Rau','Sarah_Greenholt24','Kurtis_Hickle','Jarret_Green-Hamill74@hotmail.com','$scrypt$n=16384,r=8,p=1$ZXJME21oYleeG49m7BuqZg$ZfFYv3fYzdTJU+DC1NtpPD2NVRJDCnlb8tvZ4ikkPax4+6nNzF4loSSQ9mMR1eWhBsJzoFDBtRXQcWss7gJJ9A','+13976532027','https://avatars.githubusercontent.com/u/6236920','Maldives','Rhode Island','North Elfrieda','63315-2998','90366 Schuster Route',40.645644,-73.962634,'1','2024-12-01 00:05:53','1','2024-12-23 21:51:20','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-18 10:44:29',NULL,NULL),(19,4,'user','Dr. Milton Ward','Deshaun.Mohr','Dorothea45','Virgie_Stehr36@hotmail.com','$scrypt$n=16384,r=8,p=1$zLlfwF8o/g8QuVPRjvSoCA$xxKJE1ZTb8jqn+ZiBQ2zbg0WMLbVM/D6u6tHjxObPo+/5SHXMpFJ34Lw8aZRI0+QGS7x7wG3UwZ5icSJhPO6Ww','+16882924630','https://avatars.githubusercontent.com/u/19588661','Uzbekistan','Arkansas','East Nayeliboro','48447','5253 Lyla Loop',40.726271,-74.030404,'1','2024-08-03 08:55:06','1','2024-09-29 20:51:32','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-18 08:10:41',NULL,NULL),(20,4,'user','Arthur Breitenberg','Kaleigh35','Russel_Haley-Krajcik15','Ethan93@gmail.com','$scrypt$n=16384,r=8,p=1$1ZhwKm7DxqsHQRptilyDDQ$GS/d4arxsFmCLZX0GEVos9e3EsTRmnlaWrn1NfFYZvms9XldOk89bfHmZax4psAzaUQG25Y74dBNlxV9oXEn7A','+19380526508','https://avatars.githubusercontent.com/u/66526613','Chile','Illinois','South Reyna','61830-0954','9655 County Road',40.773030,-73.919059,'1','2024-11-12 15:32:25','1','2024-08-23 21:49:08','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-19 07:21:56',NULL,NULL),(21,3,'user','Harvey Paucek','Buck_Hand','Kailey96','Rupert.Kunde@gmail.com','$scrypt$n=16384,r=8,p=1$OeLrwZ3Yc+c1W4YBg+YZ9g$BAFX7DoVNgLW1vwC8Ya9VawN7z/IJGh1eTuNFGtqC1abjceFAoVnVm1TlilQOcUC7CvVouiQ3IfYREOwDlkTKw','+14665775684','https://avatars.githubusercontent.com/u/69308637','Iran','Alaska','Baileyboro','73805','56676 Hattie Shores',40.672551,-74.093851,'1','2024-12-13 07:37:43','1','2025-04-04 16:29:54','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-23 00:23:53',NULL,NULL),(22,4,'user','Delbert Lang','Lue.Gutmann','Abdul67','Fannie.Cruickshank@hotmail.com','$scrypt$n=16384,r=8,p=1$PynAwychl0nAsOOdvgnsSQ$n8fjpVQcoz8t+6lXR8wuZgXUi/iBKw1cYQgwdGyZGJvqAAU7ICPJ+sZWI7IlOw8Nz6P4lq56aEICVgf5R+0gNw','+14180322701','https://avatars.githubusercontent.com/u/90202684','Latvia','Colorado','North Connie','26792','4190 W 6th Avenue',40.785165,-73.925819,'1','2024-09-22 10:24:34','1','2025-02-06 09:08:30','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-26 13:09:59',NULL,NULL),(23,4,'user','Joshua Gorczany','Woodrow_Volkman73','Willie_Runolfsdottir84','Karianne_Kshlerin48@gmail.com','$scrypt$n=16384,r=8,p=1$GChkHUB9FFMRgRaJMR1bEA$b9OSfVzhMzwG5DqjchFrPHEnWYcoJlT/+scEGiDzd3tbk/ijqq/yYdcziLj6rVuOkYZ+cG3EDgwMC0/HbB5ROw','+18969988320','https://avatars.githubusercontent.com/u/63479888','Norfolk Island','Kentucky','Abigailberg','47009-9485','8997 S Main Street',40.669999,-74.073245,'1','2024-09-05 05:36:29','1','2024-11-03 19:12:36','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-03-07 02:25:40',NULL,NULL),(24,3,'user','Matt Jenkins','Madelynn.Bode65','Marina_Abshire','Ellie94@gmail.com','$scrypt$n=16384,r=8,p=1$tyBnihRCjnDPmvGJAPDt8w$02AmFtUFZP36QHBsH9JhlkTJ5PZzsbcs+3HrbrBlqNijohf3BOiUzeHW5rd+vuBYNc49PJ8fPFsJRffFl8Jajw','+15269614321','https://avatars.githubusercontent.com/u/41633364','Estonia','Rhode Island','Lake Eden','41347-2668','29805 Cronin Divide',40.757391,-73.994214,'1','2024-11-25 05:05:49','1','2024-10-18 05:44:39','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-20 20:12:58',NULL,NULL),(25,4,'user','Mr. Mark Ryan','Yessenia84','Esmeralda11','Tyson12@gmail.com','$scrypt$n=16384,r=8,p=1$5dEV2OZzQIJPj5Rx016YLA$OdXdWvX6hkU+bAI+jsLMezZ9eK9ee1ijOcn71x11hU3bM32ENwvHBB82wMoQRVCZMqG518NdvNvGrEC1pK2zsQ','+14597021348','https://avatars.githubusercontent.com/u/26620667','Armenia','Mississippi','Bothell','91965','834 Olson Corner',40.737676,-74.060093,'1','2025-01-10 01:15:50','1','2025-04-19 02:36:02','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-28 03:07:10',NULL,NULL),(26,4,'user','Heather Rohan','Alysha72','Gregoria_Stark','Talia_Botsford-Roob3@yahoo.com','$scrypt$n=16384,r=8,p=1$la+tZRSeFNfhmKQal+3ywA$ggJpMZIWxpwHVkr3AqP5Fg1lkXfSwoV8BUhzMtiiATBnn/1n0xSW5RUUAHE8KMk8301lltZAS3yAh7KrGb1IfA','+19060377163','https://avatars.githubusercontent.com/u/75368537','Wallis and Futuna','Wisconsin','Robertsstad','37773','4569 Reba Point',40.621207,-73.924762,'1','2024-12-23 07:47:38','1','2024-11-15 11:39:44','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-15 08:34:39',NULL,NULL),(27,4,'user','Gayle Lynch','Mathew38','Timmothy_Stark24','Aurelie.Berge75@yahoo.com','$scrypt$n=16384,r=8,p=1$/3H+wFTAZsy/R3CtwFJjMA$SP5ofI3tsb7QtcIgapeKehYPlgnKm/1ShD4otO/CYWD0P3mFMPen46d4845/ENdxBhxsbqbAHZRDe4LFE/iA3A','+18513540208','https://avatars.githubusercontent.com/u/8644115','Pitcairn Islands','Pennsylvania','Lake Kaitlinborough','52827','62408 Krystel Vista',40.727964,-74.073245,'1','2024-06-21 01:40:00','1','2025-03-24 22:33:31','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-20 21:55:44',NULL,NULL),(28,3,'user','Lynda Emmerich','Elza_Mitchell50','Cleta41','Clark_Bartell39@yahoo.com','$scrypt$n=16384,r=8,p=1$rD0CZtMvLTrkW/M51HPUdw$6jeYsWUGmtyWpnnkF/yPI2kEBZEgat8Ot+fchNKPZINtbGBN0DAoJ7qV2Sw9urU15yCJBG/S1WrX68HiuKVtcQ','+10220907990','https://avatars.githubusercontent.com/u/54037645','North Macedonia','Nebraska','Joannyburgh','35809','5229 Kunde Walks',40.648493,-73.957907,'1','2025-02-13 11:04:43','1','2024-05-30 10:40:17','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-04 16:53:25',NULL,NULL),(29,4,'user','Ricardo Price','Carleton44','Hassie_Weissnat','Celestine4@hotmail.com','$scrypt$n=16384,r=8,p=1$sE0LWtjLqvG4cv18JElV6A$j7m8a3emV4Fl2LnlkydcGdaqo8OSp99q0MxdPqkyShnQa2EymZG6X2RbZPoh3zPC0Xn2Q67+y1kePLEF9Xy7aQ','+11496053015','https://avatars.githubusercontent.com/u/41591948','Angola','Georgia','Mission','21657-1582','5667 Mosciski Bypass',40.613523,-74.099969,'1','2024-09-08 05:39:39','1','2024-05-07 05:22:14','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-30 07:12:52',NULL,NULL),(30,3,'user','Anita Schulist','Daphney38','Etha51','Maude_Stracke37@yahoo.com','$scrypt$n=16384,r=8,p=1$LcWJsf9I2dTGSuqMbY2vRg$llViUVsFGAB/7LhU+VdchPXux8ULmyzGU8YtPa5p12ufPD2dJnBCaXn9h2nydHu3A6Hj846npHtjEBlW7HP1qA','+17046843421','https://avatars.githubusercontent.com/u/11670373','Latvia','South Dakota','West Columbus','40618-1936','6763 Old Military Road',40.669388,-73.924216,'1','2024-07-02 22:05:35','1','2024-12-03 15:37:08','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-12 09:21:26',NULL,NULL),(31,4,'user','Nicolas Wolf','Trent.Kuvalis47','Aurelio1','Alessandro30@gmail.com','$scrypt$n=16384,r=8,p=1$SjdJxNmjutXu4KLZVML9Ug$vQ4ZLSm3PLcPBiLpnT+DlS106upBE77vSpK3RHFgzzNlolVwPlAoonFtfOZQKUGPthBvZb4inXHUrq/tj9jHng','+13282121847','https://avatars.githubusercontent.com/u/67334289','Ecuador','Utah','Harmonychester','03373','199 Windermere Road',40.749879,-74.057306,'1','2024-12-02 13:32:07','1','2025-04-03 02:40:12','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-16 09:50:45',NULL,NULL),(32,3,'user','Heidi Reichel','Felipa_Kuvalis','Amani_Luettgen22','Randi_Spencer0@hotmail.com','$scrypt$n=16384,r=8,p=1$uDdGDjWs3CUNFRumu60DRQ$tu9qk7PxmmpY4M2KGcJmK6XZP2xspAZvEvqvCEdVdP9vbjbHZDwjxkztHESinnFR0ehweQkX9UDSxVvEhdjQYw','+13314774615','https://avatars.githubusercontent.com/u/33062527','Democratic Republic of the Congo','Alaska','South Colten','36922','32110 O\'Kon Crescent',40.786103,-74.072431,'1','2025-01-25 22:55:58','1','2024-12-28 18:15:00','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-15 00:58:47',NULL,NULL),(33,3,'user','Raul Kohler','Zackary_Hodkiewicz67','Sienna69','Cielo92@hotmail.com','$scrypt$n=16384,r=8,p=1$edPPrr7FMaMI15J+ymww9Q$kjcTkyPpT/D+Qo7fduFeppT9/md+oyqjTzw+WOSE7sxD1Lkz+ivHI5WG4dSf1qaOCmOyRDfiLJo8AbaWshBvNg','+10275961315','https://avatars.githubusercontent.com/u/20277630','Niger','Idaho','Quigleyshire','65909','249 N Poplar Street',40.763594,-74.021362,'1','2024-09-02 18:15:50','1','2024-08-05 05:34:31','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-04-23 22:34:40',NULL,NULL),(34,4,'user','Gregory Johns','Julio2','Daphnee_Miller71','Helen.Hickle98@gmail.com','$scrypt$n=16384,r=8,p=1$IVxymBlao0z4ii6dnRwbfw$MG5yhWgRJrLl1FTGWnaejK+GnL8AYSr3klclh1uwxJhfAQQQyYkBPkH5w7JHbC1mL6Oe8KZpvlaH60+/mqgWOA','+12859892891','https://avatars.githubusercontent.com/u/58743609','Singapore','Kansas','North Kellyland','81624-1663','8949 Gilda Prairie',40.788407,-73.952203,'1','2024-12-21 01:45:47','1','2024-10-10 13:20:27','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-26 13:12:39',NULL,NULL),(35,3,'user','Delores VonRueden','Ashly56','Brielle17','Kamren.Weimann83@gmail.com','$scrypt$n=16384,r=8,p=1$rscdx/8+UwZNDJrNVPhpLQ$bJ2rt7gWAa9BSVq9gByPZcWk6dgdqp4FcXskFNA151+TZzM/DLyNMedhbYlX/Be8DVvXlB22t/rBedpL/ZKCuQ','+18410170856','https://avatars.githubusercontent.com/u/44529269','Mozambique','Washington','Roswell','04566','68047 Heather Close',40.658117,-73.930774,'1','2024-11-08 00:15:06','1','2024-08-20 15:56:52','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-10 21:34:34',NULL,NULL),(36,4,'user','Nicole Spinka','Annetta23','Callie_Bogisich90','Riley_Morar0@hotmail.com','$scrypt$n=16384,r=8,p=1$SyuQ7UxyKVGiqqShbYbusA$43BlsrcvLrGrvjoSUSV+0ADPiRVHh0HiTPMV49ox7IlZW0L07Qh8+0oBUpqwG2Ol54RzpPRDSTFqVV1yEGYxbQ','+14209401289','https://avatars.githubusercontent.com/u/84050901','Central African Republic','South Carolina','Alessandrashire','82700','21317 Mayer Estates',40.806814,-74.064520,'1','2024-08-09 20:56:27','1','2024-09-05 09:16:13','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-03-21 03:41:03',NULL,NULL),(37,4,'user','Dixie Grimes','Claude_Greenfelder20','Roel68','Rey_Borer82@gmail.com','$scrypt$n=16384,r=8,p=1$liU8BSUTDAHAASwLEq+pLg$BzC3oBzNnmyYiAHeuBusuWiO7+vne1X2wRWDhcoYcZXgc0vq5vGes1UrdY5FhtDLoVVfM2LBIMKvOyqmlGxMxQ','+13114702544','https://avatars.githubusercontent.com/u/19156722','Eswatini','Pennsylvania','Port Cortney','25540','742 Bode Glens',40.733708,-74.030618,'1','2025-02-03 02:58:19','1','2024-04-29 16:17:20','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-27 16:55:01',NULL,NULL),(38,4,'user','Vicky Hammes','Sylvia.Powlowski','Carley_Gislason46','Lucious.Beer@gmail.com','$scrypt$n=16384,r=8,p=1$/in5aO2VB1G81w9JWUP2fw$meIf8wA+nC3uIt/fEWk9Z2M70UPAOwURBCXiweLIaiG+IDVrpAaSHrSric3EadlSW2cdhhizHFzoA3kUh1Cd2w','+14585725606','https://avatars.githubusercontent.com/u/17715696','Belize','Utah','Roycefort','40787-2023','90457 Alexane Summit',40.658586,-73.939248,'1','2025-02-03 06:21:00','1','2024-07-21 18:21:06','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-17 14:40:52',NULL,NULL),(39,3,'user','Cora Davis','Morgan78','Aiyana_Rippin24','Jose.Schultz45@hotmail.com','$scrypt$n=16384,r=8,p=1$jHlKDzRMJXgLJbiJxO0XxA$gq4QPA2m7iW0318TiZZXvzZoQ9QxpPTRtv5ZKAjeyBpTPPMoZJr66qT8xz2c23FR1Cnw23jY6Kqm+2+JRHXjHQ','+18798223341','https://avatars.githubusercontent.com/u/69448581','Cuba','New York','Fort Kelsie','55146-9287','4903 Chad Dam',40.631292,-74.086896,'1','2024-11-11 03:52:28','1','2024-08-01 00:09:20','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-02 18:45:31',NULL,NULL),(40,3,'user','Theresa Watsica','Murl.Parker','Chandler_Raynor','Delphia41@hotmail.com','$scrypt$n=16384,r=8,p=1$Oy2VUtJGPeGv6dHRDSP9dA$QZgy5Dy1mG6605I5014q1qYdIYrO1WgckY8ZH81Qp1a+3daRQyu6buB7VRwI38/WnmaLxaUhp5jOLSsJ1uWAQg','+15141061037','https://avatars.githubusercontent.com/u/51648183','Barbados','Tennessee','Fort Ludie','68141','1889 Berge Haven',40.679451,-74.032458,'1','2024-11-16 07:23:42','1','2024-05-04 03:38:36','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-11 13:38:58',NULL,NULL),(41,4,'user','Cristina Kris V','Larue.Goyette','Karli_Beahan50','Murphy.Hudson@gmail.com','$scrypt$n=16384,r=8,p=1$1JIrrtkz0LDoUfylLuNoeg$lvwb2UWeW4ITmlxY/D0eITfMZr+CQrW9zXr3dv+CWxQBE63zNeVWQ45AdFdqBE9vJE4T3Na+SQQRq7r1stUdsg','+14546212728','https://avatars.githubusercontent.com/u/57065112','Holy See (Vatican City State)','Virginia','North Montybury','24110','727 Bluebell Close',40.727839,-73.940007,'1','2024-08-03 22:42:55','1','2024-08-09 08:14:43','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-04 17:14:57',NULL,NULL),(42,4,'user','Lula Lynch III','Chanelle67','Ruben.McDermott','Peyton_Zulauf52@gmail.com','$scrypt$n=16384,r=8,p=1$7M8LfKtAE583NnAaY2NTFA$z8p+F9B5d+6j55vCyelOZO9QPt0sumi7s4PQ7NDyElEo0JhOJ0helh1o138/EKyZT9MBQTc0Qw8wlUTnEYLmcw','+18137653141','https://avatars.githubusercontent.com/u/63591591','Norway','West Virginia','Ebonyfield','01997-1168','6772 St Andrews Close',40.645142,-74.096837,'1','2024-12-15 10:41:19','1','2024-10-13 10:59:59','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-08-15 20:29:54',NULL,NULL),(43,3,'user','Mr. Myron Hahn','Lyda79','Melyna.Botsford-Zemlak44','Hayden_Funk@yahoo.com','$scrypt$n=16384,r=8,p=1$3eXNnIalQo8OfJZVfBPfpA$85RAFmqFwcG7uu1n9WTTcKSSRe/1F3Id0gEMlXhjkVCPcS94zLf7oLhi7dBoPuTNSziw89IHC66fWWN03HGkHw','+15962252594','https://avatars.githubusercontent.com/u/93334222','Saint Helena','Maine','West Domingocester','18273','3365 Cormier Pass',40.751833,-74.040616,'1','2024-08-29 09:04:47','1','2025-03-13 00:15:20','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-01 22:02:17',NULL,NULL),(44,4,'user','Vickie Reilly','Maud.Mills59','Carmen_Okuneva85','Noble62@yahoo.com','$scrypt$n=16384,r=8,p=1$3U+p3joMOx+UcSHIbrJv7w$3ePk4S8v0wN3gWKk5DP2u1vMZOvWthLXp6ctD6RMFG3l3rQM8V66B7E23YVp8MZLnF1VPr2Nr35Lb+4TCyuPfw','+11479493126','https://avatars.githubusercontent.com/u/13285603','Gabon','Georgia','Pearl City','98052-2989','64334 Mario Mountain',40.759219,-74.005634,'1','2025-01-04 22:11:01','1','2024-12-24 23:54:37','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-11 18:28:43',NULL,NULL),(45,3,'user','Dr. Harvey Kuvalis','Lavon.Kemmer','Lupe27','Rita76@gmail.com','$scrypt$n=16384,r=8,p=1$w9uz95RoHiLA29Y7an5Cwg$kr0wAjr849iik9uTRvrna0Zr+OZTFO5JIykuByduuZHUYwvI7Q4uJvQ4JvSrd4kSmEXNFTFuDkEzIMPJAv3wSg','+16733769617','https://avatars.githubusercontent.com/u/37467070','Togo','Rhode Island','East Preston','08404','573 Harber Land',40.676077,-74.045380,'1','2025-03-02 13:03:08','1','2025-04-06 06:34:06','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-04-04 19:21:48',NULL,NULL),(46,3,'user','Mary Hoppe','Camren_Bruen53','Genesis33','Golda.Volkman@hotmail.com','$scrypt$n=16384,r=8,p=1$gc4ugS0Aa0bgP+4pd87YTg$3Vqjw1rtX1e0B+rmI0a9tHle5sQv+kj5od9eQSjOtb8ocHt5rBdnHx4GjP75mGRaBF32ykIqB+yrGLJaFS7aSA','+19254348008','https://avatars.githubusercontent.com/u/31147668','Northern Mariana Islands','Washington','Kingstad','37551','6721 Alexanne Path',40.618230,-73.981146,'1','2025-04-14 08:44:38','1','2024-08-04 03:46:46','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-31 21:23:02',NULL,NULL),(47,4,'user','Eunice Raynor','Carolyn66','Leola_Nicolas','Jarod_Smith@yahoo.com','$scrypt$n=16384,r=8,p=1$0VMpm/32iTuBFwLuTjMG7w$BDJDpsM1bepC1lRT9vhPMCBs2XJFlRnGeCqjMTQc+YVOWf4Sm+gSySbDsiS4XqHuj10AW9zdzgGhD0pK7Dnqbg','+16899012664','https://avatars.githubusercontent.com/u/86270712','Gabon','Michigan','East Efrainside','39045','4021 Lorenza Plain',40.756971,-73.931918,'1','2025-03-09 18:45:50','1','2024-05-02 15:42:30','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-28 21:02:20',NULL,NULL),(48,3,'user','Ms. Cecelia Friesen','Jayson_Mohr','Broderick_Schamberger','Jacinto7@hotmail.com','$scrypt$n=16384,r=8,p=1$12SUZym6g92gJNpuP05XxQ$ddB7jFTUVwfGUQkWyGbuYQmQG61vIsLb74RIe0N98N/oXC3qscKqVSptNTLNdFYX7o0QfvQKRIrF+qQUyQT/uQ','+16935843155','https://avatars.githubusercontent.com/u/22837002','Cocos (Keeling) Islands','South Dakota','Savannah','33484-5801','5362 Rodriguez Drives',40.654051,-74.082779,'1','2024-12-20 17:24:06','1','2025-03-23 14:49:57','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-11 23:46:48',NULL,NULL),(49,3,'user','Pat Cassin','Paul_Hand','Skye.Beatty83','Maya_Cormier3@gmail.com','$scrypt$n=16384,r=8,p=1$2oJwN/yI2EaQVkQTmLX85A$edGC/gukc6Q/I73LDS3o4rGyVYxoJj0tHHLN5xbV2HntJC0+FQBtTz8BIxKtHoWLdA5g6Dwt9d7VRiKUOkfPQg','+18643546455','https://avatars.githubusercontent.com/u/61816367','Uruguay','New York','Pawtucket','81095-4607','53257 New Street',40.789232,-73.915290,'1','2025-02-20 15:58:26','1','2024-09-12 09:49:02','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-18 14:19:30',NULL,NULL),(50,4,'user','Miss Alberta Kozey','Pasquale56','Terrance.Kertzmann','Brooks77@gmail.com','$scrypt$n=16384,r=8,p=1$zczcgmJR6LvfQ6KO6uVSbQ$L9zjLxOWqoFZU4wL/ep4BvQEgNc4+fwNao8PJCMbQzQkdFz/q9YgRCD4pp4nQrgAKB1SkontmymBflwt2GIv7A','+10352962681','https://avatars.githubusercontent.com/u/69325727','Holy See (Vatican City State)','Washington','East Delta','58709','8170 Highfield Close',40.694910,-74.006354,'1','2025-01-26 17:54:39','1','2025-03-10 12:04:46','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-06-26 18:00:30',NULL,NULL),(51,4,'user','Miss Beatrice Lakin','Elise49','Freeman_Jerde63','Laverne75@hotmail.com','$scrypt$n=16384,r=8,p=1$xTTvxGIa8SB8t0DcY9dZuA$mXU2tCTxSX8zYHeFxysRsAIl4lHhVVac7lB5OT83v3oVZgxAtIVwgwQ7ILRAiEWQPmCveoRna0WfhhUB1blFpw','+11506716871','https://avatars.githubusercontent.com/u/56856262','Cape Verde','Kentucky','North Clintfield','94431-0725','26717 E 3rd Street',40.635527,-74.002116,'1','2024-09-17 12:02:23','1','2024-07-20 14:32:13','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-10 03:04:34',NULL,NULL),(52,4,'user','Eileen Schroeder','Hassie.Stoltenberg','Arvilla72','Leilani_Jakubowski@hotmail.com','$scrypt$n=16384,r=8,p=1$VZBSJnnDT6aGlMNU95zLwQ$65znSjqp3SrIElpUvaQA8SeH13s3JMYlqp2DJtzc1Dbv+5V90kxY7DFbgxdTImH4denf2V4wbZ6DqQw4HSbcVw','+11198951812','https://avatars.githubusercontent.com/u/7757437','Malawi','Connecticut','Koeppview','96421-1414','6203 Woodland Road',40.723249,-74.081610,'1','2024-10-26 14:46:20','1','2024-10-11 02:26:53','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-03 14:17:25',NULL,NULL),(53,4,'user','Frederick Abbott Jr.','Gia.Considine18','Edna10','Madie_Simonis@yahoo.com','$scrypt$n=16384,r=8,p=1$kj4i226Z1b2weaJP/HPL8g$pw5GbSLjmOcqXmmaF8JUOdaZYTm2dbjFUmeSrBig8+VrON7igfcHj1C4G10cMxeJY3wxVx+d7Cd3YaioEVBOqg','+14410118079','https://avatars.githubusercontent.com/u/58856972','Cayman Islands','New Mexico','Lancaster','98564','8097 Asia Wells',40.633746,-74.054178,'1','2024-09-23 19:00:07','1','2024-06-11 16:37:28','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-28 00:34:17',NULL,NULL),(54,3,'user','Pete Mosciski','Elmer39','Myah.Labadie78','Khalid89@gmail.com','$scrypt$n=16384,r=8,p=1$wOP2oIJy+JPxp7SlZnX1Dg$5NhbUXGfdAY5SvN5XPnOjN3/zyGcf0w+3HtoAdwfL0KU8vtodJY9DoDovM18P7XUJ6/njoihR+mhvA7I3qpnLw','+10766301952','https://avatars.githubusercontent.com/u/96963164','Saint Martin','Rhode Island','Caryhaven','65485','718 N Water Street',40.689720,-74.100989,'1','2024-05-20 07:18:07','1','2024-08-20 09:42:04','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-28 14:31:42',NULL,NULL),(55,3,'user','Curtis Heller','Lauryn.DuBuque96','Marisol_Douglas','Darrion.Purdy@yahoo.com','$scrypt$n=16384,r=8,p=1$o7thHIx4lOWCuS1xtpnwCg$uiYhNyNLf8iWUZ1zgi6jnhUglBDD51PafsCgOppiQ/tbYIWd0MK8DaOHK6+rlonrPoFC0EO33f1BYo56M1EeKg','+14645219008','https://avatars.githubusercontent.com/u/57410138','Christmas Island','Massachusetts','New Maryjane','43692','24594 Graham Circles',40.725774,-74.095935,'1','2024-08-27 12:11:41','1','2024-05-04 08:25:41','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-21 13:17:51',NULL,NULL),(56,3,'user','Miss Gloria Cronin','Sabryna62','Davion_Purdy23','Beryl_Luettgen17@yahoo.com','$scrypt$n=16384,r=8,p=1$oXHvAOGmNlsWMeT5zdztMw$iEOmAm/jo9g/byI5RUrd82G3XVs24XxswD15k+ozifilANEOQPS9WF2AoBfZC+drpL0rNjsvSgj3wE41dDx9LQ','+11484530044','https://avatars.githubusercontent.com/u/83378368','New Zealand','Alabama','Tillmancester','29055','68475 Meadow Lane',40.758817,-74.056466,'1','2024-09-16 18:02:02','1','2024-07-19 00:01:43','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-26 13:15:38',NULL,NULL),(57,4,'user','Dr. Bradford Fadel','Terence57','Mary.Nitzsche62','Angel_Kris36@gmail.com','$scrypt$n=16384,r=8,p=1$6GKQj7NfvmhNVaIbgT9H+A$wIf5hQoV5SkPyVvUSDoj8N4rf+ziNViZ/fgkOF/rxZ8D7hF21OSRAPYVcIawbxVN43ZFZs31IyxryYAXOeD1jA','+16043660624','https://avatars.githubusercontent.com/u/86065718','South Africa','Nevada','Schuppeton','32837-8931','599 Johnston Point',40.614968,-74.082093,'1','2025-01-25 18:30:19','1','2025-01-09 06:43:02','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-02 21:16:04',NULL,NULL),(58,3,'user','Randall Cronin','Tyson78','Harley_Cole21','Trent12@gmail.com','$scrypt$n=16384,r=8,p=1$pHj0Gp31aYZNkAs7A7Hktg$Xq2syL0nlMsmmUbbswC7/1qitXECWAsmabcFoj8qMFVEs4HBARvMkxHtR0JL9tQnuf5lQfB2lSx8Z8ZQS5gkog','+12666874907','https://avatars.githubusercontent.com/u/30032998','Hungary','Nebraska','Tommieport','32920','94042 Waters Corner',40.653379,-73.913446,'1','2024-10-24 13:50:30','1','2024-05-16 06:00:49','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-05 08:24:02',NULL,NULL),(59,3,'user','Claudia Schuster','Kale.Jacobi','Kiana.Thompson13','Pearl_Bayer67@yahoo.com','$scrypt$n=16384,r=8,p=1$YQ4Pa79UeIzseq/HbwiRuw$/YAfiOjAYlYLjaQ/8x9DdeiaKQsvsmo4hYFoS6R0T6fUzPGttTMsplesvSR81YhOpeJZqSWHpbX7jKCWPhjM+w','+11480413702','https://avatars.githubusercontent.com/u/8851865','Djibouti','Nebraska','Powlowskicester','47052-3117','3872 The Limes',40.640186,-74.049932,'1','2024-10-26 00:10:51','1','2025-03-01 10:53:51','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-12 17:16:42',NULL,NULL),(60,4,'user','Miss Sheila Ondricka','Dale_Gibson64','Jerry_Boehm','Hilda.Harber-Abernathy20@yahoo.com','$scrypt$n=16384,r=8,p=1$bpfyDf/oF1pNNoVg6yAzTw$zhbqaECiCe/KURBG2R5nY0sS0146TmxLrWcpOz1f4ovxd0P2bsatUk5gTacZDfNeP8gkg4+g/KcU6tz5lapCtA','+18528307634','https://avatars.githubusercontent.com/u/45564082','Djibouti','Illinois','Greensboro','01373-5823','6637 E Pine Street',40.680984,-74.098039,'1','2025-03-22 21:13:05','1','2024-12-06 21:28:43','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-04-26 22:53:14',NULL,NULL),(61,3,'user','Sheldon Lindgren Sr.','Reggie96','Baylee59','Ahmad_Grant@yahoo.com','$scrypt$n=16384,r=8,p=1$/ExYnf5dSmqlgy4v9rmJDQ$WS1k2kohUrxPmyyomHOqrEC1+GaeMvjp0JMFa6hjgF2kvPcFIs4LWrTvCJi042CCGB42WH2HdG5OA8C09Z/nzg','+18610068800','https://avatars.githubusercontent.com/u/32717781','Bosnia and Herzegovina','Colorado','Yorba Linda','55389-1260','629 Guillermo Union',40.715518,-74.048238,'1','2024-09-18 07:43:17','1','2024-06-17 14:31:54','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-20 17:22:20',NULL,NULL),(62,4,'user','Joel Daugherty','Antwan_Maggio','Ignatius.Roob','Dejah85@gmail.com','$scrypt$n=16384,r=8,p=1$CVQ9G2PjinMLY03/Lp2pdw$It2EaHCUqryqi9JGw6NC+Cbtx3kNymQJFmxKhNsNmMPoPUSpuucAbdhIXcHtrMjIm7ZchioODrCSRK+qpJ3YRA','+15565823051','https://avatars.githubusercontent.com/u/27732657','El Salvador','New Mexico','Susiefort','16436-9923','8099 Kamren Land',40.723971,-74.082785,'1','2024-10-23 12:42:14','1','2024-11-11 10:44:28','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-09 20:59:10',NULL,NULL),(63,3,'user','Rosemary Lindgren','Bernita_Lind52','Filomena_Berge','Emelia46@yahoo.com','$scrypt$n=16384,r=8,p=1$uZdrH69qm70CYOAC0SRSIQ$FIQVOLN4XAv7eYsMbi2J0gmdBMkj2qMqbJfehOa9y1CaA/eIIsDt7JwnZIz77Hv3xKwtaxiC4nSBsz3sOE6t6g','+16963563810','https://avatars.githubusercontent.com/u/17625883','Cyprus','Rhode Island','Ames','89153-3913','53940 Kassulke Pine',40.678269,-73.930412,'1','2024-11-18 15:30:00','1','2025-04-18 02:02:03','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-23 10:12:32',NULL,NULL),(64,4,'user','Cynthia Doyle','Henry38','Ryder.Glover','Rubie12@gmail.com','$scrypt$n=16384,r=8,p=1$WJp1SdLM9jP8dVKgx4JEPQ$94J7j5UM2T+jhhsFb743KvbIG1wGgUVxM7uWDutYEkyQTnTi4WZBESZfmcXgadpf6SyzVVoZmWvo1QdY+eUFqg','+15366740003','https://avatars.githubusercontent.com/u/6725206','Bahamas','Florida','Hettingerview','44068-7960','61571 Georgianna Loop',40.625547,-73.971916,'1','2024-08-28 10:47:06','1','2024-07-28 02:51:01','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-04 13:32:02',NULL,NULL),(65,3,'user','Sam Hickle','Murl.Stokes10','Jonatan_Langosh65','Filiberto.Leannon@yahoo.com','$scrypt$n=16384,r=8,p=1$DRLUuW5DW4UshVsuvQQ22w$GkdGEOmr2SJmMRmVfv6dTmxXH8LdlmHedOiZAVOCcNhtkekqudQivXe8gfvnU3SSrFYBjfQDodlTHRkskrsW1w','+15725342302','https://avatars.githubusercontent.com/u/60373460','Luxembourg','New Jersey','Miami Gardens','58251-6998','21439 Wellington Bypass',40.789277,-73.962588,'1','2025-02-14 17:23:18','1','2025-01-17 03:04:14','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-13 13:05:15',NULL,NULL),(66,3,'user','Miss Irma Bauch','Joe51','Joana90','Nakia69@hotmail.com','$scrypt$n=16384,r=8,p=1$YpF4PWhgYQvNVTd+qPV9dQ$gW4kd1QjVgNyanrydDKuc35QXyLvijnDp7CZd6O7lCfU8wofNvhab53vR4xsPgpxP8pQIKV0C6hvHL1cl4iJMg','+16812506986','https://avatars.githubusercontent.com/u/95233993','Saint Martin','Louisiana','Tamialand','63045-7066','61029 Deckow Harbor',40.622831,-73.977536,'1','2024-07-11 01:22:05','1','2024-05-21 17:33:43','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-06-06 11:26:53',NULL,NULL),(67,3,'user','Pauline Douglas','Rosie.Gerhold92','Kathlyn_Krajcik14','Mary1@hotmail.com','$scrypt$n=16384,r=8,p=1$YMHiuRmZ7lj4NguKFIqDoQ$gML7xBo01A89pB2bPYohiKZIBZHRtEXRa8KAWbRUPizb9DZN1LAdRoxr8EUAX7foOSnRtWbyM56UteTTJsdDlg','+11412720119','https://avatars.githubusercontent.com/u/65874031','Guadeloupe','North Dakota','Ondrickafield','74831-7813','49048 Swaniawski Haven',40.642562,-73.941611,'1','2024-12-09 20:24:04','1','2024-08-09 18:17:39','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-03-21 16:07:44',NULL,NULL),(68,4,'user','Henry Metz-Little','Osbaldo81','Keyshawn0','Jacklyn12@gmail.com','$scrypt$n=16384,r=8,p=1$/o2bcIuSv64TnOCIztL+AQ$dzRiaqyOXccXQN+01Hnoe9RWqRrsrVHYI6spPOuEuPWUjZbscsBg1KTxTRUloToC4ySMVlwdbiBcKxUWd6fjgg','+12949460485','https://avatars.githubusercontent.com/u/38090157','Nigeria','Florida','North Kamron','31758-8849','772 E 3rd Street',40.804375,-74.091748,'1','2024-09-19 17:28:59','1','2025-01-26 23:16:05','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-03-25 20:47:26',NULL,NULL),(69,4,'user','Meghan Mann','Llewellyn_McDermott15','Laron_Kshlerin12','Winston_Sawayn69@hotmail.com','$scrypt$n=16384,r=8,p=1$fRkq28lG9DYhQgisnXyRAQ$Tw3SI5xf1K+3H4GXtV/Zoon/ssC7e6BZoY/qTl+oOZxJ5/Dq8kGzZNqZD10IHN0BJarGoCYmoGREB0Q2dZ92Jw','+17624484394','https://avatars.githubusercontent.com/u/61106160','Turkmenistan','Virginia','Gerlachfurt','20292','5821 Birch Road',40.778810,-74.016336,'1','2025-01-30 13:22:33','1','2024-12-14 13:54:08','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-03-23 23:58:25',NULL,NULL),(70,3,'user','Ernest Pfeffer','Heber43','Dolly_Stiedemann12','Candace43@gmail.com','$scrypt$n=16384,r=8,p=1$Ax7U8UQefjHVf/IU50QnQQ$l7QYn3aR8Qr2EnoU87T/EG4je+xcDiLbREG2Y3z0ZtklMi5jTYZjGFW46dGJkH6pPQvvDVNs1OasDgGjoKyk8g','+16980440185','https://avatars.githubusercontent.com/u/87444140','Serbia','Kentucky','Lake Harmon','73844','102 Mary Street',40.638369,-74.041115,'1','2024-12-03 20:35:37','1','2025-04-24 13:32:10','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-12 20:40:48',NULL,NULL),(71,3,'user','Charlotte Heaney','Enid81','Pascale_Schumm','Halie44@yahoo.com','$scrypt$n=16384,r=8,p=1$hZhkWZVB/WKK10WYlZyrsg$Wy2YMWVftUB+fkqAC9YXkc5ij7V1N9AJG57LD17/BMaP70R/TeHCpONAXnrpg2r1A26Q1ED/BAjln8d1XhWFeQ','+10050618846','https://avatars.githubusercontent.com/u/3279434','Liberia','New Mexico','South May','62381','56412 Blanda Walks',40.747541,-74.081777,'1','2024-10-04 10:46:22','1','2025-04-11 11:47:22','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-04 02:33:41',NULL,NULL),(72,3,'user','Archie Smitham','Corene.Mueller','Guadalupe.Kerluke17','Cody84@hotmail.com','$scrypt$n=16384,r=8,p=1$TIubEsboZ4E1UNpY+mV7Sw$Xs3T8qMqm7nAdUmTkojAd/sNP79mPnHcDpNdoqujy7XAUkfVUSKJkMeQBibWaVA0GPfquTXLKEuPBU4QFalrvQ','+16363186187','https://avatars.githubusercontent.com/u/48135626','Uzbekistan','Missouri','Fishers','69409','37140 Main Street E',40.775014,-74.050398,'1','2024-08-18 06:57:54','1','2025-01-04 01:42:45','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-08-02 09:33:09',NULL,NULL),(73,4,'user','Vickie Stanton','Johathan68','Ansel.Kunde','Clint1@gmail.com','$scrypt$n=16384,r=8,p=1$Ukh87gCUz4/97y5+PxxDrw$b6rkRqOGWjXUoE61RjEY+gVLL2JAC8n3x8ikdIJHzAuSyhnpZMVwUNltiD8+awWi7j+nzdbyQzhqxyNQd3a7NQ','+16031526773','https://avatars.githubusercontent.com/u/17540631','Morocco','Indiana','North Genesis','20259','70757 Hill Road',40.635290,-73.943889,'1','2024-09-15 01:49:47','1','2024-10-08 14:13:25','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-17 16:33:56',NULL,NULL),(74,3,'user','Floyd Cole','Elmer.Kerluke52','Maverick_Schmeler-DuBuque21','Randall_Daugherty18@gmail.com','$scrypt$n=16384,r=8,p=1$/QNpAy9Uz5DGShjIaLGMBA$ZYZrrrNP7mtlZ7aGM3EWAT8iJzn66jqLyDQ1MzT6plLeD4aBlNK4Bpc1cfvpbsD0y90j6HlW4rU2UqjqUEtmMA','+19759470859','https://avatars.githubusercontent.com/u/38874043','Sint Maarten','Washington','New Augustaville','55980','782 Grant Knoll',40.793667,-73.967350,'1','2024-06-04 01:47:50','1','2024-09-06 03:34:24','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-11-07 12:14:25',NULL,NULL),(75,3,'user','Salvador Conroy','Morton_Bailey92','Enoch28','Tyshawn38@hotmail.com','$scrypt$n=16384,r=8,p=1$TEV9XsL81DmuGR4Ys3aeKQ$VBISm+nPDOJrW8Qavk4mx8h8MnFXd4xVlQEBCaxTW1R+1be7n4QQ9BuiOpLkfNhZ9DYX5YE5H0Lo2VWqdPdKJw','+15421162183','https://avatars.githubusercontent.com/u/74117508','Sudan','Arkansas','Osinskifield','16068','8110 Eda Landing',40.630914,-74.060874,'1','2024-09-04 12:43:38','1','2025-04-16 16:57:06','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-20 21:21:32',NULL,NULL),(76,3,'user','Lydia Kreiger','Maddison_Raynor15','Nina.Torp38','Jeremy.Bernier9@hotmail.com','$scrypt$n=16384,r=8,p=1$0fn2hgevD0po3JwZ5nSw0g$KyQ8frkKosBX2DWf5qtbJOoZsO9KRnkyj3JGaiS1m5UJZPwS/WPLq0UH1sEnIotqJ786QPO2tf3IRmHLtw73BQ','+11645155118','https://avatars.githubusercontent.com/u/92047785','Saint Kitts and Nevis','North Carolina','Millerstead','39049','431 E Bridge Street',40.635306,-73.994991,'1','2025-04-18 01:25:09','1','2025-03-09 09:24:34','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-04-23 01:56:57',NULL,NULL),(77,3,'user','Geraldine Crist','Kim75','Roy_OKon','Jalyn83@gmail.com','$scrypt$n=16384,r=8,p=1$pfeqim4oZAfT/SZlOdhx8A$OIV+bCg3LFZaSfAR7D+tJGW9Y8RpbI40vZurfJJAbjvdRpn4pbnG2pFbuPETTGiIQp4DbzuSyxA8z89lK6MNiw','+13617383493','https://avatars.githubusercontent.com/u/16235036','Guyana','West Virginia','Breitenbergfort','16724','5371 Oral Meadows',40.636665,-73.915439,'1','2024-11-16 18:03:57','1','2024-06-21 15:35:18','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-08-14 08:31:29',NULL,NULL),(78,4,'user','Clayton Spinka','Lauretta_Welch','Gerard_Zieme','Tremayne.Bartell@yahoo.com','$scrypt$n=16384,r=8,p=1$Mhu1SfuY37VtEFUpy7IkCA$BnS/jG5BMz6FzaPw4O2wKdL2YrRU7VCGglbDNVxqlbMME0qWhf1VBzCPQl5pAqyue4X85fl72WCU+3BAa3+WEg','+10870481133','https://avatars.githubusercontent.com/u/46205850','Suriname','West Virginia','West Eastonberg','16045-0062','212 Yost Cliff',40.683539,-73.986890,'1','2024-07-13 19:19:01','1','2024-11-25 23:46:23','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-04-23 18:23:24',NULL,NULL),(79,4,'user','Dr. Violet Lynch','Mackenzie98','Rosalee.Wilkinson3','Gerson.Koepp87@gmail.com','$scrypt$n=16384,r=8,p=1$CqYIN+memKcYRXgpDNNCxQ$gFDbVExJUJ7ko2Z8zBXzPCtNj4NniZD62s/NAr7Ekfv/W3uxw4OxnjX2h/YR6rzEscS79RpYEAdM/Mff3w8vhg','+14296956191','https://avatars.githubusercontent.com/u/26624711','Egypt','New Hampshire','Volkmanport','77621','2515 Jast Crossing',40.655009,-74.087664,'1','2024-05-26 16:24:35','1','2025-02-16 04:41:39','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-08 04:36:45',NULL,NULL),(80,3,'user','Lindsey Towne','Clarabelle.Gerhold69','Vernie.Predovic','Caitlyn_Olson8@hotmail.com','$scrypt$n=16384,r=8,p=1$izeMvPrUtfETQ9Eew6IY6g$jcybsuxXpBCTpiNHUEmjDIt4QLMVKtffzYn0sDmBzYH8untBmE8cke4PH14AKGdxnH1Dl25e3BkVaa3xyLlEXg','+15252078532','https://avatars.githubusercontent.com/u/90972720','Central African Republic','Connecticut','North Randalboro','50894','978 Tillman Valleys',40.775938,-73.961101,'1','2024-05-13 21:55:34','1','2025-01-12 00:30:30','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-11 12:33:03',NULL,NULL),(81,4,'user','Belinda Metz','Caesar24','Dana66','Melissa61@yahoo.com','$scrypt$n=16384,r=8,p=1$EDkAgzIWYAiX8OcmquLRTg$EAyRZtx5P/NA6rC/qpbyiZsqN+CrvrA0qlZuE/cE1jGwtCDt5hI5iBwDzvQwhyX/vrTSfy3oUKnsg1soDxIOuA','+10779601292','https://avatars.githubusercontent.com/u/6354331','Sao Tome and Principe','Nevada','South Jamar','22149-2968','925 Dicki Pines',40.780928,-73.948270,'1','2024-09-28 06:15:30','1','2024-12-29 01:49:21','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-05 23:55:24',NULL,NULL),(82,4,'user','Mr. Jerry Olson','Glennie49','Ricardo_Spinka45','Carmel95@yahoo.com','$scrypt$n=16384,r=8,p=1$VN7SdRmKP9ROiFJrGyMP3A$4CF63weefJyVezkACT3gNuLvGOp0nniZcinPCV0b7jIP5KhHzdjaqmfKxhg9GsyO8PxLG8LgcX8svmp1amCZTQ','+17704929171','https://avatars.githubusercontent.com/u/75418911','Kenya','New Jersey','Westfurt','97182-8470','245 Demetrius Hollow',40.717037,-73.906793,'1','2025-04-27 18:07:59','1','2024-12-05 08:34:16','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-28 01:26:35',NULL,NULL),(83,4,'user','Andrea Haley II','Clemmie.Wisozk','Ethyl.Fadel14','Dwight_Shanahan72@gmail.com','$scrypt$n=16384,r=8,p=1$QUxIlkMOwRNAjCc6f7SiNQ$aYpG/97RYrrjuaZ79k+mS0OqNalSRxK2dR9oGVZOIPQn6Q2yqajPZqx1Y4vjN5bJiSHXr8F4i5h077KTg0Q1vA','+19532032303','https://avatars.githubusercontent.com/u/48934984','Argentina','Illinois','Madison','39093-4535','1537 Freeman Corners',40.764102,-73.990657,'1','2025-03-19 05:59:32','1','2024-09-25 03:45:13','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-29 08:14:40',NULL,NULL),(84,4,'user','Dr. Sidney Shields','Braulio44','Lowell.Erdman60','Charlotte_Rodriguez5@hotmail.com','$scrypt$n=16384,r=8,p=1$3/6emygs8kJv29ffbzqQ/Q$fKm+ECvwHbd0mmM/GMpmLY1+GnFoFfIzpeUnMa/Y+X3ISFwvMBsQjI2K3kLWJSJTmFDbhcTiKkxH+Bsn+JmSDw','+11402240001','https://avatars.githubusercontent.com/u/14235376','Croatia','Iowa','Chesapeake','66286-1105','67453 Cow Lane',40.650587,-73.922743,'1','2024-12-07 06:10:48','1','2024-10-05 17:46:56','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-08 16:05:27',NULL,NULL),(85,4,'user','Randall Wunsch','Dee_Wintheiser-Quitzon','Asha.Bernier','Alfreda54@yahoo.com','$scrypt$n=16384,r=8,p=1$2EsDUAwUtlgnC3FNvHgFWA$hxtIz1hf83l+tlkSd9A5zB4YVGjo6a59RkvX2p4L9nYY+sL5ufXOsIfX6x+WBybTwN5sJ4UdP5ZsgOG+lUF3CQ','+18828991061','https://avatars.githubusercontent.com/u/93696469','Djibouti','Nevada','Indianapolis','72414-2193','8589 Hauck Prairie',40.616898,-74.019036,'1','2024-11-01 09:41:14','1','2024-08-30 06:02:47','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-09 10:11:00',NULL,NULL),(86,3,'user','Lonnie Hodkiewicz','Reyna72','Archibald_Casper','Maddison_Hahn-Nolan@hotmail.com','$scrypt$n=16384,r=8,p=1$2xaB84cqxJiKbnNzPC4FUA$UQXkG0gdkICLF8CvXICOMXodSS6dCecitLrGjASpNp1/upoo9FNrLBlF/auE2jEQlZHm4OgXj67YNdL3SOyYDg','+10884527391','https://avatars.githubusercontent.com/u/11682214','Suriname','Illinois','Johnsworth','78650','4417 Schmidt Expressway',40.802773,-73.943302,'1','2024-08-17 02:41:15','1','2025-01-09 14:48:47','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-20 12:16:01',NULL,NULL),(87,4,'user','Pedro Olson','Karlie41','Tanya50','Loyce.Waelchi@yahoo.com','$scrypt$n=16384,r=8,p=1$RypiwuLJubu7VUClnqQO8w$wE3MwRyhzC4ohvbPDskhFO/PLqcQWwXcR0+3YKe8zIOHfdSqAVJW61gahb9E9/usEJMdophNNZH7r/JbzxcANA','+16916941807','https://avatars.githubusercontent.com/u/95983391','Cameroon','Washington','Reganchester','98096','184 Somerset Road',40.646705,-74.022712,'1','2024-05-24 00:07:31','1','2024-08-20 09:42:52','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-18 18:36:24',NULL,NULL),(88,3,'user','Rene Kris','Manuela56','Earnestine75','Reuben_Johns42@hotmail.com','$scrypt$n=16384,r=8,p=1$aZ/HFgXex1bCQd1RIkIMoQ$73sf2wfplnslYiXkggq4HUtmt4VGXGn2A0F2EQTjbehJlPCwotmdKApe/FvTCbAxGIw+J/8VqNtLmhFn7hBKNg','+19908886668','https://avatars.githubusercontent.com/u/54069538','Gabon','Nebraska','Edina','68159','9086 Crona Mills',40.641073,-73.938335,'1','2024-10-02 08:14:30','1','2025-04-19 14:23:03','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-08-25 13:05:43',NULL,NULL),(89,3,'user','Pat Auer','Michelle50','Myrtie_Jakubowski','Lucius.Heaney-Erdman@gmail.com','$scrypt$n=16384,r=8,p=1$CVliCvDM3FDM1HMruDSyPg$HlljwbJNrzFkX60lf9fgsOTXX59gcIir0Wyb2vHpMxVzBvBCJIOupgmNHyZbHClIRxtGOq/wHk26HqACdvVbig','+12040782304','https://avatars.githubusercontent.com/u/51474759','Democratic People\'s Republic of Korea','Alaska','Port Hailey','87293-8901','898 Cassin Park',40.772467,-74.078346,'1','2024-07-23 20:56:24','1','2024-11-13 10:24:49','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-16 03:20:08',NULL,NULL),(90,3,'user','Myrtle Murazik','Braeden_Shields61','Kristian.Herzog','Edwina_Lockman@yahoo.com','$scrypt$n=16384,r=8,p=1$MCLvR24EBlwWMlB+sevbaw$feGxT+VVi849OWsSYjD4h/D3pzlborlyEBbAUPcWMPPxluCbTXM+pQ5HPtJPJLciF3F95wGkmRbHREE3CHwj0g','+11976083589','https://avatars.githubusercontent.com/u/57834832','Myanmar','New York','East Ottilie','73766','676 W Elm Street',40.686592,-73.958509,'1','2024-11-28 13:48:43','1','2025-03-31 03:17:18','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-26 22:09:06',NULL,NULL),(91,4,'user','Jennie Graham','Barney_Bashirian','Dejon.Kuphal15','Halie.West@hotmail.com','$scrypt$n=16384,r=8,p=1$UCngufWhza0lOUNEXiEjIg$Oh6twaThA05jD2MoWehj1ygV3WTuOuYKjaH/UFKoPX8rLCnInYOKjjeGtA9s6QcRND3Rf1FQ04BSlaIg/gZI8w','+11306983233','https://avatars.githubusercontent.com/u/94432907','Bolivia','Illinois','Burke','45656-9021','1185 Church Walk',40.678572,-74.068531,'1','2024-09-13 16:41:13','1','2024-09-01 03:02:06','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-05-24 13:38:41',NULL,NULL),(92,4,'user','Ron Spencer','Gerry.Considine','Lelah.Yost','Rico_Kemmer74@hotmail.com','$scrypt$n=16384,r=8,p=1$qmULcatelaS7JFX2linjcg$POgoQz0dR3GA0fGC/f02dllvh6d7DQGuvsiXipblcp+tTXBkp3l+eh5uUiwCGkwRcBcuU9QkFaVgniDThI+GOw','+14486904978','https://avatars.githubusercontent.com/u/23035811','United Kingdom','Alabama','New Allie','78705','33990 Goodwin Inlet',40.678342,-73.919245,'1','2024-08-09 20:44:53','1','2025-01-17 10:37:40','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-07-10 17:24:16',NULL,NULL),(93,3,'user','Marsha Schinner','Gia.Kuhlman','Kurtis70','Jason.Bauch72@yahoo.com','$scrypt$n=16384,r=8,p=1$XuJyDhOllFshdoh7qtST1w$P+W3ggIk+GiX+62c5kiAXoP671v9mSw+lmhPhImxB2qIoeNGgqL4v6/abTZfLziYp2X8Ki/PWwtUeBhQ4k4ZtA','+18416220872','https://avatars.githubusercontent.com/u/50012278','Bosnia and Herzegovina','New Mexico','North Rutheworth','20634','3993 Johnson Light',40.740690,-74.005145,'1','2025-04-21 18:19:19','1','2025-02-02 21:19:06','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-25 18:01:24',NULL,NULL),(94,3,'user','Danny Jerde-McClure','Mattie.Conroy','Alessia_Schuppe72','Carlie_Collier@yahoo.com','$scrypt$n=16384,r=8,p=1$JFLRxPv2G82pTYOF1taayg$HOne+7fhn6/fRf3Hmtd5ieY77WW2pqfpIJqMhz2hE0WhD7zDIxJ8IdiJ61eqNNyIu8I6f79phki6onP7hBUXAg','+10227130779','https://avatars.githubusercontent.com/u/92114349','Colombia','North Dakota','Joelport','28580-7736','83814 N Central Avenue',40.716067,-73.963213,'1','2024-09-18 21:19:37','1','2025-02-14 19:53:59','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-04-16 23:22:07',NULL,NULL),(95,3,'user','Hannah Bahringer Jr.','Tyreek_Nienow71','Eleanore_Dibbert','Mittie35@gmail.com','$scrypt$n=16384,r=8,p=1$xsPIpP9l7qJrcpwXNomouA$3Sx/Mwsml3768YOuD/gEyGBKS8dVmEBwt8Z0qFaX/5C3L3R0mIhiTskjcelRIUAWNnxpIjlsGbzr/K9zdEM0jA','+14543051459','https://avatars.githubusercontent.com/u/77489837','Armenia','Mississippi','Astridstead','29499-9101','84306 E Elm Street',40.669219,-74.022643,'1','2024-06-30 06:29:56','1','2025-01-27 00:37:34','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-08 05:58:13',NULL,NULL),(96,4,'user','Marcella Pfannerstill','Clarabelle.Cummerata','Angelita.Heidenreich','Shad_Leffler62@gmail.com','$scrypt$n=16384,r=8,p=1$tNtNIGMZbkOtYrBRlia7Fg$L1S7I8Ldn0OMHf1kAE2qKRZdBpZIE6ldEo0GBoQTHxYCmEHwY1w8v1/vdxEg77QZiexAVu+ogmLud5vY0IQJRA','+17909896291','https://avatars.githubusercontent.com/u/62199688','Democratic People\'s Republic of Korea','Colorado','Sandrineville','31800','8896 Pearl Street',40.626332,-74.015960,'1','2024-06-21 14:43:12','1','2025-01-28 16:36:45','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-08-08 01:10:36',NULL,NULL),(97,4,'user','Brenda Watsica III','Paul_Kozey85','Jameson79','Greg31@gmail.com','$scrypt$n=16384,r=8,p=1$n+cG8o250OoGFaL/d9OPfA$q+iPbssZZQzBwJOo0gCjyibWuMWKcmUDgppk56A9yL0zmZkdjKhjP2USj/jyNadLRQW3fAE9lRPhAObhM8x4gw','+14034445686','https://avatars.githubusercontent.com/u/88796834','Bulgaria','Colorado','Veronicafort','95649','4125 S Chestnut Street',40.798641,-73.978866,'1','2024-10-07 15:03:59','1','2024-05-06 04:12:33','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-08-15 15:51:00',NULL,NULL),(98,3,'user','Edgar Nicolas','Daphne_Reichel','Leslie_Predovic56','Abner97@gmail.com','$scrypt$n=16384,r=8,p=1$gxcC/dtkvq2Aaz8GcgLzWA$1Jxn5kQKdWXwoTIolVTQYnR/7vZ5aaZQvffXW+oOEBuUIwLUhfYM92IyYhZWqn/9+zFDMH+2s8XVHa/TZUVcDg','+11174555118','https://avatars.githubusercontent.com/u/47534073','Curacao','Minnesota','Sadiehaven','48017-8047','90157 Old Military Road',40.812272,-74.070937,'1','2024-05-21 23:18:18','1','2024-12-07 10:10:11','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-01-17 05:56:39',NULL,NULL),(99,3,'user','Oscar Zieme','Marquise_Gutmann58','Cary.Kilback','Roselyn_Simonis@gmail.com','$scrypt$n=16384,r=8,p=1$9JlvMUDTAOvwYXi54pn9xA$8weU98Y+mAdet/aQ7YsGGr84r5u5oKssUVXVmBJwt5HqeJts/crRt4Y6jIh5JPYi3ZshIfwjQmQ7WUM6uAuwXA','+14329069062','https://avatars.githubusercontent.com/u/23719257','Saint Lucia','Oklahoma','East Gracemouth','92471','61484 Padberg Row',40.666862,-74.100291,'1','2024-10-19 12:19:13','1','2024-08-09 07:12:18','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-10-29 01:28:59',NULL,NULL),(100,3,'user','Toni McGlynn','Esther_Dickens37','Don_Jacobson','Amya.Rolfson92@hotmail.com','$scrypt$n=16384,r=8,p=1$UFA+myX9HD01a7tlZ2rE2w$WOV6aT4iRDnfAsxNSlqr5zooLoHyLp+AohSfjIxCYHEWN/L3e9uFgF415zYb6I07mCio15zz0KPGUfmJwMVqew','+11510014926','https://avatars.githubusercontent.com/u/5203964','Tajikistan','Arkansas','Fort Elouiseberg','80096-7578','16334 W Division Street',40.753116,-74.024649,'1','2024-12-04 00:45:40','1','2024-07-05 21:28:41','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-12-01 05:29:38',NULL,NULL),(101,3,'user','Mr. Clayton Rice','Carmelo_Hammes4','Lou_Legros-Kirlin','Sienna.Bashirian@gmail.com','$scrypt$n=16384,r=8,p=1$jVvP27cn37GuHm4zlLLXUQ$wEFQQMkUgvqZ0UrY5hvCuhtu1foJ5/0SUx8onnRpiMtawU9EHE0+7S+bDPJUTzvhFoX1l7/mcb96qt3pTKXpcQ','+18884760511','https://avatars.githubusercontent.com/u/54790629','Lao People\'s Democratic Republic','Maryland','Xanderborough','59651-3592','91202 Janessa Summit',40.622776,-73.926297,'1','2025-03-02 02:35:56','1','2024-08-21 07:46:58','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2025-02-06 05:44:52',NULL,NULL),(102,4,'user','Kathryn Farrell','Bud.Bode-Gerhold15','Tomasa_McCullough96','Holden50@yahoo.com','$scrypt$n=16384,r=8,p=1$I9MKwgMy/2atkPmItPJNpA$Wv0ngfnvtVNcKZbwbzwbfGhP8i8EFDBJiin1YuauIA8P+GwAF+7WbNdx4kv0+hKaxNhwnQN9ve57oo8BteQH+w','+19320915824','https://avatars.githubusercontent.com/u/87257309','Guinea-Bissau','Michigan','Fort Brandtfield','64827','2108 Langworth Mills',40.782302,-73.988706,'1','2025-02-07 22:51:13','1','2024-11-25 23:31:18','1',0.00,NULL,NULL,0.00,0.00,'0','0',NULL,'2','1','2024-09-06 11:57:06',NULL,NULL);

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

CREATE TABLE `vehicle_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicle_categories_slug_unique` (`slug`),
  UNIQUE KEY `vehicle_categories_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `vehicle_categories` VALUES (1,'20250429103028968-52f39ddce6632615','Standard','A standard-sized car, ideal for everyday use and city commuting','active','2025-04-29 05:30:28',NULL,NULL),(2,'20250429103028968-efc2e90c0862e33b','SUV','A versatile, larger vehicle suitable for off-road driving and long-distance travel','active','2025-04-29 05:30:28',NULL,NULL),(3,'20250429103028968-caef6738f6d8767a','Mini','A compact, space-efficient car designed for urban environments and easy parking','active','2025-04-29 05:30:28',NULL,NULL),(4,'20250429103028968-52314e0f5161d89d','Eco-Friendly','Vehicles designed with sustainability in mind, often electric or hybrid models','active','2025-04-29 05:30:28',NULL,NULL);

--
-- Table structure for table `vehicle_colors`
--

CREATE TABLE `vehicle_colors` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `code_hash` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicle_colors_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vehicle_colors`
--

INSERT INTO `vehicle_colors` VALUES (1,'20250429103029005-3aed82067305904d','Rapid Red','#9B111E','active','2025-04-29 05:30:29',NULL,NULL),(2,'20250429103029005-f0d9d3a7ec4374e5','Oxford White','#F0F0F0','active','2025-04-29 05:30:29',NULL,NULL),(3,'20250429103029005-1f3c2daef5a2f0d1','Carbonized Gray','#4B4E53','active','2025-04-29 05:30:29',NULL,NULL),(4,'20250429103029005-e9c5819f57758e8b','Summit White','#F7F7F7','active','2025-04-29 05:30:29',NULL,NULL),(5,'20250429103029005-f39d9821decec323','Mosaic Black Metallic','#2D2926','active','2025-04-29 05:30:29',NULL,NULL),(6,'20250429103029005-ebc758cf13c5cb5f','Red Hot','#F12B2A','active','2025-04-29 05:30:29',NULL,NULL),(7,'20250429103029005-b34ae6500a391eea','Super White','#F7F7F7','active','2025-04-29 05:30:29',NULL,NULL),(8,'20250429103029005-ebed86535ed73241','Midnight Black Metallic','#1C1C1C','active','2025-04-29 05:30:29',NULL,NULL),(9,'20250429103029005-dc7e5d2b089a3704','Magnetic Gray Metallic','#4A4A4A','active','2025-04-29 05:30:29',NULL,NULL),(10,'20250429103029005-ebedffa4cc3850af','Lunar Silver Metallic','#D1D3D4','active','2025-04-29 05:30:29',NULL,NULL),(11,'20250429103029005-956dbda7588bf3a6','Crystal Black Pearl','#2B2D2F','active','2025-04-29 05:30:29',NULL,NULL),(12,'20250429103029005-e46f0011aede4c2f','Modern Steel Metallic','#5B5E5A','active','2025-04-29 05:30:29',NULL,NULL),(13,'20250429103029005-42b4a56a4fca0a31','Granite Crystal Metallic','#474A4B','active','2025-04-29 05:30:29',NULL,NULL),(14,'20250429103029005-ca83f9bd1f5da02a','Sting-Gray','#8E8F8A','active','2025-04-29 05:30:29',NULL,NULL),(15,'20250429103029005-5ce3d4cbe5b9167f','Firecracker Red','#E02F28','active','2025-04-29 05:30:29',NULL,NULL),(16,'20250429103029005-f893f02ab03da54a','White Knuckle','#F7F7F7','active','2025-04-29 05:30:29',NULL,NULL),(17,'20250429103029005-395bfa1d1d253210','Go Mango','#F44336','active','2025-04-29 05:30:29',NULL,NULL),(18,'20250429103029005-ecff130c17a9fe55','Billet Silver Metallic','#A6A9B0','active','2025-04-29 05:30:29',NULL,NULL),(19,'20250429103029006-d5b9c1013426b1be','Flame Red','#D32F2F','active','2025-04-29 05:30:29',NULL,NULL),(20,'20250429103029006-79323e35f213b730','Patriot Blue Pearl','#1C4F73','active','2025-04-29 05:30:29',NULL,NULL),(21,'20250429103029006-d5ccbc2005065686','Bright White','#FFFFFF','active','2025-04-29 05:30:29',NULL,NULL),(22,'20250429103029006-569f2017a142456e','Midnight Silver Metallic','#4B4E51','active','2025-04-29 05:30:29',NULL,NULL),(23,'20250429103029006-140d0b0275a21674','Pearl White Multi-Coat','#F0F0F0','active','2025-04-29 05:30:29',NULL,NULL),(24,'20250429103029006-fb6c3930761fffd3','Deep Blue Metallic','#005A72','active','2025-04-29 05:30:29',NULL,NULL),(25,'20250429103029006-9cf14c8788ac3aaf','Gun Metallic','#4D4F53','active','2025-04-29 05:30:29',NULL,NULL),(26,'20250429103029006-2204df5bdfcea8f1','Super Black','#1D1D1B','active','2025-04-29 05:30:29',NULL,NULL),(27,'20250429103029006-79d74da207f48af4','Brilliant Silver','#8A8C8E','active','2025-04-29 05:30:29',NULL,NULL),(28,'20250429103029006-a0b578a8b7ec798f','Alpine White','#F1F1F1','active','2025-04-29 05:30:29',NULL,NULL),(29,'20250429103029006-9cffbb7dabb0d1d0','Jet Black','#000000','active','2025-04-29 05:30:29',NULL,NULL),(30,'20250429103029006-de281979bad11bdb','Phytonic Blue','#1D5D7D','active','2025-04-29 05:30:29',NULL,NULL);

--
-- Table structure for table `vehicle_makes`
--

CREATE TABLE `vehicle_makes` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicle_makes_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vehicle_makes`
--

INSERT INTO `vehicle_makes` VALUES (1,'20250429103028987-2913530e53712251','Ford','active','2025-04-29 05:30:28',NULL,NULL),(2,'20250429103028987-9c6f980f0afa5d1c','Chevrolet','active','2025-04-29 05:30:28',NULL,NULL),(3,'20250429103028987-28ba912327b6331d','Toyota','active','2025-04-29 05:30:28',NULL,NULL),(4,'20250429103028987-aef482abf0e49de1','Honda','active','2025-04-29 05:30:28',NULL,NULL),(5,'20250429103028987-c3a8cfdb686b9abf','Jeep','active','2025-04-29 05:30:28',NULL,NULL),(6,'20250429103028987-b30c9f126a2346de','Dodge','active','2025-04-29 05:30:28',NULL,NULL),(7,'20250429103028987-3d16f5379dd2f67e','Ram','active','2025-04-29 05:30:28',NULL,NULL),(8,'20250429103028987-ff7266b88317f38b','Tesla','active','2025-04-29 05:30:28',NULL,NULL),(9,'20250429103028988-38107ae17fd9bc18','Nissan','active','2025-04-29 05:30:28',NULL,NULL),(10,'20250429103028988-155ed79a3e8299f3','BMW','active','2025-04-29 05:30:28',NULL,NULL);

--
-- Table structure for table `vehicle_models`
--

CREATE TABLE `vehicle_models` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `vehicle_make_id` int unsigned DEFAULT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('active','inactive') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `vehicle_models_slug_unique` (`slug`),
  KEY `vehicle_models_vehicle_make_id_foreign` (`vehicle_make_id`),
  CONSTRAINT `vehicle_models_vehicle_make_id_foreign` FOREIGN KEY (`vehicle_make_id`) REFERENCES `vehicle_makes` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `vehicle_models`
--

INSERT INTO `vehicle_models` VALUES (1,'20250429103028995-423dd0e3c69513e1',1,'F-150','active','2025-04-29 05:30:28',NULL,NULL),(2,'20250429103028995-91bfbbc1793a7bcf',1,'Mustang','active','2025-04-29 05:30:28',NULL,NULL),(3,'20250429103028995-9f9308de1c64414a',1,'Explorer','active','2025-04-29 05:30:28',NULL,NULL),(4,'20250429103028995-afc3165cea9054dc',2,'Silverado 1500','active','2025-04-29 05:30:28',NULL,NULL),(5,'20250429103028995-4b91762872d33e55',2,'Equinox','active','2025-04-29 05:30:28',NULL,NULL),(6,'20250429103028995-304f0914b004822c',2,'Malibu','active','2025-04-29 05:30:28',NULL,NULL),(7,'20250429103028995-2e25f8a997048f4d',3,'Camry','active','2025-04-29 05:30:28',NULL,NULL),(8,'20250429103028995-792f7790a27d8416',3,'Tacoma','active','2025-04-29 05:30:28',NULL,NULL),(9,'20250429103028995-db3b7c9fa2b2dc35',3,'RAV4','active','2025-04-29 05:30:28',NULL,NULL),(10,'20250429103028995-5489d802423ff1ec',4,'Civic','active','2025-04-29 05:30:28',NULL,NULL),(11,'20250429103028995-c8183a6098c826ed',4,'Accord','active','2025-04-29 05:30:28',NULL,NULL),(12,'20250429103028996-e7ec2d7ec5fc455f',4,'CR-V','active','2025-04-29 05:30:28',NULL,NULL),(13,'20250429103028996-7a78143f70f34e53',5,'Grand Cherokee','active','2025-04-29 05:30:28',NULL,NULL),(14,'20250429103028996-9272097b1c36a54d',5,'Wrangler','active','2025-04-29 05:30:28',NULL,NULL),(15,'20250429103028996-d472071bc5d09040',5,'Cherokee','active','2025-04-29 05:30:28',NULL,NULL),(16,'20250429103028996-e53da0e5b3389cbf',6,'Charger','active','2025-04-29 05:30:28',NULL,NULL),(17,'20250429103028996-d4ea8496ec875092',6,'Ram 1500','active','2025-04-29 05:30:28',NULL,NULL),(18,'20250429103028996-5c3a937fd70de442',6,'Durango','active','2025-04-29 05:30:28',NULL,NULL),(19,'20250429103028996-749d6221ae255ec3',7,'1500','active','2025-04-29 05:30:28',NULL,NULL),(20,'20250429103028996-50b4f419b9d75824',7,'2500','active','2025-04-29 05:30:28',NULL,NULL),(21,'20250429103028996-09309b73d2b5fd65',7,'ProMaster','active','2025-04-29 05:30:28',NULL,NULL),(22,'20250429103028996-d7238f2928d1823d',8,'Model 3','active','2025-04-29 05:30:28',NULL,NULL),(23,'20250429103028996-074a7da1cb84d7eb',8,'Model S','active','2025-04-29 05:30:28',NULL,NULL),(24,'20250429103028996-d102c48cb9a3a022',8,'Model X','active','2025-04-29 05:30:28',NULL,NULL),(25,'20250429103028996-65eb67146aa8a62e',9,'Altima','active','2025-04-29 05:30:28',NULL,NULL),(26,'20250429103028996-2fa6ef02dfc3988f',9,'Rogue','active','2025-04-29 05:30:28',NULL,NULL),(27,'20250429103028996-9b9328f9d330e4e8',9,'Frontier','active','2025-04-29 05:30:28',NULL,NULL),(28,'20250429103028996-cfb944de47059c0a',10,'3 Series','active','2025-04-29 05:30:28',NULL,NULL),(29,'20250429103028996-9f3c47fa6484d30b',10,'X5','active','2025-04-29 05:30:28',NULL,NULL),(30,'20250429103028996-86bceec105b52d68',10,'M4','active','2025-04-29 05:30:28',NULL,NULL);


