Modeler doesn't manage FK constraints with MYSQL
------------------------------------------------
Key: CAY-717
URL: http://issues.apache.org/cayenne/browse/CAY-717
Project: Cayenne
Type: Bug
Components: CayenneModeler GUI
Versions: 2.0 [STABLE]
Environment: OS: Kubuntu
DB: MYSQL5
Reporter: Landry Soules
Priority: Critical
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>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://issues.apache.org/cayenne/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
