function path_redirect_update_5100 in Path redirect 5

Same name and namespace in other branches

1. 6 path_redirect.install \path_redirect_update_5100()

Backporting schema for successful upgrades to 6.x.

File

./path_redirect.install, line 153

Install and uninstall schema and functions for the path_redirect module.

Code

function path_redirect_update_5100() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql("ALTER TABLE {path_redirect} MODIFY rid int NOT NULL auto_increment");
      $ret[] = update_sql("ALTER TABLE {path_redirect} MODIFY query varchar(255)");
      $ret[] = update_sql("ALTER TABLE {path_redirect} MODIFY fragment varchar(50)");
      $ret[] = update_sql("ALTER TABLE {path_redirect} MODIFY type smallint NOT NULL");
      break;
    case 'pgsql':
      db_change_column($ret, 'path_redirect', 'query', 'query', 'varchar(255)');
      db_change_column($ret, 'path_redirect', 'fragment', 'fragment', 'varchar(50)');
      db_change_column($ret, 'path_redirect', 'type', 'type', 'smallint', array(
        'not null' => TRUE,
      ));
      break;
  }
  return $ret;
}