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