-- 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=198 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 (169,'database/migrations/1707383527659_create_user_groups_table',1,'2025-04-28 10:24:44'),(170,'database/migrations/1707383554411_create_users_table',1,'2025-04-28 10:24:45'),(171,'database/migrations/1707386682353_create_user_api_tokens_table',1,'2025-04-28 10:24:45'),(172,'database/migrations/1707386724520_create_user_reset_passwords_table',1,'2025-04-28 10:24:45'),(173,'database/migrations/1707386764916_create_media_table',1,'2025-04-28 10:24:45'),(174,'database/migrations/1707386911174_create_notifications_table',1,'2025-04-28 10:24:45'),(175,'database/migrations/1707386921249_create_notification_settings_table',1,'2025-04-28 10:24:45'),(176,'database/migrations/1707387148824_create_user_device_tokens_table',1,'2025-04-28 10:24:46'),(177,'database/migrations/1715749860153_create_cms_modules_table',1,'2025-04-28 10:24:46'),(178,'database/migrations/1715749948547_create_application_settings_table',1,'2025-04-28 10:24:46'),(179,'database/migrations/1715750022416_create_content_managements_table',1,'2025-04-28 10:24:46'),(180,'database/migrations/1715937724497_create_faqs_table',1,'2025-04-28 10:24:46'),(181,'database/migrations/1740723861013_create_vehicle_categories_table',1,'2025-04-28 10:24:46'),(182,'database/migrations/1740724938845_create_vehicle_colors_table',1,'2025-04-28 10:24:46'),(183,'database/migrations/1740724938846_create_vehicle_makes_table',1,'2025-04-28 10:24:46'),(184,'database/migrations/1740724938847_create_vehicle_models_table',1,'2025-04-28 10:24:46'),(185,'database/migrations/1740724938848_create_user_vehicles_table',1,'2025-04-28 10:24:47'),(186,'database/migrations/1741001457628_create_create_bookings_table',1,'2025-04-28 10:24:48'),(187,'database/migrations/1741001457629_create_reasons_table',1,'2025-04-28 10:24:48'),(188,'database/migrations/1741001457630_create_disputes_table',1,'2025-04-28 10:24:48'),(189,'database/migrations/1741074783862_create_reviews_table',1,'2025-04-28 10:24:49'),(190,'database/migrations/1741084705892_create_user_drivering_details_table',1,'2025-04-28 10:24:49'),(191,'database/migrations/1741091957189_create_contactus_table',1,'2025-04-28 10:24:50'),(192,'database/migrations/1741092595829_create_chat_rooms_table',1,'2025-04-28 10:24:50'),(193,'database/migrations/1741092649802_create_chat_messages_table',1,'2025-04-28 10:24:50'),(194,'database/migrations/1741092661357_create_chat_message_statuses_table',1,'2025-04-28 10:24:51'),(195,'database/migrations/1741092682329_create_chat_room_users_table',1,'2025-04-28 10:24:51'),(196,'database/migrations/1745566941720_create_user_cards_table',1,'2025-04-28 10:24:51'),(197,'database/migrations/1745567105599_create_user_transactions_table',1,'2025-04-28 10:24:52'); /*!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-04-28 05:24:52',NULL,NULL),(2,'application_setting','logo','/images/logo.jpg','1','2025-04-28 05:24:52',NULL,NULL),(3,'application_setting','application_name','RetroCube','0','2025-04-28 05:24:52',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, `cancel_reason` text COLLATE utf8mb4_unicode_ci, `booking_type` enum('instant','scheduled') COLLATE utf8mb4_unicode_ci NOT NULL, `is_user_review` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `is_driver_review` enum('0','1') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `scheduled_time` timestamp NULL DEFAULT NULL, `status` enum('initiate','accepted','rejected','arrived','started','completed','cancelled') COLLATE utf8mb4_unicode_ci DEFAULT 'initiate', `payment_status` enum('pending','paid','failed') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `bookings_slug_unique` (`slug`), KEY `bookings_driver_id_foreign` (`driver_id`), KEY `bookings_created_by_index` (`created_by`), KEY `bookings_vehicle_category_id_index` (`vehicle_category_id`), KEY `bookings_status_index` (`status`), KEY `bookings_payment_status_index` (`payment_status`), KEY `bookings_is_user_review_index` (`is_user_review`), KEY `bookings_is_driver_review_index` (`is_driver_review`), KEY `bookings_booking_type_index` (`booking_type`), KEY `bookings_status_payment_status_index` (`status`,`payment_status`), CONSTRAINT `bookings_created_by_foreign` FOREIGN KEY (`created_by`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `bookings_driver_id_foreign` FOREIGN KEY (`driver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `bookings_vehicle_category_id_foreign` FOREIGN KEY (`vehicle_category_id`) REFERENCES `vehicle_categories` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB 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 `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-04-28 05:24:52',NULL,NULL),(2,0,'Cms Users Management','cms-users-management.index','fa fa-users','0',2.00,'2025-04-28 05:24:52',NULL,NULL),(3,0,'Application Setting','admin.application-setting','fa fa-cog','1',3.00,'2025-04-28 05:24:52',NULL,NULL),(4,0,'Users Management','app_users.index','fa fa-users','1',4.00,'2025-04-28 05:24:52',NULL,NULL),(5,0,'Content Management','content_management.index','fa fa-tasks','1',5.00,'2025-04-28 05:24:52',NULL,NULL),(6,0,'FAQ\'s','faq.index','fa fa-question-circle-o','1',6.00,'2025-04-28 05:24:52',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-04-28 05:24:52',NULL,NULL),(2,'Privacy Policy','privacy-policy','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','1','2025-04-28 05:24:52',NULL,NULL),(3,'Terms & Conditions','terms-conditions','Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.','1','2025-04-28 05:24:52',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, `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `description` text COLLATE utf8mb4_unicode_ci, `image` text COLLATE utf8mb4_unicode_ci, `status` enum('pending','closed') COLLATE utf8mb4_unicode_ci DEFAULT 'pending', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `disputes_slug_unique` (`slug`), KEY `disputes_title_index` (`title`), KEY `disputes_booking_id_index` (`booking_id`), KEY `disputes_user_id_index` (`user_id`), KEY `disputes_status_index` (`status`), CONSTRAINT `disputes_booking_id_foreign` FOREIGN KEY (`booking_id`) REFERENCES `bookings` (`id`) ON DELETE CASCADE, CONSTRAINT `disputes_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!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,'20250428102452700-998a5bd53093f1de','Why choose us?','Go Glide connects you with professional drivers in real time, ensuring you get a ride exactly when you need it. No more long waits or unexpected delays. Enjoy fast, reliable, and hassle-free taxi services, anytime, anywhere!','2025-04-28 05:24:52',NULL,NULL),(2,'20250428102452700-14f6cab3cc1b03b8','How do I book a ride with Go Glide?','To book a ride with Go Glide, simply open the app, enter your pickup and drop-off locations, choose the type of ride you prefer, and hit \'Book\'. A professional driver will be assigned to you instantly, and you\'ll be notified when they arrive.','2025-04-28 05:24:52',NULL,NULL),(3,'20250428102452700-bc5ee769e233e194','What types of vehicles are available on Go Glide?','Go Glide offers a variety of vehicle types to meet your needs. Whether you\'re looking for a quick ride in an economy car, a premium ride in a luxury vehicle, or even a larger ride for groups, we have you covered. You can select the vehicle type based on your preference during the booking process.','2025-04-28 05:24:52',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,'20250428102452691-65775c4e5ce20515',NULL,'Long Wait','active','2025-04-28 05:24:52',NULL,NULL),(2,'20250428102452692-90d780d9c241d33a',NULL,'I changed my mind','active','2025-04-28 05:24:52',NULL,NULL),(3,'20250428102452692-a532add06a262212',NULL,'Driver asked to cancel','active','2025-04-28 05:24:52',NULL,NULL),(4,'20250428102452692-2e32f5a0243ff4c3',NULL,'Driver asked to extra pay','active','2025-04-28 05:24:52',NULL,NULL),(5,'20250428102452692-464009bd2530e9e3',NULL,'Driver rating','active','2025-04-28 05:24:52',NULL,NULL),(6,'20250428102452693-32363a3d7100d23d',NULL,'Unhappy with car','active','2025-04-28 05:24:52',NULL,NULL),(7,'20250428102452693-3c0a3c13d7cb3430',NULL,'More','active','2025-04-28 05:24:52',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 AUTO_INCREMENT=2 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 */; INSERT INTO `user_api_tokens` VALUES (1,3,NULL,'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJ1c2VyX2lkIjozLCJuYW1lIjoiRGlhbm5hIEhvZWdlciIsInNsdWciOiJMYXVyYV9TY2hpbGxlcjQiLCJlbWFpbCI6Illlc2VuaWFfUmF0a2VAaG90bWFpbC5jb20iLCJtb2JpbGVObyI6IisxNTg4ODY3OTc5MCIsImltYWdlVXJsIjoiaHR0cHM6Ly9hdmF0YXJzLmdpdGh1YnVzZXJjb250ZW50LmNvbS91LzgwNDE4Njc3IiwiaWF0IjoxNzQ1ODM2NTY0fQ.up373WImZgATfuHsSk7A9EjT-tW32liDGrI_vL3kkQ8','zKb1nP_IE0s18kzgTmpM8g.TzJQYzV6OVY1aktvMnFOSQ.9Pbbbn8Sqpr1_9vzI1SoWN8bDgdh9wNC43XYmNrTiAI','custom',NULL,'2025-04-28 05:36:04','2025-04-28 05:36:04',NULL); /*!40000 ALTER TABLE `user_api_tokens` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_cards` -- DROP TABLE IF EXISTS `user_cards`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_cards` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(33) DEFAULT NULL, `user_id` int unsigned DEFAULT NULL, `card_id` varchar(255) DEFAULT NULL, `brand` varchar(255) DEFAULT NULL, `last4_digit` varchar(255) DEFAULT NULL, `is_default` enum('0','1') DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_cards_slug_unique` (`slug`), KEY `user_cards_user_id_foreign` (`user_id`), CONSTRAINT `user_cards_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_cards` -- LOCK TABLES `user_cards` WRITE; /*!40000 ALTER TABLE `user_cards` DISABLE KEYS */; /*!40000 ALTER TABLE `user_cards` 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 AUTO_INCREMENT=2 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 */; INSERT INTO `user_device_tokens` VALUES (1,3,'ios','fe8Ntj8hHU7En--kCOGEoX:APA91bF6ecffhtETh-qPHM0g8N2AYbGoAB-GyI7Fzqyqt597sByevGd9RA9dpHW8UAczfzEpz1qDNIho9oDpzDO8lnaVttvz4UZuvqswht4lMLHg2wJ-_VvWChybi-otWwWF2viHUxTI','2025-04-28 05:36:04','2025-04-28 05:36:04',NULL); /*!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-04-28 05:24:52',NULL,NULL),(2,'Admin','admin','0','2025-04-28 05:24:52',NULL,NULL),(3,'Driver','driver','0','2025-04-28 05:24:52',NULL,NULL),(4,'Passenger','passenger','0','2025-04-28 05:24:52',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_transactions` -- DROP TABLE IF EXISTS `user_transactions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `user_transactions` ( `id` int unsigned NOT NULL AUTO_INCREMENT, `slug` varchar(33) DEFAULT NULL, `sender_id` int unsigned DEFAULT NULL, `receiver_id` int unsigned DEFAULT NULL, `module` varchar(255) DEFAULT NULL, `charge_id` varchar(255) DEFAULT NULL, `module_id` int DEFAULT '0', `gateway_transaction_id` varchar(255) DEFAULT NULL, `total_charges` decimal(11,2) DEFAULT '0.00', `admin_tax` decimal(11,2) DEFAULT '0.00', `net_amount` decimal(11,2) DEFAULT '0.00', `stripe_fee` decimal(11,2) DEFAULT '0.00', `gateway_response` text, `gateway` enum('stripe','paypal') DEFAULT 'stripe', `is_transfer` enum('1','0') DEFAULT '0', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `user_transactions_slug_unique` (`slug`), KEY `user_transactions_sender_id_foreign` (`sender_id`), KEY `user_transactions_receiver_id_foreign` (`receiver_id`), CONSTRAINT `user_transactions_receiver_id_foreign` FOREIGN KEY (`receiver_id`) REFERENCES `users` (`id`) ON DELETE CASCADE, CONSTRAINT `user_transactions_sender_id_foreign` FOREIGN KEY (`sender_id`) REFERENCES `users` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_transactions` -- LOCK TABLES `user_transactions` WRITE; /*!40000 ALTER TABLE `user_transactions` DISABLE KEYS */; /*!40000 ALTER TABLE `user_transactions` 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', `rating` decimal(11,2) DEFAULT '0.00', `gateway_customer_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `gateway_connect_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `wallet` decimal(11,2) DEFAULT '0.00', `is_payment_enable` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `is_payout_enable` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `status` enum('2','1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1', `online_status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0', `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `users_username_unique` (`username`), UNIQUE KEY `users_slug_unique` (`slug`), UNIQUE KEY `users_email_unique` (`email`), UNIQUE KEY `users_mobile_no_unique` (`mobile_no`), KEY `users_username_index` (`username`), KEY `users_slug_index` (`slug`), KEY `users_email_index` (`email`), KEY `users_mobile_no_index` (`mobile_no`), KEY `users_user_group_id_index` (`user_group_id`), KEY `users_status_index` (`status`), KEY `users_is_email_verify_index` (`is_email_verify`), KEY `users_is_mobile_verify_index` (`is_mobile_verify`), CONSTRAINT `users_user_group_id_foreign` FOREIGN KEY (`user_group_id`) REFERENCES `user_groups` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci; /*!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','20250428102452530-ebf3badb1cbac8b9','admin@retrocube.com','$scrypt$n=16384,r=8,p=1$55a/z04ghzvm60cR/w+cug$6IZd8zsvewyijKVxdu5V/xHufcXJUO50ZLP5VHsipHUC+vDuDoX7qhFuKKEexCHJ9jrnsOFX//d7Nv/tc6OunQ','1-8882051816',NULL,NULL,NULL,NULL,NULL,NULL,0.000000,0.000000,'1','2025-04-28 10:24:52','1','2025-04-28 10:24:52','0',0.00,NULL,NULL,0.00,'0','0','1','0','2025-04-28 05:24:52',NULL,NULL),(2,2,'admin','GoGlide','go_glide_admin','20250428102452590-2676da63fce3a05a','admin@goglide.com','$scrypt$n=16384,r=8,p=1$P2QQxN7eMWUjqwBLpVUFOg$ZFEJsNKUKMAYYu2Yy75ROWPaKJfuMgBG7b9OIm5zbyAIviZk8/jBdsoeyY9MHJYAI8uXqMvOqtNjzbqpkkZVUg','1-8882051817',NULL,NULL,NULL,NULL,NULL,NULL,0.000000,0.000000,'1','2025-04-28 10:24:52','1','2025-04-28 10:24:52','0',0.00,NULL,NULL,0.00,'0','0','1','0','2025-04-28 05:24:52',NULL,NULL),(3,4,'user','Dianna Hoeger','Dakota49','Laura_Schiller4','Yesenia_Ratke@hotmail.com','$scrypt$n=16384,r=8,p=1$c5NksrtSoJYVewPMPW3qsA$gwOuKoihn1ILoRpAN0brXjyXqIYL0/cbL+szHa5dTuVaw9X9a/chOFVZh6K9HuTIzr9QFrJ9gSwD61Kp9Sgr4A','+15888679790','https://avatars.githubusercontent.com/u/80418677','Democratic People\'s Republic of Korea','Montana','Vernmouth','42584','158 S State Street',40.745664,-73.995991,'1','2025-04-15 14:16:50','1','2024-05-11 06:01:33','1',0.00,'cus_SDFZ6Jz2rsGNMp','acct_1RIp3xCx8N42fGUa',0.00,'0','1','2','1','2025-02-22 12:16:31',NULL,NULL),(4,4,'user','Nicolas Abbott','Katrina55','Baylee.Treutel','Allan.Waters@yahoo.com','$scrypt$n=16384,r=8,p=1$5jyGEAFSpS/BXpE52Zliow$aSlM2O8S3W8F9ICQQGYzk/Jv30P8G857y7dYuY8lgYVKoJU+2MDZR6coQST0bmUD1r+trHqSFRsWFlxTCnROXg','+10648747377','https://avatars.githubusercontent.com/u/58475179','Thailand','Utah','North Arnoldbury','93630-7304','4738 Bonnie Skyway',40.767198,-73.931729,'1','2024-11-16 03:42:08','1','2024-11-01 18:09:36','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-09-22 00:27:31',NULL,NULL),(5,3,'user','Dwayne Funk-Cummings','Jaren_Shanahan45','Meggie_Nicolas-Batz89','Eileen65@gmail.com','$scrypt$n=16384,r=8,p=1$gU+U7YYRLBNw4bnHhIESTw$DZGuMX4sPqoAbQTchQyAHQUxW90F+1JhOzrvw0f55lIqG7SrsGO9abwj0YjBykSXme7lMmbShFV9m5GNSFnnuQ','+15872105919','https://avatars.githubusercontent.com/u/31205499','Saint Kitts and Nevis','Maine','South Rogerfort','30130-1604','3878 Laburnum Grove',40.745405,-74.057277,'1','2025-03-02 08:04:04','1','2025-04-26 05:19:57','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-03 04:44:36',NULL,NULL),(6,3,'user','Paulette Fritsch','Selena_Kessler3','Emanuel_Hoeger-Buckridge47','Adella_Blick82@yahoo.com','$scrypt$n=16384,r=8,p=1$mvaZYQ9HX9eic8zui23niA$G+8+n9TVdj53TCqamMXlU9I2T0ZvylgeCwpuNvdKkhBwV4oGb+ts/m+fVLHez4+6s9g4Uku/y+MAuRYnm2412Q','+14377825271','https://avatars.githubusercontent.com/u/34737608','Taiwan','Michigan','Lake Kayceemouth','83964','55310 Betsy Walks',40.617544,-74.007118,'1','2025-03-17 07:48:53','1','2025-03-06 14:16:34','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-04-02 15:31:29',NULL,NULL),(7,4,'user','Gladys Lueilwitz','Trent95','Javon.Moen74','William71@yahoo.com','$scrypt$n=16384,r=8,p=1$Zc1hG0xwHR0C1KfglaVt8Q$fVR+mHOrS4w9yZRjHbZHF+uQn4uX7wtf7cikFXl6HAretxipPHLKTRE66YdhP9Fo37e4ODHc6qZrGvwmpgyYOw','+14884177812','https://avatars.githubusercontent.com/u/47855043','Cambodia','South Carolina','Moorecester','57715','3346 Michaela Haven',40.615803,-74.031568,'1','2025-04-28 08:20:10','1','2024-09-05 08:16:25','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-11-03 17:31:49',NULL,NULL),(8,4,'user','Jane Schowalter','Cornelius.Brown18','Jannie28','Marcelina31@hotmail.com','$scrypt$n=16384,r=8,p=1$2v8K3K5QD/Tgev2GYhgPiA$/C8ScGVByZIW2iVqaHXQN6MqBmlDR8t8bFloorwZbHb6WZs2TLNkjLv07TSF9w4bOYnP49N3rRJGdXGjXXPRmg','+19728466352','https://avatars.githubusercontent.com/u/66408843','Falkland Islands (Malvinas)','Vermont','Schummstad','97560-9413','25603 Icie Trace',40.764286,-73.928963,'1','2025-03-26 07:29:23','1','2024-07-21 04:03:29','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-09-19 10:14:18',NULL,NULL),(9,4,'user','Naomi Will','Pearline.Langworth','Meaghan_Witting','Tanya.Legros-Witting14@gmail.com','$scrypt$n=16384,r=8,p=1$PoJ1gPd9hJuMPmrRPRHOow$C34lUecEv5YgpzW+i/GGIiFwKazQ2clJoN7J6buNY+1LsnI6KYa+SIY2WXyRKePZXRkUr2bIxcyjVsYUTLSkdw','+11522302559','https://avatars.githubusercontent.com/u/86056585','Republic of Korea','Indiana','Flagstaff','41696','6301 Lesch Row',40.789153,-74.071028,'1','2025-04-11 17:44:05','1','2024-10-12 00:11:44','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-08 12:27:59',NULL,NULL),(10,3,'user','Mrs. Ramona Mraz','London33','Eloise89','Alize76@yahoo.com','$scrypt$n=16384,r=8,p=1$79AA9Wz6bz8ENCiWB0pAiA$Bm47zx3QTkOeb57/rMMH9Y9bCdWzmWUK9mp1to0iUycnnKf9BN7tJdtnQr3gpNVjubbB1qat90HhNtUuGQoFvg','+17573102452','https://avatars.githubusercontent.com/u/24120197','Turkmenistan','Texas','West Graciechester','32882','25079 Modesto Trail',40.634920,-74.043827,'1','2024-08-25 12:52:12','1','2024-09-29 13:55:38','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-11-14 16:05:30',NULL,NULL),(11,4,'user','Lucia Spencer','River.Bergnaum','Bulah.Labadie82','Cecil.Jaskolski@hotmail.com','$scrypt$n=16384,r=8,p=1$PyBY4zmUAYgIBtG1y0odqw$xfVNkRkPbAiJ3+hw31fA/xuEdf49KaXjSxtDnF0VRFpGgn6tn+fjQ+0D0RCStJiNIEg7DP7h23MaIzdU1mOeLg','+17486047579','https://avatars.githubusercontent.com/u/83384279','Austria','Nevada','Marcelside','95343','63673 Shayne Drives',40.775959,-73.952960,'1','2024-04-30 23:47:18','1','2025-04-20 02:23:40','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-11-29 21:10:25',NULL,NULL),(12,4,'user','Salvatore Glover','Clotilde12','Christelle.Kessler','Linda.Lang@yahoo.com','$scrypt$n=16384,r=8,p=1$vH8NWfRtaMSqQHCe7iLfxQ$5o/HCDZ5uXCuSblvSlmb09NEkUqXjkLeIpEGqaT/+pxwe024VHU6QKvXGwCi2lpVTjvNd0ZBtluR/c4ncos1yQ','+19163698373','https://avatars.githubusercontent.com/u/88392928','Christmas Island','Wisconsin','New Jedediahstead','33047-9087','729 Frami Knoll',40.734012,-74.018416,'1','2024-06-26 10:49:42','1','2025-04-04 06:27:13','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-05 15:11:16',NULL,NULL),(13,4,'user','Pedro Ondricka','Freeda_Block','Duncan17','Madyson.Rogahn99@gmail.com','$scrypt$n=16384,r=8,p=1$1KcjEjhlVu3Ccud2Rh9M7Q$oSc1eBK7ZSJUWPqvhwSm4QSa7w8ea4vB93Fdtw0oRDOHTK+1Aamee/4MCe/lr2/AuqmXFIr+qKpjGlIB6REpgw','+13480644977','https://avatars.githubusercontent.com/u/43725633','Saint Lucia','Washington','Marvinchester','95587-7286','206 Alvis Manors',40.651982,-73.908911,'1','2025-04-15 14:19:31','1','2024-06-24 01:26:46','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-19 10:27:24',NULL,NULL),(14,4,'user','Crystal Beier','Lessie.Hoppe38','Otto.Schroeder94','Hailie_Reichel@yahoo.com','$scrypt$n=16384,r=8,p=1$FuAr9FvVpItbT6CLJNpusg$JwsxmPy5pnW9ZAJrDH84lTckyPEfX6fOesBngDLgvdvKlUpbtDZ1nyP1qyUJT4Seg+p4sw34eAOFBKwB6P6chQ','+10260297209','https://avatars.githubusercontent.com/u/34471534','Christmas Island','Connecticut','Eladioshire','37078-2972','9851 Keshawn Trace',40.693602,-74.015650,'1','2025-03-19 11:32:05','1','2024-12-10 10:20:35','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-04-29 16:01:13',NULL,NULL),(15,4,'user','Daniel Spencer','Ariane_Feeney','Esther_Schumm3','Jimmie.Zulauf@yahoo.com','$scrypt$n=16384,r=8,p=1$BY7YFR6NeRDHs8SRSu1PRQ$B0lCYJttWcM/6IdDS54jdJqb0uv8ZC0CicKfX2+ZkC3ULygLEkfL/3DAGVHeAsD+XHSiIHw9K/bTf19R/SezEg','+19595246047','https://avatars.githubusercontent.com/u/87053305','Canada','Kansas','Camarillo','89346-7382','3256 Lebsack Gardens',40.750211,-73.992556,'1','2024-11-11 07:49:01','1','2024-06-25 22:52:28','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-16 07:37:33',NULL,NULL),(16,3,'user','Juana Ruecker','Eda_Shields79','Jedidiah.Dach','Roman_Turcotte@yahoo.com','$scrypt$n=16384,r=8,p=1$cnNjwuMIrcgPjZ4f9rfgNA$EJ48wfyToJugDkG23p1sjgw7cCY9Wa36mFlewBdAyfU9mxSBU2iNgX4kmO0eBsjEey7tCqY8j7t+8Gv+H42G4Q','+16864475762','https://avatars.githubusercontent.com/u/8124921','Pitcairn Islands','Maryland','Douglaston','72711','40063 Jordan Ranch',40.654048,-74.095646,'1','2024-06-05 11:36:40','1','2024-08-20 18:22:05','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-04 05:54:47',NULL,NULL),(17,4,'user','Anne Roob Sr.','Cristobal.Abbott98','Oceane66','Maia.Bernier74@yahoo.com','$scrypt$n=16384,r=8,p=1$bDFn+ovfuLhBONrcfsX/SA$e9cfL16vtDk5oDU9TxuYsII4jG4mX977yxQKSWR8jqlfHfMXB+5vDNkeah4isc9ytkitqbW5ASMnhFddgGsAew','+11372846893','https://avatars.githubusercontent.com/u/17044759','Colombia','Texas','Fort Kaleighfield','87568-8193','992 Emmet Ridges',40.772370,-74.082511,'1','2024-06-21 11:14:18','1','2024-08-15 03:35:19','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-21 08:18:51',NULL,NULL),(18,4,'user','Albert Ondricka','Orin96','Keara_Beer84','Autumn.Hills-Dibbert@gmail.com','$scrypt$n=16384,r=8,p=1$I4TRHI/6C5ArvPZhasQUzg$X4qLz66gbYMLZ/OtQaXUPGvinlJ4qaBLWX3NtXoGLlfN+Xuwh+agoMFybsbBeXzVKnSOtm29AFpkb/a8pLvs4g','+14788894966','https://avatars.githubusercontent.com/u/15200629','Myanmar','Michigan','Port Yasmeen','59892','88739 Locust Street',40.664485,-73.949296,'1','2024-10-24 01:49:46','1','2025-01-19 21:41:40','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-30 22:06:04',NULL,NULL),(19,3,'user','Francis Schuppe','Shirley.Halvorson','Marcelino.Simonis-Marvin','Jimmy58@yahoo.com','$scrypt$n=16384,r=8,p=1$uIbKd2rNI086X7LdTQ0O9g$fbJxObfGAhlp/4bsgNJqfq1YT1HD6SJoVAOJuL5YUS3XlmL6rgkShu0/Nspq9zPXwdgLEQEc0VZu5Cp1eYf57g','+10423711096','https://avatars.githubusercontent.com/u/20129044','Grenada','North Carolina','West Shaylee','50607','6340 Legros Point',40.660443,-73.964646,'1','2024-06-20 21:18:46','1','2025-03-04 22:28:45','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-04-21 12:56:03',NULL,NULL),(20,3,'user','Dr. Edward Reilly','Aurelio99','Jackie.Kunde','Afton.Conroy68@hotmail.com','$scrypt$n=16384,r=8,p=1$J8HZeqm1iVNs9xffwAv3+w$/SXzg9BxhKwlAOAKj9pY3a3n0IUTSW8Zdpc7MydgHwXt50lRwPFLn/Y9my2IWeIeFuh1fzQ33D3izQ+dq1TXtA','+13615326287','https://avatars.githubusercontent.com/u/67346020','Japan','California','North Aiden','70987-5847','3015 Brody Rue',40.618247,-74.057278,'1','2025-04-14 11:09:14','1','2024-09-10 00:49:39','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-08 14:46:08',NULL,NULL),(21,3,'user','Alfred Dickens','Verda68','Matilde64','Caesar_Powlowski@yahoo.com','$scrypt$n=16384,r=8,p=1$2W20thUOai0DXoGf1Gfmdw$dZLDmrURERP66FBG7coUXjCKc47dZoXus3RMhEb/eRbc2v+J9+aqfmsbPO4QsWxwzLGUhrIMST1a3OqwgR/R2g','+10700013085','https://avatars.githubusercontent.com/u/74504170','Marshall Islands','Montana','Albany','58265-1437','842 Eric Skyway',40.703054,-73.983868,'1','2024-10-16 03:54:01','1','2024-10-14 05:34:49','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-08 07:28:51',NULL,NULL),(22,3,'user','Jeff Thompson','Claudia.Hauck','Nichole34','Jacynthe.Sporer45@gmail.com','$scrypt$n=16384,r=8,p=1$M4+KsKWZN+/F14k/kj+ekQ$35skVsBaE3TkcK1oqs7dyiHeeSMbXhitxDBWUYulhltyOCSYM51/x9AEby6EnM/MVVapPLtDphlwNSc3TL4+fw','+18777415456','https://avatars.githubusercontent.com/u/74669502','Guatemala','Missouri','New Carson','79104-6987','3324 Liberty Street',40.754814,-73.934301,'1','2024-07-11 03:50:26','1','2024-09-24 08:53:27','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-01-30 13:59:48',NULL,NULL),(23,3,'user','Claudia Blick','Ebba_Treutel72','Maurice.Upton','Bonnie99@yahoo.com','$scrypt$n=16384,r=8,p=1$+IIYyZUm0BjjAkdMk70y+g$Qdd9sjfjaOoZMXedC3wa4iaBSNjpV2q1DSUlT9qJg2rk4auBX46lMl/K3XN3Bc0Oah090fjb0ZR0hy938CPELg','+15055126054','https://avatars.githubusercontent.com/u/53911268','Guatemala','South Carolina','South Jammie','03430-3739','20092 Cedar Road',40.617842,-73.906198,'1','2025-04-20 05:40:15','1','2024-08-20 06:30:44','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-04 14:57:52',NULL,NULL),(24,4,'user','Ethel Senger III','Heber40','Yessenia.Satterfield75','Liza.Wiegand40@gmail.com','$scrypt$n=16384,r=8,p=1$k+O/Mq7s/RUikDC6IwYiaQ$fR7dH6XwiCTkDoO8AEpP6/mhDx+igUCoopVLFpikFbzb0cgeHDAPtj5XSvDwvgVZmI1s+ilan2pi+DAGw1Yqyg','+16722347525','https://avatars.githubusercontent.com/u/60565239','Bhutan','New Jersey','Ontario','15754-4181','5688 Kozey Rue',40.801952,-74.035307,'1','2024-10-28 06:58:38','1','2025-02-20 12:20:15','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-09 22:33:50',NULL,NULL),(25,4,'user','Henrietta Romaguera','Yvette_Heaney','Omari38','Emile_Cole97@hotmail.com','$scrypt$n=16384,r=8,p=1$jb7IORDhXjq4rV0Ktc+e5w$er1+2NFx6k4Nte7RbuZDlW0qqUvB2TW60UenjixzTRphgc1elGCradDTAvBmJrxIaqF7IXPsb7n74oxaHBAuSQ','+15081710290','https://avatars.githubusercontent.com/u/64150096','Seychelles','Delaware','West Babylon','82810','286 Alex Village',40.714579,-74.047641,'1','2024-05-22 03:48:55','1','2024-11-04 20:53:20','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-11-20 17:26:29',NULL,NULL),(26,3,'user','Jamie Quitzon','Devan44','Althea_Kuhic','Thomas.Huel@yahoo.com','$scrypt$n=16384,r=8,p=1$6bRLLGo5LsVLYHEXzIQU4A$jHL37hNfowxczj2MukKTPaQlc/4Y+tKzxPPnIYw5p87Jwl1+HS3KFlmIv+IxfdUzjrwM2L3XSbBWKXp2Zx6TbA','+17395906525','https://avatars.githubusercontent.com/u/67124699','Liberia','Florida','New Natasha','99000-3313','50088 Monique Forge',40.625579,-74.083023,'1','2024-05-15 10:55:09','1','2024-11-30 08:10:39','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-08-23 16:27:44',NULL,NULL),(27,4,'user','Annie Roberts I','Kaycee_Bogan27','Merritt37','Joaquin.Hilpert54@yahoo.com','$scrypt$n=16384,r=8,p=1$HMdgCD7ClQ4VkLIwDrMWBQ$MMmWz/XVzi/gea33+uw/YFeYgYRO7Vo3FE6sL5nOCUVuORJrUkKwBD1T4h6pnUjHryA/BAbnwN+FFHopxVtJSw','+12554634440','https://avatars.githubusercontent.com/u/38446860','Aruba','Oregon','Sunnyvale','69260-4413','20154 Howe Shoals',40.669790,-73.917390,'1','2025-04-08 15:15:14','1','2024-07-22 21:09:51','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-20 08:32:38',NULL,NULL),(28,4,'user','Alvin Rolfson','Lavonne90','Carlotta.Kassulke','Edison73@gmail.com','$scrypt$n=16384,r=8,p=1$1d4v7JKcncsAPSa5Bmyl2Q$6N1VbZ0OC/pAoSVA1nNyvl4KKBGTd71/+b3sLKCi+O6o29x6+ooGImzwghfwKrkgtb7xOgCzdCyqqBYr5bCNKA','+13275999307','https://avatars.githubusercontent.com/u/20192450','Qatar','South Carolina','West Kaleytown','56253-2567','95480 Taurean Highway',40.773913,-74.076663,'1','2024-09-02 16:46:28','1','2025-01-14 20:26:02','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-08 04:22:51',NULL,NULL),(29,3,'user','Beatrice Heaney','Lysanne_Koss-Reinger26','Kirstin_Mraz','Amya_OHara85@gmail.com','$scrypt$n=16384,r=8,p=1$BA7v5xhTdfX/D+WsOL4Q8A$g4EzDH3Aa3LYTmWP27rykUI59g+Vwe1/GgATN0ExkNb+MUlZoAvOlh0oyRS1Ec6nwPYQ7S0K+vAxLaXxruW3wg','+15765136090','https://avatars.githubusercontent.com/u/26602915','Turkmenistan','Virginia','Kuphalborough','70615','201 Park Avenue',40.770095,-73.926910,'1','2024-12-11 06:21:26','1','2025-04-01 21:25:53','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-17 12:14:11',NULL,NULL),(30,4,'user','Leon Schneider','Cordia_Steuber46','Lewis_Larson-Daniel','Glen_Lynch@hotmail.com','$scrypt$n=16384,r=8,p=1$JMi0/IOKpG4WvYNZjun0BA$m0Tbns4sT1ZZW5BqFAHMtbC20K9lRFUYIHCMlr8MfWVvGXQ0xUR5KzUQnhBA1MbA0cgl2uUAhuFOxiS46rtz1A','+15167384050','https://avatars.githubusercontent.com/u/55302532','Bulgaria','Maryland','Veumboro','30452','1743 Shyann Mountains',40.667647,-74.039158,'1','2024-12-27 17:36:55','1','2024-06-01 07:32:18','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-16 00:30:47',NULL,NULL),(31,4,'user','Myron Block','Karl33','Rogelio.Lowe','Clemens73@yahoo.com','$scrypt$n=16384,r=8,p=1$qJP05cYXP1GvAtEwd1M1Qg$zn3idBo4239+jKiOoHnSqo0/Tag0Q1qedSPTBNDhNAThU3AT2gwONec5gYqyaV90mz1IMLy8sqDTQAmXOVkfzg','+17265193646','https://avatars.githubusercontent.com/u/2126865','Cote d\'Ivoire','Missouri','Aurelieshire','99279-1259','20705 W Oak Street',40.665494,-74.076487,'1','2024-08-01 19:20:20','1','2024-11-25 08:06:42','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-30 03:17:26',NULL,NULL),(32,4,'user','Brandon Schneider','Barbara_Friesen','Deven28','Lazaro.Armstrong@yahoo.com','$scrypt$n=16384,r=8,p=1$YHX0pYP/9qjglIk5WqCe2w$5IdKxJ7O1HWX4p8Mzvzn+rmtHsLHyDVSQiH1dZO0CTZBkaf14iWABlKSTK7mhVnRwGKwcWXGOLMD4ZYGQV2h5w','+14817675060','https://avatars.githubusercontent.com/u/98689480','Nigeria','Connecticut','New Kadin','03864','61146 Connelly Spur',40.745070,-74.098536,'1','2024-07-20 18:53:51','1','2024-10-29 17:10:28','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-16 17:33:10',NULL,NULL),(33,3,'user','Bobbie Denesik-Russel','Kayley.Lynch5','Carson13','Catherine57@gmail.com','$scrypt$n=16384,r=8,p=1$0/4eDoHHb+2NT29Q7PFmdQ$LtmEFZZI5og9a3iGhBo9GetQmx15PoH5ermxdIfzeqBKw77VytL+UQ9Bd2JByUg3Z7x+sd9+8OaZoAegg/91tg','+19901651094','https://avatars.githubusercontent.com/u/89700472','Gambia','Texas','Dickicester','87043','300 Marietta Walk',40.706332,-74.024370,'1','2024-07-15 19:22:25','1','2024-06-11 02:25:59','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-02-25 08:03:33',NULL,NULL),(34,4,'user','Carol Stanton','Noel_Rath','Bennie75','Gabriella48@hotmail.com','$scrypt$n=16384,r=8,p=1$xfdbZLnzV1PQfxLM1pCa5g$PYmVmqS0eeHARCq3oWw5ZOTIvrLo0CkJ/rg6lj240EJjp0vs4/gzkyjFXvzcUH9Am8awyE2VrwXazkNat8+Vfg','+14842878330','https://avatars.githubusercontent.com/u/29975568','Dominica','Alaska','South Jordan','47088','75143 Leatha Bypass',40.801424,-74.083352,'1','2024-09-25 15:32:34','1','2024-11-12 08:50:08','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-18 07:48:51',NULL,NULL),(35,4,'user','Ms. Laura Hessel','Keely3','Ayana.Ward','Margarette18@hotmail.com','$scrypt$n=16384,r=8,p=1$/aIwfWwK/ZZwaUAQ8aFnuA$50Z2jm4YMsHRjZKyMULXo2vjygp2+wV5nBGEdE24Shli42ng+0J/om3t3Vw3spqP4ndDaxEylBwwiOH7auP09Q','+16306728155','https://avatars.githubusercontent.com/u/61138348','Mongolia','Texas','Johnstonborough','01630-4959','4880 Torp Manor',40.796608,-74.056521,'1','2024-12-19 18:06:51','1','2024-07-24 18:30:58','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-08-15 04:54:13',NULL,NULL),(36,4,'user','Gerardo Morar','Alberta_Klein41','Bailey.Wuckert72','Patricia_Renner@gmail.com','$scrypt$n=16384,r=8,p=1$r6EWfYi7+VFr0VbjjU5O9g$jN+GdxZlT9ifcRbjTHlLDw/F/qi6kQqdlAI/S06l5nV0kSYrfiS2OUT27ynb9MRLvkyx7t1E596b9zloZwhxDA','+16441380950','https://avatars.githubusercontent.com/u/77117841','Guinea-Bissau','North Carolina','Lake Alexa','11228-4459','87057 Martin Luther King Drive',40.622936,-74.088821,'1','2024-07-25 00:50:26','1','2025-01-24 05:36:39','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-30 08:55:28',NULL,NULL),(37,4,'user','Sylvia Emmerich','Anissa_Durgan-Torp80','Alanis.Williamson81','Reuben_Graham@hotmail.com','$scrypt$n=16384,r=8,p=1$bNsJ7WVXcAHRSlBfHT8gsA$B84K/fEjuUszCAMVuwrWIV8N7xQlkvn51H2xAduRG7qzYv1d+fcQiVoXoxPS2QsoTnBP8KPmxRxq1fvDf+Zgtw','+12734944506','https://avatars.githubusercontent.com/u/9117418','Albania','Texas','Aliceberg','29890','739 E Church Street',40.697516,-73.998572,'1','2024-09-20 10:17:00','1','2024-11-13 23:12:53','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-15 01:58:35',NULL,NULL),(38,3,'user','Olive Dietrich','Mollie.Fritsch','Hilton35','Turner.Waelchi18@gmail.com','$scrypt$n=16384,r=8,p=1$8WZOix7Fm68rlumb5rBQUw$pPNTSUONEN2kJmPhck37IlC977uGrLpy9eDUozOWivcYcZb9m2rn392pw7giLX2gu1C/7GCYz8vHFX1c7Dv/2g','+16097650693','https://avatars.githubusercontent.com/u/41869390','Brazil','Missouri','Port Aryanna','93662-9526','46103 Anastacio Inlet',40.795720,-73.977474,'1','2024-07-21 14:51:30','1','2024-12-19 23:06:13','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-11 11:14:26',NULL,NULL),(39,3,'user','Neal Schamberger DVM','Jordyn.Russel','Camron_Funk5','Jerrod58@gmail.com','$scrypt$n=16384,r=8,p=1$tM2K3qkCwyZ+CzY4SrR3dA$4Rs29qvy/sf9/egzrgfxdIMLJyOueS1r5mfXUNAhzcVGdfjSF4I867IZKYvkR2Lwu5gUdVGTMTaQM7c5j/IPaA','+13664265259','https://avatars.githubusercontent.com/u/67042670','Kyrgyz Republic','Hawaii','Reichelland','69342','49053 Grady Route',40.615102,-74.008715,'1','2024-12-01 02:27:52','1','2024-05-03 04:01:31','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-25 10:56:16',NULL,NULL),(40,4,'user','Susan Heaney','Margarita_Buckridge','Abby37','Reginald_Sauer@gmail.com','$scrypt$n=16384,r=8,p=1$Jpq1SgzfqE30Z0nU/RtI3g$2rZMFXkP+Ng0pIiQ6wgbFcmgP4hr6y4D5NxZ3CaGuEKOWJ+LPqydH8XllCN0l5DyPVHKr1pytAuIepz2mCTisA','+16484561623','https://avatars.githubusercontent.com/u/51643618','Egypt','Idaho','West Macieview','63528-8032','40078 Sanford Meadows',40.692689,-73.966709,'1','2024-06-14 15:58:38','1','2024-07-02 09:39:02','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-10 11:10:00',NULL,NULL),(41,4,'user','Byron VonRueden','Stephon27','Emmet_Conroy41','Elmore.OConner-Jakubowski83@gmail.com','$scrypt$n=16384,r=8,p=1$ih7vi+U60YC8G0X293FYOQ$y2gmyKbploX+V3MdiC3J7lcwbgMXCEWZ3TJDKsfNVn3QaljxtXLfHMKjUIvXZZ11Zo8S+wg6oIGlY0bRb/8aJg','+10437891064','https://avatars.githubusercontent.com/u/37172045','El Salvador','Montana','Nyahland','76125-5906','5381 Isac Village',40.802108,-73.993656,'1','2024-06-30 03:08:53','1','2025-02-12 23:17:13','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-03 07:44:03',NULL,NULL),(42,3,'user','Dr. Alexis Considine','Kelly52','Estella57','Tania43@hotmail.com','$scrypt$n=16384,r=8,p=1$DT57XtA/YdctRM0H1j8kWg$m/9+pR1l1pSChlUoug44w1K+uIlKymv9tcfqj3kBT++mhFzWnPduzEw3bYXSvmBUsWJnAr8D9UDAt9AReAMWMQ','+10612706356','https://avatars.githubusercontent.com/u/69756521','Latvia','Michigan','Fort Joana','01446','409 Shakira Burg',40.684286,-73.918429,'1','2024-05-06 18:00:23','1','2024-07-31 08:17:11','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-04-13 04:29:02',NULL,NULL),(43,3,'user','Kathryn Ebert','Keaton_Kemmer','Kylie.McDermott25','Travon33@hotmail.com','$scrypt$n=16384,r=8,p=1$tTI6UDFRODG3NebDqF+U+Q$LueMPIsj5v9XbJZd2tPMGA2EAAHVqR1TOzUZ/WM1V7f8/Mct5lmf+3weAqsfFdqJ7rfcs7y+JbbtzyOB23jcBw','+15708237087','https://avatars.githubusercontent.com/u/21542164','Greenland','Arkansas','Fort Onieside','97495-6173','5979 Grant Street',40.713415,-74.077814,'1','2024-12-01 06:27:44','1','2024-10-30 08:35:08','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-05 18:47:14',NULL,NULL),(44,3,'user','Dr. Sam Rowe-Collins','Carol.Beer1','Adam.Padberg','Jaylon.Medhurst@yahoo.com','$scrypt$n=16384,r=8,p=1$cJVDOpnAmcGoGzn2KIjkOA$HeVReadhGhGX9vTnf4nDuL1W26TcacTr1H3lTBF8B6fIZfxkf4dDsGsYJRzJBmi+CksxKaX9B9ySs2IN6ueQTg','+11399697708','https://avatars.githubusercontent.com/u/7945661','Georgia','Nebraska','Idafield','35290','1081 11th Street',40.724003,-74.002976,'1','2024-09-21 08:45:16','1','2025-01-20 13:30:47','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-02 19:00:11',NULL,NULL),(45,3,'user','Ms. Bernice Collins','Leanne_Jacobi67','Samanta_McGlynn','Salma96@yahoo.com','$scrypt$n=16384,r=8,p=1$mjxjcOX08D+cQNBhV1yHvg$PkQt0XJfEfspEKlR+5aOU9yB7bmcB35EiQvcqq4GmWv7OU2lL1Eel2OFJV0V2w0JlOOwl1554CaX70XX8OkJvw','+14029802969','https://avatars.githubusercontent.com/u/96045612','Togo','Nebraska','Lake Isaias','17900','2728 Macy Plaza',40.795457,-73.985315,'1','2025-02-19 21:37:08','1','2025-01-22 16:26:13','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-04-29 23:37:52',NULL,NULL),(46,3,'user','Natalie Flatley','Vivien_Carter','Cletus_Carter27','Amparo.Waelchi34@gmail.com','$scrypt$n=16384,r=8,p=1$EgaN9LgYQe8Ps7gKlaKbZg$CMUB8nnoJpkvgAuH0NqTG5hKoEYq1oZZ27ZcZCGj6GNJk9Ppx1vzufvHKFEu3suBIQ62gz8hMaNVtS9A/VF6Lw','+18176686203','https://avatars.githubusercontent.com/u/92126265','Solomon Islands','Connecticut','Bozeman','50689-7869','74298 Irma Court',40.683719,-74.002239,'1','2024-12-19 22:26:46','1','2024-09-19 16:41:20','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-17 10:09:17',NULL,NULL),(47,4,'user','Anne Kunde','Wyman.Bosco','Riley_Daugherty','Madilyn.Bauch@yahoo.com','$scrypt$n=16384,r=8,p=1$FttL96chab2g8XRRxELQYg$TkPyHSfecFmJggYmWNSXprq3KdrNgoxKaRd6gjBfKaocdNrxfWQmiLy3NudM2wJdvpvUNomcF6ZGaF/9OKg4ww','+12187551152','https://avatars.githubusercontent.com/u/39834454','Curacao','North Carolina','Aliciaside','99231-7133','807 Bernhard Greens',40.752993,-74.088017,'1','2025-01-19 20:57:52','1','2024-12-01 07:26:24','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-28 15:47:43',NULL,NULL),(48,3,'user','Bethany Kris-Zulauf MD','Gerda39','Preston_Senger','Nick13@hotmail.com','$scrypt$n=16384,r=8,p=1$M3kc9zo8joF70FpeQKFGZA$sGoOkDTYvuQ+wU2e8/lsuwAD6YUBZpF1WT3Y/3G89uuOB4ukY8YQG8ubiiTY9AraSC0ymCC9Nu57ewEC8ksohw','+12325193006','https://avatars.githubusercontent.com/u/49254939','Ireland','Wisconsin','Brendanton','99238-4833','4126 Ritchie Gardens',40.725501,-73.907075,'1','2025-04-12 00:09:46','1','2025-02-28 07:58:41','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-19 11:59:28',NULL,NULL),(49,4,'user','Dora Jacobson','Nyah19','Gilbert_Upton57','Demarcus.McCullough79@hotmail.com','$scrypt$n=16384,r=8,p=1$4rTfIoS53nB4l0FqokXeaw$A+K5C4uNQTWCdBHGNWeS/7mbKrNL26f/mq97xjebiWmwCZZhC5uI4eEehigJkkAz1mPA8yz8BK2CLEuHfXQSEA','+15716106069','https://avatars.githubusercontent.com/u/64412777','Marshall Islands','Ohio','North Mary','60841','9730 Reed Loop',40.791506,-73.971114,'1','2024-10-19 23:10:23','1','2024-12-08 12:34:14','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-23 19:37:02',NULL,NULL),(50,3,'user','Pamela Hermiston','Aric50','Thea_Ortiz27','Jermain.Reilly-Walker27@yahoo.com','$scrypt$n=16384,r=8,p=1$QrfERDYrWw3jcWu1aVhX2g$KG0zYFlt6FlLB2Cjl8/PlrWsJSF81VhEIjQIsLPvJwWiXmWuM0HKqpBZiOPqvR5LQOsb2DmB02bBWQ4OuAi8xA','+10305851594','https://avatars.githubusercontent.com/u/43171033','Lithuania','Colorado','Costa Mesa','11561','99003 Prudence Estate',40.640268,-73.920754,'1','2024-06-30 05:18:08','1','2024-12-01 23:06:41','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-30 14:30:10',NULL,NULL),(51,4,'user','Juana Ziemann','Elyse3','Thad.Fritsch10','Darrick68@hotmail.com','$scrypt$n=16384,r=8,p=1$Zwmll8mTiGPUHVQ5KB5mIw$KzaPjeYXlOvISdichhu3CNvw1TOR2DgPnHBTNBepGwWqEegDi0We0L2eTDQN/dKB+KAKLT3lOR3NHg2paxj3Eg','+11788194076','https://avatars.githubusercontent.com/u/28367940','Portugal','Rhode Island','Francoboro','41633-7208','830 Bogisich Forest',40.626619,-73.985169,'1','2024-08-02 15:30:01','1','2025-04-05 09:43:46','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-16 10:12:37',NULL,NULL),(52,3,'user','Alison Sauer','Wayne.Nolan62','Irwin.Hayes','Van18@yahoo.com','$scrypt$n=16384,r=8,p=1$J0HCKnEtf9NWAKTQM497SA$Zejw0TGuq3a6qDEBiWp0pXjq536xPK0kJLM3zNCOQ6ZYaKwXQMsKHLuORlXyFxe6gcIAHhb71j80ZVVhCt84Ow','+14387291615','https://avatars.githubusercontent.com/u/73714523','Bhutan','Virginia','West Chelsie','77714-4369','517 Ebony Union',40.739210,-73.906123,'1','2025-03-14 00:33:07','1','2024-12-17 00:10:13','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-27 13:10:33',NULL,NULL),(53,4,'user','Lucy Glover','Karina.Bruen','Kaleigh_West30','Nyasia.Schuppe1@gmail.com','$scrypt$n=16384,r=8,p=1$2c/mFXEaOTcKXN2aF6ydSg$yBg/7MQDQCw04yMCAVc9hUW5l/wNAXIuQaTm5yVChVuUhTRzCuKDCQZHEUkhyYoC38SlGbj4v1Mc+W2R8JopHw','+14165537190','https://avatars.githubusercontent.com/u/96989703','Andorra','Massachusetts','Harveyside','41745-9530','3623 Morissette Ferry',40.716511,-73.995198,'1','2025-04-12 17:10:15','1','2025-04-01 07:12:36','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-27 00:38:03',NULL,NULL),(54,4,'user','Earnest Balistreri','Naomie_Sauer81','Brandyn.Leuschke68','Torey_Greenfelder-White50@gmail.com','$scrypt$n=16384,r=8,p=1$zvbECLHCI8Yv4unWI3zXEw$JutzNXt7E3v9s0tMKzxIpaaM+UcMd8ZSZ9z34Gh0IQGbfgGlQM9au47o5GweA/9/I7tGSR2TBt9zk6FbV2VJ5A','+15866871768','https://avatars.githubusercontent.com/u/41323630','Central African Republic','Nevada','Lonzoworth','06956-3918','133 Hand Street',40.726898,-74.046689,'1','2024-09-18 21:09:30','1','2024-10-04 01:14:04','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-04 17:29:48',NULL,NULL),(55,3,'user','Mrs. Lee Ritchie','Salvatore_Heathcote0','Eloisa15','Zetta_Ratke@yahoo.com','$scrypt$n=16384,r=8,p=1$frl8kPHwH1QBVV22ab7ajQ$k+VcVJGeZCLBJGfQ1upSP20DunxtADnpVE1FjbJA490zmdaKdmk7wYdXEf6MC198OwnNm7/mr++AKvYrlbMcjQ','+19344572809','https://avatars.githubusercontent.com/u/6311447','Falkland Islands (Malvinas)','Kentucky','West Allis','53956','426 Turcotte Junctions',40.766775,-74.033880,'1','2025-02-26 10:02:22','1','2024-05-02 00:42:57','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-08-21 00:18:14',NULL,NULL),(56,4,'user','Dr. Rosemarie Gorczany','Gavin.Kautzer2','Mireya41','Omer.Frami76@hotmail.com','$scrypt$n=16384,r=8,p=1$MpAO/v55FyGpnB9hnnXrQg$wpNpRSFiWX/8ugLkhADqGS1GrUvNcb/zHJ+iLW8yilWzahIyqEMHdcjryH4YJmLa5I8L3s9bFGjG5EXah90Npg','+19652196467','https://avatars.githubusercontent.com/u/62649220','Burkina Faso','Georgia','North Jermeyberg','72454','550 Eve Brook',40.660230,-74.015212,'1','2024-10-10 05:02:38','1','2024-10-28 10:30:45','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-08-27 19:05:33',NULL,NULL),(57,4,'user','Anthony Wolf','Rodrick63','Granville_Streich','Emery.Reinger@hotmail.com','$scrypt$n=16384,r=8,p=1$7nvxmVGccUEbeZUvb+nF6A$UqDJkxGeJxZ59VoBPyGf8n1rbMfYW3jJOlvK5W/+2j87zl15kHHqVeciF4PFc1FtUKToCXH+2CiGqdEet5FLkw','+17529265168','https://avatars.githubusercontent.com/u/14753613','Bulgaria','Louisiana','South Astrid','35096-6201','55938 Ara Pine',40.653417,-73.955687,'1','2024-05-28 05:37:51','1','2024-11-21 07:40:11','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-12 02:25:35',NULL,NULL),(58,4,'user','Francisco Welch','Tiara.Moore84','Karlee.Block','Danika30@yahoo.com','$scrypt$n=16384,r=8,p=1$PmMyBUMK0o9D5ta55b51BA$NK7VrVpMI9vp15D61X/T1L07HWrxUx3l34X2jYCKVCa4liM7JuAcdmQ0IsvwlMio4Et02Q47c2RdVckbpEP+Hg','+16874907047','https://avatars.githubusercontent.com/u/98715621','Libyan Arab Jamahiriya','Maryland','Klingville','14024','5529 Connelly Forges',40.703157,-74.005658,'1','2025-03-28 03:31:33','1','2024-06-15 13:03:13','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-08-02 09:14:33',NULL,NULL),(59,4,'user','Wm Weber-Littel','Pedro.Marks','Cloyd92','Dustin_Sanford@yahoo.com','$scrypt$n=16384,r=8,p=1$8F5ucysEhCwVC5XWzAedEA$nm1Pc2lMQ95U6Dcvchaf1EjyXoWxy04btAVA9gVelyc3GrfqPBqL5iFDDsewM+ilxdsSvpF1i059emLjhiALOg','+10119779499','https://avatars.githubusercontent.com/u/23747783','Argentina','Arkansas','North Leslieview','08986','5143 Crescent Road',40.716838,-74.004040,'1','2024-07-20 19:26:29','1','2024-07-08 23:08:55','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-01-13 07:39:02',NULL,NULL),(60,4,'user','Dr. Gene Friesen','Lillian46','Gerard67','Kenyon.Collins3@hotmail.com','$scrypt$n=16384,r=8,p=1$GVDtbe2olotYVuhMqJ1AQQ$BvEkM0XFU5U+o7Lfr5qvc/aSCu+5PgwYnYPOd0s4eOdvYMfqMKJD/zNJHD1rlKk990fPdyCCWw7zTiqZA3+/5g','+16789914965','https://avatars.githubusercontent.com/u/29557488','Solomon Islands','Idaho','Des Plaines','16940','5830 Edward Street',40.782945,-74.050884,'1','2024-08-14 08:48:35','1','2024-08-18 18:07:45','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-08-06 03:07:41',NULL,NULL),(61,3,'user','Lucille Raynor','Mara_Quigley','Rey20','Guillermo.Hyatt@yahoo.com','$scrypt$n=16384,r=8,p=1$Kv3SD9+U6Ht92rwOwrcoIQ$ju0RAD3jPWmYoA5ZrnyjkB+kgFk1db/hoGHuP3gVSDOxlesrAR0U0v6/wxKL+IHQ7Fnj6yz/2npIPojoC7tX3w','+14061344328','https://avatars.githubusercontent.com/u/38536578','Ecuador','Maine','Emmerichside','52750','93488 Price Pass',40.694161,-74.095790,'1','2024-12-05 09:15:09','1','2024-10-01 04:16:08','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-04-10 21:13:02',NULL,NULL),(62,3,'user','Nicholas Johnston','Boyd56','Manley.Kshlerin77','Benny_Reilly@gmail.com','$scrypt$n=16384,r=8,p=1$olAvLsgNdB2eaOKhrNhvKA$8yokZzh8M3k9YwTxilxKmHtTzGOop/9ACkjEJQu2akxe0Lblu5evuRJJxEXg7Ct+YBwGpL1x53CgjNrJsCNNLg','+12385848710','https://avatars.githubusercontent.com/u/50856312','Qatar','South Carolina','New Rosalynworth','87867','54783 Trevion Avenue',40.665996,-74.065117,'1','2025-01-11 06:35:08','1','2024-12-06 16:48:04','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-18 12:18:38',NULL,NULL),(63,3,'user','Enrique Casper','Leonardo_Schoen64','Cletus_Mayer55','Marisa_Simonis11@hotmail.com','$scrypt$n=16384,r=8,p=1$9mRJl4rB0YKhtHIshy38Qg$FkIDMv++PaGLd832y9aFofYh8LXHNpA/w4GF9ETjnytgmAaK3IFRWjHng48tAzpju6AtdrZu9FI4i0h5EIrvog','+12236219044','https://avatars.githubusercontent.com/u/41631122','Jamaica','New York','Aufderharside','16727-3511','97265 Andreane Pine',40.708849,-74.030389,'1','2024-08-31 16:57:37','1','2024-09-21 20:20:31','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-28 23:29:37',NULL,NULL),(64,4,'user','Lawrence Zemlak','Antonina.Von31','Spencer85','Rita.Ratke60@gmail.com','$scrypt$n=16384,r=8,p=1$ZxMXOfQnWxR7h2Dx8vxhbQ$t3JN5lo9MRafTkX8CGGuHe6EVTXsVRGn39LDqFwny+tlNoJvsZdg2uF5SkOc+f01UbB7/T2yS6db9ZrJDBI+9w','+18656789084','https://avatars.githubusercontent.com/u/89548345','North Macedonia','Illinois','Enaton','43034','6613 Kestrel Close',40.687217,-73.997298,'1','2024-07-27 06:26:01','1','2025-02-10 02:29:40','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-01-24 06:52:25',NULL,NULL),(65,4,'user','Eula Goodwin','Lee_McGlynn-Mann','Lilla68','Brendon30@gmail.com','$scrypt$n=16384,r=8,p=1$0aEKwXs53u1pXo+mC4XtzA$OAarHnY6XsSSDmSa0Q9n4Q1mCczdTvPuoIMNh4oNJYal8+3q97qOaSPgSIcu7G7es1uM0Ey3Z+fpzN4Oxij8Cw','+13819522797','https://avatars.githubusercontent.com/u/64429278','Jordan','Maine','Lake Angel','98935','6571 Maci Harbors',40.618720,-74.067544,'1','2025-04-03 12:30:52','1','2024-07-26 21:56:40','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-01-03 02:21:09',NULL,NULL),(66,4,'user','Mr. Alvin Konopelski','Quincy_Hirthe21','Teresa8','Jermey_Wolf@hotmail.com','$scrypt$n=16384,r=8,p=1$d9p3WMDoUNLjlBsi6ze7fQ$d8+tkCuhmvDK9pO4UaafklCYqKKDeAQ23oiVGp73JpnkpF7kiLUGm2KYhqDPNKnAXDygOb75+oVhaz1PLvp35w','+10731256630','https://avatars.githubusercontent.com/u/44014496','France','Tennessee','Krajcikview','92226','829 Meagan Bypass',40.691684,-73.914749,'1','2024-10-26 05:28:37','1','2024-06-14 20:00:44','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-25 07:13:04',NULL,NULL),(67,3,'user','Dr. Meredith Miller','Icie51','Erin_Hegmann','Keyon64@yahoo.com','$scrypt$n=16384,r=8,p=1$FK6Az+6lFYmklzb2UqzQyw$uv2YkhU9qXG3ou6wMUKblozg2EsFynS4MEc/R2H2DY0eUKU164dRjqp9biCVUW/SytI5QJH04oAtPQk8wNYTfA','+15106308495','https://avatars.githubusercontent.com/u/37376913','Holy See (Vatican City State)','South Carolina','Janisbury','89520','644 Balmoral Road',40.674058,-73.966082,'1','2024-09-07 09:48:34','1','2024-05-25 17:53:16','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-20 16:46:50',NULL,NULL),(68,4,'user','Velma Luettgen','Kory.Block','Reid_Zboncak65','Blair_Ankunding76@hotmail.com','$scrypt$n=16384,r=8,p=1$2tmgGIW6xjJqayIu9M1HGA$P/GTaUNS8FW6nqOUfJlOSpj2qNBEp8xuTTeGGn14Xf2emPvyboKbz6/MS79bDf6QliB3nm8Fk+V4qqdBnie6Jw','+12583735757','https://avatars.githubusercontent.com/u/9352749','North Macedonia','Idaho','Kissimmee','41155-0016','57875 Park Avenue',40.679859,-74.056724,'1','2024-11-25 21:11:17','1','2024-09-12 13:41:56','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-11-10 21:54:27',NULL,NULL),(69,4,'user','Sherry Zemlak','Hans.Dicki','Noemie_Stehr31','Tillman_Ledner@gmail.com','$scrypt$n=16384,r=8,p=1$wyS57gTfiZbbTz25pFh7iQ$4W9phHYmF1lu/xhOvofPSXUy5wkeIegwuMR5GMstin3wvaZ/zFQOMyQCx38uOfs0yNxP4leKKqNb7/CeQM3xVg','+16866910550','https://avatars.githubusercontent.com/u/97958075','India','California','Dimitrichester','70010-1894','6109 Luigi Branch',40.674518,-73.925009,'1','2024-05-17 11:10:05','1','2025-03-25 18:11:41','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-02 19:31:13',NULL,NULL),(70,3,'user','Colin Schneider','Foster_Stracke','Garret27','Brook68@hotmail.com','$scrypt$n=16384,r=8,p=1$WZqDFyQtWTfd11J+7v2MAA$KBqDaANAKXtKWr2TsBYotfgMeVdO9Hdqe9L8mXCDyBb7z15zTePWa97ikSovPXbSpjN6xYy9Z2xmXoGOuOAk3Q','+14688773712','https://avatars.githubusercontent.com/u/86645879','Papua New Guinea','Connecticut','Bayerview','94099','11240 Albany Road',40.712766,-74.008492,'1','2024-10-13 20:41:03','1','2024-08-09 16:49:07','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-16 11:49:54',NULL,NULL),(71,4,'user','Christine Okuneva','Cathy11','Lessie_Barrows45','Gerald_Cormier@hotmail.com','$scrypt$n=16384,r=8,p=1$tG65lMiyZ5Si6ZM4Y0RPSA$1KEHUk1mBpndgEAUgXAIJv3vYpHXZHCSOfJ5A/3H2q8mp2KhyFZWLL5wQyGvtsPT+4YSqkXTHaT10OdDw5yVhQ','+16520200393','https://avatars.githubusercontent.com/u/43019892','Cocos (Keeling) Islands','Nebraska','Jermeychester','49394-5763','337 Station Street',40.643967,-73.968253,'1','2024-08-02 14:21:52','1','2024-06-24 07:49:49','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-09-16 18:54:44',NULL,NULL),(72,3,'user','Darren Stark','Diego_Konopelski','Valerie80','Mauricio.Feeney-Mertz13@hotmail.com','$scrypt$n=16384,r=8,p=1$rnc33HklYCMxFpafkMqzrg$AWRlPGtC9KPTU878AmdU58bnNCCBVStY83HCG9koxREWX/dE2UwQ+nIUSf21fBiaz+drHvrly92Td+wO47Njhg','+13417094269','https://avatars.githubusercontent.com/u/71838562','Mauritania','Virginia','Port Rayfield','28939-5816','8629 Jordane Corner',40.717938,-73.917157,'1','2024-07-30 05:40:46','1','2024-10-06 06:09:08','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-06 22:18:37',NULL,NULL),(73,4,'user','Calvin Hermann','Sister.Satterfield58','Jovan_Green','Nathanael54@yahoo.com','$scrypt$n=16384,r=8,p=1$U2kXePp6WCRPl29pH3VPFQ$decoxv4jlI198cPmoQRTi5cT9IdWD/FPXUorlBQI+K8WbDSPrJPquNOClwnntEd9jMTuRmmBsQP+1KY1B3SkZg','+19740172499','https://avatars.githubusercontent.com/u/68120044','Nepal','New Hampshire','Lake Priscilla','05789','765 School Close',40.677444,-74.093107,'1','2024-12-27 13:18:16','1','2024-06-01 02:06:09','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-30 07:57:40',NULL,NULL),(74,4,'user','Marlene Bruen','Rickie_Weimann','Oren.OHara','Aglae51@hotmail.com','$scrypt$n=16384,r=8,p=1$4YsjX5CFqXybYMrtuVAcvw$ZZzFX+jBdPXBtvKcgY4qqlrxJX7XMGKiX9QmpeIvIBkDoJrr+JETXTL+nOD4bQZXNN9qmiIup/+c2Z/t7soIDg','+16373453556','https://avatars.githubusercontent.com/u/77847943','French Polynesia','New York','Robelville','65548-7914','45129 Stanley Street',40.688055,-74.091990,'1','2025-02-04 18:40:07','1','2025-03-13 06:46:44','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-01-13 07:52:59',NULL,NULL),(75,3,'user','Alejandro Schultz','Hattie.Gutkowski','Anthony9','Ena.Prohaska@hotmail.com','$scrypt$n=16384,r=8,p=1$ZlHgT/yD2Hfb5wDmhTYDEw$ood0Nk0OlcvJMk5Lnd/5GL8FOmgvO7xwzABbEhiVNSCvuZLp7DVpc86qjSMTpFu65vZ8twaL4HZsTe2YqyH+1Q','+19758537773','https://avatars.githubusercontent.com/u/28933','Romania','Wyoming','Lake Hellen','00225','113 Kuphal Knolls',40.762599,-73.944514,'1','2025-02-20 12:31:48','1','2024-08-10 04:26:35','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-03 19:04:30',NULL,NULL),(76,4,'user','Sylvia Howell','Jaida_Gleichner','Cora52','Darrell17@gmail.com','$scrypt$n=16384,r=8,p=1$iV5i4kGer4pdk2QwJFddEw$riKZVp2AU94re4a6PhdOda3JnxjIXNOrPwss2E8zarjBSCqJ+xTswg+XMMl6M+P7e0d6n4aC1XkzhG/K4nwx6Q','+18478183358','https://avatars.githubusercontent.com/u/84703450','Bolivia','Alabama','Port Aurelie','58791-2605','66764 Johnston Garden',40.807237,-73.957606,'1','2025-02-13 02:19:20','1','2024-06-14 04:51:49','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-09-01 05:06:05',NULL,NULL),(77,3,'user','Randal Kreiger PhD','Noemy98','Brown_Johns-Reinger','Olga.Turner78@gmail.com','$scrypt$n=16384,r=8,p=1$+Qb/S7UG0Wjr94gKUrt19A$seQRsGFAMXj0C940tzwpCot69LjktXzD1mYqgVA/nA7pg2va2q/wfgnmBwub6rEwTQPNxv1xA0yaXSJB9KWw2Q','+13598151084','https://avatars.githubusercontent.com/u/49967068','France','Oklahoma','Fadelhaven','84719-5714','56689 Leffler Branch',40.657257,-74.101364,'1','2024-06-06 07:39:09','1','2024-09-16 00:09:29','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-08-26 11:53:45',NULL,NULL),(78,3,'user','Sheldon Koelpin','Gus.Labadie','Marvin_Champlin','Davonte.Schultz1@gmail.com','$scrypt$n=16384,r=8,p=1$o4QwFHXI7VTi415rijxFAw$P1myiz9WcYWz8v+uf5x4WSRFPYXlZmdBnxo4ZMFSmGb81K/0XvLangDdv6roaT89HtWjZmmNdnsoI9k4VhUfRA','+15083849785','https://avatars.githubusercontent.com/u/33945339','Cayman Islands','Oregon','Elmorefurt','11564-2236','8788 Jerry Point',40.710317,-74.077163,'1','2025-01-15 12:30:13','1','2024-11-04 07:06:41','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-10-20 00:15:14',NULL,NULL),(79,3,'user','Gayle Crooks','Darren_Hilll75','Okey50','Felicity21@hotmail.com','$scrypt$n=16384,r=8,p=1$LxXcvQNCfbyqZmMwQEbk6g$FzD86VKwdTlLYICKtHdwC2VMyLSIR3dTJO5VSYOPGjto0mbC8NJ6zg3r3zJ4zoiSa5tHSXeofNXopzZ4bhrt6A','+10930577706','https://avatars.githubusercontent.com/u/31902962','San Marino','Maine','Daytona Beach','51998','7817 Dewayne Islands',40.699178,-74.047943,'1','2024-11-04 00:23:49','1','2024-05-14 07:48:16','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-10 19:54:04',NULL,NULL),(80,3,'user','Allan Kuvalis Sr.','Willard.Raynor','Rosetta.Cole','Layne11@hotmail.com','$scrypt$n=16384,r=8,p=1$crlzxC945OII/sKzuFzsNA$LnI+lHv7Ii6v/ttQRPy9DoBxLPvtkkjczcC0q5uVQ362aYWofeGfoiXPr5Qe0O47/YbdCb2geLA1I5TwaZafAg','+18705025760','https://avatars.githubusercontent.com/u/46083495','Libyan Arab Jamahiriya','Mississippi','Jacinthemouth','29762-0249','30068 Klocko Spring',40.647253,-73.941816,'1','2024-11-15 23:13:59','1','2024-10-03 17:45:14','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-25 00:27:30',NULL,NULL),(81,4,'user','Wilbert Mills','Adalberto35','Ova53','Tessie39@hotmail.com','$scrypt$n=16384,r=8,p=1$wZzfAYr6/Q2+ci0j88ySjg$5gE6vUT/iThoL0q4oWOXVpBSy0r5COw/5TWHtx11vyDzDwLy1BEg5RMsjPkvF75CoGeFXZLP4kB5OsH7u7qeoA','+13330457322','https://avatars.githubusercontent.com/u/97275171','Botswana','Washington','West Eliseofield','85243-0334','53894 N Elm Street',40.748051,-73.980709,'1','2024-05-15 11:20:09','1','2024-12-09 06:58:33','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-02-14 05:03:21',NULL,NULL),(82,4,'user','Mrs. Suzanne Cronin','Joan.Gerhold','Virginie12','Wiley93@hotmail.com','$scrypt$n=16384,r=8,p=1$Nw0jqskmVKQJ4E5izjoqHA$rh4Cmn+uUkPHN7C3fGYRYVzzxjKMDPPRdOmqBvpTGH1m6Y3pZbwjAZ6EPD2tLffU7vdW0ePX7i0S3XzC21FGww','+15756413077','https://avatars.githubusercontent.com/u/62024961','Jersey','California','Okunevaberg','53742-2965','53932 Beatrice Plains',40.633035,-74.039629,'1','2024-07-30 23:15:52','1','2024-09-17 00:49:48','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-02-27 17:54:44',NULL,NULL),(83,4,'user','Rosalie Lockman II','Martin.Lemke','Chad_Kerluke','Kyla_Considine@gmail.com','$scrypt$n=16384,r=8,p=1$k/mT2x/v0XM5/mc2E6smbQ$eJcQYAvePvvcpTsjJdO61AM7/O1AQTJg+bQkzRb+68vi9pVfXGkppMq+JyGfSwpRXyOfDrtm+yl4nuBrQeMdSA','+17869398600','https://avatars.githubusercontent.com/u/81901878','Sint Maarten','Minnesota','Fadelstead','64999-1640','23258 N Court Street',40.800184,-74.010752,'1','2024-09-11 09:23:33','1','2025-01-15 03:11:16','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-21 20:25:24',NULL,NULL),(84,4,'user','Cheryl Nolan','Santino.Nitzsche4','Jarred.McCullough','Lenora51@gmail.com','$scrypt$n=16384,r=8,p=1$BPs8FijqUM5AbmNADNs1QA$fEn2JhPRi+mjfbhljTUy+pdQ3XprKPK+5VwFdy9h+DE8z/VCavIbjQ5OY6D5MHhEfF3oLjD7ULoFX9ch2L3fgA','+10495332545','https://avatars.githubusercontent.com/u/92351403','Guatemala','Rhode Island','Mayerborough','52661','5533 Stanley Street',40.729088,-73.961670,'1','2024-11-03 04:28:09','1','2024-10-02 23:17:28','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-05 00:00:21',NULL,NULL),(85,3,'user','Donald Reilly','Linda43','Elsa_Schultz44','Rafael86@hotmail.com','$scrypt$n=16384,r=8,p=1$9YqMqLCY+fKIq69hRvS+RA$snu12PQyH7PgKerLeusFlj6S2vTeLh6kvS87oYRfIhKQisIHYUFB/pS16Mi9xGnr17JcbT1AtDP4XVclEDFcqA','+19132244470','https://avatars.githubusercontent.com/u/28415098','Bermuda','Alaska','Letafurt','79477','2595 Bayer Wells',40.734007,-74.102646,'1','2025-01-30 21:27:21','1','2024-09-28 06:47:45','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-12 08:26:49',NULL,NULL),(86,4,'user','Steve O\'Keefe','Alexys_Moore8','Stevie.Little56','Zack81@yahoo.com','$scrypt$n=16384,r=8,p=1$d6+f3gdpx8FN2+olnBvkeQ$HoeeNVWcC+lkr/lmTI/nrcyd7/BOAjxWWSROV4HEL0zwglW+xJX+qBz6noZy+eohludHZ2n7QTRxUDPN2Iaiaw','+15576435342','https://avatars.githubusercontent.com/u/76038936','Palestine','Arkansas','East Jayme','11282-7758','89321 Ziemann Circle',40.621582,-74.043215,'1','2025-01-25 21:11:41','1','2024-12-02 06:00:04','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-20 20:26:40',NULL,NULL),(87,3,'user','Johnathan O\'Keefe MD','Leslie65','Evan.Treutel','Mariana.Collier@hotmail.com','$scrypt$n=16384,r=8,p=1$O9EDRUU2vlTuMWdOVh72Ag$zOfJ6OUr0n0cAmzL6AWZxOLWdDsRIg1f7erj1VsHf11pmQX7+JAAeqzgNG1X/nejqWaZ4UvAEFKi/qt19jS1Eg','+11167637895','https://avatars.githubusercontent.com/u/78181199','Wallis and Futuna','Alaska','North Demondview','53429-7085','9595 Kavon Center',40.750607,-73.938053,'1','2024-05-10 10:23:27','1','2025-04-17 21:01:56','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-30 19:17:17',NULL,NULL),(88,3,'user','Winifred Stehr','Lina.Erdman35','Isom.Kertzmann','Cedrick.Morar34@yahoo.com','$scrypt$n=16384,r=8,p=1$zIVom4Oq2gHkqe0JC53rUw$JFlW3UFx3VX/3rKuYBSpZNwjpdL8IDVT63SmV6u3O/hEJxZvMcE5K6kNTiO5AdcT14apZ01oCV7K7dp2V5fgAA','+17450038999','https://avatars.githubusercontent.com/u/10184041','Philippines','Louisiana','East Myrlboro','46261','82985 E 11th Street',40.727278,-73.996242,'1','2024-05-06 07:25:47','1','2024-12-31 22:04:16','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-09-24 15:36:37',NULL,NULL),(89,3,'user','Jeannette Dooley','Dante67','Murl.Emard19','Flavio.Crooks79@yahoo.com','$scrypt$n=16384,r=8,p=1$y0Tr4xT4sq0amYmLZ8asUg$4/JYInbt+kQe5wi3O2whEm7M2xxtK2oaWP4luPKGowEVi0mhK8SDMLxy6TR+qlk/QzePEOM4+mqoIgJu8jvehA','+18566195892','https://avatars.githubusercontent.com/u/63542696','Cambodia','Missouri','Fort Cooper','92858-2999','30181 Marks Knoll',40.650823,-73.988162,'1','2025-01-06 15:03:41','1','2024-08-29 02:03:35','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-31 16:18:43',NULL,NULL),(90,4,'user','Miss Georgia Frami','Michele88','Carlos_Smitham','Marcel.Satterfield@gmail.com','$scrypt$n=16384,r=8,p=1$OexVz9mB2+8ExxEVclIyXA$18jyJR1liR/eKhCVcMG1bG5n1fqAFrFUp+5CfD2zLe2MF2YyIx04OnRRBstk7OYHpdooxidwI/dKoCYiVhbapA','+11550895471','https://avatars.githubusercontent.com/u/77694737','Zambia','Pennsylvania','Port Chaunceyworth','05625','921 The Woodlands',40.725595,-74.052070,'1','2024-12-27 10:06:25','1','2024-07-09 08:37:04','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-27 07:07:12',NULL,NULL),(91,4,'user','Nichole Beier','Steve.Hayes14','Jolie78','Kelli_Zieme36@hotmail.com','$scrypt$n=16384,r=8,p=1$JguGlAyrOP9Puj9Musec9Q$SAYV1ZSHUqk40Z2SruIKFWqeHEce2uPU6/gWow/6wKt3VwZ8VsnSUG4hxymNgeiUg/rgDy8S1UfbOO/1fNFHHA','+18426640529','https://avatars.githubusercontent.com/u/31342330','French Southern Territories','Pennsylvania','Lake Kiarraboro','61801','9724 Hammes Squares',40.629176,-73.975869,'1','2024-06-24 05:08:42','1','2025-01-04 22:51:30','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-29 23:17:09',NULL,NULL),(92,4,'user','Dr. Terry Schaefer','Athena_Goyette75','Boris22','Amir_MacGyver@hotmail.com','$scrypt$n=16384,r=8,p=1$K6MwJoA7t2Y/Twyna1RIkw$/OIOkF9AztNwy6hW2HEfgovZChD9zB7TpIWpHHCkXbn7G+t3IUl6yI4ruZPLwxB4yXLGiInwFr6175fpLEqHNQ','+15808360961','https://avatars.githubusercontent.com/u/19908312','Solomon Islands','Alabama','South Ralphshire','04980-7157','56430 Woodside Road',40.794514,-74.095925,'1','2024-05-18 22:01:23','1','2024-05-31 21:01:17','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-04-07 03:23:40',NULL,NULL),(93,4,'user','Tim Cartwright','Marjorie50','Alfonso49','Bailey_Howell21@yahoo.com','$scrypt$n=16384,r=8,p=1$cCLocwzNNHUPD/X+9MURbw$tHXjOUvQcVe1rLtozlJlE5U1dWyFZ1CVBl2YjXCY6IerpvRfbq+KmNFf+kBIETqj0+hiDFlYSawqW85XRwVe8w','+10773077419','https://avatars.githubusercontent.com/u/56144045','Monaco','Utah','West Gianni','00526','969 Stroman Cliffs',40.756543,-74.081872,'1','2024-07-28 05:53:03','1','2024-09-07 21:39:20','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-11-20 15:16:57',NULL,NULL),(94,3,'user','Bruce Bernhard','Rafael_West30','Hilton.Spinka10','Sonny.Larkin20@hotmail.com','$scrypt$n=16384,r=8,p=1$fsU6eRhFe+wm8XpZyaKyHA$FY2WfhTMNOxc71qjBH0SWYWxzOlNYmj3sji8irfRVgyoF6SjMQIPJ3i64WW/PKToCVCzl5SZdExnLbvco9fg6g','+16765178395','https://avatars.githubusercontent.com/u/87359123','Denmark','North Carolina','Port Eulah','80766','43230 Heller Shoals',40.622754,-74.072547,'1','2025-04-07 12:35:32','1','2025-03-29 17:13:06','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-12 19:30:33',NULL,NULL),(95,3,'user','Tricia Gleason','Royce_Kuhlman','Reina70','Jadyn.Bailey75@hotmail.com','$scrypt$n=16384,r=8,p=1$mbtj5uowaOMSJndcU9LjxA$M+YdvFoxIHLCCuRUMCViEgxzh/as1AIc5SI9h9sBc8EDeZdRN1kZtAKeIhZvcaqyz6EGy+fPTrxt9ky9XwkN8g','+15300084103','https://avatars.githubusercontent.com/u/83565981','Norfolk Island','Hawaii','West Dakotaport','55684-7359','4058 Maple Street',40.752880,-73.978933,'1','2025-02-03 08:53:45','1','2024-08-20 12:25:49','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-05-14 10:34:53',NULL,NULL),(96,3,'user','Nina Farrell','Keaton_Wolff27','Bernice.Batz','Josefina_Homenick@hotmail.com','$scrypt$n=16384,r=8,p=1$4pKtdSjKTV3fbfim61Z4rg$B77sfW/igwye+AtvnQkItxadTmT+RVxg1wW+CPuSSlRuAJfvskUT4e9dBEer+fiQJqzLPP+XCQJxnliACDatJw','+12962805664','https://avatars.githubusercontent.com/u/75515992','Cameroon','West Virginia','New Angeline','97502','48407 N Front Street',40.808847,-73.925613,'1','2024-07-09 23:14:24','1','2024-05-01 00:32:06','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-10 09:34:20',NULL,NULL),(97,4,'user','Ms. Jessica Heathcote','Casandra.Jakubowski','Jessika63','Niko24@hotmail.com','$scrypt$n=16384,r=8,p=1$2owrMj+cuZkFz1iX9UNDHQ$31lYaE2O/6kKTJJbwjduIY6HjoMgoue+GlZsBhiuhhD5UASiWSBLW74YHjFd2BkKicbLsO7x0yqE+GjX1ttKVg','+18677569871','https://avatars.githubusercontent.com/u/22466525','Morocco','Missouri','West Leannastad','23599','23851 Wellington Street',40.795591,-73.941791,'1','2024-08-26 07:40:55','1','2025-04-05 11:36:46','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-01-13 17:57:25',NULL,NULL),(98,3,'user','Mr. Eduardo Spinka','Alexandro.Weissnat','Dena_Windler79','Laurel_Marquardt-Lynch86@yahoo.com','$scrypt$n=16384,r=8,p=1$qQLiXuXKRoK1KjuLy05dBw$4g96Jx1ALS1awYmHiAKZnsrkJqrpXgwgy6kgLER9JWYUw/fyC8+ygcLlOT3yOK5nAGS/Bp5Y1L4KPfcHU+O0sA','+10324377852','https://avatars.githubusercontent.com/u/58521650','Greece','Maine','Heathcoteworth','68772','432 Sheldon Fort',40.675236,-73.972089,'1','2025-03-13 03:15:49','1','2024-12-19 17:26:55','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-06-30 08:26:40',NULL,NULL),(99,3,'user','Sherry Kozey','Olin.Rau','Rico_Hilpert22','Alexandrine_Morissette@yahoo.com','$scrypt$n=16384,r=8,p=1$pJpgesUoIo2qA7QIimivQw$Eq7UMW8BnLHNoLwol9KURDXNHwuKS6uZO74v5MaCFu/7BLrXxfL3+PygV0Fezhk4fDC4tHf/UIF+JZmWHUTUJQ','+14422899959','https://avatars.githubusercontent.com/u/43802760','United Kingdom','Arkansas','Oranstad','19979','9459 Destini Ridge',40.804103,-73.977582,'1','2024-06-25 10:04:12','1','2025-03-18 16:35:03','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-04-24 12:25:31',NULL,NULL),(100,3,'user','Mr. Adam Rath','Aida_Gibson97','Dan_Schmeler','Ahmed_Legros@yahoo.com','$scrypt$n=16384,r=8,p=1$fl+bIvTWISVGgHYQLJ0YPg$Hl2fAa18DVL49LqwLCi1F4uNQpuar4Xo6z5lUg//ApLVwDlf7cXrvD+iThu3YiuEzbMk4wAN8jCBUbZ0nn6FlQ','+19595744997','https://avatars.githubusercontent.com/u/54192338','Gambia','New Hampshire','Marinaberg','52587','245 Letitia Radial',40.774719,-74.076284,'1','2024-05-04 02:33:32','1','2024-06-09 23:28:27','1',0.00,NULL,NULL,0.00,'0','0','2','1','2025-03-27 18:52:34',NULL,NULL),(101,3,'user','Lula Rempel','Hazel5','Mozell4','Claudine.Ruecker@hotmail.com','$scrypt$n=16384,r=8,p=1$/djmM6OcIDK9x/OpiBwGXQ$1ZYjH6Etsk1KM9NGWvbvgBKPw5//bJnOMICADOK9yv6pGf3jyPd5Gpnu5v32uzrF+W1hjjcugMzeJ2Lq9iukZw','+14026812137','https://avatars.githubusercontent.com/u/50118855','Tajikistan','Connecticut','Wehnerfield','40410','768 Marilyne Flats',40.806548,-74.021026,'1','2025-03-13 06:21:23','1','2025-02-22 12:45:02','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-12-01 02:18:05',NULL,NULL),(102,4,'user','Grady Bergnaum','Jasmin67','Kane83','Libby20@gmail.com','$scrypt$n=16384,r=8,p=1$7jenN0U8Vxt6lWv81EZ7QQ$sI9HDSK/d3a6hxtgw7sFWc7AR/sFX0qvs4cKlz34i1I+AxxdRvY0oR2d3mH8BSy+qC1V43EpznsNB2bRakKAtA','+10158862515','https://avatars.githubusercontent.com/u/89175377','Finland','Montana','North Johnathonstad','41127','11640 Tiffany Stream',40.811834,-73.936882,'1','2024-10-08 12:56:44','1','2024-07-06 19:55:06','1',0.00,NULL,NULL,0.00,'0','0','2','1','2024-07-17 04:21:05',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,'20250428102452683-9fe11a1731b9bdde','Standard','A standard-sized car, ideal for everyday use and city commuting','active','2025-04-28 05:24:52',NULL,NULL),(2,'20250428102452683-50879f6958f29f43','SUV','A versatile, larger vehicle suitable for off-road driving and long-distance travel','active','2025-04-28 05:24:52',NULL,NULL),(3,'20250428102452683-4d25b5338f395042','Mini','A compact, space-efficient car designed for urban environments and easy parking','active','2025-04-28 05:24:52',NULL,NULL),(4,'20250428102452683-a105b7d2dd6fad99','Eco-Friendly','Vehicles designed with sustainability in mind, often electric or hybrid models','active','2025-04-28 05:24:52',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,'20250428102452728-f1ba191758a7cd01','Rapid Red','#9B111E','active','2025-04-28 05:24:52',NULL,NULL),(2,'20250428102452728-d54cf8029f7fed23','Oxford White','#F0F0F0','active','2025-04-28 05:24:52',NULL,NULL),(3,'20250428102452728-d6fcb74c280862b0','Carbonized Gray','#4B4E53','active','2025-04-28 05:24:52',NULL,NULL),(4,'20250428102452728-9e931e4ce6fff8ab','Summit White','#F7F7F7','active','2025-04-28 05:24:52',NULL,NULL),(5,'20250428102452728-3fa2c50f04fa5631','Mosaic Black Metallic','#2D2926','active','2025-04-28 05:24:52',NULL,NULL),(6,'20250428102452728-ae94a8814e308cf5','Red Hot','#F12B2A','active','2025-04-28 05:24:52',NULL,NULL),(7,'20250428102452728-50dbf1cbfdec6653','Super White','#F7F7F7','active','2025-04-28 05:24:52',NULL,NULL),(8,'20250428102452729-13184ae021945dc9','Midnight Black Metallic','#1C1C1C','active','2025-04-28 05:24:52',NULL,NULL),(9,'20250428102452729-219c3ed4fdc0468c','Magnetic Gray Metallic','#4A4A4A','active','2025-04-28 05:24:52',NULL,NULL),(10,'20250428102452729-dd513a2acb28d99f','Lunar Silver Metallic','#D1D3D4','active','2025-04-28 05:24:52',NULL,NULL),(11,'20250428102452729-d3dfea7e281c06db','Crystal Black Pearl','#2B2D2F','active','2025-04-28 05:24:52',NULL,NULL),(12,'20250428102452729-e1bd036637e7da74','Modern Steel Metallic','#5B5E5A','active','2025-04-28 05:24:52',NULL,NULL),(13,'20250428102452729-3464f05889982651','Granite Crystal Metallic','#474A4B','active','2025-04-28 05:24:52',NULL,NULL),(14,'20250428102452729-c960c9084073ba89','Sting-Gray','#8E8F8A','active','2025-04-28 05:24:52',NULL,NULL),(15,'20250428102452729-c6c10ffa6ff431ed','Firecracker Red','#E02F28','active','2025-04-28 05:24:52',NULL,NULL),(16,'20250428102452729-69527c71a7ed167c','White Knuckle','#F7F7F7','active','2025-04-28 05:24:52',NULL,NULL),(17,'20250428102452729-9fd1a83746665f20','Go Mango','#F44336','active','2025-04-28 05:24:52',NULL,NULL),(18,'20250428102452729-51abe565ceb5b6cd','Billet Silver Metallic','#A6A9B0','active','2025-04-28 05:24:52',NULL,NULL),(19,'20250428102452729-fe88850482ee9ebe','Flame Red','#D32F2F','active','2025-04-28 05:24:52',NULL,NULL),(20,'20250428102452729-d2801dfd0148e238','Patriot Blue Pearl','#1C4F73','active','2025-04-28 05:24:52',NULL,NULL),(21,'20250428102452729-b487c2bc774286ba','Bright White','#FFFFFF','active','2025-04-28 05:24:52',NULL,NULL),(22,'20250428102452729-56540594c040f30f','Midnight Silver Metallic','#4B4E51','active','2025-04-28 05:24:52',NULL,NULL),(23,'20250428102452729-e2cc517e56df8714','Pearl White Multi-Coat','#F0F0F0','active','2025-04-28 05:24:52',NULL,NULL),(24,'20250428102452729-b6b1706ebb17e293','Deep Blue Metallic','#005A72','active','2025-04-28 05:24:52',NULL,NULL),(25,'20250428102452729-0c61e965f3db417b','Gun Metallic','#4D4F53','active','2025-04-28 05:24:52',NULL,NULL),(26,'20250428102452729-e445235f19c2b679','Super Black','#1D1D1B','active','2025-04-28 05:24:52',NULL,NULL),(27,'20250428102452729-376372d13ffd027e','Brilliant Silver','#8A8C8E','active','2025-04-28 05:24:52',NULL,NULL),(28,'20250428102452729-2024b8aec4cc0f19','Alpine White','#F1F1F1','active','2025-04-28 05:24:52',NULL,NULL),(29,'20250428102452729-06db66dd5f99a1d0','Jet Black','#000000','active','2025-04-28 05:24:52',NULL,NULL),(30,'20250428102452729-7964b2c9f14df7d6','Phytonic Blue','#1D5D7D','active','2025-04-28 05:24:52',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,'20250428102452705-bd195d5616aa158b','Ford','active','2025-04-28 05:24:52',NULL,NULL),(2,'20250428102452706-4690b47207458e13','Chevrolet','active','2025-04-28 05:24:52',NULL,NULL),(3,'20250428102452706-46940f02a174c6e0','Toyota','active','2025-04-28 05:24:52',NULL,NULL),(4,'20250428102452706-a987a05432acc997','Honda','active','2025-04-28 05:24:52',NULL,NULL),(5,'20250428102452706-82bb8c70278bb770','Jeep','active','2025-04-28 05:24:52',NULL,NULL),(6,'20250428102452706-15843418f927d9e9','Dodge','active','2025-04-28 05:24:52',NULL,NULL),(7,'20250428102452706-668fdecb4007762d','Ram','active','2025-04-28 05:24:52',NULL,NULL),(8,'20250428102452706-0e0ea2383cbe371f','Tesla','active','2025-04-28 05:24:52',NULL,NULL),(9,'20250428102452706-11b19b08c25807b4','Nissan','active','2025-04-28 05:24:52',NULL,NULL),(10,'20250428102452706-d7e6e0d7c0ca4e89','BMW','active','2025-04-28 05:24:52',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,'20250428102452716-4cf05e09768afcb7',1,'F-150','active','2025-04-28 05:24:52',NULL,NULL),(2,'20250428102452716-c62e633f9b45cca6',1,'Mustang','active','2025-04-28 05:24:52',NULL,NULL),(3,'20250428102452716-286b40e354b4e495',1,'Explorer','active','2025-04-28 05:24:52',NULL,NULL),(4,'20250428102452717-86e6944d29b03087',2,'Silverado 1500','active','2025-04-28 05:24:52',NULL,NULL),(5,'20250428102452717-3a653a1c5d39453e',2,'Equinox','active','2025-04-28 05:24:52',NULL,NULL),(6,'20250428102452717-e40f8744f26375e0',2,'Malibu','active','2025-04-28 05:24:52',NULL,NULL),(7,'20250428102452717-cecfddd31ffdd83f',3,'Camry','active','2025-04-28 05:24:52',NULL,NULL),(8,'20250428102452717-784b368d0cdedde6',3,'Tacoma','active','2025-04-28 05:24:52',NULL,NULL),(9,'20250428102452717-51b470c2c2c6305b',3,'RAV4','active','2025-04-28 05:24:52',NULL,NULL),(10,'20250428102452717-41be33d93a2831d0',4,'Civic','active','2025-04-28 05:24:52',NULL,NULL),(11,'20250428102452717-1566067f486cf806',4,'Accord','active','2025-04-28 05:24:52',NULL,NULL),(12,'20250428102452717-3fea34346ca844c7',4,'CR-V','active','2025-04-28 05:24:52',NULL,NULL),(13,'20250428102452718-d588956e7f06871f',5,'Grand Cherokee','active','2025-04-28 05:24:52',NULL,NULL),(14,'20250428102452718-685d8dd4ccd16091',5,'Wrangler','active','2025-04-28 05:24:52',NULL,NULL),(15,'20250428102452718-137ac02aa72f05f2',5,'Cherokee','active','2025-04-28 05:24:52',NULL,NULL),(16,'20250428102452718-4524a383125712ab',6,'Charger','active','2025-04-28 05:24:52',NULL,NULL),(17,'20250428102452718-79b56e702d1e9ed4',6,'Ram 1500','active','2025-04-28 05:24:52',NULL,NULL),(18,'20250428102452718-716b49a33174f8c1',6,'Durango','active','2025-04-28 05:24:52',NULL,NULL),(19,'20250428102452718-3b1eed1117ecc5c2',7,'1500','active','2025-04-28 05:24:52',NULL,NULL),(20,'20250428102452718-23fb4d8a70300706',7,'2500','active','2025-04-28 05:24:52',NULL,NULL),(21,'20250428102452718-cfe76e6be48a3895',7,'ProMaster','active','2025-04-28 05:24:52',NULL,NULL),(22,'20250428102452718-4d65ce87cf4aaa75',8,'Model 3','active','2025-04-28 05:24:52',NULL,NULL),(23,'20250428102452718-7e6d6d8a31432473',8,'Model S','active','2025-04-28 05:24:52',NULL,NULL),(24,'20250428102452719-67fc484450280717',8,'Model X','active','2025-04-28 05:24:52',NULL,NULL),(25,'20250428102452719-c047247262ac1a67',9,'Altima','active','2025-04-28 05:24:52',NULL,NULL),(26,'20250428102452719-85ecfab401179aba',9,'Rogue','active','2025-04-28 05:24:52',NULL,NULL),(27,'20250428102452719-0481795d9da95449',9,'Frontier','active','2025-04-28 05:24:52',NULL,NULL),(28,'20250428102452719-ec4e7514c5485a99',10,'3 Series','active','2025-04-28 05:24:52',NULL,NULL),(29,'20250428102452719-9f8f7085109ccc73',10,'X5','active','2025-04-28 05:24:52',NULL,NULL),(30,'20250428102452719-1ed41f5b1c6c8a42',10,'M4','active','2025-04-28 05:24:52',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-04-28 16:37:37