Mysql Specified key was too long； max key length is 767 bytes

Mysql Specified key was too long; max key length is 767 bytes

mysql InnoDB 默认索引最大长度为767 bytes
启用innodb_large_prefix参数，索引可以超过 767bytes

注意：
①启用innodb_large_prefix参数能够取消对于索引中每列长度的限制(但是无法取消对于索引总长度的限制)
②启用innodb_large_prefix必须同时指定innodb_file_format=barracuda，innodb_file_per_table=true，并且建表的时候指定表的row_format为dynamic或者compressed(mysql 5.6中row_format默认值为compact)

SET GLOBAL INNODB_LARGE_PREFIX = ON;

SET GLOBAL innodb_file_format = BARRACUDA;