1 files changed, 12 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/patch-transcache-fix-pk.sql b/www/wiki/maintenance/sqlite/archives/patch-transcache-fix-pk.sql
new file mode 100644
index 00000000..53f83e1f
--- /dev/null
+++ b/www/wiki/maintenance/sqlite/archives/patch-transcache-fix-pk.sql
@@ -0,0 +1,12 @@
+CREATE TABLE /*_*/transcache_tmp (
+  tc_url varbinary(255) NOT NULL PRIMARY KEY,
+  tc_contents text,
+  tc_time binary(14) NOT NULL
+) /*$wgDBTableOptions*/;
+
+INSERT INTO /*_*/transcache_tmp
+	SELECT * FROM /*_*/transcache;
+
+DROP TABLE /*_*/transcache;
+
+ALTER TABLE /*_*/transcache_tmp RENAME TO /*_*/transcache;
+\ No newline at end of file