Article Figure 1 Figure 2 Listing 1 Listing 2
Listing 3 Listing 4 Listing 5 Listing 6 Listing 7
Listing 8 sep2006.tar

Listing 6 SQL commands to create a sample capture table

CREATE DATABASE netwacc;
USE netwacc;
CREATE TABLE rawcpature ( 
    tstamp DATETIME NOT NULL, 
    srcip INT UNSIGNED, 
    srcport INT UNSIGNED, 
    dstip INT UNSIGNED, 
    dstport INT UNSIGNED, 
    datalength INT UNSIGNED 
);