Re: ERROR 1005: Can't create table (errno: 150) - Please help

[Anil Karamchandani]

Hi, I have tried to read all the possible solutions to this problem but I am still facing problems in finding the answer. All I have read is that making the fk type as unsigned the problem gets resolved. I am not a mysql expert, infact a newbie.
below is the code which I generated from workbench mysql

please could any one help me with this.

DROP TABLE IF EXISTS `mydb`.`employee` ;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `mydb`.`employee` (
`empID` INT NOT NULL ,
`firstname` VARCHAR(400) NOT NULL ,
`lastname` VARCHAR(400) NOT NULL ,
`company` VARCHAR(400) NOT NULL ,
`username` VARCHAR(400) NOT NULL ,
`password` VARCHAR(400) NOT NULL ,
`location` VARCHAR(400) NOT NULL ,
`managerID` INT NOT NULL ,
`address1` VARCHAR(400) NULL ,
`address2` VARCHAR(400) NULL ,
`city` VARCHAR(45) NOT NULL ,
`state` VARCHAR(45) NOT NULL ,
`zipcode` VARCHAR(45) NOT NULL ,
`country` VARCHAR(45) NOT NULL ,
`datecreated` DATETIME NOT NULL ,
`datemodified` DATETIME NOT NULL ,
PRIMARY KEY (`empID`) )
ENGINE = InnoDB;

SHOW WARNINGS;
CREATE UNIQUE INDEX `username_UNIQUE` ON `mydb`.`employee` (`username` ASC) ;

SHOW WARNINGS;

-- -----------------------------------------------------
-- Table `mydb`.`frmBasic`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mydb`.`frmBasic` ;

SHOW WARNINGS;
CREATE TABLE IF NOT EXISTS `mydb`.`frmBasic` (
`empname` VARCHAR(400) NOT NULL ,
`reportsto` VARCHAR(400) NOT NULL ,
`location` VARCHAR(200) NOT NULL ,
`performancebegin` VARCHAR(200) NOT NULL ,
`performanceend` VARCHAR(200) NOT NULL ,
`lengthcurrentposition` VARCHAR(200) NOT NULL ,
`lengthwithcompany` VARCHAR(200) NOT NULL ,
`otherinformation` VARCHAR(400) NOT NULL ,
`empID` INT NOT NULL ,
`managerID` INT NOT NULL ,
`datecreated` DATETIME NOT NULL ,
`datemodified` DATETIME NOT NULL ,
CONSTRAINT `frmBasic_employee_empID`
FOREIGN KEY (`empID` )
REFERENCES `mydb`.`employee` (`empID` )
ON DELETE CASCADE
ON UPDATE CASCADE,
CONSTRAINT `frmBasic_employee_managerID`
FOREIGN KEY (`managerID` )
REFERENCES `mydb`.`employee` (`managerID` )
ON DELETE CASCADE
ON UPDATE CASCADE)
ENGINE = InnoDB;

SHOW WARNINGS;
CREATE INDEX `frmBasic_employee_empID` ON `mydb`.`frmBasic` (`empID` ASC) ;

SHOW WARNINGS;
CREATE INDEX `frmBasic_employee_managerID` ON `mydb`.`frmBasic` (`managerID` ASC) ;


while adding frmBasic I get the error "Can't create table (errno: 150) "