-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Waktu pembuatan: 07 Bulan Mei 2023 pada 18.14
-- Versi server: 10.4.28-MariaDB
-- Versi PHP: 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: `login`
--

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

--
-- Struktur dari tabel `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 untuk tabel `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');

--
-- Indexes for dumped tables
--

--
-- Indeks untuk tabel `supplier`
--
ALTER TABLE `supplier`
  ADD PRIMARY KEY (`vehicle_id`);

--
-- AUTO_INCREMENT untuk tabel yang dibuang
--

--
-- AUTO_INCREMENT untuk tabel `supplier`
--
ALTER TABLE `supplier`
  MODIFY `vehicle_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1098745313;
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 */;
