9ywjm7VS

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_art_customers_idx` (`art_customer_id` ASC) VISIBLE,
4  CONSTRAINT `f' at line 8
5SQL Code:
6        CREATE TABLE IF NOT EXISTS `final_project_sadies_art_shop`.`art` (
7          `art_title` VARCHAR(250) NOT NULL,
8          `art_medium` VARCHAR(45) NOT NULL,
9          `art_price` DECIMAL(2) NOT NULL,
10          `art_description` VARCHAR(300) NULL,
11          `art_customer_id` INT NOT NULL,
12          PRIMARY KEY (`art_title`, `art_customer_id`),
13          UNIQUE INDEX `art_title_UNIQUE` (`art_title` ASC) VISIBLE,
14          INDEX `fk_art_customers_idx` (`art_customer_id` ASC) VISIBLE,
15          CONSTRAINT `fk_art_customers`
16            FOREIGN KEY (`art_customer_id`)
17            REFERENCES `final_project_sadies_art_shop`.`customers` (`customer_id`)
18            ON DELETE NO ACTION
19            ON UPDATE NO ACTION)
20        ENGINE = InnoDB
21
22SQL script execution finished: statements: 10 succeeded, 1 failed
23
24Fetching back view definitions in final form.
25Nothing to fetch