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
--- a/installation/appc/src/main/resources/sdnctl.dump
+++ b/installation/appc/src/main/resources/sdnctl.dump
@@ -224,7 +224,7 @@
`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`),