From 7181f929279bea55c8554a86b5cdec9d0c09a7cc Mon Sep 17 00:00:00 2001
From: laforge <laforge>
Date: Mon, 20 Nov 2000 11:43:22 +0000
Subject: huge reorganization for 0.9 - added hashtables everywhere - no more
 dynamic allocation for each packet - mysql output plugin - more keys in
 ulogd_BASE - moved libipulog into ulogd directory - introduced autoconf

---
 doc/mysql.table | 55 +++++++++++++++++++++++++++++++++++++++++++++++++++++++
 1 file changed, 55 insertions(+)
 create mode 100644 doc/mysql.table

(limited to 'doc/mysql.table')

diff --git a/doc/mysql.table b/doc/mysql.table
new file mode 100644
index 0000000..bdfee71
--- /dev/null
+++ b/doc/mysql.table
@@ -0,0 +1,55 @@
+CREATE TABLE ulog (	id		INT UNSIGNED AUTO_INCREMENT UNIQUE,
+
+			raw_mac		VARCHAR(80),
+
+			oob_time_sec	INT UNSIGNED,
+			oob_time_usec	INT UNSIGNED,
+			oob_prefix	VARCHAR(32),
+			oob_mark	INT UNSIGNED,
+			oob_in		VARCHAR(32),
+			oob_out		VARCHAR(32),
+
+			ip_saddr	INT UNSIGNED,
+			ip_daddr	INT UNSIGNED,
+			ip_protocol	TINYINT UNSIGNED,
+			ip_tos		TINYINT UNSIGNED,
+			ip_ttl		TINYINT UNSIGNED,
+			ip_totlen	SMALLINT UNSIGNED,
+			ip_ihl		TINYINT UNSIGNED,
+			ip_csum		SMALLINT UNSIGNED,
+			ip_id		SMALLINT UNSIGNED,
+			ip_fragoff	SMALLINT UNSIGNED,
+
+			tcp_sport	SMALLINT UNSIGNED,
+			tcp_dport	SMALLINT UNSIGNED,
+			tcp_seq		INT UNSIGNED,
+			tcp_ackseq	INT UNSIGNED,
+			tcp_window	SMALLINT UNSIGNED,
+			tcp_urg		TINYINT,
+			tcp_urgp	SMALLINT UNSIGNED,
+			tcp_ack		TINYINT,
+			tcp_psh		TINYINT,
+			tcp_rst		TINYINT,
+			tcp_syn		TINYINT,
+			tcp_fin		TINYINT,
+
+			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,
+			
+			pwsniff_user	VARCHAR(30),
+			pwsniff_pass	VARCHAR(30),
+			
+			ahesp_spi	INT UNSIGNED,			
+
+			KEY index_id	(id)
+		);
+
+			
-- 
cgit v1.2.3