fix error of database downgrade from 38 to 37

[osm/RO.git] / 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 (executable)
--- 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;"