function location_update_5309 in Location 5.3

Fix #42901. The primary key on zipcodes is ill-advised.

File

./location.install, line 840

Installation / uninstallation routines.

Code

function location_update_5309() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql('ALTER TABLE {zipcodes} DROP PRIMARY KEY');
      break;
    case 'pgsql':
      $ret[] = update_sql('ALTER TABLE {zipcodes} DROP CONSTRAINT {zipcodes}_pkey');
      break;
  }
  return $ret;
}