Contents

Code Reference Functions bp_pre_schema_upgrade()

bp_pre_schema_upgrade()

Perform database operations that must take place before the general schema upgrades.

Description

dbDelta() cannot handle certain operations – like changing indexes – so we do it here instead.

Source

File: bp-core/bp-core-update.php

343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
function bp_pre_schema_upgrade() {
    global $wpdb;
 
    $raw_db_version = (int) bp_get_db_version_raw();
    $bp_prefix      = bp_core_get_table_prefix();
 
    // 2.3.0: Change index lengths to account for utf8mb4.
    if ( $raw_db_version < 9695 ) {
        // Map table_name => columns.
        $tables = array(
            $bp_prefix . 'bp_activity_meta'       => array( 'meta_key' ),
            $bp_prefix . 'bp_groups_groupmeta'    => array( 'meta_key' ),
            $bp_prefix . 'bp_messages_meta'       => array( 'meta_key' ),
            $bp_prefix . 'bp_notifications_meta'  => array( 'meta_key' ),
            $bp_prefix . 'bp_user_blogs_blogmeta' => array( 'meta_key' ),
            $bp_prefix . 'bp_xprofile_meta'       => array( 'meta_key' ),
        );
 
        foreach ( $tables as $table_name => $indexes ) {
            foreach ( $indexes as $index ) {
                if ( $wpdb->query( $wpdb->prepare( "SHOW TABLES LIKE %s", bp_esc_like( $table_name ) ) ) ) {
                    $wpdb->query( "ALTER TABLE {$table_name} DROP INDEX {$index}" );
                }
            }
        }
    }
}

Expand full source code Collapse full source code

Changelog

Changelog
Version Description
BuddyPress 2.3.0 Introduced.

Uses

Uses
Uses Description
bp-core/bp-core-functions.php: bp_esc_like()

Escape special characters in a SQL LIKE clause.
bp-core/bp-core-functions.php: bp_get_db_version_raw()

Return the BuddyPress database version.
bp-core/bp-core-functions.php: bp_core_get_table_prefix()

Get the $wpdb base prefix, run through the ‘bp_core_get_table_prefix’ filter.
Used By
Used By Description
bp-core/admin/bp-core-admin-schema.php: bp_core_install()

Main installer.

Questions?

We're always happy to help with code or other questions you might have! Search our developer docs, contact support, or connect with our sales team.