Manual:Primary key storage in other fields

From MediaWiki.org
Jump to: navigation, search

Other languages:
English • ‎español • ‎italiano • ‎日本語 • ‎polski • ‎português • ‎português do Brasil

This is a page to track primary key storage in other fields in the core and in extensions used on WMF wikis. Only auto-incrementing numerical keys should be mentioned here. log_search.ls_value is not included here, but it can contain any number of primary keys.

Usage[edit]

Core[edit]

Primary key Storage elsewhere
archive.ar_id N/A
category.cat_id N/A
externallinks.el_id N/A
filearchive.fa_id N/A
ipblocks.ipb_id ipblocks.ipb_parent_block_id
job.job_id N/A
logging.log_id change_tag.ct_log_id
log_search.ls_log_id
recentchanges.rc_logid
tag_summary.ts_log_id
page.page_id archive.ar_page_id
categorylinks.cl_from
externallinks.el_from
hitcounter.hc_id (until MediaWiki 1.24)
imagelinks.il_from
iwlinks.iwl_from
langlinks.ll_from
logging.log_page
pagelinks.pl_from
page_props.pp_page
page_restrictions.pr_page
recentchanges.rc_cur_id
redirect.rd_from
revision.rev_page
searchindex.si_page
templatelinks.tl_from
page_restrictions.pr_id N/A
recentchanges.rc_id change_tag.ct_rc_id
tag_summary.ts_rc_id
revision.rev_id archive.ar_rev_id
archive.ar_parent_id
change_tag.ct_rev_id
page.page_latest
recentchanges.rc_this_oldid
recentchanges.rc_last_oldid
revision.rev_parent_id
tag_summary.ts_rev_id
sites.site_id N/A
site_stats.ss_row_id N/A
text.old_id archive.ar_text_id
revision.rev_text_id
user.user_id archive.ar_user
filearchive.fa_deleted_user
filearchive.fa_user
image.img_user
ipblocks.ipb_user
ipblocks.ipb_by
logging.log_user
oldimage.oi_user
protected_titles.pt_user
recentchanges.rc_user
revision.rev_user
uploadstash.us_user
user_former_groups.ufg_user
user_groups.ug_user
user_newtalk.user_id
user_properties.up_user
watchlist.wl_user

Extensions used on Wikimedia wikis[edit]

Primary key Storage elsewhere
archive.ar_id N/A
category.cat_id N/A
externallinks.el_id N/A
filearchive.fa_id N/A
ipblocks.ipb_id N/A
job.job_id N/A
logging.log_id abuse_filter_log.afl_log_idExtension:AbuseFilter/abuse_filter_log_table#afl_log_id
page.page_id titlekey.tk_pageExtension:TitleKey/titlekey table#tk_page
page_restrictions.pr_id N/A
recentchanges.rc_id N/A
revision.rev_id abuse_filter_log.afl_rev_idExtension:AbuseFilter/abuse_filter_log_table#afl_rev_id
sites.site_id N/A
site_stats.ss_row_id N/A
text.old_id N/A
user.user_id abuse_filter.af_userExtension:AbuseFilter/abuse_filter_table#af_user
abuse_filter_history.afh_userExtension:AbuseFilter/abuse_filter_history_table#afh_user
abuse_filter_log.afl_userExtension:AbuseFilter/abuse_filter_log_table#afl_user
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