function shoutbox_update_5200 in Shoutbox 6.2

Same name and namespace in other branches

1. 5 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 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 70

Shoutbox module install file.

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