MediaWiki 1.30.2

[autoinstallsdev/mediawiki.git] / maintenance / sqlite / archives / patch-log_search-fix-pk.sql

diff --git a/maintenance/sqlite/archives/patch-log_search-fix-pk.sql b/maintenance/sqlite/archives/patch-log_search-fix-pk.sql
new file mode 100644 (file)
index 0000000..153e415
--- /dev/null
+++ b/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