X-Git-Url: https://git.heureux-cyclage.org/?a=blobdiff_plain;f=maintenance%2Farchives%2Fpatch-log_search.sql;h=8d92030b26642b4dbffec49fd560c02b62a53df2;hb=b7fa6d10bbb81239217ba88adf4544a672dcca08;hp=c992d3a0cea8685d399d9ecb865fe802a7e4b273;hpb=a2eb09f724ddb979a50bcafd058a822fd9fa6e15;p=lhc%2Fweb%2Fwiklou.git

diff --git a/maintenance/archives/patch-log_search.sql b/maintenance/archives/patch-log_search.sql
index c992d3a0ce..8d92030b26 100644
--- a/maintenance/archives/patch-log_search.sql
+++ b/maintenance/archives/patch-log_search.sql
@@ -1,9 +1,10 @@
 CREATE TABLE /*_*/log_search (
-	-- The type of ID (rev ID, log ID, timestamp, other)
-	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
-);
-CREATE INDEX /*i*/log_field_value ON /*_*/log_search (ls_field,ls_value,ls_log_id);
+  -- 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
+) /*$wgDBTableOptions*/;
+CREATE UNIQUE INDEX /*i*/ls_field_val ON /*_*/log_search (ls_field,ls_value,ls_log_id);
+CREATE INDEX /*i*/ls_log_id ON /*_*/log_search (ls_log_id);