+--------------+------------------+------+-----+---------------------+----------------+
| Field        | Type             | Null | Key | Default             | Extra          |
+--------------+------------------+------+-----+---------------------+----------------+
| accesslog_id | int(10) unsigned |      | PRI | NULL                | auto_increment |
| host         | varchar(255)     |      |     |                     |                |
| user         | varchar(255)     | YES  | MUL | NULL                |                |
| accessdate   | datetime         |      | MUL | 0000-00-00 00:00:00 |                |
| rtype        | varchar(10)      |      |     |                     |                |
| file         | varchar(255)     |      | MUL |                     |                |
| querystring  | text             | YES  |     | NULL                |                |
| proto        | varchar(8)       |      |     |                     |                |
| code         | int(10) unsigned |      | MUL | 0                   |                |
| bytes        | int(10) unsigned |      |     | 0                   |                |
| refer        | varchar(255)     | YES  |     | NULL                |                |
| agent        | varchar(255)     | YES  | MUL | NULL                |                |
| provider     | int(10) unsigned | YES  | MUL | NULL                |                |
| id           | varchar(255)     | YES  | MUL | NULL                |                |
| int_time     | int(11)          | YES  | MUL | NULL                |                |
+--------------+------------------+------+-----+---------------------+----------------+