MySQL supports the full FOREIGN KEY syntax in versions
3.23.50 and newer, and 4.0.8 and newer, and I believe
all 4.1 and 5.0 versions. To implement this in
SQLObject-0.7a, I copied the
col.SOForeignKey.postgresCreateSQL() method to
mysqlCreateSQL() and performed some minor editing.
0.7a col.py patch for MySQL FOREIGN KEY schema support
Logged In: YES
user_id=4799
Looks good at first glance, but I am reluctant to apply such
a patch while SQLObject is at the beta stage, espcially
considering I use Postgres and MySQL, but not MySQL, so I
cannot properly test it. Let's wait until post-0.7.
Logged In: YES
user_id=4799
Applied at the revision 1135 in the trunk.
Logged In: NO
I had the same problem and fixed it almost the same way as
the bug reporter, and it worked. I think this patch should
be included as soon as possible.