ALTER TABLE `user_prefs` ADD `user_language` CHAR(3) DEFAULT 'en' NOT NULL;
UPDATE `user_prefs` SET `user_language` = "en";

ALTER TABLE `queue` DROP INDEX `queue_name`;
ALTER TABLE `queue` DROP INDEX `queue_address`;

CREATE TABLE ticket_audit_log (
  audit_id bigint(20) NOT NULL auto_increment,
  ticket_id bigint(20) NOT NULL default '0',
  epoch bigint(20) NOT NULL default '0',
  timestamp datetime NOT NULL default '0000-00-00 00:00:00',
  user_id bigint(20) NOT NULL default '0',
  action int(11) NOT NULL default '0',
  action_value char(128) NOT NULL default '',
  PRIMARY KEY  (audit_id)
) TYPE=MyISAM;


ALTER TABLE `user_prefs` ADD `signature_pos` TINYINT(1) DEFAULT '0' NOT NULL;