Add missing database columns

[appc/deployment.git] / installation / appc / src / main / resources / sdnctl.dump

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;