YTepdym3

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_person_has_user_person_idx` (`person_ID` ASC) VISIBLE,
4  CONSTRAINT' at line 8
5SQL Code:
6        -- -----------------------------------------------------
7        -- Table `customers`.`person_has_user`
8        -- -----------------------------------------------------
9        CREATE TABLE IF NOT EXISTS `customers`.`person_has_user` (
10          `person_ID` INT NOT NULL,
11          `user_person_ID` INT NOT NULL,
12          PRIMARY KEY (`person_ID`, `user_person_ID`),
13          INDEX `fk_person_has_user_user1_idx` (`user_person_ID` ASC) VISIBLE,
14          INDEX `fk_person_has_user_person_idx` (`person_ID` ASC) VISIBLE,
15          CONSTRAINT `fk_person_has_user_person`
16            FOREIGN KEY (`person_ID`)
17            REFERENCES `customers`.`person` (`ID`)
18            ON DELETE NO ACTION
19            ON UPDATE NO ACTION,
20          CONSTRAINT `fk_person_has_user_user1`
21            FOREIGN KEY (`user_person_ID`)
22            REFERENCES `customers`.`user` (`person_ID`)
23            ON DELETE NO ACTION
24            ON UPDATE NO ACTION)
25        ENGINE = InnoDB
26
27SQL script execution finished: statements: 7 succeeded, 1 failed
28
29Fetching back view definitions in final form.
30Nothing to fetch