-- MySQL dump 10.13  Distrib 8.0.41, for Linux (x86_64)
--
-- Host: localhost    Database: go_glide
-- ------------------------------------------------------
-- Server version	8.0.41-0ubuntu0.22.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!50503 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

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

DROP TABLE IF EXISTS `adonis_schema`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `adonis_schema` WRITE;
/*!40000 ALTER TABLE `adonis_schema` DISABLE KEYS */;
INSERT INTO `adonis_schema` VALUES (1,'database/migrations/1707383527659_create_user_groups_table',1,'2025-03-21 08:04:38'),(2,'database/migrations/1707383554411_create_users_table',1,'2025-03-21 08:04:39'),(3,'database/migrations/1707386682353_create_user_api_tokens_table',1,'2025-03-21 08:04:39'),(4,'database/migrations/1707386724520_create_user_reset_passwords_table',1,'2025-03-21 08:04:39'),(5,'database/migrations/1707386764916_create_media_table',1,'2025-03-21 08:04:39'),(6,'database/migrations/1707386911174_create_notifications_table',1,'2025-03-21 08:04:39'),(7,'database/migrations/1707386921249_create_notification_settings_table',1,'2025-03-21 08:04:40'),(8,'database/migrations/1707387148824_create_user_device_tokens_table',1,'2025-03-21 08:04:40'),(9,'database/migrations/1715749860153_create_cms_modules_table',1,'2025-03-21 08:04:40'),(10,'database/migrations/1715749948547_create_application_settings_table',1,'2025-03-21 08:04:40'),(11,'database/migrations/1715750022416_create_content_managements_table',1,'2025-03-21 08:04:40'),(12,'database/migrations/1715937724497_create_faqs_table',1,'2025-03-21 08:04:40'),(13,'database/migrations/1740723861013_create_vehicle_categories_table',1,'2025-03-21 08:04:40'),(14,'database/migrations/1740724938845_create_vehicle_colors_table',1,'2025-03-21 08:04:40'),(15,'database/migrations/1740724938846_create_vehicle_makes_table',1,'2025-03-21 08:04:40'),(16,'database/migrations/1740724938847_create_vehicle_models_table',1,'2025-03-21 08:04:41'),(17,'database/migrations/1740724938848_create_user_vehicles_table',1,'2025-03-21 08:04:41'),(18,'database/migrations/1741001457628_create_create_bookings_table',1,'2025-03-21 08:04:42'),(19,'database/migrations/1741001457629_create_reasons_table',1,'2025-03-21 08:04:42'),(20,'database/migrations/1741001457630_create_disputes_table',1,'2025-03-21 08:04:43'),(21,'database/migrations/1741001504747_create_create_cancellations_table',1,'2025-03-21 08:04:43'),(22,'database/migrations/1741074783862_create_reviews_table',1,'2025-03-21 08:04:43'),(23,'database/migrations/1741084705892_create_user_drivering_details_table',1,'2025-03-21 08:04:44'),(24,'database/migrations/1741091957189_create_contactus_table',1,'2025-03-21 08:04:44'),(25,'database/migrations/1741092595829_create_chat_rooms_table',1,'2025-03-21 08:04:44'),(26,'database/migrations/1741092649802_create_chat_messages_table',1,'2025-03-21 08:04:45'),(27,'database/migrations/1741092661357_create_chat_message_statuses_table',1,'2025-03-21 08:04:45'),(28,'database/migrations/1741092682329_create_chat_room_users_table',1,'2025-03-21 08:04:46');
/*!40000 ALTER TABLE `adonis_schema` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `adonis_schema_versions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `adonis_schema_versions` (
  `version` int unsigned NOT NULL,
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `adonis_schema_versions` WRITE;
/*!40000 ALTER TABLE `adonis_schema_versions` DISABLE KEYS */;
INSERT INTO `adonis_schema_versions` VALUES (2);
/*!40000 ALTER TABLE `adonis_schema_versions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `application_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `application_settings` WRITE;
/*!40000 ALTER TABLE `application_settings` DISABLE KEYS */;
INSERT INTO `application_settings` VALUES (1,'application_setting','favicon','/images/favicon.png','1','2025-03-21 03:04:46',NULL,NULL),(2,'application_setting','logo','/images/logo.jpg','1','2025-03-21 03:04:46',NULL,NULL),(3,'application_setting','application_name','RetroCube','0','2025-03-21 03:04:46',NULL,NULL);
/*!40000 ALTER TABLE `application_settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `bookings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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,
  `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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `bookings` WRITE;
/*!40000 ALTER TABLE `bookings` DISABLE KEYS */;
/*!40000 ALTER TABLE `bookings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cancellations`
--

DROP TABLE IF EXISTS `cancellations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cancellations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slug` varchar(150) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reason` 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 `cancellations_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cancellations`
--

LOCK TABLES `cancellations` WRITE;
/*!40000 ALTER TABLE `cancellations` DISABLE KEYS */;
/*!40000 ALTER TABLE `cancellations` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `chat_message_status`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `chat_message_status` WRITE;
/*!40000 ALTER TABLE `chat_message_status` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_message_status` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `chat_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `chat_messages` WRITE;
/*!40000 ALTER TABLE `chat_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_messages` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `chat_room_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `chat_room_users` WRITE;
/*!40000 ALTER TABLE `chat_room_users` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_room_users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `chat_rooms`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `chat_rooms` WRITE;
/*!40000 ALTER TABLE `chat_rooms` DISABLE KEYS */;
/*!40000 ALTER TABLE `chat_rooms` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cms_modules`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cms_modules` WRITE;
/*!40000 ALTER TABLE `cms_modules` DISABLE KEYS */;
INSERT INTO `cms_modules` VALUES (1,0,'Cms Roles Management','cms-roles-management.index','fa fa-key','0',1.00,'2025-03-21 03:04:46',NULL,NULL),(2,0,'Cms Users Management','cms-users-management.index','fa fa-users','0',2.00,'2025-03-21 03:04:46',NULL,NULL),(3,0,'Application Setting','admin.application-setting','fa fa-cog','1',3.00,'2025-03-21 03:04:46',NULL,NULL),(4,0,'Users Management','app_users.index','fa fa-users','1',4.00,'2025-03-21 03:04:46',NULL,NULL),(5,0,'Content Management','content_management.index','fa fa-tasks','1',5.00,'2025-03-21 03:04:46',NULL,NULL),(6,0,'FAQ\'s','faq.index','fa fa-question-circle-o','1',6.00,'2025-03-21 03:04:46',NULL,NULL);
/*!40000 ALTER TABLE `cms_modules` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `contact_us`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `contact_us` WRITE;
/*!40000 ALTER TABLE `contact_us` DISABLE KEYS */;
/*!40000 ALTER TABLE `contact_us` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `content_managements`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `content_managements` WRITE;
/*!40000 ALTER TABLE `content_managements` DISABLE KEYS */;
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-03-21 03:04:46',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-03-21 03:04:46',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-03-21 03:04:46',NULL,NULL);
/*!40000 ALTER TABLE `content_managements` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `disputes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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,
  `reason_id` int unsigned DEFAULT NULL,
  `dispute_reason` text COLLATE utf8mb4_unicode_ci,
  `status` enum('open','resolved','closed') COLLATE utf8mb4_unicode_ci DEFAULT 'open',
  `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_user_id_foreign` (`user_id`),
  KEY `disputes_booking_id_index` (`booking_id`),
  KEY `disputes_status_index` (`status`),
  KEY `disputes_reason_id_index` (`reason_id`),
  CONSTRAINT `disputes_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE,
  CONSTRAINT `disputes_reason_id_foreign` FOREIGN KEY (`reason_id`) REFERENCES `reasons` (`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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `disputes` WRITE;
/*!40000 ALTER TABLE `disputes` DISABLE KEYS */;
/*!40000 ALTER TABLE `disputes` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `faqs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `faqs` WRITE;
/*!40000 ALTER TABLE `faqs` DISABLE KEYS */;
INSERT INTO `faqs` VALUES (1,'20250321080447352-ffb37b9fd40a34a9','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-03-21 03:04:47',NULL,NULL),(2,'20250321080447353-19c3a6dfaa8db52d','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-03-21 03:04:47',NULL,NULL),(3,'20250321080447353-ca90a5d24e94b69e','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-03-21 03:04:47',NULL,NULL);
/*!40000 ALTER TABLE `faqs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `media` WRITE;
/*!40000 ALTER TABLE `media` DISABLE KEYS */;
/*!40000 ALTER TABLE `media` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `notification_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `notification_settings` WRITE;
/*!40000 ALTER TABLE `notification_settings` DISABLE KEYS */;
/*!40000 ALTER TABLE `notification_settings` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `notifications`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `notifications` WRITE;
/*!40000 ALTER TABLE `notifications` DISABLE KEYS */;
/*!40000 ALTER TABLE `notifications` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `reasons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `reasons` WRITE;
/*!40000 ALTER TABLE `reasons` DISABLE KEYS */;
INSERT INTO `reasons` VALUES (1,'20250321080447184-839874ceef01ea65',NULL,'Long Wait','active','2025-03-21 03:04:47',NULL,NULL),(2,'20250321080447184-d4024e9c367c712e',NULL,'I changed my mind','active','2025-03-21 03:04:47',NULL,NULL),(3,'20250321080447184-edd01116f95c517a',NULL,'Driver asked to cancel','active','2025-03-21 03:04:47',NULL,NULL),(4,'20250321080447185-fd51ac182ef01f1f',NULL,'Driver asked to extra pay','active','2025-03-21 03:04:47',NULL,NULL),(5,'20250321080447185-b1f6f6065abb3a30',NULL,'Driver rating','active','2025-03-21 03:04:47',NULL,NULL),(6,'20250321080447186-3e066beb9542c98a',NULL,'Unhappy with car','active','2025-03-21 03:04:47',NULL,NULL),(7,'20250321080447186-f6b2f198bb1521e1',NULL,'More','active','2025-03-21 03:04:47',NULL,NULL);
/*!40000 ALTER TABLE `reasons` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_api_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_api_tokens` WRITE;
/*!40000 ALTER TABLE `user_api_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_api_tokens` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_device_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_device_tokens` WRITE;
/*!40000 ALTER TABLE `user_device_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_device_tokens` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_driver_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_driver_details` WRITE;
/*!40000 ALTER TABLE `user_driver_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_driver_details` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_groups`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_groups` WRITE;
/*!40000 ALTER TABLE `user_groups` DISABLE KEYS */;
INSERT INTO `user_groups` VALUES (1,'Super Admin','super_admin','1','2025-03-21 03:04:46',NULL,NULL),(2,'Admin','admin','0','2025-03-21 03:04:46',NULL,NULL),(3,'Driver','driver','0','2025-03-21 03:04:46',NULL,NULL),(4,'Passenger','passenger','0','2025-03-21 03:04:46',NULL,NULL);
/*!40000 ALTER TABLE `user_groups` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_reset_passwords`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_reset_passwords` WRITE;
/*!40000 ALTER TABLE `user_reset_passwords` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_reset_passwords` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_reviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_reviews` WRITE;
/*!40000 ALTER TABLE `user_reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_reviews` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `user_vehicle_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `user_vehicle_details` WRITE;
/*!40000 ALTER TABLE `user_vehicle_details` DISABLE KEYS */;
/*!40000 ALTER TABLE `user_vehicle_details` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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',
  `status` enum('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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,1,'admin','RetroCube','retrocube','20250321080446511-a359435d321f0154','admin@retrocube.com','$scrypt$n=16384,r=8,p=1$dfT7S5SyHkLPNOBFYdYgSw$cDp8Jjj1nMO1WKxsOJCoXNriLwq/KiZTVu4Sb6XXM7sZcYodvRnVhmsUqndXP/oiYh7fYRxqQzlWeGl1q8P9UA','1-8882051816',NULL,NULL,NULL,NULL,NULL,NULL,0.000000,0.000000,'1','2025-03-21 08:04:46','1','2025-03-21 08:04:46','0','1','0','2025-03-21 03:04:46',NULL,NULL),(2,2,'admin','GoGlide','go_glide_admin','20250321080446580-ce656d8f28e9d2a7','admin@goglide.com','$scrypt$n=16384,r=8,p=1$B0iq4HQEMfxQ5z4mlLjtYA$bEpj/48DztfrDNOZ/V/ehbIAG6icIwao2TW82+oDYGkS/JnQ4SD60eMwem55TVIGpIULwc322a+KnkdtHSCneQ','1-8882051817',NULL,NULL,NULL,NULL,NULL,NULL,0.000000,0.000000,'1','2025-03-21 08:04:46','1','2025-03-21 08:04:46','0','1','0','2025-03-21 03:04:46',NULL,NULL),(3,3,'user','Carole Gusikowski','Lottie44','Broderick85','Demetris.OConner@gmail.com','$scrypt$n=16384,r=8,p=1$b9jJXicvHIdzMsC4cqea6g$UjsQUlUaAGeiU8299tRZEecTevwPDgl/KzV6cj7zXQR9y/W//u9+zPQrqOmW680nDSi0kWxQNHu+JfdML6a2oA','+14359712505','https://avatars.githubusercontent.com/u/83680050','Guernsey','Virginia','Fort Mafalda','05875','59393 Hermiston Forest',40.710204,-73.935964,'1','2024-11-23 05:03:59','1','2025-01-23 20:40:39','1','1','1','2024-06-25 19:20:10',NULL,NULL),(4,4,'user','Clyde Lubowitz','Rafael.Davis','Alysson3','Allene.Crooks99@gmail.com','$scrypt$n=16384,r=8,p=1$FwE9Uc8oRiAlAURuzkmSvg$J20bKGNJHfXHunNZAYKr9yePOaPeo4bL1ffD/hZnlZ70rLe0TQ4Nct4yzR0y6Mq9shX6/zvBCUnHPt4unpkiBw','+15331641323','https://avatars.githubusercontent.com/u/32903129','Estonia','Mississippi','Beatriceview','93826-2187','39405 Wisozk Courts',40.764188,-73.945165,'1','2024-12-17 11:43:10','1','2024-12-19 15:58:14','1','1','1','2024-09-26 00:55:52',NULL,NULL),(5,4,'user','Mandy Kulas','Vivienne_Strosin','Elvie_Bradtke57','Jacinto.Feil7@gmail.com','$scrypt$n=16384,r=8,p=1$hYVDsvDF8ayXK5MblJkYwA$ZF5MxTkL7n7uibuwzo1tLZc0m1S0CkUH9Wg9W2aRtpP0zuwXsxz4Y+FYJr4wjvnGv5qlsORYTTO7OaiU/VHFpQ','+19505955249','https://avatars.githubusercontent.com/u/2472169','Norfolk Island','Maine','Nikkoburgh','03205-5215','2125 S 10th Street',40.683517,-73.970222,'1','2024-07-18 01:09:03','1','2024-11-06 15:58:25','1','1','1','2025-02-04 16:34:26',NULL,NULL),(6,4,'user','Guillermo Pfeffer','Lauren88','Myrl_Wolff','Haylee_Hoppe25@yahoo.com','$scrypt$n=16384,r=8,p=1$Zl0BPJBkV5TPA6iJC2Fr8g$UxsAnkbRBpDyWD6u81+dPe0OmUtlbsh9zMqeRiRB9+a2otATkYxCxLkIZ+vQB3izR4yyjp2ESRckys4VYOOHxQ','+14129641561','https://avatars.githubusercontent.com/u/84797887','Lithuania','Idaho','Creminberg','94934-5994','4865 Claudia Grove',40.784263,-73.952795,'1','2024-08-31 15:22:56','1','2025-01-19 21:53:57','1','1','1','2024-07-19 07:49:41',NULL,NULL),(7,3,'user','Toni Kuhlman-Dietrich','Coby.Leuschke','Georgianna62','Kaleb_Buckridge@hotmail.com','$scrypt$n=16384,r=8,p=1$2uTYPa6BWrBXoOc90pp3mw$fnxo0tWYg9MeeOE9DuNN+yVgtqmEpccQ6Tr2H8CX1zHx1SlzcHs3tsSC7o7ovEm+3xB1cUCQUg1SBUOETEQEOQ','+18442923454','https://avatars.githubusercontent.com/u/52066755','Honduras','Alabama','Declanstead','52887','2672 Oma Wall',40.785573,-73.917525,'1','2024-09-17 14:55:19','1','2024-10-13 18:40:26','1','1','1','2024-05-14 16:03:48',NULL,NULL),(8,4,'user','Virgil Glover','Virginia.Greenholt-Johnson90','Tabitha41','Skyla_Shields@gmail.com','$scrypt$n=16384,r=8,p=1$EqeD1vpdH0rL/YXQfp5MtQ$2O2coJK5ZOiKUNxpEGo+jntFW/wmsHPOsEuEDhQzbKm7k0C+9nBBrRsHeld6FJYzCd7DnECU5H9IjECakNAsaQ','+18075481340','https://avatars.githubusercontent.com/u/43538985','Uzbekistan','Oklahoma','Zulaufworth','19475','4825 Ozella Estate',40.736735,-74.096507,'1','2024-09-29 10:02:48','1','2024-11-29 17:15:44','1','1','1','2024-12-03 01:53:21',NULL,NULL),(9,4,'user','Dr. Rex Reinger','Donny_Sawayn','Julian_Sawayn37','Margarita_Feest6@hotmail.com','$scrypt$n=16384,r=8,p=1$iNgtka5VHBmCV76AMM8wpA$mSrMiLyZnqClFOxn2ud0/CQLbj57L1s8rxdE0NB07zd3L3NtlmXLf8iM1CVQ580BORwTgFwhjsvhJLpEl9QJsQ','+16907769639','https://avatars.githubusercontent.com/u/39528339','Martinique','Indiana','Reganworth','50378','39988 Garnett Knoll',40.811133,-73.962358,'1','2024-05-27 04:57:39','1','2024-09-21 23:03:57','1','1','1','2025-01-04 05:25:34',NULL,NULL),(10,4,'user','Elena Barton','Julien12','Mustafa64','Daphne_Kutch@gmail.com','$scrypt$n=16384,r=8,p=1$rNRYQgd27qzPvjxhDc08cA$WhqmbysvkwTngBPdMXgsQs6l1jyCbSjoyepsuMcaD2rGkP1cV99r5779hwc+3/xpurgjIYrVvRQ0h75vf74cQw','+17511700315','https://avatars.githubusercontent.com/u/10902311','Oman','Alaska','Fort Estaborough','13675-2146','97623 Ahmad View',40.762083,-74.059057,'1','2024-09-15 01:39:54','1','2024-09-25 17:03:34','1','1','1','2024-04-26 02:57:18',NULL,NULL),(11,3,'user','Garry Kunde','Isom_Howe','Josue_Denesik','Leopold.Dickens@yahoo.com','$scrypt$n=16384,r=8,p=1$Pz0n6rBls8ClX6DEwTt3lA$u/rp+4QmZ54L1wo7i8pH/qFK2JQLJthqXuIS6xMTRA/8yUqz33NN5A251B+omJn773HyUlenLGF1eGq8qoAXnQ','+13288387290','https://avatars.githubusercontent.com/u/80825965','Saudi Arabia','Hawaii','Des Plaines','87885-5832','523 Brandyn Dale',40.755874,-73.906779,'1','2024-08-13 21:23:20','1','2024-08-03 05:28:42','1','1','1','2024-06-17 08:18:49',NULL,NULL),(12,3,'user','Jamie Tromp','Rita84','Roger_Cassin46','Judd.Runolfsson@yahoo.com','$scrypt$n=16384,r=8,p=1$/u1VwXhBx0KEX9ILo7xO4w$JLO8sNY2vuJgp+GuJ5Xn/3X1Y8UpKRmg3rJr+ijY1tO8M+LVGN17RhOVIqWAqGgdlituUHjRNBjxMLRvkBst2Q','+19250700817','https://avatars.githubusercontent.com/u/82158002','Democratic Republic of the Congo','Tennessee','Fort Maximilian','18494-5782','90805 O\'Connell Curve',40.782205,-74.006017,'1','2024-06-17 13:14:54','1','2024-07-30 13:38:10','1','1','1','2024-06-02 12:52:24',NULL,NULL),(13,4,'user','Lillian Toy','Javonte_Beer','Joanny68','Dillon_Terry45@gmail.com','$scrypt$n=16384,r=8,p=1$zYSxWi6QG8Q7H0EhDhwdIA$ukVKkxYCs2O0CklK8dbvfWhTwMJ941r3uaCJJ7nGmIHsfS9QAUuRC7NQe7aJ77adYjuxxHgKY3+CjIaiFeDzjA','+17623058254','https://avatars.githubusercontent.com/u/98480334','Svalbard & Jan Mayen Islands','Wyoming','East Myafort','11876-9031','461 East Street',40.681787,-73.971209,'1','2024-12-07 14:19:25','1','2024-10-12 08:55:17','1','1','1','2024-09-24 08:26:21',NULL,NULL),(14,3,'user','Ken Kuhn','Alek1','Cortney_Beier-Kiehn','Margaret.Stoltenberg@yahoo.com','$scrypt$n=16384,r=8,p=1$2gwcHHEaPUKJM4YHcYEXhA$zXb/n+FmmUQfBFTodwP8NXsN8o5OK2Pfo+H7dRXUcYBN37oJdHkYkjuwNkFyuyPvOXUWiAYmY+ybiD/LktD/4Q','+17186031725','https://avatars.githubusercontent.com/u/81967872','Armenia','Arkansas','Kassulkemouth','17462','118 Kyle Burgs',40.787648,-74.086281,'1','2025-02-17 21:01:39','1','2024-04-22 05:33:21','1','1','1','2025-02-19 06:32:18',NULL,NULL),(15,3,'user','Ms. Henrietta Hahn','Manuela_Emard49','Jewel.Jacobi98','Benedict_Kirlin78@yahoo.com','$scrypt$n=16384,r=8,p=1$iP4F2e3mxZt63pzWUwcL4A$vD65hYrr7DChmNz0bvzOUAENE/Bk9l6j7qKlz49xcrPGbPAUsZPYLwbS+ZsTa1eqDUXl04rqvVRV50HvA8WhFA','+18572620726','https://avatars.githubusercontent.com/u/56465545','American Samoa','Missouri','East Abdul','93662-3738','3687 Baby Villages',40.796826,-74.044352,'1','2025-03-03 14:09:50','1','2024-07-10 13:57:35','1','1','1','2024-10-03 08:43:02',NULL,NULL),(16,3,'user','Hector Cassin-Dietrich','David_Abshire-Lesch','Micheal.Dietrich','Maggie71@yahoo.com','$scrypt$n=16384,r=8,p=1$jpfk0RxLdB/FDLREsk+OFw$vaHQG8BfParet1RQcWK0/wIDzPKlLqcv/Y4zqdO91reZzpIwnjavcxok0ZI6pwQRlxY8Zxfv6N5K2MAx17zTKA','+16641640152','https://avatars.githubusercontent.com/u/45266329','Papua New Guinea','Massachusetts','New Imogeneville','72002','706 Kessler Landing',40.719204,-73.962245,'1','2025-03-18 07:07:46','1','2024-11-07 23:00:11','1','1','1','2025-02-26 23:55:27',NULL,NULL),(17,4,'user','Jeannette Torp','Leopoldo_Ferry57','Waldo_Heathcote','Wilhelmine_Effertz@hotmail.com','$scrypt$n=16384,r=8,p=1$bom8Du/EJLRTcAx0ySPYiQ$ZQHZY4wznHA2e/FE9gGFVlsmEwOvl7wN1B9HaJNaoqLzAw5yz8gBRH4vy+qCxf78yzUlX1a9W0FW5PdjXERFQw','+13131239042','https://avatars.githubusercontent.com/u/45592831','Oman','Wyoming','Cliffordburgh','11480-0220','695 N Pine Street',40.641540,-74.019952,'1','2025-01-06 08:49:36','1','2025-02-24 08:46:00','1','1','1','2024-05-28 22:43:05',NULL,NULL),(18,3,'user','Seth Crooks','Alexandra17','Hassan12','Micah_OReilly@gmail.com','$scrypt$n=16384,r=8,p=1$SqOSeZLc9q5ZkpySWCStIw$2gWDnnJkt+tQ3kNL4wG/z14RgnMAAQrRdgB74UB1PL5oq40d9EvHCAh8ehGRlI0+C6pMXi3gccBam4Jnj1HK6w','+17016719023','https://avatars.githubusercontent.com/u/81353693','Aruba','Arkansas','New Karacester','94855','67172 Hilll Crossroad',40.812365,-73.980168,'1','2024-10-12 06:26:11','1','2024-09-12 08:45:51','1','1','1','2024-03-30 12:41:34',NULL,NULL),(19,4,'user','Eugene Nicolas','Giovanna48','Teresa.Herzog','Nicola.Schroeder52@gmail.com','$scrypt$n=16384,r=8,p=1$ekF8ujcJHDzR8eDPwXhJ0w$vKlNKeaBWI5fD+9HyOpAz3cEYE2Zk8Isd2/vp9ohEt86Ibe1SMsaSx5Fd9oNC8jQ7SvStoNkXz8WMI61NPFP5g','+17831092362','https://avatars.githubusercontent.com/u/29380906','French Polynesia','Ohio','Owentown','64396','254 Caleb Knolls',40.742875,-73.912983,'1','2024-09-14 08:53:41','1','2024-06-10 20:59:27','1','1','1','2024-12-07 18:31:32',NULL,NULL),(20,3,'user','Carlton Schmeler','Benton_Littel','Edd_Smith7','Lupe78@gmail.com','$scrypt$n=16384,r=8,p=1$H3AjKAk5zdbRFABdyB6Sww$zFAxGtZ/Da9MK2Bb5ecJqNnqCdj41WDWwwqrMNVhYc0PFM/rOvFXAPGP5CqkuYC6EIhkf+ssCx2tzLZave8A1Q','+10330206736','https://avatars.githubusercontent.com/u/44430044','Tanzania','Georgia','Kertzmannboro','67865-8453','6574 Bashirian Crossroad',40.707758,-74.051418,'1','2024-08-25 16:12:15','1','2024-05-07 19:11:32','1','1','1','2024-10-21 14:48:28',NULL,NULL),(21,4,'user','June Cassin','Benny.Herman66','Maurice21','Jameson.Wehner@gmail.com','$scrypt$n=16384,r=8,p=1$yBnN7z11jfy1qJ62BJYJSg$iLxReMAwrIY0/A7LjPZnuVx73jJsZxeDm3Gq42hXpBkRxve1x+K80uh0zueuDeRcZrDVqQaL6p5ZTkEi9BdIUQ','+17086317178','https://avatars.githubusercontent.com/u/74316616','Bahrain','Kentucky','Maiaburgh','44416-5148','26941 N Locust Street',40.785760,-73.994128,'1','2024-12-03 07:24:49','1','2025-02-10 23:44:38','1','1','1','2024-12-20 09:16:51',NULL,NULL),(22,3,'user','Florence Wolf V','Emelia.Grant','Sandrine_Boyer20','Marlon11@gmail.com','$scrypt$n=16384,r=8,p=1$uW3RAV7RrEObnCcHWEVnNA$E8A7CK22/KzQHnozt4JRhKDuhjg12XkKFVVdeoUt/JF/JYFZ/pKC1vzuleQ6QycEFFYNXcgNQlTz02ymj4Qo3g','+13086745548','https://avatars.githubusercontent.com/u/62548646','Slovenia','Utah','West Benjamin','10262','6210 Riverside',40.776901,-74.083073,'1','2024-07-05 22:56:50','1','2024-06-28 07:31:05','1','1','1','2024-06-19 02:37:17',NULL,NULL),(23,4,'user','Sergio Jones','Estefania_Prohaska27','Maegan.Beer','Webster71@yahoo.com','$scrypt$n=16384,r=8,p=1$mBPI7Wns1DiGauBn+5nJMg$dsiHquwYnk2w69hMQPvRNxsdxOF4Zh1uHfvSrLjbpb6o6p8HjCqbwQPjwE1b4JB2hcM66N/wF0j194qI5VdxUA','+19929536490','https://avatars.githubusercontent.com/u/39724700','Turkmenistan','Kansas','Lake Eli','14014','4412 South Avenue',40.793923,-74.105292,'1','2024-11-04 01:12:13','1','2024-10-10 14:00:01','1','1','1','2024-11-15 21:33:26',NULL,NULL),(24,3,'user','Jeremy Altenwerth-Block','Hector_Rippin58','Remington.Sawayn','Savanna_Abernathy@gmail.com','$scrypt$n=16384,r=8,p=1$Jb3vwnNf9u+pyoV3Qwh4kQ$BoV3KhHhPYzmlpmTIJj2s90hoJc94S8mKorlBODcQv5Cibhhyv79DbiZvG0cZzHvzGKITtip1c9p3UndC2wlUw','+12729241189','https://avatars.githubusercontent.com/u/65417967','Spain','Louisiana','Apopka','77066','117 Okuneva Mission',40.767646,-73.909038,'1','2025-03-02 03:47:53','1','2024-08-11 02:54:06','1','1','1','2025-02-07 01:58:57',NULL,NULL),(25,4,'user','Leah Nader','Adah.Effertz67','Doyle.Hagenes56','Linwood.Mayert19@gmail.com','$scrypt$n=16384,r=8,p=1$CHKr9LLF2npORzoksaRH8Q$/xmKx9FZ4QwYwrOIK+L9aATPf+LbIiHrtZ4CjahCCjxdE/pTm/hLr10j6M/WAQxTioUhm7UDsPAJZqCH3KLHgg','+16954134900','https://avatars.githubusercontent.com/u/76843087','Svalbard & Jan Mayen Islands','New Hampshire','East Elinorbury','31806-0167','7336 Alma Street',40.640342,-73.923616,'1','2024-03-22 20:41:33','1','2024-09-19 14:05:32','1','1','1','2024-08-18 07:29:40',NULL,NULL),(26,4,'user','Alejandro Tillman','Felix_Moore33','Ella.Greenfelder','Hudson.Becker@gmail.com','$scrypt$n=16384,r=8,p=1$/9vgahgMNtIUM4RURaNuFg$cFqjbXkj8A686bmjcAoNPXxsleABs969J2RbpRokVku0m9tvOg7KBxHmscwWCwZbVNawJunk5rcRVakfnU1RyQ','+14125240287','https://avatars.githubusercontent.com/u/44847317','Tunisia','Mississippi','South Bertha','85724','379 E Union Street',40.724335,-74.104487,'1','2024-09-30 18:31:53','1','2024-10-31 22:21:53','1','1','1','2024-07-04 12:23:53',NULL,NULL),(27,4,'user','Dr. Omar Okuneva','Assunta79','Vinnie.Halvorson','Carroll50@hotmail.com','$scrypt$n=16384,r=8,p=1$NUdi2Sbw9z1FZ8ArpUk5aw$Wj4vpFJugHnuKCJxM8Fq94qzcgN4foH2xcLDtqivdZ65JJO5A8sNGABgbWNylJaPF+9ThnEwaqV/DJXahRaKJg','+16423325465','https://avatars.githubusercontent.com/u/52492515','Iraq','Connecticut','Rochester Hills','16100','195 Park Road',40.615289,-74.058102,'1','2024-12-30 05:35:28','1','2025-02-12 01:15:44','1','1','1','2024-09-16 04:55:29',NULL,NULL),(28,3,'user','Susie Doyle DVM','Edyth.Stoltenberg','Gus_Dach21','Ali58@gmail.com','$scrypt$n=16384,r=8,p=1$f4f6XU9UiJ3PFekkPJTE5g$5kZEoJuGyXTbtBd2sWAD8TiHbR4dwaHFphyg43nEjIJdSY8iC10l9ZZ49Nu+oOFDdHkHL8BxlHYQs1oZ99z+jg','+14578992276','https://avatars.githubusercontent.com/u/37212034','Belize','Indiana','Elk Grove','00983','224 Gordon Road',40.785187,-73.934659,'1','2024-06-07 01:51:01','1','2024-07-29 10:09:12','1','1','1','2024-07-13 22:45:03',NULL,NULL),(29,3,'user','Phyllis Hamill-Anderson','Alan_Walsh-Mayert93','George87','Laurine_Koepp94@hotmail.com','$scrypt$n=16384,r=8,p=1$Efqgf3eEttSKhvXOZTPC4A$gH3LmN2JMGgYgKJFcy50joip1+j/XrTR9yTyxtz0WGBH/WUGzN8YtbTU8fpZi2f8A65WlPVYFBbQXvEiQwqJDQ','+15126948783','https://avatars.githubusercontent.com/u/23531755','Morocco','Rhode Island','Pfannerstillburgh','25779','6329 Manor Drive',40.621310,-74.021449,'1','2024-07-19 16:15:12','1','2025-02-07 14:25:28','1','1','1','2024-08-20 01:02:14',NULL,NULL),(30,4,'user','Dexter Kessler DVM','Lorenzo.Mills','Aliya.Gulgowski57','Bradly55@gmail.com','$scrypt$n=16384,r=8,p=1$taR2YITXj+wQogHzItr+gA$36VLte9lEN5j96403Wp4GGOE5coEikai8c62tzLOZsUtXfWfKyHQyIu4C9an5sxZjc/1QuqkJTj2cE9cpgpGZw','+19659102293','https://avatars.githubusercontent.com/u/85595902','Eswatini','Colorado','Mullerville','25909','9494 Twila Estates',40.703860,-74.034770,'1','2024-06-30 02:45:49','1','2025-03-12 02:26:43','1','1','1','2024-11-07 20:59:55',NULL,NULL),(31,3,'user','Sandy Hermann Jr.','Jacey97','Monserrate.Koss35','Danielle_Ondricka@yahoo.com','$scrypt$n=16384,r=8,p=1$XopPY/gtsUJJhEWEeHsKlg$/pWyuadtlMuwwRUu852koMMt8wdQAY634hDW9Y+QyWAzOUD01oQ5ntdJK2aWAgL00MK4SMdRvAJDNN8Zj1ptqA','+14070911899','https://avatars.githubusercontent.com/u/70426503','Spain','North Carolina','Akeemview','76647','7275 Sanford Mews',40.669195,-74.068447,'1','2024-08-12 10:28:22','1','2024-10-26 16:03:05','1','1','1','2024-09-01 13:08:27',NULL,NULL),(32,4,'user','Courtney Quigley','Ellsworth_Breitenberg97','Larry.Beahan','Devonte.Cole@yahoo.com','$scrypt$n=16384,r=8,p=1$1zcV0FRGzeJK6owl8pAoiA$+QlMQ7XfMTHs9oXSK7+hcJYjHPl+8qDxilBPV6q+rs5lVuncrYg/c0dIYFQdedy732Ngaj/4orgVKfnn8+xQuQ','+14843035143','https://avatars.githubusercontent.com/u/39385222','Ireland','Utah','Rohnert Park','37549-6463','140 Hunter Station',40.672806,-73.982056,'1','2025-03-04 17:55:33','1','2024-07-26 21:19:07','1','1','1','2024-05-08 20:54:11',NULL,NULL),(33,3,'user','Mr. Bob Zieme','Sharon_Bins','Merle_Friesen91','Mossie_Gislason@hotmail.com','$scrypt$n=16384,r=8,p=1$u7pcWVabaOi2QHwsiougGA$SQG8vPKUXFK19ybhZRxPHRaf03H9O/xXPkCP65T/sWlYeCL1Fl7X3tAhrXoy8EgXhRhXVZQIEjGo/M+/xzPinA','+19721942990','https://avatars.githubusercontent.com/u/38339846','British Indian Ocean Territory (Chagos Archipelago)','Maryland','Trujillo Alto','73680','6942 Russel Mount',40.808180,-74.084737,'1','2024-08-20 23:27:33','1','2024-09-05 09:09:28','1','1','1','2024-09-08 10:23:48',NULL,NULL),(34,3,'user','Randall Bergnaum','Max_Pollich74','Rachelle_Kub','Quentin_Parisian91@yahoo.com','$scrypt$n=16384,r=8,p=1$ay0w9z9XzH7gC2+moJMyJw$rHwnqYuTfeFYKk2UaOwXFWzKAbK497q+58KlYhrtpgShgiBISaIabDHY37jGt0AH59EKSrf98SwD0RThSOoOBQ','+10618093069','https://avatars.githubusercontent.com/u/70518781','Bhutan','Tennessee','New Derick','45705','39345 Howe Drives',40.762693,-73.913947,'1','2024-11-16 10:50:37','1','2024-04-08 23:17:25','1','1','1','2025-01-27 07:52:28',NULL,NULL),(35,3,'user','Mathew Glover III','Hoyt.Stamm23','Jacklyn.Streich47','Cassie_Douglas43@yahoo.com','$scrypt$n=16384,r=8,p=1$FoorpKzmlRbepd3ST6kI5A$dCsZeo2mq+o8XHfSgRXVmO55QyBJcI0T5KNVXdS4ByA3rZgbqXp+nPdfEu9Lh2ndR4aBwErqX4VKjrtZLoyO5A','+16933018736','https://avatars.githubusercontent.com/u/71730724','Singapore','Delaware','Avondale','33146-4047','200 Hilll Fords',40.613179,-74.055519,'1','2025-02-28 17:05:42','1','2025-01-21 22:01:17','1','1','1','2025-03-20 04:55:03',NULL,NULL),(36,4,'user','Cecil Conn III','Krista65','Janessa_Champlin','Tamia_Connelly54@yahoo.com','$scrypt$n=16384,r=8,p=1$cgQ6FO4SNOQUp7Y/vDUMbg$LkFbxSbrvCcfHpfe1vc7gCYREWXr4Nw2UOUiXQ3SKAXSbfix1DEIFfU+DFPaBHWTGRbCDLRF1jfq2iE+trKURQ','+12007921273','https://avatars.githubusercontent.com/u/29797272','Namibia','Missouri','Fort Ilaborough','76845-2796','6036 Schamberger Divide',40.724579,-73.959332,'1','2025-03-16 10:35:51','1','2024-03-26 23:50:19','1','1','1','2024-07-02 19:24:48',NULL,NULL),(37,3,'user','Jo Daniel PhD','Kirstin.Willms28','Mary_Wolff30','Bradford34@hotmail.com','$scrypt$n=16384,r=8,p=1$be8DakddXXzXv/JnGetiTw$xUvPA5x97JneEZ+xLzUMEcp22OAJcVa3EanpyTlIUTeGDqHSSkgFxZiEG3ylgxq6T8nTGC9RSWrqYwemxoM+3A','+13122989576','https://avatars.githubusercontent.com/u/62504705','Mali','Hawaii','Billings','12790-3899','841 Weissnat Creek',40.652147,-74.052756,'1','2025-02-15 18:59:11','1','2025-02-05 10:52:11','1','1','1','2025-01-11 17:54:36',NULL,NULL),(38,3,'user','Jay Yost','Juliet9','Noel95','Terrence93@hotmail.com','$scrypt$n=16384,r=8,p=1$thLSdwd+3G9LoKYqvYQwOg$7bHsO6K6wkgJAi71zR1EyoUJ2qeP/ybZiTlG6kzEYJJCtB7mOElIMrKS5sSV7b7C3csrCMtDyvjR2uVooFUwmQ','+12725762415','https://avatars.githubusercontent.com/u/66574601','Honduras','Ohio','Fort Luciusport','86382','93368 Strosin View',40.652359,-73.979903,'1','2024-06-07 20:12:41','1','2024-04-28 10:36:02','1','1','1','2024-10-04 08:56:04',NULL,NULL),(39,3,'user','Javier Kshlerin','Alejandrin.Renner85','Kennedy.Moore','Verdie36@hotmail.com','$scrypt$n=16384,r=8,p=1$mhYHUmH64cBuHhPlCNmAlg$IjRv9NZlUZNss3Wkb5cHFC3MP9GUMrXuwNEWgHjhjfEY7n2tHiWEOxTHOrTdZfdn1dUQqaHfCUF7yZz/6H3rlQ','+19374417253','https://avatars.githubusercontent.com/u/85599023','Sao Tome and Principe','New York','Faheymouth','35251-7457','2279 Kaley Rue',40.672511,-74.052326,'1','2024-05-23 02:15:28','1','2025-03-01 14:56:29','1','1','1','2024-10-07 16:40:57',NULL,NULL),(40,3,'user','Erin Rosenbaum','Jarret_Zboncak','Jamar_Shields99','Jacinto_Heathcote-Konopelski@gmail.com','$scrypt$n=16384,r=8,p=1$xmAf135gnABaeWQWdSPIAQ$KwSvBiV3055EsvkfrPiULU/u0I0fjnvVVgE0VtDaUqhsqo8c2RS2neaT9/zIp1HDipC50wMaQ4PEW41TFVwbQA','+13707639939','https://avatars.githubusercontent.com/u/64088411','Holy See (Vatican City State)','Wisconsin','Shieldsboro','17290','1359 N 7th Street',40.754245,-73.991559,'1','2024-06-04 00:06:30','1','2024-05-05 15:46:12','1','1','1','2024-08-23 02:00:02',NULL,NULL),(41,3,'user','Julius Spencer','Wilhelm.OKeefe67','Rosina33','Merlin_Flatley@yahoo.com','$scrypt$n=16384,r=8,p=1$0Eu5MjVGGVxDvq/x5ZS4PA$o3Pci8ox+b4ORFIf3mDpRXUCgTC/560dyivbBfI0qxJdLT2oHT0uKM8UEagYLloMIE4daKK+sBUU+9HWsNSm8g','+15010989672','https://avatars.githubusercontent.com/u/85887724','Colombia','South Carolina','Lake Lornabury','73922-4510','3424 Heaney Cliffs',40.680031,-74.035150,'1','2024-08-19 05:33:01','1','2024-10-25 03:39:22','1','1','1','2025-01-27 08:22:37',NULL,NULL),(42,4,'user','Dr. Randall Waelchi','Stella.Shanahan41','Carmelo62','Arjun.Auer@hotmail.com','$scrypt$n=16384,r=8,p=1$wwgnptrK1Pho4p3Ojgq00Q$xu9A6dt9Wa31pZvA+VmkYNT+RnPB/Drdopunt6vm8E2pOSAcFsVSBisQAujLbPwpV+bWBb6m2CrMsDX7doUSQg','+19762460204','https://avatars.githubusercontent.com/u/40741516','Serbia','Arizona','Bayerstad','24843','4546 9th Street',40.712369,-73.968183,'1','2025-01-13 21:09:29','1','2025-01-17 18:10:46','1','1','1','2024-12-21 03:42:13',NULL,NULL),(43,3,'user','Clara Mohr','Tyrese_Runolfsson52','Bethel7','Louie_Leannon@yahoo.com','$scrypt$n=16384,r=8,p=1$4V7hWboos9fA5i45bSQwzQ$UrfZV6RR5USUvUJfV5Q6E5/7MHR3fJ3uKUcbmv29pQOLu8N99SwCrLlApmYCjALNJOCyVnzuIdbKNb5XOvLmww','+15930407400','https://avatars.githubusercontent.com/u/73977196','Jordan','Indiana','Port Annamae','45246-9155','827 Center Street',40.753146,-74.080595,'1','2024-10-19 09:40:24','1','2024-06-20 03:35:58','1','1','1','2024-07-20 01:12:28',NULL,NULL),(44,3,'user','Dr. Sue Witting','Jayson.Schuppe-Mosciski34','Cassandra_Kuhic','Samantha_Brekke20@hotmail.com','$scrypt$n=16384,r=8,p=1$cgJm39w1dDYBqpcy/OLu+A$3Ul/nbfopO69F+SKRGnUNGPM0dVM69uv9DFcT6OwTgmVvSU1sHHkVlhW8qcukI7iaxqACMCNJ5tUnEcdhamfJw','+11507778646','https://avatars.githubusercontent.com/u/83997679','Bhutan','South Dakota','Lake Amanda','83703-8278','74140 General Forges',40.790849,-74.023998,'1','2024-04-13 13:10:29','1','2024-10-20 18:08:05','1','1','1','2024-09-16 08:54:14',NULL,NULL),(45,3,'user','Ann Sanford','Jessyca98','Nyasia_Grant98','Terrence.Erdman49@gmail.com','$scrypt$n=16384,r=8,p=1$L5MRbYE4u27JEIzZ/wC+Eg$rnmkfGyQf0pzVY5crsdzoaAnFpLXJDoPWI85h38hi/nUe1xlwXwsGyb60+IvBTFsYsXZBKRFBAoAI7SRq9/3DA','+15758616753','https://avatars.githubusercontent.com/u/8396354','Sierra Leone','North Dakota','Fort Jovanibury','61829-3927','85714 Brekke Fort',40.756289,-73.934233,'1','2024-04-06 04:12:56','1','2024-09-01 10:43:21','1','1','1','2024-09-24 02:16:15',NULL,NULL),(46,3,'user','Mr. Cameron Schaden-Carroll','Theron_Johnston','Dejuan78','Amanda.Altenwerth64@gmail.com','$scrypt$n=16384,r=8,p=1$g+Yjfq99F4uk5BZSSe9muA$YS9A/AtcRPlEC8if8dRFktUY+G1228mbwp4Gneb5+djL886PLDLK9pTOQFnlbU46POhEm1SS6CYaDfvagmJL8g','+19709367206','https://avatars.githubusercontent.com/u/64352390','Tajikistan','Missouri','Schulistburgh','71050','455 Christiansen Orchard',40.806264,-74.058457,'1','2024-04-07 11:45:19','1','2024-10-19 18:27:10','1','1','1','2025-03-13 01:10:07',NULL,NULL),(47,3,'user','Allison Raynor','Wilton_Bahringer','Amira_Hirthe','Johan58@yahoo.com','$scrypt$n=16384,r=8,p=1$k0NoswQ6uBlpCpaYWBEbCg$IT3e95B5baxcs2nRzGcRkAGgxjGana/4bMRfvbOQpwAV9OSrccf4Whh7yiu9Ik63HVq5H3B3k5J6Kiu0eP30HQ','+12618194147','https://avatars.githubusercontent.com/u/31566308','Russian Federation','Maine','Collinsstead','91096','932 Buckridge Grove',40.742217,-74.052141,'1','2024-05-09 07:22:35','1','2025-01-07 02:31:11','1','1','1','2024-11-25 21:11:46',NULL,NULL),(48,4,'user','Ted Mitchell-Terry','Lily_Cronin57','Kadin_Kertzmann50','Darrel_Connelly@yahoo.com','$scrypt$n=16384,r=8,p=1$qfdvXmPqStGKsC3js7Ft/g$20Xyvd2/56fbjtUB1ji0Vs+ctT7UMvJ84YZ3DNtQVmdGUrng59yxq9pUdeZSLAirfFRhHPrZkdS3+FwJek/PaQ','+19907872983','https://avatars.githubusercontent.com/u/86508693','Pitcairn Islands','Louisiana','Arvada','38209','3511 VonRueden Neck',40.762897,-74.086690,'1','2024-07-26 00:36:45','1','2024-11-02 10:42:46','1','1','1','2024-06-12 20:05:20',NULL,NULL),(49,3,'user','Leslie Botsford','Abdul_Hand','Eriberto_Hansen','Ernie.Mayert32@gmail.com','$scrypt$n=16384,r=8,p=1$jWG5evD0qzXhRI58K+QICg$OH4+8lG0i3Qst4G5Kcn0NUbzqJCpliOidvcZyBDeoWefz8XTZ59zAX1IUKfmEwvrjJMWmqEmV6f3hzsghKonIg','+11611099483','https://avatars.githubusercontent.com/u/58968772','Jordan','Montana','Vandervortborough','40098','713 S Division Street',40.804862,-73.972642,'1','2024-06-22 22:24:19','1','2024-10-24 22:10:13','1','1','1','2024-10-26 21:22:10',NULL,NULL),(50,4,'user','Antoinette Hilll','Shawna_Auer41','Jillian21','Reed_Hudson@yahoo.com','$scrypt$n=16384,r=8,p=1$Uva28zwqZv062n1Pa9aO9A$jYim3PEHm4QqsdTGxwXUpdQ8AJuEppnVI70RdGU0SSk+/HsPitubr8wEEjhBeXsz0yyBY5LXJdvjBHJk/ztlXg','+11564951985','https://avatars.githubusercontent.com/u/18332144','Tajikistan','Connecticut','Aliaside','19793','34902 Tower Road',40.685396,-74.006935,'1','2025-02-08 17:41:38','1','2025-01-30 11:19:49','1','1','1','2025-01-13 22:43:39',NULL,NULL),(51,4,'user','Margie Bernier','Eulalia32','Milton.Beatty0','Jude38@hotmail.com','$scrypt$n=16384,r=8,p=1$5QteIo7Yg2xi0l+UYsSuUA$ko4owCLDANF29ejp7C//igtBBDx2hCpVYi7TeNRu9IxuNxHkq3xUF7jx6vLpiP45Z1pZPsINEVjwpgItzlkiMA','+10461674000','https://avatars.githubusercontent.com/u/20301136','Israel','Nevada','Davenport','77934-4784','540 Jacklyn Mountain',40.716508,-73.990536,'1','2024-06-19 21:51:53','1','2024-11-06 00:35:59','1','1','1','2025-02-12 07:08:03',NULL,NULL),(52,4,'user','Christy Hartmann','Lottie.Stanton','Cecil23','Audrey3@hotmail.com','$scrypt$n=16384,r=8,p=1$w5l3JdydRiIRyU1IvGAv7w$3YWUVpuU/Lcs+m1STIaFZa70g53vZarJcJZaylxp6XF082TURtyru6BL72sxXd3YxINGZ2q/VyfaSUAjTDbJjw','+18653721812','https://avatars.githubusercontent.com/u/29126335','Georgia','Washington','Oscarberg','63601-8545','625 Reilly Ford',40.724815,-74.029031,'1','2024-03-22 18:36:18','1','2024-12-25 00:04:38','1','1','1','2024-06-22 18:15:17',NULL,NULL),(53,4,'user','Rhonda Bartell IV','Luz98','Sadie80','Jamey_VonRueden@yahoo.com','$scrypt$n=16384,r=8,p=1$7+/YNOoFS3t65liChbpchw$XDNgf+q7dpQCOWmyQmT1wtcu/vgwR/iboFy2cGmVkVbhcIXypn8Wz2ppq3RaAmBfIuk3+CvY01mQ10C7OdcoAA','+13488063615','https://avatars.githubusercontent.com/u/18092109','Niue','Texas','North Leone','45310','202 Mona Ville',40.685287,-73.918556,'1','2024-09-19 19:56:31','1','2024-04-14 19:38:42','1','1','1','2024-05-18 22:27:23',NULL,NULL),(54,3,'user','Miss Tara Reichel','Kolby.Schoen','Liza96','Tressa_Marquardt@gmail.com','$scrypt$n=16384,r=8,p=1$ws5qPcU8fQVPwt9oWPTMUw$P7ExkfIoBdRFRpaoUg4/v8nbyTL+rV4dhH5JoTbZpR0pctqVef20VIWGzcFqXon+qjO6pKo1U+xWA+8zI5p6HA','+19808655483','https://avatars.githubusercontent.com/u/70577820','Greenland','Virginia','Danielshire','33113-6992','2258 Water Lane',40.764464,-73.954792,'1','2024-04-10 14:43:21','1','2024-09-15 23:40:40','1','1','1','2025-03-16 07:10:12',NULL,NULL),(55,3,'user','Jerome Doyle','Thaddeus_Block','Johann27','Winfield67@gmail.com','$scrypt$n=16384,r=8,p=1$D2+402Sz8IP9K2CFSQUVhA$n4RAs/6YpP7Rh/onAZN9xYs92+IPaO2rW1Phk73McTnCk7fTATe7+rTcnleSKl4adzNwEVo6OMPXL7+dugU46g','+11966460485','https://avatars.githubusercontent.com/u/35795776','Saint Helena','Arkansas','Coyboro','78041','4182 Cullen Square',40.736872,-73.953748,'1','2024-11-07 00:10:50','1','2024-07-09 09:38:15','1','1','1','2025-01-10 19:50:48',NULL,NULL),(56,4,'user','Mr. Derek Wiza','Chadrick.Mante','Fatima.OKon31','Jeramie.Green9@hotmail.com','$scrypt$n=16384,r=8,p=1$yCg9vaADUv4MnnAgA2W8vw$U44SzU2Hfbul+KqgFYEaae7GnmdQyepHzSvtjlH+90OjEEMqbCbdT/X59fbxW+mUW8ZL1Ne2NLs8YbK69RPPNQ','+14008621435','https://avatars.githubusercontent.com/u/59288212','Senegal','Oklahoma','South Abdullahborough','90169-4953','33394 Clyde Center',40.716899,-74.070345,'1','2024-08-15 23:56:43','1','2024-12-09 04:07:12','1','1','1','2024-12-29 11:10:31',NULL,NULL),(57,3,'user','Ms. Vickie Kessler','Rita.Becker9','Jaquan_Shanahan','Natasha_Monahan@gmail.com','$scrypt$n=16384,r=8,p=1$a3G4HJRG4uCgpIrGYhl2Pg$jDXhKIjwf0ByRV6zL74rCundJW3eNqhu7rYNHViTQvsjmFoUT2dQMScOSP8eMo44lJPX5N0TG/SZ6f6olPnmcg','+15562415602','https://avatars.githubusercontent.com/u/89903606','Italy','Hawaii','Francescabury','93495','968 Barrows Alley',40.704565,-74.059873,'1','2024-06-11 17:20:09','1','2024-06-16 06:52:50','1','1','1','2024-07-04 19:49:32',NULL,NULL),(58,3,'user','Glenn Mueller','Jewell.VonRueden35','Roy.Harris','Stephon.Schaden78@hotmail.com','$scrypt$n=16384,r=8,p=1$s4Ut86HguOGAY53TKgmDEQ$HF3FodTxmC9Rv8LETyWHCtcC4bgXeneVfNvSiEr58UiYCre8skHLRhom78ugsl157zTcKrW5r82751A64FDHhA','+10300574935','https://avatars.githubusercontent.com/u/52461987','Cote d\'Ivoire','Indiana','Daisychester','74704-8958','3665 Johanna Shores',40.741104,-74.067898,'1','2024-07-31 13:03:37','1','2024-10-05 23:02:03','1','1','1','2024-09-27 08:51:44',NULL,NULL),(59,3,'user','Ms. Alma Ryan','Myrtice0','Millie_Torp','Fay_Zemlak25@yahoo.com','$scrypt$n=16384,r=8,p=1$lecfZVMDjrJgjvhBReKX7A$xX2rJW8OWFC61qG0U7foj0BKp7In41nr2DflUTDa5XAxN1K/LG0ve3+eDpMXmXPH539yvi97KpKxepatOJvkIQ','+16803555148','https://avatars.githubusercontent.com/u/79509128','Dominica','Connecticut','Micahchester','52413-7513','50860 Stark Viaduct',40.731658,-73.989026,'1','2024-10-06 17:47:09','1','2024-04-09 06:37:19','1','1','1','2024-06-13 21:12:08',NULL,NULL),(60,3,'user','Clarence Nolan','Iva.Mohr29','Rafaela.Koelpin','Ashly.Littel@gmail.com','$scrypt$n=16384,r=8,p=1$yVNgowKMvCDjZbR+78oOtg$2s0YdjfoQTGn4bW6uaoiMQBwMFiw0pLfPosKQB8AXtdeTPy48mKANJ9w4TunTlITOpIbauWjCQoqgf/NMqMF7Q','+18566424153','https://avatars.githubusercontent.com/u/56441917','Bermuda','Indiana','Leannonstad','89208','255 Bartoletti Mews',40.619478,-74.033093,'1','2024-12-03 11:12:58','1','2024-09-25 01:48:58','1','1','1','2025-02-23 01:18:02',NULL,NULL),(61,3,'user','Jon Casper','Henriette23','Caleigh.Hudson49','Ron.Fisher6@gmail.com','$scrypt$n=16384,r=8,p=1$XEYJR2H11ZfTqhN+cfAsxA$Hu/IVt1N/IrUHb7e5awGxN6HHrPOTfrAqWhdIBOZ67HlE8e6SdjrzCwPAGYihvT39fcU7XkQGkiSVI/gMq798g','+15919200251','https://avatars.githubusercontent.com/u/60642304','Bahamas','Minnesota','Port Corrine','20639-0292','905 Yundt Bridge',40.746728,-73.914973,'1','2024-04-28 13:28:13','1','2024-04-18 06:27:00','1','1','1','2024-10-29 17:37:36',NULL,NULL),(62,3,'user','Sean Cruickshank','Christelle14','Brain.Kling47','Lue.Deckow@yahoo.com','$scrypt$n=16384,r=8,p=1$prpuBacO9+J2wx8o6qHn6w$MqCpNJlo85z1U3Xauxnqk1rChbMB4MQix964eXKi5A3fD3jfgwTzCZF7FTASC+DdWYKxuCGw/Ngsc2gLmZV4KA','+16425138790','https://avatars.githubusercontent.com/u/26504836','Vietnam','Montana','Sylvanchester','15145-6594','4223 Mallie Ports',40.735193,-73.943448,'1','2025-02-18 10:10:12','1','2024-11-16 08:09:23','1','1','1','2025-03-11 11:23:19',NULL,NULL),(63,4,'user','Beverly Kris','Makenna_Mitchell50','Marguerite5','Miracle14@yahoo.com','$scrypt$n=16384,r=8,p=1$H7PcMx1MaN8z2wfh6sAUgg$sYgUzjiPYAzOgNK9+F+nxseVe1oJPdxXwDaurixbddXVxI+sbdJlletBz/H8g2Km6W9aCMdDHWKAJ5AxEsdm6Q','+10679154043','https://avatars.githubusercontent.com/u/57824953','Cambodia','Wyoming','MacGyverport','59913','3515 Sporer Land',40.687811,-73.916006,'1','2024-09-09 02:44:36','1','2024-03-27 02:09:37','1','1','1','2024-07-04 01:17:05',NULL,NULL),(64,4,'user','Harry Treutel','Lemuel64','Clemens_Schinner','Jacky.Mertz@gmail.com','$scrypt$n=16384,r=8,p=1$S0NJjvSy9Ifs4fMosrHrpA$yUP1oE8uzyNBoHMI4dDrDHazxBueddUI9659vluErWnoXnJwAPjTekypkIJTTXQGmDjkAUNh6BbaobzgYwAcUw','+18974065171','https://avatars.githubusercontent.com/u/3394129','Cuba','Pennsylvania','Broderickfield','06895','8991 Grant Mountain',40.686957,-73.940378,'1','2024-11-26 01:23:44','1','2025-03-09 21:16:51','1','1','1','2025-03-10 03:17:05',NULL,NULL),(65,3,'user','Blanche Stark','Jovany17','Raquel74','Keenan_Heller@yahoo.com','$scrypt$n=16384,r=8,p=1$tkQzErlXbovC/1sAT2cR1g$S8ScSjS9GVvDJmgbwKb6ctCiFEJVm9NARhgGdOwiBb7U08KvvBQj9OQXcZnm5vBZTkc+zdlJAEOIgVUD6QoQRg','+11217079257','https://avatars.githubusercontent.com/u/24397851','Greenland','New Jersey','Fairfield','22449-7154','962 Cole Estate',40.649346,-74.077156,'1','2025-03-07 07:37:54','1','2024-07-04 05:15:24','1','1','1','2025-01-22 10:01:08',NULL,NULL),(66,4,'user','Marc Sawayn','Easton.Botsford','Gianni_Ebert8','Lavern_Crist89@hotmail.com','$scrypt$n=16384,r=8,p=1$2YDBob6Vpw12WCSA0MfLLQ$sjkw+X+3qS5L1YIEM7YTcANtR5XAQz2odbeT0KEXVjclY5Nio1cPnpPEYgXzVTV3Tr47M/H0YCJxZlhR0V5maw','+11936348118','https://avatars.githubusercontent.com/u/38099465','Norway','Nebraska','South Roslyn','83483-5315','59497 Price Walks',40.739027,-73.991272,'1','2024-06-30 16:54:10','1','2024-10-29 08:39:44','1','1','1','2024-09-21 18:43:38',NULL,NULL),(67,3,'user','Gail Friesen','Eudora47','Antonette83','Joesph_Hodkiewicz@hotmail.com','$scrypt$n=16384,r=8,p=1$xuQ3Vq58DnkFA/kMXSWd4A$BiKrtrN3xXVcBfI3W6z603H4ly2o24OJ258/N2OSX/bfIHzDfl+pdhVkykRZxHZK1NBFF7oU3M87eSChoeMnyA','+10256341763','https://avatars.githubusercontent.com/u/39290791','Saint Lucia','Illinois','Lake Martafield','63214-2442','9082 Gleichner Burg',40.798247,-73.950735,'1','2025-01-24 04:36:51','1','2024-08-03 07:19:52','1','1','1','2024-03-28 18:14:38',NULL,NULL),(68,4,'user','Shawn Erdman III','Sandrine81','Joanie.Deckow9','Bobbie_Hamill@hotmail.com','$scrypt$n=16384,r=8,p=1$wUGUenTfv8EjaTYV8P+o4w$AYUVOo15LCqOUUCk+0vG1+sYy4AW6MfoirzmgmE4HlpDdP7bBQVJCJJxncKLKwVG1Z7VhX9bD+Ex1oR8qwjNhg','+19099096608','https://avatars.githubusercontent.com/u/99404415','Nepal','Maine','Garrettview','27683','6758 Bradtke Brooks',40.677056,-74.091901,'1','2024-08-31 15:09:12','1','2024-12-20 16:44:02','1','1','1','2024-12-08 21:42:29',NULL,NULL),(69,4,'user','Claudia Lockman','Kylee.Koch25','Omer19','Dena_Tremblay21@hotmail.com','$scrypt$n=16384,r=8,p=1$vlpwolutPAsRdS/jYYtnug$6aBjQYDOptIFwohqBvq2JANBxkWRpRMNxytBu+TNERen5/+o4ACxNftxFpFeZvrEHJndNf5Mm3LG0fNg2u5VZg','+11019207626','https://avatars.githubusercontent.com/u/80232359','Libyan Arab Jamahiriya','Montana','Maple Grove','10934-9641','6983 Meadow Way',40.809001,-73.987302,'1','2024-10-15 16:57:15','1','2025-02-15 23:21:35','1','1','1','2024-03-27 05:38:20',NULL,NULL),(70,4,'user','Clark Lehner','Norris.Larson23','Raul84','Tremayne_Morissette@gmail.com','$scrypt$n=16384,r=8,p=1$mn+tmNHXfHJGjuGjEKRh4g$Jo71CBvgvTG/+qePVgEpmnNHIsZJOgbk5mitMfWFuSa98ED4DgNwkkatrGCIlazVAyzvICfVn6qE/aeEd4fiyw','+15453369751','https://avatars.githubusercontent.com/u/69333046','Cape Verde','Nevada','Hermannport','39097-2741','1120 Cruickshank Way',40.787360,-73.922982,'1','2024-04-26 03:13:01','1','2024-10-19 22:16:10','1','1','1','2024-04-16 21:53:52',NULL,NULL),(71,4,'user','Ann Kautzer','Lacy.Kub','Sterling48','Joyce.Schuppe70@yahoo.com','$scrypt$n=16384,r=8,p=1$ujKserOUwzVfrzu6RgRuoQ$yYcKnDba17fyjJKpN8DRhoOrW7BtCm0cmgouRo657/wqtBDPVjz8jonpsFD9S0LWB5uOheD2GJqBJbMWQA9/PA','+11527601941','https://avatars.githubusercontent.com/u/61605112','Honduras','Connecticut','Rueckerfort','02711','7492 Howard Street',40.784952,-74.079840,'1','2024-05-27 02:05:56','1','2024-08-08 11:27:34','1','1','1','2025-02-03 04:56:33',NULL,NULL),(72,3,'user','Kristine Parisian','Osbaldo_Moore-Russel91','Beatrice27','Davonte27@yahoo.com','$scrypt$n=16384,r=8,p=1$fynIPXqDCbNMYApZcyieqA$csyRB77sbAzA4i+t/fQjdqOHNX1nQtN53qKVSwJWwTVcKxs+VII4c4uMhYpn1Cpu4A3XTBo3sSj6i1sJV0QGZA','+18026310204','https://avatars.githubusercontent.com/u/32832037','Australia','South Carolina','North Elianmouth','83167-6676','8529 Dare Shores',40.646796,-74.088960,'1','2025-01-20 05:10:57','1','2024-06-21 00:58:51','1','1','1','2024-12-23 21:22:17',NULL,NULL),(73,4,'user','Mr. Nick Stroman','Loy_Stiedemann97','Ray10','Cleo52@gmail.com','$scrypt$n=16384,r=8,p=1$KiivUdluwhGu/V1iTe//Ww$InnHZRlY2ktEXVljLmfUwp1IdE070GhOor7PiG5wPi3OFlYaNu2JD2Bzx+lHZzqDMpKC8sDTDDRTuYSZfZ3ujQ','+13866036099','https://avatars.githubusercontent.com/u/21043844','Antigua and Barbuda','Missouri','Fort Marvin','02728-7782','3457 Tara Fort',40.751751,-74.055572,'1','2024-07-28 00:29:53','1','2024-06-06 18:23:36','1','1','1','2025-02-04 10:25:33',NULL,NULL),(74,3,'user','Shannon Schumm-Huel','Michael51','Antone.Purdy','Fermin_Bednar-Wilkinson37@gmail.com','$scrypt$n=16384,r=8,p=1$KuGelRGKhQxlld4i9zuOYw$7z1qEK4REit8zdCL/LCUpEm3rRxcp8hyBBnqe50bhmP6e3pCvT/jpKTF8dscYcLpkeWKqW7Ca6xu9hvXial5WA','+12255153586','https://avatars.githubusercontent.com/u/81883974','Mauritius','Delaware','Torpburgh','47640','326 Trycia Route',40.614430,-74.054404,'1','2024-06-07 10:16:04','1','2024-05-14 19:23:41','1','1','1','2024-07-29 03:17:43',NULL,NULL),(75,3,'user','Dale Windler','Osborne57','Malinda_Cronin','Rachelle.Reichert74@hotmail.com','$scrypt$n=16384,r=8,p=1$XiCQ5w5RdoJw8xYLzPX85Q$52HeTYJbbypyV/ExLNgHlAs23jTo+PQlaRdcr4B7CvOPkoMg1vcysT0uH8dq0dAGybQ2jorwB2+dERBpbAFmIA','+14036655888','https://avatars.githubusercontent.com/u/46297918','Malaysia','South Dakota','West Octavia','07474','253 E North Street',40.812160,-73.934425,'1','2025-01-08 16:24:17','1','2024-11-20 01:28:32','1','1','1','2025-01-08 02:50:57',NULL,NULL),(76,3,'user','Betty Jast','Katherine_Langosh16','Brigitte_Orn95','Julie.Kilback81@hotmail.com','$scrypt$n=16384,r=8,p=1$OLTLMe5hJK+fIPqVxlF72Q$HOM4xBJFHr49a5fxtdUz6YfIUzq3357YlVk83Bj7lRgInxTvlFqsnqee/6l52c/IVYxVSJzt5cOd1E+eggh9ew','+12534263174','https://avatars.githubusercontent.com/u/68107964','Mayotte','Kansas','North Issacfurt','18579','779 Ledner Fall',40.688022,-73.918542,'1','2024-11-14 21:08:55','1','2024-11-03 05:56:11','1','1','1','2024-04-22 14:10:22',NULL,NULL),(77,4,'user','Joyce Lubowitz','Agnes23','Maud.Hickle43','Bryana_Mueller92@gmail.com','$scrypt$n=16384,r=8,p=1$zDfysb7ZRGoJVwfuXLi3aQ$ZOr5cBwDHqU2M9kCEu1MWE/B4yrmLsPZ0bfEezPGSFNOPlLJO1owhn7GLQZ7KBvjfx6MlqLWAW00J3y82d4D0Q','+17420227003','https://avatars.githubusercontent.com/u/55433551','Panama','Connecticut','South Audieville','06368','542 Maximillia Pine',40.637049,-74.082107,'1','2024-03-23 03:05:52','1','2024-08-03 14:05:24','1','1','1','2025-02-28 04:51:33',NULL,NULL),(78,3,'user','Paulette Jacobson','Jairo67','Presley.Spencer','Trycia_Osinski31@hotmail.com','$scrypt$n=16384,r=8,p=1$bPaV0o8n0ex7mbEy1+sZ0w$J5A86ry+P9b8dS1u5uPAUCqfBJHAVYqPEoNVdq7w+AdKNlk0xnCoAFCzzojdNTxFJ7MD9LK7TqFRd8JyFazcVQ','+13244827509','https://avatars.githubusercontent.com/u/3556992','Finland','New Mexico','Fort Christineport','66278','96278 Stacy Coves',40.655036,-74.023018,'1','2024-09-28 19:48:07','1','2024-09-24 12:59:16','1','1','1','2024-07-27 01:02:47',NULL,NULL),(79,3,'user','Karl Kilback','Lolita.Nitzsche','Mozell_Botsford17','Mike65@hotmail.com','$scrypt$n=16384,r=8,p=1$SfTVBMWK43ktL+4s1VFXBQ$ZGhXFlYqPf+erRWEncmd5ML4sXXNi9P7X1RXj/M9veY9rBFhB8hYy5SE6wQkeYlbzmAPL7a16cOeFmHZ3SkCQg','+13966243633','https://avatars.githubusercontent.com/u/78534359','Mexico','Florida','East Yesseniaboro','65425-7867','1932 The Oaks',40.796954,-73.987403,'1','2024-10-21 00:16:59','1','2024-06-11 08:59:55','1','1','1','2024-09-03 15:41:17',NULL,NULL),(80,4,'user','Stella Gerhold','Jamey.Veum','Lindsay.Friesen','Ryleigh19@gmail.com','$scrypt$n=16384,r=8,p=1$OVugrx6Kt32vfkwzUtQ26Q$reEybwQ2uTtFDmXTqQhCKW04Jzo4R7HqXMRmobcRBm9Ij9o+Q9DhJbqkK6J6VMFDR+PuS8Z1cB2AsnVItpG1uQ','+14180269354','https://avatars.githubusercontent.com/u/60916244','Burkina Faso','Nevada','Willyton','62969','871 E 4th Street',40.646822,-73.945027,'1','2025-03-08 05:46:03','1','2024-03-27 16:08:13','1','1','1','2024-09-24 11:41:45',NULL,NULL),(81,4,'user','Morris O\'Keefe','Polly85','Coralie92','Tatyana64@gmail.com','$scrypt$n=16384,r=8,p=1$AdFQYQII3OuUcwO7KlVS8Q$ClqZxzu6jvcuwABTY36wWv6ivxDJJC+1OJ/Uo7fllnzBFqQl4WBwlsNjuM6jGRtRM8Rsmlqo98XrnwFiE5U9pQ','+10793065864','https://avatars.githubusercontent.com/u/12961841','Chile','Wyoming','Colleenside','78366-6785','56488 Ortiz Street',40.762516,-73.952803,'1','2024-07-03 13:27:21','1','2024-09-23 15:43:56','1','1','1','2024-10-14 20:34:38',NULL,NULL),(82,3,'user','Ana Olson','Evie.West','Talia_Dibbert','Toy81@gmail.com','$scrypt$n=16384,r=8,p=1$qJOaXQ+foSWwg9HLS37sqA$W0Cw8te6JecRdS+6QydwbmRfS4uvLFSEVyRClm6wqu+JuOug9t8zsm2kS0xNLz9VHivSgu7ZQ7gJuJn05mrTAQ','+14994820976','https://avatars.githubusercontent.com/u/15855453','Namibia','West Virginia','Fort Myrtleborough','19264','86943 Hyatt Route',40.777205,-74.001127,'1','2024-07-15 19:34:11','1','2024-11-27 04:03:25','1','1','1','2024-11-07 05:28:38',NULL,NULL),(83,3,'user','Vanessa Upton','Aglae_Bode-Hansen95','Jerod_Treutel52','Amy.Swift9@hotmail.com','$scrypt$n=16384,r=8,p=1$3k5SYlt+iexK3Iyq1cyGTw$WU2wCUP0w5E/Op1vs21j3KeF2UkX+HXRnI4DuS3GD3pGemvZnPNOXckR4YexUZ36cLplyDMIuPBT6SLGLm0R6A','+14892897854','https://avatars.githubusercontent.com/u/62773664','Kyrgyz Republic','Connecticut','Detroit','41680-7692','20470 Will Tunnel',40.798603,-74.015319,'1','2025-03-12 16:32:18','1','2025-02-19 00:19:01','1','1','1','2025-03-16 14:51:39',NULL,NULL),(84,3,'user','Alonzo Marvin','Josefina94','Jane_Swift','Donald.Fay3@gmail.com','$scrypt$n=16384,r=8,p=1$LWTtNMZtJfL6f+Z15AM5xQ$NzIgBa+89yxig+zPb1w/6XGSlHcihgpmcub6sZX4Bfb9rsUrA2AWbiJTFEjrUVGT2VmX+fm97xneSAqe+34GyA','+10846181501','https://avatars.githubusercontent.com/u/63532681','Niue','Florida','San Tan Valley','35791-1689','302 Kuhic Stream',40.751722,-73.980478,'1','2025-03-06 22:34:43','1','2024-08-29 21:17:05','1','1','1','2024-08-31 03:06:40',NULL,NULL),(85,4,'user','Jerald Howell','Henri_Boehm','Donald.Waelchi','Retha_Vandervort73@gmail.com','$scrypt$n=16384,r=8,p=1$rJiP4EYp3/2ajpEPCkTPMg$hV4TQvtj+PZR7CrXUCGC87+ml4L9t+MdQkIEA3UeC+coscPdczmdHL7WUqftfx8V5+gzdo21MbPX7YHV5tL+5Q','+14718280886','https://avatars.githubusercontent.com/u/52841801','Bouvet Island','Hawaii','Santa Clarita','07520','1547 Jaskolski Walk',40.749314,-74.088081,'1','2024-06-16 01:48:12','1','2024-07-27 03:46:08','1','1','1','2024-07-25 21:37:38',NULL,NULL),(86,4,'user','Dr. Shaun Fisher','Craig_Wisoky','Alena_Moen','Alexandrine53@gmail.com','$scrypt$n=16384,r=8,p=1$pOg+hEZHeCJQsB3LTG7owQ$hpkKGiiygl5TUBAt6VrEfyWuq2vnWfxNKFXlGRpsDL/rV127zJy/5ndSR8gYvu2aCgtYw3psf0Q6CN/1La0T3A','+15392563108','https://avatars.githubusercontent.com/u/54418007','Japan','Kentucky','Anastaciofort','33795','756 Jakob Fork',40.617023,-74.031605,'1','2024-06-28 10:43:07','1','2024-09-28 13:26:59','1','1','1','2024-08-07 17:11:00',NULL,NULL),(87,3,'user','Conrad Labadie','Monty81','Rex35','Robin.Prosacco82@yahoo.com','$scrypt$n=16384,r=8,p=1$+1ytz1G4gjZkQ63MWNZBtA$dU7opHi2IGOsKLsPwF+xI+nJHl6YlDtozRMqa9miacPJVH8n0PDWpGB3xQYKMpHq0ot1YyVwlK7bv2kMLRV9QA','+11971653355','https://avatars.githubusercontent.com/u/93494195','Rwanda','Ohio','Andersonton','20344-9126','34508 Kirstin Ville',40.617644,-73.935896,'1','2024-08-02 03:06:51','1','2025-03-07 03:40:27','1','1','1','2024-05-10 19:52:40',NULL,NULL),(88,3,'user','Miss Gwen Nicolas-O\'Hara','Garrison_Gutkowski','Vito_Nader','Jensen96@yahoo.com','$scrypt$n=16384,r=8,p=1$S6NTlwRfpIB1EqCyNs5R4A$HVPdF1KKW2Ee9Z8QpuEb+d0zNbBgZuJIwYeHO++ZoGNcl00wOS5/IyvwkFZAQoT7jmWznFlZAwpUJKvUrbjKvA','+15867220245','https://avatars.githubusercontent.com/u/89540104','Antarctica','Nebraska','Bountiful','15482-7358','2768 Dejah Forges',40.725025,-74.039608,'1','2024-11-13 06:53:28','1','2024-07-20 09:49:12','1','1','1','2024-04-13 23:18:52',NULL,NULL),(89,4,'user','Penny Hackett','Scot_Bergnaum','Pearline_Marquardt','Ned.Upton96@hotmail.com','$scrypt$n=16384,r=8,p=1$J78J6p3xvm2SY56N7SL3nw$sF0eZE0DKT5Q35HvMW8aaB40jsyOsbOdLDHz9QViIP6S7ZDgY41HF7I9KlwCBqgi07k5TE/Ms22X5N/e2vNl1Q','+10969838529','https://avatars.githubusercontent.com/u/68765725','Virgin Islands, British','Arkansas','East Araceli','54093-7438','3740 Maxime Extensions',40.642472,-74.095983,'1','2025-01-04 14:25:04','1','2025-03-09 15:41:21','1','1','1','2024-06-29 08:20:16',NULL,NULL),(90,4,'user','Anthony VonRueden','Trycia43','Dameon_Grady','Akeem.Watsica@yahoo.com','$scrypt$n=16384,r=8,p=1$UcRBrhDY0n9nVJn5l9fuBA$IysUFnJM16nTglQ9Pkle6nj8rjJUd8dD27NMzStiWEVvjGvtKwD5Hwn4lnr0dYiwkE41a/8kpTWZcnM6XwOg+A','+15301091087','https://avatars.githubusercontent.com/u/89450622','Paraguay','Iowa','Kokomo','83565','82000 Sporer Square',40.699867,-73.989719,'1','2025-03-19 16:42:27','1','2024-06-18 04:28:44','1','1','1','2024-07-19 10:35:15',NULL,NULL),(91,3,'user','Ms. Carla Conn','Mariane86','Neoma_Maggio33','Elian_Denesik96@gmail.com','$scrypt$n=16384,r=8,p=1$X26ySjJTMZjHpPcL3AAUdw$6dG+hWLt21+G8o+NCLW3AOBqBqZ2AMCUVdJqyqvR4D4anPiuVbIdWp3vj9LBNxFcNm6gpoqSdAruBinE2czacA','+11242769348','https://avatars.githubusercontent.com/u/41201869','Dominican Republic','Ohio','West Edgardo','77527','225 Madalyn Drives',40.613822,-74.040961,'1','2025-03-19 21:40:28','1','2024-11-07 21:48:36','1','1','1','2025-01-13 05:59:44',NULL,NULL),(92,4,'user','Kathleen Zieme','Lamar.Bruen','Alene.Mayer-Kuhlman','Emmalee_Kovacek91@gmail.com','$scrypt$n=16384,r=8,p=1$q1cKF8Q17EEZiscxdBcmhQ$bU/9X8Y3X+ljzPQilGAbA4khFOB4jEhxZOkxWrE8/dM1urEpLBoq1k1JoeUA4VOQdsvu2JGk/wbZiFCol1Fd+Q','+16968383695','https://avatars.githubusercontent.com/u/49293395','China','New Jersey','South Carmine','18002-5782','245 Common Lane',40.654479,-73.940736,'1','2025-01-11 18:43:55','1','2024-09-06 06:45:48','1','1','1','2024-11-14 07:18:19',NULL,NULL),(93,3,'user','Natalie Kemmer','Kasandra.Greenfelder','Cleve63','Ezekiel_Torp@gmail.com','$scrypt$n=16384,r=8,p=1$VW6mM8YGa3Was8jwH8Fa3g$gsXFThLm637OtHr4DHAb8XLsxICQhR6Xkio+aoiHiOKnH2gd//ndwDA9g0kTvTQhliQRfC9OiyHwUhWa7i1oAg','+17748205400','https://avatars.githubusercontent.com/u/70342524','Argentina','Connecticut','Dejuanburgh','68963-3916','6500 Gordon Road',40.686060,-73.957809,'1','2024-06-27 05:32:04','1','2025-01-22 05:40:42','1','1','1','2024-10-20 21:46:28',NULL,NULL),(94,3,'user','Jackie Price V','Holden_Shanahan30','Emie36','Malika.Pfannerstill33@hotmail.com','$scrypt$n=16384,r=8,p=1$psSUxKswoxLZPiS6rr582g$L/qonPZaFxxOFeEKLoW9nlzuAGteNkpt6tynPtXusuB3JGLA1BsGSGVN2sAV48MucQairkKJetJdM/99WcIGhA','+14816288504','https://avatars.githubusercontent.com/u/62981274','Guinea','Connecticut','South Willa','72958','2475 Sabina Fall',40.701271,-74.076726,'1','2024-12-02 23:33:10','1','2024-10-26 17:32:46','1','1','1','2024-08-26 14:40:59',NULL,NULL),(95,4,'user','Cristina Franey','Emil.Friesen60','Pasquale_Koch61','Mylene_Kunde63@gmail.com','$scrypt$n=16384,r=8,p=1$YoCErCUZ8fyXafZoLT52yw$kRw7XeBs0d/IvAZor8uOZRp7gJDBgfNNfVcmFnMSOSqha+ShDeADUUhAzWKE6kjVSThrwnFMILOVGgMfm157uA','+17540708047','https://avatars.githubusercontent.com/u/37054542','Heard Island and McDonald Islands','Alabama','Streichhaven','65534-6280','1754 Monahan Cape',40.766913,-73.978364,'1','2024-09-17 20:18:56','1','2024-09-03 06:44:46','1','1','1','2024-03-30 23:08:51',NULL,NULL),(96,4,'user','Joanna Walker-Von','Lonzo_Lakin','Mikayla_Dietrich','Zula_Reilly@gmail.com','$scrypt$n=16384,r=8,p=1$bwCbMqNjp4YpeWXrlgV3Bg$oKI9UXxEMaVOKwOcVFSd543iQjdJlgAirlCUJIemLVMxXRtK8LCiBWnTtnuNnynVn8JfOEZJzDkSEa8aJaLZPQ','+10132725994','https://avatars.githubusercontent.com/u/12271089','Morocco','Texas','West Nathanworth','71138-9247','8064 Lake Street',40.760497,-73.939930,'1','2025-03-11 00:31:06','1','2025-02-24 02:18:06','1','1','1','2024-12-03 21:25:00',NULL,NULL),(97,3,'user','Jonathon Wunsch','Lydia_Rosenbaum9','Zelda_Bogan','Omer49@gmail.com','$scrypt$n=16384,r=8,p=1$RPdbyOzXiiiuOetIHT2jaw$h/m8CdxEzUZ7yYtyX7/zkkfT7ozu06NvvPmeGREUPQxLGdbkjPgyJpNwIEDoWMwlKSNEHHLNnMBGpUNCQbcvhw','+11342742339','https://avatars.githubusercontent.com/u/99391614','Virgin Islands, U.S.','South Carolina','West Colleenboro','08658','790 Ondricka River',40.734975,-73.998397,'1','2025-01-04 19:58:46','1','2024-11-09 18:28:17','1','1','1','2024-04-08 03:54:53',NULL,NULL),(98,4,'user','Ms. Kate Bartell','Brandon15','Laurine_Simonis47','Lillie_Carter28@hotmail.com','$scrypt$n=16384,r=8,p=1$X8BPaAr0UKSC8MpvdWVNzQ$dQ8Tvzqo7vwklDZTMmZuwql4YLe0PhK/239+gk/iEJ4eKCL/MBL0cg+q8QDmNV07rEl6PgpsLLm6Npi8yxjHmg','+10961810960','https://avatars.githubusercontent.com/u/45364409','Romania','Ohio','Eau Claire','46406-7119','2779 McGlynn Gateway',40.741443,-73.968198,'1','2024-08-04 08:58:34','1','2025-03-06 01:03:20','1','1','1','2024-09-28 03:31:19',NULL,NULL),(99,3,'user','Carmen West','Evans_Brown','Merle_Welch22','Jeanne42@yahoo.com','$scrypt$n=16384,r=8,p=1$bDHT+sDJx4q5rG+dnOsMAg$Mc1aCW0bXQsFH81Pi8DrmOqe8G9kt0qO5gEaOKccezyBuqI1tQnSOv2Kn083SHmuIy28U1hj/n7LDWUG1jXWng','+11817511153','https://avatars.githubusercontent.com/u/30908753','Grenada','Nebraska','Annabellborough','81804-3037','414 Alma Street',40.663353,-73.915050,'1','2024-07-08 08:54:25','1','2024-11-04 13:24:41','1','1','1','2025-02-12 16:03:53',NULL,NULL),(100,4,'user','Kara Collier','Allene.Boyle69','Tyshawn_McGlynn69','Josephine.Wolff@gmail.com','$scrypt$n=16384,r=8,p=1$1YTDh2IhCIpbU1LIIn/Pzg$n4S39+sVWUST8krllx6IM9rpOBYAPMiDrWBdiEVlTEKNTl5fE+GULX9rVO27Syw2i1YIb9tnJCOIu4Q0jkwhNg','+14329847939','https://avatars.githubusercontent.com/u/87871005','Azerbaijan','Nebraska','North Garfieldside','20235','614 Tyrell Overpass',40.743546,-74.060683,'1','2025-01-15 11:47:16','1','2024-07-06 18:50:00','1','1','1','2025-01-28 14:16:59',NULL,NULL),(101,4,'user','Adam Pfannerstill DVM','Juana81','Bernard62','Krista57@hotmail.com','$scrypt$n=16384,r=8,p=1$Sk4rhxsfVl+DcQZZ7VF0Hg$CNXYPbL0evkNa08tXO/jMetVsqgumPJGItngeA9p7opZztzw7J21nby1YDWQzIxrSsb0GIaVeZoNrYECtBPj8w','+12813201550','https://avatars.githubusercontent.com/u/9144446','Saint Kitts and Nevis','North Carolina','Jurupa Valley','65085-3528','478 S Main',40.761807,-73.978694,'1','2025-01-05 12:40:43','1','2024-05-19 04:29:49','1','1','1','2024-11-01 09:48:37',NULL,NULL),(102,4,'user','Daryl Mante I','Zola.White59','Amy_Keebler','Stuart.Brekke@yahoo.com','$scrypt$n=16384,r=8,p=1$rjEHk6F6QA3zjMolmx80Vg$MEhltybwn0Kq4+yZQCXpjTru9htyaihWfiW8nSV4MmUrVlVPk8CflKmy35q+OiA801a1shQZ1x88Rdw4HMR3ng','+12174652472','https://avatars.githubusercontent.com/u/29711349','United States of America','Rhode Island','Antelope','70450-3441','292 Carroll Loop',40.732950,-73.984820,'1','2024-12-11 20:07:03','1','2025-02-17 19:19:03','1','1','1','2024-08-01 13:12:02',NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `vehicle_categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `vehicle_categories` WRITE;
/*!40000 ALTER TABLE `vehicle_categories` DISABLE KEYS */;
INSERT INTO `vehicle_categories` VALUES (1,'20250321080447047-469880167007b7af','Standard','A standard-sized car, ideal for everyday use and city commuting','active','2025-03-21 03:04:47',NULL,NULL),(2,'20250321080447048-e1258c07f755e349','SUV','A versatile, larger vehicle suitable for off-road driving and long-distance travel','active','2025-03-21 03:04:47',NULL,NULL),(3,'20250321080447048-ee03c0437df8f870','Mini','A compact, space-efficient car designed for urban environments and easy parking','active','2025-03-21 03:04:47',NULL,NULL),(4,'20250321080447048-f845371194878617','Eco-Friendly','Vehicles designed with sustainability in mind, often electric or hybrid models','active','2025-03-21 03:04:47',NULL,NULL);
/*!40000 ALTER TABLE `vehicle_categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `vehicle_colors`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `vehicle_colors` WRITE;
/*!40000 ALTER TABLE `vehicle_colors` DISABLE KEYS */;
INSERT INTO `vehicle_colors` VALUES (1,'20250321080447864-d3663afbfb661a97','Rapid Red','#9B111E','active','2025-03-21 03:04:47',NULL,NULL),(2,'20250321080447864-eff411a275f59358','Oxford White','#F0F0F0','active','2025-03-21 03:04:47',NULL,NULL),(3,'20250321080447864-bfce2e24cdac47f6','Carbonized Gray','#4B4E53','active','2025-03-21 03:04:47',NULL,NULL),(4,'20250321080447864-3556b77bc4b007df','Summit White','#F7F7F7','active','2025-03-21 03:04:47',NULL,NULL),(5,'20250321080447864-9ec004439fd58f91','Mosaic Black Metallic','#2D2926','active','2025-03-21 03:04:47',NULL,NULL),(6,'20250321080447865-f2eaf3e3a1937403','Red Hot','#F12B2A','active','2025-03-21 03:04:47',NULL,NULL),(7,'20250321080447865-1a08ab700ba7fa62','Super White','#F7F7F7','active','2025-03-21 03:04:47',NULL,NULL),(8,'20250321080447865-dc158015895437f7','Midnight Black Metallic','#1C1C1C','active','2025-03-21 03:04:47',NULL,NULL),(9,'20250321080447865-aab2de62892459be','Magnetic Gray Metallic','#4A4A4A','active','2025-03-21 03:04:47',NULL,NULL),(10,'20250321080447865-cb6ecc464c9c3713','Lunar Silver Metallic','#D1D3D4','active','2025-03-21 03:04:47',NULL,NULL),(11,'20250321080447865-ecd778f9f766d1af','Crystal Black Pearl','#2B2D2F','active','2025-03-21 03:04:47',NULL,NULL),(12,'20250321080447865-2da35dc603399b92','Modern Steel Metallic','#5B5E5A','active','2025-03-21 03:04:47',NULL,NULL),(13,'20250321080447866-7cb8aa72f990a4fb','Granite Crystal Metallic','#474A4B','active','2025-03-21 03:04:47',NULL,NULL),(14,'20250321080447866-a5185c2f54209307','Sting-Gray','#8E8F8A','active','2025-03-21 03:04:47',NULL,NULL),(15,'20250321080447866-133be67ae8d60c0d','Firecracker Red','#E02F28','active','2025-03-21 03:04:47',NULL,NULL),(16,'20250321080447866-38f3dc8e0cbf9d49','White Knuckle','#F7F7F7','active','2025-03-21 03:04:47',NULL,NULL),(17,'20250321080447866-bd14f608a86d256a','Go Mango','#F44336','active','2025-03-21 03:04:47',NULL,NULL),(18,'20250321080447866-2050b723b6842d94','Billet Silver Metallic','#A6A9B0','active','2025-03-21 03:04:47',NULL,NULL),(19,'20250321080447866-a21ffa698c2c4f62','Flame Red','#D32F2F','active','2025-03-21 03:04:47',NULL,NULL),(20,'20250321080447866-350919023e9f2192','Patriot Blue Pearl','#1C4F73','active','2025-03-21 03:04:47',NULL,NULL),(21,'20250321080447867-eb0e2879e4bf5a11','Bright White','#FFFFFF','active','2025-03-21 03:04:47',NULL,NULL),(22,'20250321080447867-aad2228d5d852e7d','Midnight Silver Metallic','#4B4E51','active','2025-03-21 03:04:47',NULL,NULL),(23,'20250321080447867-6688c885feb22523','Pearl White Multi-Coat','#F0F0F0','active','2025-03-21 03:04:47',NULL,NULL),(24,'20250321080447867-75389960dc62c698','Deep Blue Metallic','#005A72','active','2025-03-21 03:04:47',NULL,NULL),(25,'20250321080447867-575221623abeed2e','Gun Metallic','#4D4F53','active','2025-03-21 03:04:47',NULL,NULL),(26,'20250321080447867-e1d432347a272b73','Super Black','#1D1D1B','active','2025-03-21 03:04:47',NULL,NULL),(27,'20250321080447867-353712a7f9f306ac','Brilliant Silver','#8A8C8E','active','2025-03-21 03:04:47',NULL,NULL),(28,'20250321080447867-b7d55f0dc7b7e36c','Alpine White','#F1F1F1','active','2025-03-21 03:04:47',NULL,NULL),(29,'20250321080447867-bf40056892fff4a9','Jet Black','#000000','active','2025-03-21 03:04:47',NULL,NULL),(30,'20250321080447867-41202427ba356a3a','Phytonic Blue','#1D5D7D','active','2025-03-21 03:04:47',NULL,NULL);
/*!40000 ALTER TABLE `vehicle_colors` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `vehicle_makes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `vehicle_makes` WRITE;
/*!40000 ALTER TABLE `vehicle_makes` DISABLE KEYS */;
INSERT INTO `vehicle_makes` VALUES (1,'20250321080447549-87e367fea1ac4266','Ford','active','2025-03-21 03:04:47',NULL,NULL),(2,'20250321080447550-e55c278a0d40f332','Chevrolet','active','2025-03-21 03:04:47',NULL,NULL),(3,'20250321080447550-47d7636137e952b6','Toyota','active','2025-03-21 03:04:47',NULL,NULL),(4,'20250321080447550-152bbb6fd25c197e','Honda','active','2025-03-21 03:04:47',NULL,NULL),(5,'20250321080447550-97be289eaf302140','Jeep','active','2025-03-21 03:04:47',NULL,NULL),(6,'20250321080447550-9cb845d27c0b3d55','Dodge','active','2025-03-21 03:04:47',NULL,NULL),(7,'20250321080447550-82dbe528d7ae3617','Ram','active','2025-03-21 03:04:47',NULL,NULL),(8,'20250321080447550-998c9b03c39bf9ff','Tesla','active','2025-03-21 03:04:47',NULL,NULL),(9,'20250321080447550-5ca19a5ecf02e16b','Nissan','active','2025-03-21 03:04:47',NULL,NULL),(10,'20250321080447550-7ff70be5d6eeb3ea','BMW','active','2025-03-21 03:04:47',NULL,NULL);
/*!40000 ALTER TABLE `vehicle_makes` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `vehicle_models`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `vehicle_models` WRITE;
/*!40000 ALTER TABLE `vehicle_models` DISABLE KEYS */;
INSERT INTO `vehicle_models` VALUES (1,'20250321080447682-77a20543956e4d6f',1,'F-150','active','2025-03-21 03:04:47',NULL,NULL),(2,'20250321080447682-2843b801678d9e2b',1,'Mustang','active','2025-03-21 03:04:47',NULL,NULL),(3,'20250321080447682-c9ff00370022752f',1,'Explorer','active','2025-03-21 03:04:47',NULL,NULL),(4,'20250321080447683-3b228e02d8f05ccf',2,'Silverado 1500','active','2025-03-21 03:04:47',NULL,NULL),(5,'20250321080447683-7595dca170a064b7',2,'Equinox','active','2025-03-21 03:04:47',NULL,NULL),(6,'20250321080447683-34248523f7415124',2,'Malibu','active','2025-03-21 03:04:47',NULL,NULL),(7,'20250321080447683-461447295bc81621',3,'Camry','active','2025-03-21 03:04:47',NULL,NULL),(8,'20250321080447683-9144012e4be609c5',3,'Tacoma','active','2025-03-21 03:04:47',NULL,NULL),(9,'20250321080447683-08a0de052ea5e6bd',3,'RAV4','active','2025-03-21 03:04:47',NULL,NULL),(10,'20250321080447683-17d51c40432e170b',4,'Civic','active','2025-03-21 03:04:47',NULL,NULL),(11,'20250321080447683-05957f989105cb9b',4,'Accord','active','2025-03-21 03:04:47',NULL,NULL),(12,'20250321080447683-8d3c3a55ce8e00d0',4,'CR-V','active','2025-03-21 03:04:47',NULL,NULL),(13,'20250321080447683-c5ba9d9e28fa167c',5,'Grand Cherokee','active','2025-03-21 03:04:47',NULL,NULL),(14,'20250321080447683-1d853b035fc5d557',5,'Wrangler','active','2025-03-21 03:04:47',NULL,NULL),(15,'20250321080447684-c17f154b38433c28',5,'Cherokee','active','2025-03-21 03:04:47',NULL,NULL),(16,'20250321080447684-f261cf6364d81cf6',6,'Charger','active','2025-03-21 03:04:47',NULL,NULL),(17,'20250321080447684-ae128ef491e4043a',6,'Ram 1500','active','2025-03-21 03:04:47',NULL,NULL),(18,'20250321080447684-7e568646d6fd8a50',6,'Durango','active','2025-03-21 03:04:47',NULL,NULL),(19,'20250321080447684-96de4f447fc06672',7,'1500','active','2025-03-21 03:04:47',NULL,NULL),(20,'20250321080447684-4374a9649c0084ea',7,'2500','active','2025-03-21 03:04:47',NULL,NULL),(21,'20250321080447684-505d2835c5ad8dfb',7,'ProMaster','active','2025-03-21 03:04:47',NULL,NULL),(22,'20250321080447684-211282528f35cc61',8,'Model 3','active','2025-03-21 03:04:47',NULL,NULL),(23,'20250321080447684-a96d5934b6b20120',8,'Model S','active','2025-03-21 03:04:47',NULL,NULL),(24,'20250321080447684-2f25e28a63f8a337',8,'Model X','active','2025-03-21 03:04:47',NULL,NULL),(25,'20250321080447684-27fb7a983fe1a934',9,'Altima','active','2025-03-21 03:04:47',NULL,NULL),(26,'20250321080447684-047ae478a1ac3ba7',9,'Rogue','active','2025-03-21 03:04:47',NULL,NULL),(27,'20250321080447684-2fdc47e6299b5d50',9,'Frontier','active','2025-03-21 03:04:47',NULL,NULL),(28,'20250321080447684-93e6a776a4ac1734',10,'3 Series','active','2025-03-21 03:04:47',NULL,NULL),(29,'20250321080447684-94c5ead67d165c2d',10,'X5','active','2025-03-21 03:04:47',NULL,NULL),(30,'20250321080447684-fffb433f60f1821b',10,'M4','active','2025-03-21 03:04:47',NULL,NULL);
/*!40000 ALTER TABLE `vehicle_models` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2025-03-21 13:07:12
