Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-text-fix-pk.sql b/maintenance/sqlite/archives/patch-text-fix-pk.sql
index 380887b..623bdb3 100644 (file)
--- a/maintenance/sqlite/archives/patch-text-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-text-fix-pk.sql
@@ -29,9 +29,9 @@ CREATE TABLE /*_*/text_tmp (
   old_flags tinyblob NOT NULL
 ) /*$wgDBTableOptions*/ MAX_ROWS=10000000 AVG_ROW_LENGTH=10240;
 
-INSERT INTO /*_*/text_tmp
-       SELECT * FROM /*_*/text;
+INSERT INTO /*_*/text_tmp(old_id, old_text, old_flags)
+       SELECT old_id, old_text, old_flags FROM /*_*/text;
 
 DROP TABLE /*_*/text;
 
-ALTER TABLE /*_*/text_tmp RENAME TO /*_*/text;
\ No newline at end of file
+ALTER TABLE /*_*/text_tmp RENAME TO /*_*/text;