MediaWiki/tables

from HTYP, the free directory anyone can edit if they can prove to me that they're not a spambot
< MediaWiki
Revision as of 00:51, 15 December 2017 by Woozle (talk | contribs) (should work)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

page_props

Stores "page properties". I'm not quite sure how this is supposed to be used, as it always seems to be empty until I start mucking around with it.

Names and values are kept in binary blobs, though (even though they are strings), so you have to do a modified query to see what's going on:

SELECT pp_page, CAST(pp_propname AS CHAR) AS Name, CAST(pp_value AS CHAR) AS Value, pp_sortkey FROM page_props;