summaryrefslogtreecommitdiffstats
path: root/packages/base/src/files/install/mysql
diff options
context:
space:
mode:
authorMichael Mokry <michael.mokry@att.com>2018-10-17 13:54:24 -0500
committerMichael Mokry <michael.mokry@att.com>2018-10-17 13:54:24 -0500
commit118213c007d9649aaf1d00e515aae281fe42390b (patch)
tree6758470b04ac2fdf63e54151041f9645873d5a2a /packages/base/src/files/install/mysql
parent79b08ac2ed6fdd31ac94bbf549f805487b93941b (diff)
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>
Diffstat (limited to 'packages/base/src/files/install/mysql')
-rw-r--r--packages/base/src/files/install/mysql/data/181003_upgrade_script.sql5
1 files changed, 5 insertions, 0 deletions
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