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

[max ac]

Hi there, my first post here, I have the same 105 error when I tried to import statments to my database, this is my script:


CREATE TABLE `parametros` (
`c_param` int(4) unsigned zerofill NOT NULL auto_increment,
`c_tipoparam` char(3) NOT NULL default '',
`monto_param` float default NULL,
`fecha_param` datetime default NULL,
`otro_param` varchar(50) default NULL,
PRIMARY KEY (`c_param`),
KEY `c_tipoparam` (`c_tipoparam`),
CONSTRAINT `parametros_ibfk_1` FOREIGN KEY (`c_tipoparam`) REFERENCES `tipo_param` (`c_tipoparam`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

/*Data for the table `parametros` */
CREATE TABLE `tipo_param` (
`c_tipoparam` char(3) NOT NULL default '',
`t_descrip_tipoparam` varchar(50) default NULL,
PRIMARY KEY (`c_tipoparam`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

I see the same name and type for foreign keys, I dont see the error, please help me