From bf1ebe78cf191fc3f348a0e35bf6f3d15cdbdee4 Mon Sep 17 00:00:00 2001 From: Michael Still Date: Thu, 7 Jun 2012 07:23:56 +1000 Subject: Fix whitespace in sqlite steps Change-Id: Ieab9c492aa526903c55f17b87b70fe7c25372f5e --- nova/db/sqlalchemy/migrate_repo/versions/101_sqlite_downgrade.sql | 6 +++--- 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; -- cgit