From 41ee5e7b78650ae76772f1ec5da0f208820156bd Mon Sep 17 00:00:00 2001 From: tierno Date: Tue, 2 Jul 2019 14:13:47 +0000 Subject: [PATCH] fix error of database downgrade from 38 to 37 Change-Id: I8e13f5caac4187ecba2e47127a02b2a88ca6005a Signed-off-by: tierno --- database_utils/migrate_mano_db.sh | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/database_utils/migrate_mano_db.sh b/database_utils/migrate_mano_db.sh index e9b08aa1..e89c389f 100755 --- a/database_utils/migrate_mano_db.sh +++ b/database_utils/migrate_mano_db.sh @@ -1398,7 +1398,7 @@ function downgrade_from_38(){ "CHANGE COLUMN status status ENUM('SCHEDULED','BUILD','DONE','FAILED','SUPERSEDED') " \ "NOT NULL DEFAULT 'SCHEDULED' AFTER item_id;" echo " Remove related from instance_xxxx" - for table in instance_classifications instance_nets instance_wim_netsinstance_sfis instance_sfps instance_sfs \ + for table in instance_classifications instance_nets instance_wim_nets instance_sfis instance_sfps instance_sfs \ instance_vms do sql "ALTER TABLE $table DROP COLUMN related;" -- 2.17.1