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
committerstatta <statta@research.att.com>2020-05-07 11:10:28 -0400
commit65d1504ec789ee67496f66f985520aab58c5e4df (patch)
treea1c7b5f282554bf0e57c0ea809338e31f45e8d5b /kubernetes/portal/charts/portal-mariadb
parenta2ea503f3fcc5012d5c376a3665209c38748276b (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
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);
/*