function uc_discounts_update_7200 in Ubercart Discounts (Alternative) 7.2

Adds indexes to speed up queries. Add primary key to uc_discounts_order_codes.

Note: Update numbering jumps to 7200 which indicates:

• 7 - Drupal version
• 2 - Major module version 2
• 00 - Sequential counting with this being the first update in 7.x-2.x

File

uc_discounts/uc_discounts.install, line 688

Install, update, and uninstall functions for uc_discounts module.

Code

function uc_discounts_update_7200() {
  db_add_index('uc_discounts_codes', 'discount_id', array(
    'discount_id',
  ));
  db_add_index('uc_discounts_roles', 'discount_id', array(
    'discount_id',
  ));
  db_add_index('uc_discounts_uses', 'discount_id', array(
    'discount_id',
  ));
  $order_discount_id_schema = array(
    'type' => 'serial',
    'not null' => TRUE,
  );
  $order_discount_id_keys = array(
    'primary key' => array(
      'order_discount_id',
    ),
    'indexes' => array(
      'order_id' => array(
        'order_id',
      ),
    ),
  );
  db_add_field('uc_discounts_order_codes', 'order_discount_id', $order_discount_id_schema, $order_discount_id_keys);
  return t('Added primary keys and indexes to database tables to speed up queries.');
}