Bug #47728 Export - Forward Engineer SQL Create Script is generating incorrect syntax
Submitted: 29 Sep 2009 20:41 Modified: 29 Sep 2009 21:39
Reporter: Rudolf Streif Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Workbench Severity:S3 (Non-critical)
Version:5.2.3 OSS Alpha OS:Windows (XP)
Assigned to: CPU Architecture:Any

[29 Sep 2009 20:41] Rudolf Streif 
Description:
When using Export - Forward Engineer SQL Create Script the generated script has an incorrect syntax: closing ')' are missing in CREATE TABLE statements.

-- -----------------------------------------------------
-- Table `mymedia`.`audioencoding`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `mymedia`.`audioencoding` ;

CREATE  TABLE IF NOT EXISTS `mymedia`.`audioencoding` (
    `idencoding` VARCHAR(25) NOT NULL ,
    `type` VARCHAR(255) NOT NULL ,
    `description` VARCHAR(255) NULL ,
    PRIMARY KEY (`idencoding`)
ENGINE = InnoDB;

                              ^ closing ')' is missing

How to repeat:
Design a DB with a table in OSS Workbench.
[29 Sep 2009 21:39] MySQL Verification Team 
Thank you for the bug report. Duplicate of bug http://bugs.mysql.com/bug.php?id=47407.