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