I ended up updating MySQL on my dev box to 5.6 by accident and found that our schema doesn't work as-is. I found myself running into a couple of max key length issues where the key length is limited to 767 bytes. We have a couple of indexed 1024byte fields though, for instance ca_occurrence_labels.name or ca_object_representations.original_filename.
According to the mysql doc there's no way around that 767byte limit. The weird thing is that it's been there since at least 5.1.