function webform_update_9 in Webform 5.2

Same name and namespace in other branches

1. 5 webform.install \webform_update_9()
2. 6.2 webform.install \webform_update_9()

Remove webform version variable, now obsolete with schema and version numbers. Split columns for email_from into email_from_address and email_from_name

File

./webform.install, line 365

Code

function webform_update_9() {
  variable_del('webform_version');
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'pgsql':
      db_change_column($ret, 'webform', 'email_from', 'email_from_address', 'varchar(255)', array(
        'not null' => FALSE,
        'default' => 'NULL',
      ));
      $ret[] = update_sql('ALTER TABLE {webform} ADD email_from_name varchar(255) NULL DEFAULT NULL');
      break;
    case 'mysqli':
    case 'mysql':
      $ret[] = update_sql('ALTER TABLE {webform} CHANGE email_from email_from_address varchar(255) NULL DEFAULT NULL');
      $ret[] = update_sql('ALTER TABLE {webform} ADD email_from_name varchar(255) NULL DEFAULT NULL AFTER email');
      break;
  }
  return $ret;
}