Manual:protected_titles table

From mediawiki.org

Translate this page

The protected_titles table contains Protection of non-existent pages. Restrictions on existing pages are stored in the page_restrictions table.

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

Namespace .

Page title .

User id of user who protected the page title.

Protection comment.

(deprecated) pt_reason_id and the comment table should be used instead!

This is a foreign key to comment_id in the comment table.

Timestamp of when the protection action was taken

Timestamp of when the protection expires

Protection level

DESCRIBEprotected_titles;

+----------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| pt_namespace | int(11) | NO | PRI | NULL | |
| pt_title | varbinary(255) | NO | PRI | NULL | |
| pt_user | int(10) unsigned | NO | | NULL | |
| pt_reason_id | bigint(20) unsigned | NO | | NULL | |
| pt_timestamp | binary(14) | NO | MUL | NULL | |
| pt_expiry | varbinary(14) | NO | | NULL | |
| pt_create_perm | varbinary(60) | NO | | NULL | |
+----------------+---------------------+------+-----+---------+-------+

DESCRIBEprotected_titles;

+----------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| pt_namespace | int(11) | NO | PRI | NULL | |
| pt_title | varbinary(255) | NO | PRI | NULL | |
| pt_user | int(10) unsigned | NO | | NULL | |
| pt_reason_id | bigint(20) unsigned | NO | | NULL | |
| pt_timestamp | binary(14) | NO | MUL | NULL | |
| pt_expiry | varbinary(14) | NO | | | |
| pt_create_perm | varbinary(60) | NO | | NULL | |
+----------------+---------------------+------+-----+---------+-------+

DESCRIBEprotected_titles;

+----------------+---------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| pt_namespace | int(11) | NO | PRI | NULL | |
| pt_title | varbinary(255) | NO | PRI | NULL | |
| pt_user | int(10) unsigned | NO | | NULL | |
| pt_reason | varbinary(767) | YES | | | |
| pt_reason_id | bigint(20) unsigned | NO | | 0 | |
| pt_timestamp | binary(14) | NO | MUL | NULL | |
| pt_expiry | varbinary(14) | NO | | | |
| pt_create_perm | varbinary(60) | NO | | NULL | |
+----------------+---------------------+------+-----+---------+-------+

DESCRIBEprotected_titles;

+----------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| pt_namespace | int(11) | NO | PRI | NULL | |
| pt_title | varbinary(255) | NO | PRI | NULL | |
| pt_user | int(10) unsigned | NO | | NULL | |
| pt_reason | varbinary(767) | YES | | NULL | |
| pt_timestamp | binary(14) | NO | MUL | NULL | |
| pt_expiry | varbinary(14) | NO | | | |
| pt_create_perm | varbinary(60) | NO | | NULL | |
+----------------+------------------+------+-----+---------+-------+

DESCRIBEprotected_titles;

+----------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| pt_namespace | int(11) | NO | PRI | NULL | |
| pt_title | varbinary(255) | NO | PRI | NULL | |
| pt_user | int(10) unsigned | NO | | NULL | |
| pt_reason | tinyblob | YES | | NULL | |
| pt_timestamp | binary(14) | NO | MUL | NULL | |
| pt_expiry | varbinary(14) | NO | | | |
| pt_create_perm | varbinary(60) | NO | | NULL | |
+----------------+------------------+------+-----+---------+-------+

SHOWINDEXINprotected_titles;

+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+
| protected_titles | 0 | PRIMARY | 1 | pt_namespace | A | 0 | NULL | NULL | | BTREE | | |
| protected_titles | 0 | PRIMARY | 2 | pt_title | A | 0 | NULL | NULL | | BTREE | | |
| protected_titles | 1 | pt_timestamp | 1 | pt_timestamp | A | 0 | NULL | NULL | | BTREE | | |
+------------------+------------+--------------+--------------+--------------+-----------+-------------+----------+--------+------+------------+---------+---------------+

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

Category:

• MediaWiki database tables