commit 41ee5e7b78650ae76772f1ec5da0f208820156bd
author tierno <alfonso.tiernosepulveda@telefonica.com> Tue Jul 02 14:13:47 2019 +0000
committer tierno <alfonso.tiernosepulveda@telefonica.com> Tue Jul 02 14:13:47 2019 +0000
tree 427e4fe6906767e4abb70306f1c138da966f66eb
parent 0941ac6f63c8ad51ac833c690b9de0a9964e533a

fix error of database downgrade from 38 to 37

Change-Id: I8e13f5caac4187ecba2e47127a02b2a88ca6005a
Signed-off-by: tierno <alfonso.tiernosepulveda@telefonica.com>

database_utils/migrate_mano_db.sh

diff --git a/database_utils/migrate_mano_db.sh b/database_utils/migrate_mano_db.sh
index e9b08aa..e89c389 100755
--- a/database_utils/migrate_mano_db.sh
+++ b/database_utils/migrate_mano_db.sh
@@ -1398,7 +1398,7 @@
 	    "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;"