diff options
author | 2020-05-07 11:10:28 -0400 | |
---|---|---|
committer | 2020-05-07 11:10:28 -0400 | |
commit | 65d1504ec789ee67496f66f985520aab58c5e4df (patch) | |
tree | a1c7b5f282554bf0e57c0ea809338e31f45e8d5b /kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql | |
parent | a2ea503f3fcc5012d5c376a3665209c38748276b (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/resources/config/mariadb/oom_updates.sql')
-rw-r--r-- | kubernetes/portal/charts/portal-mariadb/resources/config/mariadb/oom_updates.sql | 2 |
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); /* |