MySQL & DDL generation

[jdoran]

I'm trying to use EA (3.60.658) to generate some DDL from a data model so I can iniitalize a MySql db(4.0.14).

The MySQL DDL generation in EA is using Innodb for table types that it creates.  No problem with that, but they require that all Foreign Keys are previously INDEXed.   When I add an explicit operation to the problematic table in the EA data model that uses the index stereotype with a particular column, no SQL is generated.   I'm also selecting the Generate Index/Constraints on the Generate DDL dialog.

Has anyone seen this problem or suggest what I might be doing wrong?

Also, is there a way to insert some SQL into the top of the generated DDL file?  I'd like add a "use database" command.

Thanks.

[gerolindien]

Hi,
i'm currently facing exactly the same pb, is it any solution?
(actually only the first and the last index are generated)

Thanks

[hd]

This is a bug in EA  , and a fix should be available hopefully for build 728.

[gerolindien]

ok ...  
i ll wait then  

thx for the quick answer