Change column to varchar 17/57617/1
authorPatrick Brady <pb071s@att.com>
Wed, 25 Jul 2018 23:12:47 +0000 (16:12 -0700)
committerPatrick Brady <pb071s@att.com>
Wed, 25 Jul 2018 23:12:51 +0000 (16:12 -0700)
The code seems to be trying to treat the port number
column of the DEVICE_AUTHENTICATION table as a string
and not an integer. Setting the column to varchar.

Change-Id: I19f35ac6bdb3ae2ede991e82f177de0f00cdf99e
Signed-off-by: Patrick Brady <pb071s@att.com>
Issue-ID: APPC-1107

installation/appc/src/main/resources/sdnctl.dump

index af3be88..a171d6b 100644 (file)
@@ -215,7 +215,7 @@ CREATE TABLE `DEVICE_AUTHENTICATION` (
   `ACTION` varchar(150) DEFAULT NULL,
   `USER_NAME` varchar(50) DEFAULT NULL,
   `PASSWORD` varchar(100) DEFAULT NULL,
-  `PORT_NUMBER` int(11) DEFAULT NULL,
+  `PORT_NUMBER` varchar(50) DEFAULT NULL,
   `URL` varchar(150) DEFAULT NULL,
   PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
   UNIQUE KEY `DEVICE_AUTHENTICATION_ID` (`DEVICE_AUTHENTICATION_ID`)