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 <pb071s@att.com>
Issue-ID: APPC-1107

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index a823a6c..af3be88 100644 (file)
--- 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;