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
|
Erreur
Requête SQL:
CREATE TABLE IF NOT EXISTS `mydb`.`Livre` (
`Id_Live` INT NOT NULL AUTO_INCREMENT ,
`Titre_Livre` VARCHAR( 45 ) NULL ,
`Date_Parution` DATE NULL ,
`Nbre_Page` INT NULL ,
`Prix_Ebook` VARCHAR( 5 ) NULL ,
`Prix_Papier` VARCHAR( 5 ) NULL ,
`Pochette` VARCHAR( 45 ) NULL ,
`Type_Livre_Ref_Type` INT NOT NULL ,
`Auteur_Id_Aut` INT NOT NULL ,
`Collection_Id_Col` INT NOT NULL ,
PRIMARY KEY ( `Id_Live` ) ,
CONSTRAINT `fk_Livre_Type_Livre` FOREIGN KEY ( `Type_Livre_Ref_Type` ) REFERENCES `mydb`.`Type_Livre` (
`Ref_Type`
) ON DELETE NO ACTION ON UPDATE NO ACTION ,
CONSTRAINT `fk_Livre_Auteur1` FOREIGN KEY ( `Auteur_Id_Aut` ) REFERENCES `mydb`.`Auteur` (
`Id_Aut`
) ON DELETE NO ACTION ON UPDATE NO ACTION ,
CONSTRAINT `fk_Livre_Collection1` FOREIGN KEY ( `Collection_Id_Col` ) REFERENCES `mydb`.`Collection` (
`Id_Col`
) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE = InnoDB;
MySQL a répondu: Documentation
#1005 - Can't create table 'mydb.livre' (errno: 150) (Détails...) |
Partager