2 messages in com.mysql.lists.eventum-usersColumn type mismatch
FromSent OnAttachments
patr...@belgacom.be20 Oct 2004 01:59 
Bryan Alsdorf20 Oct 2004 07:58 
Subject:Column type mismatch
From:patr...@belgacom.be (patr@belgacom.be)
Date:10/20/2004 01:59:03 AM
List:com.mysql.lists.eventum-users

CREATE TABLE `history_type` ( ... `htt_id` tinyint(2) unsigned NOT NULL auto_increment, ... ) TYPE=MyISAM

Vs.

CREATE TABLE `issue_history` ( ... `his_htt_id` varchar(20) NOT NULL default '', ... ) TYPE=MyISAM

Is there a reason that his_htt_id is a varchar ?

More generally, lot of fields may be tuned (like mail_queue.maq_status with ENUM type, mail_queue.maq_sender_ip_address with INTEGER type using INET_* functions)...

Visit our website: www.belgacom.be