Manual:Page props table/cs

Tabulka page_props obsahuje vlastnosti o stránkách nastavené analyzátorem prostřednictvím, jako je zobrazení titulku a výchozí klíč kategorie. In particular, all double underscore magic words are automatically recorded here. Also, many extensions use this table to store their own data. Vezměte prosím na vědomí, že během přepracování obsahu stránky dojde k vymazání všech vlastností co měla nastavena z této tabulky, a jejich nahrazení hodnotami novými, takže tahle tabulka není vhodná pro ukládání dat, která se nedají během přepracování obnovit.

pp_page
by which the name/value pair is indexed

pp_propname
Page property name

pp_value
Page property value

pp_sortkey
This is so pages can be efficiently queried and sorted by property value (see ).



Přehled změn ve schématu tabulky
+-+--+--+-+-+---+ +-+--+--+-+-+---+ +-+--+--+-+-+---+
 * Field      | Type             | Null | Key | Default | Extra |
 * pp_page    | int(10) unsigned | NO   | PRI | NULL    |       |
 * pp_propname | varbinary(60)   | NO   | PRI | NULL    |       |
 * pp_value   | blob             | NO   |     | NULL    |       |
 * pp_sortkey | float            | YES  |     | NULL    |       |

+-+---+--+-+-+---+ +-+---+--+-+-+---+ +-+---+--+-+-+---+
 * Field      | Type          | Null | Key | Default | Extra |
 * pp_page    | int(11)       | NO   | PRI | NULL    |       |
 * pp_propname | varbinary(60) | NO  | PRI | NULL    |       |
 * pp_value   | blob          | NO   |     | NULL    |       |
 * pp_sortkey | float         | YES  |     | NULL    |       |

+-+---+--+-+-+---+ +-+---+--+-+-+---+ +-+---+--+-+-+---+
 * Field      | Type          | Null | Key | Default | Extra |
 * pp_page    | int(11)       | NO   | PRI | NULL    |       |
 * pp_propname | varbinary(60) | NO  | PRI | NULL    |       |
 * pp_value   | blob          | NO   |     | NULL    |       |

Indexy
 +++--+--+-+---+-+--++--++-+---+ +++--+--+-+---+-+--++--++-+---+ +++--+--+-+---+-+--++--++-+---+
 * Table     | Non_unique | Key_name                 | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment |
 * page_props |         0 | PRIMARY                  |            1 | pp_page     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page_props |         0 | PRIMARY                  |            2 | pp_propname | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page_props |         0 | pp_propname_page         |            1 | pp_propname | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page_props |         0 | pp_propname_page         |            2 | pp_page     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page_props |         0 | pp_propname_sortkey_page |            1 | pp_propname | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |
 * page_props |         0 | pp_propname_sortkey_page |            2 | pp_sortkey  | A         |           0 |     NULL | NULL   | YES  | BTREE      |         |               |
 * page_props |         0 | pp_propname_sortkey_page |            3 | pp_page     | A         |           0 |     NULL | NULL   |      | BTREE      |         |               |

Sample query
Here's a sample query to find the page properties in use (see also ).



Jednoduchý příklad využití této tabulky u rozšíření
Here is an example of an extension that stores its own page property in the  table. It defines two parser tags (hooks) &lt;getprop&gt; and &lt;setprop&gt; that manipulate its property named SimpleSetPropExtension. They allow a wiki editor to set the property's value in wikitext with Some random text, and display its value with (for the current page) or with (for its value on some other page).

