-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Apr 19, 2024 at 12:01 PM
-- 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 `admin`
--

CREATE TABLE `admin` (
  `vehicle_id` int(30) NOT NULL,
  `model` varchar(30) NOT NULL,
  `type_id` int(11) NOT NULL,
  `price` varchar(30) NOT NULL,
  `quantity` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`vehicle_id`, `model`, `type_id`, `price`, `quantity`) VALUES
(1012345678, 'Energica Ego', 4, '2,000,000,000', 7),
(1012634809, 'Haibike Xduro Trekking', 4, '80,000,000', 6),
(1012876543, 'Triumph Bonneville T120', 2, '167,000,000', 7),
(1012938475, 'Kawasaki Ninja 400', 2, '73,000,000', 7),
(1013748596, 'Canyon Ultimate', 3, '70,000,000', 8),
(1014759386, 'MV Agusta F3 675', 2, '223,000,000', 8),
(1014789653, 'KTM Freeride E-XC', 4, '250,000,000', 5),
(1019721001, 'Ford Mustang', 5, '400,000,000', 1),
(1019721003, 'Mercedes-Benz S-Class', 1, '1,364,000,000', 1),
(1019861008, 'Porsche 911', 1, '1,425,000,000', 1),
(1019861010, 'Lamborghini Aventador', 1, '7,615,000,000', 1),
(1019891021, 'Fiat 500', 1, '330,000,000', 2),
(1019981004, 'Chevrolet Corvette', 1, '862,200,000', 1),
(1020151003, 'Honda Civic', 1, '407,000,000', 1),
(1020151007, 'Audi A4', 1, '736,300,000', 1),
(1020151011, 'Rolls-Royce Phantom', 1, '6,300,000,000', 1),
(1020161033, 'Mini Cooper', 1, '670,000,000', 2),
(1020171032, 'Jaguar F-PACE', 1, '1,710,000,000', 2),
(1020171034, 'Smart Fortwo', 1, '210,000,000', 2),
(1020181002, 'Toyota Camry', 1, '355,140,000', 1),
(1020181009, 'Ferrari 488', 1, '4,215,000,000', 1),
(1020181014, 'Hyundai Sonata', 1, '405,000,000', 2),
(1020181035, 'Peugeot 3008', 1, '705,000,000', 2),
(1020191012, 'Bentley Continental GT', 1, '3,150,000,000', 2),
(1020191016, 'Nissan Rogue', 1, '417,000,000', 2),
(1020191020, 'Tesla Model S', 0, '1,190,500,000', 2),
(1020191024, 'Chrysler Pacifica', 0, '1,200,000,000', 1),
(1020191028, 'Buick Enclave', 0, '1,350,000,000', 1),
(1020191031, 'Land Rover Range Rover', 0, '5,100,000,000', 1),
(1020191036, 'Citroen C4 Picasso', 0, '750,000,000', 2),
(1020191040, 'Seat Leon', 0, '510,000,000', 2),
(1020191043, 'Alfa Romeo Giulia', 0, '2,340,000,000', 2),
(1020191047, 'McLaren 720S', 0, '11,520,000,000', 2),
(1020201005, 'BMW 3 Series', 0, '784,000,000', 1),
(1020201015, 'Kia Telluride', 0, 'Kia Telluride', 2),
(1020201018, 'Subaru Outback', 0, '423,000,000', 2),
(1020201023, 'Jeep Wrangler', 0, '990,000,000', 1),
(1020201027, 'Cadillac Escalade', 0, '5,850,000,000', 1),
(1020201037, 'Renault Megane', 0, '465,000,000', 2),
(1020201042, 'Opel Vauxhall Astra', 0, '630,000,000', 2),
(1020201046, 'Bugatti Chiron', 0, '275,000,000,000', 2),
(1020211013, 'Mazda MX-5 Miata', 0, '451,200,000', 2),
(1020211017, 'Volvo XC90', 0, '9,056,000,000', 2),
(1020211022, '1020211022', 0, '1,800,000,000', 1),
(1020211025, 'RAM 1500', 0, '1,800,000,000', 1),
(1020211029, 'Acura MDX', 0, '1,170,000,000', 2),
(1020211038, 'Volkswagen Golf', 0, '770,000,000', 2),
(1020211041, 'Dacia Sandero', 0, '240,000,000', 2),
(1020211045, 'Aston Martin DB11', 0, '13,950,000,000', 2),
(1020211048, 'Koenigsegg Jesko', 0, '180,000,000,000', 2),
(1020211050, 'Rimac C_Two', 0, '36,000,000,000', 2),
(1020221019, 'Mitsubishi Outlander', 0, '364,500,000', 2),
(1020221026, 'GMC Sierra 1500', 0, '1,500,000,000', 1),
(1020221030, 'Infiniti QX60', 0, '1,500,000,000', 1),
(1020221039, 'Skoda Octavia', 0, '495,000,000', 2),
(1020221044, 'Maserati Quattroporte', 0, '12,900,000,000', 2),
(1020221049, 'Pagani Huayra', 0, '207,900,000,000', 2),
(1023578169, 'Moto Guzzi V9 Bobber', 0, '141,000,000', 7),
(1023987654, 'Zero SR/F', 0, '700,000,000', 6),
(1025893476, 'Yamaha Wabash', 0, '60,000,000', 5),
(1028476913, 'Indian Scout Bobber', 0, '169,000,000', 7),
(1029376584, 'Bianchi Oltre XR4', 0, '120,000,000', 7),
(1029378465, 'Pinarello Dogma F12', 0, '300,000,000', 7),
(1032154897, 'Harley-Davidson LiveWire', 0, '600,000,000', 7),
(1034987621, 'Scott Addict', 0, '70,000,000', 4),
(1038567921, 'Ridley Helium SLX', 0, '80,000,000', 3),
(1038592746, 'Focus Izalco Max', 0, '70,000,000', 6),
(1039502876, 'Trek Verve+', 0, '30,000,000', 3),
(1042893750, 'Riese & Müller Nevo', 0, '100,000,000', 4),
(1045689731, 'Ford Mustang Mach-E', 0, 'Ford Mustang Mach-E	1,500,000,', 6),
(1045871396, 'Specialized Roubaix', 0, '60,000,000', 8),
(1046890251, 'Honda Rebel 500', 0, '96,000,000', 7),
(1049578136, 'Colnago C64', 0, '150,000,000', 6),
(1049587623, 'Husqvarna Svartpilen 401', 0, '79,000,000', 8),
(1049856321, 'Ducati Panigale V4', 0, '298,000,000', 7),
(1050214789, 'Chevrolet Bolt EV', 0, '900,000,000', 4),
(1056789412, 'BMC Roadmachine', 0, '80,000,000', 6),
(1056937284, 'Wilier Cento10NDR', 0, '150,000,000', 5),
(1063927185, 'Suzuki GSX-R750', 0, '176,000,000', 5),
(1065328497, 'BMW i3', 0, '1,500,000,000', 4),
(1065472938, 'Electra Townie Go!', 0, '30,000,000', 6),
(1069132745, 'Cannondale Synapse', 0, '50,000,000', 4),
(1069837451, 'KTM 390 Duke', 0, '87,000,000', 5),
(1069847532, 'Aprilia RSV4', 0, '366,000,000', 5),
(1071294685, 'Rad Power Bikes RadCity', 0, '30,000,000', 4),
(1073124985, 'Harley-Davidson Street 750', 0, '113,000,000', 5),
(1075982463, 'Nissan Leaf', 0, '800,000,000', 4),
(1076983452, 'Cervelo S5', 0, '100,000,000', 8),
(1078246715, 'Specialized Turbo Vado', 0, '50,000,000', 6),
(1084736195, 'Trek Domane', 0, '183,000,000', 4),
(1085739261, 'Royal Enfield Interceptor 650', 0, '84,000,000', 4),
(1087694215, 'Rad Power Bikes RadRunner', 0, '25,000,000', 4),
(1089472365, 'Vespa Elettrica', 0, '500,000,000', 8),
(1089473651, 'Giant Defy', 0, '40,000,000', 8),
(1090345782, 'Juiced Bikes RipCurrent S', 0, '60,000,000', 5),
(1091632548, 'BMW S1000RR', 0, '233,000,000', 5),
(1092718746, 'Yamaha YZF-R1', 0, '245,000,000', 5),
(1096345271, 'Orbea Orca', 0, '70,000,000', 4),
(1096347285, 'Gazelle Arroyo', 0, '60,000,000', 9),
(1098745312, 'Tesla Model S', 0, '2,500,000,000', 4);

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

--
-- Table structure for table `employee`
--

CREATE TABLE `employee` (
  `employee_id` int(11) NOT NULL,
  `name` varchar(30) NOT NULL,
  `address` varchar(50) NOT NULL,
  `phone_number` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` (`employee_id`, `name`, `address`, `phone_number`) VALUES
(9821, 'Nathan Thompson', 'Main Street - Haddonfield', '609-287-6043'),
(23587, 'Daniel Brown', 'Mill Street - New Castle', '872-465-3290'),
(27654, 'Jessica Martin', 'South Street - Albion', '520-834-7162'),
(34592, 'Alexandra Carter', 'Washington Street - Florence', '325-983-2456'),
(45623, 'Michael Wright', '5th Street - Columbus Junction', '937-284-5193'),
(54309, 'David Garcia', 'Rose Street - Berlin', '831-571-8290'),
(76548, 'Rachel Lee', 'Spring Street - Haddon Heights', '456-283-1987'),
(80934, 'Samantha Rodriguez', 'Maple Drive - Cloverdale', '215-684-3098'),
(88888, 'GusniaUBD', 'kp.kandang', '09876544536'),
(98762, 'Emily Davis', 'Meadow Lane - Clinton', '670-125-9381'),
(98765, 'Taeyongieeeee', 'Jl Krakatau 999, Palembang, Sumatera Selatan, Indo', '09876544536'),
(98767, 'Taeyongieeeee', 'Jl Krakatau 999, Palembang, Sumatera Selatan, Indo', '09876544536'),
(998876, 'Gusnia', 'kp.kandang', '0987657777'),
(1209749, 'Taeyong', 'Pine Street - Auburn', '09876544536'),
(1234568, '', '', ''),
(1234569, '', '', ''),
(2426481, 'Gusnia', 'Pine Street - Auburn', '09876544536'),
(2426777, 'fitria', 'Jl Krakatau 999, Palembang, Sumatera Selatan, Indo', '09876577878');

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

--
-- Table structure for table `pelanggan`
--

CREATE TABLE `pelanggan` (
  `costumer_id` int(20) NOT NULL,
  `costumer_name` varchar(20) NOT NULL,
  `username` varchar(20) NOT NULL,
  `password` varchar(50) NOT NULL,
  `costumer_num` varchar(30) NOT NULL,
  `costumer_email` varchar(50) NOT NULL,
  `costumer_address` varchar(50) NOT NULL,
  `employee_id` int(20) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `pelanggan`
--

INSERT INTO `pelanggan` (`costumer_id`, `costumer_name`, `username`, `password`, `costumer_num`, `costumer_email`, `costumer_address`, `employee_id`) VALUES
(54643, 'Michael Brown', '(702) 888-3000', 'michael.brown@gmail.com', 'michael.brown@gmail.com', 'apaya', '7634826', 1),
(135790, 'William Rodriguez', 'William', 'c3c17ac36cab79f91ca377df556d0ced', '(876) 543-2109', 'william.rodriguez@email.com', 'Oak Lane - Georgetown', 27654),
(135862, 'Benjamin Kim', 'Benjamin', '72d42854e681ca05142b29be0c607214', '(505) 274-1270', 'benjamin.kim@example.com', 'Division Street - Auburn', 80934),
(197354, 'Ethan Lee', 'Ethan', '038db7c3d42021770d7e1c2fefd1909b', '(630) 218-5427', 'ethan.lee@email.com', 'Sunset Drive - Clarksburg', 54309),
(207853, 'Sophia Kim', 'Sophia', '5da14cb19bd63ef9700d8daac1b9788a', '(987) 654-3210', 'sophia.kim@email.com', '2nd Street - Middletown', 23587),
(216459, 'Anthony Martinez', 'Anthony', '227b2c6f4c62cdcc0721528623d6e20a', '(786) 681-8521', 'anthony.martinez@example.com', 'Front Street - Minden', 9821),
(276941, 'Isabella Brown', 'Isabella ', 'd80c5fa6e3ea5015eadad3e222ce8322', '(333) 444-5555', 'isabella.brown@email.com', 'Broad Street - West Haven', 76548),
(284615, 'Maya Patel', 'Maya', 'd9509a81072c0dee5735c4246619face', '(202) 815-7938', 'maya.patel@example.com', 'Cherry Street - Lawrenceville', 23587),
(351628, 'Sophia Nguyen', 'Sophia', '424d48bc66fda81a6811d5424444a3bd', '(863) 606-9507', 'sophia.nguyen@example.com', 'College Street - Amherst', 34592),
(361087, 'Laura Garcia', 'Laura', '5093e974b0899b65f190d1cd012bd262', '(888) 555-1212', 'lauragarcia@email.com', 'Madison Avenue - Redding', 76548),
(362159, 'Emily Patel', 'Emily', '4aaa7fe38d3468ec3bd39c87cba9e428', '(714) 655-4379', 'emily.patel@email.com', 'Elmwood Avenue - Springfield', 9821),
(395871, 'James Smith', 'James', '45a668e02b1b5df1d7fcb11b28026a02', '(999) 888-7777', 'james.smith@email.com', 'Hillcrest Drive - Sweetwater', 9821),
(419085, 'Olivia Davis', 'Olivia', 'de590813651db78b9fc92d60e8ca53b2', '(444) 555-6666', 'olivia.davis@email.com', 'South Avenue - Millbrae', 45623),
(425861, 'Samantha Carter', 'Samantha', '1629ce8120d770e285aea1e7750473c9', '(478) 522-7684', 'samantha.carter@email.com', 'Cedar Lane - Madisonville', 27654),
(430975, 'Mia Davis', 'Mia', '055b36ebec8c8795d146a9bbbb96609f', '(777) 666-5555', 'mia.davis@email.com', 'Orchard Street - Verona', 80934),
(480156, 'Emily Davis', 'Emily', 'be00ed2a98dd1ef6bf33451a59acf348', '(508) 919-1861', 'emily.davis@example.com', 'Railroad Street - High Point', 54309),
(509612, 'Alexander Martinez', 'Alexander', '9872c54aa4a081b13204089b7ec127c2', '(456) 789-0123', 'alex.martinez@email.com', 'Forest Avenue - North Haven', 45623),
(527983, 'Samuel Jackson', 'Samuel', '8934ebd810f0ee040c5d3c168c0567ae', '(650) 714-3729', 'samuel.jackson@example.com', 'Clinton Street - Elizabeth City', 98762),
(589624, 'Jenna Martinnnn', 'Jenna', '1234567890', '23456789', 'jennamartin@email.com', 'Pine Street - Cikarang', 0),
(590614, 'Dylan Nguyen', 'Dylan', '546c02a8e6dcbf3dda0d9fb6be14c4f5', '(205) 635-9820', 'dylan.nguyen@example.com', 'Lincoln Street - Pine Bluff', 76548),
(642308, 'Emma Baker', 'Emma', 'd67bba5760f89b92f71b42f3d8d778f4', '(555) 777-8888', 'emma.baker@email.com', 'Maple Street - Hazleton', 34592),
(671324, 'Ethan Hernandez', 'Ethan', '1ea6c73a0e2a5a5748a49c3d9badd094', '(777) 888-9999', 'ethan.hernandez@email.com', 'Willow Drive - Elmira', 98762),
(724139, 'Kevin Lee', 'Kevin', '4b8eea26820ce67f64b1698ab1bc6eab', '321654098', 'kevinlee@email.com', 'Highview Road - Bismarck', 9821),
(769420, 'Lily Chen', 'Lily', '4044fa26d50db40830364b0cc4327600', '(614) 579-4136', 'lily.chen@example.com', 'Prospect Street - Cranford', 45623),
(786234, 'Olivia Garcia', 'Olivia', 'fd4c702eb52a7b162c6916c8565a44e4', '(236) 617-8214', 'olivia.garcia@email.com', 'Jackson Avenue - Fort Walton Beach', 98762),
(851624, 'Jacob Garcia', 'Jacob ', 'f65d26ccfbbed4747c67b2ba5b6fe1db', '(222) 333-4444', 'jacob.garcia@email.com', 'Woodland Drive - McHenry', 98767),
(3610888, 'Fitria', 'Nia', '122333', '(777) 888-97777', 'niafitria@email.com', 'Madison Avenue - Redding', 23587),
(123872399, 'nie', '(702) 888-27777', 'jenniee@email.com', 'jenniee@email.com', 'Pine Street - Auburnnnn', '23587', 1);

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

--
-- Table structure for table `review`
--

CREATE TABLE `review` (
  `review_id` int(11) NOT NULL,
  `costumer_name` varchar(30) NOT NULL,
  `costumer_email` varchar(30) NOT NULL,
  `model` varchar(30) NOT NULL,
  `type_id` int(11) NOT NULL,
  `comment` varchar(255) NOT NULL,
  `location` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `review`
--

INSERT INTO `review` (`review_id`, `costumer_name`, `costumer_email`, `model`, `type_id`, `comment`, `location`) VALUES
(27, 'Michael Brown', 'sophia.nguyen@example.com', 'rover', 1, '<p>i like the car, it was so smooth, i think i\'m gonna buy it soon.', 'cikarang'),
(33, 'Jenna Martinnnn', 'jennamartin@email.com', 'Honda Civic', 1, '<p>It&#39;s a nice car and i really like this fiture</p>\r\n', 'Jababeka'),
(34, 'Sophia Nguyen', 'sophia.nguyen@example.com', 'rover', 1, '<p>i really like it</p>\r\n', 'Bekasi');

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

--
-- Table structure for table `supplier`
--

CREATE TABLE `supplier` (
  `supplier_id` int(11) NOT NULL,
  `vehicle_id` int(11) NOT NULL,
  `name` varchar(20) NOT NULL,
  `address` varchar(50) NOT NULL,
  `phone_number` varchar(20) NOT NULL,
  `email` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `supplier`
--

INSERT INTO `supplier` (`supplier_id`, `vehicle_id`, `name`, `address`, `phone_number`, `email`) VALUES
(16161, 1012345678, 'Diamond Air Cargo', 'Suite 600- Austin', '525-559-6973', 'info@diamondair.com'),
(11111, 1012634809, 'Platinum Freight Sol', 'Suite 700-Atlanta', '525-593-6489', 'info@platinumfreightsolutions.'),
(44456, 1012876543, 'Starlight Transports', 'Suite 500-Dallas', '525-577-8476', 'info@starlighttransports.com'),
(44456, 1012938475, 'Starlight Transports', 'Suite 500-Dallas', '525-577-8476', 'mailto:info@starlighttransport'),
(18181, 1013748596, 'Platinum Railways', 'Suite 500-Washington', '525-590-7492', 'info@platinumrailways.com'),
(99911, 1014759386, 'Greyhound Transport', 'Suite 300-Philadelphia', '525-548-7975', 'info@greyhoundtransport.com'),
(18181, 1014789653, 'Swift Express', 'Suite 300-Seattle', '525-589-7102', 'info@swiftexpress.com'),
(11123, 1019721001, 'Swift Express', 'Suite 300-Seattle', '525-589-7103', 'info@swiftexpress.com'),
(11123, 1019721003, 'Swift Express', 'Suite 300-Seattle', '525-589-7104', 'info@swiftexpress.com'),
(11123, 1019861008, 'Swift Express', 'Suite 300-Seattle', '525-589-7105', 'info@swiftexpress.com'),
(11123, 1019861010, 'Swift Express', 'Suite 300-Seattle', '525-589-7106', 'info@swiftexpress.com'),
(77789, 1019891021, 'Swift Express', 'Suite 300-Seattle', '525-589-7107', 'info@swiftexpress.com'),
(11123, 1019981004, 'Swift Express', 'Suite 300-Seattle', '525-589-7108', 'info@swiftexpress.com'),
(11123, 1020151003, 'Swift Express', 'Suite 300-Seattle', '525-589-7109', 'info@swiftexpress.com'),
(11123, 1020151007, 'Swift Express', 'Suite 300-Seattle', '525-589-7110', 'info@swiftexpress.com'),
(55567, 1020151011, 'Swift Express', 'Suite 300-Seattle', '525-589-7111', 'info@swiftexpress.com'),
(11123, 1020161033, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'),
(11123, 1020171032, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'),
(11123, 1020171034, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'),
(11123, 1020181002, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'),
(11123, 1020181009, 'Swift Express', 'Suite 300-Seattle', '525-589-7116', 'info@swiftexpress.com'),
(55567, 1020181014, 'Swift Express', 'Suite 300-Seattle', '525-589-7117', 'info@swiftexpress.com'),
(11123, 1020181035, 'Swift Express', 'Suite 300-Seattle', '525-589-7118', 'info@swiftexpress.com'),
(55567, 1020191012, 'Swift Express', 'Suite 300-Seattle', '525-589-7119', 'info@swiftexpress.com'),
(11123, 1020191016, 'Purple Railways', 'Suite 600-San Francisco', '525-592-8453', 'info@purplerailways.com'),
(77789, 1020191020, 'Purple Railways', 'Suite 600-San Francisco', '525-592-8453', 'info@purplerailways.com'),
(66678, 1020191024, 'Purple Railways', 'Suite 600-San Francisco', '525-592-8453', 'info@purplerailways.com'),
(11123, 1020191028, 'Swift Express', 'Suite 300-Seattle', '525-589-7123', 'info@swiftexpress.com'),
(11123, 1020191031, 'Swift Express', 'Suite 300-Seattle', '525-589-7124', 'info@swiftexpress.com'),
(11123, 1020191036, 'Redwood Trucking', 'Suite 800-Beverly Hills', '525-505-7521', 'info@redwoodtrucking.com'),
(22234, 1020191040, 'Redwood Trucking', 'Suite 800-Beverly Hills', '525-505-7521', 'info@redwoodtrucking.com'),
(22234, 1020191043, 'Redwood Trucking', 'Suite 800-Beverly Hills', '525-505-7521', 'info@redwoodtrucking.com'),
(33345, 1020191047, 'Swift Express', 'Suite 300-Seattle', '525-589-7128', 'info@swiftexpress.com'),
(11123, 1020201005, 'Swift Express', 'Suite 300-Seattle', '525-589-7129', 'info@swiftexpress.com'),
(11123, 1020201015, 'Swift Express', 'Suite 300-Seattle', '525-589-7130', 'info@swiftexpress.com'),
(11123, 1020201018, 'Swift Express', 'Suite 300-Seattle', '525-589-7131', 'info@swiftexpress.com'),
(11123, 1020201023, 'Swift Express', 'Suite 300-Seattle', '525-589-7132', 'info@swiftexpress.com'),
(11123, 1020201027, 'Swift Express', 'Suite 300-Seattle', '525-589-7133', 'info@swiftexpress.com'),
(11123, 1020201037, 'Swift Express', 'Suite 300-Seattle', '525-589-7134', 'info@swiftexpress.com'),
(22234, 1020201042, 'Swift Express', 'Suite 300-Seattle', '525-589-7135', 'info@swiftexpress.com'),
(33345, 1020201046, 'Swift Express', 'Suite 300-Seattle', '525-589-7136', 'info@swiftexpress.com'),
(55567, 1020211013, 'Swift Express', 'Suite 300-Seattle', '525-589-7137', 'info@swiftexpress.com'),
(11123, 1020211017, 'Swift Express', 'Suite 300-Seattle', '525-589-7138', 'info@swiftexpress.com'),
(11123, 1020211022, 'Swift Express', 'Suite 300-Seattle', '525-589-7139', 'info@swiftexpress.com'),
(66678, 1020211025, 'Swift Express', 'Suite 300-Seattle', '525-589-7140', 'info@swiftexpress.com'),
(11123, 1020211029, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'),
(11123, 1020211038, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'),
(22234, 1020211041, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'),
(22234, 1020211045, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'),
(33345, 1020211048, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'),
(33345, 1020211050, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'),
(77789, 1020221019, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'),
(66678, 1020221026, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'),
(11123, 1020221030, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'),
(11123, 1020221039, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'),
(22234, 1020221044, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'),
(33345, 1020221049, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'),
(88891, 1023578169, 'Thunder Air Cargo', 'Suite 200-New York', '525-531-9315', 'info@thunderaircargo.com'),
(15151, 1023987654, 'Stellar Transports', 'Suite 300-San Francisco', '525-503-7582', 'info@stellar.com'),
(15151, 1025893476, 'Stellar Transports', 'Suite 300-San Francisco', '525-503-7582', 'info@stellar.com'),
(88891, 1028476913, 'Thunder Air Cargo', 'Suite 200-New York', '525-531-9315', 'info@thunderaircargo.com'),
(17171, 1029376584, 'Sunburst Shipping', 'Suite 100-Miami', '525-542-9780', 'info@sunburst.com'),
(14141, 1029378465, 'Swift Carriers', 'Suite 200-Boston', '525-534-9056', 'info@swifcarriers.com'),
(14141, 1032154897, 'Swift Carriers', 'Suite 200-Boston', '525-534-9056', 'info@swifcarriers.com'),
(12121, 1034987621, 'Thunder Air Cargo', 'Suite 800-Dallas', '525-512-7916', 'info@thunderaircargo.com'),
(11111, 1038567921, 'Platinum Freight Sol', 'Suite 700-Atlanta', '525-593-6489', 'info@platinumfreightsolutions.'),
(14141, 1038592746, 'Swift Carriers', 'Suite 200-Boston', '525-534-9056', 'info@swifcarriers.com'),
(16161, 1039502876, 'Diamond Air Cargo', 'Suite 600- Austin', '525-559-6973', 'info@diamondair.com'),
(12121, 1042893750, 'Thunder Air Cargo', 'Suite 800-Dallas', '525-512-7916', 'info@thunderaircargo.com'),
(13131, 1045689731, 'Transworld Carriers', 'Suite 400-San Diego', '525-567-8205', 'info@transworld.com'),
(99911, 1045871396, 'Greyhound Transport', 'Suite 300-Philadelphia', '525-548-7975', 'info@greyhoundtransport.com'),
(33345, 1046890251, 'Starlight Transports', 'Suite 500-Dallas', '525-577-8476', 'info@starlighttransports.com'),
(16161, 1049578136, 'Diamond Air Cargo', 'Suite 600- Austin', '525-559-6973', 'info@diamondair.com'),
(99911, 1049587623, 'Greyhound Transport', 'Suite 300-Philadelphia', '525-548-7975', 'info@greyhoundtransport.com'),
(44456, 1049856321, 'Starlight Transports', 'Suite 500-Dallas', '525-577-8476', 'info@starlighttransports.com'),
(11111, 1050214789, 'Platinum Freight Sol', 'Suite 700-Atlanta', '525-593-6489', 'info@platinumfreightsolutions.'),
(13131, 1056789412, 'Transworld Carriers', 'Suite 400-San Diego', '525-567-8205', 'info@transworld.com'),
(13131, 1056937284, 'Transworld Carriers', 'Suite 400-San Diego', '525-567-8205', 'info@transworld.com'),
(44456, 1063927185, 'Starlight Transports', 'Suite 500-Dallas', '525-577-8476', 'info@starlighttransports.com'),
(12121, 1065328497, 'Thunder Air Cargo', 'Suite 800-Dallas', '525-512-7916', 'info@thunderaircargo.com'),
(13131, 1065472938, 'Transworld Carriers', 'Suite 400-San Diego', '525-567-8205', 'info@transworld.com'),
(10101, 1069132745, 'Black Stallion Shipp', 'Black Stallion Shipping	Suite 100-Seattle', '525-569-6345', 'info@blackstallionshipping.com'),
(88891, 1069837451, 'Thunder Air Cargo', 'Suite 200-New York', '525-531-9315', 'info@thunderaircargo.com'),
(88891, 1069847532, 'Thunder Air Cargo', 'Suite 200-New York', '525-531-9315', 'info@thunderaircargo.com'),
(16161, 1071294685, 'Diamond Air Cargo', 'Suite 600- Austin', '525-559-6973', 'info@diamondair.com'),
(33345, 1073124985, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'),
(18181, 1075982463, 'Platinum Railways', 'Suite 500-Washington', '525-590-7492', 'info@platinumrailways.com'),
(15151, 1076983452, 'Stellar Transports', 'Suite 300-San Francisco', '525-503-7582', 'info@stellar.com'),
(17171, 1078246715, 'Sunburst Shipping', 'Suite 100-Miami', '525-542-9780', 'info@sunburst.com'),
(10101, 1084736195, 'Black Stallion Shipp', 'Suite 100-Seattle', '525-569-6345', 'info@blackstallionshipping.com'),
(10101, 1085739261, 'Black Stallion Shipp', 'Suite 100-Seattle', '525-569-6345', 'info@blackstallionshipping.com'),
(15151, 1087694215, 'Stellar Transports', 'Suite 300-San Francisco', '525-503-7582', 'info@stellar.com'),
(17171, 1089472365, 'Sunburst Shipping', 'Suite 100-Miami', '525-542-9780', 'info@sunburst.com'),
(11111, 1089473651, 'Platinum Freight Sol', 'Suite 700-Atlanta', '525-593-6489', 'info@platinumfreightsolutions.'),
(14141, 1090345782, 'Swift Carriers', 'Suite 200-Boston', '525-534-9056', 'info@swifcarriers.com'),
(44456, 1091632548, 'Starlight Transports', 'Suite 500-Dallas', '525-577-8476', 'info@starlighttransports.com'),
(44456, 1092718746, 'Starlight Transports', 'Suite 500-Dallas', '525-577-8476', 'info@starlighttransports.com'),
(12121, 1096345271, 'Thunder Air Cargo', 'Suite 800-Dallas', '525-512-7916', 'info@thunderaircargo.com'),
(18181, 1096347285, 'Platinum Railways', 'Suite 500-Washington', '525-590-7492', 'info@platinumrailways.com'),
(17171, 1098745312, 'Sunburst Shipping', 'Suite 100-Miami', '525-542-9780', 'info@sunburst.com'),
(11111111, 2147483647, 'Gusnia', 'kp.kandang', '0987657777', 'jennamartin@email.com');

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

--
-- 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,
  `comment` varchar(255) NOT NULL,
  `location` varchar(30) 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`, `comment`, `location`) VALUES
(91864, 31478264, 12387461, 'apaantuh', 'gak tau'),
(98643, 31478264, 98765, 'apaantuh', 'gak tau'),
(220201, 1019981004, 207853, 'Nice features, but not very comfortable', 'Country roads and highways'),
(220308, 1020221019, 683590, 'Very fast and great handling', 'Urban roads and highways'),
(220314, 1020191012, 276941, 'Handles well, but acceleration is lacking', 'Off-road trails and rocky terr'),
(220407, 1019861010, 642308, 'Well-rounded and comfortable ride.', 'city streets and suburban road'),
(220503, 1020201005, 853614, 'Smooth ride and good acceleration', 'Country roads and highways'),
(220608, 1020211017, 197354, 'Spacious and comfortable, but lacking in power', 'Off-road trails and rocky terr'),
(220615, 1019721001, 589624, 'Great handling and acceleration', 'Off-road trails and rocky terr'),
(220731, 1020181014, 430975, 'Nice features, but not very comfortable', 'Mountain roads and unpaved tra'),
(220821, 1019861008, 908756, 'Tight handling and decent acceleration', 'City streets and highways'),
(220910, 1020151011, 395871, 'Great handling and acceleration', 'Country roads and highways'),
(221026, 1020181002, 724139, 'Handles well, but acceleration is lacking', 'Urban roads and highways'),
(221030, 1020221026, 480156, 'Solid performance overall', 'city streets and suburban road'),
(221105, 1020201027, 913275, 'Spacious and comfortable, but lacking in power', 'Off-road trails and rocky terr'),
(221109, 1020181009, 135790, 'Very fast and great handling', 'Urban roads and highways'),
(221117, 1019891021, 590614, 'Great handling and acceleration', 'Urban roads and highways'),
(221124, 1020191020, 362159, 'Well-rounded and comfortable ride.', 'Urban roads and highways'),
(221202, 1020211029, 216459, 'Very fast and great handling', 'Off-road trails and rocky terr'),
(221207, 1020221030, 840973, 'Well-rounded and comfortable ride.', 'Off-road trails and rocky terr'),
(221211, 1020151007, 671324, 'Spacious and comfortable, but lacking in power', 'City streets and highways'),
(221228, 1020191024, 769420, 'Nice features, but not very comfortable', 'City streets and highways'),
(221229, 1020201018, 425861, 'Tight handling and decent acceleration', 'Off-road trails and rocky terr'),
(230111, 1020201023, 135862, 'Needs better acceleration and handling', 'City streets and highways'),
(230120, 1020211013, 851624, 'Needs better acceleration and handling', 'Country roads and highways'),
(230226, 1020211022, 284615, 'Handles well, but acceleration is lacking', 'Urban roads and highways'),
(230302, 1020201015, 509612, 'Smooth ride and good acceleration', 'Country roads and highways'),
(230377, 123098, 361087, 'Needs better acceleration and handling', 'Country roads and highways');

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

--
-- Table structure for table `type`
--

CREATE TABLE `type` (
  `type_id` int(11) NOT NULL,
  `type` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `type`
--

INSERT INTO `type` (`type_id`, `type`) VALUES
(1, 'Car'),
(2, 'Motorcycle'),
(3, 'Bycicle'),
(4, 'Electric Bicycle'),
(5, 'Electric Car'),
(6, 'Electric Motorcycle');

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admin`
--
ALTER TABLE `admin`
  ADD PRIMARY KEY (`vehicle_id`);

--
-- Indexes for table `employee`
--
ALTER TABLE `employee`
  ADD PRIMARY KEY (`employee_id`);

--
-- Indexes for table `pelanggan`
--
ALTER TABLE `pelanggan`
  ADD PRIMARY KEY (`costumer_id`);

--
-- Indexes for table `review`
--
ALTER TABLE `review`
  ADD PRIMARY KEY (`review_id`);

--
-- Indexes for table `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`vehicle_id`);

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

--
-- Indexes for table `type`
--
ALTER TABLE `type`
  ADD PRIMARY KEY (`type_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admin`
--
ALTER TABLE `admin`
  MODIFY `vehicle_id` int(30) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1098745313;

--
-- AUTO_INCREMENT for table `employee`
--
ALTER TABLE `employee`
  MODIFY `employee_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2426778;

--
-- AUTO_INCREMENT for table `pelanggan`
--
ALTER TABLE `pelanggan`
  MODIFY `costumer_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=123872400;

--
-- AUTO_INCREMENT for table `review`
--
ALTER TABLE `review`
  MODIFY `review_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=35;

--
-- AUTO_INCREMENT for table `supplier`
--
ALTER TABLE `supplier`
  MODIFY `vehicle_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2147483648;

--
-- AUTO_INCREMENT for table `test_drive`
--
ALTER TABLE `test_drive`
  MODIFY `testdrive_id` int(20) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9186481;

--
-- AUTO_INCREMENT for table `type`
--
ALTER TABLE `type`
  MODIFY `type_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;
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 */;
