wtqrGak9

1CREATE  TABLE IF NOT EXISTS `mydb`.`category` (
2  `id` INT NOT NULL ,
3  `name` VARCHAR(45) NULL ,
4  `parent_id` INT NULL ,
5  PRIMARY KEY (`id`) ,
6  INDEX `parentCategory_idx` (`parent_id` ASC) ,
7  CONSTRAINT `parentCategory`
8    FOREIGN KEY (`parent_id` )
9    REFERENCES `mydb`.`category` (`id` )
10    ON DELETE CASCADE
11    ON UPDATE CASCADE)
12ENGINE = InnoDB;
13
14
15
16CREATE  TABLE IF NOT EXISTS `mydb`.`product` (
17  `id` INT NOT NULL ,
18  `name` VARCHAR(45) NULL ,
19  PRIMARY KEY (`id`) )
20ENGINE = InnoDB;
21
22CREATE  TABLE IF NOT EXISTS `mydb`.`product_category` (
23  `product_id` INT NOT NULL ,
24  `category_id` INT NOT NULL ,
25  PRIMARY KEY (`product_id`, `category_id`) ,
26  INDEX `product_idx` (`product_id` ASC) ,
27  INDEX `category_idx` (`category_id` ASC) ,
28  CONSTRAINT `product`
29    FOREIGN KEY (`product_id` )
30    REFERENCES `mydb`.`product` (`id` )
31    ON DELETE CASCADE
32    ON UPDATE CASCADE,
33  CONSTRAINT `category`
34    FOREIGN KEY (`category_id` )
35    REFERENCES `mydb`.`category` (`id` )
36    ON DELETE CASCADE
37    ON UPDATE CASCADE)
38ENGINE = InnoDB;