function location_update_5304 in Location 5.3

Location 3.x update 5.

File

./location.install, line 606

Installation / uninstallation routines.

Code

function location_update_5304() {
  $ret = array();
  variable_set('location_update_5304_done', TRUE);

  // Delete unused variables.
  variable_del('location_configured_countries');
  variable_del('location_garbagecollect');

  // Update province code for Italy/Forlì-Cesena.
  $ret[] = update_sql("UPDATE {location} SET province = 'FC' WHERE country = 'it' AND province = 'FO'");

  // Update province code for Italy/Pesaro e Urbino.
  $ret[] = update_sql("UPDATE {location} SET province = 'PU' WHERE country = 'it' AND province = 'PS'");

  // Do one final garbage collection by hand.
  $ret[] = update_sql('DELETE FROM {location} WHERE lid NOT IN (SELECT lid FROM {location_instance})');

  // Garbage collect {location_phone} by hand.
  if (db_table_exists('location_phone')) {
    $ret[] = update_sql('DELETE FROM {location_phone} WHERE lid NOT IN (SELECT lid FROM {location})');
  }

  // Garbage collect {location_fax} by hand.
  if (db_table_exists('location_fax')) {
    $ret[] = update_sql('DELETE FROM {location_fax} WHERE lid NOT IN (SELECT lid FROM {location})');
  }
  return $ret;
}