[CAY-717] Modeler doesn't manage FK constraints with MYSQL

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.0 branch
• Fix Version/s: 3.0M1, 3.0
• Component/s: Modeler
• Environment: OS: Kubuntu; DB: MYSQL5
• Assignee: Unassigned
• Reporter: Landry Soules
• Created: 09/Dec/06 22:21
• Updated: 08/May/10 15:41
• Resolved: 22/Apr/07 15:58

Description

Hello,

I used CayenneModeler to design my tables and classes and would like to generate the corresponding SQL, to update my MySQL database. But unfortunately, the "create FK support" option doesn't make any difference, and no foreign key sql statement is generated.
Here is an example of a relation i want to appear in my DB :
<db-relationship name="toCountry" source="address" target="country" toMany="false">
<db-attribute-pair source="country" target="id"/>
</db-relationship>
<db-relationship name="toState" source="address" target="state" toMany="false">
<db-attribute-pair source="state" target="id"/>
</db-relationship>