Removing portal schema from configmap

-Trying a new way to initialize maria db's.
-Docker image contains project sources and sql files are fetched
and executed agains't the target database.
-duplicates are silently ignored.
-A script that takes some basic params will do the heavy lifting
-A 2nd job to make some OOM specific changes (carry over from amsterdam)
-docker image has been pushed to oomk8s under the 2.0.0 number

Issue-ID: OOM-858

Change-Id: I56d0c9c5aa1d3c4a9df2998634b9147db626d1fb
Signed-off-by: Mandeep Khinda <mandeep.khinda@amdocs.com>

1 files changed, 8 insertions, 0 deletions

diff --git a/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql b/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql
new file mode 100644
index 0000000000..781b04626c
--- /dev/null
+++ b/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql
@@ -0,0 +1,8 @@
+USE portal;
+/*
+Any updates required by OOM to the portaldb are made here.
+1. split up SDC-FE and SDC-BE.  Originally both FE and BE point to the same IP
+while the OOM K8s version has these service split up.
+*/
+UPDATE fn_app SET app_rest_endpoint = 'http://sdc.api.be.simpledemo.onap.org:8080/api/v2' where app_name = 'SDC';
+UPDATE fn_app SET app_url = 'http://cli.api.simpledemo.onap.org:8080', app_type = 1 where app_name='CLI';