zuWUTK8a

1CREATE SCHEMA IF NOT EXISTS `foo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
2USE `foo`;
3
4-- -----------------------------------------------------
5-- Table `foo`.`attribute`
6-- -----------------------------------------------------
7CREATE  TABLE IF NOT EXISTS `foo`.`attribute` (
8  `attribute_id` INT NOT NULL AUTO_INCREMENT ,
9  `parent` INT NOT NULL ,
10  `name` VARCHAR(45) NOT NULL ,
11  PRIMARY KEY (`attribute_id`) )
12ENGINE = InnoDB;
13
14
15-- -----------------------------------------------------
16-- Table `foo`.`product`
17-- -----------------------------------------------------
18CREATE  TABLE IF NOT EXISTS `foo`.`product` (
19  `product_id` INT NOT NULL AUTO_INCREMENT ,
20  `name` VARCHAR(45) NULL ,
21  PRIMARY KEY (`product_id`) )
22ENGINE = InnoDB;
23
24
25-- -----------------------------------------------------
26-- Table `foo`.`product_attribute`
27-- -----------------------------------------------------
28CREATE  TABLE IF NOT EXISTS `foo`.`product_attribute` (
29  `product_id` INT NOT NULL ,
30  `attribute_id` INT NOT NULL ,
31  PRIMARY KEY (`product_id`, `attribute_id`) ,
32  INDEX `fk_product_attribute_product` (`product_id` ASC) ,
33  INDEX `fk_product_attribute_attribute` (`attribute_id` ASC) )
34ENGINE = InnoDB;