Manual:change_tag table

From MediaWiki.org
Jump to: navigation, search

Other languages:
English • ‎español • ‎日本語
Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout change_tag table


MediaWiki version: 1.15

The change_tag table tracks tags for revisions, logs and recent changes. See also the tag_summaryManual:tag_summary table and valid_tagManual:valid_tag table tables.

Fields[edit]

ct_id[edit]

MediaWiki version: 1.28

The primary key.

ct_rc_id[edit]

rc_idManual:Recentchanges_table#rc_id for the change.

ct_log_id[edit]

log_idManual:Logging_table#log_id for the change.

ct_rev_id[edit]

rev_idManual:Revision_table#rev_id for the change. Note that this will not be unique: for each tag applied to a change, a distinct row is added.

ct_tag[edit]

String corresponding to one tag applied to the change.

ct_params[edit]

Parameters for the tag. Example: gerrit:139881 in Extension:ContentTranslationExtension:ContentTranslation.

Schema summary[edit]

MediaWiki version: 1.28

DESCRIBE change_tag;

+-----------+------------------+------+---------+---------+----------------+
| Field     | Type             | Null | Key     | Default | Extra          |
+-----------+------------------+------+---------+---------+----------------+
| ct_id     | int(10) unsigned | NO   | UNI/PRI | NULL    | AUTO_INCREMENT |
| ct_rc_id  | int(11)          | YES  | MUL     | NULL    |                |
| ct_log_id | int(11)          | YES  | MUL     | NULL    |                |
| ct_rev_id | int(11)          | YES  | MUL     | NULL    |                |
| ct_tag    | varbinary(255)   | NO   | MUL     | NULL    |                |
| ct_params | blob             | YES  |         | NULL    |                |
+-----------+------------------+------+---------+---------+----------------+
MediaWiki versions: 1.15 – 1.27

DESCRIBE change_tag;

+-----------+----------------+------+-----+---------+-------+
| Field     | Type           | Null | Key | Default | Extra |
+-----------+----------------+------+-----+---------+-------+
| ct_rc_id  | int(11)        | YES  | MUL | NULL    |       |
| ct_log_id | int(11)        | YES  | MUL | NULL    |       |
| ct_rev_id | int(11)        | YES  | MUL | NULL    |       |
| ct_tag    | varbinary(255) | NO   | MUL | NULL    |       |
| ct_params | blob           | YES  |     | 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