Re: Problem with DB schema generation

From: Landry Soules (cayennem..mail.com)
Date: Thu Dec 07 2006 - 16:40:23 EST

  • Next message: Tore Halset: "Re: Problem with MacOSX Intel modeler"

    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.
    >>
    >
    >

    This archive was generated by hypermail 2.0.0 : Thu Dec 07 2006 - 16:40:59 EST