-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: May 11, 2023 at 04:27 AM
-- Server version: 10.4.28-MariaDB
-- PHP Version: 8.1.17

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: `finalproject`
--

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

--
-- Table structure for table `test_drive`
--

CREATE TABLE `test_drive` (
  `testdrive_id` int(20) NOT NULL,
  `vehicle_id` int(11) NOT NULL,
  `costumer_id` int(11) NOT NULL,
  `costumer_name` varchar(30) NOT NULL,
  `costumer_email` varchar(30) NOT NULL,
  `review` varchar(255) NOT NULL,
  `location` varchar(30) NOT NULL,
  `type_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `test_drive`
--

INSERT INTO `test_drive` (`testdrive_id`, `vehicle_id`, `costumer_id`, `costumer_name`, `costumer_email`, `review`, `location`, `type_id`) VALUES
(91864, 31478264, 12387461, 'Sophia Nguyen', 'sophia.nguyen@example.com', 'apaantuh', 'gak tau', 12),
(98643, 31478264, 98765, 'Apaya Kim', 'sophia.nguyen@example.com', 'apaantuh', 'gak tau', 6),
(220201, 1019981004, 207853, 'Sophia Kim', 'sophia.kim@email.com', 'Nice features, but not very comfortable', 'Country roads and highways', 5),
(220308, 1020221019, 683590, 'Marcus Davis', 'marcus.davis@email.com', 'Very fast and great handling', 'Urban roads and highways', 3),
(220314, 1020191012, 276941, 'Isabella Brown', 'isabella.brown@email.com', 'Handles well, but acceleration is lacking', 'Off-road trails and rocky terr', 5),
(220407, 1019861010, 642308, 'Emma Baker', 'emma.baker@email.com', 'Well-rounded and comfortable ride.', 'city streets and suburban road', 1),
(220503, 1020201005, 853614, 'Benjamin Wright', 'ben.wright@email.com', 'Smooth ride and good acceleration', 'Country roads and highways', 0),
(220608, 1020211017, 197354, 'Ethan Lee', 'ethan.lee@email.com', 'Spacious and comfortable, but lacking in power', 'Off-road trails and rocky terr', 5),
(220615, 1019721001, 589624, 'Jenna Martin', 'jennamartin@email.com', 'Great handling and acceleration', 'Off-road trails and rocky terr', 5),
(220731, 1020181014, 430975, 'Mia Davis', 'mia.davis@email.com', 'Nice features, but not very comfortable', 'Mountain roads and unpaved tra', 4),
(220821, 1019861008, 908756, 'Ava Johnson', 'ava.johnson@email.com', 'Tight handling and decent acceleration', 'City streets and highways', 0),
(220910, 1020151011, 395871, 'James Smith', 'james.smith@email.com', 'Great handling and acceleration', 'Country roads and highways', 5),
(221026, 1020181002, 724139, 'Kevin Lee', 'kevinlee@email.com', 'Handles well, but acceleration is lacking', 'Urban roads and highways', 2),
(221030, 1020221026, 480156, 'Emily Davis', 'emily.davis@example.com', 'Solid performance overall', 'city streets and suburban road', 4),
(221105, 1020201027, 913275, 'Michael Brown', 'michael.brown@example.com', 'Spacious and comfortable, but lacking in power', 'Off-road trails and rocky terr', 0),
(221109, 1020181009, 135790, 'William Rodriguez', 'william.rodriguez@email.com', 'Very fast and great handling', 'Urban roads and highways', 3),
(221117, 1019891021, 590614, 'Dylan Nguyen', 'dylan.nguyen@example.com', 'Great handling and acceleration', 'Urban roads and highways', 6),
(221124, 1020191020, 362159, 'Emily Patel', 'emily.patel@email.com', 'Well-rounded and comfortable ride.', 'Urban roads and highways', 4),
(221202, 1020211029, 216459, 'Anthony Martinez', 'anthony.martinez@example.com', 'Very fast and great handling', 'Off-road trails and rocky terr', 2),
(221207, 1020221030, 840973, 'Grace Lee', 'grace.lee@example.com', 'Well-rounded and comfortable ride.', 'Off-road trails and rocky terr', 0),
(221211, 1020151007, 671324, 'Ethan Hernandez', 'ethan.hernandez@email.com', 'Spacious and comfortable, but lacking in power', 'City streets and highways', 3),
(221228, 1020191024, 769420, 'Lily Chen', 'lily.chen@example.com', 'Nice features, but not very comfortable', 'City streets and highways', 1),
(221229, 1020201018, 425861, 'Samantha Carter', 'samantha.carter@email.com', 'Tight handling and decent acceleration', 'Off-road trails and rocky terr', 3),
(230111, 1020201023, 135862, 'Benjamin Kim', 'benjamin.kim@example.com', 'Needs better acceleration and handling', 'City streets and highways', 5),
(230120, 1020211013, 851624, 'Jacob Garcia', 'jacob.garcia@email.com', 'Needs better acceleration and handling', 'Country roads and highways', 0),
(230125, 1020211025, 527983, 'Samuel Jackson', 'samuel.jackson@example.com', 'Smooth ride and good acceleration', 'Urban roads and highways', 2),
(230226, 1020211022, 284615, 'Maya Patel', 'maya.patel@example.com', 'Handles well, but acceleration is lacking', 'Urban roads and highways', 2),
(230302, 1020201015, 509612, 'Alexander Martinez', 'alex.martinez@email.com', 'Smooth ride and good acceleration', 'Country roads and highways', 0),
(230305, 1020151003, 361087, 'Laura Garcia', 'lauragarcia@email.com', 'Needs better acceleration and handling', 'Country roads and highways', 0);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `test_drive`
--
ALTER TABLE `test_drive`
  ADD PRIMARY KEY (`testdrive_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `test_drive`
--
ALTER TABLE `test_drive`
  MODIFY `testdrive_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9186481;
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 */;
