Forward Engineering Data Modeling Design Causes Error

[Russell Simmons]

I'm using Workbench 5.3.28 to design a database. However, when I try to forward engineer, I get an error.

The SQL script that's causing the error is:


-- -----------------------------------------------------

-- Table `mydb`.`Training_Classes`

-- -----------------------------------------------------

CREATE TABLE IF NOT EXISTS `mydb`.`Training_Classes` (

`Training_Key` CHAR(10) NOT NULL COMMENT 'This is the course number (i.e. IS-100, AWR-177)' ,

`Expiration_Term` TINYINT ZEROFILL NOT NULL COMMENT 'The training expiration time, in months. If the training doesn\'t expire, then 0.' ,

`Training_Desc` VARCHAR(45) NOT NULL ,

INDEX `Training_Key` () ,

PRIMARY KEY (`Training_Key`) ,

UNIQUE INDEX `Training_Key_UNIQUE` (`Training_Key` ASC) )

ENGINE = InnoDB;


The error says:

ERROR: Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ,

PRIMARY KEY (`Training_Key`) ,

UNIQUE INDEX `Training_Key_UNIQUE` (`Trai' at line 8

I'm familiar with database design, but not so much with MyQSL.

Does anyone have an idea what I'm doing wrong?