[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:  Under Consideration
Component:  Component - Any/All  |     Version:
 Severity:  major                |  Resolution:
 Keywords:                       |
---------------------------------+----------------------------------

Comment (by boonebgorges):

 The issue is that `dbDelta()` is attempting to change the indexes on the
 tables, but it doesn't have proper support for `DROP INDEX`. See
 https://core.trac.wordpress.org/ticket/22023#comment:52 (whoops),
 https://core.trac.wordpress.org/ticket/30795,
 https://core.trac.wordpress.org/ticket/26801,
 https://core.trac.wordpress.org/ticket/31869.

 We need an equivalent of `bp_pre_schema_upgrade()`. johnjamesjacoby is
 correct that we don't have an easy way to loop through tables, but at
 `bp_pre_schema_upgrade()` the components haven't yet installed/registered
 themselves anyway, so a hardcoded array seems fine to me. I'm going to
 commit a scaffold for this, and we can add tables as necessary.

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