maintenance/sqlite/archives/patch-page_props-fix-pk.sql

   1 CREATE TABLE /*_*/page_props_tmp (
   2   pp_page int NOT NULL,
   3   pp_propname varbinary(60) NOT NULL,
   4   pp_value blob NOT NULL,
   5   pp_sortkey float DEFAULT NULL,
   6
   7   PRIMARY KEY (pp_page,pp_propname)
   8 ) /*$wgDBTableOptions*/;
   9
  10 INSERT INTO /*_*/page_props_tmp
  11         SELECT * FROM /*_*/page_props;
  12
  13 DROP TABLE /*_*/page_props;
  14
  15 ALTER TABLE /*_*/page_props_tmp RENAME TO /*_*/page_props;
  16
  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);