Fwlog2sql/fwlog2sql.sql

CREATE table hit (
        hash            varchar(32),
        ID              INT,
        TS              TIMESTAMP,
        hostname        varchar(255),
        PROTO           varchar(8),
        TOS             varchar(8),
        CH              varchar(8),
        RULE            varchar(8),
        PREC            varchar(8),
        DST             varchar(15),
        SRC             varchar(15),
        SPT             varchar(8),
        DPT             varchar(8),
        INTERFACE       varchar(8),
        MACADDR         varchar(48),
        INDEX           index_hash (hash(32)),
        INDEX           index_scr_dst_dpt ( SRC , DST , DPT ),
        INDEX           index_src (SRC),
        INDEX           index_dst (DST),
        INDEX           index_dpt (DPT),
        INDEX           index_spt (SPT)
)