Wade Leftwich wrote:
> For MySql 3.23.44 <= version < 4.1.2, the CREATE TABLE statement must
> explicitly name the foreign key indexes to be created, so as Sqlalchemy
> now stands the table.create() method will not work with an InnoDB table
> that has foreign keys.


The syntax its doing right now is:

CREATE TABLE foo (
    col1 integer primary key,
    col2 integer,
    foreign key (col2) references bar(col1)
) engine=InnoDB

it works in my 5.0 installation.... 3/4 no good ?  we can make it whatever
it has to be.




-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems?  Stop!  Download the new AJAX search engine that makes
searching your log files as easy as surfing the  web.  DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=103432&bid=230486&dat=121642
_______________________________________________
Sqlalchemy-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/sqlalchemy-users

Reply via email to