1 files changed, 64 insertions, 17 deletions
diff --git a/sql/sqlite/patch-page-rename-name_title-index.sql b/sql/sqlite/patch-page-rename-name_title-index.sql
index d1f2f1ff1bae..5bcd56225c2e 100644
--- a/sql/sqlite/patch-page-rename-name_title-index.sql
+++ b/sql/sqlite/patch-page-rename-name_title-index.sql
@@ -1,21 +1,68 @@
 -- This file is automatically generated using maintenance/generateSchemaChangeSql.php.
--- Source: maintenance/abstractSchemaChanges/patch-page-rename-name_title-index.json
+-- Source: sql/abstractSchemaChanges/patch-page-rename-name_title-index.json
 -- Do not modify this file directly.
 -- See https://www.mediawiki.org/wiki/Manual:Schema_changes
-DROP  INDEX name_title;
-DROP  INDEX page_random;
-DROP  INDEX page_len;
-DROP  INDEX page_redirect_namespace_len;
 CREATE TEMPORARY TABLE /*_*/__temp__page AS
-SELECT  page_id,  page_namespace,  page_title,  page_is_redirect,  page_is_new,  page_random,  page_touched,  page_links_updated,  page_latest,  page_len,  page_content_model,  page_lang
-FROM  /*_*/page;
-DROP  TABLE  /*_*/page;
-CREATE TABLE  /*_*/page (    page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,    page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL,    page_is_redirect SMALLINT DEFAULT 0 NOT NULL,    page_is_new SMALLINT DEFAULT 0 NOT NULL,    page_random DOUBLE PRECISION NOT NULL,    page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL,    page_latest INTEGER UNSIGNED NOT NULL,    page_len INTEGER UNSIGNED NOT NULL,    page_content_model BLOB DEFAULT NULL,    page_lang BLOB DEFAULT NULL  );
-INSERT INTO  /*_*/page (    page_id, page_namespace, page_title, page_is_redirect,    page_is_new, page_random, page_touched,    page_links_updated, page_latest,    page_len, page_content_model, page_lang  )
-SELECT  page_id,  page_namespace,  page_title,  page_is_redirect,  page_is_new,  page_random,  page_touched,  page_links_updated,  page_latest,  page_len,  page_content_model,  page_lang
-FROM  /*_*/__temp__page;
-DROP  TABLE /*_*/__temp__page;
-CREATE INDEX page_random ON  /*_*/page (page_random);
-CREATE INDEX page_len ON  /*_*/page (page_len);
-CREATE INDEX page_redirect_namespace_len ON  /*_*/page (    page_is_redirect, page_namespace,    page_len  );
-CREATE UNIQUE INDEX page_name_title ON  /*_*/page (page_namespace, page_title);
+SELECT
+  page_id,
+  page_namespace,
+  page_title,
+  page_is_redirect,
+  page_is_new,
+  page_random,
+  page_touched,
+  page_links_updated,
+  page_latest,
+  page_len,
+  page_content_model,
+  page_lang
+FROM /*_*/page;
+DROP TABLE /*_*/page;
+
+
+CREATE TABLE /*_*/page (
+    page_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
+    page_namespace INTEGER NOT NULL, page_title BLOB NOT NULL,
+    page_is_redirect SMALLINT DEFAULT 0 NOT NULL,
+    page_is_new SMALLINT DEFAULT 0 NOT NULL,
+    page_random DOUBLE PRECISION NOT NULL,
+    page_touched BLOB NOT NULL, page_links_updated BLOB DEFAULT NULL,
+    page_latest INTEGER UNSIGNED NOT NULL,
+    page_len INTEGER UNSIGNED NOT NULL,
+    page_content_model BLOB DEFAULT NULL,
+    page_lang BLOB DEFAULT NULL
+  );
+INSERT INTO /*_*/page (
+    page_id, page_namespace, page_title,
+    page_is_redirect, page_is_new, page_random,
+    page_touched, page_links_updated,
+    page_latest, page_len, page_content_model,
+    page_lang
+  )
+SELECT
+  page_id,
+  page_namespace,
+  page_title,
+  page_is_redirect,
+  page_is_new,
+  page_random,
+  page_touched,
+  page_links_updated,
+  page_latest,
+  page_len,
+  page_content_model,
+  page_lang
+FROM
+  /*_*/__temp__page;
+DROP TABLE /*_*/__temp__page;
+
+CREATE INDEX page_random ON /*_*/page (page_random);
+
+CREATE INDEX page_len ON /*_*/page (page_len);
+
+CREATE INDEX page_redirect_namespace_len ON /*_*/page (
+    page_is_redirect, page_namespace,
+    page_len
+  );
+
+CREATE UNIQUE INDEX page_name_title ON /*_*/page (page_namespace, page_title);