Manual:Text table/be-tarask

Табліца text зьмяшчае вікітэкст рэвізіяў асобнай старонкі. Калі вы карыстаецеся Postgres альбо Oracle, гэтая табліца называецца pagecontent. Пашырэньні таксама могуць захоўваць у ёй свае зьвесткі.

Назвы палёў — спадчына з табліцы рэвізіяў у MediaWiki 1.4 і раней.

Калі вы абнавілі сваю вікі з MediaWiki 1.4 ці старэйшай да навейшай, а пасьля гэтага хоць раз запусьцілі update.php, старыя слупкі ў табліцы text засталіся, а іхні зьмест быў прадубляваны ў табліцы ' і ' (зьмест скапіяваны, а ня перанесены). Гэтыя слупкі з табліцы text больш нідзе ня будуць выкарыстоўвацца. Усе палі табліцы text, акрамя old_id, old_text і old_flags, больш не патрэбныя і могуць быць бясьпечна выдаленыя.

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

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

+---+-+--+-+-++ +---+-+--+-+-++ +---+-+--+-+-++
 * 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
Unique integer used to identify each text. in table and  table. are keys to this column.

old_text
The wikitext of the page.

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


 * {|class="wikitable"


 * | Text is compressed with PHP's  function.  If the  option is on, new rows (=current revisions) will be gzipped transparently at save time. Previous revisions can also be compressed by using the script
 * | Text was stored as UTF-8. If the  option is on, rows without this flag will be converted to UTF-8 transparently at load time.
 * | 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.
 * | Text was stored in an external location specified by old_text. Any additional flags apply to the data stored at that URL, not the URL itself. The 'object' flag is not set for URLs of the form 'DB://cluster/id/itemid', because the external storage system itself decompresses these. See also.
 * }
 * | 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.
 * | Text was stored in an external location specified by old_text. Any additional flags apply to the data stored at that URL, not the URL itself. The 'object' flag is not set for URLs of the form 'DB://cluster/id/itemid', because the external storage system itself decompresses these. See also.
 * }
 * | Text was stored in an external location specified by old_text. Any additional flags apply to the data stored at that URL, not the URL itself. The 'object' flag is not set for URLs of the form 'DB://cluster/id/itemid', because the external storage system itself decompresses these. See also.
 * }
 * | Text was stored in an external location specified by old_text. Any additional flags apply to the data stored at that URL, not the URL itself. The 'object' flag is not set for URLs of the form 'DB://cluster/id/itemid', because the external storage system itself decompresses these. See also.
 * }

Extensions can add other custom flags.