3xZPQjHE

1CREATE TABLE IF NOT EXISTS Pizza (
2PizzaID INT AUTO_INCREMENT,
3PizzaName VARCHAR(10) NOT NULL,
4PizzaPrice FLOAT NOT NULL,
5BaseID INT,
6ToppingID INT,
7PRIMARY KEY(PizzaID),
8CONSTRAINT FK_BaseID FOREIGN KEY (BaseID) REFERENCES PizzaBase(BaseID),
9CONSTRAINT FK_ToppingID FOREIGN KEY (ToppingID) REFERENCES PizzaToppings(ToppingID) );
10	
11CREATE TABLE IF NOT EXISTS PizzaToppings (
12ToppingID INT AUTO_INCREMENT,
13ToppingName TEXT NOT NULL,
14ToppingPrice FLOAT NOT NULL,
15ToppingDescrip VARCHAR(80),
16PRIMARY KEY(ToppingID) );