I keep getting an error in the following SQL code, telling me i can't create 'mdbmusic.band-genres' i can't see a problem
full database code can be provided, aswell as the MySQL Workbench Model.
Code:
-- -----------------------------------------------------
-- Table `mdbmusic`.`band-genres`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `mdbmusic`.`band-genres` (
`fk-band_id` INT NOT NULL ,
`fk-genre_id` INT NOT NULL ,
PRIMARY KEY (`fk-band_id`, `fk-genre_id`) ,
INDEX `fk-band_id` (`fk-band_id` ASC) ,
INDEX `fk-genre_id` (`fk-genre_id` ASC) ,
CONSTRAINT `fk-band_id`
FOREIGN KEY (`fk-band_id` )
REFERENCES `mdbmusic`.`band` (`band_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `fk-genre_id`
FOREIGN KEY (`fk-genre_id` )
REFERENCES `mdbmusic`.`genre` (`genre_id` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;