pb on create with foreign key

[bocquet denis]

CREATE TABLE `infos_bloc` (
`infb_code_partenaire` INT(2) NOT NULL,
`infb_reference` VARCHAR(30) NOT NULL,
`infb_numero` INT(3) NOT NULL,
`infb_type` VARCHAR(3) NULL,
`infb_actif` INT(1) NULL,
PRIMARY KEY (`infb_code_partenaire`, `infb_reference`, `infb_numero`),
CONSTRAINT `fk_infos_bl_ref_652_infos`
FOREIGN KEY `fk_infos_bl_ref_652_infos` (`infb_code_partenaire`)
REFERENCES `infos` (`inf_code_partenaire`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,

)
ENGINE = INNODB;
An error occured while executing the SQL statement.
Can't create table './xxxx/infos_bloc.frm' (errno: 150)

the solution is after "no action" you don't put a comma and it's ok
REFERENCES `infos` (`inf_code_partenaire`)
ON DELETE NO ACTION
ON UPDATE NO ACTION,

)