Extension:GlobalBlocking/globalblocks table

From mediawiki.org

The globalblocks table stores global blocks that have not expired. These blocks can target IP addresses, IP ranges, and accounts.

This table is stored on a central DB. Since 1.43, updates to it are applied via update.php . For versions before 1.43, you need to apply the updates manually.

Primary key

The target of the block. An IP address, IP range, or account.

The central ID for the target of the block. 0 if the target is an IP address or IP range.

The username of the performer of the global block.

The central ID for the performer of the global block.

The wiki where the block was performed, used to provide a link to the performer of the block on another wiki.

The reason for the global block, provided by the performer of the block.

The timestamp the block was applied.

Whether the global block only targets anon users

Whether the global block prevents account creation.

Whether the global block triggers global autoblocks.

If null, then this is not an autoblock. If an integer, then this is an autoblock and the integer is the gb_id for the global block that caused this autoblock. This value is set for autoblocks to allow deleting the autoblock when the parent block is deleted.

The expiry timestamp for the block. Blocks can have an infinite expiry.

The first IP address in hexadecimal form for the range of IPs that is targeted by this block. For a block that targets a single IP this will be the same as gb_address but in hexadecimal form.

The last IP address in hexadecimal form for the range of IPs that is targeted by this block. For a block that targets a single IP this will be the same as gb_address but in hexadecimal form.

DESCRIBEglobalblocks;

+------------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------------+------------------+------+-----+---------+----------------+
| gb_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| gb_address | varbinary(255) | NO | MUL | NULL | |
| gb_by_central_id | int(10) unsigned | NO | | NULL | |
| gb_by_wiki | varbinary(255) | NO | | NULL | |
| gb_reason | varbinary(767) | NO | | NULL | |
| gb_timestamp | binary(14) | NO | MUL | NULL | |
| gb_anon_only | tinyint(1) | NO | | 0 | |
| gb_expiry | varbinary(14) | NO | MUL | NULL | |
| gb_range_start | varbinary(35) | NO | MUL | NULL | |
| gb_range_end | varbinary(35) | NO | | NULL | |
| gb_target_central_id | int(10) unsigned | NO | MUL | 0 | |
| gb_create_account | tinyint(1) | NO | | 1 | |
| gb_enable_autoblock | tinyint(1) | NO | | 1 | |
| gb_autoblock_parent_id | int(10) unsigned | YES | MUL | NULL | |
+------------------------+------------------+------+-----+---------+----------------+

DESCRIBEglobalblocks;

+----------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+----------------+
| gb_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| gb_address | varbinary(255) | NO | MUL | NULL | |
| gb_by | varbinary(255) | NO | | | |
| gb_by_central_id | int(10) unsigned | NO | | NULL | |
| gb_by_wiki | varbinary(255) | NO | | NULL | |
| gb_reason | varbinary(767) | NO | | NULL | |
| gb_timestamp | binary(14) | NO | MUL | NULL | |
| gb_anon_only | tinyint(1) | NO | | 0 | |
| gb_expiry | varbinary(14) | NO | MUL | NULL | |
| gb_range_start | varbinary(35) | NO | MUL | NULL | |
| gb_range_end | varbinary(35) | NO | | NULL | |
| gb_target_central_id | int(10) unsigned | NO | MUL | 0 | |
+----------------------+------------------+------+-----+---------+----------------+

DESCRIBEglobalblocks;

+----------------------+------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+----------------------+------------------+------+-----+---------+----------------+
| gb_id | int(10) unsigned | NO | PRI | NULL | auto_increment |
| gb_address | varbinary(255) | NO | MUL | NULL | |
| gb_by | varbinary(255) | NO | | | |
| gb_by_central_id | int(10) unsigned | NO | | NULL | |
| gb_by_wiki | varbinary(255) | NO | | NULL | |
| gb_reason | varbinary(767) | NO | | NULL | |
| gb_timestamp | binary(14) | NO | MUL | NULL | |
| gb_anon_only | tinyint(1) | NO | | 0 | |
| gb_expiry | varbinary(14) | NO | MUL | NULL | |
| gb_range_start | varbinary(35) | NO | MUL | NULL | |
| gb_range_end | varbinary(35) | NO | | NULL | |
| gb_target_central_id | int(10) unsigned | NO | MUL | 0 | |
+----------------------+------------------+------+-----+---------+----------------+

SHOWINDEXINglobalblocks;

+--------------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+--------------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| globalblocks | 0 | PRIMARY | 1 | gb_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 0 | gb_address | 1 | gb_address | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 0 | gb_address | 2 | gb_anon_only | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_range | 1 | gb_range_start | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_range | 2 | gb_range_end | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_timestamp | 1 | gb_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_expiry | 1 | gb_expiry | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_target_central_id | 1 | gb_target_central_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_autoblock_parent_id | 1 | gb_autoblock_parent_id | A | 0 | NULL | NULL | YES | BTREE | | | NO |
+--------------+------------+------------------------+--------------+------------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

SHOWINDEXINglobalblocks;

+--------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+--------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| globalblocks | 0 | PRIMARY | 1 | gb_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 0 | gb_address | 1 | gb_address | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 0 | gb_address | 2 | gb_anon_only | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_range | 1 | gb_range_start | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_range | 2 | gb_range_end | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_timestamp | 1 | gb_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_expiry | 1 | gb_expiry | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_target_central_id | 1 | gb_target_central_id | A | 0 | NULL | NULL | | BTREE | | | NO |
+--------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

SHOWINDEXINglobalblocks;

+--------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+--------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| globalblocks | 0 | PRIMARY | 1 | gb_id | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 0 | gb_address | 1 | gb_address | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 0 | gb_address | 2 | gb_anon_only | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_range | 1 | gb_range_start | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_range | 2 | gb_range_end | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_timestamp | 1 | gb_timestamp | A | 0 | NULL | NULL | | BTREE | | | NO |
| globalblocks | 1 | gb_expiry | 1 | gb_expiry | A | 0 | NULL | NULL | | BTREE | | | NO |
+--------------+------------+----------------------+--------------+----------------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+

Retrieved from "https://www.mediawiki.org/w/index.php?title=Extension:GlobalBlocking/globalblocks_table&oldid=6768871"

Category:

• Wikimedia extension database tables