diff options
| author |   Patrick Brady <pb071s@att.com> | 2018-07-24 11:25:27 -0700 |
|---|---|---|
| committer | Patrick Brady <pb071s@att.com> | 2018-07-24 11:25:33 -0700 |
| commit | f2fd5cf6544e796d6a2f02c7777001b3d4cf2331 (patch) | |
| tree | c1d0851a35eaa2fb90a378b8e7078a7c8b0a834f | |
| parent | 536c49b27d07ada858e152fefd036b6d6060ecb4 (diff) | |
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
| -rw-r--r-- | installation/appc/src/main/resources/sdnctl.dump | 3 |
1 files changed, 3 insertions, 0 deletions
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; |