X-Git-Url: https://osm.etsi.org/gitweb/?p=osm%2FRO.git;a=blobdiff_plain;f=database_utils%2Fmigrate_mano_db.sh;h=e89c389f63f6a2036d322db7d414d2217ec14bf9;hp=e9b08aa115a451349cf0230f2abe4ea1f45c9040;hb=41ee5e7b78650ae76772f1ec5da0f208820156bd;hpb=0941ac6f63c8ad51ac833c690b9de0a9964e533a 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;"