Et, pour faire suite à mon précédent message, voici les définitions :
-- Table structure for table `robase`.`t_communes`
--
DROP TABLE IF EXISTS `t_communes`;
CREATE TABLE `t_communes` (
`IDCommune` mediumint(7) NOT NULL,
`ClairCommune` varchar(37) DEFAULT NULL,
`ref_deptprov` mediumint(7) NOT NULL,
PRIMARY KEY (`IDCommune`),
UNIQUE KEY `ClairCommune` (`ClairCommune`),
KEY `ref_deptprov` (`ref_deptprov`),
CONSTRAINT `t_communes_ibfk_1` FOREIGN KEY (`ref_deptprov`)
REFERENCES `t_dptprov` (`IDDptProv`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
et
-- Table structure for table `robase`.`t_pays`
--
DROP TABLE IF EXISTS `t_pays`;
CREATE TABLE `t_pays` (
`IDPays` mediumint(10) NOT NULL AUTO_INCREMENT,
`ClairPays` varchar(50) NOT NULL,
`ref_continent` mediumint(7) DEFAULT NULL,
PRIMARY KEY (`IDPays`),
UNIQUE KEY `ClairPays` (`ClairPays`),
KEY `ref_continent` (`ref_continent`),
CONSTRAINT `t_pays_ibfk_1` FOREIGN KEY (`ref_continent`) REFERENCES
`t_continents` (`IDContinent`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=163 DEFAULT CHARSET=latin1;
--
------------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected] with Subject: help
