nZQSeFUi

1-- phpMyAdmin SQL Dump
2-- version 4.5.2
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Generation Time: Nov 24, 2017 at 11:14 PM
7-- Server version: 5.7.9
8-- PHP Version: 7.0.0
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8mb4 */;
18
19--
20-- Database: `autolot`
21--
22
23-- --------------------------------------------------------
24
25--
26-- Table structure for table `customers`
27--
28
29DROP TABLE IF EXISTS `customers`;
30CREATE TABLE IF NOT EXISTS `customers` (
31  `custID` int(5) NOT NULL,
32  `FirstName` varchar(50) NOT NULL,
33  `LastName` varchar(50) NOT NULL,
34  PRIMARY KEY (`custID`)
35) ENGINE=MyISAM DEFAULT CHARSET=latin1;
36
37--
38-- Dumping data for table `customers`
39--
40
41INSERT INTO `customers` (`custID`, `FirstName`, `LastName`) VALUES
42(1, 'mmay', 'ree'),
43(2, 'enyii', 'alpho'),
44(3, 'ujunwa', 'ogbuotobo'),
45(4, 'ugochi', 'iwuchukwu'),
46(5, 'jacinta', 'nwaobi');
47
48-- --------------------------------------------------------
49
50--
51-- Table structure for table `inventory`
52--
53
54DROP TABLE IF EXISTS `inventory`;
55CREATE TABLE IF NOT EXISTS `inventory` (
56  `CarID` varchar(50) NOT NULL,
57  `Make` varchar(50) NOT NULL,
58  `Color` varchar(50) NOT NULL,
59  `PetName` varchar(10) NOT NULL,
60  PRIMARY KEY (`CarID`)
61) ENGINE=MyISAM DEFAULT CHARSET=latin1;
62
63--
64-- Dumping data for table `inventory`
65--
66
67INSERT INTO `inventory` (`CarID`, `Make`, `Color`, `PetName`) VALUES
68('17', 'VW', '', ''),
69('32', 'Ford', 'chocolate', 'zippy'),
70('872', 'Saab', 'orange', 'rusty'),
71('888', 'Yugo', 'blue', 'Mel'),
72('1000', 'BMW', 'pink', 'Clunker');
73
74-- --------------------------------------------------------
75
76--
77-- Table structure for table `orders`
78--
79
80DROP TABLE IF EXISTS `orders`;
81CREATE TABLE IF NOT EXISTS `orders` (
82  `OrderID` int(11) NOT NULL,
83  `custID` int(11) NOT NULL,
84  `carID` int(11) NOT NULL,
85  PRIMARY KEY (`OrderID`)
86) ENGINE=MyISAM DEFAULT CHARSET=latin1;
87
88--
89-- Dumping data for table `orders`
90--
91
92INSERT INTO `orders` (`OrderID`, `custID`, `carID`) VALUES
93(1000, 4, 888),
94(1001, 1, 17),
95(1002, 5, 1000),
96(1003, 2, 32),
97(1004, 3, 872);
98
99/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
100/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
101/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;