title: Forward Engineering MySQL Workbench Error 1064
body: <p>I made a EER diagram and I am trying to Forward Engineer it but I get this error and I can't find the mistake.</p>
  
  <blockquote>
    <p>Executing SQL script in server ERROR: 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 'INDEX
    <code>fk_User_Wallets1_idx</code> (<code>Wallets_idWallets</code> ASC) VISIBLE, CONSTRAINT '
    at line 13</p>
  </blockquote>
  
  <p>SQL Code:</p>
  
  <pre><code>        CREATE TABLE IF NOT EXISTS `mydb`.`User` (
            `idUser` INT NOT NULL AUTO_INCREMENT,
            `name` VARCHAR(45) NULL,
            `email` VARCHAR(45) NULL,
            `adress` VARCHAR(45) NULL,
            `password` VARCHAR(45) NULL,
            `saldo` INT NULL,
            `date_start` DATETIME NULL,
            `date_end` DATETIME NULL,
            `Rolls_idRolls` INT NOT NULL,
            `Wallets_idWallets` INT NOT NULL,
            PRIMARY KEY (`idUser`, `Rolls_idRolls`, `Wallets_idWallets`),
            INDEX `fk_User_Rolls1_idx` (`Rolls_idRolls` ASC) VISIBLE,
            INDEX `fk_User_Wallets1_idx` (`Wallets_idWallets` ASC) VISIBLE,
            CONSTRAINT `fk_User_Rolls1`
              FOREIGN KEY (`Rolls_idRolls`)
              REFERENCES `mydb`.`Rolls` (`idRolls`)
              ON DELETE NO ACTION
              ON UPDATE NO ACTION,
            CONSTRAINT `fk_User_Wallets1`
              FOREIGN KEY (`Wallets_idWallets`)
              REFERENCES `mydb`.`Wallets` (`idWallets`)
              ON DELETE NO ACTION
              ON UPDATE NO ACTION)
          ENGINE = InnoDB
  
  SQL script execution finished: statements: 11 succeeded, 1 failed
  
  Fetching back view definitions in final form.
  Nothing to fetch
  </code></pre>