From: Michael Mokry <michael.mokry@att.com>
Date: Wed, 17 Oct 2018 18:54:24 +0000 (-0500)
Subject: Fix exceptions related to invalid db schema
X-Git-Tag: 1.3.1~12
X-Git-Url: https://gerrit.onap.org/r/gitweb?p=policy%2Fengine.git;a=commitdiff_plain;h=118213c007d9649aaf1d00e515aae281fe42390b

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 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