+--------------+------------------+------+-----+--------------------+----------------+
| Field        | Type             | Null | Key | Default            | Extra          |
+--------------+------------------+------+-----+--------------------+----------------+
| sid          | int(10) unsigned | NO   | PRI | NULL               | auto_increment |
| name         | varchar(50)      | YES  |     | Click To Change Me |                |
| hostname     | text             | YES  |     | NULL               |                |
| interface    | text             | YES  |     | NULL               |                |
| filter       | text             | YES  |     | NULL               |                |
| detail       | int(11)          | YES  | MUL | NULL               |                |
| encoding     | int(11)          | YES  | MUL | NULL               |                |
| last_cid     | int(11)          | YES  | MUL | NULL               |                |
| events_count | int(11)          | YES  | MUL | 0                  |                |
+--------------+------------------+------+-----+--------------------+----------------+

Back to Database Schema

Back to Snorby E-Book