MySQL:Can't create table 'tablename' (errno: 150)

我创建的两个数据表：

CREATE TABLE IF NOT EXISTS `hospital` (
  `hospitalID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `hospitalname` varchar(80) COLLATE utf8_bin NOT NULL,
  `address` varchar(80) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`hospitalID`),
  UNIQUE KEY `hospital_name` (`hospitalname`),
  KEY `hospitalID` (`hospitalID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `patient` (
  `patientID` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `patientname` varchar(40) COLLATE utf8_bin NOT NULL,
  `sex` varchar(6) COLLATE utf8_bin DEFAULT NULL,
  `age` int(5) NOT NULL,
  `DOB` date NOT NULL,
  `hospitalID` int(11) unsigned NOT NULL,
  PRIMARY KEY (`patientID`),
foreign key(hospitalID) references hospital on delete restrict
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin AUTO_INCREMENT=1 ;

提示以上错误。根据发生这种情况的原因主要有： 1、外键和被引用外键数据类型不一样 2、找不到要被引用的列 3、表的字符编码不一样 

查找错误，发现可以完全排除。

后，将foreign key(hospitalID) references hospital on delete restrict改为

foreign key(hospitalID) references hospital(hospitalID) on delete restrict

创建成功。