[buddypress-trac] [BuddyPress Trac] #6346: Upgrade DB tables to utf8mb4

[buddypress-trac]

#6346: Upgrade DB tables to utf8mb4
---------------------------------+-----------------------------
 Reporter:  DJPaul               |       Owner:
     Type:  enhancement          |      Status:  new
 Priority:  normal               |   Milestone:  Future Release
Component:  Component - Any/All  |     Version:
 Severity:  normal               |  Resolution:
 Keywords:                       |
---------------------------------+-----------------------------

Comment (by johnjamesjacoby):

 [https://buddypress.trac.wordpress.org/attachment/ticket/6346/6346.01.patch
 6346.01.patch] does a few things:

 * Adds max index length for our `meta_key` columns
 * Moves `id` `PRIMARY KEY` to its own line
 * Makes our `id` columns `unsigned` to match WordPress core and get what
 little speed boost comes from it

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/6346#comment:2>
BuddyPress Trac <http://buddypress.org/>
BuddyPress Trac