From f2fd5cf6544e796d6a2f02c7777001b3d4cf2331 Mon Sep 17 00:00:00 2001 From: Patrick Brady Date: Tue, 24 Jul 2018 11:25:27 -0700 Subject: [PATCH] Add missing database columns Columns in the DEVICE_AUTHENTICATION table are missing that are being referenced in queries. Change-Id: Iab4557011d0fa6a3ff2cd16710458878442ef663 Signed-off-by: Patrick Brady Issue-ID: APPC-1107 --- installation/appc/src/main/resources/sdnctl.dump | 3 +++ 1 file changed, 3 insertions(+) diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump index a823a6c..af3be88 100644 --- a/installation/appc/src/main/resources/sdnctl.dump +++ b/installation/appc/src/main/resources/sdnctl.dump @@ -211,9 +211,12 @@ DROP TABLE IF EXISTS `DEVICE_AUTHENTICATION`; CREATE TABLE `DEVICE_AUTHENTICATION` ( `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT, `VNF_TYPE` varchar(150) DEFAULT NULL, + `PROTOCOL` varchar(150) DEFAULT NULL, + `ACTION` varchar(150) DEFAULT NULL, `USER_NAME` varchar(50) DEFAULT NULL, `PASSWORD` varchar(100) DEFAULT NULL, `PORT_NUMBER` int(11) DEFAULT NULL, + `URL` varchar(150) DEFAULT NULL, PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`), UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`) ) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1; -- 2.16.6