Manual:protected_titles table

↑ Manual:Contents

MediaWiki database layout

protected_titles table

The protected_titles table contains protection of non-existent pages, the list of protected pages can be found at Special:Protectedtitles.

Fields

pt_namespace

Namespace

pt_title

Page title

pt_user

User id of user who protected the page title

pt_reason

Protection comment

pt_timestamp

Timestamp of when the protection action was taken

pt_expiry

Timestamp of when the protection expires

pt_create_perm

Protection level

Versions

MediaWiki versions:

1.19 – 1.20

mysql> describe protected_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    |       |
+----------------+------------------+------+-----+---------+-------+

DESCRIBE protected_titles; in version 1.18 gives the following:

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

MediaWiki version:

1.12

DESCRIBE protected_titles; in version 1.12 gives the following:

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

Databases

Engines: MySQL – Oracle – PostgreSQL – SQLite Technical documentation: Schema (tables) – API property associations – Field prefixes – Primary key storage in other fields – Wikimedia extension tables Configuration: Settings – Sharing Development: Access – Optimization – Policy – Updater – Extension schema updates – Patch file Core tables: archive – category – categorylinks – change_tag – config – externallinks – filearchive – hitcounter – image – imagelinks – interwiki – iwlinks – ipblocks – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – searchindex – sites – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – valid_tag – watchlist