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 | | |
+------------------+------------+----------------------+--------------+------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+