Manual:Text table/de

Die text-Tabelle enthält Metadaten für jede Bearbeitung, die an einer Seite innerhalb des Wikis vorgenommen wurde. If using Postgres or Oracle, this table is named pagecontent. können hier ebenfalls Daten speichern.

Field names are a holdover from the revisions table in MediaWiki 1.4 and earlier.

If you updated your wiki from MediaWiki 1.4 or older to a newer version, and if you have then run update.php at least once, you will still have old columns in the text table, whose contents have been migrated to the ' table and the ' table (content is copied, not cut). These columns in the text table will not be used anymore. All fields in the text table except old_id, old_text and old_flags are not needed anymore and can be safely deleted.

Text content can be compressed or stored externally, and thus difficult to get from this table. The maintenance script can be used to retrieve the text of a given.

Extensions can add other custom flags.

This table can also hold metadata of files if the metadata is too big to store in img_metadata, oi_metadata or fa_metadata.

old_id
Eindeutige Ganzzahl, die zur Identifizierung jedes Textes verwendet wird. Es wird durch den in der -Tabelle referenziert. Before Multi-Content Revisions implementation, in  table and  in  table were keys to this column.

Also img_metadata, oi_metadata or fa_metadata can refer to this column when being used to store file metadata.

old_text
The wikitext of the page, or a pointer to external storage of the form of.

old_flags
Comma-separated list of flags. Contains the following possible values:


 * {|class="wikitable"


 * | Text is compressed with PHP's  function.
 * | Der Text wurde als UTF-8 gespeichert.
 * | Text field contained a serialized PHP object.
 * | Text was stored in an external location specified by old_text.
 * }
 * | Text field contained a serialized PHP object.
 * | Text was stored in an external location specified by old_text.
 * }
 * | Text was stored in an external location specified by old_text.
 * }
 * | Text was stored in an external location specified by old_text.
 * }

Schematische Übersicht
+---+--+--+-+-++ +---+--+--+-+-++ +---+--+--+-+-++
 * Field    | Type             | Null | Key | Default | Extra          |
 * old_id   | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
 * old_text | mediumblob       | NO   |     | NULL    |                |
 * old_flags | tinyblob        | NO   |     | NULL    |                |

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * Field    | Type            | Null | Key | Default | Extra          |
 * old_id   | int(8) unsigned | NO   | PRI | NULL    | AUTO_INCREMENT |
 * old_text | mediumblob      | NO   |     | NULL    |                |
 * old_flags | tinyblob       | NO   |     | NULL    |                |

Indexe
 +---++--+--+-+---+-+--++--++-+---+ +---++--+--+-+---+-+--++--++-+---+ +---++--+--+-+---+-+--++--++-+---+
 * Table | Non_unique | Key_name | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * text |          0 | PRIMARY  |            1 | old_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |