Manual:ipblocks_old table

From mediawiki.org
Other languages:
Manual:Contents MediaWiki database layout ipblocks_old table
MediaWiki version:
1.8

This table was added in r15482.

Schema summary[edit]

MediaWiki version:
1.8

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

Indexes[edit]

MediaWiki version:
1.8

SHOW INDEX IN ipblocks_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      |         |               |
+--------------+------------+--------------------+--------------+-----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+