Microsoft SQL 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 [dbo].[hosts] (
   ts datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
   rtime datetime,
   filterid smallint NOT NULL,
   rtype smallint,
   method smallint,
   reason smallint,
   clt_ip char(16),
   clt_port int,
   srv_ip char(16),
   srv_port int,
   clt_bytes bigint,
   srv_bytes bigint,
   host char(250))

 Note

• Field "ts" points to a time when the record was created. Microsoft SQL Server must automatically insert the current date and time in the table with new record. Therefore, you should use CURRENT_TIMESTAMP function for this purpose as the default value for the field "ts".