ALTER TABLE `queue` ADD `queue_core_update` TINYINT DEFAULT '0' NOT NULL;

CREATE TABLE whos_online (
  user_id bigint(20) unsigned NOT NULL auto_increment,
  user_ip char(20) NOT NULL default '',
  user_timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  user_what_action int(11) NOT NULL default '0',
  user_what_arg1 char(64) NOT NULL default '',
  PRIMARY KEY  (user_id)
) TYPE=MyISAM;

ALTER TABLE `user_access_levels` ADD `is_core_default` TINYINT DEFAULT '0' NOT NULL AFTER `group_name`;

ALTER TABLE `user_access_levels`
  DROP `user_create`,
  DROP `user_edit`,
  DROP `user_delete`,
  DROP `queue_create`,
  DROP `queue_edit`,
  DROP `queue_delete`,
  DROP `kb_article_create`,
  DROP `kb_article_edit`,
  DROP `kb_article_delete`,
  DROP `kb_category_create`,
  DROP `kb_category_edit`,
  DROP `kb_category_delete`,
  DROP `upload_logo`,
  DROP `maint_purge_dead`,
  DROP `email_block_senders`,
  DROP `email_download_addresses`,
  DROP `options_upload_key`,
  DROP `options_report_bug`,
  DROP `options_give_feedback`,
  DROP `ticket_change_status`,
  DROP `ticket_change_owner`,
  DROP `ticket_change_queue`,
  DROP `ticket_change_priority`,
  DROP `ticket_change_subject`,
  DROP `ticket_take`,
  DROP `change_preferences`,
  DROP `kb_view`,
  DROP `kb_search`,
  DROP `can_configure`,
  DROP `hide_requestor_emails`;

ALTER TABLE `user_access_levels` ADD `group_acl` CHAR(20) DEFAULT '0' NOT NULL;
ALTER TABLE `user_access_levels` ADD `group_acl2` CHAR(20) DEFAULT '0' NOT NULL;
ALTER TABLE `user_access_levels` ADD `group_acl3` CHAR(20) DEFAULT '0' NOT NULL; 

ALTER TABLE `ticket_views` ADD `view_hide_statuses` CHAR(255) NOT NULL;

UPDATE `ticket_views` SET `view_hide_statuses`='resolved,dead';