function lingotek_update_7721 in Lingotek Translation 7.7

Adds indices to the lingotek_config_metadata and lingotek_config_map tables

File

./lingotek.install, line 1119

Code

function lingotek_update_7721(&$sandbox) {
  $output = '';
  if (db_table_exists('lingotek_config_metadata')) {
    if (db_field_exists('lingotek_config_metadata', 'id')) {
      if (!db_index_exists('lingotek_config_metadata', 'idx_id')) {
        db_add_index('lingotek_config_metadata', 'idx_id', array(
          'id',
        ));
        $output .= 'Index added for id in lingotek_config_metadata table.' . "\r\n";
      }
    }
    if (db_field_exists('lingotek_config_metadata', 'config_key')) {
      if (!db_index_exists('lingotek_config_metadata', 'idx_config_key')) {
        db_add_index('lingotek_config_metadata', 'idx_config_key', array(
          'config_key',
        ));
        $output .= 'Index added for config_key in lingotek_config_metadata table.' . "\r\n";
      }
    }
    if (db_field_exists('lingotek_config_metadata', 'id') && db_field_exists('lingotek_config_metadata', 'config_key') && db_field_exists('lingotek_config_metadata', 'value')) {
      if (!db_index_exists('lingotek_config_metadata', 'idx_id_and_config_key_and_value')) {
        db_add_index('lingotek_config_metadata', 'idx_id_and_config_key_and_value', array(
          'id',
          'config_key',
          'value',
        ));
        $output .= 'Index added for id and config_key and value in lingotek_config_metadata table.' . "\r\n";
      }
    }
    if (db_field_exists('lingotek_config_metadata', 'config_key') && db_field_exists('lingotek_config_metadata', 'value')) {
      if (!db_index_exists('lingotek_config_metadata', 'idx_config_key_and_value')) {
        db_add_index('lingotek_config_metadata', 'idx_config_key_and_value', array(
          'config_key',
          'value',
        ));
        $output .= 'Index added for config_key and value in lingotek_config_metadata table.' . "\r\n";
      }
    }
  }
  if (db_table_exists('lingotek_config_map')) {
    if (db_field_exists('lingotek_config_map', 'lid') && db_field_exists('lingotek_config_map', 'current')) {
      if (!db_index_exists('lingotek_config_map', 'idx_lid_and_current')) {
        db_add_index('lingotek_config_map', 'idx_lid_and_current', array(
          'lid',
          'current',
        ));
        $output .= 'Index added for lid and current in lingotek_config_map table.' . "\r\n";
      }
    }
    if (db_field_exists('lingotek_config_map', 'set_id')) {
      if (!db_index_exists('lingotek_config_map', 'idx_set_id')) {
        db_add_index('lingotek_config_map', 'idx_set_id', array(
          'set_id',
        ));
        $output .= 'Index added for set_id in lingotek_config_map table.' . "\r\n";
      }
    }
  }
  if (empty($output)) {
    $output = 'All indices already present. No action taken.';
  }
  return t($output);
}