fix error of database downgrade from 38 to 37 39/7739/1
authortierno <alfonso.tiernosepulveda@telefonica.com>
Tue, 2 Jul 2019 14:13:47 +0000 (14:13 +0000)
committertierno <alfonso.tiernosepulveda@telefonica.com>
Tue, 2 Jul 2019 14:13:47 +0000 (14:13 +0000)
Change-Id: I8e13f5caac4187ecba2e47127a02b2a88ca6005a
Signed-off-by: tierno <alfonso.tiernosepulveda@telefonica.com>
database_utils/migrate_mano_db.sh

index e9b08aa..e89c389 100755 (executable)
@@ -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;"