1 files changed, 19 insertions, 0 deletions
diff --git a/sql/sqlite/patch-pagelinks-pl_title-varbinary.sql b/sql/sqlite/patch-pagelinks-pl_title-varbinary.sql
new file mode 100644
index 000000000000..c023ce0d6c1d
--- /dev/null
+++ b/sql/sqlite/patch-pagelinks-pl_title-varbinary.sql
@@ -0,0 +1,19 @@
+CREATE TABLE /*_*/pagelinks_tmp (
+  pl_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
+  pl_namespace INTEGER DEFAULT 0 NOT NULL,
+  pl_title BLOB DEFAULT '' NOT NULL,
+  pl_from_namespace INTEGER DEFAULT 0 NOT NULL,
+  PRIMARY KEY(pl_from, pl_namespace, pl_title)
+);
+
+INSERT INTO /*_*/pagelinks_tmp
+	SELECT pl_from, pl_namespace, pl_title, pl_from_namespace
+		FROM /*_*/pagelinks;
+DROP TABLE /*_*/pagelinks;
+ALTER TABLE /*_*/pagelinks_tmp RENAME TO /*_*/pagelinks;
+
+CREATE INDEX pl_namespace ON /*_*/pagelinks (pl_namespace, pl_title, pl_from);
+CREATE INDEX pl_backlinks_namespace ON /*_*/pagelinks (
+  pl_from_namespace, pl_namespace,
+  pl_title, pl_from
+);