Manual:Text table

The text table holds the wikitext of individual page revisions. If using Postgres or Oracle, this table is named pagecontent.  may also store data here.

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 man>Special:MyLanguage/Manual:External Storage|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.

old_id
Unique integer used to identify each text. It's referenced by the  in </> table. Before 1>Special:MyLanguage/Multi-Content Revisions</>|Multi-Content Revisions implementation, <tvar|2></> in <tvar|3></> table and <tvar|4></> in <tvar|5></> table were keys to this column.

old_text
The wikitext of the page, or a pointer to 1>Special:MyLanguage/Manual:External Storage</>|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 <tvar|gzdeflate> </> function.
 * | Text was stored as UTF-8.
 * | Text field contained a serialized PHP object.
 * | Text was stored in an man>Special:MyLanguage/Manual:External Storage</>|external location specified by old_text.
 * }
 * | Text field contained a serialized PHP object.
 * | Text was stored in an man>Special:MyLanguage/Manual:External Storage</>|external location specified by old_text.
 * }
 * | Text was stored in an man>Special:MyLanguage/Manual:External Storage</>|external location specified by old_text.
 * }
 * | Text was stored in an man>Special:MyLanguage/Manual:External Storage</>|external location specified by old_text.
 * }

Schema summary
+---+--+--+-+-++ +---+--+--+-+-++ +---+--+--+-+-++
 * 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    |                |

Indexes
<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 |
 * text |          0 | PRIMARY  |            1 | old_id      | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |