Database: logs
+----------+
|  Tables  |
+----------+
| data     |
| detail   |
| encoding |
| event    |
| icmphdr  |
| iphdr    |
| opt      |
| sensor   |
| tcphdr   |
| udphdr   |
+----------+
Database: logs  Table: data  Rows: 12
+--------------+------------------+------+-----+---------+-------+
| Field        | Type             | Null | Key | Default | Extra |
+--------------+------------------+------+-----+---------+-------+
| sid          | int(10) unsigned |      | PRI | 0       |       |
| cid          | int(10) unsigned |      | PRI | 0       |       |
| data_payload | text             | YES  |     |         |       |
+--------------+------------------+------+-----+---------+-------+
Database: logs  Table: detail  Rows: 2
+-------------+---------------------+------+-----+---------+-------+
| Field       | Type                | Null | Key | Default | Extra |
+-------------+---------------------+------+-----+---------+-------+
| detail_type | tinyint(3) unsigned |      | PRI | 0       |       |
| detail_text | text                |      |     |         |       |
+-------------+---------------------+------+-----+---------+-------+
Database: logs  Table: encoding  Rows: 3
+---------------+---------------------+------+-----+---------+-------+
| Field         | Type                | Null | Key | Default | Extra |
+---------------+---------------------+------+-----+---------+-------+
| encoding_type | tinyint(3) unsigned |      | PRI | 0       |       |
| encoding_text | text                |      |     |         |       |
+---------------+---------------------+------+-----+---------+-------+
Database: logs  Table: event  Rows: 77
+-----------+------------------+------+-----+---------------------+-------+
| Field     | Type             | Null | Key | Default             | Extra |
+-----------+------------------+------+-----+---------------------+-------+
| sid       | int(10) unsigned |      | PRI | 0                   |       |
| cid       | int(10) unsigned |      | PRI | 0                   |       |
| signature | varchar(255)     |      | MUL |                     |       |
| timestamp | datetime         |      | MUL | 0000-00-00 00:00:00 |       |
+-----------+------------------+------+-----+---------------------+-------+
Database: logs  Table: icmphdr  Rows: 11
+-----------+----------------------+------+-----+---------+-------+
| Field     | Type                 | Null | Key | Default | Extra |
+-----------+----------------------+------+-----+---------+-------+
| sid       | int(10) unsigned     |      | PRI | 0       |       |
| cid       | int(10) unsigned     |      | PRI | 0       |       |
| icmp_type | tinyint(3) unsigned  |      | MUL | 0       |       |
| icmp_code | tinyint(3) unsigned  |      |     | 0       |       |
| icmp_csum | smallint(5) unsigned | YES  |     |         |       |
| icmp_id   | smallint(5) unsigned | YES  |     |         |       |
| icmp_seq  | smallint(5) unsigned | YES  |     |         |       |
+-----------+----------------------+------+-----+---------+-------+
Database: logs  Table: iphdr  Rows: 77
+----------+----------------------+------+-----+---------+-------+
| Field    | Type                 | Null | Key | Default | Extra |
+----------+----------------------+------+-----+---------+-------+
| sid      | int(10) unsigned     |      | PRI | 0       |       |
| cid      | int(10) unsigned     |      | PRI | 0       |       |
| ip_src   | int(10) unsigned     |      | MUL | 0       |       |
| ip_src0  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_src1  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_src2  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_src3  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_dst   | int(10) unsigned     |      | MUL | 0       |       |
| ip_dst0  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_dst1  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_dst2  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_dst3  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_ver   | tinyint(3) unsigned  | YES  |     |         |       |
| ip_hlen  | tinyint(3) unsigned  | YES  |     |         |       |
| ip_tos   | tinyint(3) unsigned  | YES  |     |         |       |
| ip_len   | smallint(5) unsigned | YES  |     |         |       |
| ip_id    | smallint(5) unsigned | YES  |     |         |       |
| ip_flags | tinyint(3) unsigned  | YES  |     |         |       |
| ip_off   | smallint(5) unsigned | YES  |     |         |       |
| ip_ttl   | tinyint(3) unsigned  | YES  |     |         |       |
| ip_proto | tinyint(3) unsigned  |      |     | 0       |       |
| ip_csum  | smallint(5) unsigned | YES  |     |         |       |
+----------+----------------------+------+-----+---------+-------+
Database: logs  Table: opt  Rows: 460
+-----------+---------------------+------+-----+---------+-------+
| Field     | Type                | Null | Key | Default | Extra |
+-----------+---------------------+------+-----+---------+-------+
| sid       | int(10) unsigned    |      | PRI | 0       |       |
| cid       | int(10) unsigned    |      | PRI | 0       |       |
| optid     | int(10) unsigned    |      | PRI | 0       |       |
| opt_proto | tinyint(3) unsigned |      |     | 0       |       |
| opt_code  | tinyint(3) unsigned |      |     | 0       |       |
| opt_len   | smallint(6)         | YES  |     |         |       |
| opt_data  | text                | YES  |     |         |       |
+-----------+---------------------+------+-----+---------+-------+
Database: logs  Table: sensor  Rows: 4
+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| sid       | int(10) unsigned |      | PRI | 0       | auto_increment |
| hostname  | text             | YES  |     |         |                |
| interface | text             | YES  |     |         |                |
| filter    | text             | YES  |     |         |                |
| detail    | tinyint(4)       | YES  |     |         |                |
| encoding  | tinyint(4)       | YES  |     |         |                |
+-----------+------------------+------+-----+---------+----------------+
Database: logs  Table: tcphdr  Rows: 63
+-----------+----------------------+------+-----+---------+-------+
| Field     | Type                 | Null | Key | Default | Extra |
+-----------+----------------------+------+-----+---------+-------+
| sid       | int(10) unsigned     |      | PRI | 0       |       |
| cid       | int(10) unsigned     |      | PRI | 0       |       |
| tcp_sport | smallint(5) unsigned |      | MUL | 0       |       |
| tcp_dport | smallint(5) unsigned |      | MUL | 0       |       |
| tcp_seq   | int(10) unsigned     | YES  |     |         |       |
| tcp_ack   | int(10) unsigned     | YES  |     |         |       |
| tcp_off   | tinyint(3) unsigned  | YES  |     |         |       |
| tcp_res   | tinyint(3) unsigned  | YES  |     |         |       |
| tcp_flags | tinyint(3) unsigned  |      | MUL | 0       |       |
| tcp_win   | smallint(5) unsigned | YES  |     |         |       |
| tcp_csum  | smallint(5) unsigned | YES  |     |         |       |
| tcp_urp   | smallint(5) unsigned | YES  |     |         |       |
+-----------+----------------------+------+-----+---------+-------+
Database: logs  Table: udphdr  Rows: 3
+-----------+----------------------+------+-----+---------+-------+
| Field     | Type                 | Null | Key | Default | Extra |
+-----------+----------------------+------+-----+---------+-------+
| sid       | int(10) unsigned     |      | PRI | 0       |       |
| cid       | int(10) unsigned     |      | PRI | 0       |       |
| udp_sport | smallint(5) unsigned |      | MUL | 0       |       |
| udp_dport | smallint(5) unsigned |      | MUL | 0       |       |
| udp_len   | smallint(5) unsigned | YES  |     |         |       |
| udp_csum  | smallint(5) unsigned | YES  |     |         |       |
+-----------+----------------------+------+-----+---------+-------+