-- phpMyAdmin SQL Dump -- version 5.2.1 -- https://www.phpmyadmin.net/ -- -- Host: 127.0.0.1 -- Generation Time: May 07, 2023 at 09:53 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 `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 (11123, 1019721001, 'Swift Express', 'Suite 300-Seattle', '525-589-7102', 'info@swiftexpress.com'), (11123, 1019721003, 'Swift Express', 'Suite 300-Seattle', '525-589-7107', 'info@swiftexpress.com'), (11123, 1019861008, 'Swift Express', 'Suite 300-Seattle', '525-589-7109', 'info@swiftexpress.com'), (11123, 1019861010, 'Swift Express', 'Suite 300-Seattle', '525-589-7111', 'info@swiftexpress.com'), (77789, 1019891021, 'Purple Railways', 'Suite 600-San Francisco ', '525-592-8453', 'info@purplerailways.com'), (11123, 1019981004, 'Swift Express', 'Suite 300-Seattle', '1019981004', 'info@swiftexpress.com'), (11123, 1020151003, 'Swift Express', 'Suite 300-Seattle', '525-589-7104', 'info@swiftexpress.com'), (11123, 1020151007, 'Swift Express', 'Suite 300-Seattle', '525-589-7108', 'info@swiftexpress.com'), (55567, 1020151011, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'), (11123, 1020161033, 'Swift Express', 'Suite 300-Seattle', '525-589-7134', 'info@swiftexpress.com'), (11123, 1020171032, 'Swift Express', 'Suite 300-Seattle', '525-589-7133', 'info@swiftexpress.com'), (11123, 1020171034, 'Swift Express', 'Suite 300-Seattle', '525-589-7135', 'info@swiftexpress.com'), (11123, 1020181002, 'Swift Express', 'Suite 300-Seattle', '525-589-7103', 'info@swiftexpress.com'), (11123, 1020181009, 'Swift Express', 'Suite 300-Seattle', '525-589-7110', 'info@swiftexpress.com'), (55567, 1020181014, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'), (11123, 1020181035, 'Swift Express', 'Suite 300-Seattle', '525-589-7136', 'info@swiftexpress.com'), (55567, 1020191012, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'), (11123, 1020191016, 'Swift Express', 'Suite 300-Seattle', '525-589-7117', 'info@swiftexpress.com'), (77789, 1020191020, 'Purple Railways', 'Suite 600-San Francisco', '525-592-8453', 'info@purplerailways.com'), (66678, 1020191024, 'Redwood Trucking', 'Suite 800-Beverly Hills', '525-505-7521', 'info@redwoodtrucking.com'), (11123, 1020191028, 'Swift Express', 'Suite 300-Seattle', '525-589-7129', 'info@swiftexpress.com'), (11123, 1020191031, 'Swift Express', 'Suite 300-Seattle', '525-589-7132', 'info@swiftexpress.com'), (11123, 1020191036, 'Swift Express', 'Suite 300-Seattle', '525-589-7137', 'info@swiftexpress.com'), (22234, 1020191040, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'), (22234, 1020191043, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'), (33345, 1020191047, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'), (11123, 1020201005, 'Swift Express', 'Suite 300-Seattle', '525-589-7106', 'info@swiftexpress.com'), (11123, 1020201015, 'Swift Express', 'Suite 300-Seattle', '525-589-7116', 'info@swiftexpress.com'), (11123, 1020201018, 'Swift Express', 'Suite 300-Seattle', '525-589-7119', 'info@swiftexpress.com'), (11123, 1020201023, 'Swift Express', 'Suite 300-Seattle', '525-589-7124', 'info@swiftexpress.com'), (11123, 1020201027, 'Swift Express', 'Suite 300-Seattle', '525-589-7128', 'info@swiftexpress.com'), (11123, 1020201037, 'Swift Express', 'Suite 300-Seattle', '525-589-7138', 'info@swiftexpress.com'), (22234, 1020201042, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'), (33345, 1020201046, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'), (55567, 1020211013, 'Blue Horizon Freight', 'Suite 400-Chicago', '525-538-6234', 'info@bluehorizonfreight.com'), (11123, 1020211017, 'Swift Express', 'Suite 300-Seattle', '525-589-7118', 'info@swiftexpress.com'), (11123, 1020211022, 'Swift Express', 'Suite 300-Seattle', '525-589-7123', 'info@swiftexpress.com'), (66678, 1020211025, 'Redwood Trucking', 'Suite 800-Beverly Hills', '525-505-7521', 'info@redwoodtrucking.com'), (11123, 1020211029, 'Swift Express', 'Suite 300-Seattle', '525-589-7130', 'info@swiftexpress.com'), (11123, 1020211038, 'Swift Express', 'Suite 300-Seattle', '525-589-7139', 'info@swiftexpress.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, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.cominfo@ea'), (33345, 1020211050, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'), (77789, 1020221019, 'Purple Railways', 'Suite 600-San Francisco ', '525-592-8453 ', 'info@purplerailways.com'), (66678, 1020221026, 'Redwood Trucking', 'Suite 800-Beverly Hills', '525-505-7521', 'info@redwoodtrucking.com'), (11123, 1020221030, 'Swift Express', 'Suite 300-Seattle', '525-589-7131', 'info@swiftexpress.com'), (11123, 1020221039, 'Swift Express', 'Suite 300-Seattle', '525-589-7140', 'info@swiftexpress.com'), (22234, 1020221044, 'Velocity Shipping', 'Suite 200-Los Angeles', '525-501-7536', 'info@velocityshipping.com'), (33345, 1020221049, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'), (33345, 1046890251, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'), (33345, 1073124985, 'Eagle Logistics', 'Suite 100-New York', '525-524-9013', 'info@eaglelogistics.com'); -- -- Indexes for dumped tables -- -- -- Indexes for table `supplier` -- ALTER TABLE `supplier` ADD PRIMARY KEY (`vehicle_id`); -- -- AUTO_INCREMENT for dumped tables -- -- -- AUTO_INCREMENT for table `supplier` -- ALTER TABLE `supplier` MODIFY `vehicle_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1073124986; 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 */;