Manual:Text table

The text table holds the wikitext of individual page revisions.

If using Postgres or Oracle, this table is named pagecontent.

These columns in the text table will not be used anymore.

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,  in  table and  in  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.
 * }

old_id
Unique integer used to identify each text.

It's referenced by the <tvar|1></> in <tvar|2></> 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    |                |

Extensions can add other custom flags.