Manual:protected_titles table

From MediaWiki.org
Jump to: navigation, search
Language:Project:Language policy English  • 日本語 • polski
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout protected_titles table


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.

Fields[edit]

pt_namespace[edit]

Namespace

pt_title[edit]

Page title

pt_user[edit]

User id of user who protected the page title

pt_reason[edit]

Protection comment

pt_timestamp[edit]

Timestamp of when the protection action was taken

pt_expiry[edit]

Timestamp of when the protection expires

pt_create_perm[edit]

Protection level

Schema summary[edit]

MediaWiki version: 1.25

DESCRIBE protected_titles;

+----------------+---------------------+------+-----+---------+-------+
| Field          | Type                | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| pt_namespace   | int(11)             | NO   | PRI | NULL    |       | 
| pt_title       | varchar(255) binary | 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   |     | NULL    |       | 
| pt_create_perm | varbinary(60)       | NO   |     | NULL    |       | 
+----------------+---------------------+------+-----+---------+-------+


MediaWiki versions: 1.13 – 1.24

DESCRIBE protected_titles;

+----------------+---------------------+------+-----+---------+-------+
| Field          | Type                | Null | Key | Default | Extra |
+----------------+---------------------+------+-----+---------+-------+
| pt_namespace   | int(11)             | NO   | PRI | NULL    |       | 
| pt_title       | varchar(255) binary | 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   |     | NULL    |       | 
| pt_create_perm | varbinary(60)       | NO   |     | NULL    |       | 
+----------------+---------------------+------+-----+---------+-------+


MediaWiki version: 1.12

DESCRIBE protected_titles;

+----------------+------------------+------+-----+---------+-------+
| Field          | Type             | Null | Key | Default | Extra |
+----------------+------------------+------+-----+---------+-------+
| pt_namespace   | int(11)          | NO   | PRI | NULL    |       | 
| pt_title       | varchar(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   |     | NULL    |       | 
| pt_create_perm | varbinary(60)    | NO   |     | NULL    |       | 
+----------------+------------------+------+-----+---------+-------+
DatabasesManual:Database layout Engines: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technical documentation: SchemaManual:Database layout (tablesCategory:MediaWiki database tables) – API property associationsAPI:Database field and API property associationsField prefixesDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Configuration: SettingsManual:Configuration_settings#Database_settingsSharingManual:Shared database
Development: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpExtension schema updatesManual:Hooks/LoadExtensionSchemaUpdatesPatch fileManual:SQL patch file

Core tables: archivebot_passwordscategorycategorylinkschange_tagconfigexternallinksfilearchivehitcounterimageimagelinksinterwikiiwlinksipblocksjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist