mysql 1005 121_SQL-错误代码1005，错误号为121

我正在运行以下由 MySQL Workbench 自动生成的MySQL脚本(已精简)，出现以下错误：

1005无法创建表“ regula.reservation”(错误号：121)

我对数据库不是很精通，并且此错误也不是非常有用。

这里有什么问题？

-- -----------------------------------------------------

-- Table `regula`.`Users`

-- -----------------------------------------------------

DROP TABLE IF EXISTS `regula`.`Users` ;

CREATE TABLE IF NOT EXISTS `regula`.`Users` (

`idUsers` INT UNSIGNED NOT NULL AUTO_INCREMENT ,

`name` TEXT NOT NULL ,

`type` TEXT NOT NULL ,

`pwd` TEXT NOT NULL ,

PRIMARY KEY (`idUsers`) ,

UNIQUE INDEX `idUsers_UNIQUE` (`idUsers` ASC) )

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `regula`.`Projects`

-- -----------------------------------------------------

DROP TABLE IF EXISTS `regula`.`Projects` ;

CREATE TABLE IF NOT EXISTS `regula`.`Projects` (

`idProjects` INT UNSIGNED NOT NULL AUTO_INCREMENT ,

`ownerId` INT UNSIGNED NOT NULL ,

`name` TEXT NOT NULL ,

`date` DATE NOT NULL ,

`time` TIME NOT NULL ,

`place` TEXT NOT NULL ,

`itemType` INT NOT NULL ,

PRIMARY KEY (`idProjects`) ,

UNIQUE INDEX `idProjects_UNIQUE` (`idProjects` ASC) ,

INDEX `ownerId` (`ownerId` ASC) ,

CONSTRAINT `ownerId`

FOREIGN KEY (`ownerId` )

REFERENCES `regula`.`Users` (`idUsers` )

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `regula`.`ItemTypes`

-- -----------------------------------------------------

DROP TABLE IF EXISTS `regula`.`ItemTypes` ;

CREATE TABLE IF NOT EXISTS `regula`.`ItemTypes` (

`idItemTypes` INT UNSIGNED NOT NULL ,

`prjId` INT UNSIGNED NOT NULL ,

`parentId` INT UNSIGNED NULL DEFAULT NULL ,

`name` TEXT NOT NULL ,

PRIMARY KEY (`idItemTypes`) ,

INDEX `prjId` (`prjId` ASC) ,

INDEX `parentId` (`parentId` ASC) ,

CONSTRAINT `prjId`

FOREIGN KEY (`prjId` )

REFERENCES `regula`.`Projects` (`idProjects` )

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `parentId`

FOREIGN KEY (`parentId` )

REFERENCES `regula`.`ItemTypes` (`idItemTypes` )

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;

-- -----------------------------------------------------

-- Table `regula`.`Reservation`

-- -----------------------------------------------------

DROP TABLE IF EXISTS `regula`.`Reservation` ;

CREATE TABLE IF NOT EXISTS `regula`.`Reservation` (

`idReservation` INT UNSIGNED NOT NULL AUTO_INCREMENT ,

`prjId` INT UNSIGNED NOT NULL ,

`itemTypeId` INT UNSIGNED NOT NULL ,

`userId` INT UNSIGNED NOT NULL ,

PRIMARY KEY (`idReservation`) ,

INDEX `prjId` (`prjId` ASC) ,

INDEX `itemTypeId` (`itemTypeId` ASC) ,

INDEX `userId` (`userId` ASC) ,

CONSTRAINT `prjId`

FOREIGN KEY (`prjId` )

REFERENCES `regula`.`Projects` (`idProjects` )

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `itemTypeId`

FOREIGN KEY (`itemTypeId` )

REFERENCES `regula`.`ItemTypes` (`idItemTypes` )

ON DELETE NO ACTION

ON UPDATE NO ACTION,

CONSTRAINT `userId`

FOREIGN KEY (`userId` )

REFERENCES `regula`.`Users` (`idUsers` )

ON DELETE NO ACTION

ON UPDATE NO ACTION)

ENGINE = InnoDB;