Column type mismatch - patr...@belgacom.be - com.mysql.lists.eventum-users

2 messages in com.mysql.lists.eventum-usersColumn type mismatch

From	Sent On	Attachments
patr...@belgacom.be	20 Oct 2004 01:59
Bryan Alsdorf	20 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

**** DISCLAIMER **** "This e-mail and any attachments thereto may contain information which is confidential and/or protected by intellectual property rights and are intended for the sole use of the recipient(s)named above. Any use of the information contained herein (including, but not limited to, total or partial reproduction, communication or distribution in any form) by persons other than the designated recipient(s) is prohibited. If you have received this e-mail in error, please notify the sender either by telephone or by e-mail and delete the material from any computer. Thank you for your cooperation."