add SQLITE3 support (ported from ulogd-1.02 patch by Ben La Monica)

1 files changed, 22 insertions, 0 deletions

diff --git a/ulogd/doc/sqlite3.table b/ulogd/doc/sqlite3.table
new file mode 100644
index 0000000..7b5e99a
--- /dev/null
+++ b/ulogd/doc/sqlite3.table
@@ -0,0 +1,22 @@
+CREATE TABLE ulog (
+			raw_mac		VARCHAR(80),
+			oob_time_sec	INT UNSIGNED,
+			oob_time_usec	INT UNSIGNED,
+			ip_saddr	INT UNSIGNED,
+			ip_daddr	INT UNSIGNED,
+			ip_protocol	TINYINT UNSIGNED,
+			ip_totlen       SMALLINT UNSIGNED,
+			tcp_sport	SMALLINT UNSIGNED,
+			tcp_dport	SMALLINT UNSIGNED,
+			udp_sport	SMALLINT UNSIGNED,
+			udp_dport	SMALLINT UNSIGNED,
+			udp_len		SMALLINT UNSIGNED,
+			icmp_type	TINYINT UNSIGNED,
+			icmp_code	TINYINT UNSIGNED,
+			icmp_echoid	SMALLINT UNSIGNED,
+			icmp_echoseq	SMALLINT UNSIGNED,
+			icmp_gateway	INT UNSIGNED,
+			icmp_fragmtu	SMALLINT UNSIGNED
+		);
+
+