diff options
-rw-r--r-- | nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_downgrade.sql | 6 | ||||
-rw-r--r-- | nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_upgrade.sql | 6 |
2 files changed, 6 insertions, 6 deletions
diff --git a/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_downgrade.sql b/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_downgrade.sql index 5f13b8997..08aaa241c 100644 --- a/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_downgrade.sql +++ b/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_downgrade.sql @@ -5,7 +5,7 @@ BEGIN TRANSACTION; deleted_at DATETIME, deleted BOOLEAN, id INTEGER NOT NULL, - security_group_id INTEGER NOT NULL, + security_group_id INTEGER NOT NULL, instance_id INTEGER NOT NULL, instance_uuid VARCHAR(36), PRIMARY KEY (id) @@ -17,7 +17,7 @@ BEGIN TRANSACTION; deleted_at, deleted, id, - security_group_id, + security_group_id, NULL, instance_uuid FROM security_group_instance_association; @@ -37,7 +37,7 @@ BEGIN TRANSACTION; deleted_at DATETIME, deleted BOOLEAN, id INTEGER NOT NULL, - security_group_id INTEGER NOT NULL, + security_group_id INTEGER NOT NULL, instance_id INTEGER NOT NULL, PRIMARY KEY (id), FOREIGN KEY(instance_id) REFERENCES instances (id) diff --git a/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_upgrade.sql b/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_upgrade.sql index f39d5b1fc..d66c5ce37 100644 --- a/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_upgrade.sql +++ b/nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_upgrade.sql @@ -11,13 +11,13 @@ BEGIN TRANSACTION; PRIMARY KEY (id) ); - INSERT INTO security_group_instance_association_backup + INSERT INTO security_group_instance_association_backup SELECT created_at, updated_at, deleted_at, deleted, id, - security_group_id, + security_group_id, instance_id, NULL FROM security_group_instance_association; @@ -52,7 +52,7 @@ BEGIN TRANSACTION; deleted_at, deleted, id, - security_group_id, + security_group_id, instance_uuid FROM security_group_instance_association_backup; |