From 71a281bb8df312213cb231c9eb8a46caf2566432 Mon Sep 17 00:00:00 2001 From: statta Date: Thu, 7 May 2020 11:10:28 -0400 Subject: Update Docker Release version Modify Update DB script. Issue-ID: PORTAL-900, PORTAL-894 Signed-off-by: statta Change-Id: I224826ef027e38d88f035fcef64969137154fd4d (cherry picked from commit 65d1504ec789ee67496f66f985520aab58c5e4df) --- .../charts/portal-mariadb/resources/config/mariadb/oom_updates.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'kubernetes/portal/charts/portal-mariadb') 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); /* -- cgit 1.2.3-korg