summaryrefslogtreecommitdiffstats
path: root/ulogd/doc/mysql.table
diff options
context:
space:
mode:
authorlaforge <laforge>2000-11-20 11:43:22 +0000
committerlaforge <laforge>2000-11-20 11:43:22 +0000
commitc7d5ddfadc507d1cc9811229f938abe8c8004c0d (patch)
tree12125bd631ef4162c4e5eddce2e2c9929c6c5b9f /ulogd/doc/mysql.table
parent58ee76c3d9db7c2b12f8b504415917afdd6abec0 (diff)
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
Diffstat (limited to 'ulogd/doc/mysql.table')
-rw-r--r--ulogd/doc/mysql.table55
1 files changed, 55 insertions, 0 deletions
diff --git a/ulogd/doc/mysql.table b/ulogd/doc/mysql.table
new file mode 100644
index 0000000..bdfee71
--- /dev/null
+++ b/ulogd/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)
+ );
+
+