Page MenuHomePhabricator

Deploy pp_sortkey schema change to all wikis
Closed, ResolvedPublic


The schema change can be found at, reproduced here as well:

ALTER TABLE /*_*/page_props
ADD pp_sortkey float DEFAULT NULL;

CREATE UNIQUE INDEX /*i*/pp_propname_sortkey_page
ON /*_*/page_props ( pp_propname, pp_sortkey, pp_page );

This is hidden behind a feature flag so there's no rush to have this done before a set deployment.

Version: wmf-deployment
Severity: enhancement



Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 3:20 AM
bzimport set Reference to bz64411.

Change 130055 had a related patch set uploaded by Aude:
Set $wgPagePropsHaveSortkey to false

Schema change applied to all wikis.

Strictly speaking the bug is complete, however the linked patch set is unmerged and possibly still needed until the field is prepopulated by a batch job?

Change 130055 abandoned by Aude:
Set $wgPagePropsHaveSortkey to false

schema change is done