Manual:tag_summary table

From MediaWiki.org
Jump to: navigation, search

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


MediaWiki version: 1.15

The tag_summary is used to pull a LIST of tags simply without ugly GROUP_CONCAT. See also the change_tagManual:Change tag table table.


Fields[edit]

ts_id[edit]

MediaWiki version: 1.28

The primary key.

ts_rc_id[edit]

rc_idManual:Recentchanges_table#rc_id for the change.

ts_log_id[edit]

log_idManual:Logging_table#log_id for the change.

ts_rev_id[edit]

rev_idManual:Revision_table#rev_id for the change.

ts_tags[edit]

Comma-separated list of tags.

Schema summary[edit]

MediaWiki version: 1.28

DESCRIBE tag_summary;

+-----------+------------------+------+-----+---------+----------------+
| Field     | Type             | Null | Key | Default | Extra          |
+-----------+------------------+------+-----+---------+----------------+
| ts_id     | int(10) unsigned | NO   | PRI | NULL    | AUTO_INCREMENT |
| ts_rc_id  | int(11)          | YES  | UNI | NULL    |                |
| ts_log_id | int(11)          | YES  | UNI | NULL    |                |
| ts_rev_id | int(11)          | YES  | UNI | NULL    |                |
| ts_tags   | blob             | NO   |     | NULL    |                |
+-----------+------------------+------+-----+---------+----------------+


MediaWiki versions: 1.15 – 1.27

DESCRIBE tag_summary;

+-----------+---------+------+-----+---------+-------+
| Field     | Type    | Null | Key | Default | Extra |
+-----------+---------+------+-----+---------+-------+
| ts_rc_id  | int(11) | YES  | UNI | NULL    |       | 
| ts_log_id | int(11) | YES  | UNI | NULL    |       | 
| ts_rev_id | int(11) | YES  | UNI | NULL    |       | 
| ts_tags   | blob    | 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