DROP TABLE IF EXISTS ticket_old;
DROP TABLE IF EXISTS up_123;
DROP TABLE IF EXISTS ticket_123;

CREATE TABLE up_123 TYPE=HEAP SELECT t.ticket_id as ticket_id, max(th.thread_id) as max_thread_id, min(th.thread_id) as min_thread_id FROM ticket t left join thread th USING (ticket_id) GROUP BY t.ticket_id;

CREATE TABLE ticket_123 SELECT t.ticket_id, t.ticket_subject, t.ticket_date, t.ticket_priority, t.ticket_status, t.last_update_date, t.last_update_user_id, t.ticket_assigned_to_id, t.ticket_queue_id, t.queue_addresses_id, t.ticket_reopenings, u.min_thread_id, u.max_thread_id FROM ticket t, up_123 u WHERE u.ticket_id = t.ticket_id;

ALTER TABLE ticket RENAME ticket_old;
ALTER TABLE ticket_123 RENAME ticket;

DROP TABLE IF EXISTS up_123;

ALTER TABLE `ticket` ADD PRIMARY KEY (`ticket_id`);

ALTER TABLE `ticket` CHANGE `ticket_id` `ticket_id` BIGINT(20) UNSIGNED DEFAULT '0' NOT NULL AUTO_INCREMENT;

ALTER TABLE `ticket` ADD INDEX(`ticket_id`);

ALTER TABLE `ticket` ADD INDEX(`ticket_queue_id`);

ALTER TABLE `ticket` ADD FULLTEXT(`ticket_subject`);

ALTER TABLE `ticket` ADD INDEX (`min_thread_id`);

ALTER TABLE `ticket` ADD INDEX (`max_thread_id`);

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

ALTER TABLE `thread` ADD INDEX(`thread_address_id`);
 
ALTER TABLE `thread_file` ADD INDEX(`thread_id`);

DROP TABLE IF EXISTS `thread_source`;

CREATE TABLE `log` (
`log_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, 
`message` TEXT NOT NULL, 
`log_date` TIMESTAMP NOT NULL,
INDEX (`log_id`)
);