Manual:block table

From mediawiki.org

Translate this page

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.

Primary key.

The block target. Foreign key to block_target.bt_id.

Actor who made the block.

Foreign key to comment.comment_id. Text comment made by blocker.

Creation (or refresh) date in standard YMDHMS form. IP blocks expire automatically.

If set to 1, block applies only to logged-out users and temporary users.

Block prevents account creation from matching IP addresses

Block triggers autoblocks

Time at which the block will expire. May be "infinity"

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)

Block prevents user from accessing Special:Emailuser

Block allows user to edit their own talk page

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.

Block user from editing any page on the site (other than their own user talk page).

DESCRIBEblock;

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

SHOWINDEXINblock;

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

Retrieved from "https://www.mediawiki.org/w/index.php?title=Manual:Block_table&oldid=6974965"

Category:

• MediaWiki database tables