Manual:page_restrictions table

MediaWiki database layout

page_restrictions table

MediaWiki version:

≥ 1.10

The page_restrictions table is used to store page protection levels in MediaWiki 1.10 and later. The most notable feature is the introduction of cascading page protections for high-visibility pages. This table is for restrictions on existing pages only. Protections of non-existent pages are stored in the protected_titles table.

This table was introduced in MediaWiki 1.10 (r19095–r19703), and overrides the page_restrictions field in the page table.

The list of protected pages can be found at Special:ProtectedPages.

Fields

pr_id

This is the primary key for the table, and is used to identify a particular row in the table.

pr_page

This field contains a reference to page_id , which works as the foreign key for this table.

pr_type

The type of protection (whether it applies to edits, page moves, or similar) is stored in this field.

pr_level

This column describes the level of protection for the page; full protection for sysop-only pages, semi-protection for autoconfirmed users, or any other levels.

pr_cascade

This field determines whether cascading protection (meaning that all transcluded pages and files on the page will be protected as well).

pr_user

MediaWiki version:

≤ 1.37

This field was reserved to support a future per-user edit restriction system, but was never used as partial blocks were implemented as blocks.

pr_expiry

This field contains the timestamp for pages whose protection has a set expiration date, and has a format similar to the expiry time in the Ipblocks table. Rows that contain a null value in this column are considered to be protected indefinitely.

Schema summary

MediaWiki version:

≥ 1.38

DESCRIBE page_restrictions;

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| pr_id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| pr_page    | int(10) unsigned | NO   | MUL | NULL    |                |
| pr_type    | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_level   | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_cascade | tinyint(4)       | NO   | MUL | NULL    |                |
| pr_expiry  | varbinary(14)    | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

MediaWiki versions:

1.30 – 1.37

DESCRIBE page_restrictions;

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| pr_id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| pr_page    | int(11)          | NO   | MUL | NULL    |                |
| pr_type    | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_level   | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_cascade | tinyint(4)       | NO   | MUL | NULL    |                |
| pr_user    | int(10) unsigned | YES  |     | NULL    |                |
| pr_expiry  | varbinary(14)    | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

MediaWiki versions:

1.23 – 1.29

DESCRIBE page_restrictions;

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| pr_id      | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| pr_page    | int(11)          | NO   | MUL | NULL    |                |
| pr_type    | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_level   | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_cascade | tinyint(4)       | NO   | MUL | NULL    |                |
| pr_user    | int(11)          | YES  |     | NULL    |                |
| pr_expiry  | varbinary(14)    | YES  |     | NULL    |                |
+------------+------------------+------+-----+---------+----------------+

MediaWiki versions:

1.15 – 1.22

DESCRIBE page_restrictions;

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| pr_page    | int(8)           | NO   | MUL | NULL    |                |
| pr_type    | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_level   | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_cascade | tinyint(4)       | NO   | MUL | NULL    |                |
| pr_user    | int(8)           | YES  |     | NULL    |                |
| pr_expiry  | varbinary(14)    | YES  |     | NULL    |                |
| pr_id      | int(10) unsigned | NO   | PRI | NULL    | AUTO_INCREMENT |
+------------+------------------+------+-----+---------+----------------+

MediaWiki versions:

1.10 – 1.14

DESCRIBE page_restrictions;

+------------+------------------+------+-----+---------+----------------+
| Field      | Type             | Null | Key | Default | Extra          |
+------------+------------------+------+-----+---------+----------------+
| pr_page    | int(8)           | NO   | PRI | NULL    |                |
| pr_type    | varbinary(60)    | NO   | PRI | NULL    |                |
| pr_level   | varbinary(60)    | NO   | MUL | NULL    |                |
| pr_cascade | tinyint(4)       | NO   | MUL | NULL    |                |
| pr_user    | int(8)           | YES  |     | NULL    |                |
| pr_expiry  | varbinary(14)    | YES  |     | NULL    |                |
| pr_id      | int(10) unsigned | NO   | UNI | NULL    | AUTO_INCREMENT |
+------------+------------------+------+-----+---------+----------------+

Indexes

MediaWiki version:

≥ 1.15

SHOW INDEX IN page_restrictions;

+-------------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table             | Non_unique | Key_name     | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+-------------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| page_restrictions |          0 | PRIMARY      |            1 | pr_id       | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| page_restrictions |          0 | pr_pagetype  |            1 | pr_page     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| page_restrictions |          0 | pr_pagetype  |            2 | pr_type     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| page_restrictions |          1 | pr_typelevel |            1 | pr_type     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| page_restrictions |          1 | pr_typelevel |            2 | pr_level    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| page_restrictions |          1 | pr_level     |            1 | pr_level    | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
| page_restrictions |          1 | pr_cascade   |            1 | pr_cascade  | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
+-------------------+------------+--------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+