-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1:3306
-- Generation Time: May 15, 2026 at 08:05 AM
-- Server version: 5.7.40
-- PHP Version: 8.0.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `driftly`
--

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

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

DROP TABLE IF EXISTS `bookings`;
CREATE TABLE IF NOT EXISTS `bookings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ride_id` int(11) NOT NULL,
  `passenger_id` int(11) NOT NULL,
  `driver_id` int(11) NOT NULL,
  `status` enum('pending','accepted','rejected','cancelled','completed') NOT NULL DEFAULT 'pending',
  `seats` int(11) NOT NULL DEFAULT '1',
  `total_price` decimal(10,2) NOT NULL DEFAULT '0.00',
  `message` text,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_booking_ride` (`ride_id`),
  KEY `fk_booking_passenger` (`passenger_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `rides`
--

DROP TABLE IF EXISTS `rides`;
CREATE TABLE IF NOT EXISTS `rides` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `driver_id` int(11) NOT NULL,
  `from_location` varchar(255) NOT NULL,
  `to_location` varchar(255) NOT NULL,
  `departure_time` datetime NOT NULL,
  `available_seats` int(11) NOT NULL DEFAULT '1',
  `price` decimal(10,2) NOT NULL,
  `status` enum('active','completed','cancelled') DEFAULT 'active',
  `description` text,
  `vehicle_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_driver_id` (`driver_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `rides`
--

INSERT INTO `rides` (`id`, `driver_id`, `from_location`, `to_location`, `departure_time`, `available_seats`, `price`, `status`, `description`, `vehicle_id`, `created_at`, `updated_at`) VALUES
(1, 3, 'New York', 'Boston', '2026-05-16 09:11:19', 3, '28.00', 'active', 'Comfortable ride with WiFi and luggage space.', NULL, '2026-05-13 07:11:19', '2026-05-15 07:34:15'),
(2, 5, 'Paris', 'Lyon', '2026-05-17 09:11:19', 2, '42.00', 'active', 'Evening ride with one short break.', NULL, '2026-05-11 07:11:19', '2026-05-15 07:34:15'),
(3, 7, 'Los Angeles', 'San Diego', '2026-05-16 09:11:19', 4, '35.00', 'active', 'SUV vehicle with air conditioning.', NULL, '2026-05-09 07:11:19', '2026-05-15 07:34:15'),
(4, 9, 'Berlin', 'Hamburg', '2026-05-18 09:11:19', 3, '31.00', 'completed', 'Fast highway trip with experienced driver.', NULL, '2026-05-06 07:11:19', '2026-05-15 07:34:15'),
(5, 11, 'London', 'Manchester', '2026-05-17 09:11:19', 2, '26.00', 'active', 'Morning departure from central London.', NULL, '2026-05-04 07:11:19', '2026-05-15 07:34:15'),
(6, 13, 'Milan', 'Rome', '2026-05-19 09:11:19', 3, '47.00', 'cancelled', 'Ride cancelled due to vehicle maintenance.', NULL, '2026-05-01 07:11:19', '2026-05-15 07:34:15'),
(7, 15, 'Amsterdam', 'Brussels', '2026-05-16 09:11:19', 3, '24.00', 'active', 'Pet friendly ride available.', NULL, '2026-04-29 07:11:19', '2026-05-15 07:34:15'),
(8, 17, 'Madrid', 'Barcelona', '2026-05-20 09:11:19', 2, '39.00', 'active', 'Comfort ride with charging ports.', NULL, '2026-04-26 07:11:19', '2026-05-15 07:34:15'),
(9, 19, 'Vienna', 'Prague', '2026-05-17 09:11:19', 4, '29.00', 'completed', 'Weekend shared trip.', NULL, '2026-04-24 07:11:19', '2026-05-15 07:34:15'),
(10, 21, 'Munich', 'Zurich', '2026-05-18 09:11:19', 2, '52.00', 'active', 'Premium business class ride.', NULL, '2026-04-21 07:11:19', '2026-05-15 07:34:15'),
(11, 23, 'Paris', 'Nice', '2026-05-21 09:11:19', 3, '65.00', 'active', 'Long distance trip with scenic stops.', NULL, '2026-04-11 07:11:19', '2026-05-15 07:34:15'),
(12, 25, 'New York', 'Washington', '2026-05-19 09:11:19', 2, '33.00', 'completed', 'Direct ride without additional passengers.', NULL, '2026-04-08 07:11:19', '2026-05-15 07:34:15'),
(13, 27, 'Rome', 'Florence', '2026-05-17 09:11:19', 3, '21.00', 'active', 'Affordable city-to-city transport.', NULL, '2026-04-04 07:11:19', '2026-05-15 07:34:15'),
(14, 29, 'Berlin', 'Cologne', '2026-05-18 09:11:19', 4, '27.00', 'active', 'Shared ride with flexible pickup.', NULL, '2026-04-01 07:11:19', '2026-05-15 07:34:15'),
(15, 31, 'London', 'Liverpool', '2026-05-17 09:11:19', 2, '25.00', 'cancelled', 'Trip cancelled by driver.', NULL, '2026-03-28 08:11:19', '2026-05-15 07:34:15'),
(16, 33, 'Barcelona', 'Valencia', '2026-05-20 09:11:19', 3, '32.00', 'active', 'Comfortable ride with music and AC.', NULL, '2026-03-25 08:11:19', '2026-05-15 07:34:15'),
(17, 35, 'Chicago', 'Detroit', '2026-05-17 09:11:19', 4, '41.00', 'completed', 'Night drive with experienced driver.', NULL, '2026-03-22 08:11:19', '2026-05-15 07:34:15'),
(18, 37, 'Miami', 'Orlando', '2026-05-16 09:11:19', 2, '36.00', 'active', 'Family friendly ride.', NULL, '2026-03-19 08:11:19', '2026-05-15 07:34:15');

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

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
CREATE TABLE IF NOT EXISTS `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `setting_key` varchar(50) NOT NULL,
  `setting_value` varchar(100) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` (`id`, `setting_key`, `setting_value`) VALUES
(1, 'site_name', 'Driftly'),
(2, 'footer_about', 'A modern ride sharing marketplace for riders, drivers and communities.'),
(3, 'footer_copyright', 'All rights reserved.'),
(4, 'support_email', 'support@driftly.com'),
(5, 'facebook_url', '#'),
(6, 'instagram_url', '#'),
(7, 'linkedin_url', '#'),
(8, 'site_font', 'Inter');

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

--
-- Table structure for table `testimonials`
--

DROP TABLE IF EXISTS `testimonials`;
CREATE TABLE IF NOT EXISTS `testimonials` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `name` varchar(120) NOT NULL,
  `role` varchar(120) DEFAULT NULL,
  `location` varchar(120) DEFAULT NULL,
  `rating` tinyint(4) NOT NULL DEFAULT '5',
  `comment` text NOT NULL,
  `avatar` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_status` (`status`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `user_id`, `name`, `role`, `location`, `rating`, `comment`, `avatar`, `status`, `created_at`, `updated_at`) VALUES
(1, NULL, 'Emily Carter', 'Frequent traveler', 'New York, USA', 5, 'Driftly made my trip from New York to Boston simple, affordable and comfortable. The booking experience felt smooth from start to finish.', 'https://i.pravatar.cc/150?img=32', 'active', '2026-05-12 07:24:52', '2026-05-15 07:26:16'),
(2, NULL, 'Lucas Martin', 'Driver', 'Paris, France', 5, 'As a driver, I like how easy it is to publish a ride and manage available seats. The platform feels clean and professional.', 'https://i.pravatar.cc/150?img=12', 'active', '2026-05-09 07:24:52', '2026-05-15 07:26:16'),
(3, NULL, 'Sophie Williams', 'Student', 'London, UK', 5, 'I found a ride quickly and saved money compared to other transport options. The whole experience felt safe and reliable.', 'https://i.pravatar.cc/150?img=47', 'active', '2026-05-06 07:24:52', '2026-05-15 07:26:16'),
(4, NULL, 'Daniel Brooks', 'Business traveler', 'Chicago, USA', 4, 'The interface is modern and clear. I could compare rides, see details and book without confusion.', 'https://i.pravatar.cc/150?img=15', 'active', '2026-05-03 07:24:52', '2026-05-15 07:26:16'),
(5, NULL, 'Anna Müller', 'Passenger', 'Berlin, Germany', 5, 'Great experience. The driver was friendly, the ride was on time, and the price was very reasonable.', 'https://i.pravatar.cc/150?img=56', 'active', '2026-04-30 07:24:52', '2026-05-15 07:26:16'),
(6, NULL, 'Marco Rossi', 'Driver', 'Milan, Italy', 5, 'Driftly gives drivers a simple way to earn from empty seats. It is exactly what a modern ride sharing platform should be.', 'https://i.pravatar.cc/150?img=68', 'active', '2026-04-27 07:24:52', '2026-05-15 07:26:16');

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

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

DROP TABLE IF EXISTS `users`;
CREATE TABLE IF NOT EXISTS `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `avatar` varchar(150) NOT NULL,
  `password` varchar(255) NOT NULL,
  `gender` enum('male','female','other') DEFAULT NULL,
  `date_of_birth` date DEFAULT NULL,
  `email` varchar(50) NOT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `role` varchar(20) NOT NULL DEFAULT 'user',
  `verification_status` varchar(50) NOT NULL DEFAULT 'pending',
  `verification_note` varchar(255) DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=41 DEFAULT CHARSET=latin1;

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

INSERT INTO `users` (`id`, `name`, `avatar`, `password`, `gender`, `date_of_birth`, `email`, `phone`, `role`, `verification_status`, `verification_note`, `created_at`) VALUES
(1, 'Branko Matovic', 'https://i.pravatar.cc/150?img=1', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'admin@driftly.com', NULL, 'admin', 'pending', NULL, '2026-03-26 09:03:57'),
(2, 'Emma Wilson', 'https://i.pravatar.cc/150?img=47', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'emma.wilson@example.com', NULL, 'passenger', 'pending', NULL, '2026-05-12 09:03:57'),
(3, 'James Carter', 'https://i.pravatar.cc/150?img=52', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'james.carter@example.com', NULL, 'driver', 'pending', NULL, '2026-05-10 09:03:57'),
(4, 'Sophie Laurent', 'https://i.pravatar.cc/150?img=44', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'sophie.laurent@example.fr', NULL, 'passenger', 'pending', NULL, '2026-05-08 09:03:57'),
(5, 'Lucas Martin', 'https://i.pravatar.cc/150?img=59', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'lucas.martin@example.fr', NULL, 'driver', 'pending', NULL, '2026-05-06 09:03:57'),
(6, 'Olivia Brown', 'https://i.pravatar.cc/150?img=32', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'olivia.brown@example.com', NULL, 'passenger', 'pending', NULL, '2026-05-03 09:03:57'),
(7, 'Noah Davis', 'https://i.pravatar.cc/150?img=33', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'noah.davis@example.com', NULL, 'driver', 'pending', NULL, '2026-05-01 09:03:57'),
(8, 'Mia Johnson', 'https://i.pravatar.cc/150?img=34', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'mia.johnson@example.com', NULL, 'passenger', 'pending', NULL, '2026-04-29 09:03:57'),
(9, 'William Smith', 'https://i.pravatar.cc/150?img=35', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'william.smith@example.com', NULL, 'driver', 'pending', NULL, '2026-04-27 09:03:57'),
(10, 'Charlotte Taylor', 'https://i.pravatar.cc/150?img=36', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'charlotte.taylor@example.co.uk', NULL, 'passenger', 'pending', NULL, '2026-04-25 09:03:57'),
(11, 'Henry Moore', 'https://i.pravatar.cc/150?img=37', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'henry.moore@example.co.uk', NULL, 'driver', 'pending', NULL, '2026-04-23 09:03:57'),
(12, 'Amelia Anderson', 'https://i.pravatar.cc/150?img=38', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'amelia.anderson@example.com', NULL, 'passenger', 'pending', NULL, '2026-04-21 09:03:57'),
(13, 'Benjamin Thomas', 'https://i.pravatar.cc/150?img=39', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'benjamin.thomas@example.com', NULL, 'driver', 'pending', NULL, '2026-04-19 09:03:57'),
(14, 'Isabella Jackson', 'https://i.pravatar.cc/150?img=40', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'isabella.jackson@example.com', NULL, 'passenger', 'pending', NULL, '2026-04-17 09:03:57'),
(15, 'Liam White', 'https://i.pravatar.cc/150?img=41', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'liam.white@example.com', NULL, 'driver', 'pending', NULL, '2026-04-11 09:03:57'),
(16, 'Ava Harris', 'https://i.pravatar.cc/150?img=42', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'ava.harris@example.com', NULL, 'passenger', 'pending', NULL, '2026-04-09 09:03:57'),
(17, 'Ethan Clark', 'https://i.pravatar.cc/150?img=43', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'ethan.clark@example.com', NULL, 'driver', 'pending', NULL, '2026-04-07 09:03:57'),
(18, 'Grace Lewis', 'https://i.pravatar.cc/150?img=45', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'grace.lewis@example.co.uk', NULL, 'passenger', 'pending', NULL, '2026-04-05 09:03:57'),
(19, 'Oliver Walker', 'https://i.pravatar.cc/150?img=46', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'oliver.walker@example.co.uk', NULL, 'driver', 'pending', NULL, '2026-04-03 09:03:57'),
(20, 'Chloe Hall', 'https://i.pravatar.cc/150?img=48', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'chloe.hall@example.com', NULL, 'passenger', 'pending', NULL, '2026-04-01 09:03:57'),
(21, 'Daniel Allen', 'https://i.pravatar.cc/150?img=49', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'daniel.allen@example.com', NULL, 'driver', 'pending', NULL, '2026-03-30 09:03:57'),
(22, 'Hannah Young', 'https://i.pravatar.cc/150?img=50', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'hannah.young@example.com', NULL, 'passenger', 'pending', NULL, '2026-03-28 09:03:57'),
(23, 'Matthew King', 'https://i.pravatar.cc/150?img=51', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'matthew.king@example.com', NULL, 'driver', 'pending', NULL, '2026-03-26 09:03:57'),
(24, 'Emily Wright', 'https://i.pravatar.cc/150?img=53', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'emily.wright@example.com', NULL, 'passenger', 'pending', NULL, '2026-03-24 09:03:57'),
(25, 'Jack Scott', 'https://i.pravatar.cc/150?img=54', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'jack.scott@example.co.uk', NULL, 'driver', 'pending', NULL, '2026-03-22 09:03:57'),
(26, 'Lily Green', 'https://i.pravatar.cc/150?img=55', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'lily.green@example.co.uk', NULL, 'passenger', 'pending', NULL, '2026-03-20 09:03:57'),
(27, 'Thomas Baker', 'https://i.pravatar.cc/150?img=56', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'thomas.baker@example.com', NULL, 'driver', 'pending', NULL, '2026-03-18 09:03:57'),
(28, 'Camille Dubois', 'https://i.pravatar.cc/150?img=57', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'camille.dubois@example.fr', NULL, 'passenger', 'pending', NULL, '2026-05-11 09:03:57'),
(29, 'Antoine Moreau', 'https://i.pravatar.cc/150?img=58', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'antoine.moreau@example.fr', NULL, 'driver', 'pending', NULL, '2026-05-04 09:03:57'),
(30, 'Marie Bernard', 'https://i.pravatar.cc/150?img=60', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'marie.bernard@example.fr', NULL, 'passenger', 'pending', NULL, '2026-04-30 09:03:57'),
(31, 'Theo Leroy', 'https://i.pravatar.cc/150?img=61', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'theo.leroy@example.fr', NULL, 'driver', 'pending', NULL, '2026-04-24 09:03:57'),
(32, 'Anna Müller', 'https://i.pravatar.cc/150?img=62', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'anna.mueller@example.de', NULL, 'passenger', 'pending', NULL, '2026-04-12 09:03:57'),
(33, 'Max Schneider', 'https://i.pravatar.cc/150?img=63', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'max.schneider@example.de', NULL, 'driver', 'pending', NULL, '2026-04-08 09:03:57'),
(34, 'Laura Fischer', 'https://i.pravatar.cc/150?img=64', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'laura.fischer@example.de', NULL, 'passenger', 'pending', NULL, '2026-04-04 09:03:57'),
(35, 'Jonas Weber', 'https://i.pravatar.cc/150?img=65', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'jonas.weber@example.de', NULL, 'driver', 'pending', NULL, '2026-03-31 09:03:57'),
(36, 'Giulia Romano', 'https://i.pravatar.cc/150?img=66', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'giulia.romano@example.it', NULL, 'passenger', 'pending', NULL, '2026-05-09 09:03:57'),
(37, 'Marco Conti', 'https://i.pravatar.cc/150?img=67', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'marco.conti@example.it', NULL, 'driver', 'pending', NULL, '2026-05-02 09:03:57'),
(38, 'Clara Rossi', 'https://i.pravatar.cc/150?img=68', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'clara.rossi@example.it', NULL, 'passenger', 'pending', NULL, '2026-04-06 09:03:57'),
(39, 'Luca Bianchi', 'https://i.pravatar.cc/150?img=69', '$2y$10$5Ts8K.WTnIaUN6ES9UL3q.Sv0TwaOi7gAUHc4HUl7iREzGU8HU4V.', NULL, NULL, 'luca.bianchi@example.it', NULL, 'driver', 'pending', NULL, '2026-03-27 09:03:57'),
(40, 'Petar Mirkovic', 'https://i.pravatar.cc/150?img=52', '$2y$10$hE/PBO9O3toIItO9pXDwEukfBc4a40ugIPgEbqCeqgM.BNsxSrVqy', 'male', '1988-04-29', 'pero@driftly.com', '+234562532', 'passenger', 'verified', 'Verified passenger', '2026-05-15 09:42:08');
COMMIT;

/*!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 */;