ZPp9GzW3

1-- MySQL Workbench Forward Engineering
2
3SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
4SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
5SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';
6
7-- -----------------------------------------------------
8-- Schema mydb
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema mydb
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 ;
15USE `mydb` ;
16
17-- -----------------------------------------------------
18-- Table `mydb`.`Customer`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `mydb`.`Customer` (
21  `idCustomer` INT NOT NULL AUTO_INCREMENT,
22  `Username` VARCHAR(45) NOT NULL,
23  `Password` VARCHAR(45) NOT NULL,
24  PRIMARY KEY (`idCustomer`))
25ENGINE = InnoDB;
26
27
28-- -----------------------------------------------------
29-- Table `mydb`.`Admin`
30-- -----------------------------------------------------
31CREATE TABLE IF NOT EXISTS `mydb`.`Admin` (
32  `idAdmin` INT NOT NULL AUTO_INCREMENT,
33  `Username` VARCHAR(45) NOT NULL,
34  `Password` VARCHAR(45) NOT NULL,
35  PRIMARY KEY (`Username`))
36ENGINE = InnoDB;
37
38
39-- -----------------------------------------------------
40-- Table `mydb`.`Products`
41-- -----------------------------------------------------
42CREATE TABLE IF NOT EXISTS `mydb`.`Products` (
43  `idProducts` INT NOT NULL AUTO_INCREMENT,
44  `Name` VARCHAR(45) NOT NULL,
45  `Price` INT NOT NULL,
46  `Stock` INT NOT NULL,
47  `Picture` VARCHAR(80) NOT NULL,
48  `Review` INT NULL,
49  PRIMARY KEY (`idProducts`))
50ENGINE = InnoDB;
51
52
53-- -----------------------------------------------------
54-- Table `mydb`.`Orders`
55-- -----------------------------------------------------
56CREATE TABLE IF NOT EXISTS `mydb`.`Orders` (
57  `idOrders` INT NOT NULL,
58  `Price` INT NOT NULL,
59  `Customer_id` INT NOT NULL,
60  PRIMARY KEY (`idOrders`),
61  INDEX `fk_Orders_Customer1_idx` (`Customer_id` ASC),
62  CONSTRAINT `fk_Orders_Customer1`
63    FOREIGN KEY (`Customer_id`)
64    REFERENCES `mydb`.`Customer` (`idCustomer`)
65    ON DELETE NO ACTION
66    ON UPDATE NO ACTION)
67ENGINE = InnoDB;
68
69
70-- -----------------------------------------------------
71-- Table `mydb`.`Order_Prod`
72-- -----------------------------------------------------
73CREATE TABLE IF NOT EXISTS `mydb`.`Order_Prod` (
74  `Orders_id` INT NOT NULL,
75  `Amount` INT NOT NULL,
76  `Products_id` INT NOT NULL,
77  INDEX `fk_Order_Prod_Orders1_idx` (`Orders_id` ASC),
78  INDEX `fk_Order_Prod_Products1_idx` (`Products_id` ASC),
79  CONSTRAINT `fk_Order_Prod_Orders1`
80    FOREIGN KEY (`Orders_id`)
81    REFERENCES `mydb`.`Orders` (`idOrders`)
82    ON DELETE NO ACTION
83    ON UPDATE NO ACTION,
84  CONSTRAINT `fk_Order_Prod_Products1`
85    FOREIGN KEY (`Products_id`)
86    REFERENCES `mydb`.`Products` (`idProducts`)
87    ON DELETE NO ACTION
88    ON UPDATE NO ACTION)
89ENGINE = InnoDB;
90
91
92-- -----------------------------------------------------
93-- Table `mydb`.`Cart`
94-- -----------------------------------------------------
95CREATE TABLE IF NOT EXISTS `mydb`.`Cart` (
96  `Customer_id` INT NOT NULL,
97  `Products_id` INT NOT NULL,
98  INDEX `fk_Cart_Customer1_idx` (`Customer_id` ASC),
99  INDEX `fk_Cart_Products1_idx` (`Products_id` ASC),
100  CONSTRAINT `fk_Cart_Customer1`
101    FOREIGN KEY (`Customer_id`)
102    REFERENCES `mydb`.`Customer` (`idCustomer`)
103    ON DELETE NO ACTION
104    ON UPDATE NO ACTION,
105  CONSTRAINT `fk_Cart_Products1`
106    FOREIGN KEY (`Products_id`)
107    REFERENCES `mydb`.`Products` (`idProducts`)
108    ON DELETE NO ACTION
109    ON UPDATE NO ACTION)
110ENGINE = InnoDB;
111
112
113-- -----------------------------------------------------
114-- Table `mydb`.`Review`
115-- -----------------------------------------------------
116CREATE TABLE IF NOT EXISTS `mydb`.`Review` (
117  `Products_id` INT NOT NULL,
118  `Rating` INT NULL,
119  `Customer_id` INT NOT NULL,
120  INDEX `fk_Review_Products1_idx` (`Products_id` ASC),
121  INDEX `fk_Review_Customer1_idx` (`Customer_id` ASC),
122  CONSTRAINT `fk_Review_Products1`
123    FOREIGN KEY (`Products_id`)
124    REFERENCES `mydb`.`Products` (`idProducts`)
125    ON DELETE NO ACTION
126    ON UPDATE NO ACTION,
127  CONSTRAINT `fk_Review_Customer1`
128    FOREIGN KEY (`Customer_id`)
129    REFERENCES `mydb`.`Customer` (`idCustomer`)
130    ON DELETE NO ACTION
131    ON UPDATE NO ACTION)
132ENGINE = InnoDB;
133
134
135SET SQL_MODE=@OLD_SQL_MODE;
136SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
137SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;