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 <takamune.cho@att.com>

diff --git a/installation/appc/src/main/resources/sdnctl.dump b/installation/appc/src/main/resources/sdnctl.dump
index 5a4a044..dc7c08b 100644 (file)
--- 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`),