Manual:ipblocks_old table

This table was added in r15482 .

DESCRIBEipblocks_old;

+-----------------+-----------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+-----------------+------+-----+---------+----------------+
| ipb_id | int(8) | NO | PRI | NULL | auto_increment |
| ipb_address | tinyblob | NO | MUL | NULL | |
| ipb_user | int(8) unsigned | NO | MUL | 0 | |
| ipb_by | int(8) unsigned | NO | | 0 | |
| ipb_reason | tinyblob | NO | | NULL | |
| ipb_timestamp | char(14) | NO | MUL | | |
| ipb_auto | tinyint(1) | NO | | 0 | |
| ipb_expiry | char(14) | NO | MUL | | |
| ipb_range_start | tinyblob | NO | MUL | NULL | |
| ipb_range_end | tinyblob | NO | | NULL | |
+-----------------+-----------------+------+-----+---------+----------------+

SHOWINDEXINipblocks_old;

+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| ipblocks_old | 0 | PRIMARY | 1 | ipb_id | A | 0 | NULL | NULL | | BTREE | | |
| ipblocks_old | 0 | ipb_address_unique | 1 | ipb_address | A | 0 | 255 | NULL | | BTREE | | |
| ipblocks_old | 0 | ipb_address_unique | 2 | ipb_user | A | 0 | NULL | NULL | | BTREE | | |
| ipblocks_old | 0 | ipb_address_unique | 3 | ipb_auto | A | 0 | NULL | NULL | | BTREE | | |
| ipblocks_old | 1 | ipb_user | 1 | ipb_user | A | 0 | NULL | NULL | | BTREE | | |
| ipblocks_old | 1 | ipb_range | 1 | ipb_range_start | A | 0 | 8 | NULL | | BTREE | | |
| ipblocks_old | 1 | ipb_range | 2 | ipb_range_end | A | 0 | 8 | NULL | | BTREE | | |
| ipblocks_old | 1 | ipb_timestamp | 1 | ipb_timestamp | A | 0 | NULL | NULL | | BTREE | | |
| ipblocks_old | 1 | ipb_expiry | 1 | ipb_expiry | A | 0 | NULL | NULL | | BTREE | | |
+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+