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