Manual:Text table

The text table holds the wikitext of individual page revisions. If using Postgres, this table is named pagecontent.

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

mysql> describe mw_text; +---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++ 3 rows in set
 * 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 : revision.rev_text_id in revision table is a key to this column. (In MediaWiki 1.5+, archive.ar_text_id is also a key to this column.)
 * old_text : The wikitext of the page.
 * old_flags : Comma-separated list of flags. Contains the following possible values:


 * | gzip
 * | Text is compressed with PHP's gzdeflate function.
 * | utf-8
 * | Text was stored as UTF-8. If the $wgLegacyEncoding option is on, rows *without* this flag will be converted to UTF-8 transparently at load time.
 * | object
 * | Text field contained a serialized PHP object. The object either contains multiple versions compressed together to achieve a better compression ratio, or it refers to another row where the text can be found.
 * | external
 * | Text was stored in an external location specified by old_text
 * }
 * | external
 * | Text was stored in an external location specified by old_text
 * }