Manual:Text table/fr

La table text contient le code wiki des révisions individuelles des pages. Si vous utilisez Postgres ou Oracle, cette table s'appelle pagecontent. Les extensions peuvent également enregistrer des données ici.

Les noms des champs sont la transposition de ceux de la table des révisions en MediaWiki 1.4 et antérieur.

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). Ces colonnes de la table  ne seront plus jamais utilisées. 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.

Résumé du schéma
+---+--+--+-+-++ +---+--+--+-+-++ +---+--+--+-+-++
 * 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    |                |

old_id
Entier unique utilisé pour identifier chaque texte. It's referenced by the in  table. Before Multi-Content Revisions implementation, in  table and  in  table were keys to this column.

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

old_flags
Comma-separated list of flags. Contient les valeurs possibles suivantes :


 * {|class="wikitable"


 * | text est compressée avec la fonction  de PHP.
 * | Le texte a été enregistré en UTF-8.
 * | 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.
 * }

Extensions can add other custom flags.