BajSTBnv

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='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';
6
7-- -----------------------------------------------------
8-- Schema restockchicago
9-- -----------------------------------------------------
10
11-- -----------------------------------------------------
12-- Schema restockchicago
13-- -----------------------------------------------------
14CREATE SCHEMA IF NOT EXISTS `restockchicago` ;
15USE `restockchicago` ;
16
17-- -----------------------------------------------------
18-- Table `restockchicago`.`ProductsImages`
19-- -----------------------------------------------------
20CREATE TABLE IF NOT EXISTS `restockchicago`.`ProductsImages` (
21  `idImages` INT NOT NULL,
22  `Imagescol` VARCHAR(255) NULL,
23  PRIMARY KEY (`idImages`))
24ENGINE = InnoDB;
25
26
27-- -----------------------------------------------------
28-- Table `restockchicago`.`ProductsIcons`
29-- -----------------------------------------------------
30CREATE TABLE IF NOT EXISTS `restockchicago`.`ProductsIcons` (
31  `idIcons` INT NOT NULL,
32  `Iconscol` VARCHAR(255) NULL,
33  PRIMARY KEY (`idIcons`))
34ENGINE = InnoDB;
35
36
37-- -----------------------------------------------------
38-- Table `restockchicago`.`Products`
39-- -----------------------------------------------------
40CREATE TABLE IF NOT EXISTS `restockchicago`.`Products` (
41  `idProducts` INT NOT NULL,
42  `name` VARCHAR(255) NOT NULL,
43  `price` INT UNSIGNED NULL,
44  `Images` INT NULL,
45  `Icons` INT NOT NULL,
46  PRIMARY KEY (`idProducts`),
47  INDEX `fk_Products_ProductsImages_idx` (`Images` ASC) VISIBLE,
48  INDEX `fk_Products_ProductsIcons1_idx` (`Icons` ASC) VISIBLE,
49  CONSTRAINT `fk_Products_ProductsImages`
50    FOREIGN KEY (`Images`)
51    REFERENCES `restockchicago`.`ProductsImages` (`idImages`)
52    ON DELETE SET NULL
53    ON UPDATE NO ACTION,
54  CONSTRAINT `fk_Products_ProductsIcons1`
55    FOREIGN KEY (`Icons`)
56    REFERENCES `restockchicago`.`ProductsIcons` (`idIcons`)
57    ON DELETE NO ACTION
58    ON UPDATE NO ACTION)
59ENGINE = InnoDB;
60
61
62-- -----------------------------------------------------
63-- Table `restockchicago`.`CategoriesImages`
64-- -----------------------------------------------------
65CREATE TABLE IF NOT EXISTS `restockchicago`.`CategoriesImages` (
66  `idCategoriesImages` INT NOT NULL,
67  `CategoriesImagescol` VARCHAR(255) NULL,
68  PRIMARY KEY (`idCategoriesImages`))
69ENGINE = InnoDB;
70
71
72-- -----------------------------------------------------
73-- Table `restockchicago`.`CategoriesIcons`
74-- -----------------------------------------------------
75CREATE TABLE IF NOT EXISTS `restockchicago`.`CategoriesIcons` (
76  `idCategoriesIcons` INT NOT NULL,
77  `CategoriesIconscol` VARCHAR(255) NULL,
78  PRIMARY KEY (`idCategoriesIcons`))
79ENGINE = InnoDB;
80
81
82-- -----------------------------------------------------
83-- Table `restockchicago`.`Categories`
84-- -----------------------------------------------------
85CREATE TABLE IF NOT EXISTS `restockchicago`.`Categories` (
86  `idCategories` INT NOT NULL,
87  `parent` VARCHAR(255) NULL,
88  `name` VARCHAR(45) NOT NULL,
89  `Images` INT NULL,
90  `Icons` INT NULL,
91  UNIQUE INDEX `idCategories_UNIQUE` (`idCategories` ASC) VISIBLE,
92  PRIMARY KEY (`idCategories`),
93  UNIQUE INDEX `name_UNIQUE` (`name` ASC) VISIBLE,
94  INDEX `fk_Categories_CategoriesImages1_idx` (`Images` ASC) VISIBLE,
95  INDEX `fk_Categories_CategoriesIcons1_idx` (`Icons` ASC) VISIBLE,
96  CONSTRAINT `fk_Categories_CategoriesImages1`
97    FOREIGN KEY (`Images`)
98    REFERENCES `restockchicago`.`CategoriesImages` (`idCategoriesImages`)
99    ON DELETE SET NULL
100    ON UPDATE NO ACTION,
101  CONSTRAINT `fk_Categories_CategoriesIcons1`
102    FOREIGN KEY (`Icons`)
103    REFERENCES `restockchicago`.`CategoriesIcons` (`idCategoriesIcons`)
104    ON DELETE NO ACTION
105    ON UPDATE NO ACTION)
106ENGINE = InnoDB;
107
108
109-- -----------------------------------------------------
110-- Table `restockchicago`.`Categories_has_Products`
111-- -----------------------------------------------------
112CREATE TABLE IF NOT EXISTS `restockchicago`.`Categories_has_Products` (
113  `Categories_id` INT NULL,
114  `Products_id` INT NULL,
115  `product_category` INT NOT NULL,
116  PRIMARY KEY product_category (`product_id`,`category_id`),
117  INDEX `fk_Categories_has_Products_Products1_idx` (`Products_id` ASC) VISIBLE,
118  INDEX `fk_Categories_has_Products_Categories1_idx` (`Categories_id` ASC) VISIBLE,
119  UNIQUE INDEX `Products_idProducts_UNIQUE` (`Products_id` ASC) VISIBLE,
120  UNIQUE INDEX `Categories_idCategories_UNIQUE` (`Categories_id` ASC) VISIBLE,
121  CONSTRAINT `fk_Categories_has_Products_Categories1`
122    FOREIGN KEY (`Categories_id`)
123    REFERENCES `restockchicago`.`Categories` (`idCategories`)
124    ON DELETE NO ACTION
125    ON UPDATE NO ACTION,
126  CONSTRAINT `fk_Categories_has_Products_Products1`
127    FOREIGN KEY (`Products_id`)
128    REFERENCES `restockchicago`.`Products` (`idProducts`)
129    ON DELETE NO ACTION
130    ON UPDATE NO ACTION)
131ENGINE = InnoDB;
132
133
134SET SQL_MODE=@OLD_SQL_MODE;
135SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
136SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;