Hi,
I got an mysql error during migration process.
Syntax error or access violation: 1059
Cause by name of unique key being too long.
reference source
A key name 'translator_translations_locale_namespace_group_item_unique' will be used automatically, whose length is 58.
And if database prefix is being used, it may violate the restriction of maximum length(64 characters).
Is it possible to just give it a specific short key name?
like $table->unique(['locale', 'namespace', 'group', 'item'], 'short_name');
smallcar88
commented
5 years ago
Hi, I got an mysql error during migration process. Syntax error or access violation: 1059 Cause by name of unique key being too long. reference source A key name 'translator_translations_locale_namespace_group_item_unique' will be used automatically, whose length is 58. And if database prefix is being used, it may violate the restriction of maximum length(64 characters). Is it possible to just give it a specific short key name? like
$table->unique(['locale', 'namespace', 'group', 'item'], 'short_name');