-
Bug
-
Resolution: Done
-
Medium
-
Dublin Release
-
None
MariaDB [sdnctl]> CREATE TABLE `DEVICE_AUTHENTICATION` (
-> `DEVICE_AUTHENTICATION_ID` int(11) NOT NULL AUTO_INCREMENT,
-> `VNF_TYPE` varchar(255) NOT NULL,
-> `PROTOCOL` varchar(255) NOT NULL,
-> `ACTION` varchar(255) NOT NULL,
-> `USER_NAME` varchar(255) DEFAULT NULL,
-> `PASSWORD` varchar(255) DEFAULT NULL,
-> `PORT_NUMBER` int(11) DEFAULT NULL,
-> `URL` varchar(1024) DEFAULT NULL,
-> PRIMARY KEY (`DEVICE_AUTHENTICATION_ID`),
-> UNIQUE KEY `VNF_TYPE_UNIQ` (`VNF_TYPE`,`PROTOCOL`,`ACTION`,`URL`),
-> KEY `PROTOCOL` (`PROTOCOL`),
-> KEY `ACTION` (`ACTION`)
-> ) ENGINE=InnoDB AUTO_INCREMENT=107 DEFAULT CHARSET=latin1;
ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes