Manual:block table
↑ Manual:Contents | MediaWiki database layout | block table |
Blocks against user accounts, IP addresses and IP ranges.
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 | | | +-------+------------+--------------------+--------------+--------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+