function system_update_143 in Drupal 4

Same name and namespace in other branches

1. 5 modules/system/system.install \system_update_143()

File

database/updates.inc, line 631

Code

function system_update_143() {
  $ret = array();
  if ($GLOBALS['db_type'] == 'mysql') {
    $ret[] = update_sql("ALTER TABLE {contact} CHANGE subject category VARCHAR(255) NOT NULL ");
    $ret[] = update_sql("ALTER TABLE {contact} ADD PRIMARY KEY (category)");
  }
  elseif ($GLOBALS['db_type'] == 'pgsql') {

    // Why the table is created here? See update_133().
    $ret[] = update_sql("CREATE TABLE {contact} (\n      category varchar(255) NOT NULL default '',\n      recipients text NOT NULL default '',\n      reply text NOT NULL default '',\n      PRIMARY KEY (category))");
  }
  return $ret;
}