diff options
| author | Michael Still <mikal@stillhq.com> | 2012-06-07 07:23:56 +1000 |
|---|---|---|
| committer | Michael Still <mikal@stillhq.com> | 2012-06-07 08:06:53 +1000 |
| commit | bf1ebe78cf191fc3f348a0e35bf6f3d15cdbdee4 (patch) | |
| tree | 866959e13de00f88423684ed7db70b9cdbf517af | |
| parent | 66a7b1895dcf0b7b4ad133edeec3d04205e75c41 (diff) | |
| download | nova-bf1ebe78cf191fc3f348a0e35bf6f3d15cdbdee4.tar.gz nova-bf1ebe78cf191fc3f348a0e35bf6f3d15cdbdee4.tar.xz nova-bf1ebe78cf191fc3f348a0e35bf6f3d15cdbdee4.zip | |
Fix whitespace in sqlite steps
Change-Id: Ieab9c492aa526903c55f17b87b70fe7c25372f5e
| -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; |