function webform_update_9 in Webform 5

Same name and namespace in other branches

1. 5.2 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 314

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;
}