cayenne-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Landry Soules <cayenn...@gmail.com>
Subject Re: Problem with DB schema generation
Date Thu, 07 Dec 2006 21:40:23 GMT
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.
>>
>
>


Mime
View raw message