DDL script for MySQL does not work

[AndreasBuschka]

Hello!

The DDL script generated from the EA diagramm (current build) does not work with the mySQL 4.x server:

1. For foreign keys, Create Table needs to specify the InnoDB table type:

CREATE TABLE CUSTOMER (A INT, B CHAR (20), INDEX (A)) TYPE = InnoDB;

(TYPE = InnoDB is missing in the EA output)

2. The Syntax for defining foreign keys is wrong:

Wrong:
ALTER TABLE abonnements
     ADD CONSTRAINT PRIMARY
     PRIMARY KEY (ABONNEMENT_ID)
;

Right:
ALTER TABLE abonnements
     ADD
     PRIMARY KEY (ABONNEMENT_ID)
;

Is there any way to work around this?