function guestbook_update_1 in Guestbook 5

File

./guestbook.install, line 52

Code

function guestbook_update_1() {
  $ret = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
      $ret[] = update_sql('ALTER TABLE {guestbook} ADD COLUMN anonemail varchar(128)');
      $ret[] = update_sql('ALTER TABLE {guestbook} ADD COLUMN anonwebsite varchar(128)');
      $ret[] = update_sql('ALTER TABLE {guestbook} ADD COLUMN commentauthor int(10) unsigned');
      $ret[] = update_sql('ALTER TABLE {guestbook} MODIFY COLUMN anonname varchar(64)');
      $query = db_query("SELECT max(id) as id FROM {guestbook}");
      $row = db_fetch_object($query);
      $ret[] = update_sql("INSERT INTO {sequences} SET name = 'guestbook_id', id = '{$row->id}'");
      break;
    case 'pgsql':
      break;
  }
  return $ret;
}