MediaWiki/tables - Revision history

Woozle: some keys

2018-02-22T15:49:39Z

some keys

← Older revision		Revision as of 15:49, 22 February 2018
Line 1:		Line 1:
	==page_props==		==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.~~		Stores "page properties". I'm not quite sure how this is ''supposed'' to be used, but I've noticed some keys that are often present:
			* <code>notoc</code> presumably flags that the <nowiki>__NOTOC__</nowiki> indicator is present in the page's content
			* <code>noeditsection</code> presumably flags that the <nowiki>__NOEDITSECTION</nowiki> indicator is present in the page's content
			* <code>smw-semanticdata-status</code> presumably flags that there are [[Semantic MediaWiki]] tags in the page's content

	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:		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:

Woozle: slightly more useful query

2017-12-15T01:29:19Z

slightly more useful query

← Older revision		Revision as of 01:29, 15 December 2017
Line 4:		Line 4:
	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:		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:
	<syntaxhighlight lang=mysql>SELECT pp_page, CAST(pp_propname AS CHAR) AS Name, CAST(pp_value AS CHAR) AS Value, pp_sortkey FROM page_props;</syntaxhighlight>		<syntaxhighlight lang=mysql>SELECT pp_page, CAST(pp_propname AS CHAR) AS Name, CAST(pp_value AS CHAR) AS Value, pp_sortkey FROM page_props;</syntaxhighlight>
			A slightly more complex query to show the names of the pages (instead of just IDs):
			<syntaxhighlight lang=mysql>SELECT
			pp_page,
			page_namespace,
			page_title,
			CAST(pp_propname AS CHAR) AS Name,
			CAST(pp_value AS CHAR) AS Value,
			pp_sortkey
			FROM
			page_props
			LEFT JOIN
			page ON pp_page = page_id
			</syntaxhighlight>

Woozle: should work

2017-12-15T00:51:03Z

should work

New page

==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:
<syntaxhighlight lang=mysql>SELECT pp_page, CAST(pp_propname AS CHAR) AS Name, CAST(pp_value AS CHAR) AS Value, pp_sortkey FROM page_props;</syntaxhighlight>