#------------------[ 1.5.1rc1 SQL Update ]------------------------------
ALTER TABLE `configuration` DROP `cerberus_gui_path` ;
ALTER TABLE `configuration` DROP `http_server` ;
ALTER TABLE `user` ADD `user_disabled` TINYINT DEFAULT '0' NOT NULL ;
ALTER TABLE `queue_addresses` ADD UNIQUE `address_unique` ( `queue_address` , `queue_domain` );
#------------------[ 1.5.1rc2 SQL Update ]------------------------------
DROP TABLE IF EXISTS thread_source;
ALTER TABLE `requestor` ADD `suppress` TINYINT DEFAULT '0' NOT NULL ;
ALTER TABLE `configuration` DROP `mail_delay`;
ALTER TABLE `requestor` DROP `requestor_id`;
ALTER  TABLE  `requestor`  ADD  UNIQUE `ticket_and_address` (  `ticket_id` ,  `address_id`  );
CREATE TABLE `thread_errors` (
 `error_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `ticket_id` BIGINT UNSIGNED NOT NULL ,
 `thread_id` BIGINT UNSIGNED NOT NULL ,
 `error_msg` TEXT NOT NULL ,
 PRIMARY KEY ( `error_id` ), 
 INDEX (`ticket_id`),
 INDEX (`thread_id`)
);

DROP TABLE IF EXISTS ticket_old;

CREATE TABLE `war_check` (
 `warcheck_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `address_id` BIGINT UNSIGNED NOT NULL ,
 `subject_md5` CHAR( 32 ) NOT NULL ,
 `queue_id` BIGINT UNSIGNED NOT NULL ,
 `timestamp` DATETIME NOT NULL ,
 PRIMARY KEY (`warcheck_id`),
 INDEX(`address_id`),
 INDEX(`queue_id`),
 INDEX(`subject_md5`)
);

CREATE TABLE `thread_attachments` (
 `thread_id` BIGINT UNSIGNED NOT NULL ,
 `file_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `file_name` CHAR( 255 ) NOT NULL ,
 `file_size` BIGINT( 11 ) NOT NULL ,
 PRIMARY KEY ( `file_id` ) 
);

ALTER TABLE `thread_attachments` ADD INDEX ( `thread_id` );

CREATE TABLE `thread_attachments_parts` (
 `part_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `file_id` BIGINT UNSIGNED NOT NULL ,
 `part_content` MEDIUMBLOB NOT NULL ,
 PRIMARY KEY ( `part_id` ) ,
 INDEX ( `file_id` ) 
);

ALTER TABLE `product_key_info` DROP `key_name` ;
ALTER TABLE `product_key_info` DROP `key_email` ;
ALTER TABLE `product_key_info` DROP `key_issue` ;
ALTER TABLE `product_key_info` ADD `key_type` TINYINT NOT NULL ;
ALTER TABLE `product_key_info` ADD `key_expiration` DATETIME NOT NULL ;

ALTER TABLE `configuration` ADD `warcheck_secs` INT DEFAULT '10' NOT NULL AFTER `track_sid_url` ;
ALTER TABLE `configuration` ADD `ob_callback` CHAR( 64 ) NOT NULL AFTER `master_db_user` ;

#---------------[ 2.0.0 beta rc0 ]-----------------------------------
ALTER TABLE `configuration` DROP `list_tickets_per_page` ;
ALTER TABLE `user_prefs` DROP `assigned_filter`;
ALTER TABLE `user_prefs` DROP `assigned_results`;
ALTER TABLE `user_prefs` DROP `unassigned_filter`;
ALTER TABLE `user_prefs` DROP `unassigned_results` ;
ALTER TABLE `ticket_views` CHANGE `view_columns` `view_columns` TEXT NOT NULL;
ALTER TABLE `ticket_views` ADD `view_only_assigned` TINYINT( 0 ) NOT NULL ;

#---------------[ 2.0.0 release ]-----------------------------------
CREATE TABLE `merge_forward` (
	`from_ticket` BIGINT UNSIGNED NOT NULL,
	`to_ticket` BIGINT UNSIGNED NOT NULL,
	UNIQUE `merge_pair` (`from_ticket`,`to_ticket`)
);
CREATE TABLE `search_index_exclude` (
 `exclude_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
 `exclude_word` CHAR( 25 ) NOT NULL ,
 PRIMARY KEY ( `exclude_id` ) ,
 UNIQUE (
 `exclude_word` 
)
);

INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('to'),('is'),('if'),('of'),('or'),('it'),('in'),('do'),('no'),('on'),('id'),('by'),('be'),('us');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('the'),('you'),('for'),('any'),('not'),('and'),('llc'),('inc'),('key'),('has'),('let'),('new'),('can'),('was'),('are'),('get');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('this'),('have'),('name'),('from'),('that'),('your'),('been'),('know'),('need'),('with'),('mail'),('will');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('email'),('please'),('company'),('questions'),('message'),('reply'),('domain'),('thanks'),('contact'),('information'),('address'),('internet'),('phone'),('number'),('support');
INSERT IGNORE INTO `search_index_exclude` (exclude_word) VALUES ('there'),('might'),('but'),('means'),('our'),('upon'),('all'),('when'),('while'),('among'),('thank'),('now'),('would'),('could'),('like'),('just'),('may'),('use'),('again');