CREATE TABLE user_prefs (
  user_id int(11) default NULL,
  assigned_filter tinyint(4) default NULL,
  assigned_results tinyint(4) default NULL,
  unassigned_filter tinyint(4) default NULL,
  unassigned_results tinyint(4) default NULL,
  refresh_rate tinyint(4) default NULL,
  ticket_order tinyint(4) default NULL	
) TYPE=MyISAM;

ALTER TABLE `user_access_levels` ADD `hide_requestor_emails` TINYINT NOT NULL;

DROP TABLE IF EXISTS address_profile;  
  
CREATE TABLE `address_fields` (  
`field_id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,   
`field_name` CHAR(32) NOT NULL,   
`field_type` ENUM('S','T','D') NOT NULL,   
`field_options` TEXT NOT NULL  
);   
  
CREATE TABLE `address_values` (  
  `value_id` BIGINT NOT NULL AUTO_INCREMENT PRIMARY KEY,  
  `field_id` BIGINT NOT NULL default '0',  
  `address_id` BIGINT NOT NULL default '0',  
  `value_text` text NOT NULL  
);

ALTER TABLE `ticket` CHANGE `ticket_status` `ticket_status` ENUM('new','open','upstream','responded','in progress','info needed','acceptance','on hold','escalated','fixed','resolved','reopened','dead') DEFAULT 'new' NOT NULL;

UPDATE `ticket` SET `ticket_status` = "on hold" WHERE `ticket_status` = "upstream";
UPDATE `ticket` SET `ticket_status` = "in progress" WHERE `ticket_status` = "open";

ALTER TABLE `ticket` CHANGE `ticket_status` `ticket_status` ENUM('new','responded','in progress','info needed','acceptance','on hold','escalated','fixed','resolved','reopened','dead') DEFAULT 'new' NOT NULL;

ALTER TABLE `ticket` ADD `ticket_reopenings` SMALLINT DEFAULT '0' NOT NULL;