b13b6055b1d9f539c65705c205c1e482b90727fd
1 -- Add a 'sortkey' field to page_props so pages can be efficiently
2 -- queried by the numeric value of a property.
4 ALTER TABLE /*_*/page_props
5 ADD pp_sortkey
float DEFAULT NULL;
7 CREATE UNIQUE INDEX /*i*/pp_propname_sortkey_page
8 ON /*_*/page_props ( pp_propname
, pp_sortkey
, pp_page
);