Manual:Database layout/de

From MediaWiki.org
Jump to: navigation, search
This page is a translated version of the page Manual:Database layout and the translation is 20% complete.

Outdated translations are marked like this.
Other languages:
العربية • ‎Deutsch • ‎English • ‎español • ‎suomi • ‎français • ‎Bahasa Indonesia • ‎italiano • ‎日本語 • ‎lietuvių • ‎Nederlands • ‎polski • ‎português • ‎português do Brasil • ‎русский • ‎slovenčina • ‎українська • ‎中文
Schema redirects here; for information about the Schema: namespace, see Extension:EventLoggingExtension:EventLogging.
Tables redirects here; for information about wikitext table syntax, see Help:Tables/deHelp:Tables.


Manual:ContentsManual:Contents MediaWiki database layoutManual:Database layout database layout/de


(file description page)

Das aktuelle MySQL-Diagramm für jede MediaWiki-Version—mit ausführlichen Kommentaren—kann in der maintenance/tables.sql Datei gefunden werden. Sehen Sie sich die neueste Version aus SVN: maintenance/tables.sql an. Bei Verwendung von Postgres, sollte stattdessen die maintenance/postgres/tables.sql betrachtet werden. Die wichtigsten Tabellen sind wahrscheinlich page, revision, pagelinks und text.

Versionsgeschichte[edit]

Die folgende Tabelle zeigt die Bandbreite der MediaWiki-Versionen, über die jede Tabelle im Diagramm existierte. Rote Reihen zeigen Tabellen, die in einer bestimmten Version gelöscht wurden. Beachten Sie, Tabellenüberschriften werden alle 10 Zeilen für Klarheit wiederholt.

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 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
curManual:cur table  
  externallinksManual:externallinks table
  external_userManual:external_user 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 master
  filearchiveManual:filearchive table
hitcounterManual:hitcounter table  
imageManual:image table
imagelinksManual:imagelinks table
interwikiManual:interwiki table
ipblocksManual:ipblocks table
  ipblocks_old  
  iwlinksManual:iwlinks table
  jobManual:job table
  l10n_cacheManual:l10n_cache 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 master
  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
  msg_resourceManual:msg_resource table  
  objectcacheManual:objectcache table
  objectcacheManual:objectcache 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 master
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
  querycacheManual:querycache table
  querycachetwoManual:querycachetwo table
  querycache_infoManual:querycache_info 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 master
  recentchangesManual:recentchanges table
  redirectManual:redirect table
  revisionManual:revision table
searchindexManual:searchindex table
  sitesManual:sites table
  site_identifiersManual:site_identifiers table
site_statsManual:site_stats table
  tag_summaryManual:tag summary table
  templatelinksManual:templatelinks table
  textManual:text 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 master
  trackbacksManual:trackbacks table  
  transcacheManual:transcache table
  updatelogManual:updatelog table
  uploadstashManual:uploadstash table
userManual:user table
  user_former_groupsManual:user_former_groups table
  user_groupsManual:user_groups table
user_newtalkManual:user_newtalk table
  user_propertiesManual:user_properties table
  user_rightsManual:user_rights 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 master
  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 master

Database management systems[edit]

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.

Siehe auch[edit]

DatenbankenManual:Database layout Enginen: MySQL/MariaDBManual:MySQLOracleManual:OraclePostgreSQLManual:PostgreSQLSQLiteManual:SQLiteSQL ServerManual:Microsoft SQL Server

Technische Dokumentation: SchemaManual:Database layout (TabellenCategory:MediaWiki database tables) – API EigenschaftsassoziationenAPI:Database field and API property associationsFeldpräfixeDatabase field prefixesPrimary key storage in other fieldsManual:Primary key storage in other fieldsWikimedia extension tablesCategory:Wikimedia extension database tables
Konfiguration: EinstellungenManual:Configuration_settings#Database_settingsSharingManual:Shared database
Entwicklung: AccessManual:Database accessOptimizationDatabase optimizationPolicyDevelopment policy#Database_patchesUpdaterManual:DatabaseUpdater.phpSchema-AktualisierungenManual:Hooks/LoadExtensionSchemaUpdatesPatchdateiManual:SQL patch file

Kerntabellen: archivebot_passwordscategorycategorylinkschange_tagcommentconfigexternallinksfilearchivehitcounterimageimagelinksimage_comment_tempinterwikiiwlinksipblocksip_changesjobl10n_cachelanglinkslogginglog_searchmsg_resourcemsg_resource_linksmodule_depsobjectcacheoldimagepagepagelinkspage_propspage_restrictionsprotected_titlesquerycachequerycachetwoquerycache_inforecentchangesredirectrevisionrevision_comment_tempsearchindexsitessite_identifiers - site_statstag_summarytemplatelinkstexttranscacheupdateloguploadstashuseruser_former_groupsuser_groupsuser_newtalkuser_propertiestag_summaryvalid_tagwatchlist