1 CREATE TABLE /*_*/page_props_tmp (
3 pp_propname
varbinary(60) NOT NULL,
4 pp_value
blob NOT NULL,
5 pp_sortkey
float DEFAULT NULL,
7 PRIMARY KEY (pp_page
,pp_propname
)
8 ) /*$wgDBTableOptions*/;
10 INSERT INTO /*_*/page_props_tmp
11 SELECT * FROM /*_*/page_props
;
13 DROP TABLE /*_*/page_props
;
15 ALTER TABLE /*_*/page_props_tmp
RENAME TO /*_*/page_props
;
17 CREATE UNIQUE INDEX /*i*/pp_propname_page
ON /*_*/page_props (pp_propname
,pp_page
);
18 CREATE UNIQUE INDEX /*i*/pp_propname_sortkey_page
ON /*_*/page_props (pp_propname
,pp_sortkey
,pp_page
);