diff options
| author | Josh Kearney <josh@jk0.org> | 2011-07-27 15:22:51 -0500 |
|---|---|---|
| committer | Josh Kearney <josh@jk0.org> | 2011-07-27 15:22:51 -0500 |
| commit | 7d02bd555d7519d485d00e02136d26a6e4e7096e (patch) | |
| tree | ba550ec33d489159f5321407f4bf123b0aeac8f1 | |
| parent | ce8acf3275086e0337324fb69f3c1fa530e09e50 (diff) | |
| download | nova-7d02bd555d7519d485d00e02136d26a6e4e7096e.tar.gz nova-7d02bd555d7519d485d00e02136d26a6e4e7096e.tar.xz nova-7d02bd555d7519d485d00e02136d26a6e4e7096e.zip | |
Drop FK before dropping instance_id column.
| -rw-r--r-- | nova/db/sqlalchemy/migrate_repo/versions/034_change_instance_id_in_migrations.py | 6 |
1 files changed, 6 insertions, 0 deletions
diff --git a/nova/db/sqlalchemy/migrate_repo/versions/034_change_instance_id_in_migrations.py b/nova/db/sqlalchemy/migrate_repo/versions/034_change_instance_id_in_migrations.py index b002ba064..9a447c270 100644 --- a/nova/db/sqlalchemy/migrate_repo/versions/034_change_instance_id_in_migrations.py +++ b/nova/db/sqlalchemy/migrate_repo/versions/034_change_instance_id_in_migrations.py @@ -17,6 +17,7 @@ from sqlalchemy import Column, Integer, String, MetaData, Table + meta = MetaData() @@ -33,6 +34,11 @@ def upgrade(migrate_engine): meta.bind = migrate_engine migrations = Table('migrations', meta, autoload=True) migrations.create_column(instance_uuid) + + if migrate_engine.name == "mysql": + migrate_engine.execute("ALTER TABLE migrations DROP FOREIGN KEY " \ + "`migrations_ibfk_1`;") + migrations.c.instance_id.drop() |