Fixup some SELECT * usages in sqlite schema patches

[lhc/web/wiklou.git] / maintenance / sqlite / archives / patch-page_props-fix-pk.sql

diff --git a/maintenance/sqlite/archives/patch-page_props-fix-pk.sql b/maintenance/sqlite/archives/patch-page_props-fix-pk.sql
index 3a40d86..cc24632 100644 (file)
--- a/maintenance/sqlite/archives/patch-page_props-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-page_props-fix-pk.sql
@@ -7,12 +7,12 @@ CREATE TABLE /*_*/page_props_tmp (
   PRIMARY KEY (pp_page,pp_propname)
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/page_props_tmp
-       SELECT * FROM /*_*/page_props;
+INSERT INTO /*_*/page_props_tmp(pp_page, pp_propname, pp_value, pp_sortkey)
+       SELECT pp_page, pp_propname, pp_value, pp_sortkey FROM /*_*/page_props;
 
 DROP TABLE /*_*/page_props;
 
 ALTER TABLE /*_*/page_props_tmp RENAME TO /*_*/page_props;
 
 CREATE UNIQUE INDEX /*i*/pp_propname_page ON /*_*/page_props (pp_propname,pp_page);
-CREATE UNIQUE INDEX /*i*/pp_propname_sortkey_page ON /*_*/page_props (pp_propname,pp_sortkey,pp_page);
\ No newline at end of file
+CREATE UNIQUE INDEX /*i*/pp_propname_sortkey_page ON /*_*/page_props (pp_propname,pp_sortkey,pp_page);