cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrus Adamchik <and...@objectstyle.org>
Subject Re: Problem with DB schema generation
Date Thu, 07 Dec 2006 09:43:50 GMT
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.
>


Mime
View raw message