From 80c7ca3eb3509163ebf5a4f94a7fdc37fc4fc16a Mon Sep 17 00:00:00 2001 From: Taka Cho Date: Thu, 14 Mar 2019 15:53:16 -0400 Subject: [PATCH] unique key too long in DEVICE_AUTHENTICATION Specified key was too long; max key length is 767 bytes reduce URL to 256 Change-Id: I2c721db78710505a6e6f67fe2f438554655b091d Issue-ID: APPC-1537 Signed-off-by: Taka Cho --- installation/appc/src/main/resources/sdnctl.dump | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump index 5a4a044..dc7c08b 100644 --- a/installation/appc/src/main/resources/sdnctl.dump +++ b/installation/appc/src/main/resources/sdnctl.dump @@ -224,7 +224,7 @@ CREATE TABLE `DEVICE_AUTHENTICATION` ( `USER_NAME` varchar(255) DEFAULT NULL, `PASSWORD` varchar(255) DEFAULT NULL, `PORT_NUMBER` int(11) DEFAULT NULL, - `URL` varchar(1024) DEFAULT NULL, + `URL` varchar(256) DEFAULT NULL, PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`), UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`,`URL`), KEY `PROTOCOL` (`PROTOCOL`), -- 2.16.6