CREATE TABLE [dbo].[traffic] (
   filterid smallint NOT NULL,
   ts int,
   sent bigint, recv bigint)

GO

CREATE TABLE [dbo].[packets] (
   ts datetime DEFAULT CURRENT_TIMESTAMP NOT NULL,
   filterid smallint NOT NULL,
   proto smallint,
   src_ip char(16),
   src_port int,
   dst_ip char(16),
   dst_port int,
   sent int, recv int)

GO

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))

GO

CREATE TABLE [dbo].[filters] (
   filterid int PRIMARY KEY,
   filtername char(120) NOT NULL)

GO