[2.x] problème avec mes contraintes d'intégrité

Bonjour
J'ai un probléme sur doctrine symfony2 j'aimerais savoir comment créer une clé etrangère sur deux champ voila ma table

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
CREATE  TABLE IF NOT EXISTS `ACC_COMP_PROFILE` (
  `ACCESS_COMP_PROF_ID` INT NOT NULL AUTO_INCREMENT ,
  `ACCESS_PROFILE_ID` INT NOT NULL ,
  `COMPONENT_ID` INT NOT NULL ,
  `COMPANY_ID` INT NOT NULL ,
  `ACCESS_TYPE` CHAR(2) NOT NULL ,
  PRIMARY KEY (`ACCESS_COMP_PROF_ID`) ,
  UNIQUE INDEX `IX_ACC_COMP_PROFILE` (`ACCESS_PROFILE_ID` ASC, `COMPONENT_ID` ASC, `ACCESS_TYPE` ASC) ,
  CONSTRAINT `FK_ACCESS_COMPONENT_PROFILE_SEC_COMPONENT`
    FOREIGN KEY (`COMPANY_ID` , `COMPONENT_ID` )
    REFERENCES `ezWorkYinosoft`.`SEC_COMPONENT` (`COMPANY_ID` , `SEC_COMPONENT_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `FK_ACCESS_COMPONENT_PROFILE_PROFILE`
    FOREIGN KEY (`COMPANY_ID` , `ACCESS_PROFILE_ID` )
    REFERENCES `ACCESS_PROFILE` (`COMPANY_ID` , `ACCESS_PROFILE_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
COLLATE = utf8_general_ci;

je veux savoir comment déclarerer cette instruction

Code:

1
2
3
4
5
 CONSTRAINT `FK_ACCESS_COMPONENT_PROFILE_PROFILE`
    FOREIGN KEY (`COMPANY_ID` , `ACCESS_PROFILE_ID` )
    REFERENCES `ACCESS_PROFILE` (`COMPANY_ID` , `ACCESS_PROFILE_ID` )
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)

Merci a vous