Ok found the issue for those that are interested.
http://www.davidnarelle.com/EA/ddl-bug.gifHere is how to reproduce the problem. For those that cannot be bothered; the issue is when you have a self referencing foreign key. When using the generate DDL any table that has a foreign key target to that table will not be generated. So that is Table1 and Table3 in the diagram!
The EAP FileCreate a new Project or download the eap from
http://www.davidnarelle.com/EA/ddl-bug.zipHow to create the eap fileSelect "Database" Model.
Open the "Schema1" package.
Using the default schema package where Table1 references Table2.
Change the tables to MySQL
Add the following columns to
Table1id BIGINT PK
name String
Add the following columns to
Table2id BIGINT PK
parent_id BIGINT
Update the foreign key relationship betwen table1 and table2 using the ids of both tables. That is Table1 id is a reference to Table2's id.
The parent_id is a self reference to its self; that is the foreign key points back to the same table. To do this add an association that references Table2 to its self. Update the foreign key and set the Source: Table2 parent_id column to Target: Table 2 id column. Click save.
The bugRight click on the package Schema1 and select Code Engineering -> Generate DDL...
Select all tables, select a file to save the ddl to and then click generate.
The list of tables that have been generated will only include Table2. Table1 is not created. Only Table2 will be generated. If you have downloaded the project file then it contains an additional table (Table3) which is also not created.
Also note that by selecting just table 2 (not table1) and click generate no tables will be created!
