yuBQxjg6

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