Introducing pp_sortkey.
authordaniel <daniel.kinzler@wikimedia.de>
Mon, 31 Mar 2014 11:00:28 +0000 (13:00 +0200)
committerAaron Schulz <aschulz@wikimedia.org>
Thu, 24 Apr 2014 05:26:41 +0000 (05:26 +0000)
commitb1d6e78f7444211cc93793103c3673e1a2637a69
tree36a181d1ce54145041c766518e1be1a2e4f981e1
parentc00fd14c0eb17252f6273b037f973434b5e58baf
Introducing pp_sortkey.

This adds the pp_sortkey column to the page_props table.

pp_sortkeys allows for top-k queries for pages, e.g.
the 100 pages with the most language links, etc. It is also
possible to query for exact values.

For now, pp_sortkey will contain pp_value's numeric value if
the value was set to a float, int or boolean.

Associated tasks:
* create a maintenance script for populating pp_sortkey. Tricky,
because when reading from the database, all values are strings.
* create an API module for querying pages by property value.

bug: 58032
Change-Id: I217c42656fb877ff35a36eb446a22bdaf119faac
RELEASE-NOTES-1.23
includes/DefaultSettings.php
includes/deferred/LinksUpdate.php
includes/installer/MysqlUpdater.php
includes/installer/PostgresUpdater.php
includes/installer/SqliteUpdater.php
includes/parser/ParserOutput.php
maintenance/archives/patch-pp_sortkey.sql [new file with mode: 0644]
maintenance/tables.sql
tests/phpunit/includes/LinksUpdateTest.php