function uc_shipping_update_7300 in Ubercart 7.3

Add indexes to package and shipment tables.

File

shipping/uc_shipping/uc_shipping.install, line 479

Install, update and uninstall functions for the uc_shipping module.

Code

function uc_shipping_update_7300() {

  // Alter {uc_shipments} table.
  if (!db_index_exists('uc_shipments', 'order_id')) {
    db_add_index('uc_shipments', 'order_id', array(
      'order_id',
    ));
  }

  // Alter {uc_packages} table.
  if (!db_index_exists('uc_packages', 'order_id')) {
    db_add_index('uc_packages', 'order_id', array(
      'order_id',
    ));
  }
  if (!db_index_exists('uc_packages', 'sid')) {
    db_add_index('uc_packages', 'sid', array(
      'sid',
    ));
  }

  // Alter {uc_packaged_products} table.
  if (!db_index_exists('uc_packaged_products', 'order_product_id')) {
    db_add_index('uc_packaged_products', 'order_product_id', array(
      'order_product_id',
    ));
  }
}