From 118213c007d9649aaf1d00e515aae281fe42390b Mon Sep 17 00:00:00 2001 From: Michael Mokry Date: Wed, 17 Oct 2018 13:54:24 -0500 Subject: [PATCH] Fix exceptions related to invalid db schema Modified db upgrade script to alter systemlogdb table to allow null values for "remote" column. Change-Id: Ib1bba59a38084bef8f89245d3725d18a02b303dc Issue-ID: POLICY-1204 Signed-off-by: Michael Mokry --- packages/base/src/files/install/mysql/data/181003_upgrade_script.sql | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/packages/base/src/files/install/mysql/data/181003_upgrade_script.sql b/packages/base/src/files/install/mysql/data/181003_upgrade_script.sql index b060292fe..6f2f151cd 100644 --- a/packages/base/src/files/install/mysql/data/181003_upgrade_script.sql +++ b/packages/base/src/files/install/mysql/data/181003_upgrade_script.sql @@ -17,4 +17,9 @@ -- ============LICENSE_END========================================================= use onap_sdk; update fn_app set APP_PASSWORD = '/xMjAl0TB1FgnHih2qA4V5gUkFQNZaK1fiNf3QlRaLI=' where app_id =1; + +use log; +ALTER TABLE systemlogdb +MODIFY remote varchar(255) null; + commit; \ No newline at end of file -- 2.16.6