function sf_prematch_update_1 in Salesforce Suite 6.2

Same name and namespace in other branches

1. 7.2 sf_prematch/sf_prematch.install \sf_prematch_update_1()

See also

salesforce_api_update_1

File

sf_prematch/sf_prematch.install, line 75

Installs tables needed for sf_prematch module.

Code

function sf_prematch_update_1() {
  $ret = array();
  if (!db_column_exists('salesforce_field_map', 'name')) {
    $ret[] = array(
      'success' => FALSE,
      'query' => 'N/A',
    );
    drupal_set_message(t('There are still updates to be run: Update for sf_prematch was not run. Please run update.php again to complete this update.'), 'warning');
  }
  db_add_column($ret, 'salesforce_prematch', 'name', 'varchar(255)');
  $result = db_query('SELECT fieldmap, name FROM {salesforce_field_map}');
  while ($row = db_fetch_array($result)) {
    $sql = 'UPDATE {salesforce_prematch} SET name = "%s" WHERE fieldmap = %d';
    $update_result = db_query($sql, $name, $fieldmap);
    $ret[] = array(
      'success' => $update_result !== FALSE,
      'query' => check_plain($sql),
    );
  }
  db_add_primary_key($ret, 'salesforce_prematch', 'name', array(
    'name',
  ));
  $ret[] = update_sql('ALTER TABLE {salesforce_prematch} DROP COLUMN fieldmap');
  return $ret;
}