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.
Argh. There's no reason why we need the key so long. I believe they were saying the keys could be that long in InnoDb. Certainly it did work for a while. Could you revise the schema? I'm online this morning for now but won't be back on for a day or two.
Okay, I just wanted to run this by you before messing with the schema.
There's a pull request for this in GitHub.
The changes are quite substantial so I opened a pull request so you can at least take a look before we merge it.