Witam!
Czy któryś z was wie czemu wyskakuje mi błąd:
Error code 1005, SQL state HY000: Can't create table 'dentaldb.uzembienie' (errno: 121)
Line 8, column 1
Execution finished after 0 s, 1 error(s) occurred.
Przy tworzeniu tabeli:
-- -----------------------------------------------------
-- Table `DENTALDB`.`UZEMBIENIE`
-- -----------------------------------------------------
CREATE TABLE IF NOT EXISTS `DENTALDB`.`UZEMBIENIE` (
`ID` INT NOT NULL ,
`ID_ZAB` INT NOT NULL ,
`ID_PACJENT` INT NOT NULL ,
INDEX `ID_ZAB` (`ID_ZAB` ASC) ,
INDEX `ID_PACJENT` (`ID_PACJENT` ASC) ,
PRIMARY KEY (`ID`) ,
CONSTRAINT `ID_ZAB`
FOREIGN KEY (`ID_ZAB` )
REFERENCES `DENTALDB`.`ZAB` (`ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION,
CONSTRAINT `ID_PACJENT`
FOREIGN KEY (`ID_PACJENT` )
REFERENCES `DENTALDB`.`PACJENCI` (`ID` )
ON DELETE NO ACTION
ON UPDATE NO ACTION)
DEFAULT CHARACTER SET = latin2
COLLATE = latin2_general_ci;