ERROR 1005 : Can't create table '.\DB\XXXTable.frm' (errno: 150)

606 ワード

CREATE TABLE `REGION` (

`id` int(11) NOT NULL auto_increment,

`regionid` varchar(32) NOT NULL COMMENT '  ID',

`regionname` varchar(32) DEFAULT NULL COMMENT '    ',

`pregionid` varchar(32) DEFAULT NULL COMMENT '    ID ',

`orgid` varchar(32) DEFAULT NULL COMMENT '      ID ',

PRIMARY KEY (`id`),

foreign key(`orgid`) references zzjg(`orgid`) on delete cascade on update cascade

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='   ';

=========================
参照先:http://hi.baidu.com/jsjok/blog/item/7699668deb954bf4f11f3642.html