-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci ;
USE `mydb` ;

-- -----------------------------------------------------
-- Table `mydb`.`product_available_parameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`product_available_parameters` (
  `id` INT NOT NULL,
  `name` VARCHAR(255) NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`product_parameters`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`product_parameters` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `product_id` INT NULL,
  `product_available_parameters_id` INT NOT NULL,
  `parameter_value` VARCHAR(255) NULL,
  PRIMARY KEY (`id`, `product_available_parameters_id`),
  INDEX `fk_product_parameters_product_available_parameters1_idx` (`product_available_parameters_id` ASC),
  INDEX `parameter_value` (`parameter_value` ASC),
  CONSTRAINT `fk_product_parameters_product_available_parameters1`
    FOREIGN KEY (`product_available_parameters_id`)
    REFERENCES `mydb`.`product_available_parameters` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`category`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`category` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(255) NULL,
  `product_parameters` TEXT NULL,
  PRIMARY KEY (`id`),
  UNIQUE INDEX `name` (`name` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`products`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`products` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(300) NULL,
  `description` TEXT NULL,
  `price` FLOAT NULL,
  `oldprice` FLOAT NULL,
  `price_difference_percentage` INT NULL,
  `brand_id` INT NULL,
  `thumbnail_url` VARCHAR(255) NULL,
  `product_parameters_id` INT NOT NULL,
  `category_id` INT NOT NULL,
  PRIMARY KEY (`id`, `category_id`),
  INDEX `price` (`price` ASC, `oldprice` ASC, `price_difference_percentage` ASC),
  INDEX `fk_products_product_parameters_idx` (`product_parameters_id` ASC),
  INDEX `fk_products_category1_idx` (`category_id` ASC),
  CONSTRAINT `fk_products_product_parameters`
    FOREIGN KEY (`product_parameters_id`)
    REFERENCES `mydb`.`product_parameters` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_products_category1`
    FOREIGN KEY (`category_id`)
    REFERENCES `mydb`.`category` (`id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;

<param name="Цвет">черный</param>
<param name="Коллекция">Осень-зима 2014/2015</param>
<param name="Внешний материал">фетр</param>
<param name="Сезонность">Зима</param>
<param name="Ширина голенища">34</param>
<param name="Материал подошвы">искусственный материал</param>
<param name="Страна-изготовитель">Россия</param>
<param name="Unit=RU">41</param>
<param name="Пол">Женский</param>
<param name="Возраст">Взрослый</param>

<param name="Цвет">синий</param>
<param name="Коллекция">Осень-зима 2014/2015</param>
<param name="Сезонность">Мульти</param>
<param name="Страна-изготовитель">Китай</param>
<param name="Unit=INT">48/50</param>
<param name="Пол">Мужской</param>
<param name="Возраст">Взрослый</param>

`product_parameters_id` INT NOT NULL,