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 <michael.mokry@att.com>

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 b060292..6f2f151 100644 (file)
--- 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