aYLBkdeh

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_carro_leilao1_idx` (`leilao_idleilao` ASC) VISIBLE,
4  CONSTRAINT `f' at line 15 
5     
6-- -----------------------------------------------------
7    -- Table `carrosleilao`.`carro`
8    -- -----------------------------------------------------
9    CREATE TABLE IF NOT EXISTS `carrosleilao`.`carro` (
10      `idcarro` INT NOT NULL AUTO_INCREMENT,
11      `modelo` VARCHAR(45) NOT NULL,
12      `marca` VARCHAR(45) NOT NULL,
13      `ano` VARCHAR(5) NOT NULL,
14      `combustivel` VARCHAR(45) NOT NULL,
15      `precoFIPE` VARCHAR(45) NOT NULL,
16      `referencia` VARCHAR(45) NOT NULL,
17      `preco_idpreco` INT NOT NULL,
18      `leilao_idleilao` INT NOT NULL,
19      PRIMARY KEY (`idcarro`, `preco_idpreco`, `leilao_idleilao`),
20      INDEX `fk_carro_preco_idx` (`preco_idpreco` ASC) VISIBLE,
21      INDEX `fk_carro_leilao1_idx` (`leilao_idleilao` ASC) VISIBLE,
22      CONSTRAINT `fk_carro_preco`
23        FOREIGN KEY (`preco_idpreco`)
24        REFERENCES `carrosleilao`.`preco` (`idpreco`)
25        ON DELETE NO ACTION
26        ON UPDATE NO ACTION,
27      CONSTRAINT `fk_carro_leilao1`
28        FOREIGN KEY (`leilao_idleilao`)
29        REFERENCES `carrosleilao`.`leilao` (`idleilao`)
30        ON DELETE NO ACTION
31        ON UPDATE NO ACTION)
32    ENGINE = InnoDB 
33     
34index_option:
35    KEY_BLOCK_SIZE [=] value
36  | index_type
37  | WITH PARSER parser_name
38  | COMMENT 'string' 
39     
40INDEX `fk_carro_preco_idx` (`preco_idpreco` ASC) VISIBLE,
41  INDEX `fk_carro_leilao1_idx` (`leilao_idleilao` ASC) VISIBLE,