Manual:Database layout/pt-br

Schema redirects here; for information about the Schema: namespace, see Extension:EventLoggingExtension:EventLogging.

Tables redirects here; for information about wikitext table syntax, see Help:TabelasHelp:Tables.

↑ Manual:ConteúdosManual:Contents

Layout do banco de dados MediaWikiManual:Database layout

database layout/pt-br

View database schema →

(file description page)

The SQL code that creates the MySQL/MariaDBManual:MySQL core tables for any MediaWiki version—with extensive comments—is in the maintenance/tables.sql source file. The most important tables are probably pageManual:page table, revisionManual:revision table, textManual:text table and userManual:user table.

Histórico de versões

The following table depicts the range of MediaWiki versions over which each table has existed in the schema. Red rows indicate tables that are no longer used by the core nor added by the installer as of a particular version. They might however still be used by extensions. Note, table headings are repeated every 10 rows for clarity.

1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master
archiveManual:archive table
	blobsManual:blobs table
																									bot_passwordsManual:bot_passwords table
brokenlinksManual:brokenlinks table
											categoryManual:category table
	categorylinksManual:categorylinks table
													change_tagManual:change_tag table
																												commentManual:comment table
curManual:cur table
				externallinksManual:externallinks table
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master
														external_userManual:external_user table
					filearchiveManual:filearchive table
hitcounterManual:hitcounter table
imageManual:image table
																												image_comment_tempManual:image_comment_temp table
interwikiManual:interwiki table
																												ip_changesManual:ip_changes table
ipblocksManual:ipblocks table
				ipblocks_old
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master
															iwlinksManual:iwlinks table
				jobManual:job table
														l10n_cacheManual:l10n_cache table
					langlinksManual:langlinks table
linksManual:links table
linksccManual:linkscc table
		loggingManual:logging table
														log_searchManual:log_search table
mathManual:math table
															module_depsManual:module_deps table
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master
															msg_resourceManual:msg_resource table
															msg_resource_linksManual:msg_resource_links table
	objectcacheManual:objectcache table
oldManual:old table
oldimageManual:oldimage table
			pageManual:page table
			pagelinksManual:pagelinks table
											page_propsManual:page_props table
								page_restrictionsManual:page_restrictions table
										protected_titlesManual:protected_titles table
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master
	querycacheManual:querycache table
							querycachetwoManual:querycachetwo table
					querycache_infoManual:querycache_info table
			recentchangesManual:recentchanges table
							redirectManual:redirect table
			revisionManual:revision table
			revision_comment_tempManual:revision_comment_temp table
searchindexManual:searchindex table
																			sitesManual:sites table
																			site_identifiersManual:site_identifiers table
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master
site_statsManual:site_stats table
													tag_summaryManual:tag summary table
				templatelinksManual:templatelinks table
			textManual:text table
			trackbacksManual:trackbacks table
			transcacheManual:transcache table
											updatelogManual:updatelog table
																uploadstashManual:uploadstash table
userManual:user table
																user_former_groupsManual:user_former_groups table
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master
			user_groupsManual:user_groups table
user_newtalkManual:user_newtalk table
														user_propertiesManual:user_properties table
		user_rightsManual:user_rights table
													valid_tagManual:valid tag table
		validateManual:validate table
watchlistManual:watchlist table
1.2	1.3	1.4	1.5	1.6	1.7	1.8	1.9	1.10	1.11	1.12	1.13	1.14	1.15	1.16	1.17	1.18	1.19	1.20	1.21	1.22	1.23	1.24	1.25	1.26	1.27	1.28	1.29	1.30	1.31	master

Sistemas de gerenciamento de banco de dados

See the latest MariaDB/MySQL-compatible version from Git: maintenance/tables.sql.

If using PostgreSQLManual:PostgreSQL, the file maintenance/postgres/tables.sql should be viewed instead.

If using Microsoft SQL Server, see maintenance/mssql/tables.sql.

If using Oracle, see maintenance/oracle/tables.sql.

Ver também

• Manual:Acesso ao banco de dadosManual:Database access
• Proposed Database Schema ChangesProposed Database Schema Changes
• Database field prefixesDatabase field prefixes
• w:Wikipedia:Database queries
• Central do DesenvolvedorDeveloper hub
• Records of edits in the database
• A research on MediaWiki DB schema evolution
• the /diagram subpage documents the procedure to update the diagram

Bancos de dadosManual:Database layout

Gerenciadores: MySQL/MariaDBManual:MySQL – OracleManual:Oracle – PostgreSQLManual:PostgreSQL – SQLiteManual:SQLite – SQL ServerManual:Microsoft SQL Server Documentação técnica: EsquemaManual:Database layout (tabelasCategory:MediaWiki database tables) – Associações de propriedades da APIAPI:Database field and API property associations – Prefixos de campoDatabase field prefixes – Primary key storage in other fieldsManual:Primary key storage in other fields – Tabelas de extensões da WikimediaCategory:Wikimedia extension database tables Configuração: DefiniçõesManual:Configuration_settings#Database_settings – CompartilhamentoManual:Shared database Desenvolvimento: AcessoManual:Database access – OtimizaçãoDatabase optimization – PolíticasDevelopment policy#Database_patches – AtualizaçãoManual:DatabaseUpdater.php – Atualizações de esquemas de extensõesManual:Hooks/LoadExtensionSchemaUpdates – Arquivo de correçãoManual:SQL patch file Tabelas de núcleo: actor – archive – bot_passwords – category – categorylinks – change_tag – comment – config – externallinks – filearchive – hitcounter – image – imagelinks – image_comment_temp – interwiki – iwlinks – ipblocks – ip_changes – job – l10n_cache – langlinks – logging – log_search – msg_resource – msg_resource_links – module_deps – objectcache – oldimage – page – pagelinks – page_props – page_restrictions – protected_titles – querycache – querycachetwo – querycache_info – recentchanges – redirect – revision – revision_comment_temp – searchindex – sites – site_identifiers – site_stats – tag_summary – templatelinks – text – transcache – updatelog – uploadstash – user – user_former_groups – user_groups – user_newtalk – user_properties – tag_summary – valid_tag – watchlist