query( "ALTER TABLE {$wpdb->gp_translation_sets} DROP INDEX project_id_slug_locale, DROP INDEX locale_slug;" ); $wpdb->query( "ALTER TABLE {$wpdb->gp_originals} DROP INDEX singular_plural_context;" ); $wpdb->query( "ALTER TABLE {$wpdb->gp_meta} DROP INDEX object_type__meta_key, DROP INDEX object_type__object_id__meta_key;" ); } dbDelta( implode( "\n", gp_schema_get() ) ); if ( $gp_db_version ) { gp_upgrade_data( $gp_db_version ); } update_option( 'gp_db_version', GP_DB_VERSION ); } /** * Updates existing data in the database during an upgrade. * * @since 1.0.0 * * @param int $db_version The current version of the database before the upgrade. */ function gp_upgrade_data( $db_version ) { global $wpdb; if ( $db_version < 950 ) { $wpdb->query( "UPDATE {$wpdb->gp_projects} SET `path` = SUBSTRING(`path`, 1, CHAR_LENGTH(`path`) - 1) WHERE `path` LIKE '%/';" ); } }