I emailed Apache infrastructure list. Hopefully it will be back up soon.
Andrus
On Dec 7, 2006, at 11:40 PM, Landry Soules wrote:
OK, i will but for the moment the link is not accessible...
Andrus Adamchik a écrit :
This is a bug - Modeler still thinks that MySQL doesn't supports
FK constraints, just like in the old days... Could you please open
a bug report?
http://issues.apache.org/cayenne/
Andrus
On Dec 7, 2006, at 12:19 AM, Landry Soules wrote:
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>
Thank you for your help.