wc_update_310_downloadable_products()
Add an index to the downloadable product permissions table to improve performance of update_user_by_order_id.
Contents
Description Description
Source Source
File: includes/wc-update-functions.php
function wc_update_310_downloadable_products() {
global $wpdb;
$index_exists = $wpdb->get_row( "SHOW INDEX FROM {$wpdb->prefix}woocommerce_downloadable_product_permissions WHERE column_name = 'order_id' and key_name = 'order_id'" );
if ( is_null( $index_exists ) ) {
$wpdb->query( "ALTER TABLE {$wpdb->prefix}woocommerce_downloadable_product_permissions ADD INDEX order_id (order_id)" );
}
}