problème Mysql foreign key
* Bonjour, *
Code:
1 2 3 4 5 6 7
| create table Articles
(ArticleID varchar(10) primary key,
Nom varchar(12),
Quantite int,
IdFournisseur varchar(10),
Description varchar(30)
)ENGINE=INNODB; |
Code:
1 2 3 4 5 6 7 8
| create table Commande(
NumCmd varchar(10),
ClientID varchar(10),
DateLivraison date,
ManiereLivraison varchar(20),
Etat varchar(15),
primary key(NumCmd),
constraint fk_commande_client foreign key (ClientID) references Clients(ClientID))ENGINE=INNODB; |
Code:
1 2 3 4 5 6 7 8 9
| create table LigneCommande(
NumCmd varchar(10),
ArticleID varchar(10),
QuantiteLigne int,
Montantligne float,
primary key(NumCmd,ArticleID),
foreign key (NumCmd) references Commande(NumCmd),
foreign key (ArticleID) references Article(ArticleID)
)ENGINE=INNODB; |
la création de la table Ligne Commande donne
l'erreur 1005 errno : 150 :oops:
* Merci *