hs7iBiUW

1INSERT INTO Ingredient(Name, Price)
2values ('Chocolate', '10.50');
3	
4-- MySQL Workbench Forward Engineering
5
6SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
7SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
8SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
9
10-- -----------------------------------------------------
11-- Schema BrendaStore
12-- -----------------------------------------------------
13DROP SCHEMA IF EXISTS `BrendaStore` ;
14
15-- -----------------------------------------------------
16-- Schema BrendaStore
17-- -----------------------------------------------------
18CREATE SCHEMA IF NOT EXISTS `BrendaStore` DEFAULT CHARACTER SET utf8 ;
19SHOW WARNINGS;
20USE `BrendaStore` ;
21
22-- -----------------------------------------------------
23-- Table `Vendor`
24-- -----------------------------------------------------
25DROP TABLE IF EXISTS `Vendor` ;
26
27SHOW WARNINGS;
28CREATE TABLE IF NOT EXISTS `Vendor` (
29  `idVendor` INT NOT NULL AUTO_INCREMENT,
30  `Name` VARCHAR(45) NOT NULL,
31  `Address` VARCHAR(45) NOT NULL,
32  PRIMARY KEY (`idVendor`))
33ENGINE = InnoDB;
34
35SHOW WARNINGS;
36
37-- -----------------------------------------------------
38-- Table `Shop`
39-- -----------------------------------------------------
40DROP TABLE IF EXISTS `Shop` ;
41
42SHOW WARNINGS;
43CREATE TABLE IF NOT EXISTS `Shop` (
44  `idShop` INT NOT NULL AUTO_INCREMENT,
45  `Name` VARCHAR(45) NOT NULL,
46  `Address` VARCHAR(45) NOT NULL,
47  `PhoneNumber` VARCHAR(45) NOT NULL,
48  PRIMARY KEY (`idShop`))
49ENGINE = InnoDB;
50
51SHOW WARNINGS;
52
53-- -----------------------------------------------------
54-- Table `Product`
55-- -----------------------------------------------------
56DROP TABLE IF EXISTS `Product` ;
57
58SHOW WARNINGS;
59CREATE TABLE IF NOT EXISTS `Product` (
60  `idProduct` INT NOT NULL AUTO_INCREMENT,
61  `Name` VARCHAR(45) NOT NULL,
62  `ProductPrice` DECIMAL(4,2) NOT NULL,
63  `Shop_idShop` INT NOT NULL,
64  PRIMARY KEY (`idProduct`),
65  INDEX `fk_Product_Shop1_idx` (`Shop_idShop` ASC),
66  CONSTRAINT `fk_Product_Shop1`
67    FOREIGN KEY (`Shop_idShop`)
68    REFERENCES `Shop` (`idShop`)
69    ON DELETE NO ACTION
70    ON UPDATE NO ACTION)
71ENGINE = InnoDB;
72
73SHOW WARNINGS;
74
75-- -----------------------------------------------------
76-- Table `Recipe`
77-- -----------------------------------------------------
78DROP TABLE IF EXISTS `Recipe` ;
79
80SHOW WARNINGS;
81CREATE TABLE IF NOT EXISTS `Recipe` (
82  `idRecipe` INT NOT NULL AUTO_INCREMENT,
83  `IngredientAmount` VARCHAR(45) NOT NULL,
84  `Product_idProduct` INT NOT NULL,
85  PRIMARY KEY (`idRecipe`),
86  INDEX `fk_Recipe_Product1_idx` (`Product_idProduct` ASC),
87  CONSTRAINT `fk_Recipe_Product1`
88    FOREIGN KEY (`Product_idProduct`)
89    REFERENCES `Product` (`idProduct`)
90    ON DELETE NO ACTION
91    ON UPDATE NO ACTION)
92ENGINE = InnoDB;
93
94SHOW WARNINGS;
95
96-- -----------------------------------------------------
97-- Table `Ingredient`
98-- -----------------------------------------------------
99DROP TABLE IF EXISTS `Ingredient` ;
100
101SHOW WARNINGS;
102CREATE TABLE IF NOT EXISTS `Ingredient` (
103  `idIngredient` INT NOT NULL AUTO_INCREMENT,
104  `Name` VARCHAR(45) NOT NULL,
105  `Price` DECIMAL(2,2) NOT NULL,
106  `Vendor_idVendor` INT NOT NULL,
107  `Recipe_idRecipe` INT NOT NULL,
108  `Product_idProduct` INT NOT NULL,
109  PRIMARY KEY (`idIngredient`),
110  INDEX `fk_Ingredient_Vendor_idx` (`Vendor_idVendor` ASC),
111  INDEX `fk_Ingredient_Recipe1_idx` (`Recipe_idRecipe` ASC),
112  INDEX `fk_Ingredient_Product1_idx` (`Product_idProduct` ASC),
113  CONSTRAINT `fk_Ingredient_Vendor`
114    FOREIGN KEY (`Vendor_idVendor`)
115    REFERENCES `Vendor` (`idVendor`)
116    ON DELETE NO ACTION
117    ON UPDATE NO ACTION,
118  CONSTRAINT `fk_Ingredient_Recipe1`
119    FOREIGN KEY (`Recipe_idRecipe`)
120    REFERENCES `Recipe` (`idRecipe`)
121    ON DELETE NO ACTION
122    ON UPDATE NO ACTION,
123  CONSTRAINT `fk_Ingredient_Product1`
124    FOREIGN KEY (`Product_idProduct`)
125    REFERENCES `Product` (`idProduct`)
126    ON DELETE NO ACTION
127    ON UPDATE NO ACTION)
128ENGINE = InnoDB;
129
130SHOW WARNINGS;
131
132-- -----------------------------------------------------
133-- Table `Client`
134-- -----------------------------------------------------
135DROP TABLE IF EXISTS `Client` ;
136
137SHOW WARNINGS;
138CREATE TABLE IF NOT EXISTS `Client` (
139  `idClient` INT NOT NULL AUTO_INCREMENT,
140  `Name` VARCHAR(45) NOT NULL,
141  `PhoneNumber` VARCHAR(45) NOT NULL,
142  `Email` VARCHAR(45) NOT NULL,
143  PRIMARY KEY (`idClient`))
144ENGINE = InnoDB;
145
146SHOW WARNINGS;
147
148-- -----------------------------------------------------
149-- Table `Purchase`
150-- -----------------------------------------------------
151DROP TABLE IF EXISTS `Purchase` ;
152
153SHOW WARNINGS;
154CREATE TABLE IF NOT EXISTS `Purchase` (
155  `idPurchase` INT NOT NULL AUTO_INCREMENT,
156  `PurchaseDate` DATETIME NOT NULL,
157  `PurchaseAmount` DECIMAL(2,2) NOT NULL,
158  `Client_idClient` INT NOT NULL,
159  PRIMARY KEY (`idPurchase`),
160  INDEX `fk_Purchase_Client1_idx` (`Client_idClient` ASC),
161  CONSTRAINT `fk_Purchase_Client1`
162    FOREIGN KEY (`Client_idClient`)
163    REFERENCES `Client` (`idClient`)
164    ON DELETE NO ACTION
165    ON UPDATE NO ACTION)
166ENGINE = InnoDB;
167
168SHOW WARNINGS;
169
170-- -----------------------------------------------------
171-- Table `Orders`
172-- -----------------------------------------------------
173DROP TABLE IF EXISTS `Orders` ;
174
175SHOW WARNINGS;
176CREATE TABLE IF NOT EXISTS `Orders` (
177  `idOrders` INT NOT NULL AUTO_INCREMENT,
178  `Date` DATETIME NOT NULL,
179  `Quantity` VARCHAR(45) NOT NULL,
180  `Price` VARCHAR(45) NOT NULL,
181  PRIMARY KEY (`idOrders`))
182ENGINE = InnoDB;
183
184SHOW WARNINGS;
185
186-- -----------------------------------------------------
187-- Table `Employee`
188-- -----------------------------------------------------
189DROP TABLE IF EXISTS `Employee` ;
190
191SHOW WARNINGS;
192CREATE TABLE IF NOT EXISTS `Employee` (
193  `idEmployee` INT NOT NULL AUTO_INCREMENT,
194  `Name` VARCHAR(45) NOT NULL,
195  `Address` VARCHAR(45) NOT NULL,
196  `PhoneNumber` VARCHAR(45) NOT NULL,
197  PRIMARY KEY (`idEmployee`))
198ENGINE = InnoDB;
199
200SHOW WARNINGS;
201
202-- -----------------------------------------------------
203-- Table `Shop_has_Employee`
204-- -----------------------------------------------------
205DROP TABLE IF EXISTS `Shop_has_Employee` ;
206
207SHOW WARNINGS;
208CREATE TABLE IF NOT EXISTS `Shop_has_Employee` (
209  `Shop_idShop` INT NOT NULL,
210  `Employee_idEmployee` INT NOT NULL,
211  PRIMARY KEY (`Shop_idShop`, `Employee_idEmployee`),
212  INDEX `fk_Shop_has_Employee_Employee1_idx` (`Employee_idEmployee` ASC),
213  INDEX `fk_Shop_has_Employee_Shop1_idx` (`Shop_idShop` ASC),
214  CONSTRAINT `fk_Shop_has_Employee_Shop1`
215    FOREIGN KEY (`Shop_idShop`)
216    REFERENCES `Shop` (`idShop`)
217    ON DELETE NO ACTION
218    ON UPDATE NO ACTION,
219  CONSTRAINT `fk_Shop_has_Employee_Employee1`
220    FOREIGN KEY (`Employee_idEmployee`)
221    REFERENCES `Employee` (`idEmployee`)
222    ON DELETE NO ACTION
223    ON UPDATE NO ACTION)
224ENGINE = InnoDB;
225
226SHOW WARNINGS;
227
228-- -----------------------------------------------------
229-- Table `Ingredient_has_Orders`
230-- -----------------------------------------------------
231DROP TABLE IF EXISTS `Ingredient_has_Orders` ;
232
233SHOW WARNINGS;
234CREATE TABLE IF NOT EXISTS `Ingredient_has_Orders` (
235  `Ingredient_idIngredient` INT NOT NULL,
236  `Orders_idOrders` INT NOT NULL,
237  PRIMARY KEY (`Ingredient_idIngredient`, `Orders_idOrders`),
238  INDEX `fk_Ingredient_has_Orders_Orders1_idx` (`Orders_idOrders` ASC),
239  INDEX `fk_Ingredient_has_Orders_Ingredient1_idx` (`Ingredient_idIngredient` ASC),
240  CONSTRAINT `fk_Ingredient_has_Orders_Ingredient1`
241    FOREIGN KEY (`Ingredient_idIngredient`)
242    REFERENCES `Ingredient` (`idIngredient`)
243    ON DELETE NO ACTION
244    ON UPDATE NO ACTION,
245  CONSTRAINT `fk_Ingredient_has_Orders_Orders1`
246    FOREIGN KEY (`Orders_idOrders`)
247    REFERENCES `Orders` (`idOrders`)
248    ON DELETE NO ACTION
249    ON UPDATE NO ACTION)
250ENGINE = InnoDB;
251
252SHOW WARNINGS;
253
254-- -----------------------------------------------------
255-- Table `Product_has_Purchase`
256-- -----------------------------------------------------
257DROP TABLE IF EXISTS `Product_has_Purchase` ;
258
259SHOW WARNINGS;
260CREATE TABLE IF NOT EXISTS `Product_has_Purchase` (
261  `Product_idProduct` INT NOT NULL,
262  `Purchase_idPurchase` INT NOT NULL,
263  PRIMARY KEY (`Product_idProduct`, `Purchase_idPurchase`),
264  INDEX `fk_Product_has_Purchase_Purchase1_idx` (`Purchase_idPurchase` ASC),
265  INDEX `fk_Product_has_Purchase_Product1_idx` (`Product_idProduct` ASC),
266  CONSTRAINT `fk_Product_has_Purchase_Product1`
267    FOREIGN KEY (`Product_idProduct`)
268    REFERENCES `Product` (`idProduct`)
269    ON DELETE NO ACTION
270    ON UPDATE NO ACTION,
271  CONSTRAINT `fk_Product_has_Purchase_Purchase1`
272    FOREIGN KEY (`Purchase_idPurchase`)
273    REFERENCES `Purchase` (`idPurchase`)
274    ON DELETE NO ACTION
275    ON UPDATE NO ACTION)
276ENGINE = InnoDB;
277
278SHOW WARNINGS;
279
280SET SQL_MODE=@OLD_SQL_MODE;
281SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
282SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;