TMeter :: Table for Traffic Logging

Database table for Traffic Logging

To write traffic counters in a database, you must create a table with the minimal set of fields:

N	Field name	Field type	Description
1.	filterid	smallint	Filter id (from 1 to N. In general, N is a number of filters in the filterset)
2.	ts	int	The beginning of the time interval in the ymmddhhmi format. For example, 308220945 points to 09:45 August 22, 2003
3.	sent	bigint	Sent bytes counter
4.	recv	bigint	Received bytes counter

You can use the following script to create the table in Microsoft SQL Server:

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

The same script works on MySQL database:

CREATE TABLE traffic (
   filterid smallint NOT NULL,

   ts int,
   sent bigint, recv bigint)

The next figure shows the table for Microsoft Access: