{"shas":[["43ecc46a224d07661af42379f12f394e1bd873fd","75aee649a7ca5d11614c71284e842240b208603a@metaverseink.com","It looks like there's a better solution for that problem.\nRevert \"Changed Friends table to have 165-sized varchars on PrincipalID and FriendID. The reason for this number is the following: there is a combined key of these 2 fields; apparently MySql can't handle keys larger than 1000 bytes; when the table is created with utf8 encoding, this combined key is bigger than 1000 bytes, and the migration fails. WARNING: this is not a new migration! People who have gone through this migration and failed should update the sizes of these fields manually.\"\n\nThis reverts commit 3fa54a156a83e498a7d5d0949a5f848fe82fe86f.","Diva Canto"],["c13acdf5a1a94df9b0ef50b7b2739a9256656582","75aee649a7ca5d11614c71284e842240b208603a@metaverseink.com","This is the better solution: make the combined key be only on the first 36 characters of each field -- that's the UUIDs. Thanks coyled. WARNING: Again, people who have gone through this migration and failed need to run it manually.","Diva Canto"]],"ref":"refs/heads/master","size":2,"head":"c13acdf5a1a94df9b0ef50b7b2739a9256656582","push_id":32895821}