reduced the length of index being created - too long index creation was failing in mysql > 5.6