Hi,
MySQL 5.6 and Amazon Aurora have a max key length of 767 bytes. Because one character uses 4 bytes when using utf8mb4 charset, that means an index can only be created for max 191 chars. So even creating an index on a VARCHAR(255) field will fail with the error message: #1071 - Specified key was too long.
The only way to index such fields is either by reducing the field's size to 191 or by limiting the index/key length to 191.
Defining the field size in Doctrine is possible since 2.9 (see https://github.com/doctrine/dbal/pull/2412).
Can you please add an option to set the key length in Skipper? Exporting to entities should be pretty straightforward. E.g.: @Index(name="indexname", columns={"columnname"}, options={"lengths": {191}})
Thanks very much!