Fix SQLite patch-(page|template)links-fix-pk.sql column order

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

diff --git a/maintenance/sqlite/archives/patch-templatelinks-fix-pk.sql b/maintenance/sqlite/archives/patch-templatelinks-fix-pk.sql
index 5f09f60..e9bbab8 100644 (file)
--- a/maintenance/sqlite/archives/patch-templatelinks-fix-pk.sql
+++ b/maintenance/sqlite/archives/patch-templatelinks-fix-pk.sql
@@ -13,8 +13,8 @@ CREATE TABLE /*_*/templatelinks_tmp (
   PRIMARY KEY (tl_from,tl_namespace,tl_title)
 ) /*$wgDBTableOptions*/;
 
   PRIMARY KEY (tl_from,tl_namespace,tl_title)
 ) /*$wgDBTableOptions*/;
 

-INSERT INTO /*_*/templatelinks_tmp
-       SELECT * FROM /*_*/templatelinks;
+INSERT INTO /*_*/templatelinks_tmp (tl_from, tl_from_namespace, tl_namespace, tl_title)
+       SELECT tl_from, tl_from_namespace, tl_namespace, tl_title FROM /*_*/templatelinks;

 
 DROP TABLE /*_*/templatelinks;
 
 
 DROP TABLE /*_*/templatelinks;