1 2 3 4 5 6 7 8 9 10
|
CREATE TABLE `PERSONNEL_MAGASIN` (
`PERSONNEL_ID` int(4) NOT NULL,
`MAGASIN_ID` int(10) unsigned NOT NULL,
PRIMARY KEY (`MAGASIN_ID`,`PERSONNEL_ID`),
KEY `PERSONNEL_ID` (`PERSONNEL_ID`),
KEY `MAGASIN_ID` (`MAGASIN_ID`),
CONSTRAINT `PERSONNEL_MAGASIN_fk2` FOREIGN KEY (`PERSONNEL_ID`) REFERENCES `PERSONNELS` (`ID`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `PERSONNEL_MAGASIN_fk3` FOREIGN KEY (`MAGASIN_ID`) REFERENCES `MAGASINS` (`MAGASIN_ID`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci; |
Partager