MediaWiki version:
|
≥
1.42
|
The
block
table stores details about block actions of accounts and IP addresses.
The block table and
block_target
replaced the former
ip_blocks
table.
Fields
[
edit
]
bl_id
[
edit
]
Primary key.
bl_target
[
edit
]
The block target.
Foreign key to block_target.bt_id.
bl_by_actor
[
edit
]
Actor who made the block.
bl_reason_id
[
edit
]
Key to comment_id.
Text comment made by blocker.
bl_timestamp
[
edit
]
Creation (or refresh) date in standard YMDHMS form.
IP blocks expire automatically.
bl_anon_only
[
edit
]
If set to 1, block applies only to logged-out users and temporary users.
bl_create_account
[
edit
]
Block prevents account creation from matching IP addresses
bl_enable_autoblock
[
edit
]
Block triggers autoblocks
bl_expiry
[
edit
]
Time at which the block will expire.
May be "infinity"
bl_deleted
[
edit
]
If
true
, this block causes the username to be hidden, and the expiry must be infinite.
This is denormalized into rev_deleted and the other deleted bitfields. (T346716)
bl_block_email
[
edit
]
Block prevents user from accessing Special:Emailuser
bl_allow_usertalk
[
edit
]
Block allows user to edit their own talk page
bl_parent_block_id
[
edit
]
ID of the block that caused this block to exist.
Autoblocks set this to the original block so that the original block being deleted also deletes the autoblocks.
bl_sitewide
[
edit
]
Block user from editing any page on the site (other than their own user talk page).
Schema summary
[
edit
]
MediaWiki version:
|
≥
1.42
|
DESCRIBE
block
;
+---------------------+---------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+---------------------+---------------------+------+-----+---------+----------------+
| bl_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| bl_target | int(10) unsigned | NO | MUL | NULL | |
| bl_by_actor | bigint(20) unsigned | NO | | NULL | |
| bl_reason_id | bigint(20) unsigned | NO | | NULL | |
| bl_timestamp | binary(14) | NO | MUL | NULL | |
| bl_anon_only | tinyint(1) | NO | | 0 | |
| bl_create_account | tinyint(1) | NO | | 1 | |
| bl_enable_autoblock | tinyint(1) | NO | | 1 | |
| bl_expiry | varbinary(14) | NO | MUL | NULL | |
| bl_deleted | tinyint(1) | NO | | 0 | |
| bl_block_email | tinyint(1) | NO | | 0 | |
| bl_allow_usertalk | tinyint(1) | NO | | 0 | |
| bl_parent_block_id | int(10) unsigned | YES | MUL | NULL | |
| bl_sitewide | tinyint(1) | NO | | 1 | |
+---------------------+---------------------+------+-----+---------+----------------+
Indexes
[
edit
]
MediaWiki version:
|
≥
1.42
|
SHOW
INDEX
IN
block
;
+-------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| block | 0 | PRIMARY | 1 | bl_id | A | 0 | NULL | NULL | | BTREE | | |
| block | 1 | bl_timestamp | 1 | bl_timestamp | A | 0 | NULL | NULL | | BTREE | | |
| block | 1 | bl_target | 1 | bl_target | A | 0 | NULL | NULL | | BTREE | | |
| block | 1 | bl_expiry | 1 | bl_expiry | A | 0 | NULL | NULL | | BTREE | | |
| block | 1 | bl_parent_block_id | 1 | bl_parent_block_id | A | 0 | NULL | NULL | YES | BTREE | | |
+-------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
|
---|
Engines
| |
---|
Technical documentation
| |
---|
Configuration
| |
---|
Development
| |
---|
Core tables
| |
---|