CINXE.COM

<!DOCTYPE html> <html class="client-nojs vector-feature-language-in-header-disabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref--excluded vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-disabled skin-theme-clientpref-day vector-toc-available" lang="en" dir="ltr"> <head> <meta charset="UTF-8"> <title>Manual:logging table - MediaWiki</title> <script>(function(){var className="client-js vector-feature-language-in-header-disabled vector-feature-language-in-main-page-header-disabled vector-feature-sticky-header-disabled vector-feature-page-tools-pinned-disabled vector-feature-toc-pinned-clientpref-1 vector-feature-main-menu-pinned-disabled vector-feature-limited-width-clientpref-1 vector-feature-limited-width-content-enabled vector-feature-custom-font-size-clientpref--excluded vector-feature-appearance-pinned-clientpref-1 vector-feature-night-mode-disabled skin-theme-clientpref-day vector-toc-available";var cookie=document.cookie.match(/(?:^|; )mediawikiwikimwclientpreferences=([^;]+)/);if(cookie){cookie[1].split('%2C').forEach(function(pref){className=className.replace(new RegExp('(^| )'+pref.replace(/-clientpref-\w+$|[^\w-]+/g,'')+'-clientpref-\\w+( |$)'),'$1'+pref+'$2');});}document.documentElement.className=className;}());RLCONF={"wgBreakFrames":false,"wgSeparatorTransformTable":["",""],"wgDigitTransformTable":["",""], "wgDefaultDateFormat":"dmy","wgMonthNames":["","January","February","March","April","May","June","July","August","September","October","November","December"],"wgRequestId":"04e698d5-3b17-44a6-827c-ad6c64fc7df6","wgCanonicalNamespace":"Manual","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":100,"wgPageName":"Manual:Logging_table","wgTitle":"Logging table","wgCurRevisionId":6656377,"wgRevisionId":6656377,"wgArticleId":10497,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["MediaWiki database tables","Log"],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Manual:Logging_table","wgRelevantArticleId":10497,"wgIsProbablyEditable":true,"wgRelevantPageIsProbablyEditable":true,"wgRestrictionEdit":[],"wgRestrictionMove":[],"wgNoticeProject":"mediawiki","wgCiteReferencePreviewsActive":true,"wgMediaViewerOnClick":true,"wgMediaViewerEnabledByDefault":true, "wgVisualEditor":{"pageLanguageCode":"en","pageLanguageDir":"ltr","pageVariantFallbacks":"en"},"wgMFDisplayWikibaseDescriptions":{"search":true,"watchlist":true,"tagline":false,"nearby":true},"wgWMESchemaEditAttemptStepOversample":false,"wgWMEPageLength":30000,"wgInternalRedirectTargetUrl":"/wiki/Manual:Logging_table","wgTranslatePageTranslation":"source","wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"personal","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q22803917","wgCheckUserClientHintsHeadersJsApi":["brands","architecture","bitness","fullVersionList","mobile","model","platform","platformVersion"]};RLSTATE={"ext.globalCssJs.user.styles":"ready","site.styles":"ready","user.styles":"ready","ext.globalCssJs.user":"ready","user":"ready","user.options":"loading","ext.translate.tag.languages":"ready","ext.pygments":"ready","skins.vector.search.codex.styles":"ready", "skins.vector.styles":"ready","skins.vector.icons":"ready","jquery.makeCollapsible.styles":"ready","ext.translate.edit.documentation.styles":"ready","ext.translate":"ready","ext.wikimediamessages.styles":"ready","ext.visualEditor.desktopArticleTarget.noscript":"ready","ext.uls.pt":"ready","wikibase.client.init":"ready","ext.wikimediaBadges":"ready"};RLPAGEMODULES=["mediawiki.action.view.redirect","ext.pygments.view","site","mediawiki.page.ready","jquery.makeCollapsible","mediawiki.toc","skins.vector.js","ext.centralNotice.geoIP","ext.centralNotice.startUp","ext.translate.pagetranslation.uls","ext.urlShortener.toolbar","ext.centralauth.centralautologin","ext.visualEditor.desktopArticleTarget.init","ext.visualEditor.targetLoader","ext.echo.centralauth","ext.eventLogging","ext.wikimediaEvents","ext.navigationTiming","ext.uls.compactlinks","ext.uls.interface","wikibase.client.vector-2022","ext.checkUser.clientHints","wikibase.sidebar.tracking"];</script> <script>(RLQ=window.RLQ||[]).push(function(){mw.loader.impl(function(){return["user.options@12s5i",function($,jQuery,require,module){mw.user.tokens.set({"patrolToken":"+\\","watchToken":"+\\","csrfToken":"+\\"}); }];});});</script> <link rel="stylesheet" href="/w/load.php?lang=en&modules=ext.pygments%2Ctranslate%2CwikimediaBadges%7Cext.translate.edit.documentation.styles%7Cext.translate.tag.languages%7Cext.uls.pt%7Cext.visualEditor.desktopArticleTarget.noscript%7Cext.wikimediamessages.styles%7Cjquery.makeCollapsible.styles%7Cskins.vector.icons%2Cstyles%7Cskins.vector.search.codex.styles%7Cwikibase.client.init&only=styles&skin=vector-2022"> <script async="" src="/w/load.php?lang=en&modules=startup&only=scripts&raw=1&skin=vector-2022"></script> <meta name="ResourceLoaderDynamicStyles" content=""> <link rel="stylesheet" href="/w/load.php?lang=en&modules=site.styles&only=styles&skin=vector-2022"> <meta name="generator" content="MediaWiki 1.44.0-wmf.5"> <meta name="referrer" content="origin"> <meta name="referrer" content="origin-when-cross-origin"> <meta name="robots" content="max-image-preview:standard"> <meta name="format-detection" content="telephone=no"> <meta name="viewport" content="width=1120"> <meta property="og:site_name" content="MediaWiki"> <meta property="og:title" content="Manual:logging table - MediaWiki"> <meta property="og:type" content="website"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//m.mediawiki.org/wiki/Manual:Logging_table"> <link rel="alternate" type="application/x-wiki" title="Edit" href="/w/index.php?title=Manual:Logging_table&action=edit"> <link rel="apple-touch-icon" href="/static/apple-touch/mediawiki.png"> <link rel="icon" href="/static/favicon/mediawiki.ico"> <link rel="search" type="application/opensearchdescription+xml" href="/w/rest.php/v1/search" title="MediaWiki (en)"> <link rel="EditURI" type="application/rsd+xml" href="//www.mediawiki.org/w/api.php?action=rsd"> <link rel="canonical" href="https://www.mediawiki.org/wiki/Manual:Logging_table"> <link rel="license" href="https://creativecommons.org/licenses/by-sa/4.0/"> <link rel="alternate" type="application/atom+xml" title="MediaWiki Atom feed" href="/w/index.php?title=Special:RecentChanges&feed=atom"> <link rel="dns-prefetch" href="//meta.wikimedia.org" /> <link rel="dns-prefetch" href="//login.wikimedia.org"> </head> <body class="skin--responsive skin-vector skin-vector-search-vue mediawiki ltr sitedir-ltr mw-hide-empty-elt ns-100 ns-subject mw-editable page-Manual_Logging_table rootpage-Manual_Logging_table skin-vector-2022 action-view"><a class="mw-jump-link" href="#bodyContent">Jump to content</a> <div class="vector-header-container"> <header class="vector-header mw-header"> <div class="vector-header-start"> <nav class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-dropdown" class="vector-dropdown vector-main-menu-dropdown vector-button-flush-left vector-button-flush-right" > <input type="checkbox" id="vector-main-menu-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-main-menu-dropdown" class="vector-dropdown-checkbox " aria-label="Main menu" > <label id="vector-main-menu-dropdown-label" for="vector-main-menu-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-menu mw-ui-icon-wikimedia-menu"></span> <span class="vector-dropdown-label-text">Main menu</span> </label> <div class="vector-dropdown-content"> <div id="vector-main-menu-unpinned-container" class="vector-unpinned-container"> <div id="vector-main-menu" class="vector-main-menu vector-pinnable-element"> <div class="vector-pinnable-header vector-main-menu-pinnable-header vector-pinnable-header-unpinned" data-feature-name="main-menu-pinned" data-pinnable-element-id="vector-main-menu" data-pinned-container-id="vector-main-menu-pinned-container" data-unpinned-container-id="vector-main-menu-unpinned-container" > <div class="vector-pinnable-header-label">Main menu</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-main-menu.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-main-menu.unpin">hide</button> </div> <div id="p-navigation" class="vector-menu mw-portlet mw-portlet-navigation" > <div class="vector-menu-heading"> Navigation </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mainpage-description" class="mw-list-item"><a href="/wiki/MediaWiki" title="Visit the main page [z]" accesskey="z"><span>Main page</span></a></li><li id="n-mw-download" class="mw-list-item"><a href="/wiki/Download"><span>Get MediaWiki</span></a></li><li id="n-mw-extensions" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Category:Extensions"><span>Get extensions</span></a></li><li id="n-blog-text" class="mw-list-item"><a href="https://techblog.wikimedia.org/"><span>Tech blog</span></a></li><li id="n-mw-contribute" class="mw-list-item"><a href="/wiki/Special:MyLanguage/How_to_contribute"><span>Contribute</span></a></li> </ul> </div> </div> <div id="p-support" class="vector-menu mw-portlet mw-portlet-support" > <div class="vector-menu-heading"> Support </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-help" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Help:Contents" title="The place to find out"><span>User help</span></a></li><li id="n-mw-faq" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Manual:FAQ"><span>FAQ</span></a></li><li id="n-mw-manual" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Manual:Contents"><span>Technical manual</span></a></li><li id="n-mw-supportdesk" class="mw-list-item"><a href="/wiki/Project:Support_desk"><span>Support desk</span></a></li><li id="n-mw-communication" class="mw-list-item"><a href="/wiki/Special:MyLanguage/Communication"><span>Communication</span></a></li> </ul> </div> </div> <div id="p-development" class="vector-menu mw-portlet mw-portlet-development" > <div class="vector-menu-heading"> Development </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-mw-developerportal" class="mw-list-item"><a href="https://developer.wikimedia.org/"><span>Developer portal</span></a></li><li id="n-svn-statistics" class="mw-list-item"><a href="/wiki/Development_statistics"><span>Code statistics</span></a></li> </ul> </div> </div> <div id="p-mediawiki.org" class="vector-menu mw-portlet mw-portlet-mediawiki_org" > <div class="vector-menu-heading"> mediawiki.org </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="n-portal" class="mw-list-item"><a href="/wiki/Project:Help" title="About the project, what you can do, where to find things"><span>Community portal</span></a></li><li id="n-recentchanges" class="mw-list-item"><a href="/wiki/Special:RecentChanges" title="A list of recent changes in the wiki [r]" accesskey="r"><span>Recent changes</span></a></li><li id="n-mw-translate" class="mw-list-item"><a href="/wiki/Special:LanguageStats"><span>Translate content</span></a></li><li id="n-randompage" class="mw-list-item"><a href="/wiki/Special:Random" title="Load a random page [x]" accesskey="x"><span>Random page</span></a></li><li id="n-mw-discussion" class="mw-list-item"><a href="/wiki/Project:Village_Pump"><span>Village pump</span></a></li><li id="n-Sandboxlink-portlet-label" class="mw-list-item"><a href="/wiki/Project:Sandbox"><span>Sandbox</span></a></li> </ul> </div> </div> <div id="p-lang" class="vector-menu mw-portlet mw-portlet-lang" > <div class="vector-menu-heading"> In other languages </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> <div class="after-portlet after-portlet-lang"><span class="wb-langlinks-add wb-langlinks-link"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q22803917#sitelinks-wikipedia" title="Add interlanguage links" class="wbc-editpage">Add links</a></span></div> </div> </div> </div> </div> </div> </div> </nav> <a href="/wiki/MediaWiki" class="mw-logo"> <img class="mw-logo-icon" src="/static/images/icons/mediawikiwiki.svg" alt="" aria-hidden="true" height="50" width="50"> <span class="mw-logo-container skin-invert"> <img class="mw-logo-wordmark" alt="MediaWiki" src="/static/images/mobile/copyright/mediawikiwiki-wordmark.svg" style="width: 7.5em; height: 1.125em;"> </span> </a> </div> <div class="vector-header-end"> <div id="p-search" role="search" class="vector-search-box-vue vector-search-box-collapses vector-search-box-show-thumbnail vector-search-box-auto-expand-width vector-search-box"> <a href="/wiki/Special:Search" class="cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only search-toggle" title="Search MediaWiki [f]" accesskey="f"><span class="vector-icon mw-ui-icon-search mw-ui-icon-wikimedia-search"></span> <span>Search</span> </a> <div class="vector-typeahead-search-container"> <div class="cdx-typeahead-search cdx-typeahead-search--show-thumbnail cdx-typeahead-search--auto-expand-width"> <form action="/w/index.php" id="searchform" class="cdx-search-input cdx-search-input--has-end-button"> <div id="simpleSearch" class="cdx-search-input__input-wrapper" data-search-loc="header-moved"> <div class="cdx-text-input cdx-text-input--has-start-icon"> <input class="cdx-text-input__input" type="search" name="search" placeholder="Search MediaWiki" aria-label="Search MediaWiki" autocapitalize="sentences" title="Search MediaWiki [f]" accesskey="f" id="searchInput" > <span class="cdx-text-input__icon cdx-text-input__start-icon"></span> </div> <input type="hidden" name="title" value="Special:Search"> </div> <button class="cdx-button cdx-search-input__end-button">Search</button> </form> </div> </div> </div> <nav class="vector-user-links vector-user-links-wide" aria-label="Personal tools"> <div class="vector-user-links-main"> <div id="p-vector-user-menu-preferences" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-uls" class="mw-list-item active user-links-collapsible-item"><a data-mw="interface" href="#" class="uls-trigger cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet"><span class="vector-icon mw-ui-icon-wikimedia-language mw-ui-icon-wikimedia-wikimedia-language"></span> <span>English</span></a> </li> </ul> </div> </div> <div id="p-vector-user-menu-userpage" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-dropdown" class="vector-dropdown " title="Change the appearance of the page's font size, width, and color" > <input type="checkbox" id="vector-appearance-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-appearance-dropdown" class="vector-dropdown-checkbox " aria-label="Appearance" > <label id="vector-appearance-dropdown-label" for="vector-appearance-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-appearance mw-ui-icon-wikimedia-appearance"></span> <span class="vector-dropdown-label-text">Appearance</span> </label> <div class="vector-dropdown-content"> <div id="vector-appearance-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <div id="p-vector-user-menu-notifications" class="vector-menu mw-portlet emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> <div id="p-vector-user-menu-overflow" class="vector-menu mw-portlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=www.mediawiki.org&uselang=en" class=""><span>Donate</span></a> </li> <li id="pt-createaccount-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:CreateAccount&returnto=Manual%3ALogging+table" title="You are encouraged to create an account and log in; however, it is not mandatory" class=""><span>Create account</span></a> </li> <li id="pt-login-2" class="user-links-collapsible-item mw-list-item user-links-collapsible-item"><a data-mw="interface" href="/w/index.php?title=Special:UserLogin&returnto=Manual%3ALogging+table" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o" class=""><span>Log in</span></a> </li> </ul> </div> </div> </div> <div id="vector-user-links-dropdown" class="vector-dropdown vector-user-menu vector-button-flush-right vector-user-menu-logged-out" title="More options" > <input type="checkbox" id="vector-user-links-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-user-links-dropdown" class="vector-dropdown-checkbox " aria-label="Personal tools" > <label id="vector-user-links-dropdown-label" for="vector-user-links-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-ellipsis mw-ui-icon-wikimedia-ellipsis"></span> <span class="vector-dropdown-label-text">Personal tools</span> </label> <div class="vector-dropdown-content"> <div id="p-personal" class="vector-menu mw-portlet mw-portlet-personal user-links-collapsible-item" title="User menu" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-sitesupport" class="user-links-collapsible-item mw-list-item"><a href="https://donate.wikimedia.org/?wmf_source=donate&wmf_medium=sidebar&wmf_campaign=www.mediawiki.org&uselang=en"><span>Donate</span></a></li><li id="pt-createaccount" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:CreateAccount&returnto=Manual%3ALogging+table" title="You are encouraged to create an account and log in; however, it is not mandatory"><span class="vector-icon mw-ui-icon-userAdd mw-ui-icon-wikimedia-userAdd"></span> <span>Create account</span></a></li><li id="pt-login" class="user-links-collapsible-item mw-list-item"><a href="/w/index.php?title=Special:UserLogin&returnto=Manual%3ALogging+table" title="You are encouraged to log in; however, it is not mandatory [o]" accesskey="o"><span class="vector-icon mw-ui-icon-logIn mw-ui-icon-wikimedia-logIn"></span> <span>Log in</span></a></li> </ul> </div> </div> <div id="p-user-menu-anon-editor" class="vector-menu mw-portlet mw-portlet-user-menu-anon-editor" > <div class="vector-menu-heading"> Pages for logged out editors <a href="/wiki/Help:Introduction" aria-label="Learn more about editing"><span>learn more</span></a> </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="pt-anoncontribs" class="mw-list-item"><a href="/wiki/Special:MyContributions" title="A list of edits made from this IP address [y]" accesskey="y"><span>Contributions</span></a></li><li id="pt-anontalk" class="mw-list-item"><a href="/wiki/Special:MyTalk" title="Discussion about edits from this IP address [n]" accesskey="n"><span>Talk</span></a></li> </ul> </div> </div> </div> </div> </nav> </div> </header> </div> <div class="mw-page-container"> <div class="mw-page-container-inner"> <div class="vector-sitenotice-container"> <div id="siteNotice"></div> </div> <div class="vector-column-start"> <div class="vector-main-menu-container"> <div id="mw-navigation"> <nav id="mw-panel" class="vector-main-menu-landmark" aria-label="Site"> <div id="vector-main-menu-pinned-container" class="vector-pinned-container"> </div> </nav> </div> </div> <div class="vector-sticky-pinned-container"> <nav id="mw-panel-toc" aria-label="Contents" data-event-name="ui.sidebar-toc" class="mw-table-of-contents-container vector-toc-landmark"> <div id="vector-toc-pinned-container" class="vector-pinned-container"> <div id="vector-toc" class="vector-toc vector-pinnable-element"> <div class="vector-pinnable-header vector-toc-pinnable-header vector-pinnable-header-pinned" data-feature-name="toc-pinned" data-pinnable-element-id="vector-toc" > <h2 class="vector-pinnable-header-label">Contents</h2> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-toc.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-toc.unpin">hide</button> </div> <ul class="vector-toc-contents" id="mw-panel-toc-list"> <li id="toc-mw-content-text" class="vector-toc-list-item vector-toc-level-1"> <a href="#" class="vector-toc-link"> <div class="vector-toc-text">Beginning</div> </a> </li> <li id="toc-Fields" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Fields"> <div class="vector-toc-text"> <span class="vector-toc-numb">1</span> <span>Fields</span> </div> </a> <button aria-controls="toc-Fields-sublist" class="cdx-button cdx-button--weight-quiet cdx-button--icon-only vector-toc-toggle"> <span class="vector-icon mw-ui-icon-wikimedia-expand"></span> <span>Toggle Fields subsection</span> </button> <ul id="toc-Fields-sublist" class="vector-toc-list"> <li id="toc-log_id" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_id"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.1</span> <span>log_id</span> </div> </a> <ul id="toc-log_id-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_type" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_type"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.2</span> <span>log_type</span> </div> </a> <ul id="toc-log_type-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_action" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_action"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.3</span> <span>log_action</span> </div> </a> <ul id="toc-log_action-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_timestamp" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_timestamp"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.4</span> <span>log_timestamp</span> </div> </a> <ul id="toc-log_timestamp-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_user" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_user"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.5</span> <span>log_user</span> </div> </a> <ul id="toc-log_user-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_user_text" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_user_text"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.6</span> <span>log_user_text</span> </div> </a> <ul id="toc-log_user_text-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_actor" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_actor"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.7</span> <span>log_actor</span> </div> </a> <ul id="toc-log_actor-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_namespace" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_namespace"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.8</span> <span>log_namespace</span> </div> </a> <ul id="toc-log_namespace-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_title" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_title"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.9</span> <span>log_title</span> </div> </a> <ul id="toc-log_title-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_page" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_page"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.10</span> <span>log_page</span> </div> </a> <ul id="toc-log_page-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_comment" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_comment"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.11</span> <span>log_comment</span> </div> </a> <ul id="toc-log_comment-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_comment_id" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_comment_id"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.12</span> <span>log_comment_id</span> </div> </a> <ul id="toc-log_comment_id-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_params" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_params"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.13</span> <span>log_params</span> </div> </a> <ul id="toc-log_params-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-log_deleted" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#log_deleted"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.14</span> <span>log_deleted</span> </div> </a> <ul id="toc-log_deleted-sublist" class="vector-toc-list"> </ul> </li> </ul> </li> <li id="toc-Schema_summary" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Schema_summary"> <div class="vector-toc-text"> <span class="vector-toc-numb">2</span> <span>Schema summary</span> </div> </a> <ul id="toc-Schema_summary-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-Indexes" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#Indexes"> <div class="vector-toc-text"> <span class="vector-toc-numb">3</span> <span>Indexes</span> </div> </a> <ul id="toc-Indexes-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-See_also" class="vector-toc-list-item vector-toc-level-1 vector-toc-list-item-expanded"> <a class="vector-toc-link" href="#See_also"> <div class="vector-toc-text"> <span class="vector-toc-numb">4</span> <span>See also</span> </div> </a> <ul id="toc-See_also-sublist" class="vector-toc-list"> </ul> </li> </ul> </div> </div> </nav> </div> </div> <div class="mw-content-container"> <main id="content" class="mw-body"> <header class="mw-body-header vector-page-titlebar"> <nav aria-label="Contents" class="vector-toc-landmark"> <div id="vector-page-titlebar-toc" class="vector-dropdown vector-page-titlebar-toc vector-button-flush-left" > <input type="checkbox" id="vector-page-titlebar-toc-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-titlebar-toc" class="vector-dropdown-checkbox " aria-label="Toggle the table of contents" > <label id="vector-page-titlebar-toc-label" for="vector-page-titlebar-toc-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet cdx-button--icon-only " aria-hidden="true" ><span class="vector-icon mw-ui-icon-listBullet mw-ui-icon-wikimedia-listBullet"></span> <span class="vector-dropdown-label-text">Toggle the table of contents</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-titlebar-toc-unpinned-container" class="vector-unpinned-container"> </div> </div> </div> </nav> <h1 id="firstHeading" class="firstHeading mw-first-heading">Manual:logging table</h1> <div class="mw-indicators"> </div> </header> <div class="vector-page-toolbar"> <div class="vector-page-toolbar-container"> <div id="left-navigation"> <nav aria-label="Namespaces"> <div id="p-associated-pages" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-associated-pages" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-nstab-manual" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Manual:Logging_table" title="View the subject page [c]" accesskey="c"><span>Manual</span></a></li><li id="ca-talk" class="vector-tab-noicon mw-list-item"><a href="/wiki/Manual_talk:Logging_table" rel="discussion" title="Discussion about the content page [t]" accesskey="t"><span>Discussion</span></a></li> </ul> </div> </div> <div id="vector-variants-dropdown" class="vector-dropdown emptyPortlet" > <input type="checkbox" id="vector-variants-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-variants-dropdown" class="vector-dropdown-checkbox " aria-label="Change language variant" > <label id="vector-variants-dropdown-label" for="vector-variants-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">English</span> </label> <div class="vector-dropdown-content"> <div id="p-variants" class="vector-menu mw-portlet mw-portlet-variants emptyPortlet" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> </ul> </div> </div> </div> </div> </nav> </div> <div id="right-navigation" class="vector-collapsible"> <nav aria-label="Views"> <div id="p-views" class="vector-menu vector-menu-tabs mw-portlet mw-portlet-views" > <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-view" class="selected vector-tab-noicon mw-list-item"><a href="/wiki/Manual:Logging_table"><span>Read</span></a></li><li id="ca-edit" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Manual:Logging_table&action=edit" title="Edit the source code of this page [e]" accesskey="e"><span>Edit</span></a></li><li id="ca-history" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Manual:Logging_table&action=history" title="Past revisions of this page [h]" accesskey="h"><span>View history</span></a></li> </ul> </div> </div> </nav> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-dropdown" class="vector-dropdown vector-page-tools-dropdown" > <input type="checkbox" id="vector-page-tools-dropdown-checkbox" role="button" aria-haspopup="true" data-event-name="ui.dropdown-vector-page-tools-dropdown" class="vector-dropdown-checkbox " aria-label="Tools" > <label id="vector-page-tools-dropdown-label" for="vector-page-tools-dropdown-checkbox" class="vector-dropdown-label cdx-button cdx-button--fake-button cdx-button--fake-button--enabled cdx-button--weight-quiet" aria-hidden="true" ><span class="vector-dropdown-label-text">Tools</span> </label> <div class="vector-dropdown-content"> <div id="vector-page-tools-unpinned-container" class="vector-unpinned-container"> <div id="vector-page-tools" class="vector-page-tools vector-pinnable-element"> <div class="vector-pinnable-header vector-page-tools-pinnable-header vector-pinnable-header-unpinned" data-feature-name="page-tools-pinned" data-pinnable-element-id="vector-page-tools" data-pinned-container-id="vector-page-tools-pinned-container" data-unpinned-container-id="vector-page-tools-unpinned-container" > <div class="vector-pinnable-header-label">Tools</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-page-tools.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-page-tools.unpin">hide</button> </div> <div id="p-cactions" class="vector-menu mw-portlet mw-portlet-cactions emptyPortlet vector-has-collapsible-items" title="More options" > <div class="vector-menu-heading"> Actions </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="ca-more-view" class="selected vector-more-collapsible-item mw-list-item"><a href="/wiki/Manual:Logging_table"><span>Read</span></a></li><li id="ca-more-edit" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Manual:Logging_table&action=edit" title="Edit the source code of this page [e]" accesskey="e"><span>Edit</span></a></li><li id="ca-more-history" class="vector-more-collapsible-item mw-list-item"><a href="/w/index.php?title=Manual:Logging_table&action=history"><span>View history</span></a></li> </ul> </div> </div> <div id="p-tb" class="vector-menu mw-portlet mw-portlet-tb" > <div class="vector-menu-heading"> General </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-whatlinkshere" class="mw-list-item"><a href="/wiki/Special:WhatLinksHere/Manual:Logging_table" title="A list of all wiki pages that link here [j]" accesskey="j"><span>What links here</span></a></li><li id="t-recentchangeslinked" class="mw-list-item"><a href="/wiki/Special:RecentChangesLinked/Manual:Logging_table" rel="nofollow" title="Recent changes in pages linked from this page [k]" accesskey="k"><span>Related changes</span></a></li><li id="t-upload" class="mw-list-item"><a href="//commons.wikimedia.org/wiki/Special:UploadWizard" title="Upload files [u]" accesskey="u"><span>Upload file</span></a></li><li id="t-specialpages" class="mw-list-item"><a href="/wiki/Special:SpecialPages" title="A list of all special pages [q]" accesskey="q"><span>Special pages</span></a></li><li id="t-permalink" class="mw-list-item"><a href="/w/index.php?title=Manual:Logging_table&oldid=6656377" title="Permanent link to this revision of this page"><span>Permanent link</span></a></li><li id="t-info" class="mw-list-item"><a href="/w/index.php?title=Manual:Logging_table&action=info" title="More information about this page"><span>Page information</span></a></li><li id="t-cite" class="mw-list-item"><a href="/w/index.php?title=Special:CiteThisPage&page=Manual%3ALogging_table&id=6656377&wpFormIdentifier=titleform" title="Information on how to cite this page"><span>Cite this page</span></a></li><li id="t-urlshortener" class="mw-list-item"><a href="/w/index.php?title=Special:UrlShortener&url=https%3A%2F%2Fwww.mediawiki.org%2Fwiki%2FManual%3ALogging_table"><span>Get shortened URL</span></a></li><li id="t-urlshortener-qrcode" class="mw-list-item"><a href="/w/index.php?title=Special:QrCode&url=https%3A%2F%2Fwww.mediawiki.org%2Fwiki%2FManual%3ALogging_table"><span>Download QR code</span></a></li> </ul> </div> </div> <div id="p-coll-print_export" class="vector-menu mw-portlet mw-portlet-coll-print_export" > <div class="vector-menu-heading"> Print/export </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="coll-create_a_book" class="mw-list-item"><a href="/w/index.php?title=Special:Book&bookcmd=book_creator&referer=Manual%3ALogging+table"><span>Create a book</span></a></li><li id="coll-download-as-rl" class="mw-list-item"><a href="/w/index.php?title=Special:DownloadAsPdf&page=Manual%3ALogging_table&action=show-download-screen"><span>Download as PDF</span></a></li><li id="t-print" class="mw-list-item"><a href="/w/index.php?title=Manual:Logging_table&printable=yes" title="Printable version of this page [p]" accesskey="p"><span>Printable version</span></a></li> </ul> </div> </div> <div id="p-wikibase-otherprojects" class="vector-menu mw-portlet mw-portlet-wikibase-otherprojects" > <div class="vector-menu-heading"> In other projects </div> <div class="vector-menu-content"> <ul class="vector-menu-content-list"> <li id="t-wikibase" class="wb-otherproject-link wb-otherproject-wikibase-dataitem mw-list-item"><a href="https://www.wikidata.org/wiki/Special:EntityPage/Q22803917" title="Link to connected data repository item [g]" accesskey="g"><span>Wikidata item</span></a></li> </ul> </div> </div> </div> </div> </div> </div> </nav> </div> </div> </div> <div class="vector-column-end"> <div class="vector-sticky-pinned-container"> <nav class="vector-page-tools-landmark" aria-label="Page tools"> <div id="vector-page-tools-pinned-container" class="vector-pinned-container"> </div> </nav> <nav class="vector-appearance-landmark" aria-label="Appearance"> <div id="vector-appearance-pinned-container" class="vector-pinned-container"> <div id="vector-appearance" class="vector-appearance vector-pinnable-element"> <div class="vector-pinnable-header vector-appearance-pinnable-header vector-pinnable-header-pinned" data-feature-name="appearance-pinned" data-pinnable-element-id="vector-appearance" data-pinned-container-id="vector-appearance-pinned-container" data-unpinned-container-id="vector-appearance-unpinned-container" > <div class="vector-pinnable-header-label">Appearance</div> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-pin-button" data-event-name="pinnable-header.vector-appearance.pin">move to sidebar</button> <button class="vector-pinnable-header-toggle-button vector-pinnable-header-unpin-button" data-event-name="pinnable-header.vector-appearance.unpin">hide</button> </div> </div> </div> </nav> </div> </div> <div id="bodyContent" class="vector-body" aria-labelledby="firstHeading" data-mw-ve-target-container> <div class="vector-body-before-content"> <div id="siteSub" class="noprint">From mediawiki.org</div> </div> <div id="contentSub"><div id="mw-content-subtitle"></div></div> <div id="mw-content-text" class="mw-body-content"><div class="mw-pt-translate-header noprint nomobile" dir="ltr" lang="en"><a href="/w/index.php?title=Special:Translate&group=page-Manual%3ALogging+table&action=page&filter=&action_source=translate_page" title="Special:Translate">Translate this page</a></div><div class="mw-content-ltr mw-parser-output" lang="en" dir="ltr"><div class="mw-pt-languages noprint navigation-not-searchable" lang="en" dir="ltr"><div class="mw-pt-languages-label">Languages:</div><ul class="mw-pt-languages-list"><li><a href="/wiki/Manual:Logging_table/de" class="mw-pt-progress mw-pt-progress--med" title="Handbuch:logging-Tabelle (23% translated)" lang="de" dir="ltr">Deutsch</a></li> <li><span class="mw-pt-languages-ui mw-pt-languages-selected mw-pt-progress mw-pt-progress--complete" lang="en" dir="ltr">English</span></li> <li><a href="/wiki/Manual:Logging_table/fr" class="mw-pt-progress mw-pt-progress--complete" title="Table du journal (100% translated)" lang="fr" dir="ltr">français</a></li> <li><a href="/wiki/Manual:Logging_table/hu" class="mw-pt-progress mw-pt-progress--low" title="Manual:Logging table/hu (14% translated)" lang="hu" dir="ltr">magyar</a></li> <li><a href="/wiki/Manual:Logging_table/pl" class="mw-pt-progress mw-pt-progress--low" title="Podręcznik:Tabela logging (5% translated)" lang="pl" dir="ltr">polski</a></li> <li><a href="/wiki/Manual:Logging_table/pt" class="mw-pt-progress mw-pt-progress--med" title="Manual:Tabela de registos (28% translated)" lang="pt" dir="ltr">português</a></li> <li><a href="/wiki/Manual:Logging_table/pt-br" class="mw-pt-progress mw-pt-progress--med" title="Manual:Tabela de logging (36% translated)" lang="pt-BR" dir="ltr">português do Brasil</a></li> <li><a href="/wiki/Manual:Logging_table/cs" class="mw-pt-progress mw-pt-progress--complete" title="Příručka:Databázová tabulka logging (100% translated)" lang="cs" dir="ltr">čeština</a></li> <li><a href="/wiki/Manual:Logging_table/ru" class="mw-pt-progress mw-pt-progress--low" title="Manual:Logging table/ru (1% translated)" lang="ru" dir="ltr">русский</a></li> <li><a href="/wiki/Manual:Logging_table/ar" class="mw-pt-progress mw-pt-progress--med" title="دليل: جدول Logging (17% translated)" lang="ar" dir="rtl">العربية</a></li> <li><a href="/wiki/Manual:Logging_table/bn" class="mw-pt-progress mw-pt-progress--low" title="Manual:Logging table/bn (12% translated)" lang="bn" dir="ltr">বাংলা</a></li> <li><a href="/wiki/Manual:Logging_table/zh" class="mw-pt-progress mw-pt-progress--med" title="手册:logging表 (24% translated)" lang="zh" dir="ltr">中文</a></li> <li><a href="/wiki/Manual:Logging_table/ja" class="mw-pt-progress mw-pt-progress--med" title="Manual:logging テーブル (49% translated)" lang="ja" dir="ltr">日本語</a></li></ul></div> <table style="width: 100%; margin: .5em 0; border: 1px solid var( --border-color-base, #a2a9b1 ); background: var( --background-color-neutral-subtle, #f8f9fa ); color: inherit; clear:both; text-align: center;"> <tbody><tr> <td style="width:20%; text-align:left; font-size:0.9em">↑ <a href="/wiki/Special:MyLanguage/Manual:Contents" title="Special:MyLanguage/Manual:Contents">Manual:Contents</a><span style="display:none"><a href="/wiki/Manual:Contents" title="Manual:Contents"> </a></span> </td> <td style="width:60%"><b><a href="/wiki/Special:MyLanguage/Manual:Database_layout" title="Special:MyLanguage/Manual:Database layout">MediaWiki database layout</a><span style="display:none"><a href="/wiki/Manual:Database_layout" title="Manual:Database layout"> </a></span></b> </td> <td style="width:20%; text-align:right; font-size:0.9em">logging table </td></tr></tbody></table> <div style="border-bottom: 1px solid var( --border-color-base, #a2a9b1 ); text-align: center;"></div> <div style="clear: both;"></div> <div style="clear: right; margin-bottom: .5em; float: right; margin-left:2em; width: auto;"><meta property="mw:PageProp/toc" /></div> <style data-mw-deduplicate="TemplateStyles:r4199130">.mw-parser-output .mw-version{border:1px solid #72777d;font-size:80%;line-height:1.2;border-collapse:collapse}.mw-parser-output .mw-version-ltr{float:right;margin:0 0 .5em .5em;text-align:right}.mw-parser-output .mw-version-rtl{float:left;margin:0 .5em .5em 0;text-align:left}.mw-parser-output .mw-version td{padding:.1em .3em}.mw-parser-output .mw-version-versionbox{border:5px solid #00af89;text-align:center}.mw-parser-output .mw-version-versionnumber{font-weight:bold;font-size:180%}.mw-parser-output .mw-version-version .mw-version-versionbox{border-color:#c8ccd1}.mw-parser-output .mw-version.mw-version-version2 .mw-version-versionbox{border-top-color:#c8ccd1;border-right-color:#c8ccd1;border-left-color:#c8ccd1}.mw-parser-output .mw-version-version-unsupported .mw-version-versionbox{border-color:#d33}.mw-parser-output .mw-version.mw-version-version2-unsupported .mw-version-versionbox{border-top-color:#d33;border-right-color:#d33;border-left-color:#d33}.mw-parser-output .mw-version-version-legacy .mw-version-versionbox{border-color:#f93}.mw-parser-output .mw-version.mw-version-version2-legacy .mw-version-versionbox{border-top-color:#f93;border-right-color:#f93;border-left-color:#f93}.mw-parser-output .mw-version-version-stable .mw-version-versionbox,.mw-parser-output .mw-version.mw-version.mw-version-and-later .mw-version-versionbox{border-color:#00af89}.mw-parser-output .mw-version.mw-version-version2-stable .mw-version-versionbox{border-top-color:#00af89;border-right-color:#00af89;border-left-color:#00af89}.mw-parser-output .mw-version-version-future .mw-version-versionbox{border-color:#8080c0}.mw-parser-output .mw-version.mw-version-version2-future .mw-version-versionbox{border-top-color:#8080c0;border-right-color:#8080c0;border-left-color:#8080c0}.mw-parser-output .mw-version-version-alpha .mw-version-versionbox{border-style:dotted}</style> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.4</div></td> </tr></tbody></table> <p>Every log action in MediaWiki is logged in the <b>logging</b> table. Users can see those edits on <a href="/wiki/Special:Log" title="Special:Log">Special:Log</a>, except for a few restricted logs (like Special:Log/suppress). </p><p>The contents of this table is what you see on the <a href="/wiki/Special:Log" title="Special:Log">Special:Log</a> page. For example: </p> <ul><li><code>14:18, 25 June 2008 Jacksprat (Talk | contribs| block) uploaded "Image:Climb.jpg" (Added this image for the climbing page)</code></li></ul> <div class="mw-heading mw-heading2"><h2 id="Fields">Fields</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=1" title="Edit section: Fields"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <div class="mw-heading mw-heading3"><h3 id="log_id">log_id</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=2" title="Edit section: log_id"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.10</div></td> </tr></tbody></table> <p>Primary key for the table. <a href="/wiki/Special:MyLanguage/Manual:recentchanges_table#rc_logid" title="Special:MyLanguage/Manual:recentchanges table">rc_logid</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_logid" title="Manual:Recentchanges table"> </a></span> is a foreign key linking to this column. </p> <div class="mw-heading mw-heading3"><h3 id="log_type">log_type</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=3" title="Edit section: log_type"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The type of the log action, or the "log type". </p><p>You can filter by some values of this type on <a href="/wiki/Special:Log" title="Special:Log">Special:Log</a>. </p><p>Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_log_type" title="Special:MyLanguage/Manual:Recentchanges table">rc_log_type</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_log_type" title="Manual:Recentchanges table"> </a></span>. </p><p>Example values from <a rel="nofollow" class="external text" href="https://quarry.wmflabs.org/query/26205">some Wikimedia wikis</a> are as follows (including now-obsolete logs and several extensions): </p> <div style="column-width: 10em; column-count: 4;"> <ul><li>abusefilter</li> <li>block</li> <li>close</li> <li>contentmodel</li> <li>delete</li> <li>gblblock</li> <li>gblrights</li> <li>globalauth</li> <li>gwtoolset</li> <li>import</li> <li>liquidthreads</li> <li>lock</li> <li>managetags</li> <li>massmessage</li> <li>merge</li> <li>move</li> <li>mwoauthconsumer</li> <li>newsletter</li> <li>newusers</li> <li>notifytranslators</li> <li>pagelang</li> <li>pagetranslation</li> <li>patrol</li> <li>protect</li> <li>renameuser</li> <li>review</li> <li>rights</li> <li>spamblacklist</li> <li>tag</li> <li>thanks</li> <li>timedmediahandler</li> <li>translationreview</li> <li>upload</li> <li>usermerge</li></ul> </div> <div class="mw-heading mw-heading3"><h3 id="log_action">log_action</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=4" title="Edit section: log_action"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The action performed. There may be multiple actions possible for a given type: for example, an entry with the type <i>delete</i> may have the action <i>delete</i> or <i>restore</i>, etc. Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_log_action" title="Special:MyLanguage/Manual:Recentchanges table">rc_log_action</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_log_action" title="Manual:Recentchanges table"> </a></span>. See also <a href="/wiki/Special:MyLanguage/API:Logevents#Parameters" title="Special:MyLanguage/API:Logevents">API:Logevents</a><span style="display:none"><a href="/wiki/API:Logevents#Parameters" title="API:Logevents"> </a></span>. See <a href="/wiki/Special:MyLanguage/Manual:Log_actions" title="Special:MyLanguage/Manual:Log actions">Manual:Log actions</a><span style="display:none"><a href="/wiki/Manual:Log_actions" title="Manual:Log actions"> </a></span>. </p> <div class="mw-heading mw-heading3"><h3 id="log_timestamp">log_timestamp</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=5" title="Edit section: log_timestamp"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The time the action was performed, in the timestamp format MediaWiki uses everywhere in the database: yyyymmddhhmmss ("14:18, 25 June 2008" in example). Has the same value as the corresponding <a href="/wiki/Special:MyLanguage/Manual:recentchanges_table#rc_timestamp" title="Special:MyLanguage/Manual:recentchanges table">recentchanges.rc_timestamp</a> and <a href="/wiki/Special:MyLanguage/Manual:revision_table#rev_timestamp" title="Special:MyLanguage/Manual:revision table">revision.rev_timestamp</a>. Does not necessarily have the same value as the corresponding <a href="/wiki/Special:MyLanguage/Manual:image_table#img_timestamp" title="Special:MyLanguage/Manual:image table">image.img_timestamp</a>, in the case of file uploads. </p> <div class="mw-heading mw-heading3"><h3 id="log_user">log_user</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=6" title="Edit section: log_user"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="MediaWiki 1.33 is an unsupported version"><div class="mw-version-versionnumber"><small>≤</small> 1.33</div></td> </tr></tbody></table> <p>The <a href="/wiki/Special:MyLanguage/Manual:User_table#user_id" title="Special:MyLanguage/Manual:User table">id</a><span style="display:none"><a href="/wiki/Manual:User_table#user_id" title="Manual:User table"> </a></span> of the user who performed the action. This is a reference into the <a href="/wiki/Special:MyLanguage/Manual:User_table" title="Special:MyLanguage/Manual:User table">user</a><span style="display:none"><a href="/wiki/Manual:User_table" title="Manual:User table"> </a></span> table (the user id of "Jacksprat" in example). Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_user" title="Special:MyLanguage/Manual:Recentchanges table">rc_user</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_user" title="Manual:Recentchanges table"> </a></span> and <a href="/wiki/Special:MyLanguage/Manual:Revision_table#rev_user" title="Special:MyLanguage/Manual:Revision table">rev_user</a><span style="display:none"><a href="/wiki/Manual:Revision_table#rev_user" title="Manual:Revision table"> </a></span>. </p><p>Deprecated in favor of <a href="#log_actor">log_actor</a>. </p> <div class="mw-heading mw-heading3"><h3 id="log_user_text">log_user_text</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=7" title="Edit section: log_user_text"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.16</div></td> </tr></tbody></table> <p><a href="/wiki/Special:MyLanguage/Manual:User_table#user_name" title="Special:MyLanguage/Manual:User table">user_name</a><span style="display:none"><a href="/wiki/Manual:User_table#user_name" title="Manual:User table"> </a></span> of the user who performed the action, intended primarily for anonymous users, fillable by maintenance/populateLogUsertext.php. Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_user_text" title="Special:MyLanguage/Manual:Recentchanges table">rc_user_text</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_user_text" title="Manual:Recentchanges table"> </a></span> and <a href="/wiki/Special:MyLanguage/Manual:Revision_table#rev_user_text" title="Special:MyLanguage/Manual:Revision table">rev_user_text</a><span style="display:none"><a href="/wiki/Manual:Revision_table#rev_user_text" title="Manual:Revision table"> </a></span>. </p><p>Deprecated in favor of <a href="#log_actor">log_actor</a>. </p><p><span class="anchor" id="log_actor"></span> </p> <div class="mw-heading mw-heading3"><h3 id="log_actor">log_actor</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=8" title="Edit section: log_actor"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.31</div><small><a href="https://gerrit.wikimedia.org/r/380669" class="extiw" title="gerrit:380669">Gerrit change 380669</a></small></td> </tr></tbody></table> <p>This is a foreign key to <a href="/wiki/Special:MyLanguage/Manual:actor_table#actor_id" title="Special:MyLanguage/Manual:actor table">actor_id</a><span style="display:none"><a href="/wiki/Manual:Actor_table#actor_id" title="Manual:Actor table"> </a></span> in the <a href="/wiki/Special:MyLanguage/Manual:actor_table" title="Special:MyLanguage/Manual:actor table">actor</a><span style="display:none"><a href="/wiki/Manual:Actor_table" title="Manual:Actor table"> </a></span> table, corresponding to the user (registered or anonymous) who performed the action. </p> <div class="mw-heading mw-heading3"><h3 id="log_namespace">log_namespace</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=9" title="Edit section: log_namespace"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The <a href="/wiki/Special:MyLanguage/Manual:Page_table#page_namespace" title="Special:MyLanguage/Manual:Page table">namespace</a> of the affected page. Together with log_title, this is a reference into the <a href="/wiki/Special:MyLanguage/Manual:Page_table" title="Special:MyLanguage/Manual:Page table">page</a><span style="display:none"><a href="/wiki/Manual:Page_table" title="Manual:Page table"> </a></span> table ("Image:Climb.jpg" in example). Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_namespace" title="Special:MyLanguage/Manual:Recentchanges table">rc_namespace</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_namespace" title="Manual:Recentchanges table"> </a></span>. </p> <style data-mw-deduplicate="TemplateStyles:r6651107">.mw-parser-output .note{background-position:left 7px top 50%;padding:0.5em 0.5em 0.5em 40px;margin:0.5em 0;overflow:hidden;background-color:#f8f9fa;color:#333;background-repeat:no-repeat;border:1px solid #ddd}.mw-parser-output .note-inline{display:inline-block;vertical-align:middle}.mw-parser-output .note-info{background-color:#eaf3ff;color:#333;background-image:url("https://upload.wikimedia.org/wikipedia/commons/e/ec/OOjs_UI_icon_information-progressive.svg");background-size:25px;border-color:#a3caff;padding-left:40px;min-height:25px}.mw-parser-output .note-reminder{background-color:#fff9ea;color:#333;background-image:url("https://upload.wikimedia.org/wikipedia/commons/a/a8/OOjs_UI_icon_lightbulb-yellow.svg");background-size:25px;border-color:#fc3;min-height:25px}.mw-parser-output .note-warn{background-color:#fff9ea;color:#333;background-image:url("https://upload.wikimedia.org/wikipedia/commons/3/3b/OOjs_UI_icon_alert-warning.svg");background-size:25px;border-color:#fc3;min-height:25px}.mw-parser-output .note-error{background-color:#fee7e6;color:#333;background-image:url("https://upload.wikimedia.org/wikipedia/commons/b/bf/OOjs_UI_icon_notice-destructive.svg");background-size:25px;border-color:#c33;min-height:25px}@media screen{html.skin-theme-clientpref-night .mw-parser-output .note{background-color:transparent;color:inherit}}@media screen and (prefers-color-scheme:dark){html.skin-theme-clientpref-os .mw-parser-output .note{background-color:transparent;color:inherit}}</style><div role="note" class="note note-info"><code>logging</code> table may contain rows with <code>log_namespace</code> < 0:</div> <ul><li>Special:Renameuser with log_type and log_action being either "" or "renameuser"</li></ul> <dl><dd><dl><dd><ul><li>Special:Userlogin with log_type being "newusers" and log_action e.g. being "create"</li></ul></dd></dl></dd></dl> <div class="mw-heading mw-heading3"><h3 id="log_title">log_title</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=10" title="Edit section: log_title"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>The <a href="/wiki/Special:MyLanguage/Manual:Page_table#page_title" title="Special:MyLanguage/Manual:Page table">title</a><span style="display:none"><a href="/wiki/Manual:Page_table#page_title" title="Manual:Page table"> </a></span> of the affected page. Together with log_namespace, this is a reference into the <a href="/wiki/Special:MyLanguage/Manual:Page_table" title="Special:MyLanguage/Manual:Page table">page</a><span style="display:none"><a href="/wiki/Manual:Page_table" title="Manual:Page table"> </a></span> table. Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_title" title="Special:MyLanguage/Manual:Recentchanges table">rc_title</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_title" title="Manual:Recentchanges table"> </a></span> </p><p>The title is also known as the log entry's 'target'. </p><p>For user blocks, this is the blocked user's username. For thanks action, this is the thanked user's username. </p> <div class="mw-heading mw-heading3"><h3 id="log_page">log_page</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=11" title="Edit section: log_page"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.16</div></td> </tr></tbody></table> <p>The <a href="/wiki/Special:MyLanguage/Manual:Page_table#page_id" title="Special:MyLanguage/Manual:Page table">page_id</a><span style="display:none"><a href="/wiki/Manual:Page_table#page_id" title="Manual:Page table"> </a></span> that this log action is about. Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_cur_id" title="Special:MyLanguage/Manual:Recentchanges table">rc_cur_id</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_cur_id" title="Manual:Recentchanges table"> </a></span> and <a href="/wiki/Special:MyLanguage/Manual:Revision_table#rev_page" title="Special:MyLanguage/Manual:Revision table">rev_page</a><span style="display:none"><a href="/wiki/Manual:Revision_table#rev_page" title="Manual:Revision table"> </a></span>. In the case of a page move, this is set to the page_id of the moved page (since <a href="https://gerrit.wikimedia.org/r/157872" class="extiw" title="gerrit:157872">Gerrit change 157872</a>). Formerly, it was the page_id of the redirect, or 0 if the page was moved without creating a redirect. </p> <div class="mw-heading mw-heading3"><h3 id="log_comment">log_comment</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=12" title="Edit section: log_comment"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="MediaWiki 1.32 is an unsupported version"><div class="mw-version-versionnumber"><small>≤</small> 1.32</div></td> </tr></tbody></table> <p>The comment given for the action; that is the upload comment for uploads, the deletion comment for deletions, etc. Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_comment" title="Special:MyLanguage/Manual:Recentchanges table">rc_comment</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_comment" title="Manual:Recentchanges table"> </a></span> and <a href="/wiki/Special:MyLanguage/Manual:Revision_table#rev_comment" title="Special:MyLanguage/Manual:Revision table">rev_comment</a><span style="display:none"><a href="/wiki/Manual:Revision_table#rev_comment" title="Manual:Revision table"> </a></span>. </p><p><span style="color:#d33">(deprecated)</span>; log_comment_id and the <a href="/wiki/Special:MyLanguage/Manual:Comment_table" title="Special:MyLanguage/Manual:Comment table">comment</a><span style="display:none"><a href="/wiki/Manual:Comment_table" title="Manual:Comment table"> </a></span> table should be used instead! </p> <div class="mw-heading mw-heading3"><h3 id="log_comment_id">log_comment_id</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=13" title="Edit section: log_comment_id"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.30</div></td> </tr></tbody></table> <p>This is a foreign key to <a href="/wiki/Special:MyLanguage/Manual:comment_table#comment_id" title="Special:MyLanguage/Manual:comment table">comment_id</a><span style="display:none"><a href="/wiki/Manual:Comment_table#comment_id" title="Manual:Comment table"> </a></span> in the <a href="/wiki/Special:MyLanguage/Manual:Comment_table" title="Special:MyLanguage/Manual:Comment table">comment</a><span style="display:none"><a href="/wiki/Manual:Comment_table" title="Manual:Comment table"> </a></span> table. </p> <div class="mw-heading mw-heading3"><h3 id="log_params">log_params</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=14" title="Edit section: log_params"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.5</div></td> </tr></tbody></table> <p>Additional parameters, usually empty. Mirrored in <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_params" title="Special:MyLanguage/Manual:Recentchanges table">rc_params</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_params" title="Manual:Recentchanges table"> </a></span>. log_params is usually serialized, but not always; sometimes, for historical reasons, fields for log_params are separated by a newline. Anyone creating a new log type should use the PHP serialization. </p><p>For user blocks, log_params contains the duration of the block and other data, in human readable form, e.g. "2 weeks nocreate,noautoblock,noemail". For page moves, it contains a serialized array of the prefixed page title the page was moved to (i.e. in <a href="/wiki/FULLPAGENAME" class="mw-redirect" title="FULLPAGENAME">FULLPAGENAME</a> format) and the boolean value of <code>noredir</code>. For other examples, see <a href="/wiki/Special:MyLanguage/Manual:Log_parameters" title="Special:MyLanguage/Manual:Log parameters">Manual:Log parameters</a><span style="display:none"><a href="/wiki/Manual:Log_parameters" class="mw-redirect" title="Manual:Log parameters"> </a></span>. </p> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.19</div></td> </tr></tbody></table> <p>Since 1.19, data in log_params is in a different format. For instance, if you want to filter patrol/patrol log entries excluding autopatrol, pre-1.19 log entries need: </p> <pre>log.log_params LIKE '%\n0' </pre> <p>while entries added in 1.19 and further need (serialized PHP arrays): </p> <pre>log.log_params LIKE '%"6::auto";i:0%' </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.21</div></td> </tr></tbody></table> <p>Since <a href="/wiki/Special:MyLanguage/MediaWiki_1.21/wmf9#Core_changes" title="Special:MyLanguage/MediaWiki 1.21/wmf9">1.21</a><span style="display:none"><a href="/wiki/MediaWiki_1.21/wmf9#Core_changes" title="MediaWiki 1.21/wmf9"> </a></span>, log_params is always serialized for newusers log too. An entry now looks like: </p> <pre>mysql> select log_params, log_action from logging where log_user = 4681690; +----------------------------------+------------+ | log_params | log_action | +----------------------------------+------------+ | a:1:{s:9:"4::userid";i:4681690;} | autocreate | +----------------------------------+------------+ </pre> <p>while it used to look like: </p> <pre>mysql> select log_params, log_action from logging where log_user = 2298743; +------------+------------+ | log_params | log_action | +------------+------------+ | 2298743 | autocreate | +------------+------------+ </pre> <p>The numbers, e.g. the 4 in "4::userid", are used as the argument number for message keys (e.g. $1, $2,...). The numbering should start with number 4, as the first three parameters are hardcoded for every message. If there is no message key, then a number should not be used. Some data contained in log_params are also contained in <a href="/wiki/Special:MyLanguage/Manual:log_search_table" title="Special:MyLanguage/Manual:log search table">log_search</a> to facilitate indexed queries. Log parameters are typically set using functions such as <a href="/wiki/Special:MyLanguage/Manual:LogEntry.php" title="Special:MyLanguage/Manual:LogEntry.php">ManualLogEntry::setParameters()</a><span style="display:none"><a href="/wiki/Manual:LogEntry.php" title="Manual:LogEntry.php"> </a></span> and <a href="/wiki/Special:MyLanguage/Manual:LogPage.php" title="Special:MyLanguage/Manual:LogPage.php">LogPage::addEntry()</a><span style="display:none"><a href="/wiki/Manual:LogPage.php" title="Manual:LogPage.php"> </a></span>. </p> <div class="mw-heading mw-heading3"><h3 id="log_deleted">log_deleted</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=15" title="Edit section: log_deleted"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.10</div></td> </tr></tbody></table> <p>Used with the <a href="/wiki/Special:MyLanguage/Manual:RevisionDelete" title="Special:MyLanguage/Manual:RevisionDelete">RevisionDelete</a><span style="display:none"><a href="/wiki/Manual:RevisionDelete" title="Manual:RevisionDelete"> </a></span> system to delete log entries. Comparable to <a href="/wiki/Special:MyLanguage/Manual:Recentchanges_table#rc_deleted" title="Special:MyLanguage/Manual:Recentchanges table">rc_deleted</a><span style="display:none"><a href="/wiki/Manual:Recentchanges_table#rc_deleted" title="Manual:Recentchanges table"> </a></span> and <a href="/wiki/Special:MyLanguage/Manual:Revision_table#rev_deleted" title="Special:MyLanguage/Manual:Revision table">rev_deleted</a><span style="display:none"><a href="/wiki/Manual:Revision_table#rev_deleted" title="Manual:Revision table"> </a></span>. It is a bit field. Take the sum of the following to determine what it represents: </p> <ul><li><b>1</b> Action deleted</li> <li><b>2</b> Comment deleted</li> <li><b>4</b> User deleted</li> <li><b>8</b> If the deleted information is restricted. If this field is not set, then only <i>deletedhistory</i> right is needed, otherwise you need <i>suppressrevision</i> right. (On Wikimedia wikis, this corresponds to if admins can view the entry, or if only oversighters can)</li></ul> <p>For example, if the value is 6 (4+2), then the action would be visible, but the comment and user would not be unless you had <i>deletedhistory</i> rights. </p> <div class="mw-heading mw-heading2"><h2 id="Schema_summary">Schema summary</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=16" title="Edit section: Schema summary"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.34</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+----------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(32) | NO | MUL | | | | log_action | varbinary(32) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_actor | bigint(20) unsigned | NO | MUL | NULL | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_page | int(10) unsigned | YES | MUL | NULL | | | log_comment_id | bigint(20) unsigned | NO | | NULL | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +----------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="MediaWiki 1.33 is an unsupported version"><div class="mw-version-versionnumber"> 1.33</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+----------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(32) | NO | MUL | | | | log_action | varbinary(32) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_user_text | varbinary(255) | NO | MUL | | | | log_actor | bigint(20) unsigned | NO | MUL | 0 | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_page | int(10) unsigned | YES | MUL | NULL | | | log_comment_id | bigint(20) unsigned | NO | | NULL | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +----------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.32 is an unsupported version"><div class="mw-version-versionnumber"> 1.31 – 1.32</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+----------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(32) | NO | MUL | | | | log_action | varbinary(32) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_user_text | varbinary(255) | NO | MUL | | | | log_actor | bigint(20) unsigned | NO | MUL | 0 | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_page | int(10) unsigned | YES | MUL | NULL | | | log_comment | varbinary(767) | NO | | | | | log_comment_id | bigint(20) unsigned | NO | | 0 | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +----------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="MediaWiki 1.30 is an unsupported version"><div class="mw-version-versionnumber"> 1.30</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+----------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(32) | NO | MUL | | | | log_action | varbinary(32) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_user_text | varbinary(255) | NO | MUL | | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_page | int(10) unsigned | YES | MUL | NULL | | | log_comment | varbinary(767) | NO | | | | | log_comment_id | bigint(20) unsigned | NO | | 0 | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +----------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.29 is an unsupported version"><div class="mw-version-versionnumber"> 1.25 – 1.29</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(32) | NO | MUL | | | | log_action | varbinary(32) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_user_text | varbinary(255) | NO | MUL | | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_page | int(10) unsigned | YES | MUL | NULL | | | log_comment | varbinary(767) | NO | | | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.24 is an unsupported version"><div class="mw-version-versionnumber"> 1.23 – 1.24</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(32) | NO | MUL | | | | log_action | varbinary(32) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_user_text | varbinary(255) | NO | MUL | | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_page | int(10) unsigned | YES | MUL | NULL | | | log_comment | varbinary(255) | NO | | | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.22 is an unsupported version"><div class="mw-version-versionnumber"> 1.16 – 1.22</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(32) | NO | MUL | | | | log_action | varbinary(32) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_user_text | varbinary(255) | NO | | | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_page | int(10) unsigned | YES | MUL | NULL | | | log_comment | varbinary(255) | NO | | | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.15 is an unsupported version"><div class="mw-version-versionnumber"> 1.13 – 1.15</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(10) | NO | MUL | | | | log_action | varbinary(10) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_comment | varbinary(255) | NO | | | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.12 is an unsupported version"><div class="mw-version-versionnumber"> 1.10 – 1.12</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_id | int(10) unsigned | NO | PRI | NULL | auto_increment | | log_type | varbinary(10) | NO | MUL | | | | log_action | varbinary(10) | NO | | | | | log_timestamp | binary(14) | NO | MUL | 19700101000000 | | | log_user | int(10) unsigned | NO | MUL | 0 | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varbinary(255) | NO | | | | | log_comment | varbinary(255) | NO | | | | | log_params | blob | NO | | NULL | | | log_deleted | tinyint(3) unsigned | NO | | 0 | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.9 is an unsupported version"><div class="mw-version-versionnumber"> 1.6 – 1.9</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_type | char(10) | NO | MUL | NULL | | | log_action | char(10) | NO | | NULL | | | log_timestamp | char(14) | NO | MUL | 19700101000000 | | | log_user | int unsigned | NO | MUL | 0 | | | log_namespace | int | NO | MUL | 0 | | | log_title | varchar(255) binary | NO | | NULL | | | log_comment | varchar(255) | NO | | NULL | | | log_params | blob | NO | | NULL | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="MediaWiki 1.5 is an unsupported version"><div class="mw-version-versionnumber"> 1.5</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_type | char(10) | NO | MUL | NULL | | | log_action | char(10) | NO | | NULL | | | log_timestamp | char(14) | NO | | 19700101000000 | | | log_user | int unsigned | NO | MUL | 0 | | | log_namespace | int(11) | NO | MUL | 0 | | | log_title | varchar(255) binary | NO | | NULL | | | log_comment | varchar(255) | NO | | NULL | | | log_params | blob | NO | | NULL | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="MediaWiki 1.4 is an unsupported version"><div class="mw-version-versionnumber"> 1.4</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">DESCRIBE</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre>+---------------+---------------------+------+-----+----------------+----------------+ | Field | Type | Null | Key | Default | Extra | +---------------+---------------------+------+-----+----------------+----------------+ | log_type | char(10) | NO | MUL | NULL | | | log_action | char(10) | NO | | NULL | | | log_timestamp | char(14) | NO | | 19700101000000 | | | log_user | int unsigned | NO | MUL | 0 | | | log_namespace | tinyint(?) unsigned | NO | MUL | 0 | | | log_title | varchar(255) binary | NO | | NULL | | | log_comment | varchar(255) | NO | | NULL | | | log_params | blob | NO | | NULL | | +---------------+---------------------+------+-----+----------------+----------------+ </pre> <div class="mw-heading mw-heading2"><h2 id="Indexes">Indexes</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=17" title="Edit section: Indexes"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4199130"> <table class="mw-version mw-version-ltr mw-version-version mw-version-version-unsupported mw-version-and-later"><tbody><tr> <td>MediaWiki version:</td> <td class="mw-version-versionbox" title="The latest stable version is 1.42"><div class="mw-version-versionnumber"><small>≥</small> 1.36</div></td> </tr></tbody></table> <p><code class="mw-highlight mw-highlight-lang-sql mw-content-ltr" style="" dir="ltr"><span class="k">SHOW</span><span class="w"> </span><span class="k">INDEX</span><span class="w"> </span><span class="k">IN</span><span class="w"> </span><span class="n">logging</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+---------+------------+---------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | +---------+------------+---------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | logging | 0 | PRIMARY | 1 | log_id | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_type_time | 1 | log_type | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_type_time | 2 | log_timestamp | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_actor_time | 1 | log_actor | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_actor_time | 2 | log_timestamp | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_page_time | 1 | log_namespace | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_page_time | 2 | log_title | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_page_time | 3 | log_timestamp | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_times | 1 | log_timestamp | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_actor_type_time | 1 | log_actor | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_actor_type_time | 2 | log_type | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_actor_type_time | 3 | log_timestamp | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_page_id_time | 1 | log_page | A | 0 | NULL | NULL | YES | BTREE | | | | logging | 1 | log_page_id_time | 2 | log_timestamp | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_type_action | 1 | log_type | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_type_action | 2 | log_action | A | 0 | NULL | NULL | | BTREE | | | | logging | 1 | log_type_action | 3 | log_timestamp | A | 0 | NULL | NULL | | BTREE | | | +---------+------------+---------------------+--------------+---------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ </pre> <div class="mw-heading mw-heading2"><h2 id="See_also">See also</h2><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Logging_table&action=edit&section=18" title="Edit section: See also"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <ul><li><a href="/wiki/Manual:Logging_to_Special:Log" title="Manual:Logging to Special:Log">Manual:Logging to Special:Log</a></li> <li><a href="/wiki/Help:Log" title="Help:Log">Help:Log</a></li></ul> <div class="navbox-styles nomobile"><style data-mw-deduplicate="TemplateStyles:r6230902">.mw-parser-output .navbox{border:1px solid #aaa;box-sizing:border-box;width:100%;margin:auto;clear:both;font-size:88%;text-align:center;padding:1px}.mw-parser-output .navbox-inner,.mw-parser-output .navbox-subgroup{width:100%}.mw-parser-output .navbox+.navbox-styles+.navbox{margin-top:-1px}.mw-parser-output .navbox th,.mw-parser-output .navbox-title,.mw-parser-output .navbox-abovebelow{text-align:center;padding-left:1em;padding-right:1em}.mw-parser-output th.navbox-group{white-space:nowrap;text-align:right}.mw-parser-output .navbox,.mw-parser-output .navbox-subgroup{background:#fdfdfd}.mw-parser-output .navbox-list{border-color:#fdfdfd}.mw-parser-output .navbox th,.mw-parser-output .navbox-title{background:#eaeeff}.mw-parser-output .navbox-abovebelow,.mw-parser-output th.navbox-group,.mw-parser-output .navbox-subgroup .navbox-title{background:#ddddff}.mw-parser-output .navbox-subgroup .navbox-group,.mw-parser-output .navbox-subgroup .navbox-abovebelow{background:#e6e6ff}.mw-parser-output .navbox-even{background:#f7f7f7}.mw-parser-output .navbox-odd{background:transparent}.mw-parser-output th.navbox-title1{border-left:2px solid #fdfdfd;width:100%}.mw-parser-output td.navbox-list1{text-align:left;border-left-width:2px;border-left-style:solid}.mw-parser-output .navbox .hlist td dl,.mw-parser-output .navbox .hlist td ol,.mw-parser-output .navbox .hlist td ul,.mw-parser-output .navbox td.hlist dl,.mw-parser-output .navbox td.hlist ol,.mw-parser-output .navbox td.hlist ul{padding:0.125em 0}.mw-parser-output .navbox .hlist dd,.mw-parser-output .navbox .hlist dt,.mw-parser-output .navbox .hlist li{white-space:nowrap}.mw-parser-output .navbox .hlist dd dl,.mw-parser-output .navbox .hlist dt dl,.mw-parser-output .navbox .hlist li ol,.mw-parser-output .navbox .hlist li ul{white-space:normal}.mw-parser-output ol+.navbox-styles+.navbox,.mw-parser-output ul+.navbox-styles+.navbox{margin-top:0.5em}</style></div><div role="navigation" class="navbox" aria-labelledby="Databases" style="padding:3px"><table class="nowraplinks hlist mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><style data-mw-deduplicate="TemplateStyles:r6387430">.mw-parser-output .hlist dl,.mw-parser-output .hlist ol,.mw-parser-output .hlist ul{margin:0;padding:0}.mw-parser-output .hlist dd,.mw-parser-output .hlist dt,.mw-parser-output .hlist li{margin:0;display:inline}.mw-parser-output .hlist dl dl,.mw-parser-output .hlist dl ol,.mw-parser-output .hlist dl ul,.mw-parser-output .hlist ol dl,.mw-parser-output .hlist ol ol,.mw-parser-output .hlist ol ul,.mw-parser-output .hlist ul dl,.mw-parser-output .hlist ul ol,.mw-parser-output .hlist ul ul{display:inline}.mw-parser-output .hlist .mw-empty-li,.mw-parser-output .hlist .mw-empty-elt{display:none}.mw-parser-output .hlist dt:after{content:": "}.mw-parser-output .hlist dd:after,.mw-parser-output .hlist li:after{content:" · ";font-weight:bold}.mw-parser-output .hlist dd:last-child:after,.mw-parser-output .hlist dt:last-child:after,.mw-parser-output .hlist li:last-child:after{content:none}.mw-parser-output .hlist dd dd:first-child:before,.mw-parser-output .hlist dd dt:first-child:before,.mw-parser-output .hlist dd li:first-child:before,.mw-parser-output .hlist dt dd:first-child:before,.mw-parser-output .hlist dt dt:first-child:before,.mw-parser-output .hlist dt li:first-child:before,.mw-parser-output .hlist li dd:first-child:before,.mw-parser-output .hlist li dt:first-child:before,.mw-parser-output .hlist li li:first-child:before{content:" (";font-weight:normal}.mw-parser-output .hlist dd dd:last-child:after,.mw-parser-output .hlist dd dt:last-child:after,.mw-parser-output .hlist dd li:last-child:after,.mw-parser-output .hlist dt dd:last-child:after,.mw-parser-output .hlist dt dt:last-child:after,.mw-parser-output .hlist dt li:last-child:after,.mw-parser-output .hlist li dd:last-child:after,.mw-parser-output .hlist li dt:last-child:after,.mw-parser-output .hlist li li:last-child:after{content:")";font-weight:normal}.mw-parser-output .hlist ol{counter-reset:listitem}.mw-parser-output .hlist ol>li{counter-increment:listitem}.mw-parser-output .hlist ol>li:before{content:" "counter(listitem)"\a0 "}.mw-parser-output .hlist dd ol>li:first-child:before,.mw-parser-output .hlist dt ol>li:first-child:before,.mw-parser-output .hlist li ol>li:first-child:before{content:" ("counter(listitem)"\a0 "}</style><style data-mw-deduplicate="TemplateStyles:r4692751">.mw-parser-output .navbar{display:inline;font-size:88%;font-weight:normal}.mw-parser-output .navbar ul{display:inline;white-space:nowrap}.mw-parser-output .navbar li{word-spacing:-0.125em}.mw-parser-output .navbox .navbar{display:block;font-size:100%}.mw-parser-output .navbox-title .navbar{float:left;text-align:left;margin-right:0.5em;width:6em}</style><div class="plainlinks hlist navbar mini"><ul><li class="nv-view"><a href="/wiki/Template:Databases" title="Template:Databases"><abbr title="View this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">v</abbr></a></li><li class="nv-talk"><a href="/wiki/Template_talk:Databases" title="Template talk:Databases"><abbr title="Discuss this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">t</abbr></a></li><li class="nv-edit"><a class="external text" href="https://www.mediawiki.org/w/index.php?title=Template:Databases&action=edit"><abbr title="Edit this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">e</abbr></a></li></ul></div><div id="Databases" style="font-size:114%;margin:0 4em"><a href="/wiki/Special:MyLanguage/Manual:Database_layout" title="Special:MyLanguage/Manual:Database layout">Databases</a><span style="display:none"><a href="/wiki/Manual:Database_layout" title="Manual:Database layout"> </a></span></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Engines</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"><div class="navbox-styles nomobile"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r6230902"></div></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Current</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:MariaDB" title="Special:MyLanguage/Manual:MariaDB">MariaDB</a><span style="display:none"><a href="/wiki/Manual:MariaDB" title="Manual:MariaDB"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:MySQL" title="Special:MyLanguage/Manual:MySQL">MySQL</a><span style="display:none"><a href="/wiki/Manual:MySQL" title="Manual:MySQL"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:PostgreSQL" title="Special:MyLanguage/Manual:PostgreSQL">PostgreSQL</a><span style="display:none"><a href="/wiki/Manual:PostgreSQL" title="Manual:PostgreSQL"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:SQLite" title="Special:MyLanguage/Manual:SQLite">SQLite</a><span style="display:none"><a href="/wiki/Manual:SQLite" title="Manual:SQLite"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Oracle" title="Special:MyLanguage/Manual:Oracle">Oracle</a><span style="display:none"><a href="/wiki/Manual:Oracle" title="Manual:Oracle"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Microsoft_SQL_Server" title="Special:MyLanguage/Manual:Microsoft SQL Server">SQL Server</a><span style="display:none"><a href="/wiki/Manual:Microsoft_SQL_Server" title="Manual:Microsoft SQL Server"> </a></span></li></ul> </div></td></tr></tbody></table><div></div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Technical documentation</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Database_layout" title="Special:MyLanguage/Manual:Database layout">Schema</a><span style="display:none"><a href="/wiki/Manual:Database_layout" title="Manual:Database layout"> </a></span> (<a href="/wiki/Special:MyLanguage/Category:MediaWiki_database_tables" title="Special:MyLanguage/Category:MediaWiki database tables">tables</a><span style="display:none"><a href="/wiki/Category:MediaWiki_database_tables" title="Category:MediaWiki database tables"> </a></span>)</li> <li><a href="/wiki/Special:MyLanguage/API:Database_field_and_API_property_associations" title="Special:MyLanguage/API:Database field and API property associations">API property associations</a><span style="display:none"><a href="/wiki/API:Database_field_and_API_property_associations" title="API:Database field and API property associations"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Database_field_prefixes" title="Special:MyLanguage/Database field prefixes">Field prefixes</a><span style="display:none"><a href="/wiki/Database_field_prefixes" title="Database field prefixes"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Primary_key_storage_in_other_fields" title="Special:MyLanguage/Manual:Primary key storage in other fields">Primary key storage in other fields</a><span style="display:none"><a href="/wiki/Manual:Primary_key_storage_in_other_fields" title="Manual:Primary key storage in other fields"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Category:Wikimedia_extension_database_tables" title="Special:MyLanguage/Category:Wikimedia extension database tables">Wikimedia extension tables</a><span style="display:none"><a href="/wiki/Category:Wikimedia_extension_database_tables" title="Category:Wikimedia extension database tables"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Database_inconsistencies" title="Special:MyLanguage/Manual:Database inconsistencies">Inconsistencies</a><span style="display:none"><a href="/wiki/Manual:Database_inconsistencies" title="Manual:Database inconsistencies"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Configuration</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Configuration_settings#Database_settings" title="Special:MyLanguage/Manual:Configuration settings">Settings</a><span style="display:none"><a href="/wiki/Manual:Configuration_settings#Database_settings" title="Manual:Configuration settings"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Shared_database" title="Special:MyLanguage/Manual:Shared database">Sharing</a><span style="display:none"><a href="/wiki/Manual:Shared_database" title="Manual:Shared database"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Development</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Database_access" title="Special:MyLanguage/Manual:Database access">Access</a><span style="display:none"><a href="/wiki/Manual:Database_access" title="Manual:Database access"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Database_optimization" title="Special:MyLanguage/Database optimization">Optimization</a><span style="display:none"><a href="/wiki/Database_optimization" title="Database optimization"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/MediaWiki_database_policy" title="Special:MyLanguage/MediaWiki database policy">Policy</a><span style="display:none"><a href="/wiki/MediaWiki_database_policy" title="MediaWiki database policy"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:DatabaseUpdater.php" title="Special:MyLanguage/Manual:DatabaseUpdater.php">Updater</a><span style="display:none"><a href="/wiki/Manual:DatabaseUpdater.php" title="Manual:DatabaseUpdater.php"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Hooks/LoadExtensionSchemaUpdates" title="Special:MyLanguage/Manual:Hooks/LoadExtensionSchemaUpdates">Extension schema updates</a><span style="display:none"><a href="/wiki/Manual:Hooks/LoadExtensionSchemaUpdates" title="Manual:Hooks/LoadExtensionSchemaUpdates"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Schema_changes" title="Special:MyLanguage/Manual:Schema changes">Schema changes</a><span style="display:none"><a href="/wiki/Manual:Schema_changes" title="Manual:Schema changes"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%;white-space:inherit; min-width:9em">Core tables</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"><div class="navbox-styles nomobile"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r6230902"></div></div><table class="nowraplinks navbox-subgroup" style="border-spacing:0"><tbody><tr><th scope="row" class="navbox-group" style="width:1%">Current</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:actor_table" title="Special:MyLanguage/Manual:actor table">actor</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:archive_table" title="Special:MyLanguage/Manual:archive table">archive</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:block_table" title="Special:MyLanguage/Manual:block table">block</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:block_target_table" title="Special:MyLanguage/Manual:block target table">block_target</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:bot_passwords_table" title="Special:MyLanguage/Manual:bot passwords table">bot_passwords</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:category_table" title="Special:MyLanguage/Manual:category table">category</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:categorylinks_table" title="Special:MyLanguage/Manual:categorylinks table">categorylinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:change_tag_table" title="Special:MyLanguage/Manual:change tag table">change_tag</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:change_tag_def_table" title="Special:MyLanguage/Manual:change tag def table">change_tag_def</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:comment_table" title="Special:MyLanguage/Manual:comment table">comment</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:content_table" title="Special:MyLanguage/Manual:content table">content</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:content_models_table" title="Special:MyLanguage/Manual:content models table">content_models</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:externallinks_table" title="Special:MyLanguage/Manual:externallinks table">externallinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:filearchive_table" title="Special:MyLanguage/Manual:filearchive table">filearchive</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:image_table" title="Special:MyLanguage/Manual:image table">image</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:imagelinks_table" title="Special:MyLanguage/Manual:imagelinks table">imagelinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:interwiki_table" title="Special:MyLanguage/Manual:interwiki table">interwiki</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:iwlinks_table" title="Special:MyLanguage/Manual:iwlinks table">iwlinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ipblocks_table" title="Special:MyLanguage/Manual:ipblocks table">ipblocks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ipblocks_restrictions_table" title="Special:MyLanguage/Manual:ipblocks restrictions table">ipblocks_restrictions</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ip_changes_table" title="Special:MyLanguage/Manual:ip changes table">ip_changes</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:job_table" title="Special:MyLanguage/Manual:job table">job</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:l10n_cache_table" title="Special:MyLanguage/Manual:l10n cache table">l10n_cache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:langlinks_table" title="Special:MyLanguage/Manual:langlinks table">langlinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:linktarget_table" title="Special:MyLanguage/Manual:linktarget table">linktarget</a></li> <li><b><a href="/wiki/Special:MyLanguage/Manual:logging_table" title="Special:MyLanguage/Manual:logging table">logging</a></b></li> <li><a href="/wiki/Special:MyLanguage/Manual:log_search_table" title="Special:MyLanguage/Manual:log search table">log_search</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:module_deps_table" title="Special:MyLanguage/Manual:module deps table">module_deps</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:objectcache_table" title="Special:MyLanguage/Manual:objectcache table">objectcache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:oldimage_table" title="Special:MyLanguage/Manual:oldimage table">oldimage</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:page_table" title="Special:MyLanguage/Manual:page table">page</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:pagelinks_table" title="Special:MyLanguage/Manual:pagelinks table">pagelinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:page_props_table" title="Special:MyLanguage/Manual:page props table">page_props</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:page_restrictions_table" title="Special:MyLanguage/Manual:page restrictions table">page_restrictions</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:protected_titles_table" title="Special:MyLanguage/Manual:protected titles table">protected_titles</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:querycache_table" title="Special:MyLanguage/Manual:querycache table">querycache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:querycachetwo_table" title="Special:MyLanguage/Manual:querycachetwo table">querycachetwo</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:querycache_info_table" title="Special:MyLanguage/Manual:querycache info table">querycache_info</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:recentchanges_table" title="Special:MyLanguage/Manual:recentchanges table">recentchanges</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:redirect_table" title="Special:MyLanguage/Manual:redirect table">redirect</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:revision_table" title="Special:MyLanguage/Manual:revision table">revision</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:searchindex_table" title="Special:MyLanguage/Manual:searchindex table">searchindex</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:sites_table" title="Special:MyLanguage/Manual:sites table">sites</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:site_identifiers_table" title="Special:MyLanguage/Manual:site identifiers table">site_identifiers</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:site_stats_table" title="Special:MyLanguage/Manual:site stats table">site_stats</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:slots_table" title="Special:MyLanguage/Manual:slots table">slots</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:slot_roles_table" title="Special:MyLanguage/Manual:slot roles table">slot_roles</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:templatelinks_table" title="Special:MyLanguage/Manual:templatelinks table">templatelinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:text_table" title="Special:MyLanguage/Manual:text table">text</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:updatelog_table" title="Special:MyLanguage/Manual:updatelog table">updatelog</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:uploadstash_table" title="Special:MyLanguage/Manual:uploadstash table">uploadstash</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_table" title="Special:MyLanguage/Manual:user table">user</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_autocreate_serial_table" title="Special:MyLanguage/Manual:user autocreate serial table">user_autocreate_serial</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_former_groups_table" title="Special:MyLanguage/Manual:user former groups table">user_former_groups</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_groups_table" title="Special:MyLanguage/Manual:user groups table">user_groups</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_newtalk_table" title="Special:MyLanguage/Manual:user newtalk table">user_newtalk</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_properties_table" title="Special:MyLanguage/Manual:user properties table">user_properties</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:watchlist_table" title="Special:MyLanguage/Manual:watchlist table">watchlist</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:watchlist_expiry_table" title="Special:MyLanguage/Manual:watchlist expiry table">watchlist_expiry</a></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Former</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:blobs_table" title="Special:MyLanguage/Manual:blobs table">blobs</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:brokenlinks_table" title="Special:MyLanguage/Manual:brokenlinks table">brokenlinks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:config_table" title="Special:MyLanguage/Manual:config table">config</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:cur_table" title="Special:MyLanguage/Manual:cur table">cur</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:external_user_table" title="Special:MyLanguage/Manual:external user table">external_user</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:hitcounter_table" title="Special:MyLanguage/Manual:hitcounter table">hitcounter</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:image_comment_temp_table" title="Special:MyLanguage/Manual:image comment temp table">image_comment_temp</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:ipblocks_old_table" title="Special:MyLanguage/Manual:ipblocks old table">ipblocks_old</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:links_table" title="Special:MyLanguage/Manual:links table">links</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:linkscc_table" title="Special:MyLanguage/Manual:linkscc table">linkscc</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:math_table" title="Special:MyLanguage/Manual:math table">math</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:msg_resource_table" title="Special:MyLanguage/Manual:msg resource table">msg_resource</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:msg_resource_links_table" title="Special:MyLanguage/Manual:msg resource links table">msg_resource_links</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:old_table" title="Special:MyLanguage/Manual:old table">old</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:profiling_table" title="Special:MyLanguage/Manual:profiling table">profiling</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:revision_actor_temp_table" title="Special:MyLanguage/Manual:revision actor temp table">revision_actor_temp</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:revision_comment_temp_table" title="Special:MyLanguage/Manual:revision comment temp table">revision_comment_temp</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:tag_summary_table" title="Special:MyLanguage/Manual:tag summary table">tag_summary</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:trackbacks_table" title="Special:MyLanguage/Manual:trackbacks table">trackbacks</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:transcache_table" title="Special:MyLanguage/Manual:transcache table">transcache</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:user_rights_table" title="Special:MyLanguage/Manual:user rights table">user_rights</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:valid_tag_table" title="Special:MyLanguage/Manual:valid tag table">valid_tag</a></li> <li><a href="/wiki/Special:MyLanguage/Manual:validate_table" title="Special:MyLanguage/Manual:validate table">validate</a></li></ul> </div></td></tr></tbody></table><div></div></td></tr></tbody></table></div> <div class="navbox-styles nomobile"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r6230902"></div><div role="navigation" class="navbox" aria-labelledby="Log_actions" style="padding:3px"><table class="nowraplinks hlist mw-collapsible autocollapse navbox-inner" style="border-spacing:0;background:transparent;color:inherit"><tbody><tr><th scope="col" class="navbox-title" colspan="2"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r6387430"><link rel="mw-deduplicated-inline-style" href="mw-data:TemplateStyles:r4692751"><div class="plainlinks hlist navbar mini"><ul><li class="nv-view"><a href="/wiki/Template:Log_events" title="Template:Log events"><abbr title="View this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">v</abbr></a></li><li class="nv-talk"><a href="/wiki/Template_talk:Log_events" title="Template talk:Log events"><abbr title="Discuss this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">t</abbr></a></li><li class="nv-edit"><a class="external text" href="https://www.mediawiki.org/w/index.php?title=Template:Log_events&action=edit"><abbr title="Edit this template" style=";;background:none transparent;border:none;box-shadow:none; padding:0;">e</abbr></a></li></ul></div><div id="Log_actions" style="font-size:114%;margin:0 4em"><a href="/wiki/Special:MyLanguage/Manual:Log_actions" title="Special:MyLanguage/Manual:Log actions">Log actions</a><span style="display:none"><a href="/wiki/Manual:Log_actions" title="Manual:Log actions"> </a></span></div></th></tr><tr><th scope="row" class="navbox-group" style="width:1%">Events</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Block_and_unblock" title="Special:MyLanguage/Manual:Block and unblock">Blocking</a><span style="display:none"><a href="/wiki/Manual:Block_and_unblock" title="Manual:Block and unblock"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Importing_revisions" title="Special:MyLanguage/Manual:Importing revisions">Importing</a><span style="display:none"><a href="/wiki/Manual:Importing_revisions" title="Manual:Importing revisions"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Merging_histories" title="Special:MyLanguage/Manual:Merging histories">Merging histories</a><span style="display:none"><a href="/wiki/Manual:Merging_histories" title="Manual:Merging histories"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Page_deletion" title="Special:MyLanguage/Manual:Page deletion">Page deletion</a><span style="display:none"><a href="/wiki/Manual:Page_deletion" title="Manual:Page deletion"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Page_moving" title="Special:MyLanguage/Manual:Page moving">Page moving</a><span style="display:none"><a href="/wiki/Manual:Page_moving" title="Manual:Page moving"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Page_undeletion" title="Special:MyLanguage/Manual:Page undeletion">Page undeletion</a><span style="display:none"><a href="/wiki/Manual:Page_undeletion" title="Manual:Page undeletion"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Patrolling" title="Special:MyLanguage/Manual:Patrolling">Patrolling</a><span style="display:none"><a href="/wiki/Manual:Patrolling" title="Manual:Patrolling"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Protection" title="Special:MyLanguage/Manual:Protection">Protection</a><span style="display:none"><a href="/wiki/Manual:Protection" title="Manual:Protection"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Renameuser" title="Special:MyLanguage/Manual:Renameuser">Renaming a user</a><span style="display:none"><a href="/wiki/Manual:Renameuser" title="Manual:Renameuser"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:RevisionDelete" title="Special:MyLanguage/Manual:RevisionDelete">RevisionDelete</a><span style="display:none"><a href="/wiki/Manual:RevisionDelete" title="Manual:RevisionDelete"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Extension:Thanks" title="Special:MyLanguage/Extension:Thanks">Thanking</a><span style="display:none"><a href="/wiki/Extension:Thanks" title="Extension:Thanks"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Uploading" title="Special:MyLanguage/Manual:Uploading">Uploading</a><span style="display:none"><a href="/wiki/Manual:Uploading" title="Manual:Uploading"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:User_creation" title="Special:MyLanguage/Manual:User creation">User creation</a><span style="display:none"><a href="/wiki/Manual:User_creation" title="Manual:User creation"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:User_rights" title="Special:MyLanguage/Manual:User rights">User rights management</a><span style="display:none"><a href="/wiki/Manual:User_rights" title="Manual:User rights"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Merging_users" title="Special:MyLanguage/Manual:Merging users">Merging users</a><span style="display:none"><a href="/wiki/Manual:Merging_users" class="mw-redirect" title="Manual:Merging users"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Settings</th><td class="navbox-list1 navbox-list navbox-even" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:$wgLogTypes" title="Special:MyLanguage/Manual:$wgLogTypes">$wgLogTypes</a><span style="display:none"><a href="/wiki/Manual:$wgLogTypes" title="Manual:$wgLogTypes"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:$wgLogActions" title="Special:MyLanguage/Manual:$wgLogActions">$wgLogActions</a><span style="display:none"><a href="/wiki/Manual:$wgLogActions" title="Manual:$wgLogActions"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:$wgLogNames" title="Special:MyLanguage/Manual:$wgLogNames">$wgLogNames</a><span style="display:none"><a href="/wiki/Manual:$wgLogNames" title="Manual:$wgLogNames"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:$wgLogHeaders" title="Special:MyLanguage/Manual:$wgLogHeaders">$wgLogHeaders</a><span style="display:none"><a href="/wiki/Manual:$wgLogHeaders" title="Manual:$wgLogHeaders"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:$wgLogActionsHandlers" title="Special:MyLanguage/Manual:$wgLogActionsHandlers">$wgLogActionsHandlers</a><span style="display:none"><a href="/wiki/Manual:$wgLogActionsHandlers" title="Manual:$wgLogActionsHandlers"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:$wgLogRestrictions" title="Special:MyLanguage/Manual:$wgLogRestrictions">$wgLogRestrictions</a><span style="display:none"><a href="/wiki/Manual:$wgLogRestrictions" title="Manual:$wgLogRestrictions"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:$wgFilterLogTypes" title="Special:MyLanguage/Manual:$wgFilterLogTypes">$wgFilterLogTypes</a><span style="display:none"><a href="/wiki/Manual:$wgFilterLogTypes" title="Manual:$wgFilterLogTypes"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:$wgActionFilteredLogs" title="Special:MyLanguage/Manual:$wgActionFilteredLogs">$wgActionFilteredLogs</a><span style="display:none"><a href="/wiki/Manual:$wgActionFilteredLogs" title="Manual:$wgActionFilteredLogs"> </a></span></li></ul> </div></td></tr><tr><th scope="row" class="navbox-group" style="width:1%">Miscellaneous</th><td class="navbox-list1 navbox-list navbox-odd" style="width:100%;padding:0px"><div style="padding:0em 0.25em"> <ul><li><a href="/wiki/Special:MyLanguage/Manual:Logging_to_Special:Log" title="Special:MyLanguage/Manual:Logging to Special:Log">Logging to Special:Log</a><span style="display:none"><a href="/wiki/Manual:Logging_to_Special:Log" title="Manual:Logging to Special:Log"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/API:Logevents" title="Special:MyLanguage/API:Logevents">API</a><span style="display:none"><a href="/wiki/API:Logevents" title="API:Logevents"> </a></span></li> <li><b><a href="/wiki/Special:MyLanguage/Manual:Logging_table" title="Special:MyLanguage/Manual:Logging table"><code>logging</code> table</a></b><span style="display:none"><a class="mw-selflink selflink"> </a></span></li> <li><a href="/wiki/Special:MyLanguage/Manual:Null_revision" title="Special:MyLanguage/Manual:Null revision">Null revision</a><span style="display:none"><a href="/wiki/Manual:Null_revision" title="Manual:Null revision"> </a></span></li></ul> </div></td></tr></tbody></table></div>    </div><noscript><img src="https://login.wikimedia.org/wiki/Special:CentralAutoLogin/start?type=1x1" alt="" width="1" height="1" style="border: none; position: absolute;"></noscript> <div class="printfooter" data-nosnippet="">Retrieved from "<a dir="ltr" href="https://www.mediawiki.org/w/index.php?title=Manual:Logging_table&oldid=6656377">https://www.mediawiki.org/w/index.php?title=Manual:Logging_table&oldid=6656377</a>"</div></div> <div id="catlinks" class="catlinks" data-mw="interface"><div id="mw-normal-catlinks" class="mw-normal-catlinks"><a href="/wiki/Special:Categories" title="Special:Categories">Categories</a>: <ul><li><a href="/wiki/Category:MediaWiki_database_tables" title="Category:MediaWiki database tables">MediaWiki database tables</a></li><li><a href="/wiki/Category:Log" title="Category:Log">Log</a></li></ul></div></div> </div> </main> </div> <div class="mw-footer-container"> <footer id="footer" class="mw-footer" > <ul id="footer-info"> <li id="footer-info-lastmod"> This page was last edited on 20 July 2024, at 19:03.</li> <li id="footer-info-copyright">Text is available under the <a rel="nofollow" class="external text" href="https://creativecommons.org/licenses/by-sa/4.0/deed.en">Creative Commons Attribution-ShareAlike License</a>; additional terms may apply. Text in <a class="external text" href="https://www.mediawiki.org/wiki/Special:MyLanguage/Help:Contents">the Help: namespace</a> is available under the <a rel="nofollow" class="external text" href="https://creativecommons.org/publicdomain/zero/1.0/">Creative Commons CC0 License</a>. By using this site, you agree to the <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Terms_of_Use">Terms of Use</a> and <a class="external text" href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy Policy</a>.</li> </ul> <ul id="footer-places"> <li id="footer-places-privacy"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Privacy_policy">Privacy policy</a></li> <li id="footer-places-about"><a href="/wiki/Project:About">About mediawiki.org</a></li> <li id="footer-places-disclaimers"><a href="/wiki/Project:General_disclaimer">Disclaimers</a></li> <li id="footer-places-wm-codeofconduct"><a href="https://www.mediawiki.org/wiki/Special:MyLanguage/Code_of_Conduct">Code of Conduct</a></li> <li id="footer-places-developers"><a href="https://developer.wikimedia.org">Developers</a></li> <li id="footer-places-statslink"><a href="https://stats.wikimedia.org/#/www.mediawiki.org">Statistics</a></li> <li id="footer-places-cookiestatement"><a href="https://foundation.wikimedia.org/wiki/Special:MyLanguage/Policy:Cookie_statement">Cookie statement</a></li> <li id="footer-places-mobileview"><a href="//m.mediawiki.org/w/index.php?title=Manual:Logging_table&mobileaction=toggle_view_mobile" class="noprint stopMobileRedirectToggle">Mobile view</a></li> </ul> <ul id="footer-icons" class="noprint"> <li id="footer-copyrightico"><a href="https://wikimediafoundation.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/static/images/footer/wikimedia-button.svg" width="84" height="29" alt="Wikimedia Foundation" loading="lazy"></a></li> <li id="footer-poweredbyico"><a href="https://www.mediawiki.org/" class="cdx-button cdx-button--fake-button cdx-button--size-large cdx-button--fake-button--enabled"><img src="/w/resources/assets/poweredby_mediawiki.svg" alt="Powered by MediaWiki" width="88" height="31" loading="lazy"></a></li> </ul> </footer> </div> </div> </div> <div class="vector-settings" id="p-dock-bottom"> <ul></ul> </div><script>(RLQ=window.RLQ||[]).push(function(){mw.config.set({"wgHostname":"mw-web.codfw.main-5cd4cd96d5-98kkn","wgBackendResponseTime":112,"wgPageParseReport":{"limitreport":{"cputime":"1.042","walltime":"1.357","ppvisitednodes":{"value":17786,"limit":1000000},"postexpandincludesize":{"value":151938,"limit":2097152},"templateargumentsize":{"value":27710,"limit":2097152},"expansiondepth":{"value":16,"limit":100},"expensivefunctioncount":{"value":33,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":89566,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 926.200 1 -total"," 71.27% 660.143 4 Template:Navbox"," 38.15% 353.358 1 Template:Databases"," 35.12% 325.283 346 Template:Translatable"," 33.58% 311.018 175 Template:Pagelang"," 29.13% 269.807 87 Template:Ll"," 20.57% 190.556 86 Template:Db_table"," 15.14% 140.227 25 Template:MW_version/layout"," 9.06% 83.931 1 Template:Database_layout"," 8.41% 77.927 1 Template:Log_events"]},"scribunto":{"limitreport-timeusage":{"value":"0.322","limit":"10.000"},"limitreport-memusage":{"value":2111236,"limit":52428800}},"cachereport":{"origin":"mw-web.codfw.canary-84f49d4ff-f95qb","timestamp":"20241030155921","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>