TLmadp8w

1CREATE SCHEMA IF NOT EXISTS `testDB` DEFAULT CHARACTER SET utf8 ;
2USE `testDB` ;
3
4CREATE TABLE IF NOT EXISTS `testDB`.`person` (
5  `personID` INT NOT NULL AUTO_INCREMENT,
6  `firstname` VARCHAR(45) NULL,
7  `lastname` VARCHAR(45) NULL,
8  PRIMARY KEY (`personID`))
9ENGINE = InnoDB;
10
11CREATE TABLE IF NOT EXISTS `testDB`.`comment` (
12  `commentID` INT NOT NULL AUTO_INCREMENT,
13  `comment` VARCHAR(45) NOT NULL,
14  `person_personID` INT NOT NULL,
15  PRIMARY KEY (`commentID`),
16  INDEX `fk_comment_person_idx` (`person_personID` ASC) VISIBLE,
17  CONSTRAINT `fk_comment_person`
18    FOREIGN KEY (`person_personID`)
19    REFERENCES `testDB`.`person` (`personID`)
20    ON DELETE NO ACTION
21    ON UPDATE NO ACTION)
22ENGINE = InnoDB; 
23     
24Executing SQL script in server
25ERROR: Error 1064: You have an error in your SQL syntax; check the manual that
26corresponds to your MariaDB server version for the right syntax to use near '
27  CONSTRAINT `fk_comment_person`
28    FOREIGN KEY (`person_personID`)
29    REFERE' at line 9
30SQL Code:
31        -- -----------------------------------------------------
32        -- Table `testDB`.`comment`
33        -- -----------------------------------------------------
34        CREATE TABLE IF NOT EXISTS `testDB`.`comment` (
35          `commentID` INT NOT NULL AUTO_INCREMENT,
36          `comment` VARCHAR(45) NOT NULL,
37          `person_personID` INT NOT NULL,
38          PRIMARY KEY (`commentID`),
39          INDEX `fk_comment_person_idx` (`person_personID` ASC) VISIBLE,
40          CONSTRAINT `fk_comment_person`
41            FOREIGN KEY (`person_personID`)
42            REFERENCES `testDB`.`person` (`personID`)
43            ON DELETE NO ACTION
44            ON UPDATE NO ACTION)
45        ENGINE = InnoDB
46
47SQL script execution finished: statements: 6 succeeded, 1 failed
48
49Fetching back view definitions in final form.
50Nothing to fetch