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


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

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

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

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

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

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

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

INSERT INTO `adonis_schema_versions` VALUES (2);

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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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


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

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

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


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

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

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


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

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

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

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

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

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

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


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

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

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

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

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

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

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

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

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

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

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


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

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

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


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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


