X-Git-Url: https://gerrit.onap.org/r/gitweb?a=blobdiff_plain;f=installation%2Fsdnc%2Fsrc%2Fmain%2Fscripts%2FinstallSdncDb.sh;h=1a4032853ac3f7c11263a76177e425870526b9c2;hb=4b636759c3dd10471111b586092cd2487a7c3eea;hp=7f05d72305e93ae9501794cce42df1a161a70b81;hpb=817f1f33ddffb9ae86a77613439c50ff2059859f;p=sdnc%2Foam.git

diff --git a/installation/sdnc/src/main/scripts/installSdncDb.sh b/installation/sdnc/src/main/scripts/installSdncDb.sh
old mode 100644
new mode 100755
index 7f05d723..1a403285
--- a/installation/sdnc/src/main/scripts/installSdncDb.sh
+++ b/installation/sdnc/src/main/scripts/installSdncDb.sh
@@ -42,13 +42,21 @@ END
 # load schema
 if [ -f ${SDNC_HOME}/data/sdnctl.dump ]
 then
+  echo "Installing ${SDNC_HOME}/data/sdnctl.dump"
   mysql -h dbhost -u root -p${MYSQL_PASSWD} sdnctl < ${SDNC_HOME}/data/sdnctl.dump
 fi
 
 for datafile in ${SDNC_HOME}/data/*.data.dump
 do
+  echo "Installing ${datafile}"
   mysql -h dbhost -u root -p${MYSQL_PASSWD} sdnctl < $datafile
 done
 
 # Create VNIs 100-199
 ${SDNC_HOME}/bin/addVnis.sh 100 199
+
+# Create default ip address pool for VGW
+${SDNC_HOME}/bin/addIpAddresses.sh VGW 10.5.0 22 250
+
+# Drop FK_NETWORK_MODEL foreign key as workaround for SDNC-291.
+${SDNC_HOME}/bin/rmForeignKey.sh NETWORK_MODEL FK_NETWORK_MODEL