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

[Tuan Nguyen]

I create 2 table:
CREATE TABLE IF NOT EXISTS `new_vbpq`.`Document` (
`ID` INT NOT NULL,
`Symbol` VARCHAR(250) NULL,
`Name` VARCHAR(2000) NULL,
`Type_ID` INT NULL DEFAULT 0,
`Signed_date` DATE NULL,
`Start_date` DATE NULL,
`End_date` DATE NULL,
`Og_date` DATE NULL,
`Og_name` VARCHAR(250) NULL,
`Press_code` INT NULL DEFAULT 0,
`Description` VARCHAR(2000) NULL,
`English` TINYINT NULL DEFAULT 0,
`Expired` TINYINT NULL DEFAULT 0,
`HTML` VARCHAR(50) NULL,
`DOC` VARCHAR(50) NUL,
PRIMARY KEY (`ID`) )
ENGINE = InnoDB;

and:
CREATE TABLE IF NOT EXISTS `new_vbpq`.`Type` (
`ID` INT NOT NULL,
`CODE` VARCHAR(250) NULL,
`Name` VARCHAR(2000) NULL,
`Descripton` VARCHAR(2000) NULL,
`Parent_ID` INT NULL,
PRIMARY KEY (`ID`) ,
INDEX `fk_Type_Document` (`ID` ASC) ,
CONSTRAINT `fk_Type_Document`
FOREIGN KEY (`ID` )
REFERENCES `new_vbpq`.`Document` (`Type_ID` )
ON DELETE SET NULL
ON UPDATE SET NULL)
ENGINE = InnoDB;

I have error 1005 errno 150 with these create statement. Can you help me!