MySQL Server Syntax to create the table for Host Header Logging

To create the table for Packet Logging with a minimal set of fields:

create table hosts (
   rtime datetime CURRENT_TIMESTAMP,
   filterid smallint NOT NULL,
   rtype smallint,
   method smallint,
   reason smallint,
   clt_ip char(16),
   clt_port smallint unsigned,
   srv_ip char(16),
   srv_port smallint unsigned,
   clt_bytes int unsigned, 
   srv_bytes int unsigned,
   host char(100));