Bug #64110 WB requires a separate option for the index names much like the FK pattern
Submitted: 23 Jan 2012 13:00 Modified: 23 Jan 2012 15:00
Reporter: Karsten Wutzke Email Updates:
Status: Verified Impact on me:
Category:MySQL Workbench: Modeling Severity:S4 (Feature request)
Version:5.2.37 OS:Any
Assigned to: CPU Architecture:Any

[23 Jan 2012 13:00] Karsten Wutzke
In newer MySQL versions it's no longer possible to have the same names for foreign keys and indexes. Please see


and the respective forum reference:


As such, it's no longer possible to reliably derive index names from the FK pattern given in the options, e.g. when using plugins like


and others.

How to repeat:
see desc

Suggested fix:
Add an option like the FK pattern that would use "idx" or similar instead of "fk" as prefixes/suffixes.
[23 Jan 2012 15:00] Valeriy Kravchuk
Thank you for the feature request.