1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23
|
CREATE TABLE IF NOT EXISTS `contrat` (
`Nom` char(30) NOT NULL,
`Prenom` char(30) NOT NULL,
`Telephone` char(10) NOT NULL,
`NoContrat` char(10) NOT NULL,
`DateContrat` date DEFAULT NULL,
PRIMARY KEY (`NoContrat`),
KEY `Nom` (`Nom`),
KEY `Prenom` (`Prenom`),
KEY `Telephone` (`Telephone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE IF NOT EXISTS `eleve` (
`Nom` char(30) NOT NULL,
`Prenom` char(30) NOT NULL,
`Telephone` char(10) NOT NULL,
PRIMARY KEY (`Nom`,`Prenom`,`Telephone`),
KEY `Prenom` (`Prenom`),
KEY `Nom` (`Nom`),
KEY `Telephone` (`Telephone`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8; |
Partager