rh7N3DWr

1TRUNCATE TABLE City;
2TRUNCATE TABLE Customer;
3TRUNCATE TABLE Orders;
4TRUNCATE TABLE Pizza;
5TRUNCATE TABLE PizzaToppings;
6TRUNCATE TABLE Restaurant;
7TRUNCATE TABLE States;
8TRUNCATE TABLE Topping;
9
10CREATE TABLE IF NOT EXISTS `City` (
11  `CityID` int(11) NOT NULL AUTO_INCREMENT,
12  `CityName` varchar(128) DEFAULT NULL,
13  PRIMARY KEY (`CityID`),
14  UNIQUE KEY `CityID_UNIQUE` (`CityID`)
15) ENGINE=InnoDB DEFAULT CHARSET=latin1;
16
17CREATE TABLE IF NOT EXISTS `Customer` (
18  `CustomerID` int(11) NOT NULL AUTO_INCREMENT,
19  `CustomerName` varchar(45) DEFAULT NULL,
20  `StreetNum` varchar(45) DEFAULT NULL,
21  `StreetName` varchar(45) DEFAULT NULL,
22  `CityID` int(11) DEFAULT NULL,
23  `StateID` int(11) DEFAULT NULL,
24  PRIMARY KEY (`CustomerID`),
25  UNIQUE KEY `CustomerID_UNIQUE` (`CustomerID`)
26) ENGINE=InnoDB DEFAULT CHARSET=latin1;
27
28CREATE TABLE IF NOT EXISTS `Orders` (
29  `Order_SK` int(11) NOT NULL AUTO_INCREMENT,
30  `OrderNum` varchar(45) DEFAULT NULL,
31  `CustomerID` varchar(45) DEFAULT NULL,
32  `PizzaID` varchar(45) DEFAULT NULL,
33  `RestID` varchar(45) DEFAULT NULL,
34  PRIMARY KEY (`Order_SK`),
35  UNIQUE KEY `Order_SK_UNIQUE` (`Order_SK`)
36) ENGINE=InnoDB DEFAULT CHARSET=latin1;
37
38CREATE TABLE IF NOT EXISTS `Pizza` (
39  `PizzaID` int(11) NOT NULL AUTO_INCREMENT,
40  `PizzaName` varchar(45) DEFAULT NULL,
41  PRIMARY KEY (`PizzaID`),
42  UNIQUE KEY `PizzaID_UNIQUE` (`PizzaID`)
43) ENGINE=InnoDB DEFAULT CHARSET=latin1;
44
45CREATE TABLE IF NOT EXISTS `PizzaToppings` (
46  `idPizzaToppings` int(11) NOT NULL AUTO_INCREMENT,
47  `PizzaID` int(11) NOT NULL,
48  `PizzaName` varchar(45) NOT NULL,
49  PRIMARY KEY (`idPizzaToppings`),
50  UNIQUE KEY `idPizzaToppings_UNIQUE` (`idPizzaToppings`)
51) ENGINE=InnoDB DEFAULT CHARSET=latin1;
52
53CREATE TABLE IF NOT EXISTS `Restaurant` (
54  `RestID` int(11) NOT NULL AUTO_INCREMENT,
55  `RestName` varchar(45) DEFAULT NULL,
56  PRIMARY KEY (`RestID`),
57  UNIQUE KEY `RestID_UNIQUE` (`RestID`)
58) ENGINE=InnoDB DEFAULT CHARSET=latin1;
59
60CREATE TABLE IF NOT EXISTS `States` (
61  `StateID` int(11) NOT NULL AUTO_INCREMENT,
62  `StateName` varchar(45) DEFAULT NULL,
63  `StateCD` varchar(2) DEFAULT NULL,
64  PRIMARY KEY (`StateID`),
65  UNIQUE KEY `StateID_UNIQUE` (`StateID`),
66  UNIQUE KEY `StateName_UNIQUE` (`StateName`),
67  UNIQUE KEY `StateCD_UNIQUE` (`StateCD`)
68) ENGINE=InnoDB DEFAULT CHARSET=latin1;
69
70CREATE TABLE IF NOT EXISTS `Topping` (
71  `ToppingID` int(11) NOT NULL AUTO_INCREMENT,
72  `ToppingName` varchar(45) DEFAULT NULL,
73  PRIMARY KEY (`ToppingID`),
74  UNIQUE KEY `ToppingID_UNIQUE` (`ToppingID`)
75) ENGINE=InnoDB DEFAULT CHARSET=latin1;