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