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;
数据类型修改下就可以了。