]> git.ipfire.org Git - ipfire-3.x.git/blob - config/ulogd2/sqlite3.table
Added some nice ulogd config.
[ipfire-3.x.git] / config / ulogd2 / sqlite3.table
1 CREATE TABLE ulog (
2 raw_mac VARCHAR(80),
3 oob_time_sec INT UNSIGNED,
4 oob_time_usec INT UNSIGNED,
5 ip_saddr INT UNSIGNED,
6 ip_daddr INT UNSIGNED,
7 ip_protocol TINYINT UNSIGNED,
8 ip_totlen SMALLINT UNSIGNED,
9 tcp_sport SMALLINT UNSIGNED,
10 tcp_dport SMALLINT UNSIGNED,
11 udp_sport SMALLINT UNSIGNED,
12 udp_dport SMALLINT UNSIGNED,
13 udp_len SMALLINT UNSIGNED,
14 icmp_type TINYINT UNSIGNED,
15 icmp_code TINYINT UNSIGNED,
16 icmp_echoid SMALLINT UNSIGNED,
17 icmp_echoseq SMALLINT UNSIGNED,
18 icmp_gateway INT UNSIGNED,
19 icmp_fragmtu SMALLINT UNSIGNED
20 );
21