ArvMM5zJ

1--
2-- Database: autolot
3--
4
5-- --------------------------------------------------------
6
7--
8-- Table structure for table customers
9--
10create schema isThisTheProblem
11go 
12DROP TABLE IF EXISTS isThisTheProblem.customers
13go
14CREATE TABLE isThisTheProblem.customers (
15  custID int NOT NULL,
16  FirstName varchar(50) NOT NULL,
17  LastName varchar(50) NOT NULL,
18  PRIMARY KEY (custID)
19)
20-- ENGINE=MyISAM DEFAULT CHARSET=latin1;
21
22--
23-- Dumping data for table customers
24--
25
26INSERT INTO isThisTheProblem.customers (custID, FirstName, LastName) VALUES
27(1, 'mmay', 'ree'),
28(2, 'enyii', 'alpho'),
29(3, 'ujunwa', 'ogbuotobo'),
30(4, 'ugochi', 'iwuchukwu'),
31(5, 'jacintha', 'nwadinobi');
32
33-- --------------------------------------------------------
34
35--
36-- Table structure for table inventory
37--
38
39DROP TABLE IF EXISTS inventory;
40CREATE TABLE isThisTheProblem.inventory (
41  CarID varchar(50) NOT NULL,
42  Make varchar(50) NOT NULL,
43  Color varchar(50) NOT NULL,
44  PetName varchar(10) NOT NULL,
45  PRIMARY KEY (CarID)
46)
47
48--
49-- Dumping data for table inventory
50--
51
52INSERT INTO isThisTheProblem.inventory (CarID, Make, Color, PetName) VALUES
53('17', 'VW', '', ''),
54('32', 'Ford', 'chocolate', 'zippy'),
55('872', 'Saab', 'orange', 'rusty'),
56('888', 'Yugo', 'blue', 'Mel'),
57('1000', 'BMW', 'pink', 'Clunker');
58
59-- --------------------------------------------------------
60
61--
62-- Table structure for table orders
63--
64
65DROP TABLE IF EXISTS orders;
66CREATE TABLE isThisTheProblem.orders (
67  OrderID int NOT NULL,
68  custID int NOT NULL,
69  carID int NOT NULL,
70  PRIMARY KEY (OrderID)
71)
72
73--
74-- Dumping data for table orders
75--
76
77INSERT INTO isThisTheProblem.orders (OrderID, custID, carID) VALUES
78(1000, 4, 888),
79(1001, 1, 17),
80(1002, 5, 1000),
81(1003, 2, 32),
82(1004, 3, 872);
83
84/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
85/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
86/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;