Manual:image table

<!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:image 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":"93659e0d-b277-45ba-a211-acbefd2a577d","wgCanonicalNamespace":"Manual","wgCanonicalSpecialPageName":false,"wgNamespaceNumber":100,"wgPageName":"Manual:Image_table","wgTitle":"Image table","wgCurRevisionId":6773661,"wgRevisionId":6773661,"wgArticleId":10490,"wgIsArticle":true,"wgIsRedirect":false,"wgAction":"view","wgUserName":null,"wgUserGroups":["*"],"wgCategories":["MediaWiki database tables"],"wgPageViewLanguage":"en","wgPageContentLanguage":"en","wgPageContentModel":"wikitext","wgRelevantPageName":"Manual:Image_table","wgRelevantArticleId":10490,"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":40000,"wgTranslatePageTranslation":"source","wgCentralAuthMobileDomain":false,"wgEditSubmitButtonLabelPublish":true,"wgULSPosition":"personal","wgULSisCompactLinksEnabled":true,"wgVector2022LanguageInHeader":false,"wgULSisLanguageSelectorEmpty":false,"wgWikibaseItemId":"Q22803741","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=["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.4"> <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:image table - MediaWiki"> <meta property="og:type" content="website"> <link rel="alternate" media="only screen and (max-width: 640px)" href="//m.mediawiki.org/wiki/Manual:Image_table"> <link rel="alternate" type="application/x-wiki" title="Edit" href="/w/index.php?title=Manual:Image_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:Image_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_Image_table rootpage-Manual_Image_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/Q22803741#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/?utm_source=donate&utm_medium=sidebar&utm_campaign=spontaneous&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%3AImage+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%3AImage+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/?utm_source=donate&utm_medium=sidebar&utm_campaign=spontaneous&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%3AImage+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%3AImage+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-img_name" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_name"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.1</span> <span>img_name</span> </div> </a> <ul id="toc-img_name-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_size" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_size"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.2</span> <span>img_size</span> </div> </a> <ul id="toc-img_size-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_width" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_width"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.3</span> <span>img_width</span> </div> </a> <ul id="toc-img_width-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_height" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_height"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.4</span> <span>img_height</span> </div> </a> <ul id="toc-img_height-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_metadata" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_metadata"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.5</span> <span>img_metadata</span> </div> </a> <ul id="toc-img_metadata-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_bits" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_bits"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.6</span> <span>img_bits</span> </div> </a> <ul id="toc-img_bits-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_media_type" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_media_type"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.7</span> <span>img_media_type</span> </div> </a> <ul id="toc-img_media_type-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_major_mime" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_major_mime"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.8</span> <span>img_major_mime</span> </div> </a> <ul id="toc-img_major_mime-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_minor_mime" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_minor_mime"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.9</span> <span>img_minor_mime</span> </div> </a> <ul id="toc-img_minor_mime-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_description" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_description"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.10</span> <span>img_description</span> </div> </a> <ul id="toc-img_description-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_description_id" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_description_id"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.11</span> <span>img_description_id</span> </div> </a> <ul id="toc-img_description_id-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_user" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_user"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.12</span> <span>img_user</span> </div> </a> <ul id="toc-img_user-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_user_text" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_user_text"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.13</span> <span>img_user_text</span> </div> </a> <ul id="toc-img_user_text-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_actor" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_actor"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.14</span> <span>img_actor</span> </div> </a> <ul id="toc-img_actor-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_timestamp" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_timestamp"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.15</span> <span>img_timestamp</span> </div> </a> <ul id="toc-img_timestamp-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_sha1" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_sha1"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.16</span> <span>img_sha1</span> </div> </a> <ul id="toc-img_sha1-sublist" class="vector-toc-list"> </ul> </li> <li id="toc-img_type" class="vector-toc-list-item vector-toc-level-2"> <a class="vector-toc-link" href="#img_type"> <div class="vector-toc-text"> <span class="vector-toc-numb">1.17</span> <span>img_type</span> </div> </a> <ul id="toc-img_type-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> </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:image 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:Image_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:Image_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:Image_table"><span>Read</span></a></li><li id="ca-edit" class="vector-tab-noicon mw-list-item"><a href="/w/index.php?title=Manual:Image_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:Image_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:Image_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:Image_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:Image_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:Image_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:Image_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:Image_table&oldid=6773661" 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:Image_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%3AImage_table&id=6773661&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%3AImage_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%3AImage_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%3AImage+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%3AImage_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:Image_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/Q22803741" 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%3AImage+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:Image_table/de" class="mw-pt-progress mw-pt-progress--med" title="Handbuch:image-Tabelle (33% 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:Image_table/es" class="mw-pt-progress mw-pt-progress--med" title="Manual:Image table/es (24% translated)" lang="es" dir="ltr">español</a></li> <li><a href="/wiki/Manual:Image_table/fr" class="mw-pt-progress mw-pt-progress--complete" title="Manuel:table image (100% translated)" lang="fr" dir="ltr">français</a></li> <li><a href="/wiki/Manual:Image_table/pl" class="mw-pt-progress mw-pt-progress--med" title="Podręcznik:Tabela image (24% translated)" lang="pl" dir="ltr">polski</a></li> <li><a href="/wiki/Manual:Image_table/cs" class="mw-pt-progress mw-pt-progress--complete" title="Příručka:Databázová tabulka image (100% translated)" lang="cs" dir="ltr">čeština</a></li> <li><a href="/wiki/Manual:Image_table/zh" class="mw-pt-progress mw-pt-progress--med" title="手册：手册：图像表 (27% translated)" lang="zh" dir="ltr">中文</a></li> <li><a href="/wiki/Manual:Image_table/ja" class="mw-pt-progress mw-pt-progress--med" title="Manual:image テーブル (39% 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">image 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> <p>The <b>image</b> table describes <a href="/wiki/Special:MyLanguage/Help:Images" title="Special:MyLanguage/Help:Images">images and other uploaded files</a>. However, the image description pages are stored like other pages. See also: <a href="/wiki/Special:MyLanguage/Manual:Image_Administration" title="Special:MyLanguage/Manual:Image Administration">Image Administration</a>. Many of the fields in this table are analogous to those in the <a href="/wiki/Special:MyLanguage/Manual:Oldimage_table" title="Special:MyLanguage/Manual:Oldimage table">oldimage</a><span style="display:none"><a href="/wiki/Manual:Oldimage_table" title="Manual:Oldimage table"> </a></span> table. <i>Some of this information was adapted from <code>schema.doc</code> in the MediaWiki <code>docs/</code> directory.</i> </p><p>The path for the actual image is not stored in this table: see <a href="/wiki/Special:MyLanguage/Manual:$wgHashedUploadDirectory" title="Special:MyLanguage/Manual:$wgHashedUploadDirectory">$wgHashedUploadDirectory</a><span style="display:none"><a href="/wiki/Manual:$wgHashedUploadDirectory" title="Manual:$wgHashedUploadDirectory"> </a></span>. </p> <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:Image_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="img_name">img_name</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=2" title="Edit section: img_name"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Filename using underscores. </p> <div class="mw-heading mw-heading3"><h3 id="img_size">img_size</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=3" title="Edit section: img_size"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>File size in bytes. </p> <div class="mw-heading mw-heading3"><h3 id="img_width">img_width</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=4" title="Edit section: img_width"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></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.5</div></td> </tr></tbody></table> <p>Image width, in pixels. </p> <div class="mw-heading mw-heading3"><h3 id="img_height">img_height</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=5" title="Edit section: img_height"><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>Image height, in pixels. </p> <div class="mw-heading mw-heading3"><h3 id="img_metadata">img_metadata</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=6" title="Edit section: img_metadata"><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>Serialized file's properties, as PHP array serialization or as JSON. The json array can contain an address in the <code>text</code> table or external storage. <code>0</code>, <code>-1</code> or blank if the extractor fail. <a href="https://phabricator.wikimedia.org/T155741" class="extiw" title="phab:T155741">T155741</a> </p> <div class="mw-heading mw-heading3"><h3 id="img_bits">img_bits</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=7" title="Edit section: img_bits"><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>Bit-depth of GIF/PNG palette-based images (up to 8-bit). Non-palette images (JPEG/PNG/TIFF/SVG) are 0, 8, or 16. All other files default to 0. </p> <div class="mw-heading mw-heading3"><h3 id="img_media_type">img_media_type</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=8" title="Edit section: img_media_type"><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>Possibilities are: UNKNOWN, BITMAP, DRAWING, AUDIO, VIDEO, MULTIMEDIA, OFFICE, TEXT, EXECUTABLE, ARCHIVE, 3D </p> <div class="mw-heading mw-heading3"><h3 id="img_major_mime">img_major_mime</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=9" title="Edit section: img_major_mime"><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>Possibilities are: unknown, application, audio, chemical, image, message, model, multipart, text, video </p> <div class="mw-heading mw-heading3"><h3 id="img_minor_mime">img_minor_mime</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=10" title="Edit section: img_minor_mime"><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>E.g. jpeg, gif, png, svg+xml, tiff, ogg, pdf vnd.djvu, webm, wav, mpeg, x-flac, midi, x-xcf, sla, webp, etc. </p> <div class="mw-heading mw-heading3"><h3 id="img_description">img_description</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=11" title="Edit section: img_description"><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>Description field given during upload. It's not the description page (associated File: wiki page), but the "summary" provided by the user in case of reupload. </p><p><span style="color:#d33">(deprecated)</span>; <a href="/wiki/Special:MyLanguage/Manual:image_comment_temp_table#imgcomment_description_id" title="Special:MyLanguage/Manual:image comment temp table">imgcomment_description_id</a><span style="display:none"><a href="/wiki/Manual:Image_comment_temp_table#imgcomment_description_id" title="Manual:Image comment temp table"> </a></span> of the <code>image_comment_temp</code> table and the <code>comment</code> table should be used instead! </p> <div class="mw-heading mw-heading3"><h3 id="img_description_id">img_description_id</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=12" title="Edit section: img_description_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="img_user">img_user</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=13" title="Edit section: img_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><a href="/wiki/Special:MyLanguage/Manual:User_table#user_id" title="Special:MyLanguage/Manual:User table">User ID</a> of the user who uploaded the file. </p><p><span style="color:#d33">(deprecated in 1.31)</span> While <a href="/wiki/Special:MyLanguage/actor_migration" title="Special:MyLanguage/actor migration">Actor migration</a><span style="display:none"><a href="/wiki/Actor_migration" title="Actor migration"> </a></span> is being done, and depending on the configuration setting <code><a href="/wiki/Special:MyLanguage/Manual:$wgActorTableSchemaMigrationStage" title="Special:MyLanguage/Manual:$wgActorTableSchemaMigrationStage">$wgActorTableSchemaMigrationStage</a><span style="display:none"><a href="/wiki/Manual:$wgActorTableSchemaMigrationStage" title="Manual:$wgActorTableSchemaMigrationStage"> </a></span></code>, this field may be empty and the actor performing the edit can be stored in the <a href="#img_actor">img_actor</a> field instead. </p> <div class="mw-heading mw-heading3"><h3 id="img_user_text">img_user_text</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=14" title="Edit section: img_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"><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><a href="/wiki/Special:MyLanguage/Manual:User_table#user_name" title="Special:MyLanguage/Manual:User table">User name</a> of the user who uploaded the file. </p><p><span style="color:#d33">(deprecated in 1.31)</span> While <a href="/wiki/Special:MyLanguage/actor_migration" title="Special:MyLanguage/actor migration">Actor migration</a><span style="display:none"><a href="/wiki/Actor_migration" title="Actor migration"> </a></span> is being done, and depending on the configuration setting <code><a href="/wiki/Special:MyLanguage/Manual:$wgActorTableSchemaMigrationStage" title="Special:MyLanguage/Manual:$wgActorTableSchemaMigrationStage">$wgActorTableSchemaMigrationStage</a><span style="display:none"><a href="/wiki/Manual:$wgActorTableSchemaMigrationStage" title="Manual:$wgActorTableSchemaMigrationStage"> </a></span></code>, this field may be empty and the actor performing the edit can be stored in the <a href="#img_actor">img_actor</a> field instead. </p> <div class="mw-heading mw-heading3"><h3 id="img_actor">img_actor</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=15" title="Edit section: img_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></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 and specifies the actor who uploaded the most recent version of the image. </p> <div class="mw-heading mw-heading3"><h3 id="img_timestamp">img_timestamp</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=16" title="Edit section: img_timestamp"><span>edit</span></a><span class="mw-editsection-bracket">]</span></span></div> <p>Timestamp of when upload took place. Not necessarily the same timestamp as <a href="/wiki/Special:MyLanguage/Manual:logging_table#log_timestamp" title="Special:MyLanguage/Manual:logging table">logging.log_timestamp</a>. </p><p>Except for image revisions imported from another wiki, the timestamp uniquely identifies the file revision. If two uploads of the same file happen in the same second, the latter one is delayed until it gets a different timestamp. </p> <div class="mw-heading mw-heading3"><h3 id="img_sha1">img_sha1</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=17" title="Edit section: img_sha1"><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.11</div></td> </tr></tbody></table> <p>The <a href="/wiki/Special:MyLanguage/SHA-1" title="Special:MyLanguage/SHA-1">SHA-1</a> hash of the file contents in base 36 format. <code>Wikimedia\base_convert()</code> is used to convert from base 16 (hexadecimal) to base 36 and then pad the result to 31 characters. </p> <div class="mw-heading mw-heading3"><h3 id="img_type">img_type</h3><span class="mw-editsection"><span class="mw-editsection-bracket">[</span><a href="/w/index.php?title=Manual:Image_table&action=edit&section=18" title="Edit section: img_type"><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.4 is an unsupported version"><div class="mw-version-versionnumber"><small>≤</small> 1.4</div></td> </tr></tbody></table> <div style="clear: both;"></div> <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:Image_table&action=edit&section=19" 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-legacy 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.41</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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | | | | img_size | bigint(20) unsigned | NO | MUL | 0 | | | img_width | int(11) | NO | | 0 | | | img_height | int(11) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(11) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description_id | bigint(20) unsigned | NO | | NULL | | | img_actor | bigint(20) unsigned | NO | MUL | NULL | | | img_timestamp | binary(14) | NO | MUL | NULL | | | img_sha1 | varbinary(32) | NO | MUL | | | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ </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.40 is an unsupported version"><div class="mw-version-versionnumber"> 1.36 – 1.40</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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | | | | img_size | int(10) unsigned | NO | MUL | 0 | | | img_width | int(11) | NO | | 0 | | | img_height | int(11) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(11) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description_id | bigint(20) unsigned | NO | | NULL | | | img_actor | bigint(20) unsigned | NO | MUL | NULL | | | img_timestamp | binary(14) | NO | MUL | NULL | | | img_sha1 | varbinary(32) | NO | MUL | | | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ </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.35 is an unsupported version"><div class="mw-version-versionnumber"> 1.34 – 1.35</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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | | | | img_size | int(10) unsigned | NO | MUL | 0 | | | img_width | int(11) | NO | | 0 | | | img_height | int(11) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(11) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description_id | bigint(20) unsigned | NO | | NULL | | | img_actor | bigint(20) unsigned | NO | MUL | NULL | | | img_timestamp | varbinary(14) | NO | MUL | | | | img_sha1 | varbinary(32) | NO | MUL | | | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ </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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | | | | img_size | int(10) unsigned | NO | MUL | 0 | | | img_width | int(11) | NO | | 0 | | | img_height | int(11) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(11) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description_id | bigint(20) unsigned | NO | | NULL | | | img_user | int(10) unsigned | NO | MUL | 0 | | | img_user_text | varbinary(255) | NO | MUL | | | | img_actor | bigint(20) unsigned | NO | MUL | 0 | | | img_timestamp | varbinary(14) | NO | MUL | | | | img_sha1 | varbinary(32) | NO | MUL | | | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ </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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | | | | img_size | int(10) unsigned | NO | MUL | 0 | | | img_width | int(11) | NO | | 0 | | | img_height | int(11) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(11) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description | varbinary(767) | NO | | | | | img_description_id | bigint(20) unsigned | NO | | 0 | | | img_user | int(10) unsigned | NO | MUL | 0 | | | img_user_text | varbinary(255) | NO | MUL | | | | img_actor | bigint(20) unsigned | NO | MUL | 0 | | | img_timestamp | varbinary(14) | NO | MUL | | | | img_sha1 | varbinary(32) | NO | MUL | | | +--------------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ </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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | | | | img_size | int(10) unsigned | NO | MUL | 0 | | | img_width | int(11) | NO | | 0 | | | img_height | int(11) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(11) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE','3D') | YES | MUL | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description | varbinary(767) | NO | | | | | img_user | int(10) unsigned | NO | MUL | 0 | | | img_user_text | varbinary(255) | NO | MUL | NULL | | | img_timestamp | varbinary(14) | NO | MUL | | | | img_sha1 | varbinary(32) | NO | MUL | | | +-----------------+-------------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ </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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | | | | img_size | int(10) unsigned | NO | MUL | 0 | | | img_width | int(11) | NO | | 0 | | | img_height | int(11) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(11) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | MUL | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description | varbinary(767) | NO | | NULL | | | img_user | int(10) unsigned | NO | MUL | 0 | | | img_user_text | varbinary(255) | NO | MUL | NULL | | | img_timestamp | varbinary(14) | NO | MUL | | | | img_sha1 | varbinary(32) | NO | MUL | | | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ </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.24 is an unsupported version"><div class="mw-version-versionnumber"> 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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_width | int(5) | NO | | 0 | | | img_height | int(5) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(3) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart','chemical') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) binary | NO | | NULL | | | img_timestamp | varbinary(14) | NO | MUL | NULL | | | img_sha1 | varbinary(32) | 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 mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.23 is an unsupported version"><div class="mw-version-versionnumber"> 1.16 – 1.23</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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_width | int(5) | NO | | 0 | | | img_height | int(5) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(3) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | | | img_minor_mime | varbinary(100) | NO | | unknown | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) binary | NO | | NULL | | | img_timestamp | varbinary(14) | NO | MUL | NULL | | | img_sha1 | varbinary(32) | 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 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.11 – 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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_width | int(5) | NO | | 0 | | | img_height | int(5) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(3) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | | | img_minor_mime | varbinary(32) | NO | | unknown | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) binary | NO | | NULL | | | img_timestamp | varbinary(14) | NO | MUL | NULL | | | img_sha1 | varbinary(32) | 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.10 is an unsupported version"><div class="mw-version-versionnumber"> 1.10</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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varbinary(255) | NO | PRI | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_width | int(5) | NO | | 0 | | | img_height | int(5) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(3) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | | | img_minor_mime | varbinary(32) | NO | | unknown | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) binary | NO | | NULL | | | img_timestamp | varbinary(14) | NO | MUL | 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 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.5 – 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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+--------------------------------------------------------------------------------------------------------+------+-----+---------+-------+ | img_name | varchar(255) binary | NO | PRI | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_width | int(5) | NO | | 0 | | | img_height | int(5) | NO | | 0 | | | img_metadata | mediumblob | NO | | NULL | | | img_bits | int(3) | NO | | 0 | | | img_media_type | enum('UNKNOWN','BITMAP','DRAWING','AUDIO','VIDEO','MULTIMEDIA','OFFICE','TEXT','EXECUTABLE','ARCHIVE') | YES | | NULL | | | img_major_mime | enum('unknown','application','audio','image','text','video','message','model','multipart') | NO | | unknown | | | img_minor_mime | varchar(32) binary | NO | | unknown | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) binary | NO | | NULL | | | img_timestamp | char(14) binary | NO | MUL | 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 mw-version-version2 mw-version-version2-unsupported"><tbody><tr> <td>MediaWiki versions:</td> <td class="mw-version-versionbox" title="MediaWiki 1.4 is an unsupported version"><div class="mw-version-versionnumber"> 1.1 – 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">image</span><span class="p">;</span></code> </p> <pre style="overflow-x: scroll; white-space: pre;">+-----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +-----------------+---------------------+------+-----+---------+-------+ | img_name | varchar(255) binary | NO | MUL | NULL | | | img_size | int(8) unsigned | NO | MUL | 0 | | | img_description | tinyblob | NO | | NULL | | | img_user | int(5) unsigned | NO | | 0 | | | img_user_text | varchar(255) binary | NO | | NULL | | | img_timestamp | char(14) binary | NO | MUL | 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:Image_table&action=edit&section=20" 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.34</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">image</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 | +-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ | image | 0 | PRIMARY | 1 | img_name | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_actor_timestamp | 1 | img_actor | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_actor_timestamp | 2 | img_timestamp | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_size | 1 | img_size | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_timestamp | 1 | img_timestamp | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_sha1 | 1 | img_sha1 | A | 0 | 10 | NULL | | BTREE | | | | image | 1 | img_media_mime | 1 | img_media_type | A | 0 | NULL | NULL | YES | BTREE | | | | image | 1 | img_media_mime | 2 | img_major_mime | A | 0 | NULL | NULL | | BTREE | | | | image | 1 | img_media_mime | 3 | img_minor_mime | A | 0 | NULL | NULL | | BTREE | | | +-------+------------+---------------------+--------------+----------------+-----------+-------------+----------+--------+------+------------+---------+---------------+ </pre> <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><b><a href="/wiki/Special:MyLanguage/Manual:image_table" title="Special:MyLanguage/Manual:image table">image</a></b></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><a href="/wiki/Special:MyLanguage/Manual:logging_table" title="Special:MyLanguage/Manual:logging table">logging</a></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><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:Image_table&oldid=6773661">https://www.mediawiki.org/w/index.php?title=Manual:Image_table&oldid=6773661</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">Category</a>: <ul><li><a href="/wiki/Category:MediaWiki_database_tables" title="Category:MediaWiki database tables">MediaWiki database tables</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 27 September 2024, at 14:07.</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:Image_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-f69cdc8f6-7vj76","wgBackendResponseTime":148,"wgPageParseReport":{"limitreport":{"cputime":"0.611","walltime":"0.754","ppvisitednodes":{"value":15857,"limit":1000000},"postexpandincludesize":{"value":119578,"limit":2097152},"templateargumentsize":{"value":17803,"limit":2097152},"expansiondepth":{"value":16,"limit":100},"expensivefunctioncount":{"value":17,"limit":500},"unstrip-depth":{"value":0,"limit":20},"unstrip-size":{"value":106289,"limit":5000000},"entityaccesscount":{"value":0,"limit":400},"timingprofile":["100.00% 515.650 1 -total"," 81.25% 418.977 3 Template:Navbox"," 48.63% 250.750 1 Template:Databases"," 30.69% 158.243 236 Template:Translatable"," 29.32% 151.196 120 Template:Pagelang"," 26.09% 134.534 83 Template:Db_table"," 19.68% 101.479 28 Template:MW_version/layout"," 18.14% 93.534 35 Template:Ll"," 12.36% 63.715 11 Template:MW_version/en"," 12.10% 62.414 7 Template:MW_1.5"]},"scribunto":{"limitreport-timeusage":{"value":"0.173","limit":"10.000"},"limitreport-memusage":{"value":1736186,"limit":52428800}},"cachereport":{"origin":"mw-web.eqiad.main-794d77dd7f-7sjgs","timestamp":"20241030005459","ttl":2592000,"transientcontent":false}}});});</script> </body> </html>

CINXE.COM

Manual:image table - MediaWiki