Подскажите, что я делаю не так в написания скрипта в sql, есть задача -- MySQL Script generated by MySQL Workbench -- 02/04/20 09:42:58 -- Model: - вопрос №3623532

New Model Version: 1.0 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='TRADITIONAL,ALLOW_INVALID_DATES'; — — — Schema Weight — — CREATE SCHEMA IF NOT EXISTS `Weight` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci; USE `Weight`; — — — Table `Weight`.`Weight1` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight1` ( `idtable1` INT NOT NULL AUTO_INCREMENT, `table1col` VARCHAR(45) NOT NULL, `table1col2` VARCHAR(45) NOT NULL, `table1col3` VARCHAR(45) NOT NULL, PRIMARY KEY (`idtable1`)) ENGINE = InnoDB; — — — Table `Weight`.`Weight5` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight5` ( `idWeight5` INT NOT NULL AUTO_INCREMENT, `Weight5col` VARCHAR(45) NOT NULL, `Weight5col1` VARCHAR(45) NOT NULL, `Weight5col2` VARCHAR(45) NOT NULL, `Weight6_idWeight6` INT NOT NULL, PRIMARY KEY (`idWeight5`, `Weight6_idWeight6`), CONSTRAINT `fk_Weight5_Weight61` FOREIGN KEY (`idWeight5`, `Weight6_idWeight6`) REFERENCES `Weight`.`Weight6` (`idWeight6`, `idWeight6`) ON DELETE RESTRICT ON UPDATE CASCADE) ENGINE = InnoDB; — — — Table `Weight`.`Weight3` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight3` ( `idWeight3` INT NOT NULL AUTO_INCREMENT, `Weight3col` VARCHAR(45) NOT NULL, `Weight3col1` VARCHAR(45) NOT NULL, `Weight3col2` VARCHAR(45) NOT NULL, PRIMARY KEY (`idWeight3`), CONSTRAINT `id` FOREIGN KEY (`idWeight3`) REFERENCES `Weight`.`Weight5` (`idWeight5`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB; — — — Table `Weight`.`Weight4` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight4` ( `idWeight4` INT NOT NULL AUTO_INCREMENT, `Weight4col` VARCHAR(45) NOT NULL, `Weight4col1` VARCHAR(45) NOT NULL, `Weight4col2` VARCHAR(45) NOT NULL, `Weight5_idWeight5` INT NOT NULL, `Weight5_Weight6_idWeight6` INT NOT NULL, `Weight3_idWeight3` INT NOT NULL, PRIMARY KEY (`idWeight4`, `Weight5_idWeight5`, `Weight5_Weight6_idWeight6`, `Weight3_idWeight3`), INDEX `fk_Weight4_Weight51_idx` (`Weight5_idWeight5` ASC, `Weight5_Weight6_idWeight6` ASC), INDEX `fk_Weight4_Weight31_idx` (`Weight3_idWeight3` ASC), CONSTRAINT `fk_Weight4_Weight51` FOREIGN KEY (`Weight5_idWeight5`, `Weight5_Weight6_idWeight6`) REFERENCES `Weight`.`Weight5` (`idWeight5`, `Weight6_idWeight6`) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT `fk_Weight4_Weight31` FOREIGN KEY (`Weight3_idWeight3`) REFERENCES `Weight`.`Weight3` (`idWeight3`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; — — — Table `Weight`.`Weight9` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight9` ( `idtable9` INT NOT NULL AUTO_INCREMENT, `table9col` VARCHAR(45) NOT NULL, `table9col1` VARCHAR(45) NOT NULL, `table9col2` VARCHAR(45) NOT NULL, PRIMARY KEY (`idtable9`), CONSTRAINT `id` FOREIGN KEY (`idtable9`) REFERENCES `Weight`.`Weight8` (`idtable8`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB; — — — Table `Weight`.`Weight8` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight8` ( `idtable8` INT NOT NULL AUTO_INCREMENT, `table8col` VARCHAR(45) NOT NULL, `table8col1` VARCHAR(45) NOT NULL, `table8col2` VARCHAR(45) NOT NULL, `Weight9_idtable9` INT NOT NULL, `Weight9_idtable91` INT NOT NULL, PRIMARY KEY (`idtable8`, `Weight9_idtable9`), INDEX `fk_Weight8_Weight92_idx` (`Weight9_idtable91` ASC), CONSTRAINT `fk_Weight8_Weight91` FOREIGN KEY (`idtable8`, `Weight9_idtable9`) REFERENCES `Weight`.`Weight4` (`Weight5_idWeight5`, `idWeight4`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Weight8_Weight92` FOREIGN KEY (`Weight9_idtable91`) REFERENCES `Weight`.`Weight9` (`idtable9`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; — — — Table `Weight`.`Weight7` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight7` ( `idtable7` INT NOT NULL AUTO_INCREMENT, `table7col` VARCHAR(45) NOT NULL, `table7col1` VARCHAR(45) NOT NULL, `table7col2` VARCHAR(45) NOT NULL, `table8_idtable8` INT NOT NULL, PRIMARY KEY (`idtable7`, `table8_idtable8`), CONSTRAINT `fk_table7_table81` FOREIGN KEY (`idtable7`, `table8_idtable8`) REFERENCES `Weight`.`Weight8` (`idtable8`, `idtable8`) ON DELETE CASCADE ON UPDATE CASCADE) ENGINE = InnoDB; — — — Table `Weight`.`Weight6` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight6` ( `idWeight6` INT NOT NULL AUTO_INCREMENT, `Weight6col` VARCHAR(45) NOT NULL, `Weight6col1` VARCHAR(45) NOT NULL, `Weight6col2` VARCHAR(45) NOT NULL, `table7_idtable7` INT NOT NULL, PRIMARY KEY (`idWeight6`, `table7_idtable7`), INDEX `fk_Weight6_table71_idx` (`table7_idtable7` ASC), CONSTRAINT `fk_Weight6_table71` FOREIGN KEY (`table7_idtable7`) REFERENCES `Weight`.`Weight7` (`idtable7`) ON DELETE NO ACTION ON UPDATE NO ACTION) ENGINE = InnoDB; — — — Table `Weight`.`Weight2` — — CREATE TABLE IF NOT EXISTS `Weight`.`Weight2` ( `idtable6` INT NOT NULL AUTO_INCREMENT, `table6col` VARCHAR(45) NOT NULL, `table6col1` VARCHAR(45) NOT NULL, `table6col2` VARCHAR(45) NOT NULL, `Weight1_idtable1` INT NOT NULL, `Weight3_idWeight3` INT NOT NULL, PRIMARY KEY (`idtable6`, `Weight1_idtable1`, `Weight3_idWeight3`), INDEX `fk_Weight2_Weight31_idx` (`Weight3_idWeight3` ASC), CONSTRAINT `fk_Weight2_Weight11` FOREIGN KEY (`idtable6`, `Weight1_idtable1`) REFERENCES `Weight`.`Weight1` (`idtable1`, `idtable1`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `fk_Weight2_Weight31` FOREIGN KEY (`Weight3_idWeight3`) REFERENCES `Weight`.`Weight3` (`idWeight3`) 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;