Manual:Block target table

Manual:Contents MediaWiki database layout block_target table

The targets of blocks

Fields

bt_id

Primary key.

bt_address

Blocked IP address or range in dotted-quad form, or null for a user block. If bt_auto is 1 then the address is private.

bt_user

Blocked user ID or null for IP blocks.

bt_user_text

The name of the blocked user, or null for IP blocks. For Special:BlockList sorting. (T48013)

bt_auto

Indicates that the IP address was banned because a banned user accessed a page through it. If this is 1, ipb_address will be hidden, and the block identified by block ID number.

bt_range_start

Start of an address range, in hexadecimal. Null for single-IP and user blocks.

bt_range_end

End of an address range, in hexadecimal. Null for single-IP and user blocks.

bt_ip_hex

If the block is for a single IP, this is the IP address in hexadecimal. If the block is for a range, the start of the range in hexadecimal, identical to bt_range_start.

bt_count

The number of block rows associated with this target.

Schema summary

MediaWiki version:
1.42

DESCRIBE block_target;

+----------------+------------------+------+-----+---------+----------------+
| Field          | Type             | Null | Key | Default | Extra          |
+----------------+------------------+------+-----+---------+----------------+
| bt_id          | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| bt_address     | tinyblob         | YES  | MUL | NULL    |                |
| bt_user        | int(10) unsigned | YES  | MUL | NULL    |                |
| bt_user_text   | varbinary(255)   | YES  |     | NULL    |                |
| bt_auto        | tinyint(1)       | NO   |     | 0       |                |
| bt_range_start | tinyblob         | YES  | MUL | NULL    |                |
| bt_range_end   | tinyblob         | YES  |     | NULL    |                |
| bt_ip_hex      | tinyblob         | YES  | MUL | NULL    |                |
| bt_count       | int(11)          | NO   |     | 0       |                |
+----------------+------------------+------+-----+---------+----------------+

Indexes

MediaWiki version:
1.42

SHOW INDEX IN block_target;

+--------------+------------+-----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table        | Non_unique | Key_name        | Seq_in_index | Column_name    | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+--------------+------------+-----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| block_target |          0 | PRIMARY         |            1 | bt_id          | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| block_target |          1 | bt_address      |            1 | bt_address     | A         |           0 |       42 | NULL   | YES  | BTREE      |         |               |
| block_target |          1 | bt_ip_user_text |            1 | bt_ip_hex      | A         |           0 |       35 | NULL   | YES  | BTREE      |         |               |
| block_target |          1 | bt_ip_user_text |            2 | bt_user_text   | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
| block_target |          1 | bt_range        |            1 | bt_range_start | A         |           0 |       35 | NULL   | YES  | BTREE      |         |               |
| block_target |          1 | bt_range        |            2 | bt_range_end   | A         |           0 |       35 | NULL   | YES  | BTREE      |         |               |
| block_target |          1 | bt_user         |            1 | bt_user        | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
+--------------+------------+-----------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+