CREATE TABLE firewallb (idauto int(11) unsigned NOT NULL AUTO_INCREMENT,dt datetime DEFAULT NULL,dtstr varchar(20) DEFAULT NULL,timeSeconds int(11) DEFAULT NULL,priority varchar(20) DEFAULT NULL,operation varchar(20) DEFAULT NULL,messageCode varchar(50) DEFAULT NULL,protocol varchar(10) DEFAULT NULL,srcIp varchar(20) DEFAULT NULL,destIp varchar(20) DEFAULT NULL,srcIPNumber bigint(20) DEFAULT NULL,destIPNumber bigint(20) DEFAULT NULL,srcPort int(11) DEFAULT NULL,destPort int(11) DEFAULT NULL,destService varchar(20) DEFAULT NULL,direction varchar(20) DEFAULT NULL,flags varchar(20) DEFAULT NULL,command varchar(20) DEFAULT NULL,slot1min int(11) DEFAULT NULL,slot5min int(11) DEFAULT NULL,slot30min int(11) DEFAULT NULL,slot60min int(11) DEFAULT NULL,
PRIMARY KEY (idauto),
KEY fw_index_srcip (srcIp),
KEY fw_index_destip (destIp),
KEY fw_index_srcport (srcPort),
KEY fw_index_destport (destPort),
KEY fw_index_srcipnumber (srcIPNumber),
KEY fw_index_destipnumber (destIPNumber),
KEY fw_index_priority (priority),
KEY fw_index_dt (dt),
KEY fw_index_timeseconds (timeSeconds),
KEY fw_index_oper (operation),
KEY fw_index_slot5min (slot5min),
KEY fw_index_slot30min (slot30min),
KEY fw_index_slot1min (slot1min),
KEY fw_index_slot60min (slot60min)
) ENGINE=MyISAM AUTO_INCREMENT=16600932 DEFAULT CHARSET=utf8;
数据类型修改下就可以了。