Thanks for the reply. I'll watch that bug.

Just to let you know, the order of the classes in the file seems to have no effect on the order of the create table statements produced by sqlobject-admin. In fact it seems to be alphabetical. I dont have that many tables right now, so I'm fine with a script that runs sqlobject-admin create on each of them one at a time in the right order.

Mike

>There is an open bug for that:
> http://sourceforge.net/tracker/index.php?func=3Ddetail&aid=3D1432190&group_=
id=3D74338&atid=3D540672

>
>It was caused by the patch that activated foreign key constraints for
>mysql I think. IMHO, a simple workaround which is also "the right
>thing" to do, is to rearrange your table declarations so that foreign
>key constraints only reference upwards in the file.