SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @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';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------

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

-- -----------------------------------------------------
-- Table `mydb`.`formulas_frm`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`formulas_frm` (
  `frm_id` INT NOT NULL,
  `frm_name` VARCHAR(45) NOT NULL,
  `frm_description` LONGTEXT NULL,
  `frm_author` VARCHAR(45) NULL,
  PRIMARY KEY (`frm_id`),
  UNIQUE INDEX `frm_id_UNIQUE` (`frm_id` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`variables_var`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`variables_var` (
  `formulas_frm_frm_id` INT NOT NULL,
  `var_id` INT NOT NULL,
  `var_name` VARCHAR(45) NOT NULL,
  `var_description` VARCHAR(255) NULL,
  PRIMARY KEY (`formulas_frm_frm_id`, `var_id`),
  UNIQUE INDEX `var_id_UNIQUE` (`var_id` ASC),
  INDEX `fk_variables_var_formulas_frm_idx` (`formulas_frm_frm_id` ASC),
  CONSTRAINT `fk_variables_var_formulas_frm`
    FOREIGN KEY (`formulas_frm_frm_id`)
    REFERENCES `mydb`.`formulas_frm` (`frm_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`inks_ink`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`inks_ink` (
  `ink_id` INT NOT NULL,
  `ink_name` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`ink_id`))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`gradients_grd`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`gradients_grd` (
  `grd_id` INT NOT NULL,
  `grad_name` VARCHAR(45) NULL,
  PRIMARY KEY (`grd_id`),
  UNIQUE INDEX `grd_id_UNIQUE` (`grd_id` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`image_img`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`image_img` (
  `img_id` INT NOT NULL,
  `img_title` VARCHAR(100) NOT NULL,
  `img_theme` ENUM('OUTERSPACE', 'ELEMENTS', 'LIFE', 'DIALOG', 'BEYOND') NOT NULL,
  `img_final` TINYINT NOT NULL,
  `img_created` DATETIME NOT NULL,
  PRIMARY KEY (`img_id`),
  UNIQUE INDEX `img_id_UNIQUE` (`img_id` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`layers_lay`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`layers_lay` (
  `ink_ink_ink_id` INT NOT NULL,
  `gradient_grd_grd_id` INT NOT NULL,
  `image_img_img_id` INT NOT NULL,
  `image_img_imagetype_imgty_iimgty_id` INT NOT NULL,
  `lay_id` INT NOT NULL,
  `lay_score` INT NULL,
  `lay_pos_x` FLOAT NOT NULL,
  `lay_pos_y` FLOAT NOT NULL,
  `lay_zoom` FLOAT NOT NULL,
  `lay_rotation` FLOAT NOT NULL,
  `lay_opacity` INT NOT NULL,
  `lay_gradient_position` INT NOT NULL,
  `lay_created` DATETIME NOT NULL,
  PRIMARY KEY (`ink_ink_ink_id`, `gradient_grd_grd_id`, `image_img_img_id`, `image_img_imagetype_imgty_iimgty_id`, `lay_id`),
  UNIQUE INDEX `lay_id_UNIQUE` (`lay_id` ASC),
  INDEX `fk_layer_lay_ink_ink1_idx` (`ink_ink_ink_id` ASC),
  INDEX `fk_layer_lay_gradient_grd1_idx` (`gradient_grd_grd_id` ASC),
  INDEX `fk_layers_lay_image_img1_idx` (`image_img_imagetype_imgty_iimgty_id` ASC, `image_img_img_id` ASC),
  CONSTRAINT `fk_layer_lay_ink_ink1`
    FOREIGN KEY (`ink_ink_ink_id`)
    REFERENCES `mydb`.`inks_ink` (`ink_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_layer_lay_gradient_grd1`
    FOREIGN KEY (`gradient_grd_grd_id`)
    REFERENCES `mydb`.`gradients_grd` (`grd_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_layers_lay_image_img1`
    FOREIGN KEY (`image_img_img_id`)
    REFERENCES `mydb`.`image_img` (`img_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`variables_var_has_layer_lay`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`variables_var_has_layer_lay` (
  `variables_var_var_id` INT NOT NULL,
  `variables_var_formulas_frm_frm_id` INT NOT NULL,
  `layer_lay_lay_id` INT NOT NULL,
  `varlay_id` INT NOT NULL,
  `varlay_value` FLOAT NOT NULL,
  PRIMARY KEY (`variables_var_var_id`, `variables_var_formulas_frm_frm_id`, `layer_lay_lay_id`, `varlay_id`),
  INDEX `fk_variables_var_has_layer_lay_layer_lay1_idx` (`layer_lay_lay_id` ASC),
  INDEX `fk_variables_var_has_layer_lay_variables_var1_idx` (`variables_var_var_id` ASC, `variables_var_formulas_frm_frm_id` ASC),
  UNIQUE INDEX `varlay_id_UNIQUE` (`varlay_id` ASC),
  CONSTRAINT `fk_variables_var_has_layer_lay_variables_var1`
    FOREIGN KEY (`variables_var_var_id` , `variables_var_formulas_frm_frm_id`)
    REFERENCES `mydb`.`variables_var` (`var_id` , `formulas_frm_frm_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_variables_var_has_layer_lay_layer_lay1`
    FOREIGN KEY (`layer_lay_lay_id`)
    REFERENCES `mydb`.`layers_lay` (`lay_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`colors_col`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`colors_col` (
  `col_id` INT NOT NULL,
  `col_red` INT NOT NULL,
  `col_green` INT NOT NULL,
  `col_blue` INT NOT NULL,
  `col_hue` INT NOT NULL,
  `col_saturation` INT NOT NULL,
  `col_luminance` INT NOT NULL,
  PRIMARY KEY (`col_id`),
  UNIQUE INDEX `col_id_UNIQUE` (`col_id` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`gradients_grd_has_colors_col`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`gradients_grd_has_colors_col` (
  `gradients_grd_grd_id` INT NOT NULL,
  `colors_col_col_id` INT NOT NULL,
  `grdcol_alpha` INT NOT NULL,
  PRIMARY KEY (`gradients_grd_grd_id`, `colors_col_col_id`),
  INDEX `fk_gradients_grd_has_colors_col_colors_col1_idx` (`colors_col_col_id` ASC),
  INDEX `fk_gradients_grd_has_colors_col_gradients_grd1_idx` (`gradients_grd_grd_id` ASC),
  CONSTRAINT `fk_gradients_grd_has_colors_col_gradients_grd1`
    FOREIGN KEY (`gradients_grd_grd_id`)
    REFERENCES `mydb`.`gradients_grd` (`grd_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_gradients_grd_has_colors_col_colors_col1`
    FOREIGN KEY (`colors_col_col_id`)
    REFERENCES `mydb`.`colors_col` (`col_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`criteria1_crit1`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`criteria1_crit1` (
  `crit1_id` INT NOT NULL,
  `crit1_name` VARCHAR(45) NOT NULL,
  `crit1_description` VARCHAR(255) NULL,
  PRIMARY KEY (`crit1_id`),
  UNIQUE INDEX `idobserver-criteria1_crit1_UNIQUE` (`crit1_id` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`criteria2_crit2`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`criteria2_crit2` (
  `crit2_id` INT NOT NULL,
  `crit2_name` VARCHAR(45) NOT NULL,
  `crit2_description` VARCHAR(255) NULL,
  PRIMARY KEY (`crit2_id`),
  UNIQUE INDEX `idobserver-criteria1_crit1_UNIQUE` (`crit2_id` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`observer_obs`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`observer_obs` (
  `criteria1_crit1_crit1_id` INT NOT NULL,
  `criteria2_crit2_crit2_id` INT NOT NULL,
  `obs_id` INT NOT NULL,
  `obs_name` VARCHAR(45) NOT NULL,
  `obs_quality` INT NOT NULL,
  `obs_role` ENUM('creator', 'visitor') NOT NULL,
  `obs_description` VARCHAR(255) NULL,
  PRIMARY KEY (`criteria1_crit1_crit1_id`, `criteria2_crit2_crit2_id`, `obs_id`),
  INDEX `fk_observer_obs_criteria1_crit11_idx` (`criteria1_crit1_crit1_id` ASC),
  INDEX `fk_observer_obs_criteria2_crit21_idx` (`criteria2_crit2_crit2_id` ASC),
  CONSTRAINT `fk_observer_obs_criteria1_crit11`
    FOREIGN KEY (`criteria1_crit1_crit1_id`)
    REFERENCES `mydb`.`criteria1_crit1` (`crit1_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_observer_obs_criteria2_crit21`
    FOREIGN KEY (`criteria2_crit2_crit2_id`)
    REFERENCES `mydb`.`criteria2_crit2` (`crit2_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`rating_rat`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`rating_rat` (
  `rat_id` INT NOT NULL,
  `image_img_img_id` INT NOT NULL,
  `observer_obs_obs_id` INT NOT NULL,
  `rat_score` INT NOT NULL,
  `rat_created` DATETIME NOT NULL,
  PRIMARY KEY (`rat_id`, `image_img_img_id`, `observer_obs_obs_id`),
  UNIQUE INDEX `id_rat_UNIQUE` (`rat_id` ASC),
  INDEX `fk_rating_rat_image_img1_idx` (`image_img_img_id` ASC),
  INDEX `fk_rating_rat_observer_obs1_idx` (`observer_obs_obs_id` ASC),
  CONSTRAINT `fk_rating_rat_image_img1`
    FOREIGN KEY (`image_img_img_id`)
    REFERENCES `mydb`.`image_img` (`img_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_rating_rat_observer_obs1`
    FOREIGN KEY (`observer_obs_obs_id`)
    REFERENCES `mydb`.`observer_obs` (`obs_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`keywords_kew`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`keywords_kew` (
  `kew_id` INT NOT NULL,
  `kew_name` VARCHAR(45) NOT NULL,
  PRIMARY KEY (`kew_id`),
  UNIQUE INDEX `kew_id_UNIQUE` (`kew_id` ASC))
ENGINE = InnoDB;


-- -----------------------------------------------------
-- Table `mydb`.`keywords_kew_has_image_img`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mydb`.`keywords_kew_has_image_img` (
  `keywords_kew_kew_id` INT NOT NULL,
  `image_img_img_id` INT NOT NULL,
  PRIMARY KEY (`keywords_kew_kew_id`, `image_img_img_id`),
  INDEX `fk_keywords_kew_has_image_img_image_img1_idx` (`image_img_img_id` ASC),
  INDEX `fk_keywords_kew_has_image_img_keywords_kew1_idx` (`keywords_kew_kew_id` ASC),
  CONSTRAINT `fk_keywords_kew_has_image_img_keywords_kew1`
    FOREIGN KEY (`keywords_kew_kew_id`)
    REFERENCES `mydb`.`keywords_kew` (`kew_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_keywords_kew_has_image_img_image_img1`
    FOREIGN KEY (`image_img_img_id`)
    REFERENCES `mydb`.`image_img` (`img_id`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;