Manual:page_restrictions table

From mediawiki.org

Translate this page

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.

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

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

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

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.

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

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

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.

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

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

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

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

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

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

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

Category:

• MediaWiki database tables