MySQL Server Syntax to create the table for Packet Logging

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

create table packets (
   ts timestamp,
   filterid smallint  NOT NULL,
   proto tinyint,
   src_ip char(16),
   src_port smallint unsigned,
   dst_ip char(16),
   dst_port smallint unsigned,
   sent int unsigned, recv int unsigned);

To create the table for Packet Logging with additional fields:

create table packets (
   ts timestamp,
   filterid smallint NOT NULL,
   filtername char(30),
   proto tinyint,
   tos tinyint,
   src_ip char(16),
   src_mac char(16),
   src_port smallint unsigned,
   dst_ip char(16),
   dst_mac char(16),
   dst_port smallint unsigned,
   sent int unsigned, recv int unsigned);

 Note
 
MySQL Server must automatically insert the current date and time in the table with new record. Therefore, you should use the field with "timestamp" type.