1
2
3
4
5
6
7
8
9
10
| CREATE TABLE IF NOT EXISTS `rediger` (
`article` int(11) NOT NULL,
`membre` int(10) NOT NULL,
`date` date NOT NULL,
`langue` varchar(15) NOT NULL,
PRIMARY KEY (`article`,`membre`),
CONSTRAINT `FK_id_A` FOREIGN KEY (`article`) REFERENCES `article` (`id_article`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_id_B` FOREIGN KEY (`membre`) REFERENCES `membre` (`id_membre`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_id_C` FOREIGN KEY (`langue`) REFERENCES `langue` (`label`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB |
