From e90012d5581801045910f31ddefa9aee52e39d39 Mon Sep 17 00:00:00 2001 From: Reedy Date: Sun, 30 Jun 2019 17:47:53 +0100 Subject: [PATCH 1/1] Fix SQLite patch-(page|template)links-fix-pk.sql column order Bug: T202211 Change-Id: Ife673b88c23acdc1bfc04630715d18243471035f --- maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql | 4 ++-- maintenance/sqlite/archives/patch-templatelinks-fix-pk.sql | 4 ++-- 2 files changed, 4 insertions(+), 4 deletions(-) diff --git a/maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql b/maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql index 0e845865dc..40fd51fad5 100644 --- a/maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql +++ b/maintenance/sqlite/archives/patch-pagelinks-fix-pk.sql @@ -13,8 +13,8 @@ CREATE TABLE /*_*/pagelinks_tmp ( PRIMARY KEY (pl_from,pl_namespace,pl_title) ) /*$wgDBTableOptions*/; -INSERT INTO /*_*/pagelinks_tmp - SELECT * FROM /*_*/pagelinks; +INSERT INTO /*_*/pagelinks_tmp (pl_from, pl_from_namespace, pl_namespace, pl_title) + SELECT pl_from, pl_from_namespace, pl_namespace, pl_title FROM /*_*/pagelinks; DROP TABLE /*_*/pagelinks; diff --git a/maintenance/sqlite/archives/patch-templatelinks-fix-pk.sql b/maintenance/sqlite/archives/patch-templatelinks-fix-pk.sql index 5f09f60d3a..e9bbab8e9c 100644 --- 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*/; -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; -- 2.20.1