Fields

Schema summary

 DESCRIBE bad_behavior;

+------------------+---------------+------+-----+---------+----------------+
| Field            | Type          | Null | Key | Default | Extra          |
+------------------+---------------+------+-----+---------+----------------+
| log_id           | int(11)       | NO   | PRI | NULL    | auto_increment |
| ip               | varchar(45)   | NO   | MUL |         |                |
| host             | varchar(2083) | NO   |     |         |                |
| date             | datetime      | YES  |     | NULL    |                |
| request_method   | varchar(8)    | NO   | MUL |         |                |
| request_uri      | varchar(2083) | NO   |     |         |                |
| request_uri_hash | char(40)      | NO   | MUL |         |                |
| server_protocol  | varchar(12)   | NO   |     |         |                |
| http_headers     | text          | NO   |     | NULL    |                |
| user_agent       | text          | NO   |     | NULL    |                |
| user_agent_hash  | char(40)      | NO   | MUL |         |                |
| request_entity   | text          | NO   |     | NULL    |                |
| status_key       | varchar(10)   | NO   | MUL |         |                |
+------------------+---------------+------+-----+---------+----------------+

Indices

 SHOW INDEX IN bad_behavior;

+------------------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table            | Non_unique | Key_name             | Seq_in_index | Column_name      | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| dev_bad_behavior |          0 | PRIMARY              |            1 | log_id           | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| dev_bad_behavior |          1 | idx_staus_key        |            1 | status_key       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| dev_bad_behavior |          1 | idx_request_uri_hash |            1 | request_uri_hash | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| dev_bad_behavior |          1 | idx_user_agent_hash  |            1 | user_agent_hash  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| dev_bad_behavior |          1 | idx_ip               |            1 | ip               | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| dev_bad_behavior |          1 | idx_request_method   |            1 | request_method   | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+------------------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+