1 files changed, 14 insertions, 0 deletions
diff --git a/sql/sqlite/patch-langlinks-ll_title-varbinary.sql b/sql/sqlite/patch-langlinks-ll_title-varbinary.sql
new file mode 100644
index 000000000000..9fdec6cd507d
--- /dev/null
+++ b/sql/sqlite/patch-langlinks-ll_title-varbinary.sql
@@ -0,0 +1,14 @@
+CREATE TABLE /*_*/langlinks_tmp (
+  ll_from INTEGER UNSIGNED DEFAULT 0 NOT NULL,
+  ll_lang BLOB DEFAULT '' NOT NULL,
+  ll_title BLOB DEFAULT '' NOT NULL,
+  PRIMARY KEY(ll_from, ll_lang)
+);
+
+INSERT INTO /*_*/langlinks_tmp
+	SELECT ll_from, ll_lang, ll_title
+		FROM /*_*/langlinks;
+DROP TABLE /*_*/langlinks;
+ALTER TABLE /*_*/langlinks_tmp RENAME TO /*_*/langlinks;
+
+CREATE INDEX ll_lang ON /*_*/langlinks (ll_lang, ll_title);