summaryrefslogtreecommitdiffstats
path: root/kubernetes/portal/charts/portal-mariadb
diff options
context:
space:
mode:
authorstatta <statta@research.att.com>2020-05-07 11:10:28 -0400
committerSunder Tattavarada <statta@research.att.com>2020-05-14 18:00:39 +0000
commit71a281bb8df312213cb231c9eb8a46caf2566432 (patch)
treebe07b708bfe3c58aa962cad6a7a207262da79e07 /kubernetes/portal/charts/portal-mariadb
parent3e2783cbed830bac994df7dbda5832e48b44e12b (diff)
Update Docker Release version
Modify Update DB script. Issue-ID: PORTAL-900, PORTAL-894 Signed-off-by: statta <statta@research.att.com> Change-Id: I224826ef027e38d88f035fcef64969137154fd4d (cherry picked from commit 65d1504ec789ee67496f66f985520aab58c5e4df)
Diffstat (limited to 'kubernetes/portal/charts/portal-mariadb')
-rw-r--r--kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql2
1 files changed, 1 insertions, 1 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
index 13b319c76a..7502e9322a 100644
--- a/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql
+++ b/kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql
@@ -78,7 +78,7 @@ update fn_app set app_username='aaiui', app_password='4LK69amiIFtuzcl6Gsv97Tt7ML
/*
Replace spaces with underscores for role names to match AAF role names
*/
-UPDATE fn_role SET role_name= REPLACE(role_name, ' ', '_') WHERE active_yn= 'Y';
+UPDATE fn_role SET role_name= REPLACE(role_name, ' ', '_') WHERE active_yn= 'Y' AND role_id NOT IN (999);
/*