Fixup some SELECT * usages in sqlite schema patches

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

diff --git a/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql b/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql
index da096ac..ee164cc 100644 (file)
--- a/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-langlinks-fix-pk.sql
@@ -10,12 +10,12 @@ CREATE TABLE /*_*/langlinks_tmp (
   PRIMARY KEY (ll_from,ll_lang)
 ) /*$wgDBTableOptions*/;
 
-INSERT INTO /*_*/langlinks_tmp
-       SELECT * FROM /*_*/langlinks;
+INSERT INTO /*_*/langlinks_tmp(ll_from, ll_lang, ll_title)
+       SELECT ll_from, ll_lang, ll_title FROM /*_*/langlinks;
 
 DROP TABLE /*_*/langlinks;
 
 ALTER TABLE /*_*/langlinks_tmp RENAME TO /*_*/langlinks;
 
 -- Index for ApiQueryLangbacklinks
-CREATE INDEX /*i*/ll_lang ON /*_*/langlinks (ll_lang, ll_title);
\ No newline at end of file
+CREATE INDEX /*i*/ll_lang ON /*_*/langlinks (ll_lang, ll_title);