1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42
| CREATE TABLE `tab1` (
`id1` int(11) NOT NULL AUTO_INCREMENT,
`nom` varchar(30) NOT NULL,
PRIMARY KEY (`id1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `tab2` (
`id2` int(11) NOT NULL AUTO_INCREMENT,
`id1` int(11) NOT NULL,
`nom` varchar(30) NOT NULL,
PRIMARY KEY (`id2`),
KEY `id1` (`id1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
CREATE TABLE `tab3` (
`id1` int(11) NOT NULL AUTO_INCREMENT,
`nom` varchar(30) NOT NULL,
PRIMARY KEY (`id1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `tab3` (`id1`, `nom`) VALUES
(1, 'Tache1'),
(2, 'Tache2');
CREATE TABLE `tab4` (
`id2` int(11) NOT NULL AUTO_INCREMENT,
`id1` int(11) NOT NULL,
`nom` varchar(30) NOT NULL,
PRIMARY KEY (`id2`),
KEY `id1` (`id1`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
INSERT INTO `tab4` (`id2`, `id1`, `nom`) VALUES
(1, 1, 'Lien_tache1'),
(2, 1, 'Lien_tache1'),
(3, 2, 'lien_tache2');
ALTER TABLE `tab2`
ADD CONSTRAINT `tab2_ibfk_1` FOREIGN KEY (`id1`) REFERENCES `tab1` (`id1`) ON DELETE CASCADE ON UPDATE CASCADE;
ALTER TABLE `tab4`
ADD CONSTRAINT `tab4_ibfk_1` FOREIGN KEY (`id1`) REFERENCES `tab3` (`id1`) ON DELETE CASCADE ON UPDATE CASCADE; |
Partager