function shoutbox_update_5200 in Shoutbox 5

Same name and namespace in other branches

1. 6.2 shoutbox.install \shoutbox_update_5200()
2. 6 shoutbox.install \shoutbox_update_5200()
3. 7.2 shoutbox.install \shoutbox_update_5200()
4. 7 shoutbox.install \shoutbox_update_5200()

Update hook. This update prepares the database for for shoutbox 5.2.x Removes the moderation table Drops the status column on the shoutbox table Adds sid column to the shoutbox table

File

./shoutbox.install, line 53

Code

function shoutbox_update_5200() {
  $items = array();
  switch ($GLOBALS['db_type']) {
    case 'mysql':
    case 'mysqli':
    case 'pgsql':
      $items[] = update_sql("DROP TABLE {shoutbox_moderation}");
      $items[] = update_sql("ALTER TABLE {shoutbox} DROP status");
      $items[] = update_sql("ALTER TABLE {shoutbox} ADD COLUMN sid varchar(64) NOT NULL default ''");
      break;
    default:
      break;
  }
  return $items;
}