Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-user_properties-fix-pk.sql b/maintenance/sqlite/archives/patch-user_properties-fix-pk.sql
index 8362d23..682f568 100644 (file)
--- a/maintenance/sqlite/archives/patch-user_properties-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-user_properties-fix-pk.sql
@@ -10,11 +10,11 @@ CREATE TABLE /*_*/user_properties_tmp (
   PRIMARY KEY (up_user,up_property)
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/user_properties_tmp
-       SELECT * FROM /*_*/user_properties;
+INSERT INTO /*_*/user_properties_tmp(up_user, up_property, up_value)
+       SELECT up_user, up_property, up_value FROM /*_*/user_properties;
 
 DROP TABLE /*_*/user_properties;
 
 ALTER TABLE /*_*/user_properties_tmp RENAME TO /*_*/user_properties;
 
-CREATE INDEX /*i*/user_properties_property ON /*_*/user_properties (up_property);
\ No newline at end of file
+CREATE INDEX /*i*/user_properties_property ON /*_*/user_properties (up_property);