CREATE TABLE `ito_desarrollo`.`informerecurso` (
  `idInformerecurso` INT NOT NULL AUTO_INCREMENT,
  `idInforme` INT NOT NULL,
  `idRecurso` INT NOT NULL,
  `nCantidad` INT NULL DEFAULT 1,
  PRIMARY KEY (`idInformerecurso`),
  UNIQUE INDEX `idInformerecurso_UNIQUE` (`idInformerecurso` ASC));
ALTER TABLE `ito_desarrollo`.`informerecurso` 
ADD INDEX `fk_informerecurso1_idx` (`idInforme` ASC),
ADD INDEX `fk_informerecurso2_idx` (`idRecurso` ASC);
ALTER TABLE `ito_desarrollo`.`informerecurso` 
ADD CONSTRAINT `fk_informerecurso1`
  FOREIGN KEY (`idInforme`)
  REFERENCES `ito_desarrollo`.`informe` (`idInforme`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION,
ADD CONSTRAINT `fk_informerecurso2`
  FOREIGN KEY (`idRecurso`)
  REFERENCES `ito_desarrollo`.`recurso` (`idRecurso`)
  ON DELETE NO ACTION
  ON UPDATE NO ACTION;
