function uc_order_update_7002 in Ubercart 7.3

Add indexes so product and customer reports are usable with large datasets.

File

uc_order/uc_order.install, line 765

Install, update and uninstall functions for the uc_order module.

Code

function uc_order_update_7002() {

  // Indexes may have been added by uc_order_update_6019() in 6.x-2.x.
  if (!db_index_exists('uc_order_products', 'qty')) {
    db_add_index('uc_order_products', 'qty', array(
      'qty',
    ));
  }
  if (!db_index_exists('uc_order_products', 'nid')) {
    db_add_index('uc_order_products', 'nid', array(
      'nid',
    ));
  }
}