1 files changed, 18 insertions, 0 deletions
diff --git a/www/wiki/maintenance/sqlite/archives/patch-log_search-fix-pk.sql b/www/wiki/maintenance/sqlite/archives/patch-log_search-fix-pk.sql
new file mode 100644
index 00000000..153e4150
--- /dev/null
+++ b/www/wiki/maintenance/sqlite/archives/patch-log_search-fix-pk.sql
@@ -0,0 +1,18 @@
+CREATE TABLE /*_*/log_search_tmp (
+  -- The type of ID (rev ID, log ID, rev timestamp, username)
+  ls_field varbinary(32) NOT NULL,
+  -- The value of the ID
+  ls_value varchar(255) NOT NULL,
+  -- Key to log_id
+  ls_log_id int unsigned NOT NULL default 0,
+  PRIMARY KEY (ls_field,ls_value,ls_log_id)
+) /*$wgDBTableOptions*/;
+
+INSERT INTO /*_*/log_search_tmp
+	SELECT * FROM /*_*/log_search;
+
+DROP TABLE /*_*/log_search;
+
+ALTER TABLE /*_*/log_search_tmp RENAME TO /*_*/log_search;
+
+CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id);
+\ No newline at end of file