Re: ERROR 1005: Can't create table (errno: 150) :: InnoDB

[marat beiner]

Same problem here, can anyone help?

Here is my table creation:

CREATE TABLE `guidance center`.`schedular` (
`date` VARCHAR(10) NOT NULL,
`startTime` VARCHAR(10) NOT NULL,
`endTime` VARCHAR(10) NOT NULL,
`course` VARCHAR(15) NOT NULL,
PRIMARY KEY (`date`, `startTime`, `endTime`),
CONSTRAINT `fk1_schedular` FOREIGN KEY (`course`)
REFERENCES `event` (`courseName`)
ON DELETE CASCADE ON UPDATE CASCADE
)
ENGINE = InnoDB;