I am getting this error in MySQL Workbench:

Executing SQL script in server

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 ')

ENGINE = InnoDB' at line 5

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

-- Table `mydb`.`dvd_collection`

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

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



SQL script execution finished: statements: 5 succeeded, 1 failed
What is wrong with the sql?