summaryrefslogtreecommitdiffstats
path: root/doc/sqlite3.table
blob: 393b386e6cd60caf0167ee335f5f3307ca2129fe (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
CREATE TABLE ulog_ct (
			flow_start_sec		INT UNSIGNED,
			flow_start_usec		INT UNSIGNED,
			flow_end_sec		INT UNSIGNED,
			flow_end_usec		INT UNSIGNED,
			orig_ip_saddr		INT UNSIGNED,
			orig_ip_daddr		INT UNSIGNED,
			orig_l4_sport		SMALLINT UNSIGNED,
			orig_l4_dport		SMALLINT UNSIGNED,
			orig_ip_protocol	TINYINT UNSIGNED,
			icmp_type		TINYINT UNSIGNED,
			icmp_code		TINYINT UNSIGNED,
			orig_raw_pktlen		INT UNSIGNED,
			orig_raw_pktcount	INT UNSIGNED,
			reply_raw_pktlen	INT UNSIGNED,
			reply_raw_pktcount	INT UNSIGNED,
			ct_mark			INT UNSIGNED
		);
CREATE TABLE ulog_pkt (
			raw_pktlen		INT UNSIGNED,
			raw_pktcount		INT UNSIGNED,
			oob_prefix		VARCHAR(64),
			oob_time_sec		INT UNSIGNED,
			oob_time_usec		INT UNSIGNED,
			oob_mark		INT UNSIGNED,
			oob_hook		TINYINT UNSIGNED,
			oob_uid			INT UNSIGNED,
			oob_gid			INT UNSIGNED
		);