summaryrefslogtreecommitdiffstats
path: root/doc/sqlite3.table
diff options
context:
space:
mode:
Diffstat (limited to 'doc/sqlite3.table')
-rw-r--r--doc/sqlite3.table22
1 files changed, 22 insertions, 0 deletions
diff --git a/doc/sqlite3.table b/doc/sqlite3.table
new file mode 100644
index 0000000..7b5e99a
--- /dev/null
+++ b/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
+ );
+
+