commit fc5f80b75e9b9d79a27df62638e03154ca00a767
author tierno <alfonso.tiernosepulveda@telefonica.com> Tue May 29 16:00:43 2018 +0200
committer tierno <alfonso.tiernosepulveda@telefonica.com> Thu Jul 19 14:34:17 2018 +0200
tree ce075105f91351f82fb8cfa4733b9123e9e07d0a
parent a8e5b7847d8731b96623f742e62dbb6016d42bff

vdu scaling

Change-Id: I93269b77d5be6cbd8fe635239465381dc874c9a5
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 37527f1..3187324 100755
--- a/database_utils/migrate_mano_db.sh
+++ b/database_utils/migrate_mano_db.sh
@@ -33,7 +33,7 @@
 DBNAME="mano_db"
 QUIET_MODE=""
 #TODO update it with the last database version
-LAST_DB_VERSION=31
+LAST_DB_VERSION=32
 
 # Detect paths
 MYSQL=$(which mysql)
@@ -199,6 +199,7 @@
 #[ $OPENMANO_VER_NUM -ge 5059 ] && DB_VERSION=29  #0.5.59 =>  29
 #[ $OPENMANO_VER_NUM -ge 5060 ] && DB_VERSION=30  #0.5.60 =>  30
 #[ $OPENMANO_VER_NUM -ge 5061 ] && DB_VERSION=31  #0.5.61 =>  31
+#[ $OPENMANO_VER_NUM -ge 5070 ] && DB_VERSION=32  #0.5.70 =>  32
 #TODO ... put next versions here
 
 function upgrade_to_1(){
@@ -1279,6 +1280,17 @@
     sql "ALTER TABLE sce_nets DROP COLUMN vim_network_name;"
     sql "DELETE FROM schema_version WHERE version_int='31';"
 }
+function upgrade_to_32(){
+    echo "      Add 'vim_name' to 'instance_vms'"
+    sql "ALTER TABLE instance_vms ADD COLUMN vim_name VARCHAR(255) NULL DEFAULT NULL AFTER vim_vm_id;"
+    sql "INSERT INTO schema_version (version_int, version, openmano_ver, comments, date) "\
+         "VALUES (32, '0.32', '0.5.70', 'Add vim_name to instance vms', '2018-06-28');"
+}
+function downgrade_from_32(){
+    echo "      Remove back 'vim_name' from 'instance_vms'"
+    sql "ALTER TABLE instance_vms DROP COLUMN vim_name;"
+    sql "DELETE FROM schema_version WHERE version_int='32';"
+}
 
 function upgrade_to_X(){
     echo "      change 'datacenter_nets'"