From fd61189aa885764d9012bd5855104b258c44b716 Mon Sep 17 00:00:00 2001 From: Mike Bayer Date: Sun, 5 Feb 2006 18:28:02 +0000 Subject: [PATCH] writes foreign keys as individual FOREIGN KEY objects, syntax seems to work better --- lib/sqlalchemy/databases/mysql.py | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py index 268639b690..5dd89d97ef 100644 --- a/lib/sqlalchemy/databases/mysql.py +++ b/lib/sqlalchemy/databases/mysql.py @@ -215,6 +215,6 @@ class MySQLSchemaGenerator(ansisql.ANSISchemaGenerator): if first_pk and isinstance(column.type, types.Integer): colspec += " AUTO_INCREMENT" if column.foreign_key: - colspec += " REFERENCES %s(%s)" % (column.column.foreign_key.column.table.name, column.column.foreign_key.column.name) + colspec += ", FOREIGN KEY (%s) REFERENCES %s(%s)" % (column.name, column.column.foreign_key.column.table.name, column.column.foreign_key.column.name) return colspec -- 2.47.2