DFv2Ecz5

1Executing SQL script in server
2ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
3  INDEX `fk_Reservation_Objekt1_idx` (`Objectt_barcode` ASC) VISIBLE,
4  CONSTRA' at line 11
5SQL Code:
6        -- -----------------------------------------------------
7        -- Table `NewLibrary`.`Reservation`
8        -- -----------------------------------------------------
9        CREATE TABLE IF NOT EXISTS `NewLibrary`.`Reservation` (
10          `reservationID` INT NOT NULL AUTO_INCREMENT,
11          `Patron_patronID` INT NOT NULL,
12          `Objectt_barcode` VARCHAR(10) NOT NULL,
13          `date` TIMESTAMP NOT NULL,
14          `title` VARCHAR(100) NOT NULL,
15          PRIMARY KEY (`reservationID`),
16          INDEX `fk_Reservation_LÃ¥ntagare_idx` (`Patron_patronID` ASC) VISIBLE,
17          INDEX `fk_Reservation_Objekt1_idx` (`Objectt_barcode` ASC) VISIBLE,
18          CONSTRAINT `fk_Reservation_LÃ¥ntagare`
19            FOREIGN KEY (`Patron_patronID`)
20            REFERENCES `NewLibrary`.`Patron` (`patronID`)
21            ON DELETE NO ACTION
22            ON UPDATE NO ACTION,
23          CONSTRAINT `fk_Reservation_Objekt1`
24            FOREIGN KEY (`Objectt_barcode`)
25            REFERENCES `NewLibrary`.`Object` (`barcode`)
26            ON DELETE NO ACTION
27            ON UPDATE NO ACTION)
28        ENGINE = InnoDB
29
30SQL script execution finished: statements: 7 succeeded, 1 failed
31
32Fetching back view definitions in final form.
33Nothing to fetch