diff options
| author | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-02-05 18:28:02 +0000 |
|---|---|---|
| committer | Mike Bayer <mike_mp@zzzcomputing.com> | 2006-02-05 18:28:02 +0000 |
| commit | fd61189aa885764d9012bd5855104b258c44b716 (patch) | |
| tree | 415e839027aa7d34e9da11c44b75d84014999efe /lib/sqlalchemy/databases/mysql.py | |
| parent | 1e1eea05538e43a41750ba8548da517d77284e9c (diff) | |
| download | sqlalchemy-fd61189aa885764d9012bd5855104b258c44b716.tar.gz | |
writes foreign keys as individual FOREIGN KEY objects, syntax seems to work better
Diffstat (limited to 'lib/sqlalchemy/databases/mysql.py')
| -rw-r--r-- | lib/sqlalchemy/databases/mysql.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/sqlalchemy/databases/mysql.py b/lib/sqlalchemy/databases/mysql.py index 268639b69..5dd89d97e 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 |